Database Queries

Всего 164 записи.
TimeDurationTypeQuery
  
18:25:38.0480.7 msSELECTSELECT * FROM `cms_tree` WHERE (`site_code`='s1') AND (`level`=0)

18:25:38.0490.3 msSELECTSELECT * FROM `cms_tree` WHERE `id`=1

18:25:38.0500.1 msSELECTSELECT * FROM `cms_tree` WHERE 0=1

18:25:38.0500.1 msSELECTSELECT * FROM `cms_site` WHERE (`code`='s1') AND (`active`='Y')

18:25:38.0510.2 msSELECTSELECT * FROM `cms_tree_type` WHERE `id`=1

18:25:38.0510.4 msSHOWSHOW FULL COLUMNS FROM `cms_tree_type`
18:25:38.0510.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_tree_type' AND kcu.table_name = 'cms_tree_type'

18:25:38.0520.3 msSELECTSELECT * FROM `cms_content_element` WHERE `content_id`=10

18:25:38.0540.2 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

18:25:38.0550.3 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

18:25:38.0560.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=321

18:25:38.0570.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

18:25:38.0570.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

18:25:38.0580.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=326

18:25:38.0590.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

18:25:38.0590.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

18:25:38.0600.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=232

18:25:38.0600.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

18:25:38.0600.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

18:25:38.0730.7 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=320

18:25:38.0740.4 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

18:25:38.0750.3 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

18:25:38.0760.5 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=231

18:25:38.0770.3 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

18:25:38.0770.2 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

18:25:38.0780.7 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=319

18:25:38.0790.4 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

18:25:38.0790.3 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

18:25:38.0800.4 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=325

18:25:38.0810.3 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

18:25:38.0810.2 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

18:25:38.0820.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=233

18:25:38.0830.3 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

18:25:38.0830.4 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

18:25:38.0840.5 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=236

18:25:38.0850.3 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

18:25:38.0850.2 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

18:25:38.0870.6 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=229

18:25:38.0880.3 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

18:25:38.0880.3 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

18:25:38.0891.0 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=230

18:25:38.0910.8 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

18:25:38.0920.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

18:25:38.0931.0 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=235

18:25:38.0940.5 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

18:25:38.0950.3 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

18:25:38.0961.1 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=238

18:25:38.0980.2 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

18:25:38.0990.3 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

18:25:38.1000.7 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=327

18:25:38.1010.6 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

18:25:38.1020.3 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

18:25:38.1031.1 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=237

18:25:38.1040.6 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

18:25:38.1050.2 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

18:25:38.1060.9 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=234

18:25:38.1070.6 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

18:25:38.1080.5 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

18:25:38.1090.5 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=322

18:25:38.1100.8 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

18:25:38.1110.2 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

18:25:38.1121.0 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=226

18:25:38.1130.3 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

18:25:38.1140.3 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

18:25:38.1150.9 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=318

18:25:38.1160.8 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

18:25:38.1170.2 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

18:25:38.1214.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=324

18:25:38.1260.5 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

18:25:38.1270.3 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

18:25:38.1281.0 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=323

18:25:38.1290.5 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

18:25:38.1300.3 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

18:25:38.1310.6 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=227

18:25:38.1320.4 msSELECTSELECT `id` FROM `cms_tree` WHERE (`pids` LIKE '/1/%') OR (`pid`=1) ORDER BY `level`, `priority`

