| Query | Error | Affected | Num. rows | Took (ms) | Actions |
|---|
| DESCRIBE `products` | | 8 | 8 | 1 | maybe slow |
| DESCRIBE `products_photos` | | 5 | 5 | 1 | maybe slow |
| DESCRIBE `categories` | | 8 | 8 | 1 | maybe slow |
| DESCRIBE `products_categories` | | 3 | 3 | 1 | maybe slow |
| DESCRIBE `categories_uploads` | | 3 | 3 | 1 | maybe slow |
| DESCRIBE `products_uploads` | | 3 | 3 | 1 | maybe slow |
| DESCRIBE `uploads` | | 6 | 6 | 1 | maybe slow |
| DESCRIBE `uploads_folders` | | 2 | 2 | 1 | maybe slow |
| SET CHARACTER SET utf8; | | 0 | | 0 | |
| SELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`suffix`, `Setting`.`active`, `Setting`.`contact_email`, `Setting`.`mail_port`, `Setting`.`mail_timeout`, `Setting`.`mail_host`, `Setting`.`mail_username`, `Setting`.`mail_password`, `Setting`.`mail_from`, `Setting`.`mail_mail`, `Setting`.`restore_contents_id` FROM `settings` AS `Setting` WHERE 1 = 1 LIMIT 1 | | 1 | 1 | 0 | |
| SET CHARACTER SET utf8; | | 0 | | 0 | |
| SELECT `Group`.`id`, `Group`.`title`, `Group`.`register_contents_id`, `Group`.`active_default`, `Group`.`email_activation`, `Group`.`edit_contents_id` FROM `groups` AS `Group` WHERE `Group`.`id` IS NULL LIMIT 1 | | 0 | 0 | 0 | |
| SET CHARACTER SET utf8; | | 0 | | 0 | |
| SELECT `Language`.`id`, `Language`.`title`, `Language`.`url`, `Language`.`shorttitle`, `Language`.`hidden` FROM `languages` AS `Language` WHERE 1 = 1 | | 2 | 2 | 0 | |
| SET CHARACTER SET utf8; | | 0 | | 0 | |
| SELECT `Language`.`id`, `Language`.`title`, `Language`.`url`, `Language`.`shorttitle`, `Language`.`hidden` FROM `languages` AS `Language` WHERE `hidden` = 0 | | 2 | 2 | 0 | |
| SET CHARACTER SET utf8; | | 0 | | 0 | |
| SELECT `StatsEnter`.`id`, `StatsEnter`.`address`, `StatsEnter`.`host`, `StatsEnter`.`referer`, `StatsEnter`.`date`, `StatsEnter`.`ip`, `StatsEnter`.`browser`, `StatsEnter`.`referer_domain`, `StatsEnter`.`google_keywords` FROM `stats_enters` AS `StatsEnter` WHERE `StatsEnter`.`host` = '38.107.179.214' AND `StatsEnter`.`date` > '2012-02-22 12:34:16' LIMIT 1 | | 1 | 1 | 20 | maybe slow |
| SET CHARACTER SET utf8; | | 0 | | 1 | maybe slow |
| SELECT `Category`.`id`, `Category`.`collections_id`, `Category`.`title`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`description`, `Category`.`short_description`, `CategoryParent`.`id`, `CategoryParent`.`collections_id`, `CategoryParent`.`title`, `CategoryParent`.`parent_id`, `CategoryParent`.`lft`, `CategoryParent`.`rght`, `CategoryParent`.`description`, `CategoryParent`.`short_description` FROM `categories` AS `Category` LEFT JOIN `categories` AS `CategoryParent` ON (`Category`.`parent_id` = `CategoryParent`.`id`) WHERE `Category`.`collections_id` = 1 ORDER BY `Category`.`lft` asc | | 11 | 11 | 0 | |
| SET CHARACTER SET utf8; | | 0 | | 0 | |
| SELECT `Collection`.`id`, `Collection`.`contents_id`, `Collection`.`title`, `Collection`.`languages_id`, `Collection`.`full_size`, `Collection`.`thumb_size` FROM `collections` AS `Collection` WHERE `Collection`.`id` = 1 LIMIT 1 | | 1 | 1 | 0 | |
| SET CHARACTER SET utf8; | | 0 | | 0 | |
| SELECT `Content`.`id`, `Content`.`users_id`, `Content`.`title`, `Content`.`description`, `Content`.`start_site`, `Content`.`languages_id`, `Content`.`layout_file`, `Content`.`hide_title`, `Content`.`meta_description`, `Content`.`meta_keywords`, `Content`.`comments`, `Content`.`comments_active`, `Content`.`access_restriction`, `Content`.`name` FROM `contents` AS `Content` WHERE `Content`.`id` = 47 LIMIT 1 | | 1 | 1 | 0 | |
| SELECT `Module`.`id`, `Module`.`place`, `Module`.`title`, `Module`.`priority`, `Module`.`is_global`, `Module`.`description`, `Module`.`visible`, `Module`.`languages_id`, `Module`.`access_restriction`, `ContentsModule`.`id`, `ContentsModule`.`modules_id`, `ContentsModule`.`contents_id` FROM `modules` AS `Module` JOIN `contents_modules` AS `ContentsModule` ON (`ContentsModule`.`contents_id` = 47 AND `ContentsModule`.`modules_id` = `Module`.`id`) | | 0 | 0 | 0 | |
| SET CHARACTER SET utf8; | | 0 | | 0 | |
| SELECT `Module`.`id`, `Module`.`place`, `Module`.`title`, `Module`.`priority`, `Module`.`is_global`, `Module`.`description`, `Module`.`visible`, `Module`.`languages_id`, `Module`.`access_restriction` FROM `modules` AS `Module` WHERE `Module`.`is_global` = 1 AND `Module`.`visible` = 0 AND `Module`.`languages_id` = 1 ORDER BY `Module`.`priority` asc | | 5 | 5 | 0 | |
| SELECT `Menu`.`id`, `Menu`.`modules_id`, `Menu`.`title`, `Menu`.`html_before`, `Menu`.`html_after`, `Menu`.`languages_id` FROM `menus` AS `Menu` WHERE `Menu`.`modules_id` IN (2, 3, 31, 1, 39) | | 1 | 1 | 0 | |
| SELECT `MenusItem`.`id`, `MenusItem`.`menus_id`, `MenusItem`.`item_id`, `MenusItem`.`item_type`, `MenusItem`.`title`, `MenusItem`.`item_url`, `MenusItem`.`html_before`, `MenusItem`.`html_after`, `MenusItem`.`priority`, `MenusItem`.`lft`, `MenusItem`.`rght`, `MenusItem`.`parent_id`, `MenusItem`.`url`, `MenusItem`.`url2`, `MenusItem`.`url3` FROM `menus_items` AS `MenusItem` WHERE `MenusItem`.`menus_id` = (1) ORDER BY `MenusItem`.`lft` asc | | 4 | 4 | 0 | |
| SELECT `ModulesLanguage`.`id`, `ModulesLanguage`.`modules_id` FROM `modules_languages` AS `ModulesLanguage` WHERE `ModulesLanguage`.`modules_id` IN (2, 3, 31, 1, 39) | | 1 | 1 | 0 | |
| SELECT `ModulesLogin`.`id`, `ModulesLogin`.`modules_id`, `ModulesLogin`.`redirect_contents_id` FROM `modules_logins` AS `ModulesLogin` WHERE `ModulesLogin`.`modules_id` IN (2, 3, 31, 1, 39) | | 0 | 0 | 0 | |
| SELECT `ModulesRight`.`id`, `ModulesRight`.`groups_id`, `ModulesRight`.`modules_id` FROM `modules_rights` AS `ModulesRight` WHERE `ModulesRight`.`modules_id` IN (2, 3, 31, 1, 39) | | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`contents_id`, `Gallery`.`title`, `Gallery`.`languages_id`, `Gallery`.`gallery_type`, `Gallery`.`full_size`, `Gallery`.`thumb_size`, `Gallery`.`alias_id`, `ModulesGallery`.`id`, `ModulesGallery`.`galleries_id`, `ModulesGallery`.`modules_id`, `ModulesGallery`.`plugin_type` FROM `galleries` AS `Gallery` JOIN `modules_galleries` AS `ModulesGallery` ON (`ModulesGallery`.`modules_id` IN (2, 3, 31, 1, 39) AND `ModulesGallery`.`galleries_id` = `Gallery`.`id`) | | 0 | 0 | 0 | |
| SELECT `Chronicle`.`id`, `Chronicle`.`contents_id`, `Chronicle`.`title`, `Chronicle`.`languages_id`, `Chronicle`.`chronicles_type`, `Chronicle`.`date_visible`, `Chronicle`.`full_size`, `Chronicle`.`thumb_size`, `ModulesChronicle`.`id`, `ModulesChronicle`.`modules_id`, `ModulesChronicle`.`chronicles_id`, `ModulesChronicle`.`plugin_type` FROM `chronicles` AS `Chronicle` JOIN `modules_chronicles` AS `ModulesChronicle` ON (`ModulesChronicle`.`modules_id` IN (2, 3, 31, 1, 39) AND `ModulesChronicle`.`chronicles_id` = `Chronicle`.`id`) | | 0 | 0 | 0 | |
| SET CHARACTER SET utf8; | | 0 | | 0 | |
| SELECT `Content`.`id`, `Content`.`users_id`, `Content`.`title`, `Content`.`description`, `Content`.`start_site`, `Content`.`languages_id`, `Content`.`layout_file`, `Content`.`hide_title`, `Content`.`meta_description`, `Content`.`meta_keywords`, `Content`.`comments`, `Content`.`comments_active`, `Content`.`access_restriction`, `Content`.`name` FROM `contents` AS `Content` WHERE `Content`.`id` = 47 AND `Content`.`languages_id` = 1 LIMIT 1 | | 1 | 1 | 0 | |
| SELECT `Module`.`id`, `Module`.`place`, `Module`.`title`, `Module`.`priority`, `Module`.`is_global`, `Module`.`description`, `Module`.`visible`, `Module`.`languages_id`, `Module`.`access_restriction`, `ContentsModule`.`id`, `ContentsModule`.`modules_id`, `ContentsModule`.`contents_id` FROM `modules` AS `Module` JOIN `contents_modules` AS `ContentsModule` ON (`ContentsModule`.`contents_id` = 47 AND `ContentsModule`.`modules_id` = `Module`.`id`) ORDER BY `Module`.`priority` asc | | 0 | 0 | 0 | |
| SET CHARACTER SET utf8; | | 0 | | 0 | |
| SELECT `Category`.`id`, `Category`.`title` FROM `categories` AS `Category` LEFT JOIN `categories` AS `CategoryParent` ON (`Category`.`parent_id` = `CategoryParent`.`id`) WHERE `Category`.`collections_id` = 1 AND ((`Category`.`parent_id` IS NULL) OR (`Category`.`parent_id` = 0)) | | 2 | 2 | 0 | |
| SET CHARACTER SET utf8; | | 0 | | 0 | |
| SELECT COUNT(*) AS `count` FROM `products` AS `Product` WHERE `Product`.`collections_id` = 1 | | 1 | 1 | 0 | |
| SET CHARACTER SET utf8; | | 0 | | 0 | |
| SELECT `Product`.`id`, `Product`.`collections_id`, `Product`.`title`, `Product`.`description`, `Product`.`price`, `Product`.`short_description`, `Product`.`url`, `Product`.`priority` FROM `products` AS `Product` WHERE `Product`.`collections_id` = 1 ORDER BY `Product`.`priority` desc LIMIT 1000 | | 14 | 14 | 0 | |
| SELECT `ProductsPhoto`.`id`, `ProductsPhoto`.`products_id`, `ProductsPhoto`.`url`, `ProductsPhoto`.`priority`, `ProductsPhoto`.`visible` FROM `products_photos` AS `ProductsPhoto` WHERE `ProductsPhoto`.`products_id` IN (10, 3, 11, 17, 1, 12, 13, 14, 15, 16, 34, 19, 20, 18) | | 14 | 14 | 0 | |
| SET CHARACTER SET utf8; | | 0 | | 0 | |
| SELECT `CategoriesUpload`.`uploads_id` FROM `categories_uploads` AS `CategoriesUpload` WHERE `CategoriesUpload`.`categories_id` IS NULL | | 0 | 0 | 0 | |
| SET CHARACTER SET utf8; | | 0 | | 0 | |
| SELECT `Upload`.`id`, `Upload`.`uploads_folders_id`, `Upload`.`name`, `Upload`.`title`, `Upload`.`f_type`, `Upload`.`size`, `UploadsFolder`.`id`, `UploadsFolder`.`title` FROM `uploads` AS `Upload` LEFT JOIN `uploads_folders` AS `UploadsFolder` ON (`Upload`.`uploads_folders_id` = `UploadsFolder`.`id`) WHERE `Upload`.`id` IS NULL | | 0 | 0 | 0 | |
