Database Queries

Всего 166 записей.
TimeDurationTypeQuery
  
02:41:28.5550.5 msSELECTSELECT * FROM `cms_tree` WHERE (`site_code`='s1') AND (`level`=0)

02:41:28.5560.3 msSELECTSELECT * FROM `cms_tree` WHERE `id`=1

02:41:28.5590.1 msSELECTSELECT * FROM `cms_tree` WHERE 0=1

02:41:28.5590.1 msSELECTSELECT * FROM `cms_site` WHERE (`code`='s1') AND (`active`='Y')

02:41:28.5590.5 msSELECTSELECT * FROM `cms_tree_type` WHERE `id`=1

02:41:28.5600.3 msSHOWSHOW FULL COLUMNS FROM `cms_tree_type`
02:41:28.5600.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'

02:41:28.5620.4 msSELECTSELECT * FROM `cms_content_element` WHERE `content_id`=10

02:41:28.5630.4 msSHOWSHOW FULL COLUMNS FROM `cms_content_element`
02:41:28.5640.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'

02:41:28.5650.2 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

02:41:28.5660.4 msSHOWSHOW FULL COLUMNS FROM `cms_content`
02:41:28.5660.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'

02:41:28.5670.3 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

02:41:28.5680.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=321

02:41:28.5680.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

02:41:28.5690.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

02:41:28.5690.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=326

02:41:28.5700.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

02:41:28.5700.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

02:41:28.5710.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=232

02:41:28.5710.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

02:41:28.5710.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

02:41:28.5720.3 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=320

02:41:28.5730.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

02:41:28.5730.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

02:41:28.5730.3 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=231

02:41:28.5740.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

02:41:28.5740.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

02:41:28.5750.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=319

02:41:28.5750.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

02:41:28.5750.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

02:41:28.5760.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=325

02:41:28.5770.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

02:41:28.5770.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

02:41:28.5770.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=233

02:41:28.5780.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

02:41:28.5780.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

02:41:28.5790.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=236

02:41:28.5790.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

02:41:28.5790.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

02:41:28.5800.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=229

02:41:28.5800.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

02:41:28.5810.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

02:41:28.5810.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=230

02:41:28.5820.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

02:41:28.5820.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

02:41:28.5830.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=235

02:41:28.5830.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

02:41:28.5830.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

02:41:28.5840.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=238

02:41:28.5840.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

02:41:28.5850.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

02:41:28.5850.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=327

02:41:28.5860.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

02:41:28.5860.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

02:41:28.5870.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=237

02:41:28.5870.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

02:41:28.5870.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

02:41:28.5880.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=234

02:41:28.5880.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

02:41:28.5880.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

02:41:28.5890.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=322

02:41:28.5900.3 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

02:41:28.5900.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

02:41:28.5910.4 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=226

02:41:28.5910.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

02:41:28.5920.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

02:41:28.5920.3 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=318

02:41:28.5930.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

02:41:28.5930.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

02:41:28.5960.4 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=324

02:41:28.5960.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

02:41:28.5970.2 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

02:41:28.5970.3 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=323

02:41:28.5980.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

02:41:28.5980.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

02:41:28.5990.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=227

02:41:28.6020.4 msSELECTSELECT `id` FROM `cms_tree` WHERE (`pids` LIKE '/1/%') OR (`pid`=1) ORDER BY `level`, `priority`

