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

1. SELECT `data`
  FROM `jdb_session`
  WHERE `session_id` = 'db393d9e52e16905f54a28d6d33d3623'
2. SELECT `session_id`
  FROM `jdb_session`
  WHERE `session_id` = 'db393d9e52e16905f54a28d6d33d3623'
  LIMIT 0, 1
3. INSERT INTO `jdb_session` (`session_id`, `client_id`, `time`)
  VALUES ('db393d9e52e16905f54a28d6d33d3623', 0, '1471231820')
4. SELECT b.id
  FROM jdb_usergroups AS a
  LEFT JOIN jdb_usergroups AS b
  ON b.lft = a.lft
  AND b.rgt >= a.rgt
  WHERE a.id = 1
5. SELECT id, rules
  FROM `jdb_viewlevels`
6. SELECT nh.*, (SELECT n.`cookie`
  FROM jdb_avtohol_newhar n
  WHERE nh.newhar = n.id) as `cookie`
  FROM jdb_avtohol_newhar_href nh
  WHERE nh.hartype IN ('selectbox', 'checkbox')
7. SELECT *
  FROM jdb_avtohol_newhar_href
  WHERE hartype IN ('selectbox', 'checkbox')
  AND newhar IN (SELECT `id`
  FROM `jdb_avtohol_newhar`
  WHERE `cookie`=1
  AND published=1)
8. 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 jdb_menu AS m
  LEFT JOIN jdb_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
9. SHOW FULL COLUMNS
  FROM `jdb_jshopping_config`
10. SELECT *
  FROM jdb_jshopping_config
  WHERE `id` = '1'
11. SHOW FULL COLUMNS
  FROM `jdb_jshopping_currencies`
12. SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value
  FROM `jdb_jshopping_currencies`
  WHERE currency_publish = '1'
  ORDER BY currency_ordering
13. select product_id as id, `alias_ru-RU` as alias
  from jdb_jshopping_products
  where `alias_ru-RU`!=''
14. SELECT *
  FROM jdb_jshopping_categories
  WHERE category_id =62
15. SELECT *
  FROM jdb_avtohol_newhar_href
  WHERE hartype='several_selectbox'
16. select *
  from jdb_jshopping_languages
17. UPDATE `jdb_jshopping_products`
  SET `product_price`=`product_old_price`, `product_old_price`='0.00', `price_date_end`='0000-00-00 00:00:00'
  WHERE ( product_old_price > product_price
  AND price_date_end = '2016-08-15 06:30:21'
  AND price_date_end '0000-00-00 00:00:00' )
18. SHOW FULL COLUMNS
  FROM `jdb_jshopping_products`
19. SELECT *
  FROM jdb_jshopping_products
  WHERE `product_id` = '950'
20. SELECT *
  FROM `jdb_jshopping_products_to_categories`
  WHERE product_id='950'
21. SHOW FULL COLUMNS
  FROM `jdb_jshopping_attr`
22. SELECT attr_id, `name_ru-RU` as name, `description_ru-RU` as description, attr_type, independent, allcats, cats, attr_ordering
  FROM `jdb_jshopping_attr`
  ORDER BY attr_ordering
23. SELECT *
  FROM `jdb_jshopping_products_attr`
  WHERE product_id = '950'
  ORDER BY product_attr_id
24. SELECT *
  FROM `jdb_jshopping_products_attr2`
  WHERE product_id = '950'
  ORDER BY id
25. SHOW FULL COLUMNS
  FROM `jdb_jshopping_users`
26. SHOW FULL COLUMNS
  FROM `jdb_jshopping_products_extra_fields`
27. SELECT F.id, F.`name_ru-RU` as name, F.`description_ru-RU` as description, F.allcats, F.type, F.cats, F.ordering, F.`
  group`, G.`name_ru-RU` as groupname, multilist
  FROM `jdb_jshopping_products_extra_fields` as F
  left join `jdb_jshopping_products_extra_field_groups` as G
  on G.id=F.
  group
  order by G.ordering, F.ordering
28. SHOW FULL COLUMNS
  FROM `jdb_jshopping_taxes`
29. SELECT tax_id, tax_name, tax_value
  FROM `jdb_jshopping_taxes`
30. SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` as short_description, prod.product_ean, prod.product_thumb_image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.`extra_field_109` , prod.`extra_field_1` , prod.`extra_field_4` , prod.`extra_field_5` , prod.`extra_field_73` , prod.`extra_field_147` , prod.`extra_field_148` , prod.`extra_field_149` , prod.`extra_field_151` , prod.`extra_field_150` , prod.`extra_field_152` , prod.`extra_field_153` , prod.`extra_field_154` , prod.`extra_field_155` , prod.`extra_field_156` , prod.`extra_field_110` , prod.`extra_field_78` , prod.`extra_field_76` , prod.`extra_field_77` , prod.`extra_field_85` , prod.`extra_field_79` , prod.`extra_field_81` , prod.`extra_field_82` , prod.`extra_field_80` , prod.`extra_field_83` , prod.`extra_field_125` , prod.`extra_field_84` , prod.`extra_field_112` , prod.`extra_field_113` , prod.`extra_field_114` , prod.`extra_field_117` , prod.`extra_field_115` , prod.`extra_field_116` , prod.`extra_field_124` , prod.`extra_field_118` , prod.`extra_field_119` , prod.`extra_field_122` , prod.`extra_field_121` , prod.`extra_field_120` , prod.`extra_field_123` , prod.`extra_field_144` , prod.`extra_field_145` , prod.`extra_field_146` , prod.`extra_field_87` , prod.`extra_field_126` , prod.`extra_field_127` , prod.`extra_field_128` , prod.`extra_field_129` , prod.`extra_field_130` , prod.`extra_field_135` , prod.`extra_field_136` , prod.`extra_field_131` , prod.`extra_field_132` , prod.`extra_field_133` , prod.`extra_field_134` , prod.`extra_field_97` , prod.`extra_field_98` , prod.`extra_field_96` , prod.`extra_field_138` , prod.`extra_field_139` , prod.`extra_field_140` , prod.`extra_field_141` , prod.`extra_field_157` , prod.product_bonus
  FROM `jdb_jshopping_products_relations` AS relation
  INNER JOIN `jdb_jshopping_products` AS prod
  ON relation.product_related_id = prod.product_id
  LEFT JOIN `jdb_jshopping_products_to_categories` AS pr_cat
  ON pr_cat.product_id = relation.product_related_id
  LEFT JOIN `jdb_jshopping_categories` AS cat
  ON pr_cat.category_id = cat.category_id
  WHERE relation.product_id = '950'
  AND cat.category_publish='1'
  AND prod.product_publish = '1'
  AND prod.access IN (1,1)
  AND cat.access IN (1,1)
  group by prod.product_id
  order by relation.id
31. select id,link
  from jdb_menu
  where `type`='component'
  and published=1
  and link like '%option=com_jshopping%'
  and client_id=0
  and (language='*' or language='ru-RU')
  and access IN (1,1)
32. select category_id as id, `alias_ru-RU` as alias
  from jdb_jshopping_categories
  where `alias_ru-RU`!=''
33. select manufacturer_id as id, `name_ru-RU` as name, manufacturer_logo, manufacturer_url
  from jdb_jshopping_manufacturers
  where manufacturer_publish='1'
34. SHOW FULL COLUMNS
  FROM `jdb_jshopping_products_extra_field_values`
35. SELECT id, `name_ru-RU` as name, field_id
  FROM `jdb_jshopping_products_extra_field_values`
  order by ordering
36. select min(category_id) as category_id, product_id
  from jdb_jshopping_products_to_categories
  group by product_id
37. SHOW FULL COLUMNS
  FROM `jdb_jshopping_categories`
38. SELECT *
  FROM jdb_jshopping_categories
  WHERE `category_id` = '62'
39. UPDATE jdb_jshopping_products
  SET `hits` = (`hits` + 1)
  WHERE product_id = '950'
40. SHOW FULL COLUMNS
  FROM `jdb_jshopping_products_reviews`
41. SELECT FA.id, FA.required, FA.`name_ru-RU` as name, FA.`description_ru-RU` as description, FA.type
  FROM `jdb_jshopping_products_free_attr` as PFA
  left join `jdb_jshopping_free_attr` as FA
  on FA.id=PFA.attr_id
  WHERE PFA.product_id = '950'
  order by FA.ordering
42. SHOW FULL COLUMNS
  FROM `jdb_jshopping_product_labels`
43. SELECT id, image, `name_ru-RU` as name
  FROM `jdb_jshopping_product_labels`
  ORDER BY name
44. SELECT I.*, IF(P.product_name_image=I.image_name,0,1) as sort
  FROM `jdb_jshopping_products_images` as I
  left join `jdb_jshopping_products` as P
  on P.product_id=I.product_id
  WHERE I.product_id = '950'
  ORDER BY sort, I.ordering
45. SELECT video_name, video_id, video_preview, video_code
  FROM `jdb_jshopping_products_videos`
  WHERE product_id = '950'
46. SELECT *
  FROM `jdb_jshopping_products_files`
  WHERE product_id = '950'
  and demo!=''
  order by `ordering`
47. SELECT *
  FROM jdb_jshopping_product_labels
  WHERE `id` = '1'
48. SELECT *
  FROM jdb_jshopping_products
  WHERE `product_id` = '10260'
49. SELECT *
  FROM jdb_jshopping_products
  WHERE `product_id` = '9378'
50. SELECT *
  FROM jdb_jshopping_products
  WHERE `product_id` = '5787'
51. SELECT *
  FROM jdb_jshopping_products
  WHERE `product_id` = '943'
52. SELECT *
  FROM jdb_jshopping_products
  WHERE `product_id` = '940'
53. SELECT *
  FROM jdb_jshopping_products
  WHERE `product_id` = '945'
54. SELECT *
  FROM jdb_jshopping_products
  WHERE `product_id` = '4251'
55. SELECT pr_cat.category_id
  FROM `jdb_jshopping_products_to_categories` AS pr_cat
  LEFT JOIN `jdb_jshopping_categories` AS cat
  ON pr_cat.category_id = cat.category_id
  WHERE pr_cat.product_id = '950'
  AND cat.category_publish='1'
  AND cat.access IN (1,1)
  LIMIT 0,1
56. SELECT count(review_id)
  FROM `jdb_jshopping_products_reviews`
  WHERE product_id = '950'
  and publish='1'
57. SELECT *
  FROM `jdb_jshopping_products_reviews`
  WHERE product_id = '950'
  and publish='1'
  order by review_id desc
  LIMIT 0, 20
58. SHOW FULL COLUMNS
  FROM `jdb_jshopping_addons`
59. select `id`
  from jdb_jshopping_addons
  where `alias`='addon_bonus_system'
60. SELECT *
  FROM jdb_jshopping_addons
  WHERE `id` = '6'
61. SHOW FULL COLUMNS
  FROM `jdb_jshopping_usergroups`
62. UPDATE `jdb_jshopping_products`
  SET `product_price`=`product_old_price`, `product_old_price`='0.00', `price_date_end`='0000-00-00 00:00:00'
  WHERE ( product_old_price > product_price
  AND price_date_end = '2016-08-15 06:30:22'
  AND price_date_end '0000-00-00 00:00:00' )
63. SELECT *
  FROM jdb_jshopping_categories
  WHERE `category_id` = '62'
64. SHOW FULL COLUMNS
  FROM `jdb_jshopping_vendors`
65. SELECT id
  FROM jdb_jshopping_vendors
  WHERE `main`=1
66. SELECT *
  FROM jdb_jshopping_vendors
  WHERE `id` = '1'
67. SELECT har
  FROM jdb_avtohol_newhar_href
  WHERE hartype='several_selectbox'
68. SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` as short_description, prod.product_ean, prod.product_thumb_image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.`extra_field_109` , prod.`extra_field_1` , prod.`extra_field_4` , prod.`extra_field_5` , prod.`extra_field_73` , prod.`extra_field_147` , prod.`extra_field_148` , prod.`extra_field_149` , prod.`extra_field_151` , prod.`extra_field_150` , prod.`extra_field_152` , prod.`extra_field_153` , prod.`extra_field_154` , prod.`extra_field_155` , prod.`extra_field_156` , prod.`extra_field_110` , prod.`extra_field_78` , prod.`extra_field_76` , prod.`extra_field_77` , prod.`extra_field_85` , prod.`extra_field_79` , prod.`extra_field_81` , prod.`extra_field_82` , prod.`extra_field_80` , prod.`extra_field_83` , prod.`extra_field_125` , prod.`extra_field_84` , prod.`extra_field_112` , prod.`extra_field_113` , prod.`extra_field_114` , prod.`extra_field_117` , prod.`extra_field_115` , prod.`extra_field_116` , prod.`extra_field_124` , prod.`extra_field_118` , prod.`extra_field_119` , prod.`extra_field_122` , prod.`extra_field_121` , prod.`extra_field_120` , prod.`extra_field_123` , prod.`extra_field_144` , prod.`extra_field_145` , prod.`extra_field_146` , prod.`extra_field_87` , prod.`extra_field_126` , prod.`extra_field_127` , prod.`extra_field_128` , prod.`extra_field_129` , prod.`extra_field_130` , prod.`extra_field_135` , prod.`extra_field_136` , prod.`extra_field_131` , prod.`extra_field_132` , prod.`extra_field_133` , prod.`extra_field_134` , prod.`extra_field_97` , prod.`extra_field_98` , prod.`extra_field_96` , prod.`extra_field_138` , prod.`extra_field_139` , prod.`extra_field_140` , prod.`extra_field_141` , prod.`extra_field_157` , IF(prod.product_quantity>0,1,0) as qflag, prod.product_bonus
  FROM `jdb_jshopping_products` AS prod
  LEFT JOIN `jdb_jshopping_products_to_categories` AS pr_cat USING (product_id)
  LEFT JOIN `jdb_jshopping_currencies` AS cr USING (currency_id)
  WHERE pr_cat.category_id = '62'
  AND prod.product_publish = '1'
  AND prod.access IN (1,1)
  ORDER BY qflag DESC, prod.product_price/cr.currency_value ASC
