6781cc8b6b97d: GET https://avalon-tent.ru/catalog/tip/shatry-dlya-prazdnikov-na-prirode/prodaja/ at 2025-01-11 04:42:35 am by 47.128.33.241
Database Queries
Всего 93 записи.
| Time | Duration | Type | Query |
|---|---|---|---|
| 04:42:35.441 | 0.6 ms | SELECT | SELECT * FROM `cms_tree` WHERE (`dir`='catalog/tip/shatry-dlya-prazdnikov-na-prirode/prodaja') AND (`site_code`='s1') |
| 04:42:35.442 | 0.3 ms | SELECT | SELECT * FROM `cms_tree` WHERE `id`=89 |
| 04:42:35.443 | 0.2 ms | SELECT | SELECT * FROM `cms_tree` WHERE `cms_tree`.`id` IN ('1', '18', '71', '81') |
| 04:42:35.443 | 0.1 ms | SELECT | SELECT * FROM `cms_site` WHERE (`code`='s1') AND (`active`='Y') |
| 04:42:35.443 | 0.1 ms | SELECT | SELECT * FROM `cms_tree_type` WHERE `id`=6 |
| 04:42:35.444 | 0.1 ms | SELECT | SELECT * FROM `cms_tree_type` WHERE `id`=6 |
| 04:42:35.444 | 0.2 ms | SELECT | SELECT * FROM `cms_tree_type_property` WHERE `tree_type_id`=6 ORDER BY `priority` |
| 04:42:35.445 | 0.2 ms | SELECT | SELECT * FROM `cms_tree_property` WHERE `element_id`=89 |
| 04:42:35.446 | 0.2 ms | SELECT | SELECT * FROM `cms_tree` WHERE (`pid`=89) AND (`active`='Y') AND (`site_code`='s1') ORDER BY `priority` |
| 04:42:35.503 | 0.2 ms | SELECT | SELECT * FROM `cms_content` WHERE `id` IS NULL |
| 04:42:35.547 | 0.3 ms | SELECT | SELECT `id` FROM `cms_tree` WHERE (`pids` LIKE '1/18/71/81/89/%') OR (`pid`=89) ORDER BY `level`, `priority` |
| 04:42:35.547 | 1.9 ms | SELECT | SELECT *, `cms_content_element`.`id` AS `mainId` FROM `cms_content_element` LEFT JOIN `cms_content_element_tree` ON `cms_content_element`.`id` = `cms_content_element_tree`.`element_id` WHERE ((`cms_content_element`.`tree_id`=89) OR (`cms_content_element_tree`.`tree_id`=89)) AND (`cms_content_element`.`published_at` <= '1736559755') AND ((`cms_content_element`.`published_to` >= '1736559755') OR (`cms_content_element`.`published_to` IS NULL)) GROUP BY `cms_content_element`.`id` |
| 04:42:35.549 | 0.4 ms | SELECT | SELECT * FROM `cms_storage_file` WHERE `id` IN ('1494', '1427', '200', '205', '209', '213', '218', '1709', '1644', '1771', '1639', '1852', '1774', '234', '1697', '1657', '2101', '1654', '1683', '1680', '1738', '255', '256', '257', '265', '268', '271', '274', '1585', '402', '1545', '408', '411', '412', '1640', '1667', '1024', '1353', '1358', '1363', '1368', '1483', '2403', '2706', '1756', '2070', '1762', '1765', '1780', '1784', '2292') |
| 04:42:35.550 | 0.2 ms | SELECT | SELECT * FROM `cms_tree` WHERE `id`='89' |
| 04:42:35.550 | 0.6 ms | SELECT | SELECT * FROM `cms_content_element_tree` WHERE `element_id` IN ('306', '301', '296', '291', '286', '181', '281', '276', '271', '266', '261', '256', '251', '245', '241', '236', '231', '226', '220', '216', '211', '206', '201', '196', '317', '374', '368', '362', '313', '491', '350', '356', '343', '309', '191', '186', '331', '656', '654', '653', '651', '667', '672', '685', '702', '713', '724', '735', '747', '757', '812') |
| 04:42:35.584 | 0.3 ms | SELECT | SELECT * FROM `cms_storage_file` WHERE 0=1 |
| 04:42:35.585 | 1.7 ms | SELECT | SELECT COUNT(*) FROM (SELECT `cms_content_element`.* FROM `cms_content_element` LEFT JOIN `cms_content_element_tree` ON `cms_content_element`.`id` = `cms_content_element_tree`.`element_id` LEFT JOIN `shop_product` ON `shop_product`.`id` = `cms_content_element`.`id` WHERE ((`cms_content_element`.`tree_id`=89) OR (`cms_content_element_tree`.`tree_id`=89)) AND (`cms_content_element`.`published_at` <= '1736559755') AND ((`cms_content_element`.`published_to` >= '1736559755') OR (`cms_content_element`.`published_to` IS NULL)) GROUP BY `cms_content_element`.`id`) `c` |
| 04:42:35.587 | 1.9 ms | SELECT | SELECT `cms_content_element`.* FROM `cms_content_element` LEFT JOIN `cms_content_element_tree` ON `cms_content_element`.`id` = `cms_content_element_tree`.`element_id` LEFT JOIN `shop_product` ON `shop_product`.`id` = `cms_content_element`.`id` WHERE ((`cms_content_element`.`tree_id`=89) OR (`cms_content_element_tree`.`tree_id`=89)) AND (`cms_content_element`.`published_at` <= '1736559755') AND ((`cms_content_element`.`published_to` >= '1736559755') OR (`cms_content_element`.`published_to` IS NULL)) GROUP BY `cms_content_element`.`id` ORDER BY `published_at` DESC LIMIT 10 |
| 04:42:35.589 | 0.3 ms | SELECT | SELECT * FROM `cms_storage_file` WHERE `id` IN (2292, 1784, 1780, 1852, 1765, 2101, 1762, 2070, 2403, 2706) |
| 04:42:35.590 | 0.4 ms | SELECT | SELECT * FROM `cms_tree` WHERE `id` IN (40, 38) |
| 04:42:35.591 | 0.5 ms | SELECT | SELECT * FROM `cms_content_element_tree` WHERE `element_id` IN (281, 251, 250, 78, 249, 84, 248, 247, 240, 244) |
| 04:42:35.591 | 0.3 ms | SHOW | SHOW FULL COLUMNS FROM `cms_content_element_tree` |
| 04:42:35.592 | 0.2 ms | SELECT | SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'cms_content_element_tree' AND kcu.table_name = 'cms_content_element_tree' |
| 04:42:35.594 | 0.2 ms | SELECT | SELECT * FROM `cms_content` WHERE `id`=4 |
| 04:42:35.594 | 0.4 ms | SELECT | SELECT * FROM `cms_content_property` WHERE `content_id`=4 ORDER BY `priority` |
| 04:42:35.596 | 0.3 ms | SELECT | SELECT * FROM `cms_content_element_property` WHERE `element_id`=281 |
| 04:42:35.597 | 0.1 ms | SELECT | SELECT * FROM `cms_content` WHERE `id`=4 |
| 04:42:35.597 | 0.2 ms | SELECT | SELECT * FROM `cms_content_property` WHERE `content_id`=4 ORDER BY `priority` |
| 04:42:35.598 | 0.3 ms | SELECT | SELECT * FROM `cms_content_element_property` WHERE `element_id`=251 |
| 04:42:35.599 | 0.1 ms | SELECT | SELECT * FROM `cms_content` WHERE `id`=4 |
| 04:42:35.599 | 0.2 ms | SELECT | SELECT * FROM `cms_content_property` WHERE `content_id`=4 ORDER BY `priority` |
| 04:42:35.601 | 0.3 ms | SELECT | SELECT * FROM `cms_content_element_property` WHERE `element_id`=250 |
| 04:42:35.602 | 0.1 ms | SELECT | SELECT * FROM `cms_content` WHERE `id`=4 |
| 04:42:35.602 | 0.2 ms | SELECT | SELECT * FROM `cms_content_property` WHERE `content_id`=4 ORDER BY `priority` |
| 04:42:35.603 | 0.3 ms | SELECT | SELECT * FROM `cms_content_element_property` WHERE `element_id`=78 |
| 04:42:35.604 | 0.1 ms | SELECT | SELECT * FROM `cms_content` WHERE `id`=4 |
| 04:42:35.604 | 0.2 ms | SELECT | SELECT * FROM `cms_content_property` WHERE `content_id`=4 ORDER BY `priority` |
| 04:42:35.605 | 0.3 ms | SELECT | SELECT * FROM `cms_content_element_property` WHERE `element_id`=249 |
| 04:42:35.606 | 0.1 ms | SELECT | SELECT * FROM `cms_content` WHERE `id`=4 |
| 04:42:35.606 | 0.2 ms | SELECT | SELECT * FROM `cms_content_property` WHERE `content_id`=4 ORDER BY `priority` |
| 04:42:35.608 | 0.3 ms | SELECT | SELECT * FROM `cms_content_element_property` WHERE `element_id`=84 |
| 04:42:35.609 | 0.1 ms | SELECT | SELECT * FROM `cms_content` WHERE `id`=4 |
| 04:42:35.609 | 0.2 ms | SELECT | SELECT * FROM `cms_content_property` WHERE `content_id`=4 ORDER BY `priority` |
| 04:42:35.610 | 0.3 ms | SELECT | SELECT * FROM `cms_content_element_property` WHERE `element_id`=248 |
| 04:42:35.611 | 0.1 ms | SELECT | SELECT * FROM `cms_content` WHERE `id`=4 |
| 04:42:35.611 | 0.2 ms | SELECT | SELECT * FROM `cms_content_property` WHERE `content_id`=4 ORDER BY `priority` |
| 04:42:35.614 | 0.5 ms | SELECT | SELECT * FROM `cms_content_element_property` WHERE `element_id`=247 |
| 04:42:35.615 | 0.1 ms | SELECT | SELECT * FROM `cms_content` WHERE `id`=4 |
| 04:42:35.615 | 0.3 ms | SELECT | SELECT * FROM `cms_content_property` WHERE `content_id`=4 ORDER BY `priority` |
| 04:42:35.617 | 0.3 ms | SELECT | SELECT * FROM `cms_content_element_property` WHERE `element_id`=240 |
| 04:42:35.618 | 0.1 ms | SELECT | SELECT * FROM `cms_content` WHERE `id`=4 |
| 04:42:35.618 | 0.2 ms | SELECT | SELECT * FROM `cms_content_property` WHERE `content_id`=4 ORDER BY `priority` |
| 04:42:35.619 | 0.3 ms | SELECT | SELECT * FROM `cms_content_element_property` WHERE `element_id`=244 |
| 04:42:35.620 | 0.2 ms | SELECT | SELECT * FROM `cms_tree_image` WHERE `tree_id`=89 |
| 04:42:35.621 | 0.1 ms | SELECT | SELECT * FROM `cms_storage_file` WHERE 0=1 |
| 04:42:35.621 | 0.2 ms | SELECT | SELECT * FROM `cms_tree` WHERE `pid`=89 ORDER BY `priority` |
| 04:42:35.622 | 0.2 ms | SELECT | SELECT * FROM `cms_tree` WHERE `cms_tree`.`id`='1' |
| 04:42:35.623 | 0.1 ms | SELECT | SELECT * FROM `cms_tree` WHERE (`pid`='1') AND (`level`='1') AND (`active`='Y') AND (`site_code`='s1') ORDER BY `priority` |
| 04:42:35.623 | 0.1 ms | SELECT | SELECT * FROM `cms_tree` WHERE `pid` IN (65, 66, 67, 76, 7, 8, 4) ORDER BY `priority` |
| 04:42:35.624 | 0.1 ms | SELECT | SELECT * FROM `cms_tree` WHERE `id`=35 |
| 04:42:35.624 | 0.2 ms | SELECT | SELECT * FROM `cms_tree` WHERE `pid`=35 ORDER BY `priority` |
| 04:42:35.625 | 0.2 ms | SELECT | SELECT * FROM `cms_tree` WHERE (`active`='Y') AND (`pid`=35) ORDER BY `priority` |
| 04:42:35.626 | 0.1 ms | SELECT | SELECT * FROM `cms_tree` WHERE `id`=36 |
| 04:42:35.626 | 0.3 ms | SELECT | SELECT * FROM `cms_tree` WHERE `pid`=36 ORDER BY `priority` |
| 04:42:35.627 | 0.3 ms | SELECT | SELECT * FROM `cms_tree` WHERE (`active`='Y') AND (`pid`=36) ORDER BY `priority` |
| 04:42:35.628 | 0.1 ms | SELECT | SELECT * FROM `cms_tree` WHERE `id`=37 |
| 04:42:35.628 | 0.4 ms | SELECT | SELECT * FROM `cms_tree` WHERE `pid`=37 ORDER BY `priority` |
| 04:42:35.629 | 0.3 ms | SELECT | SELECT * FROM `cms_tree` WHERE (`active`='Y') AND (`pid`=37) ORDER BY `priority` |
| 04:42:35.630 | 0.1 ms | SELECT | SELECT * FROM `cms_tree` WHERE `id`=71 |
| 04:42:35.630 | 0.4 ms | SELECT | SELECT * FROM `cms_tree` WHERE `pid`=71 ORDER BY `priority` |
| 04:42:35.631 | 0.3 ms | SELECT | SELECT * FROM `cms_tree` WHERE (`active`='Y') AND (`pid`=71) ORDER BY `priority` |
| 04:42:35.631 | 0.1 ms | SELECT | SELECT * FROM `cms_tree` WHERE `id`=63 |
| 04:42:35.632 | 0.1 ms | SELECT | SELECT * FROM `cms_tree` WHERE `id`=69 |
| 04:42:35.632 | 0.1 ms | SELECT | SELECT * FROM `cms_tree` WHERE 0=1 |
| 04:42:35.632 | 0.1 ms | SELECT | SELECT * FROM `cms_tree` WHERE (`active`='Y') AND (`pid`=7) ORDER BY `priority` |
| 04:42:35.632 | 0.1 ms | SELECT | SELECT * FROM `cms_tree` WHERE 0=1 |
| 04:42:35.632 | 0.1 ms | SELECT | SELECT * FROM `cms_tree` WHERE 0=1 |
| 04:42:35.633 | 0.1 ms | SELECT | SELECT * FROM `cms_tree` WHERE (`level`='1') AND (`active`='Y') AND (`site_code`='s1') ORDER BY `priority` |
| 04:42:35.634 | 0.1 ms | SELECT | SELECT * FROM `cms_tree` WHERE `pid` IN (65, 66, 67, 76, 7, 8, 4) ORDER BY `priority` |
| 04:42:35.634 | 0.1 ms | SELECT | SELECT * FROM `cms_tree` WHERE `id`=35 |
| 04:42:35.635 | 0.1 ms | SELECT | SELECT * FROM `cms_tree` WHERE `id`=36 |
| 04:42:35.635 | 0.1 ms | SELECT | SELECT * FROM `cms_tree` WHERE `id`=37 |
| 04:42:35.635 | 0.1 ms | SELECT | SELECT * FROM `cms_tree` WHERE `id`=71 |
| 04:42:35.651 | 0.2 ms | SELECT | SELECT * FROM `cms_tree` WHERE (`pid`='18') AND (`active`='Y') AND (`site_code`='s1') AND (`tree_type_id` IN ('2', '6')) ORDER BY `priority` |
| 04:42:35.651 | 1.1 ms | SELECT | SELECT * FROM `cms_tree` WHERE `pid` IN (35, 36, 37, 71) ORDER BY `priority` |
| 04:42:35.658 | 0.1 ms | SELECT | SELECT * FROM `form2_form` WHERE `code`='callback' |
| 04:42:35.659 | 0.1 ms | SELECT | SELECT * FROM `form2_form` WHERE `id`=3 |
| 04:42:35.659 | 0.1 ms | SELECT | SELECT * FROM `form2_form_property` WHERE `form_id`=3 ORDER BY `priority` |
| 04:42:35.659 | 0.0 ms | SELECT | SELECT * FROM `form2_form_send_property` WHERE 0=1 |
| 04:42:35.660 | 0.1 ms | SELECT | SELECT * FROM `form2_form` WHERE `code`='feedback' |
| 04:42:35.660 | 0.0 ms | SELECT | SELECT * FROM `form2_form` WHERE `id`=1 |
| 04:42:35.660 | 0.1 ms | SELECT | SELECT * FROM `form2_form_property` WHERE `form_id`=1 ORDER BY `priority` |
| 04:42:35.661 | 0.0 ms | SELECT | SELECT * FROM `form2_form_send_property` WHERE 0=1 |