Database Queries

Всего 70 записей.
TimeDurationTypeQuery
  
03:44:16.4190.4 msSELECTSELECT * FROM `cms_content_element` WHERE `id`='16'

03:44:16.4190.4 msSHOWSHOW FULL COLUMNS FROM `cms_content_element`
03:44:16.4200.3 msSELECTSELECT 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' AND kcu.table_name = 'cms_content_element'

03:44:16.4210.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=4

03:44:16.4210.4 msSHOWSHOW FULL COLUMNS FROM `cms_content`
03:44:16.4220.3 msSELECTSELECT 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' AND kcu.table_name = 'cms_content'

03:44:16.4220.1 msSELECTSELECT * FROM `cms_tree` WHERE 0=1

03:44:16.4230.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=4

03:44:16.4230.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=4 ORDER BY `priority`

03:44:16.4240.3 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=16

03:44:16.4250.2 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=45

03:44:16.4260.2 msSELECTSELECT * FROM `cms_content_element_image` WHERE `content_element_id`=16

03:44:16.4270.4 msSELECTSELECT * FROM `cms_storage_file` WHERE `id` IN (793, 795, 797, 799, 801, 803, 805, 807, 809, 811, 813, 815, 817, 819, 821, 823, 825, 827, 829, 831, 833, 835, 837, 839, 840, 842, 843, 844, 845, 846, 847, 848, 849, 850, 851, 852, 853, 854, 855, 856, 857, 858, 859, 860)

03:44:16.4290.1 msSELECTSELECT * FROM `cms_tree` WHERE `id` IS NULL

03:44:16.5631.6 msSELECTSELECT COUNT(*) FROM (SELECT * FROM `cms_content_element` WHERE (`cms_content_element`.`published_at` <= '1736642656') AND ((`cms_content_element`.`published_to` >= '1736642656') OR (`cms_content_element`.`published_to` IS NULL)) GROUP BY `cms_content_element`.`id`) `c`

03:44:16.5650.7 msSELECTSELECT * FROM `cms_content_element` WHERE (`cms_content_element`.`published_at` <= '1736642656') AND ((`cms_content_element`.`published_to` >= '1736642656') OR (`cms_content_element`.`published_to` IS NULL)) GROUP BY `cms_content_element`.`id` ORDER BY `published_at` DESC LIMIT 10 OFFSET 40

03:44:16.5660.3 msSELECTSELECT * FROM `cms_storage_file` WHERE `id` IN (2445, 2434, 2395, 2867, 2388, 2865, 2864, 2357, 2332, 2641)

03:44:16.5670.3 msSELECTSELECT * FROM `cms_tree` WHERE `id` IN (109, 114, 1, 112, 42, 98, 105)

03:44:16.5690.1 msSELECTSELECT * FROM `cms_site` WHERE (`code`='s1') AND (`active`='Y')

03:44:16.5710.4 msSELECTSELECT * FROM `cms_content_element` WHERE `id`=16

03:44:16.5710.1 msSELECTSELECT * FROM `cms_tree` WHERE 0=1

03:44:16.5881.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 `cms_content_element_property` `map` ON `cms_content_element`.`id` = `map`.`element_id` LEFT JOIN `cms_content_element_property` ON `cms_content_element`.`id` = `cms_content_element_property`.`element_id` LEFT JOIN `cms_content_property` `property` ON `cms_content_element_property`.`property_id` = `property`.`id` WHERE (`cms_content_element`.`active`='Y') AND (`cms_content_element`.`content_id`='4') AND ((`cms_content_element`.`tree_id`='112') OR (`cms_content_element_tree`.`tree_id`='112')) AND (`cms_content_element`.`tree_id` IS NULL) AND (`cms_content_element`.`id` != 16) GROUP BY `cms_content_element`.`id` ORDER BY `published_at` DESC LIMIT 8

03:44:16.5890.1 msSELECTSELECT * FROM `form2_form` WHERE `code`='rent_shater'

03:44:16.5900.1 msSELECTSELECT * FROM `form2_form` WHERE `id`=5

03:44:16.5900.1 msSELECTSELECT * FROM `form2_form_property` WHERE `form_id`=5 ORDER BY `priority`

03:44:16.5910.1 msSELECTSELECT * FROM `form2_form_send_property` WHERE 0=1

03:44:16.5920.1 msSELECTSELECT * FROM `form2_form` WHERE `code`='buy_shater'

03:44:16.5920.1 msSELECTSELECT * FROM `form2_form` WHERE `id`=4

