Database Queries

Всего 105 записей.
TimeDurationTypeQuery
  
03:49:52.1750.6 msSELECTSELECT * FROM `cms_tree` WHERE (`dir`='catalog/rent-tents/safari') AND (`site_code`='s1')

03:49:52.1760.4 msSHOWSHOW FULL COLUMNS FROM `cms_tree`
03:49:52.1760.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:49:52.1770.2 msSELECTSELECT * FROM `cms_tree` WHERE `id`=103

03:49:52.1780.3 msSELECTSELECT * FROM `cms_tree` WHERE `cms_tree`.`id` IN ('1', '18', '36')

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

03:49:52.1790.1 msSELECTSELECT * FROM `cms_tree_type` WHERE `id`=6

03:49:52.1790.3 msSHOWSHOW FULL COLUMNS FROM `cms_tree_type`
03:49:52.1790.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'

03:49:52.1810.1 msSELECTSELECT * FROM `cms_tree_type` WHERE `id`=6

03:49:52.1811.7 msSELECTSELECT * FROM `cms_tree_type_property` WHERE `tree_type_id`=6 ORDER BY `priority`

03:49:52.1830.4 msSHOWSHOW FULL COLUMNS FROM `cms_tree_type_property`
03:49:52.1830.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_property' AND kcu.table_name = 'cms_tree_type_property'

03:49:52.1861.5 msSELECTSELECT * FROM `cms_tree_property` WHERE `element_id`=103

03:49:52.1870.3 msSHOWSHOW FULL COLUMNS FROM `cms_tree_property`
03:49:52.1880.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_property' AND kcu.table_name = 'cms_tree_property'

03:49:52.2130.4 msSELECTSELECT * FROM `cms_tree` WHERE (`pid`=103) AND (`active`='Y') AND (`site_code`='s1') ORDER BY `priority`

03:49:52.2300.5 msSHOWSHOW FULL COLUMNS FROM `cms_content`
03:49:52.2310.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'

03:49:52.2310.3 msSELECTSELECT * FROM `cms_content` WHERE `id`='4'

03:49:52.2320.1 msSELECTSELECT * FROM `cms_content` WHERE `id`='4'

03:49:52.2320.4 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=4 ORDER BY `priority`

03:49:52.2330.3 msSHOWSHOW FULL COLUMNS FROM `cms_content_property`
03:49:52.2330.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_property' AND kcu.table_name = 'cms_content_property'

03:49:52.2430.5 msSHOWSHOW FULL COLUMNS FROM `cms_content_element`
03:49:52.2430.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'

03:49:52.2440.2 msSELECTSELECT * FROM `cms_tree` WHERE `pid`=103 ORDER BY `priority`

03:49:52.2451.0 msSELECTSELECT *, `cms_content_element`.`id` AS `mainId` 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`='4') AND ((`cms_content_element`.`tree_id`=103) OR (`cms_content_element_tree`.`tree_id`=103)) AND (`cms_content_element`.`published_at` <= '1736556592') AND ((`cms_content_element`.`published_to` >= '1736556592') OR (`cms_content_element`.`published_to` IS NULL)) GROUP BY `cms_content_element`.`id`

03:49:52.2460.2 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`='2695'

03:49:52.2470.4 msSELECTSELECT * FROM `shop_type_price` WHERE `id`='1'

03:49:52.2470.3 msSHOWSHOW FULL COLUMNS FROM `shop_type_price`
03:49:52.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 = 'shop_type_price' AND kcu.table_name = 'shop_type_price'

03:49:52.2480.1 msSELECTSELECT * FROM `shop_type_price` WHERE `id`='1'

03:49:52.2480.1 msSELECTSELECT * FROM `shop_type_price` WHERE `id`='1'

03:49:52.2490.4 msSELECTSELECT * FROM `shop_product_price` WHERE (`product_id`=316) AND (`type_price_id`=1) ORDER BY `price`

03:49:52.2490.1 msSELECTSELECT * FROM `shop_type_price` WHERE `id`='1'

03:49:52.2490.1 msSELECTSELECT * FROM `shop_type_price` WHERE `id`='1'

03:49:52.2490.1 msSELECTSELECT * FROM `shop_type_price` WHERE `id`='1'

03:49:52.2490.1 msSELECTSELECT * FROM `shop_product_price` WHERE (`product_id`=316) AND (`type_price_id`=1) ORDER BY `price` DESC

