57 SQL-запросов зафиксировано

1. SELECT `data`
  FROM `u1weg_session`
  WHERE `session_id` = 'ueef0db2uls6pbfu14msl1lrt4'
2. DELETE
  FROM `u1weg_session`
  WHERE `time` < '1586041433'
3. SELECT `session_id`
  FROM `u1weg_session`
  WHERE `session_id` = 'ueef0db2uls6pbfu14msl1lrt4'
  LIMIT 0, 1
4. INSERT INTO `u1weg_session` (`session_id`, `client_id`, `time`)
  VALUES ('ueef0db2uls6pbfu14msl1lrt4', 0, '1586161433')
5. SELECT extension_id AS id, element AS "option", params, enabled
  FROM u1weg_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_users'
6. SELECT b.id
  FROM u1weg_usergroups AS a
  LEFT JOIN u1weg_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE a.id = 9
7. SELECT id, rules
  FROM `u1weg_viewlevels`
8. SELECT folder AS type, element AS name, params
  FROM u1weg_extensions
  WHERE enabled >= 1
  AND type ='plugin'
  AND state >= 0
  AND access IN (1,1,4)
  ORDER BY ordering
9. SELECT extension_id AS id, element AS "option", params, enabled
  FROM u1weg_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_languages'
10. select id, title, alias
  from u1weg_jumi
  where published = 1
11. SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
  FROM u1weg_menu AS m
  LEFT JOIN u1weg_extensions AS e
  ON m.component_id = e.extension_id
  WHERE m.published = 1
  AND m.parent_id > 0
  AND m.client_id = 0
  ORDER BY m.lft
12. SHOW TABLES LIKE "%virtuemart_configs%"
13. SELECT `config`
  FROM `u1weg_virtuemart_configs`
  WHERE `virtuemart_config_id` = "1";
14. SELECT *
  FROM u1weg_languages
  WHERE published=1
  ORDER BY ordering ASC
15. SELECT extension_id AS id, element AS "option", params, enabled
  FROM u1weg_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_virtuemart'
16. SELECT *
  FROM `u1weg_menu`
  where `link` like "index.php?option=com_virtuemart%"
  and client_id=0
  and published=1
  and (language="*" or language="ru_ru")
17. SELECT `virtuemart_category_id`
  FROM `u1weg_virtuemart_categories_ru_ru`
  WHERE `slug` LIKE 'all-products'
18. SELECT id, home, template, s.params
  FROM u1weg_template_styles as s
  LEFT JOIN u1weg_extensions as e
  ON e.element=s.template
  AND e.type='template'
  AND e.client_id=s.client_id
  WHERE s.client_id = 0
  AND e.enabled = 1
19. SHOW FULL COLUMNS
  FROM `u1weg_virtuemart_categories`
20. SELECT `u1weg_virtuemart_categories_ru_ru`.* ,`u1weg_virtuemart_categories`.*
  FROM `u1weg_virtuemart_categories_ru_ru` JOIN u1weg_virtuemart_categories using (`virtuemart_category_id`)
  WHERE u1weg_virtuemart_categories_ru_ru.`virtuemart_category_id` = "39"
