| 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` = 'massagekaars.be' LIMIT 1 | 1 | 1 | 8 | maybe slow |
| SELECT `StoreSetting`.`id`, `StoreSetting`.`key`, `StoreSetting`.`value`, `StoreSetting`.`type`, `StoreSetting`.`store_id` FROM `tbiback_tbshops`.`store_settings` AS `StoreSetting` WHERE `StoreSetting`.`store_id` = (21) | 14 | 14 | 1 | 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` = 'zijn-de-orli-massagekaarsen-veilig-voor-mijn-huid-en-omgeving' AND `Post`.`store_id` = 21 LIMIT 1 | 1 | 1 | 4 | maybe slow |
| SELECT `HourException`.`id`, `HourException`.`date`, `HourException`.`start`, `HourException`.`end`, `HourException`.`closed`, `HourException`.`store_location_id` FROM `tbiback_tbshops`.`hour_exceptions` AS `HourException` WHERE `date` = '2023-03-26' LIMIT 1 | 0 | 0 | 0 | |
| SELECT `Hour`.`id`, `Hour`.`weekday`, `Hour`.`start`, `Hour`.`end`, `Hour`.`closed` FROM `tbiback_tbshops`.`hours` AS `Hour` WHERE `weekday` = 7 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `HourException`.`id`, `HourException`.`date`, `HourException`.`start`, `HourException`.`end`, `HourException`.`closed`, `HourException`.`store_location_id` FROM `tbiback_tbshops`.`hour_exceptions` AS `HourException` WHERE `date` = '2023-03-26' LIMIT 1 | 0 | 0 | 0 | |
| SELECT `Hour`.`id`, `Hour`.`weekday`, `Hour`.`start`, `Hour`.`end`, `Hour`.`closed` FROM `tbiback_tbshops`.`hours` AS `Hour` WHERE `weekday` = 7 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `HourException`.`id`, `HourException`.`date`, `HourException`.`start`, `HourException`.`end`, `HourException`.`closed`, `HourException`.`store_location_id` FROM `tbiback_tbshops`.`hour_exceptions` AS `HourException` WHERE `date` = '2023-03-26' LIMIT 1 | 0 | 0 | 0 | |
| SELECT `Hour`.`id`, `Hour`.`weekday`, `Hour`.`start`, `Hour`.`end`, `Hour`.`closed` FROM `tbiback_tbshops`.`hours` AS `Hour` WHERE `weekday` = 7 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `HourException`.`id`, `HourException`.`date`, `HourException`.`start`, `HourException`.`end`, `HourException`.`closed`, `HourException`.`store_location_id` FROM `tbiback_tbshops`.`hour_exceptions` AS `HourException` WHERE `date` = '2023-03-27' LIMIT 1 | 0 | 0 | 0 | |
| SELECT `Hour`.`id`, `Hour`.`weekday`, `Hour`.`start`, `Hour`.`end`, `Hour`.`closed` FROM `tbiback_tbshops`.`hours` AS `Hour` WHERE `weekday` = 1 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `HourException`.`id`, `HourException`.`date`, `HourException`.`start`, `HourException`.`end`, `HourException`.`closed`, `HourException`.`store_location_id` FROM `tbiback_tbshops`.`hour_exceptions` AS `HourException` WHERE `date` = '2023-03-27' LIMIT 1 | 0 | 0 | 0 | |
| SELECT `Hour`.`id`, `Hour`.`weekday`, `Hour`.`start`, `Hour`.`end`, `Hour`.`closed` FROM `tbiback_tbshops`.`hours` AS `Hour` WHERE `weekday` = 1 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Store`.`id`, `Store`.`name`, `Store`.`branding`, `Store`.`defaultlocale`, `Store`.`theme_admin`, `Store`.`theme`, `Store`.`phone`, `Store`.`url`, `Store`.`email`, `Store`.`active`, `Store`.`index`, `Store`.`maintenance_mode`, `Store`.`base`, `Store`.`use_menu_builder`, `Store`.`age_confirm`, `Store`.`hours_popup`, `Store`.`is_wholesale`, `Store`.`disable_checkout`, `Store`.`enable_stores`, (`I18n__homepagetitle__nld`.`content`) AS `Store__i18n_homepagetitle_nld`, (`I18n__homepagedescription__nld`.`content`) AS `Store__i18n_homepagedescription_nld`, (`I18n__homepage_footer__nld`.`content`) AS `Store__i18n_homepage_footer_nld`, (`I18n__homepage_content__nld`.`content`) AS `Store__i18n_homepage_content_nld`, (`I18n__header_points__nld`.`content`) AS `Store__i18n_header_points_nld`, (`I18n__footer_blocks__nld`.`content`) AS `Store__i18n_footer_blocks_nld`, (`I18n__sidebar_content__nld`.`content`) AS `Store__i18n_sidebar_content_nld`, (`I18n__disable_checkout_msg__nld`.`content`) AS `Store__i18n_disable_checkout_msg_nld` FROM `tbiback_tbshops`.`stores` AS `Store` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__homepagetitle__nld` ON (`Store`.`id` = `I18n__homepagetitle__nld`.`foreign_key` AND `I18n__homepagetitle__nld`.`model` = 'Store' AND `I18n__homepagetitle__nld`.`field` = 'homepagetitle' AND `I18n__homepagetitle__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__homepagedescription__nld` ON (`Store`.`id` = `I18n__homepagedescription__nld`.`foreign_key` AND `I18n__homepagedescription__nld`.`model` = 'Store' AND `I18n__homepagedescription__nld`.`field` = 'homepagedescription' AND `I18n__homepagedescription__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__homepage_footer__nld` ON (`Store`.`id` = `I18n__homepage_footer__nld`.`foreign_key` AND `I18n__homepage_footer__nld`.`model` = 'Store' AND `I18n__homepage_footer__nld`.`field` = 'homepage_footer' AND `I18n__homepage_footer__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__homepage_content__nld` ON (`Store`.`id` = `I18n__homepage_content__nld`.`foreign_key` AND `I18n__homepage_content__nld`.`model` = 'Store' AND `I18n__homepage_content__nld`.`field` = 'homepage_content' AND `I18n__homepage_content__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__header_points__nld` ON (`Store`.`id` = `I18n__header_points__nld`.`foreign_key` AND `I18n__header_points__nld`.`model` = 'Store' AND `I18n__header_points__nld`.`field` = 'header_points' AND `I18n__header_points__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__footer_blocks__nld` ON (`Store`.`id` = `I18n__footer_blocks__nld`.`foreign_key` AND `I18n__footer_blocks__nld`.`model` = 'Store' AND `I18n__footer_blocks__nld`.`field` = 'footer_blocks' AND `I18n__footer_blocks__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__sidebar_content__nld` ON (`Store`.`id` = `I18n__sidebar_content__nld`.`foreign_key` AND `I18n__sidebar_content__nld`.`model` = 'Store' AND `I18n__sidebar_content__nld`.`field` = 'sidebar_content' AND `I18n__sidebar_content__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__disable_checkout_msg__nld` ON (`Store`.`id` = `I18n__disable_checkout_msg__nld`.`foreign_key` AND `I18n__disable_checkout_msg__nld`.`model` = 'Store' AND `I18n__disable_checkout_msg__nld`.`field` = 'disable_checkout_msg' AND `I18n__disable_checkout_msg__nld`.`locale` = 'nld') WHERE `url` = 'massagekaars.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` = (21) | 14 | 14 | 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` = 21 AND `Shippingmethod`.`code` = 'shipment' LIMIT 1 | 1 | 1 | 1 | |
| 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 | 1 | |
| SELECT `Message`.`id`, `Message`.`type`, `Message`.`start`, `Message`.`end`, `Message`.`store_id`, `Message`.`from_override`, (`I18n__message__nld`.`content`) AS `Message__i18n_message_nld` FROM `tbiback_tbshops`.`messages` AS `Message` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__message__nld` ON (`Message`.`id` = `I18n__message__nld`.`foreign_key` AND `I18n__message__nld`.`model` = 'Message' AND `I18n__message__nld`.`field` = 'message' AND `I18n__message__nld`.`locale` = 'nld') WHERE `type` = 'popover' AND `start` <= '2023-03-26' AND `end` >= '2023-03-26' AND `store_id` IN (0, 21) LIMIT 1 | 0 | 0 | 1 | maybe slow |
| SELECT `UrlRedirect`.`id`, `UrlRedirect`.`old_url`, `UrlRedirect`.`new_url`, `UrlRedirect`.`redirect_type`, `UrlRedirect`.`store_id` FROM `tbiback_tbshops`.`url_redirects` AS `UrlRedirect` WHERE `old_url` = 'http://massagekaars.be/nld/zijn-de-orli-massagekaarsen-veilig-voor-mijn-huid-en-omgeving' AND `store_id` = 21 LIMIT 1 | 0 | 0 | 1 | maybe slow |
| SELECT `Cart`.`id`, `Cart`.`display`, `Cart`.`group_id`, `Cart`.`group_model`, `Cart`.`session_id`, `Cart`.`qty`, `Cart`.`price`, `Cart`.`price_excl_vat`, `Cart`.`price_vat`, `Cart`.`price_incl_vat`, `Cart`.`vat`, `Cart`.`created`, `Cart`.`loaded`, `Cart`.`store_id`, `Cart`.`default`, `Cart`.`defaultqty`, `Cart`.`order_type`, `Productgroup`.`id`, `Productgroup`.`brand_id`, `Productgroup`.`price`, `Productgroup`.`promoprice`, `Productgroup`.`wholesaleprice`, `Productgroup`.`minimumsaleprice`, `Productgroup`.`show_retail_price`, `Productgroup`.`hidden`, `Productgroup`.`available`, `Productgroup`.`endoflife`, `Productgroup`.`exclusive`, `Productgroup`.`created`, `Productgroup`.`exportable`, `Productgroup`.`exported`, `Productgroup`.`bbat_flexible`, `Productgroup`.`bbat_fixed`, `Bundle`.`id`, `Bundle`.`SKU`, `Bundle`.`brand_id`, `Bundle`.`price`, `Bundle`.`promoprice`, `Bundle`.`purchaseprice`, `Bundle`.`wholesaleprice`, `Bundle`.`qtychange_price`, `Bundle`.`hidden`, `Bundle`.`available`, `Bundle`.`created` FROM `tbiback_tbshops`.`carts` AS `Cart` LEFT JOIN `tbiback_tbshops`.`productgroups` AS `Productgroup` ON (`Cart`.`group_id` = `Productgroup`.`id` AND `Cart`.`group_model` = 'Productgroup') LEFT JOIN `tbiback_tbshops`.`bundles` AS `Bundle` ON (`Cart`.`group_id` = `Bundle`.`id` AND `Cart`.`group_model` = 'Bundle') WHERE `session_id` = 'ocs15rt6q87a31oqb28mjsc0v6' AND `qty` > 0 | 0 | 0 | 1 | maybe slow |
| SELECT `Store`.`id`, `Store`.`name` FROM `tbiback_tbshops`.`stores` AS `Store` WHERE 1 = 1 | 23 | 23 | 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` = 'zijn-de-orli-massagekaarsen-veilig-voor-mijn-huid-en-omgeving' AND `Post`.`store_id` = 21 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` = '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` = 'zijn-de-orli-massagekaarsen-veilig-voor-mijn-huid-en-omgeving' AND `Post`.`store_id` = 21 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` = '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` = 'zijn-de-orli-massagekaarsen-veilig-voor-mijn-huid-en-omgeving' AND `Post`.`store_id` = 21 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Post`.`id`, (`I18n__title`.`content`) AS `Post__i18n_title`, (`I18n__slug`.`content`) AS `Post__i18n_slug` 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__slug` ON (`Post`.`id` = `I18n__slug`.`foreign_key` AND `I18n__slug`.`model` = 'Post' AND `I18n__slug`.`field` = 'slug' AND `I18n__slug`.`locale` = 'nld') WHERE `Post`.`id` = 39 AND `Post`.`store_id` = 21 LIMIT 1 | 1 | 1 | 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 `Post`.`id` = 39 AND `Post`.`store_id` = 21 LIMIT 1 | 1 | 1 | 3 | maybe slow |
