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-04-24 13:35:03' WHERE `millebelledb`.`product_categories`.`id` = 2 | 1 | 1 | 336 | maybe slow |
COMMIT | 1 | 1 | 336 | maybe slow |
BEGIN | 1 | 1 | 336 | 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 | 0 | |
UPDATE `millebelledb`.`product_categories` SET `id` = 3, `available_product_count` = 8, `modified` = '2024-04-24 13:35:04' WHERE `millebelledb`.`product_categories`.`id` = 3 | 1 | 1 | 0 | |
COMMIT | 1 | 1 | 0 | |
BEGIN | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `millebelledb`.`product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 5 | 1 | 1 | 0 | |
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-04-24 13:35:04' 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 | 51 | maybe slow |
SELECT COUNT(*) AS `count` FROM `millebelledb`.`product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 7 | 1 | 1 | 51 | maybe slow |
UPDATE `millebelledb`.`product_categories` SET `id` = 7, `available_product_count` = 9, `modified` = '2024-04-24 13:35:04' WHERE `millebelledb`.`product_categories`.`id` = 7 | 1 | 1 | 58 | maybe slow |
COMMIT | 1 | 1 | 58 | maybe slow |
BEGIN | 1 | 1 | 58 | maybe slow |
SELECT COUNT(*) AS `count` FROM `millebelledb`.`product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 6 | 1 | 1 | 51 | maybe slow |
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-04-24 13:35:04' 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 `Slideshow`.`id`, `Slideshow`.`sort`, `Slideshow`.`image`, `Slideshow`.`url`, `Slideshow`.`title`, `Slideshow`.`description`, `Slideshow`.`created`, `Slideshow`.`modified` FROM `millebelledb`.`slideshows` AS `Slideshow` WHERE 1 = 1 ORDER BY `sort` ASC | 13 | 13 | 0 | |
SELECT `ProductParamType`.`id`, `ProductParamType`.`name` FROM `millebelledb`.`product_param_types` AS `ProductParamType` WHERE 1 = 1 | 0 | 0 | 0 | |
SELECT `ProductParamType`.`id`, `ProductParamType`.`name` FROM `millebelledb`.`product_param_types` AS `ProductParamType` WHERE 1 = 1 | 0 | 0 | 0 | |
SELECT `Product`.`id`, `Product`.`parent_id`, `Product`.`manufacturer_id`, `Product`.`product_status_id`, `Product`.`sync_status_id`, `Product`.`product_param_type_id`, `Product`.`sku`, `Product`.`barcode`, `Product`.`name`, `Product`.`properties`, `Product`.`s_desc`, `Product`.`desc`, `Product`.`special`, `Product`.`net_price`, `Product`.`tax_id`, `Product`.`stock`, `Product`.`meta_title`, `Product`.`meta_keywords`, `Product`.`meta_description`, `Product`.`canonical`, `Product`.`quantity_unit_shop_id`, `Product`.`quantity_unit_default_id`, `Product`.`quantity_unit_default_multiplier`, `Product`.`storage_status_text`, `Product`.`weight_gr`, `Product`.`modified`, `Product`.`created`, `Product`.`top_product`, `QuantityUnit`.`id`, `QuantityUnit`.`name`, `QuantityUnit`.`created`, `QuantityUnit`.`modified`, `QuantityUnitDefault`.`id`, `QuantityUnitDefault`.`name`, `QuantityUnitDefault`.`created`, `QuantityUnitDefault`.`modified`, `Parent`.`id`, `Parent`.`parent_id`, `Parent`.`manufacturer_id`, `Parent`.`product_status_id`, `Parent`.`sync_status_id`, `Parent`.`product_param_type_id`, `Parent`.`sku`, `Parent`.`barcode`, `Parent`.`name`, `Parent`.`properties`, `Parent`.`s_desc`, `Parent`.`desc`, `Parent`.`special`, `Parent`.`net_price`, `Parent`.`tax_id`, `Parent`.`stock`, `Parent`.`meta_title`, `Parent`.`meta_keywords`, `Parent`.`meta_description`, `Parent`.`canonical`, `Parent`.`quantity_unit_shop_id`, `Parent`.`quantity_unit_default_id`, `Parent`.`quantity_unit_default_multiplier`, `Parent`.`storage_status_text`, `Parent`.`weight_gr`, `Parent`.`modified`, `Parent`.`created`, `Parent`.`top_product`, `Manufacturer`.`id`, `Manufacturer`.`sync_generated_id`, `Manufacturer`.`manufacturer_category_id`, `Manufacturer`.`name`, `Manufacturer`.`desc`, `Manufacturer`.`image`, `Manufacturer`.`meta_title`, `Manufacturer`.`meta_keywords`, `Manufacturer`.`meta_description`, `Manufacturer`.`canonical`, `Manufacturer`.`created`, `Manufacturer`.`modified`, `Manufacturer`.`visible_in_manufacturer_logos`, `ProductStatus`.`id`, `ProductStatus`.`name`, `ProductParamType`.`id`, `ProductParamType`.`name`, `Tax`.`id`, `Tax`.`name`, `Tax`.`rate`, `Tax`.`start_date`, `Tax`.`created`, `Tax`.`modified` FROM `millebelledb`.`products` AS `Product` LEFT JOIN `millebelledb`.`quantity_units` AS `QuantityUnit` ON (`Product`.`quantity_unit_shop_id` = `QuantityUnit`.`id`) LEFT JOIN `millebelledb`.`quantity_units` AS `QuantityUnitDefault` ON (`Product`.`quantity_unit_default_id` = `QuantityUnitDefault`.`id`) LEFT JOIN `millebelledb`.`products` AS `Parent` ON (`Product`.`parent_id` = `Parent`.`id`) LEFT JOIN `millebelledb`.`manufacturers` AS `Manufacturer` ON (`Product`.`manufacturer_id` = `Manufacturer`.`id`) LEFT JOIN `millebelledb`.`product_statuses` AS `ProductStatus` ON (`Product`.`product_status_id` = `ProductStatus`.`id`) LEFT JOIN `millebelledb`.`product_param_types` AS `ProductParamType` ON (`Product`.`product_param_type_id` = `ProductParamType`.`id`) LEFT JOIN `millebelledb`.`taxes` AS `Tax` ON (`Product`.`tax_id` = `Tax`.`id`) WHERE `Product`.`special` = '1' AND `Product`.`product_status_id` IN (1, 2, 4) AND `Product`.`parent_id` IS NULL ORDER BY `Product`.`special` DESC, `Product`.`net_price` ASC LIMIT 12 | 7 | 7 | 0 | |
SELECT `ProductImage`.`id`, `ProductImage`.`product_id`, `ProductImage`.`filename`, `ProductImage`.`primary`, `ProductImage`.`created`, `ProductImage`.`modified` FROM `millebelledb`.`product_images` AS `ProductImage` WHERE `ProductImage`.`product_id` IN (117, 40, 110, 111, 112, 92, 123) | 13 | 13 | 0 | |
SELECT `CustomPrice`.`id`, `CustomPrice`.`product_id`, `CustomPrice`.`price_type_id`, `CustomPrice`.`net_value` FROM `millebelledb`.`custom_prices` AS `CustomPrice` WHERE `CustomPrice`.`product_id` IN (117, 40, 110, 111, 112, 92, 123) | 7 | 7 | 0 | |
SELECT `SubProduct`.`id`, `SubProduct`.`parent_id`, `SubProduct`.`manufacturer_id`, `SubProduct`.`product_status_id`, `SubProduct`.`sync_status_id`, `SubProduct`.`product_param_type_id`, `SubProduct`.`sku`, `SubProduct`.`barcode`, `SubProduct`.`name`, `SubProduct`.`properties`, `SubProduct`.`s_desc`, `SubProduct`.`desc`, `SubProduct`.`special`, `SubProduct`.`net_price`, `SubProduct`.`tax_id`, `SubProduct`.`stock`, `SubProduct`.`meta_title`, `SubProduct`.`meta_keywords`, `SubProduct`.`meta_description`, `SubProduct`.`canonical`, `SubProduct`.`quantity_unit_shop_id`, `SubProduct`.`quantity_unit_default_id`, `SubProduct`.`quantity_unit_default_multiplier`, `SubProduct`.`storage_status_text`, `SubProduct`.`weight_gr`, `SubProduct`.`modified`, `SubProduct`.`created`, `SubProduct`.`top_product` FROM `millebelledb`.`products` AS `SubProduct` WHERE `SubProduct`.`product_status_id` IN (1, 2, 4) AND `SubProduct`.`parent_id` IN (117, 40, 110, 111, 112, 92, 123) | 0 | 0 | 0 | |
SELECT `ProductRelation`.`id`, `ProductRelation`.`product_id`, `ProductRelation`.`related_product_id`, `ProductRelation`.`created`, `ProductRelation`.`modified` FROM `millebelledb`.`product_relations` AS `ProductRelation` WHERE `ProductRelation`.`product_id` IN (117, 40, 110, 111, 112, 92, 123) | 0 | 0 | 0 | |
SELECT `ProductDiscount`.`id`, `ProductDiscount`.`product_id`, `ProductDiscount`.`customer_group_id`, `ProductDiscount`.`manufacturer_id`, `ProductDiscount`.`is_gross`, `ProductDiscount`.`calculation_string`, `ProductDiscount`.`reason` FROM `millebelledb`.`product_discounts` AS `ProductDiscount` WHERE `ProductDiscount`.`product_id` IN (117, 40, 110, 111, 112, 92, 123) | 0 | 0 | 0 | |
SELECT `ProductCategory`.`id`, `ProductCategory`.`sync_generated_id`, `ProductCategory`.`parent_id`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`depth`, `ProductCategory`.`name`, `ProductCategory`.`desc`, `ProductCategory`.`image`, `ProductCategory`.`published`, `ProductCategory`.`meta_title`, `ProductCategory`.`meta_keywords`, `ProductCategory`.`meta_description`, `ProductCategory`.`canonical`, `ProductCategory`.`available_product_count`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductsProductCategory`.`id`, `ProductsProductCategory`.`product_id`, `ProductsProductCategory`.`product_category_id` FROM `millebelledb`.`product_categories` AS `ProductCategory` JOIN `millebelledb`.`products_product_categories` AS `ProductsProductCategory` ON (`ProductsProductCategory`.`product_id` IN (117, 40, 110, 111, 112, 92, 123) AND `ProductsProductCategory`.`product_category_id` = `ProductCategory`.`id`) | 12 | 12 | 1 | maybe slow |
SELECT `Product`.`id`, `Product`.`parent_id`, `Product`.`manufacturer_id`, `Product`.`product_status_id`, `Product`.`sync_status_id`, `Product`.`product_param_type_id`, `Product`.`sku`, `Product`.`barcode`, `Product`.`name`, `Product`.`properties`, `Product`.`s_desc`, `Product`.`desc`, `Product`.`special`, `Product`.`net_price`, `Product`.`tax_id`, `Product`.`stock`, `Product`.`meta_title`, `Product`.`meta_keywords`, `Product`.`meta_description`, `Product`.`canonical`, `Product`.`quantity_unit_shop_id`, `Product`.`quantity_unit_default_id`, `Product`.`quantity_unit_default_multiplier`, `Product`.`storage_status_text`, `Product`.`weight_gr`, `Product`.`modified`, `Product`.`created`, `Product`.`top_product`, `QuantityUnit`.`id`, `QuantityUnit`.`name`, `QuantityUnit`.`created`, `QuantityUnit`.`modified`, `QuantityUnitDefault`.`id`, `QuantityUnitDefault`.`name`, `QuantityUnitDefault`.`created`, `QuantityUnitDefault`.`modified`, `Parent`.`id`, `Parent`.`parent_id`, `Parent`.`manufacturer_id`, `Parent`.`product_status_id`, `Parent`.`sync_status_id`, `Parent`.`product_param_type_id`, `Parent`.`sku`, `Parent`.`barcode`, `Parent`.`name`, `Parent`.`properties`, `Parent`.`s_desc`, `Parent`.`desc`, `Parent`.`special`, `Parent`.`net_price`, `Parent`.`tax_id`, `Parent`.`stock`, `Parent`.`meta_title`, `Parent`.`meta_keywords`, `Parent`.`meta_description`, `Parent`.`canonical`, `Parent`.`quantity_unit_shop_id`, `Parent`.`quantity_unit_default_id`, `Parent`.`quantity_unit_default_multiplier`, `Parent`.`storage_status_text`, `Parent`.`weight_gr`, `Parent`.`modified`, `Parent`.`created`, `Parent`.`top_product`, `Manufacturer`.`id`, `Manufacturer`.`sync_generated_id`, `Manufacturer`.`manufacturer_category_id`, `Manufacturer`.`name`, `Manufacturer`.`desc`, `Manufacturer`.`image`, `Manufacturer`.`meta_title`, `Manufacturer`.`meta_keywords`, `Manufacturer`.`meta_description`, `Manufacturer`.`canonical`, `Manufacturer`.`created`, `Manufacturer`.`modified`, `Manufacturer`.`visible_in_manufacturer_logos`, `ProductStatus`.`id`, `ProductStatus`.`name`, `ProductParamType`.`id`, `ProductParamType`.`name`, `Tax`.`id`, `Tax`.`name`, `Tax`.`rate`, `Tax`.`start_date`, `Tax`.`created`, `Tax`.`modified` FROM `millebelledb`.`products` AS `Product` LEFT JOIN `millebelledb`.`quantity_units` AS `QuantityUnit` ON (`Product`.`quantity_unit_shop_id` = `QuantityUnit`.`id`) LEFT JOIN `millebelledb`.`quantity_units` AS `QuantityUnitDefault` ON (`Product`.`quantity_unit_default_id` = `QuantityUnitDefault`.`id`) LEFT JOIN `millebelledb`.`products` AS `Parent` ON (`Product`.`parent_id` = `Parent`.`id`) LEFT JOIN `millebelledb`.`manufacturers` AS `Manufacturer` ON (`Product`.`manufacturer_id` = `Manufacturer`.`id`) LEFT JOIN `millebelledb`.`product_statuses` AS `ProductStatus` ON (`Product`.`product_status_id` = `ProductStatus`.`id`) LEFT JOIN `millebelledb`.`product_param_types` AS `ProductParamType` ON (`Product`.`product_param_type_id` = `ProductParamType`.`id`) LEFT JOIN `millebelledb`.`taxes` AS `Tax` ON (`Product`.`tax_id` = `Tax`.`id`) WHERE `Product`.`product_status_id` IN (1, 2, 4) AND `Product`.`parent_id` IS NULL ORDER BY `Product`.`created` desc LIMIT 30 | 30 | 30 | 0 | |
SELECT `ProductImage`.`id`, `ProductImage`.`product_id`, `ProductImage`.`filename`, `ProductImage`.`primary`, `ProductImage`.`created`, `ProductImage`.`modified` FROM `millebelledb`.`product_images` AS `ProductImage` WHERE `ProductImage`.`product_id` IN (127, 126, 125, 124, 123, 122, 121, 120, 119, 118, 117, 116, 115, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 42, 43, 44, 45, 46, 48) | 74 | 74 | 0 | |
SELECT `CustomPrice`.`id`, `CustomPrice`.`product_id`, `CustomPrice`.`price_type_id`, `CustomPrice`.`net_value` FROM `millebelledb`.`custom_prices` AS `CustomPrice` WHERE `CustomPrice`.`product_id` IN (127, 126, 125, 124, 123, 122, 121, 120, 119, 118, 117, 116, 115, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 42, 43, 44, 45, 46, 48) | 30 | 30 | 0 | |
SELECT `SubProduct`.`id`, `SubProduct`.`parent_id`, `SubProduct`.`manufacturer_id`, `SubProduct`.`product_status_id`, `SubProduct`.`sync_status_id`, `SubProduct`.`product_param_type_id`, `SubProduct`.`sku`, `SubProduct`.`barcode`, `SubProduct`.`name`, `SubProduct`.`properties`, `SubProduct`.`s_desc`, `SubProduct`.`desc`, `SubProduct`.`special`, `SubProduct`.`net_price`, `SubProduct`.`tax_id`, `SubProduct`.`stock`, `SubProduct`.`meta_title`, `SubProduct`.`meta_keywords`, `SubProduct`.`meta_description`, `SubProduct`.`canonical`, `SubProduct`.`quantity_unit_shop_id`, `SubProduct`.`quantity_unit_default_id`, `SubProduct`.`quantity_unit_default_multiplier`, `SubProduct`.`storage_status_text`, `SubProduct`.`weight_gr`, `SubProduct`.`modified`, `SubProduct`.`created`, `SubProduct`.`top_product` FROM `millebelledb`.`products` AS `SubProduct` WHERE `SubProduct`.`product_status_id` IN (1, 2, 4) AND `SubProduct`.`parent_id` IN (127, 126, 125, 124, 123, 122, 121, 120, 119, 118, 117, 116, 115, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 42, 43, 44, 45, 46, 48) | 0 | 0 | 0 | |
SELECT `ProductRelation`.`id`, `ProductRelation`.`product_id`, `ProductRelation`.`related_product_id`, `ProductRelation`.`created`, `ProductRelation`.`modified` FROM `millebelledb`.`product_relations` AS `ProductRelation` WHERE `ProductRelation`.`product_id` IN (127, 126, 125, 124, 123, 122, 121, 120, 119, 118, 117, 116, 115, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 42, 43, 44, 45, 46, 48) | 0 | 0 | 0 | |
SELECT `ProductDiscount`.`id`, `ProductDiscount`.`product_id`, `ProductDiscount`.`customer_group_id`, `ProductDiscount`.`manufacturer_id`, `ProductDiscount`.`is_gross`, `ProductDiscount`.`calculation_string`, `ProductDiscount`.`reason` FROM `millebelledb`.`product_discounts` AS `ProductDiscount` WHERE `ProductDiscount`.`product_id` IN (127, 126, 125, 124, 123, 122, 121, 120, 119, 118, 117, 116, 115, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 42, 43, 44, 45, 46, 48) | 0 | 0 | 0 | |
SELECT `ProductCategory`.`id`, `ProductCategory`.`sync_generated_id`, `ProductCategory`.`parent_id`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`depth`, `ProductCategory`.`name`, `ProductCategory`.`desc`, `ProductCategory`.`image`, `ProductCategory`.`published`, `ProductCategory`.`meta_title`, `ProductCategory`.`meta_keywords`, `ProductCategory`.`meta_description`, `ProductCategory`.`canonical`, `ProductCategory`.`available_product_count`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductsProductCategory`.`id`, `ProductsProductCategory`.`product_id`, `ProductsProductCategory`.`product_category_id` FROM `millebelledb`.`product_categories` AS `ProductCategory` JOIN `millebelledb`.`products_product_categories` AS `ProductsProductCategory` ON (`ProductsProductCategory`.`product_id` IN (127, 126, 125, 124, 123, 122, 121, 120, 119, 118, 117, 116, 115, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 42, 43, 44, 45, 46, 48) AND `ProductsProductCategory`.`product_category_id` = `ProductCategory`.`id`) | 37 | 37 | 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 | |
14 duplicate queries run.