21. SELECT `virtuemart_media_id`
  FROM `u1weg_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "39"
  ORDER BY `ordering`
22. SELECT `category_child_id`
  FROM `u1weg_virtuemart_category_categories`
  WHERE `category_parent_id` = 39
23. SELECT `virtuemart_permgroup_id`,`group_name`,`group_level`
  FROM `u1weg_virtuemart_permgroups`
  ORDER BY `group_level`
24. SELECT SQL_CALC_FOUND_ROWS c.`virtuemart_category_id`, l.`category_description`, l.`category_name`, c.`ordering`, c.`published`, cx.`category_child_id`, cx.`category_parent_id`, c.`shared`
  FROM `u1weg_virtuemart_categories_ru_ru` l JOIN `u1weg_virtuemart_categories` AS c using (`virtuemart_category_id`)
  LEFT JOIN `u1weg_virtuemart_category_categories` AS cx
  ON l.`virtuemart_category_id` = cx.`category_child_id`
  WHERE c.`published` = 1
  AND cx.`category_parent_id` = 39
  AND (c.`virtuemart_vendor_id` = "1" OR c.`shared` = "1")
  ORDER BY virtuemart_category_id
  LIMIT 0, 10
25. SELECT FOUND_ROWS()
26. SELECT count(u1weg_virtuemart_products.virtuemart_product_id) AS total
  FROM `u1weg_virtuemart_products`, `u1weg_virtuemart_product_categories`
  WHERE `u1weg_virtuemart_products`.`virtuemart_vendor_id` = "1"
  AND `u1weg_virtuemart_product_categories`.`virtuemart_category_id` = 39
  AND `u1weg_virtuemart_products`.`virtuemart_product_id` = `u1weg_virtuemart_product_categories`.`virtuemart_product_id`
  AND `u1weg_virtuemart_products`.`published` = "1"
27. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM `u1weg_virtuemart_category_categories` AS `xref`
  WHERE `xref`.`category_child_id`= 39
28. SELECT `category_name`,`virtuemart_category_id`
  FROM `u1weg_virtuemart_categories_ru_ru`
  WHERE `virtuemart_category_id`=39
29. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM u1weg_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 39
30. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM u1weg_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 39
31. SELECT `slug` as name
  FROM `u1weg_virtuemart_categories_ru_ru`
  WHERE `virtuemart_category_id`=39
32. SELECT /*SQL_NO_CACHE*/ MIN(prices.product_price) AS product_price_min,MAX(prices.product_price) AS product_price_max,COUNT(`products`.`virtuemart_product_id`) AS products_count
  FROM u1weg_virtuemart_products AS products
  INNER JOIN u1weg_virtuemart_product_categories AS productCAT
  ON (`products`.`virtuemart_product_id` = `productCAT`.`virtuemart_product_id`)
  INNER JOIN u1weg_virtuemart_product_prices AS prices
  ON (`products`.`virtuemart_product_id` = `prices`.`virtuemart_product_id`)
  INNER JOIN u1weg_virtuemart_product_manufacturers AS productMF
  ON (`products`.`virtuemart_product_id` = `productMF`.`virtuemart_product_id`)
  INNER JOIN u1weg_virtuemart_manufacturers_ru_ru AS manufacturersRU
  ON (`productMF`.`virtuemart_manufacturer_id` = `manufacturersRU`.`virtuemart_manufacturer_id`)
  WHERE (products.published = '1')
  AND (products.product_in_stock > 0)
  AND (`manufacturersRU`.`slug` = 'venum')
33. 
  SET SESSION group_concat_max_len = 10000000;
34. SELECT /*SQL_NO_CACHE*/ products.virtuemart_product_id AS product_id,products.main_picture AS product_thumb,products.main_category AS product_main_category,products.is_new AS product_is_new,products.is_reserved AS product_is_reserved,products.product_sku AS product_sku,products.product_in_stock AS product_in_stock,productsRU.product_s_desc AS product_s_desc,productsRU.product_name AS product_name,categoriesRU.virtuemart_category_id AS category_id,prices.product_price AS product_price,prices.product_override_price AS product_priceOverride,manufacturersRU.virtuemart_manufacturer_id AS mf_id,categoriesRU.category_name AS category_name,manufacturersRU.mf_name AS mf_name,manufacturersRU.slug AS mf_slug,prOfDay.ProductId AS pod_product_id,prOfDay.TypeDiscount AS pod_TypeDiscount,prOfDay.ValueDiscount AS pod_ValueDiscount,prOfDay.DateShow_start AS pod_DateShow_start,prOfDay.DateShow_finish AS pod_DateShow_finish,prOfDay.Time_start AS pod_Time_start,prOfDay.Time_finish AS pod_Time_finish,IF (`productCAT`.`virtuemart_category_id` IS NOT NULL, CONCAT('[', GROUP_CONCAT( DISTINCT CONCAT( '{', '"id":"', `productCAT`.`virtuemart_category_id`, '",', '"name":"', `categoriesRU`.`category_name`, '"}' ) ), ']'), '[]' ) AS product_categories,IF (`productCustom`.`virtuemart_product_id` IS NOT NULL, CONCAT('[', GROUP_CONCAT( DISTINCT CONCAT( '{', '"id":"', productCustom.virtuemart_custom_id, '",', /*'"rest":"', productCustom.rest, '",',*/ '"value":"', productCustom.custom_value, '"}' ) ), ']'), '[]' ) AS custom_attributes
  FROM u1weg_virtuemart_products AS products
  INNER JOIN u1weg_virtuemart_products_ru_ru AS productsRU
  ON (`products`.`virtuemart_product_id` = `productsRU`.`virtuemart_product_id`)
  INNER JOIN u1weg_virtuemart_product_categories AS productCAT
  ON (`products`.`virtuemart_product_id` = `productCAT`.`virtuemart_product_id`)
  INNER JOIN u1weg_virtuemart_product_prices AS prices
  ON (`products`.`virtuemart_product_id` = `prices`.`virtuemart_product_id`)
  INNER JOIN u1weg_virtuemart_product_manufacturers AS productMF
  ON (`products`.`virtuemart_product_id` = `productMF`.`virtuemart_product_id`)
  LEFT JOIN u1weg_virtuemart_product_customfields AS productCustom
  ON (`products`.`virtuemart_product_id` = `productCustom`.`virtuemart_product_id`)
  INNER JOIN u1weg_virtuemart_categories_ru_ru AS categoriesRU
  ON (`productCAT`.`virtuemart_category_id` = `categoriesRU`.`virtuemart_category_id`)
  INNER JOIN u1weg_virtuemart_manufacturers_ru_ru AS manufacturersRU
  ON (`productMF`.`virtuemart_manufacturer_id` = `manufacturersRU`.`virtuemart_manufacturer_id`)
  LEFT JOIN shop_productOFday AS prOfDay
  ON (`products`.virtuemart_product_id = `prOfDay`.ProductId
  AND (`prOfDay`.Time_start < '1586161434'
  AND `prOfDay`.Time_finish > '1586161434'))
  WHERE (products.published = '1')
  AND (products.product_in_stock > 0)
  AND (`categoriesRU`.`virtuemart_category_id` = '203')
  AND (`manufacturersRU`.`slug` = 'venum')
  GROUP BY `products`.`virtuemart_product_id`
  ORDER BY `products`.`virtuemart_product_id` DESC
  LIMIT 0, 36
35. SELECT /*SQL_NO_CACHE*/ medias.virtuemart_media_id AS media_id,productMedias.virtuemart_product_id AS product_id,medias.file_url AS media_fileUrl,medias.file_url_thumb AS media_fileUrlThumb
  FROM u1weg_virtuemart_product_medias AS productMedias
  INNER JOIN u1weg_virtuemart_medias AS medias
  ON (`productMedias`.`virtuemart_media_id` = `medias`.`virtuemart_media_id`)
  WHERE (`productMedias`.`virtuemart_product_id` IN (16631, 16626, 16619, 16618))
  GROUP BY `productMedias`.`virtuemart_product_id`
  ORDER BY `productMedias`.`virtuemart_media_id` DESC
36. SELECT /*SQL_NO_CACHE*/ productCAT.virtuemart_category_id AS category_id,virtuemart_product_id AS product_id
  FROM u1weg_virtuemart_product_categories AS productCAT
  WHERE (`productCAT`.`virtuemart_category_id` = '76')
  AND (`productCAT`.`virtuemart_product_id` IN('16631', '16626', '16619', '16618'))
37. SELECT `slug`
  FROM `u1weg_virtuemart_products_ru_ru`
  WHERE `virtuemart_product_id` = 16631
38. SELECT `slug`
  FROM `u1weg_virtuemart_products_ru_ru`
  WHERE `virtuemart_product_id` = 16626
39. SELECT `slug`
  FROM `u1weg_virtuemart_products_ru_ru`
  WHERE `virtuemart_product_id` = 16619
40. SELECT `slug`
  FROM `u1weg_virtuemart_products_ru_ru`
  WHERE `virtuemart_product_id` = 16618
41. SELECT /*SQL_NO_CACHE*/ categoriesRU.virtuemart_category_id AS category_id,catParents.category_parent_id AS category_parent_id,catParents.category_child_id AS category_child_id,categoriesRU.category_name AS category_name
  FROM u1weg_virtuemart_categories AS categories
  INNER JOIN u1weg_virtuemart_category_categories AS catParents
  ON (`categories`.`virtuemart_category_id` = `catParents`.`category_child_id`)
  INNER JOIN u1weg_virtuemart_categories_ru_ru AS categoriesRU
  ON (`categories`.`virtuemart_category_id` = `categoriesRU`.`virtuemart_category_id`)
  WHERE (`categories`.`published` = '1')
  AND `categories`.`is_tagging`=1
  AND `catParents`.`category_parent_id`=203
42. SELECT /*SQL_NO_CACHE*/ MIN(prices.product_price) AS product_price_min,MAX(prices.product_price) AS product_price_max,COUNT(`products`.`virtuemart_product_id`) AS products_count
  FROM u1weg_virtuemart_products AS products
  INNER JOIN u1weg_virtuemart_product_categories AS productCAT
  ON (`products`.`virtuemart_product_id` = `productCAT`.`virtuemart_product_id`)
  INNER JOIN u1weg_virtuemart_product_prices AS prices
  ON (`products`.`virtuemart_product_id` = `prices`.`virtuemart_product_id`)
  INNER JOIN u1weg_virtuemart_product_manufacturers AS productMF
  ON (`products`.`virtuemart_product_id` = `productMF`.`virtuemart_product_id`)
  INNER JOIN u1weg_virtuemart_manufacturers_ru_ru AS manufacturersRU
  ON (`productMF`.`virtuemart_manufacturer_id` = `manufacturersRU`.`virtuemart_manufacturer_id`)
  WHERE (products.published = '1')
  AND (products.product_in_stock > 0)
  AND (`manufacturersRU`.`slug` = 'venum')
43. SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
  FROM u1weg_modules AS m
  LEFT JOIN u1weg_modules_menu AS mm
  ON mm.moduleid = m.id
  LEFT JOIN u1weg_extensions AS e
  ON e.element = m.module
  AND e.client_id = m.client_id
  WHERE m.published = 1
  AND e.enabled = 1
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2020-04-06 08:23:54')
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-04-06 08:23:54')
  AND m.access IN (1,1,4)
  AND m.client_id = 0
  AND (mm.menuid = 101 OR mm.menuid <= 0)
  ORDER BY m.position, m.ordering
44. SELECT `u1weg_virtuemart_categories_ru_ru`.* ,`u1weg_virtuemart_categories`.*
  FROM `u1weg_virtuemart_categories_ru_ru` JOIN u1weg_virtuemart_categories using (`virtuemart_category_id`)
  WHERE u1weg_virtuemart_categories_ru_ru.`virtuemart_category_id` = "203"
45. SELECT `virtuemart_media_id`
  FROM `u1weg_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "203"
  ORDER BY `ordering`
