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` = 'pietjesbak.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` = (9) | 16 | 16 | 0 | |
SELECT `Productgroup`.`id`, (`I18n__slug`.`content`) AS `Productgroup__i18n_slug` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` INNER JOIN `tbiback_tbshops`.`i18n` AS `I18n__slug` ON (`Productgroup`.`id` = `I18n__slug`.`foreign_key` AND `I18n__slug`.`model` = 'Productgroup' AND `I18n__slug`.`field` = 'slug' AND `I18n__slug`.`locale` = 'nld') WHERE `I18n__slug`.`content` = 'pietjesbak-donker-hout' AND `Productgroup`.`id` = 123 LIMIT 1 | 1 | 1 | 1 | |
SELECT `HourException`.`id`, `HourException`.`date`, `HourException`.`start`, `HourException`.`end`, `HourException`.`closed`, `HourException`.`store_location_id` FROM `tbiback_tbshops`.`hour_exceptions` AS `HourException` WHERE `date` = '2023-11-30' 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-12-01' 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-12-01' 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-12-01' 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` = 'pietjesbak.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` = (9) | 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` = 9 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` = (4) | 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-12-01' AND `end` >= '2023-12-01' AND `store_id` IN (0, 9) 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://pietjesbak.be/nld/product/123/pietjesbak-donker-hout' AND `store_id` = 9 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` = 'jb8sscg60h1r590oav7trt6b70' 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` = 9) WHERE `I18n__slug`.`content` = 'pietjesbak-donker-hout' AND `Productgroup`.`id` = 123 AND `Category`.`store_id` = '9' LIMIT 1 | 1 | 1 | 7 | 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` = 123 AND `Description`.`group_model` = 'Productgroup' AND `Description`.`store_id` = 9 | 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` = (123) ORDER BY `sorting` asc, `created` asc | 3 | 3 | 3 | |
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` = (123) | 0 | 0 | 5 | 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` = (123) ORDER BY `sorting` ASC | 1 | 1 | 7 | maybe slow |
SELECT `Image`.`id`, `Image`.`group_id`, `Image`.`group_model`, `Image`.`filename`, `Image`.`sorting`, `Image`.`variant_id`, `Image`.`created`, `Image`.`compressed` FROM `tbiback_tbshops`.`images` AS `Image` WHERE `Image`.`variant_id` = 141 | 0 | 0 | 2 | maybe slow |
SELECT `Productattribute`.`id`, `Productattribute`.`product_id` FROM `tbiback_tbshops`.`productattributes` AS `Productattribute` WHERE `Productattribute`.`product_id` = (141) | 0 | 0 | 1 | maybe slow |
SELECT `RelatedProductgroup`.`id`, `RelatedProductgroup`.`brand_id`, `RelatedProductgroup`.`price`, `RelatedProductgroup`.`promoprice`, `RelatedProductgroup`.`wholesaleprice`, `RelatedProductgroup`.`minimumsaleprice`, `RelatedProductgroup`.`show_retail_price`, `RelatedProductgroup`.`hidden`, `RelatedProductgroup`.`available`, `RelatedProductgroup`.`endoflife`, `RelatedProductgroup`.`exclusive`, `RelatedProductgroup`.`created`, `RelatedProductgroup`.`exportable`, `RelatedProductgroup`.`exported`, `RelatedProductgroup`.`bbat_flexible`, `RelatedProductgroup`.`bbat_fixed`, `RelatedGroup`.`id`, `RelatedGroup`.`group_model`, `RelatedGroup`.`related_model`, `RelatedGroup`.`group_id`, `RelatedGroup`.`related_id` FROM `tbiback_tbshops`.`productgroups` AS `RelatedProductgroup` JOIN `tbiback_tbshops`.`related_groups` AS `RelatedGroup` ON (`RelatedGroup`.`group_id` = 123 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` = 123 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` = 123 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` = 123 AND `AddonGroup`.`addon_id` = `AddonBundle`.`id`) WHERE `AddonGroup`.`addon_model` = 'Bundle' | 0 | 0 | 0 | |
SELECT `Productattribute`.`id`, `Productattribute`.`product_id`, (`I18n__key`.`content`) AS `Productattribute__i18n_key`, (`I18n__value`.`content`) AS `Productattribute__i18n_value` FROM `tbiback_tbshops`.`productattributes` AS `Productattribute` INNER JOIN `tbiback_tbshops`.`productattribute_i18ns` AS `I18n__key` ON (`Productattribute`.`id` = `I18n__key`.`foreign_key` AND `I18n__key`.`model` = 'Productattribute' AND `I18n__key`.`field` = 'key' AND `I18n__key`.`locale` = 'nld') INNER JOIN `tbiback_tbshops`.`productattribute_i18ns` AS `I18n__value` ON (`Productattribute`.`id` = `I18n__value`.`foreign_key` AND `I18n__value`.`model` = 'Productattribute' AND `I18n__value`.`field` = 'value' AND `I18n__value`.`locale` = 'nld') WHERE `product_id` = 141 | 0 | 0 | 2 | maybe slow |
SELECT `Description`.`id`, (`I18n__description__nld`.`content`) AS `Description__i18n_description_nld`, (`I18n__description_short__nld`.`content`) AS `Description__i18n_description_short_nld` FROM `tbiback_tbshops`.`descriptions` AS `Description` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__description__nld` ON (`Description`.`id` = `I18n__description__nld`.`foreign_key` AND `I18n__description__nld`.`model` = 'Description' AND `I18n__description__nld`.`field` = 'description' AND `I18n__description__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__description_short__nld` ON (`Description`.`id` = `I18n__description_short__nld`.`foreign_key` AND `I18n__description_short__nld`.`model` = 'Description' AND `I18n__description_short__nld`.`field` = 'description_short' AND `I18n__description_short__nld`.`locale` = 'nld') WHERE `Description`.`id` = 198 LIMIT 1 | 1 | 1 | 0 | |
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` = 350 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` = 351 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` = 352 LIMIT 1 | 1 | 1 | 1 | |
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`sorting`, `Category`.`topmenu`, `Category`.`store_id`, (`I18n__name__nld`.`content`) AS `Category__i18n_name_nld`, (`I18n__slug__nld`.`content`) AS `Category__i18n_slug_nld`, (`I18n__description__nld`.`content`) AS `Category__i18n_description_nld`, (`I18n__description_short__nld`.`content`) AS `Category__i18n_description_short_nld`, (`I18n__path__nld`.`content`) AS `Category__i18n_path_nld`, (`I18n__pagetitle__nld`.`content`) AS `Category__i18n_pagetitle_nld`, `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`sorting`, `ParentCategory`.`topmenu`, `ParentCategory`.`store_id` FROM `tbiback_tbshops`.`categories` AS `Category` LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__name__nld` ON (`Category`.`id` = `I18n__name__nld`.`foreign_key` AND `I18n__name__nld`.`model` = 'Category' AND `I18n__name__nld`.`field` = 'name' AND `I18n__name__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__slug__nld` ON (`Category`.`id` = `I18n__slug__nld`.`foreign_key` AND `I18n__slug__nld`.`model` = 'Category' AND `I18n__slug__nld`.`field` = 'slug' AND `I18n__slug__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__description__nld` ON (`Category`.`id` = `I18n__description__nld`.`foreign_key` AND `I18n__description__nld`.`model` = 'Category' AND `I18n__description__nld`.`field` = 'description' AND `I18n__description__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__description_short__nld` ON (`Category`.`id` = `I18n__description_short__nld`.`foreign_key` AND `I18n__description_short__nld`.`model` = 'Category' AND `I18n__description_short__nld`.`field` = 'description_short' AND `I18n__description_short__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__path__nld` ON (`Category`.`id` = `I18n__path__nld`.`foreign_key` AND `I18n__path__nld`.`model` = 'Category' AND `I18n__path__nld`.`field` = 'path' AND `I18n__path__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`i18n` AS `I18n__pagetitle__nld` ON (`Category`.`id` = `I18n__pagetitle__nld`.`foreign_key` AND `I18n__pagetitle__nld`.`model` = 'Category' AND `I18n__pagetitle__nld`.`field` = 'pagetitle' AND `I18n__pagetitle__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`categories` AS `ParentCategory` ON (`Category`.`parent_id` = `ParentCategory`.`id`) WHERE `Category`.`id` = 37 AND `Category`.`store_id` = 9 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Category`.`parent_id` FROM `tbiback_tbshops`.`categories` AS `Category` WHERE `Category`.`id` = 37 AND `Category`.`store_id` = 9 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` = 37 AND `Category`.`store_id` = 9 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Productattribute`.`id`, `Productattribute`.`product_id`, (`I18n__key__nld`.`content`) AS `Productattribute__i18n_key_nld`, (`I18n__value__nld`.`content`) AS `Productattribute__i18n_value_nld` FROM `tbiback_tbshops`.`productattributes` AS `Productattribute` LEFT JOIN `tbiback_tbshops`.`productattribute_i18ns` AS `I18n__key__nld` ON (`Productattribute`.`id` = `I18n__key__nld`.`foreign_key` AND `I18n__key__nld`.`model` = 'Productattribute' AND `I18n__key__nld`.`field` = 'key' AND `I18n__key__nld`.`locale` = 'nld') LEFT JOIN `tbiback_tbshops`.`productattribute_i18ns` AS `I18n__value__nld` ON (`Productattribute`.`id` = `I18n__value__nld`.`foreign_key` AND `I18n__value__nld`.`model` = 'Productattribute' AND `I18n__value__nld`.`field` = 'value' AND `I18n__value__nld`.`locale` = 'nld') WHERE `product_id` = 141 | 0 | 0 | 1 | maybe slow |
SELECT `StoreSetting`.`id`, `StoreSetting`.`key`, `StoreSetting`.`value`, `StoreSetting`.`type`, `StoreSetting`.`store_id` FROM `tbiback_tbshops`.`store_settings` AS `StoreSetting` WHERE `key` = 'outofstock' AND `store_id` = 9 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` = 'pietjesbak-donker-hout' AND `Productgroup`.`id` = 123 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Productgroup`.`id`, (`I18n__slug`.`content`) AS `Productgroup__i18n_slug` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` INNER JOIN `tbiback_tbshops`.`i18n` AS `I18n__slug` ON (`Productgroup`.`id` = `I18n__slug`.`foreign_key` AND `I18n__slug`.`model` = 'Productgroup' AND `I18n__slug`.`field` = 'slug' AND `I18n__slug`.`locale` = 'fra') WHERE `Productgroup`.`id` = 123 LIMIT 1 | 1 | 1 | 1 | |
SELECT `Productgroup`.`id`, (`I18n__slug`.`content`) AS `Productgroup__i18n_slug` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` INNER JOIN `tbiback_tbshops`.`i18n` AS `I18n__slug` ON (`Productgroup`.`id` = `I18n__slug`.`foreign_key` AND `I18n__slug`.`model` = 'Productgroup' AND `I18n__slug`.`field` = 'slug' AND `I18n__slug`.`locale` = 'fra') WHERE `Productgroup`.`id` = 123 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` = 'eng') WHERE `Productgroup`.`id` = 123 LIMIT 1 | 1 | 1 | 1 | |
SELECT `Productgroup`.`id`, (`I18n__slug`.`content`) AS `Productgroup__i18n_slug` FROM `tbiback_tbshops`.`productgroups` AS `Productgroup` INNER JOIN `tbiback_tbshops`.`i18n` AS `I18n__slug` ON (`Productgroup`.`id` = `I18n__slug`.`foreign_key` AND `I18n__slug`.`model` = 'Productgroup' AND `I18n__slug`.`field` = 'slug' AND `I18n__slug`.`locale` = 'eng') WHERE `Productgroup`.`id` = 123 LIMIT 1 | 1 | 1 | 0 | |