02:41:28.6273.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` <= '1736638888') AND ((`cms_content_element`.`published_to` >= '1736638888') OR (`cms_content_element`.`published_to` IS NULL)) GROUP BY `cms_content_element`.`id` ORDER BY `priority`

02:41:28.6310.4 msSELECTSELECT * FROM `cms_storage_file` WHERE `id` IN (2948, 2864, 2865, 2867, 2863, 2868, 2971)

02:41:28.6320.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=1

02:41:28.6320.3 msSELECTSELECT * FROM `cms_content_element_tree` WHERE `element_id` IN (330, 287, 288, 286, 317, 329, 331)

02:41:28.6350.2 msSELECTSELECT * FROM `cms_content` WHERE `id`=9

02:41:28.6350.3 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=9 ORDER BY `priority`

02:41:28.6350.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=330

02:41:28.6360.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=9

02:41:28.6360.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=9 ORDER BY `priority`

02:41:28.6360.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=287

02:41:28.6370.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=9

02:41:28.6370.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=9 ORDER BY `priority`

02:41:28.6370.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=288

02:41:28.6380.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=9

02:41:28.6380.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=9 ORDER BY `priority`

02:41:28.6380.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=286

02:41:28.6380.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=9

02:41:28.6390.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=9 ORDER BY `priority`

02:41:28.6390.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=317

02:41:28.6390.2 msSELECTSELECT * FROM `cms_content` WHERE `id`=9

02:41:28.6400.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=9 ORDER BY `priority`

02:41:28.6400.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=329

02:41:28.6400.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=9

02:41:28.6400.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=9 ORDER BY `priority`

02:41:28.6410.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=331

02:41:28.6510.5 msSELECTSELECT * FROM `cms_tree` WHERE (`pid`='35') AND (`active`='Y') AND (`site_code`='s1') AND (`tree_type_id`='6') ORDER BY `priority`

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

02:41:28.6530.2 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=2380

02:41:28.6530.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=2959

02:41:28.6540.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=1407

02:41:28.6540.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=1402

02:41:28.6540.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=1404

02:41:28.6550.2 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=2365

02:41:28.6550.2 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=2782

02:41:28.6550.2 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=2707

02:41:28.6560.2 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=2639

02:41:28.6560.2 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=2701

02:41:28.6560.2 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=1406

02:41:28.6570.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=2360

02:41:28.6570.2 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=1409

02:41:28.6910.6 msSELECTSELECT * FROM `cms_tree` WHERE (`pid`='37') AND (`active`='Y') AND (`site_code`='s1') ORDER BY `priority`

02:41:28.6920.2 msSELECTSELECT * FROM `cms_tree` WHERE `pid` IN (57, 111, 58, 59, 62, 61) ORDER BY `priority`

02:41:28.6930.2 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=1463

02:41:28.6930.2 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=1788

02:41:28.6930.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=1790

02:41:28.6930.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=1789

02:41:28.6940.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=353

02:41:28.6940.2 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=352

02:41:28.6940.2 msSELECTSELECT * FROM `cms_tree` WHERE (`pid`='37') AND (`active`='Y') AND (`site_code`='s1') ORDER BY `priority`

02:41:28.6950.1 msSELECTSELECT * FROM `cms_tree` WHERE `pid` IN (57, 111, 58, 59, 62, 61) ORDER BY `priority`

02:41:28.6960.1 msSELECTSELECT * FROM `cms_tree` WHERE 0=1

02:41:28.6970.1 msSELECTSELECT * FROM `cms_tree` WHERE (`pid`='1') AND (`level`='1') AND (`active`='Y') AND (`site_code`='s1') ORDER BY `priority`

02:41:28.6980.2 msSELECTSELECT * FROM `cms_tree` WHERE `pid` IN (65, 66, 67, 76, 7, 8, 4) ORDER BY `priority`

02:41:28.6980.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=35

02:41:28.6980.2 msSELECTSELECT * FROM `cms_tree` WHERE `pid`=35 ORDER BY `priority`

02:41:28.6990.2 msSELECTSELECT * FROM `cms_tree` WHERE (`active`='Y') AND (`pid`=35) ORDER BY `priority`

02:41:28.7000.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=36

02:41:28.7000.2 msSELECTSELECT * FROM `cms_tree` WHERE `pid`=36 ORDER BY `priority`

02:41:28.7010.2 msSELECTSELECT * FROM `cms_tree` WHERE (`active`='Y') AND (`pid`=36) ORDER BY `priority`

02:41:28.7020.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=37

02:41:28.7020.4 msSELECTSELECT * FROM `cms_tree` WHERE `pid`=37 ORDER BY `priority`

02:41:28.7030.2 msSELECTSELECT * FROM `cms_tree` WHERE (`active`='Y') AND (`pid`=37) ORDER BY `priority`

02:41:28.7040.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=71

02:41:28.7040.2 msSELECTSELECT * FROM `cms_tree` WHERE `pid`=71 ORDER BY `priority`

02:41:28.7040.2 msSELECTSELECT * FROM `cms_tree` WHERE (`active`='Y') AND (`pid`=71) ORDER BY `priority`

02:41:28.7050.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=63

02:41:28.7050.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=69

02:41:28.7060.1 msSELECTSELECT * FROM `cms_tree` WHERE 0=1

02:41:28.7060.1 msSELECTSELECT * FROM `cms_tree` WHERE (`active`='Y') AND (`pid`=7) ORDER BY `priority`

02:41:28.7060.1 msSELECTSELECT * FROM `cms_tree` WHERE 0=1

02:41:28.7060.1 msSELECTSELECT * FROM `cms_tree` WHERE 0=1

02:41:28.7250.2 msSELECTSELECT * FROM `cms_tree` WHERE (`level`='1') AND (`active`='Y') AND (`site_code`='s1') ORDER BY `priority`

02:41:28.7250.1 msSELECTSELECT * FROM `cms_tree` WHERE `pid` IN (65, 66, 67, 76, 7, 8, 4) ORDER BY `priority`

02:41:28.7260.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=35

02:41:28.7260.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=36

02:41:28.7260.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=37

02:41:28.7260.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=71

02:41:28.7721.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`

02:41:28.7731.0 msSELECTSELECT * FROM `cms_tree` WHERE `pid` IN (35, 36, 37, 71) ORDER BY `priority`

02:41:28.7850.1 msSELECTSELECT * FROM `form2_form` WHERE `code`='callback'

02:41:28.7860.1 msSELECTSELECT * FROM `form2_form` WHERE `id`=3

02:41:28.7860.1 msSELECTSELECT * FROM `form2_form_property` WHERE `form_id`=3 ORDER BY `priority`

02:41:28.7860.0 msSELECTSELECT * FROM `form2_form_send_property` WHERE 0=1

02:41:28.7870.1 msSELECTSELECT * FROM `form2_form` WHERE `code`='feedback'

02:41:28.7880.1 msSELECTSELECT * FROM `form2_form` WHERE `id`=1

02:41:28.7880.1 msSELECTSELECT * FROM `form2_form_property` WHERE `form_id`=1 ORDER BY `priority`

02:41:28.7890.1 msSELECTSELECT * FROM `form2_form_send_property` WHERE 0=1