18:25:38.1410.8 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`='9') AND ((`cms_content_element`.`tree_id` IN (65, 66, 67, 76, 18, 7, 8, 4, 50, 51, 64, 53, 1)) OR (`cms_content_element_tree`.`tree_id` IN (65, 66, 67, 76, 18, 7, 8, 4, 50, 51, 64, 53, 1))) AND (`cms_content_element`.`published_at` <= '1737559538') AND ((`cms_content_element`.`published_to` >= '1737559538') OR (`cms_content_element`.`published_to` IS NULL)) GROUP BY `cms_content_element`.`id` ORDER BY `priority`

18:25:38.1420.2 msSELECTSELECT * FROM `cms_storage_file` WHERE `id` IN (2948, 2864, 2865, 2867, 2863, 2868, 2971)

18:25:38.1430.3 msSELECTSELECT * FROM `cms_tree` WHERE `id`=1

18:25:38.1430.3 msSELECTSELECT * FROM `cms_content_element_tree` WHERE `element_id` IN (330, 287, 288, 286, 317, 329, 331)

18:25:38.1440.3 msSHOWSHOW FULL COLUMNS FROM `cms_content_element_tree`
18:25:38.1440.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'

18:25:38.1450.3 msSELECTSELECT * FROM `cms_content` WHERE `id`=9

18:25:38.1450.2 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=9 ORDER BY `priority`

18:25:38.1460.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=330

18:25:38.1460.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=9

18:25:38.1460.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=9 ORDER BY `priority`

18:25:38.1470.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=287

18:25:38.1470.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=9

18:25:38.1470.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=9 ORDER BY `priority`

18:25:38.1470.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=288

18:25:38.1480.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=9

18:25:38.1480.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=9 ORDER BY `priority`

18:25:38.1480.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=286

18:25:38.1490.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=9

18:25:38.1490.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=9 ORDER BY `priority`

18:25:38.1490.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=317

18:25:38.1500.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=9

18:25:38.1500.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=9 ORDER BY `priority`

18:25:38.1500.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=329

18:25:38.1500.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=9

18:25:38.1510.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=9 ORDER BY `priority`

18:25:38.1510.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=331

18:25:38.1680.5 msSELECTSELECT * FROM `cms_tree` WHERE (`pid`='35') AND (`active`='Y') AND (`site_code`='s1') AND (`tree_type_id`='6') ORDER BY `priority`

18:25:38.1690.3 msSELECTSELECT * FROM `cms_tree` WHERE `pid` IN (112, 114, 42, 38, 40, 106, 39, 98, 105, 102, 43, 104, 101) ORDER BY `priority`

18:25:38.1690.2 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=2380

18:25:38.1700.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=2959

18:25:38.1700.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=1407

18:25:38.1700.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=1402

18:25:38.1710.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=1404

18:25:38.1710.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=2365

18:25:38.1710.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=2782

18:25:38.1720.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=2707

18:25:38.1720.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=2639

18:25:38.1720.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=2701

18:25:38.1720.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=1406

18:25:38.1730.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=2360

18:25:38.1730.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=1409

18:25:38.1830.5 msSELECTSELECT * FROM `cms_tree` WHERE (`pid`='37') AND (`active`='Y') AND (`site_code`='s1') ORDER BY `priority`

18:25:38.1830.2 msSELECTSELECT * FROM `cms_tree` WHERE `pid` IN (57, 111, 58, 59, 62, 61) ORDER BY `priority`

18:25:38.1840.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=1463

18:25:38.1840.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=1788

18:25:38.1840.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=1790

18:25:38.1840.2 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=1789

18:25:38.1850.2 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=353

18:25:38.1850.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=352

18:25:38.1850.2 msSELECTSELECT * FROM `cms_tree` WHERE (`pid`='37') AND (`active`='Y') AND (`site_code`='s1') ORDER BY `priority`

18:25:38.1860.1 msSELECTSELECT * FROM `cms_tree` WHERE `pid` IN (57, 111, 58, 59, 62, 61) ORDER BY `priority`

18:25:38.1870.1 msSELECTSELECT * FROM `cms_tree` WHERE 0=1

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

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

18:25:38.1900.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=35

18:25:38.1900.2 msSELECTSELECT * FROM `cms_tree` WHERE `pid`=35 ORDER BY `priority`

18:25:38.1920.2 msSELECTSELECT * FROM `cms_tree` WHERE (`active`='Y') AND (`pid`=35) ORDER BY `priority`

18:25:38.1930.2 msSELECTSELECT * FROM `cms_tree` WHERE `id`=36

18:25:38.1930.2 msSELECTSELECT * FROM `cms_tree` WHERE `pid`=36 ORDER BY `priority`

18:25:38.1940.9 msSELECTSELECT * FROM `cms_tree` WHERE (`active`='Y') AND (`pid`=36) ORDER BY `priority`

18:25:38.1971.7 msSELECTSELECT * FROM `cms_tree` WHERE `id`=37

18:25:38.1990.4 msSELECTSELECT * FROM `cms_tree` WHERE `pid`=37 ORDER BY `priority`

18:25:38.2001.0 msSELECTSELECT * FROM `cms_tree` WHERE (`active`='Y') AND (`pid`=37) ORDER BY `priority`

18:25:38.2010.4 msSELECTSELECT * FROM `cms_tree` WHERE `id`=71

18:25:38.2022.2 msSELECTSELECT * FROM `cms_tree` WHERE `pid`=71 ORDER BY `priority`

18:25:38.2050.3 msSELECTSELECT * FROM `cms_tree` WHERE (`active`='Y') AND (`pid`=71) ORDER BY `priority`

18:25:38.2060.3 msSELECTSELECT * FROM `cms_tree` WHERE `id`=63

18:25:38.2060.8 msSELECTSELECT * FROM `cms_tree` WHERE `id`=69

18:25:38.2080.1 msSELECTSELECT * FROM `cms_tree` WHERE 0=1

18:25:38.2080.1 msSELECTSELECT * FROM `cms_tree` WHERE (`active`='Y') AND (`pid`=7) ORDER BY `priority`

18:25:38.2080.1 msSELECTSELECT * FROM `cms_tree` WHERE 0=1

18:25:38.2080.4 msSELECTSELECT * FROM `cms_tree` WHERE 0=1

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

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

18:25:38.2260.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=35

18:25:38.2260.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=36

18:25:38.2270.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=37

18:25:38.2270.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=71

18:25:38.2430.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`

18:25:38.2441.1 msSELECTSELECT * FROM `cms_tree` WHERE `pid` IN (35, 36, 37, 71) ORDER BY `priority`

18:25:38.2542.8 msSELECTSELECT * FROM `form2_form` WHERE `code`='callback'

18:25:38.2570.5 msSELECTSELECT * FROM `form2_form` WHERE `id`=3

18:25:38.2580.1 msSELECTSELECT * FROM `form2_form_property` WHERE `form_id`=3 ORDER BY `priority`

18:25:38.2580.4 msSELECTSELECT * FROM `form2_form_send_property` WHERE 0=1

18:25:38.2590.8 msSELECTSELECT * FROM `form2_form` WHERE `code`='feedback'

18:25:38.2600.3 msSELECTSELECT * FROM `form2_form` WHERE `id`=1

18:25:38.2610.2 msSELECTSELECT * FROM `form2_form_property` WHERE `form_id`=1 ORDER BY `priority`

18:25:38.2610.3 msSELECTSELECT * FROM `form2_form_send_property` WHERE 0=1