Database Queries

Всего 172 записи.
TimeDurationTypeQuery
  
01:42:19.0671.6 msSELECTSELECT * FROM `cms_tree` WHERE (`site_code`='s1') AND (`level`=0)

01:42:19.1120.3 msSELECTSELECT * FROM `cms_tree` WHERE `id`=1

01:42:19.1130.1 msSELECTSELECT * FROM `cms_tree` WHERE 0=1

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

01:42:19.1130.4 msSELECTSELECT * FROM `cms_tree_type` WHERE `id`=1

01:42:19.1140.3 msSHOWSHOW FULL COLUMNS FROM `cms_tree_type`
01:42:19.1140.2 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'

01:42:19.1150.5 msSELECTSELECT * FROM `cms_content_element` WHERE `content_id`=10

01:42:19.1150.3 msSHOWSHOW FULL COLUMNS FROM `cms_content_element`
01:42:19.1160.2 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'

01:42:19.1170.4 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

01:42:19.1180.4 msSHOWSHOW FULL COLUMNS FROM `cms_content`
01:42:19.1180.2 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'

01:42:19.1180.5 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

01:42:19.1190.3 msSHOWSHOW FULL COLUMNS FROM `cms_content_property`
01:42:19.1190.2 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_property' AND kcu.table_name = 'cms_content_property'

01:42:19.1210.4 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=321

01:42:19.1210.3 msSHOWSHOW FULL COLUMNS FROM `cms_content_element_property`
01:42:19.1210.2 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_property' AND kcu.table_name = 'cms_content_element_property'

01:42:19.1220.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

01:42:19.1220.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

01:42:19.1230.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=326

01:42:19.1230.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

01:42:19.1230.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

01:42:19.1240.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=232

01:42:19.1240.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

01:42:19.1240.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

01:42:19.1250.3 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=320

01:42:19.1260.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

01:42:19.1260.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

01:42:19.1260.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=231

01:42:19.1270.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

01:42:19.1270.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

01:42:19.1280.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=319

01:42:19.1280.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

01:42:19.1280.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

01:42:19.1290.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=325

01:42:19.1290.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

01:42:19.1290.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

01:42:19.1300.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=233

01:42:19.1300.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

01:42:19.1300.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

01:42:19.1310.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=236

01:42:19.1310.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

01:42:19.1320.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

01:42:19.1320.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=229

01:42:19.1330.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

01:42:19.1330.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

01:42:19.1330.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=230

01:42:19.1340.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

01:42:19.1340.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

01:42:19.1350.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=235

01:42:19.1350.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

01:42:19.1350.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

01:42:19.1360.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=238

01:42:19.1360.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

01:42:19.1360.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

01:42:19.1370.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=327

01:42:19.1380.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

01:42:19.1380.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

01:42:19.1380.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=237

01:42:19.1390.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

01:42:19.1390.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

01:42:19.1400.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=234

01:42:19.1400.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

01:42:19.1400.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

01:42:19.1410.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=322

01:42:19.1410.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

01:42:19.1410.2 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

01:42:19.1420.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=226

01:42:19.1430.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

01:42:19.1430.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

01:42:19.1430.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=318

01:42:19.1440.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

01:42:19.1440.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

01:42:19.1470.3 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=324

01:42:19.1501.8 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

01:42:19.1520.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

01:42:19.1541.8 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=323

01:42:19.1560.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

01:42:19.1620.3 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

01:42:19.1630.5 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=227

01:42:19.1650.3 msSELECTSELECT `id` FROM `cms_tree` WHERE (`pids` LIKE '/1/%') OR (`pid`=1) ORDER BY `level`, `priority`