46. SELECT `category_child_id`
  FROM `u1weg_virtuemart_category_categories`
  WHERE `category_parent_id` = 203
47. SELECT count(u1weg_virtuemart_products.virtuemart_product_id) AS total
  FROM `u1weg_virtuemart_products`, `u1weg_virtuemart_product_categories`
  WHERE `u1weg_virtuemart_products`.`virtuemart_vendor_id` = "1"
  AND `u1weg_virtuemart_product_categories`.`virtuemart_category_id` = 203
  AND `u1weg_virtuemart_products`.`virtuemart_product_id` = `u1weg_virtuemart_product_categories`.`virtuemart_product_id`
  AND `u1weg_virtuemart_products`.`published` = "1"
48. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM `u1weg_virtuemart_category_categories` AS `xref`
  WHERE `xref`.`category_child_id`= 203
49. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM `u1weg_virtuemart_category_categories` AS `xref`
  WHERE `xref`.`category_child_id`= 68
50. SELECT `category_name`,`virtuemart_category_id`
  FROM `u1weg_virtuemart_categories_ru_ru`
  WHERE `virtuemart_category_id`=68
51. SELECT `category_name`,`virtuemart_category_id`
  FROM `u1weg_virtuemart_categories_ru_ru`
  WHERE `virtuemart_category_id`=203
52. SELECT extension_id AS id, element AS "option", params, enabled
  FROM u1weg_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_contact'
53. SELECT name, alias, app_id, app_secret, auth, token, userinfo
  FROM u1weg_offlajn_oauths
  WHERE published = 1
54. SELECT enabled, params, custom_data
  FROM u1weg_extensions
  WHERE name = 'plg_captcha_recaptcha'
55. SELECT extension_id AS id, element AS "option", params, enabled
  FROM u1weg_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_content'
56. SELECT /*SQL_NO_CACHE*/ coupons.virtuemart_coupon_id AS coupon_id,coupons.percent_or_total AS coupon_action,coupons.coupon_code AS coupon_code,coupons.coupon_type AS coupon_type,coupons.coupon_value AS coupon_value,coupons.coupon_start_date AS coupon_start_date,coupons.coupon_expiry_date AS coupon_expiry_date,coupons.coupon_value_valid AS coupon_value_valid,coupons.coupon_rules AS coupon_rules,coupons.is_external AS coupon_external,coupons.json_data AS json_data,coupons.use_countdown AS use_countdown
  FROM u1weg_virtuemart_coupons AS coupons
  WHERE (`coupons`.`published` = '1')
  AND ( `coupons`.`coupon_start_date` = NULL OR `coupons`.`coupon_start_date` = '0000-00-00 00:00:00' OR `coupons`.`coupon_start_date` < '2020-04-06 11:23:53')
  AND ( `coupons`.`coupon_expiry_date` = NULL OR `coupons`.`coupon_expiry_date` = '0000-00-00 00:00:00' OR `coupons`.`coupon_expiry_date` > '2020-04-06 11:23:53')
  AND (`coupons`.`is_external` = '0'
  AND `coupons`.`use_message`='1')
  ORDER BY `coupons`.`modified_on` DESC