69. select `id`
  from jdb_jshopping_addons
  where `alias`='products_compare'
70. SELECT *
  FROM jdb_jshopping_addons
  WHERE `id` = '12'
71. SELECT m.published, m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.params as advancedparams, 0 as menuid, m.publish_up, m.publish_down
  FROM jdb_modules AS m
  LEFT JOIN jdb_extensions AS e
  ON e.element = m.module
  AND e.client_id = m.client_id
  LEFT JOIN jdb_advancedmodules as am
  ON am.moduleid = m.id
  WHERE m.published = 1
  AND e.enabled = 1
  AND m.client_id = 0
  AND m.access IN (1,1)
  ORDER BY m.ordering, m.id
72. SELECT m.menutype
  FROM jdb_menu AS m
  WHERE m.id = 606
73. UPDATE `jdb_session`
  SET `data` = 'joomla|s:3216:\"Tzo5OiJKUmVnaXN0cnkiOjE6e3M6NzoiACoAZGF0YSI7Tzo4OiJzdGRDbGFzcyI6MTp7czo5OiJfX2RlZmF1bHQiO086ODoic3RkQ2xhc3MiOjEwOntzOjc6InNlc3Npb24iO086ODoic3RkQ2xhc3MiOjM6e3M6NzoiY291bnRlciI7aToxO3M6NToidGltZXIiO086ODoic3RkQ2xhc3MiOjM6e3M6NToic3RhcnQiO2k6MTQ3MTIzMTgyMDtzOjQ6Imxhc3QiO2k6MTQ3MTIzMTgyMDtzOjM6Im5vdyI7aToxNDcxMjMxODIwO31zOjU6InRva2VuIjtzOjMyOiIzMmQwZDE5MDNjOWUyOTQ3OWRmMjMzNWNmMTYzMDFhNiI7fXM6ODoicmVnaXN0cnkiO086OToiSlJlZ2lzdHJ5IjoxOntzOjc6IgAqAGRhdGEiO086ODoic3RkQ2xhc3MiOjE6e3M6ODoianNob3BpbmciO086ODoic3RkQ2xhc3MiOjE6e3M6NDoibGlzdCI7Tzo4OiJzdGRDbGFzcyI6MTp7czo1OiJmcm9udCI7Tzo4OiJzdGRDbGFzcyI6MTp7czo3OiJwcm9kdWN0IjtPOjg6InN0ZENsYXNzIjoxOntzOjM6ImNhdCI7Tzo4OiJzdGRDbGFzcyI6MTp7czoxNDoiNjJleHRyYV9maWVsZHMiO2E6Nzg6e2k6ODthOjA6e31pOjk7YTowOnt9aToxMDthOjA6e31pOjExO2E6MDp7fWk6MTI7YTowOnt9aToxMzthOjA6e31pOjE0O2E6MDp7fWk6MTU7YTowOnt9aToxNjthOjA6e31pOjE3O2E6MDp7fWk6MTg7YTowOnt9aToxOTthOjA6e31pOjIwO2E6MDp7fWk6MjE7YTowOnt9aToyMjthOjA6e31pOjIzO2E6MDp7fWk6MjQ7YTowOnt9aToyNTthOjA6e31pOjI2O2E6MDp7fWk6Mjc7YTowOnt9aToyODthOjA6e31pOjI5O2E6MDp7fWk6MzA7YTowOnt9aTozMTthOjA6e31pOjMyO2E6MDp7fWk6MzM7YTowOnt9aTozNDthOjA6e31pOjM1O2E6MDp7fWk6MzY7YTowOnt9aTozNzthOjA6e31pOjM4O2E6MDp7fWk6Mzk7YTowOnt9aTo0MDthOjA6e31pOjQxO2E6MDp7fWk6NDI7YTowOnt9aTo0MzthOjA6e31pOjQ0O2E6MDp7fWk6NDU7YTowOnt9aTo0NjthOjA6e31pOjQ3O2E6MDp7fWk6NDg7YTowOnt9aTo0OTthOjA6e31pOjUwO2E6MDp7fWk6NTE7YTowOnt9aTo1MjthOjA6e31pOjUzO2E6MDp7fWk6NTQ7YTowOnt9aTo1NTthOjA6e31pOjU2O2E6MDp7fWk6NTc7YTowOnt9aTo1ODthOjA6e31pOjU5O2E6MDp7fWk6NjA7YTowOnt9aTo2MTthOjA6e31pOjYyO2E6MDp7fWk6NjM7YTowOnt9aTo2ODthOjA6e31pOjcyO2E6MDp7fWk6Njk7YTowOnt9aTo2NzthOjA6e31pOjY2O2E6MDp7fWk6NzA7YTowOnt9aTo3MTthOjA6e31pOjg5O2E6MDp7fWk6OTA7YTowOnt9aTo5MTthOjA6e31pOjkyO2E6MDp7fWk6OTM7YTowOnt9aTo5NDthOjA6e31pOjk5O2E6MDp7fWk6MTAwO2E6MDp7fWk6MTAxO2E6MDp7fWk6MTA2O2E6MDp7fWk6MTA3O2E6MDp7fWk6MTA4O2E6MDp7fWk6MTExO2E6MDp7fWk6MzthOjA6e31pOjEzNzthOjA6e319fX19fX19fXM6NDoidXNlciI7Tzo1OiJKVXNlciI6MjU6e3M6OToiACoAaXNSb290IjtOO3M6MjoiaWQiO2k6MDtzOjQ6Im5hbWUiO047czo4OiJ1c2VybmFtZSI7TjtzOjU6ImVtYWlsIjtOO3M6ODoicGFzc3dvcmQiO047czoxNDoicGFzc3dvcmRfY2xlYXIiO3M6MDoiIjtzOjg6InVzZXJ0eXBlIjtOO3M6NToiYmxvY2siO047czo5OiJzZW5kRW1haWwiO2k6MDtzOjEyOiJyZWdpc3RlckRhdGUiO047czoxMzoibGFzdHZpc2l0RGF0ZSI7TjtzOjEwOiJhY3RpdmF0aW9uIjtOO3M6NjoicGFyYW1zIjtOO3M6NjoiZ3JvdXBzIjthOjA6e31zOjU6Imd1ZXN0IjtpOjE7czoxMzoibGFzdFJlc2V0VGltZSI7TjtzOjEwOiJyZXNldENvdW50IjtOO3M6MTA6IgAqAF9wYXJhbXMiO086OToiSlJlZ2lzdHJ5IjoxOntzOjc6IgAqAGRhdGEiO086ODoic3RkQ2xhc3MiOjA6e319czoxNDoiACoAX2F1dGhHcm91cHMiO047czoxNDoiACoAX2F1dGhMZXZlbHMiO2E6Mjp7aTowO2k6MTtpOjE7aToxO31zOjE1OiIAKgBfYXV0aEFjdGlvbnMiO047czoxMjoiACoAX2Vycm9yTXNnIjtOO3M6MTA6IgAqAF9lcnJvcnMiO2E6MDp7fXM6MzoiYWlkIjtpOjA7fXM6MTk6ImpzX2lkX2N1cnJlbmN5X29yaWciO3M6MToiMiI7czoxNDoianNfaWRfY3VycmVuY3kiO3M6MToiMiI7czoxOToianNfaGlzdG9yeV9zZWxfbGFuZyI7czo1OiJydS1SVSI7czoxNToianNfcHJldl91c2VyX2lkIjtpOjA7czoyMjoianNob3BfY2hlY2tlZF9sYW5ndWFnZSI7YToyOntpOjA7czo1OiJlbi1HQiI7aToxO3M6NToicnUtUlUiO31zOjI2OiJqc2hvcF9lbmRfcGFnZV9idXlfcHJvZHVjdCI7czoxNDU6Ii9hdnRvLW9ib3J1ZG92YW5pZS9iYWdham5pa2kva3JlcGxlbml5YS1kbHlhLWx5ai9rcmVwbGVuaWUtbWVuYWJvLXdoaXRlLWJlYXItNi1kbHlhLXNoZXN0aS1wYXItbHlqLWlsaS1kdnVoLXNub3Vib3Jkb3YtYWx5dW1pbmlldm9lLXMtemFta29tLmh0bWwiO3M6MTg6InByb2R1Y3RfYmFja192YWx1ZSI7YTowOnt9fX19\";' , `time` = '1471231822'
  WHERE `session_id` = 'db393d9e52e16905f54a28d6d33d3623'

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

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

