Database Queries

Всего 169 записей.
TimeDurationTypeQuery
  
00:38:44.4331.0 msSELECTSELECT * FROM `cms_tree` WHERE `id`=1

00:38:44.4350.2 msSELECTSELECT * FROM `cms_tree` WHERE 0=1

00:38:44.4360.2 msSELECTSELECT * FROM `cms_site` WHERE (`code`='s1') AND (`active`='Y')

00:38:44.4360.4 msSELECTSELECT * FROM `cms_tree_type` WHERE `id`=1

00:38:44.4380.7 msSELECTSELECT * FROM `cms_content_element` WHERE `content_id`=10

00:38:44.4390.7 msSHOWSHOW FULL COLUMNS FROM `cms_content_element`
00:38:44.4400.5 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'

00:38:44.4430.3 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

00:38:44.4430.6 msSHOWSHOW FULL COLUMNS FROM `cms_content`
00:38:44.4440.4 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'

00:38:44.4450.4 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

00:38:44.4460.5 msSHOWSHOW FULL COLUMNS FROM `cms_content_property`
00:38:44.4460.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'

00:38:44.4480.4 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=321

00:38:44.4490.4 msSHOWSHOW FULL COLUMNS FROM `cms_content_element_property`
00:38:44.4490.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'

00:38:44.4500.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

00:38:44.4500.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

00:38:44.4510.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=326

00:38:44.4520.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

00:38:44.4520.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

00:38:44.4530.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=232

00:38:44.4530.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

00:38:44.4540.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

00:38:44.4540.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=320

00:38:44.4550.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

00:38:44.4550.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

00:38:44.4560.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=231

00:38:44.4560.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

00:38:44.4570.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

00:38:44.4570.3 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=319

00:38:44.4580.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

00:38:44.4580.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

00:38:44.4590.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=325

00:38:44.4590.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

00:38:44.4590.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

00:38:44.4600.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=233

00:38:44.4610.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

00:38:44.4610.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

00:38:44.4610.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=236

00:38:44.4620.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

00:38:44.4620.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

00:38:44.4630.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=229

00:38:44.4630.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

00:38:44.4630.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

00:38:44.4640.1 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=230

00:38:44.4640.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

00:38:44.4640.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

00:38:44.4650.1 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=235

00:38:44.4650.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

00:38:44.4660.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

00:38:44.4660.1 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=238

00:38:44.4670.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

00:38:44.4670.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

00:38:44.4670.1 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=327

00:38:44.4680.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

00:38:44.4680.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

00:38:44.4680.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=237

00:38:44.4690.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

00:38:44.4690.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

00:38:44.4700.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=234

00:38:44.4700.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

00:38:44.4700.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

00:38:44.4710.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=322

00:38:44.4710.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

00:38:44.4710.2 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

00:38:44.4720.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=226

00:38:44.4720.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

00:38:44.4730.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

00:38:44.4730.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=318

00:38:44.4740.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

00:38:44.4740.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

00:38:44.4760.3 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=324

00:38:44.4770.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

00:38:44.4770.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

00:38:44.4770.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=323

00:38:44.4780.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=10

00:38:44.4780.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=10 ORDER BY `priority`

00:38:44.4790.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=227

00:38:44.4800.2 msSELECTSELECT `id` FROM `cms_tree` WHERE (`pids` LIKE '/1/%') OR (`pid`=1) ORDER BY `level`, `priority`

