Foldable Octagon Pokertable 120CM

No reviews | Write the first review

Availability: Not available

Product ID: 7100.792

€199,95

€189,95

Product description

This octagon poker table is perfect for those looking for a luxurious solution without having to sacrifice too much room in their homes. The characteristic shape is not only extremely stylish but combines eight seats into a compact and sturdy table.

The table has folding legs, is equipped with cupholders and a padded edge just as you can find at expensive casino tables.

After an evening of poker, you just fold the table and put it in the closet or under your bed.

General Information

Up to 8 players
Compact
120 cm diameter
Comfortable padded edge
Cupholders
Foldable and easy to store.

Product reviews

Please write a review of this product below, in order to help other customers make the right choices while shopping.

History
+

Request History

No previous requests logged.

====

Sqllog
+

Sql Logs

default

Total Time: 70 ms
Total Queries: 48 queries
Query Affected Num. rows Took (ms) Actions
SELECT `Store`.`id`, `Store`.`name`, `Store`.`branding`, `Store`.`defaultlocale`, `Store`.`theme_admin`, `Store`.`theme`, `Store`.`phone`, `Store`.`url`, `Store`.`email`, `Store`.`active`, `Store`.`index`, `Store`.`maintenance_mode`, `Store`.`base`, `Store`.`use_menu_builder`, `Store`.`age_confirm`, `Store`.`hours_popup`, `Store`.`is_wholesale`, `Store`.`disable_checkout`, `Store`.`enable_stores`, (`I18n__homepagetitle__nld`.`content`) AS `Store__i18n_homepagetitle_nld`, (`I18n__homepagedescription__nld`.`content`) AS `Store__i18n_homepagedescription_nld`, (`I18n__homepage_footer__nld`.`content`) AS `Store__i18n_homepage_footer_nld`, (`I18n__homepage_content__nld`.`content`) AS `Store__i18n_homepage_content_nld`, (`I18n__header_points__nld`.`content`) AS `Store__i18n_header_points_nld`, (`I18n__footer_blocks__nld`.`content`) AS `Store__i18n_footer_blocks_nld`, (`I18n__sidebar_content__nld`.`content`) AS `Store__i18n_sidebar_content_nld`, (`I18n__disable_checkout_msg__nld`.`content`) AS `Store__i18n_disable_checkout_msg_nld` FROM `tbiback_tbshops`.`stores` AS `Store` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__homepagetitle__nld` ON (`Store`.`id` = `I18n__homepagetitle__nld`.`foreign_key` AND `I18n__homepagetitle__nld`.`model` = 'Store' AND `I18n__homepagetitle__nld`.`field` = 'homepagetitle' AND `I18n__homepagetitle__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__homepagedescription__nld` ON (`Store`.`id` = `I18n__homepagedescription__nld`.`foreign_key` AND `I18n__homepagedescription__nld`.`model` = 'Store' AND `I18n__homepagedescription__nld`.`field` = 'homepagedescription' AND `I18n__homepagedescription__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__homepage_footer__nld` ON (`Store`.`id` = `I18n__homepage_footer__nld`.`foreign_key` AND `I18n__homepage_footer__nld`.`model` = 'Store' AND `I18n__homepage_footer__nld`.`field` = 'homepage_footer' AND `I18n__homepage_footer__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__homepage_content__nld` ON (`Store`.`id` = `I18n__homepage_content__nld`.`foreign_key` AND `I18n__homepage_content__nld`.`model` = 'Store' AND `I18n__homepage_content__nld`.`field` = 'homepage_content' AND `I18n__homepage_content__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__header_points__nld` ON (`Store`.`id` = `I18n__header_points__nld`.`foreign_key` AND `I18n__header_points__nld`.`model` = 'Store' AND `I18n__header_points__nld`.`field` = 'header_points' AND `I18n__header_points__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__footer_blocks__nld` ON (`Store`.`id` = `I18n__footer_blocks__nld`.`foreign_key` AND `I18n__footer_blocks__nld`.`model` = 'Store' AND `I18n__footer_blocks__nld`.`field` = 'footer_blocks' AND `I18n__footer_blocks__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__sidebar_content__nld` ON (`Store`.`id` = `I18n__sidebar_content__nld`.`foreign_key` AND `I18n__sidebar_content__nld`.`model` = 'Store' AND `I18n__sidebar_content__nld`.`field` = 'sidebar_content' AND `I18n__sidebar_content__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__disable_checkout_msg__nld` ON (`Store`.`id` = `I18n__disable_checkout_msg__nld`.`foreign_key` AND `I18n__disable_checkout_msg__nld`.`model` = 'Store' AND `I18n__disable_checkout_msg__nld`.`field` = 'disable_checkout_msg' AND `I18n__disable_checkout_msg__nld`.`locale` = 'nld') WHERE `url` = '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 `Productgroup`.`id`, (`I18n__slug`.`content`) AS `Productgroup__i18n_slug` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` INNER JOIN `tbiback_tbshops`.`i18n` AS `I18n__slug` ON (`Productgroup`.`id` = `I18n__slug`.`foreign_key` AND `I18n__slug`.`model` = 'Productgroup' AND `I18n__slug`.`field` = 'slug' AND `I18n__slug`.`locale` = 'eng') WHERE `I18n__slug`.`content` = 'foldable-octagon-pokertable-120cm' AND `Productgroup`.`id` = 367 LIMIT 1 1 1 2 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/product/367/foldable-octagon-pokertable-120cm' 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` = 'r5cq2q4vndsarec84ee330s7a5' AND `qty` > 0 0 0 1 maybe slow