57. UPDATE `u1weg_session`
  SET `data` = '__default|a:11:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1586161433;s:18:\"session.timer.last\";i:1586161433;s:17:\"session.timer.now\";i:1586161433;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":3:{s:6:\"global\";O:8:\"stdClass\":1:{s:4:\"list\";O:8:\"stdClass\":1:{s:5:\"
  limit\";i:10;}}s:22:\"com_virtuemartcategory\";O:8:\"stdClass\":1:{s:10:\"limitstart\";i:0;}s:14:\"com_virtuemart\";O:8:\"stdClass\":1:{s:8:\"category\";O:8:\"stdClass\":2:{s:5:\"
  limit\";i:10;s:10:\"limitstart\";i:0;}}}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";N;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";N;s:14:\"\0*\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:4;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:10:\"vm_mf_name\";s:5:\"Venum\";s:13:\"vm_mf_name_RU\";s:10:\"Венум\";s:12:\"vm_custom_h1\";s:0:\"\";s:13:\"session.token\";s:32:\"62d1d450ec3e2ec77f1779b3413b6c34\";}__vm|a:2:{s:8:\"vmconfig\";s:6908:\"a:182:{s:15:\"shop_is_offline\";s:1:\"0\";s:15:\"offline_message\";s:100:\"T3VyIFNob3AgaXMgY3VycmVudGx5IGRvd24gZm9yIG1haW50ZW5hbmNlLiBQbGVhc2UgY2hlY2sgYmFjayBhZ2FpbiBzb29uLg==\";s:14:\"use_as_catalog\";s:1:\"0\";s:25:\"currency_converter_module\";s:14:\"convertECB.php\";s:15:\"order_mail_html\";s:1:\"1\";s:10:\"dateformat\";s:8:\"%m/%d/%y\";s:6:\"useSSL\";s:1:\"0\";s:14:\"dangeroustools\";s:1:\"0\";s:12:\"debug_enable\";s:4:\"none\";s:13:\"google_jquery\";s:1:\"1\";s:6:\"multix\";s:1:\"1\";s:17:\"pdf_button_enable\";s:1:\"1\";s:16:\"show_emailfriend\";s:1:\"1\";s:14:\"show_printicon\";s:1:\"0\";s:26:\"show_out_of_stock_products\";s:1:\"1\";s:14:\"coupons_enable\";s:1:\"0\";s:22:\"coupons_default_expire\";s:3:\"1,D\";s:19:\"weight_unit_default\";s:2:\"KG\";s:16:\"lwh_unit_default\";s:1:\"M\";s:10:\"list_limit\";s:2:\"10\";s:13:\"showReviewFor\";s:3:\"all\";s:10:\"reviewMode\";s:10:\"registered\";s:13:\"showRatingFor\";s:3:\"all\";s:10:\"ratingMode\";s:10:\"registered\";s:19:\"reviews_autopublish\";s:1:\"1\";s:30:\"reviews_minimum_comment_length\";s:3:\"100\";s:30:\"reviews_maximum_comment_length\";s:4:\"2000\";s:10:\"vmtemplate\";s:7:\"default\";s:16:\"categorytemplate\";s:7:\"default\";s:12:\"showCategory\";s:1:\"1\";s:14:\"categorylayout\";s:7:\"default\";s:18:\"categories_per_row\";s:1:\"3\";s:13:\"productlayout\";s:7:\"default\";s:16:\"products_per_row\";s:1:\"3\";s:8:\"vmlayout\";s:18:\"default_categories\";s:13:\"show_featured\";s:1:\"1\";s:25:\"featured_products_per_row\";s:1:\"3\";s:11:\"show_topTen\";s:1:\"1\";s:23:\"topten_products_per_row\";s:1:\"3\";s:11:\"show_recent\";s:1:\"1\";s:11:\"show_latest\";s:1:\"1\";s:19:\"assets_general_path\";s:33:\"components/com_virtuemart/assets/\";s:19:\"media_category_path\";s:35:\"images/stories/virtuemart/category/\";s:18:\"media_product_path\";s:34:\"images/stories/virtuemart/product/\";s:23:\"media_manufacturer_path\";s:39:\"images/stories/virtuemart/manufacturer/\";s:17:\"media_vendor_path\";s:33:\"images/stories/virtuemart/vendor/\";s:17:\"img_resize_enable\";s:1:\"1\";s:9:\"img_width\";s:3:\"140\";s:10:\"img_height\";s:3:\"140\";s:12:\"no_image_set\";s:11:\"noimage.gif\";s:14:\"no_image_found\";s:18:\"previous_16x16.png\";s:20:\"browse_orderby_field\";s:23:\"p.virtuemart_product_id\";s:21:\"browse_orderby_fields\";a:4:{i:0;s:12:\"product_name\";i:1;s:11:\"product_sku\";i:2;s:13:\"category_name\";i:3;s:7:\"mf_name\";}s:20:\"browse_search_fields\";a:6:{i:0;s:12:\"product_name\";i:1;s:11:\"product_sku\";i:2;s:14:\"product_s_desc\";i:3;s:13:\"category_name\";i:4;s:20:\"category_description\";i:5;s:7:\"mf_name\";}s:11:\"show_prices\";s:1:\"1\";s:28:\"price_access_level_published\";s:1:\"0\";s:31:\"price_show_packaging_pricelabel\";s:1:\"0\";s:8:\"show_tax\";s:1:\"1\";s:9:\"basePrice\";s:1:\"1\";s:13:\"basePriceText\";s:1:\"1\";s:17:\"basePriceRounding\";s:1:\"2\";s:19:\"variantModification\";s:1:\"1\";s:23:\"variantModificationText\";s:1:\"1\";s:27:\"variantModificationRounding\";s:1:\"2\";s:16:\"basePriceVariant\";s:1:\"1\";s:20:\"basePriceVariantText\";s:1:\"1\";s:24:\"basePriceVariantRounding\";s:1:\"2\";s:16:\"basePriceWithTax\";s:1:\"1\";s:20:\"basePriceWithTaxText\";s:1:\"1\";s:24:\"basePriceWithTaxRounding\";s:1:\"2\";s:25:\"discountedPriceWithoutTax\";s:1:\"1\";s:29:\"discountedPriceWithoutTaxText\";s:1:\"1\";s:33:\"discountedPriceWithoutTaxRounding\";s:1:\"2\";s:22:\"salesPriceWithDiscount\";s:1:\"1\";s:26:\"salesPriceWithDiscountText\";s:1:\"1\";s:30:\"salesPriceWithDiscountRounding\";s:1:\"2\";s:10:\"salesPrice\";s:1:\"1\";s:14:\"salesPriceText\";s:1:\"1\";s:18:\"salesPriceRounding\";s:1:\"2\";s:15:\"priceWithoutTax\";s:1:\"1\";s:19:\"priceWithoutTaxText\";s:1:\"1\";s:23:\"priceWithoutTaxRounding\";s:1:\"2\";s:14:\"discountAmount\";s:1:\"1\";s:18:\"discountAmountText\";s:1:\"1\";s:22:\"discountAmountRounding\";s:1:\"2\";s:9:\"taxAmount\";s:1:\"1\";s:13:\"taxAmountText\";s:1:\"1\";s:17:\"taxAmountRounding\";s:1:\"2\";s:11:\"check_stock\";s:1:\"0\";s:17:\"automatic_payment\";s:1:\"1\";s:18:\"automatic_shipment\";s:1:\"1\";s:20:\"agree_to_tos_onorder\";s:1:\"0\";s:26:\"oncheckout_show_legal_info\";s:1:\"1\";s:24:\"oncheckout_show_register\";s:1:\"1\";s:21:\"oncheckout_show_steps\";s:1:\"0\";s:29:\"oncheckout_show_register_text\";s:47:\"COM_VIRTUEMART_ONCHECKOUT_DEFAULT_TEXT_REGISTER\";s:12:\"seo_disabled\";s:1:\"0\";s:13:\"seo_translate\";s:1:\"0\";s:10:\"seo_use_id\";s:1:\"0\";s:14:\"soap_ws_cat_on\";s:1:\"0\";s:20:\"soap_ws_cat_cache_on\";s:1:\"1\";s:16:\"soap_auth_getcat\";s:1:\"1\";s:16:\"soap_auth_addcat\";s:1:\"1\";s:15:\"soap_auth_upcat\";s:1:\"1\";s:16:\"soap_auth_delcat\";s:1:\"1\";s:22:\"soap_auth_cat_otherget\";s:1:\"1\";s:22:\"soap_auth_cat_otheradd\";s:1:\"1\";s:25:\"soap_auth_cat_otherupdate\";s:1:\"1\";s:25:\"soap_auth_cat_otherdelete\";s:1:\"1\";s:15:\"soap_ws_user_on\";s:1:\"0\";s:21:\"soap_ws_user_cache_on\";s:1:\"1\";s:17:\"soap_auth_getuser\";s:1:\"1\";s:17:\"soap_auth_adduser\";s:1:\"1\";s:16:\"soap_auth_upuser\";s:1:\"1\";s:17:\"soap_auth_deluser\";s:1:\"1\";s:23:\"soap_auth_user_otherget\";s:1:\"1\";s:23:\"soap_auth_user_otheradd\";s:1:\"1\";s:26:\"soap_auth_user_otherupdate\";s:1:\"1\";s:26:\"soap_auth_user_otherdelete\";s:1:\"1\";s:15:\"soap_ws_prod_on\";s:1:\"0\";s:21:\"soap_ws_prod_cache_on\";s:1:\"1\";s:17:\"soap_auth_getprod\";s:1:\"1\";s:17:\"soap_auth_addprod\";s:1:\"1\";s:16:\"soap_auth_upprod\";s:1:\"1\";s:17:\"soap_auth_delprod\";s:1:\"1\";s:23:\"soap_auth_prod_otherget\";s:1:\"1\";s:23:\"soap_auth_prod_otheradd\";s:1:\"1\";s:26:\"soap_auth_prod_otherupdate\";s:1:\"1\";s:26:\"soap_auth_prod_otherdelete\";s:1:\"1\";s:16:\"soap_ws_order_on\";s:1:\"0\";s:22:\"soap_ws_order_cache_on\";s:1:\"1\";s:18:\"soap_auth_getorder\";s:1:\"1\";s:18:\"soap_auth_addorder\";s:1:\"1\";s:17:\"soap_auth_uporder\";s:1:\"1\";s:18:\"soap_auth_delorder\";s:1:\"1\";s:24:\"soap_auth_order_otherget\";s:1:\"1\";s:24:\"soap_auth_order_otheradd\";s:1:\"1\";s:27:\"soap_auth_order_otherupdate\";s:1:\"1\";s:27:\"soap_auth_order_otherdelete\";s:1:\"1\";s:14:\"soap_ws_sql_on\";s:1:\"0\";s:20:\"soap_ws_sql_cache_on\";s:1:\"1\";s:17:\"soap_auth_execsql\";s:1:\"1\";s:24:\"soap_auth_execsql_select\";s:1:\"1\";s:24:\"soap_auth_execsql_insert\";s:1:\"1\";s:24:\"soap_auth_execsql_update\";s:1:\"1\";s:17:\"soap_ws_custom_on\";s:1:\"0\";s:23:\"soap_ws_custom_cache_on\";s:1:\"1\";s:14:\"soap_EP_custom\";s:24:\"VM_CustomizedService.php\";s:16:\"soap_wsdl_custom\";s:18:\"VM_Customized.wsdl\";s:6:\"sctime\";d:1586161434.021069;s:6:\"vmlang\";s:5:\"ru_ru\";s:13:\"enableEnglish\";s:1:\"1\";s:21:\"enable_content_plugin\";s:1:\"0\";s:8:\"pdf_icon\";s:1:\"0\";s:12:\"ask_question\";s:1:\"0\";s:18:\"product_navigation\";s:1:\"0\";s:11:\"stockhandle\";s:4:\"none\";s:18:\"rised_availability\";s:0:\"\";s:5:\"image\";s:0:\"\";s:13:\"display_stock\";s:1:\"0\";s:18:\"show_manufacturers\";s:1:\"1\";s:20:\"manufacturer_per_row\";s:0:\"\";s:19:\"pagination_sequence\";s:0:\"\";s:12:\"forSale_path\";s:0:\"\";s:18:\"forSale_path_thumb\";s:0:\"\";s:3:\"css\";s:1:\"1\";s:6:\"jquery\";s:1:\"0\";s:6:\"jprice\";s:1:\"0\";s:5:\"jsite\";s:1:\"1\";s:8:\"askprice\";s:1:\"0\";s:26:\"oncheckout_only_registered\";s:1:\"0\";s:22:\"oncheckout_show_images\";s:1:\"0\";s:9:\"seo_sufix\";s:7:\"-detail\";s:4:\"task\";s:4:\"save\";s:6:\"option\";s:14:\"com_virtuemart\";s:4:\"view\";s:6:\"config\";s:32:\"e33dde147a5d8adf098632fa2d97d3b4\";s:1:\"1\";s:32:\"c2e20ddd3b02eca9ac7932c3ab21601a\";s:1:\"1\";s:32:\"7622cc8d3d5b8ca5e185ee268fecf584\";s:1:\"1\";s:32:\"d13184fe601844a35aa85b17a611cf22\";s:1:\"1\";s:32:\"aae7828cda5ace08a5ae001062b95597\";s:1:\"1\";s:32:\"fb20be9c16932704049726fd2bee2c9a\";s:1:\"1\";}\";s:23:\"vmlastvisitedcategoryid\";i:39;}pg_limit|s:2:\"10\";GA|a:2:{s:8:\"PageType\";s:8:\"category\";s:8:\"Products\";s:0:\"\";}ologin|a:2:{s:5:\"https\";s:1:\"0\";s:7:\"regpage\";s:4:\"auto\";}oauth|N;' , `time` = '1586161434'
  WHERE `session_id` = 'ueef0db2uls6pbfu14msl1lrt4'

