No reviews | Write the first review
€49,95
A box of 10 cup holders for use in your own poker table build or to replace the cupholders in our deluxe poker tables.
Please write a review of this product below, in order to help other customers make the right choices while shopping.
| 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` = 'cupholders-box-of-10' AND `Productgroup`.`id` = 795 LIMIT 1 | 1 | 1 | 1 | |
| 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/795/cupholders-box-of-10' 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` = 'iefrb4n0gbkg521p44167dgk74' 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` = 'cupholders-box-of-10' AND `Productgroup`.`id` = 795 AND `Category`.`store_id` = '10' LIMIT 1 | 1 | 1 | 6 | 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` = 795 AND `Description`.`group_model` = 'Productgroup' AND `Description`.`store_id` = 10 | 1 | 1 | 2 | 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` = (795) ORDER BY `sorting` asc, `created` asc | 1 | 1 | 2 | maybe slow |
| 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` = (795) | 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` = (795) ORDER BY `sorting` ASC | 1 | 1 | 7 | maybe slow |
| SELECT `Image`.`id`, `Image`.`group_id`, `Image`.`group_model`, `Image`.`filename`, `Image`.`sorting`, `Image`.`variant_id`, `Image`.`created`, `Image`.`compressed` FROM `tbiback_tbshops`.`images` AS `Image` WHERE `Image`.`variant_id` = 1270 | 0 | 0 | 1 | maybe slow |
| SELECT `Productattribute`.`id`, `Productattribute`.`product_id` FROM `tbiback_tbshops`.`productattributes` AS `Productattribute` WHERE `Productattribute`.`product_id` = (1270) | 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` = 795 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` = 795 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` = 795 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` = 795 AND `AddonGroup`.`addon_id` = `AddonBundle`.`id`) WHERE `AddonGroup`.`addon_model` = 'Bundle' | 0 | 0 | 0 | |
| 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` = 1270 | 0 | 0 | 2 | 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` = 1034 LIMIT 1 | 1 | 1 | 3 | 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` = 1569 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` = 84 AND `Category`.`store_id` = 10 LIMIT 1 | 1 | 1 | 9 | 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 | 0 | |
| SELECT `Category`.`parent_id` FROM `tbiback_tbshops`.`categories` AS `Category` WHERE `Category`.`id` = 84 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 | 0 | |
| 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` = 1270 | 0 | 0 | 5 | 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` = 'cupholders-box-of-10' AND `Productgroup`.`id` = 795 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` = 795 LIMIT 1 | 1 | 1 | 2 | maybe slow |
| 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` = 795 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` = 795 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` = 795 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `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`, (`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`, (`I18n__pagetitle__eng`.`content`) AS `Productgroup__i18n_pagetitle_eng`, (`I18n__pagetitle__nld`.`content`) AS `Productgroup__i18n_pagetitle_nld`, (`I18n__attributes__eng`.`content`) AS `Productgroup__i18n_attributes_eng`, (`I18n__attributes__nld`.`content`) AS `Productgroup__i18n_attributes_nld`, (`I18n__default__eng`.`content`) AS `Productgroup__i18n_default_eng`, (`I18n__default__nld`.`content`) AS `Productgroup__i18n_default_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`.`i18n` AS `I18n__pagetitle__eng` ON (`Productgroup`.`id` = `I18n__pagetitle__eng`.`foreign_key` AND `I18n__pagetitle__eng`.`model` = 'Productgroup' AND `I18n__pagetitle__eng`.`field` = 'pagetitle' AND `I18n__pagetitle__eng`.`locale` = 'eng') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__pagetitle__nld` ON (`Productgroup`.`id` = `I18n__pagetitle__nld`.`foreign_key` AND `I18n__pagetitle__nld`.`model` = 'Productgroup' AND `I18n__pagetitle__nld`.`field` = 'pagetitle' AND `I18n__pagetitle__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__attributes__eng` ON (`Productgroup`.`id` = `I18n__attributes__eng`.`foreign_key` AND `I18n__attributes__eng`.`model` = 'Productgroup' AND `I18n__attributes__eng`.`field` = 'attributes' AND `I18n__attributes__eng`.`locale` = 'eng') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__attributes__nld` ON (`Productgroup`.`id` = `I18n__attributes__nld`.`foreign_key` AND `I18n__attributes__nld`.`model` = 'Productgroup' AND `I18n__attributes__nld`.`field` = 'attributes' AND `I18n__attributes__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__default__eng` ON (`Productgroup`.`id` = `I18n__default__eng`.`foreign_key` AND `I18n__default__eng`.`model` = 'Productgroup' AND `I18n__default__eng`.`field` = 'default' AND `I18n__default__eng`.`locale` = 'eng') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__default__nld` ON (`Productgroup`.`id` = `I18n__default__nld`.`foreign_key` AND `I18n__default__nld`.`model` = 'Productgroup' AND `I18n__default__nld`.`field` = 'default' AND `I18n__default__nld`.`locale` = 'nld') WHERE `Productgroup`.`id` = 795 LIMIT 1 | 1 | 1 | 9 | maybe slow |
Peak Memory Use 20.96 MB
| Message | Memory use |
|---|---|
| Component initialization | 8.72 MB |
| Controller action start | 11.84 MB |
| Controller render start | 13.51 MB |
| View render complete | 15.97 MB |
Total Request Time: 408 (ms)
| Message | Time in ms | Graph |
|---|---|---|
| Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 117.67 | |
| Event: Controller.initialize | 40.35 | |
| Event: Controller.startup | 1.39 | |
| Controller action | 101.54 | |
| Event: Controller.beforeRender | 20.38 | |
| » Processing toolbar data | 19.41 | |
| Rendering View | 66.90 | |
| » Event: View.beforeRender | 0.05 | |
| » Rendering APP/View/Productgroups/view.ctp | 9.88 | |
| » » Rendering APP/View/Themed/Pokerhandel/Elements/product/detail.ctp | 6.18 | |
| » » » Rendering APP/View/Elements/addthis.ctp | 0.15 | |
| » Event: View.afterRender | 0.04 | |
| » Event: View.beforeLayout | 0.04 | |
| » Rendering APP/View/Layouts/default.ctp | 35.80 | |
| » » Rendering APP/View/Elements/layout/facebook-jssdk.ctp | 0.19 | |
| » » Rendering APP/View/Themed/Pokerhandel/Elements/layout/top-section.ctp | 20.27 | |
| » » Rendering APP/View/Themed/Pokerhandel/Elements/layout/branding.ctp | 1.28 | |
| » » Rendering APP/View/Themed/Pokerhandel/Elements/layout/main-nav.ctp | 2.98 | |
| » » Rendering APP/View/Elements/layout/top-notice.ctp | 0.27 | |
| » » Rendering APP/View/Elements/layout/content.ctp | 1.94 | |
| » » » Rendering APP/View/Themed/Pokerhandel/Elements/layout/breadcrumbs.ctp | 1.49 | |
| » » Rendering APP/View/Themed/Pokerhandel/Elements/layout/footer.ctp | 0.57 | |
| » » Rendering APP/View/Themed/Pokerhandel/Elements/banners/footer.ctp #2 | 1.59 | |
| » » » Rendering APP/View/Elements/layout/footer-hours.ctp | 0.35 | |
| » » » Rendering APP/View/Elements/layout/footer-contact.ctp | 0.15 | |
| Event: View.afterLayout | 0.00 |
