Database Queries

Всего 70 записей.
TimeDurationTypeQuery
  
01:01:23.1470.4 msSELECTSELECT * FROM `cms_content_element` WHERE `id`='290'

01:01:23.1490.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=4

01:01:23.1500.2 msSELECTSELECT * FROM `cms_tree` WHERE `id`=114

01:01:23.1511.4 msSELECTSELECT * FROM `cms_tree` WHERE `cms_tree`.`id` IN ('1', '18', '35')

01:01:23.1540.9 msSELECTSELECT * FROM `cms_site` WHERE (`code`='s1') AND (`active`='Y')

01:01:23.1560.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=4

01:01:23.1561.0 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=4 ORDER BY `priority`

01:01:23.1620.5 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=290

01:01:23.1660.6 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=2395

01:01:23.1670.3 msSELECTSELECT * FROM `cms_content_element_image` WHERE `content_element_id`=290

01:01:23.1690.7 msSELECTSELECT * FROM `cms_storage_file` WHERE `id` IN (2396, 2397, 2953, 2954, 2955, 2956, 2990, 2991, 2992, 2993, 2994, 2995, 2996, 2997, 2998)

01:01:23.1710.3 msSELECTSELECT * FROM `cms_content_element` WHERE `id`=''

01:01:23.1730.6 msSELECTSELECT * FROM `cms_tree` WHERE `id`=114

01:01:23.1901.4 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` WHERE (`cms_content_element`.`active`='Y') AND (`cms_content_element`.`content_id`='4') AND ((`cms_content_element`.`tree_id` IN ('38', '101', '106', '39', '98', '105', '102', '43', '42', '104', '40', '112')) OR (`cms_content_element_tree`.`tree_id` IN ('38', '101', '106', '39', '98', '105', '102', '43', '42', '104', '40', '112'))) AND (`cms_content_element`.`published_at` <= '1736546483') AND ((`cms_content_element`.`published_to` >= '1736546483') OR (`cms_content_element`.`published_to` IS NULL)) GROUP BY `cms_content_element`.`id` ORDER BY `published_at` DESC

01:01:23.1930.5 msSELECTSELECT * FROM `cms_storage_file` WHERE `id` IN (2691, 2388, 2357, 2332, 2641, 2303, 2292, 2276, 2249, 2232, 2230, 2964, 2214, 2204, 2171, 2166, 2159, 2154, 2150, 2148, 2126, 2119, 2530, 2104, 2093, 2058, 1650, 1784, 1780, 1852, 1765, 2101, 1762, 2070, 2403, 2706, 1756, 2759)

01:01:23.1940.4 msSELECTSELECT * FROM `cms_tree` WHERE `id` IN (102, 112, 42, 98, 105, 101, 40, 43, 104, 106, 38, 39)

01:01:23.1950.6 msSELECTSELECT * FROM `cms_content_element_tree` WHERE `element_id` IN (315, 289, 285, 284, 283, 282, 281, 279, 278, 277, 276, 275, 274, 273, 272, 271, 270, 269, 268, 267, 266, 265, 263, 262, 261, 260, 176, 251, 250, 78, 249, 84, 248, 247, 240, 244, 246, 245)

01:01:23.1950.4 msSHOWSHOW FULL COLUMNS FROM `cms_content_element_tree`
01:01:23.1960.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_tree' AND kcu.table_name = 'cms_content_element_tree'

01:01:23.2170.3 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=2958

01:01:23.2180.7 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`=114) AND (`cms_content_element`.`id` != 290) GROUP BY `cms_content_element`.`id` ORDER BY `published_at` DESC LIMIT 8

01:01:23.2190.1 msSELECTSELECT * FROM `form2_form` WHERE `code`='rent_shater'

01:01:23.2200.1 msSELECTSELECT * FROM `form2_form` WHERE `id`=5

01:01:23.2200.1 msSELECTSELECT * FROM `form2_form_property` WHERE `form_id`=5 ORDER BY `priority`

01:01:23.2210.1 msSELECTSELECT * FROM `form2_form_send_property` WHERE 0=1

01:01:23.2220.1 msSELECTSELECT * FROM `form2_form` WHERE `code`='buy_shater'