1. 8 × SELECT *
  FROM jdb_jshopping_products
2. 3 × SELECT *
  FROM jdb_jshopping_categories
3. 2 × SELECT *
  FROM jdb_avtohol_newhar_href
4. 2 × SELECT *
  FROM jdb_jshopping_addons
5. 2 × select `id`
  from jdb_jshopping_addons
6. 1 × SELECT video_name, video_id, video_preview, video_code
  FROM `jdb_jshopping_products_videos`
7. 1 × SELECT *
  FROM `jdb_jshopping_products_files`
8. 1 × SELECT *
  FROM jdb_jshopping_product_labels
9. 1 × SELECT I.*, IF(P.product_name_image=I.image_name,0,1) as sort
  FROM `jdb_jshopping_products_images` as I
  left join `jdb_jshopping_products` as P
  on P.product_id=I.product_id
10. 1 × select min(category_id) as category_id, product_id
  from jdb_jshopping_products_to_categories
  group by product_i
11. 1 × SELECT FA.id, FA.required, FA.`name_ru-RU` as name, FA.`description_ru-RU` as description, FA.type
  FROM `jdb_jshopping_products_free_attr` as PFA
  left join `jdb_jshopping_free_attr` as FA
  on FA.id=PFA.attr_id
12. 1 × SELECT id, image, `name_ru-RU` as name
  FROM `jdb_jshopping_product_labels`
