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` = 'trampolinesonline.be' LIMIT 1 | 1 | 1 | 4 | maybe slow |
SELECT `StoreSetting`.`id`, `StoreSetting`.`key`, `StoreSetting`.`value`, `StoreSetting`.`type`, `StoreSetting`.`store_id` FROM `tbiback_tbshops`.`store_settings` AS `StoreSetting` WHERE `StoreSetting`.`store_id` = (14) | 18 | 18 | 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` = '2024-03-19' 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` = '2024-03-19' 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` = '2024-03-19' 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` = '2024-03-19' 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` = 'trampolinesonline.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` = (14) | 18 | 18 | 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` = 14 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` = (11) | 4 | 4 | 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` <= '2024-03-19' AND `end` >= '2024-03-19' AND `store_id` IN (0, 14) LIMIT 1 | 0 | 0 | 1 | maybe slow |
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://trampolinesonline.be/nld/category/88/veiligheidsnet-trampolines' AND `store_id` = 14 LIMIT 1 | 0 | 0 | 0 | |
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` = 88 AND `Category`.`store_id` = 14 LIMIT 1 | 1 | 1 | 3 | maybe slow |
SELECT `ChildCategory`.`id`, `ChildCategory`.`parent_id` FROM `tbiback_tbshops`.`categories` AS `ChildCategory` WHERE `ChildCategory`.`parent_id` = (88) | 0 | 0 | 0 | |
SELECT `Category`.`parent_id` FROM `tbiback_tbshops`.`categories` AS `Category` WHERE `Category`.`id` = 88 AND `Category`.`store_id` = 14 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` = 88 AND `Category`.`store_id` = 14 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, 88) | 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(88) AND CategoryGroup.group_model = 'Productgroup' AND Description.store_id = '14' 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(88) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '14' AND Description.group_model = 'Bundle' AND hidden = '' ORDER BY name asc LIMIT 0, 24 | 10 | 10 | 9 | 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` = 468 LIMIT 1 | 1 | 1 | 5 | 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` = (468) ORDER BY `sorting` ASC | 1 | 1 | 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` = 634 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` = 461 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` = (461) ORDER BY `sorting` ASC | 1 | 1 | 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` = 627 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` = 462 LIMIT 1 | 1 | 1 | 5 | 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` = (462) ORDER BY `sorting` ASC | 1 | 1 | 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` = 628 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` = 463 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` = (463) ORDER BY `sorting` ASC | 1 | 1 | 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` = 629 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` = 470 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` = (470) ORDER BY `sorting` ASC | 1 | 1 | 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` = 636 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` = 469 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` = (469) ORDER BY `sorting` ASC | 1 | 1 | 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` = 635 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` = 464 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` = (464) ORDER BY `sorting` ASC | 1 | 1 | 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` = 630 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` = 465 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` = (465) ORDER BY `sorting` ASC | 1 | 1 | 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` = 631 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` = 466 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` = (466) ORDER BY `sorting` ASC | 1 | 1 | 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` = 632 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` = 467 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` = (467) ORDER BY `sorting` ASC | 1 | 1 | 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` = 633 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(88) AND CategoryGroup.group_model = 'Productgroup' AND Description.store_id = '14' 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(88) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '14' AND Description.group_model = 'Bundle' AND hidden = '' ORDER BY name asc ) as groups | 1 | 1 | 9 | 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(88) AND CategoryGroup.group_model = 'Productgroup' AND Description.store_id = '14' 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(88) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '14' 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(88) AND CategoryGroup.group_model = 'Productgroup' AND Description.store_id = '14' 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(88) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '14' 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(88) AND CategoryGroup.group_model = 'Productgroup' AND Description.store_id = '14' 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(88) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '14' AND Description.group_model = 'Bundle' AND hidden = '' AND GroupAttribute_8.storeattribute_option_id = '126' 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(88) AND CategoryGroup.group_model = 'Productgroup' AND Description.store_id = '14' 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(88) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '14' AND Description.group_model = 'Bundle' AND hidden = '' AND GroupAttribute_8.storeattribute_option_id = '127' 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(88) AND CategoryGroup.group_model = 'Productgroup' AND Description.store_id = '14' 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(88) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '14' AND Description.group_model = 'Bundle' AND hidden = '' AND GroupAttribute_8.storeattribute_option_id = '128' 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(88) AND CategoryGroup.group_model = 'Productgroup' AND Description.store_id = '14' 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(88) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '14' AND Description.group_model = 'Bundle' AND hidden = '' AND GroupAttribute_8.storeattribute_option_id = '129' 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(88) AND CategoryGroup.group_model = 'Productgroup' AND Description.store_id = '14' 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(88) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '14' 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(88) AND CategoryGroup.group_model = 'Productgroup' AND Description.store_id = '14' 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(88) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '14' 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(88) AND CategoryGroup.group_model = 'Productgroup' AND Description.store_id = '14' 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(88) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '14' 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(88) AND CategoryGroup.group_model = 'Productgroup' AND Description.store_id = '14' 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(88) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '14' 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(88) AND CategoryGroup.group_model = 'Productgroup' AND Description.store_id = '14' 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(88) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '14' 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(88) AND CategoryGroup.group_model = 'Productgroup' AND Description.store_id = '14' 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(88) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '14' 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(88) AND CategoryGroup.group_model = 'Productgroup' AND Description.store_id = '14' 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(88) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '14' AND Description.group_model = 'Bundle' AND hidden = '' AND GroupAttribute_8.storeattribute_option_id = '136' 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(88) AND CategoryGroup.group_model = 'Productgroup' AND Description.store_id = '14' 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(88) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '14' AND Description.group_model = 'Bundle' AND hidden = '' AND GroupAttribute_8.storeattribute_option_id = '137' 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(88) AND CategoryGroup.group_model = 'Productgroup' AND Description.store_id = '14' 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(88) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '14' AND Description.group_model = 'Bundle' AND hidden = '' AND GroupAttribute_8.storeattribute_option_id = '138' AND GroupAttribute_8.group_model = 'Bundle') as attributes | 1 | 1 | 1 | |
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(88) AND CategoryGroup.group_model = 'Productgroup' AND Description.store_id = '14' 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(88) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '14' AND Description.group_model = 'Bundle' AND hidden = '') as prices | 1 | 1 | 11 | maybe slow |
SELECT `HourException`.`id`, `HourException`.`date`, `HourException`.`start`, `HourException`.`end`, `HourException`.`closed`, `HourException`.`store_location_id` FROM `tbiback_tbshops`.`hour_exceptions` AS `HourException` WHERE `date` = '2024-03-19' 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` = '2024-03-19' 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` = '2024-03-19' 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` = '2024-03-19' 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` = 'trampolinesonline.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` = (14) | 18 | 18 | 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` = 14 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` = (11) | 4 | 4 | 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` <= '2024-03-19' AND `end` >= '2024-03-19' AND `store_id` IN (0, 14) 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://trampolinesonline.be/nld/category/88/veiligheidsnet-trampolines' AND `store_id` = 14 LIMIT 1 | 0 | 0 | 0 | |