Limestone is a sedimentary rock that is composed of grains of marine organism skeletal fragments such as coral, silica and small amounts of clay. Limestone was first quarried in Derbyshire in Roman times, and its main use was for building and lime in agriculture.
Over the years, limestone has been used in iconic buildings such as Chatsworth House, Windsor Castle, and the Houses of Parliament.
Derbyshire is still the UK’s largest limestone quarry producer and we have three limestones available in various product types.
The Derbyshire Dove Grey Limestone, Cotswold Buff and Cotswold Gold are the three that we supply in various sizes, such as 10-14mm, 20mm and for rockeries.
The 20mm limestone products are highly popular. They look great on paths and are fantastic when used on driveways.
Similarly, the neutral tones of the limestone provide a subtle and classic look when used as rockery stones and ground cover. Not only that, but they contrast plants beautifully.
Some of our most popular, bestselling limestone products include:
(Price includes Delivery Charge and VAT) *
Note: GravelX Prodrive 30 -...
Note: GravelX Prodrive 30 -...
Note: GravelX Prodrive 30 -...
Note: GravelX Prodrive 30 -...
Note: GravelX Prodrive 30 -...
Note: GravelX Prodrive 30 -...
No post data.
No querystring data.
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_decorativeaggregates_uat`.`site_settings` AS `SiteSetting` WHERE 1 = 1 ORDER BY `SiteSetting`.`name` ASC | 19 | 19 | 1 | maybe slow |
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 | 1 | |
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 `Session`.`id`, `Session`.`data`, `Session`.`expires` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`cake_sessions` AS `Session` WHERE `id` = 'drjebbkf1t1h5rqss2295p97u5' LIMIT 1 | 0 | 0 | 0 | |
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 | 1 | |
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 `Category`.`id`, `Category`.`accent_colour_id`, `Category`.`category_type`, `Category`.`name`, `Category`.`internal_title`, `Category`.`parent_id`, `Category`.`from_price`, `Category`.`delivery_delay`, `Category`.`homepage_title`, `Category`.`homepage_text`, `Category`.`description`, `Category`.`secondary_description`, `Category`.`products_anchor_text`, `Category`.`banner_button_text`, `Category`.`banner_button_link`, `Category`.`why_use_us_heading`, `Category`.`why_use_us_left_heading`, `Category`.`why_use_us_left`, `Category`.`why_use_us_left_button_text`, `Category`.`why_use_us_left_button_link`, `Category`.`why_use_us_right_heading`, `Category`.`why_use_us_right`, `Category`.`why_use_us_right_button_text`, `Category`.`why_use_us_right_button_link`, `Category`.`expanded_text`, `Category`.`uses_gravel_calculator`, `Category`.`external_site_link`, `Category`.`external_site_url`, `Category`.`featured_on_homepage`, `Category`.`display_in_menu`, `Category`.`hidden_category`, `Category`.`product_attribute_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`created`, `Category`.`modified` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_category_categories` AS `Category` WHERE `Category`.`id` = 60 LIMIT 1 | 1 | 1 | 1 | |
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` = 'Category' AND `attachment_type` = 'BackgroundImage' AND `BackgroundImage`.`model_id` = (60) ORDER BY `sequence` ASC | 0 | 0 | 0 | |
SELECT `HomepageImage`.`id`, `HomepageImage`.`model`, `HomepageImage`.`model_id`, `HomepageImage`.`filename`, `HomepageImage`.`attachment_type`, `HomepageImage`.`alt`, `HomepageImage`.`title`, `HomepageImage`.`caption`, `HomepageImage`.`link_text`, `HomepageImage`.`link_url`, `HomepageImage`.`products`, `HomepageImage`.`body`, `HomepageImage`.`type`, `HomepageImage`.`size`, `HomepageImage`.`dir`, `HomepageImage`.`sequence`, `HomepageImage`.`is_active`, `HomepageImage`.`created`, `HomepageImage`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `HomepageImage__filepath` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`images` AS `HomepageImage` WHERE `model` = 'Category' AND `attachment_type` = 'HomepageImage' AND `HomepageImage`.`model_id` = (60) 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_decorativeaggregates_uat`.`images` AS `ListingImage` WHERE `model` = 'Category' AND `attachment_type` = 'ListingImage' AND `ListingImage`.`model_id` = (60) 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` = 'Category' AND `attachment_type` = 'InlineImage' AND `InlineImage`.`model_id` = (60) 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` = 'Category') AND (`model_id` = 60)) | 1 | 1 | 0 | |
SELECT `RelatedCategory`.`lft`, `RelatedCategory`.`rght` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_category_categories` AS `RelatedCategory` WHERE 1 = 1 AND `RelatedCategory`.`id` = 60 LIMIT 1 | 1 | 1 | 0 | |
SELECT `RelatedCategory`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_category_categories` AS `RelatedCategory` WHERE 1 = 1 AND `RelatedCategory`.`rght` < 109 AND `RelatedCategory`.`lft` > 108 ORDER BY `RelatedCategory`.`lft` asc | 0 | 0 | 0 | |
SELECT `Product`.`id`, `Product`.`plant_id`, `Product`.`force_shipping_company_id`, `Product`.`name`, `Product`.`internal_title`, `Product`.`subtitle`, `Product`.`SKU`, `Product`.`lead_time`, `Product`.`excludes_vat`, `Product`.`vat_rate_id`, `Product`.`use_size_price`, `Product`.`calculator_size`, `Product`.`aggregate_size_id`, `Product`.`homepage_text`, `Product`.`description`, `Product`.`expanded_text`, `Product`.`additional_title`, `Product`.`additional_text`, `Product`.`additional_button_title`, `Product`.`additional_button_url`, `Product`.`aside_title`, `Product`.`aside_text`, `Product`.`mix_design`, `Product`.`technical_spec`, `Product`.`addon_products_text`, `Product`.`suitable_for`, `Product`.`not_suitable_for`, `Product`.`sash_colour_id`, `Product`.`sash_message_id`, `Product`.`no_gravel_calculator`, `Product`.`display_only`, `Product`.`admin_only`, `Product`.`flag_order`, `Product`.`nofollow`, `Product`.`is_grouped_product`, `Product`.`no_loose_load_message`, `Product`.`google_feed_title`, `Product`.`google_feed_description`, `Product`.`exclude_from_feed`, `Product`.`is_featured`, `Product`.`on_homepage`, `Product`.`hide_background_image`, `Product`.`hide_background_image_on_mobile`, `Product`.`show_options_as_dropdown`, `Product`.`qualifies_for_gravelx_upsell`, `Product`.`show_gravelx_aside`, `Product`.`upsell_specific_sizes`, `Product`.`is_active`, `Product`.`is_removed`, `Product`.`created`, `Product`.`modified`, (`ProductVariant`.`price`) AS `Product__min_price`, (`ProductVariant`.`rrp`) AS `Product__min_rrp`, `SashColour`.`id`, `SashColour`.`name`, `SashColour`.`hex`, `SashColour`.`text_hex`, `SashColour`.`created`, `SashColour`.`modified`, `SashColour`.`is_active`, `SashMessage`.`id`, `SashMessage`.`name`, `SashMessage`.`created`, `SashMessage`.`modified`, `SashMessage`.`is_active`, `AggregateSize`.`id`, `AggregateSize`.`name`, `AggregateSize`.`sequence`, `AggregateSize`.`created`, `AggregateSize`.`modified` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_products` AS `Product` LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`sash_colours` AS `SashColour` ON (`Product`.`sash_colour_id` = `SashColour`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`sash_messages` AS `SashMessage` ON (`Product`.`sash_message_id` = `SashMessage`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`aggregate_sizes` AS `AggregateSize` ON (`Product`.`aggregate_size_id` = `AggregateSize`.`id`) RIGHT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_related_items_related_items` AS `RelatedItem` ON (`RelatedItem`.`model_id` = `Product`.`id` AND `RelatedItem`.`model` IN ('Product', 'GroupedProduct') AND `RelatedItem`.`related_model` = 'Category') LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_variants` AS `ProductVariant` ON (`ProductVariant`.`product_id` = `Product`.`id`) WHERE `RelatedItem`.`related_model_id` = (60) AND ((`ProductVariant`.`id` IS NOT NULL) OR (`Product`.`is_grouped_product` = 1)) AND `Product`.`is_active` = '1' AND `Product`.`is_removed` != '1' AND `Product`.`admin_only` = '0' GROUP BY `Product`.`id` ORDER BY `RelatedItem`.`sequence` ASC LIMIT 999 | 6 | 6 | 3 | 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` = 'Product' AND `attachment_type` = 'ListingImage' AND `ListingImage`.`model_id` IN (48, 5, 2, 6, 8, 7) | 6 | 6 | 1 | maybe slow |
SELECT `SampleImage`.`id`, `SampleImage`.`model`, `SampleImage`.`model_id`, `SampleImage`.`filename`, `SampleImage`.`attachment_type`, `SampleImage`.`alt`, `SampleImage`.`title`, `SampleImage`.`caption`, `SampleImage`.`link_text`, `SampleImage`.`link_url`, `SampleImage`.`products`, `SampleImage`.`body`, `SampleImage`.`type`, `SampleImage`.`size`, `SampleImage`.`dir`, `SampleImage`.`sequence`, `SampleImage`.`is_active`, `SampleImage`.`created`, `SampleImage`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `SampleImage__filepath` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`images` AS `SampleImage` WHERE `model` = 'Product' AND `attachment_type` = 'SampleImage' AND `SampleImage`.`model_id` IN (48, 5, 2, 6, 8, 7) | 6 | 6 | 1 | maybe slow |
SELECT `Image`.`id`, `Image`.`model`, `Image`.`model_id`, `Image`.`filename`, `Image`.`attachment_type`, `Image`.`alt`, `Image`.`title`, `Image`.`caption`, `Image`.`link_text`, `Image`.`link_url`, `Image`.`products`, `Image`.`body`, `Image`.`type`, `Image`.`size`, `Image`.`dir`, `Image`.`sequence`, `Image`.`is_active`, `Image`.`created`, `Image`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `Image__filepath` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`images` AS `Image` WHERE `model` = 'Product' AND `attachment_type` = 'Image' AND `Image`.`model_id` = (48) LIMIT 1 | 1 | 1 | 0 | |
SELECT `Image`.`id`, `Image`.`model`, `Image`.`model_id`, `Image`.`filename`, `Image`.`attachment_type`, `Image`.`alt`, `Image`.`title`, `Image`.`caption`, `Image`.`link_text`, `Image`.`link_url`, `Image`.`products`, `Image`.`body`, `Image`.`type`, `Image`.`size`, `Image`.`dir`, `Image`.`sequence`, `Image`.`is_active`, `Image`.`created`, `Image`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `Image__filepath` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`images` AS `Image` WHERE `model` = 'Product' AND `attachment_type` = 'Image' AND `Image`.`model_id` = (5) LIMIT 1 | 1 | 1 | 0 | |
SELECT `Image`.`id`, `Image`.`model`, `Image`.`model_id`, `Image`.`filename`, `Image`.`attachment_type`, `Image`.`alt`, `Image`.`title`, `Image`.`caption`, `Image`.`link_text`, `Image`.`link_url`, `Image`.`products`, `Image`.`body`, `Image`.`type`, `Image`.`size`, `Image`.`dir`, `Image`.`sequence`, `Image`.`is_active`, `Image`.`created`, `Image`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `Image__filepath` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`images` AS `Image` WHERE `model` = 'Product' AND `attachment_type` = 'Image' AND `Image`.`model_id` = (2) LIMIT 1 | 1 | 1 | 0 | |
SELECT `Image`.`id`, `Image`.`model`, `Image`.`model_id`, `Image`.`filename`, `Image`.`attachment_type`, `Image`.`alt`, `Image`.`title`, `Image`.`caption`, `Image`.`link_text`, `Image`.`link_url`, `Image`.`products`, `Image`.`body`, `Image`.`type`, `Image`.`size`, `Image`.`dir`, `Image`.`sequence`, `Image`.`is_active`, `Image`.`created`, `Image`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `Image__filepath` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`images` AS `Image` WHERE `model` = 'Product' AND `attachment_type` = 'Image' AND `Image`.`model_id` = (6) LIMIT 1 | 1 | 1 | 0 | |
SELECT `Image`.`id`, `Image`.`model`, `Image`.`model_id`, `Image`.`filename`, `Image`.`attachment_type`, `Image`.`alt`, `Image`.`title`, `Image`.`caption`, `Image`.`link_text`, `Image`.`link_url`, `Image`.`products`, `Image`.`body`, `Image`.`type`, `Image`.`size`, `Image`.`dir`, `Image`.`sequence`, `Image`.`is_active`, `Image`.`created`, `Image`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `Image__filepath` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`images` AS `Image` WHERE `model` = 'Product' AND `attachment_type` = 'Image' AND `Image`.`model_id` = (8) LIMIT 1 | 1 | 1 | 0 | |
SELECT `Image`.`id`, `Image`.`model`, `Image`.`model_id`, `Image`.`filename`, `Image`.`attachment_type`, `Image`.`alt`, `Image`.`title`, `Image`.`caption`, `Image`.`link_text`, `Image`.`link_url`, `Image`.`products`, `Image`.`body`, `Image`.`type`, `Image`.`size`, `Image`.`dir`, `Image`.`sequence`, `Image`.`is_active`, `Image`.`created`, `Image`.`modified`, (CONCAT("files/image/", id, "/", filename)) AS `Image__filepath` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`images` AS `Image` WHERE `model` = 'Product' AND `attachment_type` = 'Image' AND `Image`.`model_id` = (7) LIMIT 1 | 1 | 1 | 0 | |
SELECT `SecondaryPlant`.`id`, `SecondaryPlant`.`name`, `SecondaryPlant`.`front_facing_name`, `SecondaryPlant`.`order_recipient`, `SecondaryPlant`.`email`, `SecondaryPlant`.`phone`, `SecondaryPlant`.`printer_name`, `SecondaryPlant`.`use_email`, `SecondaryPlant`.`use_printer`, `SecondaryPlant`.`allow_customer_collection`, `SecondaryPlant`.`no_queue_emails`, `SecondaryPlant`.`has_earlier_next_day_queue`, `SecondaryPlant`.`is_direct`, `SecondaryPlant`.`sequence`, `SecondaryPlant`.`address_name`, `SecondaryPlant`.`address_line_1`, `SecondaryPlant`.`address_line_2`, `SecondaryPlant`.`address_line_3`, `SecondaryPlant`.`address_town`, `SecondaryPlant`.`address_county`, `SecondaryPlant`.`address_postcode`, `SecondaryPlant`.`pricing_postcode`, `SecondaryPlant`.`pallex_username`, `SecondaryPlant`.`pallex_password`, `SecondaryPlant`.`created`, `SecondaryPlant`.`modified`, `SecondaryPlant`.`is_active`, `EvShopProductsPlant`.`id`, `EvShopProductsPlant`.`ev_shop_product_id`, `EvShopProductsPlant`.`plant_id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`plants` AS `SecondaryPlant` JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_products_plants` AS `EvShopProductsPlant` ON (`EvShopProductsPlant`.`ev_shop_product_id` IN (48, 5, 2, 6, 8, 7) AND `EvShopProductsPlant`.`plant_id` = `SecondaryPlant`.`id`) | 6 | 6 | 1 | maybe slow |
SELECT `MetaData`.`id`, `MetaData`.`model`, `MetaData`.`model_id`, `MetaData`.`title`, `MetaData`.`description`, `MetaData`.`keywords`, `MetaData`.`created`, `MetaData`.`modified` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`meta_data` AS `MetaData` WHERE ((((`model` = 'Product') AND (`model_id` = 48))) OR (((`model` = 'Product') AND (`model_id` = 5))) OR (((`model` = 'Product') AND (`model_id` = 2))) OR (((`model` = 'Product') AND (`model_id` = 6))) OR (((`model` = 'Product') AND (`model_id` = 8))) OR (((`model` = 'Product') AND (`model_id` = 7)))) | 11 | 11 | 1 | maybe slow |
SELECT `ProductAttributeOption`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOption` WHERE `product_attribute_id` = 3 ORDER BY `sequence` ASC | 75 | 75 | 1 | |
SELECT `ProductVariant`.*, `VatRate`.*, `Product`.`excludes_vat`, IF(Product.excludes_vat=1,ProductVariant.price*((VatRate.rate/100)+1),ProductVariant.price) AS calculatedprice, IF(Product.excludes_vat<>1,ProductVariant.price/((VatRate.rate/100)+1),ProductVariant.price) AS exvat, `ProductVariant`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_variants` AS `ProductVariant` left JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_products` AS `Product` ON (`ProductVariant`.`product_id` = `Product`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options_product_variants` AS `ProductAttributeOptionsVariants` ON (`ProductVariant`.`id` = `ProductAttributeOptionsVariants`.`product_variant_id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOption` ON (`ProductAttributeOptionsVariants`.`product_attribute_option_id` = `ProductAttributeOption`.`id`) left JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_checkout_vat_rates` AS `VatRate` ON (`Product`.`vat_rate_id` = `VatRate`.`id`) WHERE `ProductVariant`.`product_id` = 48 AND `ProductVariant`.`is_removed` <> '1' | 12 | 12 | 1 | maybe slow |
SELECT `ProductAttributeOption`.`id`, `ProductAttributeOption`.`product_attribute_id`, `ProductAttributeOption`.`name`, `ProductAttributeOption`.`description`, `ProductAttributeOption`.`sequence`, `ProductAttributeOption`.`created`, `ProductAttributeOption`.`modified`, `EvShopProductAttributeOptionsProductVariant`.`id`, `EvShopProductAttributeOptionsProductVariant`.`product_attribute_option_id`, `EvShopProductAttributeOptionsProductVariant`.`product_variant_id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOption` JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options_product_variants` AS `EvShopProductAttributeOptionsProductVariant` ON (`EvShopProductAttributeOptionsProductVariant`.`product_variant_id` IN (741, 742, 744, 746, 818, 2023) AND `EvShopProductAttributeOptionsProductVariant`.`product_attribute_option_id` = `ProductAttributeOption`.`id`) WHERE `ProductAttributeOption`.`id` IN (129, 7, 120, 118, 55, 56, 8, 114, 123, 111, 9, 122, 110, 121, 11, 82, 57, 58, 53, 81, 80, 86, 117, 119, 124, 115, 42, 102, 101, 96, 95, 98, 97, 100, 99, 73, 14, 116, 104, 36, 37, 30, 31, 32, 18, 60, 107, 19, 106, 22, 92, 93, 94, 17, 16, 83, 23, 125, 126, 127, 128, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143) | 6 | 6 | 1 | maybe slow |
SELECT `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 `Postcode`.`id`, `Postcode`.`outcode` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`postcodes` AS `Postcode` WHERE `outcode` LIKE 'DE4' LIMIT 1 | 1 | 1 | 0 | |
SELECT `ShippingCompany`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_companies` AS `ShippingCompany` WHERE `is_active` = '1' AND `pricing_only` = '1' | 0 | 0 | 0 | |
SELECT `ShippingCost`.*, `ShippingCompany`.*, IF(cost IS NULL AND shipping_company_id <> 7, -1, 0) AS nullswitch, `ShippingCompany`.`id`, `Plant`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_costs` AS `ShippingCost` LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_companies` AS `ShippingCompany` ON (`ShippingCost`.`shipping_company_id` = `ShippingCompany`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`plants` AS `Plant` ON (`ShippingCost`.`plant_id` = `Plant`.`id`) WHERE `Plant`.`is_active` = '1' AND `ShippingCompany`.`is_active` = '1' AND `postcode_id` = 663 AND `plant_id` = 9 AND ((`cost` >= 0) OR (`cost` IS NULL)) AND NOT (`shipping_company_id` IS NULL) AND `shipping_company_id` != 6 ORDER BY `nullswitch` DESC, `cost` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `ProductAttributeOptions`.`name`, `ProductAttributeOptions`.`description`, `Product`.`excludes_vat`, `VatRate`.`rate`, `ProductVariant`.`online_price`, IF(Product.excludes_vat=1,ProductVariant.price*((VatRate.rate/100)+1),ProductVariant.price) AS calculatedprice, IF(Product.excludes_vat<>1,ProductVariant.price/((VatRate.rate/100)+1),ProductVariant.price) AS exvat, IF(ProductAttributeOptions.description LIKE "%forceprice%", 2, -1) AS force_price, IF(ProductAttributeOptions.description LIKE "%default%", 1, 0) AS is_default, IF(ProductAttributeOptions.description LIKE "%nosurcharge%", 0, 1) AS has_surcharge, IF(ProductAttributeOptions.description LIKE "%separatesurcharge%", 0, 1) AS separate_surcharge, IF(ProductAttributeOptions.description LIKE "%fromprice%", 1, 0) AS from_price, IF(ProductAttributeOptions.description LIKE "%poa%", 1, 0) AS is_poa FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_variants` AS `ProductVariant` LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options_product_variants` AS `ProductAttributeOptionsVariants` ON (`ProductVariant`.`id` = `ProductAttributeOptionsVariants`.`product_variant_id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOptions` ON (`ProductAttributeOptionsVariants`.`product_attribute_option_id` = `ProductAttributeOptions`.`id`) left JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_products` AS `Product` ON (`ProductVariant`.`product_id` = `Product`.`id`) left JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_checkout_vat_rates` AS `VatRate` ON (`Product`.`vat_rate_id` = `VatRate`.`id`) WHERE `ProductVariant`.`product_id` = 48 AND `ProductVariant`.`is_removed` = '0' AND `ProductVariant`.`price` IS NOT NULL AND `ProductVariant`.`price` > 0 AND ((`ProductAttributeOptions`.`description` LIKE '%\"main\"%') OR (`ProductAttributeOptions`.`description` LIKE '%\"default\"%')) ORDER BY `force_price` DESC, `is_default` ASC, `calculatedprice` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `ProductVariant`.*, `VatRate`.*, `Product`.`excludes_vat`, IF(Product.excludes_vat=1,ProductVariant.price*((VatRate.rate/100)+1),ProductVariant.price) AS calculatedprice, IF(Product.excludes_vat<>1,ProductVariant.price/((VatRate.rate/100)+1),ProductVariant.price) AS exvat, `ProductVariant`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_variants` AS `ProductVariant` left JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_products` AS `Product` ON (`ProductVariant`.`product_id` = `Product`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options_product_variants` AS `ProductAttributeOptionsVariants` ON (`ProductVariant`.`id` = `ProductAttributeOptionsVariants`.`product_variant_id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOption` ON (`ProductAttributeOptionsVariants`.`product_attribute_option_id` = `ProductAttributeOption`.`id`) left JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_checkout_vat_rates` AS `VatRate` ON (`Product`.`vat_rate_id` = `VatRate`.`id`) WHERE `ProductVariant`.`product_id` = 5 AND `ProductVariant`.`is_removed` <> '1' | 6 | 6 | 1 | maybe slow |
SELECT `ProductAttributeOption`.`id`, `ProductAttributeOption`.`product_attribute_id`, `ProductAttributeOption`.`name`, `ProductAttributeOption`.`description`, `ProductAttributeOption`.`sequence`, `ProductAttributeOption`.`created`, `ProductAttributeOption`.`modified`, `EvShopProductAttributeOptionsProductVariant`.`id`, `EvShopProductAttributeOptionsProductVariant`.`product_attribute_option_id`, `EvShopProductAttributeOptionsProductVariant`.`product_variant_id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOption` JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options_product_variants` AS `EvShopProductAttributeOptionsProductVariant` ON (`EvShopProductAttributeOptionsProductVariant`.`product_variant_id` IN (101, 2034) AND `EvShopProductAttributeOptionsProductVariant`.`product_attribute_option_id` = `ProductAttributeOption`.`id`) WHERE `ProductAttributeOption`.`id` IN (129, 7, 120, 118, 55, 56, 8, 114, 123, 111, 9, 122, 110, 121, 11, 82, 57, 58, 53, 81, 80, 86, 117, 119, 124, 115, 42, 102, 101, 96, 95, 98, 97, 100, 99, 73, 14, 116, 104, 36, 37, 30, 31, 32, 18, 60, 107, 19, 106, 22, 92, 93, 94, 17, 16, 83, 23, 125, 126, 127, 128, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143) | 2 | 2 | 1 | maybe slow |
SELECT `Postcode`.`id`, `Postcode`.`outcode` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`postcodes` AS `Postcode` WHERE `outcode` LIKE 'DE4' LIMIT 1 | 1 | 1 | 0 | |
SELECT `ShippingCompany`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_companies` AS `ShippingCompany` WHERE `is_active` = '1' AND `pricing_only` = '1' | 0 | 0 | 0 | |
SELECT `ShippingCost`.*, `ShippingCompany`.*, IF(cost IS NULL AND shipping_company_id <> 7, -1, 0) AS nullswitch, `ShippingCompany`.`id`, `Plant`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_costs` AS `ShippingCost` LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_companies` AS `ShippingCompany` ON (`ShippingCost`.`shipping_company_id` = `ShippingCompany`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`plants` AS `Plant` ON (`ShippingCost`.`plant_id` = `Plant`.`id`) WHERE `Plant`.`is_active` = '1' AND `ShippingCompany`.`is_active` = '1' AND `postcode_id` = 663 AND `plant_id` = 9 AND ((`cost` >= 0) OR (`cost` IS NULL)) AND NOT (`shipping_company_id` IS NULL) AND `shipping_company_id` != 6 ORDER BY `nullswitch` DESC, `cost` ASC LIMIT 1 | 1 | 1 | 2 | maybe slow |
SELECT `ProductAttributeOptions`.`name`, `ProductAttributeOptions`.`description`, `Product`.`excludes_vat`, `VatRate`.`rate`, `ProductVariant`.`online_price`, IF(Product.excludes_vat=1,ProductVariant.price*((VatRate.rate/100)+1),ProductVariant.price) AS calculatedprice, IF(Product.excludes_vat<>1,ProductVariant.price/((VatRate.rate/100)+1),ProductVariant.price) AS exvat, IF(ProductAttributeOptions.description LIKE "%forceprice%", 2, -1) AS force_price, IF(ProductAttributeOptions.description LIKE "%default%", 1, 0) AS is_default, IF(ProductAttributeOptions.description LIKE "%nosurcharge%", 0, 1) AS has_surcharge, IF(ProductAttributeOptions.description LIKE "%separatesurcharge%", 0, 1) AS separate_surcharge, IF(ProductAttributeOptions.description LIKE "%fromprice%", 1, 0) AS from_price, IF(ProductAttributeOptions.description LIKE "%poa%", 1, 0) AS is_poa FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_variants` AS `ProductVariant` LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options_product_variants` AS `ProductAttributeOptionsVariants` ON (`ProductVariant`.`id` = `ProductAttributeOptionsVariants`.`product_variant_id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOptions` ON (`ProductAttributeOptionsVariants`.`product_attribute_option_id` = `ProductAttributeOptions`.`id`) left JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_products` AS `Product` ON (`ProductVariant`.`product_id` = `Product`.`id`) left JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_checkout_vat_rates` AS `VatRate` ON (`Product`.`vat_rate_id` = `VatRate`.`id`) WHERE `ProductVariant`.`product_id` = 5 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`.*, `VatRate`.*, `Product`.`excludes_vat`, IF(Product.excludes_vat=1,ProductVariant.price*((VatRate.rate/100)+1),ProductVariant.price) AS calculatedprice, IF(Product.excludes_vat<>1,ProductVariant.price/((VatRate.rate/100)+1),ProductVariant.price) AS exvat, `ProductVariant`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_variants` AS `ProductVariant` left JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_products` AS `Product` ON (`ProductVariant`.`product_id` = `Product`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options_product_variants` AS `ProductAttributeOptionsVariants` ON (`ProductVariant`.`id` = `ProductAttributeOptionsVariants`.`product_variant_id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOption` ON (`ProductAttributeOptionsVariants`.`product_attribute_option_id` = `ProductAttributeOption`.`id`) left JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_checkout_vat_rates` AS `VatRate` ON (`Product`.`vat_rate_id` = `VatRate`.`id`) WHERE `ProductVariant`.`product_id` = 2 AND `ProductVariant`.`is_removed` <> '1' | 18 | 18 | 1 | maybe slow |
SELECT `ProductAttributeOption`.`id`, `ProductAttributeOption`.`product_attribute_id`, `ProductAttributeOption`.`name`, `ProductAttributeOption`.`description`, `ProductAttributeOption`.`sequence`, `ProductAttributeOption`.`created`, `ProductAttributeOption`.`modified`, `EvShopProductAttributeOptionsProductVariant`.`id`, `EvShopProductAttributeOptionsProductVariant`.`product_attribute_option_id`, `EvShopProductAttributeOptionsProductVariant`.`product_variant_id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOption` JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options_product_variants` AS `EvShopProductAttributeOptionsProductVariant` ON (`EvShopProductAttributeOptionsProductVariant`.`product_variant_id` IN (1476, 1477, 1478, 1479, 1481, 2040) AND `EvShopProductAttributeOptionsProductVariant`.`product_attribute_option_id` = `ProductAttributeOption`.`id`) WHERE `ProductAttributeOption`.`id` IN (129, 7, 120, 118, 55, 56, 8, 114, 123, 111, 9, 122, 110, 121, 11, 82, 57, 58, 53, 81, 80, 86, 117, 119, 124, 115, 42, 102, 101, 96, 95, 98, 97, 100, 99, 73, 14, 116, 104, 36, 37, 30, 31, 32, 18, 60, 107, 19, 106, 22, 92, 93, 94, 17, 16, 83, 23, 125, 126, 127, 128, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143) | 6 | 6 | 1 | maybe slow |
SELECT `Postcode`.`id`, `Postcode`.`outcode` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`postcodes` AS `Postcode` WHERE `outcode` LIKE 'DE4' LIMIT 1 | 1 | 1 | 0 | |
SELECT `ShippingCompany`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_companies` AS `ShippingCompany` WHERE `is_active` = '1' AND `pricing_only` = '1' | 0 | 0 | 0 | |
SELECT `ShippingCost`.*, `ShippingCompany`.*, IF(cost IS NULL AND shipping_company_id <> 7, -1, 0) AS nullswitch, `ShippingCompany`.`id`, `Plant`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_costs` AS `ShippingCost` LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_companies` AS `ShippingCompany` ON (`ShippingCost`.`shipping_company_id` = `ShippingCompany`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`plants` AS `Plant` ON (`ShippingCost`.`plant_id` = `Plant`.`id`) WHERE `Plant`.`is_active` = '1' AND `ShippingCompany`.`is_active` = '1' AND `postcode_id` = 663 AND `plant_id` = 9 AND ((`cost` >= 0) OR (`cost` IS NULL)) AND NOT (`shipping_company_id` IS NULL) AND `shipping_company_id` != 6 ORDER BY `nullswitch` DESC, `cost` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `ProductAttributeOptions`.`name`, `ProductAttributeOptions`.`description`, `Product`.`excludes_vat`, `VatRate`.`rate`, `ProductVariant`.`online_price`, IF(Product.excludes_vat=1,ProductVariant.price*((VatRate.rate/100)+1),ProductVariant.price) AS calculatedprice, IF(Product.excludes_vat<>1,ProductVariant.price/((VatRate.rate/100)+1),ProductVariant.price) AS exvat, IF(ProductAttributeOptions.description LIKE "%forceprice%", 2, -1) AS force_price, IF(ProductAttributeOptions.description LIKE "%default%", 1, 0) AS is_default, IF(ProductAttributeOptions.description LIKE "%nosurcharge%", 0, 1) AS has_surcharge, IF(ProductAttributeOptions.description LIKE "%separatesurcharge%", 0, 1) AS separate_surcharge, IF(ProductAttributeOptions.description LIKE "%fromprice%", 1, 0) AS from_price, IF(ProductAttributeOptions.description LIKE "%poa%", 1, 0) AS is_poa FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_variants` AS `ProductVariant` LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options_product_variants` AS `ProductAttributeOptionsVariants` ON (`ProductVariant`.`id` = `ProductAttributeOptionsVariants`.`product_variant_id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOptions` ON (`ProductAttributeOptionsVariants`.`product_attribute_option_id` = `ProductAttributeOptions`.`id`) left JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_products` AS `Product` ON (`ProductVariant`.`product_id` = `Product`.`id`) left JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_checkout_vat_rates` AS `VatRate` ON (`Product`.`vat_rate_id` = `VatRate`.`id`) WHERE `ProductVariant`.`product_id` = 2 AND `ProductVariant`.`is_removed` = '0' AND `ProductVariant`.`price` IS NOT NULL AND `ProductVariant`.`price` > 0 AND ((`ProductAttributeOptions`.`description` LIKE '%\"main\"%') OR (`ProductAttributeOptions`.`description` LIKE '%\"default\"%')) ORDER BY `force_price` DESC, `is_default` ASC, `calculatedprice` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `ProductVariant`.*, `VatRate`.*, `Product`.`excludes_vat`, IF(Product.excludes_vat=1,ProductVariant.price*((VatRate.rate/100)+1),ProductVariant.price) AS calculatedprice, IF(Product.excludes_vat<>1,ProductVariant.price/((VatRate.rate/100)+1),ProductVariant.price) AS exvat, `ProductVariant`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_variants` AS `ProductVariant` left JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_products` AS `Product` ON (`ProductVariant`.`product_id` = `Product`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options_product_variants` AS `ProductAttributeOptionsVariants` ON (`ProductVariant`.`id` = `ProductAttributeOptionsVariants`.`product_variant_id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOption` ON (`ProductAttributeOptionsVariants`.`product_attribute_option_id` = `ProductAttributeOption`.`id`) left JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_checkout_vat_rates` AS `VatRate` ON (`Product`.`vat_rate_id` = `VatRate`.`id`) WHERE `ProductVariant`.`product_id` = 6 AND `ProductVariant`.`is_removed` <> '1' | 12 | 12 | 1 | maybe slow |
SELECT `ProductAttributeOption`.`id`, `ProductAttributeOption`.`product_attribute_id`, `ProductAttributeOption`.`name`, `ProductAttributeOption`.`description`, `ProductAttributeOption`.`sequence`, `ProductAttributeOption`.`created`, `ProductAttributeOption`.`modified`, `EvShopProductAttributeOptionsProductVariant`.`id`, `EvShopProductAttributeOptionsProductVariant`.`product_attribute_option_id`, `EvShopProductAttributeOptionsProductVariant`.`product_variant_id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOption` JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options_product_variants` AS `EvShopProductAttributeOptionsProductVariant` ON (`EvShopProductAttributeOptionsProductVariant`.`product_variant_id` IN (65, 66, 103, 151, 545, 2039) AND `EvShopProductAttributeOptionsProductVariant`.`product_attribute_option_id` = `ProductAttributeOption`.`id`) WHERE `ProductAttributeOption`.`id` IN (129, 7, 120, 118, 55, 56, 8, 114, 123, 111, 9, 122, 110, 121, 11, 82, 57, 58, 53, 81, 80, 86, 117, 119, 124, 115, 42, 102, 101, 96, 95, 98, 97, 100, 99, 73, 14, 116, 104, 36, 37, 30, 31, 32, 18, 60, 107, 19, 106, 22, 92, 93, 94, 17, 16, 83, 23, 125, 126, 127, 128, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143) | 6 | 6 | 1 | maybe slow |
SELECT `Postcode`.`id`, `Postcode`.`outcode` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`postcodes` AS `Postcode` WHERE `outcode` LIKE 'DE4' LIMIT 1 | 1 | 1 | 0 | |
SELECT `ShippingCompany`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_companies` AS `ShippingCompany` WHERE `is_active` = '1' AND `pricing_only` = '1' | 0 | 0 | 0 | |
SELECT `ShippingCost`.*, `ShippingCompany`.*, IF(cost IS NULL AND shipping_company_id <> 7, -1, 0) AS nullswitch, `ShippingCompany`.`id`, `Plant`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_costs` AS `ShippingCost` LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_companies` AS `ShippingCompany` ON (`ShippingCost`.`shipping_company_id` = `ShippingCompany`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`plants` AS `Plant` ON (`ShippingCost`.`plant_id` = `Plant`.`id`) WHERE `Plant`.`is_active` = '1' AND `ShippingCompany`.`is_active` = '1' AND `postcode_id` = 663 AND `plant_id` = 9 AND ((`cost` >= 0) OR (`cost` IS NULL)) AND NOT (`shipping_company_id` IS NULL) AND `shipping_company_id` != 6 ORDER BY `nullswitch` DESC, `cost` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `ProductAttributeOptions`.`name`, `ProductAttributeOptions`.`description`, `Product`.`excludes_vat`, `VatRate`.`rate`, `ProductVariant`.`online_price`, IF(Product.excludes_vat=1,ProductVariant.price*((VatRate.rate/100)+1),ProductVariant.price) AS calculatedprice, IF(Product.excludes_vat<>1,ProductVariant.price/((VatRate.rate/100)+1),ProductVariant.price) AS exvat, IF(ProductAttributeOptions.description LIKE "%forceprice%", 2, -1) AS force_price, IF(ProductAttributeOptions.description LIKE "%default%", 1, 0) AS is_default, IF(ProductAttributeOptions.description LIKE "%nosurcharge%", 0, 1) AS has_surcharge, IF(ProductAttributeOptions.description LIKE "%separatesurcharge%", 0, 1) AS separate_surcharge, IF(ProductAttributeOptions.description LIKE "%fromprice%", 1, 0) AS from_price, IF(ProductAttributeOptions.description LIKE "%poa%", 1, 0) AS is_poa FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_variants` AS `ProductVariant` LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options_product_variants` AS `ProductAttributeOptionsVariants` ON (`ProductVariant`.`id` = `ProductAttributeOptionsVariants`.`product_variant_id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOptions` ON (`ProductAttributeOptionsVariants`.`product_attribute_option_id` = `ProductAttributeOptions`.`id`) left JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_products` AS `Product` ON (`ProductVariant`.`product_id` = `Product`.`id`) left JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_checkout_vat_rates` AS `VatRate` ON (`Product`.`vat_rate_id` = `VatRate`.`id`) WHERE `ProductVariant`.`product_id` = 6 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`.*, `VatRate`.*, `Product`.`excludes_vat`, IF(Product.excludes_vat=1,ProductVariant.price*((VatRate.rate/100)+1),ProductVariant.price) AS calculatedprice, IF(Product.excludes_vat<>1,ProductVariant.price/((VatRate.rate/100)+1),ProductVariant.price) AS exvat, `ProductVariant`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_variants` AS `ProductVariant` left JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_products` AS `Product` ON (`ProductVariant`.`product_id` = `Product`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options_product_variants` AS `ProductAttributeOptionsVariants` ON (`ProductVariant`.`id` = `ProductAttributeOptionsVariants`.`product_variant_id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOption` ON (`ProductAttributeOptionsVariants`.`product_attribute_option_id` = `ProductAttributeOption`.`id`) left JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_checkout_vat_rates` AS `VatRate` ON (`Product`.`vat_rate_id` = `VatRate`.`id`) WHERE `ProductVariant`.`product_id` = 8 AND `ProductVariant`.`is_removed` <> '1' | 18 | 18 | 1 | maybe slow |
SELECT `ProductAttributeOption`.`id`, `ProductAttributeOption`.`product_attribute_id`, `ProductAttributeOption`.`name`, `ProductAttributeOption`.`description`, `ProductAttributeOption`.`sequence`, `ProductAttributeOption`.`created`, `ProductAttributeOption`.`modified`, `EvShopProductAttributeOptionsProductVariant`.`id`, `EvShopProductAttributeOptionsProductVariant`.`product_attribute_option_id`, `EvShopProductAttributeOptionsProductVariant`.`product_variant_id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOption` JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options_product_variants` AS `EvShopProductAttributeOptionsProductVariant` ON (`EvShopProductAttributeOptionsProductVariant`.`product_variant_id` IN (71, 72, 105, 155, 553, 2080) AND `EvShopProductAttributeOptionsProductVariant`.`product_attribute_option_id` = `ProductAttributeOption`.`id`) WHERE `ProductAttributeOption`.`id` IN (129, 7, 120, 118, 55, 56, 8, 114, 123, 111, 9, 122, 110, 121, 11, 82, 57, 58, 53, 81, 80, 86, 117, 119, 124, 115, 42, 102, 101, 96, 95, 98, 97, 100, 99, 73, 14, 116, 104, 36, 37, 30, 31, 32, 18, 60, 107, 19, 106, 22, 92, 93, 94, 17, 16, 83, 23, 125, 126, 127, 128, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143) | 6 | 6 | 1 | maybe slow |
SELECT `Postcode`.`id`, `Postcode`.`outcode` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`postcodes` AS `Postcode` WHERE `outcode` LIKE 'DE4' LIMIT 1 | 1 | 1 | 0 | |
SELECT `ShippingCompany`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_companies` AS `ShippingCompany` WHERE `is_active` = '1' AND `pricing_only` = '1' | 0 | 0 | 0 | |
SELECT `ShippingCost`.*, `ShippingCompany`.*, IF(cost IS NULL AND shipping_company_id <> 7, -1, 0) AS nullswitch, `ShippingCompany`.`id`, `Plant`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_costs` AS `ShippingCost` LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_companies` AS `ShippingCompany` ON (`ShippingCost`.`shipping_company_id` = `ShippingCompany`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`plants` AS `Plant` ON (`ShippingCost`.`plant_id` = `Plant`.`id`) WHERE `Plant`.`is_active` = '1' AND `ShippingCompany`.`is_active` = '1' AND `postcode_id` = 663 AND `plant_id` = 9 AND ((`cost` >= 0) OR (`cost` IS NULL)) AND NOT (`shipping_company_id` IS NULL) AND `shipping_company_id` != 6 ORDER BY `nullswitch` DESC, `cost` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `ProductAttributeOptions`.`name`, `ProductAttributeOptions`.`description`, `Product`.`excludes_vat`, `VatRate`.`rate`, `ProductVariant`.`online_price`, IF(Product.excludes_vat=1,ProductVariant.price*((VatRate.rate/100)+1),ProductVariant.price) AS calculatedprice, IF(Product.excludes_vat<>1,ProductVariant.price/((VatRate.rate/100)+1),ProductVariant.price) AS exvat, IF(ProductAttributeOptions.description LIKE "%forceprice%", 2, -1) AS force_price, IF(ProductAttributeOptions.description LIKE "%default%", 1, 0) AS is_default, IF(ProductAttributeOptions.description LIKE "%nosurcharge%", 0, 1) AS has_surcharge, IF(ProductAttributeOptions.description LIKE "%separatesurcharge%", 0, 1) AS separate_surcharge, IF(ProductAttributeOptions.description LIKE "%fromprice%", 1, 0) AS from_price, IF(ProductAttributeOptions.description LIKE "%poa%", 1, 0) AS is_poa FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_variants` AS `ProductVariant` LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options_product_variants` AS `ProductAttributeOptionsVariants` ON (`ProductVariant`.`id` = `ProductAttributeOptionsVariants`.`product_variant_id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOptions` ON (`ProductAttributeOptionsVariants`.`product_attribute_option_id` = `ProductAttributeOptions`.`id`) left JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_products` AS `Product` ON (`ProductVariant`.`product_id` = `Product`.`id`) left JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_checkout_vat_rates` AS `VatRate` ON (`Product`.`vat_rate_id` = `VatRate`.`id`) WHERE `ProductVariant`.`product_id` = 8 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`.*, `VatRate`.*, `Product`.`excludes_vat`, IF(Product.excludes_vat=1,ProductVariant.price*((VatRate.rate/100)+1),ProductVariant.price) AS calculatedprice, IF(Product.excludes_vat<>1,ProductVariant.price/((VatRate.rate/100)+1),ProductVariant.price) AS exvat, `ProductVariant`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_variants` AS `ProductVariant` left JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_products` AS `Product` ON (`ProductVariant`.`product_id` = `Product`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options_product_variants` AS `ProductAttributeOptionsVariants` ON (`ProductVariant`.`id` = `ProductAttributeOptionsVariants`.`product_variant_id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOption` ON (`ProductAttributeOptionsVariants`.`product_attribute_option_id` = `ProductAttributeOption`.`id`) left JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_checkout_vat_rates` AS `VatRate` ON (`Product`.`vat_rate_id` = `VatRate`.`id`) WHERE `ProductVariant`.`product_id` = 7 AND `ProductVariant`.`is_removed` <> '1' | 12 | 12 | 1 | maybe slow |
SELECT `ProductAttributeOption`.`id`, `ProductAttributeOption`.`product_attribute_id`, `ProductAttributeOption`.`name`, `ProductAttributeOption`.`description`, `ProductAttributeOption`.`sequence`, `ProductAttributeOption`.`created`, `ProductAttributeOption`.`modified`, `EvShopProductAttributeOptionsProductVariant`.`id`, `EvShopProductAttributeOptionsProductVariant`.`product_attribute_option_id`, `EvShopProductAttributeOptionsProductVariant`.`product_variant_id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOption` JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options_product_variants` AS `EvShopProductAttributeOptionsProductVariant` ON (`EvShopProductAttributeOptionsProductVariant`.`product_variant_id` IN (83, 84, 107, 152, 548, 2024) AND `EvShopProductAttributeOptionsProductVariant`.`product_attribute_option_id` = `ProductAttributeOption`.`id`) WHERE `ProductAttributeOption`.`id` IN (129, 7, 120, 118, 55, 56, 8, 114, 123, 111, 9, 122, 110, 121, 11, 82, 57, 58, 53, 81, 80, 86, 117, 119, 124, 115, 42, 102, 101, 96, 95, 98, 97, 100, 99, 73, 14, 116, 104, 36, 37, 30, 31, 32, 18, 60, 107, 19, 106, 22, 92, 93, 94, 17, 16, 83, 23, 125, 126, 127, 128, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143) | 6 | 6 | 1 | maybe slow |
SELECT `Postcode`.`id`, `Postcode`.`outcode` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`postcodes` AS `Postcode` WHERE `outcode` LIKE 'DE4' LIMIT 1 | 1 | 1 | 1 | |
SELECT `ShippingCompany`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_companies` AS `ShippingCompany` WHERE `is_active` = '1' AND `pricing_only` = '1' | 0 | 0 | 0 | |
SELECT `ShippingCost`.*, `ShippingCompany`.*, IF(cost IS NULL AND shipping_company_id <> 7, -1, 0) AS nullswitch, `ShippingCompany`.`id`, `Plant`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_costs` AS `ShippingCost` LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_companies` AS `ShippingCompany` ON (`ShippingCost`.`shipping_company_id` = `ShippingCompany`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`plants` AS `Plant` ON (`ShippingCost`.`plant_id` = `Plant`.`id`) WHERE `Plant`.`is_active` = '1' AND `ShippingCompany`.`is_active` = '1' AND `postcode_id` = 663 AND `plant_id` = 9 AND ((`cost` >= 0) OR (`cost` IS NULL)) AND NOT (`shipping_company_id` IS NULL) AND `shipping_company_id` != 6 ORDER BY `nullswitch` DESC, `cost` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `ProductAttributeOptions`.`name`, `ProductAttributeOptions`.`description`, `Product`.`excludes_vat`, `VatRate`.`rate`, `ProductVariant`.`online_price`, IF(Product.excludes_vat=1,ProductVariant.price*((VatRate.rate/100)+1),ProductVariant.price) AS calculatedprice, IF(Product.excludes_vat<>1,ProductVariant.price/((VatRate.rate/100)+1),ProductVariant.price) AS exvat, IF(ProductAttributeOptions.description LIKE "%forceprice%", 2, -1) AS force_price, IF(ProductAttributeOptions.description LIKE "%default%", 1, 0) AS is_default, IF(ProductAttributeOptions.description LIKE "%nosurcharge%", 0, 1) AS has_surcharge, IF(ProductAttributeOptions.description LIKE "%separatesurcharge%", 0, 1) AS separate_surcharge, IF(ProductAttributeOptions.description LIKE "%fromprice%", 1, 0) AS from_price, IF(ProductAttributeOptions.description LIKE "%poa%", 1, 0) AS is_poa FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_variants` AS `ProductVariant` LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options_product_variants` AS `ProductAttributeOptionsVariants` ON (`ProductVariant`.`id` = `ProductAttributeOptionsVariants`.`product_variant_id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_product_attribute_options` AS `ProductAttributeOptions` ON (`ProductAttributeOptionsVariants`.`product_attribute_option_id` = `ProductAttributeOptions`.`id`) left JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_shop_products` AS `Product` ON (`ProductVariant`.`product_id` = `Product`.`id`) left JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`ev_checkout_vat_rates` AS `VatRate` ON (`Product`.`vat_rate_id` = `VatRate`.`id`) WHERE `ProductVariant`.`product_id` = 7 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_decorativeaggregates_uat`.`postcodes` AS `Postcode` WHERE `outcode` LIKE 'DE4' LIMIT 1 | 1 | 1 | 0 | |
SELECT `ShippingCompany`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_companies` AS `ShippingCompany` WHERE `is_active` = '1' AND `pricing_only` = '1' | 0 | 0 | 0 | |
SELECT `ShippingCost`.*, `ShippingCompany`.*, IF(cost IS NULL AND shipping_company_id <> 7, -1, 0) AS nullswitch, `ShippingCompany`.`id`, `Plant`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_costs` AS `ShippingCost` LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_companies` AS `ShippingCompany` ON (`ShippingCost`.`shipping_company_id` = `ShippingCompany`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`plants` AS `Plant` ON (`ShippingCost`.`plant_id` = `Plant`.`id`) WHERE `Plant`.`is_active` = '1' AND `ShippingCompany`.`is_active` = '1' AND `postcode_id` = 663 AND `plant_id` = 9 AND ((`cost` >= 0) OR (`cost` IS NULL)) AND NOT (`shipping_company_id` IS NULL) AND `shipping_company_id` != 6 ORDER BY `nullswitch` DESC, `cost` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `Postcode`.`id`, `Postcode`.`outcode` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`postcodes` AS `Postcode` WHERE `outcode` LIKE 'DE4' LIMIT 1 | 1 | 1 | 0 | |
SELECT `ShippingCompany`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_companies` AS `ShippingCompany` WHERE `is_active` = '1' AND `pricing_only` = '1' | 0 | 0 | 0 | |
SELECT `ShippingCost`.*, `ShippingCompany`.*, IF(cost IS NULL AND shipping_company_id <> 7, -1, 0) AS nullswitch, `ShippingCompany`.`id`, `Plant`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_costs` AS `ShippingCost` LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_companies` AS `ShippingCompany` ON (`ShippingCost`.`shipping_company_id` = `ShippingCompany`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`plants` AS `Plant` ON (`ShippingCost`.`plant_id` = `Plant`.`id`) WHERE `Plant`.`is_active` = '1' AND `ShippingCompany`.`is_active` = '1' AND `postcode_id` = 663 AND `plant_id` = 9 AND ((`cost` >= 0) OR (`cost` IS NULL)) AND NOT (`shipping_company_id` IS NULL) AND `shipping_company_id` != 6 ORDER BY `nullswitch` DESC, `cost` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `Postcode`.`id`, `Postcode`.`outcode` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`postcodes` AS `Postcode` WHERE `outcode` LIKE 'DE4' LIMIT 1 | 1 | 1 | 0 | |
SELECT `ShippingCompany`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_companies` AS `ShippingCompany` WHERE `is_active` = '1' AND `pricing_only` = '1' | 0 | 0 | 0 | |
SELECT `ShippingCost`.*, `ShippingCompany`.*, IF(cost IS NULL AND shipping_company_id <> 7, -1, 0) AS nullswitch, `ShippingCompany`.`id`, `Plant`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_costs` AS `ShippingCost` LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_companies` AS `ShippingCompany` ON (`ShippingCost`.`shipping_company_id` = `ShippingCompany`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`plants` AS `Plant` ON (`ShippingCost`.`plant_id` = `Plant`.`id`) WHERE `Plant`.`is_active` = '1' AND `ShippingCompany`.`is_active` = '1' AND `postcode_id` = 663 AND `plant_id` = 9 AND ((`cost` >= 0) OR (`cost` IS NULL)) AND NOT (`shipping_company_id` IS NULL) AND `shipping_company_id` != 6 ORDER BY `nullswitch` DESC, `cost` ASC LIMIT 1 | 1 | 1 | 2 | maybe slow |
SELECT `Postcode`.`id`, `Postcode`.`outcode` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`postcodes` AS `Postcode` WHERE `outcode` LIKE 'DE4' LIMIT 1 | 1 | 1 | 0 | |
SELECT `ShippingCompany`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_companies` AS `ShippingCompany` WHERE `is_active` = '1' AND `pricing_only` = '1' | 0 | 0 | 0 | |
SELECT `ShippingCost`.*, `ShippingCompany`.*, IF(cost IS NULL AND shipping_company_id <> 7, -1, 0) AS nullswitch, `ShippingCompany`.`id`, `Plant`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_costs` AS `ShippingCost` LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_companies` AS `ShippingCompany` ON (`ShippingCost`.`shipping_company_id` = `ShippingCompany`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`plants` AS `Plant` ON (`ShippingCost`.`plant_id` = `Plant`.`id`) WHERE `Plant`.`is_active` = '1' AND `ShippingCompany`.`is_active` = '1' AND `postcode_id` = 663 AND `plant_id` = 9 AND ((`cost` >= 0) OR (`cost` IS NULL)) AND NOT (`shipping_company_id` IS NULL) AND `shipping_company_id` != 6 ORDER BY `nullswitch` DESC, `cost` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `Postcode`.`id`, `Postcode`.`outcode` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`postcodes` AS `Postcode` WHERE `outcode` LIKE 'DE4' LIMIT 1 | 1 | 1 | 0 | |
SELECT `ShippingCompany`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_companies` AS `ShippingCompany` WHERE `is_active` = '1' AND `pricing_only` = '1' | 0 | 0 | 0 | |
SELECT `ShippingCost`.*, `ShippingCompany`.*, IF(cost IS NULL AND shipping_company_id <> 7, -1, 0) AS nullswitch, `ShippingCompany`.`id`, `Plant`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_costs` AS `ShippingCost` LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_companies` AS `ShippingCompany` ON (`ShippingCost`.`shipping_company_id` = `ShippingCompany`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`plants` AS `Plant` ON (`ShippingCost`.`plant_id` = `Plant`.`id`) WHERE `Plant`.`is_active` = '1' AND `ShippingCompany`.`is_active` = '1' AND `postcode_id` = 663 AND `plant_id` = 9 AND ((`cost` >= 0) OR (`cost` IS NULL)) AND NOT (`shipping_company_id` IS NULL) AND `shipping_company_id` != 6 ORDER BY `nullswitch` DESC, `cost` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `Postcode`.`id`, `Postcode`.`outcode` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`postcodes` AS `Postcode` WHERE `outcode` LIKE 'DE4' LIMIT 1 | 1 | 1 | 0 | |
SELECT `ShippingCompany`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_companies` AS `ShippingCompany` WHERE `is_active` = '1' AND `pricing_only` = '1' | 0 | 0 | 0 | |
SELECT `ShippingCost`.*, `ShippingCompany`.*, IF(cost IS NULL AND shipping_company_id <> 7, -1, 0) AS nullswitch, `ShippingCompany`.`id`, `Plant`.`id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_costs` AS `ShippingCost` LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`shipping_companies` AS `ShippingCompany` ON (`ShippingCost`.`shipping_company_id` = `ShippingCompany`.`id`) LEFT JOIN `cd_decorative_aggregates_decorativeaggregates_uat`.`plants` AS `Plant` ON (`ShippingCost`.`plant_id` = `Plant`.`id`) WHERE `Plant`.`is_active` = '1' AND `ShippingCompany`.`is_active` = '1' AND `postcode_id` = 663 AND `plant_id` = 9 AND ((`cost` >= 0) OR (`cost` IS NULL)) AND NOT (`shipping_company_id` IS NULL) AND `shipping_company_id` != 6 ORDER BY `nullswitch` DESC, `cost` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `Menu`.`id`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`name`, `Menu`.`url`, `Menu`.`pattern`, `Menu`.`plugin`, `Menu`.`controller`, `Menu`.`model`, `Menu`.`model_id`, `Menu`.`action`, `Menu`.`class`, `Menu`.`new_window`, `Menu`.`is_menu_hidden`, `Menu`.`is_active`, `Menu`.`created`, `Menu`.`modified`, `Menu`.`user_group_id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`menus` AS `Menu` WHERE `Menu`.`id` = 7 ORDER BY `lft` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `Menu`.`id`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`name`, `Menu`.`url`, `Menu`.`pattern`, `Menu`.`plugin`, `Menu`.`controller`, `Menu`.`model`, `Menu`.`model_id`, `Menu`.`action`, `Menu`.`class`, `Menu`.`new_window`, `Menu`.`is_menu_hidden`, `Menu`.`is_active`, `Menu`.`created`, `Menu`.`modified`, `Menu`.`user_group_id` FROM `cd_decorative_aggregates_decorativeaggregates_uat`.`menus` AS `Menu` WHERE `lft` > 92 AND `rght` < 115 AND `is_active` = '1' ORDER BY `lft` ASC | 11 | 11 | 1 | maybe slow |
SELECT `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 | 1 | maybe slow |
35 duplicate queries run.
Peak Memory Use 25.05 MB
Message | Memory use |
---|---|
Component initialization | 4.83 MB |
Controller action start | 8.84 MB |
Controller render start | 13.09 MB |
View render complete | 15.15 MB |
Total Request Time: 598 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 18.36 | |
Event: Controller.initialize | 62.83 | |
Event: Controller.startup | 0.52 | |
Controller action | 183.50 | |
Event: Controller.beforeRender | 51.71 | |
» Processing toolbar data | 39.28 | |
Rendering View | 114.07 | |
» Event: View.beforeRender | 0.58 | |
» Rendering APP/View/AppCategories/view.ctp | 58.77 | |
» » Rendering APP/View/Elements/categories_vertical.ctp | 18.33 | |
» » Rendering APP/View/Elements/postcode.ctp | 0.70 | |
» » Rendering APP/View/Elements/product_block.ctp | 6.99 | |
» » Rendering APP/View/Elements/product_block.ctp #2 | 6.31 | |
» » Rendering APP/View/Elements/product_block.ctp #3 | 6.23 | |
» » Rendering APP/View/Elements/product_block.ctp #4 | 6.34 | |
» » Rendering APP/View/Elements/product_block.ctp #5 | 6.32 | |
» » Rendering APP/View/Elements/product_block.ctp #6 | 6.33 | |
» Event: View.afterRender | 0.04 | |
» Event: View.beforeLayout | 0.04 | |
» Rendering APP/View/Layouts/default.ctp | 52.78 | |
» » Rendering APP/View/Elements/preconnects.ctp | 0.51 | |
» » Rendering APP/View/Elements/beta_warning.ctp | 0.12 | |
» » Rendering APP/View/Elements/site_header.ctp | 46.51 | |
» » » Rendering APP/View/Elements/menu_mobile.ctp | 2.48 | |
» » Rendering APP/View/Elements/postcode_messages.ctp | 0.16 | |
» » Rendering APP/View/Elements/site_footer.ctp | 2.14 | |
Event: View.afterLayout | 0.00 |
Constant | Value |
---|---|
MONDAY | (int) 1 |
TUESDAY | (int) 2 |
WEDNESDAY | (int) 3 |
THURSDAY | (int) 4 |
FRIDAY | (int) 5 |
SATURDAY | (int) 6 |
SUNDAY | (int) 7 |
RANDOM_COMPAT_READ_BUFFER | (int) 8 |
PHP_INT_MIN | (int) -9223372036854775808 |
ORDERSTATUS_CREATED | '1' |
ORDERSTATUS_PENDING | '2' |
ORDERSTATUS_COMPLETED | '3' |
ORDERSTATUS_CANCELLED | '4' |
ORDERSTATUS_DISPATCHED | '5' |
ORDERSTATUS_REFUNDED | '6' |
ORDERSTATUS_PART_DISPATCHED | '7' |
ORDERSTATUS_CHECKED_BY_DA | '8' |
ORDERSTATUS_DISPATCHED_BY_DA | '9' |
ORDERSTATUS_ON_HOLD | '10' |
ORDERSTATUS_ON_MANIFEST | '11' |
ORDERSTATUS_COPIED | '12' |
ORDERSTATUS_COLLECTION | '13' |
ORDERSTATUS_COLLECTED | '14' |
ORDERSTATUS_QUOTE | '15' |
ORDERSTATUS_ON_HOLD_STOCK | '16' |
FPDF_VERSION | '1.6' |
Constant | Value |
---|---|
APP | '/var/www/cd/decorative-aggregates/uat/decorativeaggregates/releases/46/www/app/' |
APP_DIR | 'app' |
APPLIBS | '/var/www/cd/decorative-aggregates/uat/decorativeaggregates/releases/46/www/app/Lib/' |
CACHE | '/var/www/cd/decorative-aggregates/uat/decorativeaggregates/releases/46/www/app/tmp/cache/' |
CAKE | '/var/www/cd/decorative-aggregates/uat/decorativeaggregates/releases/46/www/Vendor/cakephp/cakephp/lib/Cake/' |
CAKE_CORE_INCLUDE_PATH | '/var/www/cd/decorative-aggregates/uat/decorativeaggregates/releases/46/www/Vendor/cakephp/cakephp/lib' |
CORE_PATH | '/var/www/cd/decorative-aggregates/uat/decorativeaggregates/releases/46/www/Vendor/cakephp/cakephp/lib/' |
CAKE_VERSION | '2.5.8' |
CSS | '/var/www/cd/decorative-aggregates/uat/decorativeaggregates/releases/46/www/app/webroot/css/' |
CSS_URL | 'css/' |
DS | '/' |
FULL_BASE_URL | 'http://decorativeaggregates.uat2.evoluted.net' |
IMAGES | '/var/www/cd/decorative-aggregates/uat/decorativeaggregates/releases/46/www/app/webroot/img/' |
IMAGES_URL | 'img/' |
JS | '/var/www/cd/decorative-aggregates/uat/decorativeaggregates/releases/46/www/app/webroot/js/' |
JS_URL | 'js/' |
LOGS | '/var/www/cd/decorative-aggregates/uat/decorativeaggregates/releases/46/www/app/tmp/logs/' |
ROOT | '/var/www/cd/decorative-aggregates/uat/decorativeaggregates/releases/46/www' |
TESTS | '/var/www/cd/decorative-aggregates/uat/decorativeaggregates/releases/46/www/app/Test/' |
TMP | '/var/www/cd/decorative-aggregates/uat/decorativeaggregates/releases/46/www/app/tmp/' |
VENDORS | '/var/www/cd/decorative-aggregates/uat/decorativeaggregates/releases/46/www/vendors/' |
WEBROOT_DIR | 'webroot' |
WWW_ROOT | '/var/www/cd/decorative-aggregates/uat/decorativeaggregates/releases/46/www/app/webroot/' |
Environment Variable | Value |
---|---|
Php Version | '5.6.40-78+ubuntu20.04.1+deb.sury.org+1' |
Redirect Status | '200' |
Http Host | 'decorativeaggregates.uat2.evoluted.net' |
Http X Forwarded Scheme | 'https' |
Http X Forwarded Proto | 'https' |
Http X Forwarded For | '18.221.192.248' |
Http X Real Ip | '18.221.192.248' |
Http Connection | 'close' |
Http Accept | '*/*' |
Http User Agent | 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' |
Http Accept Encoding | 'gzip, br, zstd, deflate' |
Path | '/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin' |
Server Signature | 'Apache/2.4.41 (Ubuntu) Server at decorativeaggregates.uat2.evoluted.net Port 80' |
Server Software | 'Apache/2.4.41 (Ubuntu)' |
Server Name | 'decorativeaggregates.uat2.evoluted.net' |
Server Addr | '10.35.1.2' |
Server Port | '80' |
Remote Addr | '10.35.0.1' |
Document Root | '/var/www/cd/decorative-aggregates/uat/decorativeaggregates/releases/46/www/app/webroot' |
Request Scheme | 'http' |
Context Prefix | '' |
Context Document Root | '/var/www/cd/decorative-aggregates/uat/decorativeaggregates/releases/46/www/app/webroot' |
Server Admin | '[no address given]' |
Script Filename | '/var/www/cd/decorative-aggregates/uat/decorativeaggregates/releases/46/www/app/webroot/index.php' |
Remote Port | '37416' |
Redirect Url | '/category/limestone-history' |
Gateway Interface | 'CGI/1.1' |
Server Protocol | 'HTTP/1.1' |
Request Method | 'GET' |
Query String | '' |
Request Uri | '/category/limestone-history' |
Script Name | '/index.php' |
Php Self | '/index.php' |
Request Time Float | (float) 1732335797.911 |
Request Time | (int) 1732335797 |
Db Name | 'cd_decorative_aggregates_decorativeaggregates_uat' |
Db User | 'gitlab_cd' |
Db Pass | 'f9rm8uev' |
Db Host | 'database.staging.evoluted.net' |
Environment | 'PREVIEW' |
Branch | 'uat' |
Preview Url | 'http://decorativeaggregates.uat2.evoluted.net' |
Application Prefix | 'decorativeaggregates' |
Https | true |