Database Queries

Всего 171 запись.
TimeDurationTypeQuery
  
07:28:08.2431.2 msSELECTSELECT * FROM `cms_tree` WHERE `id`=1

07:28:08.2450.5 msSELECTSELECT * FROM `cms_tree` WHERE 0=1

07:28:08.2460.2 msSELECTSELECT * FROM `cms_site` WHERE (`code`='s1') AND (`active`='Y')

07:28:08.2460.2 msSELECTSELECT * FROM `cms_tree_type` WHERE `id`=1

07:28:08.2460.4 msSHOWSHOW FULL COLUMNS FROM `cms_tree_type`
07:28:08.2470.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'

07:28:08.2470.3 msSELECTSELECT * FROM `cms_content_element` WHERE `content_id`=10

07:28:08.2480.3 msSHOWSHOW FULL COLUMNS FROM `cms_content_element`
07:28:08.2480.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'

07:28:08.2491.0 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

07:28:08.2510.4 msSHOWSHOW FULL COLUMNS FROM `cms_content`
07:28:08.2510.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'

07:28:08.2510.2 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

07:28:08.2520.3 msSHOWSHOW FULL COLUMNS FROM `cms_content_property`
07:28:08.2520.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_property' AND kcu.table_name = 'cms_content_property'

07:28:08.2530.8 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=321

07:28:08.2540.3 msSHOWSHOW FULL COLUMNS FROM `cms_content_element_property`
07:28:08.2540.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_property' AND kcu.table_name = 'cms_content_element_property'

07:28:08.2550.3 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

07:28:08.2550.2 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

07:28:08.2560.7 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=326

07:28:08.2570.4 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

07:28:08.2570.3 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

07:28:08.2580.7 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=232

07:28:08.2590.4 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

07:28:08.2600.2 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

07:28:08.2600.7 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=320

07:28:08.2610.6 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

07:28:08.2620.2 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

07:28:08.2630.7 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=231

07:28:08.2640.2 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

07:28:08.2640.2 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

07:28:08.2650.7 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=319

07:28:08.2660.4 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

07:28:08.2670.2 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

07:28:08.2670.7 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=325

07:28:08.2680.4 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

07:28:08.2690.2 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

07:28:08.2700.1 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=233

07:28:08.2700.4 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

07:28:08.2710.2 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

07:28:08.2720.7 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=236

07:28:08.2720.4 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

07:28:08.2730.2 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

07:28:08.2740.7 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=229

07:28:08.2750.4 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

07:28:08.2750.2 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

07:28:08.2760.9 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=230

07:28:08.2770.4 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

07:28:08.2780.2 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

07:28:08.2780.7 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=235

07:28:08.2790.4 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

07:28:08.2800.2 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

07:28:08.2800.7 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=238

07:28:08.2810.5 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

07:28:08.2820.2 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

07:28:08.2820.7 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=327

07:28:08.2830.4 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

07:28:08.2840.2 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

07:28:08.2850.7 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=237

07:28:08.2860.4 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

07:28:08.2860.2 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

07:28:08.2870.7 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=234

07:28:08.2880.4 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

07:28:08.2880.2 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

07:28:08.2890.3 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=322

07:28:08.2900.2 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

07:28:08.2900.3 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

07:28:08.2920.1 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=226

07:28:08.2920.5 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

07:28:08.2930.2 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

07:28:08.2940.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=318

07:28:08.2950.4 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

07:28:08.2950.2 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

07:28:08.2983.1 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=324

07:28:08.3010.5 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

07:28:08.3020.2 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

07:28:08.3030.7 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=323

07:28:08.3040.4 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

07:28:08.3040.2 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

07:28:08.3050.7 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=227

07:28:08.3071.5 msSELECTSELECT `id` FROM `cms_tree` WHERE (`pids` LIKE '/1/%') OR (`pid`=1) ORDER BY `level`, `priority`

07:28:08.3200.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` <= '1736569688') AND ((`cms_content_element`.`published_to` >= '1736569688') OR (`cms_content_element`.`published_to` IS NULL)) GROUP BY `cms_content_element`.`id` ORDER BY `priority`

07:28:08.3210.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id` IN (2948, 2864, 2865, 2867, 2863, 2868, 2971)

07:28:08.3210.3 msSHOWSHOW FULL COLUMNS FROM `cms_storage_file`
07:28:08.3220.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_storage_file' AND kcu.table_name = 'cms_storage_file'

07:28:08.3220.3 msSELECTSELECT * FROM `cms_tree` WHERE `id`=1

07:28:08.3230.1 msSELECTSELECT * FROM `cms_content_element_tree` WHERE `element_id` IN (330, 287, 288, 286, 317, 329, 331)

07:28:08.3240.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=9

07:28:08.3240.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=9 ORDER BY `priority`

07:28:08.3240.1 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=330

07:28:08.3240.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=9

07:28:08.3240.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=9 ORDER BY `priority`

07:28:08.3250.1 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=287

07:28:08.3250.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=9

07:28:08.3250.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=9 ORDER BY `priority`

07:28:08.3250.1 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=288

07:28:08.3260.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=9

07:28:08.3260.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=9 ORDER BY `priority`

07:28:08.3260.1 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=286

07:28:08.3260.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=9

07:28:08.3270.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=9 ORDER BY `priority`

