Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`cake_sessions` AS `Session` WHERE `id` = 'mmv24i5fca3ood8oesilv5s5f3' LIMIT 1 | 1 | 1 | 1 | |
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_decorativeaggregates_uat`.`site_settings` AS `SiteSetting` WHERE 1 = 1 ORDER BY `SiteSetting`.`name` ASC | 19 | 19 | 0 | |
SELECT `AppOrderStatus`.`system_name`, `AppOrderStatus`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_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`.`delivery_instructions_disclaimer`, `Site`.`delivery_cutoff_warning_before`, `Site`.`delivery_cutoff_warning_after`, `Site`.`next_day_not_available`, `Site`.`free_day_now_costs`, `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`.`created`, `Site`.`modified`, `Site`.`is_active`, `Site`.`uses_pegasus_opera`, `Site`.`vat_display`, `Site`.`top_bar_population`, `Site`.`site_primary_category_id`, `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_decorativeaggregates_uat`.`sites` AS `Site` WHERE `url` LIKE '%decorativeaggregates.uat2.evoluted.net%' LIMIT 1 | 1 | 1 | 1 | |
SELECT `VatRate`.`id`, `VatRate`.`rate`, `VatRate`.`name`, `VatRate`.`is_active`, `VatRate`.`created`, `VatRate`.`modified` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_checkout_vat_rates` AS `VatRate` WHERE `VatRate`.`id` = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Order`.`id`, `Order`.`original_id`, `Order`.`site_id`, `Order`.`created`, `Order`.`modified`, `Order`.`order_time`, `Order`.`dispatch_date`, `Order`.`delivery_date`, `Order`.`invoice_date`, `Order`.`am_delivery`, `Order`.`early_am_delivery`, `Order`.`pm_delivery`, `Order`.`excel_delivery`, `Order`.`payment_method`, `Order`.`purchase_order`, `Order`.`is_next_day`, `Order`.`is_prepaid`, `Order`.`collection_plant_id`, `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`.`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`.`delivery_instructions_disclaimer`, `Site`.`delivery_cutoff_warning_before`, `Site`.`delivery_cutoff_warning_after`, `Site`.`next_day_not_available`, `Site`.`free_day_now_costs`, `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`.`created`, `Site`.`modified`, `Site`.`is_active`, `Site`.`uses_pegasus_opera`, `Site`.`vat_display`, `Site`.`top_bar_population`, `Site`.`site_primary_category_id`, `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_decorativeaggregates_uat`.`ev_checkout_orders` AS `Order` LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_checkout_customer_addresses` AS `DeliveryAddress` ON (`Order`.`delivery_address_id` = `DeliveryAddress`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_checkout_customer_addresses` AS `InvoiceAddress` ON (`Order`.`invoice_address_id` = `InvoiceAddress`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_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 `NoDelivery`.`id`, `NoDelivery`.`date` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`no_deliveries` AS `NoDelivery` WHERE `is_active` = '1' | 116 | 116 | 1 | |
SELECT `NoDelivery`.`id`, `NoDelivery`.`date` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`no_deliveries` AS `NoDelivery` WHERE `is_active` = '1' | 116 | 116 | 0 | |
SELECT `NoDelivery`.`id`, `NoDelivery`.`date` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`no_deliveries` AS `NoDelivery` WHERE `can_dispatch` = '0' AND `is_active` = '1' | 114 | 114 | 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_decorativeaggregates_uat`.`pages` AS `Page` WHERE `Page`.`id` = 22 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_decorativeaggregates_uat`.`meta_data` AS `MetaData` WHERE ((`model` = 'Page') AND (`model_id` = 22)) | 1 | 1 | 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_decorativeaggregates_uat`.`pages` AS `Page` WHERE `Page`.`id` = 22 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_decorativeaggregates_uat`.`meta_data` AS `MetaData` WHERE ((`model` = 'Page') AND (`model_id` = 22)) | 1 | 1 | 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_decorativeaggregates_uat`.`pages` AS `Page` WHERE `Page`.`id` = 22 LIMIT 1 | 1 | 1 | 0 | |
SELECT `BackgroundImage`.`id`, `BackgroundImage`.`model`, `BackgroundImage`.`model_id`, `BackgroundImage`.`filename`, `BackgroundImage`.`attachment_type`, `BackgroundImage`.`alt`, `BackgroundImage`.`title`, `BackgroundImage`.`caption`, `BackgroundImage`.`link_text`, `BackgroundImage`.`link_url`, `BackgroundImage`.`products`, `BackgroundImage`.`body`, `BackgroundImage`.`type`, `BackgroundImage`.`size`, `BackgroundImage`.`dir`, `BackgroundImage`.`sequence`, `BackgroundImage`.`is_active`, `BackgroundImage`.`created`, `BackgroundImage`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `BackgroundImage__filepath` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`images` AS `BackgroundImage` WHERE `model` = 'Page' AND `attachment_type` = 'BackgroundImage' AND `BackgroundImage`.`model_id` = (22) ORDER BY `sequence` ASC | 0 | 0 | 1 | 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_decorativeaggregates_uat`.`images` AS `ListingImage` WHERE `model` = 'Page' AND `attachment_type` = 'ListingImage' AND `ListingImage`.`model_id` = (22) ORDER BY `sequence` ASC | 0 | 0 | 0 | |
SELECT `Image`.`id`, `Image`.`model`, `Image`.`model_id`, `Image`.`filename`, `Image`.`attachment_type`, `Image`.`alt`, `Image`.`title`, `Image`.`caption`, `Image`.`link_text`, `Image`.`link_url`, `Image`.`products`, `Image`.`body`, `Image`.`type`, `Image`.`size`, `Image`.`dir`, `Image`.`sequence`, `Image`.`is_active`, `Image`.`created`, `Image`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `Image__filepath` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`images` AS `Image` WHERE `model` = 'Page' AND `attachment_type` = 'Image' AND `Image`.`model_id` = (22) 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_decorativeaggregates_uat`.`images` AS `TradeBannerImage` WHERE `model` = 'Page' AND `attachment_type` = 'TradeBannerImage' AND `TradeBannerImage`.`model_id` = (22) 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_decorativeaggregates_uat`.`images` AS `GalleryImage` WHERE `model` = 'Page' AND `attachment_type` = 'GalleryImage' AND `GalleryImage`.`model_id` = (22) 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_decorativeaggregates_uat`.`images` AS `InlineImage` WHERE `model` = 'Page' AND `attachment_type` = 'InlineImage' AND `InlineImage`.`model_id` = (22) 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_decorativeaggregates_uat`.`meta_data` AS `MetaData` WHERE ((`model` = 'Page') AND (`model_id` = 22)) | 1 | 1 | 0 | |
SELECT `Route`.`id`, `Route`.`alias`, `Route`.`actual` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`routes` AS `Route` WHERE `Route`.`actual` = 'pages/view/22' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Menu`.`id`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`name`, `Menu`.`url`, `Menu`.`pattern`, `Menu`.`plugin`, `Menu`.`controller`, `Menu`.`model`, `Menu`.`model_id`, `Menu`.`action`, `Menu`.`class`, `Menu`.`new_window`, `Menu`.`is_menu_hidden`, `Menu`.`is_active`, `Menu`.`created`, `Menu`.`modified`, `Menu`.`user_group_id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`menus` AS `Menu` WHERE `model` = 'Page' AND `model_id` = 22 ORDER BY `lft` ASC LIMIT 1 | 0 | 0 | 0 | |
SELECT `Order`.`id`, `Order`.`original_id`, `Order`.`site_id`, `Order`.`created`, `Order`.`modified`, `Order`.`order_time`, `Order`.`dispatch_date`, `Order`.`delivery_date`, `Order`.`invoice_date`, `Order`.`am_delivery`, `Order`.`early_am_delivery`, `Order`.`pm_delivery`, `Order`.`excel_delivery`, `Order`.`payment_method`, `Order`.`purchase_order`, `Order`.`is_next_day`, `Order`.`is_prepaid`, `Order`.`collection_plant_id`, `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`.`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`.`delivery_instructions_disclaimer`, `Site`.`delivery_cutoff_warning_before`, `Site`.`delivery_cutoff_warning_after`, `Site`.`next_day_not_available`, `Site`.`free_day_now_costs`, `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`.`created`, `Site`.`modified`, `Site`.`is_active`, `Site`.`uses_pegasus_opera`, `Site`.`vat_display`, `Site`.`top_bar_population`, `Site`.`site_primary_category_id`, `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_decorativeaggregates_uat`.`ev_checkout_orders` AS `Order` LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_checkout_customer_addresses` AS `DeliveryAddress` ON (`Order`.`delivery_address_id` = `DeliveryAddress`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_checkout_customer_addresses` AS `InvoiceAddress` ON (`Order`.`invoice_address_id` = `InvoiceAddress`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_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 `Menu`.`id`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`name`, `Menu`.`url`, `Menu`.`pattern`, `Menu`.`plugin`, `Menu`.`controller`, `Menu`.`model`, `Menu`.`model_id`, `Menu`.`action`, `Menu`.`class`, `Menu`.`new_window`, `Menu`.`is_menu_hidden`, `Menu`.`is_active`, `Menu`.`created`, `Menu`.`modified`, `Menu`.`user_group_id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`menus` AS `Menu` WHERE `Menu`.`id` = 7 ORDER BY `lft` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `Menu`.`id`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`name`, `Menu`.`url`, `Menu`.`pattern`, `Menu`.`plugin`, `Menu`.`controller`, `Menu`.`model`, `Menu`.`model_id`, `Menu`.`action`, `Menu`.`class`, `Menu`.`new_window`, `Menu`.`is_menu_hidden`, `Menu`.`is_active`, `Menu`.`created`, `Menu`.`modified`, `Menu`.`user_group_id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`menus` AS `Menu` WHERE `lft` > 92 AND `rght` < 115 AND `is_active` = '1' ORDER BY `lft` ASC | 11 | 11 | 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_decorativeaggregates_uat`.`pages` AS `Page` WHERE `Page`.`internal_title` = 'blog' LIMIT 1 | 0 | 0 | 0 | |
6 duplicate queries run.