Database Queries

Всего 169 записей.
TimeDurationTypeQuery
  
03:29:53.8331.8 msSHOWSHOW FULL COLUMNS FROM `cms_tree`
03:29:53.8361.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' AND kcu.table_name = 'cms_tree'

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

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

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

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

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

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

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

03:29:53.8621.1 msSHOWSHOW FULL COLUMNS FROM `cms_content_property`
03:29:53.8640.8 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'

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

03:29:53.8680.6 msSHOWSHOW FULL COLUMNS FROM `cms_content_element_property`
03:29:53.8690.6 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'

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

03:29:53.9210.3 msSHOWSHOW FULL COLUMNS FROM `cms_storage_file`
03:29:53.9210.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'

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

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

03:29:53.9220.2 msSHOWSHOW FULL COLUMNS FROM `cms_content_element_tree`
03:29:53.9230.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_tree' AND kcu.table_name = 'cms_content_element_tree'

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

03:29:53.9300.2 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:53.9310.2 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=2380

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

03:29:53.9830.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:53.9831.0 msSELECTSELECT * FROM `cms_tree` WHERE `pid` IN (35, 36, 37, 71) ORDER BY `priority`

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

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

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

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

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

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

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

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