Modiano 4 Color Poker Dual Deck

Geen beoordelingen | Schrijf de eerste beoordeling

Beschikbaarheid: Niet in stock: levertermijn ongeveer twee weken.

Product ID: MOD-4C2

€11,95

Modiano is een wereldberoemde speelkaartenmaker uit Italië. Hun specialiteit is het maken van 100% plastic kaarten van de allerhoogste kwaliteit. Ook deze 4 color decks zijn van de gekende Modiano-kwaliteit.

Met deze 4-kleur set van Modiano pokerkaarten heeft elke suit z'n eigen kleur: zwart voor schoppen, blauw voor ruiten, groen voor klaveren en rood voor harten. Het lijkt misschien minder "normaal", maar het maakt het spel wél duidelijk: een flushdraw op het bord is nooit verborgen!

Deze kaarten zijn voorzien van normale indexes en zijn poker size (63mm op 89 mm). Deze kaarten worden verkocht per twee decks, in een handige kunststof tray en kartonnen doosje voor het opbergen van de kaarten.

Beoordelingen

Schrijf hieronder een review van dit product, en help zo anderen een weloverwogen keuze maken tijdens het winkelen!

History
+

Request History

No previous requests logged.

====

Sqllog

Sql Logs

default

Total Time: 40 ms
Total Queries: 49 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` = 'nld') WHERE `I18n__slug`.`content` = 'modiano-4-color-poker-dual-deck' AND `Productgroup`.`id` = 150 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-02-08' LIMIT 1	0	0	0
SELECT `Hour`.`id`, `Hour`.`weekday`, `Hour`.`start`, `Hour`.`end`, `Hour`.`closed` FROM `tbiback_tbshops`.`hours` AS `Hour` WHERE `weekday` = 3 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-02-08' LIMIT 1	0	0	0
SELECT `Hour`.`id`, `Hour`.`weekday`, `Hour`.`start`, `Hour`.`end`, `Hour`.`closed` FROM `tbiback_tbshops`.`hours` AS `Hour` WHERE `weekday` = 3 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-02-08' LIMIT 1	0	0	0
SELECT `Hour`.`id`, `Hour`.`weekday`, `Hour`.`start`, `Hour`.`end`, `Hour`.`closed` FROM `tbiback_tbshops`.`hours` AS `Hour` WHERE `weekday` = 3 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-02-09' 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-02-09' 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 `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 `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__nld`.`content`) AS `Message__i18n_message_nld` FROM `tbiback_tbshops`.`messages` AS `Message` 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-02-08' AND `end` >= '2023-02-08' 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` = 'https://pokerhandel.be/nld/product/150/modiano-4-color-poker-dual-deck' 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` = '17f7rmbo5rou39ratdnnm9pbd2' 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` = 'nld') 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') 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` = 'nld') 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` = 'nld') 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` = 'nld') 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` = 'modiano-4-color-poker-dual-deck' AND `Productgroup`.`id` = 150 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` = 150 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` = (150) 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` = 'nld' AND `moderated` = '1' AND `Review`.`group_id` = (150)	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` = (150) 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` = 158	0	0	1	maybe slow
SELECT `Productattribute`.`id`, `Productattribute`.`product_id` FROM `tbiback_tbshops`.`productattributes` AS `Productattribute` WHERE `Productattribute`.`product_id` = (158)	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` = 150 AND `RelatedGroup`.`related_id` = `RelatedProductgroup`.`id`) WHERE `RelatedGroup`.`related_model` = 'Productgroup'	0	0	0
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` = 150 AND `RelatedGroup`.`related_id` = `RelatedBundle`.`id`) WHERE `RelatedGroup`.`related_model` = 'Bundle'	0	0	0
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` = 150 AND `AddonGroup`.`addon_id` = `AddonProductgroup`.`id`) WHERE `AddonGroup`.`addon_model` = 'Productgroup'	0	0	0
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` = 150 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` = 'nld') 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` = 'nld') WHERE `product_id` = 158	0	0	2	maybe slow
SELECT `Description`.`id`, (`I18n__description__nld`.`content`) AS `Description__i18n_description_nld`, (`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__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__nld` ON (`Description`.`id` = `I18n__description_short__nld`.`foreign_key` AND `I18n__description_short__nld`.`model` = 'Description' AND `I18n__description_short__nld`.`field` = 'description_short' AND `I18n__description_short__nld`.`locale` = 'nld') WHERE `Description`.`id` = 224 LIMIT 1	1	1	1
SELECT `Image`.`id`, (`I18n__title__nld`.`content`) AS `Image__i18n_title_nld` FROM `tbiback_tbshops`.`images` AS `Image` 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` = 399 LIMIT 1	1	1	1
SELECT `Image`.`id`, (`I18n__title__nld`.`content`) AS `Image__i18n_title_nld` FROM `tbiback_tbshops`.`images` AS `Image` 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` = 400 LIMIT 1	1	1	1
SELECT `Brand`.`id`, (`I18n__pagetitle__nld`.`content`) AS `Brand__i18n_pagetitle_nld`, (`I18n__description__nld`.`content`) AS `Brand__i18n_description_nld` FROM `tbiback_tbshops`.`brands` AS `Brand` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__pagetitle__nld` ON (`Brand`.`id` = `I18n__pagetitle__nld`.`foreign_key` AND `I18n__pagetitle__nld`.`model` = 'Brand' AND `I18n__pagetitle__nld`.`field` = 'pagetitle' AND `I18n__pagetitle__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__description__nld` ON (`Brand`.`id` = `I18n__description__nld`.`foreign_key` AND `I18n__description__nld`.`model` = 'Brand' AND `I18n__description__nld`.`field` = 'description' AND `I18n__description__nld`.`locale` = 'nld') WHERE `Brand`.`id` = 84 LIMIT 1	1	1	1
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`sorting`, `Category`.`topmenu`, `Category`.`store_id`, (`I18n__name__nld`.`content`) AS `Category__i18n_name_nld`, (`I18n__slug__nld`.`content`) AS `Category__i18n_slug_nld`, (`I18n__description__nld`.`content`) AS `Category__i18n_description_nld`, (`I18n__description_short__nld`.`content`) AS `Category__i18n_description_short_nld`, (`I18n__path__nld`.`content`) AS `Category__i18n_path_nld`, (`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__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__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__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__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__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__nld` ON (`Category`.`id` = `I18n__pagetitle__nld`.`foreign_key` AND `I18n__pagetitle__nld`.`model` = 'Category' AND `I18n__pagetitle__nld`.`field` = 'pagetitle' AND `I18n__pagetitle__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`categories` AS `ParentCategory` ON (`Category`.`parent_id` = `ParentCategory`.`id`) WHERE `Category`.`id` = 63 AND `Category`.`store_id` = 10 LIMIT 1	1	1	3	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__nld`.`content`) AS `ParentCategory__i18n_name_nld`, (`I18n__slug__nld`.`content`) AS `ParentCategory__i18n_slug_nld`, (`I18n__description__nld`.`content`) AS `ParentCategory__i18n_description_nld`, (`I18n__description_short__nld`.`content`) AS `ParentCategory__i18n_description_short_nld`, (`I18n__path__nld`.`content`) AS `ParentCategory__i18n_path_nld`, (`I18n__pagetitle__nld`.`content`) AS `ParentCategory__i18n_pagetitle_nld` FROM `tbiback_tbshops`.`categories` AS `ParentCategory` 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__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__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__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__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__nld` ON (`ParentCategory`.`id` = `I18n__pagetitle__nld`.`foreign_key` AND `I18n__pagetitle__nld`.`model` = 'Category' AND `I18n__pagetitle__nld`.`field` = 'pagetitle' AND `I18n__pagetitle__nld`.`locale` = 'nld') WHERE `ParentCategory`.`id` = 42 AND `ParentCategory`.`store_id` = 10 LIMIT 1	1	1	2	maybe slow
SELECT `Category`.`parent_id` FROM `tbiback_tbshops`.`categories` AS `Category` WHERE `Category`.`id` = 63 AND `Category`.`store_id` = 10 LIMIT 1	1	1	0
SELECT `Category`.`parent_id` FROM `tbiback_tbshops`.`categories` AS `Category` WHERE `Category`.`id` = 42 AND `Category`.`store_id` = 10 LIMIT 1	1	1	0
SELECT `Category`.`id`, (`I18n__slug__nld`.`content`) AS `Category__i18n_slug_nld` FROM `tbiback_tbshops`.`categories` AS `Category` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__slug__nld` ON (`Category`.`id` = `I18n__slug__nld`.`foreign_key` AND `I18n__slug__nld`.`model` = 'Category' AND `I18n__slug__nld`.`field` = 'slug' AND `I18n__slug__nld`.`locale` = 'nld') WHERE `Category`.`id` = 42 AND `Category`.`store_id` = 10 LIMIT 1	1	1	1
SELECT `Productattribute`.`id`, `Productattribute`.`product_id`, (`I18n__key__nld`.`content`) AS `Productattribute__i18n_key_nld`, (`I18n__value__nld`.`content`) AS `Productattribute__i18n_value_nld` FROM `tbiback_tbshops`.`productattributes` AS `Productattribute` 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__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` = 158	0	0	1	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` = 'nld') WHERE `I18n__slug`.`content` = 'modiano-4-color-poker-dual-deck' AND `Productgroup`.`id` = 150 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` = 150 LIMIT 1	0	0	1	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` = 150 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` = 'eng') WHERE `Productgroup`.`id` = 150 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` = 'eng') WHERE `Productgroup`.`id` = 150 LIMIT 1	1	1	0

Query Explain:

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

====

Timer

Memory

Peak Memory Use 19.70 MB

Message	Memory use
Component initialization	8.55 MB
Controller action start	11.69 MB
Controller render start	13.43 MB
View render complete	15.86 MB

Timers

Total Request Time: 366 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	101.72
Event: Controller.initialize	51.68
Event: Controller.startup	2.05
Controller action	89.17
Event: Controller.beforeRender	12.99
» Processing toolbar data	12.24
Rendering View	53.41
» Event: View.beforeRender	0.05
» Rendering APP/View/Productgroups/view.ctp	9.95
» » Rendering APP/View/Themed/Pokerhandel/Elements/product/detail.ctp	6.27
» » » Rendering APP/View/Elements/addthis.ctp	0.16
» Event: View.afterRender	0.04
» Event: View.beforeLayout	0.04
» Rendering APP/View/Layouts/default.ctp	20.52
» » Rendering APP/View/Elements/layout/facebook-jssdk.ctp	0.20
» » Rendering APP/View/Themed/Pokerhandel/Elements/layout/top-section.ctp	7.30
» » Rendering APP/View/Themed/Pokerhandel/Elements/layout/branding.ctp	0.99
» » Rendering APP/View/Themed/Pokerhandel/Elements/layout/main-nav.ctp	2.26
» » Rendering APP/View/Elements/layout/top-notice.ctp	0.20
» » Rendering APP/View/Elements/layout/content.ctp	1.54
» » » Rendering APP/View/Themed/Pokerhandel/Elements/layout/breadcrumbs.ctp	1.22
» » Rendering APP/View/Themed/Pokerhandel/Elements/layout/footer.ctp	0.57
» » Rendering APP/View/Themed/Pokerhandel/Elements/banners/footer.ctp #2	1.67
» » » Rendering APP/View/Elements/layout/footer-hours.ctp	0.38
» » » Rendering APP/View/Elements/layout/footer-contact.ctp	0.16
Event: View.afterLayout	0.00