07:28:08.3270.1 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=317

07:28:08.3270.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=9

07:28:08.3270.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=9 ORDER BY `priority`

07:28:08.3280.1 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=329

07:28:08.3280.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=9

07:28:08.3280.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=9 ORDER BY `priority`

07:28:08.3280.1 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=331

07:28:08.3380.3 msSELECTSELECT * FROM `cms_tree` WHERE (`pid`='35') AND (`active`='Y') AND (`site_code`='s1') AND (`tree_type_id`='6') ORDER BY `priority`

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

07:28:08.3400.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=2380

07:28:08.3400.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=2959

07:28:08.3400.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=1407

07:28:08.3400.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=1402

07:28:08.3410.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=1404

07:28:08.3410.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=2365

07:28:08.3410.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=2782

07:28:08.3410.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=2707

07:28:08.3410.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=2639

07:28:08.3420.0 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=2701

07:28:08.3420.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=1406

07:28:08.3420.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=2360

07:28:08.3420.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=1409

07:28:08.3430.2 msSELECTSELECT * FROM `cms_tree` WHERE (`pid`='37') AND (`active`='Y') AND (`site_code`='s1') ORDER BY `priority`

07:28:08.3440.1 msSELECTSELECT * FROM `cms_tree` WHERE `pid` IN (57, 111, 58, 59, 62, 61) ORDER BY `priority`

07:28:08.3440.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=1463

07:28:08.3440.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=1788

07:28:08.3440.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=1790

07:28:08.3440.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=1789

07:28:08.3450.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=353

07:28:08.3450.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=352

07:28:08.3450.2 msSELECTSELECT * FROM `cms_tree` WHERE (`pid`='37') AND (`active`='Y') AND (`site_code`='s1') ORDER BY `priority`

07:28:08.3450.0 msSELECTSELECT * FROM `cms_tree` WHERE `pid` IN (57, 111, 58, 59, 62, 61) ORDER BY `priority`

07:28:08.3470.1 msSELECTSELECT * FROM `cms_tree` WHERE 0=1

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

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

07:28:08.3480.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=35

07:28:08.3480.1 msSELECTSELECT * FROM `cms_tree` WHERE `pid`=35 ORDER BY `priority`

07:28:08.3490.1 msSELECTSELECT * FROM `cms_tree` WHERE (`active`='Y') AND (`pid`=35) ORDER BY `priority`

07:28:08.3500.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=36

07:28:08.3500.1 msSELECTSELECT * FROM `cms_tree` WHERE `pid`=36 ORDER BY `priority`

07:28:08.3510.2 msSELECTSELECT * FROM `cms_tree` WHERE (`active`='Y') AND (`pid`=36) ORDER BY `priority`

07:28:08.3520.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=37

07:28:08.3520.2 msSELECTSELECT * FROM `cms_tree` WHERE `pid`=37 ORDER BY `priority`

07:28:08.3530.1 msSELECTSELECT * FROM `cms_tree` WHERE (`active`='Y') AND (`pid`=37) ORDER BY `priority`

07:28:08.3530.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=71

07:28:08.3540.2 msSELECTSELECT * FROM `cms_tree` WHERE `pid`=71 ORDER BY `priority`

07:28:08.3540.1 msSELECTSELECT * FROM `cms_tree` WHERE (`active`='Y') AND (`pid`=71) ORDER BY `priority`

07:28:08.3550.5 msSELECTSELECT * FROM `cms_tree` WHERE `id`=63

07:28:08.3550.3 msSELECTSELECT * FROM `cms_tree` WHERE `id`=69

07:28:08.3560.3 msSELECTSELECT * FROM `cms_tree` WHERE 0=1

07:28:08.3560.2 msSELECTSELECT * FROM `cms_tree` WHERE (`active`='Y') AND (`pid`=7) ORDER BY `priority`

07:28:08.3560.1 msSELECTSELECT * FROM `cms_tree` WHERE 0=1

07:28:08.3570.2 msSELECTSELECT * FROM `cms_tree` WHERE 0=1

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

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

07:28:08.3630.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=35

07:28:08.3630.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=36

07:28:08.3630.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=37

07:28:08.3630.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=71

07:28:08.3830.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`

07:28:08.3830.5 msSELECTSELECT * FROM `cms_tree` WHERE `pid` IN (35, 36, 37, 71) ORDER BY `priority`

07:28:08.3930.2 msSELECTSELECT * FROM `form2_form` WHERE `code`='callback'

07:28:08.3930.1 msSELECTSELECT * FROM `form2_form` WHERE `id`=3

07:28:08.3930.1 msSELECTSELECT * FROM `form2_form_property` WHERE `form_id`=3 ORDER BY `priority`

07:28:08.3940.1 msSELECTSELECT * FROM `form2_form_send_property` WHERE 0=1

07:28:08.3950.1 msSELECTSELECT * FROM `form2_form` WHERE `code`='feedback'

07:28:08.3950.1 msSELECTSELECT * FROM `form2_form` WHERE `id`=1

07:28:08.3950.1 msSELECTSELECT * FROM `form2_form_property` WHERE `form_id`=1 ORDER BY `priority`

07:28:08.3950.0 msSELECTSELECT * FROM `form2_form_send_property` WHERE 0=1