-
- History
-
Sqllog +
Sql Logs
default
Total Time: 50 ms
Total Queries: 42 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` = '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 `Productgroup`.`id`, (`I18n__slug`.`content`) AS `Productgroup__i18n_slug` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` INNER JOIN `tbiback_tbshops`.`i18n` AS `I18n__slug` ON (`Productgroup`.`id` = `I18n__slug`.`foreign_key` AND `I18n__slug`.`model` = 'Productgroup' AND `I18n__slug`.`field` = 'slug' AND `I18n__slug`.`locale` = 'nld') WHERE `I18n__slug`.`content` = 'orli-massagekaars-frangipani' AND `Productgroup`.`id` = 831 LIMIT 1 1 1 2 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-01-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` = 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-01-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` = 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-01-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` = 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-01-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` = 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-01-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` = 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` = '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 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-01-26' AND `end` >= '2023-01-26' AND `store_id` IN (0, 21) LIMIT 1 0 0 0 SELECT `UrlRedirect`.`id`, `UrlRedirect`.`old_url`, `UrlRedirect`.`new_url`, `UrlRedirect`.`redirect_type`, `UrlRedirect`.`store_id` FROM `tbiback_tbshops`.`url_redirects` AS `UrlRedirect` WHERE `old_url` = 'http://massagekaars.be/nld/product/831/orli-massagekaars-frangipani' 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` = 't0nvjoifrdvs3u1ev9dr37r2e2' AND `qty` > 0 0 0 1 maybe slow SELECT `Productgroup`.*, `CategoryGroup`.*, `Brand`.*, `Brand`.`id`, `Productgroup`.`id`, (`I18n__name`.`content`) AS `Productgroup__i18n_name`, (`I18n__slug`.`content`) AS `Productgroup__i18n_slug`, (`I18n__pagetitle`.`content`) AS `Productgroup__i18n_pagetitle`, (`I18n__attributes`.`content`) AS `Productgroup__i18n_attributes`, (`I18n__default`.`content`) AS `Productgroup__i18n_default` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` LEFT JOIN `tbiback_tbshops`.`category_groups` AS `CategoryGroup` ON (`CategoryGroup`.`group_id` = `Productgroup`.`id` AND `CategoryGroup`.`group_model` = 'Productgroup') LEFT JOIN `tbiback_tbshops`.`categories` AS `Category` ON (`Category`.`id` = `CategoryGroup`.`category_id`) INNER JOIN `tbiback_tbshops`.`i18n` AS `I18n__name` ON (`Productgroup`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Productgroup' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'nld') INNER JOIN `tbiback_tbshops`.`i18n` AS `I18n__slug` ON (`Productgroup`.`id` = `I18n__slug`.`foreign_key` AND `I18n__slug`.`model` = 'Productgroup' AND `I18n__slug`.`field` = 'slug' AND `I18n__slug`.`locale` = 'nld') INNER JOIN `tbiback_tbshops`.`i18n` AS `I18n__pagetitle` ON (`Productgroup`.`id` = `I18n__pagetitle`.`foreign_key` AND `I18n__pagetitle`.`model` = 'Productgroup' AND `I18n__pagetitle`.`field` = 'pagetitle' AND `I18n__pagetitle`.`locale` = 'nld') INNER JOIN `tbiback_tbshops`.`i18n` AS `I18n__attributes` ON (`Productgroup`.`id` = `I18n__attributes`.`foreign_key` AND `I18n__attributes`.`model` = 'Productgroup' AND `I18n__attributes`.`field` = 'attributes' AND `I18n__attributes`.`locale` = 'nld') INNER JOIN `tbiback_tbshops`.`i18n` AS `I18n__default` ON (`Productgroup`.`id` = `I18n__default`.`foreign_key` AND `I18n__default`.`model` = 'Productgroup' AND `I18n__default`.`field` = 'default' AND `I18n__default`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`brands` AS `Brand` ON (`Productgroup`.`brand_id` = `Brand`.`id`) LEFT JOIN `tbiback_tbshops`.`descriptions` AS `Description` ON (`Description`.`group_id` = `Productgroup`.`id` AND `Description`.`group_model` = 'Productgroup' AND `Description`.`store_id` = 21) WHERE `I18n__slug`.`content` = 'orli-massagekaars-frangipani' AND `Productgroup`.`id` = 831 AND `Category`.`store_id` = '21' LIMIT 1 1 1 11 maybe slow SELECT `Description`.`id`, `Description`.`group_id`, `Description`.`group_model`, `Description`.`store_id`, `Description`.`featured` FROM `tbiback_tbshops`.`descriptions` AS `Description` WHERE `Description`.`group_id` = 831 AND `Description`.`group_model` = 'Productgroup' AND `Description`.`store_id` = 21 1 1 2 maybe slow SELECT `Image`.`id`, `Image`.`group_id`, `Image`.`group_model`, `Image`.`filename`, `Image`.`sorting`, `Image`.`variant_id`, `Image`.`created`, `Image`.`compressed` FROM `tbiback_tbshops`.`images` AS `Image` WHERE `Image`.`group_model` = 'Productgroup' AND `Image`.`group_id` = (831) ORDER BY `sorting` asc, `created` asc 1 1 2 maybe slow SELECT `Review`.`id`, `Review`.`group_id`, `Review`.`group_model`, `Review`.`title`, `Review`.`content`, `Review`.`rating`, `Review`.`moderated`, `Review`.`reviewer_name`, `Review`.`reviewer_email`, `Review`.`customer_id`, `Review`.`lang`, `Review`.`store_id`, `Review`.`created` FROM `tbiback_tbshops`.`reviews` AS `Review` WHERE `lang` = 'nld' AND `moderated` = '1' AND `Review`.`group_id` = (831) 0 0 3 maybe slow SELECT `Product`.`id`, `Product`.`SKU`, `Product`.`ehale`, `Product`.`price`, `Product`.`promoprice`, `Product`.`purchaseprice`, `Product`.`wholesaleprice`, `Product`.`stock`, `Product`.`criticalstock`, `Product`.`dropship`, `Product`.`outofstock`, `Product`.`green`, `Product`.`weight`, `Product`.`width`, `Product`.`height`, `Product`.`depth`, `Product`.`productgroup_id`, `Product`.`created`, `Product`.`modified`, `Product`.`sorting`, `Product`.`available`, `Product`.`endoflife`, `Product`.`warehouse_location`, `Product`.`sellable`, `Product`.`exported`, `Product`.`expires`, `Product`.`status`, `Product`.`barcode`, `Product`.`contains_nicotine` FROM `tbiback_tbshops`.`products` AS `Product` WHERE `Product`.`productgroup_id` = (831) ORDER BY `sorting` ASC 2 2 8 maybe slow SELECT `Image`.`id`, `Image`.`group_id`, `Image`.`group_model`, `Image`.`filename`, `Image`.`sorting`, `Image`.`variant_id`, `Image`.`created`, `Image`.`compressed` FROM `tbiback_tbshops`.`images` AS `Image` WHERE `Image`.`variant_id` = 1402 0 0 2 maybe slow SELECT `Image`.`id`, `Image`.`group_id`, `Image`.`group_model`, `Image`.`filename`, `Image`.`sorting`, `Image`.`variant_id`, `Image`.`created`, `Image`.`compressed` FROM `tbiback_tbshops`.`images` AS `Image` WHERE `Image`.`variant_id` = 1403 0 0 2 maybe slow SELECT `Productattribute`.`id`, `Productattribute`.`product_id` FROM `tbiback_tbshops`.`productattributes` AS `Productattribute` WHERE `Productattribute`.`product_id` IN (1402, 1403) 2 2 1 maybe slow SELECT `RelatedProductgroup`.`id`, `RelatedProductgroup`.`brand_id`, `RelatedProductgroup`.`price`, `RelatedProductgroup`.`promoprice`, `RelatedProductgroup`.`wholesaleprice`, `RelatedProductgroup`.`minimumsaleprice`, `RelatedProductgroup`.`show_retail_price`, `RelatedProductgroup`.`hidden`, `RelatedProductgroup`.`available`, `RelatedProductgroup`.`endoflife`, `RelatedProductgroup`.`exclusive`, `RelatedProductgroup`.`created`, `RelatedProductgroup`.`exportable`, `RelatedProductgroup`.`exported`, `RelatedProductgroup`.`bbat_flexible`, `RelatedProductgroup`.`bbat_fixed`, `RelatedGroup`.`id`, `RelatedGroup`.`group_model`, `RelatedGroup`.`related_model`, `RelatedGroup`.`group_id`, `RelatedGroup`.`related_id` FROM `tbiback_tbshops`.`productgroups` AS `RelatedProductgroup` JOIN `tbiback_tbshops`.`related_groups` AS `RelatedGroup` ON (`RelatedGroup`.`group_id` = 831 AND `RelatedGroup`.`related_id` = `RelatedProductgroup`.`id`) WHERE `RelatedGroup`.`related_model` = 'Productgroup' 0 0 1 maybe slow SELECT `RelatedBundle`.`id`, `RelatedBundle`.`SKU`, `RelatedBundle`.`brand_id`, `RelatedBundle`.`price`, `RelatedBundle`.`promoprice`, `RelatedBundle`.`purchaseprice`, `RelatedBundle`.`wholesaleprice`, `RelatedBundle`.`qtychange_price`, `RelatedBundle`.`hidden`, `RelatedBundle`.`available`, `RelatedBundle`.`created`, `RelatedGroup`.`id`, `RelatedGroup`.`group_model`, `RelatedGroup`.`related_model`, `RelatedGroup`.`group_id`, `RelatedGroup`.`related_id` FROM `tbiback_tbshops`.`bundles` AS `RelatedBundle` JOIN `tbiback_tbshops`.`related_groups` AS `RelatedGroup` ON (`RelatedGroup`.`group_id` = 831 AND `RelatedGroup`.`related_id` = `RelatedBundle`.`id`) WHERE `RelatedGroup`.`related_model` = 'Bundle' 0 0 1 maybe slow SELECT `AddonProductgroup`.`id`, `AddonProductgroup`.`brand_id`, `AddonProductgroup`.`price`, `AddonProductgroup`.`promoprice`, `AddonProductgroup`.`wholesaleprice`, `AddonProductgroup`.`minimumsaleprice`, `AddonProductgroup`.`show_retail_price`, `AddonProductgroup`.`hidden`, `AddonProductgroup`.`available`, `AddonProductgroup`.`endoflife`, `AddonProductgroup`.`exclusive`, `AddonProductgroup`.`created`, `AddonProductgroup`.`exportable`, `AddonProductgroup`.`exported`, `AddonProductgroup`.`bbat_flexible`, `AddonProductgroup`.`bbat_fixed`, `AddonGroup`.`id`, `AddonGroup`.`group_model`, `AddonGroup`.`group_id`, `AddonGroup`.`addon_model`, `AddonGroup`.`addon_id`, `AddonGroup`.`addon_qty`, `AddonGroup`.`addon_variant_id` FROM `tbiback_tbshops`.`productgroups` AS `AddonProductgroup` JOIN `tbiback_tbshops`.`addon_groups` AS `AddonGroup` ON (`AddonGroup`.`group_id` = 831 AND `AddonGroup`.`addon_id` = `AddonProductgroup`.`id`) WHERE `AddonGroup`.`addon_model` = 'Productgroup' 0 0 1 maybe slow SELECT `AddonBundle`.`id`, `AddonBundle`.`SKU`, `AddonBundle`.`brand_id`, `AddonBundle`.`price`, `AddonBundle`.`promoprice`, `AddonBundle`.`purchaseprice`, `AddonBundle`.`wholesaleprice`, `AddonBundle`.`qtychange_price`, `AddonBundle`.`hidden`, `AddonBundle`.`available`, `AddonBundle`.`created`, `AddonGroup`.`id`, `AddonGroup`.`group_model`, `AddonGroup`.`group_id`, `AddonGroup`.`addon_model`, `AddonGroup`.`addon_id`, `AddonGroup`.`addon_qty`, `AddonGroup`.`addon_variant_id` FROM `tbiback_tbshops`.`bundles` AS `AddonBundle` JOIN `tbiback_tbshops`.`addon_groups` AS `AddonGroup` ON (`AddonGroup`.`group_id` = 831 AND `AddonGroup`.`addon_id` = `AddonBundle`.`id`) WHERE `AddonGroup`.`addon_model` = 'Bundle' 0 0 1 maybe slow SELECT `Productattribute`.`id`, `Productattribute`.`product_id`, (`I18n__key`.`content`) AS `Productattribute__i18n_key`, (`I18n__value`.`content`) AS `Productattribute__i18n_value` FROM `tbiback_tbshops`.`productattributes` AS `Productattribute` INNER JOIN `tbiback_tbshops`.`productattribute_i18ns` AS `I18n__key` ON (`Productattribute`.`id` = `I18n__key`.`foreign_key` AND `I18n__key`.`model` = 'Productattribute' AND `I18n__key`.`field` = 'key' AND `I18n__key`.`locale` = 'nld') INNER JOIN `tbiback_tbshops`.`productattribute_i18ns` AS `I18n__value` ON (`Productattribute`.`id` = `I18n__value`.`foreign_key` AND `I18n__value`.`model` = 'Productattribute' AND `I18n__value`.`field` = 'value' AND `I18n__value`.`locale` = 'nld') WHERE `product_id` = 1402 1 1 2 maybe slow SELECT `Productattribute`.`id`, `Productattribute`.`product_id`, (`I18n__key`.`content`) AS `Productattribute__i18n_key`, (`I18n__value`.`content`) AS `Productattribute__i18n_value` FROM `tbiback_tbshops`.`productattributes` AS `Productattribute` INNER JOIN `tbiback_tbshops`.`productattribute_i18ns` AS `I18n__key` ON (`Productattribute`.`id` = `I18n__key`.`foreign_key` AND `I18n__key`.`model` = 'Productattribute' AND `I18n__key`.`field` = 'key' AND `I18n__key`.`locale` = 'nld') INNER JOIN `tbiback_tbshops`.`productattribute_i18ns` AS `I18n__value` ON (`Productattribute`.`id` = `I18n__value`.`foreign_key` AND `I18n__value`.`model` = 'Productattribute' AND `I18n__value`.`field` = 'value' AND `I18n__value`.`locale` = 'nld') WHERE `product_id` = 1403 1 1 2 maybe slow SELECT `Description`.`id`, (`I18n__description__nld`.`content`) AS `Description__i18n_description_nld`, (`I18n__description_short__nld`.`content`) AS `Description__i18n_description_short_nld` FROM `tbiback_tbshops`.`descriptions` AS `Description` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__description__nld` ON (`Description`.`id` = `I18n__description__nld`.`foreign_key` AND `I18n__description__nld`.`model` = 'Description' AND `I18n__description__nld`.`field` = 'description' AND `I18n__description__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__description_short__nld` ON (`Description`.`id` = `I18n__description_short__nld`.`foreign_key` AND `I18n__description_short__nld`.`model` = 'Description' AND `I18n__description_short__nld`.`field` = 'description_short' AND `I18n__description_short__nld`.`locale` = 'nld') WHERE `Description`.`id` = 1071 LIMIT 1 1 1 1 SELECT `Image`.`id`, (`I18n__title__nld`.`content`) AS `Image__i18n_title_nld` FROM `tbiback_tbshops`.`images` AS `Image` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__title__nld` ON (`Image`.`id` = `I18n__title__nld`.`foreign_key` AND `I18n__title__nld`.`model` = 'Image' AND `I18n__title__nld`.`field` = 'title' AND `I18n__title__nld`.`locale` = 'nld') WHERE `Image`.`id` = 1629 LIMIT 1 1 1 1 SELECT `Brand`.`id`, (`I18n__pagetitle__nld`.`content`) AS `Brand__i18n_pagetitle_nld`, (`I18n__description__nld`.`content`) AS `Brand__i18n_description_nld` FROM `tbiback_tbshops`.`brands` AS `Brand` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__pagetitle__nld` ON (`Brand`.`id` = `I18n__pagetitle__nld`.`foreign_key` AND `I18n__pagetitle__nld`.`model` = 'Brand' AND `I18n__pagetitle__nld`.`field` = 'pagetitle' AND `I18n__pagetitle__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__description__nld` ON (`Brand`.`id` = `I18n__description__nld`.`foreign_key` AND `I18n__description__nld`.`model` = 'Brand' AND `I18n__description__nld`.`field` = 'description' AND `I18n__description__nld`.`locale` = 'nld') WHERE `Brand`.`id` = 117 LIMIT 1 1 1 0 SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`sorting`, `Category`.`topmenu`, `Category`.`store_id`, (`I18n__name__nld`.`content`) AS `Category__i18n_name_nld`, (`I18n__slug__nld`.`content`) AS `Category__i18n_slug_nld`, (`I18n__description__nld`.`content`) AS `Category__i18n_description_nld`, (`I18n__description_short__nld`.`content`) AS `Category__i18n_description_short_nld`, (`I18n__path__nld`.`content`) AS `Category__i18n_path_nld`, (`I18n__pagetitle__nld`.`content`) AS `Category__i18n_pagetitle_nld`, `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`sorting`, `ParentCategory`.`topmenu`, `ParentCategory`.`store_id` FROM `tbiback_tbshops`.`categories` AS `Category` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__nld` ON (`Category`.`id` = `I18n__name__nld`.`foreign_key` AND `I18n__name__nld`.`model` = 'Category' AND `I18n__name__nld`.`field` = 'name' AND `I18n__name__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__slug__nld` ON (`Category`.`id` = `I18n__slug__nld`.`foreign_key` AND `I18n__slug__nld`.`model` = 'Category' AND `I18n__slug__nld`.`field` = 'slug' AND `I18n__slug__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__description__nld` ON (`Category`.`id` = `I18n__description__nld`.`foreign_key` AND `I18n__description__nld`.`model` = 'Category' AND `I18n__description__nld`.`field` = 'description' AND `I18n__description__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__description_short__nld` ON (`Category`.`id` = `I18n__description_short__nld`.`foreign_key` AND `I18n__description_short__nld`.`model` = 'Category' AND `I18n__description_short__nld`.`field` = 'description_short' AND `I18n__description_short__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__path__nld` ON (`Category`.`id` = `I18n__path__nld`.`foreign_key` AND `I18n__path__nld`.`model` = 'Category' AND `I18n__path__nld`.`field` = 'path' AND `I18n__path__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__pagetitle__nld` ON (`Category`.`id` = `I18n__pagetitle__nld`.`foreign_key` AND `I18n__pagetitle__nld`.`model` = 'Category' AND `I18n__pagetitle__nld`.`field` = 'pagetitle' AND `I18n__pagetitle__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`categories` AS `ParentCategory` ON (`Category`.`parent_id` = `ParentCategory`.`id`) WHERE `Category`.`id` = 188 AND `Category`.`store_id` = 21 LIMIT 1 1 1 4 maybe slow SELECT `Category`.`parent_id` FROM `tbiback_tbshops`.`categories` AS `Category` WHERE `Category`.`id` = 188 AND `Category`.`store_id` = 21 LIMIT 1 1 1 0 SELECT `Category`.`id`, (`I18n__slug__nld`.`content`) AS `Category__i18n_slug_nld` FROM `tbiback_tbshops`.`categories` AS `Category` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__slug__nld` ON (`Category`.`id` = `I18n__slug__nld`.`foreign_key` AND `I18n__slug__nld`.`model` = 'Category' AND `I18n__slug__nld`.`field` = 'slug' AND `I18n__slug__nld`.`locale` = 'nld') WHERE `Category`.`id` = 188 AND `Category`.`store_id` = 21 LIMIT 1 1 1 1 SELECT `StoreSetting`.`id`, `StoreSetting`.`key`, `StoreSetting`.`value`, `StoreSetting`.`type`, `StoreSetting`.`store_id` FROM `tbiback_tbshops`.`store_settings` AS `StoreSetting` WHERE `key` = 'outofstock' AND `store_id` = 21 LIMIT 1 1 1 0 SELECT `Productgroup`.`id`, (`I18n__slug`.`content`) AS `Productgroup__i18n_slug` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` INNER JOIN `tbiback_tbshops`.`i18n` AS `I18n__slug` ON (`Productgroup`.`id` = `I18n__slug`.`foreign_key` AND `I18n__slug`.`model` = 'Productgroup' AND `I18n__slug`.`field` = 'slug' AND `I18n__slug`.`locale` = 'nld') WHERE `I18n__slug`.`content` = 'orli-massagekaars-frangipani' AND `Productgroup`.`id` = 831 LIMIT 1 1 1 0 Query Explain:
==== -
Timer +
Memory
Peak Memory Use 18.44 MB
Message Memory use Component initialization 8.53 MB Controller action start 11.41 MB Controller render start 13.11 MB View render complete 15.54 MB Timers
Total Request Time: 379 (ms)
Message Time in ms Graph Core Processing (Derived from $_SERVER["REQUEST_TIME"]) 110.68 Event: Controller.initialize 53.63 Event: Controller.startup 1.60 Controller action 101.41 Event: Controller.beforeRender 9.48 » Processing toolbar data 8.90 Rendering View 49.43 » Event: View.beforeRender 0.05 » Rendering APP/View/Productgroups/view.ctp 10.17 » » Rendering APP/View/Themed/Massagekaars/Elements/product/detail.ctp 6.62 » Event: View.afterRender 0.07 » Event: View.beforeLayout 0.05 » Rendering APP/View/Layouts/default.ctp 14.20 » » Rendering APP/View/Elements/layout/facebook-jssdk.ctp 0.18 » » Rendering APP/View/Themed/Massagekaars/Elements/layout/top-section.ctp 1.80 » » Rendering APP/View/Themed/Massagekaars/Elements/layout/branding.ctp 0.69 » » Rendering APP/View/Themed/Massagekaars/Elements/layout/main-nav.ctp 0.98 » » Rendering APP/View/Elements/layout/top-notice.ctp 0.20 » » Rendering APP/View/Elements/layout/content.ctp 1.81 » » » Rendering APP/View/Themed/Massagekaars/Elements/layout/breadcrumbs.ctp 1.42 » » Rendering APP/View/Themed/Massagekaars/Elements/layout/footer.ctp 0.54 » » Rendering APP/View/Elements/banners/footer.ctp #2 1.82 » » » Rendering APP/View/Elements/layout/footer-hours.ctp 0.51 » » » Rendering APP/View/Elements/layout/footer-contact.ctp 0.16 Event: View.afterLayout 0.00 ====