Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Image`.`id`, `Image`.`model`, `Image`.`model_id`, `Image`.`filename`, `Image`.`attachment_type`, `Image`.`alt`, `Image`.`title`, `Image`.`caption`, `Image`.`link_text`, `Image`.`link_url`, `Image`.`products`, `Image`.`body`, `Image`.`type`, `Image`.`size`, `Image`.`dir`, `Image`.`sequence`, `Image`.`is_active`, `Image`.`created`, `Image`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `Image__filepath` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`images` AS `Image` WHERE `model` = 'Product' AND `attachment_type` = 'Image' AND `Image`.`model_id` = (128) ORDER BY `sequence` ASC | 4 | 4 | 0 | |
SELECT `ProductAttributeOption`.`id`, `ProductAttributeOption`.`product_attribute_id`, `ProductAttributeOption`.`name`, `ProductAttributeOption`.`description`, `ProductAttributeOption`.`sequence`, `ProductAttributeOption`.`created`, `ProductAttributeOption`.`modified`, `EvShopProductAttributeOptionsProduct`.`id`, `EvShopProductAttributeOptionsProduct`.`product_attribute_option_id`, `EvShopProductAttributeOptionsProduct`.`product_id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOption` JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options_products` AS `EvShopProductAttributeOptionsProduct` ON (`EvShopProductAttributeOptionsProduct`.`product_id` = 128 AND `EvShopProductAttributeOptionsProduct`.`product_attribute_option_id` = `ProductAttributeOption`.`id`) | 1 | 1 | 0 | |
SELECT `SecondaryPlant`.`id`, `SecondaryPlant`.`name`, `SecondaryPlant`.`front_facing_name`, `SecondaryPlant`.`order_recipient`, `SecondaryPlant`.`email`, `SecondaryPlant`.`phone`, `SecondaryPlant`.`printer_name`, `SecondaryPlant`.`use_email`, `SecondaryPlant`.`use_printer`, `SecondaryPlant`.`allow_customer_collection`, `SecondaryPlant`.`no_queue_emails`, `SecondaryPlant`.`has_earlier_next_day_queue`, `SecondaryPlant`.`is_direct`, `SecondaryPlant`.`sequence`, `SecondaryPlant`.`address_name`, `SecondaryPlant`.`address_line_1`, `SecondaryPlant`.`address_line_2`, `SecondaryPlant`.`address_line_3`, `SecondaryPlant`.`address_town`, `SecondaryPlant`.`address_county`, `SecondaryPlant`.`address_postcode`, `SecondaryPlant`.`pricing_postcode`, `SecondaryPlant`.`pallex_username`, `SecondaryPlant`.`pallex_password`, `SecondaryPlant`.`created`, `SecondaryPlant`.`modified`, `SecondaryPlant`.`is_active`, `EvShopProductsPlant`.`id`, `EvShopProductsPlant`.`ev_shop_product_id`, `EvShopProductsPlant`.`plant_id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`plants` AS `SecondaryPlant` JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_products_plants` AS `EvShopProductsPlant` ON (`EvShopProductsPlant`.`ev_shop_product_id` = 128 AND `EvShopProductsPlant`.`plant_id` = `SecondaryPlant`.`id`) | 1 | 1 | 0 | |
SELECT `ProductFaq`.`id`, `ProductFaq`.`question`, `ProductFaq`.`answer`, `ProductFaq`.`is_active`, `ProductFaq`.`sequence`, `ProductFaq`.`created`, `ProductFaq`.`modified`, `ProductFaqsEvShopProduct`.`id`, `ProductFaqsEvShopProduct`.`faq_id`, `ProductFaqsEvShopProduct`.`ev_shop_product_id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`product_faqs` AS `ProductFaq` JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`product_faqs_ev_shop_products` AS `ProductFaqsEvShopProduct` ON (`ProductFaqsEvShopProduct`.`ev_shop_product_id` = 128 AND `ProductFaqsEvShopProduct`.`faq_id` = `ProductFaq`.`id`) ORDER BY `ProductFaq`.`sequence` ASC | 0 | 0 | 0 | |
SELECT `RelatedCategory`.`id`, `RelatedCategory`.`accent_colour_id`, `RelatedCategory`.`category_type`, `RelatedCategory`.`name`, `RelatedCategory`.`internal_title`, `RelatedCategory`.`parent_id`, `RelatedCategory`.`from_price`, `RelatedCategory`.`delivery_delay`, `RelatedCategory`.`homepage_title`, `RelatedCategory`.`homepage_text`, `RelatedCategory`.`description`, `RelatedCategory`.`secondary_description`, `RelatedCategory`.`products_anchor_text`, `RelatedCategory`.`banner_button_text`, `RelatedCategory`.`banner_button_link`, `RelatedCategory`.`why_use_us_heading`, `RelatedCategory`.`why_use_us_left_heading`, `RelatedCategory`.`why_use_us_left`, `RelatedCategory`.`why_use_us_left_button_text`, `RelatedCategory`.`why_use_us_left_button_link`, `RelatedCategory`.`why_use_us_right_heading`, `RelatedCategory`.`why_use_us_right`, `RelatedCategory`.`why_use_us_right_button_text`, `RelatedCategory`.`why_use_us_right_button_link`, `RelatedCategory`.`expanded_text`, `RelatedCategory`.`uses_gravel_calculator`, `RelatedCategory`.`external_site_link`, `RelatedCategory`.`external_site_url`, `RelatedCategory`.`featured_on_homepage`, `RelatedCategory`.`display_in_menu`, `RelatedCategory`.`hidden_category`, `RelatedCategory`.`product_attribute_id`, `RelatedCategory`.`lft`, `RelatedCategory`.`rght`, `RelatedCategory`.`created`, `RelatedCategory`.`modified`, `RelatedItem`.`id`, `RelatedItem`.`model`, `RelatedItem`.`model_id`, `RelatedItem`.`related_model`, `RelatedItem`.`related_model_id`, `RelatedItem`.`sequence`, `RelatedItem`.`created`, `RelatedItem`.`modified` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_category_categories` AS `RelatedCategory` JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_related_items_related_items` AS `RelatedItem` ON (`RelatedItem`.`model_id` = 128 AND `RelatedItem`.`related_model_id` = `RelatedCategory`.`id`) WHERE `model` = 'Product' AND `related_model` = 'Category' | 4 | 4 | 2 | maybe slow |
SELECT `RelatedBrand`.`id`, `RelatedBrand`.`name`, `RelatedBrand`.`description`, `RelatedBrand`.`created`, `RelatedBrand`.`modified`, `RelatedItem`.`id`, `RelatedItem`.`model`, `RelatedItem`.`model_id`, `RelatedItem`.`related_model`, `RelatedItem`.`related_model_id`, `RelatedItem`.`sequence`, `RelatedItem`.`created`, `RelatedItem`.`modified` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_brands` AS `RelatedBrand` JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_related_items_related_items` AS `RelatedItem` ON (`RelatedItem`.`model_id` = 128 AND `RelatedItem`.`related_model_id` = `RelatedBrand`.`id`) WHERE `model` = 'Product' AND `related_model` = 'Brand' | 0 | 0 | 1 | maybe slow |
SELECT `RelatedProduct`.`id`, `RelatedProduct`.`plant_id`, `RelatedProduct`.`force_shipping_company_id`, `RelatedProduct`.`name`, `RelatedProduct`.`internal_title`, `RelatedProduct`.`subtitle`, `RelatedProduct`.`SKU`, `RelatedProduct`.`lead_time`, `RelatedProduct`.`excludes_vat`, `RelatedProduct`.`vat_rate_id`, `RelatedProduct`.`use_size_price`, `RelatedProduct`.`calculator_size`, `RelatedProduct`.`aggregate_size_id`, `RelatedProduct`.`homepage_text`, `RelatedProduct`.`description`, `RelatedProduct`.`expanded_text`, `RelatedProduct`.`additional_title`, `RelatedProduct`.`additional_text`, `RelatedProduct`.`additional_button_title`, `RelatedProduct`.`additional_button_url`, `RelatedProduct`.`aside_title`, `RelatedProduct`.`aside_text`, `RelatedProduct`.`mix_design`, `RelatedProduct`.`technical_spec`, `RelatedProduct`.`addon_products_text`, `RelatedProduct`.`suitable_for`, `RelatedProduct`.`not_suitable_for`, `RelatedProduct`.`sash_colour_id`, `RelatedProduct`.`sash_message_id`, `RelatedProduct`.`no_gravel_calculator`, `RelatedProduct`.`display_only`, `RelatedProduct`.`admin_only`, `RelatedProduct`.`flag_order`, `RelatedProduct`.`nofollow`, `RelatedProduct`.`is_grouped_product`, `RelatedProduct`.`no_loose_load_message`, `RelatedProduct`.`google_feed_title`, `RelatedProduct`.`google_feed_description`, `RelatedProduct`.`exclude_from_feed`, `RelatedProduct`.`is_featured`, `RelatedProduct`.`on_homepage`, `RelatedProduct`.`hide_background_image`, `RelatedProduct`.`hide_background_image_on_mobile`, `RelatedProduct`.`show_options_as_dropdown`, `RelatedProduct`.`qualifies_for_gravelx_upsell`, `RelatedProduct`.`show_gravelx_aside`, `RelatedProduct`.`upsell_specific_sizes`, `RelatedProduct`.`is_active`, `RelatedProduct`.`is_removed`, `RelatedProduct`.`created`, `RelatedProduct`.`modified`, `RelatedItem`.`id`, `RelatedItem`.`model`, `RelatedItem`.`model_id`, `RelatedItem`.`related_model`, `RelatedItem`.`related_model_id`, `RelatedItem`.`sequence`, `RelatedItem`.`created`, `RelatedItem`.`modified` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_products` AS `RelatedProduct` JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_related_items_related_items` AS `RelatedItem` ON (`RelatedItem`.`model_id` = 128 AND `RelatedItem`.`related_model_id` = `RelatedProduct`.`id`) WHERE `RelatedProduct`.`is_active` = '1' AND `model` = 'Product' AND `related_model` = 'Product' AND `is_active` = '1' ORDER BY `sequence` ASC | 0 | 0 | 1 | maybe slow |
SELECT `MetaData`.`id`, `MetaData`.`model`, `MetaData`.`model_id`, `MetaData`.`title`, `MetaData`.`description`, `MetaData`.`keywords`, `MetaData`.`created`, `MetaData`.`modified` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`meta_data` AS `MetaData` WHERE ((`model` = 'Product') AND (`model_id` = 128)) | 1 | 1 | 0 | |
SELECT `Route`.`id`, `Route`.`alias`, `Route`.`actual` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`routes` AS `Route` WHERE `Route`.`actual` = 'app_products/view/128' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Postcode`.`id`, `Postcode`.`outcode` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`postcodes` AS `Postcode` WHERE `outcode` LIKE 'DE4' LIMIT 1 | 1 | 1 | 0 | |
SELECT `ShippingCompany`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_companies` AS `ShippingCompany` WHERE `is_active` = '1' AND `pricing_only` = '1' | 0 | 0 | 0 | |
SELECT `ShippingCost`.*, `ShippingCompany`.*, IF(cost IS NULL AND shipping_company_id <> 7, -1, 0) AS nullswitch, `ShippingCompany`.`id`, `Plant`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_costs` AS `ShippingCost` LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_companies` AS `ShippingCompany` ON (`ShippingCost`.`shipping_company_id` = `ShippingCompany`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`plants` AS `Plant` ON (`ShippingCost`.`plant_id` = `Plant`.`id`) WHERE `Plant`.`is_active` = '1' AND `ShippingCompany`.`is_active` = '1' AND `postcode_id` = 663 AND `plant_id` = 1 AND ((`cost` >= 0) OR (`cost` IS NULL)) AND NOT (`shipping_company_id` IS NULL) AND `shipping_company_id` != 6 ORDER BY `nullswitch` DESC, `cost` ASC LIMIT 1 | 1 | 1 | 6 | maybe slow |
SELECT `Postcode`.`id`, `Postcode`.`outcode` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`postcodes` AS `Postcode` WHERE `outcode` LIKE 'DE4' LIMIT 1 | 1 | 1 | 0 | |
SELECT `ShippingCompany`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_companies` AS `ShippingCompany` WHERE `is_active` = '1' AND `pricing_only` = '1' | 0 | 0 | 0 | |
SELECT `ShippingCost`.*, `ShippingCompany`.*, IF(cost IS NULL AND shipping_company_id <> 7, -1, 0) AS nullswitch, `ShippingCompany`.`id`, `Plant`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_costs` AS `ShippingCost` LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_companies` AS `ShippingCompany` ON (`ShippingCost`.`shipping_company_id` = `ShippingCompany`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`plants` AS `Plant` ON (`ShippingCost`.`plant_id` = `Plant`.`id`) WHERE `Plant`.`is_active` = '1' AND `ShippingCompany`.`is_active` = '1' AND `postcode_id` = 663 AND `plant_id` = 1 AND ((`cost` >= 0) OR (`cost` IS NULL)) AND NOT (`shipping_company_id` IS NULL) AND `shipping_company_id` != 6 ORDER BY `nullswitch` DESC, `cost` ASC LIMIT 1 | 1 | 1 | 5 | maybe slow |
SELECT `ProductVariant`.*, `VatRate`.*, `Product`.`excludes_vat`, IF(Product.excludes_vat=1,ProductVariant.price*((VatRate.rate/100)+1),ProductVariant.price) AS calculatedprice, IF(Product.excludes_vat<>1,ProductVariant.price/((VatRate.rate/100)+1),ProductVariant.price) AS exvat, `ProductVariant`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_variants` AS `ProductVariant` left JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_products` AS `Product` ON (`ProductVariant`.`product_id` = `Product`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options_product_variants` AS `ProductAttributeOptionsVariants` ON (`ProductVariant`.`id` = `ProductAttributeOptionsVariants`.`product_variant_id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOption` ON (`ProductAttributeOptionsVariants`.`product_attribute_option_id` = `ProductAttributeOption`.`id`) left JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_checkout_vat_rates` AS `VatRate` ON (`Product`.`vat_rate_id` = `VatRate`.`id`) WHERE `ProductVariant`.`product_id` = 128 AND `ProductVariant`.`is_removed` <> '1' | 1 | 1 | 1 | |
SELECT `ProductAttributeOption`.`id`, `ProductAttributeOption`.`product_attribute_id`, `ProductAttributeOption`.`name`, `ProductAttributeOption`.`description`, `ProductAttributeOption`.`sequence`, `ProductAttributeOption`.`created`, `ProductAttributeOption`.`modified`, `EvShopProductAttributeOptionsProductVariant`.`id`, `EvShopProductAttributeOptionsProductVariant`.`product_attribute_option_id`, `EvShopProductAttributeOptionsProductVariant`.`product_variant_id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOption` JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options_product_variants` AS `EvShopProductAttributeOptionsProductVariant` ON (`EvShopProductAttributeOptionsProductVariant`.`product_variant_id` = 1975 AND `EvShopProductAttributeOptionsProductVariant`.`product_attribute_option_id` = `ProductAttributeOption`.`id`) WHERE `ProductAttributeOption`.`id` IN (129, 7, 120, 118, 55, 56, 8, 114, 123, 111, 9, 122, 110, 121, 11, 82, 57, 58, 53, 81, 80, 86, 117, 119, 124, 115, 42, 102, 101, 96, 95, 98, 97, 100, 99, 73, 14, 116, 104, 36, 37, 30, 31, 32, 18, 60, 107, 19, 106, 22, 92, 93, 94, 17, 16, 83, 23, 125, 126, 127, 128, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143) | 1 | 1 | 1 | |
SELECT `ProductAttributeOptions`.`name`, `ProductAttributeOptions`.`description`, `Product`.`excludes_vat`, `VatRate`.`rate`, `ProductVariant`.`online_price`, IF(Product.excludes_vat=1,ProductVariant.price*((VatRate.rate/100)+1),ProductVariant.price) AS calculatedprice, IF(Product.excludes_vat<>1,ProductVariant.price/((VatRate.rate/100)+1),ProductVariant.price) AS exvat, IF(ProductAttributeOptions.description LIKE "%forceprice%", 2, -1) AS force_price, IF(ProductAttributeOptions.description LIKE "%default%", 1, 0) AS is_default, IF(ProductAttributeOptions.description LIKE "%nosurcharge%", 0, 1) AS has_surcharge, IF(ProductAttributeOptions.description LIKE "%separatesurcharge%", 0, 1) AS separate_surcharge, IF(ProductAttributeOptions.description LIKE "%fromprice%", 1, 0) AS from_price, IF(ProductAttributeOptions.description LIKE "%poa%", 1, 0) AS is_poa FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_variants` AS `ProductVariant` LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options_product_variants` AS `ProductAttributeOptionsVariants` ON (`ProductVariant`.`id` = `ProductAttributeOptionsVariants`.`product_variant_id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOptions` ON (`ProductAttributeOptionsVariants`.`product_attribute_option_id` = `ProductAttributeOptions`.`id`) left JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_products` AS `Product` ON (`ProductVariant`.`product_id` = `Product`.`id`) left JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_checkout_vat_rates` AS `VatRate` ON (`Product`.`vat_rate_id` = `VatRate`.`id`) WHERE `ProductVariant`.`product_id` = 128 AND `ProductVariant`.`is_removed` = '0' AND `ProductVariant`.`price` IS NOT NULL AND `ProductVariant`.`price` > 0 AND ((`ProductAttributeOptions`.`description` LIKE '%\"main\"%') OR (`ProductAttributeOptions`.`description` LIKE '%\"default\"%')) ORDER BY `force_price` DESC, `is_default` ASC, `calculatedprice` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `Product`.`id`, `Product`.`plant_id`, `Product`.`force_shipping_company_id`, `Product`.`name`, `Product`.`internal_title`, `Product`.`subtitle`, `Product`.`SKU`, `Product`.`lead_time`, `Product`.`excludes_vat`, `Product`.`vat_rate_id`, `Product`.`use_size_price`, `Product`.`calculator_size`, `Product`.`aggregate_size_id`, `Product`.`homepage_text`, `Product`.`description`, `Product`.`expanded_text`, `Product`.`additional_title`, `Product`.`additional_text`, `Product`.`additional_button_title`, `Product`.`additional_button_url`, `Product`.`aside_title`, `Product`.`aside_text`, `Product`.`mix_design`, `Product`.`technical_spec`, `Product`.`addon_products_text`, `Product`.`suitable_for`, `Product`.`not_suitable_for`, `Product`.`sash_colour_id`, `Product`.`sash_message_id`, `Product`.`no_gravel_calculator`, `Product`.`display_only`, `Product`.`admin_only`, `Product`.`flag_order`, `Product`.`nofollow`, `Product`.`is_grouped_product`, `Product`.`no_loose_load_message`, `Product`.`google_feed_title`, `Product`.`google_feed_description`, `Product`.`exclude_from_feed`, `Product`.`is_featured`, `Product`.`on_homepage`, `Product`.`hide_background_image`, `Product`.`hide_background_image_on_mobile`, `Product`.`show_options_as_dropdown`, `Product`.`qualifies_for_gravelx_upsell`, `Product`.`show_gravelx_aside`, `Product`.`upsell_specific_sizes`, `Product`.`is_active`, `Product`.`is_removed`, `Product`.`created`, `Product`.`modified`, `VatRate`.`id`, `VatRate`.`rate`, `VatRate`.`name`, `VatRate`.`is_active`, `VatRate`.`created`, `VatRate`.`modified`, `SashColour`.`id`, `SashColour`.`name`, `SashColour`.`hex`, `SashColour`.`text_hex`, `SashColour`.`created`, `SashColour`.`modified`, `SashColour`.`is_active`, `SashMessage`.`id`, `SashMessage`.`name`, `SashMessage`.`created`, `SashMessage`.`modified`, `SashMessage`.`is_active`, `AggregateSize`.`id`, `AggregateSize`.`name`, `AggregateSize`.`sequence`, `AggregateSize`.`created`, `AggregateSize`.`modified` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_products` AS `Product` LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_checkout_vat_rates` AS `VatRate` ON (`Product`.`vat_rate_id` = `VatRate`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`sash_colours` AS `SashColour` ON (`Product`.`sash_colour_id` = `SashColour`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`sash_messages` AS `SashMessage` ON (`Product`.`sash_message_id` = `SashMessage`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`aggregate_sizes` AS `AggregateSize` ON (`Product`.`aggregate_size_id` = `AggregateSize`.`id`) WHERE `Product`.`is_active` = '1' AND `Product`.`id` = 2 AND `is_removed` = '0' ORDER BY `Product`.`modified` DESC LIMIT 1 | 1 | 1 | 1 | |
SELECT `ProductVariant`.`id`, `ProductVariant`.`product_id`, `ProductVariant`.`name`, `ProductVariant`.`opera_stock_ref`, `ProductVariant`.`price`, `ProductVariant`.`online_price`, `ProductVariant`.`pick_and_mix_price`, `ProductVariant`.`rrp`, `ProductVariant`.`stock`, `ProductVariant`.`unlimited_stock`, `ProductVariant`.`google_feed_title`, `ProductVariant`.`google_feed_description`, `ProductVariant`.`custom_quantities`, `ProductVariant`.`allow_upsell`, `ProductVariant`.`is_removed`, `ProductVariant`.`created`, `ProductVariant`.`modified`, `ProductVariant`.`last_exported` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_variants` AS `ProductVariant` WHERE `ProductVariant`.`is_removed` <> '1' AND `ProductVariant`.`product_id` = (2) | 6 | 6 | 1 | maybe slow |
SELECT `BackgroundImage`.`id`, `BackgroundImage`.`model`, `BackgroundImage`.`model_id`, `BackgroundImage`.`filename`, `BackgroundImage`.`attachment_type`, `BackgroundImage`.`alt`, `BackgroundImage`.`title`, `BackgroundImage`.`caption`, `BackgroundImage`.`link_text`, `BackgroundImage`.`link_url`, `BackgroundImage`.`products`, `BackgroundImage`.`body`, `BackgroundImage`.`type`, `BackgroundImage`.`size`, `BackgroundImage`.`dir`, `BackgroundImage`.`sequence`, `BackgroundImage`.`is_active`, `BackgroundImage`.`created`, `BackgroundImage`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `BackgroundImage__filepath` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`images` AS `BackgroundImage` WHERE `model` = 'Product' AND `attachment_type` = 'BackgroundImage' AND `BackgroundImage`.`model_id` = (2) ORDER BY `sequence` ASC | 1 | 1 | 1 | |
SELECT `ListingImage`.`id`, `ListingImage`.`model`, `ListingImage`.`model_id`, `ListingImage`.`filename`, `ListingImage`.`attachment_type`, `ListingImage`.`alt`, `ListingImage`.`title`, `ListingImage`.`caption`, `ListingImage`.`link_text`, `ListingImage`.`link_url`, `ListingImage`.`products`, `ListingImage`.`body`, `ListingImage`.`type`, `ListingImage`.`size`, `ListingImage`.`dir`, `ListingImage`.`sequence`, `ListingImage`.`is_active`, `ListingImage`.`created`, `ListingImage`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `ListingImage__filepath` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`images` AS `ListingImage` WHERE `model` = 'Product' AND `attachment_type` = 'ListingImage' AND `ListingImage`.`model_id` = (2) ORDER BY `sequence` ASC | 1 | 1 | 1 | |
SELECT `SampleImage`.`id`, `SampleImage`.`model`, `SampleImage`.`model_id`, `SampleImage`.`filename`, `SampleImage`.`attachment_type`, `SampleImage`.`alt`, `SampleImage`.`title`, `SampleImage`.`caption`, `SampleImage`.`link_text`, `SampleImage`.`link_url`, `SampleImage`.`products`, `SampleImage`.`body`, `SampleImage`.`type`, `SampleImage`.`size`, `SampleImage`.`dir`, `SampleImage`.`sequence`, `SampleImage`.`is_active`, `SampleImage`.`created`, `SampleImage`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `SampleImage__filepath` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`images` AS `SampleImage` WHERE `model` = 'Product' AND `attachment_type` = 'SampleImage' AND `SampleImage`.`model_id` = (2) ORDER BY `sequence` ASC | 1 | 1 | 1 | |
SELECT `AsideImage`.`id`, `AsideImage`.`model`, `AsideImage`.`model_id`, `AsideImage`.`filename`, `AsideImage`.`attachment_type`, `AsideImage`.`alt`, `AsideImage`.`title`, `AsideImage`.`caption`, `AsideImage`.`link_text`, `AsideImage`.`link_url`, `AsideImage`.`products`, `AsideImage`.`body`, `AsideImage`.`type`, `AsideImage`.`size`, `AsideImage`.`dir`, `AsideImage`.`sequence`, `AsideImage`.`is_active`, `AsideImage`.`created`, `AsideImage`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `AsideImage__filepath` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`images` AS `AsideImage` WHERE `model` = 'Product' AND `attachment_type` = 'AsideImage' AND `AsideImage`.`model_id` = (2) ORDER BY `sequence` ASC | 0 | 0 | 0 | |
SELECT `Image`.`id`, `Image`.`model`, `Image`.`model_id`, `Image`.`filename`, `Image`.`attachment_type`, `Image`.`alt`, `Image`.`title`, `Image`.`caption`, `Image`.`link_text`, `Image`.`link_url`, `Image`.`products`, `Image`.`body`, `Image`.`type`, `Image`.`size`, `Image`.`dir`, `Image`.`sequence`, `Image`.`is_active`, `Image`.`created`, `Image`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `Image__filepath` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`images` AS `Image` WHERE `model` = 'Product' AND `attachment_type` = 'Image' AND `Image`.`model_id` = (2) ORDER BY `sequence` ASC | 4 | 4 | 0 | |
SELECT `ProductAttributeOption`.`id`, `ProductAttributeOption`.`product_attribute_id`, `ProductAttributeOption`.`name`, `ProductAttributeOption`.`description`, `ProductAttributeOption`.`sequence`, `ProductAttributeOption`.`created`, `ProductAttributeOption`.`modified`, `EvShopProductAttributeOptionsProduct`.`id`, `EvShopProductAttributeOptionsProduct`.`product_attribute_option_id`, `EvShopProductAttributeOptionsProduct`.`product_id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOption` JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options_products` AS `EvShopProductAttributeOptionsProduct` ON (`EvShopProductAttributeOptionsProduct`.`product_id` = 2 AND `EvShopProductAttributeOptionsProduct`.`product_attribute_option_id` = `ProductAttributeOption`.`id`) | 8 | 8 | 0 | |
SELECT `SecondaryPlant`.`id`, `SecondaryPlant`.`name`, `SecondaryPlant`.`front_facing_name`, `SecondaryPlant`.`order_recipient`, `SecondaryPlant`.`email`, `SecondaryPlant`.`phone`, `SecondaryPlant`.`printer_name`, `SecondaryPlant`.`use_email`, `SecondaryPlant`.`use_printer`, `SecondaryPlant`.`allow_customer_collection`, `SecondaryPlant`.`no_queue_emails`, `SecondaryPlant`.`has_earlier_next_day_queue`, `SecondaryPlant`.`is_direct`, `SecondaryPlant`.`sequence`, `SecondaryPlant`.`address_name`, `SecondaryPlant`.`address_line_1`, `SecondaryPlant`.`address_line_2`, `SecondaryPlant`.`address_line_3`, `SecondaryPlant`.`address_town`, `SecondaryPlant`.`address_county`, `SecondaryPlant`.`address_postcode`, `SecondaryPlant`.`pricing_postcode`, `SecondaryPlant`.`pallex_username`, `SecondaryPlant`.`pallex_password`, `SecondaryPlant`.`created`, `SecondaryPlant`.`modified`, `SecondaryPlant`.`is_active`, `EvShopProductsPlant`.`id`, `EvShopProductsPlant`.`ev_shop_product_id`, `EvShopProductsPlant`.`plant_id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`plants` AS `SecondaryPlant` JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_products_plants` AS `EvShopProductsPlant` ON (`EvShopProductsPlant`.`ev_shop_product_id` = 2 AND `EvShopProductsPlant`.`plant_id` = `SecondaryPlant`.`id`) | 1 | 1 | 1 | |
SELECT `ProductFaq`.`id`, `ProductFaq`.`question`, `ProductFaq`.`answer`, `ProductFaq`.`is_active`, `ProductFaq`.`sequence`, `ProductFaq`.`created`, `ProductFaq`.`modified`, `ProductFaqsEvShopProduct`.`id`, `ProductFaqsEvShopProduct`.`faq_id`, `ProductFaqsEvShopProduct`.`ev_shop_product_id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`product_faqs` AS `ProductFaq` JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`product_faqs_ev_shop_products` AS `ProductFaqsEvShopProduct` ON (`ProductFaqsEvShopProduct`.`ev_shop_product_id` = 2 AND `ProductFaqsEvShopProduct`.`faq_id` = `ProductFaq`.`id`) ORDER BY `ProductFaq`.`sequence` ASC | 0 | 0 | 0 | |
SELECT `RelatedCategory`.`id`, `RelatedCategory`.`accent_colour_id`, `RelatedCategory`.`category_type`, `RelatedCategory`.`name`, `RelatedCategory`.`internal_title`, `RelatedCategory`.`parent_id`, `RelatedCategory`.`from_price`, `RelatedCategory`.`delivery_delay`, `RelatedCategory`.`homepage_title`, `RelatedCategory`.`homepage_text`, `RelatedCategory`.`description`, `RelatedCategory`.`secondary_description`, `RelatedCategory`.`products_anchor_text`, `RelatedCategory`.`banner_button_text`, `RelatedCategory`.`banner_button_link`, `RelatedCategory`.`why_use_us_heading`, `RelatedCategory`.`why_use_us_left_heading`, `RelatedCategory`.`why_use_us_left`, `RelatedCategory`.`why_use_us_left_button_text`, `RelatedCategory`.`why_use_us_left_button_link`, `RelatedCategory`.`why_use_us_right_heading`, `RelatedCategory`.`why_use_us_right`, `RelatedCategory`.`why_use_us_right_button_text`, `RelatedCategory`.`why_use_us_right_button_link`, `RelatedCategory`.`expanded_text`, `RelatedCategory`.`uses_gravel_calculator`, `RelatedCategory`.`external_site_link`, `RelatedCategory`.`external_site_url`, `RelatedCategory`.`featured_on_homepage`, `RelatedCategory`.`display_in_menu`, `RelatedCategory`.`hidden_category`, `RelatedCategory`.`product_attribute_id`, `RelatedCategory`.`lft`, `RelatedCategory`.`rght`, `RelatedCategory`.`created`, `RelatedCategory`.`modified`, `RelatedItem`.`id`, `RelatedItem`.`model`, `RelatedItem`.`model_id`, `RelatedItem`.`related_model`, `RelatedItem`.`related_model_id`, `RelatedItem`.`sequence`, `RelatedItem`.`created`, `RelatedItem`.`modified` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_category_categories` AS `RelatedCategory` JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_related_items_related_items` AS `RelatedItem` ON (`RelatedItem`.`model_id` = 2 AND `RelatedItem`.`related_model_id` = `RelatedCategory`.`id`) WHERE `model` = 'Product' AND `related_model` = 'Category' | 10 | 10 | 2 | maybe slow |
SELECT `RelatedBrand`.`id`, `RelatedBrand`.`name`, `RelatedBrand`.`description`, `RelatedBrand`.`created`, `RelatedBrand`.`modified`, `RelatedItem`.`id`, `RelatedItem`.`model`, `RelatedItem`.`model_id`, `RelatedItem`.`related_model`, `RelatedItem`.`related_model_id`, `RelatedItem`.`sequence`, `RelatedItem`.`created`, `RelatedItem`.`modified` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_brands` AS `RelatedBrand` JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_related_items_related_items` AS `RelatedItem` ON (`RelatedItem`.`model_id` = 2 AND `RelatedItem`.`related_model_id` = `RelatedBrand`.`id`) WHERE `model` = 'Product' AND `related_model` = 'Brand' | 0 | 0 | 2 | maybe slow |
SELECT `RelatedProduct`.`id`, `RelatedProduct`.`plant_id`, `RelatedProduct`.`force_shipping_company_id`, `RelatedProduct`.`name`, `RelatedProduct`.`internal_title`, `RelatedProduct`.`subtitle`, `RelatedProduct`.`SKU`, `RelatedProduct`.`lead_time`, `RelatedProduct`.`excludes_vat`, `RelatedProduct`.`vat_rate_id`, `RelatedProduct`.`use_size_price`, `RelatedProduct`.`calculator_size`, `RelatedProduct`.`aggregate_size_id`, `RelatedProduct`.`homepage_text`, `RelatedProduct`.`description`, `RelatedProduct`.`expanded_text`, `RelatedProduct`.`additional_title`, `RelatedProduct`.`additional_text`, `RelatedProduct`.`additional_button_title`, `RelatedProduct`.`additional_button_url`, `RelatedProduct`.`aside_title`, `RelatedProduct`.`aside_text`, `RelatedProduct`.`mix_design`, `RelatedProduct`.`technical_spec`, `RelatedProduct`.`addon_products_text`, `RelatedProduct`.`suitable_for`, `RelatedProduct`.`not_suitable_for`, `RelatedProduct`.`sash_colour_id`, `RelatedProduct`.`sash_message_id`, `RelatedProduct`.`no_gravel_calculator`, `RelatedProduct`.`display_only`, `RelatedProduct`.`admin_only`, `RelatedProduct`.`flag_order`, `RelatedProduct`.`nofollow`, `RelatedProduct`.`is_grouped_product`, `RelatedProduct`.`no_loose_load_message`, `RelatedProduct`.`google_feed_title`, `RelatedProduct`.`google_feed_description`, `RelatedProduct`.`exclude_from_feed`, `RelatedProduct`.`is_featured`, `RelatedProduct`.`on_homepage`, `RelatedProduct`.`hide_background_image`, `RelatedProduct`.`hide_background_image_on_mobile`, `RelatedProduct`.`show_options_as_dropdown`, `RelatedProduct`.`qualifies_for_gravelx_upsell`, `RelatedProduct`.`show_gravelx_aside`, `RelatedProduct`.`upsell_specific_sizes`, `RelatedProduct`.`is_active`, `RelatedProduct`.`is_removed`, `RelatedProduct`.`created`, `RelatedProduct`.`modified`, `RelatedItem`.`id`, `RelatedItem`.`model`, `RelatedItem`.`model_id`, `RelatedItem`.`related_model`, `RelatedItem`.`related_model_id`, `RelatedItem`.`sequence`, `RelatedItem`.`created`, `RelatedItem`.`modified` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_products` AS `RelatedProduct` JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_related_items_related_items` AS `RelatedItem` ON (`RelatedItem`.`model_id` = 2 AND `RelatedItem`.`related_model_id` = `RelatedProduct`.`id`) WHERE `RelatedProduct`.`is_active` = '1' AND `model` = 'Product' AND `related_model` = 'Product' AND `is_active` = '1' ORDER BY `sequence` ASC | 12 | 12 | 2 | maybe slow |
SELECT `MetaData`.`id`, `MetaData`.`model`, `MetaData`.`model_id`, `MetaData`.`title`, `MetaData`.`description`, `MetaData`.`keywords`, `MetaData`.`created`, `MetaData`.`modified` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`meta_data` AS `MetaData` WHERE ((`model` = 'Product') AND (`model_id` = 2)) | 3 | 3 | 0 | |
SELECT `Route`.`id`, `Route`.`alias`, `Route`.`actual` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`routes` AS `Route` WHERE `Route`.`actual` = 'app_products/view/2' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Postcode`.`id`, `Postcode`.`outcode` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`postcodes` AS `Postcode` WHERE `outcode` LIKE 'DE4' LIMIT 1 | 1 | 1 | 0 | |
SELECT `ShippingCompany`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_companies` AS `ShippingCompany` WHERE `is_active` = '1' AND `pricing_only` = '1' | 0 | 0 | 0 | |
SELECT `ShippingCost`.*, `ShippingCompany`.*, IF(cost IS NULL AND shipping_company_id <> 7, -1, 0) AS nullswitch, `ShippingCompany`.`id`, `Plant`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_costs` AS `ShippingCost` LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_companies` AS `ShippingCompany` ON (`ShippingCost`.`shipping_company_id` = `ShippingCompany`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`plants` AS `Plant` ON (`ShippingCost`.`plant_id` = `Plant`.`id`) WHERE `Plant`.`is_active` = '1' AND `ShippingCompany`.`is_active` = '1' AND `postcode_id` = 663 AND `plant_id` = 9 AND ((`cost` >= 0) OR (`cost` IS NULL)) AND NOT (`shipping_company_id` IS NULL) AND `shipping_company_id` != 6 ORDER BY `nullswitch` DESC, `cost` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `Postcode`.`id`, `Postcode`.`outcode` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`postcodes` AS `Postcode` WHERE `outcode` LIKE 'DE4' LIMIT 1 | 1 | 1 | 0 | |
SELECT `ShippingCompany`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_companies` AS `ShippingCompany` WHERE `is_active` = '1' AND `pricing_only` = '1' | 0 | 0 | 0 | |
SELECT `ShippingCost`.*, `ShippingCompany`.*, IF(cost IS NULL AND shipping_company_id <> 7, -1, 0) AS nullswitch, `ShippingCompany`.`id`, `Plant`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_costs` AS `ShippingCost` LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_companies` AS `ShippingCompany` ON (`ShippingCost`.`shipping_company_id` = `ShippingCompany`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`plants` AS `Plant` ON (`ShippingCost`.`plant_id` = `Plant`.`id`) WHERE `Plant`.`is_active` = '1' AND `ShippingCompany`.`is_active` = '1' AND `postcode_id` = 663 AND `plant_id` = 9 AND ((`cost` >= 0) OR (`cost` IS NULL)) AND NOT (`shipping_company_id` IS NULL) AND `shipping_company_id` != 6 ORDER BY `nullswitch` DESC, `cost` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `ProductVariant`.*, `VatRate`.*, `Product`.`excludes_vat`, IF(Product.excludes_vat=1,ProductVariant.price*((VatRate.rate/100)+1),ProductVariant.price) AS calculatedprice, IF(Product.excludes_vat<>1,ProductVariant.price/((VatRate.rate/100)+1),ProductVariant.price) AS exvat, `ProductVariant`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_variants` AS `ProductVariant` left JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_products` AS `Product` ON (`ProductVariant`.`product_id` = `Product`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options_product_variants` AS `ProductAttributeOptionsVariants` ON (`ProductVariant`.`id` = `ProductAttributeOptionsVariants`.`product_variant_id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOption` ON (`ProductAttributeOptionsVariants`.`product_attribute_option_id` = `ProductAttributeOption`.`id`) left JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_checkout_vat_rates` AS `VatRate` ON (`Product`.`vat_rate_id` = `VatRate`.`id`) WHERE `ProductVariant`.`product_id` = 2 AND `ProductVariant`.`is_removed` <> '1' | 18 | 18 | 1 | maybe slow |
SELECT `ProductAttributeOption`.`id`, `ProductAttributeOption`.`product_attribute_id`, `ProductAttributeOption`.`name`, `ProductAttributeOption`.`description`, `ProductAttributeOption`.`sequence`, `ProductAttributeOption`.`created`, `ProductAttributeOption`.`modified`, `EvShopProductAttributeOptionsProductVariant`.`id`, `EvShopProductAttributeOptionsProductVariant`.`product_attribute_option_id`, `EvShopProductAttributeOptionsProductVariant`.`product_variant_id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOption` JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options_product_variants` AS `EvShopProductAttributeOptionsProductVariant` ON (`EvShopProductAttributeOptionsProductVariant`.`product_variant_id` IN (1476, 1477, 1478, 1479, 1481, 2040) AND `EvShopProductAttributeOptionsProductVariant`.`product_attribute_option_id` = `ProductAttributeOption`.`id`) WHERE `ProductAttributeOption`.`id` IN (129, 7, 120, 118, 55, 56, 8, 114, 123, 111, 9, 122, 110, 121, 11, 82, 57, 58, 53, 81, 80, 86, 117, 119, 124, 115, 42, 102, 101, 96, 95, 98, 97, 100, 99, 73, 14, 116, 104, 36, 37, 30, 31, 32, 18, 60, 107, 19, 106, 22, 92, 93, 94, 17, 16, 83, 23, 125, 126, 127, 128, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143) | 6 | 6 | 1 | maybe slow |
SELECT `ProductAttributeOptions`.`name`, `ProductAttributeOptions`.`description`, `Product`.`excludes_vat`, `VatRate`.`rate`, `ProductVariant`.`online_price`, IF(Product.excludes_vat=1,ProductVariant.price*((VatRate.rate/100)+1),ProductVariant.price) AS calculatedprice, IF(Product.excludes_vat<>1,ProductVariant.price/((VatRate.rate/100)+1),ProductVariant.price) AS exvat, IF(ProductAttributeOptions.description LIKE "%forceprice%", 2, -1) AS force_price, IF(ProductAttributeOptions.description LIKE "%default%", 1, 0) AS is_default, IF(ProductAttributeOptions.description LIKE "%nosurcharge%", 0, 1) AS has_surcharge, IF(ProductAttributeOptions.description LIKE "%separatesurcharge%", 0, 1) AS separate_surcharge, IF(ProductAttributeOptions.description LIKE "%fromprice%", 1, 0) AS from_price, IF(ProductAttributeOptions.description LIKE "%poa%", 1, 0) AS is_poa FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_variants` AS `ProductVariant` LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options_product_variants` AS `ProductAttributeOptionsVariants` ON (`ProductVariant`.`id` = `ProductAttributeOptionsVariants`.`product_variant_id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOptions` ON (`ProductAttributeOptionsVariants`.`product_attribute_option_id` = `ProductAttributeOptions`.`id`) left JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_products` AS `Product` ON (`ProductVariant`.`product_id` = `Product`.`id`) left JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_checkout_vat_rates` AS `VatRate` ON (`Product`.`vat_rate_id` = `VatRate`.`id`) WHERE `ProductVariant`.`product_id` = 2 AND `ProductVariant`.`is_removed` = '0' AND `ProductVariant`.`price` IS NOT NULL AND `ProductVariant`.`price` > 0 AND ((`ProductAttributeOptions`.`description` LIKE '%\"main\"%') OR (`ProductAttributeOptions`.`description` LIKE '%\"default\"%')) ORDER BY `force_price` DESC, `is_default` ASC, `calculatedprice` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `Product`.`id`, `Product`.`plant_id`, `Product`.`force_shipping_company_id`, `Product`.`name`, `Product`.`internal_title`, `Product`.`subtitle`, `Product`.`SKU`, `Product`.`lead_time`, `Product`.`excludes_vat`, `Product`.`vat_rate_id`, `Product`.`use_size_price`, `Product`.`calculator_size`, `Product`.`aggregate_size_id`, `Product`.`homepage_text`, `Product`.`description`, `Product`.`expanded_text`, `Product`.`additional_title`, `Product`.`additional_text`, `Product`.`additional_button_title`, `Product`.`additional_button_url`, `Product`.`aside_title`, `Product`.`aside_text`, `Product`.`mix_design`, `Product`.`technical_spec`, `Product`.`addon_products_text`, `Product`.`suitable_for`, `Product`.`not_suitable_for`, `Product`.`sash_colour_id`, `Product`.`sash_message_id`, `Product`.`no_gravel_calculator`, `Product`.`display_only`, `Product`.`admin_only`, `Product`.`flag_order`, `Product`.`nofollow`, `Product`.`is_grouped_product`, `Product`.`no_loose_load_message`, `Product`.`google_feed_title`, `Product`.`google_feed_description`, `Product`.`exclude_from_feed`, `Product`.`is_featured`, `Product`.`on_homepage`, `Product`.`hide_background_image`, `Product`.`hide_background_image_on_mobile`, `Product`.`show_options_as_dropdown`, `Product`.`qualifies_for_gravelx_upsell`, `Product`.`show_gravelx_aside`, `Product`.`upsell_specific_sizes`, `Product`.`is_active`, `Product`.`is_removed`, `Product`.`created`, `Product`.`modified`, `VatRate`.`id`, `VatRate`.`rate`, `VatRate`.`name`, `VatRate`.`is_active`, `VatRate`.`created`, `VatRate`.`modified`, `SashColour`.`id`, `SashColour`.`name`, `SashColour`.`hex`, `SashColour`.`text_hex`, `SashColour`.`created`, `SashColour`.`modified`, `SashColour`.`is_active`, `SashMessage`.`id`, `SashMessage`.`name`, `SashMessage`.`created`, `SashMessage`.`modified`, `SashMessage`.`is_active`, `AggregateSize`.`id`, `AggregateSize`.`name`, `AggregateSize`.`sequence`, `AggregateSize`.`created`, `AggregateSize`.`modified` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_products` AS `Product` LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_checkout_vat_rates` AS `VatRate` ON (`Product`.`vat_rate_id` = `VatRate`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`sash_colours` AS `SashColour` ON (`Product`.`sash_colour_id` = `SashColour`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`sash_messages` AS `SashMessage` ON (`Product`.`sash_message_id` = `SashMessage`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`aggregate_sizes` AS `AggregateSize` ON (`Product`.`aggregate_size_id` = `AggregateSize`.`id`) WHERE `Product`.`is_active` = '1' AND `Product`.`id` = 42 AND `is_removed` = '0' ORDER BY `Product`.`modified` DESC LIMIT 1 | 1 | 1 | 1 | |
SELECT `ProductVariant`.`id`, `ProductVariant`.`product_id`, `ProductVariant`.`name`, `ProductVariant`.`opera_stock_ref`, `ProductVariant`.`price`, `ProductVariant`.`online_price`, `ProductVariant`.`pick_and_mix_price`, `ProductVariant`.`rrp`, `ProductVariant`.`stock`, `ProductVariant`.`unlimited_stock`, `ProductVariant`.`google_feed_title`, `ProductVariant`.`google_feed_description`, `ProductVariant`.`custom_quantities`, `ProductVariant`.`allow_upsell`, `ProductVariant`.`is_removed`, `ProductVariant`.`created`, `ProductVariant`.`modified`, `ProductVariant`.`last_exported` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_variants` AS `ProductVariant` WHERE `ProductVariant`.`is_removed` <> '1' AND `ProductVariant`.`product_id` = (42) | 6 | 6 | 0 | |
SELECT `BackgroundImage`.`id`, `BackgroundImage`.`model`, `BackgroundImage`.`model_id`, `BackgroundImage`.`filename`, `BackgroundImage`.`attachment_type`, `BackgroundImage`.`alt`, `BackgroundImage`.`title`, `BackgroundImage`.`caption`, `BackgroundImage`.`link_text`, `BackgroundImage`.`link_url`, `BackgroundImage`.`products`, `BackgroundImage`.`body`, `BackgroundImage`.`type`, `BackgroundImage`.`size`, `BackgroundImage`.`dir`, `BackgroundImage`.`sequence`, `BackgroundImage`.`is_active`, `BackgroundImage`.`created`, `BackgroundImage`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `BackgroundImage__filepath` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`images` AS `BackgroundImage` WHERE `model` = 'Product' AND `attachment_type` = 'BackgroundImage' AND `BackgroundImage`.`model_id` = (42) ORDER BY `sequence` ASC | 1 | 1 | 0 | |
SELECT `ListingImage`.`id`, `ListingImage`.`model`, `ListingImage`.`model_id`, `ListingImage`.`filename`, `ListingImage`.`attachment_type`, `ListingImage`.`alt`, `ListingImage`.`title`, `ListingImage`.`caption`, `ListingImage`.`link_text`, `ListingImage`.`link_url`, `ListingImage`.`products`, `ListingImage`.`body`, `ListingImage`.`type`, `ListingImage`.`size`, `ListingImage`.`dir`, `ListingImage`.`sequence`, `ListingImage`.`is_active`, `ListingImage`.`created`, `ListingImage`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `ListingImage__filepath` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`images` AS `ListingImage` WHERE `model` = 'Product' AND `attachment_type` = 'ListingImage' AND `ListingImage`.`model_id` = (42) ORDER BY `sequence` ASC | 1 | 1 | 0 | |
SELECT `SampleImage`.`id`, `SampleImage`.`model`, `SampleImage`.`model_id`, `SampleImage`.`filename`, `SampleImage`.`attachment_type`, `SampleImage`.`alt`, `SampleImage`.`title`, `SampleImage`.`caption`, `SampleImage`.`link_text`, `SampleImage`.`link_url`, `SampleImage`.`products`, `SampleImage`.`body`, `SampleImage`.`type`, `SampleImage`.`size`, `SampleImage`.`dir`, `SampleImage`.`sequence`, `SampleImage`.`is_active`, `SampleImage`.`created`, `SampleImage`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `SampleImage__filepath` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`images` AS `SampleImage` WHERE `model` = 'Product' AND `attachment_type` = 'SampleImage' AND `SampleImage`.`model_id` = (42) ORDER BY `sequence` ASC | 1 | 1 | 0 | |
SELECT `AsideImage`.`id`, `AsideImage`.`model`, `AsideImage`.`model_id`, `AsideImage`.`filename`, `AsideImage`.`attachment_type`, `AsideImage`.`alt`, `AsideImage`.`title`, `AsideImage`.`caption`, `AsideImage`.`link_text`, `AsideImage`.`link_url`, `AsideImage`.`products`, `AsideImage`.`body`, `AsideImage`.`type`, `AsideImage`.`size`, `AsideImage`.`dir`, `AsideImage`.`sequence`, `AsideImage`.`is_active`, `AsideImage`.`created`, `AsideImage`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `AsideImage__filepath` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`images` AS `AsideImage` WHERE `model` = 'Product' AND `attachment_type` = 'AsideImage' AND `AsideImage`.`model_id` = (42) ORDER BY `sequence` ASC | 0 | 0 | 0 | |
SELECT `Image`.`id`, `Image`.`model`, `Image`.`model_id`, `Image`.`filename`, `Image`.`attachment_type`, `Image`.`alt`, `Image`.`title`, `Image`.`caption`, `Image`.`link_text`, `Image`.`link_url`, `Image`.`products`, `Image`.`body`, `Image`.`type`, `Image`.`size`, `Image`.`dir`, `Image`.`sequence`, `Image`.`is_active`, `Image`.`created`, `Image`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `Image__filepath` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`images` AS `Image` WHERE `model` = 'Product' AND `attachment_type` = 'Image' AND `Image`.`model_id` = (42) ORDER BY `sequence` ASC | 6 | 6 | 0 | |
SELECT `ProductAttributeOption`.`id`, `ProductAttributeOption`.`product_attribute_id`, `ProductAttributeOption`.`name`, `ProductAttributeOption`.`description`, `ProductAttributeOption`.`sequence`, `ProductAttributeOption`.`created`, `ProductAttributeOption`.`modified`, `EvShopProductAttributeOptionsProduct`.`id`, `EvShopProductAttributeOptionsProduct`.`product_attribute_option_id`, `EvShopProductAttributeOptionsProduct`.`product_id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOption` JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options_products` AS `EvShopProductAttributeOptionsProduct` ON (`EvShopProductAttributeOptionsProduct`.`product_id` = 42 AND `EvShopProductAttributeOptionsProduct`.`product_attribute_option_id` = `ProductAttributeOption`.`id`) | 8 | 8 | 0 | |
SELECT `SecondaryPlant`.`id`, `SecondaryPlant`.`name`, `SecondaryPlant`.`front_facing_name`, `SecondaryPlant`.`order_recipient`, `SecondaryPlant`.`email`, `SecondaryPlant`.`phone`, `SecondaryPlant`.`printer_name`, `SecondaryPlant`.`use_email`, `SecondaryPlant`.`use_printer`, `SecondaryPlant`.`allow_customer_collection`, `SecondaryPlant`.`no_queue_emails`, `SecondaryPlant`.`has_earlier_next_day_queue`, `SecondaryPlant`.`is_direct`, `SecondaryPlant`.`sequence`, `SecondaryPlant`.`address_name`, `SecondaryPlant`.`address_line_1`, `SecondaryPlant`.`address_line_2`, `SecondaryPlant`.`address_line_3`, `SecondaryPlant`.`address_town`, `SecondaryPlant`.`address_county`, `SecondaryPlant`.`address_postcode`, `SecondaryPlant`.`pricing_postcode`, `SecondaryPlant`.`pallex_username`, `SecondaryPlant`.`pallex_password`, `SecondaryPlant`.`created`, `SecondaryPlant`.`modified`, `SecondaryPlant`.`is_active`, `EvShopProductsPlant`.`id`, `EvShopProductsPlant`.`ev_shop_product_id`, `EvShopProductsPlant`.`plant_id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`plants` AS `SecondaryPlant` JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_products_plants` AS `EvShopProductsPlant` ON (`EvShopProductsPlant`.`ev_shop_product_id` = 42 AND `EvShopProductsPlant`.`plant_id` = `SecondaryPlant`.`id`) | 1 | 1 | 0 | |
SELECT `ProductFaq`.`id`, `ProductFaq`.`question`, `ProductFaq`.`answer`, `ProductFaq`.`is_active`, `ProductFaq`.`sequence`, `ProductFaq`.`created`, `ProductFaq`.`modified`, `ProductFaqsEvShopProduct`.`id`, `ProductFaqsEvShopProduct`.`faq_id`, `ProductFaqsEvShopProduct`.`ev_shop_product_id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`product_faqs` AS `ProductFaq` JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`product_faqs_ev_shop_products` AS `ProductFaqsEvShopProduct` ON (`ProductFaqsEvShopProduct`.`ev_shop_product_id` = 42 AND `ProductFaqsEvShopProduct`.`faq_id` = `ProductFaq`.`id`) ORDER BY `ProductFaq`.`sequence` ASC | 0 | 0 | 0 | |
SELECT `RelatedCategory`.`id`, `RelatedCategory`.`accent_colour_id`, `RelatedCategory`.`category_type`, `RelatedCategory`.`name`, `RelatedCategory`.`internal_title`, `RelatedCategory`.`parent_id`, `RelatedCategory`.`from_price`, `RelatedCategory`.`delivery_delay`, `RelatedCategory`.`homepage_title`, `RelatedCategory`.`homepage_text`, `RelatedCategory`.`description`, `RelatedCategory`.`secondary_description`, `RelatedCategory`.`products_anchor_text`, `RelatedCategory`.`banner_button_text`, `RelatedCategory`.`banner_button_link`, `RelatedCategory`.`why_use_us_heading`, `RelatedCategory`.`why_use_us_left_heading`, `RelatedCategory`.`why_use_us_left`, `RelatedCategory`.`why_use_us_left_button_text`, `RelatedCategory`.`why_use_us_left_button_link`, `RelatedCategory`.`why_use_us_right_heading`, `RelatedCategory`.`why_use_us_right`, `RelatedCategory`.`why_use_us_right_button_text`, `RelatedCategory`.`why_use_us_right_button_link`, `RelatedCategory`.`expanded_text`, `RelatedCategory`.`uses_gravel_calculator`, `RelatedCategory`.`external_site_link`, `RelatedCategory`.`external_site_url`, `RelatedCategory`.`featured_on_homepage`, `RelatedCategory`.`display_in_menu`, `RelatedCategory`.`hidden_category`, `RelatedCategory`.`product_attribute_id`, `RelatedCategory`.`lft`, `RelatedCategory`.`rght`, `RelatedCategory`.`created`, `RelatedCategory`.`modified`, `RelatedItem`.`id`, `RelatedItem`.`model`, `RelatedItem`.`model_id`, `RelatedItem`.`related_model`, `RelatedItem`.`related_model_id`, `RelatedItem`.`sequence`, `RelatedItem`.`created`, `RelatedItem`.`modified` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_category_categories` AS `RelatedCategory` JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_related_items_related_items` AS `RelatedItem` ON (`RelatedItem`.`model_id` = 42 AND `RelatedItem`.`related_model_id` = `RelatedCategory`.`id`) WHERE `model` = 'Product' AND `related_model` = 'Category' | 8 | 8 | 2 | maybe slow |
SELECT `RelatedBrand`.`id`, `RelatedBrand`.`name`, `RelatedBrand`.`description`, `RelatedBrand`.`created`, `RelatedBrand`.`modified`, `RelatedItem`.`id`, `RelatedItem`.`model`, `RelatedItem`.`model_id`, `RelatedItem`.`related_model`, `RelatedItem`.`related_model_id`, `RelatedItem`.`sequence`, `RelatedItem`.`created`, `RelatedItem`.`modified` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_brands` AS `RelatedBrand` JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_related_items_related_items` AS `RelatedItem` ON (`RelatedItem`.`model_id` = 42 AND `RelatedItem`.`related_model_id` = `RelatedBrand`.`id`) WHERE `model` = 'Product' AND `related_model` = 'Brand' | 0 | 0 | 1 | maybe slow |
SELECT `RelatedProduct`.`id`, `RelatedProduct`.`plant_id`, `RelatedProduct`.`force_shipping_company_id`, `RelatedProduct`.`name`, `RelatedProduct`.`internal_title`, `RelatedProduct`.`subtitle`, `RelatedProduct`.`SKU`, `RelatedProduct`.`lead_time`, `RelatedProduct`.`excludes_vat`, `RelatedProduct`.`vat_rate_id`, `RelatedProduct`.`use_size_price`, `RelatedProduct`.`calculator_size`, `RelatedProduct`.`aggregate_size_id`, `RelatedProduct`.`homepage_text`, `RelatedProduct`.`description`, `RelatedProduct`.`expanded_text`, `RelatedProduct`.`additional_title`, `RelatedProduct`.`additional_text`, `RelatedProduct`.`additional_button_title`, `RelatedProduct`.`additional_button_url`, `RelatedProduct`.`aside_title`, `RelatedProduct`.`aside_text`, `RelatedProduct`.`mix_design`, `RelatedProduct`.`technical_spec`, `RelatedProduct`.`addon_products_text`, `RelatedProduct`.`suitable_for`, `RelatedProduct`.`not_suitable_for`, `RelatedProduct`.`sash_colour_id`, `RelatedProduct`.`sash_message_id`, `RelatedProduct`.`no_gravel_calculator`, `RelatedProduct`.`display_only`, `RelatedProduct`.`admin_only`, `RelatedProduct`.`flag_order`, `RelatedProduct`.`nofollow`, `RelatedProduct`.`is_grouped_product`, `RelatedProduct`.`no_loose_load_message`, `RelatedProduct`.`google_feed_title`, `RelatedProduct`.`google_feed_description`, `RelatedProduct`.`exclude_from_feed`, `RelatedProduct`.`is_featured`, `RelatedProduct`.`on_homepage`, `RelatedProduct`.`hide_background_image`, `RelatedProduct`.`hide_background_image_on_mobile`, `RelatedProduct`.`show_options_as_dropdown`, `RelatedProduct`.`qualifies_for_gravelx_upsell`, `RelatedProduct`.`show_gravelx_aside`, `RelatedProduct`.`upsell_specific_sizes`, `RelatedProduct`.`is_active`, `RelatedProduct`.`is_removed`, `RelatedProduct`.`created`, `RelatedProduct`.`modified`, `RelatedItem`.`id`, `RelatedItem`.`model`, `RelatedItem`.`model_id`, `RelatedItem`.`related_model`, `RelatedItem`.`related_model_id`, `RelatedItem`.`sequence`, `RelatedItem`.`created`, `RelatedItem`.`modified` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_products` AS `RelatedProduct` JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_related_items_related_items` AS `RelatedItem` ON (`RelatedItem`.`model_id` = 42 AND `RelatedItem`.`related_model_id` = `RelatedProduct`.`id`) WHERE `RelatedProduct`.`is_active` = '1' AND `model` = 'Product' AND `related_model` = 'Product' AND `is_active` = '1' ORDER BY `sequence` ASC | 17 | 17 | 2 | maybe slow |
SELECT `MetaData`.`id`, `MetaData`.`model`, `MetaData`.`model_id`, `MetaData`.`title`, `MetaData`.`description`, `MetaData`.`keywords`, `MetaData`.`created`, `MetaData`.`modified` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`meta_data` AS `MetaData` WHERE ((`model` = 'Product') AND (`model_id` = 42)) | 1 | 1 | 0 | |
SELECT `Route`.`id`, `Route`.`alias`, `Route`.`actual` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`routes` AS `Route` WHERE `Route`.`actual` = 'app_products/view/42' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Postcode`.`id`, `Postcode`.`outcode` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`postcodes` AS `Postcode` WHERE `outcode` LIKE 'DE4' LIMIT 1 | 1 | 1 | 0 | |
SELECT `ShippingCompany`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_companies` AS `ShippingCompany` WHERE `is_active` = '1' AND `pricing_only` = '1' | 0 | 0 | 0 | |
SELECT `ShippingCost`.*, `ShippingCompany`.*, IF(cost IS NULL AND shipping_company_id <> 7, -1, 0) AS nullswitch, `ShippingCompany`.`id`, `Plant`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_costs` AS `ShippingCost` LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_companies` AS `ShippingCompany` ON (`ShippingCost`.`shipping_company_id` = `ShippingCompany`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`plants` AS `Plant` ON (`ShippingCost`.`plant_id` = `Plant`.`id`) WHERE `Plant`.`is_active` = '1' AND `ShippingCompany`.`is_active` = '1' AND `postcode_id` = 663 AND `plant_id` = 9 AND ((`cost` >= 0) OR (`cost` IS NULL)) AND NOT (`shipping_company_id` IS NULL) AND `shipping_company_id` != 6 ORDER BY `nullswitch` DESC, `cost` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `Postcode`.`id`, `Postcode`.`outcode` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`postcodes` AS `Postcode` WHERE `outcode` LIKE 'DE4' LIMIT 1 | 1 | 1 | 0 | |
SELECT `ShippingCompany`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_companies` AS `ShippingCompany` WHERE `is_active` = '1' AND `pricing_only` = '1' | 0 | 0 | 0 | |
SELECT `ShippingCost`.*, `ShippingCompany`.*, IF(cost IS NULL AND shipping_company_id <> 7, -1, 0) AS nullswitch, `ShippingCompany`.`id`, `Plant`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_costs` AS `ShippingCost` LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_companies` AS `ShippingCompany` ON (`ShippingCost`.`shipping_company_id` = `ShippingCompany`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`plants` AS `Plant` ON (`ShippingCost`.`plant_id` = `Plant`.`id`) WHERE `Plant`.`is_active` = '1' AND `ShippingCompany`.`is_active` = '1' AND `postcode_id` = 663 AND `plant_id` = 9 AND ((`cost` >= 0) OR (`cost` IS NULL)) AND NOT (`shipping_company_id` IS NULL) AND `shipping_company_id` != 6 ORDER BY `nullswitch` DESC, `cost` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `ProductVariant`.*, `VatRate`.*, `Product`.`excludes_vat`, IF(Product.excludes_vat=1,ProductVariant.price*((VatRate.rate/100)+1),ProductVariant.price) AS calculatedprice, IF(Product.excludes_vat<>1,ProductVariant.price/((VatRate.rate/100)+1),ProductVariant.price) AS exvat, `ProductVariant`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_variants` AS `ProductVariant` left JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_products` AS `Product` ON (`ProductVariant`.`product_id` = `Product`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options_product_variants` AS `ProductAttributeOptionsVariants` ON (`ProductVariant`.`id` = `ProductAttributeOptionsVariants`.`product_variant_id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOption` ON (`ProductAttributeOptionsVariants`.`product_attribute_option_id` = `ProductAttributeOption`.`id`) left JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_checkout_vat_rates` AS `VatRate` ON (`Product`.`vat_rate_id` = `VatRate`.`id`) WHERE `ProductVariant`.`product_id` = 42 AND `ProductVariant`.`is_removed` <> '1' | 18 | 18 | 1 | maybe slow |
SELECT `ProductAttributeOption`.`id`, `ProductAttributeOption`.`product_attribute_id`, `ProductAttributeOption`.`name`, `ProductAttributeOption`.`description`, `ProductAttributeOption`.`sequence`, `ProductAttributeOption`.`created`, `ProductAttributeOption`.`modified`, `EvShopProductAttributeOptionsProductVariant`.`id`, `EvShopProductAttributeOptionsProductVariant`.`product_attribute_option_id`, `EvShopProductAttributeOptionsProductVariant`.`product_variant_id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOption` JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options_product_variants` AS `EvShopProductAttributeOptionsProductVariant` ON (`EvShopProductAttributeOptionsProductVariant`.`product_variant_id` IN (837, 838, 843, 845, 847, 2047) AND `EvShopProductAttributeOptionsProductVariant`.`product_attribute_option_id` = `ProductAttributeOption`.`id`) WHERE `ProductAttributeOption`.`id` IN (129, 7, 120, 118, 55, 56, 8, 114, 123, 111, 9, 122, 110, 121, 11, 82, 57, 58, 53, 81, 80, 86, 117, 119, 124, 115, 42, 102, 101, 96, 95, 98, 97, 100, 99, 73, 14, 116, 104, 36, 37, 30, 31, 32, 18, 60, 107, 19, 106, 22, 92, 93, 94, 17, 16, 83, 23, 125, 126, 127, 128, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143) | 6 | 6 | 1 | maybe slow |
SELECT `ProductAttributeOptions`.`name`, `ProductAttributeOptions`.`description`, `Product`.`excludes_vat`, `VatRate`.`rate`, `ProductVariant`.`online_price`, IF(Product.excludes_vat=1,ProductVariant.price*((VatRate.rate/100)+1),ProductVariant.price) AS calculatedprice, IF(Product.excludes_vat<>1,ProductVariant.price/((VatRate.rate/100)+1),ProductVariant.price) AS exvat, IF(ProductAttributeOptions.description LIKE "%forceprice%", 2, -1) AS force_price, IF(ProductAttributeOptions.description LIKE "%default%", 1, 0) AS is_default, IF(ProductAttributeOptions.description LIKE "%nosurcharge%", 0, 1) AS has_surcharge, IF(ProductAttributeOptions.description LIKE "%separatesurcharge%", 0, 1) AS separate_surcharge, IF(ProductAttributeOptions.description LIKE "%fromprice%", 1, 0) AS from_price, IF(ProductAttributeOptions.description LIKE "%poa%", 1, 0) AS is_poa FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_variants` AS `ProductVariant` LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options_product_variants` AS `ProductAttributeOptionsVariants` ON (`ProductVariant`.`id` = `ProductAttributeOptionsVariants`.`product_variant_id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOptions` ON (`ProductAttributeOptionsVariants`.`product_attribute_option_id` = `ProductAttributeOptions`.`id`) left JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_products` AS `Product` ON (`ProductVariant`.`product_id` = `Product`.`id`) left JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_checkout_vat_rates` AS `VatRate` ON (`Product`.`vat_rate_id` = `VatRate`.`id`) WHERE `ProductVariant`.`product_id` = 42 AND `ProductVariant`.`is_removed` = '0' AND `ProductVariant`.`price` IS NOT NULL AND `ProductVariant`.`price` > 0 AND ((`ProductAttributeOptions`.`description` LIKE '%\"main\"%') OR (`ProductAttributeOptions`.`description` LIKE '%\"default\"%')) ORDER BY `force_price` DESC, `is_default` ASC, `calculatedprice` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `Product`.`id`, `Product`.`plant_id`, `Product`.`force_shipping_company_id`, `Product`.`name`, `Product`.`internal_title`, `Product`.`subtitle`, `Product`.`SKU`, `Product`.`lead_time`, `Product`.`excludes_vat`, `Product`.`vat_rate_id`, `Product`.`use_size_price`, `Product`.`calculator_size`, `Product`.`aggregate_size_id`, `Product`.`homepage_text`, `Product`.`description`, `Product`.`expanded_text`, `Product`.`additional_title`, `Product`.`additional_text`, `Product`.`additional_button_title`, `Product`.`additional_button_url`, `Product`.`aside_title`, `Product`.`aside_text`, `Product`.`mix_design`, `Product`.`technical_spec`, `Product`.`addon_products_text`, `Product`.`suitable_for`, `Product`.`not_suitable_for`, `Product`.`sash_colour_id`, `Product`.`sash_message_id`, `Product`.`no_gravel_calculator`, `Product`.`display_only`, `Product`.`admin_only`, `Product`.`flag_order`, `Product`.`nofollow`, `Product`.`is_grouped_product`, `Product`.`no_loose_load_message`, `Product`.`google_feed_title`, `Product`.`google_feed_description`, `Product`.`exclude_from_feed`, `Product`.`is_featured`, `Product`.`on_homepage`, `Product`.`hide_background_image`, `Product`.`hide_background_image_on_mobile`, `Product`.`show_options_as_dropdown`, `Product`.`qualifies_for_gravelx_upsell`, `Product`.`show_gravelx_aside`, `Product`.`upsell_specific_sizes`, `Product`.`is_active`, `Product`.`is_removed`, `Product`.`created`, `Product`.`modified`, `VatRate`.`id`, `VatRate`.`rate`, `VatRate`.`name`, `VatRate`.`is_active`, `VatRate`.`created`, `VatRate`.`modified`, `SashColour`.`id`, `SashColour`.`name`, `SashColour`.`hex`, `SashColour`.`text_hex`, `SashColour`.`created`, `SashColour`.`modified`, `SashColour`.`is_active`, `SashMessage`.`id`, `SashMessage`.`name`, `SashMessage`.`created`, `SashMessage`.`modified`, `SashMessage`.`is_active`, `AggregateSize`.`id`, `AggregateSize`.`name`, `AggregateSize`.`sequence`, `AggregateSize`.`created`, `AggregateSize`.`modified` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_products` AS `Product` LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_checkout_vat_rates` AS `VatRate` ON (`Product`.`vat_rate_id` = `VatRate`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`sash_colours` AS `SashColour` ON (`Product`.`sash_colour_id` = `SashColour`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`sash_messages` AS `SashMessage` ON (`Product`.`sash_message_id` = `SashMessage`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`aggregate_sizes` AS `AggregateSize` ON (`Product`.`aggregate_size_id` = `AggregateSize`.`id`) WHERE `Product`.`is_active` = '1' AND `Product`.`id` = 26 AND `is_removed` = '0' ORDER BY `Product`.`modified` DESC LIMIT 1 | 1 | 1 | 1 | |
SELECT `ProductVariant`.`id`, `ProductVariant`.`product_id`, `ProductVariant`.`name`, `ProductVariant`.`opera_stock_ref`, `ProductVariant`.`price`, `ProductVariant`.`online_price`, `ProductVariant`.`pick_and_mix_price`, `ProductVariant`.`rrp`, `ProductVariant`.`stock`, `ProductVariant`.`unlimited_stock`, `ProductVariant`.`google_feed_title`, `ProductVariant`.`google_feed_description`, `ProductVariant`.`custom_quantities`, `ProductVariant`.`allow_upsell`, `ProductVariant`.`is_removed`, `ProductVariant`.`created`, `ProductVariant`.`modified`, `ProductVariant`.`last_exported` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_variants` AS `ProductVariant` WHERE `ProductVariant`.`is_removed` <> '1' AND `ProductVariant`.`product_id` = (26) | 6 | 6 | 0 | |
SELECT `BackgroundImage`.`id`, `BackgroundImage`.`model`, `BackgroundImage`.`model_id`, `BackgroundImage`.`filename`, `BackgroundImage`.`attachment_type`, `BackgroundImage`.`alt`, `BackgroundImage`.`title`, `BackgroundImage`.`caption`, `BackgroundImage`.`link_text`, `BackgroundImage`.`link_url`, `BackgroundImage`.`products`, `BackgroundImage`.`body`, `BackgroundImage`.`type`, `BackgroundImage`.`size`, `BackgroundImage`.`dir`, `BackgroundImage`.`sequence`, `BackgroundImage`.`is_active`, `BackgroundImage`.`created`, `BackgroundImage`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `BackgroundImage__filepath` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`images` AS `BackgroundImage` WHERE `model` = 'Product' AND `attachment_type` = 'BackgroundImage' AND `BackgroundImage`.`model_id` = (26) ORDER BY `sequence` ASC | 1 | 1 | 0 | |
SELECT `ListingImage`.`id`, `ListingImage`.`model`, `ListingImage`.`model_id`, `ListingImage`.`filename`, `ListingImage`.`attachment_type`, `ListingImage`.`alt`, `ListingImage`.`title`, `ListingImage`.`caption`, `ListingImage`.`link_text`, `ListingImage`.`link_url`, `ListingImage`.`products`, `ListingImage`.`body`, `ListingImage`.`type`, `ListingImage`.`size`, `ListingImage`.`dir`, `ListingImage`.`sequence`, `ListingImage`.`is_active`, `ListingImage`.`created`, `ListingImage`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `ListingImage__filepath` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`images` AS `ListingImage` WHERE `model` = 'Product' AND `attachment_type` = 'ListingImage' AND `ListingImage`.`model_id` = (26) ORDER BY `sequence` ASC | 1 | 1 | 0 | |
SELECT `SampleImage`.`id`, `SampleImage`.`model`, `SampleImage`.`model_id`, `SampleImage`.`filename`, `SampleImage`.`attachment_type`, `SampleImage`.`alt`, `SampleImage`.`title`, `SampleImage`.`caption`, `SampleImage`.`link_text`, `SampleImage`.`link_url`, `SampleImage`.`products`, `SampleImage`.`body`, `SampleImage`.`type`, `SampleImage`.`size`, `SampleImage`.`dir`, `SampleImage`.`sequence`, `SampleImage`.`is_active`, `SampleImage`.`created`, `SampleImage`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `SampleImage__filepath` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`images` AS `SampleImage` WHERE `model` = 'Product' AND `attachment_type` = 'SampleImage' AND `SampleImage`.`model_id` = (26) ORDER BY `sequence` ASC | 1 | 1 | 0 | |
SELECT `AsideImage`.`id`, `AsideImage`.`model`, `AsideImage`.`model_id`, `AsideImage`.`filename`, `AsideImage`.`attachment_type`, `AsideImage`.`alt`, `AsideImage`.`title`, `AsideImage`.`caption`, `AsideImage`.`link_text`, `AsideImage`.`link_url`, `AsideImage`.`products`, `AsideImage`.`body`, `AsideImage`.`type`, `AsideImage`.`size`, `AsideImage`.`dir`, `AsideImage`.`sequence`, `AsideImage`.`is_active`, `AsideImage`.`created`, `AsideImage`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `AsideImage__filepath` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`images` AS `AsideImage` WHERE `model` = 'Product' AND `attachment_type` = 'AsideImage' AND `AsideImage`.`model_id` = (26) ORDER BY `sequence` ASC | 0 | 0 | 0 | |
SELECT `Image`.`id`, `Image`.`model`, `Image`.`model_id`, `Image`.`filename`, `Image`.`attachment_type`, `Image`.`alt`, `Image`.`title`, `Image`.`caption`, `Image`.`link_text`, `Image`.`link_url`, `Image`.`products`, `Image`.`body`, `Image`.`type`, `Image`.`size`, `Image`.`dir`, `Image`.`sequence`, `Image`.`is_active`, `Image`.`created`, `Image`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `Image__filepath` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`images` AS `Image` WHERE `model` = 'Product' AND `attachment_type` = 'Image' AND `Image`.`model_id` = (26) ORDER BY `sequence` ASC | 5 | 5 | 0 | |
SELECT `ProductAttributeOption`.`id`, `ProductAttributeOption`.`product_attribute_id`, `ProductAttributeOption`.`name`, `ProductAttributeOption`.`description`, `ProductAttributeOption`.`sequence`, `ProductAttributeOption`.`created`, `ProductAttributeOption`.`modified`, `EvShopProductAttributeOptionsProduct`.`id`, `EvShopProductAttributeOptionsProduct`.`product_attribute_option_id`, `EvShopProductAttributeOptionsProduct`.`product_id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOption` JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options_products` AS `EvShopProductAttributeOptionsProduct` ON (`EvShopProductAttributeOptionsProduct`.`product_id` = 26 AND `EvShopProductAttributeOptionsProduct`.`product_attribute_option_id` = `ProductAttributeOption`.`id`) | 8 | 8 | 0 | |
SELECT `SecondaryPlant`.`id`, `SecondaryPlant`.`name`, `SecondaryPlant`.`front_facing_name`, `SecondaryPlant`.`order_recipient`, `SecondaryPlant`.`email`, `SecondaryPlant`.`phone`, `SecondaryPlant`.`printer_name`, `SecondaryPlant`.`use_email`, `SecondaryPlant`.`use_printer`, `SecondaryPlant`.`allow_customer_collection`, `SecondaryPlant`.`no_queue_emails`, `SecondaryPlant`.`has_earlier_next_day_queue`, `SecondaryPlant`.`is_direct`, `SecondaryPlant`.`sequence`, `SecondaryPlant`.`address_name`, `SecondaryPlant`.`address_line_1`, `SecondaryPlant`.`address_line_2`, `SecondaryPlant`.`address_line_3`, `SecondaryPlant`.`address_town`, `SecondaryPlant`.`address_county`, `SecondaryPlant`.`address_postcode`, `SecondaryPlant`.`pricing_postcode`, `SecondaryPlant`.`pallex_username`, `SecondaryPlant`.`pallex_password`, `SecondaryPlant`.`created`, `SecondaryPlant`.`modified`, `SecondaryPlant`.`is_active`, `EvShopProductsPlant`.`id`, `EvShopProductsPlant`.`ev_shop_product_id`, `EvShopProductsPlant`.`plant_id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`plants` AS `SecondaryPlant` JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_products_plants` AS `EvShopProductsPlant` ON (`EvShopProductsPlant`.`ev_shop_product_id` = 26 AND `EvShopProductsPlant`.`plant_id` = `SecondaryPlant`.`id`) | 1 | 1 | 0 | |
SELECT `ProductFaq`.`id`, `ProductFaq`.`question`, `ProductFaq`.`answer`, `ProductFaq`.`is_active`, `ProductFaq`.`sequence`, `ProductFaq`.`created`, `ProductFaq`.`modified`, `ProductFaqsEvShopProduct`.`id`, `ProductFaqsEvShopProduct`.`faq_id`, `ProductFaqsEvShopProduct`.`ev_shop_product_id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`product_faqs` AS `ProductFaq` JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`product_faqs_ev_shop_products` AS `ProductFaqsEvShopProduct` ON (`ProductFaqsEvShopProduct`.`ev_shop_product_id` = 26 AND `ProductFaqsEvShopProduct`.`faq_id` = `ProductFaq`.`id`) ORDER BY `ProductFaq`.`sequence` ASC | 0 | 0 | 0 | |
SELECT `RelatedCategory`.`id`, `RelatedCategory`.`accent_colour_id`, `RelatedCategory`.`category_type`, `RelatedCategory`.`name`, `RelatedCategory`.`internal_title`, `RelatedCategory`.`parent_id`, `RelatedCategory`.`from_price`, `RelatedCategory`.`delivery_delay`, `RelatedCategory`.`homepage_title`, `RelatedCategory`.`homepage_text`, `RelatedCategory`.`description`, `RelatedCategory`.`secondary_description`, `RelatedCategory`.`products_anchor_text`, `RelatedCategory`.`banner_button_text`, `RelatedCategory`.`banner_button_link`, `RelatedCategory`.`why_use_us_heading`, `RelatedCategory`.`why_use_us_left_heading`, `RelatedCategory`.`why_use_us_left`, `RelatedCategory`.`why_use_us_left_button_text`, `RelatedCategory`.`why_use_us_left_button_link`, `RelatedCategory`.`why_use_us_right_heading`, `RelatedCategory`.`why_use_us_right`, `RelatedCategory`.`why_use_us_right_button_text`, `RelatedCategory`.`why_use_us_right_button_link`, `RelatedCategory`.`expanded_text`, `RelatedCategory`.`uses_gravel_calculator`, `RelatedCategory`.`external_site_link`, `RelatedCategory`.`external_site_url`, `RelatedCategory`.`featured_on_homepage`, `RelatedCategory`.`display_in_menu`, `RelatedCategory`.`hidden_category`, `RelatedCategory`.`product_attribute_id`, `RelatedCategory`.`lft`, `RelatedCategory`.`rght`, `RelatedCategory`.`created`, `RelatedCategory`.`modified`, `RelatedItem`.`id`, `RelatedItem`.`model`, `RelatedItem`.`model_id`, `RelatedItem`.`related_model`, `RelatedItem`.`related_model_id`, `RelatedItem`.`sequence`, `RelatedItem`.`created`, `RelatedItem`.`modified` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_category_categories` AS `RelatedCategory` JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_related_items_related_items` AS `RelatedItem` ON (`RelatedItem`.`model_id` = 26 AND `RelatedItem`.`related_model_id` = `RelatedCategory`.`id`) WHERE `model` = 'Product' AND `related_model` = 'Category' | 11 | 11 | 2 | maybe slow |
SELECT `RelatedBrand`.`id`, `RelatedBrand`.`name`, `RelatedBrand`.`description`, `RelatedBrand`.`created`, `RelatedBrand`.`modified`, `RelatedItem`.`id`, `RelatedItem`.`model`, `RelatedItem`.`model_id`, `RelatedItem`.`related_model`, `RelatedItem`.`related_model_id`, `RelatedItem`.`sequence`, `RelatedItem`.`created`, `RelatedItem`.`modified` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_brands` AS `RelatedBrand` JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_related_items_related_items` AS `RelatedItem` ON (`RelatedItem`.`model_id` = 26 AND `RelatedItem`.`related_model_id` = `RelatedBrand`.`id`) WHERE `model` = 'Product' AND `related_model` = 'Brand' | 0 | 0 | 1 | maybe slow |
SELECT `RelatedProduct`.`id`, `RelatedProduct`.`plant_id`, `RelatedProduct`.`force_shipping_company_id`, `RelatedProduct`.`name`, `RelatedProduct`.`internal_title`, `RelatedProduct`.`subtitle`, `RelatedProduct`.`SKU`, `RelatedProduct`.`lead_time`, `RelatedProduct`.`excludes_vat`, `RelatedProduct`.`vat_rate_id`, `RelatedProduct`.`use_size_price`, `RelatedProduct`.`calculator_size`, `RelatedProduct`.`aggregate_size_id`, `RelatedProduct`.`homepage_text`, `RelatedProduct`.`description`, `RelatedProduct`.`expanded_text`, `RelatedProduct`.`additional_title`, `RelatedProduct`.`additional_text`, `RelatedProduct`.`additional_button_title`, `RelatedProduct`.`additional_button_url`, `RelatedProduct`.`aside_title`, `RelatedProduct`.`aside_text`, `RelatedProduct`.`mix_design`, `RelatedProduct`.`technical_spec`, `RelatedProduct`.`addon_products_text`, `RelatedProduct`.`suitable_for`, `RelatedProduct`.`not_suitable_for`, `RelatedProduct`.`sash_colour_id`, `RelatedProduct`.`sash_message_id`, `RelatedProduct`.`no_gravel_calculator`, `RelatedProduct`.`display_only`, `RelatedProduct`.`admin_only`, `RelatedProduct`.`flag_order`, `RelatedProduct`.`nofollow`, `RelatedProduct`.`is_grouped_product`, `RelatedProduct`.`no_loose_load_message`, `RelatedProduct`.`google_feed_title`, `RelatedProduct`.`google_feed_description`, `RelatedProduct`.`exclude_from_feed`, `RelatedProduct`.`is_featured`, `RelatedProduct`.`on_homepage`, `RelatedProduct`.`hide_background_image`, `RelatedProduct`.`hide_background_image_on_mobile`, `RelatedProduct`.`show_options_as_dropdown`, `RelatedProduct`.`qualifies_for_gravelx_upsell`, `RelatedProduct`.`show_gravelx_aside`, `RelatedProduct`.`upsell_specific_sizes`, `RelatedProduct`.`is_active`, `RelatedProduct`.`is_removed`, `RelatedProduct`.`created`, `RelatedProduct`.`modified`, `RelatedItem`.`id`, `RelatedItem`.`model`, `RelatedItem`.`model_id`, `RelatedItem`.`related_model`, `RelatedItem`.`related_model_id`, `RelatedItem`.`sequence`, `RelatedItem`.`created`, `RelatedItem`.`modified` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_products` AS `RelatedProduct` JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_related_items_related_items` AS `RelatedItem` ON (`RelatedItem`.`model_id` = 26 AND `RelatedItem`.`related_model_id` = `RelatedProduct`.`id`) WHERE `RelatedProduct`.`is_active` = '1' AND `model` = 'Product' AND `related_model` = 'Product' AND `is_active` = '1' ORDER BY `sequence` ASC | 15 | 15 | 2 | maybe slow |
SELECT `MetaData`.`id`, `MetaData`.`model`, `MetaData`.`model_id`, `MetaData`.`title`, `MetaData`.`description`, `MetaData`.`keywords`, `MetaData`.`created`, `MetaData`.`modified` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`meta_data` AS `MetaData` WHERE ((`model` = 'Product') AND (`model_id` = 26)) | 1 | 1 | 0 | |
SELECT `Route`.`id`, `Route`.`alias`, `Route`.`actual` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`routes` AS `Route` WHERE `Route`.`actual` = 'app_products/view/26' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Postcode`.`id`, `Postcode`.`outcode` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`postcodes` AS `Postcode` WHERE `outcode` LIKE 'DE4' LIMIT 1 | 1 | 1 | 0 | |
SELECT `ShippingCompany`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_companies` AS `ShippingCompany` WHERE `is_active` = '1' AND `pricing_only` = '1' | 0 | 0 | 0 | |
SELECT `ShippingCost`.*, `ShippingCompany`.*, IF(cost IS NULL AND shipping_company_id <> 7, -1, 0) AS nullswitch, `ShippingCompany`.`id`, `Plant`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_costs` AS `ShippingCost` LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_companies` AS `ShippingCompany` ON (`ShippingCost`.`shipping_company_id` = `ShippingCompany`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`plants` AS `Plant` ON (`ShippingCost`.`plant_id` = `Plant`.`id`) WHERE `Plant`.`is_active` = '1' AND `ShippingCompany`.`is_active` = '1' AND `postcode_id` = 663 AND `plant_id` = 9 AND ((`cost` >= 0) OR (`cost` IS NULL)) AND NOT (`shipping_company_id` IS NULL) AND `shipping_company_id` != 6 ORDER BY `nullswitch` DESC, `cost` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `Postcode`.`id`, `Postcode`.`outcode` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`postcodes` AS `Postcode` WHERE `outcode` LIKE 'DE4' LIMIT 1 | 1 | 1 | 0 | |
SELECT `ShippingCompany`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_companies` AS `ShippingCompany` WHERE `is_active` = '1' AND `pricing_only` = '1' | 0 | 0 | 0 | |
SELECT `ShippingCost`.*, `ShippingCompany`.*, IF(cost IS NULL AND shipping_company_id <> 7, -1, 0) AS nullswitch, `ShippingCompany`.`id`, `Plant`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_costs` AS `ShippingCost` LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_companies` AS `ShippingCompany` ON (`ShippingCost`.`shipping_company_id` = `ShippingCompany`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`plants` AS `Plant` ON (`ShippingCost`.`plant_id` = `Plant`.`id`) WHERE `Plant`.`is_active` = '1' AND `ShippingCompany`.`is_active` = '1' AND `postcode_id` = 663 AND `plant_id` = 9 AND ((`cost` >= 0) OR (`cost` IS NULL)) AND NOT (`shipping_company_id` IS NULL) AND `shipping_company_id` != 6 ORDER BY `nullswitch` DESC, `cost` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `ProductVariant`.*, `VatRate`.*, `Product`.`excludes_vat`, IF(Product.excludes_vat=1,ProductVariant.price*((VatRate.rate/100)+1),ProductVariant.price) AS calculatedprice, IF(Product.excludes_vat<>1,ProductVariant.price/((VatRate.rate/100)+1),ProductVariant.price) AS exvat, `ProductVariant`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_variants` AS `ProductVariant` left JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_products` AS `Product` ON (`ProductVariant`.`product_id` = `Product`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options_product_variants` AS `ProductAttributeOptionsVariants` ON (`ProductVariant`.`id` = `ProductAttributeOptionsVariants`.`product_variant_id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOption` ON (`ProductAttributeOptionsVariants`.`product_attribute_option_id` = `ProductAttributeOption`.`id`) left JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_checkout_vat_rates` AS `VatRate` ON (`Product`.`vat_rate_id` = `VatRate`.`id`) WHERE `ProductVariant`.`product_id` = 26 AND `ProductVariant`.`is_removed` <> '1' | 18 | 18 | 1 | maybe slow |
SELECT `ProductAttributeOption`.`id`, `ProductAttributeOption`.`product_attribute_id`, `ProductAttributeOption`.`name`, `ProductAttributeOption`.`description`, `ProductAttributeOption`.`sequence`, `ProductAttributeOption`.`created`, `ProductAttributeOption`.`modified`, `EvShopProductAttributeOptionsProductVariant`.`id`, `EvShopProductAttributeOptionsProductVariant`.`product_attribute_option_id`, `EvShopProductAttributeOptionsProductVariant`.`product_variant_id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOption` JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options_product_variants` AS `EvShopProductAttributeOptionsProductVariant` ON (`EvShopProductAttributeOptionsProductVariant`.`product_variant_id` IN (177, 178, 180, 181, 183, 2036) AND `EvShopProductAttributeOptionsProductVariant`.`product_attribute_option_id` = `ProductAttributeOption`.`id`) WHERE `ProductAttributeOption`.`id` IN (129, 7, 120, 118, 55, 56, 8, 114, 123, 111, 9, 122, 110, 121, 11, 82, 57, 58, 53, 81, 80, 86, 117, 119, 124, 115, 42, 102, 101, 96, 95, 98, 97, 100, 99, 73, 14, 116, 104, 36, 37, 30, 31, 32, 18, 60, 107, 19, 106, 22, 92, 93, 94, 17, 16, 83, 23, 125, 126, 127, 128, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143) | 6 | 6 | 1 | maybe slow |
SELECT `ProductAttributeOptions`.`name`, `ProductAttributeOptions`.`description`, `Product`.`excludes_vat`, `VatRate`.`rate`, `ProductVariant`.`online_price`, IF(Product.excludes_vat=1,ProductVariant.price*((VatRate.rate/100)+1),ProductVariant.price) AS calculatedprice, IF(Product.excludes_vat<>1,ProductVariant.price/((VatRate.rate/100)+1),ProductVariant.price) AS exvat, IF(ProductAttributeOptions.description LIKE "%forceprice%", 2, -1) AS force_price, IF(ProductAttributeOptions.description LIKE "%default%", 1, 0) AS is_default, IF(ProductAttributeOptions.description LIKE "%nosurcharge%", 0, 1) AS has_surcharge, IF(ProductAttributeOptions.description LIKE "%separatesurcharge%", 0, 1) AS separate_surcharge, IF(ProductAttributeOptions.description LIKE "%fromprice%", 1, 0) AS from_price, IF(ProductAttributeOptions.description LIKE "%poa%", 1, 0) AS is_poa FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_variants` AS `ProductVariant` LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options_product_variants` AS `ProductAttributeOptionsVariants` ON (`ProductVariant`.`id` = `ProductAttributeOptionsVariants`.`product_variant_id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOptions` ON (`ProductAttributeOptionsVariants`.`product_attribute_option_id` = `ProductAttributeOptions`.`id`) left JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_products` AS `Product` ON (`ProductVariant`.`product_id` = `Product`.`id`) left JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_checkout_vat_rates` AS `VatRate` ON (`Product`.`vat_rate_id` = `VatRate`.`id`) WHERE `ProductVariant`.`product_id` = 26 AND `ProductVariant`.`is_removed` = '0' AND `ProductVariant`.`price` IS NOT NULL AND `ProductVariant`.`price` > 0 AND ((`ProductAttributeOptions`.`description` LIKE '%\"main\"%') OR (`ProductAttributeOptions`.`description` LIKE '%\"default\"%')) ORDER BY `force_price` DESC, `is_default` ASC, `calculatedprice` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `Product`.`id`, `Product`.`plant_id`, `Product`.`force_shipping_company_id`, `Product`.`name`, `Product`.`internal_title`, `Product`.`subtitle`, `Product`.`SKU`, `Product`.`lead_time`, `Product`.`excludes_vat`, `Product`.`vat_rate_id`, `Product`.`use_size_price`, `Product`.`calculator_size`, `Product`.`aggregate_size_id`, `Product`.`homepage_text`, `Product`.`description`, `Product`.`expanded_text`, `Product`.`additional_title`, `Product`.`additional_text`, `Product`.`additional_button_title`, `Product`.`additional_button_url`, `Product`.`aside_title`, `Product`.`aside_text`, `Product`.`mix_design`, `Product`.`technical_spec`, `Product`.`addon_products_text`, `Product`.`suitable_for`, `Product`.`not_suitable_for`, `Product`.`sash_colour_id`, `Product`.`sash_message_id`, `Product`.`no_gravel_calculator`, `Product`.`display_only`, `Product`.`admin_only`, `Product`.`flag_order`, `Product`.`nofollow`, `Product`.`is_grouped_product`, `Product`.`no_loose_load_message`, `Product`.`google_feed_title`, `Product`.`google_feed_description`, `Product`.`exclude_from_feed`, `Product`.`is_featured`, `Product`.`on_homepage`, `Product`.`hide_background_image`, `Product`.`hide_background_image_on_mobile`, `Product`.`show_options_as_dropdown`, `Product`.`qualifies_for_gravelx_upsell`, `Product`.`show_gravelx_aside`, `Product`.`upsell_specific_sizes`, `Product`.`is_active`, `Product`.`is_removed`, `Product`.`created`, `Product`.`modified`, `VatRate`.`id`, `VatRate`.`rate`, `VatRate`.`name`, `VatRate`.`is_active`, `VatRate`.`created`, `VatRate`.`modified`, `SashColour`.`id`, `SashColour`.`name`, `SashColour`.`hex`, `SashColour`.`text_hex`, `SashColour`.`created`, `SashColour`.`modified`, `SashColour`.`is_active`, `SashMessage`.`id`, `SashMessage`.`name`, `SashMessage`.`created`, `SashMessage`.`modified`, `SashMessage`.`is_active`, `AggregateSize`.`id`, `AggregateSize`.`name`, `AggregateSize`.`sequence`, `AggregateSize`.`created`, `AggregateSize`.`modified` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_products` AS `Product` LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_checkout_vat_rates` AS `VatRate` ON (`Product`.`vat_rate_id` = `VatRate`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`sash_colours` AS `SashColour` ON (`Product`.`sash_colour_id` = `SashColour`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`sash_messages` AS `SashMessage` ON (`Product`.`sash_message_id` = `SashMessage`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`aggregate_sizes` AS `AggregateSize` ON (`Product`.`aggregate_size_id` = `AggregateSize`.`id`) WHERE `Product`.`is_active` = '1' AND `Product`.`id` = 30 AND `is_removed` = '0' ORDER BY `Product`.`modified` DESC LIMIT 1 | 1 | 1 | 1 | |
SELECT `ProductVariant`.`id`, `ProductVariant`.`product_id`, `ProductVariant`.`name`, `ProductVariant`.`opera_stock_ref`, `ProductVariant`.`price`, `ProductVariant`.`online_price`, `ProductVariant`.`pick_and_mix_price`, `ProductVariant`.`rrp`, `ProductVariant`.`stock`, `ProductVariant`.`unlimited_stock`, `ProductVariant`.`google_feed_title`, `ProductVariant`.`google_feed_description`, `ProductVariant`.`custom_quantities`, `ProductVariant`.`allow_upsell`, `ProductVariant`.`is_removed`, `ProductVariant`.`created`, `ProductVariant`.`modified`, `ProductVariant`.`last_exported` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_variants` AS `ProductVariant` WHERE `ProductVariant`.`is_removed` <> '1' AND `ProductVariant`.`product_id` = (30) | 6 | 6 | 0 | |
SELECT `BackgroundImage`.`id`, `BackgroundImage`.`model`, `BackgroundImage`.`model_id`, `BackgroundImage`.`filename`, `BackgroundImage`.`attachment_type`, `BackgroundImage`.`alt`, `BackgroundImage`.`title`, `BackgroundImage`.`caption`, `BackgroundImage`.`link_text`, `BackgroundImage`.`link_url`, `BackgroundImage`.`products`, `BackgroundImage`.`body`, `BackgroundImage`.`type`, `BackgroundImage`.`size`, `BackgroundImage`.`dir`, `BackgroundImage`.`sequence`, `BackgroundImage`.`is_active`, `BackgroundImage`.`created`, `BackgroundImage`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `BackgroundImage__filepath` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`images` AS `BackgroundImage` WHERE `model` = 'Product' AND `attachment_type` = 'BackgroundImage' AND `BackgroundImage`.`model_id` = (30) ORDER BY `sequence` ASC | 1 | 1 | 0 | |
SELECT `ListingImage`.`id`, `ListingImage`.`model`, `ListingImage`.`model_id`, `ListingImage`.`filename`, `ListingImage`.`attachment_type`, `ListingImage`.`alt`, `ListingImage`.`title`, `ListingImage`.`caption`, `ListingImage`.`link_text`, `ListingImage`.`link_url`, `ListingImage`.`products`, `ListingImage`.`body`, `ListingImage`.`type`, `ListingImage`.`size`, `ListingImage`.`dir`, `ListingImage`.`sequence`, `ListingImage`.`is_active`, `ListingImage`.`created`, `ListingImage`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `ListingImage__filepath` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`images` AS `ListingImage` WHERE `model` = 'Product' AND `attachment_type` = 'ListingImage' AND `ListingImage`.`model_id` = (30) ORDER BY `sequence` ASC | 1 | 1 | 0 | |
SELECT `SampleImage`.`id`, `SampleImage`.`model`, `SampleImage`.`model_id`, `SampleImage`.`filename`, `SampleImage`.`attachment_type`, `SampleImage`.`alt`, `SampleImage`.`title`, `SampleImage`.`caption`, `SampleImage`.`link_text`, `SampleImage`.`link_url`, `SampleImage`.`products`, `SampleImage`.`body`, `SampleImage`.`type`, `SampleImage`.`size`, `SampleImage`.`dir`, `SampleImage`.`sequence`, `SampleImage`.`is_active`, `SampleImage`.`created`, `SampleImage`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `SampleImage__filepath` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`images` AS `SampleImage` WHERE `model` = 'Product' AND `attachment_type` = 'SampleImage' AND `SampleImage`.`model_id` = (30) ORDER BY `sequence` ASC | 1 | 1 | 0 | |
SELECT `AsideImage`.`id`, `AsideImage`.`model`, `AsideImage`.`model_id`, `AsideImage`.`filename`, `AsideImage`.`attachment_type`, `AsideImage`.`alt`, `AsideImage`.`title`, `AsideImage`.`caption`, `AsideImage`.`link_text`, `AsideImage`.`link_url`, `AsideImage`.`products`, `AsideImage`.`body`, `AsideImage`.`type`, `AsideImage`.`size`, `AsideImage`.`dir`, `AsideImage`.`sequence`, `AsideImage`.`is_active`, `AsideImage`.`created`, `AsideImage`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `AsideImage__filepath` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`images` AS `AsideImage` WHERE `model` = 'Product' AND `attachment_type` = 'AsideImage' AND `AsideImage`.`model_id` = (30) ORDER BY `sequence` ASC | 0 | 0 | 0 | |
SELECT `Image`.`id`, `Image`.`model`, `Image`.`model_id`, `Image`.`filename`, `Image`.`attachment_type`, `Image`.`alt`, `Image`.`title`, `Image`.`caption`, `Image`.`link_text`, `Image`.`link_url`, `Image`.`products`, `Image`.`body`, `Image`.`type`, `Image`.`size`, `Image`.`dir`, `Image`.`sequence`, `Image`.`is_active`, `Image`.`created`, `Image`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `Image__filepath` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`images` AS `Image` WHERE `model` = 'Product' AND `attachment_type` = 'Image' AND `Image`.`model_id` = (30) ORDER BY `sequence` ASC | 11 | 11 | 0 | |
SELECT `ProductAttributeOption`.`id`, `ProductAttributeOption`.`product_attribute_id`, `ProductAttributeOption`.`name`, `ProductAttributeOption`.`description`, `ProductAttributeOption`.`sequence`, `ProductAttributeOption`.`created`, `ProductAttributeOption`.`modified`, `EvShopProductAttributeOptionsProduct`.`id`, `EvShopProductAttributeOptionsProduct`.`product_attribute_option_id`, `EvShopProductAttributeOptionsProduct`.`product_id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOption` JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options_products` AS `EvShopProductAttributeOptionsProduct` ON (`EvShopProductAttributeOptionsProduct`.`product_id` = 30 AND `EvShopProductAttributeOptionsProduct`.`product_attribute_option_id` = `ProductAttributeOption`.`id`) | 8 | 8 | 0 | |
SELECT `SecondaryPlant`.`id`, `SecondaryPlant`.`name`, `SecondaryPlant`.`front_facing_name`, `SecondaryPlant`.`order_recipient`, `SecondaryPlant`.`email`, `SecondaryPlant`.`phone`, `SecondaryPlant`.`printer_name`, `SecondaryPlant`.`use_email`, `SecondaryPlant`.`use_printer`, `SecondaryPlant`.`allow_customer_collection`, `SecondaryPlant`.`no_queue_emails`, `SecondaryPlant`.`has_earlier_next_day_queue`, `SecondaryPlant`.`is_direct`, `SecondaryPlant`.`sequence`, `SecondaryPlant`.`address_name`, `SecondaryPlant`.`address_line_1`, `SecondaryPlant`.`address_line_2`, `SecondaryPlant`.`address_line_3`, `SecondaryPlant`.`address_town`, `SecondaryPlant`.`address_county`, `SecondaryPlant`.`address_postcode`, `SecondaryPlant`.`pricing_postcode`, `SecondaryPlant`.`pallex_username`, `SecondaryPlant`.`pallex_password`, `SecondaryPlant`.`created`, `SecondaryPlant`.`modified`, `SecondaryPlant`.`is_active`, `EvShopProductsPlant`.`id`, `EvShopProductsPlant`.`ev_shop_product_id`, `EvShopProductsPlant`.`plant_id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`plants` AS `SecondaryPlant` JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_products_plants` AS `EvShopProductsPlant` ON (`EvShopProductsPlant`.`ev_shop_product_id` = 30 AND `EvShopProductsPlant`.`plant_id` = `SecondaryPlant`.`id`) | 1 | 1 | 0 | |
SELECT `ProductFaq`.`id`, `ProductFaq`.`question`, `ProductFaq`.`answer`, `ProductFaq`.`is_active`, `ProductFaq`.`sequence`, `ProductFaq`.`created`, `ProductFaq`.`modified`, `ProductFaqsEvShopProduct`.`id`, `ProductFaqsEvShopProduct`.`faq_id`, `ProductFaqsEvShopProduct`.`ev_shop_product_id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`product_faqs` AS `ProductFaq` JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`product_faqs_ev_shop_products` AS `ProductFaqsEvShopProduct` ON (`ProductFaqsEvShopProduct`.`ev_shop_product_id` = 30 AND `ProductFaqsEvShopProduct`.`faq_id` = `ProductFaq`.`id`) ORDER BY `ProductFaq`.`sequence` ASC | 0 | 0 | 0 | |
SELECT `RelatedCategory`.`id`, `RelatedCategory`.`accent_colour_id`, `RelatedCategory`.`category_type`, `RelatedCategory`.`name`, `RelatedCategory`.`internal_title`, `RelatedCategory`.`parent_id`, `RelatedCategory`.`from_price`, `RelatedCategory`.`delivery_delay`, `RelatedCategory`.`homepage_title`, `RelatedCategory`.`homepage_text`, `RelatedCategory`.`description`, `RelatedCategory`.`secondary_description`, `RelatedCategory`.`products_anchor_text`, `RelatedCategory`.`banner_button_text`, `RelatedCategory`.`banner_button_link`, `RelatedCategory`.`why_use_us_heading`, `RelatedCategory`.`why_use_us_left_heading`, `RelatedCategory`.`why_use_us_left`, `RelatedCategory`.`why_use_us_left_button_text`, `RelatedCategory`.`why_use_us_left_button_link`, `RelatedCategory`.`why_use_us_right_heading`, `RelatedCategory`.`why_use_us_right`, `RelatedCategory`.`why_use_us_right_button_text`, `RelatedCategory`.`why_use_us_right_button_link`, `RelatedCategory`.`expanded_text`, `RelatedCategory`.`uses_gravel_calculator`, `RelatedCategory`.`external_site_link`, `RelatedCategory`.`external_site_url`, `RelatedCategory`.`featured_on_homepage`, `RelatedCategory`.`display_in_menu`, `RelatedCategory`.`hidden_category`, `RelatedCategory`.`product_attribute_id`, `RelatedCategory`.`lft`, `RelatedCategory`.`rght`, `RelatedCategory`.`created`, `RelatedCategory`.`modified`, `RelatedItem`.`id`, `RelatedItem`.`model`, `RelatedItem`.`model_id`, `RelatedItem`.`related_model`, `RelatedItem`.`related_model_id`, `RelatedItem`.`sequence`, `RelatedItem`.`created`, `RelatedItem`.`modified` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_category_categories` AS `RelatedCategory` JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_related_items_related_items` AS `RelatedItem` ON (`RelatedItem`.`model_id` = 30 AND `RelatedItem`.`related_model_id` = `RelatedCategory`.`id`) WHERE `model` = 'Product' AND `related_model` = 'Category' | 9 | 9 | 2 | maybe slow |
SELECT `RelatedBrand`.`id`, `RelatedBrand`.`name`, `RelatedBrand`.`description`, `RelatedBrand`.`created`, `RelatedBrand`.`modified`, `RelatedItem`.`id`, `RelatedItem`.`model`, `RelatedItem`.`model_id`, `RelatedItem`.`related_model`, `RelatedItem`.`related_model_id`, `RelatedItem`.`sequence`, `RelatedItem`.`created`, `RelatedItem`.`modified` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_brands` AS `RelatedBrand` JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_related_items_related_items` AS `RelatedItem` ON (`RelatedItem`.`model_id` = 30 AND `RelatedItem`.`related_model_id` = `RelatedBrand`.`id`) WHERE `model` = 'Product' AND `related_model` = 'Brand' | 0 | 0 | 1 | maybe slow |
SELECT `RelatedProduct`.`id`, `RelatedProduct`.`plant_id`, `RelatedProduct`.`force_shipping_company_id`, `RelatedProduct`.`name`, `RelatedProduct`.`internal_title`, `RelatedProduct`.`subtitle`, `RelatedProduct`.`SKU`, `RelatedProduct`.`lead_time`, `RelatedProduct`.`excludes_vat`, `RelatedProduct`.`vat_rate_id`, `RelatedProduct`.`use_size_price`, `RelatedProduct`.`calculator_size`, `RelatedProduct`.`aggregate_size_id`, `RelatedProduct`.`homepage_text`, `RelatedProduct`.`description`, `RelatedProduct`.`expanded_text`, `RelatedProduct`.`additional_title`, `RelatedProduct`.`additional_text`, `RelatedProduct`.`additional_button_title`, `RelatedProduct`.`additional_button_url`, `RelatedProduct`.`aside_title`, `RelatedProduct`.`aside_text`, `RelatedProduct`.`mix_design`, `RelatedProduct`.`technical_spec`, `RelatedProduct`.`addon_products_text`, `RelatedProduct`.`suitable_for`, `RelatedProduct`.`not_suitable_for`, `RelatedProduct`.`sash_colour_id`, `RelatedProduct`.`sash_message_id`, `RelatedProduct`.`no_gravel_calculator`, `RelatedProduct`.`display_only`, `RelatedProduct`.`admin_only`, `RelatedProduct`.`flag_order`, `RelatedProduct`.`nofollow`, `RelatedProduct`.`is_grouped_product`, `RelatedProduct`.`no_loose_load_message`, `RelatedProduct`.`google_feed_title`, `RelatedProduct`.`google_feed_description`, `RelatedProduct`.`exclude_from_feed`, `RelatedProduct`.`is_featured`, `RelatedProduct`.`on_homepage`, `RelatedProduct`.`hide_background_image`, `RelatedProduct`.`hide_background_image_on_mobile`, `RelatedProduct`.`show_options_as_dropdown`, `RelatedProduct`.`qualifies_for_gravelx_upsell`, `RelatedProduct`.`show_gravelx_aside`, `RelatedProduct`.`upsell_specific_sizes`, `RelatedProduct`.`is_active`, `RelatedProduct`.`is_removed`, `RelatedProduct`.`created`, `RelatedProduct`.`modified`, `RelatedItem`.`id`, `RelatedItem`.`model`, `RelatedItem`.`model_id`, `RelatedItem`.`related_model`, `RelatedItem`.`related_model_id`, `RelatedItem`.`sequence`, `RelatedItem`.`created`, `RelatedItem`.`modified` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_products` AS `RelatedProduct` JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_related_items_related_items` AS `RelatedItem` ON (`RelatedItem`.`model_id` = 30 AND `RelatedItem`.`related_model_id` = `RelatedProduct`.`id`) WHERE `RelatedProduct`.`is_active` = '1' AND `model` = 'Product' AND `related_model` = 'Product' AND `is_active` = '1' ORDER BY `sequence` ASC | 0 | 0 | 1 | maybe slow |
SELECT `MetaData`.`id`, `MetaData`.`model`, `MetaData`.`model_id`, `MetaData`.`title`, `MetaData`.`description`, `MetaData`.`keywords`, `MetaData`.`created`, `MetaData`.`modified` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`meta_data` AS `MetaData` WHERE ((`model` = 'Product') AND (`model_id` = 30)) | 1 | 1 | 0 | |
SELECT `Route`.`id`, `Route`.`alias`, `Route`.`actual` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`routes` AS `Route` WHERE `Route`.`actual` = 'app_products/view/30' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Postcode`.`id`, `Postcode`.`outcode` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`postcodes` AS `Postcode` WHERE `outcode` LIKE 'DE4' LIMIT 1 | 1 | 1 | 0 | |
SELECT `ShippingCompany`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_companies` AS `ShippingCompany` WHERE `is_active` = '1' AND `pricing_only` = '1' | 0 | 0 | 0 | |
SELECT `ShippingCost`.*, `ShippingCompany`.*, IF(cost IS NULL AND shipping_company_id <> 7, -1, 0) AS nullswitch, `ShippingCompany`.`id`, `Plant`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_costs` AS `ShippingCost` LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_companies` AS `ShippingCompany` ON (`ShippingCost`.`shipping_company_id` = `ShippingCompany`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`plants` AS `Plant` ON (`ShippingCost`.`plant_id` = `Plant`.`id`) WHERE `Plant`.`is_active` = '1' AND `ShippingCompany`.`is_active` = '1' AND `postcode_id` = 663 AND `plant_id` = 1 AND ((`cost` >= 0) OR (`cost` IS NULL)) AND NOT (`shipping_company_id` IS NULL) AND `shipping_company_id` != 6 ORDER BY `nullswitch` DESC, `cost` ASC LIMIT 1 | 1 | 1 | 5 | maybe slow |
SELECT `Postcode`.`id`, `Postcode`.`outcode` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`postcodes` AS `Postcode` WHERE `outcode` LIKE 'DE4' LIMIT 1 | 1 | 1 | 0 | |
SELECT `ShippingCompany`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_companies` AS `ShippingCompany` WHERE `is_active` = '1' AND `pricing_only` = '1' | 0 | 0 | 0 | |
SELECT `ShippingCost`.*, `ShippingCompany`.*, IF(cost IS NULL AND shipping_company_id <> 7, -1, 0) AS nullswitch, `ShippingCompany`.`id`, `Plant`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_costs` AS `ShippingCost` LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_companies` AS `ShippingCompany` ON (`ShippingCost`.`shipping_company_id` = `ShippingCompany`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`plants` AS `Plant` ON (`ShippingCost`.`plant_id` = `Plant`.`id`) WHERE `Plant`.`is_active` = '1' AND `ShippingCompany`.`is_active` = '1' AND `postcode_id` = 663 AND `plant_id` = 1 AND ((`cost` >= 0) OR (`cost` IS NULL)) AND NOT (`shipping_company_id` IS NULL) AND `shipping_company_id` != 6 ORDER BY `nullswitch` DESC, `cost` ASC LIMIT 1 | 1 | 1 | 5 | maybe slow |
SELECT `ProductVariant`.*, `VatRate`.*, `Product`.`excludes_vat`, IF(Product.excludes_vat=1,ProductVariant.price*((VatRate.rate/100)+1),ProductVariant.price) AS calculatedprice, IF(Product.excludes_vat<>1,ProductVariant.price/((VatRate.rate/100)+1),ProductVariant.price) AS exvat, `ProductVariant`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_variants` AS `ProductVariant` left JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_products` AS `Product` ON (`ProductVariant`.`product_id` = `Product`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options_product_variants` AS `ProductAttributeOptionsVariants` ON (`ProductVariant`.`id` = `ProductAttributeOptionsVariants`.`product_variant_id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOption` ON (`ProductAttributeOptionsVariants`.`product_attribute_option_id` = `ProductAttributeOption`.`id`) left JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_checkout_vat_rates` AS `VatRate` ON (`Product`.`vat_rate_id` = `VatRate`.`id`) WHERE `ProductVariant`.`product_id` = 30 AND `ProductVariant`.`is_removed` <> '1' | 18 | 18 | 1 | maybe slow |
SELECT `ProductAttributeOption`.`id`, `ProductAttributeOption`.`product_attribute_id`, `ProductAttributeOption`.`name`, `ProductAttributeOption`.`description`, `ProductAttributeOption`.`sequence`, `ProductAttributeOption`.`created`, `ProductAttributeOption`.`modified`, `EvShopProductAttributeOptionsProductVariant`.`id`, `EvShopProductAttributeOptionsProductVariant`.`product_attribute_option_id`, `EvShopProductAttributeOptionsProductVariant`.`product_variant_id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOption` JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options_product_variants` AS `EvShopProductAttributeOptionsProductVariant` ON (`EvShopProductAttributeOptionsProductVariant`.`product_variant_id` IN (213, 214, 216, 217, 219, 2014) AND `EvShopProductAttributeOptionsProductVariant`.`product_attribute_option_id` = `ProductAttributeOption`.`id`) WHERE `ProductAttributeOption`.`id` IN (129, 7, 120, 118, 55, 56, 8, 114, 123, 111, 9, 122, 110, 121, 11, 82, 57, 58, 53, 81, 80, 86, 117, 119, 124, 115, 42, 102, 101, 96, 95, 98, 97, 100, 99, 73, 14, 116, 104, 36, 37, 30, 31, 32, 18, 60, 107, 19, 106, 22, 92, 93, 94, 17, 16, 83, 23, 125, 126, 127, 128, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143) | 6 | 6 | 1 | maybe slow |
SELECT `ProductAttributeOptions`.`name`, `ProductAttributeOptions`.`description`, `Product`.`excludes_vat`, `VatRate`.`rate`, `ProductVariant`.`online_price`, IF(Product.excludes_vat=1,ProductVariant.price*((VatRate.rate/100)+1),ProductVariant.price) AS calculatedprice, IF(Product.excludes_vat<>1,ProductVariant.price/((VatRate.rate/100)+1),ProductVariant.price) AS exvat, IF(ProductAttributeOptions.description LIKE "%forceprice%", 2, -1) AS force_price, IF(ProductAttributeOptions.description LIKE "%default%", 1, 0) AS is_default, IF(ProductAttributeOptions.description LIKE "%nosurcharge%", 0, 1) AS has_surcharge, IF(ProductAttributeOptions.description LIKE "%separatesurcharge%", 0, 1) AS separate_surcharge, IF(ProductAttributeOptions.description LIKE "%fromprice%", 1, 0) AS from_price, IF(ProductAttributeOptions.description LIKE "%poa%", 1, 0) AS is_poa FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_variants` AS `ProductVariant` LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options_product_variants` AS `ProductAttributeOptionsVariants` ON (`ProductVariant`.`id` = `ProductAttributeOptionsVariants`.`product_variant_id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOptions` ON (`ProductAttributeOptionsVariants`.`product_attribute_option_id` = `ProductAttributeOptions`.`id`) left JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_products` AS `Product` ON (`ProductVariant`.`product_id` = `Product`.`id`) left JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_checkout_vat_rates` AS `VatRate` ON (`Product`.`vat_rate_id` = `VatRate`.`id`) WHERE `ProductVariant`.`product_id` = 30 AND `ProductVariant`.`is_removed` = '0' AND `ProductVariant`.`price` IS NOT NULL AND `ProductVariant`.`price` > 0 AND ((`ProductAttributeOptions`.`description` LIKE '%\"main\"%') OR (`ProductAttributeOptions`.`description` LIKE '%\"default\"%')) ORDER BY `force_price` DESC, `is_default` ASC, `calculatedprice` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `Product`.`id`, `Product`.`plant_id`, `Product`.`force_shipping_company_id`, `Product`.`name`, `Product`.`internal_title`, `Product`.`subtitle`, `Product`.`SKU`, `Product`.`lead_time`, `Product`.`excludes_vat`, `Product`.`vat_rate_id`, `Product`.`use_size_price`, `Product`.`calculator_size`, `Product`.`aggregate_size_id`, `Product`.`homepage_text`, `Product`.`description`, `Product`.`expanded_text`, `Product`.`additional_title`, `Product`.`additional_text`, `Product`.`additional_button_title`, `Product`.`additional_button_url`, `Product`.`aside_title`, `Product`.`aside_text`, `Product`.`mix_design`, `Product`.`technical_spec`, `Product`.`addon_products_text`, `Product`.`suitable_for`, `Product`.`not_suitable_for`, `Product`.`sash_colour_id`, `Product`.`sash_message_id`, `Product`.`no_gravel_calculator`, `Product`.`display_only`, `Product`.`admin_only`, `Product`.`flag_order`, `Product`.`nofollow`, `Product`.`is_grouped_product`, `Product`.`no_loose_load_message`, `Product`.`google_feed_title`, `Product`.`google_feed_description`, `Product`.`exclude_from_feed`, `Product`.`is_featured`, `Product`.`on_homepage`, `Product`.`hide_background_image`, `Product`.`hide_background_image_on_mobile`, `Product`.`show_options_as_dropdown`, `Product`.`qualifies_for_gravelx_upsell`, `Product`.`show_gravelx_aside`, `Product`.`upsell_specific_sizes`, `Product`.`is_active`, `Product`.`is_removed`, `Product`.`created`, `Product`.`modified`, `VatRate`.`id`, `VatRate`.`rate`, `VatRate`.`name`, `VatRate`.`is_active`, `VatRate`.`created`, `VatRate`.`modified`, `SashColour`.`id`, `SashColour`.`name`, `SashColour`.`hex`, `SashColour`.`text_hex`, `SashColour`.`created`, `SashColour`.`modified`, `SashColour`.`is_active`, `SashMessage`.`id`, `SashMessage`.`name`, `SashMessage`.`created`, `SashMessage`.`modified`, `SashMessage`.`is_active`, `AggregateSize`.`id`, `AggregateSize`.`name`, `AggregateSize`.`sequence`, `AggregateSize`.`created`, `AggregateSize`.`modified` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_products` AS `Product` LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_checkout_vat_rates` AS `VatRate` ON (`Product`.`vat_rate_id` = `VatRate`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`sash_colours` AS `SashColour` ON (`Product`.`sash_colour_id` = `SashColour`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`sash_messages` AS `SashMessage` ON (`Product`.`sash_message_id` = `SashMessage`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`aggregate_sizes` AS `AggregateSize` ON (`Product`.`aggregate_size_id` = `AggregateSize`.`id`) WHERE `Product`.`is_active` = '1' AND `Product`.`id` = 24 AND `is_removed` = '0' ORDER BY `Product`.`modified` DESC LIMIT 1 | 1 | 1 | 1 | |
SELECT `ProductVariant`.`id`, `ProductVariant`.`product_id`, `ProductVariant`.`name`, `ProductVariant`.`opera_stock_ref`, `ProductVariant`.`price`, `ProductVariant`.`online_price`, `ProductVariant`.`pick_and_mix_price`, `ProductVariant`.`rrp`, `ProductVariant`.`stock`, `ProductVariant`.`unlimited_stock`, `ProductVariant`.`google_feed_title`, `ProductVariant`.`google_feed_description`, `ProductVariant`.`custom_quantities`, `ProductVariant`.`allow_upsell`, `ProductVariant`.`is_removed`, `ProductVariant`.`created`, `ProductVariant`.`modified`, `ProductVariant`.`last_exported` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_variants` AS `ProductVariant` WHERE `ProductVariant`.`is_removed` <> '1' AND `ProductVariant`.`product_id` = (24) | 6 | 6 | 0 | |
SELECT `BackgroundImage`.`id`, `BackgroundImage`.`model`, `BackgroundImage`.`model_id`, `BackgroundImage`.`filename`, `BackgroundImage`.`attachment_type`, `BackgroundImage`.`alt`, `BackgroundImage`.`title`, `BackgroundImage`.`caption`, `BackgroundImage`.`link_text`, `BackgroundImage`.`link_url`, `BackgroundImage`.`products`, `BackgroundImage`.`body`, `BackgroundImage`.`type`, `BackgroundImage`.`size`, `BackgroundImage`.`dir`, `BackgroundImage`.`sequence`, `BackgroundImage`.`is_active`, `BackgroundImage`.`created`, `BackgroundImage`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `BackgroundImage__filepath` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`images` AS `BackgroundImage` WHERE `model` = 'Product' AND `attachment_type` = 'BackgroundImage' AND `BackgroundImage`.`model_id` = (24) ORDER BY `sequence` ASC | 1 | 1 | 0 | |
SELECT `ListingImage`.`id`, `ListingImage`.`model`, `ListingImage`.`model_id`, `ListingImage`.`filename`, `ListingImage`.`attachment_type`, `ListingImage`.`alt`, `ListingImage`.`title`, `ListingImage`.`caption`, `ListingImage`.`link_text`, `ListingImage`.`link_url`, `ListingImage`.`products`, `ListingImage`.`body`, `ListingImage`.`type`, `ListingImage`.`size`, `ListingImage`.`dir`, `ListingImage`.`sequence`, `ListingImage`.`is_active`, `ListingImage`.`created`, `ListingImage`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `ListingImage__filepath` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`images` AS `ListingImage` WHERE `model` = 'Product' AND `attachment_type` = 'ListingImage' AND `ListingImage`.`model_id` = (24) ORDER BY `sequence` ASC | 1 | 1 | 0 | |
SELECT `SampleImage`.`id`, `SampleImage`.`model`, `SampleImage`.`model_id`, `SampleImage`.`filename`, `SampleImage`.`attachment_type`, `SampleImage`.`alt`, `SampleImage`.`title`, `SampleImage`.`caption`, `SampleImage`.`link_text`, `SampleImage`.`link_url`, `SampleImage`.`products`, `SampleImage`.`body`, `SampleImage`.`type`, `SampleImage`.`size`, `SampleImage`.`dir`, `SampleImage`.`sequence`, `SampleImage`.`is_active`, `SampleImage`.`created`, `SampleImage`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `SampleImage__filepath` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`images` AS `SampleImage` WHERE `model` = 'Product' AND `attachment_type` = 'SampleImage' AND `SampleImage`.`model_id` = (24) ORDER BY `sequence` ASC | 1 | 1 | 0 | |
SELECT `AsideImage`.`id`, `AsideImage`.`model`, `AsideImage`.`model_id`, `AsideImage`.`filename`, `AsideImage`.`attachment_type`, `AsideImage`.`alt`, `AsideImage`.`title`, `AsideImage`.`caption`, `AsideImage`.`link_text`, `AsideImage`.`link_url`, `AsideImage`.`products`, `AsideImage`.`body`, `AsideImage`.`type`, `AsideImage`.`size`, `AsideImage`.`dir`, `AsideImage`.`sequence`, `AsideImage`.`is_active`, `AsideImage`.`created`, `AsideImage`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `AsideImage__filepath` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`images` AS `AsideImage` WHERE `model` = 'Product' AND `attachment_type` = 'AsideImage' AND `AsideImage`.`model_id` = (24) ORDER BY `sequence` ASC | 0 | 0 | 0 | |
SELECT `Image`.`id`, `Image`.`model`, `Image`.`model_id`, `Image`.`filename`, `Image`.`attachment_type`, `Image`.`alt`, `Image`.`title`, `Image`.`caption`, `Image`.`link_text`, `Image`.`link_url`, `Image`.`products`, `Image`.`body`, `Image`.`type`, `Image`.`size`, `Image`.`dir`, `Image`.`sequence`, `Image`.`is_active`, `Image`.`created`, `Image`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `Image__filepath` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`images` AS `Image` WHERE `model` = 'Product' AND `attachment_type` = 'Image' AND `Image`.`model_id` = (24) ORDER BY `sequence` ASC | 10 | 10 | 0 | |
SELECT `ProductAttributeOption`.`id`, `ProductAttributeOption`.`product_attribute_id`, `ProductAttributeOption`.`name`, `ProductAttributeOption`.`description`, `ProductAttributeOption`.`sequence`, `ProductAttributeOption`.`created`, `ProductAttributeOption`.`modified`, `EvShopProductAttributeOptionsProduct`.`id`, `EvShopProductAttributeOptionsProduct`.`product_attribute_option_id`, `EvShopProductAttributeOptionsProduct`.`product_id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOption` JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options_products` AS `EvShopProductAttributeOptionsProduct` ON (`EvShopProductAttributeOptionsProduct`.`product_id` = 24 AND `EvShopProductAttributeOptionsProduct`.`product_attribute_option_id` = `ProductAttributeOption`.`id`) | 8 | 8 | 0 | |
SELECT `SecondaryPlant`.`id`, `SecondaryPlant`.`name`, `SecondaryPlant`.`front_facing_name`, `SecondaryPlant`.`order_recipient`, `SecondaryPlant`.`email`, `SecondaryPlant`.`phone`, `SecondaryPlant`.`printer_name`, `SecondaryPlant`.`use_email`, `SecondaryPlant`.`use_printer`, `SecondaryPlant`.`allow_customer_collection`, `SecondaryPlant`.`no_queue_emails`, `SecondaryPlant`.`has_earlier_next_day_queue`, `SecondaryPlant`.`is_direct`, `SecondaryPlant`.`sequence`, `SecondaryPlant`.`address_name`, `SecondaryPlant`.`address_line_1`, `SecondaryPlant`.`address_line_2`, `SecondaryPlant`.`address_line_3`, `SecondaryPlant`.`address_town`, `SecondaryPlant`.`address_county`, `SecondaryPlant`.`address_postcode`, `SecondaryPlant`.`pricing_postcode`, `SecondaryPlant`.`pallex_username`, `SecondaryPlant`.`pallex_password`, `SecondaryPlant`.`created`, `SecondaryPlant`.`modified`, `SecondaryPlant`.`is_active`, `EvShopProductsPlant`.`id`, `EvShopProductsPlant`.`ev_shop_product_id`, `EvShopProductsPlant`.`plant_id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`plants` AS `SecondaryPlant` JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_products_plants` AS `EvShopProductsPlant` ON (`EvShopProductsPlant`.`ev_shop_product_id` = 24 AND `EvShopProductsPlant`.`plant_id` = `SecondaryPlant`.`id`) | 1 | 1 | 0 | |
SELECT `ProductFaq`.`id`, `ProductFaq`.`question`, `ProductFaq`.`answer`, `ProductFaq`.`is_active`, `ProductFaq`.`sequence`, `ProductFaq`.`created`, `ProductFaq`.`modified`, `ProductFaqsEvShopProduct`.`id`, `ProductFaqsEvShopProduct`.`faq_id`, `ProductFaqsEvShopProduct`.`ev_shop_product_id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`product_faqs` AS `ProductFaq` JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`product_faqs_ev_shop_products` AS `ProductFaqsEvShopProduct` ON (`ProductFaqsEvShopProduct`.`ev_shop_product_id` = 24 AND `ProductFaqsEvShopProduct`.`faq_id` = `ProductFaq`.`id`) ORDER BY `ProductFaq`.`sequence` ASC | 0 | 0 | 0 | |
SELECT `RelatedCategory`.`id`, `RelatedCategory`.`accent_colour_id`, `RelatedCategory`.`category_type`, `RelatedCategory`.`name`, `RelatedCategory`.`internal_title`, `RelatedCategory`.`parent_id`, `RelatedCategory`.`from_price`, `RelatedCategory`.`delivery_delay`, `RelatedCategory`.`homepage_title`, `RelatedCategory`.`homepage_text`, `RelatedCategory`.`description`, `RelatedCategory`.`secondary_description`, `RelatedCategory`.`products_anchor_text`, `RelatedCategory`.`banner_button_text`, `RelatedCategory`.`banner_button_link`, `RelatedCategory`.`why_use_us_heading`, `RelatedCategory`.`why_use_us_left_heading`, `RelatedCategory`.`why_use_us_left`, `RelatedCategory`.`why_use_us_left_button_text`, `RelatedCategory`.`why_use_us_left_button_link`, `RelatedCategory`.`why_use_us_right_heading`, `RelatedCategory`.`why_use_us_right`, `RelatedCategory`.`why_use_us_right_button_text`, `RelatedCategory`.`why_use_us_right_button_link`, `RelatedCategory`.`expanded_text`, `RelatedCategory`.`uses_gravel_calculator`, `RelatedCategory`.`external_site_link`, `RelatedCategory`.`external_site_url`, `RelatedCategory`.`featured_on_homepage`, `RelatedCategory`.`display_in_menu`, `RelatedCategory`.`hidden_category`, `RelatedCategory`.`product_attribute_id`, `RelatedCategory`.`lft`, `RelatedCategory`.`rght`, `RelatedCategory`.`created`, `RelatedCategory`.`modified`, `RelatedItem`.`id`, `RelatedItem`.`model`, `RelatedItem`.`model_id`, `RelatedItem`.`related_model`, `RelatedItem`.`related_model_id`, `RelatedItem`.`sequence`, `RelatedItem`.`created`, `RelatedItem`.`modified` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_category_categories` AS `RelatedCategory` JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_related_items_related_items` AS `RelatedItem` ON (`RelatedItem`.`model_id` = 24 AND `RelatedItem`.`related_model_id` = `RelatedCategory`.`id`) WHERE `model` = 'Product' AND `related_model` = 'Category' | 7 | 7 | 2 | maybe slow |
SELECT `RelatedBrand`.`id`, `RelatedBrand`.`name`, `RelatedBrand`.`description`, `RelatedBrand`.`created`, `RelatedBrand`.`modified`, `RelatedItem`.`id`, `RelatedItem`.`model`, `RelatedItem`.`model_id`, `RelatedItem`.`related_model`, `RelatedItem`.`related_model_id`, `RelatedItem`.`sequence`, `RelatedItem`.`created`, `RelatedItem`.`modified` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_brands` AS `RelatedBrand` JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_related_items_related_items` AS `RelatedItem` ON (`RelatedItem`.`model_id` = 24 AND `RelatedItem`.`related_model_id` = `RelatedBrand`.`id`) WHERE `model` = 'Product' AND `related_model` = 'Brand' | 0 | 0 | 1 | maybe slow |
SELECT `RelatedProduct`.`id`, `RelatedProduct`.`plant_id`, `RelatedProduct`.`force_shipping_company_id`, `RelatedProduct`.`name`, `RelatedProduct`.`internal_title`, `RelatedProduct`.`subtitle`, `RelatedProduct`.`SKU`, `RelatedProduct`.`lead_time`, `RelatedProduct`.`excludes_vat`, `RelatedProduct`.`vat_rate_id`, `RelatedProduct`.`use_size_price`, `RelatedProduct`.`calculator_size`, `RelatedProduct`.`aggregate_size_id`, `RelatedProduct`.`homepage_text`, `RelatedProduct`.`description`, `RelatedProduct`.`expanded_text`, `RelatedProduct`.`additional_title`, `RelatedProduct`.`additional_text`, `RelatedProduct`.`additional_button_title`, `RelatedProduct`.`additional_button_url`, `RelatedProduct`.`aside_title`, `RelatedProduct`.`aside_text`, `RelatedProduct`.`mix_design`, `RelatedProduct`.`technical_spec`, `RelatedProduct`.`addon_products_text`, `RelatedProduct`.`suitable_for`, `RelatedProduct`.`not_suitable_for`, `RelatedProduct`.`sash_colour_id`, `RelatedProduct`.`sash_message_id`, `RelatedProduct`.`no_gravel_calculator`, `RelatedProduct`.`display_only`, `RelatedProduct`.`admin_only`, `RelatedProduct`.`flag_order`, `RelatedProduct`.`nofollow`, `RelatedProduct`.`is_grouped_product`, `RelatedProduct`.`no_loose_load_message`, `RelatedProduct`.`google_feed_title`, `RelatedProduct`.`google_feed_description`, `RelatedProduct`.`exclude_from_feed`, `RelatedProduct`.`is_featured`, `RelatedProduct`.`on_homepage`, `RelatedProduct`.`hide_background_image`, `RelatedProduct`.`hide_background_image_on_mobile`, `RelatedProduct`.`show_options_as_dropdown`, `RelatedProduct`.`qualifies_for_gravelx_upsell`, `RelatedProduct`.`show_gravelx_aside`, `RelatedProduct`.`upsell_specific_sizes`, `RelatedProduct`.`is_active`, `RelatedProduct`.`is_removed`, `RelatedProduct`.`created`, `RelatedProduct`.`modified`, `RelatedItem`.`id`, `RelatedItem`.`model`, `RelatedItem`.`model_id`, `RelatedItem`.`related_model`, `RelatedItem`.`related_model_id`, `RelatedItem`.`sequence`, `RelatedItem`.`created`, `RelatedItem`.`modified` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_products` AS `RelatedProduct` JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_related_items_related_items` AS `RelatedItem` ON (`RelatedItem`.`model_id` = 24 AND `RelatedItem`.`related_model_id` = `RelatedProduct`.`id`) WHERE `RelatedProduct`.`is_active` = '1' AND `model` = 'Product' AND `related_model` = 'Product' AND `is_active` = '1' ORDER BY `sequence` ASC | 1 | 1 | 1 | |
SELECT `MetaData`.`id`, `MetaData`.`model`, `MetaData`.`model_id`, `MetaData`.`title`, `MetaData`.`description`, `MetaData`.`keywords`, `MetaData`.`created`, `MetaData`.`modified` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`meta_data` AS `MetaData` WHERE ((`model` = 'Product') AND (`model_id` = 24)) | 1 | 1 | 0 | |
SELECT `Route`.`id`, `Route`.`alias`, `Route`.`actual` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`routes` AS `Route` WHERE `Route`.`actual` = 'app_products/view/24' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Postcode`.`id`, `Postcode`.`outcode` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`postcodes` AS `Postcode` WHERE `outcode` LIKE 'DE4' LIMIT 1 | 1 | 1 | 0 | |
SELECT `ShippingCompany`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_companies` AS `ShippingCompany` WHERE `is_active` = '1' AND `pricing_only` = '1' | 0 | 0 | 0 | |
SELECT `ShippingCost`.*, `ShippingCompany`.*, IF(cost IS NULL AND shipping_company_id <> 7, -1, 0) AS nullswitch, `ShippingCompany`.`id`, `Plant`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_costs` AS `ShippingCost` LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_companies` AS `ShippingCompany` ON (`ShippingCost`.`shipping_company_id` = `ShippingCompany`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`plants` AS `Plant` ON (`ShippingCost`.`plant_id` = `Plant`.`id`) WHERE `Plant`.`is_active` = '1' AND `ShippingCompany`.`is_active` = '1' AND `postcode_id` = 663 AND `plant_id` = 9 AND ((`cost` >= 0) OR (`cost` IS NULL)) AND NOT (`shipping_company_id` IS NULL) AND `shipping_company_id` != 6 ORDER BY `nullswitch` DESC, `cost` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `Postcode`.`id`, `Postcode`.`outcode` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`postcodes` AS `Postcode` WHERE `outcode` LIKE 'DE4' LIMIT 1 | 1 | 1 | 0 | |
SELECT `ShippingCompany`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_companies` AS `ShippingCompany` WHERE `is_active` = '1' AND `pricing_only` = '1' | 0 | 0 | 0 | |
SELECT `ShippingCost`.*, `ShippingCompany`.*, IF(cost IS NULL AND shipping_company_id <> 7, -1, 0) AS nullswitch, `ShippingCompany`.`id`, `Plant`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_costs` AS `ShippingCost` LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_companies` AS `ShippingCompany` ON (`ShippingCost`.`shipping_company_id` = `ShippingCompany`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`plants` AS `Plant` ON (`ShippingCost`.`plant_id` = `Plant`.`id`) WHERE `Plant`.`is_active` = '1' AND `ShippingCompany`.`is_active` = '1' AND `postcode_id` = 663 AND `plant_id` = 9 AND ((`cost` >= 0) OR (`cost` IS NULL)) AND NOT (`shipping_company_id` IS NULL) AND `shipping_company_id` != 6 ORDER BY `nullswitch` DESC, `cost` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `ProductVariant`.*, `VatRate`.*, `Product`.`excludes_vat`, IF(Product.excludes_vat=1,ProductVariant.price*((VatRate.rate/100)+1),ProductVariant.price) AS calculatedprice, IF(Product.excludes_vat<>1,ProductVariant.price/((VatRate.rate/100)+1),ProductVariant.price) AS exvat, `ProductVariant`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_variants` AS `ProductVariant` left JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_products` AS `Product` ON (`ProductVariant`.`product_id` = `Product`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options_product_variants` AS `ProductAttributeOptionsVariants` ON (`ProductVariant`.`id` = `ProductAttributeOptionsVariants`.`product_variant_id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOption` ON (`ProductAttributeOptionsVariants`.`product_attribute_option_id` = `ProductAttributeOption`.`id`) left JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_checkout_vat_rates` AS `VatRate` ON (`Product`.`vat_rate_id` = `VatRate`.`id`) WHERE `ProductVariant`.`product_id` = 24 AND `ProductVariant`.`is_removed` <> '1' | 18 | 18 | 1 | maybe slow |
SELECT `ProductAttributeOption`.`id`, `ProductAttributeOption`.`product_attribute_id`, `ProductAttributeOption`.`name`, `ProductAttributeOption`.`description`, `ProductAttributeOption`.`sequence`, `ProductAttributeOption`.`created`, `ProductAttributeOption`.`modified`, `EvShopProductAttributeOptionsProductVariant`.`id`, `EvShopProductAttributeOptionsProductVariant`.`product_attribute_option_id`, `EvShopProductAttributeOptionsProductVariant`.`product_variant_id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOption` JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options_product_variants` AS `EvShopProductAttributeOptionsProductVariant` ON (`EvShopProductAttributeOptionsProductVariant`.`product_variant_id` IN (161, 162, 164, 165, 560, 2046) AND `EvShopProductAttributeOptionsProductVariant`.`product_attribute_option_id` = `ProductAttributeOption`.`id`) WHERE `ProductAttributeOption`.`id` IN (129, 7, 120, 118, 55, 56, 8, 114, 123, 111, 9, 122, 110, 121, 11, 82, 57, 58, 53, 81, 80, 86, 117, 119, 124, 115, 42, 102, 101, 96, 95, 98, 97, 100, 99, 73, 14, 116, 104, 36, 37, 30, 31, 32, 18, 60, 107, 19, 106, 22, 92, 93, 94, 17, 16, 83, 23, 125, 126, 127, 128, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143) | 6 | 6 | 1 | maybe slow |
SELECT `ProductAttributeOptions`.`name`, `ProductAttributeOptions`.`description`, `Product`.`excludes_vat`, `VatRate`.`rate`, `ProductVariant`.`online_price`, IF(Product.excludes_vat=1,ProductVariant.price*((VatRate.rate/100)+1),ProductVariant.price) AS calculatedprice, IF(Product.excludes_vat<>1,ProductVariant.price/((VatRate.rate/100)+1),ProductVariant.price) AS exvat, IF(ProductAttributeOptions.description LIKE "%forceprice%", 2, -1) AS force_price, IF(ProductAttributeOptions.description LIKE "%default%", 1, 0) AS is_default, IF(ProductAttributeOptions.description LIKE "%nosurcharge%", 0, 1) AS has_surcharge, IF(ProductAttributeOptions.description LIKE "%separatesurcharge%", 0, 1) AS separate_surcharge, IF(ProductAttributeOptions.description LIKE "%fromprice%", 1, 0) AS from_price, IF(ProductAttributeOptions.description LIKE "%poa%", 1, 0) AS is_poa FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_variants` AS `ProductVariant` LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options_product_variants` AS `ProductAttributeOptionsVariants` ON (`ProductVariant`.`id` = `ProductAttributeOptionsVariants`.`product_variant_id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOptions` ON (`ProductAttributeOptionsVariants`.`product_attribute_option_id` = `ProductAttributeOptions`.`id`) left JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_products` AS `Product` ON (`ProductVariant`.`product_id` = `Product`.`id`) left JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_checkout_vat_rates` AS `VatRate` ON (`Product`.`vat_rate_id` = `VatRate`.`id`) WHERE `ProductVariant`.`product_id` = 24 AND `ProductVariant`.`is_removed` = '0' AND `ProductVariant`.`price` IS NOT NULL AND `ProductVariant`.`price` > 0 AND ((`ProductAttributeOptions`.`description` LIKE '%\"main\"%') OR (`ProductAttributeOptions`.`description` LIKE '%\"default\"%')) ORDER BY `force_price` DESC, `is_default` ASC, `calculatedprice` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `Product`.`id`, `Product`.`plant_id`, `Product`.`force_shipping_company_id`, `Product`.`name`, `Product`.`internal_title`, `Product`.`subtitle`, `Product`.`SKU`, `Product`.`lead_time`, `Product`.`excludes_vat`, `Product`.`vat_rate_id`, `Product`.`use_size_price`, `Product`.`calculator_size`, `Product`.`aggregate_size_id`, `Product`.`homepage_text`, `Product`.`description`, `Product`.`expanded_text`, `Product`.`additional_title`, `Product`.`additional_text`, `Product`.`additional_button_title`, `Product`.`additional_button_url`, `Product`.`aside_title`, `Product`.`aside_text`, `Product`.`mix_design`, `Product`.`technical_spec`, `Product`.`addon_products_text`, `Product`.`suitable_for`, `Product`.`not_suitable_for`, `Product`.`sash_colour_id`, `Product`.`sash_message_id`, `Product`.`no_gravel_calculator`, `Product`.`display_only`, `Product`.`admin_only`, `Product`.`flag_order`, `Product`.`nofollow`, `Product`.`is_grouped_product`, `Product`.`no_loose_load_message`, `Product`.`google_feed_title`, `Product`.`google_feed_description`, `Product`.`exclude_from_feed`, `Product`.`is_featured`, `Product`.`on_homepage`, `Product`.`hide_background_image`, `Product`.`hide_background_image_on_mobile`, `Product`.`show_options_as_dropdown`, `Product`.`qualifies_for_gravelx_upsell`, `Product`.`show_gravelx_aside`, `Product`.`upsell_specific_sizes`, `Product`.`is_active`, `Product`.`is_removed`, `Product`.`created`, `Product`.`modified`, `VatRate`.`id`, `VatRate`.`rate`, `VatRate`.`name`, `VatRate`.`is_active`, `VatRate`.`created`, `VatRate`.`modified`, `SashColour`.`id`, `SashColour`.`name`, `SashColour`.`hex`, `SashColour`.`text_hex`, `SashColour`.`created`, `SashColour`.`modified`, `SashColour`.`is_active`, `SashMessage`.`id`, `SashMessage`.`name`, `SashMessage`.`created`, `SashMessage`.`modified`, `SashMessage`.`is_active`, `AggregateSize`.`id`, `AggregateSize`.`name`, `AggregateSize`.`sequence`, `AggregateSize`.`created`, `AggregateSize`.`modified` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_products` AS `Product` LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_checkout_vat_rates` AS `VatRate` ON (`Product`.`vat_rate_id` = `VatRate`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`sash_colours` AS `SashColour` ON (`Product`.`sash_colour_id` = `SashColour`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`sash_messages` AS `SashMessage` ON (`Product`.`sash_message_id` = `SashMessage`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`aggregate_sizes` AS `AggregateSize` ON (`Product`.`aggregate_size_id` = `AggregateSize`.`id`) WHERE `Product`.`is_active` = '1' AND `Product`.`id` = 55 AND `is_removed` = '0' ORDER BY `Product`.`modified` DESC LIMIT 1 | 1 | 1 | 1 | |
SELECT `ProductVariant`.`id`, `ProductVariant`.`product_id`, `ProductVariant`.`name`, `ProductVariant`.`opera_stock_ref`, `ProductVariant`.`price`, `ProductVariant`.`online_price`, `ProductVariant`.`pick_and_mix_price`, `ProductVariant`.`rrp`, `ProductVariant`.`stock`, `ProductVariant`.`unlimited_stock`, `ProductVariant`.`google_feed_title`, `ProductVariant`.`google_feed_description`, `ProductVariant`.`custom_quantities`, `ProductVariant`.`allow_upsell`, `ProductVariant`.`is_removed`, `ProductVariant`.`created`, `ProductVariant`.`modified`, `ProductVariant`.`last_exported` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_variants` AS `ProductVariant` WHERE `ProductVariant`.`is_removed` <> '1' AND `ProductVariant`.`product_id` = (55) | 6 | 6 | 0 | |
SELECT `BackgroundImage`.`id`, `BackgroundImage`.`model`, `BackgroundImage`.`model_id`, `BackgroundImage`.`filename`, `BackgroundImage`.`attachment_type`, `BackgroundImage`.`alt`, `BackgroundImage`.`title`, `BackgroundImage`.`caption`, `BackgroundImage`.`link_text`, `BackgroundImage`.`link_url`, `BackgroundImage`.`products`, `BackgroundImage`.`body`, `BackgroundImage`.`type`, `BackgroundImage`.`size`, `BackgroundImage`.`dir`, `BackgroundImage`.`sequence`, `BackgroundImage`.`is_active`, `BackgroundImage`.`created`, `BackgroundImage`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `BackgroundImage__filepath` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`images` AS `BackgroundImage` WHERE `model` = 'Product' AND `attachment_type` = 'BackgroundImage' AND `BackgroundImage`.`model_id` = (55) ORDER BY `sequence` ASC | 1 | 1 | 0 | |
SELECT `ListingImage`.`id`, `ListingImage`.`model`, `ListingImage`.`model_id`, `ListingImage`.`filename`, `ListingImage`.`attachment_type`, `ListingImage`.`alt`, `ListingImage`.`title`, `ListingImage`.`caption`, `ListingImage`.`link_text`, `ListingImage`.`link_url`, `ListingImage`.`products`, `ListingImage`.`body`, `ListingImage`.`type`, `ListingImage`.`size`, `ListingImage`.`dir`, `ListingImage`.`sequence`, `ListingImage`.`is_active`, `ListingImage`.`created`, `ListingImage`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `ListingImage__filepath` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`images` AS `ListingImage` WHERE `model` = 'Product' AND `attachment_type` = 'ListingImage' AND `ListingImage`.`model_id` = (55) ORDER BY `sequence` ASC | 1 | 1 | 0 | |
SELECT `SampleImage`.`id`, `SampleImage`.`model`, `SampleImage`.`model_id`, `SampleImage`.`filename`, `SampleImage`.`attachment_type`, `SampleImage`.`alt`, `SampleImage`.`title`, `SampleImage`.`caption`, `SampleImage`.`link_text`, `SampleImage`.`link_url`, `SampleImage`.`products`, `SampleImage`.`body`, `SampleImage`.`type`, `SampleImage`.`size`, `SampleImage`.`dir`, `SampleImage`.`sequence`, `SampleImage`.`is_active`, `SampleImage`.`created`, `SampleImage`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `SampleImage__filepath` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`images` AS `SampleImage` WHERE `model` = 'Product' AND `attachment_type` = 'SampleImage' AND `SampleImage`.`model_id` = (55) ORDER BY `sequence` ASC | 1 | 1 | 0 | |
SELECT `AsideImage`.`id`, `AsideImage`.`model`, `AsideImage`.`model_id`, `AsideImage`.`filename`, `AsideImage`.`attachment_type`, `AsideImage`.`alt`, `AsideImage`.`title`, `AsideImage`.`caption`, `AsideImage`.`link_text`, `AsideImage`.`link_url`, `AsideImage`.`products`, `AsideImage`.`body`, `AsideImage`.`type`, `AsideImage`.`size`, `AsideImage`.`dir`, `AsideImage`.`sequence`, `AsideImage`.`is_active`, `AsideImage`.`created`, `AsideImage`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `AsideImage__filepath` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`images` AS `AsideImage` WHERE `model` = 'Product' AND `attachment_type` = 'AsideImage' AND `AsideImage`.`model_id` = (55) ORDER BY `sequence` ASC | 0 | 0 | 0 | |
SELECT `Image`.`id`, `Image`.`model`, `Image`.`model_id`, `Image`.`filename`, `Image`.`attachment_type`, `Image`.`alt`, `Image`.`title`, `Image`.`caption`, `Image`.`link_text`, `Image`.`link_url`, `Image`.`products`, `Image`.`body`, `Image`.`type`, `Image`.`size`, `Image`.`dir`, `Image`.`sequence`, `Image`.`is_active`, `Image`.`created`, `Image`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `Image__filepath` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`images` AS `Image` WHERE `model` = 'Product' AND `attachment_type` = 'Image' AND `Image`.`model_id` = (55) ORDER BY `sequence` ASC | 8 | 8 | 0 | |
SELECT `ProductAttributeOption`.`id`, `ProductAttributeOption`.`product_attribute_id`, `ProductAttributeOption`.`name`, `ProductAttributeOption`.`description`, `ProductAttributeOption`.`sequence`, `ProductAttributeOption`.`created`, `ProductAttributeOption`.`modified`, `EvShopProductAttributeOptionsProduct`.`id`, `EvShopProductAttributeOptionsProduct`.`product_attribute_option_id`, `EvShopProductAttributeOptionsProduct`.`product_id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOption` JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options_products` AS `EvShopProductAttributeOptionsProduct` ON (`EvShopProductAttributeOptionsProduct`.`product_id` = 55 AND `EvShopProductAttributeOptionsProduct`.`product_attribute_option_id` = `ProductAttributeOption`.`id`) | 7 | 7 | 0 | |
SELECT `SecondaryPlant`.`id`, `SecondaryPlant`.`name`, `SecondaryPlant`.`front_facing_name`, `SecondaryPlant`.`order_recipient`, `SecondaryPlant`.`email`, `SecondaryPlant`.`phone`, `SecondaryPlant`.`printer_name`, `SecondaryPlant`.`use_email`, `SecondaryPlant`.`use_printer`, `SecondaryPlant`.`allow_customer_collection`, `SecondaryPlant`.`no_queue_emails`, `SecondaryPlant`.`has_earlier_next_day_queue`, `SecondaryPlant`.`is_direct`, `SecondaryPlant`.`sequence`, `SecondaryPlant`.`address_name`, `SecondaryPlant`.`address_line_1`, `SecondaryPlant`.`address_line_2`, `SecondaryPlant`.`address_line_3`, `SecondaryPlant`.`address_town`, `SecondaryPlant`.`address_county`, `SecondaryPlant`.`address_postcode`, `SecondaryPlant`.`pricing_postcode`, `SecondaryPlant`.`pallex_username`, `SecondaryPlant`.`pallex_password`, `SecondaryPlant`.`created`, `SecondaryPlant`.`modified`, `SecondaryPlant`.`is_active`, `EvShopProductsPlant`.`id`, `EvShopProductsPlant`.`ev_shop_product_id`, `EvShopProductsPlant`.`plant_id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`plants` AS `SecondaryPlant` JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_products_plants` AS `EvShopProductsPlant` ON (`EvShopProductsPlant`.`ev_shop_product_id` = 55 AND `EvShopProductsPlant`.`plant_id` = `SecondaryPlant`.`id`) | 1 | 1 | 1 | |
SELECT `ProductFaq`.`id`, `ProductFaq`.`question`, `ProductFaq`.`answer`, `ProductFaq`.`is_active`, `ProductFaq`.`sequence`, `ProductFaq`.`created`, `ProductFaq`.`modified`, `ProductFaqsEvShopProduct`.`id`, `ProductFaqsEvShopProduct`.`faq_id`, `ProductFaqsEvShopProduct`.`ev_shop_product_id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`product_faqs` AS `ProductFaq` JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`product_faqs_ev_shop_products` AS `ProductFaqsEvShopProduct` ON (`ProductFaqsEvShopProduct`.`ev_shop_product_id` = 55 AND `ProductFaqsEvShopProduct`.`faq_id` = `ProductFaq`.`id`) ORDER BY `ProductFaq`.`sequence` ASC | 0 | 0 | 0 | |
SELECT `RelatedCategory`.`id`, `RelatedCategory`.`accent_colour_id`, `RelatedCategory`.`category_type`, `RelatedCategory`.`name`, `RelatedCategory`.`internal_title`, `RelatedCategory`.`parent_id`, `RelatedCategory`.`from_price`, `RelatedCategory`.`delivery_delay`, `RelatedCategory`.`homepage_title`, `RelatedCategory`.`homepage_text`, `RelatedCategory`.`description`, `RelatedCategory`.`secondary_description`, `RelatedCategory`.`products_anchor_text`, `RelatedCategory`.`banner_button_text`, `RelatedCategory`.`banner_button_link`, `RelatedCategory`.`why_use_us_heading`, `RelatedCategory`.`why_use_us_left_heading`, `RelatedCategory`.`why_use_us_left`, `RelatedCategory`.`why_use_us_left_button_text`, `RelatedCategory`.`why_use_us_left_button_link`, `RelatedCategory`.`why_use_us_right_heading`, `RelatedCategory`.`why_use_us_right`, `RelatedCategory`.`why_use_us_right_button_text`, `RelatedCategory`.`why_use_us_right_button_link`, `RelatedCategory`.`expanded_text`, `RelatedCategory`.`uses_gravel_calculator`, `RelatedCategory`.`external_site_link`, `RelatedCategory`.`external_site_url`, `RelatedCategory`.`featured_on_homepage`, `RelatedCategory`.`display_in_menu`, `RelatedCategory`.`hidden_category`, `RelatedCategory`.`product_attribute_id`, `RelatedCategory`.`lft`, `RelatedCategory`.`rght`, `RelatedCategory`.`created`, `RelatedCategory`.`modified`, `RelatedItem`.`id`, `RelatedItem`.`model`, `RelatedItem`.`model_id`, `RelatedItem`.`related_model`, `RelatedItem`.`related_model_id`, `RelatedItem`.`sequence`, `RelatedItem`.`created`, `RelatedItem`.`modified` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_category_categories` AS `RelatedCategory` JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_related_items_related_items` AS `RelatedItem` ON (`RelatedItem`.`model_id` = 55 AND `RelatedItem`.`related_model_id` = `RelatedCategory`.`id`) WHERE `model` = 'Product' AND `related_model` = 'Category' | 5 | 5 | 2 | maybe slow |
SELECT `RelatedBrand`.`id`, `RelatedBrand`.`name`, `RelatedBrand`.`description`, `RelatedBrand`.`created`, `RelatedBrand`.`modified`, `RelatedItem`.`id`, `RelatedItem`.`model`, `RelatedItem`.`model_id`, `RelatedItem`.`related_model`, `RelatedItem`.`related_model_id`, `RelatedItem`.`sequence`, `RelatedItem`.`created`, `RelatedItem`.`modified` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_brands` AS `RelatedBrand` JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_related_items_related_items` AS `RelatedItem` ON (`RelatedItem`.`model_id` = 55 AND `RelatedItem`.`related_model_id` = `RelatedBrand`.`id`) WHERE `model` = 'Product' AND `related_model` = 'Brand' | 0 | 0 | 1 | maybe slow |
SELECT `RelatedProduct`.`id`, `RelatedProduct`.`plant_id`, `RelatedProduct`.`force_shipping_company_id`, `RelatedProduct`.`name`, `RelatedProduct`.`internal_title`, `RelatedProduct`.`subtitle`, `RelatedProduct`.`SKU`, `RelatedProduct`.`lead_time`, `RelatedProduct`.`excludes_vat`, `RelatedProduct`.`vat_rate_id`, `RelatedProduct`.`use_size_price`, `RelatedProduct`.`calculator_size`, `RelatedProduct`.`aggregate_size_id`, `RelatedProduct`.`homepage_text`, `RelatedProduct`.`description`, `RelatedProduct`.`expanded_text`, `RelatedProduct`.`additional_title`, `RelatedProduct`.`additional_text`, `RelatedProduct`.`additional_button_title`, `RelatedProduct`.`additional_button_url`, `RelatedProduct`.`aside_title`, `RelatedProduct`.`aside_text`, `RelatedProduct`.`mix_design`, `RelatedProduct`.`technical_spec`, `RelatedProduct`.`addon_products_text`, `RelatedProduct`.`suitable_for`, `RelatedProduct`.`not_suitable_for`, `RelatedProduct`.`sash_colour_id`, `RelatedProduct`.`sash_message_id`, `RelatedProduct`.`no_gravel_calculator`, `RelatedProduct`.`display_only`, `RelatedProduct`.`admin_only`, `RelatedProduct`.`flag_order`, `RelatedProduct`.`nofollow`, `RelatedProduct`.`is_grouped_product`, `RelatedProduct`.`no_loose_load_message`, `RelatedProduct`.`google_feed_title`, `RelatedProduct`.`google_feed_description`, `RelatedProduct`.`exclude_from_feed`, `RelatedProduct`.`is_featured`, `RelatedProduct`.`on_homepage`, `RelatedProduct`.`hide_background_image`, `RelatedProduct`.`hide_background_image_on_mobile`, `RelatedProduct`.`show_options_as_dropdown`, `RelatedProduct`.`qualifies_for_gravelx_upsell`, `RelatedProduct`.`show_gravelx_aside`, `RelatedProduct`.`upsell_specific_sizes`, `RelatedProduct`.`is_active`, `RelatedProduct`.`is_removed`, `RelatedProduct`.`created`, `RelatedProduct`.`modified`, `RelatedItem`.`id`, `RelatedItem`.`model`, `RelatedItem`.`model_id`, `RelatedItem`.`related_model`, `RelatedItem`.`related_model_id`, `RelatedItem`.`sequence`, `RelatedItem`.`created`, `RelatedItem`.`modified` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_products` AS `RelatedProduct` JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_related_items_related_items` AS `RelatedItem` ON (`RelatedItem`.`model_id` = 55 AND `RelatedItem`.`related_model_id` = `RelatedProduct`.`id`) WHERE `RelatedProduct`.`is_active` = '1' AND `model` = 'Product' AND `related_model` = 'Product' AND `is_active` = '1' ORDER BY `sequence` ASC | 2 | 2 | 1 | maybe slow |
SELECT `MetaData`.`id`, `MetaData`.`model`, `MetaData`.`model_id`, `MetaData`.`title`, `MetaData`.`description`, `MetaData`.`keywords`, `MetaData`.`created`, `MetaData`.`modified` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`meta_data` AS `MetaData` WHERE ((`model` = 'Product') AND (`model_id` = 55)) | 1 | 1 | 0 | |
SELECT `Route`.`id`, `Route`.`alias`, `Route`.`actual` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`routes` AS `Route` WHERE `Route`.`actual` = 'app_products/view/55' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Postcode`.`id`, `Postcode`.`outcode` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`postcodes` AS `Postcode` WHERE `outcode` LIKE 'DE4' LIMIT 1 | 1 | 1 | 0 | |
SELECT `ShippingCompany`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_companies` AS `ShippingCompany` WHERE `is_active` = '1' AND `pricing_only` = '1' | 0 | 0 | 0 | |
SELECT `ShippingCost`.*, `ShippingCompany`.*, IF(cost IS NULL AND shipping_company_id <> 7, -1, 0) AS nullswitch, `ShippingCompany`.`id`, `Plant`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_costs` AS `ShippingCost` LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_companies` AS `ShippingCompany` ON (`ShippingCost`.`shipping_company_id` = `ShippingCompany`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`plants` AS `Plant` ON (`ShippingCost`.`plant_id` = `Plant`.`id`) WHERE `Plant`.`is_active` = '1' AND `ShippingCompany`.`is_active` = '1' AND `postcode_id` = 663 AND `plant_id` = 9 AND ((`cost` >= 0) OR (`cost` IS NULL)) AND NOT (`shipping_company_id` IS NULL) AND `shipping_company_id` != 6 ORDER BY `nullswitch` DESC, `cost` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `Postcode`.`id`, `Postcode`.`outcode` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`postcodes` AS `Postcode` WHERE `outcode` LIKE 'DE4' LIMIT 1 | 1 | 1 | 0 | |
SELECT `ShippingCompany`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_companies` AS `ShippingCompany` WHERE `is_active` = '1' AND `pricing_only` = '1' | 0 | 0 | 0 | |
SELECT `ShippingCost`.*, `ShippingCompany`.*, IF(cost IS NULL AND shipping_company_id <> 7, -1, 0) AS nullswitch, `ShippingCompany`.`id`, `Plant`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_costs` AS `ShippingCost` LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_companies` AS `ShippingCompany` ON (`ShippingCost`.`shipping_company_id` = `ShippingCompany`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`plants` AS `Plant` ON (`ShippingCost`.`plant_id` = `Plant`.`id`) WHERE `Plant`.`is_active` = '1' AND `ShippingCompany`.`is_active` = '1' AND `postcode_id` = 663 AND `plant_id` = 9 AND ((`cost` >= 0) OR (`cost` IS NULL)) AND NOT (`shipping_company_id` IS NULL) AND `shipping_company_id` != 6 ORDER BY `nullswitch` DESC, `cost` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `ProductVariant`.*, `VatRate`.*, `Product`.`excludes_vat`, IF(Product.excludes_vat=1,ProductVariant.price*((VatRate.rate/100)+1),ProductVariant.price) AS calculatedprice, IF(Product.excludes_vat<>1,ProductVariant.price/((VatRate.rate/100)+1),ProductVariant.price) AS exvat, `ProductVariant`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_variants` AS `ProductVariant` left JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_products` AS `Product` ON (`ProductVariant`.`product_id` = `Product`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options_product_variants` AS `ProductAttributeOptionsVariants` ON (`ProductVariant`.`id` = `ProductAttributeOptionsVariants`.`product_variant_id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOption` ON (`ProductAttributeOptionsVariants`.`product_attribute_option_id` = `ProductAttributeOption`.`id`) left JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_checkout_vat_rates` AS `VatRate` ON (`Product`.`vat_rate_id` = `VatRate`.`id`) WHERE `ProductVariant`.`product_id` = 55 AND `ProductVariant`.`is_removed` <> '1' | 12 | 12 | 1 | maybe slow |
SELECT `ProductAttributeOption`.`id`, `ProductAttributeOption`.`product_attribute_id`, `ProductAttributeOption`.`name`, `ProductAttributeOption`.`description`, `ProductAttributeOption`.`sequence`, `ProductAttributeOption`.`created`, `ProductAttributeOption`.`modified`, `EvShopProductAttributeOptionsProductVariant`.`id`, `EvShopProductAttributeOptionsProductVariant`.`product_attribute_option_id`, `EvShopProductAttributeOptionsProductVariant`.`product_variant_id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOption` JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options_product_variants` AS `EvShopProductAttributeOptionsProductVariant` ON (`EvShopProductAttributeOptionsProductVariant`.`product_variant_id` IN (1843, 2056, 2216, 2219, 2220, 2225) AND `EvShopProductAttributeOptionsProductVariant`.`product_attribute_option_id` = `ProductAttributeOption`.`id`) WHERE `ProductAttributeOption`.`id` IN (129, 7, 120, 118, 55, 56, 8, 114, 123, 111, 9, 122, 110, 121, 11, 82, 57, 58, 53, 81, 80, 86, 117, 119, 124, 115, 42, 102, 101, 96, 95, 98, 97, 100, 99, 73, 14, 116, 104, 36, 37, 30, 31, 32, 18, 60, 107, 19, 106, 22, 92, 93, 94, 17, 16, 83, 23, 125, 126, 127, 128, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143) | 6 | 6 | 1 | maybe slow |
SELECT `ProductAttributeOptions`.`name`, `ProductAttributeOptions`.`description`, `Product`.`excludes_vat`, `VatRate`.`rate`, `ProductVariant`.`online_price`, IF(Product.excludes_vat=1,ProductVariant.price*((VatRate.rate/100)+1),ProductVariant.price) AS calculatedprice, IF(Product.excludes_vat<>1,ProductVariant.price/((VatRate.rate/100)+1),ProductVariant.price) AS exvat, IF(ProductAttributeOptions.description LIKE "%forceprice%", 2, -1) AS force_price, IF(ProductAttributeOptions.description LIKE "%default%", 1, 0) AS is_default, IF(ProductAttributeOptions.description LIKE "%nosurcharge%", 0, 1) AS has_surcharge, IF(ProductAttributeOptions.description LIKE "%separatesurcharge%", 0, 1) AS separate_surcharge, IF(ProductAttributeOptions.description LIKE "%fromprice%", 1, 0) AS from_price, IF(ProductAttributeOptions.description LIKE "%poa%", 1, 0) AS is_poa FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_variants` AS `ProductVariant` LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options_product_variants` AS `ProductAttributeOptionsVariants` ON (`ProductVariant`.`id` = `ProductAttributeOptionsVariants`.`product_variant_id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOptions` ON (`ProductAttributeOptionsVariants`.`product_attribute_option_id` = `ProductAttributeOptions`.`id`) left JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_products` AS `Product` ON (`ProductVariant`.`product_id` = `Product`.`id`) left JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_checkout_vat_rates` AS `VatRate` ON (`Product`.`vat_rate_id` = `VatRate`.`id`) WHERE `ProductVariant`.`product_id` = 55 AND `ProductVariant`.`is_removed` = '0' AND `ProductVariant`.`price` IS NOT NULL AND `ProductVariant`.`price` > 0 AND ((`ProductAttributeOptions`.`description` LIKE '%\"main\"%') OR (`ProductAttributeOptions`.`description` LIKE '%\"default\"%')) ORDER BY `force_price` DESC, `is_default` ASC, `calculatedprice` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `Product`.`id`, `Product`.`plant_id`, `Product`.`force_shipping_company_id`, `Product`.`name`, `Product`.`internal_title`, `Product`.`subtitle`, `Product`.`SKU`, `Product`.`lead_time`, `Product`.`excludes_vat`, `Product`.`vat_rate_id`, `Product`.`use_size_price`, `Product`.`calculator_size`, `Product`.`aggregate_size_id`, `Product`.`homepage_text`, `Product`.`description`, `Product`.`expanded_text`, `Product`.`additional_title`, `Product`.`additional_text`, `Product`.`additional_button_title`, `Product`.`additional_button_url`, `Product`.`aside_title`, `Product`.`aside_text`, `Product`.`mix_design`, `Product`.`technical_spec`, `Product`.`addon_products_text`, `Product`.`suitable_for`, `Product`.`not_suitable_for`, `Product`.`sash_colour_id`, `Product`.`sash_message_id`, `Product`.`no_gravel_calculator`, `Product`.`display_only`, `Product`.`admin_only`, `Product`.`flag_order`, `Product`.`nofollow`, `Product`.`is_grouped_product`, `Product`.`no_loose_load_message`, `Product`.`google_feed_title`, `Product`.`google_feed_description`, `Product`.`exclude_from_feed`, `Product`.`is_featured`, `Product`.`on_homepage`, `Product`.`hide_background_image`, `Product`.`hide_background_image_on_mobile`, `Product`.`show_options_as_dropdown`, `Product`.`qualifies_for_gravelx_upsell`, `Product`.`show_gravelx_aside`, `Product`.`upsell_specific_sizes`, `Product`.`is_active`, `Product`.`is_removed`, `Product`.`created`, `Product`.`modified`, `VatRate`.`id`, `VatRate`.`rate`, `VatRate`.`name`, `VatRate`.`is_active`, `VatRate`.`created`, `VatRate`.`modified`, `SashColour`.`id`, `SashColour`.`name`, `SashColour`.`hex`, `SashColour`.`text_hex`, `SashColour`.`created`, `SashColour`.`modified`, `SashColour`.`is_active`, `SashMessage`.`id`, `SashMessage`.`name`, `SashMessage`.`created`, `SashMessage`.`modified`, `SashMessage`.`is_active`, `AggregateSize`.`id`, `AggregateSize`.`name`, `AggregateSize`.`sequence`, `AggregateSize`.`created`, `AggregateSize`.`modified` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_products` AS `Product` LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_checkout_vat_rates` AS `VatRate` ON (`Product`.`vat_rate_id` = `VatRate`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`sash_colours` AS `SashColour` ON (`Product`.`sash_colour_id` = `SashColour`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`sash_messages` AS `SashMessage` ON (`Product`.`sash_message_id` = `SashMessage`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`aggregate_sizes` AS `AggregateSize` ON (`Product`.`aggregate_size_id` = `AggregateSize`.`id`) WHERE `Product`.`is_active` = '1' AND `Product`.`id` = 48 AND `is_removed` = '0' ORDER BY `Product`.`modified` DESC LIMIT 1 | 1 | 1 | 1 | |
SELECT `ProductVariant`.`id`, `ProductVariant`.`product_id`, `ProductVariant`.`name`, `ProductVariant`.`opera_stock_ref`, `ProductVariant`.`price`, `ProductVariant`.`online_price`, `ProductVariant`.`pick_and_mix_price`, `ProductVariant`.`rrp`, `ProductVariant`.`stock`, `ProductVariant`.`unlimited_stock`, `ProductVariant`.`google_feed_title`, `ProductVariant`.`google_feed_description`, `ProductVariant`.`custom_quantities`, `ProductVariant`.`allow_upsell`, `ProductVariant`.`is_removed`, `ProductVariant`.`created`, `ProductVariant`.`modified`, `ProductVariant`.`last_exported` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_variants` AS `ProductVariant` WHERE `ProductVariant`.`is_removed` <> '1' AND `ProductVariant`.`product_id` = (48) | 6 | 6 | 0 | |
SELECT `BackgroundImage`.`id`, `BackgroundImage`.`model`, `BackgroundImage`.`model_id`, `BackgroundImage`.`filename`, `BackgroundImage`.`attachment_type`, `BackgroundImage`.`alt`, `BackgroundImage`.`title`, `BackgroundImage`.`caption`, `BackgroundImage`.`link_text`, `BackgroundImage`.`link_url`, `BackgroundImage`.`products`, `BackgroundImage`.`body`, `BackgroundImage`.`type`, `BackgroundImage`.`size`, `BackgroundImage`.`dir`, `BackgroundImage`.`sequence`, `BackgroundImage`.`is_active`, `BackgroundImage`.`created`, `BackgroundImage`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `BackgroundImage__filepath` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`images` AS `BackgroundImage` WHERE `model` = 'Product' AND `attachment_type` = 'BackgroundImage' AND `BackgroundImage`.`model_id` = (48) ORDER BY `sequence` ASC | 1 | 1 | 0 | |
SELECT `ListingImage`.`id`, `ListingImage`.`model`, `ListingImage`.`model_id`, `ListingImage`.`filename`, `ListingImage`.`attachment_type`, `ListingImage`.`alt`, `ListingImage`.`title`, `ListingImage`.`caption`, `ListingImage`.`link_text`, `ListingImage`.`link_url`, `ListingImage`.`products`, `ListingImage`.`body`, `ListingImage`.`type`, `ListingImage`.`size`, `ListingImage`.`dir`, `ListingImage`.`sequence`, `ListingImage`.`is_active`, `ListingImage`.`created`, `ListingImage`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `ListingImage__filepath` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`images` AS `ListingImage` WHERE `model` = 'Product' AND `attachment_type` = 'ListingImage' AND `ListingImage`.`model_id` = (48) ORDER BY `sequence` ASC | 1 | 1 | 0 | |
SELECT `SampleImage`.`id`, `SampleImage`.`model`, `SampleImage`.`model_id`, `SampleImage`.`filename`, `SampleImage`.`attachment_type`, `SampleImage`.`alt`, `SampleImage`.`title`, `SampleImage`.`caption`, `SampleImage`.`link_text`, `SampleImage`.`link_url`, `SampleImage`.`products`, `SampleImage`.`body`, `SampleImage`.`type`, `SampleImage`.`size`, `SampleImage`.`dir`, `SampleImage`.`sequence`, `SampleImage`.`is_active`, `SampleImage`.`created`, `SampleImage`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `SampleImage__filepath` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`images` AS `SampleImage` WHERE `model` = 'Product' AND `attachment_type` = 'SampleImage' AND `SampleImage`.`model_id` = (48) ORDER BY `sequence` ASC | 1 | 1 | 0 | |
SELECT `AsideImage`.`id`, `AsideImage`.`model`, `AsideImage`.`model_id`, `AsideImage`.`filename`, `AsideImage`.`attachment_type`, `AsideImage`.`alt`, `AsideImage`.`title`, `AsideImage`.`caption`, `AsideImage`.`link_text`, `AsideImage`.`link_url`, `AsideImage`.`products`, `AsideImage`.`body`, `AsideImage`.`type`, `AsideImage`.`size`, `AsideImage`.`dir`, `AsideImage`.`sequence`, `AsideImage`.`is_active`, `AsideImage`.`created`, `AsideImage`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `AsideImage__filepath` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`images` AS `AsideImage` WHERE `model` = 'Product' AND `attachment_type` = 'AsideImage' AND `AsideImage`.`model_id` = (48) ORDER BY `sequence` ASC | 0 | 0 | 0 | |
SELECT `Image`.`id`, `Image`.`model`, `Image`.`model_id`, `Image`.`filename`, `Image`.`attachment_type`, `Image`.`alt`, `Image`.`title`, `Image`.`caption`, `Image`.`link_text`, `Image`.`link_url`, `Image`.`products`, `Image`.`body`, `Image`.`type`, `Image`.`size`, `Image`.`dir`, `Image`.`sequence`, `Image`.`is_active`, `Image`.`created`, `Image`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `Image__filepath` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`images` AS `Image` WHERE `model` = 'Product' AND `attachment_type` = 'Image' AND `Image`.`model_id` = (48) ORDER BY `sequence` ASC | 5 | 5 | 0 | |
SELECT `ProductAttributeOption`.`id`, `ProductAttributeOption`.`product_attribute_id`, `ProductAttributeOption`.`name`, `ProductAttributeOption`.`description`, `ProductAttributeOption`.`sequence`, `ProductAttributeOption`.`created`, `ProductAttributeOption`.`modified`, `EvShopProductAttributeOptionsProduct`.`id`, `EvShopProductAttributeOptionsProduct`.`product_attribute_option_id`, `EvShopProductAttributeOptionsProduct`.`product_id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOption` JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options_products` AS `EvShopProductAttributeOptionsProduct` ON (`EvShopProductAttributeOptionsProduct`.`product_id` = 48 AND `EvShopProductAttributeOptionsProduct`.`product_attribute_option_id` = `ProductAttributeOption`.`id`) | 7 | 7 | 0 | |
SELECT `SecondaryPlant`.`id`, `SecondaryPlant`.`name`, `SecondaryPlant`.`front_facing_name`, `SecondaryPlant`.`order_recipient`, `SecondaryPlant`.`email`, `SecondaryPlant`.`phone`, `SecondaryPlant`.`printer_name`, `SecondaryPlant`.`use_email`, `SecondaryPlant`.`use_printer`, `SecondaryPlant`.`allow_customer_collection`, `SecondaryPlant`.`no_queue_emails`, `SecondaryPlant`.`has_earlier_next_day_queue`, `SecondaryPlant`.`is_direct`, `SecondaryPlant`.`sequence`, `SecondaryPlant`.`address_name`, `SecondaryPlant`.`address_line_1`, `SecondaryPlant`.`address_line_2`, `SecondaryPlant`.`address_line_3`, `SecondaryPlant`.`address_town`, `SecondaryPlant`.`address_county`, `SecondaryPlant`.`address_postcode`, `SecondaryPlant`.`pricing_postcode`, `SecondaryPlant`.`pallex_username`, `SecondaryPlant`.`pallex_password`, `SecondaryPlant`.`created`, `SecondaryPlant`.`modified`, `SecondaryPlant`.`is_active`, `EvShopProductsPlant`.`id`, `EvShopProductsPlant`.`ev_shop_product_id`, `EvShopProductsPlant`.`plant_id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`plants` AS `SecondaryPlant` JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_products_plants` AS `EvShopProductsPlant` ON (`EvShopProductsPlant`.`ev_shop_product_id` = 48 AND `EvShopProductsPlant`.`plant_id` = `SecondaryPlant`.`id`) | 1 | 1 | 0 | |
SELECT `ProductFaq`.`id`, `ProductFaq`.`question`, `ProductFaq`.`answer`, `ProductFaq`.`is_active`, `ProductFaq`.`sequence`, `ProductFaq`.`created`, `ProductFaq`.`modified`, `ProductFaqsEvShopProduct`.`id`, `ProductFaqsEvShopProduct`.`faq_id`, `ProductFaqsEvShopProduct`.`ev_shop_product_id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`product_faqs` AS `ProductFaq` JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`product_faqs_ev_shop_products` AS `ProductFaqsEvShopProduct` ON (`ProductFaqsEvShopProduct`.`ev_shop_product_id` = 48 AND `ProductFaqsEvShopProduct`.`faq_id` = `ProductFaq`.`id`) ORDER BY `ProductFaq`.`sequence` ASC | 0 | 0 | 0 | |
SELECT `RelatedCategory`.`id`, `RelatedCategory`.`accent_colour_id`, `RelatedCategory`.`category_type`, `RelatedCategory`.`name`, `RelatedCategory`.`internal_title`, `RelatedCategory`.`parent_id`, `RelatedCategory`.`from_price`, `RelatedCategory`.`delivery_delay`, `RelatedCategory`.`homepage_title`, `RelatedCategory`.`homepage_text`, `RelatedCategory`.`description`, `RelatedCategory`.`secondary_description`, `RelatedCategory`.`products_anchor_text`, `RelatedCategory`.`banner_button_text`, `RelatedCategory`.`banner_button_link`, `RelatedCategory`.`why_use_us_heading`, `RelatedCategory`.`why_use_us_left_heading`, `RelatedCategory`.`why_use_us_left`, `RelatedCategory`.`why_use_us_left_button_text`, `RelatedCategory`.`why_use_us_left_button_link`, `RelatedCategory`.`why_use_us_right_heading`, `RelatedCategory`.`why_use_us_right`, `RelatedCategory`.`why_use_us_right_button_text`, `RelatedCategory`.`why_use_us_right_button_link`, `RelatedCategory`.`expanded_text`, `RelatedCategory`.`uses_gravel_calculator`, `RelatedCategory`.`external_site_link`, `RelatedCategory`.`external_site_url`, `RelatedCategory`.`featured_on_homepage`, `RelatedCategory`.`display_in_menu`, `RelatedCategory`.`hidden_category`, `RelatedCategory`.`product_attribute_id`, `RelatedCategory`.`lft`, `RelatedCategory`.`rght`, `RelatedCategory`.`created`, `RelatedCategory`.`modified`, `RelatedItem`.`id`, `RelatedItem`.`model`, `RelatedItem`.`model_id`, `RelatedItem`.`related_model`, `RelatedItem`.`related_model_id`, `RelatedItem`.`sequence`, `RelatedItem`.`created`, `RelatedItem`.`modified` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_category_categories` AS `RelatedCategory` JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_related_items_related_items` AS `RelatedItem` ON (`RelatedItem`.`model_id` = 48 AND `RelatedItem`.`related_model_id` = `RelatedCategory`.`id`) WHERE `model` = 'Product' AND `related_model` = 'Category' | 11 | 11 | 2 | maybe slow |
SELECT `RelatedBrand`.`id`, `RelatedBrand`.`name`, `RelatedBrand`.`description`, `RelatedBrand`.`created`, `RelatedBrand`.`modified`, `RelatedItem`.`id`, `RelatedItem`.`model`, `RelatedItem`.`model_id`, `RelatedItem`.`related_model`, `RelatedItem`.`related_model_id`, `RelatedItem`.`sequence`, `RelatedItem`.`created`, `RelatedItem`.`modified` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_brands` AS `RelatedBrand` JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_related_items_related_items` AS `RelatedItem` ON (`RelatedItem`.`model_id` = 48 AND `RelatedItem`.`related_model_id` = `RelatedBrand`.`id`) WHERE `model` = 'Product' AND `related_model` = 'Brand' | 0 | 0 | 1 | maybe slow |
SELECT `RelatedProduct`.`id`, `RelatedProduct`.`plant_id`, `RelatedProduct`.`force_shipping_company_id`, `RelatedProduct`.`name`, `RelatedProduct`.`internal_title`, `RelatedProduct`.`subtitle`, `RelatedProduct`.`SKU`, `RelatedProduct`.`lead_time`, `RelatedProduct`.`excludes_vat`, `RelatedProduct`.`vat_rate_id`, `RelatedProduct`.`use_size_price`, `RelatedProduct`.`calculator_size`, `RelatedProduct`.`aggregate_size_id`, `RelatedProduct`.`homepage_text`, `RelatedProduct`.`description`, `RelatedProduct`.`expanded_text`, `RelatedProduct`.`additional_title`, `RelatedProduct`.`additional_text`, `RelatedProduct`.`additional_button_title`, `RelatedProduct`.`additional_button_url`, `RelatedProduct`.`aside_title`, `RelatedProduct`.`aside_text`, `RelatedProduct`.`mix_design`, `RelatedProduct`.`technical_spec`, `RelatedProduct`.`addon_products_text`, `RelatedProduct`.`suitable_for`, `RelatedProduct`.`not_suitable_for`, `RelatedProduct`.`sash_colour_id`, `RelatedProduct`.`sash_message_id`, `RelatedProduct`.`no_gravel_calculator`, `RelatedProduct`.`display_only`, `RelatedProduct`.`admin_only`, `RelatedProduct`.`flag_order`, `RelatedProduct`.`nofollow`, `RelatedProduct`.`is_grouped_product`, `RelatedProduct`.`no_loose_load_message`, `RelatedProduct`.`google_feed_title`, `RelatedProduct`.`google_feed_description`, `RelatedProduct`.`exclude_from_feed`, `RelatedProduct`.`is_featured`, `RelatedProduct`.`on_homepage`, `RelatedProduct`.`hide_background_image`, `RelatedProduct`.`hide_background_image_on_mobile`, `RelatedProduct`.`show_options_as_dropdown`, `RelatedProduct`.`qualifies_for_gravelx_upsell`, `RelatedProduct`.`show_gravelx_aside`, `RelatedProduct`.`upsell_specific_sizes`, `RelatedProduct`.`is_active`, `RelatedProduct`.`is_removed`, `RelatedProduct`.`created`, `RelatedProduct`.`modified`, `RelatedItem`.`id`, `RelatedItem`.`model`, `RelatedItem`.`model_id`, `RelatedItem`.`related_model`, `RelatedItem`.`related_model_id`, `RelatedItem`.`sequence`, `RelatedItem`.`created`, `RelatedItem`.`modified` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_products` AS `RelatedProduct` JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_related_items_related_items` AS `RelatedItem` ON (`RelatedItem`.`model_id` = 48 AND `RelatedItem`.`related_model_id` = `RelatedProduct`.`id`) WHERE `RelatedProduct`.`is_active` = '1' AND `model` = 'Product' AND `related_model` = 'Product' AND `is_active` = '1' ORDER BY `sequence` ASC | 5 | 5 | 1 | maybe slow |
SELECT `MetaData`.`id`, `MetaData`.`model`, `MetaData`.`model_id`, `MetaData`.`title`, `MetaData`.`description`, `MetaData`.`keywords`, `MetaData`.`created`, `MetaData`.`modified` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`meta_data` AS `MetaData` WHERE ((`model` = 'Product') AND (`model_id` = 48)) | 1 | 1 | 0 | |
SELECT `Route`.`id`, `Route`.`alias`, `Route`.`actual` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`routes` AS `Route` WHERE `Route`.`actual` = 'app_products/view/48' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Postcode`.`id`, `Postcode`.`outcode` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`postcodes` AS `Postcode` WHERE `outcode` LIKE 'DE4' LIMIT 1 | 1 | 1 | 0 | |
SELECT `ShippingCompany`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_companies` AS `ShippingCompany` WHERE `is_active` = '1' AND `pricing_only` = '1' | 0 | 0 | 0 | |
SELECT `ShippingCost`.*, `ShippingCompany`.*, IF(cost IS NULL AND shipping_company_id <> 7, -1, 0) AS nullswitch, `ShippingCompany`.`id`, `Plant`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_costs` AS `ShippingCost` LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_companies` AS `ShippingCompany` ON (`ShippingCost`.`shipping_company_id` = `ShippingCompany`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`plants` AS `Plant` ON (`ShippingCost`.`plant_id` = `Plant`.`id`) WHERE `Plant`.`is_active` = '1' AND `ShippingCompany`.`is_active` = '1' AND `postcode_id` = 663 AND `plant_id` = 9 AND ((`cost` >= 0) OR (`cost` IS NULL)) AND NOT (`shipping_company_id` IS NULL) AND `shipping_company_id` != 6 ORDER BY `nullswitch` DESC, `cost` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `Postcode`.`id`, `Postcode`.`outcode` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`postcodes` AS `Postcode` WHERE `outcode` LIKE 'DE4' LIMIT 1 | 1 | 1 | 0 | |
SELECT `ShippingCompany`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_companies` AS `ShippingCompany` WHERE `is_active` = '1' AND `pricing_only` = '1' | 0 | 0 | 0 | |
SELECT `ShippingCost`.*, `ShippingCompany`.*, IF(cost IS NULL AND shipping_company_id <> 7, -1, 0) AS nullswitch, `ShippingCompany`.`id`, `Plant`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_costs` AS `ShippingCost` LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_companies` AS `ShippingCompany` ON (`ShippingCost`.`shipping_company_id` = `ShippingCompany`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`plants` AS `Plant` ON (`ShippingCost`.`plant_id` = `Plant`.`id`) WHERE `Plant`.`is_active` = '1' AND `ShippingCompany`.`is_active` = '1' AND `postcode_id` = 663 AND `plant_id` = 9 AND ((`cost` >= 0) OR (`cost` IS NULL)) AND NOT (`shipping_company_id` IS NULL) AND `shipping_company_id` != 6 ORDER BY `nullswitch` DESC, `cost` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `ProductVariant`.*, `VatRate`.*, `Product`.`excludes_vat`, IF(Product.excludes_vat=1,ProductVariant.price*((VatRate.rate/100)+1),ProductVariant.price) AS calculatedprice, IF(Product.excludes_vat<>1,ProductVariant.price/((VatRate.rate/100)+1),ProductVariant.price) AS exvat, `ProductVariant`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_variants` AS `ProductVariant` left JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_products` AS `Product` ON (`ProductVariant`.`product_id` = `Product`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options_product_variants` AS `ProductAttributeOptionsVariants` ON (`ProductVariant`.`id` = `ProductAttributeOptionsVariants`.`product_variant_id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOption` ON (`ProductAttributeOptionsVariants`.`product_attribute_option_id` = `ProductAttributeOption`.`id`) left JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_checkout_vat_rates` AS `VatRate` ON (`Product`.`vat_rate_id` = `VatRate`.`id`) WHERE `ProductVariant`.`product_id` = 48 AND `ProductVariant`.`is_removed` <> '1' | 12 | 12 | 1 | maybe slow |
SELECT `ProductAttributeOption`.`id`, `ProductAttributeOption`.`product_attribute_id`, `ProductAttributeOption`.`name`, `ProductAttributeOption`.`description`, `ProductAttributeOption`.`sequence`, `ProductAttributeOption`.`created`, `ProductAttributeOption`.`modified`, `EvShopProductAttributeOptionsProductVariant`.`id`, `EvShopProductAttributeOptionsProductVariant`.`product_attribute_option_id`, `EvShopProductAttributeOptionsProductVariant`.`product_variant_id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOption` JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options_product_variants` AS `EvShopProductAttributeOptionsProductVariant` ON (`EvShopProductAttributeOptionsProductVariant`.`product_variant_id` IN (741, 742, 744, 746, 818, 2023) AND `EvShopProductAttributeOptionsProductVariant`.`product_attribute_option_id` = `ProductAttributeOption`.`id`) WHERE `ProductAttributeOption`.`id` IN (129, 7, 120, 118, 55, 56, 8, 114, 123, 111, 9, 122, 110, 121, 11, 82, 57, 58, 53, 81, 80, 86, 117, 119, 124, 115, 42, 102, 101, 96, 95, 98, 97, 100, 99, 73, 14, 116, 104, 36, 37, 30, 31, 32, 18, 60, 107, 19, 106, 22, 92, 93, 94, 17, 16, 83, 23, 125, 126, 127, 128, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143) | 6 | 6 | 1 | maybe slow |
SELECT `ProductAttributeOptions`.`name`, `ProductAttributeOptions`.`description`, `Product`.`excludes_vat`, `VatRate`.`rate`, `ProductVariant`.`online_price`, IF(Product.excludes_vat=1,ProductVariant.price*((VatRate.rate/100)+1),ProductVariant.price) AS calculatedprice, IF(Product.excludes_vat<>1,ProductVariant.price/((VatRate.rate/100)+1),ProductVariant.price) AS exvat, IF(ProductAttributeOptions.description LIKE "%forceprice%", 2, -1) AS force_price, IF(ProductAttributeOptions.description LIKE "%default%", 1, 0) AS is_default, IF(ProductAttributeOptions.description LIKE "%nosurcharge%", 0, 1) AS has_surcharge, IF(ProductAttributeOptions.description LIKE "%separatesurcharge%", 0, 1) AS separate_surcharge, IF(ProductAttributeOptions.description LIKE "%fromprice%", 1, 0) AS from_price, IF(ProductAttributeOptions.description LIKE "%poa%", 1, 0) AS is_poa FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_variants` AS `ProductVariant` LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options_product_variants` AS `ProductAttributeOptionsVariants` ON (`ProductVariant`.`id` = `ProductAttributeOptionsVariants`.`product_variant_id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOptions` ON (`ProductAttributeOptionsVariants`.`product_attribute_option_id` = `ProductAttributeOptions`.`id`) left JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_products` AS `Product` ON (`ProductVariant`.`product_id` = `Product`.`id`) left JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_checkout_vat_rates` AS `VatRate` ON (`Product`.`vat_rate_id` = `VatRate`.`id`) WHERE `ProductVariant`.`product_id` = 48 AND `ProductVariant`.`is_removed` = '0' AND `ProductVariant`.`price` IS NOT NULL AND `ProductVariant`.`price` > 0 AND ((`ProductAttributeOptions`.`description` LIKE '%\"main\"%') OR (`ProductAttributeOptions`.`description` LIKE '%\"default\"%')) ORDER BY `force_price` DESC, `is_default` ASC, `calculatedprice` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `FreeItem`.`id`, `FreeItem`.`name`, `FreeItem`.`dropdown_text`, `FreeItem`.`body`, `FreeItem`.`date_from`, `FreeItem`.`date_to`, `FreeItem`.`created`, `FreeItem`.`modified`, `FreeItem`.`is_active`, (DATE_FORMAT(date_from, "%D %M %Y")) AS `FreeItem__date_from_nice`, (DATE_FORMAT(date_to, "%D %M %Y")) AS `FreeItem__date_to_nice` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`free_items` AS `FreeItem` JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`free_item_source_products` AS `SourceProductVariant` ON (`FreeItem`.`id` = `SourceProductVariant`.`free_item_id`) JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`free_item_target_products` AS `TargetProductVariant` ON (`FreeItem`.`id` = `TargetProductVariant`.`free_item_id`) JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_variants` AS `ProductVariant` ON (`TargetProductVariant`.`product_variant_id` = `ProductVariant`.`id` AND`ProductVariant`.`is_removed` = 0 AND (`ProductVariant`.`unlimited_stock` = 1 OR `ProductVariant`.`stock` > 0)) JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_products` AS `Product` ON (`ProductVariant`.`product_id` = `Product`.`id` AND`Product`.`is_active` = 1 AND`Product`.`is_removed` = 0 AND`Product`.`display_only` = 0 AND`Product`.`admin_only` = 0) WHERE `SourceProductVariant`.`product_variant_id` = ('2034') AND `FreeItem`.`date_from` <= '2024-11-22 23:58:15' AND `FreeItem`.`date_to` >= '2024-11-22 23:58:15' AND `FreeItem`.`is_active` = '1' | 0 | 0 | 1 | maybe slow |
SELECT `Menu`.`id`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`name`, `Menu`.`url`, `Menu`.`pattern`, `Menu`.`plugin`, `Menu`.`controller`, `Menu`.`model`, `Menu`.`model_id`, `Menu`.`action`, `Menu`.`class`, `Menu`.`new_window`, `Menu`.`is_menu_hidden`, `Menu`.`is_active`, `Menu`.`created`, `Menu`.`modified`, `Menu`.`user_group_id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`menus` AS `Menu` WHERE `Menu`.`id` = 7 ORDER BY `lft` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `Menu`.`id`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`name`, `Menu`.`url`, `Menu`.`pattern`, `Menu`.`plugin`, `Menu`.`controller`, `Menu`.`model`, `Menu`.`model_id`, `Menu`.`action`, `Menu`.`class`, `Menu`.`new_window`, `Menu`.`is_menu_hidden`, `Menu`.`is_active`, `Menu`.`created`, `Menu`.`modified`, `Menu`.`user_group_id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`menus` AS `Menu` WHERE `lft` > 92 AND `rght` < 115 AND `is_active` = '1' ORDER BY `lft` ASC | 11 | 11 | 1 | maybe slow |
SELECT `Product`.`id`, `Product`.`plant_id`, `Product`.`force_shipping_company_id`, `Product`.`name`, `Product`.`internal_title`, `Product`.`subtitle`, `Product`.`SKU`, `Product`.`lead_time`, `Product`.`excludes_vat`, `Product`.`vat_rate_id`, `Product`.`use_size_price`, `Product`.`calculator_size`, `Product`.`aggregate_size_id`, `Product`.`homepage_text`, `Product`.`description`, `Product`.`expanded_text`, `Product`.`additional_title`, `Product`.`additional_text`, `Product`.`additional_button_title`, `Product`.`additional_button_url`, `Product`.`aside_title`, `Product`.`aside_text`, `Product`.`mix_design`, `Product`.`technical_spec`, `Product`.`addon_products_text`, `Product`.`suitable_for`, `Product`.`not_suitable_for`, `Product`.`sash_colour_id`, `Product`.`sash_message_id`, `Product`.`no_gravel_calculator`, `Product`.`display_only`, `Product`.`admin_only`, `Product`.`flag_order`, `Product`.`nofollow`, `Product`.`is_grouped_product`, `Product`.`no_loose_load_message`, `Product`.`google_feed_title`, `Product`.`google_feed_description`, `Product`.`exclude_from_feed`, `Product`.`is_featured`, `Product`.`on_homepage`, `Product`.`hide_background_image`, `Product`.`hide_background_image_on_mobile`, `Product`.`show_options_as_dropdown`, `Product`.`qualifies_for_gravelx_upsell`, `Product`.`show_gravelx_aside`, `Product`.`upsell_specific_sizes`, `Product`.`is_active`, `Product`.`is_removed`, `Product`.`created`, `Product`.`modified` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_products` AS `Product` WHERE `id` = 5 AND `is_active` = '1' ORDER BY `Product`.`modified` DESC | 1 | 1 | 1 | |
SELECT `ListingImage`.`id`, `ListingImage`.`model`, `ListingImage`.`model_id`, `ListingImage`.`filename`, `ListingImage`.`attachment_type`, `ListingImage`.`alt`, `ListingImage`.`title`, `ListingImage`.`caption`, `ListingImage`.`link_text`, `ListingImage`.`link_url`, `ListingImage`.`products`, `ListingImage`.`body`, `ListingImage`.`type`, `ListingImage`.`size`, `ListingImage`.`dir`, `ListingImage`.`sequence`, `ListingImage`.`is_active`, `ListingImage`.`created`, `ListingImage`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `ListingImage__filepath` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`images` AS `ListingImage` WHERE `model` = 'Product' AND `attachment_type` = 'ListingImage' AND `ListingImage`.`model_id` = (5) | 1 | 1 | 0 | |
SELECT `MetaData`.`id`, `MetaData`.`model`, `MetaData`.`model_id`, `MetaData`.`title`, `MetaData`.`description`, `MetaData`.`keywords`, `MetaData`.`created`, `MetaData`.`modified` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`meta_data` AS `MetaData` WHERE ((`model` = 'Product') AND (`model_id` = 5)) | 2 | 2 | 0 | |
SELECT `Category`.* FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_related_items_related_items` AS `RelatedItem` JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_category_categories` AS `Category` ON (`RelatedItem`.`related_model_id` = `Category`.`id`) WHERE `RelatedItem`.`model` = 'Product' AND `RelatedItem`.`model_id` = 5 AND `RelatedItem`.`related_model` = 'Category' | 11 | 11 | 2 | maybe slow |
SELECT `Postcode`.`id`, `Postcode`.`outcode` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`postcodes` AS `Postcode` WHERE `outcode` LIKE 'DE4' LIMIT 1 | 1 | 1 | 0 | |
SELECT `ShippingCompany`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_companies` AS `ShippingCompany` WHERE `is_active` = '1' AND `pricing_only` = '1' | 0 | 0 | 0 | |
SELECT `ShippingCost`.*, `ShippingCompany`.*, IF(cost IS NULL AND shipping_company_id <> 7, -1, 0) AS nullswitch, `ShippingCompany`.`id`, `Plant`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_costs` AS `ShippingCost` LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_companies` AS `ShippingCompany` ON (`ShippingCost`.`shipping_company_id` = `ShippingCompany`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`plants` AS `Plant` ON (`ShippingCost`.`plant_id` = `Plant`.`id`) WHERE `Plant`.`is_active` = '1' AND `ShippingCompany`.`is_active` = '1' AND `postcode_id` = 663 AND `plant_id` = 9 AND ((`cost` >= 0) OR (`cost` IS NULL)) AND NOT (`shipping_company_id` IS NULL) AND `shipping_company_id` != 6 ORDER BY `nullswitch` DESC, `cost` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `Postcode`.`id`, `Postcode`.`outcode` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`postcodes` AS `Postcode` WHERE `outcode` LIKE 'DE4' LIMIT 1 | 1 | 1 | 0 | |
SELECT `ShippingCompany`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_companies` AS `ShippingCompany` WHERE `is_active` = '1' AND `pricing_only` = '1' | 0 | 0 | 0 | |
SELECT `ShippingCost`.*, `ShippingCompany`.*, IF(cost IS NULL AND shipping_company_id <> 7, -1, 0) AS nullswitch, `ShippingCompany`.`id`, `Plant`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_costs` AS `ShippingCost` LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_companies` AS `ShippingCompany` ON (`ShippingCost`.`shipping_company_id` = `ShippingCompany`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`plants` AS `Plant` ON (`ShippingCost`.`plant_id` = `Plant`.`id`) WHERE `Plant`.`is_active` = '1' AND `ShippingCompany`.`is_active` = '1' AND `postcode_id` = 663 AND `plant_id` = 9 AND ((`cost` >= 0) OR (`cost` IS NULL)) AND NOT (`shipping_company_id` IS NULL) AND `shipping_company_id` != 6 ORDER BY `nullswitch` DESC, `cost` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `Page`.`id`, `Page`.`accent_colour_id`, `Page`.`title`, `Page`.`internal_title`, `Page`.`body`, `Page`.`hide_background_image`, `Page`.`hide_background_image_on_mobile`, `Page`.`is_active`, `Page`.`is_protected`, `Page`.`view_template`, `Page`.`created`, `Page`.`modified` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`pages` AS `Page` WHERE `Page`.`internal_title` = 'blog' LIMIT 1 | 0 | 0 | 0 | |
50 duplicate queries run.