Database Queries

Всего 91 запись.
TimeDurationTypeQuery
  
06:27:40.4490.7 msSELECTSELECT * FROM `cms_tree` WHERE (`dir`='catalog/tip/shatry-dlya-provedeniya-meropriyatiy/prodaja') AND (`site_code`='s1')

06:27:40.4500.6 msSELECTSELECT * FROM `cms_tree` WHERE `id`=93

06:27:40.4510.6 msSELECTSELECT * FROM `cms_tree` WHERE `cms_tree`.`id` IN ('1', '18', '71', '83')

06:27:40.4520.4 msSELECTSELECT * FROM `cms_site` WHERE (`code`='s1') AND (`active`='Y')

06:27:40.4530.3 msSELECTSELECT * FROM `cms_tree_type` WHERE `id`=6

06:27:40.4790.1 msSELECTSELECT * FROM `cms_tree_type` WHERE `id`=6

06:27:40.4790.2 msSELECTSELECT * FROM `cms_tree_type_property` WHERE `tree_type_id`=6 ORDER BY `priority`

06:27:40.5040.3 msSELECTSELECT * FROM `cms_tree_property` WHERE `element_id`=93

06:27:40.5140.4 msSELECTSELECT * FROM `cms_tree` WHERE (`pid`=93) AND (`active`='Y') AND (`site_code`='s1') ORDER BY `priority`

06:27:40.5580.3 msSELECTSELECT * FROM `cms_content` WHERE `id` IS NULL

06:27:40.5720.4 msSELECTSELECT `id` FROM `cms_tree` WHERE (`pids` LIKE '1/18/71/83/93/%') OR (`pid`=93) ORDER BY `level`, `priority`

06:27:40.5722.1 msSELECTSELECT *, `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`=93) OR (`cms_content_element_tree`.`tree_id`=93)) AND (`cms_content_element`.`published_at` <= '1736566060') AND ((`cms_content_element`.`published_to` >= '1736566060') OR (`cms_content_element`.`published_to` IS NULL)) GROUP BY `cms_content_element`.`id`

06:27:40.5750.5 msSELECTSELECT * 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', '1530', '1527', '1524', '1521', '265', '268', '271', '274', '1585', '402', '1545', '408', '411', '412', '1640', '1613', '1610', '1607', '1597', '1604', '1601', '1667', '1024', '1483', '2403', '2706', '2759', '1756', '2070', '1762', '1765', '1780', '1784', '2276', '2292')

06:27:40.5750.2 msSELECTSELECT * FROM `cms_tree` WHERE `id`='93'

06:27:40.5760.7 msSELECTSELECT * FROM `cms_content_element_tree` WHERE `element_id` IN ('307', '302', '297', '292', '287', '182', '282', '277', '272', '267', '262', '257', '252', '246', '242', '237', '232', '227', '221', '217', '212', '207', '202', '197', '414', '410', '404', '402', '319', '376', '370', '364', '315', '492', '352', '358', '345', '310', '192', '489', '479', '469', '459', '449', '436', '187', '335', '668', '673', '687', '694', '703', '715', '726', '737', '748', '759', '803', '816')

06:27:40.5920.1 msSELECTSELECT * FROM `cms_storage_file` WHERE 0=1

