- 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
-
Foldable Poker Tables
Like our other tables, these are delivered free at home starting at 150 EUR. A foldable poker table is the perfect for people who want a high end poker table, but don't have room to put a poker table at all times.
These are easily folded and stored after your poker game!Items 1 to 6 of 6 totalItems 1 to 6 of 6 total
-
- History
-
Sqllog +
Sql Logs
default
Total Time: 160 ms
Total Queries: 56 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 13 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 2 maybe slow SELECT `UrlRedirect`.`id`, `UrlRedirect`.`old_url`, `UrlRedirect`.`new_url`, `UrlRedirect`.`redirect_type`, `UrlRedirect`.`store_id` FROM `tbiback_tbshops`.`url_redirects` AS `UrlRedirect` WHERE `old_url` = 'https://pokerhandel.be/eng/category/61/poker-tables/foldable-poker-tables' AND `store_id` = 10 LIMIT 1 0 0 1 maybe slow SELECT `Cart`.`id`, `Cart`.`display`, `Cart`.`group_id`, `Cart`.`group_model`, `Cart`.`session_id`, `Cart`.`qty`, `Cart`.`price`, `Cart`.`price_excl_vat`, `Cart`.`price_vat`, `Cart`.`price_incl_vat`, `Cart`.`vat`, `Cart`.`created`, `Cart`.`loaded`, `Cart`.`store_id`, `Cart`.`default`, `Cart`.`defaultqty`, `Cart`.`order_type`, `Productgroup`.`id`, `Productgroup`.`brand_id`, `Productgroup`.`price`, `Productgroup`.`promoprice`, `Productgroup`.`wholesaleprice`, `Productgroup`.`minimumsaleprice`, `Productgroup`.`show_retail_price`, `Productgroup`.`hidden`, `Productgroup`.`available`, `Productgroup`.`endoflife`, `Productgroup`.`exclusive`, `Productgroup`.`created`, `Productgroup`.`exportable`, `Productgroup`.`exported`, `Productgroup`.`bbat_flexible`, `Productgroup`.`bbat_fixed`, `Bundle`.`id`, `Bundle`.`SKU`, `Bundle`.`brand_id`, `Bundle`.`price`, `Bundle`.`promoprice`, `Bundle`.`purchaseprice`, `Bundle`.`wholesaleprice`, `Bundle`.`qtychange_price`, `Bundle`.`hidden`, `Bundle`.`available`, `Bundle`.`created` FROM `tbiback_tbshops`.`carts` AS `Cart` LEFT JOIN `tbiback_tbshops`.`productgroups` AS `Productgroup` ON (`Cart`.`group_id` = `Productgroup`.`id` AND `Cart`.`group_model` = 'Productgroup') LEFT JOIN `tbiback_tbshops`.`bundles` AS `Bundle` ON (`Cart`.`group_id` = `Bundle`.`id` AND `Cart`.`group_model` = 'Bundle') WHERE `session_id` = 'tdjcm32j5shff2alakqv4lgh16' 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` = 61 AND `Category`.`store_id` = 10 LIMIT 1 1 1 10 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` = (61) 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 5 maybe slow SELECT `Category`.`parent_id` FROM `tbiback_tbshops`.`categories` AS `Category` WHERE `Category`.`id` = 61 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, 61) 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(61) 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(61) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '10' AND Description.group_model = 'Bundle' AND hidden = '' ORDER BY name asc LIMIT 0, 24 6 6 12 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` = 446 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` = (446) 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` = 610 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` = 367 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` = (367) 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` = 510 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` = 442 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` = (442) 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` = 606 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` = 444 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` = (444) 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` = 608 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` = 443 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` = (443) 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` = 607 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` = 445 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` = (445) 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` = 609 LIMIT 1 1 1 1 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(61) 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(61) 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(61) 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(61) 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(61) 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(61) AND CategoryGroup.group_model = 'Bundle' AND Description.store_id = '10' AND Description.group_model = 'Bundle' AND hidden = '' GROUP BY Brand.id) as Brand GROUP BY Brand.id ORDER BY name 0 0 11 maybe slow SELECT `Category`.`id`, (`I18n__path`.`content`) AS `Category__i18n_path` FROM `tbiback_tbshops`.`categories` AS `Category` INNER JOIN `tbiback_tbshops`.`i18n` AS `I18n__path` ON (`Category`.`id` = `I18n__path`.`foreign_key` AND `I18n__path`.`model` = 'Category' AND `I18n__path`.`field` = 'path' AND `I18n__path`.`locale` = 'nld') WHERE `Category`.`id` = 61 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` = 61 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` = 61 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` = 61 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` = 61 AND `Category`.`store_id` = 10 LIMIT 1 1 1 0 Query Explain:
==== -
Timer +
Memory
Peak Memory Use 19.45 MB
Message Memory use Component initialization 8.33 MB Controller action start 10.92 MB Controller render start 12.18 MB View render complete 14.71 MB Timers
Total Request Time: 489 (ms)
Message Time in ms Graph Core Processing (Derived from $_SERVER["REQUEST_TIME"]) 89.88 Event: Controller.initialize 57.49 Event: Controller.startup 1.47 Controller action 207.03 Event: Controller.beforeRender 18.23 » Processing toolbar data 17.22 Rendering View 52.04 » Event: View.beforeRender 0.05 » Rendering APP/View/Categories/view.ctp 17.03 » » Rendering APP/View/Themed/Pokerhandel/Elements/catalog/sidebar.ctp 5.20 » » » Rendering APP/View/Elements/catalog/filter-price.ctp 0.45 » » Rendering APP/View/Themed/Pokerhandel/Elements/layout/sidebar.ctp #2 14.21 » » » » Rendering APP/View/Elements/stores/pokerhandel/troeven.ctp 0.23 » » » Rendering APP/View/Themed/Pokerhandel/Elements/catalog/toolbar.ctp 2.03 » » » » Rendering APP/View/Elements/pagination_frontend.ctp 0.30 » » » Rendering APP/View/Themed/Pokerhandel/Elements/group/group-item.ctp 0.79 » » » 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.70 » » » Rendering APP/View/Themed/Pokerhandel/Elements/group/group-item.ctp #4 0.68 » » » Rendering APP/View/Themed/Pokerhandel/Elements/group/group-item.ctp #5 0.68 » » » Rendering APP/View/Themed/Pokerhandel/Elements/group/group-item.ctp #6 0.69 » » » Rendering APP/View/Themed/Pokerhandel/Elements/catalog/toolbar.ctp #2 2.08 » » » » Rendering APP/View/Elements/pagination_frontend.ctp #2 0.29 » Event: View.afterRender 0.07 » Event: View.beforeLayout 0.05 » Rendering APP/View/Layouts/default.ctp 15.77 » » Rendering APP/View/Elements/layout/facebook-jssdk.ctp 0.19 » » Rendering APP/View/Themed/Pokerhandel/Elements/layout/top-section.ctp 3.87 » » Rendering APP/View/Themed/Pokerhandel/Elements/layout/branding.ctp 1.01 » » Rendering APP/View/Themed/Pokerhandel/Elements/layout/main-nav.ctp 2.29 » » Rendering APP/View/Elements/layout/top-notice.ctp 0.23 » » Rendering APP/View/Elements/layout/content.ctp 1.61 » » » Rendering APP/View/Themed/Pokerhandel/Elements/layout/breadcrumbs.ctp 1.22 » » Rendering APP/View/Themed/Pokerhandel/Elements/layout/footer.ctp 0.58 » » Rendering APP/View/Themed/Pokerhandel/Elements/banners/footer.ctp #2 1.66 » » » Rendering APP/View/Elements/layout/footer-hours.ctp 0.36 » » » Rendering APP/View/Elements/layout/footer-contact.ctp 0.20 Event: View.afterLayout 0.00 ====
-
-
