Database Queries

Всего 165 записей.
TimeDurationTypeQuery
  
03:29:07.1850.3 msSELECTSELECT * FROM `cms_site_domain` WHERE `domain`='avalon-tent.ru'

03:29:07.1860.3 msSELECTSELECT * FROM `cms_site` WHERE (`active`='Y') AND (`def`='Y')

03:29:07.1860.4 msSHOWSHOW FULL COLUMNS FROM `cms_site`
03:29:07.1870.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_site' AND kcu.table_name = 'cms_site'

03:29:07.2550.4 msSELECTSELECT * FROM `cms_tree` WHERE `id`=1

03:29:07.2560.2 msSELECTSELECT * FROM `cms_tree` WHERE 0=1

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

03:29:07.2570.2 msSELECTSELECT * FROM `cms_tree_type` WHERE `id`=1

03:29:07.2580.3 msSELECTSELECT * FROM `cms_content_element` WHERE `content_id`=10

03:29:07.2600.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

03:29:07.2600.2 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

03:29:07.2620.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=321

03:29:07.2630.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

03:29:07.2630.2 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

03:29:07.2640.1 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=326

03:29:07.2640.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

03:29:07.2650.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

03:29:07.2660.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=232

03:29:07.2660.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

03:29:07.2660.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

03:29:07.2670.1 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=320

03:29:07.2680.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

03:29:07.2680.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

03:29:07.2690.1 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=231

03:29:07.2690.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

03:29:07.2690.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

03:29:07.2700.1 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=319

03:29:07.2710.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

03:29:07.2710.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

03:29:07.2720.1 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=325

03:29:07.2720.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

03:29:07.2720.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

03:29:07.2730.1 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=233

03:29:07.2730.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

03:29:07.2740.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

03:29:07.2740.1 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=236

03:29:07.2750.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

03:29:07.2750.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

03:29:07.2760.1 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=229

03:29:07.2760.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

03:29:07.2760.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

03:29:07.2770.1 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=230

03:29:07.2770.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

03:29:07.2770.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

03:29:07.2780.1 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=235

03:29:07.2780.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

03:29:07.2790.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

03:29:07.2790.1 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=238

03:29:07.2800.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

03:29:07.2800.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

03:29:07.2800.1 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=327

03:29:07.2810.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

03:29:07.2810.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

03:29:07.2820.1 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=237

03:29:07.2820.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

03:29:07.2820.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

03:29:07.2830.1 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=234

03:29:07.2830.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

03:29:07.2830.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

03:29:07.2840.1 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=322

03:29:07.2840.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

03:29:07.2840.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

03:29:07.2850.1 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=226

03:29:07.2850.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

03:29:07.2850.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

03:29:07.2860.1 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=318

03:29:07.2860.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

03:29:07.2870.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

03:29:07.2890.1 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=324

03:29:07.2900.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

03:29:07.2900.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

03:29:07.2900.1 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=323

03:29:07.2910.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

03:29:07.2910.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

03:29:07.2920.1 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=227

03:29:07.2930.1 msSELECTSELECT `id` FROM `cms_tree` WHERE (`pids` LIKE '/1/%') OR (`pid`=1) ORDER BY `level`, `priority`

03:29:07.3080.9 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` <= '1736555347') AND ((`cms_content_element`.`published_to` >= '1736555347') OR (`cms_content_element`.`published_to` IS NULL)) GROUP BY `cms_content_element`.`id` ORDER BY `priority`

03:29:07.3090.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id` IN (2948, 2864, 2865, 2867, 2863, 2868, 2971)

03:29:07.3100.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=1

03:29:07.3100.1 msSELECTSELECT * FROM `cms_content_element_tree` WHERE `element_id` IN (330, 287, 288, 286, 317, 329, 331)

03:29:07.3100.3 msSHOWSHOW FULL COLUMNS FROM `cms_content_element_tree`
03:29:07.3100.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'

03:29:07.3110.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=9

03:29:07.3110.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=9 ORDER BY `priority`

03:29:07.3120.1 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=330

03:29:07.3120.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=9

03:29:07.3120.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=9 ORDER BY `priority`

03:29:07.3130.1 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=287

03:29:07.3130.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=9

03:29:07.3130.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=9 ORDER BY `priority`

03:29:07.3130.1 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=288

03:29:07.3130.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=9

03:29:07.3140.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=9 ORDER BY `priority`