06:27:40.5921.8 msSELECTSELECT 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`=93) OR (`cms_content_element_tree`.`tree_id`=93)) AND (`cms_content_element`.`published_at` <= '1736566060') AND ((`cms_content_element`.`published_to` >= '1736566060') OR (`cms_content_element`.`published_to` IS NULL)) GROUP BY `cms_content_element`.`id`) `c`

06:27:40.5942.0 msSELECTSELECT `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`=93) OR (`cms_content_element_tree`.`tree_id`=93)) AND (`cms_content_element`.`published_at` <= '1736566060') AND ((`cms_content_element`.`published_to` >= '1736566060') OR (`cms_content_element`.`published_to` IS NULL)) GROUP BY `cms_content_element`.`id` ORDER BY `published_at` DESC LIMIT 10

06:27:40.5970.3 msSELECTSELECT * FROM `cms_storage_file` WHERE `id` IN (2292, 2276, 1784, 1780, 1852, 1765, 2101, 1762, 2070, 2403)

06:27:40.6010.3 msSELECTSELECT * FROM `cms_tree` WHERE `id` IN (40, 43, 38)

06:27:40.6020.3 msSELECTSELECT * FROM `cms_content_element_tree` WHERE `element_id` IN (281, 279, 251, 250, 78, 249, 84, 248, 247, 240)

06:27:40.6030.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=4

06:27:40.6030.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=4 ORDER BY `priority`

06:27:40.6050.4 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=281

06:27:40.6170.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=4

06:27:40.6170.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=4 ORDER BY `priority`

06:27:40.6180.3 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=279

06:27:40.6190.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=4

06:27:40.6200.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=4 ORDER BY `priority`

06:27:40.6210.3 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=251

06:27:40.6220.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=4

06:27:40.6220.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=4 ORDER BY `priority`

06:27:40.6230.3 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=250

06:27:40.6240.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=4

06:27:40.6240.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=4 ORDER BY `priority`

06:27:40.6250.3 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=78

06:27:40.6260.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=4

06:27:40.6270.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=4 ORDER BY `priority`

06:27:40.6280.3 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=249

06:27:40.6290.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=4

06:27:40.6290.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=4 ORDER BY `priority`

06:27:40.6300.3 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=84

06:27:40.6310.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=4

06:27:40.6310.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=4 ORDER BY `priority`

06:27:40.6361.8 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=248

06:27:40.6390.9 msSELECTSELECT * FROM `cms_content` WHERE `id`=4

06:27:40.6400.5 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=4 ORDER BY `priority`

06:27:40.6411.7 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=247

06:27:40.6440.9 msSELECTSELECT * FROM `cms_content` WHERE `id`=4

06:27:40.6450.2 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=4 ORDER BY `priority`

06:27:40.6461.5 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=240

06:27:40.6491.6 msSELECTSELECT * FROM `cms_tree_image` WHERE `tree_id`=93

06:27:40.6500.1 msSELECTSELECT * FROM `cms_storage_file` WHERE 0=1

06:27:40.6500.2 msSELECTSELECT * FROM `cms_tree` WHERE `pid`=93 ORDER BY `priority`

06:27:40.6510.8 msSELECTSELECT * FROM `cms_tree` WHERE `cms_tree`.`id`='1'

06:27:40.6530.9 msSELECTSELECT * FROM `cms_tree` WHERE (`pid`='1') AND (`level`='1') AND (`active`='Y') AND (`site_code`='s1') ORDER BY `priority`

06:27:40.6540.4 msSELECTSELECT * FROM `cms_tree` WHERE `pid` IN (65, 66, 67, 76, 7, 8, 4) ORDER BY `priority`

06:27:40.6550.5 msSELECTSELECT * FROM `cms_tree` WHERE `id`=35

06:27:40.6550.4 msSELECTSELECT * FROM `cms_tree` WHERE `pid`=35 ORDER BY `priority`

06:27:40.6561.1 msSELECTSELECT * FROM `cms_tree` WHERE (`active`='Y') AND (`pid`=35) ORDER BY `priority`

06:27:40.6591.0 msSELECTSELECT * FROM `cms_tree` WHERE `id`=36

06:27:40.6600.3 msSELECTSELECT * FROM `cms_tree` WHERE `pid`=36 ORDER BY `priority`

06:27:40.6610.9 msSELECTSELECT * FROM `cms_tree` WHERE (`active`='Y') AND (`pid`=36) ORDER BY `priority`

06:27:40.6630.6 msSELECTSELECT * FROM `cms_tree` WHERE `id`=37

06:27:40.6640.3 msSELECTSELECT * FROM `cms_tree` WHERE `pid`=37 ORDER BY `priority`

06:27:40.6640.7 msSELECTSELECT * FROM `cms_tree` WHERE (`active`='Y') AND (`pid`=37) ORDER BY `priority`

06:27:40.6660.6 msSELECTSELECT * FROM `cms_tree` WHERE `id`=71

06:27:40.6660.4 msSELECTSELECT * FROM `cms_tree` WHERE `pid`=71 ORDER BY `priority`

06:27:40.6670.8 msSELECTSELECT * FROM `cms_tree` WHERE (`active`='Y') AND (`pid`=71) ORDER BY `priority`

06:27:40.6680.7 msSELECTSELECT * FROM `cms_tree` WHERE `id`=63

06:27:40.6690.2 msSELECTSELECT * FROM `cms_tree` WHERE `id`=69

06:27:40.6700.4 msSELECTSELECT * FROM `cms_tree` WHERE 0=1

06:27:40.6700.2 msSELECTSELECT * FROM `cms_tree` WHERE (`active`='Y') AND (`pid`=7) ORDER BY `priority`

06:27:40.6710.2 msSELECTSELECT * FROM `cms_tree` WHERE 0=1

06:27:40.6710.2 msSELECTSELECT * FROM `cms_tree` WHERE 0=1

06:27:40.6910.2 msSELECTSELECT * FROM `cms_tree` WHERE (`level`='1') AND (`active`='Y') AND (`site_code`='s1') ORDER BY `priority`

06:27:40.6910.1 msSELECTSELECT * FROM `cms_tree` WHERE `pid` IN (65, 66, 67, 76, 7, 8, 4) ORDER BY `priority`

06:27:40.6920.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=35

06:27:40.6920.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=36

06:27:40.6920.0 msSELECTSELECT * FROM `cms_tree` WHERE `id`=37

06:27:40.6920.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=71

06:27:40.7010.1 msSELECTSELECT * FROM `cms_tree` WHERE (`pid`='18') AND (`active`='Y') AND (`site_code`='s1') AND (`tree_type_id` IN ('2', '6')) ORDER BY `priority`

06:27:40.7010.4 msSELECTSELECT * FROM `cms_tree` WHERE `pid` IN (35, 36, 37, 71) ORDER BY `priority`

06:27:40.7080.1 msSELECTSELECT * FROM `form2_form` WHERE `code`='callback'

06:27:40.7090.1 msSELECTSELECT * FROM `form2_form` WHERE `id`=3

06:27:40.7090.1 msSELECTSELECT * FROM `form2_form_property` WHERE `form_id`=3 ORDER BY `priority`

06:27:40.7090.0 msSELECTSELECT * FROM `form2_form_send_property` WHERE 0=1

06:27:40.7100.1 msSELECTSELECT * FROM `form2_form` WHERE `code`='feedback'

06:27:40.7100.1 msSELECTSELECT * FROM `form2_form` WHERE `id`=1

06:27:40.7100.1 msSELECTSELECT * FROM `form2_form_property` WHERE `form_id`=1 ORDER BY `priority`

06:27:40.7110.1 msSELECTSELECT * FROM `form2_form_send_property` WHERE 0=1