01:42:19.1951.2 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` <= '1736548939') AND ((`cms_content_element`.`published_to` >= '1736548939') OR (`cms_content_element`.`published_to` IS NULL)) GROUP BY `cms_content_element`.`id` ORDER BY `priority`

01:42:19.1970.5 msSELECTSELECT * FROM `cms_storage_file` WHERE `id` IN (2948, 2864, 2865, 2867, 2863, 2868, 2971)

01:42:19.1970.4 msSHOWSHOW FULL COLUMNS FROM `cms_storage_file`
01:42:19.1980.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_storage_file' AND kcu.table_name = 'cms_storage_file'

01:42:19.1980.2 msSELECTSELECT * FROM `cms_tree` WHERE `id`=1

01:42:19.1990.3 msSELECTSELECT * FROM `cms_content_element_tree` WHERE `element_id` IN (330, 287, 288, 286, 317, 329, 331)

01:42:19.2200.2 msSELECTSELECT * FROM `cms_content` WHERE `id`=9

01:42:19.2200.2 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=9 ORDER BY `priority`

01:42:19.2200.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=330

01:42:19.2210.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=9

01:42:19.2210.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=9 ORDER BY `priority`

01:42:19.2210.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=287

01:42:19.2220.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=9

01:42:19.2220.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=9 ORDER BY `priority`

01:42:19.2220.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=288

01:42:19.2220.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=9

01:42:19.2230.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=9 ORDER BY `priority`

01:42:19.2230.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=286

01:42:19.2230.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=9

01:42:19.2230.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=9 ORDER BY `priority`

01:42:19.2240.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=317

01:42:19.2240.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=9

01:42:19.2240.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=9 ORDER BY `priority`

01:42:19.2240.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=329

01:42:19.2250.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=9

01:42:19.2250.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=9 ORDER BY `priority`

01:42:19.2250.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=331

01:42:19.3050.5 msSELECTSELECT * FROM `cms_tree` WHERE (`pid`='35') AND (`active`='Y') AND (`site_code`='s1') AND (`tree_type_id`='6') ORDER BY `priority`

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

01:42:19.3070.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=2380

01:42:19.3070.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=2959

01:42:19.3070.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=1407

01:42:19.3080.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=1402

01:42:19.3080.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=1404

01:42:19.3080.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=2365

01:42:19.3090.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=2782

01:42:19.3090.2 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=2707

01:42:19.3090.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=2639

01:42:19.3090.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=2701

01:42:19.3100.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=1406

01:42:19.3100.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=2360

01:42:19.3100.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=1409

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

01:42:19.3600.2 msSELECTSELECT * FROM `cms_tree` WHERE `pid` IN (57, 111, 58, 59, 62, 61) ORDER BY `priority`

01:42:19.3600.2 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=1463

01:42:19.3610.2 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=1788

01:42:19.3610.2 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=1790

01:42:19.3610.2 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=1789

01:42:19.3620.3 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=353

01:42:19.3620.2 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=352

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

01:42:19.3630.1 msSELECTSELECT * FROM `cms_tree` WHERE `pid` IN (57, 111, 58, 59, 62, 61) ORDER BY `priority`

01:42:19.3660.1 msSELECTSELECT * FROM `cms_tree` WHERE 0=1

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

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

01:42:19.3680.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=35

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

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

01:42:19.3720.5 msSELECTSELECT * FROM `cms_tree` WHERE `id`=36

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

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

01:42:19.3770.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=37

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

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

01:42:19.3790.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=71

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

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

01:42:19.3800.6 msSELECTSELECT * FROM `cms_tree` WHERE `id`=63

01:42:19.3800.4 msSELECTSELECT * FROM `cms_tree` WHERE `id`=69

01:42:19.3810.3 msSELECTSELECT * FROM `cms_tree` WHERE 0=1

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

01:42:19.3820.1 msSELECTSELECT * FROM `cms_tree` WHERE 0=1

01:42:19.3820.7 msSELECTSELECT * FROM `cms_tree` WHERE 0=1

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

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

01:42:19.4210.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=35

01:42:19.4210.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=36

01:42:19.4210.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=37

01:42:19.4220.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=71

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

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

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

01:42:19.5190.1 msSELECTSELECT * FROM `form2_form` WHERE `id`=3

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

01:42:19.5390.1 msSELECTSELECT * FROM `form2_form_send_property` WHERE 0=1

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

01:42:19.5400.0 msSELECTSELECT * FROM `form2_form` WHERE `id`=1

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

01:42:19.5400.1 msSELECTSELECT * FROM `form2_form_send_property` WHERE 0=1