| 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 | 1 | |
| SELECT `ProductParamType`.`id`, `ProductParamType`.`name` FROM `millebelledb`.`product_param_types` AS `ProductParamType` WHERE 1 = 1 | 0 | 0 | 0 | |
| 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 | 0 | |
| 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 | 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 | 1 | maybe slow |
| 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 | 1 | maybe slow |
| 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 | 1 | maybe slow |
| 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` FROM `millebelledb`.`product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 2 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ProductCategory`.`lft`, `ProductCategory`.`rght` FROM `millebelledb`.`product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 2 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ProductCategory`.`id` FROM `millebelledb`.`product_categories` AS `ProductCategory` WHERE 1 = 1 AND `ProductCategory`.`lft` <= 3 AND `ProductCategory`.`rght` >= 4 ORDER BY `ProductCategory`.`lft` asc | 1 | 1 | 0 | |
| SELECT `ProductCategory`.`lft`, `ProductCategory`.`rght` FROM `millebelledb`.`product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 2 LIMIT 1 | 1 | 1 | 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` FROM `millebelledb`.`product_categories` AS `ProductCategory` WHERE 1 = 1 AND `ProductCategory`.`lft` <= 3 AND `ProductCategory`.`rght` >= 4 ORDER BY `ProductCategory`.`lft` asc | 1 | 1 | 1 | |
| SELECT `ProductCategory`.`lft`, `ProductCategory`.`rght` FROM `millebelledb`.`product_categories` AS `ProductCategory` WHERE 1 = 1 AND `ProductCategory`.`id` = 2 LIMIT 1 | 1 | 1 | 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` FROM `millebelledb`.`product_categories` AS `ProductCategory` WHERE 1 = 1 AND `ProductCategory`.`rght` < 4 AND `ProductCategory`.`lft` > 3 ORDER BY `ProductCategory`.`lft` asc | 0 | 0 | 0 | |
| SELECT `ProductsProductCategory`.`product_id` FROM `millebelledb`.`products_product_categories` AS `ProductsProductCategory` WHERE product_category_id = (2) | 54 | 54 | 1 | |
| SELECT DISTINCT `Product`.`product_param_type_id` FROM `millebelledb`.`products` AS `Product` WHERE `Product`.`id` IN (1, 2, 3, 4, 6, 10, 11, 12, 16, 17, 18, 19, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 33, 34, 35, 36, 37, 38, 40, 73, 74, 75, 76, 79, 88, 92, 94, 105, 106, 108, 110, 111, 112, 115, 116, 117, 118, 119, 120, 121, 122, 125, 126, 127) AND `Product`.`product_status_id` IN (1, 2, 4) AND `Product`.`parent_id` IS NULL | 1 | 1 | 1 | |
| 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`.`id` IN (22, 31, 73, 74, 75, 76, 79, 1, 25, 26, 27, 6, 4, 24, 28, 30, 11, 2, 33, 3, 35, 36, 23, 29, 34, 10, 37, 38, 105, 106, 108, 111, 112, 110, 12, 18, 19, 88, 16, 92, 94, 17, 40, 116, 115, 118, 119, 120, 121, 122, 125, 126, 127, 117) AND `Product`.`product_status_id` IN (1, 2, 4) AND `Product`.`parent_id` IS NULL ORDER BY `Product`.`net_price` asc LIMIT 48, 12 | 6 | 6 | 3 | maybe slow |
| 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 (105, 106, 108, 22, 31, 29) | 10 | 10 | 1 | maybe slow |
| SELECT `CustomPrice`.`id`, `CustomPrice`.`product_id`, `CustomPrice`.`price_type_id`, `CustomPrice`.`net_value` FROM `millebelledb`.`custom_prices` AS `CustomPrice` WHERE `CustomPrice`.`product_id` IN (105, 106, 108, 22, 31, 29) | 6 | 6 | 1 | maybe slow |
| 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 (105, 106, 108, 22, 31, 29) | 0 | 0 | 1 | maybe slow |
| 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 (105, 106, 108, 22, 31, 29) | 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 (105, 106, 108, 22, 31, 29) | 0 | 0 | 1 | maybe slow |
| 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 (105, 106, 108, 22, 31, 29) AND `ProductsProductCategory`.`product_category_id` = `ProductCategory`.`id`) | 9 | 9 | 1 | maybe slow |
| SELECT COUNT(*) AS `count` 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`.`id` IN (22, 31, 73, 74, 75, 76, 79, 1, 25, 26, 27, 6, 4, 24, 28, 30, 11, 2, 33, 3, 35, 36, 23, 29, 34, 10, 37, 38, 105, 106, 108, 111, 112, 110, 12, 18, 19, 88, 16, 92, 94, 17, 40, 116, 115, 118, 119, 120, 121, 122, 125, 126, 127, 117) AND `Product`.`product_status_id` IN (1, 2, 4) AND `Product`.`parent_id` IS NULL | 1 | 1 | 2 | maybe slow |
| 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 | 1 | maybe slow |
| SELECT `CustomerGroup`.`id`, `CustomerGroup`.`name`, `CustomerGroup`.`price_type_id`, `CustomerGroup`.`created`, `CustomerGroup`.`modified`, `PriceType`.`id`, `PriceType`.`name`, `PriceType`.`is_default`, `PriceType`.`calculation_method_type_id`, `PriceType`.`calculation_method_type_string` FROM `millebelledb`.`customer_groups` AS `CustomerGroup` LEFT JOIN `millebelledb`.`price_types` AS `PriceType` ON (`CustomerGroup`.`price_type_id` = `PriceType`.`id`) WHERE `CustomerGroup`.`id` = 1 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Customer`.`id`, `Customer`.`email`, `Customer`.`password`, `Customer`.`customer_group_id`, `Customer`.`company_name`, `Customer`.`firstname`, `Customer`.`lastname`, `Customer`.`phone`, `Customer`.`guest`, `Customer`.`active`, `Customer`.`last_login`, `Customer`.`modified`, `Customer`.`created`, `Customer`.`aszf_accept_version`, `Customer`.`aszf_accept_date`, `Customer`.`newsletter_subscribe`, `Customer`.`cookie_hash`, (CONCAT(`Customer`.`firstname`, " ", `Customer`.`lastname`)) AS `Customer__name` FROM `millebelledb`.`customers` AS `Customer` WHERE `Customer`.`customer_group_id` = (1) | 0 | 0 | 1 | maybe slow |
| SELECT `PriceType`.`id`, `PriceType`.`name`, `PriceType`.`is_default`, `PriceType`.`calculation_method_type_id`, `PriceType`.`calculation_method_type_string` FROM `millebelledb`.`price_types` AS `PriceType` WHERE `is_default` = '1' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `CustomPrice`.`id`, `CustomPrice`.`product_id`, `CustomPrice`.`price_type_id`, `CustomPrice`.`net_value`, `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`, `PriceType`.`id`, `PriceType`.`name`, `PriceType`.`is_default`, `PriceType`.`calculation_method_type_id`, `PriceType`.`calculation_method_type_string` FROM `millebelledb`.`custom_prices` AS `CustomPrice` LEFT JOIN `millebelledb`.`products` AS `Product` ON (`CustomPrice`.`product_id` = `Product`.`id`) LEFT JOIN `millebelledb`.`price_types` AS `PriceType` ON (`CustomPrice`.`price_type_id` = `PriceType`.`id`) WHERE `product_id` = 105 AND `price_type_id` = 1 LIMIT 1 | 1 | 1 | 1 | |
| 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` IS NULL) OR (`ProductDiscount`.`product_id` = 105))) AND (((`ProductDiscount`.`customer_group_id` IS NULL) OR (`ProductDiscount`.`customer_group_id` = 1))) AND (((`ProductDiscount`.`manufacturer_id` IS NULL) OR (`ProductDiscount`.`manufacturer_id` = 1)))) | 0 | 0 | 1 | maybe slow |
| SELECT `CustomPrice`.`id`, `CustomPrice`.`product_id`, `CustomPrice`.`price_type_id`, `CustomPrice`.`net_value`, `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`, `PriceType`.`id`, `PriceType`.`name`, `PriceType`.`is_default`, `PriceType`.`calculation_method_type_id`, `PriceType`.`calculation_method_type_string` FROM `millebelledb`.`custom_prices` AS `CustomPrice` LEFT JOIN `millebelledb`.`products` AS `Product` ON (`CustomPrice`.`product_id` = `Product`.`id`) LEFT JOIN `millebelledb`.`price_types` AS `PriceType` ON (`CustomPrice`.`price_type_id` = `PriceType`.`id`) WHERE `product_id` = 105 AND `price_type_id` = 1 LIMIT 1 | 1 | 1 | 1 | |
| 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` IS NULL) OR (`ProductDiscount`.`product_id` = 105))) AND (((`ProductDiscount`.`customer_group_id` IS NULL) OR (`ProductDiscount`.`customer_group_id` = 1))) AND (((`ProductDiscount`.`manufacturer_id` IS NULL) OR (`ProductDiscount`.`manufacturer_id` = 1)))) | 0 | 0 | 1 | maybe slow |
| SELECT `CustomPrice`.`id`, `CustomPrice`.`product_id`, `CustomPrice`.`price_type_id`, `CustomPrice`.`net_value`, `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`, `PriceType`.`id`, `PriceType`.`name`, `PriceType`.`is_default`, `PriceType`.`calculation_method_type_id`, `PriceType`.`calculation_method_type_string` FROM `millebelledb`.`custom_prices` AS `CustomPrice` LEFT JOIN `millebelledb`.`products` AS `Product` ON (`CustomPrice`.`product_id` = `Product`.`id`) LEFT JOIN `millebelledb`.`price_types` AS `PriceType` ON (`CustomPrice`.`price_type_id` = `PriceType`.`id`) WHERE `product_id` = 105 AND `price_type_id` = 1 LIMIT 1 | 1 | 1 | 1 | |
| 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` IS NULL) OR (`ProductDiscount`.`product_id` = 105))) AND (((`ProductDiscount`.`customer_group_id` IS NULL) OR (`ProductDiscount`.`customer_group_id` = 1))) AND (((`ProductDiscount`.`manufacturer_id` IS NULL) OR (`ProductDiscount`.`manufacturer_id` = 1)))) | 0 | 0 | 1 | maybe slow |
| SELECT `CustomPrice`.`id`, `CustomPrice`.`product_id`, `CustomPrice`.`price_type_id`, `CustomPrice`.`net_value`, `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`, `PriceType`.`id`, `PriceType`.`name`, `PriceType`.`is_default`, `PriceType`.`calculation_method_type_id`, `PriceType`.`calculation_method_type_string` FROM `millebelledb`.`custom_prices` AS `CustomPrice` LEFT JOIN `millebelledb`.`products` AS `Product` ON (`CustomPrice`.`product_id` = `Product`.`id`) LEFT JOIN `millebelledb`.`price_types` AS `PriceType` ON (`CustomPrice`.`price_type_id` = `PriceType`.`id`) WHERE `product_id` = 106 AND `price_type_id` = 1 LIMIT 1 | 1 | 1 | 1 | |
| 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` IS NULL) OR (`ProductDiscount`.`product_id` = 106))) AND (((`ProductDiscount`.`customer_group_id` IS NULL) OR (`ProductDiscount`.`customer_group_id` = 1))) AND (((`ProductDiscount`.`manufacturer_id` IS NULL) OR (`ProductDiscount`.`manufacturer_id` = 1)))) | 0 | 0 | 1 | maybe slow |
| SELECT `CustomPrice`.`id`, `CustomPrice`.`product_id`, `CustomPrice`.`price_type_id`, `CustomPrice`.`net_value`, `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`, `PriceType`.`id`, `PriceType`.`name`, `PriceType`.`is_default`, `PriceType`.`calculation_method_type_id`, `PriceType`.`calculation_method_type_string` FROM `millebelledb`.`custom_prices` AS `CustomPrice` LEFT JOIN `millebelledb`.`products` AS `Product` ON (`CustomPrice`.`product_id` = `Product`.`id`) LEFT JOIN `millebelledb`.`price_types` AS `PriceType` ON (`CustomPrice`.`price_type_id` = `PriceType`.`id`) WHERE `product_id` = 106 AND `price_type_id` = 1 LIMIT 1 | 1 | 1 | 1 | |
| 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` IS NULL) OR (`ProductDiscount`.`product_id` = 106))) AND (((`ProductDiscount`.`customer_group_id` IS NULL) OR (`ProductDiscount`.`customer_group_id` = 1))) AND (((`ProductDiscount`.`manufacturer_id` IS NULL) OR (`ProductDiscount`.`manufacturer_id` = 1)))) | 0 | 0 | 1 | maybe slow |
| SELECT `CustomPrice`.`id`, `CustomPrice`.`product_id`, `CustomPrice`.`price_type_id`, `CustomPrice`.`net_value`, `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`, `PriceType`.`id`, `PriceType`.`name`, `PriceType`.`is_default`, `PriceType`.`calculation_method_type_id`, `PriceType`.`calculation_method_type_string` FROM `millebelledb`.`custom_prices` AS `CustomPrice` LEFT JOIN `millebelledb`.`products` AS `Product` ON (`CustomPrice`.`product_id` = `Product`.`id`) LEFT JOIN `millebelledb`.`price_types` AS `PriceType` ON (`CustomPrice`.`price_type_id` = `PriceType`.`id`) WHERE `product_id` = 106 AND `price_type_id` = 1 LIMIT 1 | 1 | 1 | 1 | |
| 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` IS NULL) OR (`ProductDiscount`.`product_id` = 106))) AND (((`ProductDiscount`.`customer_group_id` IS NULL) OR (`ProductDiscount`.`customer_group_id` = 1))) AND (((`ProductDiscount`.`manufacturer_id` IS NULL) OR (`ProductDiscount`.`manufacturer_id` = 1)))) | 0 | 0 | 1 | maybe slow |
| SELECT `CustomPrice`.`id`, `CustomPrice`.`product_id`, `CustomPrice`.`price_type_id`, `CustomPrice`.`net_value`, `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`, `PriceType`.`id`, `PriceType`.`name`, `PriceType`.`is_default`, `PriceType`.`calculation_method_type_id`, `PriceType`.`calculation_method_type_string` FROM `millebelledb`.`custom_prices` AS `CustomPrice` LEFT JOIN `millebelledb`.`products` AS `Product` ON (`CustomPrice`.`product_id` = `Product`.`id`) LEFT JOIN `millebelledb`.`price_types` AS `PriceType` ON (`CustomPrice`.`price_type_id` = `PriceType`.`id`) WHERE `product_id` = 108 AND `price_type_id` = 1 LIMIT 1 | 1 | 1 | 1 | |
| 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` IS NULL) OR (`ProductDiscount`.`product_id` = 108))) AND (((`ProductDiscount`.`customer_group_id` IS NULL) OR (`ProductDiscount`.`customer_group_id` = 1))) AND (((`ProductDiscount`.`manufacturer_id` IS NULL) OR (`ProductDiscount`.`manufacturer_id` = 1)))) | 0 | 0 | 1 | maybe slow |
| SELECT `CustomPrice`.`id`, `CustomPrice`.`product_id`, `CustomPrice`.`price_type_id`, `CustomPrice`.`net_value`, `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`, `PriceType`.`id`, `PriceType`.`name`, `PriceType`.`is_default`, `PriceType`.`calculation_method_type_id`, `PriceType`.`calculation_method_type_string` FROM `millebelledb`.`custom_prices` AS `CustomPrice` LEFT JOIN `millebelledb`.`products` AS `Product` ON (`CustomPrice`.`product_id` = `Product`.`id`) LEFT JOIN `millebelledb`.`price_types` AS `PriceType` ON (`CustomPrice`.`price_type_id` = `PriceType`.`id`) WHERE `product_id` = 108 AND `price_type_id` = 1 LIMIT 1 | 1 | 1 | 1 | |
| 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` IS NULL) OR (`ProductDiscount`.`product_id` = 108))) AND (((`ProductDiscount`.`customer_group_id` IS NULL) OR (`ProductDiscount`.`customer_group_id` = 1))) AND (((`ProductDiscount`.`manufacturer_id` IS NULL) OR (`ProductDiscount`.`manufacturer_id` = 1)))) | 0 | 0 | 1 | maybe slow |
| SELECT `CustomPrice`.`id`, `CustomPrice`.`product_id`, `CustomPrice`.`price_type_id`, `CustomPrice`.`net_value`, `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`, `PriceType`.`id`, `PriceType`.`name`, `PriceType`.`is_default`, `PriceType`.`calculation_method_type_id`, `PriceType`.`calculation_method_type_string` FROM `millebelledb`.`custom_prices` AS `CustomPrice` LEFT JOIN `millebelledb`.`products` AS `Product` ON (`CustomPrice`.`product_id` = `Product`.`id`) LEFT JOIN `millebelledb`.`price_types` AS `PriceType` ON (`CustomPrice`.`price_type_id` = `PriceType`.`id`) WHERE `product_id` = 108 AND `price_type_id` = 1 LIMIT 1 | 1 | 1 | 1 | |
| 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` IS NULL) OR (`ProductDiscount`.`product_id` = 108))) AND (((`ProductDiscount`.`customer_group_id` IS NULL) OR (`ProductDiscount`.`customer_group_id` = 1))) AND (((`ProductDiscount`.`manufacturer_id` IS NULL) OR (`ProductDiscount`.`manufacturer_id` = 1)))) | 0 | 0 | 1 | maybe slow |
| SELECT `CustomPrice`.`id`, `CustomPrice`.`product_id`, `CustomPrice`.`price_type_id`, `CustomPrice`.`net_value`, `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`, `PriceType`.`id`, `PriceType`.`name`, `PriceType`.`is_default`, `PriceType`.`calculation_method_type_id`, `PriceType`.`calculation_method_type_string` FROM `millebelledb`.`custom_prices` AS `CustomPrice` LEFT JOIN `millebelledb`.`products` AS `Product` ON (`CustomPrice`.`product_id` = `Product`.`id`) LEFT JOIN `millebelledb`.`price_types` AS `PriceType` ON (`CustomPrice`.`price_type_id` = `PriceType`.`id`) WHERE `product_id` = 22 AND `price_type_id` = 1 LIMIT 1 | 1 | 1 | 1 | |
| 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` IS NULL) OR (`ProductDiscount`.`product_id` = 22))) AND (((`ProductDiscount`.`customer_group_id` IS NULL) OR (`ProductDiscount`.`customer_group_id` = 1))) AND (((`ProductDiscount`.`manufacturer_id` IS NULL) OR (`ProductDiscount`.`manufacturer_id` = 2)))) | 0 | 0 | 1 | maybe slow |
| SELECT `CustomPrice`.`id`, `CustomPrice`.`product_id`, `CustomPrice`.`price_type_id`, `CustomPrice`.`net_value`, `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`, `PriceType`.`id`, `PriceType`.`name`, `PriceType`.`is_default`, `PriceType`.`calculation_method_type_id`, `PriceType`.`calculation_method_type_string` FROM `millebelledb`.`custom_prices` AS `CustomPrice` LEFT JOIN `millebelledb`.`products` AS `Product` ON (`CustomPrice`.`product_id` = `Product`.`id`) LEFT JOIN `millebelledb`.`price_types` AS `PriceType` ON (`CustomPrice`.`price_type_id` = `PriceType`.`id`) WHERE `product_id` = 22 AND `price_type_id` = 1 LIMIT 1 | 1 | 1 | 1 | |
| 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` IS NULL) OR (`ProductDiscount`.`product_id` = 22))) AND (((`ProductDiscount`.`customer_group_id` IS NULL) OR (`ProductDiscount`.`customer_group_id` = 1))) AND (((`ProductDiscount`.`manufacturer_id` IS NULL) OR (`ProductDiscount`.`manufacturer_id` = 2)))) | 0 | 0 | 1 | maybe slow |
| SELECT `CustomPrice`.`id`, `CustomPrice`.`product_id`, `CustomPrice`.`price_type_id`, `CustomPrice`.`net_value`, `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`, `PriceType`.`id`, `PriceType`.`name`, `PriceType`.`is_default`, `PriceType`.`calculation_method_type_id`, `PriceType`.`calculation_method_type_string` FROM `millebelledb`.`custom_prices` AS `CustomPrice` LEFT JOIN `millebelledb`.`products` AS `Product` ON (`CustomPrice`.`product_id` = `Product`.`id`) LEFT JOIN `millebelledb`.`price_types` AS `PriceType` ON (`CustomPrice`.`price_type_id` = `PriceType`.`id`) WHERE `product_id` = 22 AND `price_type_id` = 1 LIMIT 1 | 1 | 1 | 1 | |
| 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` IS NULL) OR (`ProductDiscount`.`product_id` = 22))) AND (((`ProductDiscount`.`customer_group_id` IS NULL) OR (`ProductDiscount`.`customer_group_id` = 1))) AND (((`ProductDiscount`.`manufacturer_id` IS NULL) OR (`ProductDiscount`.`manufacturer_id` = 2)))) | 0 | 0 | 1 | maybe slow |
| SELECT `CustomPrice`.`id`, `CustomPrice`.`product_id`, `CustomPrice`.`price_type_id`, `CustomPrice`.`net_value`, `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`, `PriceType`.`id`, `PriceType`.`name`, `PriceType`.`is_default`, `PriceType`.`calculation_method_type_id`, `PriceType`.`calculation_method_type_string` FROM `millebelledb`.`custom_prices` AS `CustomPrice` LEFT JOIN `millebelledb`.`products` AS `Product` ON (`CustomPrice`.`product_id` = `Product`.`id`) LEFT JOIN `millebelledb`.`price_types` AS `PriceType` ON (`CustomPrice`.`price_type_id` = `PriceType`.`id`) WHERE `product_id` = 31 AND `price_type_id` = 1 LIMIT 1 | 1 | 1 | 1 | |
| 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` IS NULL) OR (`ProductDiscount`.`product_id` = 31))) AND (((`ProductDiscount`.`customer_group_id` IS NULL) OR (`ProductDiscount`.`customer_group_id` = 1))) AND (((`ProductDiscount`.`manufacturer_id` IS NULL) OR (`ProductDiscount`.`manufacturer_id` = 2)))) | 0 | 0 | 1 | maybe slow |
| SELECT `CustomPrice`.`id`, `CustomPrice`.`product_id`, `CustomPrice`.`price_type_id`, `CustomPrice`.`net_value`, `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`, `PriceType`.`id`, `PriceType`.`name`, `PriceType`.`is_default`, `PriceType`.`calculation_method_type_id`, `PriceType`.`calculation_method_type_string` FROM `millebelledb`.`custom_prices` AS `CustomPrice` LEFT JOIN `millebelledb`.`products` AS `Product` ON (`CustomPrice`.`product_id` = `Product`.`id`) LEFT JOIN `millebelledb`.`price_types` AS `PriceType` ON (`CustomPrice`.`price_type_id` = `PriceType`.`id`) WHERE `product_id` = 31 AND `price_type_id` = 1 LIMIT 1 | 1 | 1 | 1 | |
| 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` IS NULL) OR (`ProductDiscount`.`product_id` = 31))) AND (((`ProductDiscount`.`customer_group_id` IS NULL) OR (`ProductDiscount`.`customer_group_id` = 1))) AND (((`ProductDiscount`.`manufacturer_id` IS NULL) OR (`ProductDiscount`.`manufacturer_id` = 2)))) | 0 | 0 | 1 | maybe slow |
| SELECT `CustomPrice`.`id`, `CustomPrice`.`product_id`, `CustomPrice`.`price_type_id`, `CustomPrice`.`net_value`, `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`, `PriceType`.`id`, `PriceType`.`name`, `PriceType`.`is_default`, `PriceType`.`calculation_method_type_id`, `PriceType`.`calculation_method_type_string` FROM `millebelledb`.`custom_prices` AS `CustomPrice` LEFT JOIN `millebelledb`.`products` AS `Product` ON (`CustomPrice`.`product_id` = `Product`.`id`) LEFT JOIN `millebelledb`.`price_types` AS `PriceType` ON (`CustomPrice`.`price_type_id` = `PriceType`.`id`) WHERE `product_id` = 31 AND `price_type_id` = 1 LIMIT 1 | 1 | 1 | 1 | |
| 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` IS NULL) OR (`ProductDiscount`.`product_id` = 31))) AND (((`ProductDiscount`.`customer_group_id` IS NULL) OR (`ProductDiscount`.`customer_group_id` = 1))) AND (((`ProductDiscount`.`manufacturer_id` IS NULL) OR (`ProductDiscount`.`manufacturer_id` = 2)))) | 0 | 0 | 1 | maybe slow |
| SELECT `CustomPrice`.`id`, `CustomPrice`.`product_id`, `CustomPrice`.`price_type_id`, `CustomPrice`.`net_value`, `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`, `PriceType`.`id`, `PriceType`.`name`, `PriceType`.`is_default`, `PriceType`.`calculation_method_type_id`, `PriceType`.`calculation_method_type_string` FROM `millebelledb`.`custom_prices` AS `CustomPrice` LEFT JOIN `millebelledb`.`products` AS `Product` ON (`CustomPrice`.`product_id` = `Product`.`id`) LEFT JOIN `millebelledb`.`price_types` AS `PriceType` ON (`CustomPrice`.`price_type_id` = `PriceType`.`id`) WHERE `product_id` = 29 AND `price_type_id` = 1 LIMIT 1 | 1 | 1 | 1 | |
| 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` IS NULL) OR (`ProductDiscount`.`product_id` = 29))) AND (((`ProductDiscount`.`customer_group_id` IS NULL) OR (`ProductDiscount`.`customer_group_id` = 1))) AND (((`ProductDiscount`.`manufacturer_id` IS NULL) OR (`ProductDiscount`.`manufacturer_id` = 3)))) | 0 | 0 | 1 | maybe slow |
| SELECT `CustomPrice`.`id`, `CustomPrice`.`product_id`, `CustomPrice`.`price_type_id`, `CustomPrice`.`net_value`, `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`, `PriceType`.`id`, `PriceType`.`name`, `PriceType`.`is_default`, `PriceType`.`calculation_method_type_id`, `PriceType`.`calculation_method_type_string` FROM `millebelledb`.`custom_prices` AS `CustomPrice` LEFT JOIN `millebelledb`.`products` AS `Product` ON (`CustomPrice`.`product_id` = `Product`.`id`) LEFT JOIN `millebelledb`.`price_types` AS `PriceType` ON (`CustomPrice`.`price_type_id` = `PriceType`.`id`) WHERE `product_id` = 29 AND `price_type_id` = 1 LIMIT 1 | 1 | 1 | 1 | |
| 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` IS NULL) OR (`ProductDiscount`.`product_id` = 29))) AND (((`ProductDiscount`.`customer_group_id` IS NULL) OR (`ProductDiscount`.`customer_group_id` = 1))) AND (((`ProductDiscount`.`manufacturer_id` IS NULL) OR (`ProductDiscount`.`manufacturer_id` = 3)))) | 0 | 0 | 1 | maybe slow |
| SELECT `CustomPrice`.`id`, `CustomPrice`.`product_id`, `CustomPrice`.`price_type_id`, `CustomPrice`.`net_value`, `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`, `PriceType`.`id`, `PriceType`.`name`, `PriceType`.`is_default`, `PriceType`.`calculation_method_type_id`, `PriceType`.`calculation_method_type_string` FROM `millebelledb`.`custom_prices` AS `CustomPrice` LEFT JOIN `millebelledb`.`products` AS `Product` ON (`CustomPrice`.`product_id` = `Product`.`id`) LEFT JOIN `millebelledb`.`price_types` AS `PriceType` ON (`CustomPrice`.`price_type_id` = `PriceType`.`id`) WHERE `product_id` = 29 AND `price_type_id` = 1 LIMIT 1 | 1 | 1 | 1 | |
| 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` IS NULL) OR (`ProductDiscount`.`product_id` = 29))) AND (((`ProductDiscount`.`customer_group_id` IS NULL) OR (`ProductDiscount`.`customer_group_id` = 1))) AND (((`ProductDiscount`.`manufacturer_id` IS NULL) OR (`ProductDiscount`.`manufacturer_id` = 3)))) | 0 | 0 | 1 | maybe slow |
27 duplicate queries run.
