Joomla! Debug Console
session.client.browser ⇒ CCBot/2.0 (https://commoncrawl.org/faq/)
password_clear ⇒
groups ⇒
search_key ⇒
bat_id ⇒
art_id ⇒
brands ⇒
session.token ⇒ 680d32ab6ad66a23deefc34e2c62d383
Application 0.000 seconds (+0.000); 0.35 MB (+0.349) - afterLoad
Application 0.016 seconds (+0.016); 1.39 MB (+1.043) - afterInitialise
Application 0.025 seconds (+0.009); 2.18 MB (+0.793) - afterRoute
Application 2.248 seconds (+2.223); 4.48 MB (+2.291) - afterDispatch
Application 2.252 seconds (+0.003); 4.56 MB (+0.083) - beforeRenderModule mod_menu (Нижнее1)
Application 2.256 seconds (+0.004); 4.61 MB (+0.051) - afterRenderModule mod_menu (Нижнее1)
Application 2.256 seconds (+0.000); 4.60 MB (-0.006) - beforeRenderModule mod_menu (Нижнее2)
Application 2.256 seconds (+0.001); 4.62 MB (+0.013) - afterRenderModule mod_menu (Нижнее2)
Application 2.257 seconds (+0.000); 4.61 MB (-0.004) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Application 2.258 seconds (+0.001); 4.65 MB (+0.034) - afterRenderModule mod_breadcrumbs (Breadcrumbs)
Application 2.258 seconds (+0.000); 4.64 MB (-0.005) - beforeRenderModule mod_menu (Верхнее меню)
Application 2.260 seconds (+0.002); 4.67 MB (+0.031) - afterRenderModule mod_menu (Верхнее меню)
Application 2.260 seconds (+0.000); 4.67 MB (-0.007) - beforeRenderModule mod_custom (Контакты)
Application 2.261 seconds (+0.001); 4.67 MB (+0.007) - afterRenderModule mod_custom (Контакты)
Application 2.261 seconds (+0.000); 4.67 MB (-0.002) - beforeRenderModule mod_login (Вход на сайт)
Application 2.263 seconds (+0.002); 4.70 MB (+0.025) - afterRenderModule mod_login (Вход на сайт)
Application 2.263 seconds (+0.000); 4.69 MB (-0.003) - beforeRenderModule mod_custom (Корзина)
Application 2.263 seconds (+0.000); 4.70 MB (+0.004) - afterRenderModule mod_custom (Корзина)
Application 2.870 seconds (+0.607); 5.92 MB (+1.226) - afterRender
6.54 MB (6,853,968 Bytes)
38 SQL-запросов зафиксировано
SELECT `data`
FROM `a0gyq_session`
WHERE `session_id` = 't4hotkd826p38gbt8mdkdh3si3'DELETE
FROM `a0gyq_session`
WHERE `time` < '1679716923'SELECT `session_id`
FROM `a0gyq_session`
WHERE `session_id` = 't4hotkd826p38gbt8mdkdh3si3'
LIMIT 0, 1INSERT INTO `a0gyq_session`
(`session_id`, `client_id`, `time`)
VALUES
('t4hotkd826p38gbt8mdkdh3si3', 0, '1679806923')SELECT extension_id AS id, element AS "option", params, enabled
FROM a0gyq_extensions
WHERE `type` = 'component'
AND `element` = 'com_users'SELECT b.id
FROM a0gyq_usergroups AS a
LEFT JOIN a0gyq_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1SELECT id, rules
FROM `a0gyq_viewlevels`SELECT folder AS type, element AS name, params
FROM a0gyq_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1)
ORDER BY orderingSELECT extension_id AS id, element AS "option", params, enabled
FROM a0gyq_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'SHOW TABLESSELECT file_id
from a0gyq_jdownloads_files
WHERE published = 1
AND use_timeframe = 1
AND publish_to != '0000-00-00 00:00:00'
AND publish_to <= '2023-03-26 05:02:03'SELECT file_id
from a0gyq_jdownloads_files
WHERE published = 0
AND use_timeframe = 1
AND publish_from != '0000-00-00 00:00:00'
AND publish_from <= '2023-03-26 05:02:03'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 a0gyq_menu AS m
LEFT JOIN a0gyq_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 TABLESSELECT extension_id AS id, element AS "option", params, enabled
FROM a0gyq_extensions
WHERE `type` = 'component'
AND `element` = 'com_b2b'SELECT *
FROM a0gyq_languages
WHERE published=1
ORDER BY ordering ASCSELECT id, home, template, s.params
FROM a0gyq_template_styles as s
LEFT JOIN a0gyq_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 = 1SELECT extension_id AS id, element AS "option", params, enabled
FROM a0gyq_extensions
WHERE `type` = 'component'
AND `element` = 'com_B2B'SELECT *
FROM a0gyq_b2b_currencies
WHERE cur_code = 'KZT'SELECT *
FROM a0gyq_b2b_product_types
ORDER BY prt_sort_orderSELECT pdt_id, pdt_bra_id, pdt_images, pdt_name, pdt_article_nr, pdt_lct_type
FROM a0gyq_b2b_products
WHERE (pdt_lct_type = 3 or pdt_retail_price <> 999)
AND pdt_lct_type <= 3
ORDER BY pdt_lct_type, pdt_bra_priority, pdt_retail_priceSELECT pdt_id, pdt_bra_id, pdt_images, pdt_name, pdt_article_nr, pdt_lct_type
FROM a0gyq_b2b_products
WHERE (pdt_lct_type = 3 or pdt_retail_price <> 999)
AND pdt_lct_type <= 3
ORDER BY pdt_lct_type, pdt_bra_priority, pdt_retail_price
LIMIT 700, 100SELECT bra_id, bra_name
FROM a0gyq_b2b_brands
WHERE bra_id IN (740,782)SELECT stk_pdt_id, stk_lct_id,stk_base_price * cur_rate * cur_mult / (1.00000 * 1.00000) AS retail_price,stk_price * cur_rate * cur_mult / (1.00000 * 1.00000) AS price,lct_name, lct_type,sum(stk_qty) stk_qty, sum(bst_qty) as bst_qty, sum(bst_qty* bst_price) as bst_sum
FROM a0gyq_b2b_stocks
LEFT JOIN a0gyq_b2b_basket
ON bst_pdt_id = stk_pdt_id
AND bst_lct_id = stk_lct_id
AND bst_session_id = 't4hotkd826p38gbt8mdkdh3si3'
INNER JOIN a0gyq_b2b_locations
ON lct_id = stk_lct_id
INNER JOIN a0gyq_b2b_currencies
ON stk_cur_code = cur_code
WHERE stk_pdt_id in (123086,126929,126165,123360,123617,123368,123115,122350,122879,122370,125187,160776,122890,123917,185106,124690,122392,188443,124445,123422,125729,124706,123942,122408,125227,123455,123459,122436,122437,127057,170583,168280,168284,156768,126841,126845,166787,127368,122776,124840,123818,125357,125629,123090,126930,126931,123092,123354,167643,126945,170726,123114,123371,123116,123118,123121,170739,184827,167676,122882,156931,156933,170759,126728,126985,123402,192525,123414,123417,126745,122394,170781,124707,124963,122404,185125,124711,123945,123436,167726,170546,126770,123443,126772,123191,123961,123963,123967,156992,123968,122433,123202,123458,156995,124490,124236,124492,127058,122451,126547)
GROUP BY stk_pdt_id, stk_lct_id, price, lct_name, lct_type
ORDER BY lct_type, priceSELECT bst_pdt_id as stk_pdt_id, 1 lct_type, bst_qty as bst_qty, (bst_qty* bst_price) as bst_sum
FROM a0gyq_b2b_basket
WHERE bst_session_id = 't4hotkd826p38gbt8mdkdh3si3'
AND bst_pdt_id in (123086,126929,126165,123360,123617,123368,123115,122350,122879,122370,125187,160776,122890,123917,185106,124690,122392,188443,124445,123422,125729,124706,123942,122408,125227,123455,123459,122436,122437,127057,170583,168280,168284,156768,126841,126845,166787,127368,122776,124840,123818,125357,125629,123090,126930,126931,123092,123354,167643,126945,170726,123114,123371,123116,123118,123121,170739,184827,167676,122882,156931,156933,170759,126728,126985,123402,192525,123414,123417,126745,122394,170781,124707,124963,122404,185125,124711,123945,123436,167726,170546,126770,123443,126772,123191,123961,123963,123967,156992,123968,122433,123202,123458,156995,124490,124236,124492,127058,122451,126547)
AND bst_lct_id = 0SELECT *
FROM a0gyq_b2b_currencies
WHERE cur_code = 'KZT'SELECT *
FROM a0gyq_b2b_prices
INNER JOIN a0gyq_b2b_currencies
ON cur_code = prc_cur_code
WHERE prc_ptp_id = 700
AND prc_pdt_id IN (123086,126929,126165,123360,123617,123368,123115,122350,122879,122370,125187,160776,122890,123917,185106,124690,122392,188443,124445,123422,125729,124706,123942,122408,125227,123455,123459,122436,122437,127057,170583,168280,168284,156768,126841,126845,166787,127368,122776,124840,123818,125357,125629,123090,126930,126931,123092,123354,167643,126945,170726,123114,123371,123116,123118,123121,170739,184827,167676,122882,156931,156933,170759,126728,126985,123402,192525,123414,123417,126745,122394,170781,124707,124963,122404,185125,124711,123945,123436,167726,170546,126770,123443,126772,123191,123961,123963,123967,156992,123968,122433,123202,123458,156995,124490,124236,124492,127058,122451,126547)SELECT ifnull(sum(bst_base_price * bst_qty), 0)
FROM a0gyq_b2b_basket
WHERE bst_session_id = 't4hotkd826p38gbt8mdkdh3si3'SELECT *
FROM a0gyq_b2b_discounts
LEFT JOIN a0gyq_b2b_actions
ON dsc_act_id = act_id
WHERE ((dsc_recipient_id = 44
AND dsc_recipient_type = 'CUSTOMER')
OR (dsc_recipient_id = 700
AND dsc_recipient_type = 'PRICETYPE'))
AND (dsc_criteria_type = 'NO' OR (dsc_criteria_type='PRODUCT'
AND dsc_criteria_id IN (123086,126929,126165,123360,123617,123368,123115,122350,122879,122370,125187,160776,122890,123917,185106,124690,122392,188443,124445,123422,125729,124706,123942,122408,125227,123455,123459,122436,122437,127057,170583,168280,168284,156768,126841,126845,166787,127368,122776,124840,123818,125357,125629,123090,126930,126931,123092,123354,167643,126945,170726,123114,123371,123116,123118,123121,170739,184827,167676,122882,156931,156933,170759,126728,126985,123402,192525,123414,123417,126745,122394,170781,124707,124963,122404,185125,124711,123945,123436,167726,170546,126770,123443,126772,123191,123961,123963,123967,156992,123968,122433,123202,123458,156995,124490,124236,124492,127058,122451,126547)))SELECT *
FROM a0gyq_b2b_stocks
INNER JOIN a0gyq_b2b_currencies
ON stk_cur_code = cur_code
WHERE stk_pdt_id IN (123086,126929,126165,123360,123617,123368,123115,122350,122879,122370,125187,160776,122890,123917,185106,124690,122392,188443,124445,123422,125729,124706,123942,122408,125227,123455,123459,122436,122437,127057,170583,168280,168284,156768,126841,126845,166787,127368,122776,124840,123818,125357,125629,123090,126930,126931,123092,123354,167643,126945,170726,123114,123371,123116,123118,123121,170739,184827,167676,122882,156931,156933,170759,126728,126985,123402,192525,123414,123417,126745,122394,170781,124707,124963,122404,185125,124711,123945,123436,167726,170546,126770,123443,126772,123191,123961,123963,123967,156992,123968,122433,123202,123458,156995,124490,124236,124492,127058,122451,126547)SELECT DISTINCT pdt_bra_id `key`, bra_name `value`
FROM a0gyq_b2b_products
INNER JOIN a0gyq_b2b_brands
ON bra_id = pdt_bra_id
AND bra_id <> 0
AND bra_enabled = 1
WHERE pdt_prt_id = 0
ORDER BY bra_priority, bra_nameSELECT DISTINCT dsc_act_id
FROM a0gyq_b2b_discounts
WHERE ((dsc_recipient_id = 44
AND dsc_recipient_type = 'CUSTOMER')
OR (dsc_recipient_id = 700
AND dsc_recipient_type = 'PRICETYPE'))
AND dsc_act_id IS NOT NULLSELECT *
FROM a0gyq_b2b_actions
WHERE act_id IN (-1)
ORDER BY act_date_to DESCSELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM a0gyq_modules AS m
LEFT JOIN a0gyq_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN a0gyq_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 <= '2023-03-26 05:02:05')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-03-26 05:02:05')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 558 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingSELECT extension_id AS id, element AS "option", params, enabled
FROM a0gyq_extensions
WHERE `type` = 'component'
AND `element` = 'com_content'SHOW TABLESSELECT *
FROM a0gyq_acymailing_configUPDATE `a0gyq_session`
SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1679806923;s:18:\"session.timer.last\";i:1679806923;s:17:\"session.timer.now\";i:1679806923;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\":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:2:{i:0;i:1;i:1;i:1;}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:15:\"b2b_item_filter\";a:4:{s:10:\"search_key\";s:0:\"\";s:6:\"bat_id\";s:0:\"\";s:6:\"art_id\";s:0:\"\";s:6:\"brands\";a:0:{}}s:13:\"session.token\";s:32:\"680d32ab6ad66a23deefc34e2c62d383\";}'
, `time` = '1679806926'
WHERE `session_id` = 't4hotkd826p38gbt8mdkdh3si3'
29 типов SQL-запросов зафиксировано, отсортировано по вхождениям
Запросы типа SELECT:
5 × SELECT extension_id AS id, element AS "option", params, enabled
FROM a0gyq_extensions2 × SELECT *
FROM a0gyq_b2b_currencies2 × SELECT file_id
from a0gyq_jdownloads_files2 × SELECT pdt_id, pdt_bra_id, pdt_images, pdt_name, pdt_article_nr, pdt_lct_type
FROM a0gyq_b2b_products1 × SELECT *
FROM a0gyq_b2b_stocks
INNER JOIN a0gyq_b2b_currencies
ON stk_cur_code = cur_code1 × SELECT *
FROM a0gyq_b2b_discounts
LEFT JOIN a0gyq_b2b_actions
ON dsc_act_id = act_id1 × SELECT ifnull(sum(bst_base_price * bst_qty), 0)
FROM a0gyq_b2b_basket1 × SELECT *
FROM a0gyq_b2b_prices
INNER JOIN a0gyq_b2b_currencies
ON cur_code = prc_cur_code1 × SELECT DISTINCT pdt_bra_id `key`, bra_name `value`
FROM a0gyq_b2b_products
INNER JOIN a0gyq_b2b_brands
ON bra_id = pdt_bra_id
AND bra_id <> 0
AND bra_enabled = 11 × SELECT DISTINCT dsc_act_id
FROM a0gyq_b2b_discounts1 × SELECT *
FROM a0gyq_acymailing_confi1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM a0gyq_modules AS m
LEFT JOIN a0gyq_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN a0gyq_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT *
FROM a0gyq_b2b_actions1 × SELECT bst_pdt_id as stk_pdt_id, 1 lct_type, bst_qty as bst_qty, (bst_qty* bst_price) as bst_sum
FROM a0gyq_b2b_basket1 × SELECT stk_pdt_id, stk_lct_id,stk_base_price * cur_rate * cur_mult / (1.00000 * 1.00000) AS retail_price,stk_price * cur_rate * cur_mult / (1.00000 * 1.00000) AS price,lct_name, lct_type,sum(stk_qty) stk_qty, sum(bst_qty) as bst_qty, sum(bst_qty* bst_price) as bst_sum
FROM a0gyq_b2b_stocks
LEFT JOIN a0gyq_b2b_basket
ON bst_pdt_id = stk_pdt_id
AND bst_lct_id = stk_lct_id
AND bst_session_id = 't4hotkd826p38gbt8mdkdh3si3'
INNER JOIN a0gyq_b2b_locations
ON lct_id = stk_lct_id
INNER JOIN a0gyq_b2b_currencies
ON stk_cur_code = cur_code1 × SELECT *
FROM a0gyq_languages1 × 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 a0gyq_menu AS m
LEFT JOIN a0gyq_extensions AS e
ON m.component_id = e.extension_id1 × SELECT b.id
FROM a0gyq_usergroups AS a
LEFT JOIN a0gyq_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT folder AS type, element AS name, params
FROM a0gyq_extensions1 × SELECT id, home, template, s.params
FROM a0gyq_template_styles as s
LEFT JOIN a0gyq_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT `session_id`
FROM `a0gyq_session`1 × SELECT bra_id, bra_name
FROM a0gyq_b2b_brands1 × SELECT `data`
FROM `a0gyq_session`1 × SELECT *
FROM a0gyq_b2b_product_types1 × SELECT id, rules
FROM `a0gyq_viewlevels
Прочие SQL-запросы:
3 × SHOW TABLE1 × UPDATE `a0gyq_session`
SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1679806923;s:18:\"session.timer.last\";i:1679806923;s:17:\"session.timer.now\";i:1679806923;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\":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:2:{i:0;i:1;i:1;i:1;}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:15:\"b2b_item_filter\";a:4:{s:10:\"search_key\";s:0:\"\";s:6:\"bat_id\";s:0:\"\";s:6:\"art_id\";s:0:\"\";s:6:\"brands\";a:0:{}}s:13:\"session.token\";s:32:\"680d32ab6ad66a23deefc34e2c62d383\";}' , `time` = '1679806926'1 × INSERT INTO `a0gyq_session` (`session_id`, `client_id`, `time`)
VALUES ('t4hotkd826p38gbt8mdkdh3si3', 0, '1679806923'1 × DELETE
FROM `a0gyq_session`
