Fournier werd gesticht in 1868 en werd na het ontvangen van verschillende prijzen op talloze expo's een wereldwijde referentie op het gebied van speelkaarten.
De kaarten werden gemaakt met uitzonderlijk detail door artiesten en experts in print technieken en dit doen ze tot op heden nog. Iedereen heeft tegenwoordig bijna een deck in huis en in Spanje zijn 95% van deze decks zelfs Fournier.
Het feit dat deze kaarten in casino's wereldwijd gebruikt worden, getuigt van uitzonderlijke duurzaamheid en kwaliteit welke optimaal spelplezier garanderen.
Let's play together!
Our store in Kontich is currently open until 18:00.
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 `Post`.`id`, `Post`.`user_id`, `Post`.`store_id`, `Post`.`created`, (`I18n__title`.`content`) AS `Post__i18n_title`, (`I18n__content`.`content`) AS `Post__i18n_content`, (`I18n__slug`.`content`) AS `Post__i18n_slug`, (`I18n__pagetitle`.`content`) AS `Post__i18n_pagetitle`, (`I18n__description`.`content`) AS `Post__i18n_description` FROM `tbiback_tbshops`.`posts` AS `Post` INNER JOIN `tbiback_tbshops`.`post_i18ns` AS `I18n__title` ON (`Post`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Post' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'eng') INNER JOIN `tbiback_tbshops`.`post_i18ns` AS `I18n__content` ON (`Post`.`id` = `I18n__content`.`foreign_key` AND `I18n__content`.`model` = 'Post' AND `I18n__content`.`field` = 'content' AND `I18n__content`.`locale` = 'eng') INNER JOIN `tbiback_tbshops`.`post_i18ns` AS `I18n__slug` ON (`Post`.`id` = `I18n__slug`.`foreign_key` AND `I18n__slug`.`model` = 'Post' AND `I18n__slug`.`field` = 'slug' AND `I18n__slug`.`locale` = 'eng') INNER JOIN `tbiback_tbshops`.`post_i18ns` AS `I18n__pagetitle` ON (`Post`.`id` = `I18n__pagetitle`.`foreign_key` AND `I18n__pagetitle`.`model` = 'Post' AND `I18n__pagetitle`.`field` = 'pagetitle' AND `I18n__pagetitle`.`locale` = 'eng') INNER JOIN `tbiback_tbshops`.`post_i18ns` AS `I18n__description` ON (`Post`.`id` = `I18n__description`.`foreign_key` AND `I18n__description`.`model` = 'Post' AND `I18n__description`.`field` = 'description' AND `I18n__description`.`locale` = 'eng') WHERE `I18n__slug`.`content` = 'fournier' AND `Post`.`store_id` = 10 LIMIT 1 | 0 | 0 | 2 | maybe slow |
SELECT `Post`.`id`, `Post`.`user_id`, `Post`.`store_id`, `Post`.`created`, (`I18n__title`.`content`) AS `Post__i18n_title`, (`I18n__content`.`content`) AS `Post__i18n_content`, (`I18n__slug`.`content`) AS `Post__i18n_slug`, (`I18n__pagetitle`.`content`) AS `Post__i18n_pagetitle`, (`I18n__description`.`content`) AS `Post__i18n_description` FROM `tbiback_tbshops`.`posts` AS `Post` INNER JOIN `tbiback_tbshops`.`post_i18ns` AS `I18n__title` ON (`Post`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Post' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'nld') INNER JOIN `tbiback_tbshops`.`post_i18ns` AS `I18n__content` ON (`Post`.`id` = `I18n__content`.`foreign_key` AND `I18n__content`.`model` = 'Post' AND `I18n__content`.`field` = 'content' AND `I18n__content`.`locale` = 'nld') INNER JOIN `tbiback_tbshops`.`post_i18ns` AS `I18n__slug` ON (`Post`.`id` = `I18n__slug`.`foreign_key` AND `I18n__slug`.`model` = 'Post' AND `I18n__slug`.`field` = 'slug' AND `I18n__slug`.`locale` = 'nld') INNER JOIN `tbiback_tbshops`.`post_i18ns` AS `I18n__pagetitle` ON (`Post`.`id` = `I18n__pagetitle`.`foreign_key` AND `I18n__pagetitle`.`model` = 'Post' AND `I18n__pagetitle`.`field` = 'pagetitle' AND `I18n__pagetitle`.`locale` = 'nld') INNER JOIN `tbiback_tbshops`.`post_i18ns` AS `I18n__description` ON (`Post`.`id` = `I18n__description`.`foreign_key` AND `I18n__description`.`model` = 'Post' AND `I18n__description`.`field` = 'description' AND `I18n__description`.`locale` = 'nld') WHERE `I18n__slug`.`content` = 'fournier' AND `Post`.`store_id` = 10 LIMIT 1 | 0 | 0 | 1 | maybe slow |
SELECT `Brand`.`id`, `Brand`.`name`, `Brand`.`slug`, (`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 `slug` = 'fournier' 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` = '2024-03-28' 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` = '2024-03-28' 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` = '2024-03-28' 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` = '2024-03-29' 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` = '2024-03-29' 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` <= '2024-03-28' AND `end` >= '2024-03-28' 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/eng/fournier' 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` = 'fsp5822hrak1rf97b2ggepgub5' AND `qty` > 0 | 0 | 0 | 1 | maybe slow |
SELECT `Brand`.`id`, `Brand`.`name`, `Brand`.`slug`, (`I18n__pagetitle__eng`.`content`) AS `Brand__i18n_pagetitle_eng`, (`I18n__pagetitle__nld`.`content`) AS `Brand__i18n_pagetitle_nld`, (`I18n__description__eng`.`content`) AS `Brand__i18n_description_eng`, (`I18n__description__nld`.`content`) AS `Brand__i18n_description_nld` FROM `tbiback_tbshops`.`brands` AS `Brand` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__pagetitle__eng` ON (`Brand`.`id` = `I18n__pagetitle__eng`.`foreign_key` AND `I18n__pagetitle__eng`.`model` = 'Brand' AND `I18n__pagetitle__eng`.`field` = 'pagetitle' AND `I18n__pagetitle__eng`.`locale` = 'eng') 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__eng` ON (`Brand`.`id` = `I18n__description__eng`.`foreign_key` AND `I18n__description__eng`.`model` = 'Brand' AND `I18n__description__eng`.`field` = 'description' AND `I18n__description__eng`.`locale` = 'eng') 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`.`slug` = 'fournier' LIMIT 1 | 1 | 1 | 2 | maybe slow |
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`, `Description`.`id`, `Description`.`group_id`, `Description`.`group_model`, `Description`.`store_id`, `Description`.`featured` 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') LEFT JOIN `tbiback_tbshops`.`descriptions` AS `Description` ON (`Description`.`group_id` = `Productgroup`.`id` AND `Description`.`group_model` = 'Productgroup') WHERE `brand_id` = 83 AND `Description`.`store_id` = 10 | 4 | 4 | 15 | maybe slow |
SELECT 'Bundle' as model, Bundle.id, promoprice, created FROM bundles as Bundle WHERE Bundle.id = 0 UNION SELECT 'Productgroup' as model, Productgroup.id, promoprice, created FROM productgroups as Productgroup RIGHT JOIN descriptions AS Description ON (Description.group_id = Productgroup.id) WHERE Description.id IN(218,318,530,604) ORDER BY promoprice asc LIMIT 0, 24 | 4 | 4 | 1 | maybe slow |
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`, `Brand`.`id`, `Brand`.`name`, `Brand`.`slug`, `Description`.`id`, `Description`.`group_id`, `Description`.`group_model`, `Description`.`store_id`, `Description`.`featured` 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') 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') WHERE `Productgroup`.`id` = 180 LIMIT 1 | 1 | 1 | 5 | 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` = (180) | 3 | 3 | 2 | maybe slow |
SELECT `Brand`.`id`, (`I18n__pagetitle__eng`.`content`) AS `Brand__i18n_pagetitle_eng`, (`I18n__pagetitle__nld`.`content`) AS `Brand__i18n_pagetitle_nld`, (`I18n__description__eng`.`content`) AS `Brand__i18n_description_eng`, (`I18n__description__nld`.`content`) AS `Brand__i18n_description_nld` FROM `tbiback_tbshops`.`brands` AS `Brand` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__pagetitle__eng` ON (`Brand`.`id` = `I18n__pagetitle__eng`.`foreign_key` AND `I18n__pagetitle__eng`.`model` = 'Brand' AND `I18n__pagetitle__eng`.`field` = 'pagetitle' AND `I18n__pagetitle__eng`.`locale` = 'eng') 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__eng` ON (`Brand`.`id` = `I18n__description__eng`.`foreign_key` AND `I18n__description__eng`.`model` = 'Brand' AND `I18n__description__eng`.`field` = 'description' AND `I18n__description__eng`.`locale` = 'eng') 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` = 83 LIMIT 1 | 1 | 1 | 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` = 318 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` = 468 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` = 469 LIMIT 1 | 1 | 1 | 1 | |
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` = 470 LIMIT 1 | 1 | 1 | 1 | |
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`, `Brand`.`id`, `Brand`.`name`, `Brand`.`slug`, `Description`.`id`, `Description`.`group_id`, `Description`.`group_model`, `Description`.`store_id`, `Description`.`featured` 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') 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') WHERE `Productgroup`.`id` = 377 LIMIT 1 | 1 | 1 | 6 | 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` = (377) | 2 | 2 | 2 | |
SELECT `Brand`.`id`, (`I18n__pagetitle__eng`.`content`) AS `Brand__i18n_pagetitle_eng`, (`I18n__pagetitle__nld`.`content`) AS `Brand__i18n_pagetitle_nld`, (`I18n__description__eng`.`content`) AS `Brand__i18n_description_eng`, (`I18n__description__nld`.`content`) AS `Brand__i18n_description_nld` FROM `tbiback_tbshops`.`brands` AS `Brand` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__pagetitle__eng` ON (`Brand`.`id` = `I18n__pagetitle__eng`.`foreign_key` AND `I18n__pagetitle__eng`.`model` = 'Brand' AND `I18n__pagetitle__eng`.`field` = 'pagetitle' AND `I18n__pagetitle__eng`.`locale` = 'eng') 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__eng` ON (`Brand`.`id` = `I18n__description__eng`.`foreign_key` AND `I18n__description__eng`.`model` = 'Brand' AND `I18n__description__eng`.`field` = 'description' AND `I18n__description__eng`.`locale` = 'eng') 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` = 83 LIMIT 1 | 1 | 1 | 0 | |
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` = 530 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` = 1070 LIMIT 1 | 1 | 1 | 1 | |
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` = 1071 LIMIT 1 | 1 | 1 | 1 | |
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`, `Brand`.`id`, `Brand`.`name`, `Brand`.`slug`, `Description`.`id`, `Description`.`group_id`, `Description`.`group_model`, `Description`.`store_id`, `Description`.`featured` 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') 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') WHERE `Productgroup`.`id` = 440 LIMIT 1 | 1 | 1 | 6 | 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` = (440) | 1 | 1 | 2 | maybe slow |
SELECT `Brand`.`id`, (`I18n__pagetitle__eng`.`content`) AS `Brand__i18n_pagetitle_eng`, (`I18n__pagetitle__nld`.`content`) AS `Brand__i18n_pagetitle_nld`, (`I18n__description__eng`.`content`) AS `Brand__i18n_description_eng`, (`I18n__description__nld`.`content`) AS `Brand__i18n_description_nld` FROM `tbiback_tbshops`.`brands` AS `Brand` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__pagetitle__eng` ON (`Brand`.`id` = `I18n__pagetitle__eng`.`foreign_key` AND `I18n__pagetitle__eng`.`model` = 'Brand' AND `I18n__pagetitle__eng`.`field` = 'pagetitle' AND `I18n__pagetitle__eng`.`locale` = 'eng') 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__eng` ON (`Brand`.`id` = `I18n__description__eng`.`foreign_key` AND `I18n__description__eng`.`model` = 'Brand' AND `I18n__description__eng`.`field` = 'description' AND `I18n__description__eng`.`locale` = 'eng') 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` = 83 LIMIT 1 | 1 | 1 | 0 | |
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` = 604 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` = 1072 LIMIT 1 | 1 | 1 | 1 | |
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`, `Brand`.`id`, `Brand`.`name`, `Brand`.`slug`, `Description`.`id`, `Description`.`group_id`, `Description`.`group_model`, `Description`.`store_id`, `Description`.`featured` 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') 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') WHERE `Productgroup`.`id` = 144 LIMIT 1 | 1 | 1 | 6 | 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` = (144) | 1 | 1 | 2 | maybe slow |
SELECT `Brand`.`id`, (`I18n__pagetitle__eng`.`content`) AS `Brand__i18n_pagetitle_eng`, (`I18n__pagetitle__nld`.`content`) AS `Brand__i18n_pagetitle_nld`, (`I18n__description__eng`.`content`) AS `Brand__i18n_description_eng`, (`I18n__description__nld`.`content`) AS `Brand__i18n_description_nld` FROM `tbiback_tbshops`.`brands` AS `Brand` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__pagetitle__eng` ON (`Brand`.`id` = `I18n__pagetitle__eng`.`foreign_key` AND `I18n__pagetitle__eng`.`model` = 'Brand' AND `I18n__pagetitle__eng`.`field` = 'pagetitle' AND `I18n__pagetitle__eng`.`locale` = 'eng') 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__eng` ON (`Brand`.`id` = `I18n__description__eng`.`foreign_key` AND `I18n__description__eng`.`model` = 'Brand' AND `I18n__description__eng`.`field` = 'description' AND `I18n__description__eng`.`locale` = 'eng') 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` = 83 LIMIT 1 | 1 | 1 | 0 | |
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` = 218 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` = 391 LIMIT 1 | 1 | 1 | 1 | |
SELECT count(*) as count FROM (SELECT 'Bundle' as model, Bundle.id, promoprice, created FROM bundles as Bundle WHERE Bundle.id = 0 UNION SELECT 'Productgroup' as model, Productgroup.id, promoprice, created FROM productgroups as Productgroup RIGHT JOIN descriptions AS Description ON (Description.group_id = Productgroup.id) WHERE Description.id IN(218,318,530,604) ORDER BY promoprice asc ) as groups | 1 | 1 | 1 | |
SELECT `Brand`.`id`, `Brand`.`name`, `Brand`.`slug`, (`I18n__pagetitle__eng`.`content`) AS `Brand__i18n_pagetitle_eng`, (`I18n__pagetitle__nld`.`content`) AS `Brand__i18n_pagetitle_nld`, (`I18n__description__eng`.`content`) AS `Brand__i18n_description_eng`, (`I18n__description__nld`.`content`) AS `Brand__i18n_description_nld` FROM `tbiback_tbshops`.`brands` AS `Brand` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__pagetitle__eng` ON (`Brand`.`id` = `I18n__pagetitle__eng`.`foreign_key` AND `I18n__pagetitle__eng`.`model` = 'Brand' AND `I18n__pagetitle__eng`.`field` = 'pagetitle' AND `I18n__pagetitle__eng`.`locale` = 'eng') 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__eng` ON (`Brand`.`id` = `I18n__description__eng`.`foreign_key` AND `I18n__description__eng`.`model` = 'Brand' AND `I18n__description__eng`.`field` = 'description' AND `I18n__description__eng`.`locale` = 'eng') 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`.`slug` = 'fournier' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Brand`.`id`, `Brand`.`name`, `Brand`.`slug`, (`I18n__pagetitle__eng`.`content`) AS `Brand__i18n_pagetitle_eng`, (`I18n__pagetitle__nld`.`content`) AS `Brand__i18n_pagetitle_nld`, (`I18n__description__eng`.`content`) AS `Brand__i18n_description_eng`, (`I18n__description__nld`.`content`) AS `Brand__i18n_description_nld` FROM `tbiback_tbshops`.`brands` AS `Brand` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__pagetitle__eng` ON (`Brand`.`id` = `I18n__pagetitle__eng`.`foreign_key` AND `I18n__pagetitle__eng`.`model` = 'Brand' AND `I18n__pagetitle__eng`.`field` = 'pagetitle' AND `I18n__pagetitle__eng`.`locale` = 'eng') 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__eng` ON (`Brand`.`id` = `I18n__description__eng`.`foreign_key` AND `I18n__description__eng`.`model` = 'Brand' AND `I18n__description__eng`.`field` = 'description' AND `I18n__description__eng`.`locale` = 'eng') 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`.`slug` = 'fournier' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Brand`.`id`, `Brand`.`name`, `Brand`.`slug`, (`I18n__pagetitle__eng`.`content`) AS `Brand__i18n_pagetitle_eng`, (`I18n__pagetitle__nld`.`content`) AS `Brand__i18n_pagetitle_nld`, (`I18n__description__eng`.`content`) AS `Brand__i18n_description_eng`, (`I18n__description__nld`.`content`) AS `Brand__i18n_description_nld` FROM `tbiback_tbshops`.`brands` AS `Brand` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__pagetitle__eng` ON (`Brand`.`id` = `I18n__pagetitle__eng`.`foreign_key` AND `I18n__pagetitle__eng`.`model` = 'Brand' AND `I18n__pagetitle__eng`.`field` = 'pagetitle' AND `I18n__pagetitle__eng`.`locale` = 'eng') 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__eng` ON (`Brand`.`id` = `I18n__description__eng`.`foreign_key` AND `I18n__description__eng`.`model` = 'Brand' AND `I18n__description__eng`.`field` = 'description' AND `I18n__description__eng`.`locale` = 'eng') 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`.`slug` = 'fournier' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Brand`.`id`, `Brand`.`name`, `Brand`.`slug`, (`I18n__pagetitle__eng`.`content`) AS `Brand__i18n_pagetitle_eng`, (`I18n__pagetitle__nld`.`content`) AS `Brand__i18n_pagetitle_nld`, (`I18n__description__eng`.`content`) AS `Brand__i18n_description_eng`, (`I18n__description__nld`.`content`) AS `Brand__i18n_description_nld` FROM `tbiback_tbshops`.`brands` AS `Brand` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__pagetitle__eng` ON (`Brand`.`id` = `I18n__pagetitle__eng`.`foreign_key` AND `I18n__pagetitle__eng`.`model` = 'Brand' AND `I18n__pagetitle__eng`.`field` = 'pagetitle' AND `I18n__pagetitle__eng`.`locale` = 'eng') 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__eng` ON (`Brand`.`id` = `I18n__description__eng`.`foreign_key` AND `I18n__description__eng`.`model` = 'Brand' AND `I18n__description__eng`.`field` = 'description' AND `I18n__description__eng`.`locale` = 'eng') 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`.`slug` = 'fournier' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Brand`.`id`, `Brand`.`name`, `Brand`.`slug`, (`I18n__pagetitle__eng`.`content`) AS `Brand__i18n_pagetitle_eng`, (`I18n__pagetitle__nld`.`content`) AS `Brand__i18n_pagetitle_nld`, (`I18n__description__eng`.`content`) AS `Brand__i18n_description_eng`, (`I18n__description__nld`.`content`) AS `Brand__i18n_description_nld` FROM `tbiback_tbshops`.`brands` AS `Brand` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__pagetitle__eng` ON (`Brand`.`id` = `I18n__pagetitle__eng`.`foreign_key` AND `I18n__pagetitle__eng`.`model` = 'Brand' AND `I18n__pagetitle__eng`.`field` = 'pagetitle' AND `I18n__pagetitle__eng`.`locale` = 'eng') 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__eng` ON (`Brand`.`id` = `I18n__description__eng`.`foreign_key` AND `I18n__description__eng`.`model` = 'Brand' AND `I18n__description__eng`.`field` = 'description' AND `I18n__description__eng`.`locale` = 'eng') 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`.`slug` = 'fournier' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Brand`.`id`, `Brand`.`name`, `Brand`.`slug`, (`I18n__pagetitle__eng`.`content`) AS `Brand__i18n_pagetitle_eng`, (`I18n__pagetitle__nld`.`content`) AS `Brand__i18n_pagetitle_nld`, (`I18n__description__eng`.`content`) AS `Brand__i18n_description_eng`, (`I18n__description__nld`.`content`) AS `Brand__i18n_description_nld` FROM `tbiback_tbshops`.`brands` AS `Brand` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__pagetitle__eng` ON (`Brand`.`id` = `I18n__pagetitle__eng`.`foreign_key` AND `I18n__pagetitle__eng`.`model` = 'Brand' AND `I18n__pagetitle__eng`.`field` = 'pagetitle' AND `I18n__pagetitle__eng`.`locale` = 'eng') 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__eng` ON (`Brand`.`id` = `I18n__description__eng`.`foreign_key` AND `I18n__description__eng`.`model` = 'Brand' AND `I18n__description__eng`.`field` = 'description' AND `I18n__description__eng`.`locale` = 'eng') 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`.`slug` = 'fournier' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Brand`.`id`, `Brand`.`name`, `Brand`.`slug`, (`I18n__pagetitle__eng`.`content`) AS `Brand__i18n_pagetitle_eng`, (`I18n__pagetitle__nld`.`content`) AS `Brand__i18n_pagetitle_nld`, (`I18n__description__eng`.`content`) AS `Brand__i18n_description_eng`, (`I18n__description__nld`.`content`) AS `Brand__i18n_description_nld` FROM `tbiback_tbshops`.`brands` AS `Brand` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__pagetitle__eng` ON (`Brand`.`id` = `I18n__pagetitle__eng`.`foreign_key` AND `I18n__pagetitle__eng`.`model` = 'Brand' AND `I18n__pagetitle__eng`.`field` = 'pagetitle' AND `I18n__pagetitle__eng`.`locale` = 'eng') 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__eng` ON (`Brand`.`id` = `I18n__description__eng`.`foreign_key` AND `I18n__description__eng`.`model` = 'Brand' AND `I18n__description__eng`.`field` = 'description' AND `I18n__description__eng`.`locale` = 'eng') 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`.`slug` = 'fournier' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Brand`.`id`, `Brand`.`name`, `Brand`.`slug`, (`I18n__pagetitle__eng`.`content`) AS `Brand__i18n_pagetitle_eng`, (`I18n__pagetitle__nld`.`content`) AS `Brand__i18n_pagetitle_nld`, (`I18n__description__eng`.`content`) AS `Brand__i18n_description_eng`, (`I18n__description__nld`.`content`) AS `Brand__i18n_description_nld` FROM `tbiback_tbshops`.`brands` AS `Brand` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__pagetitle__eng` ON (`Brand`.`id` = `I18n__pagetitle__eng`.`foreign_key` AND `I18n__pagetitle__eng`.`model` = 'Brand' AND `I18n__pagetitle__eng`.`field` = 'pagetitle' AND `I18n__pagetitle__eng`.`locale` = 'eng') 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__eng` ON (`Brand`.`id` = `I18n__description__eng`.`foreign_key` AND `I18n__description__eng`.`model` = 'Brand' AND `I18n__description__eng`.`field` = 'description' AND `I18n__description__eng`.`locale` = 'eng') 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`.`slug` = 'fournier' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Brand`.`id`, `Brand`.`name`, `Brand`.`slug`, (`I18n__pagetitle__eng`.`content`) AS `Brand__i18n_pagetitle_eng`, (`I18n__pagetitle__nld`.`content`) AS `Brand__i18n_pagetitle_nld`, (`I18n__description__eng`.`content`) AS `Brand__i18n_description_eng`, (`I18n__description__nld`.`content`) AS `Brand__i18n_description_nld` FROM `tbiback_tbshops`.`brands` AS `Brand` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__pagetitle__eng` ON (`Brand`.`id` = `I18n__pagetitle__eng`.`foreign_key` AND `I18n__pagetitle__eng`.`model` = 'Brand' AND `I18n__pagetitle__eng`.`field` = 'pagetitle' AND `I18n__pagetitle__eng`.`locale` = 'eng') 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__eng` ON (`Brand`.`id` = `I18n__description__eng`.`foreign_key` AND `I18n__description__eng`.`model` = 'Brand' AND `I18n__description__eng`.`field` = 'description' AND `I18n__description__eng`.`locale` = 'eng') 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`.`slug` = 'fournier' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Brand`.`id`, `Brand`.`name`, `Brand`.`slug`, (`I18n__pagetitle__eng`.`content`) AS `Brand__i18n_pagetitle_eng`, (`I18n__pagetitle__nld`.`content`) AS `Brand__i18n_pagetitle_nld`, (`I18n__description__eng`.`content`) AS `Brand__i18n_description_eng`, (`I18n__description__nld`.`content`) AS `Brand__i18n_description_nld` FROM `tbiback_tbshops`.`brands` AS `Brand` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__pagetitle__eng` ON (`Brand`.`id` = `I18n__pagetitle__eng`.`foreign_key` AND `I18n__pagetitle__eng`.`model` = 'Brand' AND `I18n__pagetitle__eng`.`field` = 'pagetitle' AND `I18n__pagetitle__eng`.`locale` = 'eng') 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__eng` ON (`Brand`.`id` = `I18n__description__eng`.`foreign_key` AND `I18n__description__eng`.`model` = 'Brand' AND `I18n__description__eng`.`field` = 'description' AND `I18n__description__eng`.`locale` = 'eng') 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`.`slug` = 'fournier' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Brand`.`id`, `Brand`.`name`, `Brand`.`slug`, (`I18n__pagetitle__eng`.`content`) AS `Brand__i18n_pagetitle_eng`, (`I18n__pagetitle__nld`.`content`) AS `Brand__i18n_pagetitle_nld`, (`I18n__description__eng`.`content`) AS `Brand__i18n_description_eng`, (`I18n__description__nld`.`content`) AS `Brand__i18n_description_nld` FROM `tbiback_tbshops`.`brands` AS `Brand` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__pagetitle__eng` ON (`Brand`.`id` = `I18n__pagetitle__eng`.`foreign_key` AND `I18n__pagetitle__eng`.`model` = 'Brand' AND `I18n__pagetitle__eng`.`field` = 'pagetitle' AND `I18n__pagetitle__eng`.`locale` = 'eng') 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__eng` ON (`Brand`.`id` = `I18n__description__eng`.`foreign_key` AND `I18n__description__eng`.`model` = 'Brand' AND `I18n__description__eng`.`field` = 'description' AND `I18n__description__eng`.`locale` = 'eng') 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`.`slug` = 'fournier' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Brand`.`id`, `Brand`.`name`, `Brand`.`slug`, (`I18n__pagetitle__eng`.`content`) AS `Brand__i18n_pagetitle_eng`, (`I18n__pagetitle__nld`.`content`) AS `Brand__i18n_pagetitle_nld`, (`I18n__description__eng`.`content`) AS `Brand__i18n_description_eng`, (`I18n__description__nld`.`content`) AS `Brand__i18n_description_nld` FROM `tbiback_tbshops`.`brands` AS `Brand` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__pagetitle__eng` ON (`Brand`.`id` = `I18n__pagetitle__eng`.`foreign_key` AND `I18n__pagetitle__eng`.`model` = 'Brand' AND `I18n__pagetitle__eng`.`field` = 'pagetitle' AND `I18n__pagetitle__eng`.`locale` = 'eng') 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__eng` ON (`Brand`.`id` = `I18n__description__eng`.`foreign_key` AND `I18n__description__eng`.`model` = 'Brand' AND `I18n__description__eng`.`field` = 'description' AND `I18n__description__eng`.`locale` = 'eng') 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`.`slug` = 'fournier' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Brand`.`id`, `Brand`.`name`, `Brand`.`slug`, (`I18n__pagetitle__eng`.`content`) AS `Brand__i18n_pagetitle_eng`, (`I18n__pagetitle__nld`.`content`) AS `Brand__i18n_pagetitle_nld`, (`I18n__description__eng`.`content`) AS `Brand__i18n_description_eng`, (`I18n__description__nld`.`content`) AS `Brand__i18n_description_nld` FROM `tbiback_tbshops`.`brands` AS `Brand` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__pagetitle__eng` ON (`Brand`.`id` = `I18n__pagetitle__eng`.`foreign_key` AND `I18n__pagetitle__eng`.`model` = 'Brand' AND `I18n__pagetitle__eng`.`field` = 'pagetitle' AND `I18n__pagetitle__eng`.`locale` = 'eng') 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__eng` ON (`Brand`.`id` = `I18n__description__eng`.`foreign_key` AND `I18n__description__eng`.`model` = 'Brand' AND `I18n__description__eng`.`field` = 'description' AND `I18n__description__eng`.`locale` = 'eng') 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`.`slug` = 'fournier' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Brand`.`id`, `Brand`.`name`, `Brand`.`slug`, (`I18n__pagetitle__eng`.`content`) AS `Brand__i18n_pagetitle_eng`, (`I18n__pagetitle__nld`.`content`) AS `Brand__i18n_pagetitle_nld`, (`I18n__description__eng`.`content`) AS `Brand__i18n_description_eng`, (`I18n__description__nld`.`content`) AS `Brand__i18n_description_nld` FROM `tbiback_tbshops`.`brands` AS `Brand` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__pagetitle__eng` ON (`Brand`.`id` = `I18n__pagetitle__eng`.`foreign_key` AND `I18n__pagetitle__eng`.`model` = 'Brand' AND `I18n__pagetitle__eng`.`field` = 'pagetitle' AND `I18n__pagetitle__eng`.`locale` = 'eng') 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__eng` ON (`Brand`.`id` = `I18n__description__eng`.`foreign_key` AND `I18n__description__eng`.`model` = 'Brand' AND `I18n__description__eng`.`field` = 'description' AND `I18n__description__eng`.`locale` = 'eng') 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`.`slug` = 'fournier' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Brand`.`id`, `Brand`.`name`, `Brand`.`slug`, (`I18n__pagetitle__eng`.`content`) AS `Brand__i18n_pagetitle_eng`, (`I18n__pagetitle__nld`.`content`) AS `Brand__i18n_pagetitle_nld`, (`I18n__description__eng`.`content`) AS `Brand__i18n_description_eng`, (`I18n__description__nld`.`content`) AS `Brand__i18n_description_nld` FROM `tbiback_tbshops`.`brands` AS `Brand` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__pagetitle__eng` ON (`Brand`.`id` = `I18n__pagetitle__eng`.`foreign_key` AND `I18n__pagetitle__eng`.`model` = 'Brand' AND `I18n__pagetitle__eng`.`field` = 'pagetitle' AND `I18n__pagetitle__eng`.`locale` = 'eng') 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__eng` ON (`Brand`.`id` = `I18n__description__eng`.`foreign_key` AND `I18n__description__eng`.`model` = 'Brand' AND `I18n__description__eng`.`field` = 'description' AND `I18n__description__eng`.`locale` = 'eng') 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`.`slug` = 'fournier' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Brand`.`id`, `Brand`.`name`, `Brand`.`slug`, (`I18n__pagetitle__eng`.`content`) AS `Brand__i18n_pagetitle_eng`, (`I18n__pagetitle__nld`.`content`) AS `Brand__i18n_pagetitle_nld`, (`I18n__description__eng`.`content`) AS `Brand__i18n_description_eng`, (`I18n__description__nld`.`content`) AS `Brand__i18n_description_nld` FROM `tbiback_tbshops`.`brands` AS `Brand` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__pagetitle__eng` ON (`Brand`.`id` = `I18n__pagetitle__eng`.`foreign_key` AND `I18n__pagetitle__eng`.`model` = 'Brand' AND `I18n__pagetitle__eng`.`field` = 'pagetitle' AND `I18n__pagetitle__eng`.`locale` = 'eng') 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__eng` ON (`Brand`.`id` = `I18n__description__eng`.`foreign_key` AND `I18n__description__eng`.`model` = 'Brand' AND `I18n__description__eng`.`field` = 'description' AND `I18n__description__eng`.`locale` = 'eng') 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`.`slug` = 'fournier' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Brand`.`id`, `Brand`.`name`, `Brand`.`slug`, (`I18n__pagetitle__eng`.`content`) AS `Brand__i18n_pagetitle_eng`, (`I18n__pagetitle__nld`.`content`) AS `Brand__i18n_pagetitle_nld`, (`I18n__description__eng`.`content`) AS `Brand__i18n_description_eng`, (`I18n__description__nld`.`content`) AS `Brand__i18n_description_nld` FROM `tbiback_tbshops`.`brands` AS `Brand` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__pagetitle__eng` ON (`Brand`.`id` = `I18n__pagetitle__eng`.`foreign_key` AND `I18n__pagetitle__eng`.`model` = 'Brand' AND `I18n__pagetitle__eng`.`field` = 'pagetitle' AND `I18n__pagetitle__eng`.`locale` = 'eng') 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__eng` ON (`Brand`.`id` = `I18n__description__eng`.`foreign_key` AND `I18n__description__eng`.`model` = 'Brand' AND `I18n__description__eng`.`field` = 'description' AND `I18n__description__eng`.`locale` = 'eng') 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`.`slug` = 'fournier' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Brand`.`id`, `Brand`.`name`, `Brand`.`slug`, (`I18n__pagetitle__eng`.`content`) AS `Brand__i18n_pagetitle_eng`, (`I18n__pagetitle__nld`.`content`) AS `Brand__i18n_pagetitle_nld`, (`I18n__description__eng`.`content`) AS `Brand__i18n_description_eng`, (`I18n__description__nld`.`content`) AS `Brand__i18n_description_nld` FROM `tbiback_tbshops`.`brands` AS `Brand` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__pagetitle__eng` ON (`Brand`.`id` = `I18n__pagetitle__eng`.`foreign_key` AND `I18n__pagetitle__eng`.`model` = 'Brand' AND `I18n__pagetitle__eng`.`field` = 'pagetitle' AND `I18n__pagetitle__eng`.`locale` = 'eng') 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__eng` ON (`Brand`.`id` = `I18n__description__eng`.`foreign_key` AND `I18n__description__eng`.`model` = 'Brand' AND `I18n__description__eng`.`field` = 'description' AND `I18n__description__eng`.`locale` = 'eng') 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`.`slug` = 'fournier' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Post`.`id`, `Post`.`user_id`, `Post`.`store_id`, `Post`.`created`, (`I18n__title`.`content`) AS `Post__i18n_title`, (`I18n__content`.`content`) AS `Post__i18n_content`, (`I18n__slug`.`content`) AS `Post__i18n_slug`, (`I18n__pagetitle`.`content`) AS `Post__i18n_pagetitle`, (`I18n__description`.`content`) AS `Post__i18n_description` FROM `tbiback_tbshops`.`posts` AS `Post` INNER JOIN `tbiback_tbshops`.`post_i18ns` AS `I18n__title` ON (`Post`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Post' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'eng') INNER JOIN `tbiback_tbshops`.`post_i18ns` AS `I18n__content` ON (`Post`.`id` = `I18n__content`.`foreign_key` AND `I18n__content`.`model` = 'Post' AND `I18n__content`.`field` = 'content' AND `I18n__content`.`locale` = 'eng') INNER JOIN `tbiback_tbshops`.`post_i18ns` AS `I18n__slug` ON (`Post`.`id` = `I18n__slug`.`foreign_key` AND `I18n__slug`.`model` = 'Post' AND `I18n__slug`.`field` = 'slug' AND `I18n__slug`.`locale` = 'eng') INNER JOIN `tbiback_tbshops`.`post_i18ns` AS `I18n__pagetitle` ON (`Post`.`id` = `I18n__pagetitle`.`foreign_key` AND `I18n__pagetitle`.`model` = 'Post' AND `I18n__pagetitle`.`field` = 'pagetitle' AND `I18n__pagetitle`.`locale` = 'eng') INNER JOIN `tbiback_tbshops`.`post_i18ns` AS `I18n__description` ON (`Post`.`id` = `I18n__description`.`foreign_key` AND `I18n__description`.`model` = 'Post' AND `I18n__description`.`field` = 'description' AND `I18n__description`.`locale` = 'eng') WHERE `I18n__slug`.`content` = 'fournier' AND `Post`.`store_id` = 10 LIMIT 1 | 0 | 0 | 0 | |
SELECT `Post`.`id`, `Post`.`user_id`, `Post`.`store_id`, `Post`.`created`, (`I18n__title`.`content`) AS `Post__i18n_title`, (`I18n__content`.`content`) AS `Post__i18n_content`, (`I18n__slug`.`content`) AS `Post__i18n_slug`, (`I18n__pagetitle`.`content`) AS `Post__i18n_pagetitle`, (`I18n__description`.`content`) AS `Post__i18n_description` FROM `tbiback_tbshops`.`posts` AS `Post` INNER JOIN `tbiback_tbshops`.`post_i18ns` AS `I18n__title` ON (`Post`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Post' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'nld') INNER JOIN `tbiback_tbshops`.`post_i18ns` AS `I18n__content` ON (`Post`.`id` = `I18n__content`.`foreign_key` AND `I18n__content`.`model` = 'Post' AND `I18n__content`.`field` = 'content' AND `I18n__content`.`locale` = 'nld') INNER JOIN `tbiback_tbshops`.`post_i18ns` AS `I18n__slug` ON (`Post`.`id` = `I18n__slug`.`foreign_key` AND `I18n__slug`.`model` = 'Post' AND `I18n__slug`.`field` = 'slug' AND `I18n__slug`.`locale` = 'nld') INNER JOIN `tbiback_tbshops`.`post_i18ns` AS `I18n__pagetitle` ON (`Post`.`id` = `I18n__pagetitle`.`foreign_key` AND `I18n__pagetitle`.`model` = 'Post' AND `I18n__pagetitle`.`field` = 'pagetitle' AND `I18n__pagetitle`.`locale` = 'nld') INNER JOIN `tbiback_tbshops`.`post_i18ns` AS `I18n__description` ON (`Post`.`id` = `I18n__description`.`foreign_key` AND `I18n__description`.`model` = 'Post' AND `I18n__description`.`field` = 'description' AND `I18n__description`.`locale` = 'nld') WHERE `I18n__slug`.`content` = 'fournier' AND `Post`.`store_id` = 10 LIMIT 1 | 0 | 0 | 0 | |
SELECT `Brand`.`id`, `Brand`.`name`, `Brand`.`slug`, (`I18n__pagetitle__eng`.`content`) AS `Brand__i18n_pagetitle_eng`, (`I18n__pagetitle__nld`.`content`) AS `Brand__i18n_pagetitle_nld`, (`I18n__description__eng`.`content`) AS `Brand__i18n_description_eng`, (`I18n__description__nld`.`content`) AS `Brand__i18n_description_nld` FROM `tbiback_tbshops`.`brands` AS `Brand` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__pagetitle__eng` ON (`Brand`.`id` = `I18n__pagetitle__eng`.`foreign_key` AND `I18n__pagetitle__eng`.`model` = 'Brand' AND `I18n__pagetitle__eng`.`field` = 'pagetitle' AND `I18n__pagetitle__eng`.`locale` = 'eng') 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__eng` ON (`Brand`.`id` = `I18n__description__eng`.`foreign_key` AND `I18n__description__eng`.`model` = 'Brand' AND `I18n__description__eng`.`field` = 'description' AND `I18n__description__eng`.`locale` = 'eng') 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 `slug` = 'fournier' LIMIT 1 | 1 | 1 | 2 | maybe slow |
SELECT `Brand`.`id`, `Brand`.`name`, `Brand`.`slug`, (`I18n__pagetitle__eng`.`content`) AS `Brand__i18n_pagetitle_eng`, (`I18n__pagetitle__nld`.`content`) AS `Brand__i18n_pagetitle_nld`, (`I18n__description__eng`.`content`) AS `Brand__i18n_description_eng`, (`I18n__description__nld`.`content`) AS `Brand__i18n_description_nld` FROM `tbiback_tbshops`.`brands` AS `Brand` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__pagetitle__eng` ON (`Brand`.`id` = `I18n__pagetitle__eng`.`foreign_key` AND `I18n__pagetitle__eng`.`model` = 'Brand' AND `I18n__pagetitle__eng`.`field` = 'pagetitle' AND `I18n__pagetitle__eng`.`locale` = 'eng') 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__eng` ON (`Brand`.`id` = `I18n__description__eng`.`foreign_key` AND `I18n__description__eng`.`model` = 'Brand' AND `I18n__description__eng`.`field` = 'description' AND `I18n__description__eng`.`locale` = 'eng') 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`.`slug` = 'fournier' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Brand`.`id`, `Brand`.`name`, `Brand`.`slug`, (`I18n__pagetitle__eng`.`content`) AS `Brand__i18n_pagetitle_eng`, (`I18n__pagetitle__nld`.`content`) AS `Brand__i18n_pagetitle_nld`, (`I18n__description__eng`.`content`) AS `Brand__i18n_description_eng`, (`I18n__description__nld`.`content`) AS `Brand__i18n_description_nld` FROM `tbiback_tbshops`.`brands` AS `Brand` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__pagetitle__eng` ON (`Brand`.`id` = `I18n__pagetitle__eng`.`foreign_key` AND `I18n__pagetitle__eng`.`model` = 'Brand' AND `I18n__pagetitle__eng`.`field` = 'pagetitle' AND `I18n__pagetitle__eng`.`locale` = 'eng') 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__eng` ON (`Brand`.`id` = `I18n__description__eng`.`foreign_key` AND `I18n__description__eng`.`model` = 'Brand' AND `I18n__description__eng`.`field` = 'description' AND `I18n__description__eng`.`locale` = 'eng') 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`.`slug` = 'fournier' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Brand`.`id`, `Brand`.`name`, `Brand`.`slug`, (`I18n__pagetitle__eng`.`content`) AS `Brand__i18n_pagetitle_eng`, (`I18n__pagetitle__nld`.`content`) AS `Brand__i18n_pagetitle_nld`, (`I18n__description__eng`.`content`) AS `Brand__i18n_description_eng`, (`I18n__description__nld`.`content`) AS `Brand__i18n_description_nld` FROM `tbiback_tbshops`.`brands` AS `Brand` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__pagetitle__eng` ON (`Brand`.`id` = `I18n__pagetitle__eng`.`foreign_key` AND `I18n__pagetitle__eng`.`model` = 'Brand' AND `I18n__pagetitle__eng`.`field` = 'pagetitle' AND `I18n__pagetitle__eng`.`locale` = 'eng') 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__eng` ON (`Brand`.`id` = `I18n__description__eng`.`foreign_key` AND `I18n__description__eng`.`model` = 'Brand' AND `I18n__description__eng`.`field` = 'description' AND `I18n__description__eng`.`locale` = 'eng') 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`.`slug` = 'fournier' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Brand`.`id`, `Brand`.`name`, `Brand`.`slug`, (`I18n__pagetitle__eng`.`content`) AS `Brand__i18n_pagetitle_eng`, (`I18n__pagetitle__nld`.`content`) AS `Brand__i18n_pagetitle_nld`, (`I18n__description__eng`.`content`) AS `Brand__i18n_description_eng`, (`I18n__description__nld`.`content`) AS `Brand__i18n_description_nld` FROM `tbiback_tbshops`.`brands` AS `Brand` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__pagetitle__eng` ON (`Brand`.`id` = `I18n__pagetitle__eng`.`foreign_key` AND `I18n__pagetitle__eng`.`model` = 'Brand' AND `I18n__pagetitle__eng`.`field` = 'pagetitle' AND `I18n__pagetitle__eng`.`locale` = 'eng') 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__eng` ON (`Brand`.`id` = `I18n__description__eng`.`foreign_key` AND `I18n__description__eng`.`model` = 'Brand' AND `I18n__description__eng`.`field` = 'description' AND `I18n__description__eng`.`locale` = 'eng') 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`.`slug` = 'fournier' LIMIT 1 | 1 | 1 | 0 |
Peak Memory Use 11.43 MB
Message | Memory use |
---|---|
Component initialization | 3.45 MB |
Controller action start | 5.30 MB |
Controller render start | 5.83 MB |
View render complete | 6.93 MB |
Total Request Time: 400 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 53.99 | |
Event: Controller.initialize | 46.51 | |
Event: Controller.startup | 1.62 | |
Controller action | 131.18 | |
Event: Controller.beforeRender | 15.90 | |
» Processing toolbar data | 15.07 | |
Rendering View | 74.05 | |
» Event: View.beforeRender | 0.07 | |
» Rendering APP/View/Brands/view.ctp | 30.28 | |
» » Rendering APP/View/Themed/Pokerhandel/Elements/catalog/sidebar.ctp | 3.79 | |
» » Rendering APP/View/Themed/Pokerhandel/Elements/layout/sidebar.ctp #2 | 28.67 | |
» » » » Rendering APP/View/Elements/stores/pokerhandel/troeven.ctp | 0.25 | |
» » » Rendering APP/View/Themed/Pokerhandel/Elements/catalog/toolbar.ctp | 10.52 | |
» » » » Rendering APP/View/Elements/pagination_frontend.ctp | 0.41 | |
» » » Rendering APP/View/Themed/Pokerhandel/Elements/group/group-item.ctp | 1.02 | |
» » » Rendering APP/View/Themed/Pokerhandel/Elements/group/group-item.ctp #2 | 0.68 | |
» » » Rendering APP/View/Themed/Pokerhandel/Elements/group/group-item.ctp #3 | 0.66 | |
» » » Rendering APP/View/Themed/Pokerhandel/Elements/group/group-item.ctp #4 | 0.63 | |
» » » Rendering APP/View/Themed/Pokerhandel/Elements/catalog/toolbar.ctp #2 | 10.34 | |
» » » » Rendering APP/View/Elements/pagination_frontend.ctp #2 | 0.27 | |
» Event: View.afterRender | 0.05 | |
» Event: View.beforeLayout | 0.06 | |
» Rendering APP/View/Layouts/default.ctp | 26.56 | |
» » Rendering APP/View/Elements/layout/facebook-jssdk.ctp | 0.24 | |
» » Rendering APP/View/Themed/Pokerhandel/Elements/layout/top-section.ctp | 4.56 | |
» » Rendering APP/View/Themed/Pokerhandel/Elements/layout/branding.ctp | 1.28 | |
» » Rendering APP/View/Themed/Pokerhandel/Elements/layout/main-nav.ctp | 2.55 | |
» » Rendering APP/View/Elements/layout/top-notice.ctp | 0.22 | |
» » Rendering APP/View/Elements/layout/content.ctp | 3.89 | |
» » » Rendering APP/View/Themed/Pokerhandel/Elements/layout/breadcrumbs.ctp | 3.44 | |
» » Rendering APP/View/Themed/Pokerhandel/Elements/layout/footer.ctp | 0.67 | |
» » Rendering APP/View/Themed/Pokerhandel/Elements/banners/footer.ctp #2 | 2.22 | |
» » » Rendering APP/View/Elements/layout/footer-hours.ctp | 0.35 | |
» » » Rendering APP/View/Elements/layout/footer-contact.ctp | 0.26 | |
Event: View.afterLayout | 0.00 |