03:49:52.2500.0 msSELECTSELECT * FROM `shop_type_price` WHERE `id`='1'

03:49:52.2511.1 msSELECTSELECT `value`, `value_enum` FROM `cms_content_element_property` WHERE (`property_id`=2) AND (`element_id`=316) ORDER BY `value_enum`, `value`

03:49:52.2520.3 msSHOWSHOW FULL COLUMNS FROM `cms_content_element_property`
03:49:52.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_element_property' AND kcu.table_name = 'cms_content_element_property'

03:49:52.2530.3 msSELECTSELECT `value`, `value_enum` FROM `cms_content_element_property` WHERE (`property_id`=3) AND (`element_id`=316) ORDER BY `value_enum`, `value`

03:49:52.2530.2 msSELECTSELECT `value`, `value_enum` FROM `cms_content_element_property` WHERE (`property_id`=4) AND (`element_id`=316) ORDER BY `value_enum`, `value`

03:49:52.2540.1 msSELECTSELECT * FROM `cms_content` WHERE `id`='4'

03:49:52.2551.1 msSELECTSELECT * FROM `cms_content_property` WHERE (`code`='square') AND (`content_id`=4) ORDER BY `priority`

03:49:52.2560.2 msSELECTSELECT * FROM `cms_content_property` WHERE (`code`='price') AND (`content_id`=4) ORDER BY `priority`

03:49:52.2560.3 msSELECTSELECT * FROM `cms_content_property` WHERE (`code`='rentPrice') AND (`content_id`=4) ORDER BY `priority`

03:49:52.2670.3 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=2703

03:49:52.2670.4 msSHOWSHOW FULL COLUMNS FROM `cms_storage_file`
03:49:52.2680.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_storage_file' AND kcu.table_name = 'cms_storage_file'

03:49:52.2692.0 msSELECTSELECT COUNT(*) FROM (SELECT `cms_content_element`.*, `p1`.`value_num` AS `square`, `p2`.`value_num` AS `price`, `p3`.`value_num` AS `rentPrice` FROM `cms_content_element` LEFT JOIN `cms_content_element_tree` ON `cms_content_element`.`id` = `cms_content_element_tree`.`element_id` LEFT JOIN `shop_product` ON `shop_product`.`id` = `cms_content_element`.`id` LEFT JOIN `cms_content_element_property` `p1` ON (`p1`.`property_id`=2) AND (`p1`.`element_id`=cms_content_element.id) LEFT JOIN `cms_content_element_property` `p2` ON (`p2`.`property_id`=10) AND (`p2`.`element_id`=cms_content_element.id) LEFT JOIN `cms_content_element_property` `p3` ON (`p3`.`property_id`=11) AND (`p3`.`element_id`=cms_content_element.id) WHERE (`cms_content_element`.`active`='Y') AND (`cms_content_element`.`content_id`='4') AND ((`cms_content_element`.`tree_id`=103) OR (`cms_content_element_tree`.`tree_id`=103)) AND (`cms_content_element`.`published_at` <= '1736556592') AND ((`cms_content_element`.`published_to` >= '1736556592') OR (`cms_content_element`.`published_to` IS NULL)) GROUP BY `cms_content_element`.`id`) `c`

03:49:52.2710.9 msSELECTSELECT `cms_content_element`.*, `p1`.`value_num` AS `square`, `p2`.`value_num` AS `price`, `p3`.`value_num` AS `rentPrice` FROM `cms_content_element` LEFT JOIN `cms_content_element_tree` ON `cms_content_element`.`id` = `cms_content_element_tree`.`element_id` LEFT JOIN `shop_product` ON `shop_product`.`id` = `cms_content_element`.`id` LEFT JOIN `cms_content_element_property` `p1` ON (`p1`.`property_id`=2) AND (`p1`.`element_id`=cms_content_element.id) LEFT JOIN `cms_content_element_property` `p2` ON (`p2`.`property_id`=10) AND (`p2`.`element_id`=cms_content_element.id) LEFT JOIN `cms_content_element_property` `p3` ON (`p3`.`property_id`=11) AND (`p3`.`element_id`=cms_content_element.id) WHERE (`cms_content_element`.`active`='Y') AND (`cms_content_element`.`content_id`='4') AND ((`cms_content_element`.`tree_id`=103) OR (`cms_content_element_tree`.`tree_id`=103)) AND (`cms_content_element`.`published_at` <= '1736556592') AND ((`cms_content_element`.`published_to` >= '1736556592') OR (`cms_content_element`.`published_to` IS NULL)) GROUP BY `cms_content_element`.`id` ORDER BY `square`, `price`, `rentPrice`, `published_at` LIMIT 24

