Консоль отладки Joomla!
⇒{"__default":{"session":{"counter":1,"timer":{"start":1471093030,"last":1471093030,"now":1471093030},"token":"39195dde37c055b193f2a8eceaa90071"},"registry":{},"user":{"id":0,"name":null,"username":null,"email":null,"password":null,"password_clear":"","usertype":null,"block":null,"sendEmail":0,"registerDate":null,"lastvisitDate":null,"activation":null,"params":null,"groups":[],"guest":1,"lastResetTime":null,"resetCount":null,"aid":0},"js_id_currency_orig":"2","js_id_currency":"2","js_history_sel_lang":"ru-RU","js_prev_user_id":0,"jshop_checked_language":["en-GB","ru-RU"],"jshop_end_page_buy_product":"\/avto-oborudovanie\/bagajniki\/korziny-dlya-bagajnikov\/korzina-atlant-1200x700.html","product_back_value":[]}}
Application 0.000 seconds (+0.000); 0.73 MB (+0.733) - afterLoad
Application 0.052 seconds (+0.052); 2.20 MB (+1.469) - afterInitialise
Application 0.262 seconds (+0.210); 13.89 MB (+11.687) - afterRoute
Application 0.856 seconds (+0.594); 22.22 MB (+8.333) - beforeRenderModule mod_yashare (Ya.Share jshop)
Application 0.857 seconds (+0.002); 22.24 MB (+0.013) - afterRenderModule mod_yashare (Ya.Share jshop)
Application 0.861 seconds (+0.004); 22.16 MB (-0.073) - afterDispatch
Application 0.864 seconds (+0.003); 22.24 MB (+0.078) - beforeRenderModule mod_custom (Yandex informer counter Метрика)
Application 0.866 seconds (+0.003); 22.25 MB (+0.007) - afterRenderModule mod_custom (Yandex informer counter Метрика)
Application 0.869 seconds (+0.002); 22.30 MB (+0.052) - beforeRenderModule mod_menu (меню Footer 2)
Application 0.885 seconds (+0.016); 22.37 MB (+0.068) - afterRenderModule mod_menu (меню Footer 2)
Application 0.887 seconds (+0.002); 22.36 MB (-0.005) - beforeRenderModule mod_menu (Главное меню Footer)
Application 0.903 seconds (+0.015); 22.39 MB (+0.027) - afterRenderModule mod_menu (Главное меню Footer)
Application 0.905 seconds (+0.002); 22.38 MB (-0.006) - beforeRenderModule mod_menu (Внутреннее меню багажников)
Application 0.915 seconds (+0.011); 22.40 MB (+0.021) - afterRenderModule mod_menu (Внутреннее меню багажников)
Application 0.916 seconds (+0.001); 22.35 MB (-0.053) - beforeRenderModule mod_breadcrumbs (Хлебные крошки)
Application 0.921 seconds (+0.005); 22.37 MB (+0.019) - afterRenderModule mod_breadcrumbs (Хлебные крошки)
Application 0.922 seconds (+0.001); 22.36 MB (-0.005) - beforeRenderModule mod_jshopping_products_compare (JoomShopping Products Compare)
Application 0.926 seconds (+0.004); 22.42 MB (+0.052) - beforeRenderModule mod_menu (Автооборудование каталог)
Application 1.094 seconds (+0.168); 22.67 MB (+0.252) - afterRenderModule mod_menu (Автооборудование каталог)
Application 1.096 seconds (+0.002); 22.62 MB (-0.053) - beforeRenderModule mod_jshopping_cart_ext (Корзина)
Application 1.101 seconds (+0.005); 22.66 MB (+0.043) - afterRenderModule mod_jshopping_cart_ext (Корзина)
Application 1.103 seconds (+0.002); 22.66 MB (-0.000) - beforeRenderModule mod_slogin (SLogin)
Application 1.121 seconds (+0.019); 22.85 MB (+0.190) - afterRenderModule mod_slogin (SLogin)
Application 1.123 seconds (+0.001); 22.88 MB (+0.032) - beforeRenderModule mod_menu (Главное меню)
Application 1.136 seconds (+0.013); 22.89 MB (+0.009) - afterRenderModule mod_menu (Главное меню)
Application 1.290 seconds (+0.154); 23.18 MB (+0.293) - afterRender
23.22 MB (24,349,160 Bytes)
72 SQL-запросов зафиксировано
SELECT `data`
FROM `jdb_session`
WHERE `session_id` = 'e36222b391b157496cdcc19aa0ea32ee'SELECT `session_id`
FROM `jdb_session`
WHERE `session_id` = 'e36222b391b157496cdcc19aa0ea32ee'
LIMIT 0, 1INSERT INTO `jdb_session`
(`session_id`, `client_id`, `time`)
VALUES
('e36222b391b157496cdcc19aa0ea32ee', 0, '1471093030')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 = 1SELECT id, rules
FROM `jdb_viewlevels`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')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)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.lftSHOW FULL COLUMNS
FROM `jdb_jshopping_config`SELECT *
FROM jdb_jshopping_config
WHERE `id` = '1'SHOW FULL COLUMNS
FROM `jdb_jshopping_currencies`SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value
FROM `jdb_jshopping_currencies`
WHERE currency_publish = '1'
ORDER BY currency_orderingselect product_id as id, `alias_ru-RU` as alias
from jdb_jshopping_products
where `alias_ru-RU`!=''SELECT *
FROM jdb_jshopping_categories
WHERE category_id =111SELECT *
FROM jdb_avtohol_newhar_href
WHERE hartype='several_selectbox'select *
from jdb_jshopping_languagesUPDATE `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-13 15:57:10'
AND price_date_end '0000-00-00 00:00:00' )SHOW FULL COLUMNS
FROM `jdb_jshopping_products`SELECT *
FROM jdb_jshopping_products
WHERE `product_id` = '936'SELECT *
FROM `jdb_jshopping_products_to_categories`
WHERE product_id='936'SHOW FULL COLUMNS
FROM `jdb_jshopping_attr`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_orderingSELECT *
FROM `jdb_jshopping_products_attr`
WHERE product_id = '936'
ORDER BY product_attr_idSELECT *
FROM `jdb_jshopping_products_attr2`
WHERE product_id = '936'
ORDER BY idSHOW FULL COLUMNS
FROM `jdb_jshopping_users`SHOW FULL COLUMNS
FROM `jdb_jshopping_products_extra_fields`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.orderingSHOW FULL COLUMNS
FROM `jdb_jshopping_taxes`SELECT tax_id, tax_name, tax_value
FROM `jdb_jshopping_taxes`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 = '936'
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.idselect 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)select category_id as id, `alias_ru-RU` as alias
from jdb_jshopping_categories
where `alias_ru-RU`!=''select manufacturer_id as id, `name_ru-RU` as name, manufacturer_logo, manufacturer_url
from jdb_jshopping_manufacturers
where manufacturer_publish='1'SHOW FULL COLUMNS
FROM `jdb_jshopping_products_extra_field_values`SELECT id, `name_ru-RU` as name, field_id
FROM `jdb_jshopping_products_extra_field_values`
order by orderingselect min(category_id) as category_id, product_id
from jdb_jshopping_products_to_categories
group by product_idSHOW FULL COLUMNS
FROM `jdb_jshopping_categories`SELECT *
FROM jdb_jshopping_categories
WHERE `category_id` = '111'UPDATE jdb_jshopping_products
SET `hits` = (`hits` + 1)
WHERE product_id = '936'SHOW FULL COLUMNS
FROM `jdb_jshopping_products_reviews`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 = '936'
order by FA.orderingSELECT 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 = '936'
ORDER BY sort, I.orderingSELECT video_name, video_id, video_preview, video_code
FROM `jdb_jshopping_products_videos`
WHERE product_id = '936'SELECT *
FROM `jdb_jshopping_products_files`
WHERE product_id = '936'
and demo!=''
order by `ordering`SHOW FULL COLUMNS
FROM `jdb_jshopping_product_labels`SELECT *
FROM jdb_jshopping_product_labels
WHERE `id` = '1'SELECT *
FROM jdb_jshopping_products
WHERE `product_id` = '9641'SELECT *
FROM jdb_jshopping_products
WHERE `product_id` = '448'SELECT *
FROM jdb_jshopping_products
WHERE `product_id` = '940'SELECT *
FROM jdb_jshopping_products
WHERE `product_id` = '946'SELECT *
FROM jdb_jshopping_products
WHERE `product_id` = '953'SELECT *
FROM jdb_jshopping_products
WHERE `product_id` = '4252'SELECT *
FROM jdb_jshopping_products
WHERE `product_id` = '935'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 = '936'
AND cat.category_publish='1'
AND cat.access IN (1,1)
LIMIT 0,1SELECT count(review_id)
FROM `jdb_jshopping_products_reviews`
WHERE product_id = '936'
and publish='1'SELECT *
FROM `jdb_jshopping_products_reviews`
WHERE product_id = '936'
and publish='1'
order by review_id desc
LIMIT 0, 20SHOW FULL COLUMNS
FROM `jdb_jshopping_addons`select `id`
from jdb_jshopping_addons
where `alias`='addon_bonus_system'SELECT *
FROM jdb_jshopping_addons
WHERE `id` = '6'SHOW FULL COLUMNS
FROM `jdb_jshopping_usergroups`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-13 15:57:11'
AND price_date_end '0000-00-00 00:00:00' )SELECT *
FROM jdb_jshopping_categories
WHERE `category_id` = '111'SHOW FULL COLUMNS
FROM `jdb_jshopping_vendors`SELECT id
FROM jdb_jshopping_vendors
WHERE `main`=1SELECT *
FROM jdb_jshopping_vendors
WHERE `id` = '1'SELECT har
FROM jdb_avtohol_newhar_href
WHERE hartype='several_selectbox'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 = '111'
AND prod.product_publish = '1'
AND prod.access IN (1,1)
ORDER BY qflag DESC, prod.product_price/cr.currency_value ASCselect `id`
from jdb_jshopping_addons
where `alias`='products_compare'SELECT *
FROM jdb_jshopping_addons
WHERE `id` = '12'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.idSELECT m.menutype
FROM jdb_menu AS m
WHERE m.id = 607UPDATE `jdb_session`
SET `data` = 'joomla|s:3132:\"Tzo5OiJKUmVnaXN0cnkiOjE6e3M6NzoiACoAZGF0YSI7Tzo4OiJzdGRDbGFzcyI6MTp7czo5OiJfX2RlZmF1bHQiO086ODoic3RkQ2xhc3MiOjEwOntzOjc6InNlc3Npb24iO086ODoic3RkQ2xhc3MiOjM6e3M6NzoiY291bnRlciI7aToxO3M6NToidGltZXIiO086ODoic3RkQ2xhc3MiOjM6e3M6NToic3RhcnQiO2k6MTQ3MTA5MzAzMDtzOjQ6Imxhc3QiO2k6MTQ3MTA5MzAzMDtzOjM6Im5vdyI7aToxNDcxMDkzMDMwO31zOjU6InRva2VuIjtzOjMyOiIzOTE5NWRkZTM3YzA1NWIxOTNmMmE4ZWNlYWE5MDA3MSI7fXM6ODoicmVnaXN0cnkiO086OToiSlJlZ2lzdHJ5IjoxOntzOjc6IgAqAGRhdGEiO086ODoic3RkQ2xhc3MiOjE6e3M6ODoianNob3BpbmciO086ODoic3RkQ2xhc3MiOjE6e3M6NDoibGlzdCI7Tzo4OiJzdGRDbGFzcyI6MTp7czo1OiJmcm9udCI7Tzo4OiJzdGRDbGFzcyI6MTp7czo3OiJwcm9kdWN0IjtPOjg6InN0ZENsYXNzIjoxOntzOjM6ImNhdCI7Tzo4OiJzdGRDbGFzcyI6MTp7czoxNToiMTExZXh0cmFfZmllbGRzIjthOjc4OntpOjg7YTowOnt9aTo5O2E6MDp7fWk6MTA7YTowOnt9aToxMTthOjA6e31pOjEyO2E6MDp7fWk6MTM7YTowOnt9aToxNDthOjA6e31pOjE1O2E6MDp7fWk6MTY7YTowOnt9aToxNzthOjA6e31pOjE4O2E6MDp7fWk6MTk7YTowOnt9aToyMDthOjA6e31pOjIxO2E6MDp7fWk6MjI7YTowOnt9aToyMzthOjA6e31pOjI0O2E6MDp7fWk6MjU7YTowOnt9aToyNjthOjA6e31pOjI3O2E6MDp7fWk6Mjg7YTowOnt9aToyOTthOjA6e31pOjMwO2E6MDp7fWk6MzE7YTowOnt9aTozMjthOjA6e31pOjMzO2E6MDp7fWk6MzQ7YTowOnt9aTozNTthOjA6e31pOjM2O2E6MDp7fWk6Mzc7YTowOnt9aTozODthOjA6e31pOjM5O2E6MDp7fWk6NDA7YTowOnt9aTo0MTthOjA6e31pOjQyO2E6MDp7fWk6NDM7YTowOnt9aTo0NDthOjA6e31pOjQ1O2E6MDp7fWk6NDY7YTowOnt9aTo0NzthOjA6e31pOjQ4O2E6MDp7fWk6NDk7YTowOnt9aTo1MDthOjA6e31pOjUxO2E6MDp7fWk6NTI7YTowOnt9aTo1MzthOjA6e31pOjU0O2E6MDp7fWk6NTU7YTowOnt9aTo1NjthOjA6e31pOjU3O2E6MDp7fWk6NTg7YTowOnt9aTo1OTthOjA6e31pOjYwO2E6MDp7fWk6NjE7YTowOnt9aTo2MjthOjA6e31pOjYzO2E6MDp7fWk6Njg7YTowOnt9aTo3MjthOjA6e31pOjY5O2E6MDp7fWk6Njc7YTowOnt9aTo2NjthOjA6e31pOjcwO2E6MDp7fWk6NzE7YTowOnt9aTo4OTthOjA6e31pOjkwO2E6MDp7fWk6OTE7YTowOnt9aTo5MjthOjA6e31pOjkzO2E6MDp7fWk6OTQ7YTowOnt9aTo5OTthOjA6e31pOjEwMDthOjA6e31pOjEwMTthOjA6e31pOjEwNjthOjA6e31pOjEwNzthOjA6e31pOjEwODthOjA6e31pOjExMTthOjA6e31pOjM7YTowOnt9aToxMzc7YTowOnt9fX19fX19fX1zOjQ6InVzZXIiO086NToiSlVzZXIiOjI1OntzOjk6IgAqAGlzUm9vdCI7TjtzOjI6ImlkIjtpOjA7czo0OiJuYW1lIjtOO3M6ODoidXNlcm5hbWUiO047czo1OiJlbWFpbCI7TjtzOjg6InBhc3N3b3JkIjtOO3M6MTQ6InBhc3N3b3JkX2NsZWFyIjtzOjA6IiI7czo4OiJ1c2VydHlwZSI7TjtzOjU6ImJsb2NrIjtOO3M6OToic2VuZEVtYWlsIjtpOjA7czoxMjoicmVnaXN0ZXJEYXRlIjtOO3M6MTM6Imxhc3R2aXNpdERhdGUiO047czoxMDoiYWN0aXZhdGlvbiI7TjtzOjY6InBhcmFtcyI7TjtzOjY6Imdyb3VwcyI7YTowOnt9czo1OiJndWVzdCI7aToxO3M6MTM6Imxhc3RSZXNldFRpbWUiO047czoxMDoicmVzZXRDb3VudCI7TjtzOjEwOiIAKgBfcGFyYW1zIjtPOjk6IkpSZWdpc3RyeSI6MTp7czo3OiIAKgBkYXRhIjtPOjg6InN0ZENsYXNzIjowOnt9fXM6MTQ6IgAqAF9hdXRoR3JvdXBzIjtOO3M6MTQ6IgAqAF9hdXRoTGV2ZWxzIjthOjI6e2k6MDtpOjE7aToxO2k6MTt9czoxNToiACoAX2F1dGhBY3Rpb25zIjtOO3M6MTI6IgAqAF9lcnJvck1zZyI7TjtzOjEwOiIAKgBfZXJyb3JzIjthOjA6e31zOjM6ImFpZCI7aTowO31zOjE5OiJqc19pZF9jdXJyZW5jeV9vcmlnIjtzOjE6IjIiO3M6MTQ6ImpzX2lkX2N1cnJlbmN5IjtzOjE6IjIiO3M6MTk6ImpzX2hpc3Rvcnlfc2VsX2xhbmciO3M6NToicnUtUlUiO3M6MTU6ImpzX3ByZXZfdXNlcl9pZCI7aTowO3M6MjI6ImpzaG9wX2NoZWNrZWRfbGFuZ3VhZ2UiO2E6Mjp7aTowO3M6NToiZW4tR0IiO2k6MTtzOjU6InJ1LVJVIjt9czoyNjoianNob3BfZW5kX3BhZ2VfYnV5X3Byb2R1Y3QiO3M6ODE6Ii9hdnRvLW9ib3J1ZG92YW5pZS9iYWdham5pa2kva29yemlueS1kbHlhLWJhZ2Fqbmlrb3Yva29yemluYS1hdGxhbnQtMTIwMHg3MDAuaHRtbCI7czoxODoicHJvZHVjdF9iYWNrX3ZhbHVlIjthOjA6e319fX0=\";'
, `time` = '1471093031'
WHERE `session_id` = 'e36222b391b157496cdcc19aa0ea32ee'
59 типов SQL-запросов зафиксировано, отсортировано по вхождениям
Запросы типа SELECT:
8 × SELECT *
FROM jdb_jshopping_products3 × SELECT *
FROM jdb_jshopping_categories2 × SELECT *
FROM jdb_avtohol_newhar_href2 × SELECT *
FROM jdb_jshopping_addons2 × select `id`
from jdb_jshopping_addons1 × SELECT video_name, video_id, video_preview, video_code
FROM `jdb_jshopping_products_videos`1 × SELECT *
FROM `jdb_jshopping_products_files`1 × SELECT *
FROM jdb_jshopping_product_labels1 × 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_id1 × SELECT id, `name_ru-RU` as name, field_id
FROM `jdb_jshopping_products_extra_field_values`1 × select min(category_id) as category_id, product_id
from jdb_jshopping_products_to_categories
group by product_i1 × 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_id1 × 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_id1 × SELECT *
FROM `jdb_jshopping_products_reviews`1 × SELECT *
FROM jdb_jshopping_vendors1 × SELECT har
FROM jdb_avtohol_newhar_href1 × 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)1 × SELECT id
FROM jdb_jshopping_vendors1 × select manufacturer_id as id, `name_ru-RU` as name, manufacturer_logo, manufacturer_url
from jdb_jshopping_manufacturers1 × SELECT m.menutype
FROM jdb_menu AS m1 × 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.id1 × SELECT count(review_id)
FROM `jdb_jshopping_products_reviews`1 × select id,link
from jdb_menu1 × SELECT *
FROM jdb_jshopping_config1 × SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value
FROM `jdb_jshopping_currencies`1 × select product_id as id, `alias_ru-RU` as alias
from jdb_jshopping_products1 × 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_id1 × SELECT nh.*, (SELECT n.`cookie`
FROM jdb_avtohol_newhar n1 × SELECT `session_id`
FROM `jdb_session`1 × SELECT b.id
FROM jdb_usergroups AS a
LEFT JOIN jdb_usergroups AS b
ON b.lft = a.lft
AND b.rgt >= a.rgt1 × SELECT id, rules
FROM `jdb_viewlevels1 × select *
from jdb_jshopping_language1 × SELECT *
FROM `jdb_jshopping_products_to_categories`1 × SELECT tax_id, tax_name, tax_value
FROM `jdb_jshopping_taxes1 × 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_id1 × SELECT `data`
FROM `jdb_session`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.
group1 × SELECT *
FROM `jdb_jshopping_products_attr2`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`1 × SELECT *
FROM `jdb_jshopping_products_attr`1 × select category_id as id, `alias_ru-RU` as alias
from jdb_jshopping_categories
Прочие SQL-запросы:
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'1 × SHOW FULL COLUMNS
FROM `jdb_jshopping_product_labels1 × SHOW FULL COLUMNS
FROM `jdb_jshopping_products_reviews1 × UPDATE jdb_jshopping_products
SET `hits` = (`hits` + 1)1 × SHOW FULL COLUMNS
FROM `jdb_jshopping_addons1 × SHOW FULL COLUMNS
FROM `jdb_jshopping_usergroups1 × UPDATE `jdb_session`
SET `data` = 'joomla|s:3132:\"Tzo5OiJKUmVnaXN0cnkiOjE6e3M6NzoiACoAZGF0YSI7Tzo4OiJzdGRDbGFzcyI6MTp7czo5OiJfX2RlZmF1bHQiO086ODoic3RkQ2xhc3MiOjEwOntzOjc6InNlc3Npb24iO086ODoic3RkQ2xhc3MiOjM6e3M6NzoiY291bnRlciI7aToxO3M6NToidGltZXIiO086ODoic3RkQ2xhc3MiOjM6e3M6NToic3RhcnQiO2k6MTQ3MTA5MzAzMDtzOjQ6Imxhc3QiO2k6MTQ3MTA5MzAzMDtzOjM6Im5vdyI7aToxNDcxMDkzMDMwO31zOjU6InRva2VuIjtzOjMyOiIzOTE5NWRkZTM3YzA1NWIxOTNmMmE4ZWNlYWE5MDA3MSI7fXM6ODoicmVnaXN0cnkiO086OToiSlJlZ2lzdHJ5IjoxOntzOjc6IgAqAGRhdGEiO086ODoic3RkQ2xhc3MiOjE6e3M6ODoianNob3BpbmciO086ODoic3RkQ2xhc3MiOjE6e3M6NDoibGlzdCI7Tzo4OiJzdGRDbGFzcyI6MTp7czo1OiJmcm9udCI7Tzo4OiJzdGRDbGFzcyI6MTp7czo3OiJwcm9kdWN0IjtPOjg6InN0ZENsYXNzIjoxOntzOjM6ImNhdCI7Tzo4OiJzdGRDbGFzcyI6MTp7czoxNToiMTExZXh0cmFfZmllbGRzIjthOjc4OntpOjg7YTowOnt9aTo5O2E6MDp7fWk6MTA7YTowOnt9aToxMTthOjA6e31pOjEyO2E6MDp7fWk6MTM7YTowOnt9aToxNDthOjA6e31pOjE1O2E6MDp7fWk6MTY7YTowOnt9aToxNzthOjA6e31pOjE4O2E6MDp7fWk6MTk7YTowOnt9aToyMDthOjA6e31pOjIxO2E6MDp7fWk6MjI7YTowOnt9aToyMzthOjA6e31pOjI0O2E6MDp7fWk6MjU7YTowOnt9aToyNjthOjA6e31pOjI3O2E6MDp7fWk6Mjg7YTowOnt9aToyOTthOjA6e31pOjMwO2E6MDp7fWk6MzE7YTowOnt9aTozMjthOjA6e31pOjMzO2E6MDp7fWk6MzQ7YTowOnt9aTozNTthOjA6e31pOjM2O2E6MDp7fWk6Mzc7YTowOnt9aTozODthOjA6e31pOjM5O2E6MDp7fWk6NDA7YTowOnt9aTo0MTthOjA6e31pOjQyO2E6MDp7fWk6NDM7YTowOnt9aTo0NDthOjA6e31pOjQ1O2E6MDp7fWk6NDY7YTowOnt9aTo0NzthOjA6e31pOjQ4O2E6MDp7fWk6NDk7YTowOnt9aTo1MDthOjA6e31pOjUxO2E6MDp7fWk6NTI7YTowOnt9aTo1MzthOjA6e31pOjU0O2E6MDp7fWk6NTU7YTowOnt9aTo1NjthOjA6e31pOjU3O2E6MDp7fWk6NTg7YTowOnt9aTo1OTthOjA6e31pOjYwO2E6MDp7fWk6NjE7YTowOnt9aTo2MjthOjA6e31pOjYzO2E6MDp7fWk6Njg7YTowOnt9aTo3MjthOjA6e31pOjY5O2E6MDp7fWk6Njc7YTowOnt9aTo2NjthOjA6e31pOjcwO2E6MDp7fWk6NzE7YTowOnt9aTo4OTthOjA6e31pOjkwO2E6MDp7fWk6OTE7YTowOnt9aTo5MjthOjA6e31pOjkzO2E6MDp7fWk6OTQ7YTowOnt9aTo5OTthOjA6e31pOjEwMDthOjA6e31pOjEwMTthOjA6e31pOjEwNjthOjA6e31pOjEwNzthOjA6e31pOjEwODthOjA6e31pOjExMTthOjA6e31pOjM7YTowOnt9aToxMzc7YTowOnt9fX19fX19fX1zOjQ6InVzZXIiO086NToiSlVzZXIiOjI1OntzOjk6IgAqAGlzUm9vdCI7TjtzOjI6ImlkIjtpOjA7czo0OiJuYW1lIjtOO3M6ODoidXNlcm5hbWUiO047czo1OiJlbWFpbCI7TjtzOjg6InBhc3N3b3JkIjtOO3M6MTQ6InBhc3N3b3JkX2NsZWFyIjtzOjA6IiI7czo4OiJ1c2VydHlwZSI7TjtzOjU6ImJsb2NrIjtOO3M6OToic2VuZEVtYWlsIjtpOjA7czoxMjoicmVnaXN0ZXJEYXRlIjtOO3M6MTM6Imxhc3R2aXNpdERhdGUiO047czoxMDoiYWN0aXZhdGlvbiI7TjtzOjY6InBhcmFtcyI7TjtzOjY6Imdyb3VwcyI7YTowOnt9czo1OiJndWVzdCI7aToxO3M6MTM6Imxhc3RSZXNldFRpbWUiO047czoxMDoicmVzZXRDb3VudCI7TjtzOjEwOiIAKgBfcGFyYW1zIjtPOjk6IkpSZWdpc3RyeSI6MTp7czo3OiIAKgBkYXRhIjtPOjg6InN0ZENsYXNzIjowOnt9fXM6MTQ6IgAqAF9hdXRoR3JvdXBzIjtOO3M6MTQ6IgAqAF9hdXRoTGV2ZWxzIjthOjI6e2k6MDtpOjE7aToxO2k6MTt9czoxNToiACoAX2F1dGhBY3Rpb25zIjtOO3M6MTI6IgAqAF9lcnJvck1zZyI7TjtzOjEwOiIAKgBfZXJyb3JzIjthOjA6e31zOjM6ImFpZCI7aTowO31zOjE5OiJqc19pZF9jdXJyZW5jeV9vcmlnIjtzOjE6IjIiO3M6MTQ6ImpzX2lkX2N1cnJlbmN5IjtzOjE6IjIiO3M6MTk6ImpzX2hpc3Rvcnlfc2VsX2xhbmciO3M6NToicnUtUlUiO3M6MTU6ImpzX3ByZXZfdXNlcl9pZCI7aTowO3M6MjI6ImpzaG9wX2NoZWNrZWRfbGFuZ3VhZ2UiO2E6Mjp7aTowO3M6NToiZW4tR0IiO2k6MTtzOjU6InJ1LVJVIjt9czoyNjoianNob3BfZW5kX3BhZ2VfYnV5X3Byb2R1Y3QiO3M6ODE6Ii9hdnRvLW9ib3J1ZG92YW5pZS9iYWdham5pa2kva29yemlueS1kbHlhLWJhZ2Fqbmlrb3Yva29yemluYS1hdGxhbnQtMTIwMHg3MDAuaHRtbCI7czoxODoicHJvZHVjdF9iYWNrX3ZhbHVlIjthOjA6e319fX0=\";' , `time` = '1471093031'1 × SHOW FULL COLUMNS
FROM `jdb_jshopping_vendors1 × SHOW FULL COLUMNS
FROM `jdb_jshopping_categories1 × SHOW FULL COLUMNS
FROM `jdb_jshopping_taxes1 × SHOW FULL COLUMNS
FROM `jdb_jshopping_products1 × SHOW FULL COLUMNS
FROM `jdb_jshopping_currencies1 × SHOW FULL COLUMNS
FROM `jdb_jshopping_config1 × SHOW FULL COLUMNS
FROM `jdb_jshopping_attr1 × SHOW FULL COLUMNS
FROM `jdb_jshopping_users1 × INSERT INTO `jdb_session` (`session_id`, `client_id`, `time`)
VALUES ('e36222b391b157496cdcc19aa0ea32ee', 0, '1471093030'1 × SHOW FULL COLUMNS
FROM `jdb_jshopping_products_extra_fields1 × SHOW FULL COLUMNS
FROM `jdb_jshopping_products_extra_field_values
