- Home
- Poker Sets
- Budget Poker Sets
- Deluxe Poker Sets
- Exclusive Poker Sets
- Poker Set 200
- Poker Set 300
- Poker Set 500
- Poker Set 750
- Poker Set 1000
- Travel Sets Poker
- Empty Poker Cases
- Poker Chips
- Monte Carlo Chip Series
- 12 Star Clay Series
- Caesar Poker Club Series
- Cartamundi Diamond Series
- Poker Tables
- Pokerkaarten
-
Plastic Playing Cards
If you're going to have a serious home poker game, you're going to want to invest in a deck of high quality 100% plastic playing cards, as they will not only last longer, they'll also feel better. We sell a large variety of brands in plastic cards including some of the most prominent brands like Modiano, KEM, COPAG, Bicycle and Fournier.
With prices starting at around €5 it's definately worth the investment to upgrade your home game!Items 1 to 24 of 37 totalItems 1 to 24 of 37 total
-
- History
-
Sqllog +
Sql Logs
default
Total Time: 431 ms
Total Queries: 110 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-03-30' LIMIT 1 0 0 0 SELECT `Hour`.`id`, `Hour`.`weekday`, `Hour`.`start`, `Hour`.`end`, `Hour`.`closed` FROM `tbiback_tbshops`.`hours` AS `Hour` WHERE `weekday` = 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-03-30' LIMIT 1 0 0 0 SELECT `Hour`.`id`, `Hour`.`weekday`, `Hour`.`start`, `Hour`.`end`, `Hour`.`closed` FROM `tbiback_tbshops`.`hours` AS `Hour` WHERE `weekday` = 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-03-30' LIMIT 1 0 0 0 SELECT `Hour`.`id`, `Hour`.`weekday`, `Hour`.`start`, `Hour`.`end`, `Hour`.`closed` FROM `tbiback_tbshops`.`hours` AS `Hour` WHERE `weekday` = 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-03-31' LIMIT 1 0 0 0 SELECT `Hour`.`id`, `Hour`.`weekday`, `Hour`.`start`, `Hour`.`end`, `Hour`.`closed` FROM `tbiback_tbshops`.`hours` AS `Hour` WHERE `weekday` = 5 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-03-31' LIMIT 1 0 0 0 SELECT `Hour`.`id`, `Hour`.`weekday`, `Hour`.`start`, `Hour`.`end`, `Hour`.`closed` FROM `tbiback_tbshops`.`hours` AS `Hour` WHERE `weekday` = 5 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__eng`.`content`) AS `Store__i18n_homepagetitle_eng`, (`I18n__homepagetitle__nld`.`content`) AS `Store__i18n_homepagetitle_nld`, (`I18n__homepagedescription__eng`.`content`) AS `Store__i18n_homepagedescription_eng`, (`I18n__homepagedescription__nld`.`content`) AS `Store__i18n_homepagedescription_nld`, (`I18n__homepage_footer__eng`.`content`) AS `Store__i18n_homepage_footer_eng`, (`I18n__homepage_footer__nld`.`content`) AS `Store__i18n_homepage_footer_nld`, (`I18n__homepage_content__eng`.`content`) AS `Store__i18n_homepage_content_eng`, (`I18n__homepage_content__nld`.`content`) AS `Store__i18n_homepage_content_nld`, (`I18n__header_points__eng`.`content`) AS `Store__i18n_header_points_eng`, (`I18n__header_points__nld`.`content`) AS `Store__i18n_header_points_nld`, (`I18n__footer_blocks__eng`.`content`) AS `Store__i18n_footer_blocks_eng`, (`I18n__footer_blocks__nld`.`content`) AS `Store__i18n_footer_blocks_nld`, (`I18n__sidebar_content__eng`.`content`) AS `Store__i18n_sidebar_content_eng`, (`I18n__sidebar_content__nld`.`content`) AS `Store__i18n_sidebar_content_nld`, (`I18n__disable_checkout_msg__eng`.`content`) AS `Store__i18n_disable_checkout_msg_eng`, (`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__eng` ON (`Store`.`id` = `I18n__homepagetitle__eng`.`foreign_key` AND `I18n__homepagetitle__eng`.`model` = 'Store' AND `I18n__homepagetitle__eng`.`field` = 'homepagetitle' AND `I18n__homepagetitle__eng`.`locale` = 'eng') 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__eng` ON (`Store`.`id` = `I18n__homepagedescription__eng`.`foreign_key` AND `I18n__homepagedescription__eng`.`model` = 'Store' AND `I18n__homepagedescription__eng`.`field` = 'homepagedescription' AND `I18n__homepagedescription__eng`.`locale` = 'eng') 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__eng` ON (`Store`.`id` = `I18n__homepage_footer__eng`.`foreign_key` AND `I18n__homepage_footer__eng`.`model` = 'Store' AND `I18n__homepage_footer__eng`.`field` = 'homepage_footer' AND `I18n__homepage_footer__eng`.`locale` = 'eng') 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__eng` ON (`Store`.`id` = `I18n__homepage_content__eng`.`foreign_key` AND `I18n__homepage_content__eng`.`model` = 'Store' AND `I18n__homepage_content__eng`.`field` = 'homepage_content' AND `I18n__homepage_content__eng`.`locale` = 'eng') 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__eng` ON (`Store`.`id` = `I18n__header_points__eng`.`foreign_key` AND `I18n__header_points__eng`.`model` = 'Store' AND `I18n__header_points__eng`.`field` = 'header_points' AND `I18n__header_points__eng`.`locale` = 'eng') 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__eng` ON (`Store`.`id` = `I18n__footer_blocks__eng`.`foreign_key` AND `I18n__footer_blocks__eng`.`model` = 'Store' AND `I18n__footer_blocks__eng`.`field` = 'footer_blocks' AND `I18n__footer_blocks__eng`.`locale` = 'eng') 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__eng` ON (`Store`.`id` = `I18n__sidebar_content__eng`.`foreign_key` AND `I18n__sidebar_content__eng`.`model` = 'Store' AND `I18n__sidebar_content__eng`.`field` = 'sidebar_content' AND `I18n__sidebar_content__eng`.`locale` = 'eng') 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__eng` ON (`Store`.`id` = `I18n__disable_checkout_msg__eng`.`foreign_key` AND `I18n__disable_checkout_msg__eng`.`model` = 'Store' AND `I18n__disable_checkout_msg__eng`.`field` = 'disable_checkout_msg' AND `I18n__disable_checkout_msg__eng`.`locale` = 'eng') 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 7 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` = (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__eng`.`content`) AS `Message__i18n_message_eng`, (`I18n__message__nld`.`content`) AS `Message__i18n_message_nld` FROM `tbiback_tbshops`.`messages` AS `Message` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__message__eng` ON (`Message`.`id` = `I18n__message__eng`.`foreign_key` AND `I18n__message__eng`.`model` = 'Message' AND `I18n__message__eng`.`field` = 'message' AND `I18n__message__eng`.`locale` = 'eng') 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-03-30' AND `end` >= '2023-03-30' 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` = 'http://www.pokerhandel.be/eng/category/63/pokercards/plastic-playing-cards' 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` = 'm4un0fc580kkt755cf751i8rj6' AND `qty` > 0 0 0 0 SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`sorting`, `Category`.`topmenu`, `Category`.`store_id`, (`I18n__name__eng`.`content`) AS `Category__i18n_name_eng`, (`I18n__name__nld`.`content`) AS `Category__i18n_name_nld`, (`I18n__slug__eng`.`content`) AS `Category__i18n_slug_eng`, (`I18n__slug__nld`.`content`) AS `Category__i18n_slug_nld`, (`I18n__description__eng`.`content`) AS `Category__i18n_description_eng`, (`I18n__description__nld`.`content`) AS `Category__i18n_description_nld`, (`I18n__description_short__eng`.`content`) AS `Category__i18n_description_short_eng`, (`I18n__description_short__nld`.`content`) AS `Category__i18n_description_short_nld`, (`I18n__path__eng`.`content`) AS `Category__i18n_path_eng`, (`I18n__path__nld`.`content`) AS `Category__i18n_path_nld`, (`I18n__pagetitle__eng`.`content`) AS `Category__i18n_pagetitle_eng`, (`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__eng` ON (`Category`.`id` = `I18n__name__eng`.`foreign_key` AND `I18n__name__eng`.`model` = 'Category' AND `I18n__name__eng`.`field` = 'name' AND `I18n__name__eng`.`locale` = 'eng') 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__eng` ON (`Category`.`id` = `I18n__slug__eng`.`foreign_key` AND `I18n__slug__eng`.`model` = 'Category' AND `I18n__slug__eng`.`field` = 'slug' AND `I18n__slug__eng`.`locale` = 'eng') 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__eng` ON (`Category`.`id` = `I18n__description__eng`.`foreign_key` AND `I18n__description__eng`.`model` = 'Category' AND `I18n__description__eng`.`field` = 'description' AND `I18n__description__eng`.`locale` = 'eng') 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__eng` ON (`Category`.`id` = `I18n__description_short__eng`.`foreign_key` AND `I18n__description_short__eng`.`model` = 'Category' AND `I18n__description_short__eng`.`field` = 'description_short' AND `I18n__description_short__eng`.`locale` = 'eng') 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__eng` ON (`Category`.`id` = `I18n__path__eng`.`foreign_key` AND `I18n__path__eng`.`model` = 'Category' AND `I18n__path__eng`.`field` = 'path' AND `I18n__path__eng`.`locale` = 'eng') 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__eng` ON (`Category`.`id` = `I18n__pagetitle__eng`.`foreign_key` AND `I18n__pagetitle__eng`.`model` = 'Category' AND `I18n__pagetitle__eng`.`field` = 'pagetitle' AND `I18n__pagetitle__eng`.`locale` = 'eng') 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` = 63 AND `Category`.`store_id` = 10 LIMIT 1 1 1 7 maybe slow SELECT `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`sorting`, `ParentCategory`.`topmenu`, `ParentCategory`.`store_id` FROM `tbiback_tbshops`.`categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 0 0 0 0 SELECT `ChildCategory`.`id`, `ChildCategory`.`parent_id` FROM `tbiback_tbshops`.`categories` AS `ChildCategory` WHERE `ChildCategory`.`parent_id` = (63) 0 0 0 SELECT `ParentCategory`.`id`, (`I18n__name__eng`.`content`) AS `ParentCategory__i18n_name_eng`, (`I18n__name__nld`.`content`) AS `ParentCategory__i18n_name_nld`, (`I18n__slug__eng`.`content`) AS `ParentCategory__i18n_slug_eng`, (`I18n__slug__nld`.`content`) AS `ParentCategory__i18n_slug_nld`, (`I18n__description__eng`.`content`) AS `ParentCategory__i18n_description_eng`, (`I18n__description__nld`.`content`) AS `ParentCategory__i18n_description_nld`, (`I18n__description_short__eng`.`content`) AS `ParentCategory__i18n_description_short_eng`, (`I18n__description_short__nld`.`content`) AS `ParentCategory__i18n_description_short_nld`, (`I18n__path__eng`.`content`) AS `ParentCategory__i18n_path_eng`, (`I18n__path__nld`.`content`) AS `ParentCategory__i18n_path_nld`, (`I18n__pagetitle__eng`.`content`) AS `ParentCategory__i18n_pagetitle_eng`, (`I18n__pagetitle__nld`.`content`) AS `ParentCategory__i18n_pagetitle_nld` FROM `tbiback_tbshops`.`categories` AS `ParentCategory` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__eng` ON (`ParentCategory`.`id` = `I18n__name__eng`.`foreign_key` AND `I18n__name__eng`.`model` = 'Category' AND `I18n__name__eng`.`field` = 'name' AND `I18n__name__eng`.`locale` = 'eng') 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__eng` ON (`ParentCategory`.`id` = `I18n__slug__eng`.`foreign_key` AND `I18n__slug__eng`.`model` = 'Category' AND `I18n__slug__eng`.`field` = 'slug' AND `I18n__slug__eng`.`locale` = 'eng') 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__eng` ON (`ParentCategory`.`id` = `I18n__description__eng`.`foreign_key` AND `I18n__description__eng`.`model` = 'Category' AND `I18n__description__eng`.`field` = 'description' AND `I18n__description__eng`.`locale` = 'eng') 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__eng` ON (`ParentCategory`.`id` = `I18n__description_short__eng`.`foreign_key` AND `I18n__description_short__eng`.`model` = 'Category' AND `I18n__description_short__eng`.`field` = 'description_short' AND `I18n__description_short__eng`.`locale` = 'eng') 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__eng` ON (`ParentCategory`.`id` = `I18n__path__eng`.`foreign_key` AND `I18n__path__eng`.`model` = 'Category' AND `I18n__path__eng`.`field` = 'path' AND `I18n__path__eng`.`locale` = 'eng') 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__eng` ON (`ParentCategory`.`id` = `I18n__pagetitle__eng`.`foreign_key` AND `I18n__pagetitle__eng`.`model` = 'Category' AND `I18n__pagetitle__eng`.`field` = 'pagetitle' AND `I18n__pagetitle__eng`.`locale` = 'eng') 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` = 42 AND `ParentCategory`.`store_id` = 10 LIMIT 1 1 1 5 maybe slow SELECT `Category`.`parent_id` FROM `tbiback_tbshops`.`categories` AS `Category` WHERE `Category`.`id` = 63 AND `Category`.`store_id` = 10 LIMIT 1 1 1 0 SELECT `Category`.`parent_id` FROM `tbiback_tbshops`.`categories` AS `Category` WHERE `Category`.`id` = 42 AND `Category`.`store_id` = 10 LIMIT 1 1 1 0 SELECT `Category`.`id`, (`I18n__slug__eng`.`content`) AS `Category__i18n_slug_eng`, (`I18n__slug__nld`.`content`) AS `Category__i18n_slug_nld` FROM `tbiback_tbshops`.`categories` AS `Category` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__slug__eng` ON (`Category`.`id` = `I18n__slug__eng`.`foreign_key` AND `I18n__slug__eng`.`model` = 'Category' AND `I18n__slug__eng`.`field` = 'slug' AND `I18n__slug__eng`.`locale` = 'eng') 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` = 42 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, 63) 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` = 'eng' 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` = 'eng' AND `StoreattributeOption`.`storeattribute_id` = (8) ORDER BY `id` asc 0 0 0 SELECT 'Productgroup' as model, Productgroup.id, promoprice, created, I18n__name__eng.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__eng ON (Productgroup.id = I18n__name__eng.foreign_key AND I18n__name__eng.model = 'Productgroup' AND I18n__name__eng.field = 'name' AND I18n__name__eng.locale = 'eng') WHERE CategoryGroup.category_id IN(63) 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__eng.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__eng ON (Bundle.id = I18n__name__eng.foreign_key AND I18n__name__eng.model = 'Bundle' AND I18n__name__eng.field = 'name' AND I18n__name__eng.locale = 'eng') WHERE CategoryGroup.category_id IN(63) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '10' AND Description.group_model = 'Bundle' AND hidden = '' ORDER BY name asc LIMIT 0, 24 24 24 22 maybe slow SELECT `Productgroup`.`id`, `Productgroup`.`promoprice`, `Productgroup`.`wholesaleprice`, `Productgroup`.`price`, `Description`.`id`, (`I18n__name__eng`.`content`) AS `Productgroup__i18n_name_eng`, (`I18n__name__nld`.`content`) AS `Productgroup__i18n_name_nld`, (`I18n__slug__eng`.`content`) AS `Productgroup__i18n_slug_eng`, (`I18n__slug__nld`.`content`) AS `Productgroup__i18n_slug_nld` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__eng` ON (`Productgroup`.`id` = `I18n__name__eng`.`foreign_key` AND `I18n__name__eng`.`model` = 'Productgroup' AND `I18n__name__eng`.`field` = 'name' AND `I18n__name__eng`.`locale` = 'eng') 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__eng` ON (`Productgroup`.`id` = `I18n__slug__eng`.`foreign_key` AND `I18n__slug__eng`.`model` = 'Productgroup' AND `I18n__slug__eng`.`field` = 'slug' AND `I18n__slug__eng`.`locale` = 'eng') 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` = 174 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` = (174) ORDER BY `sorting` ASC 1 1 1 SELECT `Description`.`id`, (`I18n__description_short__eng`.`content`) AS `Description__i18n_description_short_eng`, (`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__eng` ON (`Description`.`id` = `I18n__description_short__eng`.`foreign_key` AND `I18n__description_short__eng`.`model` = 'Description' AND `I18n__description_short__eng`.`field` = 'description_short' AND `I18n__description_short__eng`.`locale` = 'eng') 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` = 312 LIMIT 1 1 1 1 SELECT `Productgroup`.`id`, `Productgroup`.`promoprice`, `Productgroup`.`wholesaleprice`, `Productgroup`.`price`, `Description`.`id`, (`I18n__name__eng`.`content`) AS `Productgroup__i18n_name_eng`, (`I18n__name__nld`.`content`) AS `Productgroup__i18n_name_nld`, (`I18n__slug__eng`.`content`) AS `Productgroup__i18n_slug_eng`, (`I18n__slug__nld`.`content`) AS `Productgroup__i18n_slug_nld` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__eng` ON (`Productgroup`.`id` = `I18n__name__eng`.`foreign_key` AND `I18n__name__eng`.`model` = 'Productgroup' AND `I18n__name__eng`.`field` = 'name' AND `I18n__name__eng`.`locale` = 'eng') 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__eng` ON (`Productgroup`.`id` = `I18n__slug__eng`.`foreign_key` AND `I18n__slug__eng`.`model` = 'Productgroup' AND `I18n__slug__eng`.`field` = 'slug' AND `I18n__slug__eng`.`locale` = 'eng') 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` = 382 LIMIT 1 1 1 7 maybe slow SELECT `Image`.`id`, `Image`.`group_id`, `Image`.`group_model`, `Image`.`filename`, `Image`.`sorting`, `Image`.`variant_id`, `Image`.`created`, `Image`.`compressed` FROM `tbiback_tbshops`.`images` AS `Image` WHERE `Image`.`group_model` = 'Productgroup' AND `Image`.`group_id` = (382) ORDER BY `sorting` ASC 0 0 4 maybe slow SELECT `Description`.`id`, (`I18n__description_short__eng`.`content`) AS `Description__i18n_description_short_eng`, (`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__eng` ON (`Description`.`id` = `I18n__description_short__eng`.`foreign_key` AND `I18n__description_short__eng`.`model` = 'Description' AND `I18n__description_short__eng`.`field` = 'description_short' AND `I18n__description_short__eng`.`locale` = 'eng') 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` = 535 LIMIT 1 1 1 2 maybe slow SELECT `Productgroup`.`id`, `Productgroup`.`promoprice`, `Productgroup`.`wholesaleprice`, `Productgroup`.`price`, `Description`.`id`, (`I18n__name__eng`.`content`) AS `Productgroup__i18n_name_eng`, (`I18n__name__nld`.`content`) AS `Productgroup__i18n_name_nld`, (`I18n__slug__eng`.`content`) AS `Productgroup__i18n_slug_eng`, (`I18n__slug__nld`.`content`) AS `Productgroup__i18n_slug_nld` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__eng` ON (`Productgroup`.`id` = `I18n__name__eng`.`foreign_key` AND `I18n__name__eng`.`model` = 'Productgroup' AND `I18n__name__eng`.`field` = 'name' AND `I18n__name__eng`.`locale` = 'eng') 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__eng` ON (`Productgroup`.`id` = `I18n__slug__eng`.`foreign_key` AND `I18n__slug__eng`.`model` = 'Productgroup' AND `I18n__slug__eng`.`field` = 'slug' AND `I18n__slug__eng`.`locale` = 'eng') 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` = 390 LIMIT 1 1 1 10 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` = (390) ORDER BY `sorting` ASC 0 0 2 maybe slow SELECT `Description`.`id`, (`I18n__description_short__eng`.`content`) AS `Description__i18n_description_short_eng`, (`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__eng` ON (`Description`.`id` = `I18n__description_short__eng`.`foreign_key` AND `I18n__description_short__eng`.`model` = 'Description' AND `I18n__description_short__eng`.`field` = 'description_short' AND `I18n__description_short__eng`.`locale` = 'eng') 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` = 543 LIMIT 1 1 1 1 SELECT `Productgroup`.`id`, `Productgroup`.`promoprice`, `Productgroup`.`wholesaleprice`, `Productgroup`.`price`, `Description`.`id`, (`I18n__name__eng`.`content`) AS `Productgroup__i18n_name_eng`, (`I18n__name__nld`.`content`) AS `Productgroup__i18n_name_nld`, (`I18n__slug__eng`.`content`) AS `Productgroup__i18n_slug_eng`, (`I18n__slug__nld`.`content`) AS `Productgroup__i18n_slug_nld` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__eng` ON (`Productgroup`.`id` = `I18n__name__eng`.`foreign_key` AND `I18n__name__eng`.`model` = 'Productgroup' AND `I18n__name__eng`.`field` = 'name' AND `I18n__name__eng`.`locale` = 'eng') 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__eng` ON (`Productgroup`.`id` = `I18n__slug__eng`.`foreign_key` AND `I18n__slug__eng`.`model` = 'Productgroup' AND `I18n__slug__eng`.`field` = 'slug' AND `I18n__slug__eng`.`locale` = 'eng') 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` = 426 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` = (426) ORDER BY `sorting` ASC 1 1 2 maybe slow SELECT `Description`.`id`, (`I18n__description_short__eng`.`content`) AS `Description__i18n_description_short_eng`, (`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__eng` ON (`Description`.`id` = `I18n__description_short__eng`.`foreign_key` AND `I18n__description_short__eng`.`model` = 'Description' AND `I18n__description_short__eng`.`field` = 'description_short' AND `I18n__description_short__eng`.`locale` = 'eng') 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` = 582 LIMIT 1 1 1 3 maybe slow SELECT `Productgroup`.`id`, `Productgroup`.`promoprice`, `Productgroup`.`wholesaleprice`, `Productgroup`.`price`, `Description`.`id`, (`I18n__name__eng`.`content`) AS `Productgroup__i18n_name_eng`, (`I18n__name__nld`.`content`) AS `Productgroup__i18n_name_nld`, (`I18n__slug__eng`.`content`) AS `Productgroup__i18n_slug_eng`, (`I18n__slug__nld`.`content`) AS `Productgroup__i18n_slug_nld` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__eng` ON (`Productgroup`.`id` = `I18n__name__eng`.`foreign_key` AND `I18n__name__eng`.`model` = 'Productgroup' AND `I18n__name__eng`.`field` = 'name' AND `I18n__name__eng`.`locale` = 'eng') 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__eng` ON (`Productgroup`.`id` = `I18n__slug__eng`.`foreign_key` AND `I18n__slug__eng`.`model` = 'Productgroup' AND `I18n__slug__eng`.`field` = 'slug' AND `I18n__slug__eng`.`locale` = 'eng') 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` = 434 LIMIT 1 1 1 10 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` = (434) ORDER BY `sorting` ASC 0 0 2 maybe slow SELECT `Description`.`id`, (`I18n__description_short__eng`.`content`) AS `Description__i18n_description_short_eng`, (`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__eng` ON (`Description`.`id` = `I18n__description_short__eng`.`foreign_key` AND `I18n__description_short__eng`.`model` = 'Description' AND `I18n__description_short__eng`.`field` = 'description_short' AND `I18n__description_short__eng`.`locale` = 'eng') 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` = 590 LIMIT 1 1 1 1 SELECT `Productgroup`.`id`, `Productgroup`.`promoprice`, `Productgroup`.`wholesaleprice`, `Productgroup`.`price`, `Description`.`id`, (`I18n__name__eng`.`content`) AS `Productgroup__i18n_name_eng`, (`I18n__name__nld`.`content`) AS `Productgroup__i18n_name_nld`, (`I18n__slug__eng`.`content`) AS `Productgroup__i18n_slug_eng`, (`I18n__slug__nld`.`content`) AS `Productgroup__i18n_slug_nld` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__eng` ON (`Productgroup`.`id` = `I18n__name__eng`.`foreign_key` AND `I18n__name__eng`.`model` = 'Productgroup' AND `I18n__name__eng`.`field` = 'name' AND `I18n__name__eng`.`locale` = 'eng') 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__eng` ON (`Productgroup`.`id` = `I18n__slug__eng`.`foreign_key` AND `I18n__slug__eng`.`model` = 'Productgroup' AND `I18n__slug__eng`.`field` = 'slug' AND `I18n__slug__eng`.`locale` = 'eng') 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` = 665 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` = (665) ORDER BY `sorting` ASC 3 3 2 maybe slow SELECT `Description`.`id`, (`I18n__description_short__eng`.`content`) AS `Description__i18n_description_short_eng`, (`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__eng` ON (`Description`.`id` = `I18n__description_short__eng`.`foreign_key` AND `I18n__description_short__eng`.`model` = 'Description' AND `I18n__description_short__eng`.`field` = 'description_short' AND `I18n__description_short__eng`.`locale` = 'eng') 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` = 893 LIMIT 1 1 1 2 maybe slow SELECT `Productgroup`.`id`, `Productgroup`.`promoprice`, `Productgroup`.`wholesaleprice`, `Productgroup`.`price`, `Description`.`id`, (`I18n__name__eng`.`content`) AS `Productgroup__i18n_name_eng`, (`I18n__name__nld`.`content`) AS `Productgroup__i18n_name_nld`, (`I18n__slug__eng`.`content`) AS `Productgroup__i18n_slug_eng`, (`I18n__slug__nld`.`content`) AS `Productgroup__i18n_slug_nld` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__eng` ON (`Productgroup`.`id` = `I18n__name__eng`.`foreign_key` AND `I18n__name__eng`.`model` = 'Productgroup' AND `I18n__name__eng`.`field` = 'name' AND `I18n__name__eng`.`locale` = 'eng') 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__eng` ON (`Productgroup`.`id` = `I18n__slug__eng`.`foreign_key` AND `I18n__slug__eng`.`model` = 'Productgroup' AND `I18n__slug__eng`.`field` = 'slug' AND `I18n__slug__eng`.`locale` = 'eng') 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` = 203 LIMIT 1 1 1 14 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` = (203) ORDER BY `sorting` ASC 5 5 2 maybe slow SELECT `Description`.`id`, (`I18n__description_short__eng`.`content`) AS `Description__i18n_description_short_eng`, (`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__eng` ON (`Description`.`id` = `I18n__description_short__eng`.`foreign_key` AND `I18n__description_short__eng`.`model` = 'Description' AND `I18n__description_short__eng`.`field` = 'description_short' AND `I18n__description_short__eng`.`locale` = 'eng') 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` = 341 LIMIT 1 1 1 1 SELECT `Productgroup`.`id`, `Productgroup`.`promoprice`, `Productgroup`.`wholesaleprice`, `Productgroup`.`price`, `Description`.`id`, (`I18n__name__eng`.`content`) AS `Productgroup__i18n_name_eng`, (`I18n__name__nld`.`content`) AS `Productgroup__i18n_name_nld`, (`I18n__slug__eng`.`content`) AS `Productgroup__i18n_slug_eng`, (`I18n__slug__nld`.`content`) AS `Productgroup__i18n_slug_nld` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__eng` ON (`Productgroup`.`id` = `I18n__name__eng`.`foreign_key` AND `I18n__name__eng`.`model` = 'Productgroup' AND `I18n__name__eng`.`field` = 'name' AND `I18n__name__eng`.`locale` = 'eng') 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__eng` ON (`Productgroup`.`id` = `I18n__slug__eng`.`foreign_key` AND `I18n__slug__eng`.`model` = 'Productgroup' AND `I18n__slug__eng`.`field` = 'slug' AND `I18n__slug__eng`.`locale` = 'eng') 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` = 178 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` = (178) ORDER BY `sorting` ASC 6 6 2 maybe slow SELECT `Description`.`id`, (`I18n__description_short__eng`.`content`) AS `Description__i18n_description_short_eng`, (`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__eng` ON (`Description`.`id` = `I18n__description_short__eng`.`foreign_key` AND `I18n__description_short__eng`.`model` = 'Description' AND `I18n__description_short__eng`.`field` = 'description_short' AND `I18n__description_short__eng`.`locale` = 'eng') 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` = 316 LIMIT 1 1 1 1 SELECT `Productgroup`.`id`, `Productgroup`.`promoprice`, `Productgroup`.`wholesaleprice`, `Productgroup`.`price`, `Description`.`id`, (`I18n__name__eng`.`content`) AS `Productgroup__i18n_name_eng`, (`I18n__name__nld`.`content`) AS `Productgroup__i18n_name_nld`, (`I18n__slug__eng`.`content`) AS `Productgroup__i18n_slug_eng`, (`I18n__slug__nld`.`content`) AS `Productgroup__i18n_slug_nld` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__eng` ON (`Productgroup`.`id` = `I18n__name__eng`.`foreign_key` AND `I18n__name__eng`.`model` = 'Productgroup' AND `I18n__name__eng`.`field` = 'name' AND `I18n__name__eng`.`locale` = 'eng') 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__eng` ON (`Productgroup`.`id` = `I18n__slug__eng`.`foreign_key` AND `I18n__slug__eng`.`model` = 'Productgroup' AND `I18n__slug__eng`.`field` = 'slug' AND `I18n__slug__eng`.`locale` = 'eng') 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` = 188 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` = (188) ORDER BY `sorting` ASC 4 4 2 maybe slow SELECT `Description`.`id`, (`I18n__description_short__eng`.`content`) AS `Description__i18n_description_short_eng`, (`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__eng` ON (`Description`.`id` = `I18n__description_short__eng`.`foreign_key` AND `I18n__description_short__eng`.`model` = 'Description' AND `I18n__description_short__eng`.`field` = 'description_short' AND `I18n__description_short__eng`.`locale` = 'eng') 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` = 326 LIMIT 1 1 1 2 maybe slow SELECT `Productgroup`.`id`, `Productgroup`.`promoprice`, `Productgroup`.`wholesaleprice`, `Productgroup`.`price`, `Description`.`id`, (`I18n__name__eng`.`content`) AS `Productgroup__i18n_name_eng`, (`I18n__name__nld`.`content`) AS `Productgroup__i18n_name_nld`, (`I18n__slug__eng`.`content`) AS `Productgroup__i18n_slug_eng`, (`I18n__slug__nld`.`content`) AS `Productgroup__i18n_slug_nld` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__eng` ON (`Productgroup`.`id` = `I18n__name__eng`.`foreign_key` AND `I18n__name__eng`.`model` = 'Productgroup' AND `I18n__name__eng`.`field` = 'name' AND `I18n__name__eng`.`locale` = 'eng') 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__eng` ON (`Productgroup`.`id` = `I18n__slug__eng`.`foreign_key` AND `I18n__slug__eng`.`model` = 'Productgroup' AND `I18n__slug__eng`.`field` = 'slug' AND `I18n__slug__eng`.`locale` = 'eng') 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` = 184 LIMIT 1 1 1 13 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` = (184) ORDER BY `sorting` ASC 2 2 2 SELECT `Description`.`id`, (`I18n__description_short__eng`.`content`) AS `Description__i18n_description_short_eng`, (`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__eng` ON (`Description`.`id` = `I18n__description_short__eng`.`foreign_key` AND `I18n__description_short__eng`.`model` = 'Description' AND `I18n__description_short__eng`.`field` = 'description_short' AND `I18n__description_short__eng`.`locale` = 'eng') 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` = 322 LIMIT 1 1 1 1 SELECT `Productgroup`.`id`, `Productgroup`.`promoprice`, `Productgroup`.`wholesaleprice`, `Productgroup`.`price`, `Description`.`id`, (`I18n__name__eng`.`content`) AS `Productgroup__i18n_name_eng`, (`I18n__name__nld`.`content`) AS `Productgroup__i18n_name_nld`, (`I18n__slug__eng`.`content`) AS `Productgroup__i18n_slug_eng`, (`I18n__slug__nld`.`content`) AS `Productgroup__i18n_slug_nld` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__eng` ON (`Productgroup`.`id` = `I18n__name__eng`.`foreign_key` AND `I18n__name__eng`.`model` = 'Productgroup' AND `I18n__name__eng`.`field` = 'name' AND `I18n__name__eng`.`locale` = 'eng') 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__eng` ON (`Productgroup`.`id` = `I18n__slug__eng`.`foreign_key` AND `I18n__slug__eng`.`model` = 'Productgroup' AND `I18n__slug__eng`.`field` = 'slug' AND `I18n__slug__eng`.`locale` = 'eng') 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` = 186 LIMIT 1 1 1 10 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` = (186) ORDER BY `sorting` ASC 1 1 2 maybe slow SELECT `Description`.`id`, (`I18n__description_short__eng`.`content`) AS `Description__i18n_description_short_eng`, (`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__eng` ON (`Description`.`id` = `I18n__description_short__eng`.`foreign_key` AND `I18n__description_short__eng`.`model` = 'Description' AND `I18n__description_short__eng`.`field` = 'description_short' AND `I18n__description_short__eng`.`locale` = 'eng') 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` = 324 LIMIT 1 1 1 1 SELECT `Productgroup`.`id`, `Productgroup`.`promoprice`, `Productgroup`.`wholesaleprice`, `Productgroup`.`price`, `Description`.`id`, (`I18n__name__eng`.`content`) AS `Productgroup__i18n_name_eng`, (`I18n__name__nld`.`content`) AS `Productgroup__i18n_name_nld`, (`I18n__slug__eng`.`content`) AS `Productgroup__i18n_slug_eng`, (`I18n__slug__nld`.`content`) AS `Productgroup__i18n_slug_nld` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__eng` ON (`Productgroup`.`id` = `I18n__name__eng`.`foreign_key` AND `I18n__name__eng`.`model` = 'Productgroup' AND `I18n__name__eng`.`field` = 'name' AND `I18n__name__eng`.`locale` = 'eng') 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__eng` ON (`Productgroup`.`id` = `I18n__slug__eng`.`foreign_key` AND `I18n__slug__eng`.`model` = 'Productgroup' AND `I18n__slug__eng`.`field` = 'slug' AND `I18n__slug__eng`.`locale` = 'eng') 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` = 183 LIMIT 1 1 1 10 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` = (183) ORDER BY `sorting` ASC 1 1 2 maybe slow SELECT `Description`.`id`, (`I18n__description_short__eng`.`content`) AS `Description__i18n_description_short_eng`, (`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__eng` ON (`Description`.`id` = `I18n__description_short__eng`.`foreign_key` AND `I18n__description_short__eng`.`model` = 'Description' AND `I18n__description_short__eng`.`field` = 'description_short' AND `I18n__description_short__eng`.`locale` = 'eng') 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` = 321 LIMIT 1 1 1 1 SELECT `Productgroup`.`id`, `Productgroup`.`promoprice`, `Productgroup`.`wholesaleprice`, `Productgroup`.`price`, `Description`.`id`, (`I18n__name__eng`.`content`) AS `Productgroup__i18n_name_eng`, (`I18n__name__nld`.`content`) AS `Productgroup__i18n_name_nld`, (`I18n__slug__eng`.`content`) AS `Productgroup__i18n_slug_eng`, (`I18n__slug__nld`.`content`) AS `Productgroup__i18n_slug_nld` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__eng` ON (`Productgroup`.`id` = `I18n__name__eng`.`foreign_key` AND `I18n__name__eng`.`model` = 'Productgroup' AND `I18n__name__eng`.`field` = 'name' AND `I18n__name__eng`.`locale` = 'eng') 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__eng` ON (`Productgroup`.`id` = `I18n__slug__eng`.`foreign_key` AND `I18n__slug__eng`.`model` = 'Productgroup' AND `I18n__slug__eng`.`field` = 'slug' AND `I18n__slug__eng`.`locale` = 'eng') 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` = 169 LIMIT 1 1 1 10 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` = (169) ORDER BY `sorting` ASC 6 6 2 maybe slow SELECT `Description`.`id`, (`I18n__description_short__eng`.`content`) AS `Description__i18n_description_short_eng`, (`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__eng` ON (`Description`.`id` = `I18n__description_short__eng`.`foreign_key` AND `I18n__description_short__eng`.`model` = 'Description' AND `I18n__description_short__eng`.`field` = 'description_short' AND `I18n__description_short__eng`.`locale` = 'eng') 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` = 307 LIMIT 1 1 1 2 maybe slow SELECT `Productgroup`.`id`, `Productgroup`.`promoprice`, `Productgroup`.`wholesaleprice`, `Productgroup`.`price`, `Description`.`id`, (`I18n__name__eng`.`content`) AS `Productgroup__i18n_name_eng`, (`I18n__name__nld`.`content`) AS `Productgroup__i18n_name_nld`, (`I18n__slug__eng`.`content`) AS `Productgroup__i18n_slug_eng`, (`I18n__slug__nld`.`content`) AS `Productgroup__i18n_slug_nld` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__eng` ON (`Productgroup`.`id` = `I18n__name__eng`.`foreign_key` AND `I18n__name__eng`.`model` = 'Productgroup' AND `I18n__name__eng`.`field` = 'name' AND `I18n__name__eng`.`locale` = 'eng') 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__eng` ON (`Productgroup`.`id` = `I18n__slug__eng`.`foreign_key` AND `I18n__slug__eng`.`model` = 'Productgroup' AND `I18n__slug__eng`.`field` = 'slug' AND `I18n__slug__eng`.`locale` = 'eng') 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` = 175 LIMIT 1 1 1 9 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` = (175) ORDER BY `sorting` ASC 6 6 2 maybe slow SELECT `Description`.`id`, (`I18n__description_short__eng`.`content`) AS `Description__i18n_description_short_eng`, (`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__eng` ON (`Description`.`id` = `I18n__description_short__eng`.`foreign_key` AND `I18n__description_short__eng`.`model` = 'Description' AND `I18n__description_short__eng`.`field` = 'description_short' AND `I18n__description_short__eng`.`locale` = 'eng') 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` = 313 LIMIT 1 1 1 1 SELECT `Productgroup`.`id`, `Productgroup`.`promoprice`, `Productgroup`.`wholesaleprice`, `Productgroup`.`price`, `Description`.`id`, (`I18n__name__eng`.`content`) AS `Productgroup__i18n_name_eng`, (`I18n__name__nld`.`content`) AS `Productgroup__i18n_name_nld`, (`I18n__slug__eng`.`content`) AS `Productgroup__i18n_slug_eng`, (`I18n__slug__nld`.`content`) AS `Productgroup__i18n_slug_nld` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__eng` ON (`Productgroup`.`id` = `I18n__name__eng`.`foreign_key` AND `I18n__name__eng`.`model` = 'Productgroup' AND `I18n__name__eng`.`field` = 'name' AND `I18n__name__eng`.`locale` = 'eng') 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__eng` ON (`Productgroup`.`id` = `I18n__slug__eng`.`foreign_key` AND `I18n__slug__eng`.`model` = 'Productgroup' AND `I18n__slug__eng`.`field` = 'slug' AND `I18n__slug__eng`.`locale` = 'eng') 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` = 182 LIMIT 1 1 1 10 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` = (182) ORDER BY `sorting` ASC 2 2 2 SELECT `Description`.`id`, (`I18n__description_short__eng`.`content`) AS `Description__i18n_description_short_eng`, (`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__eng` ON (`Description`.`id` = `I18n__description_short__eng`.`foreign_key` AND `I18n__description_short__eng`.`model` = 'Description' AND `I18n__description_short__eng`.`field` = 'description_short' AND `I18n__description_short__eng`.`locale` = 'eng') 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` = 320 LIMIT 1 1 1 1 SELECT `Productgroup`.`id`, `Productgroup`.`promoprice`, `Productgroup`.`wholesaleprice`, `Productgroup`.`price`, `Description`.`id`, (`I18n__name__eng`.`content`) AS `Productgroup__i18n_name_eng`, (`I18n__name__nld`.`content`) AS `Productgroup__i18n_name_nld`, (`I18n__slug__eng`.`content`) AS `Productgroup__i18n_slug_eng`, (`I18n__slug__nld`.`content`) AS `Productgroup__i18n_slug_nld` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__eng` ON (`Productgroup`.`id` = `I18n__name__eng`.`foreign_key` AND `I18n__name__eng`.`model` = 'Productgroup' AND `I18n__name__eng`.`field` = 'name' AND `I18n__name__eng`.`locale` = 'eng') 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__eng` ON (`Productgroup`.`id` = `I18n__slug__eng`.`foreign_key` AND `I18n__slug__eng`.`model` = 'Productgroup' AND `I18n__slug__eng`.`field` = 'slug' AND `I18n__slug__eng`.`locale` = 'eng') 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` = 181 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` = (181) ORDER BY `sorting` ASC 3 3 2 maybe slow SELECT `Description`.`id`, (`I18n__description_short__eng`.`content`) AS `Description__i18n_description_short_eng`, (`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__eng` ON (`Description`.`id` = `I18n__description_short__eng`.`foreign_key` AND `I18n__description_short__eng`.`model` = 'Description' AND `I18n__description_short__eng`.`field` = 'description_short' AND `I18n__description_short__eng`.`locale` = 'eng') 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` = 319 LIMIT 1 1 1 1 SELECT `Productgroup`.`id`, `Productgroup`.`promoprice`, `Productgroup`.`wholesaleprice`, `Productgroup`.`price`, `Description`.`id`, (`I18n__name__eng`.`content`) AS `Productgroup__i18n_name_eng`, (`I18n__name__nld`.`content`) AS `Productgroup__i18n_name_nld`, (`I18n__slug__eng`.`content`) AS `Productgroup__i18n_slug_eng`, (`I18n__slug__nld`.`content`) AS `Productgroup__i18n_slug_nld` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__eng` ON (`Productgroup`.`id` = `I18n__name__eng`.`foreign_key` AND `I18n__name__eng`.`model` = 'Productgroup' AND `I18n__name__eng`.`field` = 'name' AND `I18n__name__eng`.`locale` = 'eng') 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__eng` ON (`Productgroup`.`id` = `I18n__slug__eng`.`foreign_key` AND `I18n__slug__eng`.`model` = 'Productgroup' AND `I18n__slug__eng`.`field` = 'slug' AND `I18n__slug__eng`.`locale` = 'eng') 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` = 180 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` = (180) ORDER BY `sorting` ASC 3 3 2 maybe slow SELECT `Description`.`id`, (`I18n__description_short__eng`.`content`) AS `Description__i18n_description_short_eng`, (`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__eng` ON (`Description`.`id` = `I18n__description_short__eng`.`foreign_key` AND `I18n__description_short__eng`.`model` = 'Description' AND `I18n__description_short__eng`.`field` = 'description_short' AND `I18n__description_short__eng`.`locale` = 'eng') 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` = 318 LIMIT 1 1 1 2 maybe slow SELECT `Productgroup`.`id`, `Productgroup`.`promoprice`, `Productgroup`.`wholesaleprice`, `Productgroup`.`price`, `Description`.`id`, (`I18n__name__eng`.`content`) AS `Productgroup__i18n_name_eng`, (`I18n__name__nld`.`content`) AS `Productgroup__i18n_name_nld`, (`I18n__slug__eng`.`content`) AS `Productgroup__i18n_slug_eng`, (`I18n__slug__nld`.`content`) AS `Productgroup__i18n_slug_nld` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__eng` ON (`Productgroup`.`id` = `I18n__name__eng`.`foreign_key` AND `I18n__name__eng`.`model` = 'Productgroup' AND `I18n__name__eng`.`field` = 'name' AND `I18n__name__eng`.`locale` = 'eng') 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__eng` ON (`Productgroup`.`id` = `I18n__slug__eng`.`foreign_key` AND `I18n__slug__eng`.`model` = 'Productgroup' AND `I18n__slug__eng`.`field` = 'slug' AND `I18n__slug__eng`.`locale` = 'eng') 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` = 187 LIMIT 1 1 1 15 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` = (187) ORDER BY `sorting` ASC 3 3 3 SELECT `Description`.`id`, (`I18n__description_short__eng`.`content`) AS `Description__i18n_description_short_eng`, (`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__eng` ON (`Description`.`id` = `I18n__description_short__eng`.`foreign_key` AND `I18n__description_short__eng`.`model` = 'Description' AND `I18n__description_short__eng`.`field` = 'description_short' AND `I18n__description_short__eng`.`locale` = 'eng') 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` = 325 LIMIT 1 1 1 2 maybe slow SELECT `Productgroup`.`id`, `Productgroup`.`promoprice`, `Productgroup`.`wholesaleprice`, `Productgroup`.`price`, `Description`.`id`, (`I18n__name__eng`.`content`) AS `Productgroup__i18n_name_eng`, (`I18n__name__nld`.`content`) AS `Productgroup__i18n_name_nld`, (`I18n__slug__eng`.`content`) AS `Productgroup__i18n_slug_eng`, (`I18n__slug__nld`.`content`) AS `Productgroup__i18n_slug_nld` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__eng` ON (`Productgroup`.`id` = `I18n__name__eng`.`foreign_key` AND `I18n__name__eng`.`model` = 'Productgroup' AND `I18n__name__eng`.`field` = 'name' AND `I18n__name__eng`.`locale` = 'eng') 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__eng` ON (`Productgroup`.`id` = `I18n__slug__eng`.`foreign_key` AND `I18n__slug__eng`.`model` = 'Productgroup' AND `I18n__slug__eng`.`field` = 'slug' AND `I18n__slug__eng`.`locale` = 'eng') 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` = 173 LIMIT 1 1 1 10 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` = (173) ORDER BY `sorting` ASC 3 3 2 maybe slow SELECT `Description`.`id`, (`I18n__description_short__eng`.`content`) AS `Description__i18n_description_short_eng`, (`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__eng` ON (`Description`.`id` = `I18n__description_short__eng`.`foreign_key` AND `I18n__description_short__eng`.`model` = 'Description' AND `I18n__description_short__eng`.`field` = 'description_short' AND `I18n__description_short__eng`.`locale` = 'eng') 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` = 311 LIMIT 1 1 1 1 SELECT `Productgroup`.`id`, `Productgroup`.`promoprice`, `Productgroup`.`wholesaleprice`, `Productgroup`.`price`, `Description`.`id`, (`I18n__name__eng`.`content`) AS `Productgroup__i18n_name_eng`, (`I18n__name__nld`.`content`) AS `Productgroup__i18n_name_nld`, (`I18n__slug__eng`.`content`) AS `Productgroup__i18n_slug_eng`, (`I18n__slug__nld`.`content`) AS `Productgroup__i18n_slug_nld` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__eng` ON (`Productgroup`.`id` = `I18n__name__eng`.`foreign_key` AND `I18n__name__eng`.`model` = 'Productgroup' AND `I18n__name__eng`.`field` = 'name' AND `I18n__name__eng`.`locale` = 'eng') 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__eng` ON (`Productgroup`.`id` = `I18n__slug__eng`.`foreign_key` AND `I18n__slug__eng`.`model` = 'Productgroup' AND `I18n__slug__eng`.`field` = 'slug' AND `I18n__slug__eng`.`locale` = 'eng') 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` = 149 LIMIT 1 1 1 10 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` = (149) ORDER BY `sorting` ASC 2 2 2 SELECT `Description`.`id`, (`I18n__description_short__eng`.`content`) AS `Description__i18n_description_short_eng`, (`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__eng` ON (`Description`.`id` = `I18n__description_short__eng`.`foreign_key` AND `I18n__description_short__eng`.`model` = 'Description' AND `I18n__description_short__eng`.`field` = 'description_short' AND `I18n__description_short__eng`.`locale` = 'eng') 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` = 223 LIMIT 1 1 1 1 SELECT `Productgroup`.`id`, `Productgroup`.`promoprice`, `Productgroup`.`wholesaleprice`, `Productgroup`.`price`, `Description`.`id`, (`I18n__name__eng`.`content`) AS `Productgroup__i18n_name_eng`, (`I18n__name__nld`.`content`) AS `Productgroup__i18n_name_nld`, (`I18n__slug__eng`.`content`) AS `Productgroup__i18n_slug_eng`, (`I18n__slug__nld`.`content`) AS `Productgroup__i18n_slug_nld` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__eng` ON (`Productgroup`.`id` = `I18n__name__eng`.`foreign_key` AND `I18n__name__eng`.`model` = 'Productgroup' AND `I18n__name__eng`.`field` = 'name' AND `I18n__name__eng`.`locale` = 'eng') 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__eng` ON (`Productgroup`.`id` = `I18n__slug__eng`.`foreign_key` AND `I18n__slug__eng`.`model` = 'Productgroup' AND `I18n__slug__eng`.`field` = 'slug' AND `I18n__slug__eng`.`locale` = 'eng') 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` = 161 LIMIT 1 1 1 10 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` = (161) ORDER BY `sorting` ASC 3 3 2 maybe slow SELECT `Description`.`id`, (`I18n__description_short__eng`.`content`) AS `Description__i18n_description_short_eng`, (`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__eng` ON (`Description`.`id` = `I18n__description_short__eng`.`foreign_key` AND `I18n__description_short__eng`.`model` = 'Description' AND `I18n__description_short__eng`.`field` = 'description_short' AND `I18n__description_short__eng`.`locale` = 'eng') 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` = 235 LIMIT 1 1 1 2 maybe slow SELECT `Productgroup`.`id`, `Productgroup`.`promoprice`, `Productgroup`.`wholesaleprice`, `Productgroup`.`price`, `Description`.`id`, (`I18n__name__eng`.`content`) AS `Productgroup__i18n_name_eng`, (`I18n__name__nld`.`content`) AS `Productgroup__i18n_name_nld`, (`I18n__slug__eng`.`content`) AS `Productgroup__i18n_slug_eng`, (`I18n__slug__nld`.`content`) AS `Productgroup__i18n_slug_nld` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__eng` ON (`Productgroup`.`id` = `I18n__name__eng`.`foreign_key` AND `I18n__name__eng`.`model` = 'Productgroup' AND `I18n__name__eng`.`field` = 'name' AND `I18n__name__eng`.`locale` = 'eng') 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__eng` ON (`Productgroup`.`id` = `I18n__slug__eng`.`foreign_key` AND `I18n__slug__eng`.`model` = 'Productgroup' AND `I18n__slug__eng`.`field` = 'slug' AND `I18n__slug__eng`.`locale` = 'eng') 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` = 150 LIMIT 1 1 1 10 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` = (150) ORDER BY `sorting` ASC 2 2 2 SELECT `Description`.`id`, (`I18n__description_short__eng`.`content`) AS `Description__i18n_description_short_eng`, (`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__eng` ON (`Description`.`id` = `I18n__description_short__eng`.`foreign_key` AND `I18n__description_short__eng`.`model` = 'Description' AND `I18n__description_short__eng`.`field` = 'description_short' AND `I18n__description_short__eng`.`locale` = 'eng') 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` = 224 LIMIT 1 1 1 1 SELECT `Productgroup`.`id`, `Productgroup`.`promoprice`, `Productgroup`.`wholesaleprice`, `Productgroup`.`price`, `Description`.`id`, (`I18n__name__eng`.`content`) AS `Productgroup__i18n_name_eng`, (`I18n__name__nld`.`content`) AS `Productgroup__i18n_name_nld`, (`I18n__slug__eng`.`content`) AS `Productgroup__i18n_slug_eng`, (`I18n__slug__nld`.`content`) AS `Productgroup__i18n_slug_nld` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__eng` ON (`Productgroup`.`id` = `I18n__name__eng`.`foreign_key` AND `I18n__name__eng`.`model` = 'Productgroup' AND `I18n__name__eng`.`field` = 'name' AND `I18n__name__eng`.`locale` = 'eng') 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__eng` ON (`Productgroup`.`id` = `I18n__slug__eng`.`foreign_key` AND `I18n__slug__eng`.`model` = 'Productgroup' AND `I18n__slug__eng`.`field` = 'slug' AND `I18n__slug__eng`.`locale` = 'eng') 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` = 151 LIMIT 1 1 1 10 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` = (151) ORDER BY `sorting` ASC 2 2 2 SELECT `Description`.`id`, (`I18n__description_short__eng`.`content`) AS `Description__i18n_description_short_eng`, (`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__eng` ON (`Description`.`id` = `I18n__description_short__eng`.`foreign_key` AND `I18n__description_short__eng`.`model` = 'Description' AND `I18n__description_short__eng`.`field` = 'description_short' AND `I18n__description_short__eng`.`locale` = 'eng') 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` = 225 LIMIT 1 1 1 2 maybe slow SELECT `Productgroup`.`id`, `Productgroup`.`promoprice`, `Productgroup`.`wholesaleprice`, `Productgroup`.`price`, `Description`.`id`, (`I18n__name__eng`.`content`) AS `Productgroup__i18n_name_eng`, (`I18n__name__nld`.`content`) AS `Productgroup__i18n_name_nld`, (`I18n__slug__eng`.`content`) AS `Productgroup__i18n_slug_eng`, (`I18n__slug__nld`.`content`) AS `Productgroup__i18n_slug_nld` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__eng` ON (`Productgroup`.`id` = `I18n__name__eng`.`foreign_key` AND `I18n__name__eng`.`model` = 'Productgroup' AND `I18n__name__eng`.`field` = 'name' AND `I18n__name__eng`.`locale` = 'eng') 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__eng` ON (`Productgroup`.`id` = `I18n__slug__eng`.`foreign_key` AND `I18n__slug__eng`.`model` = 'Productgroup' AND `I18n__slug__eng`.`field` = 'slug' AND `I18n__slug__eng`.`locale` = 'eng') 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` = 156 LIMIT 1 1 1 10 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` = (156) ORDER BY `sorting` ASC 3 3 2 maybe slow SELECT `Description`.`id`, (`I18n__description_short__eng`.`content`) AS `Description__i18n_description_short_eng`, (`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__eng` ON (`Description`.`id` = `I18n__description_short__eng`.`foreign_key` AND `I18n__description_short__eng`.`model` = 'Description' AND `I18n__description_short__eng`.`field` = 'description_short' AND `I18n__description_short__eng`.`locale` = 'eng') 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` = 230 LIMIT 1 1 1 2 maybe slow SELECT count(*) as count FROM (SELECT 'Productgroup' as model, Productgroup.id, promoprice, created, I18n__name__eng.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__eng ON (Productgroup.id = I18n__name__eng.foreign_key AND I18n__name__eng.model = 'Productgroup' AND I18n__name__eng.field = 'name' AND I18n__name__eng.locale = 'eng') WHERE CategoryGroup.category_id IN(63) 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__eng.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__eng ON (Bundle.id = I18n__name__eng.foreign_key AND I18n__name__eng.model = 'Bundle' AND I18n__name__eng.field = 'name' AND I18n__name__eng.locale = 'eng') WHERE CategoryGroup.category_id IN(63) 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 23 maybe slow SELECT MAX(maxprice) as maxprice, MIN(minprice) as minprice FROM (SELECT MAX(promoprice) as maxprice, MIN(promoprice) as minprice FROM productgroups as Productgroup RIGHT JOIN category_groups AS CategoryGroup ON (CategoryGroup.group_id = Productgroup.id) RIGHT JOIN descriptions AS Description ON (Description.group_id = Productgroup.id) LEFT JOIN i18n AS I18n__name__eng ON (Productgroup.id = I18n__name__eng.foreign_key AND I18n__name__eng.model = 'Productgroup' AND I18n__name__eng.field = 'name' AND I18n__name__eng.locale = 'eng') WHERE CategoryGroup.category_id IN(63) 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__eng ON (Bundle.id = I18n__name__eng.foreign_key AND I18n__name__eng.model = 'Bundle' AND I18n__name__eng.field = 'name' AND I18n__name__eng.locale = 'eng') WHERE CategoryGroup.category_id IN(63) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '10' AND Description.group_model = 'Bundle' AND hidden = '') as prices 1 1 27 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__eng ON (Productgroup.id = I18n__name__eng.foreign_key AND I18n__name__eng.model = 'Productgroup' AND I18n__name__eng.field = 'name' AND I18n__name__eng.locale = 'eng') RIGHT JOIN brands AS Brand ON (Productgroup.brand_id = Brand.id) WHERE CategoryGroup.category_id IN(63) 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__eng ON (Bundle.id = I18n__name__eng.foreign_key AND I18n__name__eng.model = 'Bundle' AND I18n__name__eng.field = 'name' AND I18n__name__eng.locale = 'eng') RIGHT JOIN brands AS Brand ON (Bundle.brand_id = Brand.id) WHERE CategoryGroup.category_id IN(63) 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 8 8 17 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` = 'nld') WHERE `Category`.`id` = 63 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` = 63 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` = 'nld') WHERE `Category`.`id` = 63 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` = 'nld') WHERE `Category`.`id` = 63 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` = 'fra') WHERE `Category`.`id` = 63 AND `Category`.`store_id` = 10 LIMIT 1 1 1 0 Query Explain:
==== -
Timer +
Memory
Peak Memory Use 19.21 MB
Message Memory use Component initialization 8.14 MB Controller action start 10.80 MB Controller render start 12.43 MB View render complete 15.03 MB Timers
Total Request Time: 931 (ms)
Message Time in ms Graph Core Processing (Derived from $_SERVER["REQUEST_TIME"]) 108.38 Event: Controller.initialize 62.76 Event: Controller.startup 1.39 Controller action 567.55 Event: Controller.beforeRender 12.52 » Processing toolbar data 11.66 Rendering View 82.02 » Event: View.beforeRender 0.11 » Rendering APP/View/Categories/view.ctp 35.06 » » Rendering APP/View/Themed/Pokerhandel/Elements/catalog/sidebar.ctp 7.64 » » » Rendering APP/View/Elements/catalog/filter.ctp 1.97 » » » Rendering APP/View/Elements/catalog/filter-price.ctp 0.44 » » Rendering APP/View/Themed/Pokerhandel/Elements/layout/sidebar.ctp #2 30.05 » » » » Rendering APP/View/Elements/stores/pokerhandel/troeven.ctp 0.26 » » » Rendering APP/View/Themed/Pokerhandel/Elements/catalog/toolbar.ctp 2.48 » » » » Rendering APP/View/Elements/pagination_frontend.ctp 0.68 » » » Rendering APP/View/Themed/Pokerhandel/Elements/group/group-item.ctp 0.81 » » » Rendering APP/View/Themed/Pokerhandel/Elements/group/group-item.ctp #2 0.71 » » » Rendering APP/View/Themed/Pokerhandel/Elements/group/group-item.ctp #3 0.77 » » » Rendering APP/View/Themed/Pokerhandel/Elements/group/group-item.ctp #4 0.73 » » » 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.60 » » » Rendering APP/View/Themed/Pokerhandel/Elements/group/group-item.ctp #7 0.64 » » » Rendering APP/View/Themed/Pokerhandel/Elements/group/group-item.ctp #8 0.68 » » » Rendering APP/View/Themed/Pokerhandel/Elements/group/group-item.ctp #9 0.61 » » » Rendering APP/View/Themed/Pokerhandel/Elements/group/group-item.ctp #10 0.60 » » » Rendering APP/View/Themed/Pokerhandel/Elements/group/group-item.ctp #11 0.62 » » » Rendering APP/View/Themed/Pokerhandel/Elements/group/group-item.ctp #12 0.68 » » » Rendering APP/View/Themed/Pokerhandel/Elements/group/group-item.ctp #13 0.67 » » » Rendering APP/View/Themed/Pokerhandel/Elements/group/group-item.ctp #14 0.61 » » » Rendering APP/View/Themed/Pokerhandel/Elements/group/group-item.ctp #15 0.70 » » » Rendering APP/View/Themed/Pokerhandel/Elements/group/group-item.ctp #16 0.77 » » » Rendering APP/View/Themed/Pokerhandel/Elements/group/group-item.ctp #17 0.78 » » » Rendering APP/View/Themed/Pokerhandel/Elements/group/group-item.ctp #18 0.78 » » » Rendering APP/View/Themed/Pokerhandel/Elements/group/group-item.ctp #19 0.69 » » » Rendering APP/View/Themed/Pokerhandel/Elements/group/group-item.ctp #20 0.69 » » » Rendering APP/View/Themed/Pokerhandel/Elements/group/group-item.ctp #21 0.70 » » » Rendering APP/View/Themed/Pokerhandel/Elements/group/group-item.ctp #22 0.63 » » » Rendering APP/View/Themed/Pokerhandel/Elements/group/group-item.ctp #23 0.67 » » » Rendering APP/View/Themed/Pokerhandel/Elements/group/group-item.ctp #24 0.67 » » » Rendering APP/View/Themed/Pokerhandel/Elements/catalog/toolbar.ctp #2 2.43 » » » » Rendering APP/View/Elements/pagination_frontend.ctp #2 0.70 » Event: View.afterRender 0.04 » Event: View.beforeLayout 0.04 » Rendering APP/View/Layouts/default.ctp 15.61 » » Rendering APP/View/Elements/layout/facebook-jssdk.ctp 0.17 » » Rendering APP/View/Themed/Pokerhandel/Elements/layout/top-section.ctp 3.99 » » Rendering APP/View/Themed/Pokerhandel/Elements/layout/branding.ctp 0.99 » » Rendering APP/View/Themed/Pokerhandel/Elements/layout/main-nav.ctp 2.22 » » Rendering APP/View/Elements/layout/top-notice.ctp 0.21 » » Rendering APP/View/Elements/layout/content.ctp 1.47 » » » Rendering APP/View/Themed/Pokerhandel/Elements/layout/breadcrumbs.ctp 1.11 » » Rendering APP/View/Themed/Pokerhandel/Elements/layout/footer.ctp 0.62 » » Rendering APP/View/Themed/Pokerhandel/Elements/banners/footer.ctp #2 1.64 » » » Rendering APP/View/Elements/layout/footer-hours.ctp 0.42 » » » Rendering APP/View/Elements/layout/footer-contact.ctp 0.17 Event: View.afterLayout 0.00 ====
-
-