40 типов SQL-запросов зафиксировано, отсортировано по вхождениям

Запросы типа SELECT:

1. 5 × SELECT extension_id AS id, element AS "option", params, enabled
  FROM u1weg_extensions
2. 4 × SELECT `slug`
  FROM `u1weg_virtuemart_products_ru_ru`
3. 3 × SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM `u1weg_virtuemart_category_categories` AS `xref`
4. 3 × SELECT `category_name`,`virtuemart_category_id`
  FROM `u1weg_virtuemart_categories_ru_ru`
5. 2 × SELECT `u1weg_virtuemart_categories_ru_ru`.* ,`u1weg_virtuemart_categories`.*
  FROM `u1weg_virtuemart_categories_ru_ru` JOIN u1weg_virtuemart_categories using (`virtuemart_category_id`)
6. 2 × SELECT count(u1weg_virtuemart_products.virtuemart_product_id) AS total
  FROM `u1weg_virtuemart_products`, `u1weg_virtuemart_product_categories`
7. 2 × SELECT `category_child_id`
  FROM `u1weg_virtuemart_category_categories`
8. 2 × SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM u1weg_virtuemart_category_categories AS `xref`
9. 2 × SELECT /*SQL_NO_CACHE*/ MIN(prices.product_price) AS product_price_min,MAX(prices.product_price) AS product_price_max,COUNT(`products`.`virtuemart_product_id`) AS products_count
  FROM u1weg_virtuemart_products AS products
  INNER JOIN u1weg_virtuemart_product_categories AS productCAT
  ON (`products`.`virtuemart_product_id` = `productCAT`.`virtuemart_product_id`)
  INNER JOIN u1weg_virtuemart_product_prices AS prices
  ON (`products`.`virtuemart_product_id` = `prices`.`virtuemart_product_id`)
  INNER JOIN u1weg_virtuemart_product_manufacturers AS productMF
  ON (`products`.`virtuemart_product_id` = `productMF`.`virtuemart_product_id`)
  INNER JOIN u1weg_virtuemart_manufacturers_ru_ru AS manufacturersRU
  ON (`productMF`.`virtuemart_manufacturer_id` = `manufacturersRU`.`virtuemart_manufacturer_id`)
10. 2 × SELECT `virtuemart_media_id`
  FROM `u1weg_virtuemart_category_medias`
11. 1 × SELECT `slug` as name
  FROM `u1weg_virtuemart_categories_ru_ru`
12. 1 × SELECT /*SQL_NO_CACHE*/ medias.virtuemart_media_id AS media_id,productMedias.virtuemart_product_id AS product_id,medias.file_url AS media_fileUrl,medias.file_url_thumb AS media_fileUrlThumb
  FROM u1weg_virtuemart_product_medias AS productMedias
  INNER JOIN u1weg_virtuemart_medias AS medias
  ON (`productMedias`.`virtuemart_media_id` = `medias`.`virtuemart_media_id`)
13. 1 × SELECT enabled, params, custom_data
  FROM u1weg_extensions
14. 1 × SELECT /*SQL_NO_CACHE*/ coupons.virtuemart_coupon_id AS coupon_id,coupons.percent_or_total AS coupon_action,coupons.coupon_code AS coupon_code,coupons.coupon_type AS coupon_type,coupons.coupon_value AS coupon_value,coupons.coupon_start_date AS coupon_start_date,coupons.coupon_expiry_date AS coupon_expiry_date,coupons.coupon_value_valid AS coupon_value_valid,coupons.coupon_rules AS coupon_rules,coupons.is_external AS coupon_external,coupons.json_data AS json_data,coupons.use_countdown AS use_countdown
  FROM u1weg_virtuemart_coupons AS coupons
