-
- History
-
Sqllog +
Sql Logs
default
Total Time: 12 ms
Total Queries: 26 queriesQuery 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` = 'pastawereld.be' LIMIT 1 1 1 4 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` = (20) 17 17 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` = 'levering-en-betaling' AND `Post`.`store_id` = 20 LIMIT 1 1 1 3 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-09-21' LIMIT 1 0 0 0 SELECT `Hour`.`id`, `Hour`.`weekday`, `Hour`.`start`, `Hour`.`end`, `Hour`.`closed` FROM `tbiback_tbshops`.`hours` AS `Hour` WHERE `weekday` = 4 LIMIT 1 1 1 0 SELECT `HourException`.`id`, `HourException`.`date`, `HourException`.`start`, `HourException`.`end`, `HourException`.`closed`, `HourException`.`store_location_id` FROM `tbiback_tbshops`.`hour_exceptions` AS `HourException` WHERE `date` = '2023-09-21' LIMIT 1 0 0 0 SELECT `Hour`.`id`, `Hour`.`weekday`, `Hour`.`start`, `Hour`.`end`, `Hour`.`closed` FROM `tbiback_tbshops`.`hours` AS `Hour` WHERE `weekday` = 4 LIMIT 1 1 1 0 SELECT `HourException`.`id`, `HourException`.`date`, `HourException`.`start`, `HourException`.`end`, `HourException`.`closed`, `HourException`.`store_location_id` FROM `tbiback_tbshops`.`hour_exceptions` AS `HourException` WHERE `date` = '2023-09-21' LIMIT 1 0 0 0 SELECT `Hour`.`id`, `Hour`.`weekday`, `Hour`.`start`, `Hour`.`end`, `Hour`.`closed` FROM `tbiback_tbshops`.`hours` AS `Hour` WHERE `weekday` = 4 LIMIT 1 1 1 0 SELECT `HourException`.`id`, `HourException`.`date`, `HourException`.`start`, `HourException`.`end`, `HourException`.`closed`, `HourException`.`store_location_id` FROM `tbiback_tbshops`.`hour_exceptions` AS `HourException` WHERE `date` = '2023-09-22' LIMIT 1 0 0 0 SELECT `Hour`.`id`, `Hour`.`weekday`, `Hour`.`start`, `Hour`.`end`, `Hour`.`closed` FROM `tbiback_tbshops`.`hours` AS `Hour` WHERE `weekday` = 5 LIMIT 1 1 1 0 SELECT `HourException`.`id`, `HourException`.`date`, `HourException`.`start`, `HourException`.`end`, `HourException`.`closed`, `HourException`.`store_location_id` FROM `tbiback_tbshops`.`hour_exceptions` AS `HourException` WHERE `date` = '2023-09-22' 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__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` = 'pastawereld.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` = (20) 17 17 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` = 20 AND `Shippingmethod`.`code` = 'shipment' LIMIT 1 1 1 0 SELECT `ShippingRate`.`id`, `ShippingRate`.`shippingmethod_id`, `ShippingRate`.`country`, `ShippingRate`.`floor`, `ShippingRate`.`ceiling`, `ShippingRate`.`criteria`, `ShippingRate`.`price` FROM `tbiback_tbshops`.`shipping_rates` AS `ShippingRate` WHERE `ShippingRate`.`shippingmethod_id` = (8) 41 41 0 SELECT `Message`.`id`, `Message`.`type`, `Message`.`start`, `Message`.`end`, `Message`.`store_id`, `Message`.`from_override`, (`I18n__message__nld`.`content`) AS `Message__i18n_message_nld` FROM `tbiback_tbshops`.`messages` AS `Message` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__message__nld` ON (`Message`.`id` = `I18n__message__nld`.`foreign_key` AND `I18n__message__nld`.`model` = 'Message' AND `I18n__message__nld`.`field` = 'message' AND `I18n__message__nld`.`locale` = 'nld') WHERE `type` = 'popover' AND `start` <= '2023-09-21' AND `end` >= '2023-09-21' AND `store_id` IN (0, 20) 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://pastawereld.be/nld/levering-en-betaling' AND `store_id` = 20 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` = 'og52ojkaod14mbsr9lrej7l946' 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` = 'levering-en-betaling' AND `Post`.`store_id` = 20 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` = 'levering-en-betaling' AND `Post`.`store_id` = 20 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` = 'levering-en-betaling' AND `Post`.`store_id` = 20 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` = 60 AND `Post`.`store_id` = 20 LIMIT 1 1 1 1 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` = 60 AND `Post`.`store_id` = 20 LIMIT 1 1 1 1 Query Explain:
==== -
Timer +
Memory
Peak Memory Use 8.12 MB
Message Memory use Component initialization 3.26 MB Controller action start 4.81 MB Controller render start 4.87 MB View render complete 5.73 MB Timers
Total Request Time: 221 (ms)
Message Time in ms Graph Core Processing (Derived from $_SERVER["REQUEST_TIME"]) 68.44 Event: Controller.initialize 62.35 Event: Controller.startup 2.40 Controller action 3.21 Event: Controller.beforeRender 10.90 » Processing toolbar data 10.22 Rendering View 39.09 » Event: View.beforeRender 0.06 » Rendering APP/View/Posts/view.ctp 0.85 » » Rendering APP/View/Elements/layout/sidebar.ctp 0.26 » Event: View.afterRender 0.04 » Event: View.beforeLayout 0.04 » Rendering APP/View/Layouts/default.ctp 21.15 » » Rendering APP/View/Elements/layout/facebook-jssdk.ctp 0.19 » » Rendering APP/View/Elements/layout/top-section.ctp 1.33 » » Rendering APP/View/Elements/layout/branding.ctp 1.34 » » Rendering APP/View/Elements/layout/main-nav.ctp 0.71 » » Rendering APP/View/Elements/layout/top-notice.ctp 0.24 » » Rendering APP/View/Elements/layout/content.ctp 7.74 » » » Rendering APP/View/Elements/layout/breadcrumbs.ctp 7.33 » » Rendering APP/View/Elements/layout/footer.ctp 0.43 » » Rendering APP/View/Elements/banners/footer.ctp #2 1.81 » » » Rendering APP/View/Elements/layout/footer-hours.ctp 0.37 » » » Rendering APP/View/Elements/layout/footer-contact.ctp 0.18 Event: View.afterLayout 0.00 ====