13. 1 × SELECT pr_cat.category_id
  FROM `jdb_jshopping_products_to_categories` AS pr_cat
  LEFT JOIN `jdb_jshopping_categories` AS cat
  ON pr_cat.category_id = cat.category_id
14. 1 × SELECT *
  FROM `jdb_jshopping_products_reviews`
15. 1 × SELECT *
  FROM jdb_jshopping_vendors
16. 1 × SELECT har
  FROM jdb_avtohol_newhar_href
17. 1 × SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` as short_description, prod.product_ean, prod.product_thumb_image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.`extra_field_109` , prod.`extra_field_1` , prod.`extra_field_4` , prod.`extra_field_5` , prod.`extra_field_73` , prod.`extra_field_147` , prod.`extra_field_148` , prod.`extra_field_149` , prod.`extra_field_151` , prod.`extra_field_150` , prod.`extra_field_152` , prod.`extra_field_153` , prod.`extra_field_154` , prod.`extra_field_155` , prod.`extra_field_156` , prod.`extra_field_110` , prod.`extra_field_78` , prod.`extra_field_76` , prod.`extra_field_77` , prod.`extra_field_85` , prod.`extra_field_79` , prod.`extra_field_81` , prod.`extra_field_82` , prod.`extra_field_80` , prod.`extra_field_83` , prod.`extra_field_125` , prod.`extra_field_84` , prod.`extra_field_112` , prod.`extra_field_113` , prod.`extra_field_114` , prod.`extra_field_117` , prod.`extra_field_115` , prod.`extra_field_116` , prod.`extra_field_124` , prod.`extra_field_118` , prod.`extra_field_119` , prod.`extra_field_122` , prod.`extra_field_121` , prod.`extra_field_120` , prod.`extra_field_123` , prod.`extra_field_144` , prod.`extra_field_145` , prod.`extra_field_146` , prod.`extra_field_87` , prod.`extra_field_126` , prod.`extra_field_127` , prod.`extra_field_128` , prod.`extra_field_129` , prod.`extra_field_130` , prod.`extra_field_135` , prod.`extra_field_136` , prod.`extra_field_131` , prod.`extra_field_132` , prod.`extra_field_133` , prod.`extra_field_134` , prod.`extra_field_97` , prod.`extra_field_98` , prod.`extra_field_96` , prod.`extra_field_138` , prod.`extra_field_139` , prod.`extra_field_140` , prod.`extra_field_141` , prod.`extra_field_157` , IF(prod.product_quantity>0,1,0) as qflag, prod.product_bonus
  FROM `jdb_jshopping_products` AS prod
  LEFT JOIN `jdb_jshopping_products_to_categories` AS pr_cat USING (product_id)
  LEFT JOIN `jdb_jshopping_currencies` AS cr USING (currency_id)
18. 1 × SELECT id
  FROM jdb_jshopping_vendors
19. 1 × SELECT id, `name_ru-RU` as name, field_id
  FROM `jdb_jshopping_products_extra_field_values`
20. 1 × SELECT m.menutype
  FROM jdb_menu AS m
21. 1 × SELECT m.published, m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.params as advancedparams, 0 as menuid, m.publish_up, m.publish_down
  FROM jdb_modules AS m
  LEFT JOIN jdb_extensions AS e
  ON e.element = m.module
  AND e.client_id = m.client_id
  LEFT JOIN jdb_advancedmodules as am
  ON am.moduleid = m.id
22. 1 × SELECT count(review_id)
  FROM `jdb_jshopping_products_reviews`
23. 1 × select id,link
  from jdb_menu
24. 1 × SELECT *
  FROM jdb_jshopping_config
25. 1 × SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value
  FROM `jdb_jshopping_currencies`
26. 1 × select product_id as id, `alias_ru-RU` as alias
  from jdb_jshopping_products
27. 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 jdb_menu AS m
  LEFT JOIN jdb_extensions AS e
  ON m.component_id = e.extension_id
28. 1 × SELECT nh.*, (SELECT n.`cookie`
  FROM jdb_avtohol_newhar n
29. 1 × SELECT `session_id`
  FROM `jdb_session`
30. 1 × SELECT b.id
  FROM jdb_usergroups AS a
  LEFT JOIN jdb_usergroups AS b
  ON b.lft = a.lft
  AND b.rgt >= a.rgt
31. 1 × SELECT id, rules
  FROM `jdb_viewlevels
