Кофемания. Кофе в кофемании


Кофемания Метрополис | Меню | Кофемания

Query Affected Num. rows Took (ms) ActionsSELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value`, `Setting`.`label`, `Setting`.`group`, `Setting`.`input_type`, `Setting`.`is_array` FROM `db_coffeemania_team`.`settings` AS `Setting` WHERE `Setting`.`group` = 'general' 7 7 0 SELECT `Product`.`id`, `Product`.`name`, `Product`.`title`, `Product`.`title_en`, `Product`.`type`, `Product`.`state`, `Product`.`slug`, `Product`.`price`, `Product`.`text`, `Product`.`text_en`, `Product`.`announce`, `Product`.`announce_en`, `Product`.`promo`, `Product`.`promo_en`, `Product`.`is_new`, `Product`.`parent_id`, `Product`.`lft`, `Product`.`rght`, `Product`.`created`, `Product`.`modified`, `Product`.`kkal` FROM `db_coffeemania_team`.`products` AS `Product` WHERE `Product`.`name` = 'menu' ORDER BY `Product`.`lft` asc LIMIT 1 1 1 4 maybe slowSELECT `Node`.`id`, `Node`.`title`, `Node`.`name`, `Node`.`title_en`, `Node`.`parent_id`, `Node`.`lft`, `Node`.`rght`, `Node`.`slug`, `Node`.`node_type`, `Node`.`node_state`, `Node`.`created`, `Node`.`modified`, `Node`.`published`, `Node`.`stopped`, `Node`.`user_id`, `Node`.`is_dictionary`, `Node`.`is_directory`, `Node`.`is_news`, `Node`.`image_count`, `Node`.`price_count`, `Node`.`order`, `Node`.`protected`, `Node`.`text`, `Node`.`text_en`, `Node`.`announce`, `Node`.`announce_en`, `Node`.`price`, `Node`.`email`, `Node`.`phone`, `Node`.`address`, `Node`.`address_en`, `Node`.`schedule`, `Node`.`schedule_en`, `Node`.`breakfast`, `Node`.`breakfast_en`, `Node`.`animators`, `Node`.`animators_en`, `Node`.`short_title`, `Node`.`short_title_en`, `Node`.`gps`, `Node`.`map`, `Node`.`map_en`, `Node`.`comment`, `Node`.`comment_en`, `Node`.`use_first_child`, `Node`.`promo`, `Node`.`promo_en`, `Node`.`parking_url`, `Node`.`address_2`, `Node`.`address_2_en`, `Node`.`address_3`, `Node`.`yandexmaps_id`, `Node`.`yandexmaps_working_time_en`, `Node`.`yandexmaps_working_time` FROM `db_coffeemania_team`.`nodes` AS `Node` WHERE `Node`.`name` = 'address' ORDER BY `Node`.`lft` asc LIMIT 1 1 1 6 maybe slowSELECT `Node`.`id`, `Node`.`title`, `Node`.`name`, `Node`.`title_en`, `Node`.`parent_id`, `Node`.`lft`, `Node`.`rght`, `Node`.`slug`, `Node`.`node_type`, `Node`.`node_state`, `Node`.`created`, `Node`.`modified`, `Node`.`published`, `Node`.`stopped`, `Node`.`user_id`, `Node`.`is_dictionary`, `Node`.`is_directory`, `Node`.`is_news`, `Node`.`image_count`, `Node`.`price_count`, `Node`.`order`, `Node`.`protected`, `Node`.`text`, `Node`.`text_en`, `Node`.`announce`, `Node`.`announce_en`, `Node`.`price`, `Node`.`email`, `Node`.`phone`, `Node`.`address`, `Node`.`address_en`, `Node`.`schedule`, `Node`.`schedule_en`, `Node`.`breakfast`, `Node`.`breakfast_en`, `Node`.`animators`, `Node`.`animators_en`, `Node`.`short_title`, `Node`.`short_title_en`, `Node`.`gps`, `Node`.`map`, `Node`.`map_en`, `Node`.`comment`, `Node`.`comment_en`, `Node`.`use_first_child`, `Node`.`promo`, `Node`.`promo_en`, `Node`.`parking_url`, `Node`.`address_2`, `Node`.`address_2_en`, `Node`.`address_3`, `Node`.`yandexmaps_id`, `Node`.`yandexmaps_working_time_en`, `Node`.`yandexmaps_working_time` FROM `db_coffeemania_team`.`nodes` AS `Node` WHERE `Node`.`parent_id` = 937 ORDER BY `Node`.`lft` asc 2 2 0 SELECT `Node`.`id`, `Node`.`title`, `Node`.`name`, `Node`.`title_en`, `Node`.`parent_id`, `Node`.`lft`, `Node`.`rght`, `Node`.`slug`, `Node`.`node_type`, `Node`.`node_state`, `Node`.`created`, `Node`.`modified`, `Node`.`published`, `Node`.`stopped`, `Node`.`user_id`, `Node`.`is_dictionary`, `Node`.`is_directory`, `Node`.`is_news`, `Node`.`image_count`, `Node`.`price_count`, `Node`.`order`, `Node`.`protected`, `Node`.`text`, `Node`.`text_en`, `Node`.`announce`, `Node`.`announce_en`, `Node`.`price`, `Node`.`email`, `Node`.`phone`, `Node`.`address`, `Node`.`address_en`, `Node`.`schedule`, `Node`.`schedule_en`, `Node`.`breakfast`, `Node`.`breakfast_en`, `Node`.`animators`, `Node`.`animators_en`, `Node`.`short_title`, `Node`.`short_title_en`, `Node`.`gps`, `Node`.`map`, `Node`.`map_en`, `Node`.`comment`, `Node`.`comment_en`, `Node`.`use_first_child`, `Node`.`promo`, `Node`.`promo_en`, `Node`.`parking_url`, `Node`.`address_2`, `Node`.`address_2_en`, `Node`.`address_3`, `Node`.`yandexmaps_id`, `Node`.`yandexmaps_working_time_en`, `Node`.`yandexmaps_working_time`, `Seo`.`id`, `Seo`.`node_id`, `Seo`.`title`, `Seo`.`title_en`, `Seo`.`keywords`, `Seo`.`keywords_en`, `Seo`.`description`, `Seo`.`description_en`, `ImageParameter`.`id`, `ImageParameter`.`node_id`, `ImageParameter`.`no_limits`, `ImageParameter`.`max_width`, `ImageParameter`.`max_height`, `ImageParameter`.`min_width`, `ImageParameter`.`min_height`, `ImageParameter`.`exact_width`, `ImageParameter`.`exact_height` FROM `db_coffeemania_team`.`nodes` AS `Node` LEFT JOIN `db_coffeemania_team`.`seos` AS `Seo` ON (`Seo`.`node_id` = `Node`.`id`) LEFT JOIN `db_coffeemania_team`.`image_parameters` AS `ImageParameter` ON (`ImageParameter`.`node_id` = `Node`.`id`) WHERE `Node`.`name` = 'metropolis' AND `Node`.`parent_id` IN (2003, 2004) ORDER BY `Node`.`lft` asc LIMIT 1 1 1 12 maybe slowSELECT `ChildNode`.`id`, `ChildNode`.`title`, `ChildNode`.`name`, `ChildNode`.`title_en`, `ChildNode`.`parent_id`, `ChildNode`.`lft`, `ChildNode`.`rght`, `ChildNode`.`slug`, `ChildNode`.`node_type`, `ChildNode`.`node_state`, `ChildNode`.`created`, `ChildNode`.`modified`, `ChildNode`.`published`, `ChildNode`.`stopped`, `ChildNode`.`user_id`, `ChildNode`.`is_dictionary`, `ChildNode`.`is_directory`, `ChildNode`.`is_news`, `ChildNode`.`image_count`, `ChildNode`.`price_count`, `ChildNode`.`order`, `ChildNode`.`protected`, `ChildNode`.`text`, `ChildNode`.`text_en`, `ChildNode`.`announce`, `ChildNode`.`announce_en`, `ChildNode`.`price`, `ChildNode`.`email`, `ChildNode`.`phone`, `ChildNode`.`address`, `ChildNode`.`address_en`, `ChildNode`.`schedule`, `ChildNode`.`schedule_en`, `ChildNode`.`breakfast`, `ChildNode`.`breakfast_en`, `ChildNode`.`animators`, `ChildNode`.`animators_en`, `ChildNode`.`short_title`, `ChildNode`.`short_title_en`, `ChildNode`.`gps`, `ChildNode`.`map`, `ChildNode`.`map_en`, `ChildNode`.`comment`, `ChildNode`.`comment_en`, `ChildNode`.`use_first_child`, `ChildNode`.`promo`, `ChildNode`.`promo_en`, `ChildNode`.`parking_url`, `ChildNode`.`address_2`, `ChildNode`.`address_2_en`, `ChildNode`.`address_3`, `ChildNode`.`yandexmaps_id`, `ChildNode`.`yandexmaps_working_time_en`, `ChildNode`.`yandexmaps_working_time` FROM `db_coffeemania_team`.`nodes` AS `ChildNode` WHERE `ChildNode`.`parent_id` = (3531) ORDER BY `lft` asc 1 1 14 maybe slowSELECT `Flag`.`id`, `Flag`.`name`, `Flag`.`node_id`, `Flag`.`value`, `Flag`.`label` FROM `db_coffeemania_team`.`flags` AS `Flag` WHERE `Flag`.`node_id` = (3531) 1 1 0 SELECT `Image`.`id`, `Image`.`model_id`, `Image`.`model_name`, `Image`.`name`, `Image`.`name_en`, `Image`.`title`, `Image`.`title_en`, `Image`.`description`, `Image`.`description_en`, `Image`.`order`, `Image`.`url`, `Image`.`url_en`, `Image`.`target`, `Image`.`css_class` FROM `db_coffeemania_team`.`images` AS `Image` WHERE `Image`.`model_name` = 'Node' AND `Image`.`model_id` = (3531) ORDER BY `Image`.`order` ASC 3 3 0 SELECT `Attachment`.`id`, `Attachment`.`model_id`, `Attachment`.`name`, `Attachment`.`name_en`, `Attachment`.`title`, `Attachment`.`title_en`, `Attachment`.`description`, `Attachment`.`description_en`, `Attachment`.`model_name`, `Attachment`.`order`, (CONCAT("/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name`)) AS `Attachment__src`, (CONCAT("/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name_en`)) AS `Attachment__src_en`, (CONCAT("/home/coffeemania/www/app/webroot/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name`)) AS `Attachment__path`, (CONCAT("/home/coffeemania/www/app/webroot/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name_en`)) AS `Attachment__path_en` FROM `db_coffeemania_team`.`attachments` AS `Attachment` WHERE `Attachment`.`model_name` = 'Node' AND `Attachment`.`model_id` = (3531) ORDER BY `Attachment`.`order` ASC 4 4 25 maybe slowSELECT `Link`.`id`, `Link`.`node_id`, `Link`.`name`, `Link`.`label`, `Link`.`url`, `Link`.`text`, `Link`.`title`, `Link`.`target` FROM `db_coffeemania_team`.`links` AS `Link` WHERE `Link`.`node_id` = (3531) 0 0 0 SELECT `Node`.`id`, `Node`.`title`, `Node`.`name`, `Node`.`title_en`, `Node`.`parent_id`, `Node`.`lft`, `Node`.`rght`, `Node`.`slug`, `Node`.`node_type`, `Node`.`node_state`, `Node`.`created`, `Node`.`modified`, `Node`.`published`, `Node`.`stopped`, `Node`.`user_id`, `Node`.`is_dictionary`, `Node`.`is_directory`, `Node`.`is_news`, `Node`.`image_count`, `Node`.`price_count`, `Node`.`order`, `Node`.`protected`, `Node`.`text`, `Node`.`text_en`, `Node`.`announce`, `Node`.`announce_en`, `Node`.`price`, `Node`.`email`, `Node`.`phone`, `Node`.`address`, `Node`.`address_en`, `Node`.`schedule`, `Node`.`schedule_en`, `Node`.`breakfast`, `Node`.`breakfast_en`, `Node`.`animators`, `Node`.`animators_en`, `Node`.`short_title`, `Node`.`short_title_en`, `Node`.`gps`, `Node`.`map`, `Node`.`map_en`, `Node`.`comment`, `Node`.`comment_en`, `Node`.`use_first_child`, `Node`.`promo`, `Node`.`promo_en`, `Node`.`parking_url`, `Node`.`address_2`, `Node`.`address_2_en`, `Node`.`address_3`, `Node`.`yandexmaps_id`, `Node`.`yandexmaps_working_time_en`, `Node`.`yandexmaps_working_time` FROM `db_coffeemania_team`.`nodes` AS `Node` WHERE `Node`.`name` = 'city_coffeeshops' ORDER BY `Node`.`lft` asc LIMIT 1 1 1 1 SELECT `Node`.`id`, `Node`.`title`, `Node`.`name`, `Node`.`title_en`, `Node`.`parent_id`, `Node`.`lft`, `Node`.`rght`, `Node`.`slug`, `Node`.`node_type`, `Node`.`node_state`, `Node`.`created`, `Node`.`modified`, `Node`.`published`, `Node`.`stopped`, `Node`.`user_id`, `Node`.`is_dictionary`, `Node`.`is_directory`, `Node`.`is_news`, `Node`.`image_count`, `Node`.`price_count`, `Node`.`order`, `Node`.`protected`, `Node`.`text`, `Node`.`text_en`, `Node`.`announce`, `Node`.`announce_en`, `Node`.`price`, `Node`.`email`, `Node`.`phone`, `Node`.`address`, `Node`.`address_en`, `Node`.`schedule`, `Node`.`schedule_en`, `Node`.`breakfast`, `Node`.`breakfast_en`, `Node`.`animators`, `Node`.`animators_en`, `Node`.`short_title`, `Node`.`short_title_en`, `Node`.`gps`, `Node`.`map`, `Node`.`map_en`, `Node`.`comment`, `Node`.`comment_en`, `Node`.`use_first_child`, `Node`.`promo`, `Node`.`promo_en`, `Node`.`parking_url`, `Node`.`address_2`, `Node`.`address_2_en`, `Node`.`address_3`, `Node`.`yandexmaps_id`, `Node`.`yandexmaps_working_time_en`, `Node`.`yandexmaps_working_time` FROM `db_coffeemania_team`.`nodes` AS `Node` WHERE `Node`.`parent_id` = 2003 AND `Node`.`node_state` = 'published' AND `Node`.`node_type` = 'place' ORDER BY `Node`.`lft` asc 19 19 1 maybe slowSELECT `Flag`.`id`, `Flag`.`name`, `Flag`.`node_id`, `Flag`.`value`, `Flag`.`label` FROM `db_coffeemania_team`.`flags` AS `Flag` WHERE `Flag`.`node_id` IN (944, 938, 1852, 2898, 1389, 942, 946, 1421, 3531, 941, 950, 844, 3362, 976, 947, 1300, 2649, 3363, 3413) 34 34 5 maybe slowSELECT `Image`.`id`, `Image`.`model_id`, `Image`.`model_name`, `Image`.`name`, `Image`.`name_en`, `Image`.`title`, `Image`.`title_en`, `Image`.`description`, `Image`.`description_en`, `Image`.`order`, `Image`.`url`, `Image`.`url_en`, `Image`.`target`, `Image`.`css_class` FROM `db_coffeemania_team`.`images` AS `Image` WHERE `Image`.`model_name` = 'Node' AND `Image`.`model_id` IN (944, 938, 1852, 2898, 1389, 942, 946, 1421, 3531, 941, 950, 844, 3362, 976, 947, 1300, 2649, 3363, 3413) ORDER BY `Image`.`order` ASC 186 186 0 SELECT `Attachment`.`id`, `Attachment`.`model_id`, `Attachment`.`name`, `Attachment`.`name_en`, `Attachment`.`title`, `Attachment`.`title_en`, `Attachment`.`description`, `Attachment`.`description_en`, `Attachment`.`model_name`, `Attachment`.`order`, (CONCAT("/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name`)) AS `Attachment__src`, (CONCAT("/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name_en`)) AS `Attachment__src_en`, (CONCAT("/home/coffeemania/www/app/webroot/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name`)) AS `Attachment__path`, (CONCAT("/home/coffeemania/www/app/webroot/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name_en`)) AS `Attachment__path_en` FROM `db_coffeemania_team`.`attachments` AS `Attachment` WHERE `Attachment`.`model_name` = 'Node' AND `Attachment`.`model_id` IN (944, 938, 1852, 2898, 1389, 942, 946, 1421, 3531, 941, 950, 844, 3362, 976, 947, 1300, 2649, 3363, 3413) ORDER BY `Attachment`.`order` ASC 76 76 20 maybe slowSELECT `Node`.`id`, `Node`.`title`, `Node`.`name`, `Node`.`title_en`, `Node`.`parent_id`, `Node`.`lft`, `Node`.`rght`, `Node`.`slug`, `Node`.`node_type`, `Node`.`node_state`, `Node`.`created`, `Node`.`modified`, `Node`.`published`, `Node`.`stopped`, `Node`.`user_id`, `Node`.`is_dictionary`, `Node`.`is_directory`, `Node`.`is_news`, `Node`.`image_count`, `Node`.`price_count`, `Node`.`order`, `Node`.`protected`, `Node`.`text`, `Node`.`text_en`, `Node`.`announce`, `Node`.`announce_en`, `Node`.`price`, `Node`.`email`, `Node`.`phone`, `Node`.`address`, `Node`.`address_en`, `Node`.`schedule`, `Node`.`schedule_en`, `Node`.`breakfast`, `Node`.`breakfast_en`, `Node`.`animators`, `Node`.`animators_en`, `Node`.`short_title`, `Node`.`short_title_en`, `Node`.`gps`, `Node`.`map`, `Node`.`map_en`, `Node`.`comment`, `Node`.`comment_en`, `Node`.`use_first_child`, `Node`.`promo`, `Node`.`promo_en`, `Node`.`parking_url`, `Node`.`address_2`, `Node`.`address_2_en`, `Node`.`address_3`, `Node`.`yandexmaps_id`, `Node`.`yandexmaps_working_time_en`, `Node`.`yandexmaps_working_time` FROM `db_coffeemania_team`.`nodes` AS `Node` WHERE `Node`.`name` = 'aero_coffeeshops' ORDER BY `Node`.`lft` asc LIMIT 1 1 1 0 SELECT `Node`.`id`, `Node`.`title`, `Node`.`name`, `Node`.`title_en`, `Node`.`parent_id`, `Node`.`lft`, `Node`.`rght`, `Node`.`slug`, `Node`.`node_type`, `Node`.`node_state`, `Node`.`created`, `Node`.`modified`, `Node`.`published`, `Node`.`stopped`, `Node`.`user_id`, `Node`.`is_dictionary`, `Node`.`is_directory`, `Node`.`is_news`, `Node`.`image_count`, `Node`.`price_count`, `Node`.`order`, `Node`.`protected`, `Node`.`text`, `Node`.`text_en`, `Node`.`announce`, `Node`.`announce_en`, `Node`.`price`, `Node`.`email`, `Node`.`phone`, `Node`.`address`, `Node`.`address_en`, `Node`.`schedule`, `Node`.`schedule_en`, `Node`.`breakfast`, `Node`.`breakfast_en`, `Node`.`animators`, `Node`.`animators_en`, `Node`.`short_title`, `Node`.`short_title_en`, `Node`.`gps`, `Node`.`map`, `Node`.`map_en`, `Node`.`comment`, `Node`.`comment_en`, `Node`.`use_first_child`, `Node`.`promo`, `Node`.`promo_en`, `Node`.`parking_url`, `Node`.`address_2`, `Node`.`address_2_en`, `Node`.`address_3`, `Node`.`yandexmaps_id`, `Node`.`yandexmaps_working_time_en`, `Node`.`yandexmaps_working_time` FROM `db_coffeemania_team`.`nodes` AS `Node` WHERE `Node`.`parent_id` = 2004 AND `Node`.`node_state` = 'published' AND `Node`.`node_type` = 'place' ORDER BY `Node`.`lft` asc 6 6 0 SELECT `Flag`.`id`, `Flag`.`name`, `Flag`.`node_id`, `Flag`.`value`, `Flag`.`label` FROM `db_coffeemania_team`.`flags` AS `Flag` WHERE `Flag`.`node_id` IN (835, 3196, 1224, 833, 3042, 2915) 5 5 0 SELECT `Image`.`id`, `Image`.`model_id`, `Image`.`model_name`, `Image`.`name`, `Image`.`name_en`, `Image`.`title`, `Image`.`title_en`, `Image`.`description`, `Image`.`description_en`, `Image`.`order`, `Image`.`url`, `Image`.`url_en`, `Image`.`target`, `Image`.`css_class` FROM `db_coffeemania_team`.`images` AS `Image` WHERE `Image`.`model_name` = 'Node' AND `Image`.`model_id` IN (835, 3196, 1224, 833, 3042, 2915) ORDER BY `Image`.`order` ASC 19 19 0 SELECT `Attachment`.`id`, `Attachment`.`model_id`, `Attachment`.`name`, `Attachment`.`name_en`, `Attachment`.`title`, `Attachment`.`title_en`, `Attachment`.`description`, `Attachment`.`description_en`, `Attachment`.`model_name`, `Attachment`.`order`, (CONCAT("/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name`)) AS `Attachment__src`, (CONCAT("/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name_en`)) AS `Attachment__src_en`, (CONCAT("/home/coffeemania/www/app/webroot/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name`)) AS `Attachment__path`, (CONCAT("/home/coffeemania/www/app/webroot/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name_en`)) AS `Attachment__path_en` FROM `db_coffeemania_team`.`attachments` AS `Attachment` WHERE `Attachment`.`model_name` = 'Node' AND `Attachment`.`model_id` IN (835, 3196, 1224, 833, 3042, 2915) ORDER BY `Attachment`.`order` ASC 18 18 0 SELECT `Node`.`id`, `Node`.`title`, `Node`.`name`, `Node`.`title_en`, `Node`.`parent_id`, `Node`.`lft`, `Node`.`rght`, `Node`.`slug`, `Node`.`node_type`, `Node`.`node_state`, `Node`.`created`, `Node`.`modified`, `Node`.`published`, `Node`.`stopped`, `Node`.`user_id`, `Node`.`is_dictionary`, `Node`.`is_directory`, `Node`.`is_news`, `Node`.`image_count`, `Node`.`price_count`, `Node`.`order`, `Node`.`protected`, `Node`.`text`, `Node`.`text_en`, `Node`.`announce`, `Node`.`announce_en`, `Node`.`price`, `Node`.`email`, `Node`.`phone`, `Node`.`address`, `Node`.`address_en`, `Node`.`schedule`, `Node`.`schedule_en`, `Node`.`breakfast`, `Node`.`breakfast_en`, `Node`.`animators`, `Node`.`animators_en`, `Node`.`short_title`, `Node`.`short_title_en`, `Node`.`gps`, `Node`.`map`, `Node`.`map_en`, `Node`.`comment`, `Node`.`comment_en`, `Node`.`use_first_child`, `Node`.`promo`, `Node`.`promo_en`, `Node`.`parking_url`, `Node`.`address_2`, `Node`.`address_2_en`, `Node`.`address_3`, `Node`.`yandexmaps_id`, `Node`.`yandexmaps_working_time_en`, `Node`.`yandexmaps_working_time` FROM `db_coffeemania_team`.`nodes` AS `Node` WHERE `Node`.`name` = 'aero_coffeeshops' ORDER BY `Node`.`lft` asc LIMIT 1 1 1 17 maybe slowSELECT `Node`.`id`, `Node`.`title`, `Node`.`name`, `Node`.`title_en`, `Node`.`parent_id`, `Node`.`lft`, `Node`.`rght`, `Node`.`slug`, `Node`.`node_type`, `Node`.`node_state`, `Node`.`created`, `Node`.`modified`, `Node`.`published`, `Node`.`stopped`, `Node`.`user_id`, `Node`.`is_dictionary`, `Node`.`is_directory`, `Node`.`is_news`, `Node`.`image_count`, `Node`.`price_count`, `Node`.`order`, `Node`.`protected`, `Node`.`text`, `Node`.`text_en`, `Node`.`announce`, `Node`.`announce_en`, `Node`.`price`, `Node`.`email`, `Node`.`phone`, `Node`.`address`, `Node`.`address_en`, `Node`.`schedule`, `Node`.`schedule_en`, `Node`.`breakfast`, `Node`.`breakfast_en`, `Node`.`animators`, `Node`.`animators_en`, `Node`.`short_title`, `Node`.`short_title_en`, `Node`.`gps`, `Node`.`map`, `Node`.`map_en`, `Node`.`comment`, `Node`.`comment_en`, `Node`.`use_first_child`, `Node`.`promo`, `Node`.`promo_en`, `Node`.`parking_url`, `Node`.`address_2`, `Node`.`address_2_en`, `Node`.`address_3`, `Node`.`yandexmaps_id`, `Node`.`yandexmaps_working_time_en`, `Node`.`yandexmaps_working_time` FROM `db_coffeemania_team`.`nodes` AS `Node` WHERE `Node`.`parent_id` = 2004 AND `Node`.`node_state` = 'published' AND `Node`.`node_type` = 'place' ORDER BY `Node`.`lft` asc 6 6 0 SELECT `Flag`.`id`, `Flag`.`name`, `Flag`.`node_id`, `Flag`.`value`, `Flag`.`label` FROM `db_coffeemania_team`.`flags` AS `Flag` WHERE `Flag`.`node_id` IN (835, 3196, 1224, 833, 3042, 2915) 5 5 0 SELECT `Image`.`id`, `Image`.`model_id`, `Image`.`model_name`, `Image`.`name`, `Image`.`name_en`, `Image`.`title`, `Image`.`title_en`, `Image`.`description`, `Image`.`description_en`, `Image`.`order`, `Image`.`url`, `Image`.`url_en`, `Image`.`target`, `Image`.`css_class` FROM `db_coffeemania_team`.`images` AS `Image` WHERE `Image`.`model_name` = 'Node' AND `Image`.`model_id` IN (835, 3196, 1224, 833, 3042, 2915) ORDER BY `Image`.`order` ASC 19 19 0 SELECT `Attachment`.`id`, `Attachment`.`model_id`, `Attachment`.`name`, `Attachment`.`name_en`, `Attachment`.`title`, `Attachment`.`title_en`, `Attachment`.`description`, `Attachment`.`description_en`, `Attachment`.`model_name`, `Attachment`.`order`, (CONCAT("/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name`)) AS `Attachment__src`, (CONCAT("/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name_en`)) AS `Attachment__src_en`, (CONCAT("/home/coffeemania/www/app/webroot/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name`)) AS `Attachment__path`, (CONCAT("/home/coffeemania/www/app/webroot/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name_en`)) AS `Attachment__path_en` FROM `db_coffeemania_team`.`attachments` AS `Attachment` WHERE `Attachment`.`model_name` = 'Node' AND `Attachment`.`model_id` IN (835, 3196, 1224, 833, 3042, 2915) ORDER BY `Attachment`.`order` ASC 18 18 0 SELECT `Node`.`id`, `Node`.`title`, `Node`.`name`, `Node`.`title_en`, `Node`.`parent_id`, `Node`.`lft`, `Node`.`rght`, `Node`.`slug`, `Node`.`node_type`, `Node`.`node_state`, `Node`.`created`, `Node`.`modified`, `Node`.`published`, `Node`.`stopped`, `Node`.`user_id`, `Node`.`is_dictionary`, `Node`.`is_directory`, `Node`.`is_news`, `Node`.`image_count`, `Node`.`price_count`, `Node`.`order`, `Node`.`protected`, `Node`.`text`, `Node`.`text_en`, `Node`.`announce`, `Node`.`announce_en`, `Node`.`price`, `Node`.`email`, `Node`.`phone`, `Node`.`address`, `Node`.`address_en`, `Node`.`schedule`, `Node`.`schedule_en`, `Node`.`breakfast`, `Node`.`breakfast_en`, `Node`.`animators`, `Node`.`animators_en`, `Node`.`short_title`, `Node`.`short_title_en`, `Node`.`gps`, `Node`.`map`, `Node`.`map_en`, `Node`.`comment`, `Node`.`comment_en`, `Node`.`use_first_child`, `Node`.`promo`, `Node`.`promo_en`, `Node`.`parking_url`, `Node`.`address_2`, `Node`.`address_2_en`, `Node`.`address_3`, `Node`.`yandexmaps_id`, `Node`.`yandexmaps_working_time_en`, `Node`.`yandexmaps_working_time`, `Seo`.`id`, `Seo`.`node_id`, `Seo`.`title`, `Seo`.`title_en`, `Seo`.`keywords`, `Seo`.`keywords_en`, `Seo`.`description`, `Seo`.`description_en` FROM `db_coffeemania_team`.`nodes` AS `Node` LEFT JOIN `db_coffeemania_team`.`seos` AS `Seo` ON (`Seo`.`node_id` = `Node`.`id`) WHERE `Node`.`name` = 'mainpage' ORDER BY `Node`.`lft` asc LIMIT 1 1 1 0 SELECT `Product`.`lft`, `Product`.`rght` FROM `db_coffeemania_team`.`products` AS `Product` WHERE `Product`.`id` = 2 LIMIT 1 1 1 21 maybe slowSELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`title`, `Product`.`announce`, `Product`.`promo` FROM `db_coffeemania_team`.`products` AS `Product` WHERE 1 = 1 AND `Product`.`lft` <= 1 AND `Product`.`rght` >= 946 ORDER BY `Product`.`lft` asc 1 1 0 SELECT `Menu`.`id`, `Menu`.`title`, `Menu`.`title_en`, `Menu`.`node_id`, `Menu`.`url`, `Menu`.`url_en`, `Menu`.`target`, `Menu`.`parent_id`, `Menu`.`rght`, `Menu`.`lft`, `Menu`.`description`, `Menu`.`description_en`, `Node`.`id`, `Node`.`name`, `Node`.`title`, `Node`.`title_en`, `Node`.`slug` FROM `db_coffeemania_team`.`menus` AS `Menu` LEFT JOIN `db_coffeemania_team`.`nodes` AS `Node` ON (`Menu`.`node_id` = `Node`.`id`) WHERE 1 = 1 ORDER BY `Menu`.`lft` ASC 12 12 0 SELECT `Image`.`id`, `Image`.`model_id`, `Image`.`model_name`, `Image`.`name`, `Image`.`name_en`, `Image`.`title`, `Image`.`title_en`, `Image`.`description`, `Image`.`description_en`, `Image`.`order`, `Image`.`url`, `Image`.`url_en`, `Image`.`target`, `Image`.`css_class` FROM `db_coffeemania_team`.`images` AS `Image` WHERE `Image`.`model_id` = 2 AND `Image`.`model_name` = 'Product' ORDER BY `Image`.`order` asc LIMIT 1 1 1 0 SELECT `Node`.`id`, `Node`.`title`, `Node`.`name`, `Node`.`title_en`, `Node`.`parent_id`, `Node`.`lft`, `Node`.`rght`, `Node`.`slug`, `Node`.`node_type`, `Node`.`node_state`, `Node`.`created`, `Node`.`modified`, `Node`.`published`, `Node`.`stopped`, `Node`.`user_id`, `Node`.`is_dictionary`, `Node`.`is_directory`, `Node`.`is_news`, `Node`.`image_count`, `Node`.`price_count`, `Node`.`order`, `Node`.`protected`, `Node`.`text`, `Node`.`text_en`, `Node`.`announce`, `Node`.`announce_en`, `Node`.`price`, `Node`.`email`, `Node`.`phone`, `Node`.`address`, `Node`.`address_en`, `Node`.`schedule`, `Node`.`schedule_en`, `Node`.`breakfast`, `Node`.`breakfast_en`, `Node`.`animators`, `Node`.`animators_en`, `Node`.`short_title`, `Node`.`short_title_en`, `Node`.`gps`, `Node`.`map`, `Node`.`map_en`, `Node`.`comment`, `Node`.`comment_en`, `Node`.`use_first_child`, `Node`.`promo`, `Node`.`promo_en`, `Node`.`parking_url`, `Node`.`address_2`, `Node`.`address_2_en`, `Node`.`address_3`, `Node`.`yandexmaps_id`, `Node`.`yandexmaps_working_time_en`, `Node`.`yandexmaps_working_time` FROM `db_coffeemania_team`.`nodes` AS `Node` WHERE `Node`.`name` = 'city_coffeeshops' ORDER BY `Node`.`lft` asc LIMIT 1 1 1 0 SELECT `Node`.`id`, `Node`.`title`, `Node`.`name`, `Node`.`title_en`, `Node`.`parent_id`, `Node`.`lft`, `Node`.`rght`, `Node`.`slug`, `Node`.`node_type`, `Node`.`node_state`, `Node`.`created`, `Node`.`modified`, `Node`.`published`, `Node`.`stopped`, `Node`.`user_id`, `Node`.`is_dictionary`, `Node`.`is_directory`, `Node`.`is_news`, `Node`.`image_count`, `Node`.`price_count`, `Node`.`order`, `Node`.`protected`, `Node`.`text`, `Node`.`text_en`, `Node`.`announce`, `Node`.`announce_en`, `Node`.`price`, `Node`.`email`, `Node`.`phone`, `Node`.`address`, `Node`.`address_en`, `Node`.`schedule`, `Node`.`schedule_en`, `Node`.`breakfast`, `Node`.`breakfast_en`, `Node`.`animators`, `Node`.`animators_en`, `Node`.`short_title`, `Node`.`short_title_en`, `Node`.`gps`, `Node`.`map`, `Node`.`map_en`, `Node`.`comment`, `Node`.`comment_en`, `Node`.`use_first_child`, `Node`.`promo`, `Node`.`promo_en`, `Node`.`parking_url`, `Node`.`address_2`, `Node`.`address_2_en`, `Node`.`address_3`, `Node`.`yandexmaps_id`, `Node`.`yandexmaps_working_time_en`, `Node`.`yandexmaps_working_time` FROM `db_coffeemania_team`.`nodes` AS `Node` WHERE `Node`.`name` = 'aero_coffeeshops' ORDER BY `Node`.`lft` asc LIMIT 1 1 1 0 SELECT `Node`.`id`, `Node`.`title`, `Node`.`name`, `Node`.`title_en`, `Node`.`parent_id`, `Node`.`lft`, `Node`.`rght`, `Node`.`slug`, `Node`.`node_type`, `Node`.`node_state`, `Node`.`created`, `Node`.`modified`, `Node`.`published`, `Node`.`stopped`, `Node`.`user_id`, `Node`.`is_dictionary`, `Node`.`is_directory`, `Node`.`is_news`, `Node`.`image_count`, `Node`.`price_count`, `Node`.`order`, `Node`.`protected`, `Node`.`text`, `Node`.`text_en`, `Node`.`announce`, `Node`.`announce_en`, `Node`.`price`, `Node`.`email`, `Node`.`phone`, `Node`.`address`, `Node`.`address_en`, `Node`.`schedule`, `Node`.`schedule_en`, `Node`.`breakfast`, `Node`.`breakfast_en`, `Node`.`animators`, `Node`.`animators_en`, `Node`.`short_title`, `Node`.`short_title_en`, `Node`.`gps`, `Node`.`map`, `Node`.`map_en`, `Node`.`comment`, `Node`.`comment_en`, `Node`.`use_first_child`, `Node`.`promo`, `Node`.`promo_en`, `Node`.`parking_url`, `Node`.`address_2`, `Node`.`address_2_en`, `Node`.`address_3`, `Node`.`yandexmaps_id`, `Node`.`yandexmaps_working_time_en`, `Node`.`yandexmaps_working_time`, `Seo`.`id`, `Seo`.`node_id`, `Seo`.`title`, `Seo`.`title_en`, `Seo`.`keywords`, `Seo`.`keywords_en`, `Seo`.`description`, `Seo`.`description_en`, `ImageParameter`.`id`, `ImageParameter`.`node_id`, `ImageParameter`.`no_limits`, `ImageParameter`.`max_width`, `ImageParameter`.`max_height`, `ImageParameter`.`min_width`, `ImageParameter`.`min_height`, `ImageParameter`.`exact_width`, `ImageParameter`.`exact_height` FROM `db_coffeemania_team`.`nodes` AS `Node` LEFT JOIN `db_coffeemania_team`.`seos` AS `Seo` ON (`Seo`.`node_id` = `Node`.`id`) LEFT JOIN `db_coffeemania_team`.`image_parameters` AS `ImageParameter` ON (`ImageParameter`.`node_id` = `Node`.`id`) WHERE `Node`.`parent_id` IN (2003, 2004) AND `Node`.`node_state` = 'published' ORDER BY `Node`.`lft` asc 983 983 25 SELECT `ChildNode`.`id`, `ChildNode`.`title`, `ChildNode`.`name`, `ChildNode`.`title_en`, `ChildNode`.`parent_id`, `ChildNode`.`lft`, `ChildNode`.`rght`, `ChildNode`.`slug`, `ChildNode`.`node_type`, `ChildNode`.`node_state`, `ChildNode`.`created`, `ChildNode`.`modified`, `ChildNode`.`published`, `ChildNode`.`stopped`, `ChildNode`.`user_id`, `ChildNode`.`is_dictionary`, `ChildNode`.`is_directory`, `ChildNode`.`is_news`, `ChildNode`.`image_count`, `ChildNode`.`price_count`, `ChildNode`.`order`, `ChildNode`.`protected`, `ChildNode`.`text`, `ChildNode`.`text_en`, `ChildNode`.`announce`, `ChildNode`.`announce_en`, `ChildNode`.`price`, `ChildNode`.`email`, `ChildNode`.`phone`, `ChildNode`.`address`, `ChildNode`.`address_en`, `ChildNode`.`schedule`, `ChildNode`.`schedule_en`, `ChildNode`.`breakfast`, `ChildNode`.`breakfast_en`, `ChildNode`.`animators`, `ChildNode`.`animators_en`, `ChildNode`.`short_title`, `ChildNode`.`short_title_en`, `ChildNode`.`gps`, `ChildNode`.`map`, `ChildNode`.`map_en`, `ChildNode`.`comment`, `ChildNode`.`comment_en`, `ChildNode`.`use_first_child`, `ChildNode`.`promo`, `ChildNode`.`promo_en`, `ChildNode`.`parking_url`, `ChildNode`.`address_2`, `ChildNode`.`address_2_en`, `ChildNode`.`address_3`, `ChildNode`.`yandexmaps_id`, `ChildNode`.`yandexmaps_working_time_en`, `ChildNode`.`yandexmaps_working_time` FROM `db_coffeemania_team`.`nodes` AS `ChildNode` WHERE `ChildNode`.`parent_id` IN (944, 938, 1852, 2898, 1389, 942, 946, 1421, 3531, 941, 950, 844, 3362, 976, 947, 1300, 2649, 3363, 3413, 835, 3196, 1224, 833, 3042, 2915) ORDER BY `lft` asc 18 18 0 SELECT `Flag`.`id`, `Flag`.`name`, `Flag`.`node_id`, `Flag`.`value`, `Flag`.`label` FROM `db_coffeemania_team`.`flags` AS `Flag` WHERE `Flag`.`node_id` IN (944, 938, 1852, 2898, 1389, 942, 946, 1421, 3531, 941, 950, 844, 3362, 976, 947, 1300, 2649, 3363, 3413, 835, 3196, 1224, 833, 3042, 2915) 39 39 0 SELECT `Image`.`id`, `Image`.`model_id`, `Image`.`model_name`, `Image`.`name`, `Image`.`name_en`, `Image`.`title`, `Image`.`title_en`, `Image`.`description`, `Image`.`description_en`, `Image`.`order`, `Image`.`url`, `Image`.`url_en`, `Image`.`target`, `Image`.`css_class` FROM `db_coffeemania_team`.`images` AS `Image` WHERE `Image`.`model_name` = 'Node' AND `Image`.`model_id` IN (944, 938, 1852, 2898, 1389, 942, 946, 1421, 3531, 941, 950, 844, 3362, 976, 947, 1300, 2649, 3363, 3413, 835, 3196, 1224, 833, 3042, 2915) ORDER BY `Image`.`order` ASC 205 205 1 SELECT `Attachment`.`id`, `Attachment`.`model_id`, `Attachment`.`name`, `Attachment`.`name_en`, `Attachment`.`title`, `Attachment`.`title_en`, `Attachment`.`description`, `Attachment`.`description_en`, `Attachment`.`model_name`, `Attachment`.`order`, (CONCAT("/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name`)) AS `Attachment__src`, (CONCAT("/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name_en`)) AS `Attachment__src_en`, (CONCAT("/home/coffeemania/www/app/webroot/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name`)) AS `Attachment__path`, (CONCAT("/home/coffeemania/www/app/webroot/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name_en`)) AS `Attachment__path_en` FROM `db_coffeemania_team`.`attachments` AS `Attachment` WHERE `Attachment`.`model_name` = 'Node' AND `Attachment`.`model_id` IN (944, 938, 1852, 2898, 1389, 942, 946, 1421, 3531, 941, 950, 844, 3362, 976, 947, 1300, 2649, 3363, 3413, 835, 3196, 1224, 833, 3042, 2915) ORDER BY `Attachment`.`order` ASC 94 94 11 maybe slowSELECT `Link`.`id`, `Link`.`node_id`, `Link`.`name`, `Link`.`label`, `Link`.`url`, `Link`.`text`, `Link`.`title`, `Link`.`target` FROM `db_coffeemania_team`.`links` AS `Link` WHERE `Link`.`node_id` IN (944, 938, 1852, 2898, 1389, 942, 946, 1421, 3531, 941, 950, 844, 3362, 976, 947, 1300, 2649, 3363, 3413, 835, 3196, 1224, 833, 3042, 2915) 0 0 18 maybe slow

7 duplicate queries run.

coffeemania.ru

Кофемания на Усачёвском | Меню

Query Affected Num. rows Took (ms) ActionsSELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value`, `Setting`.`label`, `Setting`.`group`, `Setting`.`input_type`, `Setting`.`is_array` FROM `db_coffeemania_team`.`settings` AS `Setting` WHERE `Setting`.`group` = 'general' 7 7 2 maybe slowSELECT `Product`.`id`, `Product`.`name`, `Product`.`title`, `Product`.`title_en`, `Product`.`type`, `Product`.`state`, `Product`.`slug`, `Product`.`price`, `Product`.`text`, `Product`.`text_en`, `Product`.`announce`, `Product`.`announce_en`, `Product`.`promo`, `Product`.`promo_en`, `Product`.`is_new`, `Product`.`parent_id`, `Product`.`lft`, `Product`.`rght`, `Product`.`created`, `Product`.`modified`, `Product`.`kkal` FROM `db_coffeemania_team`.`products` AS `Product` WHERE `Product`.`name` = 'menu' ORDER BY `Product`.`lft` asc LIMIT 1 1 1 1 SELECT `Node`.`id`, `Node`.`title`, `Node`.`name`, `Node`.`title_en`, `Node`.`parent_id`, `Node`.`lft`, `Node`.`rght`, `Node`.`slug`, `Node`.`node_type`, `Node`.`node_state`, `Node`.`created`, `Node`.`modified`, `Node`.`published`, `Node`.`stopped`, `Node`.`user_id`, `Node`.`is_dictionary`, `Node`.`is_directory`, `Node`.`is_news`, `Node`.`image_count`, `Node`.`price_count`, `Node`.`order`, `Node`.`protected`, `Node`.`text`, `Node`.`text_en`, `Node`.`announce`, `Node`.`announce_en`, `Node`.`price`, `Node`.`email`, `Node`.`phone`, `Node`.`address`, `Node`.`address_en`, `Node`.`schedule`, `Node`.`schedule_en`, `Node`.`breakfast`, `Node`.`breakfast_en`, `Node`.`animators`, `Node`.`animators_en`, `Node`.`short_title`, `Node`.`short_title_en`, `Node`.`gps`, `Node`.`map`, `Node`.`map_en`, `Node`.`comment`, `Node`.`comment_en`, `Node`.`use_first_child`, `Node`.`promo`, `Node`.`promo_en`, `Node`.`parking_url`, `Node`.`address_2`, `Node`.`address_2_en`, `Node`.`address_3`, `Node`.`yandexmaps_id`, `Node`.`yandexmaps_working_time_en`, `Node`.`yandexmaps_working_time` FROM `db_coffeemania_team`.`nodes` AS `Node` WHERE `Node`.`name` = 'address' ORDER BY `Node`.`lft` asc LIMIT 1 1 1 11 maybe slowSELECT `Node`.`id`, `Node`.`title`, `Node`.`name`, `Node`.`title_en`, `Node`.`parent_id`, `Node`.`lft`, `Node`.`rght`, `Node`.`slug`, `Node`.`node_type`, `Node`.`node_state`, `Node`.`created`, `Node`.`modified`, `Node`.`published`, `Node`.`stopped`, `Node`.`user_id`, `Node`.`is_dictionary`, `Node`.`is_directory`, `Node`.`is_news`, `Node`.`image_count`, `Node`.`price_count`, `Node`.`order`, `Node`.`protected`, `Node`.`text`, `Node`.`text_en`, `Node`.`announce`, `Node`.`announce_en`, `Node`.`price`, `Node`.`email`, `Node`.`phone`, `Node`.`address`, `Node`.`address_en`, `Node`.`schedule`, `Node`.`schedule_en`, `Node`.`breakfast`, `Node`.`breakfast_en`, `Node`.`animators`, `Node`.`animators_en`, `Node`.`short_title`, `Node`.`short_title_en`, `Node`.`gps`, `Node`.`map`, `Node`.`map_en`, `Node`.`comment`, `Node`.`comment_en`, `Node`.`use_first_child`, `Node`.`promo`, `Node`.`promo_en`, `Node`.`parking_url`, `Node`.`address_2`, `Node`.`address_2_en`, `Node`.`address_3`, `Node`.`yandexmaps_id`, `Node`.`yandexmaps_working_time_en`, `Node`.`yandexmaps_working_time` FROM `db_coffeemania_team`.`nodes` AS `Node` WHERE `Node`.`parent_id` = 937 ORDER BY `Node`.`lft` asc 2 2 2 SELECT `Node`.`id`, `Node`.`title`, `Node`.`name`, `Node`.`title_en`, `Node`.`parent_id`, `Node`.`lft`, `Node`.`rght`, `Node`.`slug`, `Node`.`node_type`, `Node`.`node_state`, `Node`.`created`, `Node`.`modified`, `Node`.`published`, `Node`.`stopped`, `Node`.`user_id`, `Node`.`is_dictionary`, `Node`.`is_directory`, `Node`.`is_news`, `Node`.`image_count`, `Node`.`price_count`, `Node`.`order`, `Node`.`protected`, `Node`.`text`, `Node`.`text_en`, `Node`.`announce`, `Node`.`announce_en`, `Node`.`price`, `Node`.`email`, `Node`.`phone`, `Node`.`address`, `Node`.`address_en`, `Node`.`schedule`, `Node`.`schedule_en`, `Node`.`breakfast`, `Node`.`breakfast_en`, `Node`.`animators`, `Node`.`animators_en`, `Node`.`short_title`, `Node`.`short_title_en`, `Node`.`gps`, `Node`.`map`, `Node`.`map_en`, `Node`.`comment`, `Node`.`comment_en`, `Node`.`use_first_child`, `Node`.`promo`, `Node`.`promo_en`, `Node`.`parking_url`, `Node`.`address_2`, `Node`.`address_2_en`, `Node`.`address_3`, `Node`.`yandexmaps_id`, `Node`.`yandexmaps_working_time_en`, `Node`.`yandexmaps_working_time`, `Seo`.`id`, `Seo`.`node_id`, `Seo`.`title`, `Seo`.`title_en`, `Seo`.`keywords`, `Seo`.`keywords_en`, `Seo`.`description`, `Seo`.`description_en`, `ImageParameter`.`id`, `ImageParameter`.`node_id`, `ImageParameter`.`no_limits`, `ImageParameter`.`max_width`, `ImageParameter`.`max_height`, `ImageParameter`.`min_width`, `ImageParameter`.`min_height`, `ImageParameter`.`exact_width`, `ImageParameter`.`exact_height` FROM `db_coffeemania_team`.`nodes` AS `Node` LEFT JOIN `db_coffeemania_team`.`seos` AS `Seo` ON (`Seo`.`node_id` = `Node`.`id`) LEFT JOIN `db_coffeemania_team`.`image_parameters` AS `ImageParameter` ON (`ImageParameter`.`node_id` = `Node`.`id`) WHERE `Node`.`name` = 'usachevskiy' AND `Node`.`parent_id` IN (2003, 2004) ORDER BY `Node`.`lft` asc LIMIT 1 1 1 20 maybe slowSELECT `ChildNode`.`id`, `ChildNode`.`title`, `ChildNode`.`name`, `ChildNode`.`title_en`, `ChildNode`.`parent_id`, `ChildNode`.`lft`, `ChildNode`.`rght`, `ChildNode`.`slug`, `ChildNode`.`node_type`, `ChildNode`.`node_state`, `ChildNode`.`created`, `ChildNode`.`modified`, `ChildNode`.`published`, `ChildNode`.`stopped`, `ChildNode`.`user_id`, `ChildNode`.`is_dictionary`, `ChildNode`.`is_directory`, `ChildNode`.`is_news`, `ChildNode`.`image_count`, `ChildNode`.`price_count`, `ChildNode`.`order`, `ChildNode`.`protected`, `ChildNode`.`text`, `ChildNode`.`text_en`, `ChildNode`.`announce`, `ChildNode`.`announce_en`, `ChildNode`.`price`, `ChildNode`.`email`, `ChildNode`.`phone`, `ChildNode`.`address`, `ChildNode`.`address_en`, `ChildNode`.`schedule`, `ChildNode`.`schedule_en`, `ChildNode`.`breakfast`, `ChildNode`.`breakfast_en`, `ChildNode`.`animators`, `ChildNode`.`animators_en`, `ChildNode`.`short_title`, `ChildNode`.`short_title_en`, `ChildNode`.`gps`, `ChildNode`.`map`, `ChildNode`.`map_en`, `ChildNode`.`comment`, `ChildNode`.`comment_en`, `ChildNode`.`use_first_child`, `ChildNode`.`promo`, `ChildNode`.`promo_en`, `ChildNode`.`parking_url`, `ChildNode`.`address_2`, `ChildNode`.`address_2_en`, `ChildNode`.`address_3`, `ChildNode`.`yandexmaps_id`, `ChildNode`.`yandexmaps_working_time_en`, `ChildNode`.`yandexmaps_working_time` FROM `db_coffeemania_team`.`nodes` AS `ChildNode` WHERE `ChildNode`.`parent_id` = (3413) ORDER BY `lft` asc 1 1 3 maybe slowSELECT `Flag`.`id`, `Flag`.`name`, `Flag`.`node_id`, `Flag`.`value`, `Flag`.`label` FROM `db_coffeemania_team`.`flags` AS `Flag` WHERE `Flag`.`node_id` = (3413) 2 2 0 SELECT `Image`.`id`, `Image`.`model_id`, `Image`.`model_name`, `Image`.`name`, `Image`.`name_en`, `Image`.`title`, `Image`.`title_en`, `Image`.`description`, `Image`.`description_en`, `Image`.`order`, `Image`.`url`, `Image`.`url_en`, `Image`.`target`, `Image`.`css_class` FROM `db_coffeemania_team`.`images` AS `Image` WHERE `Image`.`model_name` = 'Node' AND `Image`.`model_id` = (3413) ORDER BY `Image`.`order` ASC 4 4 0 SELECT `Attachment`.`id`, `Attachment`.`model_id`, `Attachment`.`name`, `Attachment`.`name_en`, `Attachment`.`title`, `Attachment`.`title_en`, `Attachment`.`description`, `Attachment`.`description_en`, `Attachment`.`model_name`, `Attachment`.`order`, (CONCAT("/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name`)) AS `Attachment__src`, (CONCAT("/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name_en`)) AS `Attachment__src_en`, (CONCAT("/home/coffeemania/www/app/webroot/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name`)) AS `Attachment__path`, (CONCAT("/home/coffeemania/www/app/webroot/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name_en`)) AS `Attachment__path_en` FROM `db_coffeemania_team`.`attachments` AS `Attachment` WHERE `Attachment`.`model_name` = 'Node' AND `Attachment`.`model_id` = (3413) ORDER BY `Attachment`.`order` ASC 4 4 3 maybe slowSELECT `Link`.`id`, `Link`.`node_id`, `Link`.`name`, `Link`.`label`, `Link`.`url`, `Link`.`text`, `Link`.`title`, `Link`.`target` FROM `db_coffeemania_team`.`links` AS `Link` WHERE `Link`.`node_id` = (3413) 0 0 0 SELECT `Node`.`id`, `Node`.`title`, `Node`.`name`, `Node`.`title_en`, `Node`.`parent_id`, `Node`.`lft`, `Node`.`rght`, `Node`.`slug`, `Node`.`node_type`, `Node`.`node_state`, `Node`.`created`, `Node`.`modified`, `Node`.`published`, `Node`.`stopped`, `Node`.`user_id`, `Node`.`is_dictionary`, `Node`.`is_directory`, `Node`.`is_news`, `Node`.`image_count`, `Node`.`price_count`, `Node`.`order`, `Node`.`protected`, `Node`.`text`, `Node`.`text_en`, `Node`.`announce`, `Node`.`announce_en`, `Node`.`price`, `Node`.`email`, `Node`.`phone`, `Node`.`address`, `Node`.`address_en`, `Node`.`schedule`, `Node`.`schedule_en`, `Node`.`breakfast`, `Node`.`breakfast_en`, `Node`.`animators`, `Node`.`animators_en`, `Node`.`short_title`, `Node`.`short_title_en`, `Node`.`gps`, `Node`.`map`, `Node`.`map_en`, `Node`.`comment`, `Node`.`comment_en`, `Node`.`use_first_child`, `Node`.`promo`, `Node`.`promo_en`, `Node`.`parking_url`, `Node`.`address_2`, `Node`.`address_2_en`, `Node`.`address_3`, `Node`.`yandexmaps_id`, `Node`.`yandexmaps_working_time_en`, `Node`.`yandexmaps_working_time` FROM `db_coffeemania_team`.`nodes` AS `Node` WHERE `Node`.`name` = 'city_coffeeshops' ORDER BY `Node`.`lft` asc LIMIT 1 1 1 10 maybe slowSELECT `Node`.`id`, `Node`.`title`, `Node`.`name`, `Node`.`title_en`, `Node`.`parent_id`, `Node`.`lft`, `Node`.`rght`, `Node`.`slug`, `Node`.`node_type`, `Node`.`node_state`, `Node`.`created`, `Node`.`modified`, `Node`.`published`, `Node`.`stopped`, `Node`.`user_id`, `Node`.`is_dictionary`, `Node`.`is_directory`, `Node`.`is_news`, `Node`.`image_count`, `Node`.`price_count`, `Node`.`order`, `Node`.`protected`, `Node`.`text`, `Node`.`text_en`, `Node`.`announce`, `Node`.`announce_en`, `Node`.`price`, `Node`.`email`, `Node`.`phone`, `Node`.`address`, `Node`.`address_en`, `Node`.`schedule`, `Node`.`schedule_en`, `Node`.`breakfast`, `Node`.`breakfast_en`, `Node`.`animators`, `Node`.`animators_en`, `Node`.`short_title`, `Node`.`short_title_en`, `Node`.`gps`, `Node`.`map`, `Node`.`map_en`, `Node`.`comment`, `Node`.`comment_en`, `Node`.`use_first_child`, `Node`.`promo`, `Node`.`promo_en`, `Node`.`parking_url`, `Node`.`address_2`, `Node`.`address_2_en`, `Node`.`address_3`, `Node`.`yandexmaps_id`, `Node`.`yandexmaps_working_time_en`, `Node`.`yandexmaps_working_time` FROM `db_coffeemania_team`.`nodes` AS `Node` WHERE `Node`.`parent_id` = 2003 AND `Node`.`node_state` = 'published' AND `Node`.`node_type` = 'place' ORDER BY `Node`.`lft` asc 19 19 0 SELECT `Flag`.`id`, `Flag`.`name`, `Flag`.`node_id`, `Flag`.`value`, `Flag`.`label` FROM `db_coffeemania_team`.`flags` AS `Flag` WHERE `Flag`.`node_id` IN (944, 938, 1852, 2898, 1389, 942, 946, 1421, 3531, 941, 950, 844, 3362, 976, 947, 1300, 2649, 3363, 3413) 34 34 0 SELECT `Image`.`id`, `Image`.`model_id`, `Image`.`model_name`, `Image`.`name`, `Image`.`name_en`, `Image`.`title`, `Image`.`title_en`, `Image`.`description`, `Image`.`description_en`, `Image`.`order`, `Image`.`url`, `Image`.`url_en`, `Image`.`target`, `Image`.`css_class` FROM `db_coffeemania_team`.`images` AS `Image` WHERE `Image`.`model_name` = 'Node' AND `Image`.`model_id` IN (944, 938, 1852, 2898, 1389, 942, 946, 1421, 3531, 941, 950, 844, 3362, 976, 947, 1300, 2649, 3363, 3413) ORDER BY `Image`.`order` ASC 186 186 0 SELECT `Attachment`.`id`, `Attachment`.`model_id`, `Attachment`.`name`, `Attachment`.`name_en`, `Attachment`.`title`, `Attachment`.`title_en`, `Attachment`.`description`, `Attachment`.`description_en`, `Attachment`.`model_name`, `Attachment`.`order`, (CONCAT("/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name`)) AS `Attachment__src`, (CONCAT("/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name_en`)) AS `Attachment__src_en`, (CONCAT("/home/coffeemania/www/app/webroot/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name`)) AS `Attachment__path`, (CONCAT("/home/coffeemania/www/app/webroot/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name_en`)) AS `Attachment__path_en` FROM `db_coffeemania_team`.`attachments` AS `Attachment` WHERE `Attachment`.`model_name` = 'Node' AND `Attachment`.`model_id` IN (944, 938, 1852, 2898, 1389, 942, 946, 1421, 3531, 941, 950, 844, 3362, 976, 947, 1300, 2649, 3363, 3413) ORDER BY `Attachment`.`order` ASC 76 76 19 maybe slowSELECT `Node`.`id`, `Node`.`title`, `Node`.`name`, `Node`.`title_en`, `Node`.`parent_id`, `Node`.`lft`, `Node`.`rght`, `Node`.`slug`, `Node`.`node_type`, `Node`.`node_state`, `Node`.`created`, `Node`.`modified`, `Node`.`published`, `Node`.`stopped`, `Node`.`user_id`, `Node`.`is_dictionary`, `Node`.`is_directory`, `Node`.`is_news`, `Node`.`image_count`, `Node`.`price_count`, `Node`.`order`, `Node`.`protected`, `Node`.`text`, `Node`.`text_en`, `Node`.`announce`, `Node`.`announce_en`, `Node`.`price`, `Node`.`email`, `Node`.`phone`, `Node`.`address`, `Node`.`address_en`, `Node`.`schedule`, `Node`.`schedule_en`, `Node`.`breakfast`, `Node`.`breakfast_en`, `Node`.`animators`, `Node`.`animators_en`, `Node`.`short_title`, `Node`.`short_title_en`, `Node`.`gps`, `Node`.`map`, `Node`.`map_en`, `Node`.`comment`, `Node`.`comment_en`, `Node`.`use_first_child`, `Node`.`promo`, `Node`.`promo_en`, `Node`.`parking_url`, `Node`.`address_2`, `Node`.`address_2_en`, `Node`.`address_3`, `Node`.`yandexmaps_id`, `Node`.`yandexmaps_working_time_en`, `Node`.`yandexmaps_working_time` FROM `db_coffeemania_team`.`nodes` AS `Node` WHERE `Node`.`name` = 'aero_coffeeshops' ORDER BY `Node`.`lft` asc LIMIT 1 1 1 0 SELECT `Node`.`id`, `Node`.`title`, `Node`.`name`, `Node`.`title_en`, `Node`.`parent_id`, `Node`.`lft`, `Node`.`rght`, `Node`.`slug`, `Node`.`node_type`, `Node`.`node_state`, `Node`.`created`, `Node`.`modified`, `Node`.`published`, `Node`.`stopped`, `Node`.`user_id`, `Node`.`is_dictionary`, `Node`.`is_directory`, `Node`.`is_news`, `Node`.`image_count`, `Node`.`price_count`, `Node`.`order`, `Node`.`protected`, `Node`.`text`, `Node`.`text_en`, `Node`.`announce`, `Node`.`announce_en`, `Node`.`price`, `Node`.`email`, `Node`.`phone`, `Node`.`address`, `Node`.`address_en`, `Node`.`schedule`, `Node`.`schedule_en`, `Node`.`breakfast`, `Node`.`breakfast_en`, `Node`.`animators`, `Node`.`animators_en`, `Node`.`short_title`, `Node`.`short_title_en`, `Node`.`gps`, `Node`.`map`, `Node`.`map_en`, `Node`.`comment`, `Node`.`comment_en`, `Node`.`use_first_child`, `Node`.`promo`, `Node`.`promo_en`, `Node`.`parking_url`, `Node`.`address_2`, `Node`.`address_2_en`, `Node`.`address_3`, `Node`.`yandexmaps_id`, `Node`.`yandexmaps_working_time_en`, `Node`.`yandexmaps_working_time` FROM `db_coffeemania_team`.`nodes` AS `Node` WHERE `Node`.`parent_id` = 2004 AND `Node`.`node_state` = 'published' AND `Node`.`node_type` = 'place' ORDER BY `Node`.`lft` asc 6 6 0 SELECT `Flag`.`id`, `Flag`.`name`, `Flag`.`node_id`, `Flag`.`value`, `Flag`.`label` FROM `db_coffeemania_team`.`flags` AS `Flag` WHERE `Flag`.`node_id` IN (835, 3196, 1224, 833, 3042, 2915) 5 5 0 SELECT `Image`.`id`, `Image`.`model_id`, `Image`.`model_name`, `Image`.`name`, `Image`.`name_en`, `Image`.`title`, `Image`.`title_en`, `Image`.`description`, `Image`.`description_en`, `Image`.`order`, `Image`.`url`, `Image`.`url_en`, `Image`.`target`, `Image`.`css_class` FROM `db_coffeemania_team`.`images` AS `Image` WHERE `Image`.`model_name` = 'Node' AND `Image`.`model_id` IN (835, 3196, 1224, 833, 3042, 2915) ORDER BY `Image`.`order` ASC 19 19 0 SELECT `Attachment`.`id`, `Attachment`.`model_id`, `Attachment`.`name`, `Attachment`.`name_en`, `Attachment`.`title`, `Attachment`.`title_en`, `Attachment`.`description`, `Attachment`.`description_en`, `Attachment`.`model_name`, `Attachment`.`order`, (CONCAT("/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name`)) AS `Attachment__src`, (CONCAT("/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name_en`)) AS `Attachment__src_en`, (CONCAT("/home/coffeemania/www/app/webroot/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name`)) AS `Attachment__path`, (CONCAT("/home/coffeemania/www/app/webroot/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name_en`)) AS `Attachment__path_en` FROM `db_coffeemania_team`.`attachments` AS `Attachment` WHERE `Attachment`.`model_name` = 'Node' AND `Attachment`.`model_id` IN (835, 3196, 1224, 833, 3042, 2915) ORDER BY `Attachment`.`order` ASC 18 18 17 maybe slowSELECT `Node`.`id`, `Node`.`title`, `Node`.`name`, `Node`.`title_en`, `Node`.`parent_id`, `Node`.`lft`, `Node`.`rght`, `Node`.`slug`, `Node`.`node_type`, `Node`.`node_state`, `Node`.`created`, `Node`.`modified`, `Node`.`published`, `Node`.`stopped`, `Node`.`user_id`, `Node`.`is_dictionary`, `Node`.`is_directory`, `Node`.`is_news`, `Node`.`image_count`, `Node`.`price_count`, `Node`.`order`, `Node`.`protected`, `Node`.`text`, `Node`.`text_en`, `Node`.`announce`, `Node`.`announce_en`, `Node`.`price`, `Node`.`email`, `Node`.`phone`, `Node`.`address`, `Node`.`address_en`, `Node`.`schedule`, `Node`.`schedule_en`, `Node`.`breakfast`, `Node`.`breakfast_en`, `Node`.`animators`, `Node`.`animators_en`, `Node`.`short_title`, `Node`.`short_title_en`, `Node`.`gps`, `Node`.`map`, `Node`.`map_en`, `Node`.`comment`, `Node`.`comment_en`, `Node`.`use_first_child`, `Node`.`promo`, `Node`.`promo_en`, `Node`.`parking_url`, `Node`.`address_2`, `Node`.`address_2_en`, `Node`.`address_3`, `Node`.`yandexmaps_id`, `Node`.`yandexmaps_working_time_en`, `Node`.`yandexmaps_working_time` FROM `db_coffeemania_team`.`nodes` AS `Node` WHERE `Node`.`name` = 'aero_coffeeshops' ORDER BY `Node`.`lft` asc LIMIT 1 1 1 0 SELECT `Node`.`id`, `Node`.`title`, `Node`.`name`, `Node`.`title_en`, `Node`.`parent_id`, `Node`.`lft`, `Node`.`rght`, `Node`.`slug`, `Node`.`node_type`, `Node`.`node_state`, `Node`.`created`, `Node`.`modified`, `Node`.`published`, `Node`.`stopped`, `Node`.`user_id`, `Node`.`is_dictionary`, `Node`.`is_directory`, `Node`.`is_news`, `Node`.`image_count`, `Node`.`price_count`, `Node`.`order`, `Node`.`protected`, `Node`.`text`, `Node`.`text_en`, `Node`.`announce`, `Node`.`announce_en`, `Node`.`price`, `Node`.`email`, `Node`.`phone`, `Node`.`address`, `Node`.`address_en`, `Node`.`schedule`, `Node`.`schedule_en`, `Node`.`breakfast`, `Node`.`breakfast_en`, `Node`.`animators`, `Node`.`animators_en`, `Node`.`short_title`, `Node`.`short_title_en`, `Node`.`gps`, `Node`.`map`, `Node`.`map_en`, `Node`.`comment`, `Node`.`comment_en`, `Node`.`use_first_child`, `Node`.`promo`, `Node`.`promo_en`, `Node`.`parking_url`, `Node`.`address_2`, `Node`.`address_2_en`, `Node`.`address_3`, `Node`.`yandexmaps_id`, `Node`.`yandexmaps_working_time_en`, `Node`.`yandexmaps_working_time` FROM `db_coffeemania_team`.`nodes` AS `Node` WHERE `Node`.`parent_id` = 2004 AND `Node`.`node_state` = 'published' AND `Node`.`node_type` = 'place' ORDER BY `Node`.`lft` asc 6 6 0 SELECT `Flag`.`id`, `Flag`.`name`, `Flag`.`node_id`, `Flag`.`value`, `Flag`.`label` FROM `db_coffeemania_team`.`flags` AS `Flag` WHERE `Flag`.`node_id` IN (835, 3196, 1224, 833, 3042, 2915) 5 5 0 SELECT `Image`.`id`, `Image`.`model_id`, `Image`.`model_name`, `Image`.`name`, `Image`.`name_en`, `Image`.`title`, `Image`.`title_en`, `Image`.`description`, `Image`.`description_en`, `Image`.`order`, `Image`.`url`, `Image`.`url_en`, `Image`.`target`, `Image`.`css_class` FROM `db_coffeemania_team`.`images` AS `Image` WHERE `Image`.`model_name` = 'Node' AND `Image`.`model_id` IN (835, 3196, 1224, 833, 3042, 2915) ORDER BY `Image`.`order` ASC 19 19 0 SELECT `Attachment`.`id`, `Attachment`.`model_id`, `Attachment`.`name`, `Attachment`.`name_en`, `Attachment`.`title`, `Attachment`.`title_en`, `Attachment`.`description`, `Attachment`.`description_en`, `Attachment`.`model_name`, `Attachment`.`order`, (CONCAT("/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name`)) AS `Attachment__src`, (CONCAT("/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name_en`)) AS `Attachment__src_en`, (CONCAT("/home/coffeemania/www/app/webroot/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name`)) AS `Attachment__path`, (CONCAT("/home/coffeemania/www/app/webroot/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name_en`)) AS `Attachment__path_en` FROM `db_coffeemania_team`.`attachments` AS `Attachment` WHERE `Attachment`.`model_name` = 'Node' AND `Attachment`.`model_id` IN (835, 3196, 1224, 833, 3042, 2915) ORDER BY `Attachment`.`order` ASC 18 18 0 SELECT `Node`.`id`, `Node`.`title`, `Node`.`name`, `Node`.`title_en`, `Node`.`parent_id`, `Node`.`lft`, `Node`.`rght`, `Node`.`slug`, `Node`.`node_type`, `Node`.`node_state`, `Node`.`created`, `Node`.`modified`, `Node`.`published`, `Node`.`stopped`, `Node`.`user_id`, `Node`.`is_dictionary`, `Node`.`is_directory`, `Node`.`is_news`, `Node`.`image_count`, `Node`.`price_count`, `Node`.`order`, `Node`.`protected`, `Node`.`text`, `Node`.`text_en`, `Node`.`announce`, `Node`.`announce_en`, `Node`.`price`, `Node`.`email`, `Node`.`phone`, `Node`.`address`, `Node`.`address_en`, `Node`.`schedule`, `Node`.`schedule_en`, `Node`.`breakfast`, `Node`.`breakfast_en`, `Node`.`animators`, `Node`.`animators_en`, `Node`.`short_title`, `Node`.`short_title_en`, `Node`.`gps`, `Node`.`map`, `Node`.`map_en`, `Node`.`comment`, `Node`.`comment_en`, `Node`.`use_first_child`, `Node`.`promo`, `Node`.`promo_en`, `Node`.`parking_url`, `Node`.`address_2`, `Node`.`address_2_en`, `Node`.`address_3`, `Node`.`yandexmaps_id`, `Node`.`yandexmaps_working_time_en`, `Node`.`yandexmaps_working_time`, `Seo`.`id`, `Seo`.`node_id`, `Seo`.`title`, `Seo`.`title_en`, `Seo`.`keywords`, `Seo`.`keywords_en`, `Seo`.`description`, `Seo`.`description_en` FROM `db_coffeemania_team`.`nodes` AS `Node` LEFT JOIN `db_coffeemania_team`.`seos` AS `Seo` ON (`Seo`.`node_id` = `Node`.`id`) WHERE `Node`.`name` = 'mainpage' ORDER BY `Node`.`lft` asc LIMIT 1 1 1 0 SELECT `Product`.`lft`, `Product`.`rght` FROM `db_coffeemania_team`.`products` AS `Product` WHERE `Product`.`id` = 2 LIMIT 1 1 1 0 SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`title`, `Product`.`announce`, `Product`.`promo` FROM `db_coffeemania_team`.`products` AS `Product` WHERE 1 = 1 AND `Product`.`lft` <= 1 AND `Product`.`rght` >= 946 ORDER BY `Product`.`lft` asc 1 1 0 SELECT `Menu`.`id`, `Menu`.`title`, `Menu`.`title_en`, `Menu`.`node_id`, `Menu`.`url`, `Menu`.`url_en`, `Menu`.`target`, `Menu`.`parent_id`, `Menu`.`rght`, `Menu`.`lft`, `Menu`.`description`, `Menu`.`description_en`, `Node`.`id`, `Node`.`name`, `Node`.`title`, `Node`.`title_en`, `Node`.`slug` FROM `db_coffeemania_team`.`menus` AS `Menu` LEFT JOIN `db_coffeemania_team`.`nodes` AS `Node` ON (`Menu`.`node_id` = `Node`.`id`) WHERE 1 = 1 ORDER BY `Menu`.`lft` ASC 12 12 0 SELECT `Image`.`id`, `Image`.`model_id`, `Image`.`model_name`, `Image`.`name`, `Image`.`name_en`, `Image`.`title`, `Image`.`title_en`, `Image`.`description`, `Image`.`description_en`, `Image`.`order`, `Image`.`url`, `Image`.`url_en`, `Image`.`target`, `Image`.`css_class` FROM `db_coffeemania_team`.`images` AS `Image` WHERE `Image`.`model_id` = 2 AND `Image`.`model_name` = 'Product' ORDER BY `Image`.`order` asc LIMIT 1 1 1 0 SELECT `Node`.`id`, `Node`.`title`, `Node`.`name`, `Node`.`title_en`, `Node`.`parent_id`, `Node`.`lft`, `Node`.`rght`, `Node`.`slug`, `Node`.`node_type`, `Node`.`node_state`, `Node`.`created`, `Node`.`modified`, `Node`.`published`, `Node`.`stopped`, `Node`.`user_id`, `Node`.`is_dictionary`, `Node`.`is_directory`, `Node`.`is_news`, `Node`.`image_count`, `Node`.`price_count`, `Node`.`order`, `Node`.`protected`, `Node`.`text`, `Node`.`text_en`, `Node`.`announce`, `Node`.`announce_en`, `Node`.`price`, `Node`.`email`, `Node`.`phone`, `Node`.`address`, `Node`.`address_en`, `Node`.`schedule`, `Node`.`schedule_en`, `Node`.`breakfast`, `Node`.`breakfast_en`, `Node`.`animators`, `Node`.`animators_en`, `Node`.`short_title`, `Node`.`short_title_en`, `Node`.`gps`, `Node`.`map`, `Node`.`map_en`, `Node`.`comment`, `Node`.`comment_en`, `Node`.`use_first_child`, `Node`.`promo`, `Node`.`promo_en`, `Node`.`parking_url`, `Node`.`address_2`, `Node`.`address_2_en`, `Node`.`address_3`, `Node`.`yandexmaps_id`, `Node`.`yandexmaps_working_time_en`, `Node`.`yandexmaps_working_time` FROM `db_coffeemania_team`.`nodes` AS `Node` WHERE `Node`.`name` = 'city_coffeeshops' ORDER BY `Node`.`lft` asc LIMIT 1 1 1 20 maybe slowSELECT `Node`.`id`, `Node`.`title`, `Node`.`name`, `Node`.`title_en`, `Node`.`parent_id`, `Node`.`lft`, `Node`.`rght`, `Node`.`slug`, `Node`.`node_type`, `Node`.`node_state`, `Node`.`created`, `Node`.`modified`, `Node`.`published`, `Node`.`stopped`, `Node`.`user_id`, `Node`.`is_dictionary`, `Node`.`is_directory`, `Node`.`is_news`, `Node`.`image_count`, `Node`.`price_count`, `Node`.`order`, `Node`.`protected`, `Node`.`text`, `Node`.`text_en`, `Node`.`announce`, `Node`.`announce_en`, `Node`.`price`, `Node`.`email`, `Node`.`phone`, `Node`.`address`, `Node`.`address_en`, `Node`.`schedule`, `Node`.`schedule_en`, `Node`.`breakfast`, `Node`.`breakfast_en`, `Node`.`animators`, `Node`.`animators_en`, `Node`.`short_title`, `Node`.`short_title_en`, `Node`.`gps`, `Node`.`map`, `Node`.`map_en`, `Node`.`comment`, `Node`.`comment_en`, `Node`.`use_first_child`, `Node`.`promo`, `Node`.`promo_en`, `Node`.`parking_url`, `Node`.`address_2`, `Node`.`address_2_en`, `Node`.`address_3`, `Node`.`yandexmaps_id`, `Node`.`yandexmaps_working_time_en`, `Node`.`yandexmaps_working_time` FROM `db_coffeemania_team`.`nodes` AS `Node` WHERE `Node`.`name` = 'aero_coffeeshops' ORDER BY `Node`.`lft` asc LIMIT 1 1 1 0 SELECT `Node`.`id`, `Node`.`title`, `Node`.`name`, `Node`.`title_en`, `Node`.`parent_id`, `Node`.`lft`, `Node`.`rght`, `Node`.`slug`, `Node`.`node_type`, `Node`.`node_state`, `Node`.`created`, `Node`.`modified`, `Node`.`published`, `Node`.`stopped`, `Node`.`user_id`, `Node`.`is_dictionary`, `Node`.`is_directory`, `Node`.`is_news`, `Node`.`image_count`, `Node`.`price_count`, `Node`.`order`, `Node`.`protected`, `Node`.`text`, `Node`.`text_en`, `Node`.`announce`, `Node`.`announce_en`, `Node`.`price`, `Node`.`email`, `Node`.`phone`, `Node`.`address`, `Node`.`address_en`, `Node`.`schedule`, `Node`.`schedule_en`, `Node`.`breakfast`, `Node`.`breakfast_en`, `Node`.`animators`, `Node`.`animators_en`, `Node`.`short_title`, `Node`.`short_title_en`, `Node`.`gps`, `Node`.`map`, `Node`.`map_en`, `Node`.`comment`, `Node`.`comment_en`, `Node`.`use_first_child`, `Node`.`promo`, `Node`.`promo_en`, `Node`.`parking_url`, `Node`.`address_2`, `Node`.`address_2_en`, `Node`.`address_3`, `Node`.`yandexmaps_id`, `Node`.`yandexmaps_working_time_en`, `Node`.`yandexmaps_working_time`, `Seo`.`id`, `Seo`.`node_id`, `Seo`.`title`, `Seo`.`title_en`, `Seo`.`keywords`, `Seo`.`keywords_en`, `Seo`.`description`, `Seo`.`description_en`, `ImageParameter`.`id`, `ImageParameter`.`node_id`, `ImageParameter`.`no_limits`, `ImageParameter`.`max_width`, `ImageParameter`.`max_height`, `ImageParameter`.`min_width`, `ImageParameter`.`min_height`, `ImageParameter`.`exact_width`, `ImageParameter`.`exact_height` FROM `db_coffeemania_team`.`nodes` AS `Node` LEFT JOIN `db_coffeemania_team`.`seos` AS `Seo` ON (`Seo`.`node_id` = `Node`.`id`) LEFT JOIN `db_coffeemania_team`.`image_parameters` AS `ImageParameter` ON (`ImageParameter`.`node_id` = `Node`.`id`) WHERE `Node`.`parent_id` IN (2003, 2004) AND `Node`.`node_state` = 'published' ORDER BY `Node`.`lft` asc 983 983 2 SELECT `ChildNode`.`id`, `ChildNode`.`title`, `ChildNode`.`name`, `ChildNode`.`title_en`, `ChildNode`.`parent_id`, `ChildNode`.`lft`, `ChildNode`.`rght`, `ChildNode`.`slug`, `ChildNode`.`node_type`, `ChildNode`.`node_state`, `ChildNode`.`created`, `ChildNode`.`modified`, `ChildNode`.`published`, `ChildNode`.`stopped`, `ChildNode`.`user_id`, `ChildNode`.`is_dictionary`, `ChildNode`.`is_directory`, `ChildNode`.`is_news`, `ChildNode`.`image_count`, `ChildNode`.`price_count`, `ChildNode`.`order`, `ChildNode`.`protected`, `ChildNode`.`text`, `ChildNode`.`text_en`, `ChildNode`.`announce`, `ChildNode`.`announce_en`, `ChildNode`.`price`, `ChildNode`.`email`, `ChildNode`.`phone`, `ChildNode`.`address`, `ChildNode`.`address_en`, `ChildNode`.`schedule`, `ChildNode`.`schedule_en`, `ChildNode`.`breakfast`, `ChildNode`.`breakfast_en`, `ChildNode`.`animators`, `ChildNode`.`animators_en`, `ChildNode`.`short_title`, `ChildNode`.`short_title_en`, `ChildNode`.`gps`, `ChildNode`.`map`, `ChildNode`.`map_en`, `ChildNode`.`comment`, `ChildNode`.`comment_en`, `ChildNode`.`use_first_child`, `ChildNode`.`promo`, `ChildNode`.`promo_en`, `ChildNode`.`parking_url`, `ChildNode`.`address_2`, `ChildNode`.`address_2_en`, `ChildNode`.`address_3`, `ChildNode`.`yandexmaps_id`, `ChildNode`.`yandexmaps_working_time_en`, `ChildNode`.`yandexmaps_working_time` FROM `db_coffeemania_team`.`nodes` AS `ChildNode` WHERE `ChildNode`.`parent_id` IN (944, 938, 1852, 2898, 1389, 942, 946, 1421, 3531, 941, 950, 844, 3362, 976, 947, 1300, 2649, 3363, 3413, 835, 3196, 1224, 833, 3042, 2915) ORDER BY `lft` asc 18 18 0 SELECT `Flag`.`id`, `Flag`.`name`, `Flag`.`node_id`, `Flag`.`value`, `Flag`.`label` FROM `db_coffeemania_team`.`flags` AS `Flag` WHERE `Flag`.`node_id` IN (944, 938, 1852, 2898, 1389, 942, 946, 1421, 3531, 941, 950, 844, 3362, 976, 947, 1300, 2649, 3363, 3413, 835, 3196, 1224, 833, 3042, 2915) 39 39 0 SELECT `Image`.`id`, `Image`.`model_id`, `Image`.`model_name`, `Image`.`name`, `Image`.`name_en`, `Image`.`title`, `Image`.`title_en`, `Image`.`description`, `Image`.`description_en`, `Image`.`order`, `Image`.`url`, `Image`.`url_en`, `Image`.`target`, `Image`.`css_class` FROM `db_coffeemania_team`.`images` AS `Image` WHERE `Image`.`model_name` = 'Node' AND `Image`.`model_id` IN (944, 938, 1852, 2898, 1389, 942, 946, 1421, 3531, 941, 950, 844, 3362, 976, 947, 1300, 2649, 3363, 3413, 835, 3196, 1224, 833, 3042, 2915) ORDER BY `Image`.`order` ASC 205 205 0 SELECT `Attachment`.`id`, `Attachment`.`model_id`, `Attachment`.`name`, `Attachment`.`name_en`, `Attachment`.`title`, `Attachment`.`title_en`, `Attachment`.`description`, `Attachment`.`description_en`, `Attachment`.`model_name`, `Attachment`.`order`, (CONCAT("/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name`)) AS `Attachment__src`, (CONCAT("/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name_en`)) AS `Attachment__src_en`, (CONCAT("/home/coffeemania/www/app/webroot/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name`)) AS `Attachment__path`, (CONCAT("/home/coffeemania/www/app/webroot/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name_en`)) AS `Attachment__path_en` FROM `db_coffeemania_team`.`attachments` AS `Attachment` WHERE `Attachment`.`model_name` = 'Node' AND `Attachment`.`model_id` IN (944, 938, 1852, 2898, 1389, 942, 946, 1421, 3531, 941, 950, 844, 3362, 976, 947, 1300, 2649, 3363, 3413, 835, 3196, 1224, 833, 3042, 2915) ORDER BY `Attachment`.`order` ASC 94 94 8 maybe slowSELECT `Link`.`id`, `Link`.`node_id`, `Link`.`name`, `Link`.`label`, `Link`.`url`, `Link`.`text`, `Link`.`title`, `Link`.`target` FROM `db_coffeemania_team`.`links` AS `Link` WHERE `Link`.`node_id` IN (944, 938, 1852, 2898, 1389, 942, 946, 1421, 3531, 941, 950, 844, 3362, 976, 947, 1300, 2649, 3363, 3413, 835, 3196, 1224, 833, 3042, 2915) 0 0 1 maybe slow

7 duplicate queries run.

coffeemania.ru

О компании | Кофемания | Кофемания

Query Affected Num. rows Took (ms) ActionsSELECT `Node`.`id`, `Node`.`slug` FROM `db_coffeemania_team`.`nodes` AS `Node` WHERE `Node`.`slug` = '/coffeemania/about' ORDER BY `Node`.`lft` asc LIMIT 1 1 1 0 SELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value`, `Setting`.`label`, `Setting`.`group`, `Setting`.`input_type`, `Setting`.`is_array` FROM `db_coffeemania_team`.`settings` AS `Setting` WHERE `Setting`.`group` = 'general' 7 7 4 maybe slowSELECT `Node`.`id`, `Node`.`title`, `Node`.`name`, `Node`.`title_en`, `Node`.`parent_id`, `Node`.`lft`, `Node`.`rght`, `Node`.`slug`, `Node`.`node_type`, `Node`.`node_state`, `Node`.`created`, `Node`.`modified`, `Node`.`published`, `Node`.`stopped`, `Node`.`user_id`, `Node`.`is_dictionary`, `Node`.`is_directory`, `Node`.`is_news`, `Node`.`image_count`, `Node`.`price_count`, `Node`.`order`, `Node`.`protected`, `Node`.`text`, `Node`.`text_en`, `Node`.`announce`, `Node`.`announce_en`, `Node`.`price`, `Node`.`email`, `Node`.`phone`, `Node`.`address`, `Node`.`address_en`, `Node`.`schedule`, `Node`.`schedule_en`, `Node`.`breakfast`, `Node`.`breakfast_en`, `Node`.`animators`, `Node`.`animators_en`, `Node`.`short_title`, `Node`.`short_title_en`, `Node`.`gps`, `Node`.`map`, `Node`.`map_en`, `Node`.`comment`, `Node`.`comment_en`, `Node`.`use_first_child`, `Node`.`promo`, `Node`.`promo_en`, `Node`.`parking_url`, `Node`.`address_2`, `Node`.`address_2_en`, `Node`.`address_3`, `Node`.`yandexmaps_id`, `Node`.`yandexmaps_working_time_en`, `Node`.`yandexmaps_working_time`, `Seo`.`id`, `Seo`.`node_id`, `Seo`.`title`, `Seo`.`title_en`, `Seo`.`keywords`, `Seo`.`keywords_en`, `Seo`.`description`, `Seo`.`description_en`, `ImageParameter`.`id`, `ImageParameter`.`node_id`, `ImageParameter`.`no_limits`, `ImageParameter`.`max_width`, `ImageParameter`.`max_height`, `ImageParameter`.`min_width`, `ImageParameter`.`min_height`, `ImageParameter`.`exact_width`, `ImageParameter`.`exact_height` FROM `db_coffeemania_team`.`nodes` AS `Node` LEFT JOIN `db_coffeemania_team`.`seos` AS `Seo` ON (`Seo`.`node_id` = `Node`.`id`) LEFT JOIN `db_coffeemania_team`.`image_parameters` AS `ImageParameter` ON (`ImageParameter`.`node_id` = `Node`.`id`) WHERE `Node`.`id` = 819 ORDER BY `Node`.`lft` asc LIMIT 1 1 1 2 maybe slowSELECT `ChildNode`.`id`, `ChildNode`.`title`, `ChildNode`.`name`, `ChildNode`.`title_en`, `ChildNode`.`parent_id`, `ChildNode`.`lft`, `ChildNode`.`rght`, `ChildNode`.`slug`, `ChildNode`.`node_type`, `ChildNode`.`node_state`, `ChildNode`.`created`, `ChildNode`.`modified`, `ChildNode`.`published`, `ChildNode`.`stopped`, `ChildNode`.`user_id`, `ChildNode`.`is_dictionary`, `ChildNode`.`is_directory`, `ChildNode`.`is_news`, `ChildNode`.`image_count`, `ChildNode`.`price_count`, `ChildNode`.`order`, `ChildNode`.`protected`, `ChildNode`.`text`, `ChildNode`.`text_en`, `ChildNode`.`announce`, `ChildNode`.`announce_en`, `ChildNode`.`price`, `ChildNode`.`email`, `ChildNode`.`phone`, `ChildNode`.`address`, `ChildNode`.`address_en`, `ChildNode`.`schedule`, `ChildNode`.`schedule_en`, `ChildNode`.`breakfast`, `ChildNode`.`breakfast_en`, `ChildNode`.`animators`, `ChildNode`.`animators_en`, `ChildNode`.`short_title`, `ChildNode`.`short_title_en`, `ChildNode`.`gps`, `ChildNode`.`map`, `ChildNode`.`map_en`, `ChildNode`.`comment`, `ChildNode`.`comment_en`, `ChildNode`.`use_first_child`, `ChildNode`.`promo`, `ChildNode`.`promo_en`, `ChildNode`.`parking_url`, `ChildNode`.`address_2`, `ChildNode`.`address_2_en`, `ChildNode`.`address_3`, `ChildNode`.`yandexmaps_id`, `ChildNode`.`yandexmaps_working_time_en`, `ChildNode`.`yandexmaps_working_time` FROM `db_coffeemania_team`.`nodes` AS `ChildNode` WHERE `ChildNode`.`parent_id` = (819) ORDER BY `lft` asc 0 0 2 maybe slowSELECT `Flag`.`id`, `Flag`.`name`, `Flag`.`node_id`, `Flag`.`value`, `Flag`.`label` FROM `db_coffeemania_team`.`flags` AS `Flag` WHERE `Flag`.`node_id` = (819) 0 0 2 maybe slowSELECT `Image`.`id`, `Image`.`model_id`, `Image`.`model_name`, `Image`.`name`, `Image`.`name_en`, `Image`.`title`, `Image`.`title_en`, `Image`.`description`, `Image`.`description_en`, `Image`.`order`, `Image`.`url`, `Image`.`url_en`, `Image`.`target`, `Image`.`css_class` FROM `db_coffeemania_team`.`images` AS `Image` WHERE `Image`.`model_name` = 'Node' AND `Image`.`model_id` = (819) ORDER BY `Image`.`order` ASC 0 0 0 SELECT `Attachment`.`id`, `Attachment`.`model_id`, `Attachment`.`name`, `Attachment`.`name_en`, `Attachment`.`title`, `Attachment`.`title_en`, `Attachment`.`description`, `Attachment`.`description_en`, `Attachment`.`model_name`, `Attachment`.`order`, (CONCAT("/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name`)) AS `Attachment__src`, (CONCAT("/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name_en`)) AS `Attachment__src_en`, (CONCAT("/home/coffeemania/www/app/webroot/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name`)) AS `Attachment__path`, (CONCAT("/home/coffeemania/www/app/webroot/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name_en`)) AS `Attachment__path_en` FROM `db_coffeemania_team`.`attachments` AS `Attachment` WHERE `Attachment`.`model_name` = 'Node' AND `Attachment`.`model_id` = (819) ORDER BY `Attachment`.`order` ASC 0 0 2 maybe slowSELECT `Link`.`id`, `Link`.`node_id`, `Link`.`name`, `Link`.`label`, `Link`.`url`, `Link`.`text`, `Link`.`title`, `Link`.`target` FROM `db_coffeemania_team`.`links` AS `Link` WHERE `Link`.`node_id` = (819) 0 0 0 SELECT `Node`.`lft`, `Node`.`rght` FROM `db_coffeemania_team`.`nodes` AS `Node` WHERE `Node`.`id` = 819 LIMIT 1 1 1 1 SELECT `Node`.`id`, `Node`.`name`, `Node`.`slug`, `Node`.`title`, `Node`.`announce`, `Node`.`promo` FROM `db_coffeemania_team`.`nodes` AS `Node` WHERE 1 = 1 AND `Node`.`lft` <= 3 AND `Node`.`rght` >= 4 ORDER BY `Node`.`lft` asc 3 3 0 SELECT `Seo`.`node_id`, `Seo`.`title` FROM `db_coffeemania_team`.`seos` AS `Seo` WHERE `Seo`.`node_id` IN (1, 818, 819) 291 291 1 SELECT `Seo`.`node_id`, `Seo`.`description` FROM `db_coffeemania_team`.`seos` AS `Seo` WHERE `Seo`.`node_id` IN (1, 818, 819) 291 291 2 SELECT `Menu`.`id`, `Menu`.`title`, `Menu`.`title_en`, `Menu`.`node_id`, `Menu`.`url`, `Menu`.`url_en`, `Menu`.`target`, `Menu`.`parent_id`, `Menu`.`rght`, `Menu`.`lft`, `Menu`.`description`, `Menu`.`description_en`, `Node`.`id`, `Node`.`name`, `Node`.`title`, `Node`.`title_en`, `Node`.`slug` FROM `db_coffeemania_team`.`menus` AS `Menu` LEFT JOIN `db_coffeemania_team`.`nodes` AS `Node` ON (`Menu`.`node_id` = `Node`.`id`) WHERE 1 = 1 ORDER BY `Menu`.`lft` ASC 12 12 1 maybe slowSELECT `Node`.`id`, `Node`.`title`, `Node`.`name`, `Node`.`title_en`, `Node`.`parent_id`, `Node`.`lft`, `Node`.`rght`, `Node`.`slug`, `Node`.`node_type`, `Node`.`node_state`, `Node`.`created`, `Node`.`modified`, `Node`.`published`, `Node`.`stopped`, `Node`.`user_id`, `Node`.`is_dictionary`, `Node`.`is_directory`, `Node`.`is_news`, `Node`.`image_count`, `Node`.`price_count`, `Node`.`order`, `Node`.`protected`, `Node`.`text`, `Node`.`text_en`, `Node`.`announce`, `Node`.`announce_en`, `Node`.`price`, `Node`.`email`, `Node`.`phone`, `Node`.`address`, `Node`.`address_en`, `Node`.`schedule`, `Node`.`schedule_en`, `Node`.`breakfast`, `Node`.`breakfast_en`, `Node`.`animators`, `Node`.`animators_en`, `Node`.`short_title`, `Node`.`short_title_en`, `Node`.`gps`, `Node`.`map`, `Node`.`map_en`, `Node`.`comment`, `Node`.`comment_en`, `Node`.`use_first_child`, `Node`.`promo`, `Node`.`promo_en`, `Node`.`parking_url`, `Node`.`address_2`, `Node`.`address_2_en`, `Node`.`address_3`, `Node`.`yandexmaps_id`, `Node`.`yandexmaps_working_time_en`, `Node`.`yandexmaps_working_time` FROM `db_coffeemania_team`.`nodes` AS `Node` WHERE `Node`.`parent_id` = 818 AND `Node`.`node_state` = 'published' ORDER BY `Node`.`lft` asc 11 11 0 SELECT `Image`.`id`, `Image`.`model_id`, `Image`.`model_name`, `Image`.`name`, `Image`.`name_en`, `Image`.`title`, `Image`.`title_en`, `Image`.`description`, `Image`.`description_en`, `Image`.`order`, `Image`.`url`, `Image`.`url_en`, `Image`.`target`, `Image`.`css_class` FROM `db_coffeemania_team`.`images` AS `Image` WHERE `Image`.`model_id` = 818 AND `Image`.`model_name` = 'Node' ORDER BY `Image`.`order` asc LIMIT 1 1 1 0 SELECT `Node`.`id`, `Node`.`title`, `Node`.`name`, `Node`.`title_en`, `Node`.`parent_id`, `Node`.`lft`, `Node`.`rght`, `Node`.`slug`, `Node`.`node_type`, `Node`.`node_state`, `Node`.`created`, `Node`.`modified`, `Node`.`published`, `Node`.`stopped`, `Node`.`user_id`, `Node`.`is_dictionary`, `Node`.`is_directory`, `Node`.`is_news`, `Node`.`image_count`, `Node`.`price_count`, `Node`.`order`, `Node`.`protected`, `Node`.`text`, `Node`.`text_en`, `Node`.`announce`, `Node`.`announce_en`, `Node`.`price`, `Node`.`email`, `Node`.`phone`, `Node`.`address`, `Node`.`address_en`, `Node`.`schedule`, `Node`.`schedule_en`, `Node`.`breakfast`, `Node`.`breakfast_en`, `Node`.`animators`, `Node`.`animators_en`, `Node`.`short_title`, `Node`.`short_title_en`, `Node`.`gps`, `Node`.`map`, `Node`.`map_en`, `Node`.`comment`, `Node`.`comment_en`, `Node`.`use_first_child`, `Node`.`promo`, `Node`.`promo_en`, `Node`.`parking_url`, `Node`.`address_2`, `Node`.`address_2_en`, `Node`.`address_3`, `Node`.`yandexmaps_id`, `Node`.`yandexmaps_working_time_en`, `Node`.`yandexmaps_working_time` FROM `db_coffeemania_team`.`nodes` AS `Node` WHERE `Node`.`name` = 'city_coffeeshops' ORDER BY `Node`.`lft` asc LIMIT 1 1 1 0 SELECT `Node`.`id`, `Node`.`title`, `Node`.`name`, `Node`.`title_en`, `Node`.`parent_id`, `Node`.`lft`, `Node`.`rght`, `Node`.`slug`, `Node`.`node_type`, `Node`.`node_state`, `Node`.`created`, `Node`.`modified`, `Node`.`published`, `Node`.`stopped`, `Node`.`user_id`, `Node`.`is_dictionary`, `Node`.`is_directory`, `Node`.`is_news`, `Node`.`image_count`, `Node`.`price_count`, `Node`.`order`, `Node`.`protected`, `Node`.`text`, `Node`.`text_en`, `Node`.`announce`, `Node`.`announce_en`, `Node`.`price`, `Node`.`email`, `Node`.`phone`, `Node`.`address`, `Node`.`address_en`, `Node`.`schedule`, `Node`.`schedule_en`, `Node`.`breakfast`, `Node`.`breakfast_en`, `Node`.`animators`, `Node`.`animators_en`, `Node`.`short_title`, `Node`.`short_title_en`, `Node`.`gps`, `Node`.`map`, `Node`.`map_en`, `Node`.`comment`, `Node`.`comment_en`, `Node`.`use_first_child`, `Node`.`promo`, `Node`.`promo_en`, `Node`.`parking_url`, `Node`.`address_2`, `Node`.`address_2_en`, `Node`.`address_3`, `Node`.`yandexmaps_id`, `Node`.`yandexmaps_working_time_en`, `Node`.`yandexmaps_working_time` FROM `db_coffeemania_team`.`nodes` AS `Node` WHERE `Node`.`name` = 'aero_coffeeshops' ORDER BY `Node`.`lft` asc LIMIT 1 1 1 0 SELECT `Node`.`id`, `Node`.`title`, `Node`.`name`, `Node`.`title_en`, `Node`.`parent_id`, `Node`.`lft`, `Node`.`rght`, `Node`.`slug`, `Node`.`node_type`, `Node`.`node_state`, `Node`.`created`, `Node`.`modified`, `Node`.`published`, `Node`.`stopped`, `Node`.`user_id`, `Node`.`is_dictionary`, `Node`.`is_directory`, `Node`.`is_news`, `Node`.`image_count`, `Node`.`price_count`, `Node`.`order`, `Node`.`protected`, `Node`.`text`, `Node`.`text_en`, `Node`.`announce`, `Node`.`announce_en`, `Node`.`price`, `Node`.`email`, `Node`.`phone`, `Node`.`address`, `Node`.`address_en`, `Node`.`schedule`, `Node`.`schedule_en`, `Node`.`breakfast`, `Node`.`breakfast_en`, `Node`.`animators`, `Node`.`animators_en`, `Node`.`short_title`, `Node`.`short_title_en`, `Node`.`gps`, `Node`.`map`, `Node`.`map_en`, `Node`.`comment`, `Node`.`comment_en`, `Node`.`use_first_child`, `Node`.`promo`, `Node`.`promo_en`, `Node`.`parking_url`, `Node`.`address_2`, `Node`.`address_2_en`, `Node`.`address_3`, `Node`.`yandexmaps_id`, `Node`.`yandexmaps_working_time_en`, `Node`.`yandexmaps_working_time`, `Seo`.`id`, `Seo`.`node_id`, `Seo`.`title`, `Seo`.`title_en`, `Seo`.`keywords`, `Seo`.`keywords_en`, `Seo`.`description`, `Seo`.`description_en`, `ImageParameter`.`id`, `ImageParameter`.`node_id`, `ImageParameter`.`no_limits`, `ImageParameter`.`max_width`, `ImageParameter`.`max_height`, `ImageParameter`.`min_width`, `ImageParameter`.`min_height`, `ImageParameter`.`exact_width`, `ImageParameter`.`exact_height` FROM `db_coffeemania_team`.`nodes` AS `Node` LEFT JOIN `db_coffeemania_team`.`seos` AS `Seo` ON (`Seo`.`node_id` = `Node`.`id`) LEFT JOIN `db_coffeemania_team`.`image_parameters` AS `ImageParameter` ON (`ImageParameter`.`node_id` = `Node`.`id`) WHERE `Node`.`parent_id` IN (2003, 2004) AND `Node`.`node_state` = 'published' ORDER BY `Node`.`lft` asc 983 983 19 SELECT `ChildNode`.`id`, `ChildNode`.`title`, `ChildNode`.`name`, `ChildNode`.`title_en`, `ChildNode`.`parent_id`, `ChildNode`.`lft`, `ChildNode`.`rght`, `ChildNode`.`slug`, `ChildNode`.`node_type`, `ChildNode`.`node_state`, `ChildNode`.`created`, `ChildNode`.`modified`, `ChildNode`.`published`, `ChildNode`.`stopped`, `ChildNode`.`user_id`, `ChildNode`.`is_dictionary`, `ChildNode`.`is_directory`, `ChildNode`.`is_news`, `ChildNode`.`image_count`, `ChildNode`.`price_count`, `ChildNode`.`order`, `ChildNode`.`protected`, `ChildNode`.`text`, `ChildNode`.`text_en`, `ChildNode`.`announce`, `ChildNode`.`announce_en`, `ChildNode`.`price`, `ChildNode`.`email`, `ChildNode`.`phone`, `ChildNode`.`address`, `ChildNode`.`address_en`, `ChildNode`.`schedule`, `ChildNode`.`schedule_en`, `ChildNode`.`breakfast`, `ChildNode`.`breakfast_en`, `ChildNode`.`animators`, `ChildNode`.`animators_en`, `ChildNode`.`short_title`, `ChildNode`.`short_title_en`, `ChildNode`.`gps`, `ChildNode`.`map`, `ChildNode`.`map_en`, `ChildNode`.`comment`, `ChildNode`.`comment_en`, `ChildNode`.`use_first_child`, `ChildNode`.`promo`, `ChildNode`.`promo_en`, `ChildNode`.`parking_url`, `ChildNode`.`address_2`, `ChildNode`.`address_2_en`, `ChildNode`.`address_3`, `ChildNode`.`yandexmaps_id`, `ChildNode`.`yandexmaps_working_time_en`, `ChildNode`.`yandexmaps_working_time` FROM `db_coffeemania_team`.`nodes` AS `ChildNode` WHERE `ChildNode`.`parent_id` IN (944, 938, 1852, 2898, 1389, 942, 946, 1421, 3531, 941, 950, 844, 3362, 976, 947, 1300, 2649, 3363, 3413, 835, 3196, 1224, 833, 3042, 2915) ORDER BY `lft` asc 18 18 0 SELECT `Flag`.`id`, `Flag`.`name`, `Flag`.`node_id`, `Flag`.`value`, `Flag`.`label` FROM `db_coffeemania_team`.`flags` AS `Flag` WHERE `Flag`.`node_id` IN (944, 938, 1852, 2898, 1389, 942, 946, 1421, 3531, 941, 950, 844, 3362, 976, 947, 1300, 2649, 3363, 3413, 835, 3196, 1224, 833, 3042, 2915) 39 39 0 SELECT `Image`.`id`, `Image`.`model_id`, `Image`.`model_name`, `Image`.`name`, `Image`.`name_en`, `Image`.`title`, `Image`.`title_en`, `Image`.`description`, `Image`.`description_en`, `Image`.`order`, `Image`.`url`, `Image`.`url_en`, `Image`.`target`, `Image`.`css_class` FROM `db_coffeemania_team`.`images` AS `Image` WHERE `Image`.`model_name` = 'Node' AND `Image`.`model_id` IN (944, 938, 1852, 2898, 1389, 942, 946, 1421, 3531, 941, 950, 844, 3362, 976, 947, 1300, 2649, 3363, 3413, 835, 3196, 1224, 833, 3042, 2915) ORDER BY `Image`.`order` ASC 205 205 0 SELECT `Attachment`.`id`, `Attachment`.`model_id`, `Attachment`.`name`, `Attachment`.`name_en`, `Attachment`.`title`, `Attachment`.`title_en`, `Attachment`.`description`, `Attachment`.`description_en`, `Attachment`.`model_name`, `Attachment`.`order`, (CONCAT("/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name`)) AS `Attachment__src`, (CONCAT("/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name_en`)) AS `Attachment__src_en`, (CONCAT("/home/coffeemania/www/app/webroot/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name`)) AS `Attachment__path`, (CONCAT("/home/coffeemania/www/app/webroot/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name_en`)) AS `Attachment__path_en` FROM `db_coffeemania_team`.`attachments` AS `Attachment` WHERE `Attachment`.`model_name` = 'Node' AND `Attachment`.`model_id` IN (944, 938, 1852, 2898, 1389, 942, 946, 1421, 3531, 941, 950, 844, 3362, 976, 947, 1300, 2649, 3363, 3413, 835, 3196, 1224, 833, 3042, 2915) ORDER BY `Attachment`.`order` ASC 94 94 0 SELECT `Link`.`id`, `Link`.`node_id`, `Link`.`name`, `Link`.`label`, `Link`.`url`, `Link`.`text`, `Link`.`title`, `Link`.`target` FROM `db_coffeemania_team`.`links` AS `Link` WHERE `Link`.`node_id` IN (944, 938, 1852, 2898, 1389, 942, 946, 1421, 3531, 941, 950, 844, 3362, 976, 947, 1300, 2649, 3363, 3413, 835, 3196, 1224, 833, 3042, 2915) 0 0 0

coffeemania.ru

Наши награды | Кофемания | Кофемания

Query Affected Num. rows Took (ms) ActionsSELECT `Node`.`id`, `Node`.`slug` FROM `db_coffeemania_team`.`nodes` AS `Node` WHERE `Node`.`slug` = '/coffeemania/awards' ORDER BY `Node`.`lft` asc LIMIT 1 1 1 3 maybe slowSELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value`, `Setting`.`label`, `Setting`.`group`, `Setting`.`input_type`, `Setting`.`is_array` FROM `db_coffeemania_team`.`settings` AS `Setting` WHERE `Setting`.`group` = 'general' 7 7 3 maybe slowSELECT `Node`.`id`, `Node`.`title`, `Node`.`name`, `Node`.`title_en`, `Node`.`parent_id`, `Node`.`lft`, `Node`.`rght`, `Node`.`slug`, `Node`.`node_type`, `Node`.`node_state`, `Node`.`created`, `Node`.`modified`, `Node`.`published`, `Node`.`stopped`, `Node`.`user_id`, `Node`.`is_dictionary`, `Node`.`is_directory`, `Node`.`is_news`, `Node`.`image_count`, `Node`.`price_count`, `Node`.`order`, `Node`.`protected`, `Node`.`text`, `Node`.`text_en`, `Node`.`announce`, `Node`.`announce_en`, `Node`.`price`, `Node`.`email`, `Node`.`phone`, `Node`.`address`, `Node`.`address_en`, `Node`.`schedule`, `Node`.`schedule_en`, `Node`.`breakfast`, `Node`.`breakfast_en`, `Node`.`animators`, `Node`.`animators_en`, `Node`.`short_title`, `Node`.`short_title_en`, `Node`.`gps`, `Node`.`map`, `Node`.`map_en`, `Node`.`comment`, `Node`.`comment_en`, `Node`.`use_first_child`, `Node`.`promo`, `Node`.`promo_en`, `Node`.`parking_url`, `Node`.`address_2`, `Node`.`address_2_en`, `Node`.`address_3`, `Node`.`yandexmaps_id`, `Node`.`yandexmaps_working_time_en`, `Node`.`yandexmaps_working_time`, `Seo`.`id`, `Seo`.`node_id`, `Seo`.`title`, `Seo`.`title_en`, `Seo`.`keywords`, `Seo`.`keywords_en`, `Seo`.`description`, `Seo`.`description_en`, `ImageParameter`.`id`, `ImageParameter`.`node_id`, `ImageParameter`.`no_limits`, `ImageParameter`.`max_width`, `ImageParameter`.`max_height`, `ImageParameter`.`min_width`, `ImageParameter`.`min_height`, `ImageParameter`.`exact_width`, `ImageParameter`.`exact_height` FROM `db_coffeemania_team`.`nodes` AS `Node` LEFT JOIN `db_coffeemania_team`.`seos` AS `Seo` ON (`Seo`.`node_id` = `Node`.`id`) LEFT JOIN `db_coffeemania_team`.`image_parameters` AS `ImageParameter` ON (`ImageParameter`.`node_id` = `Node`.`id`) WHERE `Node`.`id` = 830 ORDER BY `Node`.`lft` asc LIMIT 1 1 1 5 maybe slowSELECT `ChildNode`.`id`, `ChildNode`.`title`, `ChildNode`.`name`, `ChildNode`.`title_en`, `ChildNode`.`parent_id`, `ChildNode`.`lft`, `ChildNode`.`rght`, `ChildNode`.`slug`, `ChildNode`.`node_type`, `ChildNode`.`node_state`, `ChildNode`.`created`, `ChildNode`.`modified`, `ChildNode`.`published`, `ChildNode`.`stopped`, `ChildNode`.`user_id`, `ChildNode`.`is_dictionary`, `ChildNode`.`is_directory`, `ChildNode`.`is_news`, `ChildNode`.`image_count`, `ChildNode`.`price_count`, `ChildNode`.`order`, `ChildNode`.`protected`, `ChildNode`.`text`, `ChildNode`.`text_en`, `ChildNode`.`announce`, `ChildNode`.`announce_en`, `ChildNode`.`price`, `ChildNode`.`email`, `ChildNode`.`phone`, `ChildNode`.`address`, `ChildNode`.`address_en`, `ChildNode`.`schedule`, `ChildNode`.`schedule_en`, `ChildNode`.`breakfast`, `ChildNode`.`breakfast_en`, `ChildNode`.`animators`, `ChildNode`.`animators_en`, `ChildNode`.`short_title`, `ChildNode`.`short_title_en`, `ChildNode`.`gps`, `ChildNode`.`map`, `ChildNode`.`map_en`, `ChildNode`.`comment`, `ChildNode`.`comment_en`, `ChildNode`.`use_first_child`, `ChildNode`.`promo`, `ChildNode`.`promo_en`, `ChildNode`.`parking_url`, `ChildNode`.`address_2`, `ChildNode`.`address_2_en`, `ChildNode`.`address_3`, `ChildNode`.`yandexmaps_id`, `ChildNode`.`yandexmaps_working_time_en`, `ChildNode`.`yandexmaps_working_time` FROM `db_coffeemania_team`.`nodes` AS `ChildNode` WHERE `ChildNode`.`parent_id` = (830) ORDER BY `lft` asc 0 0 8 maybe slowSELECT `Flag`.`id`, `Flag`.`name`, `Flag`.`node_id`, `Flag`.`value`, `Flag`.`label` FROM `db_coffeemania_team`.`flags` AS `Flag` WHERE `Flag`.`node_id` = (830) 0 0 3 maybe slowSELECT `Image`.`id`, `Image`.`model_id`, `Image`.`model_name`, `Image`.`name`, `Image`.`name_en`, `Image`.`title`, `Image`.`title_en`, `Image`.`description`, `Image`.`description_en`, `Image`.`order`, `Image`.`url`, `Image`.`url_en`, `Image`.`target`, `Image`.`css_class` FROM `db_coffeemania_team`.`images` AS `Image` WHERE `Image`.`model_name` = 'Node' AND `Image`.`model_id` = (830) ORDER BY `Image`.`order` ASC 0 0 10 maybe slowSELECT `Attachment`.`id`, `Attachment`.`model_id`, `Attachment`.`name`, `Attachment`.`name_en`, `Attachment`.`title`, `Attachment`.`title_en`, `Attachment`.`description`, `Attachment`.`description_en`, `Attachment`.`model_name`, `Attachment`.`order`, (CONCAT("/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name`)) AS `Attachment__src`, (CONCAT("/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name_en`)) AS `Attachment__src_en`, (CONCAT("/home/coffeemania/www/app/webroot/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name`)) AS `Attachment__path`, (CONCAT("/home/coffeemania/www/app/webroot/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name_en`)) AS `Attachment__path_en` FROM `db_coffeemania_team`.`attachments` AS `Attachment` WHERE `Attachment`.`model_name` = 'Node' AND `Attachment`.`model_id` = (830) ORDER BY `Attachment`.`order` ASC 0 0 0 SELECT `Link`.`id`, `Link`.`node_id`, `Link`.`name`, `Link`.`label`, `Link`.`url`, `Link`.`text`, `Link`.`title`, `Link`.`target` FROM `db_coffeemania_team`.`links` AS `Link` WHERE `Link`.`node_id` = (830) 0 0 0 SELECT `Node`.`lft`, `Node`.`rght` FROM `db_coffeemania_team`.`nodes` AS `Node` WHERE `Node`.`id` = 830 LIMIT 1 1 1 0 SELECT `Node`.`id`, `Node`.`name`, `Node`.`slug`, `Node`.`title`, `Node`.`announce`, `Node`.`promo` FROM `db_coffeemania_team`.`nodes` AS `Node` WHERE 1 = 1 AND `Node`.`lft` <= 1297 AND `Node`.`rght` >= 1298 ORDER BY `Node`.`lft` asc 3 3 3 SELECT `Seo`.`node_id`, `Seo`.`title` FROM `db_coffeemania_team`.`seos` AS `Seo` WHERE `Seo`.`node_id` IN (1, 818, 830) 287 287 2 SELECT `Seo`.`node_id`, `Seo`.`description` FROM `db_coffeemania_team`.`seos` AS `Seo` WHERE `Seo`.`node_id` IN (1, 818, 830) 287 287 17 maybe slowSELECT `Menu`.`id`, `Menu`.`title`, `Menu`.`title_en`, `Menu`.`node_id`, `Menu`.`url`, `Menu`.`url_en`, `Menu`.`target`, `Menu`.`parent_id`, `Menu`.`rght`, `Menu`.`lft`, `Menu`.`description`, `Menu`.`description_en`, `Node`.`id`, `Node`.`name`, `Node`.`title`, `Node`.`title_en`, `Node`.`slug` FROM `db_coffeemania_team`.`menus` AS `Menu` LEFT JOIN `db_coffeemania_team`.`nodes` AS `Node` ON (`Menu`.`node_id` = `Node`.`id`) WHERE 1 = 1 ORDER BY `Menu`.`lft` ASC 12 12 0 SELECT `Node`.`id`, `Node`.`title`, `Node`.`name`, `Node`.`title_en`, `Node`.`parent_id`, `Node`.`lft`, `Node`.`rght`, `Node`.`slug`, `Node`.`node_type`, `Node`.`node_state`, `Node`.`created`, `Node`.`modified`, `Node`.`published`, `Node`.`stopped`, `Node`.`user_id`, `Node`.`is_dictionary`, `Node`.`is_directory`, `Node`.`is_news`, `Node`.`image_count`, `Node`.`price_count`, `Node`.`order`, `Node`.`protected`, `Node`.`text`, `Node`.`text_en`, `Node`.`announce`, `Node`.`announce_en`, `Node`.`price`, `Node`.`email`, `Node`.`phone`, `Node`.`address`, `Node`.`address_en`, `Node`.`schedule`, `Node`.`schedule_en`, `Node`.`breakfast`, `Node`.`breakfast_en`, `Node`.`animators`, `Node`.`animators_en`, `Node`.`short_title`, `Node`.`short_title_en`, `Node`.`gps`, `Node`.`map`, `Node`.`map_en`, `Node`.`comment`, `Node`.`comment_en`, `Node`.`use_first_child`, `Node`.`promo`, `Node`.`promo_en`, `Node`.`parking_url`, `Node`.`address_2`, `Node`.`address_2_en`, `Node`.`address_3`, `Node`.`yandexmaps_id`, `Node`.`yandexmaps_working_time_en`, `Node`.`yandexmaps_working_time` FROM `db_coffeemania_team`.`nodes` AS `Node` WHERE `Node`.`parent_id` = 818 AND `Node`.`node_state` = 'published' ORDER BY `Node`.`lft` asc 11 11 0 SELECT `Image`.`id`, `Image`.`model_id`, `Image`.`model_name`, `Image`.`name`, `Image`.`name_en`, `Image`.`title`, `Image`.`title_en`, `Image`.`description`, `Image`.`description_en`, `Image`.`order`, `Image`.`url`, `Image`.`url_en`, `Image`.`target`, `Image`.`css_class` FROM `db_coffeemania_team`.`images` AS `Image` WHERE `Image`.`model_id` = 818 AND `Image`.`model_name` = 'Node' ORDER BY `Image`.`order` asc LIMIT 1 1 1 0 SELECT `Node`.`id`, `Node`.`title`, `Node`.`name`, `Node`.`title_en`, `Node`.`parent_id`, `Node`.`lft`, `Node`.`rght`, `Node`.`slug`, `Node`.`node_type`, `Node`.`node_state`, `Node`.`created`, `Node`.`modified`, `Node`.`published`, `Node`.`stopped`, `Node`.`user_id`, `Node`.`is_dictionary`, `Node`.`is_directory`, `Node`.`is_news`, `Node`.`image_count`, `Node`.`price_count`, `Node`.`order`, `Node`.`protected`, `Node`.`text`, `Node`.`text_en`, `Node`.`announce`, `Node`.`announce_en`, `Node`.`price`, `Node`.`email`, `Node`.`phone`, `Node`.`address`, `Node`.`address_en`, `Node`.`schedule`, `Node`.`schedule_en`, `Node`.`breakfast`, `Node`.`breakfast_en`, `Node`.`animators`, `Node`.`animators_en`, `Node`.`short_title`, `Node`.`short_title_en`, `Node`.`gps`, `Node`.`map`, `Node`.`map_en`, `Node`.`comment`, `Node`.`comment_en`, `Node`.`use_first_child`, `Node`.`promo`, `Node`.`promo_en`, `Node`.`parking_url`, `Node`.`address_2`, `Node`.`address_2_en`, `Node`.`address_3`, `Node`.`yandexmaps_id`, `Node`.`yandexmaps_working_time_en`, `Node`.`yandexmaps_working_time` FROM `db_coffeemania_team`.`nodes` AS `Node` WHERE `Node`.`name` = 'city_coffeeshops' ORDER BY `Node`.`lft` asc LIMIT 1 1 1 0 SELECT `Node`.`id`, `Node`.`title`, `Node`.`name`, `Node`.`title_en`, `Node`.`parent_id`, `Node`.`lft`, `Node`.`rght`, `Node`.`slug`, `Node`.`node_type`, `Node`.`node_state`, `Node`.`created`, `Node`.`modified`, `Node`.`published`, `Node`.`stopped`, `Node`.`user_id`, `Node`.`is_dictionary`, `Node`.`is_directory`, `Node`.`is_news`, `Node`.`image_count`, `Node`.`price_count`, `Node`.`order`, `Node`.`protected`, `Node`.`text`, `Node`.`text_en`, `Node`.`announce`, `Node`.`announce_en`, `Node`.`price`, `Node`.`email`, `Node`.`phone`, `Node`.`address`, `Node`.`address_en`, `Node`.`schedule`, `Node`.`schedule_en`, `Node`.`breakfast`, `Node`.`breakfast_en`, `Node`.`animators`, `Node`.`animators_en`, `Node`.`short_title`, `Node`.`short_title_en`, `Node`.`gps`, `Node`.`map`, `Node`.`map_en`, `Node`.`comment`, `Node`.`comment_en`, `Node`.`use_first_child`, `Node`.`promo`, `Node`.`promo_en`, `Node`.`parking_url`, `Node`.`address_2`, `Node`.`address_2_en`, `Node`.`address_3`, `Node`.`yandexmaps_id`, `Node`.`yandexmaps_working_time_en`, `Node`.`yandexmaps_working_time` FROM `db_coffeemania_team`.`nodes` AS `Node` WHERE `Node`.`name` = 'aero_coffeeshops' ORDER BY `Node`.`lft` asc LIMIT 1 1 1 0 SELECT `Node`.`id`, `Node`.`title`, `Node`.`name`, `Node`.`title_en`, `Node`.`parent_id`, `Node`.`lft`, `Node`.`rght`, `Node`.`slug`, `Node`.`node_type`, `Node`.`node_state`, `Node`.`created`, `Node`.`modified`, `Node`.`published`, `Node`.`stopped`, `Node`.`user_id`, `Node`.`is_dictionary`, `Node`.`is_directory`, `Node`.`is_news`, `Node`.`image_count`, `Node`.`price_count`, `Node`.`order`, `Node`.`protected`, `Node`.`text`, `Node`.`text_en`, `Node`.`announce`, `Node`.`announce_en`, `Node`.`price`, `Node`.`email`, `Node`.`phone`, `Node`.`address`, `Node`.`address_en`, `Node`.`schedule`, `Node`.`schedule_en`, `Node`.`breakfast`, `Node`.`breakfast_en`, `Node`.`animators`, `Node`.`animators_en`, `Node`.`short_title`, `Node`.`short_title_en`, `Node`.`gps`, `Node`.`map`, `Node`.`map_en`, `Node`.`comment`, `Node`.`comment_en`, `Node`.`use_first_child`, `Node`.`promo`, `Node`.`promo_en`, `Node`.`parking_url`, `Node`.`address_2`, `Node`.`address_2_en`, `Node`.`address_3`, `Node`.`yandexmaps_id`, `Node`.`yandexmaps_working_time_en`, `Node`.`yandexmaps_working_time`, `Seo`.`id`, `Seo`.`node_id`, `Seo`.`title`, `Seo`.`title_en`, `Seo`.`keywords`, `Seo`.`keywords_en`, `Seo`.`description`, `Seo`.`description_en`, `ImageParameter`.`id`, `ImageParameter`.`node_id`, `ImageParameter`.`no_limits`, `ImageParameter`.`max_width`, `ImageParameter`.`max_height`, `ImageParameter`.`min_width`, `ImageParameter`.`min_height`, `ImageParameter`.`exact_width`, `ImageParameter`.`exact_height` FROM `db_coffeemania_team`.`nodes` AS `Node` LEFT JOIN `db_coffeemania_team`.`seos` AS `Seo` ON (`Seo`.`node_id` = `Node`.`id`) LEFT JOIN `db_coffeemania_team`.`image_parameters` AS `ImageParameter` ON (`ImageParameter`.`node_id` = `Node`.`id`) WHERE `Node`.`parent_id` IN (2003, 2004) AND `Node`.`node_state` = 'published' ORDER BY `Node`.`lft` asc 983 983 2 SELECT `ChildNode`.`id`, `ChildNode`.`title`, `ChildNode`.`name`, `ChildNode`.`title_en`, `ChildNode`.`parent_id`, `ChildNode`.`lft`, `ChildNode`.`rght`, `ChildNode`.`slug`, `ChildNode`.`node_type`, `ChildNode`.`node_state`, `ChildNode`.`created`, `ChildNode`.`modified`, `ChildNode`.`published`, `ChildNode`.`stopped`, `ChildNode`.`user_id`, `ChildNode`.`is_dictionary`, `ChildNode`.`is_directory`, `ChildNode`.`is_news`, `ChildNode`.`image_count`, `ChildNode`.`price_count`, `ChildNode`.`order`, `ChildNode`.`protected`, `ChildNode`.`text`, `ChildNode`.`text_en`, `ChildNode`.`announce`, `ChildNode`.`announce_en`, `ChildNode`.`price`, `ChildNode`.`email`, `ChildNode`.`phone`, `ChildNode`.`address`, `ChildNode`.`address_en`, `ChildNode`.`schedule`, `ChildNode`.`schedule_en`, `ChildNode`.`breakfast`, `ChildNode`.`breakfast_en`, `ChildNode`.`animators`, `ChildNode`.`animators_en`, `ChildNode`.`short_title`, `ChildNode`.`short_title_en`, `ChildNode`.`gps`, `ChildNode`.`map`, `ChildNode`.`map_en`, `ChildNode`.`comment`, `ChildNode`.`comment_en`, `ChildNode`.`use_first_child`, `ChildNode`.`promo`, `ChildNode`.`promo_en`, `ChildNode`.`parking_url`, `ChildNode`.`address_2`, `ChildNode`.`address_2_en`, `ChildNode`.`address_3`, `ChildNode`.`yandexmaps_id`, `ChildNode`.`yandexmaps_working_time_en`, `ChildNode`.`yandexmaps_working_time` FROM `db_coffeemania_team`.`nodes` AS `ChildNode` WHERE `ChildNode`.`parent_id` IN (944, 938, 1852, 2898, 1389, 942, 946, 1421, 3531, 941, 950, 844, 3362, 976, 947, 1300, 2649, 3363, 3413, 835, 3196, 1224, 833, 3042, 2915) ORDER BY `lft` asc 18 18 0 SELECT `Flag`.`id`, `Flag`.`name`, `Flag`.`node_id`, `Flag`.`value`, `Flag`.`label` FROM `db_coffeemania_team`.`flags` AS `Flag` WHERE `Flag`.`node_id` IN (944, 938, 1852, 2898, 1389, 942, 946, 1421, 3531, 941, 950, 844, 3362, 976, 947, 1300, 2649, 3363, 3413, 835, 3196, 1224, 833, 3042, 2915) 39 39 0 SELECT `Image`.`id`, `Image`.`model_id`, `Image`.`model_name`, `Image`.`name`, `Image`.`name_en`, `Image`.`title`, `Image`.`title_en`, `Image`.`description`, `Image`.`description_en`, `Image`.`order`, `Image`.`url`, `Image`.`url_en`, `Image`.`target`, `Image`.`css_class` FROM `db_coffeemania_team`.`images` AS `Image` WHERE `Image`.`model_name` = 'Node' AND `Image`.`model_id` IN (944, 938, 1852, 2898, 1389, 942, 946, 1421, 3531, 941, 950, 844, 3362, 976, 947, 1300, 2649, 3363, 3413, 835, 3196, 1224, 833, 3042, 2915) ORDER BY `Image`.`order` ASC 205 205 0 SELECT `Attachment`.`id`, `Attachment`.`model_id`, `Attachment`.`name`, `Attachment`.`name_en`, `Attachment`.`title`, `Attachment`.`title_en`, `Attachment`.`description`, `Attachment`.`description_en`, `Attachment`.`model_name`, `Attachment`.`order`, (CONCAT("/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name`)) AS `Attachment__src`, (CONCAT("/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name_en`)) AS `Attachment__src_en`, (CONCAT("/home/coffeemania/www/app/webroot/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name`)) AS `Attachment__path`, (CONCAT("/home/coffeemania/www/app/webroot/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name_en`)) AS `Attachment__path_en` FROM `db_coffeemania_team`.`attachments` AS `Attachment` WHERE `Attachment`.`model_name` = 'Node' AND `Attachment`.`model_id` IN (944, 938, 1852, 2898, 1389, 942, 946, 1421, 3531, 941, 950, 844, 3362, 976, 947, 1300, 2649, 3363, 3413, 835, 3196, 1224, 833, 3042, 2915) ORDER BY `Attachment`.`order` ASC 94 94 0 SELECT `Link`.`id`, `Link`.`node_id`, `Link`.`name`, `Link`.`label`, `Link`.`url`, `Link`.`text`, `Link`.`title`, `Link`.`target` FROM `db_coffeemania_team`.`links` AS `Link` WHERE `Link`.`node_id` IN (944, 938, 1852, 2898, 1389, 942, 946, 1421, 3531, 941, 950, 844, 3362, 976, 947, 1300, 2649, 3363, 3413, 835, 3196, 1224, 833, 3042, 2915) 0 0 0

coffeemania.ru

Coffeemania

Query Affected Num. rows Took (ms) ActionsSELECT `Node`.`id`, `Node`.`slug` FROM `db_coffeemania_team`.`nodes` AS `Node` WHERE `Node`.`slug` = '/' ORDER BY `Node`.`lft` asc LIMIT 1 1 1 16 maybe slowSELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value`, `Setting`.`label`, `Setting`.`group`, `Setting`.`input_type`, `Setting`.`is_array` FROM `db_coffeemania_team`.`settings` AS `Setting` WHERE `Setting`.`group` = 'general' 7 7 0 SELECT `Node`.`id`, `Node`.`title`, `Node`.`name`, `Node`.`title_en`, `Node`.`parent_id`, `Node`.`lft`, `Node`.`rght`, `Node`.`slug`, `Node`.`node_type`, `Node`.`node_state`, `Node`.`created`, `Node`.`modified`, `Node`.`published`, `Node`.`stopped`, `Node`.`user_id`, `Node`.`is_dictionary`, `Node`.`is_directory`, `Node`.`is_news`, `Node`.`image_count`, `Node`.`price_count`, `Node`.`order`, `Node`.`protected`, `Node`.`text`, `Node`.`text_en`, `Node`.`announce`, `Node`.`announce_en`, `Node`.`price`, `Node`.`email`, `Node`.`phone`, `Node`.`address`, `Node`.`address_en`, `Node`.`schedule`, `Node`.`schedule_en`, `Node`.`breakfast`, `Node`.`breakfast_en`, `Node`.`animators`, `Node`.`animators_en`, `Node`.`short_title`, `Node`.`short_title_en`, `Node`.`gps`, `Node`.`map`, `Node`.`map_en`, `Node`.`comment`, `Node`.`comment_en`, `Node`.`use_first_child`, `Node`.`promo`, `Node`.`promo_en`, `Node`.`parking_url`, `Node`.`address_2`, `Node`.`address_2_en`, `Node`.`address_3`, `Node`.`yandexmaps_id`, `Node`.`yandexmaps_working_time_en`, `Node`.`yandexmaps_working_time`, `Seo`.`id`, `Seo`.`node_id`, `Seo`.`title`, `Seo`.`title_en`, `Seo`.`keywords`, `Seo`.`keywords_en`, `Seo`.`description`, `Seo`.`description_en`, `ImageParameter`.`id`, `ImageParameter`.`node_id`, `ImageParameter`.`no_limits`, `ImageParameter`.`max_width`, `ImageParameter`.`max_height`, `ImageParameter`.`min_width`, `ImageParameter`.`min_height`, `ImageParameter`.`exact_width`, `ImageParameter`.`exact_height` FROM `db_coffeemania_team`.`nodes` AS `Node` LEFT JOIN `db_coffeemania_team`.`seos` AS `Seo` ON (`Seo`.`node_id` = `Node`.`id`) LEFT JOIN `db_coffeemania_team`.`image_parameters` AS `ImageParameter` ON (`ImageParameter`.`node_id` = `Node`.`id`) WHERE `Node`.`id` = 1 ORDER BY `Node`.`lft` asc LIMIT 1 1 1 0 SELECT `ChildNode`.`id`, `ChildNode`.`title`, `ChildNode`.`name`, `ChildNode`.`title_en`, `ChildNode`.`parent_id`, `ChildNode`.`lft`, `ChildNode`.`rght`, `ChildNode`.`slug`, `ChildNode`.`node_type`, `ChildNode`.`node_state`, `ChildNode`.`created`, `ChildNode`.`modified`, `ChildNode`.`published`, `ChildNode`.`stopped`, `ChildNode`.`user_id`, `ChildNode`.`is_dictionary`, `ChildNode`.`is_directory`, `ChildNode`.`is_news`, `ChildNode`.`image_count`, `ChildNode`.`price_count`, `ChildNode`.`order`, `ChildNode`.`protected`, `ChildNode`.`text`, `ChildNode`.`text_en`, `ChildNode`.`announce`, `ChildNode`.`announce_en`, `ChildNode`.`price`, `ChildNode`.`email`, `ChildNode`.`phone`, `ChildNode`.`address`, `ChildNode`.`address_en`, `ChildNode`.`schedule`, `ChildNode`.`schedule_en`, `ChildNode`.`breakfast`, `ChildNode`.`breakfast_en`, `ChildNode`.`animators`, `ChildNode`.`animators_en`, `ChildNode`.`short_title`, `ChildNode`.`short_title_en`, `ChildNode`.`gps`, `ChildNode`.`map`, `ChildNode`.`map_en`, `ChildNode`.`comment`, `ChildNode`.`comment_en`, `ChildNode`.`use_first_child`, `ChildNode`.`promo`, `ChildNode`.`promo_en`, `ChildNode`.`parking_url`, `ChildNode`.`address_2`, `ChildNode`.`address_2_en`, `ChildNode`.`address_3`, `ChildNode`.`yandexmaps_id`, `ChildNode`.`yandexmaps_working_time_en`, `ChildNode`.`yandexmaps_working_time` FROM `db_coffeemania_team`.`nodes` AS `ChildNode` WHERE `ChildNode`.`parent_id` = (1) ORDER BY `lft` asc 9 9 2 maybe slowSELECT `Flag`.`id`, `Flag`.`name`, `Flag`.`node_id`, `Flag`.`value`, `Flag`.`label` FROM `db_coffeemania_team`.`flags` AS `Flag` WHERE `Flag`.`node_id` = (1) 0 0 0 SELECT `Image`.`id`, `Image`.`model_id`, `Image`.`model_name`, `Image`.`name`, `Image`.`name_en`, `Image`.`title`, `Image`.`title_en`, `Image`.`description`, `Image`.`description_en`, `Image`.`order`, `Image`.`url`, `Image`.`url_en`, `Image`.`target`, `Image`.`css_class` FROM `db_coffeemania_team`.`images` AS `Image` WHERE `Image`.`model_name` = 'Node' AND `Image`.`model_id` = (1) ORDER BY `Image`.`order` ASC 11 11 2 maybe slowSELECT `Attachment`.`id`, `Attachment`.`model_id`, `Attachment`.`name`, `Attachment`.`name_en`, `Attachment`.`title`, `Attachment`.`title_en`, `Attachment`.`description`, `Attachment`.`description_en`, `Attachment`.`model_name`, `Attachment`.`order`, (CONCAT("/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name`)) AS `Attachment__src`, (CONCAT("/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name_en`)) AS `Attachment__src_en`, (CONCAT("/home/coffeemania/www/app/webroot/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name`)) AS `Attachment__path`, (CONCAT("/home/coffeemania/www/app/webroot/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name_en`)) AS `Attachment__path_en` FROM `db_coffeemania_team`.`attachments` AS `Attachment` WHERE `Attachment`.`model_name` = 'Node' AND `Attachment`.`model_id` = (1) ORDER BY `Attachment`.`order` ASC 0 0 0 SELECT `Link`.`id`, `Link`.`node_id`, `Link`.`name`, `Link`.`label`, `Link`.`url`, `Link`.`text`, `Link`.`title`, `Link`.`target` FROM `db_coffeemania_team`.`links` AS `Link` WHERE `Link`.`node_id` = (1) 0 0 1 maybe slowSELECT `Node`.`lft`, `Node`.`rght` FROM `db_coffeemania_team`.`nodes` AS `Node` WHERE `Node`.`id` = 1 LIMIT 1 1 1 0 SELECT `Node`.`id`, `Node`.`name`, `Node`.`slug`, `Node`.`title_en`, `Node`.`announce_en`, `Node`.`promo_en` FROM `db_coffeemania_team`.`nodes` AS `Node` WHERE 1 = 1 AND `Node`.`lft` <= 1 AND `Node`.`rght` >= 1640 ORDER BY `Node`.`lft` asc 1 1 1 SELECT `Seo`.`node_id`, `Seo`.`title_en` FROM `db_coffeemania_team`.`seos` AS `Seo` WHERE `Seo`.`node_id` = (1) 273 273 3 SELECT `Seo`.`node_id`, `Seo`.`description_en` FROM `db_coffeemania_team`.`seos` AS `Seo` WHERE `Seo`.`node_id` = (1) 273 273 11 SELECT `Node`.`id`, `Node`.`title`, `Node`.`name`, `Node`.`title_en`, `Node`.`parent_id`, `Node`.`lft`, `Node`.`rght`, `Node`.`slug`, `Node`.`node_type`, `Node`.`node_state`, `Node`.`created`, `Node`.`modified`, `Node`.`published`, `Node`.`stopped`, `Node`.`user_id`, `Node`.`is_dictionary`, `Node`.`is_directory`, `Node`.`is_news`, `Node`.`image_count`, `Node`.`price_count`, `Node`.`order`, `Node`.`protected`, `Node`.`text`, `Node`.`text_en`, `Node`.`announce`, `Node`.`announce_en`, `Node`.`price`, `Node`.`email`, `Node`.`phone`, `Node`.`address`, `Node`.`address_en`, `Node`.`schedule`, `Node`.`schedule_en`, `Node`.`breakfast`, `Node`.`breakfast_en`, `Node`.`animators`, `Node`.`animators_en`, `Node`.`short_title`, `Node`.`short_title_en`, `Node`.`gps`, `Node`.`map`, `Node`.`map_en`, `Node`.`comment`, `Node`.`comment_en`, `Node`.`use_first_child`, `Node`.`promo`, `Node`.`promo_en`, `Node`.`parking_url`, `Node`.`address_2`, `Node`.`address_2_en`, `Node`.`address_3`, `Node`.`yandexmaps_id`, `Node`.`yandexmaps_working_time_en`, `Node`.`yandexmaps_working_time` FROM `db_coffeemania_team`.`nodes` AS `Node` WHERE `Node`.`name` = 'vtours' ORDER BY `Node`.`lft` asc LIMIT 1 1 1 0 SELECT `Node`.`id`, `Node`.`title`, `Node`.`name`, `Node`.`title_en`, `Node`.`parent_id`, `Node`.`lft`, `Node`.`rght`, `Node`.`slug`, `Node`.`node_type`, `Node`.`node_state`, `Node`.`created`, `Node`.`modified`, `Node`.`published`, `Node`.`stopped`, `Node`.`user_id`, `Node`.`is_dictionary`, `Node`.`is_directory`, `Node`.`is_news`, `Node`.`image_count`, `Node`.`price_count`, `Node`.`order`, `Node`.`protected`, `Node`.`text`, `Node`.`text_en`, `Node`.`announce`, `Node`.`announce_en`, `Node`.`price`, `Node`.`email`, `Node`.`phone`, `Node`.`address`, `Node`.`address_en`, `Node`.`schedule`, `Node`.`schedule_en`, `Node`.`breakfast`, `Node`.`breakfast_en`, `Node`.`animators`, `Node`.`animators_en`, `Node`.`short_title`, `Node`.`short_title_en`, `Node`.`gps`, `Node`.`map`, `Node`.`map_en`, `Node`.`comment`, `Node`.`comment_en`, `Node`.`use_first_child`, `Node`.`promo`, `Node`.`promo_en`, `Node`.`parking_url`, `Node`.`address_2`, `Node`.`address_2_en`, `Node`.`address_3`, `Node`.`yandexmaps_id`, `Node`.`yandexmaps_working_time_en`, `Node`.`yandexmaps_working_time`, `Seo`.`id`, `Seo`.`node_id`, `Seo`.`title`, `Seo`.`title_en`, `Seo`.`keywords`, `Seo`.`keywords_en`, `Seo`.`description`, `Seo`.`description_en`, `ImageParameter`.`id`, `ImageParameter`.`node_id`, `ImageParameter`.`no_limits`, `ImageParameter`.`max_width`, `ImageParameter`.`max_height`, `ImageParameter`.`min_width`, `ImageParameter`.`min_height`, `ImageParameter`.`exact_width`, `ImageParameter`.`exact_height` FROM `db_coffeemania_team`.`nodes` AS `Node` LEFT JOIN `db_coffeemania_team`.`seos` AS `Seo` ON (`Seo`.`node_id` = `Node`.`id`) LEFT JOIN `db_coffeemania_team`.`image_parameters` AS `ImageParameter` ON (`ImageParameter`.`node_id` = `Node`.`id`) WHERE `Node`.`parent_id` = 2042 AND `Node`.`node_state` = 'published' ORDER BY `Node`.`lft` asc 3 3 0 SELECT `ChildNode`.`id`, `ChildNode`.`title`, `ChildNode`.`name`, `ChildNode`.`title_en`, `ChildNode`.`parent_id`, `ChildNode`.`lft`, `ChildNode`.`rght`, `ChildNode`.`slug`, `ChildNode`.`node_type`, `ChildNode`.`node_state`, `ChildNode`.`created`, `ChildNode`.`modified`, `ChildNode`.`published`, `ChildNode`.`stopped`, `ChildNode`.`user_id`, `ChildNode`.`is_dictionary`, `ChildNode`.`is_directory`, `ChildNode`.`is_news`, `ChildNode`.`image_count`, `ChildNode`.`price_count`, `ChildNode`.`order`, `ChildNode`.`protected`, `ChildNode`.`text`, `ChildNode`.`text_en`, `ChildNode`.`announce`, `ChildNode`.`announce_en`, `ChildNode`.`price`, `ChildNode`.`email`, `ChildNode`.`phone`, `ChildNode`.`address`, `ChildNode`.`address_en`, `ChildNode`.`schedule`, `ChildNode`.`schedule_en`, `ChildNode`.`breakfast`, `ChildNode`.`breakfast_en`, `ChildNode`.`animators`, `ChildNode`.`animators_en`, `ChildNode`.`short_title`, `ChildNode`.`short_title_en`, `ChildNode`.`gps`, `ChildNode`.`map`, `ChildNode`.`map_en`, `ChildNode`.`comment`, `ChildNode`.`comment_en`, `ChildNode`.`use_first_child`, `ChildNode`.`promo`, `ChildNode`.`promo_en`, `ChildNode`.`parking_url`, `ChildNode`.`address_2`, `ChildNode`.`address_2_en`, `ChildNode`.`address_3`, `ChildNode`.`yandexmaps_id`, `ChildNode`.`yandexmaps_working_time_en`, `ChildNode`.`yandexmaps_working_time` FROM `db_coffeemania_team`.`nodes` AS `ChildNode` WHERE `ChildNode`.`parent_id` = (2043) ORDER BY `lft` asc 0 0 0 SELECT `Flag`.`id`, `Flag`.`name`, `Flag`.`node_id`, `Flag`.`value`, `Flag`.`label` FROM `db_coffeemania_team`.`flags` AS `Flag` WHERE `Flag`.`node_id` = (2043) 0 0 0 SELECT `Image`.`id`, `Image`.`model_id`, `Image`.`model_name`, `Image`.`name`, `Image`.`name_en`, `Image`.`title`, `Image`.`title_en`, `Image`.`description`, `Image`.`description_en`, `Image`.`order`, `Image`.`url`, `Image`.`url_en`, `Image`.`target`, `Image`.`css_class` FROM `db_coffeemania_team`.`images` AS `Image` WHERE `Image`.`model_name` = 'Node' AND `Image`.`model_id` = (2043) ORDER BY `Image`.`order` ASC 0 0 0 SELECT `Attachment`.`id`, `Attachment`.`model_id`, `Attachment`.`name`, `Attachment`.`name_en`, `Attachment`.`title`, `Attachment`.`title_en`, `Attachment`.`description`, `Attachment`.`description_en`, `Attachment`.`model_name`, `Attachment`.`order`, (CONCAT("/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name`)) AS `Attachment__src`, (CONCAT("/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name_en`)) AS `Attachment__src_en`, (CONCAT("/home/coffeemania/www/app/webroot/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name`)) AS `Attachment__path`, (CONCAT("/home/coffeemania/www/app/webroot/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name_en`)) AS `Attachment__path_en` FROM `db_coffeemania_team`.`attachments` AS `Attachment` WHERE `Attachment`.`model_name` = 'Node' AND `Attachment`.`model_id` = (2043) ORDER BY `Attachment`.`order` ASC 0 0 0 SELECT `Link`.`id`, `Link`.`node_id`, `Link`.`name`, `Link`.`label`, `Link`.`url`, `Link`.`text`, `Link`.`title`, `Link`.`target` FROM `db_coffeemania_team`.`links` AS `Link` WHERE `Link`.`node_id` = (2043) 0 0 0 SELECT `Node`.`id`, `Node`.`title`, `Node`.`name`, `Node`.`title_en`, `Node`.`parent_id`, `Node`.`lft`, `Node`.`rght`, `Node`.`slug`, `Node`.`node_type`, `Node`.`node_state`, `Node`.`created`, `Node`.`modified`, `Node`.`published`, `Node`.`stopped`, `Node`.`user_id`, `Node`.`is_dictionary`, `Node`.`is_directory`, `Node`.`is_news`, `Node`.`image_count`, `Node`.`price_count`, `Node`.`order`, `Node`.`protected`, `Node`.`text`, `Node`.`text_en`, `Node`.`announce`, `Node`.`announce_en`, `Node`.`price`, `Node`.`email`, `Node`.`phone`, `Node`.`address`, `Node`.`address_en`, `Node`.`schedule`, `Node`.`schedule_en`, `Node`.`breakfast`, `Node`.`breakfast_en`, `Node`.`animators`, `Node`.`animators_en`, `Node`.`short_title`, `Node`.`short_title_en`, `Node`.`gps`, `Node`.`map`, `Node`.`map_en`, `Node`.`comment`, `Node`.`comment_en`, `Node`.`use_first_child`, `Node`.`promo`, `Node`.`promo_en`, `Node`.`parking_url`, `Node`.`address_2`, `Node`.`address_2_en`, `Node`.`address_3`, `Node`.`yandexmaps_id`, `Node`.`yandexmaps_working_time_en`, `Node`.`yandexmaps_working_time`, `Seo`.`id`, `Seo`.`node_id`, `Seo`.`title`, `Seo`.`title_en`, `Seo`.`keywords`, `Seo`.`keywords_en`, `Seo`.`description`, `Seo`.`description_en`, `ImageParameter`.`id`, `ImageParameter`.`node_id`, `ImageParameter`.`no_limits`, `ImageParameter`.`max_width`, `ImageParameter`.`max_height`, `ImageParameter`.`min_width`, `ImageParameter`.`min_height`, `ImageParameter`.`exact_width`, `ImageParameter`.`exact_height` FROM `db_coffeemania_team`.`nodes` AS `Node` LEFT JOIN `db_coffeemania_team`.`seos` AS `Seo` ON (`Seo`.`node_id` = `Node`.`id`) LEFT JOIN `db_coffeemania_team`.`image_parameters` AS `ImageParameter` ON (`ImageParameter`.`node_id` = `Node`.`id`) WHERE `Node`.`name` = 'news' ORDER BY `Node`.`lft` asc LIMIT 1 1 1 0 SELECT `ChildNode`.`id`, `ChildNode`.`title`, `ChildNode`.`name`, `ChildNode`.`title_en`, `ChildNode`.`parent_id`, `ChildNode`.`lft`, `ChildNode`.`rght`, `ChildNode`.`slug`, `ChildNode`.`node_type`, `ChildNode`.`node_state`, `ChildNode`.`created`, `ChildNode`.`modified`, `ChildNode`.`published`, `ChildNode`.`stopped`, `ChildNode`.`user_id`, `ChildNode`.`is_dictionary`, `ChildNode`.`is_directory`, `ChildNode`.`is_news`, `ChildNode`.`image_count`, `ChildNode`.`price_count`, `ChildNode`.`order`, `ChildNode`.`protected`, `ChildNode`.`text`, `ChildNode`.`text_en`, `ChildNode`.`announce`, `ChildNode`.`announce_en`, `ChildNode`.`price`, `ChildNode`.`email`, `ChildNode`.`phone`, `ChildNode`.`address`, `ChildNode`.`address_en`, `ChildNode`.`schedule`, `ChildNode`.`schedule_en`, `ChildNode`.`breakfast`, `ChildNode`.`breakfast_en`, `ChildNode`.`animators`, `ChildNode`.`animators_en`, `ChildNode`.`short_title`, `ChildNode`.`short_title_en`, `ChildNode`.`gps`, `ChildNode`.`map`, `ChildNode`.`map_en`, `ChildNode`.`comment`, `ChildNode`.`comment_en`, `ChildNode`.`use_first_child`, `ChildNode`.`promo`, `ChildNode`.`promo_en`, `ChildNode`.`parking_url`, `ChildNode`.`address_2`, `ChildNode`.`address_2_en`, `ChildNode`.`address_3`, `ChildNode`.`yandexmaps_id`, `ChildNode`.`yandexmaps_working_time_en`, `ChildNode`.`yandexmaps_working_time` FROM `db_coffeemania_team`.`nodes` AS `ChildNode` WHERE `ChildNode`.`parent_id` = (670) ORDER BY `lft` asc 645 645 8 SELECT `Flag`.`id`, `Flag`.`name`, `Flag`.`node_id`, `Flag`.`value`, `Flag`.`label` FROM `db_coffeemania_team`.`flags` AS `Flag` WHERE `Flag`.`node_id` = (670) 0 0 0 SELECT `Image`.`id`, `Image`.`model_id`, `Image`.`model_name`, `Image`.`name`, `Image`.`name_en`, `Image`.`title`, `Image`.`title_en`, `Image`.`description`, `Image`.`description_en`, `Image`.`order`, `Image`.`url`, `Image`.`url_en`, `Image`.`target`, `Image`.`css_class` FROM `db_coffeemania_team`.`images` AS `Image` WHERE `Image`.`model_name` = 'Node' AND `Image`.`model_id` = (670) ORDER BY `Image`.`order` ASC 0 0 19 maybe slowSELECT `Attachment`.`id`, `Attachment`.`model_id`, `Attachment`.`name`, `Attachment`.`name_en`, `Attachment`.`title`, `Attachment`.`title_en`, `Attachment`.`description`, `Attachment`.`description_en`, `Attachment`.`model_name`, `Attachment`.`order`, (CONCAT("/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name`)) AS `Attachment__src`, (CONCAT("/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name_en`)) AS `Attachment__src_en`, (CONCAT("/home/coffeemania/www/app/webroot/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name`)) AS `Attachment__path`, (CONCAT("/home/coffeemania/www/app/webroot/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name_en`)) AS `Attachment__path_en` FROM `db_coffeemania_team`.`attachments` AS `Attachment` WHERE `Attachment`.`model_name` = 'Node' AND `Attachment`.`model_id` = (670) ORDER BY `Attachment`.`order` ASC 0 0 0 SELECT `Link`.`id`, `Link`.`node_id`, `Link`.`name`, `Link`.`label`, `Link`.`url`, `Link`.`text`, `Link`.`title`, `Link`.`target` FROM `db_coffeemania_team`.`links` AS `Link` WHERE `Link`.`node_id` = (670) 0 0 0 SELECT `Node`.`id`, `Node`.`title`, `Node`.`name`, `Node`.`title_en`, `Node`.`parent_id`, `Node`.`lft`, `Node`.`rght`, `Node`.`slug`, `Node`.`node_type`, `Node`.`node_state`, `Node`.`created`, `Node`.`modified`, `Node`.`published`, `Node`.`stopped`, `Node`.`user_id`, `Node`.`is_dictionary`, `Node`.`is_directory`, `Node`.`is_news`, `Node`.`image_count`, `Node`.`price_count`, `Node`.`order`, `Node`.`protected`, `Node`.`text`, `Node`.`text_en`, `Node`.`announce`, `Node`.`announce_en`, `Node`.`price`, `Node`.`email`, `Node`.`phone`, `Node`.`address`, `Node`.`address_en`, `Node`.`schedule`, `Node`.`schedule_en`, `Node`.`breakfast`, `Node`.`breakfast_en`, `Node`.`animators`, `Node`.`animators_en`, `Node`.`short_title`, `Node`.`short_title_en`, `Node`.`gps`, `Node`.`map`, `Node`.`map_en`, `Node`.`comment`, `Node`.`comment_en`, `Node`.`use_first_child`, `Node`.`promo`, `Node`.`promo_en`, `Node`.`parking_url`, `Node`.`address_2`, `Node`.`address_2_en`, `Node`.`address_3`, `Node`.`yandexmaps_id`, `Node`.`yandexmaps_working_time_en`, `Node`.`yandexmaps_working_time` FROM `db_coffeemania_team`.`nodes` AS `Node` WHERE `Node`.`parent_id` = 670 AND `Node`.`node_state` = 'published' ORDER BY `Node`.`published` DESC LIMIT 1 1 1 0 SELECT `Menu`.`id`, `Menu`.`title`, `Menu`.`title_en`, `Menu`.`node_id`, `Menu`.`url`, `Menu`.`url_en`, `Menu`.`target`, `Menu`.`parent_id`, `Menu`.`rght`, `Menu`.`lft`, `Menu`.`description`, `Menu`.`description_en`, `Node`.`id`, `Node`.`name`, `Node`.`title`, `Node`.`title_en`, `Node`.`slug` FROM `db_coffeemania_team`.`menus` AS `Menu` LEFT JOIN `db_coffeemania_team`.`nodes` AS `Node` ON (`Menu`.`node_id` = `Node`.`id`) WHERE 1 = 1 ORDER BY `Menu`.`lft` ASC 12 12 0 SELECT `Node`.`id`, `Node`.`title`, `Node`.`name`, `Node`.`title_en`, `Node`.`parent_id`, `Node`.`lft`, `Node`.`rght`, `Node`.`slug`, `Node`.`node_type`, `Node`.`node_state`, `Node`.`created`, `Node`.`modified`, `Node`.`published`, `Node`.`stopped`, `Node`.`user_id`, `Node`.`is_dictionary`, `Node`.`is_directory`, `Node`.`is_news`, `Node`.`image_count`, `Node`.`price_count`, `Node`.`order`, `Node`.`protected`, `Node`.`text`, `Node`.`text_en`, `Node`.`announce`, `Node`.`announce_en`, `Node`.`price`, `Node`.`email`, `Node`.`phone`, `Node`.`address`, `Node`.`address_en`, `Node`.`schedule`, `Node`.`schedule_en`, `Node`.`breakfast`, `Node`.`breakfast_en`, `Node`.`animators`, `Node`.`animators_en`, `Node`.`short_title`, `Node`.`short_title_en`, `Node`.`gps`, `Node`.`map`, `Node`.`map_en`, `Node`.`comment`, `Node`.`comment_en`, `Node`.`use_first_child`, `Node`.`promo`, `Node`.`promo_en`, `Node`.`parking_url`, `Node`.`address_2`, `Node`.`address_2_en`, `Node`.`address_3`, `Node`.`yandexmaps_id`, `Node`.`yandexmaps_working_time_en`, `Node`.`yandexmaps_working_time` FROM `db_coffeemania_team`.`nodes` AS `Node` WHERE `Node`.`name` = 'city_coffeeshops' ORDER BY `Node`.`lft` asc LIMIT 1 1 1 0 SELECT `Node`.`id`, `Node`.`title`, `Node`.`name`, `Node`.`title_en`, `Node`.`parent_id`, `Node`.`lft`, `Node`.`rght`, `Node`.`slug`, `Node`.`node_type`, `Node`.`node_state`, `Node`.`created`, `Node`.`modified`, `Node`.`published`, `Node`.`stopped`, `Node`.`user_id`, `Node`.`is_dictionary`, `Node`.`is_directory`, `Node`.`is_news`, `Node`.`image_count`, `Node`.`price_count`, `Node`.`order`, `Node`.`protected`, `Node`.`text`, `Node`.`text_en`, `Node`.`announce`, `Node`.`announce_en`, `Node`.`price`, `Node`.`email`, `Node`.`phone`, `Node`.`address`, `Node`.`address_en`, `Node`.`schedule`, `Node`.`schedule_en`, `Node`.`breakfast`, `Node`.`breakfast_en`, `Node`.`animators`, `Node`.`animators_en`, `Node`.`short_title`, `Node`.`short_title_en`, `Node`.`gps`, `Node`.`map`, `Node`.`map_en`, `Node`.`comment`, `Node`.`comment_en`, `Node`.`use_first_child`, `Node`.`promo`, `Node`.`promo_en`, `Node`.`parking_url`, `Node`.`address_2`, `Node`.`address_2_en`, `Node`.`address_3`, `Node`.`yandexmaps_id`, `Node`.`yandexmaps_working_time_en`, `Node`.`yandexmaps_working_time` FROM `db_coffeemania_team`.`nodes` AS `Node` WHERE `Node`.`name` = 'aero_coffeeshops' ORDER BY `Node`.`lft` asc LIMIT 1 1 1 0 SELECT `Node`.`id`, `Node`.`title`, `Node`.`name`, `Node`.`title_en`, `Node`.`parent_id`, `Node`.`lft`, `Node`.`rght`, `Node`.`slug`, `Node`.`node_type`, `Node`.`node_state`, `Node`.`created`, `Node`.`modified`, `Node`.`published`, `Node`.`stopped`, `Node`.`user_id`, `Node`.`is_dictionary`, `Node`.`is_directory`, `Node`.`is_news`, `Node`.`image_count`, `Node`.`price_count`, `Node`.`order`, `Node`.`protected`, `Node`.`text`, `Node`.`text_en`, `Node`.`announce`, `Node`.`announce_en`, `Node`.`price`, `Node`.`email`, `Node`.`phone`, `Node`.`address`, `Node`.`address_en`, `Node`.`schedule`, `Node`.`schedule_en`, `Node`.`breakfast`, `Node`.`breakfast_en`, `Node`.`animators`, `Node`.`animators_en`, `Node`.`short_title`, `Node`.`short_title_en`, `Node`.`gps`, `Node`.`map`, `Node`.`map_en`, `Node`.`comment`, `Node`.`comment_en`, `Node`.`use_first_child`, `Node`.`promo`, `Node`.`promo_en`, `Node`.`parking_url`, `Node`.`address_2`, `Node`.`address_2_en`, `Node`.`address_3`, `Node`.`yandexmaps_id`, `Node`.`yandexmaps_working_time_en`, `Node`.`yandexmaps_working_time`, `Seo`.`id`, `Seo`.`node_id`, `Seo`.`title`, `Seo`.`title_en`, `Seo`.`keywords`, `Seo`.`keywords_en`, `Seo`.`description`, `Seo`.`description_en`, `ImageParameter`.`id`, `ImageParameter`.`node_id`, `ImageParameter`.`no_limits`, `ImageParameter`.`max_width`, `ImageParameter`.`max_height`, `ImageParameter`.`min_width`, `ImageParameter`.`min_height`, `ImageParameter`.`exact_width`, `ImageParameter`.`exact_height` FROM `db_coffeemania_team`.`nodes` AS `Node` LEFT JOIN `db_coffeemania_team`.`seos` AS `Seo` ON (`Seo`.`node_id` = `Node`.`id`) LEFT JOIN `db_coffeemania_team`.`image_parameters` AS `ImageParameter` ON (`ImageParameter`.`node_id` = `Node`.`id`) WHERE `Node`.`parent_id` IN (2003, 2004) AND `Node`.`node_state` = 'published' ORDER BY `Node`.`lft` asc 983 983 20 SELECT `ChildNode`.`id`, `ChildNode`.`title`, `ChildNode`.`name`, `ChildNode`.`title_en`, `ChildNode`.`parent_id`, `ChildNode`.`lft`, `ChildNode`.`rght`, `ChildNode`.`slug`, `ChildNode`.`node_type`, `ChildNode`.`node_state`, `ChildNode`.`created`, `ChildNode`.`modified`, `ChildNode`.`published`, `ChildNode`.`stopped`, `ChildNode`.`user_id`, `ChildNode`.`is_dictionary`, `ChildNode`.`is_directory`, `ChildNode`.`is_news`, `ChildNode`.`image_count`, `ChildNode`.`price_count`, `ChildNode`.`order`, `ChildNode`.`protected`, `ChildNode`.`text`, `ChildNode`.`text_en`, `ChildNode`.`announce`, `ChildNode`.`announce_en`, `ChildNode`.`price`, `ChildNode`.`email`, `ChildNode`.`phone`, `ChildNode`.`address`, `ChildNode`.`address_en`, `ChildNode`.`schedule`, `ChildNode`.`schedule_en`, `ChildNode`.`breakfast`, `ChildNode`.`breakfast_en`, `ChildNode`.`animators`, `ChildNode`.`animators_en`, `ChildNode`.`short_title`, `ChildNode`.`short_title_en`, `ChildNode`.`gps`, `ChildNode`.`map`, `ChildNode`.`map_en`, `ChildNode`.`comment`, `ChildNode`.`comment_en`, `ChildNode`.`use_first_child`, `ChildNode`.`promo`, `ChildNode`.`promo_en`, `ChildNode`.`parking_url`, `ChildNode`.`address_2`, `ChildNode`.`address_2_en`, `ChildNode`.`address_3`, `ChildNode`.`yandexmaps_id`, `ChildNode`.`yandexmaps_working_time_en`, `ChildNode`.`yandexmaps_working_time` FROM `db_coffeemania_team`.`nodes` AS `ChildNode` WHERE `ChildNode`.`parent_id` IN (944, 938, 1852, 2898, 1389, 942, 946, 1421, 3531, 941, 950, 844, 3362, 976, 947, 1300, 2649, 3363, 3413, 835, 3196, 1224, 833, 3042, 2915) ORDER BY `lft` asc 18 18 6 maybe slowSELECT `Flag`.`id`, `Flag`.`name`, `Flag`.`node_id`, `Flag`.`value`, `Flag`.`label` FROM `db_coffeemania_team`.`flags` AS `Flag` WHERE `Flag`.`node_id` IN (944, 938, 1852, 2898, 1389, 942, 946, 1421, 3531, 941, 950, 844, 3362, 976, 947, 1300, 2649, 3363, 3413, 835, 3196, 1224, 833, 3042, 2915) 39 39 6 maybe slowSELECT `Image`.`id`, `Image`.`model_id`, `Image`.`model_name`, `Image`.`name`, `Image`.`name_en`, `Image`.`title`, `Image`.`title_en`, `Image`.`description`, `Image`.`description_en`, `Image`.`order`, `Image`.`url`, `Image`.`url_en`, `Image`.`target`, `Image`.`css_class` FROM `db_coffeemania_team`.`images` AS `Image` WHERE `Image`.`model_name` = 'Node' AND `Image`.`model_id` IN (944, 938, 1852, 2898, 1389, 942, 946, 1421, 3531, 941, 950, 844, 3362, 976, 947, 1300, 2649, 3363, 3413, 835, 3196, 1224, 833, 3042, 2915) ORDER BY `Image`.`order` ASC 205 205 1 SELECT `Attachment`.`id`, `Attachment`.`model_id`, `Attachment`.`name`, `Attachment`.`name_en`, `Attachment`.`title`, `Attachment`.`title_en`, `Attachment`.`description`, `Attachment`.`description_en`, `Attachment`.`model_name`, `Attachment`.`order`, (CONCAT("/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name`)) AS `Attachment__src`, (CONCAT("/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name_en`)) AS `Attachment__src_en`, (CONCAT("/home/coffeemania/www/app/webroot/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name`)) AS `Attachment__path`, (CONCAT("/home/coffeemania/www/app/webroot/media/attachments/nodes/", `Attachment`.`model_id`, "/", `Attachment`.`name_en`)) AS `Attachment__path_en` FROM `db_coffeemania_team`.`attachments` AS `Attachment` WHERE `Attachment`.`model_name` = 'Node' AND `Attachment`.`model_id` IN (944, 938, 1852, 2898, 1389, 942, 946, 1421, 3531, 941, 950, 844, 3362, 976, 947, 1300, 2649, 3363, 3413, 835, 3196, 1224, 833, 3042, 2915) ORDER BY `Attachment`.`order` ASC 94 94 13 maybe slowSELECT `Link`.`id`, `Link`.`node_id`, `Link`.`name`, `Link`.`label`, `Link`.`url`, `Link`.`text`, `Link`.`title`, `Link`.`target` FROM `db_coffeemania_team`.`links` AS `Link` WHERE `Link`.`node_id` IN (944, 938, 1852, 2898, 1389, 942, 946, 1421, 3531, 941, 950, 844, 3362, 976, 947, 1300, 2649, 3363, 3413, 835, 3196, 1224, 833, 3042, 2915) 0 0 2 maybe slow

coffeemania.ru


Смотрите также