Database Queries

Всего 97 записей.

Time	Duration	Type	Query

04:49:51.813	0.6 ms	SELECT	SELECT * FROM `cms_tree` WHERE (`dir`='catalog/tip/shatry-dlya-togrovli-ulice/prodaja') AND (`site_code`='s1') [+] Explain
04:49:51.814	0.2 ms	SELECT	SELECT * FROM `cms_tree` WHERE `id`=85 [+] Explain
04:49:51.814	0.4 ms	SELECT	SELECT * FROM `cms_tree` WHERE `cms_tree`.`id` IN ('1', '18', '71', '77') [+] Explain
04:49:51.815	0.1 ms	SELECT	SELECT * FROM `cms_site` WHERE (`code`='s1') AND (`active`='Y') [+] Explain
04:49:51.815	0.1 ms	SELECT	SELECT * FROM `cms_tree_type` WHERE `id`=6 [+] Explain
04:49:51.816	0.1 ms	SELECT	SELECT * FROM `cms_tree_type` WHERE `id`=6 [+] Explain
04:49:51.816	0.1 ms	SELECT	SELECT * FROM `cms_tree_type_property` WHERE `tree_type_id`=6 ORDER BY `priority` [+] Explain
04:49:51.817	0.3 ms	SELECT	SELECT * FROM `cms_tree_property` WHERE `element_id`=85 [+] Explain
04:49:51.832	0.5 ms	SELECT	SELECT * FROM `cms_tree` WHERE (`pid`=85) AND (`active`='Y') AND (`site_code`='s1') ORDER BY `priority` [+] Explain
04:49:51.856	0.2 ms	SELECT	SELECT * FROM `cms_content` WHERE `id` IS NULL [+] Explain
04:49:51.909	0.3 ms	SELECT	SELECT `id` FROM `cms_tree` WHERE (`pids` LIKE '1/18/71/77/85/%') OR (`pid`=85) ORDER BY `level`, `priority` [+] Explain
04:49:51.910	2.1 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`=85) OR (`cms_content_element_tree`.`tree_id`=85)) AND (`cms_content_element`.`published_at` <= '1736560191') AND ((`cms_content_element`.`published_to` >= '1736560191') OR (`cms_content_element`.`published_to` IS NULL)) GROUP BY `cms_content_element`.`id` [+] Explain
04:49:51.912	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', '1024', '1353', '1358', '1363', '1368', '1483', '2403', '2706', '2070', '1762', '1765', '1780', '1784', '2292') [+] Explain
04:49:51.913	0.2 ms	SELECT	SELECT * FROM `cms_tree` WHERE `id`='85' [+] Explain
04:49:51.913	0.6 ms	SELECT	SELECT * FROM `cms_content_element_tree` WHERE `element_id` IN ('303', '298', '293', '288', '283', '178', '278', '273', '268', '263', '258', '253', '248', '247', '238', '233', '228', '223', '222', '213', '208', '203', '198', '193', '316', '371', '366', '359', '312', '490', '347', '353', '340', '308', '188', '329', '657', '655', '652', '650', '665', '670', '682', '709', '720', '734', '743', '756', '811') [+] Explain
04:49:51.946	0.1 ms	SELECT	SELECT * FROM `cms_storage_file` WHERE 0=1 [+] Explain
04:49:51.947	1.4 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`=85) OR (`cms_content_element_tree`.`tree_id`=85)) AND (`cms_content_element`.`published_at` <= '1736560191') AND ((`cms_content_element`.`published_to` >= '1736560191') OR (`cms_content_element`.`published_to` IS NULL)) GROUP BY `cms_content_element`.`id`) `c` [+] Explain
04:49:51.948	1.5 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`=85) OR (`cms_content_element_tree`.`tree_id`=85)) AND (`cms_content_element`.`published_at` <= '1736560191') AND ((`cms_content_element`.`published_to` >= '1736560191') OR (`cms_content_element`.`published_to` IS NULL)) GROUP BY `cms_content_element`.`id` ORDER BY `published_at` DESC LIMIT 10 [+] Explain
04:49:51.950	0.1 ms	SELECT	SELECT * FROM `cms_storage_file` WHERE `id` IN (2292, 1784, 1780, 1852, 1765, 2101, 1762, 2070, 2403, 2706) [+] Explain
04:49:51.951	0.1 ms	SELECT	SELECT * FROM `cms_tree` WHERE `id` IN (40, 38) [+] Explain
04:49:51.951	0.2 ms	SELECT	SELECT * FROM `cms_content_element_tree` WHERE `element_id` IN (281, 251, 250, 78, 249, 84, 248, 247, 240, 244) [+] Explain
04:49:51.952	0.1 ms	SELECT	SELECT * FROM `cms_content` WHERE `id`=4 [+] Explain
04:49:51.953	0.2 ms	SELECT	SELECT * FROM `cms_content_property` WHERE `content_id`=4 ORDER BY `priority` [+] Explain
04:49:51.954	0.1 ms	SELECT	SELECT * FROM `cms_content_element_property` WHERE `element_id`=281 [+] Explain
04:49:51.955	0.1 ms	SELECT	SELECT * FROM `cms_content` WHERE `id`=4 [+] Explain
04:49:51.955	0.2 ms	SELECT	SELECT * FROM `cms_content_property` WHERE `content_id`=4 ORDER BY `priority` [+] Explain
04:49:51.956	0.1 ms	SELECT	SELECT * FROM `cms_content_element_property` WHERE `element_id`=251 [+] Explain
04:49:51.957	0.1 ms	SELECT	SELECT * FROM `cms_content` WHERE `id`=4 [+] Explain
04:49:51.957	0.2 ms	SELECT	SELECT * FROM `cms_content_property` WHERE `content_id`=4 ORDER BY `priority` [+] Explain
04:49:51.959	0.1 ms	SELECT	SELECT * FROM `cms_content_element_property` WHERE `element_id`=250 [+] Explain
04:49:51.959	0.1 ms	SELECT	SELECT * FROM `cms_content` WHERE `id`=4 [+] Explain
04:49:51.959	0.1 ms	SELECT	SELECT * FROM `cms_content_property` WHERE `content_id`=4 ORDER BY `priority` [+] Explain
04:49:51.961	0.1 ms	SELECT	SELECT * FROM `cms_content_element_property` WHERE `element_id`=78 [+] Explain
04:49:51.962	0.1 ms	SELECT	SELECT * FROM `cms_content` WHERE `id`=4 [+] Explain
04:49:51.962	0.1 ms	SELECT	SELECT * FROM `cms_content_property` WHERE `content_id`=4 ORDER BY `priority` [+] Explain
04:49:51.963	0.1 ms	SELECT	SELECT * FROM `cms_content_element_property` WHERE `element_id`=249 [+] Explain
04:49:51.964	0.1 ms	SELECT	SELECT * FROM `cms_content` WHERE `id`=4 [+] Explain
04:49:51.964	0.3 ms	SELECT	SELECT * FROM `cms_content_property` WHERE `content_id`=4 ORDER BY `priority` [+] Explain
04:49:51.965	0.1 ms	SELECT	SELECT * FROM `cms_content_element_property` WHERE `element_id`=84 [+] Explain
04:49:51.966	0.1 ms	SELECT	SELECT * FROM `cms_content` WHERE `id`=4 [+] Explain
04:49:51.966	0.2 ms	SELECT	SELECT * FROM `cms_content_property` WHERE `content_id`=4 ORDER BY `priority` [+] Explain
04:49:51.968	0.1 ms	SELECT	SELECT * FROM `cms_content_element_property` WHERE `element_id`=248 [+] Explain
04:49:51.968	0.1 ms	SELECT	SELECT * FROM `cms_content` WHERE `id`=4 [+] Explain
04:49:51.969	0.2 ms	SELECT	SELECT * FROM `cms_content_property` WHERE `content_id`=4 ORDER BY `priority` [+] Explain
04:49:51.972	0.2 ms	SELECT	SELECT * FROM `cms_content_element_property` WHERE `element_id`=247 [+] Explain
04:49:51.972	0.1 ms	SELECT	SELECT * FROM `cms_content` WHERE `id`=4 [+] Explain
04:49:51.973	0.1 ms	SELECT	SELECT * FROM `cms_content_property` WHERE `content_id`=4 ORDER BY `priority` [+] Explain
04:49:51.974	0.2 ms	SELECT	SELECT * FROM `cms_content_element_property` WHERE `element_id`=240 [+] Explain
04:49:51.975	0.1 ms	SELECT	SELECT * FROM `cms_content` WHERE `id`=4 [+] Explain
04:49:51.975	0.2 ms	SELECT	SELECT * FROM `cms_content_property` WHERE `content_id`=4 ORDER BY `priority` [+] Explain
04:49:51.976	0.1 ms	SELECT	SELECT * FROM `cms_content_element_property` WHERE `element_id`=244 [+] Explain
04:49:51.977	0.3 ms	SELECT	SELECT * FROM `cms_tree_image` WHERE `tree_id`=85 [+] Explain
04:49:51.978	0.1 ms	SELECT	SELECT * FROM `cms_storage_file` WHERE 0=1 [+] Explain
04:49:51.978	0.2 ms	SELECT	SELECT * FROM `cms_tree` WHERE `pid`=85 ORDER BY `priority` [+] Explain
04:49:51.979	0.1 ms	SELECT	SELECT * FROM `cms_tree` WHERE `cms_tree`.`id`='1' [+] Explain
04:49:51.980	0.1 ms	SELECT	SELECT * FROM `cms_tree` WHERE (`pid`='1') AND (`level`='1') AND (`active`='Y') AND (`site_code`='s1') ORDER BY `priority` [+] Explain
04:49:51.980	0.1 ms	SELECT	SELECT * FROM `cms_tree` WHERE `pid` IN (65, 66, 67, 76, 7, 8, 4) ORDER BY `priority` [+] Explain
04:49:51.981	0.1 ms	SELECT	SELECT * FROM `cms_tree` WHERE `id`=35 [+] Explain
04:49:51.981	0.2 ms	SELECT	SELECT * FROM `cms_tree` WHERE `pid`=35 ORDER BY `priority` [+] Explain
04:49:51.982	0.2 ms	SELECT	SELECT * FROM `cms_tree` WHERE (`active`='Y') AND (`pid`=35) ORDER BY `priority` [+] Explain
04:49:51.983	0.1 ms	SELECT	SELECT * FROM `cms_tree` WHERE `id`=36 [+] Explain
04:49:51.983	0.3 ms	SELECT	SELECT * FROM `cms_tree` WHERE `pid`=36 ORDER BY `priority` [+] Explain
04:49:51.984	0.3 ms	SELECT	SELECT * FROM `cms_tree` WHERE (`active`='Y') AND (`pid`=36) ORDER BY `priority` [+] Explain
04:49:51.985	0.1 ms	SELECT	SELECT * FROM `cms_tree` WHERE `id`=37 [+] Explain
04:49:51.985	0.3 ms	SELECT	SELECT * FROM `cms_tree` WHERE `pid`=37 ORDER BY `priority` [+] Explain
04:49:51.986	0.2 ms	SELECT	SELECT * FROM `cms_tree` WHERE (`active`='Y') AND (`pid`=37) ORDER BY `priority` [+] Explain
04:49:51.987	0.1 ms	SELECT	SELECT * FROM `cms_tree` WHERE `id`=71 [+] Explain
04:49:51.987	0.3 ms	SELECT	SELECT * FROM `cms_tree` WHERE `pid`=71 ORDER BY `priority` [+] Explain
04:49:51.988	0.3 ms	SELECT	SELECT * FROM `cms_tree` WHERE (`active`='Y') AND (`pid`=71) ORDER BY `priority` [+] Explain
04:49:51.988	0.2 ms	SELECT	SELECT * FROM `cms_tree` WHERE `id`=63 [+] Explain
04:49:51.989	0.1 ms	SELECT	SELECT * FROM `cms_tree` WHERE `id`=69 [+] Explain
04:49:51.989	0.1 ms	SELECT	SELECT * FROM `cms_tree` WHERE 0=1 [+] Explain
04:49:51.989	0.1 ms	SELECT	SELECT * FROM `cms_tree` WHERE (`active`='Y') AND (`pid`=7) ORDER BY `priority` [+] Explain
04:49:51.989	0.1 ms	SELECT	SELECT * FROM `cms_tree` WHERE 0=1 [+] Explain
04:49:51.990	0.1 ms	SELECT	SELECT * FROM `cms_tree` WHERE 0=1 [+] Explain
04:49:52.006	0.2 ms	SELECT	SELECT * FROM `cms_tree` WHERE (`level`='1') AND (`active`='Y') AND (`site_code`='s1') ORDER BY `priority` [+] Explain
04:49:52.007	0.1 ms	SELECT	SELECT * FROM `cms_tree` WHERE `pid` IN (65, 66, 67, 76, 7, 8, 4) ORDER BY `priority` [+] Explain
04:49:52.007	0.1 ms	SELECT	SELECT * FROM `cms_tree` WHERE `id`=35 [+] Explain
04:49:52.007	0.1 ms	SELECT	SELECT * FROM `cms_tree` WHERE `id`=36 [+] Explain
04:49:52.008	0.1 ms	SELECT	SELECT * FROM `cms_tree` WHERE `id`=37 [+] Explain
04:49:52.008	0.1 ms	SELECT	SELECT * FROM `cms_tree` WHERE `id`=71 [+] Explain
04:49:52.019	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` [+] Explain
04:49:52.020	0.9 ms	SELECT	SELECT * FROM `cms_tree` WHERE `pid` IN (35, 36, 37, 71) ORDER BY `priority` [+] Explain
04:49:52.027	0.1 ms	SELECT	SELECT * FROM `form2_form` WHERE `code`='callback' [+] Explain
04:49:52.027	0.4 ms	SHOW	SHOW FULL COLUMNS FROM `form2_form`
04:49:52.028	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 = 'form2_form' AND kcu.table_name = 'form2_form' [+] Explain
04:49:52.028	0.3 ms	SHOW	SHOW FULL COLUMNS FROM `form2_form_send`
04:49:52.029	0.3 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 = 'form2_form_send' AND kcu.table_name = 'form2_form_send' [+] Explain
04:49:52.029	0.1 ms	SELECT	SELECT * FROM `form2_form` WHERE `id`=3 [+] Explain
04:49:52.029	0.1 ms	SELECT	SELECT * FROM `form2_form_property` WHERE `form_id`=3 ORDER BY `priority` [+] Explain
04:49:52.030	0.3 ms	SHOW	SHOW FULL COLUMNS FROM `form2_form_property`
04:49:52.030	0.3 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 = 'form2_form_property' AND kcu.table_name = 'form2_form_property' [+] Explain
04:49:52.031	0.1 ms	SELECT	SELECT * FROM `form2_form_send_property` WHERE 0=1 [+] Explain
04:49:52.031	0.1 ms	SELECT	SELECT * FROM `form2_form` WHERE `code`='feedback' [+] Explain
04:49:52.032	0.1 ms	SELECT	SELECT * FROM `form2_form` WHERE `id`=1 [+] Explain
04:49:52.032	0.1 ms	SELECT	SELECT * FROM `form2_form_property` WHERE `form_id`=1 ORDER BY `priority` [+] Explain
04:49:52.032	0.1 ms	SELECT	SELECT * FROM `form2_form_send_property` WHERE 0=1 [+] Explain

[+] Explain all