32. 1 × select *
  from jdb_jshopping_language
33. 1 × SELECT *
  FROM `jdb_jshopping_products_to_categories`
34. 1 × SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` as short_description, prod.product_ean, prod.product_thumb_image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.`extra_field_109` , prod.`extra_field_1` , prod.`extra_field_4` , prod.`extra_field_5` , prod.`extra_field_73` , prod.`extra_field_147` , prod.`extra_field_148` , prod.`extra_field_149` , prod.`extra_field_151` , prod.`extra_field_150` , prod.`extra_field_152` , prod.`extra_field_153` , prod.`extra_field_154` , prod.`extra_field_155` , prod.`extra_field_156` , prod.`extra_field_110` , prod.`extra_field_78` , prod.`extra_field_76` , prod.`extra_field_77` , prod.`extra_field_85` , prod.`extra_field_79` , prod.`extra_field_81` , prod.`extra_field_82` , prod.`extra_field_80` , prod.`extra_field_83` , prod.`extra_field_125` , prod.`extra_field_84` , prod.`extra_field_112` , prod.`extra_field_113` , prod.`extra_field_114` , prod.`extra_field_117` , prod.`extra_field_115` , prod.`extra_field_116` , prod.`extra_field_124` , prod.`extra_field_118` , prod.`extra_field_119` , prod.`extra_field_122` , prod.`extra_field_121` , prod.`extra_field_120` , prod.`extra_field_123` , prod.`extra_field_144` , prod.`extra_field_145` , prod.`extra_field_146` , prod.`extra_field_87` , prod.`extra_field_126` , prod.`extra_field_127` , prod.`extra_field_128` , prod.`extra_field_129` , prod.`extra_field_130` , prod.`extra_field_135` , prod.`extra_field_136` , prod.`extra_field_131` , prod.`extra_field_132` , prod.`extra_field_133` , prod.`extra_field_134` , prod.`extra_field_97` , prod.`extra_field_98` , prod.`extra_field_96` , prod.`extra_field_138` , prod.`extra_field_139` , prod.`extra_field_140` , prod.`extra_field_141` , prod.`extra_field_157` , prod.product_bonus
  FROM `jdb_jshopping_products_relations` AS relation
  INNER JOIN `jdb_jshopping_products` AS prod
  ON relation.product_related_id = prod.product_id
  LEFT JOIN `jdb_jshopping_products_to_categories` AS pr_cat
  ON pr_cat.product_id = relation.product_related_id
  LEFT JOIN `jdb_jshopping_categories` AS cat
  ON pr_cat.category_id = cat.category_id
35. 1 × SELECT `data`
  FROM `jdb_session`
36. 1 × select category_id as id, `alias_ru-RU` as alias
  from jdb_jshopping_categories
37. 1 × SELECT tax_id, tax_name, tax_value
  FROM `jdb_jshopping_taxes