SELECT `Productgroup`.*, `CategoryGroup`.*, `Brand`.*, `Brand`.`id`, `Productgroup`.`id`, (`I18n__name`.`content`) AS `Productgroup__i18n_name`, (`I18n__slug`.`content`) AS `Productgroup__i18n_slug`, (`I18n__pagetitle`.`content`) AS `Productgroup__i18n_pagetitle`, (`I18n__attributes`.`content`) AS `Productgroup__i18n_attributes`, (`I18n__default`.`content`) AS `Productgroup__i18n_default` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` LEFT JOIN `tbiback_tbshops`.`category_groups` AS `CategoryGroup` ON (`CategoryGroup`.`group_id` = `Productgroup`.`id` AND `CategoryGroup`.`group_model` = 'Productgroup') LEFT JOIN `tbiback_tbshops`.`categories` AS `Category` ON (`Category`.`id` = `CategoryGroup`.`category_id`) INNER JOIN `tbiback_tbshops`.`i18n` AS `I18n__name` ON (`Productgroup`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Productgroup' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'eng') INNER JOIN `tbiback_tbshops`.`i18n` AS `I18n__slug` ON (`Productgroup`.`id` = `I18n__slug`.`foreign_key` AND `I18n__slug`.`model` = 'Productgroup' AND `I18n__slug`.`field` = 'slug' AND `I18n__slug`.`locale` = 'eng') INNER JOIN `tbiback_tbshops`.`i18n` AS `I18n__pagetitle` ON (`Productgroup`.`id` = `I18n__pagetitle`.`foreign_key` AND `I18n__pagetitle`.`model` = 'Productgroup' AND `I18n__pagetitle`.`field` = 'pagetitle' AND `I18n__pagetitle`.`locale` = 'eng') INNER JOIN `tbiback_tbshops`.`i18n` AS `I18n__attributes` ON (`Productgroup`.`id` = `I18n__attributes`.`foreign_key` AND `I18n__attributes`.`model` = 'Productgroup' AND `I18n__attributes`.`field` = 'attributes' AND `I18n__attributes`.`locale` = 'eng') INNER JOIN `tbiback_tbshops`.`i18n` AS `I18n__default` ON (`Productgroup`.`id` = `I18n__default`.`foreign_key` AND `I18n__default`.`model` = 'Productgroup' AND `I18n__default`.`field` = 'default' AND `I18n__default`.`locale` = 'eng') LEFT JOIN `tbiback_tbshops`.`brands` AS `Brand` ON (`Productgroup`.`brand_id` = `Brand`.`id`) LEFT JOIN `tbiback_tbshops`.`descriptions` AS `Description` ON (`Description`.`group_id` = `Productgroup`.`id` AND `Description`.`group_model` = 'Productgroup' AND `Description`.`store_id` = 10) WHERE `I18n__slug`.`content` = 'foldable-octagon-pokertable-120cm' AND `Productgroup`.`id` = 367 AND `Category`.`store_id` = '10' LIMIT 1 1 1 9 maybe slow

SELECT `Description`.`id`, `Description`.`group_id`, `Description`.`group_model`, `Description`.`store_id`, `Description`.`featured` FROM `tbiback_tbshops`.`descriptions` AS `Description` WHERE `Description`.`group_id` = 367 AND `Description`.`group_model` = 'Productgroup' AND `Description`.`store_id` = 10 1 1 3 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, `created` asc 2 2 2

SELECT `Review`.`id`, `Review`.`group_id`, `Review`.`group_model`, `Review`.`title`, `Review`.`content`, `Review`.`rating`, `Review`.`moderated`, `Review`.`reviewer_name`, `Review`.`reviewer_email`, `Review`.`customer_id`, `Review`.`lang`, `Review`.`store_id`, `Review`.`created` FROM `tbiback_tbshops`.`reviews` AS `Review` WHERE `lang` = 'eng' AND `moderated` = '1' AND `Review`.`group_id` = (367) 0 0 3 maybe slow

SELECT `Product`.`id`, `Product`.`SKU`, `Product`.`ehale`, `Product`.`price`, `Product`.`promoprice`, `Product`.`purchaseprice`, `Product`.`wholesaleprice`, `Product`.`stock`, `Product`.`criticalstock`, `Product`.`dropship`, `Product`.`outofstock`, `Product`.`green`, `Product`.`weight`, `Product`.`width`, `Product`.`height`, `Product`.`depth`, `Product`.`productgroup_id`, `Product`.`created`, `Product`.`modified`, `Product`.`sorting`, `Product`.`available`, `Product`.`endoflife`, `Product`.`warehouse_location`, `Product`.`sellable`, `Product`.`exported`, `Product`.`expires`, `Product`.`status`, `Product`.`barcode`, `Product`.`contains_nicotine` FROM `tbiback_tbshops`.`products` AS `Product` WHERE `Product`.`productgroup_id` = (367) ORDER BY `sorting` ASC 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`.`variant_id` = 419 0 0 2 maybe slow

