| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `Store`.`id`, `Store`.`name`, `Store`.`branding`, `Store`.`defaultlocale`, `Store`.`theme_admin`, `Store`.`theme`, `Store`.`phone`, `Store`.`url`, `Store`.`email`, `Store`.`active`, `Store`.`index`, `Store`.`maintenance_mode`, `Store`.`base`, `Store`.`use_menu_builder`, `Store`.`age_confirm`, `Store`.`hours_popup`, `Store`.`is_wholesale`, `Store`.`disable_checkout`, `Store`.`enable_stores`, (`I18n__homepagetitle__nld`.`content`) AS `Store__i18n_homepagetitle_nld`, (`I18n__homepagedescription__nld`.`content`) AS `Store__i18n_homepagedescription_nld`, (`I18n__homepage_footer__nld`.`content`) AS `Store__i18n_homepage_footer_nld`, (`I18n__homepage_content__nld`.`content`) AS `Store__i18n_homepage_content_nld`, (`I18n__header_points__nld`.`content`) AS `Store__i18n_header_points_nld`, (`I18n__footer_blocks__nld`.`content`) AS `Store__i18n_footer_blocks_nld`, (`I18n__sidebar_content__nld`.`content`) AS `Store__i18n_sidebar_content_nld`, (`I18n__disable_checkout_msg__nld`.`content`) AS `Store__i18n_disable_checkout_msg_nld` FROM `tbiback_tbshops`.`stores` AS `Store` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__homepagetitle__nld` ON (`Store`.`id` = `I18n__homepagetitle__nld`.`foreign_key` AND `I18n__homepagetitle__nld`.`model` = 'Store' AND `I18n__homepagetitle__nld`.`field` = 'homepagetitle' AND `I18n__homepagetitle__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__homepagedescription__nld` ON (`Store`.`id` = `I18n__homepagedescription__nld`.`foreign_key` AND `I18n__homepagedescription__nld`.`model` = 'Store' AND `I18n__homepagedescription__nld`.`field` = 'homepagedescription' AND `I18n__homepagedescription__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__homepage_footer__nld` ON (`Store`.`id` = `I18n__homepage_footer__nld`.`foreign_key` AND `I18n__homepage_footer__nld`.`model` = 'Store' AND `I18n__homepage_footer__nld`.`field` = 'homepage_footer' AND `I18n__homepage_footer__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__homepage_content__nld` ON (`Store`.`id` = `I18n__homepage_content__nld`.`foreign_key` AND `I18n__homepage_content__nld`.`model` = 'Store' AND `I18n__homepage_content__nld`.`field` = 'homepage_content' AND `I18n__homepage_content__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__header_points__nld` ON (`Store`.`id` = `I18n__header_points__nld`.`foreign_key` AND `I18n__header_points__nld`.`model` = 'Store' AND `I18n__header_points__nld`.`field` = 'header_points' AND `I18n__header_points__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__footer_blocks__nld` ON (`Store`.`id` = `I18n__footer_blocks__nld`.`foreign_key` AND `I18n__footer_blocks__nld`.`model` = 'Store' AND `I18n__footer_blocks__nld`.`field` = 'footer_blocks' AND `I18n__footer_blocks__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__sidebar_content__nld` ON (`Store`.`id` = `I18n__sidebar_content__nld`.`foreign_key` AND `I18n__sidebar_content__nld`.`model` = 'Store' AND `I18n__sidebar_content__nld`.`field` = 'sidebar_content' AND `I18n__sidebar_content__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__disable_checkout_msg__nld` ON (`Store`.`id` = `I18n__disable_checkout_msg__nld`.`foreign_key` AND `I18n__disable_checkout_msg__nld`.`model` = 'Store' AND `I18n__disable_checkout_msg__nld`.`field` = 'disable_checkout_msg' AND `I18n__disable_checkout_msg__nld`.`locale` = 'nld') WHERE `url` = 'pietjesbak.be' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `StoreSetting`.`id`, `StoreSetting`.`key`, `StoreSetting`.`value`, `StoreSetting`.`type`, `StoreSetting`.`store_id` FROM `tbiback_tbshops`.`store_settings` AS `StoreSetting` WHERE `StoreSetting`.`store_id` = (9) | 16 | 16 | 0 | |
| SELECT `HourException`.`id`, `HourException`.`date`, `HourException`.`start`, `HourException`.`end`, `HourException`.`closed`, `HourException`.`store_location_id` FROM `tbiback_tbshops`.`hour_exceptions` AS `HourException` WHERE `date` = '2023-01-30' LIMIT 1 | 0 | 0 | 0 | |
| SELECT `Hour`.`id`, `Hour`.`weekday`, `Hour`.`start`, `Hour`.`end`, `Hour`.`closed` FROM `tbiback_tbshops`.`hours` AS `Hour` WHERE `weekday` = 1 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `HourException`.`id`, `HourException`.`date`, `HourException`.`start`, `HourException`.`end`, `HourException`.`closed`, `HourException`.`store_location_id` FROM `tbiback_tbshops`.`hour_exceptions` AS `HourException` WHERE `date` = '2023-01-30' LIMIT 1 | 0 | 0 | 0 | |
| SELECT `Hour`.`id`, `Hour`.`weekday`, `Hour`.`start`, `Hour`.`end`, `Hour`.`closed` FROM `tbiback_tbshops`.`hours` AS `Hour` WHERE `weekday` = 1 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `HourException`.`id`, `HourException`.`date`, `HourException`.`start`, `HourException`.`end`, `HourException`.`closed`, `HourException`.`store_location_id` FROM `tbiback_tbshops`.`hour_exceptions` AS `HourException` WHERE `date` = '2023-01-30' LIMIT 1 | 0 | 0 | 0 | |
| SELECT `Hour`.`id`, `Hour`.`weekday`, `Hour`.`start`, `Hour`.`end`, `Hour`.`closed` FROM `tbiback_tbshops`.`hours` AS `Hour` WHERE `weekday` = 1 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `HourException`.`id`, `HourException`.`date`, `HourException`.`start`, `HourException`.`end`, `HourException`.`closed`, `HourException`.`store_location_id` FROM `tbiback_tbshops`.`hour_exceptions` AS `HourException` WHERE `date` = '2023-01-31' LIMIT 1 | 0 | 0 | 0 | |
| SELECT `Hour`.`id`, `Hour`.`weekday`, `Hour`.`start`, `Hour`.`end`, `Hour`.`closed` FROM `tbiback_tbshops`.`hours` AS `Hour` WHERE `weekday` = 2 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `HourException`.`id`, `HourException`.`date`, `HourException`.`start`, `HourException`.`end`, `HourException`.`closed`, `HourException`.`store_location_id` FROM `tbiback_tbshops`.`hour_exceptions` AS `HourException` WHERE `date` = '2023-01-31' LIMIT 1 | 0 | 0 | 0 | |
| SELECT `Hour`.`id`, `Hour`.`weekday`, `Hour`.`start`, `Hour`.`end`, `Hour`.`closed` FROM `tbiback_tbshops`.`hours` AS `Hour` WHERE `weekday` = 2 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Store`.`id`, `Store`.`name`, `Store`.`branding`, `Store`.`defaultlocale`, `Store`.`theme_admin`, `Store`.`theme`, `Store`.`phone`, `Store`.`url`, `Store`.`email`, `Store`.`active`, `Store`.`index`, `Store`.`maintenance_mode`, `Store`.`base`, `Store`.`use_menu_builder`, `Store`.`age_confirm`, `Store`.`hours_popup`, `Store`.`is_wholesale`, `Store`.`disable_checkout`, `Store`.`enable_stores`, (`I18n__homepagetitle__nld`.`content`) AS `Store__i18n_homepagetitle_nld`, (`I18n__homepagedescription__nld`.`content`) AS `Store__i18n_homepagedescription_nld`, (`I18n__homepage_footer__nld`.`content`) AS `Store__i18n_homepage_footer_nld`, (`I18n__homepage_content__nld`.`content`) AS `Store__i18n_homepage_content_nld`, (`I18n__header_points__nld`.`content`) AS `Store__i18n_header_points_nld`, (`I18n__footer_blocks__nld`.`content`) AS `Store__i18n_footer_blocks_nld`, (`I18n__sidebar_content__nld`.`content`) AS `Store__i18n_sidebar_content_nld`, (`I18n__disable_checkout_msg__nld`.`content`) AS `Store__i18n_disable_checkout_msg_nld` FROM `tbiback_tbshops`.`stores` AS `Store` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__homepagetitle__nld` ON (`Store`.`id` = `I18n__homepagetitle__nld`.`foreign_key` AND `I18n__homepagetitle__nld`.`model` = 'Store' AND `I18n__homepagetitle__nld`.`field` = 'homepagetitle' AND `I18n__homepagetitle__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__homepagedescription__nld` ON (`Store`.`id` = `I18n__homepagedescription__nld`.`foreign_key` AND `I18n__homepagedescription__nld`.`model` = 'Store' AND `I18n__homepagedescription__nld`.`field` = 'homepagedescription' AND `I18n__homepagedescription__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__homepage_footer__nld` ON (`Store`.`id` = `I18n__homepage_footer__nld`.`foreign_key` AND `I18n__homepage_footer__nld`.`model` = 'Store' AND `I18n__homepage_footer__nld`.`field` = 'homepage_footer' AND `I18n__homepage_footer__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__homepage_content__nld` ON (`Store`.`id` = `I18n__homepage_content__nld`.`foreign_key` AND `I18n__homepage_content__nld`.`model` = 'Store' AND `I18n__homepage_content__nld`.`field` = 'homepage_content' AND `I18n__homepage_content__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__header_points__nld` ON (`Store`.`id` = `I18n__header_points__nld`.`foreign_key` AND `I18n__header_points__nld`.`model` = 'Store' AND `I18n__header_points__nld`.`field` = 'header_points' AND `I18n__header_points__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__footer_blocks__nld` ON (`Store`.`id` = `I18n__footer_blocks__nld`.`foreign_key` AND `I18n__footer_blocks__nld`.`model` = 'Store' AND `I18n__footer_blocks__nld`.`field` = 'footer_blocks' AND `I18n__footer_blocks__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__sidebar_content__nld` ON (`Store`.`id` = `I18n__sidebar_content__nld`.`foreign_key` AND `I18n__sidebar_content__nld`.`model` = 'Store' AND `I18n__sidebar_content__nld`.`field` = 'sidebar_content' AND `I18n__sidebar_content__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__disable_checkout_msg__nld` ON (`Store`.`id` = `I18n__disable_checkout_msg__nld`.`foreign_key` AND `I18n__disable_checkout_msg__nld`.`model` = 'Store' AND `I18n__disable_checkout_msg__nld`.`field` = 'disable_checkout_msg' AND `I18n__disable_checkout_msg__nld`.`locale` = 'nld') WHERE `url` = 'pietjesbak.be' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `StoreSetting`.`id`, `StoreSetting`.`key`, `StoreSetting`.`value`, `StoreSetting`.`type`, `StoreSetting`.`store_id` FROM `tbiback_tbshops`.`store_settings` AS `StoreSetting` WHERE `StoreSetting`.`store_id` = (9) | 16 | 16 | 0 | |
| SELECT `ShippingmethodsStore`.`id`, `ShippingmethodsStore`.`shippingmethod_id`, `ShippingmethodsStore`.`store_id`, `Shippingmethod`.`id`, `Shippingmethod`.`code`, `Shippingmethod`.`sorting`, `Shippingmethod`.`countries`, `Shippingmethod`.`store_id`, `Store`.`id`, `Store`.`name`, `Store`.`branding`, `Store`.`defaultlocale`, `Store`.`theme_admin`, `Store`.`theme`, `Store`.`phone`, `Store`.`url`, `Store`.`email`, `Store`.`active`, `Store`.`index`, `Store`.`maintenance_mode`, `Store`.`base`, `Store`.`use_menu_builder`, `Store`.`age_confirm`, `Store`.`hours_popup`, `Store`.`is_wholesale`, `Store`.`disable_checkout`, `Store`.`enable_stores` FROM `tbiback_tbshops`.`shippingmethods_stores` AS `ShippingmethodsStore` LEFT JOIN `tbiback_tbshops`.`shippingmethods` AS `Shippingmethod` ON (`ShippingmethodsStore`.`shippingmethod_id` = `Shippingmethod`.`id`) LEFT JOIN `tbiback_tbshops`.`stores` AS `Store` ON (`ShippingmethodsStore`.`store_id` = `Store`.`id`) WHERE `Store`.`id` = 9 AND `Shippingmethod`.`code` = 'shipment' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ShippingRate`.`id`, `ShippingRate`.`shippingmethod_id`, `ShippingRate`.`country`, `ShippingRate`.`floor`, `ShippingRate`.`ceiling`, `ShippingRate`.`criteria`, `ShippingRate`.`price` FROM `tbiback_tbshops`.`shipping_rates` AS `ShippingRate` WHERE `ShippingRate`.`shippingmethod_id` = (4) | 41 | 41 | 0 | |
| SELECT `Message`.`id`, `Message`.`type`, `Message`.`start`, `Message`.`end`, `Message`.`store_id`, `Message`.`from_override`, (`I18n__message__nld`.`content`) AS `Message__i18n_message_nld` FROM `tbiback_tbshops`.`messages` AS `Message` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__message__nld` ON (`Message`.`id` = `I18n__message__nld`.`foreign_key` AND `I18n__message__nld`.`model` = 'Message' AND `I18n__message__nld`.`field` = 'message' AND `I18n__message__nld`.`locale` = 'nld') WHERE `type` = 'popover' AND `start` <= '2023-01-30' AND `end` >= '2023-01-30' AND `store_id` IN (0, 9) LIMIT 1 | 0 | 0 | 0 | |
| SELECT `UrlRedirect`.`id`, `UrlRedirect`.`old_url`, `UrlRedirect`.`new_url`, `UrlRedirect`.`redirect_type`, `UrlRedirect`.`store_id` FROM `tbiback_tbshops`.`url_redirects` AS `UrlRedirect` WHERE `old_url` = 'http://pietjesbak.be/nld/category/37/pietjesbakken' AND `store_id` = 9 LIMIT 1 | 0 | 0 | 1 | maybe slow |
| SELECT `Cart`.`id`, `Cart`.`display`, `Cart`.`group_id`, `Cart`.`group_model`, `Cart`.`session_id`, `Cart`.`qty`, `Cart`.`price`, `Cart`.`price_excl_vat`, `Cart`.`price_vat`, `Cart`.`price_incl_vat`, `Cart`.`vat`, `Cart`.`created`, `Cart`.`loaded`, `Cart`.`store_id`, `Cart`.`default`, `Cart`.`defaultqty`, `Cart`.`order_type`, `Productgroup`.`id`, `Productgroup`.`brand_id`, `Productgroup`.`price`, `Productgroup`.`promoprice`, `Productgroup`.`wholesaleprice`, `Productgroup`.`minimumsaleprice`, `Productgroup`.`show_retail_price`, `Productgroup`.`hidden`, `Productgroup`.`available`, `Productgroup`.`endoflife`, `Productgroup`.`exclusive`, `Productgroup`.`created`, `Productgroup`.`exportable`, `Productgroup`.`exported`, `Productgroup`.`bbat_flexible`, `Productgroup`.`bbat_fixed`, `Bundle`.`id`, `Bundle`.`SKU`, `Bundle`.`brand_id`, `Bundle`.`price`, `Bundle`.`promoprice`, `Bundle`.`purchaseprice`, `Bundle`.`wholesaleprice`, `Bundle`.`qtychange_price`, `Bundle`.`hidden`, `Bundle`.`available`, `Bundle`.`created` FROM `tbiback_tbshops`.`carts` AS `Cart` LEFT JOIN `tbiback_tbshops`.`productgroups` AS `Productgroup` ON (`Cart`.`group_id` = `Productgroup`.`id` AND `Cart`.`group_model` = 'Productgroup') LEFT JOIN `tbiback_tbshops`.`bundles` AS `Bundle` ON (`Cart`.`group_id` = `Bundle`.`id` AND `Cart`.`group_model` = 'Bundle') WHERE `session_id` = '1dd94phncgt21sfgtrfu5etro3' AND `qty` > 0 | 0 | 0 | 1 | maybe slow |
| SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`sorting`, `Category`.`topmenu`, `Category`.`store_id`, (`I18n__name__nld`.`content`) AS `Category__i18n_name_nld`, (`I18n__slug__nld`.`content`) AS `Category__i18n_slug_nld`, (`I18n__description__nld`.`content`) AS `Category__i18n_description_nld`, (`I18n__description_short__nld`.`content`) AS `Category__i18n_description_short_nld`, (`I18n__path__nld`.`content`) AS `Category__i18n_path_nld`, (`I18n__pagetitle__nld`.`content`) AS `Category__i18n_pagetitle_nld`, `ParentCategory`.`id`, `ParentCategory`.`parent_id` FROM `tbiback_tbshops`.`categories` AS `Category` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__nld` ON (`Category`.`id` = `I18n__name__nld`.`foreign_key` AND `I18n__name__nld`.`model` = 'Category' AND `I18n__name__nld`.`field` = 'name' AND `I18n__name__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__slug__nld` ON (`Category`.`id` = `I18n__slug__nld`.`foreign_key` AND `I18n__slug__nld`.`model` = 'Category' AND `I18n__slug__nld`.`field` = 'slug' AND `I18n__slug__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__description__nld` ON (`Category`.`id` = `I18n__description__nld`.`foreign_key` AND `I18n__description__nld`.`model` = 'Category' AND `I18n__description__nld`.`field` = 'description' AND `I18n__description__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__description_short__nld` ON (`Category`.`id` = `I18n__description_short__nld`.`foreign_key` AND `I18n__description_short__nld`.`model` = 'Category' AND `I18n__description_short__nld`.`field` = 'description_short' AND `I18n__description_short__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__path__nld` ON (`Category`.`id` = `I18n__path__nld`.`foreign_key` AND `I18n__path__nld`.`model` = 'Category' AND `I18n__path__nld`.`field` = 'path' AND `I18n__path__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__pagetitle__nld` ON (`Category`.`id` = `I18n__pagetitle__nld`.`foreign_key` AND `I18n__pagetitle__nld`.`model` = 'Category' AND `I18n__pagetitle__nld`.`field` = 'pagetitle' AND `I18n__pagetitle__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`categories` AS `ParentCategory` ON (`Category`.`parent_id` = `ParentCategory`.`id`) WHERE `Category`.`id` = 37 AND `Category`.`store_id` = 9 LIMIT 1 | 1 | 1 | 6 | maybe slow |
| SELECT `ChildCategory`.`id`, `ChildCategory`.`parent_id` FROM `tbiback_tbshops`.`categories` AS `ChildCategory` WHERE `ChildCategory`.`parent_id` = (37) | 0 | 0 | 0 | |
| SELECT `Category`.`parent_id` FROM `tbiback_tbshops`.`categories` AS `Category` WHERE `Category`.`id` = 37 AND `Category`.`store_id` = 9 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Category`.`id`, (`I18n__slug__nld`.`content`) AS `Category__i18n_slug_nld` FROM `tbiback_tbshops`.`categories` AS `Category` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__slug__nld` ON (`Category`.`id` = `I18n__slug__nld`.`foreign_key` AND `I18n__slug__nld`.`model` = 'Category' AND `I18n__slug__nld`.`field` = 'slug' AND `I18n__slug__nld`.`locale` = 'nld') WHERE `Category`.`id` = 37 AND `Category`.`store_id` = 9 LIMIT 1 | 1 | 1 | 1 | |
| SELECT `CategoryFilter`.`id`, `CategoryFilter`.`category_id`, `CategoryFilter`.`storeattribute_id`, `CategoryFilter`.`active`, `Storeattribute`.`id`, `Storeattribute`.`type`, `Storeattribute`.`created` FROM `tbiback_tbshops`.`category_filters` AS `CategoryFilter` LEFT JOIN `tbiback_tbshops`.`storeattributes` AS `Storeattribute` ON (`CategoryFilter`.`storeattribute_id` = `Storeattribute`.`id`) WHERE `category_id` IN (0, 37) | 1 | 1 | 0 | |
| SELECT `Storetranslation`.`id`, `Storetranslation`.`translation_model`, `Storetranslation`.`translation_id`, `Storetranslation`.`locale`, `Storetranslation`.`value` FROM `tbiback_tbshops`.`storetranslations` AS `Storetranslation` WHERE `Storetranslation`.`translation_id` = 8 AND `locale` = 'nld' | 1 | 1 | 0 | |
| SELECT `StoreattributeOption`.`id`, `StoreattributeOption`.`locale`, `StoreattributeOption`.`value`, `StoreattributeOption`.`standard`, `StoreattributeOption`.`group`, `StoreattributeOption`.`storeattribute_id` FROM `tbiback_tbshops`.`storeattribute_options` AS `StoreattributeOption` WHERE `locale` = 'nld' AND `StoreattributeOption`.`storeattribute_id` = (8) ORDER BY `id` asc | 15 | 15 | 0 | |
| SELECT 'Productgroup' as model, Productgroup.id, promoprice, created, I18n__name__nld.content as name FROM productgroups as Productgroup RIGHT JOIN category_groups AS CategoryGroup ON (CategoryGroup.group_id = Productgroup.id) RIGHT JOIN descriptions AS Description ON (Description.group_id = Productgroup.id) LEFT JOIN i18n AS I18n__name__nld ON (Productgroup.id = I18n__name__nld.foreign_key AND I18n__name__nld.model = 'Productgroup' AND I18n__name__nld.field = 'name' AND I18n__name__nld.locale = 'nld') WHERE CategoryGroup.category_id IN(37) AND CategoryGroup.group_model = 'Productgroup' AND Description.store_id = '9' AND Description.group_model = 'Productgroup' AND hidden = '' UNION SELECT 'Bundle' as model, Bundle.id, promoprice, created, I18n__name__nld.content as name FROM bundles as Bundle RIGHT JOIN category_groups AS CategoryGroup ON (CategoryGroup.group_id = Bundle.id) RIGHT JOIN descriptions AS Description ON (Description.group_id = Bundle.id) LEFT JOIN i18n AS I18n__name__nld ON (Bundle.id = I18n__name__nld.foreign_key AND I18n__name__nld.model = 'Bundle' AND I18n__name__nld.field = 'name' AND I18n__name__nld.locale = 'nld') WHERE CategoryGroup.category_id IN(37) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '9' AND Description.group_model = 'Bundle' AND hidden = '' ORDER BY name asc LIMIT 0, 24 | 6 | 6 | 10 | maybe slow |
| SELECT `Productgroup`.`id`, `Productgroup`.`promoprice`, `Productgroup`.`wholesaleprice`, `Productgroup`.`price`, `Description`.`id`, (`I18n__name__nld`.`content`) AS `Productgroup__i18n_name_nld`, (`I18n__slug__nld`.`content`) AS `Productgroup__i18n_slug_nld` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__nld` ON (`Productgroup`.`id` = `I18n__name__nld`.`foreign_key` AND `I18n__name__nld`.`model` = 'Productgroup' AND `I18n__name__nld`.`field` = 'name' AND `I18n__name__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__slug__nld` ON (`Productgroup`.`id` = `I18n__slug__nld`.`foreign_key` AND `I18n__slug__nld`.`model` = 'Productgroup' AND `I18n__slug__nld`.`field` = 'slug' AND `I18n__slug__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`category_groups` AS `CategoryGroup` ON (`CategoryGroup`.`group_id` = `Productgroup`.`id` AND `CategoryGroup`.`group_model` = 'Productgroup') LEFT JOIN `tbiback_tbshops`.`descriptions` AS `Description` ON (`Description`.`group_id` = `Productgroup`.`id` AND `Description`.`group_model` = 'Productgroup') WHERE `Productgroup`.`id` = 120 LIMIT 1 | 1 | 1 | 7 | maybe slow |
| SELECT `Image`.`id`, `Image`.`group_id`, `Image`.`group_model`, `Image`.`filename`, `Image`.`sorting`, `Image`.`variant_id`, `Image`.`created`, `Image`.`compressed` FROM `tbiback_tbshops`.`images` AS `Image` WHERE `Image`.`group_model` = 'Productgroup' AND `Image`.`group_id` = (120) ORDER BY `sorting` ASC | 3 | 3 | 3 | |
| SELECT `Description`.`id`, (`I18n__description_short__nld`.`content`) AS `Description__i18n_description_short_nld` FROM `tbiback_tbshops`.`descriptions` AS `Description` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__description_short__nld` ON (`Description`.`id` = `I18n__description_short__nld`.`foreign_key` AND `I18n__description_short__nld`.`model` = 'Description' AND `I18n__description_short__nld`.`field` = 'description_short' AND `I18n__description_short__nld`.`locale` = 'nld') WHERE `Description`.`id` = 195 LIMIT 1 | 1 | 1 | 1 | |
| SELECT `Productgroup`.`id`, `Productgroup`.`promoprice`, `Productgroup`.`wholesaleprice`, `Productgroup`.`price`, `Description`.`id`, (`I18n__name__nld`.`content`) AS `Productgroup__i18n_name_nld`, (`I18n__slug__nld`.`content`) AS `Productgroup__i18n_slug_nld` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__nld` ON (`Productgroup`.`id` = `I18n__name__nld`.`foreign_key` AND `I18n__name__nld`.`model` = 'Productgroup' AND `I18n__name__nld`.`field` = 'name' AND `I18n__name__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__slug__nld` ON (`Productgroup`.`id` = `I18n__slug__nld`.`foreign_key` AND `I18n__slug__nld`.`model` = 'Productgroup' AND `I18n__slug__nld`.`field` = 'slug' AND `I18n__slug__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`category_groups` AS `CategoryGroup` ON (`CategoryGroup`.`group_id` = `Productgroup`.`id` AND `CategoryGroup`.`group_model` = 'Productgroup') LEFT JOIN `tbiback_tbshops`.`descriptions` AS `Description` ON (`Description`.`group_id` = `Productgroup`.`id` AND `Description`.`group_model` = 'Productgroup') WHERE `Productgroup`.`id` = 123 LIMIT 1 | 1 | 1 | 7 | maybe slow |
| SELECT `Image`.`id`, `Image`.`group_id`, `Image`.`group_model`, `Image`.`filename`, `Image`.`sorting`, `Image`.`variant_id`, `Image`.`created`, `Image`.`compressed` FROM `tbiback_tbshops`.`images` AS `Image` WHERE `Image`.`group_model` = 'Productgroup' AND `Image`.`group_id` = (123) ORDER BY `sorting` ASC | 3 | 3 | 3 | |
| SELECT `Description`.`id`, (`I18n__description_short__nld`.`content`) AS `Description__i18n_description_short_nld` FROM `tbiback_tbshops`.`descriptions` AS `Description` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__description_short__nld` ON (`Description`.`id` = `I18n__description_short__nld`.`foreign_key` AND `I18n__description_short__nld`.`model` = 'Description' AND `I18n__description_short__nld`.`field` = 'description_short' AND `I18n__description_short__nld`.`locale` = 'nld') WHERE `Description`.`id` = 198 LIMIT 1 | 1 | 1 | 2 | maybe slow |
| SELECT `Productgroup`.`id`, `Productgroup`.`promoprice`, `Productgroup`.`wholesaleprice`, `Productgroup`.`price`, `Description`.`id`, (`I18n__name__nld`.`content`) AS `Productgroup__i18n_name_nld`, (`I18n__slug__nld`.`content`) AS `Productgroup__i18n_slug_nld` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__nld` ON (`Productgroup`.`id` = `I18n__name__nld`.`foreign_key` AND `I18n__name__nld`.`model` = 'Productgroup' AND `I18n__name__nld`.`field` = 'name' AND `I18n__name__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__slug__nld` ON (`Productgroup`.`id` = `I18n__slug__nld`.`foreign_key` AND `I18n__slug__nld`.`model` = 'Productgroup' AND `I18n__slug__nld`.`field` = 'slug' AND `I18n__slug__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`category_groups` AS `CategoryGroup` ON (`CategoryGroup`.`group_id` = `Productgroup`.`id` AND `CategoryGroup`.`group_model` = 'Productgroup') LEFT JOIN `tbiback_tbshops`.`descriptions` AS `Description` ON (`Description`.`group_id` = `Productgroup`.`id` AND `Description`.`group_model` = 'Productgroup') WHERE `Productgroup`.`id` = 126 LIMIT 1 | 1 | 1 | 8 | maybe slow |
| SELECT `Image`.`id`, `Image`.`group_id`, `Image`.`group_model`, `Image`.`filename`, `Image`.`sorting`, `Image`.`variant_id`, `Image`.`created`, `Image`.`compressed` FROM `tbiback_tbshops`.`images` AS `Image` WHERE `Image`.`group_model` = 'Productgroup' AND `Image`.`group_id` = (126) ORDER BY `sorting` ASC | 3 | 3 | 2 | maybe slow |
| SELECT `Description`.`id`, (`I18n__description_short__nld`.`content`) AS `Description__i18n_description_short_nld` FROM `tbiback_tbshops`.`descriptions` AS `Description` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__description_short__nld` ON (`Description`.`id` = `I18n__description_short__nld`.`foreign_key` AND `I18n__description_short__nld`.`model` = 'Description' AND `I18n__description_short__nld`.`field` = 'description_short' AND `I18n__description_short__nld`.`locale` = 'nld') WHERE `Description`.`id` = 201 LIMIT 1 | 1 | 1 | 1 | |
| SELECT `Productgroup`.`id`, `Productgroup`.`promoprice`, `Productgroup`.`wholesaleprice`, `Productgroup`.`price`, `Description`.`id`, (`I18n__name__nld`.`content`) AS `Productgroup__i18n_name_nld`, (`I18n__slug__nld`.`content`) AS `Productgroup__i18n_slug_nld` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__nld` ON (`Productgroup`.`id` = `I18n__name__nld`.`foreign_key` AND `I18n__name__nld`.`model` = 'Productgroup' AND `I18n__name__nld`.`field` = 'name' AND `I18n__name__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__slug__nld` ON (`Productgroup`.`id` = `I18n__slug__nld`.`foreign_key` AND `I18n__slug__nld`.`model` = 'Productgroup' AND `I18n__slug__nld`.`field` = 'slug' AND `I18n__slug__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`category_groups` AS `CategoryGroup` ON (`CategoryGroup`.`group_id` = `Productgroup`.`id` AND `CategoryGroup`.`group_model` = 'Productgroup') LEFT JOIN `tbiback_tbshops`.`descriptions` AS `Description` ON (`Description`.`group_id` = `Productgroup`.`id` AND `Description`.`group_model` = 'Productgroup') WHERE `Productgroup`.`id` = 124 LIMIT 1 | 1 | 1 | 8 | maybe slow |
| SELECT `Image`.`id`, `Image`.`group_id`, `Image`.`group_model`, `Image`.`filename`, `Image`.`sorting`, `Image`.`variant_id`, `Image`.`created`, `Image`.`compressed` FROM `tbiback_tbshops`.`images` AS `Image` WHERE `Image`.`group_model` = 'Productgroup' AND `Image`.`group_id` = (124) ORDER BY `sorting` ASC | 3 | 3 | 2 | maybe slow |
| SELECT `Description`.`id`, (`I18n__description_short__nld`.`content`) AS `Description__i18n_description_short_nld` FROM `tbiback_tbshops`.`descriptions` AS `Description` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__description_short__nld` ON (`Description`.`id` = `I18n__description_short__nld`.`foreign_key` AND `I18n__description_short__nld`.`model` = 'Description' AND `I18n__description_short__nld`.`field` = 'description_short' AND `I18n__description_short__nld`.`locale` = 'nld') WHERE `Description`.`id` = 199 LIMIT 1 | 1 | 1 | 1 | |
| SELECT `Productgroup`.`id`, `Productgroup`.`promoprice`, `Productgroup`.`wholesaleprice`, `Productgroup`.`price`, `Description`.`id`, (`I18n__name__nld`.`content`) AS `Productgroup__i18n_name_nld`, (`I18n__slug__nld`.`content`) AS `Productgroup__i18n_slug_nld` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__nld` ON (`Productgroup`.`id` = `I18n__name__nld`.`foreign_key` AND `I18n__name__nld`.`model` = 'Productgroup' AND `I18n__name__nld`.`field` = 'name' AND `I18n__name__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__slug__nld` ON (`Productgroup`.`id` = `I18n__slug__nld`.`foreign_key` AND `I18n__slug__nld`.`model` = 'Productgroup' AND `I18n__slug__nld`.`field` = 'slug' AND `I18n__slug__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`category_groups` AS `CategoryGroup` ON (`CategoryGroup`.`group_id` = `Productgroup`.`id` AND `CategoryGroup`.`group_model` = 'Productgroup') LEFT JOIN `tbiback_tbshops`.`descriptions` AS `Description` ON (`Description`.`group_id` = `Productgroup`.`id` AND `Description`.`group_model` = 'Productgroup') WHERE `Productgroup`.`id` = 122 LIMIT 1 | 1 | 1 | 6 | maybe slow |
| SELECT `Image`.`id`, `Image`.`group_id`, `Image`.`group_model`, `Image`.`filename`, `Image`.`sorting`, `Image`.`variant_id`, `Image`.`created`, `Image`.`compressed` FROM `tbiback_tbshops`.`images` AS `Image` WHERE `Image`.`group_model` = 'Productgroup' AND `Image`.`group_id` = (122) ORDER BY `sorting` ASC | 3 | 3 | 2 | maybe slow |
| SELECT `Description`.`id`, (`I18n__description_short__nld`.`content`) AS `Description__i18n_description_short_nld` FROM `tbiback_tbshops`.`descriptions` AS `Description` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__description_short__nld` ON (`Description`.`id` = `I18n__description_short__nld`.`foreign_key` AND `I18n__description_short__nld`.`model` = 'Description' AND `I18n__description_short__nld`.`field` = 'description_short' AND `I18n__description_short__nld`.`locale` = 'nld') WHERE `Description`.`id` = 197 LIMIT 1 | 1 | 1 | 1 | |
| SELECT `Productgroup`.`id`, `Productgroup`.`promoprice`, `Productgroup`.`wholesaleprice`, `Productgroup`.`price`, `Description`.`id`, (`I18n__name__nld`.`content`) AS `Productgroup__i18n_name_nld`, (`I18n__slug__nld`.`content`) AS `Productgroup__i18n_slug_nld` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__nld` ON (`Productgroup`.`id` = `I18n__name__nld`.`foreign_key` AND `I18n__name__nld`.`model` = 'Productgroup' AND `I18n__name__nld`.`field` = 'name' AND `I18n__name__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__slug__nld` ON (`Productgroup`.`id` = `I18n__slug__nld`.`foreign_key` AND `I18n__slug__nld`.`model` = 'Productgroup' AND `I18n__slug__nld`.`field` = 'slug' AND `I18n__slug__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`category_groups` AS `CategoryGroup` ON (`CategoryGroup`.`group_id` = `Productgroup`.`id` AND `CategoryGroup`.`group_model` = 'Productgroup') LEFT JOIN `tbiback_tbshops`.`descriptions` AS `Description` ON (`Description`.`group_id` = `Productgroup`.`id` AND `Description`.`group_model` = 'Productgroup') WHERE `Productgroup`.`id` = 121 LIMIT 1 | 1 | 1 | 12 | maybe slow |
| SELECT `Image`.`id`, `Image`.`group_id`, `Image`.`group_model`, `Image`.`filename`, `Image`.`sorting`, `Image`.`variant_id`, `Image`.`created`, `Image`.`compressed` FROM `tbiback_tbshops`.`images` AS `Image` WHERE `Image`.`group_model` = 'Productgroup' AND `Image`.`group_id` = (121) ORDER BY `sorting` ASC | 3 | 3 | 3 | |
| SELECT `Description`.`id`, (`I18n__description_short__nld`.`content`) AS `Description__i18n_description_short_nld` FROM `tbiback_tbshops`.`descriptions` AS `Description` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__description_short__nld` ON (`Description`.`id` = `I18n__description_short__nld`.`foreign_key` AND `I18n__description_short__nld`.`model` = 'Description' AND `I18n__description_short__nld`.`field` = 'description_short' AND `I18n__description_short__nld`.`locale` = 'nld') WHERE `Description`.`id` = 196 LIMIT 1 | 1 | 1 | 1 | |
| SELECT count(*) as count FROM (SELECT 'Productgroup' as model, Productgroup.id, promoprice, created, I18n__name__nld.content as name FROM productgroups as Productgroup RIGHT JOIN category_groups AS CategoryGroup ON (CategoryGroup.group_id = Productgroup.id) RIGHT JOIN descriptions AS Description ON (Description.group_id = Productgroup.id) LEFT JOIN i18n AS I18n__name__nld ON (Productgroup.id = I18n__name__nld.foreign_key AND I18n__name__nld.model = 'Productgroup' AND I18n__name__nld.field = 'name' AND I18n__name__nld.locale = 'nld') WHERE CategoryGroup.category_id IN(37) AND CategoryGroup.group_model = 'Productgroup' AND Description.store_id = '9' AND Description.group_model = 'Productgroup' AND hidden = '' UNION SELECT 'Bundle' as model, Bundle.id, promoprice, created, I18n__name__nld.content as name FROM bundles as Bundle RIGHT JOIN category_groups AS CategoryGroup ON (CategoryGroup.group_id = Bundle.id) RIGHT JOIN descriptions AS Description ON (Description.group_id = Bundle.id) LEFT JOIN i18n AS I18n__name__nld ON (Bundle.id = I18n__name__nld.foreign_key AND I18n__name__nld.model = 'Bundle' AND I18n__name__nld.field = 'name' AND I18n__name__nld.locale = 'nld') WHERE CategoryGroup.category_id IN(37) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '9' AND Description.group_model = 'Bundle' AND hidden = '' ORDER BY name asc ) as groups | 1 | 1 | 11 | maybe slow |
| SELECT SUM(count) as count FROM (SELECT count(*) as count FROM productgroups as Productgroup RIGHT JOIN category_groups AS CategoryGroup ON (CategoryGroup.group_id = Productgroup.id) RIGHT JOIN descriptions AS Description ON (Description.group_id = Productgroup.id) LEFT JOIN i18n AS I18n__name__nld ON (Productgroup.id = I18n__name__nld.foreign_key AND I18n__name__nld.model = 'Productgroup' AND I18n__name__nld.field = 'name' AND I18n__name__nld.locale = 'nld') RIGHT JOIN group_attributes AS GroupAttribute_8 ON (GroupAttribute_8.group_id = Productgroup.id) WHERE CategoryGroup.category_id IN(37) AND CategoryGroup.group_model = 'Productgroup' AND Description.store_id = '9' AND Description.group_model = 'Productgroup' AND hidden = '' AND GroupAttribute_8.storeattribute_option_id = '124' AND GroupAttribute_8.group_model = 'Productgroup' UNION SELECT count(*) as count FROM bundles as Bundle RIGHT JOIN category_groups AS CategoryGroup ON (CategoryGroup.group_id = Bundle.id) RIGHT JOIN descriptions AS Description ON (Description.group_id = Bundle.id) LEFT JOIN i18n AS I18n__name__nld ON (Bundle.id = I18n__name__nld.foreign_key AND I18n__name__nld.model = 'Bundle' AND I18n__name__nld.field = 'name' AND I18n__name__nld.locale = 'nld') RIGHT JOIN group_attributes AS GroupAttribute_8 ON (GroupAttribute_8.group_id = Bundle.id) WHERE CategoryGroup.category_id IN(37) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '9' AND Description.group_model = 'Bundle' AND hidden = '' AND GroupAttribute_8.storeattribute_option_id = '124' AND GroupAttribute_8.group_model = 'Bundle') as attributes | 1 | 1 | 1 | |
| SELECT SUM(count) as count FROM (SELECT count(*) as count FROM productgroups as Productgroup RIGHT JOIN category_groups AS CategoryGroup ON (CategoryGroup.group_id = Productgroup.id) RIGHT JOIN descriptions AS Description ON (Description.group_id = Productgroup.id) LEFT JOIN i18n AS I18n__name__nld ON (Productgroup.id = I18n__name__nld.foreign_key AND I18n__name__nld.model = 'Productgroup' AND I18n__name__nld.field = 'name' AND I18n__name__nld.locale = 'nld') RIGHT JOIN group_attributes AS GroupAttribute_8 ON (GroupAttribute_8.group_id = Productgroup.id) WHERE CategoryGroup.category_id IN(37) AND CategoryGroup.group_model = 'Productgroup' AND Description.store_id = '9' AND Description.group_model = 'Productgroup' AND hidden = '' AND GroupAttribute_8.storeattribute_option_id = '125' AND GroupAttribute_8.group_model = 'Productgroup' UNION SELECT count(*) as count FROM bundles as Bundle RIGHT JOIN category_groups AS CategoryGroup ON (CategoryGroup.group_id = Bundle.id) RIGHT JOIN descriptions AS Description ON (Description.group_id = Bundle.id) LEFT JOIN i18n AS I18n__name__nld ON (Bundle.id = I18n__name__nld.foreign_key AND I18n__name__nld.model = 'Bundle' AND I18n__name__nld.field = 'name' AND I18n__name__nld.locale = 'nld') RIGHT JOIN group_attributes AS GroupAttribute_8 ON (GroupAttribute_8.group_id = Bundle.id) WHERE CategoryGroup.category_id IN(37) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '9' AND Description.group_model = 'Bundle' AND hidden = '' AND GroupAttribute_8.storeattribute_option_id = '125' AND GroupAttribute_8.group_model = 'Bundle') as attributes | 1 | 1 | 1 | |
| SELECT SUM(count) as count FROM (SELECT count(*) as count FROM productgroups as Productgroup RIGHT JOIN category_groups AS CategoryGroup ON (CategoryGroup.group_id = Productgroup.id) RIGHT JOIN descriptions AS Description ON (Description.group_id = Productgroup.id) LEFT JOIN i18n AS I18n__name__nld ON (Productgroup.id = I18n__name__nld.foreign_key AND I18n__name__nld.model = 'Productgroup' AND I18n__name__nld.field = 'name' AND I18n__name__nld.locale = 'nld') RIGHT JOIN group_attributes AS GroupAttribute_8 ON (GroupAttribute_8.group_id = Productgroup.id) WHERE CategoryGroup.category_id IN(37) AND CategoryGroup.group_model = 'Productgroup' AND Description.store_id = '9' AND Description.group_model = 'Productgroup' AND hidden = '' AND GroupAttribute_8.storeattribute_option_id = '126' AND GroupAttribute_8.group_model = 'Productgroup' UNION SELECT count(*) as count FROM bundles as Bundle RIGHT JOIN category_groups AS CategoryGroup ON (CategoryGroup.group_id = Bundle.id) RIGHT JOIN descriptions AS Description ON (Description.group_id = Bundle.id) LEFT JOIN i18n AS I18n__name__nld ON (Bundle.id = I18n__name__nld.foreign_key AND I18n__name__nld.model = 'Bundle' AND I18n__name__nld.field = 'name' AND I18n__name__nld.locale = 'nld') RIGHT JOIN group_attributes AS GroupAttribute_8 ON (GroupAttribute_8.group_id = Bundle.id) WHERE CategoryGroup.category_id IN(37) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '9' AND Description.group_model = 'Bundle' AND hidden = '' AND GroupAttribute_8.storeattribute_option_id = '126' AND GroupAttribute_8.group_model = 'Bundle') as attributes | 1 | 1 | 2 | maybe slow |
| SELECT SUM(count) as count FROM (SELECT count(*) as count FROM productgroups as Productgroup RIGHT JOIN category_groups AS CategoryGroup ON (CategoryGroup.group_id = Productgroup.id) RIGHT JOIN descriptions AS Description ON (Description.group_id = Productgroup.id) LEFT JOIN i18n AS I18n__name__nld ON (Productgroup.id = I18n__name__nld.foreign_key AND I18n__name__nld.model = 'Productgroup' AND I18n__name__nld.field = 'name' AND I18n__name__nld.locale = 'nld') RIGHT JOIN group_attributes AS GroupAttribute_8 ON (GroupAttribute_8.group_id = Productgroup.id) WHERE CategoryGroup.category_id IN(37) AND CategoryGroup.group_model = 'Productgroup' AND Description.store_id = '9' AND Description.group_model = 'Productgroup' AND hidden = '' AND GroupAttribute_8.storeattribute_option_id = '127' AND GroupAttribute_8.group_model = 'Productgroup' UNION SELECT count(*) as count FROM bundles as Bundle RIGHT JOIN category_groups AS CategoryGroup ON (CategoryGroup.group_id = Bundle.id) RIGHT JOIN descriptions AS Description ON (Description.group_id = Bundle.id) LEFT JOIN i18n AS I18n__name__nld ON (Bundle.id = I18n__name__nld.foreign_key AND I18n__name__nld.model = 'Bundle' AND I18n__name__nld.field = 'name' AND I18n__name__nld.locale = 'nld') RIGHT JOIN group_attributes AS GroupAttribute_8 ON (GroupAttribute_8.group_id = Bundle.id) WHERE CategoryGroup.category_id IN(37) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '9' AND Description.group_model = 'Bundle' AND hidden = '' AND GroupAttribute_8.storeattribute_option_id = '127' AND GroupAttribute_8.group_model = 'Bundle') as attributes | 1 | 1 | 2 | maybe slow |
| SELECT SUM(count) as count FROM (SELECT count(*) as count FROM productgroups as Productgroup RIGHT JOIN category_groups AS CategoryGroup ON (CategoryGroup.group_id = Productgroup.id) RIGHT JOIN descriptions AS Description ON (Description.group_id = Productgroup.id) LEFT JOIN i18n AS I18n__name__nld ON (Productgroup.id = I18n__name__nld.foreign_key AND I18n__name__nld.model = 'Productgroup' AND I18n__name__nld.field = 'name' AND I18n__name__nld.locale = 'nld') RIGHT JOIN group_attributes AS GroupAttribute_8 ON (GroupAttribute_8.group_id = Productgroup.id) WHERE CategoryGroup.category_id IN(37) AND CategoryGroup.group_model = 'Productgroup' AND Description.store_id = '9' AND Description.group_model = 'Productgroup' AND hidden = '' AND GroupAttribute_8.storeattribute_option_id = '128' AND GroupAttribute_8.group_model = 'Productgroup' UNION SELECT count(*) as count FROM bundles as Bundle RIGHT JOIN category_groups AS CategoryGroup ON (CategoryGroup.group_id = Bundle.id) RIGHT JOIN descriptions AS Description ON (Description.group_id = Bundle.id) LEFT JOIN i18n AS I18n__name__nld ON (Bundle.id = I18n__name__nld.foreign_key AND I18n__name__nld.model = 'Bundle' AND I18n__name__nld.field = 'name' AND I18n__name__nld.locale = 'nld') RIGHT JOIN group_attributes AS GroupAttribute_8 ON (GroupAttribute_8.group_id = Bundle.id) WHERE CategoryGroup.category_id IN(37) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '9' AND Description.group_model = 'Bundle' AND hidden = '' AND GroupAttribute_8.storeattribute_option_id = '128' AND GroupAttribute_8.group_model = 'Bundle') as attributes | 1 | 1 | 2 | maybe slow |
| SELECT SUM(count) as count FROM (SELECT count(*) as count FROM productgroups as Productgroup RIGHT JOIN category_groups AS CategoryGroup ON (CategoryGroup.group_id = Productgroup.id) RIGHT JOIN descriptions AS Description ON (Description.group_id = Productgroup.id) LEFT JOIN i18n AS I18n__name__nld ON (Productgroup.id = I18n__name__nld.foreign_key AND I18n__name__nld.model = 'Productgroup' AND I18n__name__nld.field = 'name' AND I18n__name__nld.locale = 'nld') RIGHT JOIN group_attributes AS GroupAttribute_8 ON (GroupAttribute_8.group_id = Productgroup.id) WHERE CategoryGroup.category_id IN(37) AND CategoryGroup.group_model = 'Productgroup' AND Description.store_id = '9' AND Description.group_model = 'Productgroup' AND hidden = '' AND GroupAttribute_8.storeattribute_option_id = '129' AND GroupAttribute_8.group_model = 'Productgroup' UNION SELECT count(*) as count FROM bundles as Bundle RIGHT JOIN category_groups AS CategoryGroup ON (CategoryGroup.group_id = Bundle.id) RIGHT JOIN descriptions AS Description ON (Description.group_id = Bundle.id) LEFT JOIN i18n AS I18n__name__nld ON (Bundle.id = I18n__name__nld.foreign_key AND I18n__name__nld.model = 'Bundle' AND I18n__name__nld.field = 'name' AND I18n__name__nld.locale = 'nld') RIGHT JOIN group_attributes AS GroupAttribute_8 ON (GroupAttribute_8.group_id = Bundle.id) WHERE CategoryGroup.category_id IN(37) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '9' AND Description.group_model = 'Bundle' AND hidden = '' AND GroupAttribute_8.storeattribute_option_id = '129' AND GroupAttribute_8.group_model = 'Bundle') as attributes | 1 | 1 | 2 | maybe slow |
| SELECT SUM(count) as count FROM (SELECT count(*) as count FROM productgroups as Productgroup RIGHT JOIN category_groups AS CategoryGroup ON (CategoryGroup.group_id = Productgroup.id) RIGHT JOIN descriptions AS Description ON (Description.group_id = Productgroup.id) LEFT JOIN i18n AS I18n__name__nld ON (Productgroup.id = I18n__name__nld.foreign_key AND I18n__name__nld.model = 'Productgroup' AND I18n__name__nld.field = 'name' AND I18n__name__nld.locale = 'nld') RIGHT JOIN group_attributes AS GroupAttribute_8 ON (GroupAttribute_8.group_id = Productgroup.id) WHERE CategoryGroup.category_id IN(37) AND CategoryGroup.group_model = 'Productgroup' AND Description.store_id = '9' AND Description.group_model = 'Productgroup' AND hidden = '' AND GroupAttribute_8.storeattribute_option_id = '130' AND GroupAttribute_8.group_model = 'Productgroup' UNION SELECT count(*) as count FROM bundles as Bundle RIGHT JOIN category_groups AS CategoryGroup ON (CategoryGroup.group_id = Bundle.id) RIGHT JOIN descriptions AS Description ON (Description.group_id = Bundle.id) LEFT JOIN i18n AS I18n__name__nld ON (Bundle.id = I18n__name__nld.foreign_key AND I18n__name__nld.model = 'Bundle' AND I18n__name__nld.field = 'name' AND I18n__name__nld.locale = 'nld') RIGHT JOIN group_attributes AS GroupAttribute_8 ON (GroupAttribute_8.group_id = Bundle.id) WHERE CategoryGroup.category_id IN(37) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '9' AND Description.group_model = 'Bundle' AND hidden = '' AND GroupAttribute_8.storeattribute_option_id = '130' AND GroupAttribute_8.group_model = 'Bundle') as attributes | 1 | 1 | 1 | |
| SELECT SUM(count) as count FROM (SELECT count(*) as count FROM productgroups as Productgroup RIGHT JOIN category_groups AS CategoryGroup ON (CategoryGroup.group_id = Productgroup.id) RIGHT JOIN descriptions AS Description ON (Description.group_id = Productgroup.id) LEFT JOIN i18n AS I18n__name__nld ON (Productgroup.id = I18n__name__nld.foreign_key AND I18n__name__nld.model = 'Productgroup' AND I18n__name__nld.field = 'name' AND I18n__name__nld.locale = 'nld') RIGHT JOIN group_attributes AS GroupAttribute_8 ON (GroupAttribute_8.group_id = Productgroup.id) WHERE CategoryGroup.category_id IN(37) AND CategoryGroup.group_model = 'Productgroup' AND Description.store_id = '9' AND Description.group_model = 'Productgroup' AND hidden = '' AND GroupAttribute_8.storeattribute_option_id = '131' AND GroupAttribute_8.group_model = 'Productgroup' UNION SELECT count(*) as count FROM bundles as Bundle RIGHT JOIN category_groups AS CategoryGroup ON (CategoryGroup.group_id = Bundle.id) RIGHT JOIN descriptions AS Description ON (Description.group_id = Bundle.id) LEFT JOIN i18n AS I18n__name__nld ON (Bundle.id = I18n__name__nld.foreign_key AND I18n__name__nld.model = 'Bundle' AND I18n__name__nld.field = 'name' AND I18n__name__nld.locale = 'nld') RIGHT JOIN group_attributes AS GroupAttribute_8 ON (GroupAttribute_8.group_id = Bundle.id) WHERE CategoryGroup.category_id IN(37) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '9' AND Description.group_model = 'Bundle' AND hidden = '' AND GroupAttribute_8.storeattribute_option_id = '131' AND GroupAttribute_8.group_model = 'Bundle') as attributes | 1 | 1 | 1 | |
| SELECT SUM(count) as count FROM (SELECT count(*) as count FROM productgroups as Productgroup RIGHT JOIN category_groups AS CategoryGroup ON (CategoryGroup.group_id = Productgroup.id) RIGHT JOIN descriptions AS Description ON (Description.group_id = Productgroup.id) LEFT JOIN i18n AS I18n__name__nld ON (Productgroup.id = I18n__name__nld.foreign_key AND I18n__name__nld.model = 'Productgroup' AND I18n__name__nld.field = 'name' AND I18n__name__nld.locale = 'nld') RIGHT JOIN group_attributes AS GroupAttribute_8 ON (GroupAttribute_8.group_id = Productgroup.id) WHERE CategoryGroup.category_id IN(37) AND CategoryGroup.group_model = 'Productgroup' AND Description.store_id = '9' AND Description.group_model = 'Productgroup' AND hidden = '' AND GroupAttribute_8.storeattribute_option_id = '132' AND GroupAttribute_8.group_model = 'Productgroup' UNION SELECT count(*) as count FROM bundles as Bundle RIGHT JOIN category_groups AS CategoryGroup ON (CategoryGroup.group_id = Bundle.id) RIGHT JOIN descriptions AS Description ON (Description.group_id = Bundle.id) LEFT JOIN i18n AS I18n__name__nld ON (Bundle.id = I18n__name__nld.foreign_key AND I18n__name__nld.model = 'Bundle' AND I18n__name__nld.field = 'name' AND I18n__name__nld.locale = 'nld') RIGHT JOIN group_attributes AS GroupAttribute_8 ON (GroupAttribute_8.group_id = Bundle.id) WHERE CategoryGroup.category_id IN(37) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '9' AND Description.group_model = 'Bundle' AND hidden = '' AND GroupAttribute_8.storeattribute_option_id = '132' AND GroupAttribute_8.group_model = 'Bundle') as attributes | 1 | 1 | 1 | |
| SELECT SUM(count) as count FROM (SELECT count(*) as count FROM productgroups as Productgroup RIGHT JOIN category_groups AS CategoryGroup ON (CategoryGroup.group_id = Productgroup.id) RIGHT JOIN descriptions AS Description ON (Description.group_id = Productgroup.id) LEFT JOIN i18n AS I18n__name__nld ON (Productgroup.id = I18n__name__nld.foreign_key AND I18n__name__nld.model = 'Productgroup' AND I18n__name__nld.field = 'name' AND I18n__name__nld.locale = 'nld') RIGHT JOIN group_attributes AS GroupAttribute_8 ON (GroupAttribute_8.group_id = Productgroup.id) WHERE CategoryGroup.category_id IN(37) AND CategoryGroup.group_model = 'Productgroup' AND Description.store_id = '9' AND Description.group_model = 'Productgroup' AND hidden = '' AND GroupAttribute_8.storeattribute_option_id = '133' AND GroupAttribute_8.group_model = 'Productgroup' UNION SELECT count(*) as count FROM bundles as Bundle RIGHT JOIN category_groups AS CategoryGroup ON (CategoryGroup.group_id = Bundle.id) RIGHT JOIN descriptions AS Description ON (Description.group_id = Bundle.id) LEFT JOIN i18n AS I18n__name__nld ON (Bundle.id = I18n__name__nld.foreign_key AND I18n__name__nld.model = 'Bundle' AND I18n__name__nld.field = 'name' AND I18n__name__nld.locale = 'nld') RIGHT JOIN group_attributes AS GroupAttribute_8 ON (GroupAttribute_8.group_id = Bundle.id) WHERE CategoryGroup.category_id IN(37) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '9' AND Description.group_model = 'Bundle' AND hidden = '' AND GroupAttribute_8.storeattribute_option_id = '133' AND GroupAttribute_8.group_model = 'Bundle') as attributes | 1 | 1 | 1 | |
| SELECT SUM(count) as count FROM (SELECT count(*) as count FROM productgroups as Productgroup RIGHT JOIN category_groups AS CategoryGroup ON (CategoryGroup.group_id = Productgroup.id) RIGHT JOIN descriptions AS Description ON (Description.group_id = Productgroup.id) LEFT JOIN i18n AS I18n__name__nld ON (Productgroup.id = I18n__name__nld.foreign_key AND I18n__name__nld.model = 'Productgroup' AND I18n__name__nld.field = 'name' AND I18n__name__nld.locale = 'nld') RIGHT JOIN group_attributes AS GroupAttribute_8 ON (GroupAttribute_8.group_id = Productgroup.id) WHERE CategoryGroup.category_id IN(37) AND CategoryGroup.group_model = 'Productgroup' AND Description.store_id = '9' AND Description.group_model = 'Productgroup' AND hidden = '' AND GroupAttribute_8.storeattribute_option_id = '134' AND GroupAttribute_8.group_model = 'Productgroup' UNION SELECT count(*) as count FROM bundles as Bundle RIGHT JOIN category_groups AS CategoryGroup ON (CategoryGroup.group_id = Bundle.id) RIGHT JOIN descriptions AS Description ON (Description.group_id = Bundle.id) LEFT JOIN i18n AS I18n__name__nld ON (Bundle.id = I18n__name__nld.foreign_key AND I18n__name__nld.model = 'Bundle' AND I18n__name__nld.field = 'name' AND I18n__name__nld.locale = 'nld') RIGHT JOIN group_attributes AS GroupAttribute_8 ON (GroupAttribute_8.group_id = Bundle.id) WHERE CategoryGroup.category_id IN(37) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '9' AND Description.group_model = 'Bundle' AND hidden = '' AND GroupAttribute_8.storeattribute_option_id = '134' AND GroupAttribute_8.group_model = 'Bundle') as attributes | 1 | 1 | 1 | |
| SELECT SUM(count) as count FROM (SELECT count(*) as count FROM productgroups as Productgroup RIGHT JOIN category_groups AS CategoryGroup ON (CategoryGroup.group_id = Productgroup.id) RIGHT JOIN descriptions AS Description ON (Description.group_id = Productgroup.id) LEFT JOIN i18n AS I18n__name__nld ON (Productgroup.id = I18n__name__nld.foreign_key AND I18n__name__nld.model = 'Productgroup' AND I18n__name__nld.field = 'name' AND I18n__name__nld.locale = 'nld') RIGHT JOIN group_attributes AS GroupAttribute_8 ON (GroupAttribute_8.group_id = Productgroup.id) WHERE CategoryGroup.category_id IN(37) AND CategoryGroup.group_model = 'Productgroup' AND Description.store_id = '9' AND Description.group_model = 'Productgroup' AND hidden = '' AND GroupAttribute_8.storeattribute_option_id = '135' AND GroupAttribute_8.group_model = 'Productgroup' UNION SELECT count(*) as count FROM bundles as Bundle RIGHT JOIN category_groups AS CategoryGroup ON (CategoryGroup.group_id = Bundle.id) RIGHT JOIN descriptions AS Description ON (Description.group_id = Bundle.id) LEFT JOIN i18n AS I18n__name__nld ON (Bundle.id = I18n__name__nld.foreign_key AND I18n__name__nld.model = 'Bundle' AND I18n__name__nld.field = 'name' AND I18n__name__nld.locale = 'nld') RIGHT JOIN group_attributes AS GroupAttribute_8 ON (GroupAttribute_8.group_id = Bundle.id) WHERE CategoryGroup.category_id IN(37) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '9' AND Description.group_model = 'Bundle' AND hidden = '' AND GroupAttribute_8.storeattribute_option_id = '135' AND GroupAttribute_8.group_model = 'Bundle') as attributes | 1 | 1 | 1 | |
| SELECT SUM(count) as count FROM (SELECT count(*) as count FROM productgroups as Productgroup RIGHT JOIN category_groups AS CategoryGroup ON (CategoryGroup.group_id = Productgroup.id) RIGHT JOIN descriptions AS Description ON (Description.group_id = Productgroup.id) LEFT JOIN i18n AS I18n__name__nld ON (Productgroup.id = I18n__name__nld.foreign_key AND I18n__name__nld.model = 'Productgroup' AND I18n__name__nld.field = 'name' AND I18n__name__nld.locale = 'nld') RIGHT JOIN group_attributes AS GroupAttribute_8 ON (GroupAttribute_8.group_id = Productgroup.id) WHERE CategoryGroup.category_id IN(37) AND CategoryGroup.group_model = 'Productgroup' AND Description.store_id = '9' AND Description.group_model = 'Productgroup' AND hidden = '' AND GroupAttribute_8.storeattribute_option_id = '136' AND GroupAttribute_8.group_model = 'Productgroup' UNION SELECT count(*) as count FROM bundles as Bundle RIGHT JOIN category_groups AS CategoryGroup ON (CategoryGroup.group_id = Bundle.id) RIGHT JOIN descriptions AS Description ON (Description.group_id = Bundle.id) LEFT JOIN i18n AS I18n__name__nld ON (Bundle.id = I18n__name__nld.foreign_key AND I18n__name__nld.model = 'Bundle' AND I18n__name__nld.field = 'name' AND I18n__name__nld.locale = 'nld') RIGHT JOIN group_attributes AS GroupAttribute_8 ON (GroupAttribute_8.group_id = Bundle.id) WHERE CategoryGroup.category_id IN(37) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '9' AND Description.group_model = 'Bundle' AND hidden = '' AND GroupAttribute_8.storeattribute_option_id = '136' AND GroupAttribute_8.group_model = 'Bundle') as attributes | 1 | 1 | 2 | maybe slow |
| SELECT SUM(count) as count FROM (SELECT count(*) as count FROM productgroups as Productgroup RIGHT JOIN category_groups AS CategoryGroup ON (CategoryGroup.group_id = Productgroup.id) RIGHT JOIN descriptions AS Description ON (Description.group_id = Productgroup.id) LEFT JOIN i18n AS I18n__name__nld ON (Productgroup.id = I18n__name__nld.foreign_key AND I18n__name__nld.model = 'Productgroup' AND I18n__name__nld.field = 'name' AND I18n__name__nld.locale = 'nld') RIGHT JOIN group_attributes AS GroupAttribute_8 ON (GroupAttribute_8.group_id = Productgroup.id) WHERE CategoryGroup.category_id IN(37) AND CategoryGroup.group_model = 'Productgroup' AND Description.store_id = '9' AND Description.group_model = 'Productgroup' AND hidden = '' AND GroupAttribute_8.storeattribute_option_id = '137' AND GroupAttribute_8.group_model = 'Productgroup' UNION SELECT count(*) as count FROM bundles as Bundle RIGHT JOIN category_groups AS CategoryGroup ON (CategoryGroup.group_id = Bundle.id) RIGHT JOIN descriptions AS Description ON (Description.group_id = Bundle.id) LEFT JOIN i18n AS I18n__name__nld ON (Bundle.id = I18n__name__nld.foreign_key AND I18n__name__nld.model = 'Bundle' AND I18n__name__nld.field = 'name' AND I18n__name__nld.locale = 'nld') RIGHT JOIN group_attributes AS GroupAttribute_8 ON (GroupAttribute_8.group_id = Bundle.id) WHERE CategoryGroup.category_id IN(37) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '9' AND Description.group_model = 'Bundle' AND hidden = '' AND GroupAttribute_8.storeattribute_option_id = '137' AND GroupAttribute_8.group_model = 'Bundle') as attributes | 1 | 1 | 2 | maybe slow |
| SELECT SUM(count) as count FROM (SELECT count(*) as count FROM productgroups as Productgroup RIGHT JOIN category_groups AS CategoryGroup ON (CategoryGroup.group_id = Productgroup.id) RIGHT JOIN descriptions AS Description ON (Description.group_id = Productgroup.id) LEFT JOIN i18n AS I18n__name__nld ON (Productgroup.id = I18n__name__nld.foreign_key AND I18n__name__nld.model = 'Productgroup' AND I18n__name__nld.field = 'name' AND I18n__name__nld.locale = 'nld') RIGHT JOIN group_attributes AS GroupAttribute_8 ON (GroupAttribute_8.group_id = Productgroup.id) WHERE CategoryGroup.category_id IN(37) AND CategoryGroup.group_model = 'Productgroup' AND Description.store_id = '9' AND Description.group_model = 'Productgroup' AND hidden = '' AND GroupAttribute_8.storeattribute_option_id = '138' AND GroupAttribute_8.group_model = 'Productgroup' UNION SELECT count(*) as count FROM bundles as Bundle RIGHT JOIN category_groups AS CategoryGroup ON (CategoryGroup.group_id = Bundle.id) RIGHT JOIN descriptions AS Description ON (Description.group_id = Bundle.id) LEFT JOIN i18n AS I18n__name__nld ON (Bundle.id = I18n__name__nld.foreign_key AND I18n__name__nld.model = 'Bundle' AND I18n__name__nld.field = 'name' AND I18n__name__nld.locale = 'nld') RIGHT JOIN group_attributes AS GroupAttribute_8 ON (GroupAttribute_8.group_id = Bundle.id) WHERE CategoryGroup.category_id IN(37) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '9' AND Description.group_model = 'Bundle' AND hidden = '' AND GroupAttribute_8.storeattribute_option_id = '138' AND GroupAttribute_8.group_model = 'Bundle') as attributes | 1 | 1 | 2 | maybe slow |
| SELECT MAX(maxprice) as maxprice, MIN(minprice) as minprice FROM (SELECT MAX(promoprice) as maxprice, MIN(promoprice) as minprice FROM productgroups as Productgroup RIGHT JOIN category_groups AS CategoryGroup ON (CategoryGroup.group_id = Productgroup.id) RIGHT JOIN descriptions AS Description ON (Description.group_id = Productgroup.id) LEFT JOIN i18n AS I18n__name__nld ON (Productgroup.id = I18n__name__nld.foreign_key AND I18n__name__nld.model = 'Productgroup' AND I18n__name__nld.field = 'name' AND I18n__name__nld.locale = 'nld') WHERE CategoryGroup.category_id IN(37) AND CategoryGroup.group_model = 'Productgroup' AND Description.store_id = '9' AND Description.group_model = 'Productgroup' AND hidden = '' UNION SELECT MAX(promoprice) as maxprice, MIN(promoprice) as minprice FROM bundles as Bundle RIGHT JOIN category_groups AS CategoryGroup ON (CategoryGroup.group_id = Bundle.id) RIGHT JOIN descriptions AS Description ON (Description.group_id = Bundle.id) LEFT JOIN i18n AS I18n__name__nld ON (Bundle.id = I18n__name__nld.foreign_key AND I18n__name__nld.model = 'Bundle' AND I18n__name__nld.field = 'name' AND I18n__name__nld.locale = 'nld') WHERE CategoryGroup.category_id IN(37) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '9' AND Description.group_model = 'Bundle' AND hidden = '') as prices | 1 | 1 | 15 | maybe slow |
| SELECT name as value, id, sum(count) as count FROM (SELECT Brand.name as name, Brand.id as id, count(DISTINCT Productgroup.id) as count FROM productgroups as Productgroup RIGHT JOIN category_groups AS CategoryGroup ON (CategoryGroup.group_id = Productgroup.id) RIGHT JOIN descriptions AS Description ON (Description.group_id = Productgroup.id) LEFT JOIN i18n AS I18n__name__nld ON (Productgroup.id = I18n__name__nld.foreign_key AND I18n__name__nld.model = 'Productgroup' AND I18n__name__nld.field = 'name' AND I18n__name__nld.locale = 'nld') RIGHT JOIN brands AS Brand ON (Productgroup.brand_id = Brand.id) WHERE CategoryGroup.category_id IN(37) AND CategoryGroup.group_model = 'Productgroup' AND Description.store_id = '9' AND Description.group_model = 'Productgroup' AND hidden = '' GROUP BY Brand.id UNION SELECT Brand.name as name, Brand.id as id, count(DISTINCT Bundle.id) as count FROM bundles as Bundle RIGHT JOIN category_groups AS CategoryGroup ON (CategoryGroup.group_id = Bundle.id) RIGHT JOIN descriptions AS Description ON (Description.group_id = Bundle.id) LEFT JOIN i18n AS I18n__name__nld ON (Bundle.id = I18n__name__nld.foreign_key AND I18n__name__nld.model = 'Bundle' AND I18n__name__nld.field = 'name' AND I18n__name__nld.locale = 'nld') RIGHT JOIN brands AS Brand ON (Bundle.brand_id = Brand.id) WHERE CategoryGroup.category_id IN(37) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '9' AND Description.group_model = 'Bundle' AND hidden = '' GROUP BY Brand.id) as Brand GROUP BY Brand.id ORDER BY name | 0 | 0 | 10 | maybe slow |
| SELECT `Category`.`id`, (`I18n__path`.`content`) AS `Category__i18n_path` FROM `tbiback_tbshops`.`categories` AS `Category` INNER JOIN `tbiback_tbshops`.`i18n` AS `I18n__path` ON (`Category`.`id` = `I18n__path`.`foreign_key` AND `I18n__path`.`model` = 'Category' AND `I18n__path`.`field` = 'path' AND `I18n__path`.`locale` = 'fra') WHERE `Category`.`id` = 37 AND `Category`.`store_id` = 9 LIMIT 1 | 1 | 1 | 1 | |
| SELECT `Category`.`id`, (`I18n__path`.`content`) AS `Category__i18n_path` FROM `tbiback_tbshops`.`categories` AS `Category` INNER JOIN `tbiback_tbshops`.`i18n` AS `I18n__path` ON (`Category`.`id` = `I18n__path`.`foreign_key` AND `I18n__path`.`model` = 'Category' AND `I18n__path`.`field` = 'path' AND `I18n__path`.`locale` = 'eng') WHERE `Category`.`id` = 37 AND `Category`.`store_id` = 9 LIMIT 1 | 1 | 1 | 1 | |
| SELECT `Category`.`id`, (`I18n__path`.`content`) AS `Category__i18n_path` FROM `tbiback_tbshops`.`categories` AS `Category` INNER JOIN `tbiback_tbshops`.`i18n` AS `I18n__path` ON (`Category`.`id` = `I18n__path`.`foreign_key` AND `I18n__path`.`model` = 'Category' AND `I18n__path`.`field` = 'path' AND `I18n__path`.`locale` = 'fra') WHERE `Category`.`id` = 37 AND `Category`.`store_id` = 9 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Category`.`id`, (`I18n__path`.`content`) AS `Category__i18n_path` FROM `tbiback_tbshops`.`categories` AS `Category` INNER JOIN `tbiback_tbshops`.`i18n` AS `I18n__path` ON (`Category`.`id` = `I18n__path`.`foreign_key` AND `I18n__path`.`model` = 'Category' AND `I18n__path`.`field` = 'path' AND `I18n__path`.`locale` = 'eng') WHERE `Category`.`id` = 37 AND `Category`.`store_id` = 9 LIMIT 1 | 1 | 1 | 0 | |