38. 1 × SELECT F.id, F.`name_ru-RU` as name, F.`description_ru-RU` as description, F.allcats, F.type, F.cats, F.ordering, F.`
  group`, G.`name_ru-RU` as groupname, multilist
  FROM `jdb_jshopping_products_extra_fields` as F
  left join `jdb_jshopping_products_extra_field_groups` as G
  on G.id=F.
  group
39. 1 × SELECT attr_id, `name_ru-RU` as name, `description_ru-RU` as description, attr_type, independent, allcats, cats, attr_ordering
  FROM `jdb_jshopping_attr`
40. 1 × SELECT *
  FROM `jdb_jshopping_products_attr`
41. 1 × SELECT *
  FROM `jdb_jshopping_products_attr2`
42. 1 × select manufacturer_id as id, `name_ru-RU` as name, manufacturer_logo, manufacturer_url
  from jdb_jshopping_manufacturers

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

1. 2 × UPDATE `jdb_jshopping_products`
  SET `product_price`=`product_old_price`, `product_old_price`='0.00', `price_date_end`='0000-00-00 00:00:00'
2. 1 × SHOW FULL COLUMNS
  FROM `jdb_jshopping_product_labels
3. 1 × SHOW FULL COLUMNS
  FROM `jdb_jshopping_products_reviews
4. 1 × UPDATE jdb_jshopping_products
  SET `hits` = (`hits` + 1)
5. 1 × SHOW FULL COLUMNS
  FROM `jdb_jshopping_addons
6. 1 × SHOW FULL COLUMNS
  FROM `jdb_jshopping_usergroups