01:01:23.2220.1 msSELECTSELECT * FROM `form2_form` WHERE `id`=4

01:01:23.2220.1 msSELECTSELECT * FROM `form2_form_property` WHERE `form_id`=4 ORDER BY `priority`

01:01:23.2220.1 msSELECTSELECT * FROM `form2_form_send_property` WHERE 0=1

01:01:23.2230.1 msSELECTSELECT * FROM `form2_form` WHERE `code`='make_request'

01:01:23.2230.1 msSELECTSELECT * FROM `form2_form` WHERE `id`=6

01:01:23.2230.1 msSELECTSELECT * FROM `form2_form_property` WHERE `form_id`=6 ORDER BY `priority`

01:01:23.2240.1 msSELECTSELECT * FROM `form2_form_send_property` WHERE 0=1

01:01:23.2250.4 msSELECTSELECT * FROM `cms_tree` WHERE `cms_tree`.`id`='1'

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

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

01:01:23.2270.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=35

01:01:23.2270.3 msSELECTSELECT * FROM `cms_tree` WHERE `pid`=35 ORDER BY `priority`

01:01:23.2280.2 msSELECTSELECT * FROM `cms_tree` WHERE (`active`='Y') AND (`pid`=35) ORDER BY `priority`

01:01:23.2293.7 msSELECTSELECT * FROM `cms_tree` WHERE `id`=36

01:01:23.2330.5 msSELECTSELECT * FROM `cms_tree` WHERE `pid`=36 ORDER BY `priority`

01:01:23.2340.3 msSELECTSELECT * FROM `cms_tree` WHERE (`active`='Y') AND (`pid`=36) ORDER BY `priority`

01:01:23.2350.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=37

01:01:23.2350.3 msSELECTSELECT * FROM `cms_tree` WHERE `pid`=37 ORDER BY `priority`

01:01:23.2385.9 msSELECTSELECT * FROM `cms_tree` WHERE (`active`='Y') AND (`pid`=37) ORDER BY `priority`

01:01:23.2450.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=71

01:01:23.2450.2 msSELECTSELECT * FROM `cms_tree` WHERE `pid`=71 ORDER BY `priority`

01:01:23.2460.1 msSELECTSELECT * FROM `cms_tree` WHERE (`active`='Y') AND (`pid`=71) ORDER BY `priority`

01:01:23.2460.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=63

01:01:23.2460.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=69

01:01:23.2470.1 msSELECTSELECT * FROM `cms_tree` WHERE 0=1

01:01:23.2470.1 msSELECTSELECT * FROM `cms_tree` WHERE (`active`='Y') AND (`pid`=7) ORDER BY `priority`

01:01:23.2470.1 msSELECTSELECT * FROM `cms_tree` WHERE 0=1

01:01:23.2470.1 msSELECTSELECT * FROM `cms_tree` WHERE 0=1

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

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

01:01:23.2630.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=35

01:01:23.2630.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=36

01:01:23.2630.3 msSELECTSELECT * FROM `cms_tree` WHERE `id`=37

01:01:23.2640.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=71

01:01:23.2800.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`

01:01:23.2810.6 msSELECTSELECT * FROM `cms_tree` WHERE `pid` IN (35, 36, 37, 71) ORDER BY `priority`

01:01:23.2840.1 msSELECTSELECT * FROM `form2_form` WHERE `code`='callback'

01:01:23.2840.1 msSELECTSELECT * FROM `form2_form` WHERE `id`=3

01:01:23.2840.1 msSELECTSELECT * FROM `form2_form_property` WHERE `form_id`=3 ORDER BY `priority`

01:01:23.2850.1 msSELECTSELECT * FROM `form2_form_send_property` WHERE 0=1

01:01:23.2850.1 msSELECTSELECT * FROM `form2_form` WHERE `code`='feedback'

01:01:23.2850.1 msSELECTSELECT * FROM `form2_form` WHERE `id`=1

01:01:23.2860.0 msSELECTSELECT * FROM `form2_form_property` WHERE `form_id`=1 ORDER BY `priority`

01:01:23.2860.1 msSELECTSELECT * FROM `form2_form_send_property` WHERE 0=1