SELECT `Productattribute`.`id`, `Productattribute`.`product_id` FROM `tbiback_tbshops`.`productattributes` AS `Productattribute` WHERE `Productattribute`.`product_id` = (419) 0 0 1 maybe slow

SELECT `RelatedProductgroup`.`id`, `RelatedProductgroup`.`brand_id`, `RelatedProductgroup`.`price`, `RelatedProductgroup`.`promoprice`, `RelatedProductgroup`.`wholesaleprice`, `RelatedProductgroup`.`minimumsaleprice`, `RelatedProductgroup`.`show_retail_price`, `RelatedProductgroup`.`hidden`, `RelatedProductgroup`.`available`, `RelatedProductgroup`.`endoflife`, `RelatedProductgroup`.`exclusive`, `RelatedProductgroup`.`created`, `RelatedProductgroup`.`exportable`, `RelatedProductgroup`.`exported`, `RelatedProductgroup`.`bbat_flexible`, `RelatedProductgroup`.`bbat_fixed`, `RelatedGroup`.`id`, `RelatedGroup`.`group_model`, `RelatedGroup`.`related_model`, `RelatedGroup`.`group_id`, `RelatedGroup`.`related_id` FROM `tbiback_tbshops`.`productgroups` AS `RelatedProductgroup` JOIN `tbiback_tbshops`.`related_groups` AS `RelatedGroup` ON (`RelatedGroup`.`group_id` = 367 AND `RelatedGroup`.`related_id` = `RelatedProductgroup`.`id`) WHERE `RelatedGroup`.`related_model` = 'Productgroup' 0 0 1 maybe slow