00:38:44.4911.3 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` <= '1736545124') AND ((`cms_content_element`.`published_to` >= '1736545124') OR (`cms_content_element`.`published_to` IS NULL)) GROUP BY `cms_content_element`.`id` ORDER BY `priority`

00:38:44.4940.4 msSELECTSELECT * FROM `cms_storage_file` WHERE `id` IN (2948, 2864, 2865, 2867, 2863, 2868, 2971)

00:38:44.4940.5 msSHOWSHOW FULL COLUMNS FROM `cms_storage_file`
00:38:44.4950.4 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'

00:38:44.4960.4 msSELECTSELECT * FROM `cms_tree` WHERE `id`=1

00:38:44.4960.3 msSELECTSELECT * FROM `cms_content_element_tree` WHERE `element_id` IN (330, 287, 288, 286, 317, 329, 331)

00:38:44.4980.3 msSELECTSELECT * FROM `cms_content` WHERE `id`=9

00:38:44.4980.3 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=9 ORDER BY `priority`

00:38:44.4990.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=330

00:38:44.4990.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=9

00:38:44.5000.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=9 ORDER BY `priority`

00:38:44.5000.3 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=287

00:38:44.5010.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=9

00:38:44.5010.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=9 ORDER BY `priority`

00:38:44.5010.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=288

00:38:44.5020.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=9

00:38:44.5020.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=9 ORDER BY `priority`

00:38:44.5020.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=286

00:38:44.5030.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=9

00:38:44.5030.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=9 ORDER BY `priority`

00:38:44.5030.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=317

00:38:44.5040.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=9

00:38:44.5040.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=9 ORDER BY `priority`

00:38:44.5040.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=329

00:38:44.5050.1 msSELECTSELECT * FROM `cms_content` WHERE `id`=9

00:38:44.5050.1 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=9 ORDER BY `priority`

00:38:44.5050.2 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=331

00:38:44.5180.4 msSELECTSELECT * FROM `cms_tree` WHERE (`pid`='35') AND (`active`='Y') AND (`site_code`='s1') AND (`tree_type_id`='6') ORDER BY `priority`

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

00:38:44.5190.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=2380

00:38:44.5190.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=2959

00:38:44.5200.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=1407

00:38:44.5200.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=1402

00:38:44.5200.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=1404

00:38:44.5210.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=2365

00:38:44.5210.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=2782

00:38:44.5210.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=2707

00:38:44.5210.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=2639

00:38:44.5220.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=2701

00:38:44.5220.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=1406

00:38:44.5220.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=2360

00:38:44.5230.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=1409

00:38:44.5240.3 msSELECTSELECT * FROM `cms_tree` WHERE (`pid`='37') AND (`active`='Y') AND (`site_code`='s1') ORDER BY `priority`

00:38:44.5250.2 msSELECTSELECT * FROM `cms_tree` WHERE `pid` IN (57, 111, 58, 59, 62, 61) ORDER BY `priority`

00:38:44.5250.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=1463

00:38:44.5250.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=1788

00:38:44.5260.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=1790

00:38:44.5260.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=1789

00:38:44.5260.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=353

00:38:44.5260.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=352

00:38:44.5270.1 msSELECTSELECT * FROM `cms_tree` WHERE (`pid`='37') AND (`active`='Y') AND (`site_code`='s1') ORDER BY `priority`

00:38:44.5270.1 msSELECTSELECT * FROM `cms_tree` WHERE `pid` IN (57, 111, 58, 59, 62, 61) ORDER BY `priority`

00:38:44.5290.1 msSELECTSELECT * FROM `cms_tree` WHERE 0=1

00:38:44.5420.2 msSELECTSELECT * FROM `cms_tree` WHERE (`pid`='1') AND (`level`='1') AND (`active`='Y') AND (`site_code`='s1') ORDER BY `priority`

00:38:44.5420.1 msSELECTSELECT * FROM `cms_tree` WHERE `pid` IN (65, 66, 67, 76, 7, 8, 4) ORDER BY `priority`

00:38:44.5430.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=35

00:38:44.5430.2 msSELECTSELECT * FROM `cms_tree` WHERE `pid`=35 ORDER BY `priority`

00:38:44.5440.2 msSELECTSELECT * FROM `cms_tree` WHERE (`active`='Y') AND (`pid`=35) ORDER BY `priority`

00:38:44.5450.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=36

00:38:44.5450.3 msSELECTSELECT * FROM `cms_tree` WHERE `pid`=36 ORDER BY `priority`

00:38:44.5460.3 msSELECTSELECT * FROM `cms_tree` WHERE (`active`='Y') AND (`pid`=36) ORDER BY `priority`

00:38:44.5470.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=37

00:38:44.5470.3 msSELECTSELECT * FROM `cms_tree` WHERE `pid`=37 ORDER BY `priority`

00:38:44.5480.2 msSELECTSELECT * FROM `cms_tree` WHERE (`active`='Y') AND (`pid`=37) ORDER BY `priority`

00:38:44.5490.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=71

00:38:44.5490.2 msSELECTSELECT * FROM `cms_tree` WHERE `pid`=71 ORDER BY `priority`

00:38:44.5490.1 msSELECTSELECT * FROM `cms_tree` WHERE (`active`='Y') AND (`pid`=71) ORDER BY `priority`

00:38:44.5500.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=63

00:38:44.5500.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=69

00:38:44.5500.1 msSELECTSELECT * FROM `cms_tree` WHERE 0=1

00:38:44.5510.1 msSELECTSELECT * FROM `cms_tree` WHERE (`active`='Y') AND (`pid`=7) ORDER BY `priority`

00:38:44.5510.1 msSELECTSELECT * FROM `cms_tree` WHERE 0=1

00:38:44.5510.1 msSELECTSELECT * FROM `cms_tree` WHERE 0=1

00:38:44.5570.2 msSELECTSELECT * FROM `cms_tree` WHERE (`level`='1') AND (`active`='Y') AND (`site_code`='s1') ORDER BY `priority`

00:38:44.5580.1 msSELECTSELECT * FROM `cms_tree` WHERE `pid` IN (65, 66, 67, 76, 7, 8, 4) ORDER BY `priority`

00:38:44.5580.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=35

00:38:44.5590.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=36

00:38:44.5590.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=37

00:38:44.5590.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=71

00:38:44.5670.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`

00:38:44.5670.7 msSELECTSELECT * FROM `cms_tree` WHERE `pid` IN (35, 36, 37, 71) ORDER BY `priority`

00:38:44.5770.1 msSELECTSELECT * FROM `form2_form` WHERE `code`='callback'

00:38:44.5770.1 msSELECTSELECT * FROM `form2_form` WHERE `id`=3

00:38:44.5780.1 msSELECTSELECT * FROM `form2_form_property` WHERE `form_id`=3 ORDER BY `priority`

00:38:44.5780.1 msSELECTSELECT * FROM `form2_form_send_property` WHERE 0=1

00:38:44.5790.1 msSELECTSELECT * FROM `form2_form` WHERE `code`='feedback'

00:38:44.5790.1 msSELECTSELECT * FROM `form2_form` WHERE `id`=1

00:38:44.5790.1 msSELECTSELECT * FROM `form2_form_property` WHERE `form_id`=1 ORDER BY `priority`

00:38:44.5790.1 msSELECTSELECT * FROM `form2_form_send_property` WHERE 0=1