7. 1 × UPDATE `jdb_session`
  SET `data` = 'joomla|s:3216:\"Tzo5OiJKUmVnaXN0cnkiOjE6e3M6NzoiACoAZGF0YSI7Tzo4OiJzdGRDbGFzcyI6MTp7czo5OiJfX2RlZmF1bHQiO086ODoic3RkQ2xhc3MiOjEwOntzOjc6InNlc3Npb24iO086ODoic3RkQ2xhc3MiOjM6e3M6NzoiY291bnRlciI7aToxO3M6NToidGltZXIiO086ODoic3RkQ2xhc3MiOjM6e3M6NToic3RhcnQiO2k6MTQ3MTIzMTgyMDtzOjQ6Imxhc3QiO2k6MTQ3MTIzMTgyMDtzOjM6Im5vdyI7aToxNDcxMjMxODIwO31zOjU6InRva2VuIjtzOjMyOiIzMmQwZDE5MDNjOWUyOTQ3OWRmMjMzNWNmMTYzMDFhNiI7fXM6ODoicmVnaXN0cnkiO086OToiSlJlZ2lzdHJ5IjoxOntzOjc6IgAqAGRhdGEiO086ODoic3RkQ2xhc3MiOjE6e3M6ODoianNob3BpbmciO086ODoic3RkQ2xhc3MiOjE6e3M6NDoibGlzdCI7Tzo4OiJzdGRDbGFzcyI6MTp7czo1OiJmcm9udCI7Tzo4OiJzdGRDbGFzcyI6MTp7czo3OiJwcm9kdWN0IjtPOjg6InN0ZENsYXNzIjoxOntzOjM6ImNhdCI7Tzo4OiJzdGRDbGFzcyI6MTp7czoxNDoiNjJleHRyYV9maWVsZHMiO2E6Nzg6e2k6ODthOjA6e31pOjk7YTowOnt9aToxMDthOjA6e31pOjExO2E6MDp7fWk6MTI7YTowOnt9aToxMzthOjA6e31pOjE0O2E6MDp7fWk6MTU7YTowOnt9aToxNjthOjA6e31pOjE3O2E6MDp7fWk6MTg7YTowOnt9aToxOTthOjA6e31pOjIwO2E6MDp7fWk6MjE7YTowOnt9aToyMjthOjA6e31pOjIzO2E6MDp7fWk6MjQ7YTowOnt9aToyNTthOjA6e31pOjI2O2E6MDp7fWk6Mjc7YTowOnt9aToyODthOjA6e31pOjI5O2E6MDp7fWk6MzA7YTowOnt9aTozMTthOjA6e31pOjMyO2E6MDp7fWk6MzM7YTowOnt9aTozNDthOjA6e31pOjM1O2E6MDp7fWk6MzY7YTowOnt9aTozNzthOjA6e31pOjM4O2E6MDp7fWk6Mzk7YTowOnt9aTo0MDthOjA6e31pOjQxO2E6MDp7fWk6NDI7YTowOnt9aTo0MzthOjA6e31pOjQ0O2E6MDp7fWk6NDU7YTowOnt9aTo0NjthOjA6e31pOjQ3O2E6MDp7fWk6NDg7YTowOnt9aTo0OTthOjA6e31pOjUwO2E6MDp7fWk6NTE7YTowOnt9aTo1MjthOjA6e31pOjUzO2E6MDp7fWk6NTQ7YTowOnt9aTo1NTthOjA6e31pOjU2O2E6MDp7fWk6NTc7YTowOnt9aTo1ODthOjA6e31pOjU5O2E6MDp7fWk6NjA7YTowOnt9aTo2MTthOjA6e31pOjYyO2E6MDp7fWk6NjM7YTowOnt9aTo2ODthOjA6e31pOjcyO2E6MDp7fWk6Njk7YTowOnt9aTo2NzthOjA6e31pOjY2O2E6MDp7fWk6NzA7YTowOnt9aTo3MTthOjA6e31pOjg5O2E6MDp7fWk6OTA7YTowOnt9aTo5MTthOjA6e31pOjkyO2E6MDp7fWk6OTM7YTowOnt9aTo5NDthOjA6e31pOjk5O2E6MDp7fWk6MTAwO2E6MDp7fWk6MTAxO2E6MDp7fWk6MTA2O2E6MDp7fWk6MTA3O2E6MDp7fWk6MTA4O2E6MDp7fWk6MTExO2E6MDp7fWk6MzthOjA6e31pOjEzNzthOjA6e319fX19fX19fXM6NDoidXNlciI7Tzo1OiJKVXNlciI6MjU6e3M6OToiACoAaXNSb290IjtOO3M6MjoiaWQiO2k6MDtzOjQ6Im5hbWUiO047czo4OiJ1c2VybmFtZSI7TjtzOjU6ImVtYWlsIjtOO3M6ODoicGFzc3dvcmQiO047czoxNDoicGFzc3dvcmRfY2xlYXIiO3M6MDoiIjtzOjg6InVzZXJ0eXBlIjtOO3M6NToiYmxvY2siO047czo5OiJzZW5kRW1haWwiO2k6MDtzOjEyOiJyZWdpc3RlckRhdGUiO047czoxMzoibGFzdHZpc2l0RGF0ZSI7TjtzOjEwOiJhY3RpdmF0aW9uIjtOO3M6NjoicGFyYW1zIjtOO3M6NjoiZ3JvdXBzIjthOjA6e31zOjU6Imd1ZXN0IjtpOjE7czoxMzoibGFzdFJlc2V0VGltZSI7TjtzOjEwOiJyZXNldENvdW50IjtOO3M6MTA6IgAqAF9wYXJhbXMiO086OToiSlJlZ2lzdHJ5IjoxOntzOjc6IgAqAGRhdGEiO086ODoic3RkQ2xhc3MiOjA6e319czoxNDoiACoAX2F1dGhHcm91cHMiO047czoxNDoiACoAX2F1dGhMZXZlbHMiO2E6Mjp7aTowO2k6MTtpOjE7aToxO31zOjE1OiIAKgBfYXV0aEFjdGlvbnMiO047czoxMjoiACoAX2Vycm9yTXNnIjtOO3M6MTA6IgAqAF9lcnJvcnMiO2E6MDp7fXM6MzoiYWlkIjtpOjA7fXM6MTk6ImpzX2lkX2N1cnJlbmN5X29yaWciO3M6MToiMiI7czoxNDoianNfaWRfY3VycmVuY3kiO3M6MToiMiI7czoxOToianNfaGlzdG9yeV9zZWxfbGFuZyI7czo1OiJydS1SVSI7czoxNToianNfcHJldl91c2VyX2lkIjtpOjA7czoyMjoianNob3BfY2hlY2tlZF9sYW5ndWFnZSI7YToyOntpOjA7czo1OiJlbi1HQiI7aToxO3M6NToicnUtUlUiO31zOjI2OiJqc2hvcF9lbmRfcGFnZV9idXlfcHJvZHVjdCI7czoxNDU6Ii9hdnRvLW9ib3J1ZG92YW5pZS9iYWdham5pa2kva3JlcGxlbml5YS1kbHlhLWx5ai9rcmVwbGVuaWUtbWVuYWJvLXdoaXRlLWJlYXItNi1kbHlhLXNoZXN0aS1wYXItbHlqLWlsaS1kdnVoLXNub3Vib3Jkb3YtYWx5dW1pbmlldm9lLXMtemFta29tLmh0bWwiO3M6MTg6InByb2R1Y3RfYmFja192YWx1ZSI7YTowOnt9fX19\";' , `time` = '1471231822'
8. 1 × SHOW FULL COLUMNS
  FROM `jdb_jshopping_vendors
9. 1 × SHOW FULL COLUMNS
  FROM `jdb_jshopping_categories
10. 1 × SHOW FULL COLUMNS
  FROM `jdb_jshopping_taxes
11. 1 × SHOW FULL COLUMNS
  FROM `jdb_jshopping_products
12. 1 × SHOW FULL COLUMNS
  FROM `jdb_jshopping_currencies
13. 1 × SHOW FULL COLUMNS
  FROM `jdb_jshopping_config
14. 1 × SHOW FULL COLUMNS
  FROM `jdb_jshopping_attr
15. 1 × SHOW FULL COLUMNS
  FROM `jdb_jshopping_users
16. 1 × INSERT INTO `jdb_session` (`session_id`, `client_id`, `time`)
  VALUES ('db393d9e52e16905f54a28d6d33d3623', 0, '1471231820'
17. 1 × SHOW FULL COLUMNS
  FROM `jdb_jshopping_products_extra_fields
18. 1 × SHOW FULL COLUMNS
  FROM `jdb_jshopping_products_extra_field_values