SELECT `RelatedBundle`.`id`, `RelatedBundle`.`SKU`, `RelatedBundle`.`brand_id`, `RelatedBundle`.`price`, `RelatedBundle`.`promoprice`, `RelatedBundle`.`purchaseprice`, `RelatedBundle`.`wholesaleprice`, `RelatedBundle`.`qtychange_price`, `RelatedBundle`.`hidden`, `RelatedBundle`.`available`, `RelatedBundle`.`created`, `RelatedGroup`.`id`, `RelatedGroup`.`group_model`, `RelatedGroup`.`related_model`, `RelatedGroup`.`group_id`, `RelatedGroup`.`related_id` FROM `tbiback_tbshops`.`bundles` AS `RelatedBundle` JOIN `tbiback_tbshops`.`related_groups` AS `RelatedGroup` ON (`RelatedGroup`.`group_id` = 367 AND `RelatedGroup`.`related_id` = `RelatedBundle`.`id`) WHERE `RelatedGroup`.`related_model` = 'Bundle' 0 0 1 maybe slow

SELECT `AddonProductgroup`.`id`, `AddonProductgroup`.`brand_id`, `AddonProductgroup`.`price`, `AddonProductgroup`.`promoprice`, `AddonProductgroup`.`wholesaleprice`, `AddonProductgroup`.`minimumsaleprice`, `AddonProductgroup`.`show_retail_price`, `AddonProductgroup`.`hidden`, `AddonProductgroup`.`available`, `AddonProductgroup`.`endoflife`, `AddonProductgroup`.`exclusive`, `AddonProductgroup`.`created`, `AddonProductgroup`.`exportable`, `AddonProductgroup`.`exported`, `AddonProductgroup`.`bbat_flexible`, `AddonProductgroup`.`bbat_fixed`, `AddonGroup`.`id`, `AddonGroup`.`group_model`, `AddonGroup`.`group_id`, `AddonGroup`.`addon_model`, `AddonGroup`.`addon_id`, `AddonGroup`.`addon_qty`, `AddonGroup`.`addon_variant_id` FROM `tbiback_tbshops`.`productgroups` AS `AddonProductgroup` JOIN `tbiback_tbshops`.`addon_groups` AS `AddonGroup` ON (`AddonGroup`.`group_id` = 367 AND `AddonGroup`.`addon_id` = `AddonProductgroup`.`id`) WHERE `AddonGroup`.`addon_model` = 'Productgroup' 0 0 1 maybe slow

SELECT `AddonBundle`.`id`, `AddonBundle`.`SKU`, `AddonBundle`.`brand_id`, `AddonBundle`.`price`, `AddonBundle`.`promoprice`, `AddonBundle`.`purchaseprice`, `AddonBundle`.`wholesaleprice`, `AddonBundle`.`qtychange_price`, `AddonBundle`.`hidden`, `AddonBundle`.`available`, `AddonBundle`.`created`, `AddonGroup`.`id`, `AddonGroup`.`group_model`, `AddonGroup`.`group_id`, `AddonGroup`.`addon_model`, `AddonGroup`.`addon_id`, `AddonGroup`.`addon_qty`, `AddonGroup`.`addon_variant_id` FROM `tbiback_tbshops`.`bundles` AS `AddonBundle` JOIN `tbiback_tbshops`.`addon_groups` AS `AddonGroup` ON (`AddonGroup`.`group_id` = 367 AND `AddonGroup`.`addon_id` = `AddonBundle`.`id`) WHERE `AddonGroup`.`addon_model` = 'Bundle' 0 0 1 maybe slow