15. 1 × SELECT name, alias, app_id, app_secret, auth, token, userinfo
  FROM u1weg_offlajn_oauths
16. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
  FROM u1weg_modules AS m
  LEFT JOIN u1weg_modules_menu AS mm
  ON mm.moduleid = m.id
  LEFT JOIN u1weg_extensions AS e
  ON e.element = m.module
  AND e.client_id = m.client_id
17. 1 × SELECT /*SQL_NO_CACHE*/ productCAT.virtuemart_category_id AS category_id,virtuemart_product_id AS product_id
  FROM u1weg_virtuemart_product_categories AS productCAT
18. 1 × SELECT /*SQL_NO_CACHE*/ categoriesRU.virtuemart_category_id AS category_id,catParents.category_parent_id AS category_parent_id,catParents.category_child_id AS category_child_id,categoriesRU.category_name AS category_name
  FROM u1weg_virtuemart_categories AS categories
  INNER JOIN u1weg_virtuemart_category_categories AS catParents
  ON (`categories`.`virtuemart_category_id` = `catParents`.`category_child_id`)
  INNER JOIN u1weg_virtuemart_categories_ru_ru AS categoriesRU
  ON (`categories`.`virtuemart_category_id` = `categoriesRU`.`virtuemart_category_id`)
19. 1 × SELECT /*SQL_NO_CACHE*/ products.virtuemart_product_id AS product_id,products.main_picture AS product_thumb,products.main_category AS product_main_category,products.is_new AS product_is_new,products.is_reserved AS product_is_reserved,products.product_sku AS product_sku,products.product_in_stock AS product_in_stock,productsRU.product_s_desc AS product_s_desc,productsRU.product_name AS product_name,categoriesRU.virtuemart_category_id AS category_id,prices.product_price AS product_price,prices.product_override_price AS product_priceOverride,manufacturersRU.virtuemart_manufacturer_id AS mf_id,categoriesRU.category_name AS category_name,manufacturersRU.mf_name AS mf_name,manufacturersRU.slug AS mf_slug,prOfDay.ProductId AS pod_product_id,prOfDay.TypeDiscount AS pod_TypeDiscount,prOfDay.ValueDiscount AS pod_ValueDiscount,prOfDay.DateShow_start AS pod_DateShow_start,prOfDay.DateShow_finish AS pod_DateShow_finish,prOfDay.Time_start AS pod_Time_start,prOfDay.Time_finish AS pod_Time_finish,IF (`productCAT`.`virtuemart_category_id` IS NOT NULL, CONCAT('[', GROUP_CONCAT( DISTINCT CONCAT( '{', '"id":"', `productCAT`.`virtuemart_category_id`, '",', '"name":"', `categoriesRU`.`category_name`, '"}' ) ), ']'), '[]' ) AS product_categories,IF (`productCustom`.`virtuemart_product_id` IS NOT NULL, CONCAT('[', GROUP_CONCAT( DISTINCT CONCAT( '{', '"id":"', productCustom.virtuemart_custom_id, '",', /*'"rest":"', productCustom.rest, '",',*/ '"value":"', productCustom.custom_value, '"}' ) ), ']'), '[]' ) AS custom_attributes
  FROM u1weg_virtuemart_products AS products
  INNER JOIN u1weg_virtuemart_products_ru_ru AS productsRU
  ON (`products`.`virtuemart_product_id` = `productsRU`.`virtuemart_product_id`)
  INNER JOIN u1weg_virtuemart_product_categories AS productCAT
  ON (`products`.`virtuemart_product_id` = `productCAT`.`virtuemart_product_id`)
  INNER JOIN u1weg_virtuemart_product_prices AS prices
  ON (`products`.`virtuemart_product_id` = `prices`.`virtuemart_product_id`)
  INNER JOIN u1weg_virtuemart_product_manufacturers AS productMF
  ON (`products`.`virtuemart_product_id` = `productMF`.`virtuemart_product_id`)
  LEFT JOIN u1weg_virtuemart_product_customfields AS productCustom
  ON (`products`.`virtuemart_product_id` = `productCustom`.`virtuemart_product_id`)
  INNER JOIN u1weg_virtuemart_categories_ru_ru AS categoriesRU
  ON (`productCAT`.`virtuemart_category_id` = `categoriesRU`.`virtuemart_category_id`)
  INNER JOIN u1weg_virtuemart_manufacturers_ru_ru AS manufacturersRU
  ON (`productMF`.`virtuemart_manufacturer_id` = `manufacturersRU`.`virtuemart_manufacturer_id`)
  LEFT JOIN shop_productOFday AS prOfDay
  ON (`products`.virtuemart_product_id = `prOfDay`.ProductId
  AND (`prOfDay`.Time_start < '1586161434'
  AND `prOfDay`.Time_finish > '1586161434'))
20. 1 × SELECT `virtuemart_permgroup_id`,`group_name`,`group_level`
  FROM `u1weg_virtuemart_permgroups`
21. 1 × select id, title, alias
  from u1weg_jumi
22. 1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
  FROM u1weg_menu AS m
  LEFT JOIN u1weg_extensions AS e
  ON m.component_id = e.extension_id
23. 1 × SELECT folder AS type, element AS name, params
  FROM u1weg_extensions
