Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Settings`.`id`, `Settings`.`theme_id`, `Settings`.`theme`, `Settings`.`project_name`, `Settings`.`title`, `Settings`.`keywords`, `Settings`.`description`, `Settings`.`canonical`, `Settings`.`suspend_date_start`, `Settings`.`suspend_date_stop`, `Settings`.`suspend_text`, `Settings`.`suspend_type`, `Settings`.`webshop_site`, `Settings`.`webshop_name`, `Settings`.`webshop_company`, `Settings`.`webshop_address`, `Settings`.`webshop_phone`, `Settings`.`webshop_email`, `Settings`.`facebook_url`, `Settings`.`shipping_article_id`, `Settings`.`aszf_url`, `Settings`.`aszf_id`, `Settings`.`aszf_version`, `Settings`.`manufacturer_logos_toggle`, `Settings`.`slideshow_toggle`, `Settings`.`category_list_toggle` FROM `millebelledb`.`settings` AS `Settings` WHERE 1 = 1 LIMIT 1 | 1 | 1 | 51 | maybe slow |
SELECT `ProductParamType`.`id`, `ProductParamType`.`name` FROM `millebelledb`.`product_param_types` AS `ProductParamType` WHERE 1 = 1 | 0 | 0 | 51 | maybe slow |
SELECT `Manufacturer`.`id`, `Manufacturer`.`name`, `Manufacturer`.`image`, `Manufacturer`.`visible_in_manufacturer_logos` FROM `millebelledb`.`manufacturers` AS `Manufacturer` WHERE `visible_in_manufacturer_logos` = '1' | 4 | 4 | 51 | maybe slow |
SELECT `ProductCategory`.`id`, `parent_id`, `ProductCategory`.`name`, `ProductCategory`.`published`, `ProductCategory`.`desc`, `ProductCategory`.`image`, `ProductCategory`.`available_product_count` FROM `millebelledb`.`product_categories` AS `ProductCategory` WHERE `published` = '1' ORDER BY `lft` ASC | 5 | 5 | 51 | maybe slow |
SELECT product_category_id, COUNT(product_category_id) FROM `millebelledb`.`products_product_categories` AS `ProductsProductCategory` WHERE 1 = 1 GROUP BY product_category_id | 7 | 7 | 51 | maybe slow |
BEGIN | 7 | 7 | 51 | maybe slow |
SELECT COUNT(*) AS `count` FROM `millebelledb`.`product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 2 | 1 | 1 | 51 | maybe slow |
SELECT COUNT(*) AS `count` FROM `millebelledb`.`product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 2 | 1 | 1 | 51 | maybe slow |
UPDATE `millebelledb`.`product_categories` SET `id` = 2, `available_product_count` = 54, `modified` = '2024-05-06 12:37:29' WHERE `millebelledb`.`product_categories`.`id` = 2 | 1 | 1 | 2551 | maybe slow |
COMMIT | 1 | 1 | 2551 | maybe slow |
BEGIN | 1 | 1 | 2551 | maybe slow |
SELECT COUNT(*) AS `count` FROM `millebelledb`.`product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 3 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `millebelledb`.`product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 3 | 1 | 1 | 1 | |
UPDATE `millebelledb`.`product_categories` SET `id` = 3, `available_product_count` = 8, `modified` = '2024-05-06 12:37:31' WHERE `millebelledb`.`product_categories`.`id` = 3 | 1 | 1 | 1 | |
COMMIT | 1 | 1 | 1 | |
BEGIN | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `millebelledb`.`product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 5 | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `millebelledb`.`product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 5 | 1 | 1 | 0 | |
UPDATE `millebelledb`.`product_categories` SET `id` = 5, `available_product_count` = 31, `modified` = '2024-05-06 12:37:31' WHERE `millebelledb`.`product_categories`.`id` = 5 | 1 | 1 | 0 | |
COMMIT | 1 | 1 | 0 | |
BEGIN | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `millebelledb`.`product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 7 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `millebelledb`.`product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 7 | 1 | 1 | 0 | |
UPDATE `millebelledb`.`product_categories` SET `id` = 7, `available_product_count` = 9, `modified` = '2024-05-06 12:37:31' WHERE `millebelledb`.`product_categories`.`id` = 7 | 1 | 1 | 0 | |
COMMIT | 1 | 1 | 0 | |
BEGIN | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `millebelledb`.`product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 6 | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `millebelledb`.`product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 6 | 1 | 1 | 0 | |
UPDATE `millebelledb`.`product_categories` SET `id` = 6, `available_product_count` = 39, `modified` = '2024-05-06 12:37:31' WHERE `millebelledb`.`product_categories`.`id` = 6 | 1 | 1 | 0 | |
COMMIT | 1 | 1 | 0 | |
SELECT `ArticleCategory`.`id`, `ArticleCategory`.`name`, `ArticleCategory`.`desc`, `ArticleCategory`.`published`, `ArticleCategory`.`meta_title`, `ArticleCategory`.`meta_keywords`, `ArticleCategory`.`meta_description`, `ArticleCategory`.`canonical`, `ArticleCategory`.`robots`, `ArticleCategory`.`articles_published`, `ArticleCategory`.`created`, `ArticleCategory`.`modified`, `ArticleCategory`.`image` FROM `millebelledb`.`article_categories` AS `ArticleCategory` WHERE `ArticleCategory`.`published` = '1' LIMIT 1 | 1 | 1 | 0 | |
SELECT `HighlightedArticle`.`id`, `HighlightedArticle`.`admin_id`, `HighlightedArticle`.`article_category_id`, `HighlightedArticle`.`title`, `HighlightedArticle`.`image`, `HighlightedArticle`.`image2`, `HighlightedArticle`.`gallery_id`, `HighlightedArticle`.`desc`, `HighlightedArticle`.`body`, `HighlightedArticle`.`published`, `HighlightedArticle`.`highlighted`, `HighlightedArticle`.`meta_title`, `HighlightedArticle`.`meta_keywords`, `HighlightedArticle`.`meta_description`, `HighlightedArticle`.`canonical`, `HighlightedArticle`.`robots`, `HighlightedArticle`.`start_date`, `HighlightedArticle`.`created`, `HighlightedArticle`.`modified`, `HighlightedArticle`.`file_name`, `HighlightedArticle`.`file_size`, `HighlightedArticle`.`order_in_category` FROM `millebelledb`.`articles` AS `HighlightedArticle` WHERE `HighlightedArticle`.`highlighted` = '1' AND `HighlightedArticle`.`article_category_id` = (1) | 0 | 0 | 0 | |
SELECT `Article`.`id`, `Article`.`admin_id`, `Article`.`article_category_id`, `Article`.`title`, `Article`.`image`, `Article`.`image2`, `Article`.`gallery_id`, `Article`.`desc`, `Article`.`body`, `Article`.`published`, `Article`.`highlighted`, `Article`.`meta_title`, `Article`.`meta_keywords`, `Article`.`meta_description`, `Article`.`canonical`, `Article`.`robots`, `Article`.`start_date`, `Article`.`created`, `Article`.`modified`, `Article`.`file_name`, `Article`.`file_size`, `Article`.`order_in_category`, `Admin`.`name`, `ArticleCategory`.`id`, `ArticleCategory`.`name`, `ArticleCategory`.`desc`, `ArticleCategory`.`published`, `ArticleCategory`.`meta_title`, `ArticleCategory`.`meta_keywords`, `ArticleCategory`.`meta_description`, `ArticleCategory`.`canonical`, `ArticleCategory`.`robots`, `ArticleCategory`.`articles_published`, `ArticleCategory`.`created`, `ArticleCategory`.`modified`, `ArticleCategory`.`image`, `Gallery`.`id`, `Gallery`.`name`, `Gallery`.`parent_id`, `Gallery`.`gallery_images_count` FROM `millebelledb`.`articles` AS `Article` LEFT JOIN `millebelledb`.`admins` AS `Admin` ON (`Article`.`admin_id` = `Admin`.`id`) LEFT JOIN `millebelledb`.`article_categories` AS `ArticleCategory` ON (`Article`.`article_category_id` = `ArticleCategory`.`id`) LEFT JOIN `millebelledb`.`galleries` AS `Gallery` ON (`Article`.`gallery_id` = `Gallery`.`id`) WHERE `Article`.`id` IS NULL | 0 | 0 | 0 | |
SELECT `Article`.`id`, `Article`.`admin_id`, `Article`.`article_category_id`, `Article`.`title`, `Article`.`image`, `Article`.`image2`, `Article`.`gallery_id`, `Article`.`desc`, `Article`.`body`, `Article`.`published`, `Article`.`highlighted`, `Article`.`meta_title`, `Article`.`meta_keywords`, `Article`.`meta_description`, `Article`.`canonical`, `Article`.`robots`, `Article`.`start_date`, `Article`.`created`, `Article`.`modified`, `Article`.`file_name`, `Article`.`file_size`, `Article`.`order_in_category`, `Admin`.`name`, `ArticleCategory`.`id`, `ArticleCategory`.`name`, `ArticleCategory`.`desc`, `ArticleCategory`.`published`, `ArticleCategory`.`meta_title`, `ArticleCategory`.`meta_keywords`, `ArticleCategory`.`meta_description`, `ArticleCategory`.`canonical`, `ArticleCategory`.`robots`, `ArticleCategory`.`articles_published`, `ArticleCategory`.`created`, `ArticleCategory`.`modified`, `ArticleCategory`.`image`, `Gallery`.`id`, `Gallery`.`name`, `Gallery`.`parent_id`, `Gallery`.`gallery_images_count` FROM `millebelledb`.`articles` AS `Article` LEFT JOIN `millebelledb`.`admins` AS `Admin` ON (`Article`.`admin_id` = `Admin`.`id`) LEFT JOIN `millebelledb`.`article_categories` AS `ArticleCategory` ON (`Article`.`article_category_id` = `ArticleCategory`.`id`) LEFT JOIN `millebelledb`.`galleries` AS `Gallery` ON (`Article`.`gallery_id` = `Gallery`.`id`) WHERE `Article`.`published` = '1' AND `article_category_id` = 1 ORDER BY `Article`.`created` DESC LIMIT 5 | 5 | 5 | 0 | |
SELECT `Article`.`id`, `Article`.`admin_id`, `Article`.`article_category_id`, `Article`.`title`, `Article`.`image`, `Article`.`image2`, `Article`.`gallery_id`, `Article`.`desc`, `Article`.`body`, `Article`.`published`, `Article`.`highlighted`, `Article`.`meta_title`, `Article`.`meta_keywords`, `Article`.`meta_description`, `Article`.`canonical`, `Article`.`robots`, `Article`.`start_date`, `Article`.`created`, `Article`.`modified`, `Article`.`file_name`, `Article`.`file_size`, `Article`.`order_in_category`, `Admin`.`name`, `ArticleCategory`.`id`, `ArticleCategory`.`name`, `ArticleCategory`.`desc`, `ArticleCategory`.`published`, `ArticleCategory`.`meta_title`, `ArticleCategory`.`meta_keywords`, `ArticleCategory`.`meta_description`, `ArticleCategory`.`canonical`, `ArticleCategory`.`robots`, `ArticleCategory`.`articles_published`, `ArticleCategory`.`created`, `ArticleCategory`.`modified`, `ArticleCategory`.`image`, `Gallery`.`id`, `Gallery`.`name`, `Gallery`.`parent_id`, `Gallery`.`gallery_images_count` FROM `millebelledb`.`articles` AS `Article` LEFT JOIN `millebelledb`.`admins` AS `Admin` ON (`Article`.`admin_id` = `Admin`.`id`) LEFT JOIN `millebelledb`.`article_categories` AS `ArticleCategory` ON (`Article`.`article_category_id` = `ArticleCategory`.`id`) LEFT JOIN `millebelledb`.`galleries` AS `Gallery` ON (`Article`.`gallery_id` = `Gallery`.`id`) WHERE `Article`.`id` = 5 AND `Article`.`published` = '1' LIMIT 1 | 1 | 1 | 1 | |
SELECT `Menu`.`id`, `Menu`.`sort`, `Menu`.`position`, `Menu`.`title`, `Menu`.`url`, `Menu`.`active`, `Menu`.`parent_id` FROM `millebelledb`.`menus` AS `Menu` WHERE `active` = '1' ORDER BY `position` ASC, `sort` ASC | 5 | 5 | 0 | |
12 duplicate queries run.