- 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
-
Playing Felts
These poker felts are very practical. Just unfold them on your table, and it will instantly transform into a poker table.
Works great, at a very low cost!Items 1 to 8 of 8 totalItems 1 to 8 of 8 total
-
- History
-
Sqllog +
Sql Logs
default
Total Time: 212 ms
Total Queries: 62 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 1 maybe slow SELECT `HourException`.`id`, `HourException`.`date`, `HourException`.`start`, `HourException`.`end`, `HourException`.`closed`, `HourException`.`store_location_id` FROM `tbiback_tbshops`.`hour_exceptions` AS `HourException` WHERE `date` = '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 0 SELECT `StoreSetting`.`id`, `StoreSetting`.`key`, `StoreSetting`.`value`, `StoreSetting`.`type`, `StoreSetting`.`store_id` FROM `tbiback_tbshops`.`store_settings` AS `StoreSetting` WHERE `StoreSetting`.`store_id` = (10) 16 16 0 SELECT `ShippingmethodsStore`.`id`, `ShippingmethodsStore`.`shippingmethod_id`, `ShippingmethodsStore`.`store_id`, `Shippingmethod`.`id`, `Shippingmethod`.`code`, `Shippingmethod`.`sorting`, `Shippingmethod`.`countries`, `Shippingmethod`.`store_id`, `Store`.`id`, `Store`.`name`, `Store`.`branding`, `Store`.`defaultlocale`, `Store`.`theme_admin`, `Store`.`theme`, `Store`.`phone`, `Store`.`url`, `Store`.`email`, `Store`.`active`, `Store`.`index`, `Store`.`maintenance_mode`, `Store`.`base`, `Store`.`use_menu_builder`, `Store`.`age_confirm`, `Store`.`hours_popup`, `Store`.`is_wholesale`, `Store`.`disable_checkout`, `Store`.`enable_stores` FROM `tbiback_tbshops`.`shippingmethods_stores` AS `ShippingmethodsStore` LEFT JOIN `tbiback_tbshops`.`shippingmethods` AS `Shippingmethod` ON (`ShippingmethodsStore`.`shippingmethod_id` = `Shippingmethod`.`id`) LEFT JOIN `tbiback_tbshops`.`stores` AS `Store` ON (`ShippingmethodsStore`.`store_id` = `Store`.`id`) WHERE `Store`.`id` = 10 AND `Shippingmethod`.`code` = 'shipment' LIMIT 1 1 1 0 SELECT `ShippingRate`.`id`, `ShippingRate`.`shippingmethod_id`, `ShippingRate`.`country`, `ShippingRate`.`floor`, `ShippingRate`.`ceiling`, `ShippingRate`.`criteria`, `ShippingRate`.`price` FROM `tbiback_tbshops`.`shipping_rates` AS `ShippingRate` WHERE `ShippingRate`.`shippingmethod_id` = (8) 41 41 0 SELECT `Message`.`id`, `Message`.`type`, `Message`.`start`, `Message`.`end`, `Message`.`store_id`, `Message`.`from_override`, (`I18n__message__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 0 SELECT `UrlRedirect`.`id`, `UrlRedirect`.`old_url`, `UrlRedirect`.`new_url`, `UrlRedirect`.`redirect_type`, `UrlRedirect`.`store_id` FROM `tbiback_tbshops`.`url_redirects` AS `UrlRedirect` WHERE `old_url` = 'http://www.pokerhandel.be/eng/category/60/poker-tables/playing-felts' 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` = 'nq5vlbb21tf329ibeoejtan8i5' AND `qty` > 0 0 0 1 maybe slow 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` = 60 AND `Category`.`store_id` = 10 LIMIT 1 1 1 11 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` = (60) 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` = 41 AND `ParentCategory`.`store_id` = 10 LIMIT 1 1 1 6 maybe slow SELECT `Category`.`parent_id` FROM `tbiback_tbshops`.`categories` AS `Category` WHERE `Category`.`id` = 60 AND `Category`.`store_id` = 10 LIMIT 1 1 1 0 SELECT `Category`.`parent_id` FROM `tbiback_tbshops`.`categories` AS `Category` WHERE `Category`.`id` = 41 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` = 41 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, 60) 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(60) 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(60) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '10' AND Description.group_model = 'Bundle' AND hidden = '' ORDER BY name asc LIMIT 0, 24 8 8 17 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` = 387 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` = (387) 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` = 540 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` = 330 LIMIT 1 1 1 11 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` = (330) 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` = 468 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` = 291 LIMIT 1 1 1 11 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` = (291) 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` = 429 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` = 331 LIMIT 1 1 1 12 maybe slow SELECT `Image`.`id`, `Image`.`group_id`, `Image`.`group_model`, `Image`.`filename`, `Image`.`sorting`, `Image`.`variant_id`, `Image`.`created`, `Image`.`compressed` FROM `tbiback_tbshops`.`images` AS `Image` WHERE `Image`.`group_model` = 'Productgroup' AND `Image`.`group_id` = (331) ORDER BY `sorting` ASC 2 2 3 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` = 469 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` = 329 LIMIT 1 1 1 17 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` = (329) ORDER BY `sorting` ASC 1 1 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` = 467 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` = 332 LIMIT 1 1 1 12 maybe slow SELECT `Image`.`id`, `Image`.`group_id`, `Image`.`group_model`, `Image`.`filename`, `Image`.`sorting`, `Image`.`variant_id`, `Image`.`created`, `Image`.`compressed` FROM `tbiback_tbshops`.`images` AS `Image` WHERE `Image`.`group_model` = 'Productgroup' AND `Image`.`group_id` = (332) 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` = 470 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` = 333 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` = (333) 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` = 471 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` = 328 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` = (328) 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` = 466 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(60) 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(60) 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 13 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(60) 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(60) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '10' AND Description.group_model = 'Bundle' AND hidden = '') as prices 1 1 12 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(60) 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(60) 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 1 1 11 maybe slow SELECT `Category`.`id`, (`I18n__path`.`content`) AS `Category__i18n_path` FROM `tbiback_tbshops`.`categories` AS `Category` INNER JOIN `tbiback_tbshops`.`i18n` AS `I18n__path` ON (`Category`.`id` = `I18n__path`.`foreign_key` AND `I18n__path`.`model` = 'Category' AND `I18n__path`.`field` = 'path' AND `I18n__path`.`locale` = 'nld') WHERE `Category`.`id` = 60 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` = 60 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` = 60 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` = 60 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` = 60 AND `Category`.`store_id` = 10 LIMIT 1 1 1 0 Query Explain:
==== -
Timer +
Memory
Peak Memory Use 19.70 MB
Message Memory use Component initialization 8.13 MB Controller action start 10.80 MB Controller render start 12.09 MB View render complete 14.63 MB Timers
Total Request Time: 650 (ms)
Message Time in ms Graph Core Processing (Derived from $_SERVER["REQUEST_TIME"]) 126.87 Event: Controller.initialize 66.69 Event: Controller.startup 1.60 Controller action 311.38 Event: Controller.beforeRender 19.08 » Processing toolbar data 17.97 Rendering View 56.49 » Event: View.beforeRender 0.09 » Rendering APP/View/Categories/view.ctp 20.88 » » Rendering APP/View/Themed/Pokerhandel/Elements/catalog/sidebar.ctp 7.31 » » » Rendering APP/View/Elements/catalog/filter.ctp 0.81 » » » Rendering APP/View/Elements/catalog/filter-price.ctp 0.66 » » Rendering APP/View/Themed/Pokerhandel/Elements/layout/sidebar.ctp #2 15.74 » » » » Rendering APP/View/Elements/stores/pokerhandel/troeven.ctp 0.21 » » » Rendering APP/View/Themed/Pokerhandel/Elements/catalog/toolbar.ctp 2.24 » » » » Rendering APP/View/Elements/pagination_frontend.ctp 0.28 » » » Rendering APP/View/Themed/Pokerhandel/Elements/group/group-item.ctp 0.80 » » » Rendering APP/View/Themed/Pokerhandel/Elements/group/group-item.ctp #2 0.70 » » » Rendering APP/View/Themed/Pokerhandel/Elements/group/group-item.ctp #3 0.65 » » » Rendering APP/View/Themed/Pokerhandel/Elements/group/group-item.ctp #4 0.62 » » » Rendering APP/View/Themed/Pokerhandel/Elements/group/group-item.ctp #5 0.62 » » » Rendering APP/View/Themed/Pokerhandel/Elements/group/group-item.ctp #6 0.62 » » » Rendering APP/View/Themed/Pokerhandel/Elements/group/group-item.ctp #7 0.68 » » » Rendering APP/View/Themed/Pokerhandel/Elements/group/group-item.ctp #8 0.62 » » » Rendering APP/View/Themed/Pokerhandel/Elements/catalog/toolbar.ctp #2 1.96 » » » » Rendering APP/View/Elements/pagination_frontend.ctp #2 0.26 » Event: View.afterRender 0.04 » Event: View.beforeLayout 0.04 » Rendering APP/View/Layouts/default.ctp 16.00 » » Rendering APP/View/Elements/layout/facebook-jssdk.ctp 0.19 » » Rendering APP/View/Themed/Pokerhandel/Elements/layout/top-section.ctp 4.18 » » Rendering APP/View/Themed/Pokerhandel/Elements/layout/branding.ctp 1.01 » » Rendering APP/View/Themed/Pokerhandel/Elements/layout/main-nav.ctp 2.17 » » Rendering APP/View/Elements/layout/top-notice.ctp 0.22 » » Rendering APP/View/Elements/layout/content.ctp 1.51 » » » Rendering APP/View/Themed/Pokerhandel/Elements/layout/breadcrumbs.ctp 1.15 » » Rendering APP/View/Themed/Pokerhandel/Elements/layout/footer.ctp 0.65 » » Rendering APP/View/Themed/Pokerhandel/Elements/banners/footer.ctp #2 1.82 » » » Rendering APP/View/Elements/layout/footer-hours.ctp 0.36 » » » Rendering APP/View/Elements/layout/footer-contact.ctp 0.17 Event: View.afterLayout 0.00 ====
-
-