24. 1 × SELECT id, rules
  FROM `u1weg_viewlevels
25. 1 × SELECT `session_id`
  FROM `u1weg_session`
26. 1 × SELECT b.id
  FROM u1weg_usergroups AS a
  LEFT JOIN u1weg_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
27. 1 × SELECT `config`
  FROM `u1weg_virtuemart_configs`
28. 1 × SELECT *
  FROM u1weg_languages
29. 1 × SELECT `data`
  FROM `u1weg_session`
30. 1 × SELECT SQL_CALC_FOUND_ROWS c.`virtuemart_category_id`, l.`category_description`, l.`category_name`, c.`ordering`, c.`published`, cx.`category_child_id`, cx.`category_parent_id`, c.`shared`
  FROM `u1weg_virtuemart_categories_ru_ru` l JOIN `u1weg_virtuemart_categories` AS c using (`virtuemart_category_id`)
  LEFT JOIN `u1weg_virtuemart_category_categories` AS cx
  ON l.`virtuemart_category_id` = cx.`category_child_id`
31. 1 × SELECT id, home, template, s.params
  FROM u1weg_template_styles as s
  LEFT JOIN u1weg_extensions as e
  ON e.element=s.template
  AND e.type='template'
  AND e.client_id=s.client_id
32. 1 × SELECT `virtuemart_category_id`
  FROM `u1weg_virtuemart_categories_ru_ru`
33. 1 × SELECT *
  FROM `u1weg_menu`
34. 1 × SELECT FOUND_ROWS(

Прочие SQL-запросы:

1. 1 ×
  SET SESSION group_concat_max_len = 10000000
2. 1 × UPDATE `u1weg_session`
  SET `data` = '__default|a:11:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1586161433;s:18:\"session.timer.last\";i:1586161433;s:17:\"session.timer.now\";i:1586161433;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":3:{s:6:\"global\";O:8:\"stdClass\":1:{s:4:\"list\";O:8:\"stdClass\":1:{s:5:\"
  limit\";i:10;}}s:22:\"com_virtuemartcategory\";O:8:\"stdClass\":1:{s:10:\"limitstart\";i:0;}s:14:\"com_virtuemart\";O:8:\"stdClass\":1:{s:8:\"category\";O:8:\"stdClass\":2:{s:5:\"
  limit\";i:10;s:10:\"limitstart\";i:0;}}}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";N;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";N;s:14:\"\0*\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:4;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:10:\"vm_mf_name\";s:5:\"Venum\";s:13:\"vm_mf_name_RU\";s:10:\"Венум\";s:12:\"vm_custom_h1\";s:0:\"\";s:13:\"session.token\";s:32:\"62d1d450ec3e2ec77f1779b3413b6c34\";}__vm|a:2:{s:8:\"vmconfig\";s:6908:\"a:182:{s:15:\"shop_is_offline\";s:1:\"0\";s:15:\"offline_message\";s:100:\"T3VyIFNob3AgaXMgY3VycmVudGx5IGRvd24gZm9yIG1haW50ZW5hbmNlLiBQbGVhc2UgY2hlY2sgYmFjayBhZ2FpbiBzb29uLg==\";s:14:\"use_as_catalog\";s:1:\"0\";s:25:\"currency_converter_module\";s:14:\"convertECB.php\";s:15:\"order_mail_html\";s:1:\"1\";s:10:\"dateformat\";s:8:\"%m/%d/%y\";s:6:\"useSSL\";s:1:\"0\";s:14:\"dangeroustools\";s:1:\"0\";s:12:\"debug_enable\";s:4:\"none\";s:13:\"google_jquery\";s:1:\"1\";s:6:\"multix\";s:1:\"1\";s:17:\"pdf_button_enable\";s:1:\"1\";s:16:\"show_emailfriend\";s:1:\"1\";s:14:\"show_printicon\";s:1:\"0\";s:26:\"show_out_of_stock_products\";s:1:\"1\";s:14:\"coupons_enable\";s:1:\"0\";s:22:\"coupons_default_expire\";s:3:\"1,D\";s:19:\"weight_unit_default\";s:2:\"KG\";s:16:\"lwh_unit_default\";s:1:\"M\";s:10:\"list_limit\";s:2:\"10\";s:13:\"showReviewFor\";s:3:\"all\";s:10:\"reviewMode\";s:10:\"registered\";s:13:\"showRatingFor\";s:3:\"all\";s:10:\"ratingMode\";s:10:\"registered\";s:19:\"reviews_autopublish\";s:1:\"1\";s:30:\"reviews_minimum_comment_length\";s:3:\"100\";s:30:\"reviews_maximum_comment_length\";s:4:\"2000\";s:10:\"vmtemplate\";s:7:\"default\";s:16:\"categorytemplate\";s:7:\"default\";s:12:\"showCategory\";s:1:\"1\";s:14:\"categorylayout\";s:7:\"default\";s:18:\"categories_per_row\";s:1:\"3\";s:13:\"productlayout\";s:7:\"default\";s:16:\"products_per_row\";s:1:\"3\";s:8:\"vmlayout\";s:18:\"default_categories\";s:13:\"show_featured\";s:1:\"1\";s:25:\"featured_products_per_row\";s:1:\"3\";s:11:\"show_topTen\";s:1:\"1\";s:23:\"topten_products_per_row\";s:1:\"3\";s:11:\"show_recent\";s:1:\"1\";s:11:\"show_latest\";s:1:\"1\";s:19:\"assets_general_path\";s:33:\"components/com_virtuemart/assets/\";s:19:\"media_category_path\";s:35:\"images/stories/virtuemart/category/\";s:18:\"media_product_path\";s:34:\"images/stories/virtuemart/product/\";s:23:\"media_manufacturer_path\";s:39:\"images/stories/virtuemart/manufacturer/\";s:17:\"media_vendor_path\";s:33:\"images/stories/virtuemart/vendor/\";s:17:\"img_resize_enable\";s:1:\"1\";s:9:\"img_width\";s:3:\"140\";s:10:\"img_height\";s:3:\"140\";s:12:\"no_image_set\";s:11:\"noimage.gif\";s:14:\"no_image_found\";s:18:\"previous_16x16.png\";s:20:\"browse_orderby_field\";s:23:\"p.virtuemart_product_id\";s:21:\"browse_orderby_fields\";a:4:{i:0;s:12:\"product_name\";i:1;s:11:\"product_sku\";i:2;s:13:\"category_name\";i:3;s:7:\"mf_name\";}s:20:\"browse_search_fields\";a:6:{i:0;s:12:\"product_name\";i:1;s:11:\"product_sku\";i:2;s:14:\"product_s_desc\";i:3;s:13:\"category_name\";i:4;s:20:\"category_description\";i:5;s:7:\"mf_name\";}s:11:\"show_prices\";s:1:\"1\";s:28:\"price_access_level_published\";s:1:\"0\";s:31:\"price_show_packaging_pricelabel\";s:1:\"0\";s:8:\"show_tax\";s:1:\"1\";s:9:\"basePrice\";s:1:\"1\";s:13:\"basePriceText\";s:1:\"1\";s:17:\"basePriceRounding\";s:1:\"2\";s:19:\"variantModification\";s:1:\"1\";s:23:\"variantModificationText\";s:1:\"1\";s:27:\"variantModificationRounding\";s:1:\"2\";s:16:\"basePriceVariant\";s:1:\"1\";s:20:\"basePriceVariantText\";s:1:\"1\";s:24:\"basePriceVariantRounding\";s:1:\"2\";s:16:\"basePriceWithTax\";s:1:\"1\";s:20:\"basePriceWithTaxText\";s:1:\"1\";s:24:\"basePriceWithTaxRounding\";s:1:\"2\";s:25:\"discountedPriceWithoutTax\";s:1:\"1\";s:29:\"discountedPriceWithoutTaxText\";s:1:\"1\";s:33:\"discountedPriceWithoutTaxRounding\";s:1:\"2\";s:22:\"salesPriceWithDiscount\";s:1:\"1\";s:26:\"salesPriceWithDiscountText\";s:1:\"1\";s:30:\"salesPriceWithDiscountRounding\";s:1:\"2\";s:10:\"salesPrice\";s:1:\"1\";s:14:\"salesPriceText\";s:1:\"1\";s:18:\"salesPriceRounding\";s:1:\"2\";s:15:\"priceWithoutTax\";s:1:\"1\";s:19:\"priceWithoutTaxText\";s:1:\"1\";s:23:\"priceWithoutTaxRounding\";s:1:\"2\";s:14:\"discountAmount\";s:1:\"1\";s:18:\"discountAmountText\";s:1:\"1\";s:22:\"discountAmountRounding\";s:1:\"2\";s:9:\"taxAmount\";s:1:\"1\";s:13:\"taxAmountText\";s:1:\"1\";s:17:\"taxAmountRounding\";s:1:\"2\";s:11:\"check_stock\";s:1:\"0\";s:17:\"automatic_payment\";s:1:\"1\";s:18:\"automatic_shipment\";s:1:\"1\";s:20:\"agree_to_tos_onorder\";s:1:\"0\";s:26:\"oncheckout_show_legal_info\";s:1:\"1\";s:24:\"oncheckout_show_register\";s:1:\"1\";s:21:\"oncheckout_show_steps\";s:1:\"0\";s:29:\"oncheckout_show_register_text\";s:47:\"COM_VIRTUEMART_ONCHECKOUT_DEFAULT_TEXT_REGISTER\";s:12:\"seo_disabled\";s:1:\"0\";s:13:\"seo_translate\";s:1:\"0\";s:10:\"seo_use_id\";s:1:\"0\";s:14:\"soap_ws_cat_on\";s:1:\"0\";s:20:\"soap_ws_cat_cache_on\";s:1:\"1\";s:16:\"soap_auth_getcat\";s:1:\"1\";s:16:\"soap_auth_addcat\";s:1:\"1\";s:15:\"soap_auth_upcat\";s:1:\"1\";s:16:\"soap_auth_delcat\";s:1:\"1\";s:22:\"soap_auth_cat_otherget\";s:1:\"1\";s:22:\"soap_auth_cat_otheradd\";s:1:\"1\";s:25:\"soap_auth_cat_otherupdate\";s:1:\"1\";s:25:\"soap_auth_cat_otherdelete\";s:1:\"1\";s:15:\"soap_ws_user_on\";s:1:\"0\";s:21:\"soap_ws_user_cache_on\";s:1:\"1\";s:17:\"soap_auth_getuser\";s:1:\"1\";s:17:\"soap_auth_adduser\";s:1:\"1\";s:16:\"soap_auth_upuser\";s:1:\"1\";s:17:\"soap_auth_deluser\";s:1:\"1\";s:23:\"soap_auth_user_otherget\";s:1:\"1\";s:23:\"soap_auth_user_otheradd\";s:1:\"1\";s:26:\"soap_auth_user_otherupdate\";s:1:\"1\";s:26:\"soap_auth_user_otherdelete\";s:1:\"1\";s:15:\"soap_ws_prod_on\";s:1:\"0\";s:21:\"soap_ws_prod_cache_on\";s:1:\"1\";s:17:\"soap_auth_getprod\";s:1:\"1\";s:17:\"soap_auth_addprod\";s:1:\"1\";s:16:\"soap_auth_upprod\";s:1:\"1\";s:17:\"soap_auth_delprod\";s:1:\"1\";s:23:\"soap_auth_prod_otherget\";s:1:\"1\";s:23:\"soap_auth_prod_otheradd\";s:1:\"1\";s:26:\"soap_auth_prod_otherupdate\";s:1:\"1\";s:26:\"soap_auth_prod_otherdelete\";s:1:\"1\";s:16:\"soap_ws_order_on\";s:1:\"0\";s:22:\"soap_ws_order_cache_on\";s:1:\"1\";s:18:\"soap_auth_getorder\";s:1:\"1\";s:18:\"soap_auth_addorder\";s:1:\"1\";s:17:\"soap_auth_uporder\";s:1:\"1\";s:18:\"soap_auth_delorder\";s:1:\"1\";s:24:\"soap_auth_order_otherget\";s:1:\"1\";s:24:\"soap_auth_order_otheradd\";s:1:\"1\";s:27:\"soap_auth_order_otherupdate\";s:1:\"1\";s:27:\"soap_auth_order_otherdelete\";s:1:\"1\";s:14:\"soap_ws_sql_on\";s:1:\"0\";s:20:\"soap_ws_sql_cache_on\";s:1:\"1\";s:17:\"soap_auth_execsql\";s:1:\"1\";s:24:\"soap_auth_execsql_select\";s:1:\"1\";s:24:\"soap_auth_execsql_insert\";s:1:\"1\";s:24:\"soap_auth_execsql_update\";s:1:\"1\";s:17:\"soap_ws_custom_on\";s:1:\"0\";s:23:\"soap_ws_custom_cache_on\";s:1:\"1\";s:14:\"soap_EP_custom\";s:24:\"VM_CustomizedService.php\";s:16:\"soap_wsdl_custom\";s:18:\"VM_Customized.wsdl\";s:6:\"sctime\";d:1586161434.021069;s:6:\"vmlang\";s:5:\"ru_ru\";s:13:\"enableEnglish\";s:1:\"1\";s:21:\"enable_content_plugin\";s:1:\"0\";s:8:\"pdf_icon\";s:1:\"0\";s:12:\"ask_question\";s:1:\"0\";s:18:\"product_navigation\";s:1:\"0\";s:11:\"stockhandle\";s:4:\"none\";s:18:\"rised_availability\";s:0:\"\";s:5:\"image\";s:0:\"\";s:13:\"display_stock\";s:1:\"0\";s:18:\"show_manufacturers\";s:1:\"1\";s:20:\"manufacturer_per_row\";s:0:\"\";s:19:\"pagination_sequence\";s:0:\"\";s:12:\"forSale_path\";s:0:\"\";s:18:\"forSale_path_thumb\";s:0:\"\";s:3:\"css\";s:1:\"1\";s:6:\"jquery\";s:1:\"0\";s:6:\"jprice\";s:1:\"0\";s:5:\"jsite\";s:1:\"1\";s:8:\"askprice\";s:1:\"0\";s:26:\"oncheckout_only_registered\";s:1:\"0\";s:22:\"oncheckout_show_images\";s:1:\"0\";s:9:\"seo_sufix\";s:7:\"-detail\";s:4:\"task\";s:4:\"save\";s:6:\"option\";s:14:\"com_virtuemart\";s:4:\"view\";s:6:\"config\";s:32:\"e33dde147a5d8adf098632fa2d97d3b4\";s:1:\"1\";s:32:\"c2e20ddd3b02eca9ac7932c3ab21601a\";s:1:\"1\";s:32:\"7622cc8d3d5b8ca5e185ee268fecf584\";s:1:\"1\";s:32:\"d13184fe601844a35aa85b17a611cf22\";s:1:\"1\";s:32:\"aae7828cda5ace08a5ae001062b95597\";s:1:\"1\";s:32:\"fb20be9c16932704049726fd2bee2c9a\";s:1:\"1\";}\";s:23:\"vmlastvisitedcategoryid\";i:39;}pg_limit|s:2:\"10\";GA|a:2:{s:8:\"PageType\";s:8:\"category\";s:8:\"Products\";s:0:\"\";}ologin|a:2:{s:5:\"https\";s:1:\"0\";s:7:\"regpage\";s:4:\"auto\";}oauth|N;' , `time` = '1586161434'
3. 1 × SHOW FULL COLUMNS
  FROM `u1weg_virtuemart_categories
4. 1 × SHOW TABLES LIKE "%virtuemart_configs%
5. 1 × INSERT INTO `u1weg_session` (`session_id`, `client_id`, `time`)
  VALUES ('ueef0db2uls6pbfu14msl1lrt4', 0, '1586161433'
6. 1 × DELETE
  FROM `u1weg_session`