- Home
- Poker Sets
- Budget Poker Sets
- Deluxe Poker Sets
- Exclusieve Poker Sets
- Pokerset 200
- Pokerset 300
- Pokerset 500
- Pokerset 750
- Pokerset 1000
- Reissets Poker
- Lege Pokerkoffers
- Poker Chips
- Monte Carlo Chip Series
- 12 Star Clay Series
- Caesar Poker Club Series
- Cartamundi Diamond Series
- Pokertafels
- Pokerkaarten
-
Caesar Poker Club Series
Items 1 tot 7 van 7 in totaalItems 1 tot 7 van 7 in totaal
-
- History
-
Sqllog +
Sql Logs
default
Total Time: 135 ms
Total Queries: 75 queriesQuery 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` = 'pokerhandel.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` = (10) 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-02-08' LIMIT 1 0 0 0 SELECT `Hour`.`id`, `Hour`.`weekday`, `Hour`.`start`, `Hour`.`end`, `Hour`.`closed` FROM `tbiback_tbshops`.`hours` AS `Hour` WHERE `weekday` = 3 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-02-08' LIMIT 1 0 0 0 SELECT `Hour`.`id`, `Hour`.`weekday`, `Hour`.`start`, `Hour`.`end`, `Hour`.`closed` FROM `tbiback_tbshops`.`hours` AS `Hour` WHERE `weekday` = 3 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-02-08' LIMIT 1 0 0 0 SELECT `Hour`.`id`, `Hour`.`weekday`, `Hour`.`start`, `Hour`.`end`, `Hour`.`closed` FROM `tbiback_tbshops`.`hours` AS `Hour` WHERE `weekday` = 3 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-02-09' LIMIT 1 0 0 0 SELECT `Hour`.`id`, `Hour`.`weekday`, `Hour`.`start`, `Hour`.`end`, `Hour`.`closed` FROM `tbiback_tbshops`.`hours` AS `Hour` WHERE `weekday` = 4 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-02-09' LIMIT 1 0 0 0 SELECT `Hour`.`id`, `Hour`.`weekday`, `Hour`.`start`, `Hour`.`end`, `Hour`.`closed` FROM `tbiback_tbshops`.`hours` AS `Hour` WHERE `weekday` = 4 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` = 'pokerhandel.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` = (10) 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` = 10 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` = (8) 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-02-08' AND `end` >= '2023-02-08' AND `store_id` IN (0, 10) 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` = 'https://pokerhandel.be/nld/category/80/deluxe-pokerchips/caesar-poker-club-series' AND `store_id` = 10 LIMIT 1 0 0 0 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` = 'ce9bgnsn90a1tvfete2iim3ej4' 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` = 80 AND `Category`.`store_id` = 10 LIMIT 1 1 1 3 maybe slow SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`sorting`, `ParentCategory`.`topmenu`, `ParentCategory`.`store_id` FROM `tbiback_tbshops`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 40 1 1 0 SELECT `ChildCategory`.`id`, `ChildCategory`.`parent_id` FROM `tbiback_tbshops`.`categories` AS `ChildCategory` WHERE `ChildCategory`.`parent_id` = (80) 0 0 0 SELECT `ParentCategory`.`id`, (`I18n__name__nld`.`content`) AS `ParentCategory__i18n_name_nld`, (`I18n__slug__nld`.`content`) AS `ParentCategory__i18n_slug_nld`, (`I18n__description__nld`.`content`) AS `ParentCategory__i18n_description_nld`, (`I18n__description_short__nld`.`content`) AS `ParentCategory__i18n_description_short_nld`, (`I18n__path__nld`.`content`) AS `ParentCategory__i18n_path_nld`, (`I18n__pagetitle__nld`.`content`) AS `ParentCategory__i18n_pagetitle_nld` FROM `tbiback_tbshops`.`categories` AS `ParentCategory` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__nld` ON (`ParentCategory`.`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 (`ParentCategory`.`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 (`ParentCategory`.`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 (`ParentCategory`.`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 (`ParentCategory`.`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 (`ParentCategory`.`id` = `I18n__pagetitle__nld`.`foreign_key` AND `I18n__pagetitle__nld`.`model` = 'Category' AND `I18n__pagetitle__nld`.`field` = 'pagetitle' AND `I18n__pagetitle__nld`.`locale` = 'nld') WHERE `ParentCategory`.`id` = 40 AND `ParentCategory`.`store_id` = 10 LIMIT 1 1 1 3 maybe slow SELECT `ParentCategory`.`id`, (`I18n__name__nld`.`content`) AS `ParentCategory__i18n_name_nld`, (`I18n__slug__nld`.`content`) AS `ParentCategory__i18n_slug_nld`, (`I18n__description__nld`.`content`) AS `ParentCategory__i18n_description_nld`, (`I18n__description_short__nld`.`content`) AS `ParentCategory__i18n_description_short_nld`, (`I18n__path__nld`.`content`) AS `ParentCategory__i18n_path_nld`, (`I18n__pagetitle__nld`.`content`) AS `ParentCategory__i18n_pagetitle_nld` FROM `tbiback_tbshops`.`categories` AS `ParentCategory` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__nld` ON (`ParentCategory`.`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 (`ParentCategory`.`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 (`ParentCategory`.`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 (`ParentCategory`.`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 (`ParentCategory`.`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 (`ParentCategory`.`id` = `I18n__pagetitle__nld`.`foreign_key` AND `I18n__pagetitle__nld`.`model` = 'Category' AND `I18n__pagetitle__nld`.`field` = 'pagetitle' AND `I18n__pagetitle__nld`.`locale` = 'nld') WHERE `ParentCategory`.`id` = 56 AND `ParentCategory`.`store_id` = 10 LIMIT 1 1 1 3 maybe slow SELECT `Category`.`parent_id` FROM `tbiback_tbshops`.`categories` AS `Category` WHERE `Category`.`id` = 80 AND `Category`.`store_id` = 10 LIMIT 1 1 1 0 SELECT `Category`.`parent_id` FROM `tbiback_tbshops`.`categories` AS `Category` WHERE `Category`.`id` = 56 AND `Category`.`store_id` = 10 LIMIT 1 1 1 0 SELECT `Category`.`parent_id` FROM `tbiback_tbshops`.`categories` AS `Category` WHERE `Category`.`id` = 40 AND `Category`.`store_id` = 10 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` = 40 AND `Category`.`store_id` = 10 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, 80) 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(80) AND CategoryGroup.group_model = 'Productgroup' AND Description.store_id = '10' 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(80) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '10' AND Description.group_model = 'Bundle' AND hidden = '' ORDER BY name asc LIMIT 0, 24 7 7 13 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` = 302 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` = (302) ORDER BY `sorting` ASC 2 2 2 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` = 440 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` = 305 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` = (305) ORDER BY `sorting` ASC 2 2 2 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` = 443 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` = 307 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` = (307) ORDER BY `sorting` ASC 2 2 2 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` = 445 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` = 304 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` = (304) ORDER BY `sorting` ASC 2 2 2 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` = 442 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` = 303 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` = (303) ORDER BY `sorting` ASC 2 2 2 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` = 441 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` = 306 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` = (306) ORDER BY `sorting` ASC 2 2 2 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` = 444 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` = 308 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` = (308) ORDER BY `sorting` ASC 2 2 2 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` = 446 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(80) AND CategoryGroup.group_model = 'Productgroup' AND Description.store_id = '10' 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(80) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '10' AND Description.group_model = 'Bundle' AND hidden = '' ORDER BY name asc ) as groups 1 1 12 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(80) AND CategoryGroup.group_model = 'Productgroup' AND Description.store_id = '10' 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(80) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '10' 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(80) AND CategoryGroup.group_model = 'Productgroup' AND Description.store_id = '10' 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(80) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '10' 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(80) AND CategoryGroup.group_model = 'Productgroup' AND Description.store_id = '10' 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(80) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '10' 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(80) AND CategoryGroup.group_model = 'Productgroup' AND Description.store_id = '10' 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(80) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '10' 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(80) AND CategoryGroup.group_model = 'Productgroup' AND Description.store_id = '10' 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(80) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '10' 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(80) AND CategoryGroup.group_model = 'Productgroup' AND Description.store_id = '10' 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(80) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '10' 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(80) AND CategoryGroup.group_model = 'Productgroup' AND Description.store_id = '10' 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(80) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '10' 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(80) AND CategoryGroup.group_model = 'Productgroup' AND Description.store_id = '10' 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(80) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '10' 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(80) AND CategoryGroup.group_model = 'Productgroup' AND Description.store_id = '10' 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(80) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '10' 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(80) AND CategoryGroup.group_model = 'Productgroup' AND Description.store_id = '10' 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(80) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '10' 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(80) AND CategoryGroup.group_model = 'Productgroup' AND Description.store_id = '10' 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(80) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '10' 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(80) AND CategoryGroup.group_model = 'Productgroup' AND Description.store_id = '10' 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(80) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '10' 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(80) AND CategoryGroup.group_model = 'Productgroup' AND Description.store_id = '10' 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(80) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '10' 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(80) AND CategoryGroup.group_model = 'Productgroup' AND Description.store_id = '10' 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(80) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '10' 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(80) AND CategoryGroup.group_model = 'Productgroup' AND Description.store_id = '10' 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(80) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '10' 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(80) AND CategoryGroup.group_model = 'Productgroup' AND Description.store_id = '10' 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(80) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '10' AND Description.group_model = 'Bundle' AND hidden = '') as prices 1 1 11 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(80) AND CategoryGroup.group_model = 'Productgroup' AND Description.store_id = '10' 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(80) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '10' AND Description.group_model = 'Bundle' AND hidden = '' GROUP BY Brand.id) as Brand GROUP BY Brand.id ORDER BY name 0 0 11 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` = 80 AND `Category`.`store_id` = 10 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` = 80 AND `Category`.`store_id` = 10 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` = 80 AND `Category`.`store_id` = 10 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` = 80 AND `Category`.`store_id` = 10 LIMIT 1 1 1 0 Query Explain:
==== -
Timer +
Memory
Peak Memory Use 18.69 MB
Message Memory use Component initialization 8.40 MB Controller action start 10.95 MB Controller render start 12.29 MB View render complete 14.82 MB Timers
Total Request Time: 440 (ms)
Message Time in ms Graph Core Processing (Derived from $_SERVER["REQUEST_TIME"]) 80.25 Event: Controller.initialize 35.56 Event: Controller.startup 1.36 Controller action 188.78 Event: Controller.beforeRender 13.92 » Processing toolbar data 13.25 Rendering View 51.09 » Event: View.beforeRender 0.06 » Rendering APP/View/Categories/view.ctp 16.39 » » Rendering APP/View/Themed/Pokerhandel/Elements/catalog/sidebar.ctp 4.66 » » » Rendering APP/View/Elements/catalog/filter-price.ctp 0.41 » » Rendering APP/View/Themed/Pokerhandel/Elements/layout/sidebar.ctp #2 14.13 » » » » Rendering APP/View/Elements/stores/pokerhandel/troeven.ctp 0.21 » » » Rendering APP/View/Themed/Pokerhandel/Elements/catalog/toolbar.ctp 2.02 » » » » Rendering APP/View/Elements/pagination_frontend.ctp 0.32 » » » Rendering APP/View/Themed/Pokerhandel/Elements/group/group-item.ctp 0.81 » » » Rendering APP/View/Themed/Pokerhandel/Elements/group/group-item.ctp #2 0.63 » » » Rendering APP/View/Themed/Pokerhandel/Elements/group/group-item.ctp #3 0.60 » » » Rendering APP/View/Themed/Pokerhandel/Elements/group/group-item.ctp #4 0.61 » » » Rendering APP/View/Themed/Pokerhandel/Elements/group/group-item.ctp #5 0.64 » » » Rendering APP/View/Themed/Pokerhandel/Elements/group/group-item.ctp #6 0.59 » » » Rendering APP/View/Themed/Pokerhandel/Elements/group/group-item.ctp #7 0.59 » » » Rendering APP/View/Themed/Pokerhandel/Elements/catalog/toolbar.ctp #2 1.86 » » » » Rendering APP/View/Elements/pagination_frontend.ctp #2 0.25 » Event: View.afterRender 0.04 » Event: View.beforeLayout 0.04 » Rendering APP/View/Layouts/default.ctp 15.66 » » Rendering APP/View/Elements/layout/facebook-jssdk.ctp 0.18 » » Rendering APP/View/Themed/Pokerhandel/Elements/layout/top-section.ctp 3.81 » » Rendering APP/View/Themed/Pokerhandel/Elements/layout/branding.ctp 0.98 » » Rendering APP/View/Themed/Pokerhandel/Elements/layout/main-nav.ctp 2.18 » » Rendering APP/View/Elements/layout/top-notice.ctp 0.21 » » Rendering APP/View/Elements/layout/content.ctp 1.79 » » » Rendering APP/View/Themed/Pokerhandel/Elements/layout/breadcrumbs.ctp 1.43 » » Rendering APP/View/Themed/Pokerhandel/Elements/layout/footer.ctp 0.58 » » Rendering APP/View/Themed/Pokerhandel/Elements/banners/footer.ctp #2 1.67 » » » Rendering APP/View/Elements/layout/footer-hours.ctp 0.36 » » » Rendering APP/View/Elements/layout/footer-contact.ctp 0.17 Event: View.afterLayout 0.00 ====
-
-