03:44:16.5920.1 msSELECTSELECT * FROM `form2_form_property` WHERE `form_id`=4 ORDER BY `priority`

03:44:16.5920.1 msSELECTSELECT * FROM `form2_form_send_property` WHERE 0=1

03:44:16.5930.1 msSELECTSELECT * FROM `form2_form` WHERE `code`='make_request'

03:44:16.5930.1 msSELECTSELECT * FROM `form2_form` WHERE `id`=6

03:44:16.5940.1 msSELECTSELECT * FROM `form2_form_property` WHERE `form_id`=6 ORDER BY `priority`

03:44:16.5940.1 msSELECTSELECT * FROM `form2_form_send_property` WHERE 0=1

03:44:16.6280.2 msSELECTSELECT * FROM `cms_tree` WHERE (`pid`='1') AND (`level`='1') AND (`active`='Y') AND (`site_code`='s1') ORDER BY `priority`

03:44:16.6280.1 msSELECTSELECT * FROM `cms_tree` WHERE `pid` IN (65, 66, 67, 76, 7, 8, 4) ORDER BY `priority`

03:44:16.6290.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=35

03:44:16.6290.2 msSELECTSELECT * FROM `cms_tree` WHERE `pid`=35 ORDER BY `priority`

03:44:16.6300.2 msSELECTSELECT * FROM `cms_tree` WHERE (`active`='Y') AND (`pid`=35) ORDER BY `priority`

03:44:16.6310.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=36

03:44:16.6310.2 msSELECTSELECT * FROM `cms_tree` WHERE `pid`=36 ORDER BY `priority`

03:44:16.6320.1 msSELECTSELECT * FROM `cms_tree` WHERE (`active`='Y') AND (`pid`=36) ORDER BY `priority`

03:44:16.6330.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=37

03:44:16.6330.2 msSELECTSELECT * FROM `cms_tree` WHERE `pid`=37 ORDER BY `priority`

03:44:16.6340.2 msSELECTSELECT * FROM `cms_tree` WHERE (`active`='Y') AND (`pid`=37) ORDER BY `priority`

03:44:16.6340.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=71

03:44:16.6350.3 msSELECTSELECT * FROM `cms_tree` WHERE `pid`=71 ORDER BY `priority`

03:44:16.6350.2 msSELECTSELECT * FROM `cms_tree` WHERE (`active`='Y') AND (`pid`=71) ORDER BY `priority`

03:44:16.6360.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=63

03:44:16.6360.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=69

03:44:16.6370.1 msSELECTSELECT * FROM `cms_tree` WHERE 0=1

03:44:16.6370.1 msSELECTSELECT * FROM `cms_tree` WHERE (`active`='Y') AND (`pid`=7) ORDER BY `priority`

03:44:16.6370.1 msSELECTSELECT * FROM `cms_tree` WHERE 0=1

03:44:16.6370.1 msSELECTSELECT * FROM `cms_tree` WHERE 0=1

03:44:16.6650.2 msSELECTSELECT * FROM `cms_tree` WHERE (`level`='1') AND (`active`='Y') AND (`site_code`='s1') ORDER BY `priority`

03:44:16.6660.2 msSELECTSELECT * FROM `cms_tree` WHERE `pid` IN (65, 66, 67, 76, 7, 8, 4) ORDER BY `priority`

03:44:16.6660.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=35

03:44:16.6660.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=36

03:44:16.6670.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=37

03:44:16.6670.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=71

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

03:44:16.6890.9 msSELECTSELECT * FROM `cms_tree` WHERE `pid` IN (35, 36, 37, 71) ORDER BY `priority`

03:44:16.6930.1 msSELECTSELECT * FROM `form2_form` WHERE `code`='callback'

03:44:16.6930.1 msSELECTSELECT * FROM `form2_form` WHERE `id`=3

03:44:16.6930.1 msSELECTSELECT * FROM `form2_form_property` WHERE `form_id`=3 ORDER BY `priority`

03:44:16.6930.1 msSELECTSELECT * FROM `form2_form_send_property` WHERE 0=1

03:44:16.6940.1 msSELECTSELECT * FROM `form2_form` WHERE `code`='feedback'

03:44:16.6940.1 msSELECTSELECT * FROM `form2_form` WHERE `id`=1

03:44:16.6940.1 msSELECTSELECT * FROM `form2_form_property` WHERE `form_id`=1 ORDER BY `priority`

03:44:16.6950.0 msSELECTSELECT * FROM `form2_form_send_property` WHERE 0=1