03:49:52.2720.1 msSELECTSELECT * FROM `cms_storage_file` WHERE `id`=2695

03:49:52.2730.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=103

03:49:52.2730.2 msSELECTSELECT * FROM `cms_content_element_tree` WHERE `element_id`=316

03:49:52.2730.2 msSELECTSELECT * FROM `cms_content` WHERE `id`=4

03:49:52.2740.2 msSELECTSELECT * FROM `cms_content_property` WHERE `content_id`=4 ORDER BY `priority`

03:49:52.2750.4 msSELECTSELECT * FROM `cms_content_element_property` WHERE `element_id`=316

03:49:52.2771.3 msSELECTSELECT * FROM `cms_tree_image` WHERE `tree_id`=103

03:49:52.2780.2 msSELECTSELECT * FROM `cms_storage_file` WHERE 0=1

03:49:52.2800.3 msSELECTSELECT * FROM `cms_tree` WHERE `cms_tree`.`id`='1'

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

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

03:49:52.2820.2 msSELECTSELECT * FROM `cms_tree` WHERE `id`=35

03:49:52.2820.3 msSELECTSELECT * FROM `cms_tree` WHERE `pid`=35 ORDER BY `priority`

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

03:49:52.2850.3 msSELECTSELECT * FROM `cms_tree` WHERE `id`=36

03:49:52.2850.4 msSELECTSELECT * FROM `cms_tree` WHERE `pid`=36 ORDER BY `priority`

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

03:49:52.2870.2 msSELECTSELECT * FROM `cms_tree` WHERE `id`=37

03:49:52.2870.4 msSELECTSELECT * FROM `cms_tree` WHERE `pid`=37 ORDER BY `priority`

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

03:49:52.2890.2 msSELECTSELECT * FROM `cms_tree` WHERE `id`=71

03:49:52.2890.4 msSELECTSELECT * FROM `cms_tree` WHERE `pid`=71 ORDER BY `priority`

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

03:49:52.2910.2 msSELECTSELECT * FROM `cms_tree` WHERE `id`=63

03:49:52.2910.2 msSELECTSELECT * FROM `cms_tree` WHERE `id`=69

03:49:52.2910.1 msSELECTSELECT * FROM `cms_tree` WHERE 0=1

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

03:49:52.2920.1 msSELECTSELECT * FROM `cms_tree` WHERE 0=1

03:49:52.2920.1 msSELECTSELECT * FROM `cms_tree` WHERE 0=1

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

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

03:49:52.3050.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=35

03:49:52.3050.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=36

03:49:52.3050.1 msSELECTSELECT * FROM `cms_tree` WHERE `id`=37

03:49:52.3050.0 msSELECTSELECT * FROM `cms_tree` WHERE `id`=71

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

03:49:52.3200.3 msSELECTSELECT * FROM `form2_form` WHERE `code`='callback'

03:49:52.3200.3 msSHOWSHOW FULL COLUMNS FROM `form2_form`
03:49:52.3200.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 = 'form2_form' AND kcu.table_name = 'form2_form'

03:49:52.3210.3 msSHOWSHOW FULL COLUMNS FROM `form2_form_send`
03:49:52.3210.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 = 'form2_form_send' AND kcu.table_name = 'form2_form_send'

03:49:52.3220.2 msSELECTSELECT * FROM `form2_form` WHERE `id`=3

03:49:52.3220.2 msSELECTSELECT * FROM `form2_form_property` WHERE `form_id`=3 ORDER BY `priority`

03:49:52.3220.3 msSHOWSHOW FULL COLUMNS FROM `form2_form_property`
03:49:52.3230.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 = 'form2_form_property' AND kcu.table_name = 'form2_form_property'

03:49:52.3230.2 msSELECTSELECT * FROM `form2_form_send_property` WHERE 0=1

03:49:52.3240.2 msSELECTSELECT * FROM `form2_form` WHERE `code`='feedback'

03:49:52.3250.2 msSELECTSELECT * FROM `form2_form` WHERE `id`=1

03:49:52.3250.2 msSELECTSELECT * FROM `form2_form_property` WHERE `form_id`=1 ORDER BY `priority`

03:49:52.3250.1 msSELECTSELECT * FROM `form2_form_send_property` WHERE 0=1