SELECT `Productattribute`.`id`, `Productattribute`.`product_id`, (`I18n__key`.`content`) AS `Productattribute__i18n_key`, (`I18n__value`.`content`) AS `Productattribute__i18n_value` FROM `tbiback_tbshops`.`productattributes` AS `Productattribute` INNER JOIN `tbiback_tbshops`.`productattribute_i18ns` AS `I18n__key` ON (`Productattribute`.`id` = `I18n__key`.`foreign_key` AND `I18n__key`.`model` = 'Productattribute' AND `I18n__key`.`field` = 'key' AND `I18n__key`.`locale` = 'eng') INNER JOIN `tbiback_tbshops`.`productattribute_i18ns` AS `I18n__value` ON (`Productattribute`.`id` = `I18n__value`.`foreign_key` AND `I18n__value`.`model` = 'Productattribute' AND `I18n__value`.`field` = 'value' AND `I18n__value`.`locale` = 'eng') WHERE `product_id` = 419 0 0 4 maybe slow

SELECT `Description`.`id`, (`I18n__description__eng`.`content`) AS `Description__i18n_description_eng`, (`I18n__description__nld`.`content`) AS `Description__i18n_description_nld`, (`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__eng` ON (`Description`.`id` = `I18n__description__eng`.`foreign_key` AND `I18n__description__eng`.`model` = 'Description' AND `I18n__description__eng`.`field` = 'description' AND `I18n__description__eng`.`locale` = 'eng') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__description__nld` ON (`Description`.`id` = `I18n__description__nld`.`foreign_key` AND `I18n__description__nld`.`model` = 'Description' AND `I18n__description__nld`.`field` = 'description' AND `I18n__description__nld`.`locale` = 'nld') 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 5 maybe slow

SELECT `Image`.`id`, (`I18n__title__eng`.`content`) AS `Image__i18n_title_eng`, (`I18n__title__nld`.`content`) AS `Image__i18n_title_nld` FROM `tbiback_tbshops`.`images` AS `Image` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__title__eng` ON (`Image`.`id` = `I18n__title__eng`.`foreign_key` AND `I18n__title__eng`.`model` = 'Image' AND `I18n__title__eng`.`field` = 'title' AND `I18n__title__eng`.`locale` = 'eng') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__title__nld` ON (`Image`.`id` = `I18n__title__nld`.`foreign_key` AND `I18n__title__nld`.`model` = 'Image' AND `I18n__title__nld`.`field` = 'title' AND `I18n__title__nld`.`locale` = 'nld') WHERE `Image`.`id` = 1075 LIMIT 1 1 1 2 maybe slow

SELECT `Image`.`id`, (`I18n__title__eng`.`content`) AS `Image__i18n_title_eng`, (`I18n__title__nld`.`content`) AS `Image__i18n_title_nld` FROM `tbiback_tbshops`.`images` AS `Image` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__title__eng` ON (`Image`.`id` = `I18n__title__eng`.`foreign_key` AND `I18n__title__eng`.`model` = 'Image' AND `I18n__title__eng`.`field` = 'title' AND `I18n__title__eng`.`locale` = 'eng') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__title__nld` ON (`Image`.`id` = `I18n__title__nld`.`foreign_key` AND `I18n__title__nld`.`model` = 'Image' AND `I18n__title__nld`.`field` = 'title' AND `I18n__title__nld`.`locale` = 'nld') WHERE `Image`.`id` = 862 LIMIT 1 1 1 1

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`, `ParentCategory`.`sorting`, `ParentCategory`.`topmenu`, `ParentCategory`.`store_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 `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 7 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 `Productattribute`.`id`, `Productattribute`.`product_id`, (`I18n__key__eng`.`content`) AS `Productattribute__i18n_key_eng`, (`I18n__key__nld`.`content`) AS `Productattribute__i18n_key_nld`, (`I18n__value__eng`.`content`) AS `Productattribute__i18n_value_eng`, (`I18n__value__nld`.`content`) AS `Productattribute__i18n_value_nld` FROM `tbiback_tbshops`.`productattributes` AS `Productattribute` LEFT JOIN `tbiback_tbshops`.`productattribute_i18ns` AS `I18n__key__eng` ON (`Productattribute`.`id` = `I18n__key__eng`.`foreign_key` AND `I18n__key__eng`.`model` = 'Productattribute' AND `I18n__key__eng`.`field` = 'key' AND `I18n__key__eng`.`locale` = 'eng') LEFT JOIN `tbiback_tbshops`.`productattribute_i18ns` AS `I18n__key__nld` ON (`Productattribute`.`id` = `I18n__key__nld`.`foreign_key` AND `I18n__key__nld`.`model` = 'Productattribute' AND `I18n__key__nld`.`field` = 'key' AND `I18n__key__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`productattribute_i18ns` AS `I18n__value__eng` ON (`Productattribute`.`id` = `I18n__value__eng`.`foreign_key` AND `I18n__value__eng`.`model` = 'Productattribute' AND `I18n__value__eng`.`field` = 'value' AND `I18n__value__eng`.`locale` = 'eng') LEFT JOIN `tbiback_tbshops`.`productattribute_i18ns` AS `I18n__value__nld` ON (`Productattribute`.`id` = `I18n__value__nld`.`foreign_key` AND `I18n__value__nld`.`model` = 'Productattribute' AND `I18n__value__nld`.`field` = 'value' AND `I18n__value__nld`.`locale` = 'nld') WHERE `product_id` = 419 0 0 3 maybe slow

SELECT `StoreSetting`.`id`, `StoreSetting`.`key`, `StoreSetting`.`value`, `StoreSetting`.`type`, `StoreSetting`.`store_id` FROM `tbiback_tbshops`.`store_settings` AS `StoreSetting` WHERE `key` = 'outofstock' AND `store_id` = 10 LIMIT 1 1 1 0

SELECT `Productgroup`.`id`, (`I18n__slug`.`content`) AS `Productgroup__i18n_slug` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` INNER JOIN `tbiback_tbshops`.`i18n` AS `I18n__slug` ON (`Productgroup`.`id` = `I18n__slug`.`foreign_key` AND `I18n__slug`.`model` = 'Productgroup' AND `I18n__slug`.`field` = 'slug' AND `I18n__slug`.`locale` = 'eng') WHERE `I18n__slug`.`content` = 'foldable-octagon-pokertable-120cm' AND `Productgroup`.`id` = 367 LIMIT 1 1 1 0

SELECT `Productgroup`.`id`, (`I18n__slug`.`content`) AS `Productgroup__i18n_slug` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` INNER JOIN `tbiback_tbshops`.`i18n` AS `I18n__slug` ON (`Productgroup`.`id` = `I18n__slug`.`foreign_key` AND `I18n__slug`.`model` = 'Productgroup' AND `I18n__slug`.`field` = 'slug' AND `I18n__slug`.`locale` = 'nld') WHERE `Productgroup`.`id` = 367 LIMIT 1 1 1 1

SELECT `Productgroup`.`id`, (`I18n__slug`.`content`) AS `Productgroup__i18n_slug` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` INNER JOIN `tbiback_tbshops`.`i18n` AS `I18n__slug` ON (`Productgroup`.`id` = `I18n__slug`.`foreign_key` AND `I18n__slug`.`model` = 'Productgroup' AND `I18n__slug`.`field` = 'slug' AND `I18n__slug`.`locale` = 'nld') WHERE `Productgroup`.`id` = 367 LIMIT 1 1 1 0

SELECT `Productgroup`.`id`, (`I18n__slug`.`content`) AS `Productgroup__i18n_slug` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` INNER JOIN `tbiback_tbshops`.`i18n` AS `I18n__slug` ON (`Productgroup`.`id` = `I18n__slug`.`foreign_key` AND `I18n__slug`.`model` = 'Productgroup' AND `I18n__slug`.`field` = 'slug' AND `I18n__slug`.`locale` = 'fra') WHERE `Productgroup`.`id` = 367 LIMIT 1 1 1 1

SELECT `Productgroup`.`id`, (`I18n__slug`.`content`) AS `Productgroup__i18n_slug` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` INNER JOIN `tbiback_tbshops`.`i18n` AS `I18n__slug` ON (`Productgroup`.`id` = `I18n__slug`.`foreign_key` AND `I18n__slug`.`model` = 'Productgroup' AND `I18n__slug`.`field` = 'slug' AND `I18n__slug`.`locale` = 'fra') WHERE `Productgroup`.`id` = 367 LIMIT 1 1 1 0

Query Explain:

Click an "Explain" link above, to see the query explanation.

====

Timer
+

Memory

Peak Memory Use 20.43 MB

Message Memory use
Component initialization 8.53 MB

Controller action start 11.72 MB

Controller render start 13.46 MB

View render complete 15.82 MB

Timers

Total Request Time: 457 (ms)

Message Time in ms Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"]) 115.85

Event: Controller.initialize 64.17

Event: Controller.startup 1.28

Controller action 138.03

Event: Controller.beforeRender 16.74

» Processing toolbar data 15.93

Rendering View 59.26

» Event: View.beforeRender 0.05

» Rendering APP/View/Productgroups/view.ctp 8.94

» » Rendering APP/View/Themed/Pokerhandel/Elements/product/detail.ctp 5.45

» Event: View.afterRender 0.03

» Event: View.beforeLayout 0.04

» Rendering APP/View/Layouts/default.ctp 28.23

» » Rendering APP/View/Elements/layout/facebook-jssdk.ctp 0.29

» » Rendering APP/View/Themed/Pokerhandel/Elements/layout/top-section.ctp 12.07

» » Rendering APP/View/Themed/Pokerhandel/Elements/layout/branding.ctp 1.24

» » Rendering APP/View/Themed/Pokerhandel/Elements/layout/main-nav.ctp 2.83

» » Rendering APP/View/Elements/layout/top-notice.ctp 0.22

» » Rendering APP/View/Elements/layout/content.ctp 1.93

» » » Rendering APP/View/Themed/Pokerhandel/Elements/layout/breadcrumbs.ctp 1.44

» » Rendering APP/View/Themed/Pokerhandel/Elements/layout/footer.ctp 0.55

» » Rendering APP/View/Themed/Pokerhandel/Elements/banners/footer.ctp #2 1.88

» » » Rendering APP/View/Elements/layout/footer-hours.ctp 0.41

» » » Rendering APP/View/Elements/layout/footer-contact.ctp 0.20

Event: View.afterLayout 0.00

====

Message	Memory use
Component initialization	8.53 MB
Controller action start	11.72 MB
Controller render start	13.46 MB
View render complete	15.82 MB

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	115.85
Event: Controller.initialize	64.17
Event: Controller.startup	1.28
Controller action	138.03
Event: Controller.beforeRender	16.74
» Processing toolbar data	15.93
Rendering View	59.26
» Event: View.beforeRender	0.05
» Rendering APP/View/Productgroups/view.ctp	8.94
» » Rendering APP/View/Themed/Pokerhandel/Elements/product/detail.ctp	5.45
» Event: View.afterRender	0.03
» Event: View.beforeLayout	0.04
» Rendering APP/View/Layouts/default.ctp	28.23
» » Rendering APP/View/Elements/layout/facebook-jssdk.ctp	0.29
» » Rendering APP/View/Themed/Pokerhandel/Elements/layout/top-section.ctp	12.07
» » Rendering APP/View/Themed/Pokerhandel/Elements/layout/branding.ctp	1.24
» » Rendering APP/View/Themed/Pokerhandel/Elements/layout/main-nav.ctp	2.83
» » Rendering APP/View/Elements/layout/top-notice.ctp	0.22
» » Rendering APP/View/Elements/layout/content.ctp	1.93
» » » Rendering APP/View/Themed/Pokerhandel/Elements/layout/breadcrumbs.ctp	1.44
» » Rendering APP/View/Themed/Pokerhandel/Elements/layout/footer.ctp	0.55
» » Rendering APP/View/Themed/Pokerhandel/Elements/banners/footer.ctp #2	1.88
» » » Rendering APP/View/Elements/layout/footer-hours.ctp	0.41
» » » Rendering APP/View/Elements/layout/footer-contact.ctp	0.20
Event: View.afterLayout	0.00

Foldable Octagon Pokertable 120CM

Request History

Sql Logs

default

Total Time: 70 ms Total Queries: 48 queries

Query Explain:

Memory

Timers

Total Time: 70 ms
Total Queries: 48 queries