03:29:07.3140.1 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=286

03:29:07.3140.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=9

03:29:07.3140.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=9 ORDER BY `priority`

03:29:07.3150.0 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=317

03:29:07.3150.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=9

03:29:07.3150.0 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=9 ORDER BY `priority`

03:29:07.3150.1 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=329

03:29:07.3150.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=9

03:29:07.3150.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=9 ORDER BY `priority`

03:29:07.3160.0 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=331

03:29:07.3260.2 msSELECTSELECT * FROM `cms_tree` WHERE (`pid`='35') AND (`active`='Y') AND (`site_code`='s1') AND (`tree_type_id`='6') ORDER BY `priority`

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

03:29:07.3270.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=2380

03:29:07.3270.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=2959

03:29:07.3280.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=1407

03:29:07.3280.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=1402

03:29:07.3280.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=1404

03:29:07.3280.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=2365

03:29:07.3290.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=2782

03:29:07.3290.0 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=2707

03:29:07.3290.0 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=2639

03:29:07.3290.0 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=2701

03:29:07.3290.0 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=1406

03:29:07.3290.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=2360

03:29:07.3300.0 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=1409

03:29:07.3410.2 msSELECTSELECT * FROM `cms_tree` WHERE (`pid`='37') AND (`active`='Y') AND (`site_code`='s1') ORDER BY `priority`

03:29:07.3410.1 msSELECTSELECT * FROM `cms_tree` WHERE `pid` IN (57, 111, 58, 59, 62, 61) ORDER BY `priority`

03:29:07.3420.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=1463

03:29:07.3420.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=1788

03:29:07.3420.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=1790

03:29:07.3420.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=1789

03:29:07.3420.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=353

03:29:07.3430.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=352

03:29:07.3430.1 msSELECTSELECT * FROM `cms_tree` WHERE (`pid`='37') AND (`active`='Y') AND (`site_code`='s1') ORDER BY `priority`

03:29:07.3430.1 msSELECTSELECT * FROM `cms_tree` WHERE `pid` IN (57, 111, 58, 59, 62, 61) ORDER BY `priority`

03:29:07.3440.1 msSELECTSELECT * FROM `cms_tree` WHERE 0=1

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

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

03:29:07.3460.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=35

03:29:07.3460.2 msSELECTSELECT * FROM `cms_tree` WHERE `pid`=35 ORDER BY `priority`

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

03:29:07.3480.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=36

03:29:07.3480.2 msSELECTSELECT * FROM `cms_tree` WHERE `pid`=36 ORDER BY `priority`

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

03:29:07.3500.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=37

03:29:07.3500.3 msSELECTSELECT * FROM `cms_tree` WHERE `pid`=37 ORDER BY `priority`

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

03:29:07.3510.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=71

03:29:07.3510.2 msSELECTSELECT * FROM `cms_tree` WHERE `pid`=71 ORDER BY `priority`

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

03:29:07.3520.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=63

03:29:07.3530.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=69

03:29:07.3530.1 msSELECTSELECT * FROM `cms_tree` WHERE 0=1

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

03:29:07.3530.1 msSELECTSELECT * FROM `cms_tree` WHERE 0=1

03:29:07.3530.1 msSELECTSELECT * FROM `cms_tree` WHERE 0=1

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

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

03:29:07.3670.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=35

03:29:07.3670.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=36

03:29:07.3680.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=37

03:29:07.3680.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=71

03:29:07.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`

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

03:29:07.3940.1 msSELECTSELECT * FROM `form2_form` WHERE `code`='callback'

03:29:07.3940.1 msSELECTSELECT * FROM `form2_form` WHERE `id`=3

03:29:07.3940.1 msSELECTSELECT * FROM `form2_form_property` WHERE `form_id`=3 ORDER BY `priority`

03:29:07.3950.1 msSELECTSELECT * FROM `form2_form_send_property` WHERE 0=1

03:29:07.3960.1 msSELECTSELECT * FROM `form2_form` WHERE `code`='feedback'

03:29:07.3960.1 msSELECTSELECT * FROM `form2_form` WHERE `id`=1

03:29:07.3960.1 msSELECTSELECT * FROM `form2_form_property` WHERE `form_id`=1 ORDER BY `priority`

03:29:07.3970.1 msSELECTSELECT * FROM `form2_form_send_property` WHERE 0=1