| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `SiteSetting`.`id`, `SiteSetting`.`label`, `SiteSetting`.`name`, `SiteSetting`.`type`, `SiteSetting`.`value`, `SiteSetting`.`sequence`, `SiteSetting`.`site_setting_category_id`, `SiteSetting`.`created`, `SiteSetting`.`modified` FROM `cd_decorative_aggregates_daltex_uat`.`site_settings` AS `SiteSetting` WHERE 1 = 1 ORDER BY `SiteSetting`.`name` ASC | 21 | 21 | 1 | |
| SELECT `AppOrderStatus`.`system_name`, `AppOrderStatus`.`id` FROM `cd_decorative_aggregates_daltex_uat`.`ev_checkout_order_statuses` AS `AppOrderStatus` WHERE 1 = 1 | 16 | 16 | 0 | |
| SELECT `Site`.`id`, `Site`.`name`, `Site`.`invoice_name`, `Site`.`url`, `Site`.`theme`, `Site`.`order_prefix`, `Site`.`next_day_delivery`, `Site`.`saturday_delivery`, `Site`.`am_delivery`, `Site`.`base_pallet_limit`, `Site`.`early_am_delivery`, `Site`.`early_am_cutoff`, `Site`.`early_am_cutoff_admin`, `Site`.`excel_delivery`, `Site`.`excel_next_day_delivery`, `Site`.`excel_saturday_delivery`, `Site`.`loose_load_message`, `Site`.`postcode_changed_message`, `Site`.`print_confirmation_text`, `Site`.`permanent_site_message`, `Site`.`questions_panel_heading`, `Site`.`questions_panel_text`, `Site`.`footer_copyright`, `Site`.`opening_hours`, `Site`.`vat_registration_info`, `Site`.`footer_text`, `Site`.`email_header`, `Site`.`email_text`, `Site`.`email_footer`, `Site`.`dispatch_email_text`, `Site`.`confirmation_email_from`, `Site`.`invoice_email_from`, `Site`.`vat_display`, `Site`.`top_bar_population`, `Site`.`site_primary_category_id`, `Site`.`created`, `Site`.`modified`, `Site`.`is_active`, `Site`.`uses_pegasus_opera`, `Site`.`delivery_instructions_disclaimer`, `Site`.`delivery_cutoff_warning_before`, `Site`.`delivery_cutoff_warning_after`, `Site`.`next_day_not_available`, `Site`.`free_day_now_costs`, `Site`.`delivery_cutoff_time`, `Site`.`delivery_cutoff_time_customer`, `Site`.`alter_postcode_at_basket_cta_text`, `Site`.`separate_haulage_surcharge`, `Site`.`check_pallet_availability` FROM `cd_decorative_aggregates_daltex_uat`.`sites` AS `Site` WHERE `url` LIKE '%daltex.uat2.evoluted.net%' LIMIT 1 | 0 | 0 | 1 | maybe slow |
| SELECT `Site`.`id`, `Site`.`name`, `Site`.`invoice_name`, `Site`.`url`, `Site`.`theme`, `Site`.`order_prefix`, `Site`.`next_day_delivery`, `Site`.`saturday_delivery`, `Site`.`am_delivery`, `Site`.`base_pallet_limit`, `Site`.`early_am_delivery`, `Site`.`early_am_cutoff`, `Site`.`early_am_cutoff_admin`, `Site`.`excel_delivery`, `Site`.`excel_next_day_delivery`, `Site`.`excel_saturday_delivery`, `Site`.`loose_load_message`, `Site`.`postcode_changed_message`, `Site`.`print_confirmation_text`, `Site`.`permanent_site_message`, `Site`.`questions_panel_heading`, `Site`.`questions_panel_text`, `Site`.`footer_copyright`, `Site`.`opening_hours`, `Site`.`vat_registration_info`, `Site`.`footer_text`, `Site`.`email_header`, `Site`.`email_text`, `Site`.`email_footer`, `Site`.`dispatch_email_text`, `Site`.`confirmation_email_from`, `Site`.`invoice_email_from`, `Site`.`vat_display`, `Site`.`top_bar_population`, `Site`.`site_primary_category_id`, `Site`.`created`, `Site`.`modified`, `Site`.`is_active`, `Site`.`uses_pegasus_opera`, `Site`.`delivery_instructions_disclaimer`, `Site`.`delivery_cutoff_warning_before`, `Site`.`delivery_cutoff_warning_after`, `Site`.`next_day_not_available`, `Site`.`free_day_now_costs`, `Site`.`delivery_cutoff_time`, `Site`.`delivery_cutoff_time_customer`, `Site`.`alter_postcode_at_basket_cta_text`, `Site`.`separate_haulage_surcharge`, `Site`.`check_pallet_availability` FROM `cd_decorative_aggregates_daltex_uat`.`sites` AS `Site` WHERE 1 = 1 LIMIT 1 | 1 | 1 | 1 | |
| SELECT `Order`.`id`, `Order`.`original_id`, `Order`.`site_id`, `Order`.`shopify_id`, `Order`.`shopify_name`, `Order`.`created`, `Order`.`modified`, `Order`.`order_time`, `Order`.`dispatch_date`, `Order`.`delivery_date`, `Order`.`invoice_date`, `Order`.`am_delivery`, `Order`.`early_am_delivery`, `Order`.`excel_delivery`, `Order`.`payment_method`, `Order`.`purchase_order`, `Order`.`is_next_day`, `Order`.`is_prepaid`, `Order`.`prepaid_method`, `Order`.`prepaid_total`, `Order`.`user_id`, `Order`.`first_name`, `Order`.`last_name`, `Order`.`company`, `Order`.`phone`, `Order`.`phone_2`, `Order`.`email`, `Order`.`email_2`, `Order`.`opt_in_email`, `Order`.`opt_in_post`, `Order`.`opt_in_telephone`, `Order`.`is_homeowner`, `Order`.`processed_by`, `Order`.`basket_postcode`, `Order`.`delivery_address_id`, `Order`.`invoice_address_id`, `Order`.`order_status_id`, `Order`.`is_paid`, `Order`.`subtotal`, `Order`.`delivery_subtotal`, `Order`.`delivery_subtotal_override`, `Order`.`delivery_vat`, `Order`.`delivery_total`, `Order`.`true_delivery_subtotal`, `Order`.`true_delivery_vat`, `Order`.`true_delivery_total`, `Order`.`surcharge_subtotal`, `Order`.`surcharge_subtotal_override`, `Order`.`surcharge_vat`, `Order`.`surcharge_total`, `Order`.`vat`, `Order`.`discount_code`, `Order`.`discount_vat`, `Order`.`discount_total`, `Order`.`total`, `Order`.`items_total`, `Order`.`is_virtual`, `Order`.`online_eligible`, `Order`.`delivery_method_id`, `Order`.`collection_location_id`, `Order`.`order_instructions`, `Order`.`delivery_instructions`, `Order`.`delivery_instructions_approved`, `Order`.`attention_postcode_approved`, `Order`.`scotland_postcode_approved`, `Order`.`delivery_flat_surface`, `Order`.`send_dispatch_email`, `Order`.`send_invoice_email`, `Order`.`invoice_email_sent`, `Order`.`confirmation_email_sent`, `Order`.`has_issues_haulage`, `Order`.`is_manifested`, `Order`.`is_dispatch_now`, `Order`.`print_copy_count`, `Order`.`gclid`, `Order`.`opera_export_time`, `Order`.`admin_notes`, `Order`.`admin_edited`, `Order`.`pallet_snapshot`, `Order`.`in_cm`, `Order`.`trade_discount`, `Order`.`use_online_prices`, `Order`.`cancellation_reason_id`, `Order`.`cancellation_reason_other`, (CONCAT(`Order`.`first_name`, " ", `Order`.`last_name`)) AS `Order__full_name`, (CONCAT("#", LPAD(`Order`.`id`, 7, 0))) AS `Order__invoice_number`, (CAST(( `Order`.`subtotal` + `Order`.`vat` + `Order`.`discount_vat` - `Order`.`delivery_vat` - `Order`.`surcharge_vat`) AS DECIMAL(7,2))) AS `Order__subtotal_inc_vat`, (CAST(( `Order`.`discount_total` * (1 + (`Order`.`vat` + `Order`.`discount_vat` - `Order`.`delivery_vat` - `Order`.`surcharge_vat`) / `Order`.`subtotal`)) AS DECIMAL(7,2))) AS `Order__discount_inc_vat`, `DeliveryAddress`.`id`, `DeliveryAddress`.`user_id`, `DeliveryAddress`.`house_number`, `DeliveryAddress`.`po_box`, `DeliveryAddress`.`company`, `DeliveryAddress`.`address_line_1`, `DeliveryAddress`.`address_line_2`, `DeliveryAddress`.`address_line_3`, `DeliveryAddress`.`city`, `DeliveryAddress`.`county`, `DeliveryAddress`.`postcode`, `DeliveryAddress`.`is_active`, `DeliveryAddress`.`is_pegasus_opera`, `DeliveryAddress`.`last_used_for_invoice`, `DeliveryAddress`.`last_used_for_delivery`, `InvoiceAddress`.`id`, `InvoiceAddress`.`user_id`, `InvoiceAddress`.`house_number`, `InvoiceAddress`.`po_box`, `InvoiceAddress`.`company`, `InvoiceAddress`.`address_line_1`, `InvoiceAddress`.`address_line_2`, `InvoiceAddress`.`address_line_3`, `InvoiceAddress`.`city`, `InvoiceAddress`.`county`, `InvoiceAddress`.`postcode`, `InvoiceAddress`.`is_active`, `InvoiceAddress`.`is_pegasus_opera`, `InvoiceAddress`.`last_used_for_invoice`, `InvoiceAddress`.`last_used_for_delivery`, `Site`.`id`, `Site`.`name`, `Site`.`invoice_name`, `Site`.`url`, `Site`.`theme`, `Site`.`order_prefix`, `Site`.`next_day_delivery`, `Site`.`saturday_delivery`, `Site`.`am_delivery`, `Site`.`base_pallet_limit`, `Site`.`early_am_delivery`, `Site`.`early_am_cutoff`, `Site`.`early_am_cutoff_admin`, `Site`.`excel_delivery`, `Site`.`excel_next_day_delivery`, `Site`.`excel_saturday_delivery`, `Site`.`loose_load_message`, `Site`.`postcode_changed_message`, `Site`.`print_confirmation_text`, `Site`.`permanent_site_message`, `Site`.`questions_panel_heading`, `Site`.`questions_panel_text`, `Site`.`footer_copyright`, `Site`.`opening_hours`, `Site`.`vat_registration_info`, `Site`.`footer_text`, `Site`.`email_header`, `Site`.`email_text`, `Site`.`email_footer`, `Site`.`dispatch_email_text`, `Site`.`confirmation_email_from`, `Site`.`invoice_email_from`, `Site`.`vat_display`, `Site`.`top_bar_population`, `Site`.`site_primary_category_id`, `Site`.`created`, `Site`.`modified`, `Site`.`is_active`, `Site`.`uses_pegasus_opera`, `Site`.`delivery_instructions_disclaimer`, `Site`.`delivery_cutoff_warning_before`, `Site`.`delivery_cutoff_warning_after`, `Site`.`next_day_not_available`, `Site`.`free_day_now_costs`, `Site`.`delivery_cutoff_time`, `Site`.`delivery_cutoff_time_customer`, `Site`.`alter_postcode_at_basket_cta_text`, `Site`.`separate_haulage_surcharge`, `Site`.`check_pallet_availability` FROM `cd_decorative_aggregates_daltex_uat`.`ev_checkout_orders` AS `Order` LEFT JOIN `cd_decorative_aggregates_daltex_uat`.`ev_checkout_customer_addresses` AS `DeliveryAddress` ON (`Order`.`delivery_address_id` = `DeliveryAddress`.`id`) LEFT JOIN `cd_decorative_aggregates_daltex_uat`.`ev_checkout_customer_addresses` AS `InvoiceAddress` ON (`Order`.`invoice_address_id` = `InvoiceAddress`.`id`) LEFT JOIN `cd_decorative_aggregates_daltex_uat`.`sites` AS `Site` ON (`Order`.`site_id` = `Site`.`id`) WHERE `Order`.`id` IS NULL AND `Order`.`order_status_id` IN (1, 15) ORDER BY `Order`.`created` DESC LIMIT 1 | 0 | 0 | 1 | maybe slow |
| SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires` FROM `cd_decorative_aggregates_daltex_uat`.`cake_sessions` AS `Session` WHERE `id` = 'r7eanshfjnb9pq02i8hf7hq2b6' LIMIT 1 | 0 | 0 | 0 | |
| 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_daltex_uat`.`pages` AS `Page` WHERE `Page`.`id` = 19 LIMIT 1 | 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_daltex_uat`.`meta_data` AS `MetaData` WHERE ((`model` = 'Page') AND (`model_id` = 19)) | 1 | 1 | 0 | |
| SELECT `NoDelivery`.`id`, `NoDelivery`.`date` FROM `cd_decorative_aggregates_daltex_uat`.`no_deliveries` AS `NoDelivery` WHERE `is_active` = '1' | 133 | 133 | 1 | |
| SELECT `NoDelivery`.`id`, `NoDelivery`.`date` FROM `cd_decorative_aggregates_daltex_uat`.`no_deliveries` AS `NoDelivery` WHERE `is_active` = '1' | 133 | 133 | 1 | |
| SELECT `NoDelivery`.`id`, `NoDelivery`.`date` FROM `cd_decorative_aggregates_daltex_uat`.`no_deliveries` AS `NoDelivery` WHERE `can_dispatch` = '0' AND `is_active` = '1' | 133 | 133 | 0 | |
| 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_daltex_uat`.`pages` AS `Page` WHERE `Page`.`id` = 45 LIMIT 1 | 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_daltex_uat`.`meta_data` AS `MetaData` WHERE ((`model` = 'Page') AND (`model_id` = 45)) | 2 | 2 | 1 | maybe slow |
| 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_daltex_uat`.`pages` AS `Page` WHERE `Page`.`id` = 45 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `HomepageBlocksImage`.`id`, `HomepageBlocksImage`.`model`, `HomepageBlocksImage`.`model_id`, `HomepageBlocksImage`.`filename`, `HomepageBlocksImage`.`attachment_type`, `HomepageBlocksImage`.`alt`, `HomepageBlocksImage`.`title`, `HomepageBlocksImage`.`caption`, `HomepageBlocksImage`.`link_text`, `HomepageBlocksImage`.`link_url`, `HomepageBlocksImage`.`products`, `HomepageBlocksImage`.`body`, `HomepageBlocksImage`.`type`, `HomepageBlocksImage`.`size`, `HomepageBlocksImage`.`dir`, `HomepageBlocksImage`.`sequence`, `HomepageBlocksImage`.`is_active`, `HomepageBlocksImage`.`created`, `HomepageBlocksImage`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `HomepageBlocksImage__filepath` FROM `cd_decorative_aggregates_daltex_uat`.`images` AS `HomepageBlocksImage` WHERE `model` = 'Page' AND `attachment_type` = 'HomepageBlocksImage' AND `HomepageBlocksImage`.`model_id` = (45) ORDER BY `sequence` ASC | 0 | 0 | 1 | maybe slow |
| SELECT `ActionBlocksImage`.`id`, `ActionBlocksImage`.`model`, `ActionBlocksImage`.`model_id`, `ActionBlocksImage`.`filename`, `ActionBlocksImage`.`attachment_type`, `ActionBlocksImage`.`alt`, `ActionBlocksImage`.`title`, `ActionBlocksImage`.`caption`, `ActionBlocksImage`.`link_text`, `ActionBlocksImage`.`link_url`, `ActionBlocksImage`.`products`, `ActionBlocksImage`.`body`, `ActionBlocksImage`.`type`, `ActionBlocksImage`.`size`, `ActionBlocksImage`.`dir`, `ActionBlocksImage`.`sequence`, `ActionBlocksImage`.`is_active`, `ActionBlocksImage`.`created`, `ActionBlocksImage`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `ActionBlocksImage__filepath` FROM `cd_decorative_aggregates_daltex_uat`.`images` AS `ActionBlocksImage` WHERE `model` = 'Page' AND `attachment_type` = 'ActionBlocksImage' AND `ActionBlocksImage`.`model_id` = (45) ORDER BY `sequence` ASC | 0 | 0 | 0 | |
| SELECT `FeatureBlocksImage`.`id`, `FeatureBlocksImage`.`model`, `FeatureBlocksImage`.`model_id`, `FeatureBlocksImage`.`filename`, `FeatureBlocksImage`.`attachment_type`, `FeatureBlocksImage`.`alt`, `FeatureBlocksImage`.`title`, `FeatureBlocksImage`.`caption`, `FeatureBlocksImage`.`link_text`, `FeatureBlocksImage`.`link_url`, `FeatureBlocksImage`.`products`, `FeatureBlocksImage`.`body`, `FeatureBlocksImage`.`type`, `FeatureBlocksImage`.`size`, `FeatureBlocksImage`.`dir`, `FeatureBlocksImage`.`sequence`, `FeatureBlocksImage`.`is_active`, `FeatureBlocksImage`.`created`, `FeatureBlocksImage`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `FeatureBlocksImage__filepath` FROM `cd_decorative_aggregates_daltex_uat`.`images` AS `FeatureBlocksImage` WHERE `model` = 'Page' AND `attachment_type` = 'FeatureBlocksImage' AND `FeatureBlocksImage`.`model_id` = (45) ORDER BY `sequence` ASC | 0 | 0 | 0 | |
| SELECT `PreviewImage`.`id`, `PreviewImage`.`model`, `PreviewImage`.`model_id`, `PreviewImage`.`filename`, `PreviewImage`.`attachment_type`, `PreviewImage`.`alt`, `PreviewImage`.`title`, `PreviewImage`.`caption`, `PreviewImage`.`link_text`, `PreviewImage`.`link_url`, `PreviewImage`.`products`, `PreviewImage`.`body`, `PreviewImage`.`type`, `PreviewImage`.`size`, `PreviewImage`.`dir`, `PreviewImage`.`sequence`, `PreviewImage`.`is_active`, `PreviewImage`.`created`, `PreviewImage`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `PreviewImage__filepath` FROM `cd_decorative_aggregates_daltex_uat`.`images` AS `PreviewImage` WHERE `model` = 'Page' AND `attachment_type` = 'PreviewImage' AND `PreviewImage`.`model_id` = (45) ORDER BY `sequence` ASC | 0 | 0 | 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_daltex_uat`.`images` AS `BackgroundImage` WHERE `model` = 'Page' AND `attachment_type` = 'BackgroundImage' AND `BackgroundImage`.`model_id` = (45) ORDER BY `sequence` ASC | 0 | 0 | 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_daltex_uat`.`images` AS `ListingImage` WHERE `model` = 'Page' AND `attachment_type` = 'ListingImage' AND `ListingImage`.`model_id` = (45) 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_daltex_uat`.`images` AS `Image` WHERE `model` = 'Page' AND `attachment_type` = 'Image' AND `Image`.`model_id` = (45) ORDER BY `sequence` ASC | 0 | 0 | 0 | |
| SELECT `TrainingImage`.`id`, `TrainingImage`.`model`, `TrainingImage`.`model_id`, `TrainingImage`.`filename`, `TrainingImage`.`attachment_type`, `TrainingImage`.`alt`, `TrainingImage`.`title`, `TrainingImage`.`caption`, `TrainingImage`.`link_text`, `TrainingImage`.`link_url`, `TrainingImage`.`products`, `TrainingImage`.`body`, `TrainingImage`.`type`, `TrainingImage`.`size`, `TrainingImage`.`dir`, `TrainingImage`.`sequence`, `TrainingImage`.`is_active`, `TrainingImage`.`created`, `TrainingImage`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `TrainingImage__filepath` FROM `cd_decorative_aggregates_daltex_uat`.`images` AS `TrainingImage` WHERE `model` = 'Page' AND `attachment_type` = 'TrainingImage' AND `TrainingImage`.`model_id` = (45) ORDER BY `sequence` ASC | 0 | 0 | 0 | |
| SELECT `KnowledgeImage`.`id`, `KnowledgeImage`.`model`, `KnowledgeImage`.`model_id`, `KnowledgeImage`.`filename`, `KnowledgeImage`.`attachment_type`, `KnowledgeImage`.`alt`, `KnowledgeImage`.`title`, `KnowledgeImage`.`caption`, `KnowledgeImage`.`link_text`, `KnowledgeImage`.`link_url`, `KnowledgeImage`.`products`, `KnowledgeImage`.`body`, `KnowledgeImage`.`type`, `KnowledgeImage`.`size`, `KnowledgeImage`.`dir`, `KnowledgeImage`.`sequence`, `KnowledgeImage`.`is_active`, `KnowledgeImage`.`created`, `KnowledgeImage`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `KnowledgeImage__filepath` FROM `cd_decorative_aggregates_daltex_uat`.`images` AS `KnowledgeImage` WHERE `model` = 'Page' AND `attachment_type` = 'KnowledgeImage' AND `KnowledgeImage`.`model_id` = (45) ORDER BY `sequence` ASC | 0 | 0 | 0 | |
| SELECT `AboutBlocksImage`.`id`, `AboutBlocksImage`.`model`, `AboutBlocksImage`.`model_id`, `AboutBlocksImage`.`filename`, `AboutBlocksImage`.`attachment_type`, `AboutBlocksImage`.`alt`, `AboutBlocksImage`.`title`, `AboutBlocksImage`.`caption`, `AboutBlocksImage`.`link_text`, `AboutBlocksImage`.`link_url`, `AboutBlocksImage`.`products`, `AboutBlocksImage`.`body`, `AboutBlocksImage`.`type`, `AboutBlocksImage`.`size`, `AboutBlocksImage`.`dir`, `AboutBlocksImage`.`sequence`, `AboutBlocksImage`.`is_active`, `AboutBlocksImage`.`created`, `AboutBlocksImage`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `AboutBlocksImage__filepath` FROM `cd_decorative_aggregates_daltex_uat`.`images` AS `AboutBlocksImage` WHERE `model` = 'Page' AND `attachment_type` = 'AboutBlocksImage' AND `AboutBlocksImage`.`model_id` = (45) ORDER BY `sequence` ASC | 0 | 0 | 0 | |
| SELECT `TradeBannerImage`.`id`, `TradeBannerImage`.`model`, `TradeBannerImage`.`model_id`, `TradeBannerImage`.`filename`, `TradeBannerImage`.`attachment_type`, `TradeBannerImage`.`alt`, `TradeBannerImage`.`title`, `TradeBannerImage`.`caption`, `TradeBannerImage`.`link_text`, `TradeBannerImage`.`link_url`, `TradeBannerImage`.`products`, `TradeBannerImage`.`body`, `TradeBannerImage`.`type`, `TradeBannerImage`.`size`, `TradeBannerImage`.`dir`, `TradeBannerImage`.`sequence`, `TradeBannerImage`.`is_active`, `TradeBannerImage`.`created`, `TradeBannerImage`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `TradeBannerImage__filepath` FROM `cd_decorative_aggregates_daltex_uat`.`images` AS `TradeBannerImage` WHERE `model` = 'Page' AND `attachment_type` = 'TradeBannerImage' AND `TradeBannerImage`.`model_id` = (45) ORDER BY `sequence` ASC | 0 | 0 | 0 | |
| SELECT `TradeBlocksImage`.`id`, `TradeBlocksImage`.`model`, `TradeBlocksImage`.`model_id`, `TradeBlocksImage`.`filename`, `TradeBlocksImage`.`attachment_type`, `TradeBlocksImage`.`alt`, `TradeBlocksImage`.`title`, `TradeBlocksImage`.`caption`, `TradeBlocksImage`.`link_text`, `TradeBlocksImage`.`link_url`, `TradeBlocksImage`.`products`, `TradeBlocksImage`.`body`, `TradeBlocksImage`.`type`, `TradeBlocksImage`.`size`, `TradeBlocksImage`.`dir`, `TradeBlocksImage`.`sequence`, `TradeBlocksImage`.`is_active`, `TradeBlocksImage`.`created`, `TradeBlocksImage`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `TradeBlocksImage__filepath` FROM `cd_decorative_aggregates_daltex_uat`.`images` AS `TradeBlocksImage` WHERE `model` = 'Page' AND `attachment_type` = 'TradeBlocksImage' AND `TradeBlocksImage`.`model_id` = (45) ORDER BY `sequence` ASC | 0 | 0 | 1 | maybe slow |
| SELECT `ContentBlocksImage`.`id`, `ContentBlocksImage`.`model`, `ContentBlocksImage`.`model_id`, `ContentBlocksImage`.`filename`, `ContentBlocksImage`.`attachment_type`, `ContentBlocksImage`.`alt`, `ContentBlocksImage`.`title`, `ContentBlocksImage`.`caption`, `ContentBlocksImage`.`link_text`, `ContentBlocksImage`.`link_url`, `ContentBlocksImage`.`products`, `ContentBlocksImage`.`body`, `ContentBlocksImage`.`type`, `ContentBlocksImage`.`size`, `ContentBlocksImage`.`dir`, `ContentBlocksImage`.`sequence`, `ContentBlocksImage`.`is_active`, `ContentBlocksImage`.`created`, `ContentBlocksImage`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `ContentBlocksImage__filepath` FROM `cd_decorative_aggregates_daltex_uat`.`images` AS `ContentBlocksImage` WHERE `model` = 'Page' AND `attachment_type` = 'ContentBlocksImage' AND `ContentBlocksImage`.`model_id` = (45) ORDER BY `sequence` ASC | 0 | 0 | 0 | |
| SELECT `GalleryImage`.`id`, `GalleryImage`.`model`, `GalleryImage`.`model_id`, `GalleryImage`.`filename`, `GalleryImage`.`attachment_type`, `GalleryImage`.`alt`, `GalleryImage`.`title`, `GalleryImage`.`caption`, `GalleryImage`.`link_text`, `GalleryImage`.`link_url`, `GalleryImage`.`products`, `GalleryImage`.`body`, `GalleryImage`.`type`, `GalleryImage`.`size`, `GalleryImage`.`dir`, `GalleryImage`.`sequence`, `GalleryImage`.`is_active`, `GalleryImage`.`created`, `GalleryImage`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `GalleryImage__filepath` FROM `cd_decorative_aggregates_daltex_uat`.`images` AS `GalleryImage` WHERE `model` = 'Page' AND `attachment_type` = 'GalleryImage' AND `GalleryImage`.`model_id` = (45) ORDER BY `sequence` ASC | 0 | 0 | 0 | |
| SELECT `5050blocksImage`.`id`, `5050blocksImage`.`model`, `5050blocksImage`.`model_id`, `5050blocksImage`.`filename`, `5050blocksImage`.`attachment_type`, `5050blocksImage`.`alt`, `5050blocksImage`.`title`, `5050blocksImage`.`caption`, `5050blocksImage`.`link_text`, `5050blocksImage`.`link_url`, `5050blocksImage`.`products`, `5050blocksImage`.`body`, `5050blocksImage`.`type`, `5050blocksImage`.`size`, `5050blocksImage`.`dir`, `5050blocksImage`.`sequence`, `5050blocksImage`.`is_active`, `5050blocksImage`.`created`, `5050blocksImage`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `5050blocksImage__filepath` FROM `cd_decorative_aggregates_daltex_uat`.`images` AS `5050blocksImage` WHERE `model` = 'Page' AND `attachment_type` = '5050blocksImage' AND `5050blocksImage`.`model_id` = (45) ORDER BY `sequence` ASC | 0 | 0 | 0 | |
| SELECT `5050visualiserImage`.`id`, `5050visualiserImage`.`model`, `5050visualiserImage`.`model_id`, `5050visualiserImage`.`filename`, `5050visualiserImage`.`attachment_type`, `5050visualiserImage`.`alt`, `5050visualiserImage`.`title`, `5050visualiserImage`.`caption`, `5050visualiserImage`.`link_text`, `5050visualiserImage`.`link_url`, `5050visualiserImage`.`products`, `5050visualiserImage`.`body`, `5050visualiserImage`.`type`, `5050visualiserImage`.`size`, `5050visualiserImage`.`dir`, `5050visualiserImage`.`sequence`, `5050visualiserImage`.`is_active`, `5050visualiserImage`.`created`, `5050visualiserImage`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `5050visualiserImage__filepath` FROM `cd_decorative_aggregates_daltex_uat`.`images` AS `5050visualiserImage` WHERE `model` = 'Page' AND `attachment_type` = '5050visualiserImage' AND `5050visualiserImage`.`model_id` = (45) ORDER BY `sequence` ASC | 0 | 0 | 0 | |
| SELECT `InlineImage`.`id`, `InlineImage`.`model`, `InlineImage`.`model_id`, `InlineImage`.`filename`, `InlineImage`.`attachment_type`, `InlineImage`.`alt`, `InlineImage`.`title`, `InlineImage`.`caption`, `InlineImage`.`link_text`, `InlineImage`.`link_url`, `InlineImage`.`products`, `InlineImage`.`body`, `InlineImage`.`type`, `InlineImage`.`size`, `InlineImage`.`dir`, `InlineImage`.`sequence`, `InlineImage`.`is_active`, `InlineImage`.`created`, `InlineImage`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `InlineImage__filepath` FROM `cd_decorative_aggregates_daltex_uat`.`images` AS `InlineImage` WHERE `model` = 'Page' AND `attachment_type` = 'InlineImage' AND `InlineImage`.`model_id` = (45) ORDER BY `sequence` ASC | 0 | 0 | 0 | |
| SELECT `MetaData`.`id`, `MetaData`.`model`, `MetaData`.`model_id`, `MetaData`.`title`, `MetaData`.`description`, `MetaData`.`keywords`, `MetaData`.`created`, `MetaData`.`modified` FROM `cd_decorative_aggregates_daltex_uat`.`meta_data` AS `MetaData` WHERE ((`model` = 'Page') AND (`model_id` = 45)) | 2 | 2 | 0 | |
| SELECT `Route`.`id`, `Route`.`alias`, `Route`.`actual` FROM `cd_decorative_aggregates_daltex_uat`.`routes` AS `Route` WHERE `Route`.`actual` = 'pages/view/45' 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_daltex_uat`.`menus` AS `Menu` WHERE `model` = 'Page' AND `model_id` = 45 ORDER BY `lft` ASC LIMIT 1 | 0 | 0 | 1 | maybe slow |
| SELECT `Product`.`id`, `Product`.`shopify_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`.`no_loose_load_message`, `Product`.`google_feed_title`, `Product`.`google_feed_description`, `Product`.`exclude_from_feed`, `Product`.`is_poa`, `Product`.`display_only`, `Product`.`admin_only`, `Product`.`flag_order`, `Product`.`nofollow`, `Product`.`is_grouped_product`, `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`.`show_samples_configurator`, `Product`.`upsell_specific_sizes`, `Product`.`is_active`, `Product`.`is_removed`, `Product`.`created`, `Product`.`modified` FROM `cd_decorative_aggregates_daltex_uat`.`ev_shop_products` AS `Product` JOIN `cd_decorative_aggregates_daltex_uat`.`aggregate_sizes` AS `AggregateSize` ON (`Product`.`aggregate_size_id` = `AggregateSize`.`id`) JOIN `cd_decorative_aggregates_daltex_uat`.`ev_shop_product_variants` AS `ProductVariant` ON (`Product`.`id` = `ProductVariant`.`product_id`) WHERE `Product`.`is_active` = '1' AND `AggregateSize`.`name` = '2-5mm' ORDER BY `ProductVariant`.`price` ASC LIMIT 1 | 1 | 1 | 31 | maybe slow |
| SELECT `MetaData`.`id`, `MetaData`.`model`, `MetaData`.`model_id`, `MetaData`.`title`, `MetaData`.`description`, `MetaData`.`keywords`, `MetaData`.`created`, `MetaData`.`modified` FROM `cd_decorative_aggregates_daltex_uat`.`meta_data` AS `MetaData` WHERE ((`model` = 'Product') AND (`model_id` = 142)) | 5 | 5 | 1 | maybe slow |
| SELECT `Product`.`id`, `Product`.`shopify_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`.`no_loose_load_message`, `Product`.`google_feed_title`, `Product`.`google_feed_description`, `Product`.`exclude_from_feed`, `Product`.`is_poa`, `Product`.`display_only`, `Product`.`admin_only`, `Product`.`flag_order`, `Product`.`nofollow`, `Product`.`is_grouped_product`, `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`.`show_samples_configurator`, `Product`.`upsell_specific_sizes`, `Product`.`is_active`, `Product`.`is_removed`, `Product`.`created`, `Product`.`modified` FROM `cd_decorative_aggregates_daltex_uat`.`ev_shop_products` AS `Product` JOIN `cd_decorative_aggregates_daltex_uat`.`aggregate_sizes` AS `AggregateSize` ON (`Product`.`aggregate_size_id` = `AggregateSize`.`id`) JOIN `cd_decorative_aggregates_daltex_uat`.`ev_shop_product_variants` AS `ProductVariant` ON (`Product`.`id` = `ProductVariant`.`product_id`) WHERE `Product`.`is_active` = '1' AND `AggregateSize`.`name` = '1-3mm' ORDER BY `ProductVariant`.`price` ASC LIMIT 1 | 1 | 1 | 3 | maybe slow |
| SELECT `MetaData`.`id`, `MetaData`.`model`, `MetaData`.`model_id`, `MetaData`.`title`, `MetaData`.`description`, `MetaData`.`keywords`, `MetaData`.`created`, `MetaData`.`modified` FROM `cd_decorative_aggregates_daltex_uat`.`meta_data` AS `MetaData` WHERE ((`model` = 'Product') AND (`model_id` = 321)) | 1 | 1 | 15 | maybe slow |
| SELECT `Product`.`id`, `Product`.`shopify_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`.`no_loose_load_message`, `Product`.`google_feed_title`, `Product`.`google_feed_description`, `Product`.`exclude_from_feed`, `Product`.`is_poa`, `Product`.`display_only`, `Product`.`admin_only`, `Product`.`flag_order`, `Product`.`nofollow`, `Product`.`is_grouped_product`, `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`.`show_samples_configurator`, `Product`.`upsell_specific_sizes`, `Product`.`is_active`, `Product`.`is_removed`, `Product`.`created`, `Product`.`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_daltex_uat`.`ev_shop_products` AS `Product` LEFT JOIN `cd_decorative_aggregates_daltex_uat`.`sash_colours` AS `SashColour` ON (`Product`.`sash_colour_id` = `SashColour`.`id`) LEFT JOIN `cd_decorative_aggregates_daltex_uat`.`sash_messages` AS `SashMessage` ON (`Product`.`sash_message_id` = `SashMessage`.`id`) LEFT JOIN `cd_decorative_aggregates_daltex_uat`.`aggregate_sizes` AS `AggregateSize` ON (`Product`.`aggregate_size_id` = `AggregateSize`.`id`) WHERE `Product`.`id` IN (463, 464, 316, 440, 441, 142, 321, 461) ORDER BY `Product`.`modified` DESC | 8 | 8 | 19 | maybe slow |
| 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_daltex_uat`.`images` AS `ListingImage` WHERE `model` = 'Product' AND `attachment_type` = 'ListingImage' AND `ListingImage`.`model_id` IN (142, 321, 461, 464, 440, 463, 316, 441) | 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_daltex_uat`.`meta_data` AS `MetaData` WHERE ((((`model` = 'Product') AND (`model_id` = 142))) OR (((`model` = 'Product') AND (`model_id` = 321))) OR (((`model` = 'Product') AND (`model_id` = 461))) OR (((`model` = 'Product') AND (`model_id` = 464))) OR (((`model` = 'Product') AND (`model_id` = 440))) OR (((`model` = 'Product') AND (`model_id` = 463))) OR (((`model` = 'Product') AND (`model_id` = 316))) OR (((`model` = 'Product') AND (`model_id` = 441)))) | 12 | 12 | 1 | maybe slow |
| SELECT `ProductAttributeOption`.`id` FROM `cd_decorative_aggregates_daltex_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOption` WHERE `product_attribute_id` = 3 ORDER BY `sequence` ASC | 134 | 134 | 2 | |
| SELECT `ProductVariant`.`id` FROM `cd_decorative_aggregates_daltex_uat`.`ev_shop_product_variants` AS `ProductVariant` WHERE `ProductVariant`.`product_id` = 142 | 5 | 5 | 0 | |
| SELECT `UserPrice`.`product_variant_id`, `UserPrice`.`price` FROM `cd_decorative_aggregates_daltex_uat`.`user_prices` AS `UserPrice` WHERE `UserPrice`.`user_id` IS NULL AND `UserPrice`.`product_variant_id` IN (1793, 1795, 1796, 2093, 2177) | 0 | 0 | 1 | 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_daltex_uat`.`ev_shop_product_variants` AS `ProductVariant` left JOIN `cd_decorative_aggregates_daltex_uat`.`ev_shop_products` AS `Product` ON (`ProductVariant`.`product_id` = `Product`.`id`) LEFT JOIN `cd_decorative_aggregates_daltex_uat`.`ev_shop_product_attribute_options_product_variants` AS `ProductAttributeOptionsVariants` ON (`ProductVariant`.`id` = `ProductAttributeOptionsVariants`.`product_variant_id`) LEFT JOIN `cd_decorative_aggregates_daltex_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOption` ON (`ProductAttributeOptionsVariants`.`product_attribute_option_id` = `ProductAttributeOption`.`id`) left JOIN `cd_decorative_aggregates_daltex_uat`.`ev_checkout_vat_rates` AS `VatRate` ON (`Product`.`vat_rate_id` = `VatRate`.`id`) WHERE `ProductVariant`.`product_id` = 142 AND `ProductVariant`.`is_removed` <> '1' | 4 | 4 | 2 | 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_daltex_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOption` JOIN `cd_decorative_aggregates_daltex_uat`.`ev_shop_product_attribute_options_product_variants` AS `EvShopProductAttributeOptionsProductVariant` ON (`EvShopProductAttributeOptionsProductVariant`.`product_variant_id` IN (1793, 1795, 1796, 2177) AND `EvShopProductAttributeOptionsProductVariant`.`product_attribute_option_id` = `ProductAttributeOption`.`id`) WHERE `ProductAttributeOption`.`id` IN (83, 93, 89, 94, 84, 102, 103, 104, 105, 106, 107, 85, 108, 109, 110, 111, 92, 90, 91, 95, 101, 99, 97, 100, 98, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 148, 149, 150, 151, 152, 153, 154, 155, 156, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 205, 206, 207, 208, 209, 211, 212, 213, 214, 215, 216, 217, 218, 219, 220, 221, 222, 223, 226) | 4 | 4 | 2 | maybe slow |
| SELECT `Order`.`id`, `Order`.`original_id`, `Order`.`site_id`, `Order`.`shopify_id`, `Order`.`shopify_name`, `Order`.`created`, `Order`.`modified`, `Order`.`order_time`, `Order`.`dispatch_date`, `Order`.`delivery_date`, `Order`.`invoice_date`, `Order`.`am_delivery`, `Order`.`early_am_delivery`, `Order`.`excel_delivery`, `Order`.`payment_method`, `Order`.`purchase_order`, `Order`.`is_next_day`, `Order`.`is_prepaid`, `Order`.`prepaid_method`, `Order`.`prepaid_total`, `Order`.`user_id`, `Order`.`first_name`, `Order`.`last_name`, `Order`.`company`, `Order`.`phone`, `Order`.`phone_2`, `Order`.`email`, `Order`.`email_2`, `Order`.`opt_in_email`, `Order`.`opt_in_post`, `Order`.`opt_in_telephone`, `Order`.`is_homeowner`, `Order`.`processed_by`, `Order`.`basket_postcode`, `Order`.`delivery_address_id`, `Order`.`invoice_address_id`, `Order`.`order_status_id`, `Order`.`is_paid`, `Order`.`subtotal`, `Order`.`delivery_subtotal`, `Order`.`delivery_subtotal_override`, `Order`.`delivery_vat`, `Order`.`delivery_total`, `Order`.`true_delivery_subtotal`, `Order`.`true_delivery_vat`, `Order`.`true_delivery_total`, `Order`.`surcharge_subtotal`, `Order`.`surcharge_subtotal_override`, `Order`.`surcharge_vat`, `Order`.`surcharge_total`, `Order`.`vat`, `Order`.`discount_code`, `Order`.`discount_vat`, `Order`.`discount_total`, `Order`.`total`, `Order`.`items_total`, `Order`.`is_virtual`, `Order`.`online_eligible`, `Order`.`delivery_method_id`, `Order`.`collection_location_id`, `Order`.`order_instructions`, `Order`.`delivery_instructions`, `Order`.`delivery_instructions_approved`, `Order`.`attention_postcode_approved`, `Order`.`scotland_postcode_approved`, `Order`.`delivery_flat_surface`, `Order`.`send_dispatch_email`, `Order`.`send_invoice_email`, `Order`.`invoice_email_sent`, `Order`.`confirmation_email_sent`, `Order`.`has_issues_haulage`, `Order`.`is_manifested`, `Order`.`is_dispatch_now`, `Order`.`print_copy_count`, `Order`.`gclid`, `Order`.`opera_export_time`, `Order`.`admin_notes`, `Order`.`admin_edited`, `Order`.`pallet_snapshot`, `Order`.`in_cm`, `Order`.`trade_discount`, `Order`.`use_online_prices`, `Order`.`cancellation_reason_id`, `Order`.`cancellation_reason_other`, (CONCAT(`Order`.`first_name`, " ", `Order`.`last_name`)) AS `Order__full_name`, (CONCAT("#", LPAD(`Order`.`id`, 7, 0))) AS `Order__invoice_number`, (CAST(( `Order`.`subtotal` + `Order`.`vat` + `Order`.`discount_vat` - `Order`.`delivery_vat` - `Order`.`surcharge_vat`) AS DECIMAL(7,2))) AS `Order__subtotal_inc_vat`, (CAST(( `Order`.`discount_total` * (1 + (`Order`.`vat` + `Order`.`discount_vat` - `Order`.`delivery_vat` - `Order`.`surcharge_vat`) / `Order`.`subtotal`)) AS DECIMAL(7,2))) AS `Order__discount_inc_vat`, `DeliveryAddress`.`id`, `DeliveryAddress`.`user_id`, `DeliveryAddress`.`house_number`, `DeliveryAddress`.`po_box`, `DeliveryAddress`.`company`, `DeliveryAddress`.`address_line_1`, `DeliveryAddress`.`address_line_2`, `DeliveryAddress`.`address_line_3`, `DeliveryAddress`.`city`, `DeliveryAddress`.`county`, `DeliveryAddress`.`postcode`, `DeliveryAddress`.`is_active`, `DeliveryAddress`.`is_pegasus_opera`, `DeliveryAddress`.`last_used_for_invoice`, `DeliveryAddress`.`last_used_for_delivery`, `InvoiceAddress`.`id`, `InvoiceAddress`.`user_id`, `InvoiceAddress`.`house_number`, `InvoiceAddress`.`po_box`, `InvoiceAddress`.`company`, `InvoiceAddress`.`address_line_1`, `InvoiceAddress`.`address_line_2`, `InvoiceAddress`.`address_line_3`, `InvoiceAddress`.`city`, `InvoiceAddress`.`county`, `InvoiceAddress`.`postcode`, `InvoiceAddress`.`is_active`, `InvoiceAddress`.`is_pegasus_opera`, `InvoiceAddress`.`last_used_for_invoice`, `InvoiceAddress`.`last_used_for_delivery`, `Site`.`id`, `Site`.`name`, `Site`.`invoice_name`, `Site`.`url`, `Site`.`theme`, `Site`.`order_prefix`, `Site`.`next_day_delivery`, `Site`.`saturday_delivery`, `Site`.`am_delivery`, `Site`.`base_pallet_limit`, `Site`.`early_am_delivery`, `Site`.`early_am_cutoff`, `Site`.`early_am_cutoff_admin`, `Site`.`excel_delivery`, `Site`.`excel_next_day_delivery`, `Site`.`excel_saturday_delivery`, `Site`.`loose_load_message`, `Site`.`postcode_changed_message`, `Site`.`print_confirmation_text`, `Site`.`permanent_site_message`, `Site`.`questions_panel_heading`, `Site`.`questions_panel_text`, `Site`.`footer_copyright`, `Site`.`opening_hours`, `Site`.`vat_registration_info`, `Site`.`footer_text`, `Site`.`email_header`, `Site`.`email_text`, `Site`.`email_footer`, `Site`.`dispatch_email_text`, `Site`.`confirmation_email_from`, `Site`.`invoice_email_from`, `Site`.`vat_display`, `Site`.`top_bar_population`, `Site`.`site_primary_category_id`, `Site`.`created`, `Site`.`modified`, `Site`.`is_active`, `Site`.`uses_pegasus_opera`, `Site`.`delivery_instructions_disclaimer`, `Site`.`delivery_cutoff_warning_before`, `Site`.`delivery_cutoff_warning_after`, `Site`.`next_day_not_available`, `Site`.`free_day_now_costs`, `Site`.`delivery_cutoff_time`, `Site`.`delivery_cutoff_time_customer`, `Site`.`alter_postcode_at_basket_cta_text`, `Site`.`separate_haulage_surcharge`, `Site`.`check_pallet_availability` FROM `cd_decorative_aggregates_daltex_uat`.`ev_checkout_orders` AS `Order` LEFT JOIN `cd_decorative_aggregates_daltex_uat`.`ev_checkout_customer_addresses` AS `DeliveryAddress` ON (`Order`.`delivery_address_id` = `DeliveryAddress`.`id`) LEFT JOIN `cd_decorative_aggregates_daltex_uat`.`ev_checkout_customer_addresses` AS `InvoiceAddress` ON (`Order`.`invoice_address_id` = `InvoiceAddress`.`id`) LEFT JOIN `cd_decorative_aggregates_daltex_uat`.`sites` AS `Site` ON (`Order`.`site_id` = `Site`.`id`) WHERE `Order`.`id` IS NULL AND `Order`.`order_status_id` IN (1, 15) ORDER BY `Order`.`created` DESC LIMIT 1 | 0 | 0 | 1 | maybe slow |
| SELECT `Postcode`.`id`, `Postcode`.`outcode` FROM `cd_decorative_aggregates_daltex_uat`.`postcodes` AS `Postcode` WHERE `outcode` LIKE 'DE4' LIMIT 1 | 1 | 1 | 10 | maybe slow |
| SELECT `ShippingCompany`.`id` FROM `cd_decorative_aggregates_daltex_uat`.`shipping_companies` AS `ShippingCompany` WHERE `is_active` = '1' AND `pricing_only` = '1' | 1 | 1 | 0 | |
| SELECT `ShippingCost`.*, IF(cost IS NULL AND shipping_company_id <> 7, -1, 0) AS nullswitch, `ShippingCompany`.`id`, `Plant`.`id` FROM `cd_decorative_aggregates_daltex_uat`.`shipping_costs` AS `ShippingCost` LEFT JOIN `cd_decorative_aggregates_daltex_uat`.`shipping_companies` AS `ShippingCompany` ON (`ShippingCost`.`shipping_company_id` = `ShippingCompany`.`id`) LEFT JOIN `cd_decorative_aggregates_daltex_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` = 8 AND ((`cost` >= 0) OR (`cost` IS NULL)) AND shipping_company_id = (11) ORDER BY `nullswitch` DESC, `cost` ASC LIMIT 1 | 1 | 1 | 650 | maybe slow |
| SELECT `ProductAttributeOptions`.`name`, `ProductAttributeOptions`.`description`, `Product`.`excludes_vat`, `VatRate`.`rate`, `ProductVariant`.`online_price`, IF(Product.excludes_vat=1,IF(UserPrice.price IS NOT NULL, UserPrice.price, ProductVariant.price)*((VatRate.rate/100)+1),IF(UserPrice.price IS NOT NULL, UserPrice.price, ProductVariant.price)) AS calculatedprice, IF(Product.excludes_vat<>1,IF(UserPrice.price IS NOT NULL, UserPrice.price, ProductVariant.price)/((VatRate.rate/100)+1),IF(UserPrice.price IS NOT NULL, UserPrice.price, 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_daltex_uat`.`ev_shop_product_variants` AS `ProductVariant` LEFT JOIN `cd_decorative_aggregates_daltex_uat`.`ev_shop_product_attribute_options_product_variants` AS `ProductAttributeOptionsVariants` ON (`ProductVariant`.`id` = `ProductAttributeOptionsVariants`.`product_variant_id`) LEFT JOIN `cd_decorative_aggregates_daltex_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOptions` ON (`ProductAttributeOptionsVariants`.`product_attribute_option_id` = `ProductAttributeOptions`.`id`) left JOIN `cd_decorative_aggregates_daltex_uat`.`ev_shop_products` AS `Product` ON (`ProductVariant`.`product_id` = `Product`.`id`) left JOIN `cd_decorative_aggregates_daltex_uat`.`ev_checkout_vat_rates` AS `VatRate` ON (`Product`.`vat_rate_id` = `VatRate`.`id`) left JOIN `cd_decorative_aggregates_daltex_uat`.`user_prices` AS `UserPrice` ON (`ProductVariant`.`id` = `UserPrice`.`product_variant_id` AND `UserPrice`.`user_id` IS NULL) WHERE `ProductVariant`.`product_id` = 142 AND `ProductVariant`.`is_removed` = '0' AND `ProductVariant`.`price` IS NOT NULL AND `ProductVariant`.`price` > 0 AND ((`ProductAttributeOptions`.`description` LIKE '%\"single_bag_25\"%') OR (`ProductAttributeOptions`.`description` LIKE '%\"default\"%')) ORDER BY `force_price` DESC, `is_default` ASC, `calculatedprice` ASC LIMIT 1 | 1 | 1 | 1 | |
| SELECT `Postcode`.`id`, `Postcode`.`outcode` FROM `cd_decorative_aggregates_daltex_uat`.`postcodes` AS `Postcode` WHERE `outcode` LIKE 'DE4' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ShippingCompany`.`id` FROM `cd_decorative_aggregates_daltex_uat`.`shipping_companies` AS `ShippingCompany` WHERE `is_active` = '1' AND `pricing_only` = '1' | 1 | 1 | 0 | |
| SELECT `ShippingCost`.*, IF(cost IS NULL AND shipping_company_id <> 7, -1, 0) AS nullswitch, `ShippingCompany`.`id`, `Plant`.`id` FROM `cd_decorative_aggregates_daltex_uat`.`shipping_costs` AS `ShippingCost` LEFT JOIN `cd_decorative_aggregates_daltex_uat`.`shipping_companies` AS `ShippingCompany` ON (`ShippingCost`.`shipping_company_id` = `ShippingCompany`.`id`) LEFT JOIN `cd_decorative_aggregates_daltex_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` = 8 AND ((`cost` >= 0) OR (`cost` IS NULL)) AND shipping_company_id = (11) ORDER BY `nullswitch` DESC, `cost` ASC LIMIT 1 | 1 | 1 | 1 | |
| SELECT `Postcode`.`id`, `Postcode`.`outcode` FROM `cd_decorative_aggregates_daltex_uat`.`postcodes` AS `Postcode` WHERE `outcode` LIKE 'DE4' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ShippingCompany`.`id` FROM `cd_decorative_aggregates_daltex_uat`.`shipping_companies` AS `ShippingCompany` WHERE `is_active` = '1' AND `pricing_only` = '1' | 1 | 1 | 0 | |
| SELECT `ShippingCost`.*, IF(cost IS NULL AND shipping_company_id <> 7, -1, 0) AS nullswitch, `ShippingCompany`.`id`, `Plant`.`id` FROM `cd_decorative_aggregates_daltex_uat`.`shipping_costs` AS `ShippingCost` LEFT JOIN `cd_decorative_aggregates_daltex_uat`.`shipping_companies` AS `ShippingCompany` ON (`ShippingCost`.`shipping_company_id` = `ShippingCompany`.`id`) LEFT JOIN `cd_decorative_aggregates_daltex_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` = 8 AND ((`cost` >= 0) OR (`cost` IS NULL)) AND shipping_company_id = (11) ORDER BY `nullswitch` DESC, `cost` ASC LIMIT 1 | 1 | 1 | 1 | |
| SELECT `Postcode`.`id`, `Postcode`.`outcode` FROM `cd_decorative_aggregates_daltex_uat`.`postcodes` AS `Postcode` WHERE `outcode` LIKE 'DE4' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ShippingCompany`.`id` FROM `cd_decorative_aggregates_daltex_uat`.`shipping_companies` AS `ShippingCompany` WHERE `is_active` = '1' AND `pricing_only` = '1' | 1 | 1 | 0 | |
| SELECT `ShippingCost`.*, IF(cost IS NULL AND shipping_company_id <> 7, -1, 0) AS nullswitch, `ShippingCompany`.`id`, `Plant`.`id` FROM `cd_decorative_aggregates_daltex_uat`.`shipping_costs` AS `ShippingCost` LEFT JOIN `cd_decorative_aggregates_daltex_uat`.`shipping_companies` AS `ShippingCompany` ON (`ShippingCost`.`shipping_company_id` = `ShippingCompany`.`id`) LEFT JOIN `cd_decorative_aggregates_daltex_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` = 8 AND ((`cost` >= 0) OR (`cost` IS NULL)) AND shipping_company_id = (11) ORDER BY `nullswitch` DESC, `cost` ASC LIMIT 1 | 1 | 1 | 1 | |
| SELECT `ProductVariant`.`id` FROM `cd_decorative_aggregates_daltex_uat`.`ev_shop_product_variants` AS `ProductVariant` WHERE `ProductVariant`.`product_id` = 321 | 5 | 5 | 0 | |
| SELECT `UserPrice`.`product_variant_id`, `UserPrice`.`price` FROM `cd_decorative_aggregates_daltex_uat`.`user_prices` AS `UserPrice` WHERE `UserPrice`.`user_id` IS NULL AND `UserPrice`.`product_variant_id` IN (2129, 2130, 2176, 2208, 2209) | 0 | 0 | 0 | |
| 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_daltex_uat`.`ev_shop_product_variants` AS `ProductVariant` left JOIN `cd_decorative_aggregates_daltex_uat`.`ev_shop_products` AS `Product` ON (`ProductVariant`.`product_id` = `Product`.`id`) LEFT JOIN `cd_decorative_aggregates_daltex_uat`.`ev_shop_product_attribute_options_product_variants` AS `ProductAttributeOptionsVariants` ON (`ProductVariant`.`id` = `ProductAttributeOptionsVariants`.`product_variant_id`) LEFT JOIN `cd_decorative_aggregates_daltex_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOption` ON (`ProductAttributeOptionsVariants`.`product_attribute_option_id` = `ProductAttributeOption`.`id`) left JOIN `cd_decorative_aggregates_daltex_uat`.`ev_checkout_vat_rates` AS `VatRate` ON (`Product`.`vat_rate_id` = `VatRate`.`id`) WHERE `ProductVariant`.`product_id` = 321 AND `ProductVariant`.`is_removed` <> '1' | 3 | 3 | 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_daltex_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOption` JOIN `cd_decorative_aggregates_daltex_uat`.`ev_shop_product_attribute_options_product_variants` AS `EvShopProductAttributeOptionsProductVariant` ON (`EvShopProductAttributeOptionsProductVariant`.`product_variant_id` IN (2130, 2208, 2209) AND `EvShopProductAttributeOptionsProductVariant`.`product_attribute_option_id` = `ProductAttributeOption`.`id`) WHERE `ProductAttributeOption`.`id` IN (83, 93, 89, 94, 84, 102, 103, 104, 105, 106, 107, 85, 108, 109, 110, 111, 92, 90, 91, 95, 101, 99, 97, 100, 98, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 148, 149, 150, 151, 152, 153, 154, 155, 156, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 205, 206, 207, 208, 209, 211, 212, 213, 214, 215, 216, 217, 218, 219, 220, 221, 222, 223, 226) | 3 | 3 | 2 | maybe slow |
| SELECT `Postcode`.`id`, `Postcode`.`outcode` FROM `cd_decorative_aggregates_daltex_uat`.`postcodes` AS `Postcode` WHERE `outcode` LIKE 'DE4' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ShippingCompany`.`id` FROM `cd_decorative_aggregates_daltex_uat`.`shipping_companies` AS `ShippingCompany` WHERE `is_active` = '1' AND `pricing_only` = '1' | 1 | 1 | 0 | |
| SELECT `ShippingCost`.*, IF(cost IS NULL AND shipping_company_id <> 7, -1, 0) AS nullswitch, `ShippingCompany`.`id`, `Plant`.`id` FROM `cd_decorative_aggregates_daltex_uat`.`shipping_costs` AS `ShippingCost` LEFT JOIN `cd_decorative_aggregates_daltex_uat`.`shipping_companies` AS `ShippingCompany` ON (`ShippingCost`.`shipping_company_id` = `ShippingCompany`.`id`) LEFT JOIN `cd_decorative_aggregates_daltex_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` = 8 AND ((`cost` >= 0) OR (`cost` IS NULL)) AND shipping_company_id = (11) ORDER BY `nullswitch` DESC, `cost` ASC LIMIT 1 | 1 | 1 | 1 | |
| SELECT `ProductAttributeOptions`.`name`, `ProductAttributeOptions`.`description`, `Product`.`excludes_vat`, `VatRate`.`rate`, `ProductVariant`.`online_price`, IF(Product.excludes_vat=1,IF(UserPrice.price IS NOT NULL, UserPrice.price, ProductVariant.price)*((VatRate.rate/100)+1),IF(UserPrice.price IS NOT NULL, UserPrice.price, ProductVariant.price)) AS calculatedprice, IF(Product.excludes_vat<>1,IF(UserPrice.price IS NOT NULL, UserPrice.price, ProductVariant.price)/((VatRate.rate/100)+1),IF(UserPrice.price IS NOT NULL, UserPrice.price, 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_daltex_uat`.`ev_shop_product_variants` AS `ProductVariant` LEFT JOIN `cd_decorative_aggregates_daltex_uat`.`ev_shop_product_attribute_options_product_variants` AS `ProductAttributeOptionsVariants` ON (`ProductVariant`.`id` = `ProductAttributeOptionsVariants`.`product_variant_id`) LEFT JOIN `cd_decorative_aggregates_daltex_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOptions` ON (`ProductAttributeOptionsVariants`.`product_attribute_option_id` = `ProductAttributeOptions`.`id`) left JOIN `cd_decorative_aggregates_daltex_uat`.`ev_shop_products` AS `Product` ON (`ProductVariant`.`product_id` = `Product`.`id`) left JOIN `cd_decorative_aggregates_daltex_uat`.`ev_checkout_vat_rates` AS `VatRate` ON (`Product`.`vat_rate_id` = `VatRate`.`id`) left JOIN `cd_decorative_aggregates_daltex_uat`.`user_prices` AS `UserPrice` ON (`ProductVariant`.`id` = `UserPrice`.`product_variant_id` AND `UserPrice`.`user_id` IS NULL) WHERE `ProductVariant`.`product_id` = 321 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 `Postcode`.`id`, `Postcode`.`outcode` FROM `cd_decorative_aggregates_daltex_uat`.`postcodes` AS `Postcode` WHERE `outcode` LIKE 'DE4' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ShippingCompany`.`id` FROM `cd_decorative_aggregates_daltex_uat`.`shipping_companies` AS `ShippingCompany` WHERE `is_active` = '1' AND `pricing_only` = '1' | 1 | 1 | 0 | |
| SELECT `ShippingCost`.*, IF(cost IS NULL AND shipping_company_id <> 7, -1, 0) AS nullswitch, `ShippingCompany`.`id`, `Plant`.`id` FROM `cd_decorative_aggregates_daltex_uat`.`shipping_costs` AS `ShippingCost` LEFT JOIN `cd_decorative_aggregates_daltex_uat`.`shipping_companies` AS `ShippingCompany` ON (`ShippingCost`.`shipping_company_id` = `ShippingCompany`.`id`) LEFT JOIN `cd_decorative_aggregates_daltex_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` = 8 AND ((`cost` >= 0) OR (`cost` IS NULL)) AND shipping_company_id = (11) ORDER BY `nullswitch` DESC, `cost` ASC LIMIT 1 | 1 | 1 | 1 | |
| SELECT `Postcode`.`id`, `Postcode`.`outcode` FROM `cd_decorative_aggregates_daltex_uat`.`postcodes` AS `Postcode` WHERE `outcode` LIKE 'DE4' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ShippingCompany`.`id` FROM `cd_decorative_aggregates_daltex_uat`.`shipping_companies` AS `ShippingCompany` WHERE `is_active` = '1' AND `pricing_only` = '1' | 1 | 1 | 0 | |
| SELECT `ShippingCost`.*, IF(cost IS NULL AND shipping_company_id <> 7, -1, 0) AS nullswitch, `ShippingCompany`.`id`, `Plant`.`id` FROM `cd_decorative_aggregates_daltex_uat`.`shipping_costs` AS `ShippingCost` LEFT JOIN `cd_decorative_aggregates_daltex_uat`.`shipping_companies` AS `ShippingCompany` ON (`ShippingCost`.`shipping_company_id` = `ShippingCompany`.`id`) LEFT JOIN `cd_decorative_aggregates_daltex_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` = 8 AND ((`cost` >= 0) OR (`cost` IS NULL)) AND shipping_company_id = (11) ORDER BY `nullswitch` DESC, `cost` ASC LIMIT 1 | 1 | 1 | 1 | |
| SELECT `ProductVariant`.`id` FROM `cd_decorative_aggregates_daltex_uat`.`ev_shop_product_variants` AS `ProductVariant` WHERE `ProductVariant`.`product_id` = 461 | 10 | 10 | 0 | |
| SELECT `UserPrice`.`product_variant_id`, `UserPrice`.`price` FROM `cd_decorative_aggregates_daltex_uat`.`user_prices` AS `UserPrice` WHERE `UserPrice`.`user_id` IS NULL AND `UserPrice`.`product_variant_id` IN (2419, 2420, 2427, 2428, 2431, 2432, 2433, 2434, 2435, 2436) | 0 | 0 | 0 | |
| 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_daltex_uat`.`ev_shop_product_variants` AS `ProductVariant` left JOIN `cd_decorative_aggregates_daltex_uat`.`ev_shop_products` AS `Product` ON (`ProductVariant`.`product_id` = `Product`.`id`) LEFT JOIN `cd_decorative_aggregates_daltex_uat`.`ev_shop_product_attribute_options_product_variants` AS `ProductAttributeOptionsVariants` ON (`ProductVariant`.`id` = `ProductAttributeOptionsVariants`.`product_variant_id`) LEFT JOIN `cd_decorative_aggregates_daltex_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOption` ON (`ProductAttributeOptionsVariants`.`product_attribute_option_id` = `ProductAttributeOption`.`id`) left JOIN `cd_decorative_aggregates_daltex_uat`.`ev_checkout_vat_rates` AS `VatRate` ON (`Product`.`vat_rate_id` = `VatRate`.`id`) WHERE `ProductVariant`.`product_id` = 461 AND `ProductVariant`.`is_removed` <> '1' | 3 | 3 | 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_daltex_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOption` JOIN `cd_decorative_aggregates_daltex_uat`.`ev_shop_product_attribute_options_product_variants` AS `EvShopProductAttributeOptionsProductVariant` ON (`EvShopProductAttributeOptionsProductVariant`.`product_variant_id` IN (2420, 2435, 2436) AND `EvShopProductAttributeOptionsProductVariant`.`product_attribute_option_id` = `ProductAttributeOption`.`id`) WHERE `ProductAttributeOption`.`id` IN (83, 93, 89, 94, 84, 102, 103, 104, 105, 106, 107, 85, 108, 109, 110, 111, 92, 90, 91, 95, 101, 99, 97, 100, 98, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 148, 149, 150, 151, 152, 153, 154, 155, 156, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 205, 206, 207, 208, 209, 211, 212, 213, 214, 215, 216, 217, 218, 219, 220, 221, 222, 223, 226) | 3 | 3 | 1 | maybe slow |
| SELECT `Postcode`.`id`, `Postcode`.`outcode` FROM `cd_decorative_aggregates_daltex_uat`.`postcodes` AS `Postcode` WHERE `outcode` LIKE 'DE4' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ShippingCompany`.`id` FROM `cd_decorative_aggregates_daltex_uat`.`shipping_companies` AS `ShippingCompany` WHERE `is_active` = '1' AND `pricing_only` = '1' | 1 | 1 | 0 | |
| SELECT `ShippingCost`.*, IF(cost IS NULL AND shipping_company_id <> 7, -1, 0) AS nullswitch, `ShippingCompany`.`id`, `Plant`.`id` FROM `cd_decorative_aggregates_daltex_uat`.`shipping_costs` AS `ShippingCost` LEFT JOIN `cd_decorative_aggregates_daltex_uat`.`shipping_companies` AS `ShippingCompany` ON (`ShippingCost`.`shipping_company_id` = `ShippingCompany`.`id`) LEFT JOIN `cd_decorative_aggregates_daltex_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` = 8 AND ((`cost` >= 0) OR (`cost` IS NULL)) AND shipping_company_id = (11) ORDER BY `nullswitch` DESC, `cost` ASC LIMIT 1 | 1 | 1 | 1 | |
| SELECT `ProductAttributeOptions`.`name`, `ProductAttributeOptions`.`description`, `Product`.`excludes_vat`, `VatRate`.`rate`, `ProductVariant`.`online_price`, IF(Product.excludes_vat=1,IF(UserPrice.price IS NOT NULL, UserPrice.price, ProductVariant.price)*((VatRate.rate/100)+1),IF(UserPrice.price IS NOT NULL, UserPrice.price, ProductVariant.price)) AS calculatedprice, IF(Product.excludes_vat<>1,IF(UserPrice.price IS NOT NULL, UserPrice.price, ProductVariant.price)/((VatRate.rate/100)+1),IF(UserPrice.price IS NOT NULL, UserPrice.price, 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_daltex_uat`.`ev_shop_product_variants` AS `ProductVariant` LEFT JOIN `cd_decorative_aggregates_daltex_uat`.`ev_shop_product_attribute_options_product_variants` AS `ProductAttributeOptionsVariants` ON (`ProductVariant`.`id` = `ProductAttributeOptionsVariants`.`product_variant_id`) LEFT JOIN `cd_decorative_aggregates_daltex_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOptions` ON (`ProductAttributeOptionsVariants`.`product_attribute_option_id` = `ProductAttributeOptions`.`id`) left JOIN `cd_decorative_aggregates_daltex_uat`.`ev_shop_products` AS `Product` ON (`ProductVariant`.`product_id` = `Product`.`id`) left JOIN `cd_decorative_aggregates_daltex_uat`.`ev_checkout_vat_rates` AS `VatRate` ON (`Product`.`vat_rate_id` = `VatRate`.`id`) left JOIN `cd_decorative_aggregates_daltex_uat`.`user_prices` AS `UserPrice` ON (`ProductVariant`.`id` = `UserPrice`.`product_variant_id` AND `UserPrice`.`user_id` IS NULL) WHERE `ProductVariant`.`product_id` = 461 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 `Postcode`.`id`, `Postcode`.`outcode` FROM `cd_decorative_aggregates_daltex_uat`.`postcodes` AS `Postcode` WHERE `outcode` LIKE 'DE4' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ShippingCompany`.`id` FROM `cd_decorative_aggregates_daltex_uat`.`shipping_companies` AS `ShippingCompany` WHERE `is_active` = '1' AND `pricing_only` = '1' | 1 | 1 | 0 | |
| SELECT `ShippingCost`.*, IF(cost IS NULL AND shipping_company_id <> 7, -1, 0) AS nullswitch, `ShippingCompany`.`id`, `Plant`.`id` FROM `cd_decorative_aggregates_daltex_uat`.`shipping_costs` AS `ShippingCost` LEFT JOIN `cd_decorative_aggregates_daltex_uat`.`shipping_companies` AS `ShippingCompany` ON (`ShippingCost`.`shipping_company_id` = `ShippingCompany`.`id`) LEFT JOIN `cd_decorative_aggregates_daltex_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` = 8 AND ((`cost` >= 0) OR (`cost` IS NULL)) AND shipping_company_id = (11) ORDER BY `nullswitch` DESC, `cost` ASC LIMIT 1 | 1 | 1 | 1 | |
| SELECT `Postcode`.`id`, `Postcode`.`outcode` FROM `cd_decorative_aggregates_daltex_uat`.`postcodes` AS `Postcode` WHERE `outcode` LIKE 'DE4' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ShippingCompany`.`id` FROM `cd_decorative_aggregates_daltex_uat`.`shipping_companies` AS `ShippingCompany` WHERE `is_active` = '1' AND `pricing_only` = '1' | 1 | 1 | 0 | |
| SELECT `ShippingCost`.*, IF(cost IS NULL AND shipping_company_id <> 7, -1, 0) AS nullswitch, `ShippingCompany`.`id`, `Plant`.`id` FROM `cd_decorative_aggregates_daltex_uat`.`shipping_costs` AS `ShippingCost` LEFT JOIN `cd_decorative_aggregates_daltex_uat`.`shipping_companies` AS `ShippingCompany` ON (`ShippingCost`.`shipping_company_id` = `ShippingCompany`.`id`) LEFT JOIN `cd_decorative_aggregates_daltex_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` = 8 AND ((`cost` >= 0) OR (`cost` IS NULL)) AND shipping_company_id = (11) ORDER BY `nullswitch` DESC, `cost` ASC LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ProductVariant`.`id` FROM `cd_decorative_aggregates_daltex_uat`.`ev_shop_product_variants` AS `ProductVariant` WHERE `ProductVariant`.`product_id` = 464 | 2 | 2 | 0 | |
| SELECT `UserPrice`.`product_variant_id`, `UserPrice`.`price` FROM `cd_decorative_aggregates_daltex_uat`.`user_prices` AS `UserPrice` WHERE `UserPrice`.`user_id` IS NULL AND `UserPrice`.`product_variant_id` IN (2430, 2437) | 0 | 0 | 0 | |
| 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_daltex_uat`.`ev_shop_product_variants` AS `ProductVariant` left JOIN `cd_decorative_aggregates_daltex_uat`.`ev_shop_products` AS `Product` ON (`ProductVariant`.`product_id` = `Product`.`id`) LEFT JOIN `cd_decorative_aggregates_daltex_uat`.`ev_shop_product_attribute_options_product_variants` AS `ProductAttributeOptionsVariants` ON (`ProductVariant`.`id` = `ProductAttributeOptionsVariants`.`product_variant_id`) LEFT JOIN `cd_decorative_aggregates_daltex_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOption` ON (`ProductAttributeOptionsVariants`.`product_attribute_option_id` = `ProductAttributeOption`.`id`) left JOIN `cd_decorative_aggregates_daltex_uat`.`ev_checkout_vat_rates` AS `VatRate` ON (`Product`.`vat_rate_id` = `VatRate`.`id`) WHERE `ProductVariant`.`product_id` = 464 AND `ProductVariant`.`is_removed` <> '1' | 1 | 1 | 0 | |
| 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_daltex_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOption` JOIN `cd_decorative_aggregates_daltex_uat`.`ev_shop_product_attribute_options_product_variants` AS `EvShopProductAttributeOptionsProductVariant` ON (`EvShopProductAttributeOptionsProductVariant`.`product_variant_id` = 2437 AND `EvShopProductAttributeOptionsProductVariant`.`product_attribute_option_id` = `ProductAttributeOption`.`id`) WHERE `ProductAttributeOption`.`id` IN (83, 93, 89, 94, 84, 102, 103, 104, 105, 106, 107, 85, 108, 109, 110, 111, 92, 90, 91, 95, 101, 99, 97, 100, 98, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 148, 149, 150, 151, 152, 153, 154, 155, 156, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 205, 206, 207, 208, 209, 211, 212, 213, 214, 215, 216, 217, 218, 219, 220, 221, 222, 223, 226) | 1 | 1 | 1 | |
| SELECT `Postcode`.`id`, `Postcode`.`outcode` FROM `cd_decorative_aggregates_daltex_uat`.`postcodes` AS `Postcode` WHERE `outcode` LIKE 'DE4' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ShippingCompany`.`id` FROM `cd_decorative_aggregates_daltex_uat`.`shipping_companies` AS `ShippingCompany` WHERE `is_active` = '1' AND `pricing_only` = '1' | 1 | 1 | 0 | |
| SELECT `ShippingCost`.*, IF(cost IS NULL AND shipping_company_id <> 7, -1, 0) AS nullswitch, `ShippingCompany`.`id`, `Plant`.`id` FROM `cd_decorative_aggregates_daltex_uat`.`shipping_costs` AS `ShippingCost` LEFT JOIN `cd_decorative_aggregates_daltex_uat`.`shipping_companies` AS `ShippingCompany` ON (`ShippingCost`.`shipping_company_id` = `ShippingCompany`.`id`) LEFT JOIN `cd_decorative_aggregates_daltex_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` = 8 AND ((`cost` >= 0) OR (`cost` IS NULL)) AND shipping_company_id = (11) ORDER BY `nullswitch` DESC, `cost` ASC LIMIT 1 | 1 | 1 | 1 | |
| SELECT `ProductAttributeOptions`.`name`, `ProductAttributeOptions`.`description`, `Product`.`excludes_vat`, `VatRate`.`rate`, `ProductVariant`.`online_price`, IF(Product.excludes_vat=1,IF(UserPrice.price IS NOT NULL, UserPrice.price, ProductVariant.price)*((VatRate.rate/100)+1),IF(UserPrice.price IS NOT NULL, UserPrice.price, ProductVariant.price)) AS calculatedprice, IF(Product.excludes_vat<>1,IF(UserPrice.price IS NOT NULL, UserPrice.price, ProductVariant.price)/((VatRate.rate/100)+1),IF(UserPrice.price IS NOT NULL, UserPrice.price, 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_daltex_uat`.`ev_shop_product_variants` AS `ProductVariant` LEFT JOIN `cd_decorative_aggregates_daltex_uat`.`ev_shop_product_attribute_options_product_variants` AS `ProductAttributeOptionsVariants` ON (`ProductVariant`.`id` = `ProductAttributeOptionsVariants`.`product_variant_id`) LEFT JOIN `cd_decorative_aggregates_daltex_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOptions` ON (`ProductAttributeOptionsVariants`.`product_attribute_option_id` = `ProductAttributeOptions`.`id`) left JOIN `cd_decorative_aggregates_daltex_uat`.`ev_shop_products` AS `Product` ON (`ProductVariant`.`product_id` = `Product`.`id`) left JOIN `cd_decorative_aggregates_daltex_uat`.`ev_checkout_vat_rates` AS `VatRate` ON (`Product`.`vat_rate_id` = `VatRate`.`id`) left JOIN `cd_decorative_aggregates_daltex_uat`.`user_prices` AS `UserPrice` ON (`ProductVariant`.`id` = `UserPrice`.`product_variant_id` AND `UserPrice`.`user_id` IS NULL) WHERE `ProductVariant`.`product_id` = 464 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 `ProductVariant`.`id` FROM `cd_decorative_aggregates_daltex_uat`.`ev_shop_product_variants` AS `ProductVariant` WHERE `ProductVariant`.`product_id` = 440 | 4 | 4 | 0 | |
| SELECT `UserPrice`.`product_variant_id`, `UserPrice`.`price` FROM `cd_decorative_aggregates_daltex_uat`.`user_prices` AS `UserPrice` WHERE `UserPrice`.`user_id` IS NULL AND `UserPrice`.`product_variant_id` IN (2373, 2374, 2376, 2378) | 0 | 0 | 0 | |
| 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_daltex_uat`.`ev_shop_product_variants` AS `ProductVariant` left JOIN `cd_decorative_aggregates_daltex_uat`.`ev_shop_products` AS `Product` ON (`ProductVariant`.`product_id` = `Product`.`id`) LEFT JOIN `cd_decorative_aggregates_daltex_uat`.`ev_shop_product_attribute_options_product_variants` AS `ProductAttributeOptionsVariants` ON (`ProductVariant`.`id` = `ProductAttributeOptionsVariants`.`product_variant_id`) LEFT JOIN `cd_decorative_aggregates_daltex_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOption` ON (`ProductAttributeOptionsVariants`.`product_attribute_option_id` = `ProductAttributeOption`.`id`) left JOIN `cd_decorative_aggregates_daltex_uat`.`ev_checkout_vat_rates` AS `VatRate` ON (`Product`.`vat_rate_id` = `VatRate`.`id`) WHERE `ProductVariant`.`product_id` = 440 AND `ProductVariant`.`is_removed` <> '1' | 1 | 1 | 0 | |
| 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_daltex_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOption` JOIN `cd_decorative_aggregates_daltex_uat`.`ev_shop_product_attribute_options_product_variants` AS `EvShopProductAttributeOptionsProductVariant` ON (`EvShopProductAttributeOptionsProductVariant`.`product_variant_id` = 2378 AND `EvShopProductAttributeOptionsProductVariant`.`product_attribute_option_id` = `ProductAttributeOption`.`id`) WHERE `ProductAttributeOption`.`id` IN (83, 93, 89, 94, 84, 102, 103, 104, 105, 106, 107, 85, 108, 109, 110, 111, 92, 90, 91, 95, 101, 99, 97, 100, 98, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 148, 149, 150, 151, 152, 153, 154, 155, 156, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 205, 206, 207, 208, 209, 211, 212, 213, 214, 215, 216, 217, 218, 219, 220, 221, 222, 223, 226) | 1 | 1 | 1 | |
| SELECT `Postcode`.`id`, `Postcode`.`outcode` FROM `cd_decorative_aggregates_daltex_uat`.`postcodes` AS `Postcode` WHERE `outcode` LIKE 'DE4' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ShippingCompany`.`id` FROM `cd_decorative_aggregates_daltex_uat`.`shipping_companies` AS `ShippingCompany` WHERE `is_active` = '1' AND `pricing_only` = '1' | 1 | 1 | 0 | |
| SELECT `ShippingCost`.*, IF(cost IS NULL AND shipping_company_id <> 7, -1, 0) AS nullswitch, `ShippingCompany`.`id`, `Plant`.`id` FROM `cd_decorative_aggregates_daltex_uat`.`shipping_costs` AS `ShippingCost` LEFT JOIN `cd_decorative_aggregates_daltex_uat`.`shipping_companies` AS `ShippingCompany` ON (`ShippingCost`.`shipping_company_id` = `ShippingCompany`.`id`) LEFT JOIN `cd_decorative_aggregates_daltex_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` = 8 AND ((`cost` >= 0) OR (`cost` IS NULL)) AND shipping_company_id = (11) ORDER BY `nullswitch` DESC, `cost` ASC LIMIT 1 | 1 | 1 | 1 | |
| SELECT `ProductAttributeOptions`.`name`, `ProductAttributeOptions`.`description`, `Product`.`excludes_vat`, `VatRate`.`rate`, `ProductVariant`.`online_price`, IF(Product.excludes_vat=1,IF(UserPrice.price IS NOT NULL, UserPrice.price, ProductVariant.price)*((VatRate.rate/100)+1),IF(UserPrice.price IS NOT NULL, UserPrice.price, ProductVariant.price)) AS calculatedprice, IF(Product.excludes_vat<>1,IF(UserPrice.price IS NOT NULL, UserPrice.price, ProductVariant.price)/((VatRate.rate/100)+1),IF(UserPrice.price IS NOT NULL, UserPrice.price, 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_daltex_uat`.`ev_shop_product_variants` AS `ProductVariant` LEFT JOIN `cd_decorative_aggregates_daltex_uat`.`ev_shop_product_attribute_options_product_variants` AS `ProductAttributeOptionsVariants` ON (`ProductVariant`.`id` = `ProductAttributeOptionsVariants`.`product_variant_id`) LEFT JOIN `cd_decorative_aggregates_daltex_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOptions` ON (`ProductAttributeOptionsVariants`.`product_attribute_option_id` = `ProductAttributeOptions`.`id`) left JOIN `cd_decorative_aggregates_daltex_uat`.`ev_shop_products` AS `Product` ON (`ProductVariant`.`product_id` = `Product`.`id`) left JOIN `cd_decorative_aggregates_daltex_uat`.`ev_checkout_vat_rates` AS `VatRate` ON (`Product`.`vat_rate_id` = `VatRate`.`id`) left JOIN `cd_decorative_aggregates_daltex_uat`.`user_prices` AS `UserPrice` ON (`ProductVariant`.`id` = `UserPrice`.`product_variant_id` AND `UserPrice`.`user_id` IS NULL) WHERE `ProductVariant`.`product_id` = 440 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 `ProductVariant`.`id` FROM `cd_decorative_aggregates_daltex_uat`.`ev_shop_product_variants` AS `ProductVariant` WHERE `ProductVariant`.`product_id` = 463 | 2 | 2 | 0 | |
| SELECT `UserPrice`.`product_variant_id`, `UserPrice`.`price` FROM `cd_decorative_aggregates_daltex_uat`.`user_prices` AS `UserPrice` WHERE `UserPrice`.`user_id` IS NULL AND `UserPrice`.`product_variant_id` IN (2429, 2438) | 0 | 0 | 0 | |
| 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_daltex_uat`.`ev_shop_product_variants` AS `ProductVariant` left JOIN `cd_decorative_aggregates_daltex_uat`.`ev_shop_products` AS `Product` ON (`ProductVariant`.`product_id` = `Product`.`id`) LEFT JOIN `cd_decorative_aggregates_daltex_uat`.`ev_shop_product_attribute_options_product_variants` AS `ProductAttributeOptionsVariants` ON (`ProductVariant`.`id` = `ProductAttributeOptionsVariants`.`product_variant_id`) LEFT JOIN `cd_decorative_aggregates_daltex_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOption` ON (`ProductAttributeOptionsVariants`.`product_attribute_option_id` = `ProductAttributeOption`.`id`) left JOIN `cd_decorative_aggregates_daltex_uat`.`ev_checkout_vat_rates` AS `VatRate` ON (`Product`.`vat_rate_id` = `VatRate`.`id`) WHERE `ProductVariant`.`product_id` = 463 AND `ProductVariant`.`is_removed` <> '1' | 1 | 1 | 0 | |
| 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_daltex_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOption` JOIN `cd_decorative_aggregates_daltex_uat`.`ev_shop_product_attribute_options_product_variants` AS `EvShopProductAttributeOptionsProductVariant` ON (`EvShopProductAttributeOptionsProductVariant`.`product_variant_id` = 2438 AND `EvShopProductAttributeOptionsProductVariant`.`product_attribute_option_id` = `ProductAttributeOption`.`id`) WHERE `ProductAttributeOption`.`id` IN (83, 93, 89, 94, 84, 102, 103, 104, 105, 106, 107, 85, 108, 109, 110, 111, 92, 90, 91, 95, 101, 99, 97, 100, 98, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 148, 149, 150, 151, 152, 153, 154, 155, 156, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 205, 206, 207, 208, 209, 211, 212, 213, 214, 215, 216, 217, 218, 219, 220, 221, 222, 223, 226) | 1 | 1 | 1 | |
| SELECT `Postcode`.`id`, `Postcode`.`outcode` FROM `cd_decorative_aggregates_daltex_uat`.`postcodes` AS `Postcode` WHERE `outcode` LIKE 'DE4' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ShippingCompany`.`id` FROM `cd_decorative_aggregates_daltex_uat`.`shipping_companies` AS `ShippingCompany` WHERE `is_active` = '1' AND `pricing_only` = '1' | 1 | 1 | 0 | |
| SELECT `ShippingCost`.*, IF(cost IS NULL AND shipping_company_id <> 7, -1, 0) AS nullswitch, `ShippingCompany`.`id`, `Plant`.`id` FROM `cd_decorative_aggregates_daltex_uat`.`shipping_costs` AS `ShippingCost` LEFT JOIN `cd_decorative_aggregates_daltex_uat`.`shipping_companies` AS `ShippingCompany` ON (`ShippingCost`.`shipping_company_id` = `ShippingCompany`.`id`) LEFT JOIN `cd_decorative_aggregates_daltex_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` = 8 AND ((`cost` >= 0) OR (`cost` IS NULL)) AND shipping_company_id = (11) ORDER BY `nullswitch` DESC, `cost` ASC LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ProductAttributeOptions`.`name`, `ProductAttributeOptions`.`description`, `Product`.`excludes_vat`, `VatRate`.`rate`, `ProductVariant`.`online_price`, IF(Product.excludes_vat=1,IF(UserPrice.price IS NOT NULL, UserPrice.price, ProductVariant.price)*((VatRate.rate/100)+1),IF(UserPrice.price IS NOT NULL, UserPrice.price, ProductVariant.price)) AS calculatedprice, IF(Product.excludes_vat<>1,IF(UserPrice.price IS NOT NULL, UserPrice.price, ProductVariant.price)/((VatRate.rate/100)+1),IF(UserPrice.price IS NOT NULL, UserPrice.price, 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_daltex_uat`.`ev_shop_product_variants` AS `ProductVariant` LEFT JOIN `cd_decorative_aggregates_daltex_uat`.`ev_shop_product_attribute_options_product_variants` AS `ProductAttributeOptionsVariants` ON (`ProductVariant`.`id` = `ProductAttributeOptionsVariants`.`product_variant_id`) LEFT JOIN `cd_decorative_aggregates_daltex_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOptions` ON (`ProductAttributeOptionsVariants`.`product_attribute_option_id` = `ProductAttributeOptions`.`id`) left JOIN `cd_decorative_aggregates_daltex_uat`.`ev_shop_products` AS `Product` ON (`ProductVariant`.`product_id` = `Product`.`id`) left JOIN `cd_decorative_aggregates_daltex_uat`.`ev_checkout_vat_rates` AS `VatRate` ON (`Product`.`vat_rate_id` = `VatRate`.`id`) left JOIN `cd_decorative_aggregates_daltex_uat`.`user_prices` AS `UserPrice` ON (`ProductVariant`.`id` = `UserPrice`.`product_variant_id` AND `UserPrice`.`user_id` IS NULL) WHERE `ProductVariant`.`product_id` = 463 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 `ProductVariant`.`id` FROM `cd_decorative_aggregates_daltex_uat`.`ev_shop_product_variants` AS `ProductVariant` WHERE `ProductVariant`.`product_id` = 316 | 7 | 7 | 0 | |
| SELECT `UserPrice`.`product_variant_id`, `UserPrice`.`price` FROM `cd_decorative_aggregates_daltex_uat`.`user_prices` AS `UserPrice` WHERE `UserPrice`.`user_id` IS NULL AND `UserPrice`.`product_variant_id` IN (2071, 2072, 2137, 2138, 2205, 2377, 2379) | 0 | 0 | 0 | |
| 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_daltex_uat`.`ev_shop_product_variants` AS `ProductVariant` left JOIN `cd_decorative_aggregates_daltex_uat`.`ev_shop_products` AS `Product` ON (`ProductVariant`.`product_id` = `Product`.`id`) LEFT JOIN `cd_decorative_aggregates_daltex_uat`.`ev_shop_product_attribute_options_product_variants` AS `ProductAttributeOptionsVariants` ON (`ProductVariant`.`id` = `ProductAttributeOptionsVariants`.`product_variant_id`) LEFT JOIN `cd_decorative_aggregates_daltex_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOption` ON (`ProductAttributeOptionsVariants`.`product_attribute_option_id` = `ProductAttributeOption`.`id`) left JOIN `cd_decorative_aggregates_daltex_uat`.`ev_checkout_vat_rates` AS `VatRate` ON (`Product`.`vat_rate_id` = `VatRate`.`id`) WHERE `ProductVariant`.`product_id` = 316 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_daltex_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOption` JOIN `cd_decorative_aggregates_daltex_uat`.`ev_shop_product_attribute_options_product_variants` AS `EvShopProductAttributeOptionsProductVariant` ON (`EvShopProductAttributeOptionsProductVariant`.`product_variant_id` = 2379 AND `EvShopProductAttributeOptionsProductVariant`.`product_attribute_option_id` = `ProductAttributeOption`.`id`) WHERE `ProductAttributeOption`.`id` IN (83, 93, 89, 94, 84, 102, 103, 104, 105, 106, 107, 85, 108, 109, 110, 111, 92, 90, 91, 95, 101, 99, 97, 100, 98, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 148, 149, 150, 151, 152, 153, 154, 155, 156, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 205, 206, 207, 208, 209, 211, 212, 213, 214, 215, 216, 217, 218, 219, 220, 221, 222, 223, 226) | 1 | 1 | 1 | |
| SELECT `Postcode`.`id`, `Postcode`.`outcode` FROM `cd_decorative_aggregates_daltex_uat`.`postcodes` AS `Postcode` WHERE `outcode` LIKE 'DE4' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ShippingCompany`.`id` FROM `cd_decorative_aggregates_daltex_uat`.`shipping_companies` AS `ShippingCompany` WHERE `is_active` = '1' AND `pricing_only` = '1' | 1 | 1 | 0 | |
| SELECT `ShippingCost`.*, IF(cost IS NULL AND shipping_company_id <> 7, -1, 0) AS nullswitch, `ShippingCompany`.`id`, `Plant`.`id` FROM `cd_decorative_aggregates_daltex_uat`.`shipping_costs` AS `ShippingCost` LEFT JOIN `cd_decorative_aggregates_daltex_uat`.`shipping_companies` AS `ShippingCompany` ON (`ShippingCost`.`shipping_company_id` = `ShippingCompany`.`id`) LEFT JOIN `cd_decorative_aggregates_daltex_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` = 10 AND ((`cost` >= 0) OR (`cost` IS NULL)) AND shipping_company_id = (11) ORDER BY `nullswitch` DESC, `cost` ASC LIMIT 1 | 0 | 0 | 134 | maybe slow |
| SELECT `Postcode`.`id`, `Postcode`.`outcode` FROM `cd_decorative_aggregates_daltex_uat`.`postcodes` AS `Postcode` WHERE `outcode` LIKE 'DE4' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ShippingCompany`.`id` FROM `cd_decorative_aggregates_daltex_uat`.`shipping_companies` AS `ShippingCompany` WHERE `is_active` = '1' AND `pricing_only` = '1' | 1 | 1 | 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_daltex_uat`.`shipping_costs` AS `ShippingCost` LEFT JOIN `cd_decorative_aggregates_daltex_uat`.`shipping_companies` AS `ShippingCompany` ON (`ShippingCost`.`shipping_company_id` = `ShippingCompany`.`id`) LEFT JOIN `cd_decorative_aggregates_daltex_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` = 10 AND ((`cost` >= 0) OR (`cost` IS NULL)) AND NOT (shipping_company_id = (11)) AND `shipping_company_id` != 6 ORDER BY `nullswitch` DESC, `cost` ASC LIMIT 1 | 0 | 0 | 1 | maybe slow |
| SELECT `ProductAttributeOptions`.`name`, `ProductAttributeOptions`.`description`, `Product`.`excludes_vat`, `VatRate`.`rate`, `ProductVariant`.`online_price`, IF(Product.excludes_vat=1,IF(UserPrice.price IS NOT NULL, UserPrice.price, ProductVariant.price)*((VatRate.rate/100)+1),IF(UserPrice.price IS NOT NULL, UserPrice.price, ProductVariant.price)) AS calculatedprice, IF(Product.excludes_vat<>1,IF(UserPrice.price IS NOT NULL, UserPrice.price, ProductVariant.price)/((VatRate.rate/100)+1),IF(UserPrice.price IS NOT NULL, UserPrice.price, 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_daltex_uat`.`ev_shop_product_variants` AS `ProductVariant` LEFT JOIN `cd_decorative_aggregates_daltex_uat`.`ev_shop_product_attribute_options_product_variants` AS `ProductAttributeOptionsVariants` ON (`ProductVariant`.`id` = `ProductAttributeOptionsVariants`.`product_variant_id`) LEFT JOIN `cd_decorative_aggregates_daltex_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOptions` ON (`ProductAttributeOptionsVariants`.`product_attribute_option_id` = `ProductAttributeOptions`.`id`) left JOIN `cd_decorative_aggregates_daltex_uat`.`ev_shop_products` AS `Product` ON (`ProductVariant`.`product_id` = `Product`.`id`) left JOIN `cd_decorative_aggregates_daltex_uat`.`ev_checkout_vat_rates` AS `VatRate` ON (`Product`.`vat_rate_id` = `VatRate`.`id`) left JOIN `cd_decorative_aggregates_daltex_uat`.`user_prices` AS `UserPrice` ON (`ProductVariant`.`id` = `UserPrice`.`product_variant_id` AND `UserPrice`.`user_id` IS NULL) WHERE `ProductVariant`.`product_id` = 316 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 `ProductVariant`.`id` FROM `cd_decorative_aggregates_daltex_uat`.`ev_shop_product_variants` AS `ProductVariant` WHERE `ProductVariant`.`product_id` = 441 | 4 | 4 | 0 | |
| SELECT `UserPrice`.`product_variant_id`, `UserPrice`.`price` FROM `cd_decorative_aggregates_daltex_uat`.`user_prices` AS `UserPrice` WHERE `UserPrice`.`user_id` IS NULL AND `UserPrice`.`product_variant_id` IN (2375, 2380, 2383, 2384) | 0 | 0 | 0 | |
| 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_daltex_uat`.`ev_shop_product_variants` AS `ProductVariant` left JOIN `cd_decorative_aggregates_daltex_uat`.`ev_shop_products` AS `Product` ON (`ProductVariant`.`product_id` = `Product`.`id`) LEFT JOIN `cd_decorative_aggregates_daltex_uat`.`ev_shop_product_attribute_options_product_variants` AS `ProductAttributeOptionsVariants` ON (`ProductVariant`.`id` = `ProductAttributeOptionsVariants`.`product_variant_id`) LEFT JOIN `cd_decorative_aggregates_daltex_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOption` ON (`ProductAttributeOptionsVariants`.`product_attribute_option_id` = `ProductAttributeOption`.`id`) left JOIN `cd_decorative_aggregates_daltex_uat`.`ev_checkout_vat_rates` AS `VatRate` ON (`Product`.`vat_rate_id` = `VatRate`.`id`) WHERE `ProductVariant`.`product_id` = 441 AND `ProductVariant`.`is_removed` <> '1' | 1 | 1 | 0 | |
| 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_daltex_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOption` JOIN `cd_decorative_aggregates_daltex_uat`.`ev_shop_product_attribute_options_product_variants` AS `EvShopProductAttributeOptionsProductVariant` ON (`EvShopProductAttributeOptionsProductVariant`.`product_variant_id` = 2384 AND `EvShopProductAttributeOptionsProductVariant`.`product_attribute_option_id` = `ProductAttributeOption`.`id`) WHERE `ProductAttributeOption`.`id` IN (83, 93, 89, 94, 84, 102, 103, 104, 105, 106, 107, 85, 108, 109, 110, 111, 92, 90, 91, 95, 101, 99, 97, 100, 98, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 148, 149, 150, 151, 152, 153, 154, 155, 156, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 205, 206, 207, 208, 209, 211, 212, 213, 214, 215, 216, 217, 218, 219, 220, 221, 222, 223, 226) | 1 | 1 | 1 | |
| SELECT `Postcode`.`id`, `Postcode`.`outcode` FROM `cd_decorative_aggregates_daltex_uat`.`postcodes` AS `Postcode` WHERE `outcode` LIKE 'DE4' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ShippingCompany`.`id` FROM `cd_decorative_aggregates_daltex_uat`.`shipping_companies` AS `ShippingCompany` WHERE `is_active` = '1' AND `pricing_only` = '1' | 1 | 1 | 0 | |
| SELECT `ShippingCost`.*, IF(cost IS NULL AND shipping_company_id <> 7, -1, 0) AS nullswitch, `ShippingCompany`.`id`, `Plant`.`id` FROM `cd_decorative_aggregates_daltex_uat`.`shipping_costs` AS `ShippingCost` LEFT JOIN `cd_decorative_aggregates_daltex_uat`.`shipping_companies` AS `ShippingCompany` ON (`ShippingCost`.`shipping_company_id` = `ShippingCompany`.`id`) LEFT JOIN `cd_decorative_aggregates_daltex_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` = 10 AND ((`cost` >= 0) OR (`cost` IS NULL)) AND shipping_company_id = (11) ORDER BY `nullswitch` DESC, `cost` ASC LIMIT 1 | 0 | 0 | 0 | |
| SELECT `Postcode`.`id`, `Postcode`.`outcode` FROM `cd_decorative_aggregates_daltex_uat`.`postcodes` AS `Postcode` WHERE `outcode` LIKE 'DE4' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ShippingCompany`.`id` FROM `cd_decorative_aggregates_daltex_uat`.`shipping_companies` AS `ShippingCompany` WHERE `is_active` = '1' AND `pricing_only` = '1' | 1 | 1 | 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_daltex_uat`.`shipping_costs` AS `ShippingCost` LEFT JOIN `cd_decorative_aggregates_daltex_uat`.`shipping_companies` AS `ShippingCompany` ON (`ShippingCost`.`shipping_company_id` = `ShippingCompany`.`id`) LEFT JOIN `cd_decorative_aggregates_daltex_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` = 10 AND ((`cost` >= 0) OR (`cost` IS NULL)) AND NOT (shipping_company_id = (11)) AND `shipping_company_id` != 6 ORDER BY `nullswitch` DESC, `cost` ASC LIMIT 1 | 0 | 0 | 1 | maybe slow |
| SELECT `ProductAttributeOptions`.`name`, `ProductAttributeOptions`.`description`, `Product`.`excludes_vat`, `VatRate`.`rate`, `ProductVariant`.`online_price`, IF(Product.excludes_vat=1,IF(UserPrice.price IS NOT NULL, UserPrice.price, ProductVariant.price)*((VatRate.rate/100)+1),IF(UserPrice.price IS NOT NULL, UserPrice.price, ProductVariant.price)) AS calculatedprice, IF(Product.excludes_vat<>1,IF(UserPrice.price IS NOT NULL, UserPrice.price, ProductVariant.price)/((VatRate.rate/100)+1),IF(UserPrice.price IS NOT NULL, UserPrice.price, 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_daltex_uat`.`ev_shop_product_variants` AS `ProductVariant` LEFT JOIN `cd_decorative_aggregates_daltex_uat`.`ev_shop_product_attribute_options_product_variants` AS `ProductAttributeOptionsVariants` ON (`ProductVariant`.`id` = `ProductAttributeOptionsVariants`.`product_variant_id`) LEFT JOIN `cd_decorative_aggregates_daltex_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOptions` ON (`ProductAttributeOptionsVariants`.`product_attribute_option_id` = `ProductAttributeOptions`.`id`) left JOIN `cd_decorative_aggregates_daltex_uat`.`ev_shop_products` AS `Product` ON (`ProductVariant`.`product_id` = `Product`.`id`) left JOIN `cd_decorative_aggregates_daltex_uat`.`ev_checkout_vat_rates` AS `VatRate` ON (`Product`.`vat_rate_id` = `VatRate`.`id`) left JOIN `cd_decorative_aggregates_daltex_uat`.`user_prices` AS `UserPrice` ON (`ProductVariant`.`id` = `UserPrice`.`product_variant_id` AND `UserPrice`.`user_id` IS NULL) WHERE `ProductVariant`.`product_id` = 441 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 `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_daltex_uat`.`pages` AS `Page` WHERE `Page`.`id` = 45 LIMIT 1 | 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_daltex_uat`.`meta_data` AS `MetaData` WHERE ((`model` = 'Page') AND (`model_id` = 45)) | 2 | 2 | 0 | |
| 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_daltex_uat`.`pages` AS `Page` WHERE `Page`.`id` = 45 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `HomepageBlocksImage`.`id`, `HomepageBlocksImage`.`model`, `HomepageBlocksImage`.`model_id`, `HomepageBlocksImage`.`filename`, `HomepageBlocksImage`.`attachment_type`, `HomepageBlocksImage`.`alt`, `HomepageBlocksImage`.`title`, `HomepageBlocksImage`.`caption`, `HomepageBlocksImage`.`link_text`, `HomepageBlocksImage`.`link_url`, `HomepageBlocksImage`.`products`, `HomepageBlocksImage`.`body`, `HomepageBlocksImage`.`type`, `HomepageBlocksImage`.`size`, `HomepageBlocksImage`.`dir`, `HomepageBlocksImage`.`sequence`, `HomepageBlocksImage`.`is_active`, `HomepageBlocksImage`.`created`, `HomepageBlocksImage`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `HomepageBlocksImage__filepath` FROM `cd_decorative_aggregates_daltex_uat`.`images` AS `HomepageBlocksImage` WHERE `model` = 'Page' AND `attachment_type` = 'HomepageBlocksImage' AND `HomepageBlocksImage`.`model_id` = (45) ORDER BY `sequence` ASC | 0 | 0 | 0 | |
| SELECT `ActionBlocksImage`.`id`, `ActionBlocksImage`.`model`, `ActionBlocksImage`.`model_id`, `ActionBlocksImage`.`filename`, `ActionBlocksImage`.`attachment_type`, `ActionBlocksImage`.`alt`, `ActionBlocksImage`.`title`, `ActionBlocksImage`.`caption`, `ActionBlocksImage`.`link_text`, `ActionBlocksImage`.`link_url`, `ActionBlocksImage`.`products`, `ActionBlocksImage`.`body`, `ActionBlocksImage`.`type`, `ActionBlocksImage`.`size`, `ActionBlocksImage`.`dir`, `ActionBlocksImage`.`sequence`, `ActionBlocksImage`.`is_active`, `ActionBlocksImage`.`created`, `ActionBlocksImage`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `ActionBlocksImage__filepath` FROM `cd_decorative_aggregates_daltex_uat`.`images` AS `ActionBlocksImage` WHERE `model` = 'Page' AND `attachment_type` = 'ActionBlocksImage' AND `ActionBlocksImage`.`model_id` = (45) ORDER BY `sequence` ASC | 0 | 0 | 0 | |
| SELECT `FeatureBlocksImage`.`id`, `FeatureBlocksImage`.`model`, `FeatureBlocksImage`.`model_id`, `FeatureBlocksImage`.`filename`, `FeatureBlocksImage`.`attachment_type`, `FeatureBlocksImage`.`alt`, `FeatureBlocksImage`.`title`, `FeatureBlocksImage`.`caption`, `FeatureBlocksImage`.`link_text`, `FeatureBlocksImage`.`link_url`, `FeatureBlocksImage`.`products`, `FeatureBlocksImage`.`body`, `FeatureBlocksImage`.`type`, `FeatureBlocksImage`.`size`, `FeatureBlocksImage`.`dir`, `FeatureBlocksImage`.`sequence`, `FeatureBlocksImage`.`is_active`, `FeatureBlocksImage`.`created`, `FeatureBlocksImage`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `FeatureBlocksImage__filepath` FROM `cd_decorative_aggregates_daltex_uat`.`images` AS `FeatureBlocksImage` WHERE `model` = 'Page' AND `attachment_type` = 'FeatureBlocksImage' AND `FeatureBlocksImage`.`model_id` = (45) ORDER BY `sequence` ASC | 0 | 0 | 0 | |
| SELECT `PreviewImage`.`id`, `PreviewImage`.`model`, `PreviewImage`.`model_id`, `PreviewImage`.`filename`, `PreviewImage`.`attachment_type`, `PreviewImage`.`alt`, `PreviewImage`.`title`, `PreviewImage`.`caption`, `PreviewImage`.`link_text`, `PreviewImage`.`link_url`, `PreviewImage`.`products`, `PreviewImage`.`body`, `PreviewImage`.`type`, `PreviewImage`.`size`, `PreviewImage`.`dir`, `PreviewImage`.`sequence`, `PreviewImage`.`is_active`, `PreviewImage`.`created`, `PreviewImage`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `PreviewImage__filepath` FROM `cd_decorative_aggregates_daltex_uat`.`images` AS `PreviewImage` WHERE `model` = 'Page' AND `attachment_type` = 'PreviewImage' AND `PreviewImage`.`model_id` = (45) ORDER BY `sequence` ASC | 0 | 0 | 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_daltex_uat`.`images` AS `BackgroundImage` WHERE `model` = 'Page' AND `attachment_type` = 'BackgroundImage' AND `BackgroundImage`.`model_id` = (45) ORDER BY `sequence` ASC | 0 | 0 | 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_daltex_uat`.`images` AS `ListingImage` WHERE `model` = 'Page' AND `attachment_type` = 'ListingImage' AND `ListingImage`.`model_id` = (45) 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_daltex_uat`.`images` AS `Image` WHERE `model` = 'Page' AND `attachment_type` = 'Image' AND `Image`.`model_id` = (45) ORDER BY `sequence` ASC | 0 | 0 | 0 | |
| SELECT `TrainingImage`.`id`, `TrainingImage`.`model`, `TrainingImage`.`model_id`, `TrainingImage`.`filename`, `TrainingImage`.`attachment_type`, `TrainingImage`.`alt`, `TrainingImage`.`title`, `TrainingImage`.`caption`, `TrainingImage`.`link_text`, `TrainingImage`.`link_url`, `TrainingImage`.`products`, `TrainingImage`.`body`, `TrainingImage`.`type`, `TrainingImage`.`size`, `TrainingImage`.`dir`, `TrainingImage`.`sequence`, `TrainingImage`.`is_active`, `TrainingImage`.`created`, `TrainingImage`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `TrainingImage__filepath` FROM `cd_decorative_aggregates_daltex_uat`.`images` AS `TrainingImage` WHERE `model` = 'Page' AND `attachment_type` = 'TrainingImage' AND `TrainingImage`.`model_id` = (45) ORDER BY `sequence` ASC | 0 | 0 | 0 | |
| SELECT `KnowledgeImage`.`id`, `KnowledgeImage`.`model`, `KnowledgeImage`.`model_id`, `KnowledgeImage`.`filename`, `KnowledgeImage`.`attachment_type`, `KnowledgeImage`.`alt`, `KnowledgeImage`.`title`, `KnowledgeImage`.`caption`, `KnowledgeImage`.`link_text`, `KnowledgeImage`.`link_url`, `KnowledgeImage`.`products`, `KnowledgeImage`.`body`, `KnowledgeImage`.`type`, `KnowledgeImage`.`size`, `KnowledgeImage`.`dir`, `KnowledgeImage`.`sequence`, `KnowledgeImage`.`is_active`, `KnowledgeImage`.`created`, `KnowledgeImage`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `KnowledgeImage__filepath` FROM `cd_decorative_aggregates_daltex_uat`.`images` AS `KnowledgeImage` WHERE `model` = 'Page' AND `attachment_type` = 'KnowledgeImage' AND `KnowledgeImage`.`model_id` = (45) ORDER BY `sequence` ASC | 0 | 0 | 0 | |
| SELECT `AboutBlocksImage`.`id`, `AboutBlocksImage`.`model`, `AboutBlocksImage`.`model_id`, `AboutBlocksImage`.`filename`, `AboutBlocksImage`.`attachment_type`, `AboutBlocksImage`.`alt`, `AboutBlocksImage`.`title`, `AboutBlocksImage`.`caption`, `AboutBlocksImage`.`link_text`, `AboutBlocksImage`.`link_url`, `AboutBlocksImage`.`products`, `AboutBlocksImage`.`body`, `AboutBlocksImage`.`type`, `AboutBlocksImage`.`size`, `AboutBlocksImage`.`dir`, `AboutBlocksImage`.`sequence`, `AboutBlocksImage`.`is_active`, `AboutBlocksImage`.`created`, `AboutBlocksImage`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `AboutBlocksImage__filepath` FROM `cd_decorative_aggregates_daltex_uat`.`images` AS `AboutBlocksImage` WHERE `model` = 'Page' AND `attachment_type` = 'AboutBlocksImage' AND `AboutBlocksImage`.`model_id` = (45) ORDER BY `sequence` ASC | 0 | 0 | 0 | |
| SELECT `TradeBannerImage`.`id`, `TradeBannerImage`.`model`, `TradeBannerImage`.`model_id`, `TradeBannerImage`.`filename`, `TradeBannerImage`.`attachment_type`, `TradeBannerImage`.`alt`, `TradeBannerImage`.`title`, `TradeBannerImage`.`caption`, `TradeBannerImage`.`link_text`, `TradeBannerImage`.`link_url`, `TradeBannerImage`.`products`, `TradeBannerImage`.`body`, `TradeBannerImage`.`type`, `TradeBannerImage`.`size`, `TradeBannerImage`.`dir`, `TradeBannerImage`.`sequence`, `TradeBannerImage`.`is_active`, `TradeBannerImage`.`created`, `TradeBannerImage`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `TradeBannerImage__filepath` FROM `cd_decorative_aggregates_daltex_uat`.`images` AS `TradeBannerImage` WHERE `model` = 'Page' AND `attachment_type` = 'TradeBannerImage' AND `TradeBannerImage`.`model_id` = (45) ORDER BY `sequence` ASC | 0 | 0 | 0 | |
| SELECT `TradeBlocksImage`.`id`, `TradeBlocksImage`.`model`, `TradeBlocksImage`.`model_id`, `TradeBlocksImage`.`filename`, `TradeBlocksImage`.`attachment_type`, `TradeBlocksImage`.`alt`, `TradeBlocksImage`.`title`, `TradeBlocksImage`.`caption`, `TradeBlocksImage`.`link_text`, `TradeBlocksImage`.`link_url`, `TradeBlocksImage`.`products`, `TradeBlocksImage`.`body`, `TradeBlocksImage`.`type`, `TradeBlocksImage`.`size`, `TradeBlocksImage`.`dir`, `TradeBlocksImage`.`sequence`, `TradeBlocksImage`.`is_active`, `TradeBlocksImage`.`created`, `TradeBlocksImage`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `TradeBlocksImage__filepath` FROM `cd_decorative_aggregates_daltex_uat`.`images` AS `TradeBlocksImage` WHERE `model` = 'Page' AND `attachment_type` = 'TradeBlocksImage' AND `TradeBlocksImage`.`model_id` = (45) ORDER BY `sequence` ASC | 0 | 0 | 0 | |
| SELECT `ContentBlocksImage`.`id`, `ContentBlocksImage`.`model`, `ContentBlocksImage`.`model_id`, `ContentBlocksImage`.`filename`, `ContentBlocksImage`.`attachment_type`, `ContentBlocksImage`.`alt`, `ContentBlocksImage`.`title`, `ContentBlocksImage`.`caption`, `ContentBlocksImage`.`link_text`, `ContentBlocksImage`.`link_url`, `ContentBlocksImage`.`products`, `ContentBlocksImage`.`body`, `ContentBlocksImage`.`type`, `ContentBlocksImage`.`size`, `ContentBlocksImage`.`dir`, `ContentBlocksImage`.`sequence`, `ContentBlocksImage`.`is_active`, `ContentBlocksImage`.`created`, `ContentBlocksImage`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `ContentBlocksImage__filepath` FROM `cd_decorative_aggregates_daltex_uat`.`images` AS `ContentBlocksImage` WHERE `model` = 'Page' AND `attachment_type` = 'ContentBlocksImage' AND `ContentBlocksImage`.`model_id` = (45) ORDER BY `sequence` ASC | 0 | 0 | 0 | |
| SELECT `GalleryImage`.`id`, `GalleryImage`.`model`, `GalleryImage`.`model_id`, `GalleryImage`.`filename`, `GalleryImage`.`attachment_type`, `GalleryImage`.`alt`, `GalleryImage`.`title`, `GalleryImage`.`caption`, `GalleryImage`.`link_text`, `GalleryImage`.`link_url`, `GalleryImage`.`products`, `GalleryImage`.`body`, `GalleryImage`.`type`, `GalleryImage`.`size`, `GalleryImage`.`dir`, `GalleryImage`.`sequence`, `GalleryImage`.`is_active`, `GalleryImage`.`created`, `GalleryImage`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `GalleryImage__filepath` FROM `cd_decorative_aggregates_daltex_uat`.`images` AS `GalleryImage` WHERE `model` = 'Page' AND `attachment_type` = 'GalleryImage' AND `GalleryImage`.`model_id` = (45) ORDER BY `sequence` ASC | 0 | 0 | 0 | |
| SELECT `5050blocksImage`.`id`, `5050blocksImage`.`model`, `5050blocksImage`.`model_id`, `5050blocksImage`.`filename`, `5050blocksImage`.`attachment_type`, `5050blocksImage`.`alt`, `5050blocksImage`.`title`, `5050blocksImage`.`caption`, `5050blocksImage`.`link_text`, `5050blocksImage`.`link_url`, `5050blocksImage`.`products`, `5050blocksImage`.`body`, `5050blocksImage`.`type`, `5050blocksImage`.`size`, `5050blocksImage`.`dir`, `5050blocksImage`.`sequence`, `5050blocksImage`.`is_active`, `5050blocksImage`.`created`, `5050blocksImage`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `5050blocksImage__filepath` FROM `cd_decorative_aggregates_daltex_uat`.`images` AS `5050blocksImage` WHERE `model` = 'Page' AND `attachment_type` = '5050blocksImage' AND `5050blocksImage`.`model_id` = (45) ORDER BY `sequence` ASC | 0 | 0 | 0 | |
| SELECT `5050visualiserImage`.`id`, `5050visualiserImage`.`model`, `5050visualiserImage`.`model_id`, `5050visualiserImage`.`filename`, `5050visualiserImage`.`attachment_type`, `5050visualiserImage`.`alt`, `5050visualiserImage`.`title`, `5050visualiserImage`.`caption`, `5050visualiserImage`.`link_text`, `5050visualiserImage`.`link_url`, `5050visualiserImage`.`products`, `5050visualiserImage`.`body`, `5050visualiserImage`.`type`, `5050visualiserImage`.`size`, `5050visualiserImage`.`dir`, `5050visualiserImage`.`sequence`, `5050visualiserImage`.`is_active`, `5050visualiserImage`.`created`, `5050visualiserImage`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `5050visualiserImage__filepath` FROM `cd_decorative_aggregates_daltex_uat`.`images` AS `5050visualiserImage` WHERE `model` = 'Page' AND `attachment_type` = '5050visualiserImage' AND `5050visualiserImage`.`model_id` = (45) ORDER BY `sequence` ASC | 0 | 0 | 0 | |
| SELECT `InlineImage`.`id`, `InlineImage`.`model`, `InlineImage`.`model_id`, `InlineImage`.`filename`, `InlineImage`.`attachment_type`, `InlineImage`.`alt`, `InlineImage`.`title`, `InlineImage`.`caption`, `InlineImage`.`link_text`, `InlineImage`.`link_url`, `InlineImage`.`products`, `InlineImage`.`body`, `InlineImage`.`type`, `InlineImage`.`size`, `InlineImage`.`dir`, `InlineImage`.`sequence`, `InlineImage`.`is_active`, `InlineImage`.`created`, `InlineImage`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `InlineImage__filepath` FROM `cd_decorative_aggregates_daltex_uat`.`images` AS `InlineImage` WHERE `model` = 'Page' AND `attachment_type` = 'InlineImage' AND `InlineImage`.`model_id` = (45) ORDER BY `sequence` ASC | 0 | 0 | 0 | |
| SELECT `MetaData`.`id`, `MetaData`.`model`, `MetaData`.`model_id`, `MetaData`.`title`, `MetaData`.`description`, `MetaData`.`keywords`, `MetaData`.`created`, `MetaData`.`modified` FROM `cd_decorative_aggregates_daltex_uat`.`meta_data` AS `MetaData` WHERE ((`model` = 'Page') AND (`model_id` = 45)) | 2 | 2 | 0 | |
| SELECT `Route`.`id`, `Route`.`alias`, `Route`.`actual` FROM `cd_decorative_aggregates_daltex_uat`.`routes` AS `Route` WHERE `Route`.`actual` = 'pages/view/45' 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_daltex_uat`.`menus` AS `Menu` WHERE `model` = 'Page' AND `model_id` = 45 ORDER BY `lft` ASC LIMIT 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_daltex_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_daltex_uat`.`menus` AS `Menu` WHERE `lft` > 114 AND `rght` < 135 AND `is_active` = '1' ORDER BY `lft` ASC | 10 | 10 | 1 | maybe slow |
73 duplicate queries run.