Symfony Profiler

Query Metrics

43 Database Queries

17 Different statements

68.95 ms Query time

10 Invalid entities

78 Managed entities

Queries

Group similar statements

default connection


SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.u_date AS u_date_5, t0.id AS id_6, t0.sira AS sira_7, t0.code AS code_8, t0.del AS del_9, t0.name AS name_10, t0.url AS url_11, t0.short_name AS short_name_12, t0.site_title AS site_title_13, t0.site_description AS site_description_14 FROM web_site t0 WHERE t0.id = ?
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.u_date AS u_date_5, t0.id AS id_6, t0.sira AS sira_7, t0.code AS code_8, t0.del AS del_9, t0.freeSample AS freeSample_10, t0.gap AS gap_11, t0.projects_slab AS projects_slab_12, t0.dummy AS dummy_13, t0.title AS title_14, t0.brand AS brand_15, t0.product_type AS product_type_16, t0.sub_title AS sub_title_17, t0.title_seo AS title_seo_18, t0.web_group_name AS web_group_name_19, t0.photo AS photo_20, t0.photo_title AS photo_title_21, t0.photo_sub_title AS photo_sub_title_22, t0.little_description AS little_description_23, t0.description AS description_24, t0.meta_title AS meta_title_25, t0.meta_keywords AS meta_keywords_26, t0.meta_description AS meta_description_27, t0.special_offer AS special_offer_28, t0.most_popular AS most_popular_29, t0.best_sellers AS best_sellers_30, t0.suggested_fixing AS suggested_fixing_31, t0.review_average AS review_average_32, t0.free_delivery AS free_delivery_33, t0.new_item AS new_item_34, t0.last_id AS last_id_35, t0.last_url AS last_url_36, t0.rss_xml AS rss_xml_37, t0.price AS price_38, t0.show_control AS show_control_39, t0.courier_option AS courier_option_40, t0.show_first AS show_first_41, t0.tile_sealer AS tile_sealer_42, t0.tile_adhesive AS tile_adhesive_43, t0.samples_weight AS samples_weight_44, t0.default_category AS default_category_45, t0.default_alt_category AS default_alt_category_46, t0.type AS type_47, t0.per AS per_48, t0.site_id AS site_id_49, t0.item_id AS item_id_50 FROM web_item_detail t0 WHERE t0.title_seo = ? AND t0.site_id = ? AND t0.del = ? LIMIT 1
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.u_date AS u_date_5, t0.id AS id_6, t0.sira AS sira_7, t0.code AS code_8, t0.del AS del_9, t0.status AS status_10, t0.title AS title_11, t0.title_seo AS title_seo_12, t0.footer_title AS footer_title_13, t0.meta_title AS meta_title_14, t0.meta_keywords AS meta_keywords_15, t0.meta_description AS meta_description_16, t0.seo_description AS seo_description_17, t0.group_name AS group_name_18, t0.group_status AS group_status_19, t0.meta_tickets AS meta_tickets_20, t0.site_id AS site_id_21, t0.category_id AS category_id_22 FROM web_category t0 WHERE t0.id = ?
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.u_date AS u_date_5, t0.id AS id_6, t0.sira AS sira_7, t0.code AS code_8, t0.del AS del_9, t0.status AS status_10, t0.title AS title_11, t0.title_seo AS title_seo_12, t0.footer_title AS footer_title_13, t0.meta_title AS meta_title_14, t0.meta_keywords AS meta_keywords_15, t0.meta_description AS meta_description_16, t0.seo_description AS seo_description_17, t0.group_name AS group_name_18, t0.group_status AS group_status_19, t0.meta_tickets AS meta_tickets_20, t0.site_id AS site_id_21, t0.category_id AS category_id_22 FROM web_category t0 WHERE t0.id = ?
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.u_date AS u_date_5, t0.id AS id_6, t0.sira AS sira_7, t0.code AS code_8, t0.del AS del_9, t0.title AS title_10, t0.title_seo AS title_seo_11, t0.size_name AS size_name_12, t0.size_description AS size_description_13, t0.web_group_name AS web_group_name_14, t0.web_listele AS web_listele_15, t0.price AS price_16, t0.old_price AS old_price_17, t0.discount AS discount_18, t0.photo AS photo_19, t0.little_description AS little_description_20, t0.description AS description_21, t0.meta_title AS meta_title_22, t0.meta_description AS meta_description_23, t0.show_control AS show_control_24, t0.special_offer AS special_offer_25, t0.most_popular AS most_popular_26, t0.best_sellers AS best_sellers_27, t0.product_code AS product_code_28, t0.suggested_fixing AS suggested_fixing_29, t0.review_average AS review_average_30, t0.free_delivery AS free_delivery_31, t0.new_item AS new_item_32, t0.stock AS stock_33, t0.last_id AS last_id_34, t0.last_url AS last_url_35, t0.rss_xml AS rss_xml_36, t0.show_first AS show_first_37, t0.tile_grout AS tile_grout_38, t0.site_id AS site_id_39, t0.item_id AS item_id_40, t0.web_item_detail_id AS web_item_detail_id_41 FROM web_item t0 WHERE t0.web_item_detail_id = ? LIMIT 1
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.u_date AS u_date_5, t0.id AS id_6, t0.sira AS sira_7, t0.code AS code_8, t0.del AS del_9, t0.name AS name_10, t0.email AS email_11, t0.comment AS comment_12, t0.score AS score_13, t0.title AS title_14, t0.city AS city_15, t0.status AS status_16, t0.web_item_detail_id AS web_item_detail_id_17, t0.site_id AS site_id_18 FROM web_item_review t0 WHERE t0.web_item_detail_id = ? AND t0.status = ? AND t0.del = ? AND t0.site_id = ? ORDER BY t0.id DESC
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.u_date AS u_date_5, t0.id AS id_6, t0.sira AS sira_7, t0.code AS code_8, t0.del AS del_9, t0.name AS name_10, t0.email AS email_11, t0.question AS question_12, t0.answer AS answer_13, t0.status AS status_14, t0.web_item_detail_id AS web_item_detail_id_15, t0.site_id AS site_id_16 FROM web_item_question t0 WHERE t0.web_item_detail_id = ? AND t0.status = ? AND t0.del = ? AND t0.site_id = ? ORDER BY t0.id DESC
SELECT w0_.id AS id_0, w0_.price AS price_1, w0_.size_name AS size_name_2, w0_.size_description AS size_description_3, w0_.stock AS stock_4, w0_.old_price AS old_price_5, w0_.discount AS discount_6, sum(i1_.free_stock) AS sclr_7, i2_.status AS status_8, i2_.um_quantity AS um_quantity_9, u3_.unit_measure AS unit_measure_10, u4_.type AS type_11 FROM web_item w0_ INNER JOIN web_site w5_ ON w0_.site_id = w5_.id INNER JOIN item i2_ ON w0_.item_id = i2_.id INNER JOIN unit_measure u3_ ON i2_.um_id = u3_.id LEFT JOIN item_warehouse i1_ ON i2_.id = i1_.item_id LEFT JOIN unit_type u4_ ON i2_.unit_type_id = u4_.id INNER JOIN web_item_detail w6_ ON w0_.web_item_detail_id = w6_.id WHERE w0_.show_control = 1 AND w0_.del = 0 AND w5_.id = ? AND i2_.web_group_name = ? AND w6_.id = ? GROUP BY w0_.id ORDER BY w0_.price + 0 ASC, w0_.size_name ASC
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.u_date AS u_date_5, t0.id AS id_6, t0.sira AS sira_7, t0.code AS code_8, t0.del AS del_9, t0.freeSample AS freeSample_10, t0.gap AS gap_11, t0.projects_slab AS projects_slab_12, t0.dummy AS dummy_13, t0.title AS title_14, t0.brand AS brand_15, t0.product_type AS product_type_16, t0.sub_title AS sub_title_17, t0.title_seo AS title_seo_18, t0.web_group_name AS web_group_name_19, t0.photo AS photo_20, t0.photo_title AS photo_title_21, t0.photo_sub_title AS photo_sub_title_22, t0.little_description AS little_description_23, t0.description AS description_24, t0.meta_title AS meta_title_25, t0.meta_keywords AS meta_keywords_26, t0.meta_description AS meta_description_27, t0.special_offer AS special_offer_28, t0.most_popular AS most_popular_29, t0.best_sellers AS best_sellers_30, t0.suggested_fixing AS suggested_fixing_31, t0.review_average AS review_average_32, t0.free_delivery AS free_delivery_33, t0.new_item AS new_item_34, t0.last_id AS last_id_35, t0.last_url AS last_url_36, t0.rss_xml AS rss_xml_37, t0.price AS price_38, t0.show_control AS show_control_39, t0.courier_option AS courier_option_40, t0.show_first AS show_first_41, t0.tile_sealer AS tile_sealer_42, t0.tile_adhesive AS tile_adhesive_43, t0.samples_weight AS samples_weight_44, t0.default_category AS default_category_45, t0.default_alt_category AS default_alt_category_46, t0.type AS type_47, t0.per AS per_48, t0.site_id AS site_id_49, t0.item_id AS item_id_50 FROM web_item_detail t0 INNER JOIN web_item_details_needs ON t0.id = web_item_details_needs.need_item_id WHERE web_item_details_needs.item_id = ?
SELECT count(w0_.id) AS sclr_0 FROM web_item_detail w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.del = 0 AND w1_.id = ? AND w0_.web_group_name = ?
SELECT w0_.price AS price_0, w0_.old_price AS old_price_1, w0_.discount AS discount_2, w0_.show_control AS show_control_3 FROM web_item w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id INNER JOIN item i2_ ON w0_.item_id = i2_.id WHERE w0_.show_control = 1 AND i2_.status <> 2 AND w0_.del = 0 AND w1_.id = ? AND w0_.web_group_name = ? AND i2_.web_group_name = ? ORDER BY w0_.price + 0 ASC LIMIT 1
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
SELECT count(w0_.id) AS sclr_0 FROM web_item_detail w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.del = 0 AND w1_.id = ? AND w0_.web_group_name = ?
SELECT w0_.price AS price_0, w0_.old_price AS old_price_1, w0_.discount AS discount_2, w0_.show_control AS show_control_3 FROM web_item w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id INNER JOIN item i2_ ON w0_.item_id = i2_.id WHERE w0_.show_control = 1 AND i2_.status <> 2 AND w0_.del = 0 AND w1_.id = ? AND w0_.web_group_name = ? AND i2_.web_group_name = ? ORDER BY w0_.price + 0 ASC LIMIT 1
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
SELECT count(w0_.id) AS sclr_0 FROM web_item_detail w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.del = 0 AND w1_.id = ? AND w0_.web_group_name = ?
SELECT w0_.price AS price_0, w0_.old_price AS old_price_1, w0_.discount AS discount_2, w0_.show_control AS show_control_3 FROM web_item w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id INNER JOIN item i2_ ON w0_.item_id = i2_.id WHERE w0_.show_control = 1 AND i2_.status <> 2 AND w0_.del = 0 AND w1_.id = ? AND w0_.web_group_name = ? AND i2_.web_group_name = ? ORDER BY w0_.price + 0 ASC LIMIT 1
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
SELECT count(w0_.id) AS sclr_0 FROM web_item_detail w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.del = 0 AND w1_.id = ? AND w0_.web_group_name = ?
SELECT w0_.price AS price_0, w0_.old_price AS old_price_1, w0_.discount AS discount_2, w0_.show_control AS show_control_3 FROM web_item w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id INNER JOIN item i2_ ON w0_.item_id = i2_.id WHERE w0_.show_control = 1 AND i2_.status <> 2 AND w0_.del = 0 AND w1_.id = ? AND w0_.web_group_name = ? AND i2_.web_group_name = ? ORDER BY w0_.price + 0 ASC LIMIT 1
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.u_date AS u_date_5, t0.id AS id_6, t0.sira AS sira_7, t0.code AS code_8, t0.del AS del_9, t0.freeSample AS freeSample_10, t0.gap AS gap_11, t0.projects_slab AS projects_slab_12, t0.dummy AS dummy_13, t0.title AS title_14, t0.brand AS brand_15, t0.product_type AS product_type_16, t0.sub_title AS sub_title_17, t0.title_seo AS title_seo_18, t0.web_group_name AS web_group_name_19, t0.photo AS photo_20, t0.photo_title AS photo_title_21, t0.photo_sub_title AS photo_sub_title_22, t0.little_description AS little_description_23, t0.description AS description_24, t0.meta_title AS meta_title_25, t0.meta_keywords AS meta_keywords_26, t0.meta_description AS meta_description_27, t0.special_offer AS special_offer_28, t0.most_popular AS most_popular_29, t0.best_sellers AS best_sellers_30, t0.suggested_fixing AS suggested_fixing_31, t0.review_average AS review_average_32, t0.free_delivery AS free_delivery_33, t0.new_item AS new_item_34, t0.last_id AS last_id_35, t0.last_url AS last_url_36, t0.rss_xml AS rss_xml_37, t0.price AS price_38, t0.show_control AS show_control_39, t0.courier_option AS courier_option_40, t0.show_first AS show_first_41, t0.tile_sealer AS tile_sealer_42, t0.tile_adhesive AS tile_adhesive_43, t0.samples_weight AS samples_weight_44, t0.default_category AS default_category_45, t0.default_alt_category AS default_alt_category_46, t0.type AS type_47, t0.per AS per_48, t0.site_id AS site_id_49, t0.item_id AS item_id_50 FROM web_item_detail t0 INNER JOIN web_item_details_fixings ON t0.id = web_item_details_fixings.fixing_item_id WHERE web_item_details_fixings.item_id = ?
SELECT count(w0_.id) AS sclr_0 FROM web_item_detail w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.del = 0 AND w1_.id = ? AND w0_.web_group_name = ?
SELECT w0_.price AS price_0, w0_.old_price AS old_price_1, w0_.discount AS discount_2, w0_.show_control AS show_control_3 FROM web_item w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id INNER JOIN item i2_ ON w0_.item_id = i2_.id WHERE w0_.show_control = 1 AND i2_.status <> 2 AND w0_.del = 0 AND w1_.id = ? AND w0_.web_group_name = ? AND i2_.web_group_name = ? ORDER BY w0_.price + 0 ASC LIMIT 1
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
SELECT count(w0_.id) AS sclr_0 FROM web_item_detail w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.del = 0 AND w1_.id = ? AND w0_.web_group_name = ?
SELECT w0_.price AS price_0, w0_.old_price AS old_price_1, w0_.discount AS discount_2, w0_.show_control AS show_control_3 FROM web_item w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id INNER JOIN item i2_ ON w0_.item_id = i2_.id WHERE w0_.show_control = 1 AND i2_.status <> 2 AND w0_.del = 0 AND w1_.id = ? AND w0_.web_group_name = ? AND i2_.web_group_name = ? ORDER BY w0_.price + 0 ASC LIMIT 1
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
SELECT count(w0_.id) AS sclr_0 FROM web_item_detail w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.del = 0 AND w1_.id = ? AND w0_.web_group_name = ?
SELECT w0_.price AS price_0, w0_.old_price AS old_price_1, w0_.discount AS discount_2, w0_.show_control AS show_control_3 FROM web_item w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id INNER JOIN item i2_ ON w0_.item_id = i2_.id WHERE w0_.show_control = 1 AND i2_.status <> 2 AND w0_.del = 0 AND w1_.id = ? AND w0_.web_group_name = ? AND i2_.web_group_name = ? ORDER BY w0_.price + 0 ASC LIMIT 1
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
SELECT count(w0_.id) AS sclr_0 FROM web_item_detail w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.del = 0 AND w1_.id = ? AND w0_.web_group_name = ?
SELECT w0_.price AS price_0, w0_.old_price AS old_price_1, w0_.discount AS discount_2, w0_.show_control AS show_control_3 FROM web_item w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id INNER JOIN item i2_ ON w0_.item_id = i2_.id WHERE w0_.show_control = 1 AND i2_.status <> 2 AND w0_.del = 0 AND w1_.id = ? AND w0_.web_group_name = ? AND i2_.web_group_name = ? ORDER BY w0_.price + 0 ASC LIMIT 1
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
SELECT count(w0_.id) AS sclr_0 FROM web_item_detail w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.del = 0 AND w1_.id = ? AND w0_.web_group_name = ?
SELECT w0_.price AS price_0, w0_.old_price AS old_price_1, w0_.discount AS discount_2, w0_.show_control AS show_control_3 FROM web_item w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id INNER JOIN item i2_ ON w0_.item_id = i2_.id WHERE w0_.show_control = 1 AND i2_.status <> 2 AND w0_.del = 0 AND w1_.id = ? AND w0_.web_group_name = ? AND i2_.web_group_name = ? ORDER BY w0_.price + 0 ASC LIMIT 1
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
SELECT i0_.code AS code_0 FROM web_item w1_ LEFT JOIN item i0_ ON w1_.item_id = i0_.id WHERE i0_.id = ?
SELECT w0_.created_at AS created_at_0, w0_.updated_at AS updated_at_1, w0_.created_by AS created_by_2, w0_.updated_by AS updated_by_3, w0_.u_date AS u_date_4, w0_.id AS id_5, w0_.sira AS sira_6, w0_.code AS code_7, w0_.del AS del_8, w0_.web_item_detail_id AS web_item_detail_id_9, w0_.web_item_info_options_id AS web_item_info_options_id_10 FROM web_item_info w0_ INNER JOIN web_item_info_option w1_ ON w0_.web_item_info_options_id = w1_.id WHERE w0_.web_item_detail_id = ? ORDER BY w1_.sira ASC, w1_.title ASC
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.u_date AS u_date_5, t0.id AS id_6, t0.sira AS sira_7, t0.code AS code_8, t0.del AS del_9, t0.web_item_detail_id AS web_item_detail_id_10, t0.web_care_delivery_id AS web_care_delivery_id_11 FROM web_item_care_delivery t0 WHERE t0.web_item_detail_id = ?
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.u_date AS u_date_5, t0.id AS id_6, t0.sira AS sira_7, t0.code AS code_8, t0.del AS del_9, t0.title AS title_10, t0.titleSeo AS titleSeo_11, t0.infoTitle AS infoTitle_12, t0.description AS description_13, t0.type AS type_14, t0.infoIcon AS infoIcon_15, t0.main_id AS main_id_16, t0.site_id AS site_id_17 FROM web_care_delivery t0 WHERE t0.site_id = ?
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.u_date AS u_date_5, t0.id AS id_6, t0.sira AS sira_7, t0.code AS code_8, t0.del AS del_9, t0.pallet_kg AS pallet_kg_10, t0.weight_limit AS weight_limit_11, t0.financial_year_start AS financial_year_start_12, t0.financial_year_end AS financial_year_end_13, t0.voidDay1 AS voidDay1_14, t0.voidDay2 AS voidDay2_15, t0.voidDay3 AS voidDay3_16, t0.voidDay4 AS voidDay4_17, t0.voidDay5 AS voidDay5_18, t0.kdv_value AS kdv_value_19, t0.default_tax AS default_tax_20 FROM settings t0 WHERE t0.id = ?

#▲	Time	Info
1	1.02 ms	SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.u_date AS u_date_5, t0.id AS id_6, t0.sira AS sira_7, t0.code AS code_8, t0.del AS del_9, t0.name AS name_10, t0.url AS url_11, t0.short_name AS short_name_12, t0.site_title AS site_title_13, t0.site_description AS site_description_14 FROM web_site t0 WHERE t0.id = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.u_date AS u_date_5, t0.id AS id_6, t0.sira AS sira_7, t0.code AS code_8, t0.del AS del_9, t0.name AS name_10, t0.url AS url_11, t0.short_name AS short_name_12, t0.site_title AS site_title_13, t0.site_description AS site_description_14 FROM web_site t0 WHERE t0.id = ? SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.u_date AS u_date_5, t0.id AS id_6, t0.sira AS sira_7, t0.code AS code_8, t0.del AS del_9, t0.name AS name_10, t0.url AS url_11, t0.short_name AS short_name_12, t0.site_title AS site_title_13, t0.site_description AS site_description_14 FROM web_site t0 WHERE t0.id = 2;
2	5.67 ms	SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.u_date AS u_date_5, t0.id AS id_6, t0.sira AS sira_7, t0.code AS code_8, t0.del AS del_9, t0.freeSample AS freeSample_10, t0.gap AS gap_11, t0.projects_slab AS projects_slab_12, t0.dummy AS dummy_13, t0.title AS title_14, t0.brand AS brand_15, t0.product_type AS product_type_16, t0.sub_title AS sub_title_17, t0.title_seo AS title_seo_18, t0.web_group_name AS web_group_name_19, t0.photo AS photo_20, t0.photo_title AS photo_title_21, t0.photo_sub_title AS photo_sub_title_22, t0.little_description AS little_description_23, t0.description AS description_24, t0.meta_title AS meta_title_25, t0.meta_keywords AS meta_keywords_26, t0.meta_description AS meta_description_27, t0.special_offer AS special_offer_28, t0.most_popular AS most_popular_29, t0.best_sellers AS best_sellers_30, t0.suggested_fixing AS suggested_fixing_31, t0.review_average AS review_average_32, t0.free_delivery AS free_delivery_33, t0.new_item AS new_item_34, t0.last_id AS last_id_35, t0.last_url AS last_url_36, t0.rss_xml AS rss_xml_37, t0.price AS price_38, t0.show_control AS show_control_39, t0.courier_option AS courier_option_40, t0.show_first AS show_first_41, t0.tile_sealer AS tile_sealer_42, t0.tile_adhesive AS tile_adhesive_43, t0.samples_weight AS samples_weight_44, t0.default_category AS default_category_45, t0.default_alt_category AS default_alt_category_46, t0.type AS type_47, t0.per AS per_48, t0.site_id AS site_id_49, t0.item_id AS item_id_50 FROM web_item_detail t0 WHERE t0.title_seo = ? AND t0.site_id = ? AND t0.del = ? LIMIT 1 Parameters: [`"caria-white-blue-stone-octagon-marble-tile-tumbled" 2 0`] View formatted query View runnable query Explain query SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.u_date AS u_date_5, t0.id AS id_6, t0.sira AS sira_7, t0.code AS code_8, t0.del AS del_9, t0.freeSample AS freeSample_10, t0.gap AS gap_11, t0.projects_slab AS projects_slab_12, t0.dummy AS dummy_13, t0.title AS title_14, t0.brand AS brand_15, t0.product_type AS product_type_16, t0.sub_title AS sub_title_17, t0.title_seo AS title_seo_18, t0.web_group_name AS web_group_name_19, t0.photo AS photo_20, t0.photo_title AS photo_title_21, t0.photo_sub_title AS photo_sub_title_22, t0.little_description AS little_description_23, t0.description AS description_24, t0.meta_title AS meta_title_25, t0.meta_keywords AS meta_keywords_26, t0.meta_description AS meta_description_27, t0.special_offer AS special_offer_28, t0.most_popular AS most_popular_29, t0.best_sellers AS best_sellers_30, t0.suggested_fixing AS suggested_fixing_31, t0.review_average AS review_average_32, t0.free_delivery AS free_delivery_33, t0.new_item AS new_item_34, t0.last_id AS last_id_35, t0.last_url AS last_url_36, t0.rss_xml AS rss_xml_37, t0.price AS price_38, t0.show_control AS show_control_39, t0.courier_option AS courier_option_40, t0.show_first AS show_first_41, t0.tile_sealer AS tile_sealer_42, t0.tile_adhesive AS tile_adhesive_43, t0.samples_weight AS samples_weight_44, t0.default_category AS default_category_45, t0.default_alt_category AS default_alt_category_46, t0.type AS type_47, t0.per AS per_48, t0.site_id AS site_id_49, t0.item_id AS item_id_50 FROM web_item_detail t0 WHERE t0.title_seo = ? AND t0.site_id = ? AND t0.del = ? LIMIT 1 SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.u_date AS u_date_5, t0.id AS id_6, t0.sira AS sira_7, t0.code AS code_8, t0.del AS del_9, t0.freeSample AS freeSample_10, t0.gap AS gap_11, t0.projects_slab AS projects_slab_12, t0.dummy AS dummy_13, t0.title AS title_14, t0.brand AS brand_15, t0.product_type AS product_type_16, t0.sub_title AS sub_title_17, t0.title_seo AS title_seo_18, t0.web_group_name AS web_group_name_19, t0.photo AS photo_20, t0.photo_title AS photo_title_21, t0.photo_sub_title AS photo_sub_title_22, t0.little_description AS little_description_23, t0.description AS description_24, t0.meta_title AS meta_title_25, t0.meta_keywords AS meta_keywords_26, t0.meta_description AS meta_description_27, t0.special_offer AS special_offer_28, t0.most_popular AS most_popular_29, t0.best_sellers AS best_sellers_30, t0.suggested_fixing AS suggested_fixing_31, t0.review_average AS review_average_32, t0.free_delivery AS free_delivery_33, t0.new_item AS new_item_34, t0.last_id AS last_id_35, t0.last_url AS last_url_36, t0.rss_xml AS rss_xml_37, t0.price AS price_38, t0.show_control AS show_control_39, t0.courier_option AS courier_option_40, t0.show_first AS show_first_41, t0.tile_sealer AS tile_sealer_42, t0.tile_adhesive AS tile_adhesive_43, t0.samples_weight AS samples_weight_44, t0.default_category AS default_category_45, t0.default_alt_category AS default_alt_category_46, t0.type AS type_47, t0.per AS per_48, t0.site_id AS site_id_49, t0.item_id AS item_id_50 FROM web_item_detail t0 WHERE t0.title_seo = 'caria-white-blue-stone-octagon-marble-tile-tumbled' AND t0.site_id = 2 AND t0.del = 0 LIMIT 1;
3	1.02 ms	SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.u_date AS u_date_5, t0.id AS id_6, t0.sira AS sira_7, t0.code AS code_8, t0.del AS del_9, t0.status AS status_10, t0.title AS title_11, t0.title_seo AS title_seo_12, t0.footer_title AS footer_title_13, t0.meta_title AS meta_title_14, t0.meta_keywords AS meta_keywords_15, t0.meta_description AS meta_description_16, t0.seo_description AS seo_description_17, t0.group_name AS group_name_18, t0.group_status AS group_status_19, t0.meta_tickets AS meta_tickets_20, t0.site_id AS site_id_21, t0.category_id AS category_id_22 FROM web_category t0 WHERE t0.id = ? Parameters: [`46`] View formatted query View runnable query Explain query SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.u_date AS u_date_5, t0.id AS id_6, t0.sira AS sira_7, t0.code AS code_8, t0.del AS del_9, t0.status AS status_10, t0.title AS title_11, t0.title_seo AS title_seo_12, t0.footer_title AS footer_title_13, t0.meta_title AS meta_title_14, t0.meta_keywords AS meta_keywords_15, t0.meta_description AS meta_description_16, t0.seo_description AS seo_description_17, t0.group_name AS group_name_18, t0.group_status AS group_status_19, t0.meta_tickets AS meta_tickets_20, t0.site_id AS site_id_21, t0.category_id AS category_id_22 FROM web_category t0 WHERE t0.id = ? SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.u_date AS u_date_5, t0.id AS id_6, t0.sira AS sira_7, t0.code AS code_8, t0.del AS del_9, t0.status AS status_10, t0.title AS title_11, t0.title_seo AS title_seo_12, t0.footer_title AS footer_title_13, t0.meta_title AS meta_title_14, t0.meta_keywords AS meta_keywords_15, t0.meta_description AS meta_description_16, t0.seo_description AS seo_description_17, t0.group_name AS group_name_18, t0.group_status AS group_status_19, t0.meta_tickets AS meta_tickets_20, t0.site_id AS site_id_21, t0.category_id AS category_id_22 FROM web_category t0 WHERE t0.id = 46;
4	0.98 ms	SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.u_date AS u_date_5, t0.id AS id_6, t0.sira AS sira_7, t0.code AS code_8, t0.del AS del_9, t0.status AS status_10, t0.title AS title_11, t0.title_seo AS title_seo_12, t0.footer_title AS footer_title_13, t0.meta_title AS meta_title_14, t0.meta_keywords AS meta_keywords_15, t0.meta_description AS meta_description_16, t0.seo_description AS seo_description_17, t0.group_name AS group_name_18, t0.group_status AS group_status_19, t0.meta_tickets AS meta_tickets_20, t0.site_id AS site_id_21, t0.category_id AS category_id_22 FROM web_category t0 WHERE t0.id = ? Parameters: [`101`] View formatted query View runnable query Explain query SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.u_date AS u_date_5, t0.id AS id_6, t0.sira AS sira_7, t0.code AS code_8, t0.del AS del_9, t0.status AS status_10, t0.title AS title_11, t0.title_seo AS title_seo_12, t0.footer_title AS footer_title_13, t0.meta_title AS meta_title_14, t0.meta_keywords AS meta_keywords_15, t0.meta_description AS meta_description_16, t0.seo_description AS seo_description_17, t0.group_name AS group_name_18, t0.group_status AS group_status_19, t0.meta_tickets AS meta_tickets_20, t0.site_id AS site_id_21, t0.category_id AS category_id_22 FROM web_category t0 WHERE t0.id = ? SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.u_date AS u_date_5, t0.id AS id_6, t0.sira AS sira_7, t0.code AS code_8, t0.del AS del_9, t0.status AS status_10, t0.title AS title_11, t0.title_seo AS title_seo_12, t0.footer_title AS footer_title_13, t0.meta_title AS meta_title_14, t0.meta_keywords AS meta_keywords_15, t0.meta_description AS meta_description_16, t0.seo_description AS seo_description_17, t0.group_name AS group_name_18, t0.group_status AS group_status_19, t0.meta_tickets AS meta_tickets_20, t0.site_id AS site_id_21, t0.category_id AS category_id_22 FROM web_category t0 WHERE t0.id = 101;
5	7.91 ms	SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.u_date AS u_date_5, t0.id AS id_6, t0.sira AS sira_7, t0.code AS code_8, t0.del AS del_9, t0.title AS title_10, t0.title_seo AS title_seo_11, t0.size_name AS size_name_12, t0.size_description AS size_description_13, t0.web_group_name AS web_group_name_14, t0.web_listele AS web_listele_15, t0.price AS price_16, t0.old_price AS old_price_17, t0.discount AS discount_18, t0.photo AS photo_19, t0.little_description AS little_description_20, t0.description AS description_21, t0.meta_title AS meta_title_22, t0.meta_description AS meta_description_23, t0.show_control AS show_control_24, t0.special_offer AS special_offer_25, t0.most_popular AS most_popular_26, t0.best_sellers AS best_sellers_27, t0.product_code AS product_code_28, t0.suggested_fixing AS suggested_fixing_29, t0.review_average AS review_average_30, t0.free_delivery AS free_delivery_31, t0.new_item AS new_item_32, t0.stock AS stock_33, t0.last_id AS last_id_34, t0.last_url AS last_url_35, t0.rss_xml AS rss_xml_36, t0.show_first AS show_first_37, t0.tile_grout AS tile_grout_38, t0.site_id AS site_id_39, t0.item_id AS item_id_40, t0.web_item_detail_id AS web_item_detail_id_41 FROM web_item t0 WHERE t0.web_item_detail_id = ? LIMIT 1 Parameters: [`873`] View formatted query View runnable query Explain query SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.u_date AS u_date_5, t0.id AS id_6, t0.sira AS sira_7, t0.code AS code_8, t0.del AS del_9, t0.title AS title_10, t0.title_seo AS title_seo_11, t0.size_name AS size_name_12, t0.size_description AS size_description_13, t0.web_group_name AS web_group_name_14, t0.web_listele AS web_listele_15, t0.price AS price_16, t0.old_price AS old_price_17, t0.discount AS discount_18, t0.photo AS photo_19, t0.little_description AS little_description_20, t0.description AS description_21, t0.meta_title AS meta_title_22, t0.meta_description AS meta_description_23, t0.show_control AS show_control_24, t0.special_offer AS special_offer_25, t0.most_popular AS most_popular_26, t0.best_sellers AS best_sellers_27, t0.product_code AS product_code_28, t0.suggested_fixing AS suggested_fixing_29, t0.review_average AS review_average_30, t0.free_delivery AS free_delivery_31, t0.new_item AS new_item_32, t0.stock AS stock_33, t0.last_id AS last_id_34, t0.last_url AS last_url_35, t0.rss_xml AS rss_xml_36, t0.show_first AS show_first_37, t0.tile_grout AS tile_grout_38, t0.site_id AS site_id_39, t0.item_id AS item_id_40, t0.web_item_detail_id AS web_item_detail_id_41 FROM web_item t0 WHERE t0.web_item_detail_id = ? LIMIT 1 SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.u_date AS u_date_5, t0.id AS id_6, t0.sira AS sira_7, t0.code AS code_8, t0.del AS del_9, t0.title AS title_10, t0.title_seo AS title_seo_11, t0.size_name AS size_name_12, t0.size_description AS size_description_13, t0.web_group_name AS web_group_name_14, t0.web_listele AS web_listele_15, t0.price AS price_16, t0.old_price AS old_price_17, t0.discount AS discount_18, t0.photo AS photo_19, t0.little_description AS little_description_20, t0.description AS description_21, t0.meta_title AS meta_title_22, t0.meta_description AS meta_description_23, t0.show_control AS show_control_24, t0.special_offer AS special_offer_25, t0.most_popular AS most_popular_26, t0.best_sellers AS best_sellers_27, t0.product_code AS product_code_28, t0.suggested_fixing AS suggested_fixing_29, t0.review_average AS review_average_30, t0.free_delivery AS free_delivery_31, t0.new_item AS new_item_32, t0.stock AS stock_33, t0.last_id AS last_id_34, t0.last_url AS last_url_35, t0.rss_xml AS rss_xml_36, t0.show_first AS show_first_37, t0.tile_grout AS tile_grout_38, t0.site_id AS site_id_39, t0.item_id AS item_id_40, t0.web_item_detail_id AS web_item_detail_id_41 FROM web_item t0 WHERE t0.web_item_detail_id = 873 LIMIT 1;
6	5.02 ms	SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.u_date AS u_date_5, t0.id AS id_6, t0.sira AS sira_7, t0.code AS code_8, t0.del AS del_9, t0.name AS name_10, t0.email AS email_11, t0.comment AS comment_12, t0.score AS score_13, t0.title AS title_14, t0.city AS city_15, t0.status AS status_16, t0.web_item_detail_id AS web_item_detail_id_17, t0.site_id AS site_id_18 FROM web_item_review t0 WHERE t0.web_item_detail_id = ? AND t0.status = ? AND t0.del = ? AND t0.site_id = ? ORDER BY t0.id DESC Parameters: [`873 1 0 2`] View formatted query View runnable query Explain query SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.u_date AS u_date_5, t0.id AS id_6, t0.sira AS sira_7, t0.code AS code_8, t0.del AS del_9, t0.name AS name_10, t0.email AS email_11, t0.comment AS comment_12, t0.score AS score_13, t0.title AS title_14, t0.city AS city_15, t0.status AS status_16, t0.web_item_detail_id AS web_item_detail_id_17, t0.site_id AS site_id_18 FROM web_item_review t0 WHERE t0.web_item_detail_id = ? AND t0.status = ? AND t0.del = ? AND t0.site_id = ? ORDER BY t0.id DESC SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.u_date AS u_date_5, t0.id AS id_6, t0.sira AS sira_7, t0.code AS code_8, t0.del AS del_9, t0.name AS name_10, t0.email AS email_11, t0.comment AS comment_12, t0.score AS score_13, t0.title AS title_14, t0.city AS city_15, t0.status AS status_16, t0.web_item_detail_id AS web_item_detail_id_17, t0.site_id AS site_id_18 FROM web_item_review t0 WHERE t0.web_item_detail_id = 873 AND t0.status = 1 AND t0.del = 0 AND t0.site_id = 2 ORDER BY t0.id DESC;
7	3.85 ms	SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.u_date AS u_date_5, t0.id AS id_6, t0.sira AS sira_7, t0.code AS code_8, t0.del AS del_9, t0.name AS name_10, t0.email AS email_11, t0.question AS question_12, t0.answer AS answer_13, t0.status AS status_14, t0.web_item_detail_id AS web_item_detail_id_15, t0.site_id AS site_id_16 FROM web_item_question t0 WHERE t0.web_item_detail_id = ? AND t0.status = ? AND t0.del = ? AND t0.site_id = ? ORDER BY t0.id DESC Parameters: [`873 1 0 2`] View formatted query View runnable query Explain query SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.u_date AS u_date_5, t0.id AS id_6, t0.sira AS sira_7, t0.code AS code_8, t0.del AS del_9, t0.name AS name_10, t0.email AS email_11, t0.question AS question_12, t0.answer AS answer_13, t0.status AS status_14, t0.web_item_detail_id AS web_item_detail_id_15, t0.site_id AS site_id_16 FROM web_item_question t0 WHERE t0.web_item_detail_id = ? AND t0.status = ? AND t0.del = ? AND t0.site_id = ? ORDER BY t0.id DESC SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.u_date AS u_date_5, t0.id AS id_6, t0.sira AS sira_7, t0.code AS code_8, t0.del AS del_9, t0.name AS name_10, t0.email AS email_11, t0.question AS question_12, t0.answer AS answer_13, t0.status AS status_14, t0.web_item_detail_id AS web_item_detail_id_15, t0.site_id AS site_id_16 FROM web_item_question t0 WHERE t0.web_item_detail_id = 873 AND t0.status = 1 AND t0.del = 0 AND t0.site_id = 2 ORDER BY t0.id DESC;
8	3.10 ms	SELECT w0_.id AS id_0, w0_.price AS price_1, w0_.size_name AS size_name_2, w0_.size_description AS size_description_3, w0_.stock AS stock_4, w0_.old_price AS old_price_5, w0_.discount AS discount_6, sum(i1_.free_stock) AS sclr_7, i2_.status AS status_8, i2_.um_quantity AS um_quantity_9, u3_.unit_measure AS unit_measure_10, u4_.type AS type_11 FROM web_item w0_ INNER JOIN web_site w5_ ON w0_.site_id = w5_.id INNER JOIN item i2_ ON w0_.item_id = i2_.id INNER JOIN unit_measure u3_ ON i2_.um_id = u3_.id LEFT JOIN item_warehouse i1_ ON i2_.id = i1_.item_id LEFT JOIN unit_type u4_ ON i2_.unit_type_id = u4_.id INNER JOIN web_item_detail w6_ ON w0_.web_item_detail_id = w6_.id WHERE w0_.show_control = 1 AND w0_.del = 0 AND w5_.id = ? AND i2_.web_group_name = ? AND w6_.id = ? GROUP BY w0_.id ORDER BY w0_.price + 0 ASC, w0_.size_name ASC Parameters: [`2 "CARIA LUNA - ASH BLUE TUMBLED OCTAGON MARBLE" 873`] View formatted query View runnable query Explain query SELECT w0_.id AS id_0, w0_.price AS price_1, w0_.size_name AS size_name_2, w0_.size_description AS size_description_3, w0_.stock AS stock_4, w0_.old_price AS old_price_5, w0_.discount AS discount_6, sum(i1_.free_stock) AS sclr_7, i2_.status AS status_8, i2_.um_quantity AS um_quantity_9, u3_.unit_measure AS unit_measure_10, u4_.type AS type_11 FROM web_item w0_ INNER JOIN web_site w5_ ON w0_.site_id = w5_.id INNER JOIN item i2_ ON w0_.item_id = i2_.id INNER JOIN unit_measure u3_ ON i2_.um_id = u3_.id LEFT JOIN item_warehouse i1_ ON i2_.id = i1_.item_id LEFT JOIN unit_type u4_ ON i2_.unit_type_id = u4_.id INNER JOIN web_item_detail w6_ ON w0_.web_item_detail_id = w6_.id WHERE w0_.show_control = 1 AND w0_.del = 0 AND w5_.id = ? AND i2_.web_group_name = ? AND w6_.id = ? GROUP BY w0_.id ORDER BY w0_.price + 0 ASC, w0_.size_name ASC SELECT w0_.id AS id_0, w0_.price AS price_1, w0_.size_name AS size_name_2, w0_.size_description AS size_description_3, w0_.stock AS stock_4, w0_.old_price AS old_price_5, w0_.discount AS discount_6, sum(i1_.free_stock) AS sclr_7, i2_.status AS status_8, i2_.um_quantity AS um_quantity_9, u3_.unit_measure AS unit_measure_10, u4_.type AS type_11 FROM web_item w0_ INNER JOIN web_site w5_ ON w0_.site_id = w5_.id INNER JOIN item i2_ ON w0_.item_id = i2_.id INNER JOIN unit_measure u3_ ON i2_.um_id = u3_.id LEFT JOIN item_warehouse i1_ ON i2_.id = i1_.item_id LEFT JOIN unit_type u4_ ON i2_.unit_type_id = u4_.id INNER JOIN web_item_detail w6_ ON w0_.web_item_detail_id = w6_.id WHERE w0_.show_control = 1 AND w0_.del = 0 AND w5_.id = 2 AND i2_.web_group_name = 'CARIA LUNA - ASH BLUE TUMBLED OCTAGON MARBLE' AND w6_.id = 873 GROUP BY w0_.id ORDER BY w0_.price + 0 ASC, w0_.size_name ASC;
9	2.30 ms	SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.u_date AS u_date_5, t0.id AS id_6, t0.sira AS sira_7, t0.code AS code_8, t0.del AS del_9, t0.freeSample AS freeSample_10, t0.gap AS gap_11, t0.projects_slab AS projects_slab_12, t0.dummy AS dummy_13, t0.title AS title_14, t0.brand AS brand_15, t0.product_type AS product_type_16, t0.sub_title AS sub_title_17, t0.title_seo AS title_seo_18, t0.web_group_name AS web_group_name_19, t0.photo AS photo_20, t0.photo_title AS photo_title_21, t0.photo_sub_title AS photo_sub_title_22, t0.little_description AS little_description_23, t0.description AS description_24, t0.meta_title AS meta_title_25, t0.meta_keywords AS meta_keywords_26, t0.meta_description AS meta_description_27, t0.special_offer AS special_offer_28, t0.most_popular AS most_popular_29, t0.best_sellers AS best_sellers_30, t0.suggested_fixing AS suggested_fixing_31, t0.review_average AS review_average_32, t0.free_delivery AS free_delivery_33, t0.new_item AS new_item_34, t0.last_id AS last_id_35, t0.last_url AS last_url_36, t0.rss_xml AS rss_xml_37, t0.price AS price_38, t0.show_control AS show_control_39, t0.courier_option AS courier_option_40, t0.show_first AS show_first_41, t0.tile_sealer AS tile_sealer_42, t0.tile_adhesive AS tile_adhesive_43, t0.samples_weight AS samples_weight_44, t0.default_category AS default_category_45, t0.default_alt_category AS default_alt_category_46, t0.type AS type_47, t0.per AS per_48, t0.site_id AS site_id_49, t0.item_id AS item_id_50 FROM web_item_detail t0 INNER JOIN web_item_details_needs ON t0.id = web_item_details_needs.need_item_id WHERE web_item_details_needs.item_id = ? Parameters: [`873`] View formatted query View runnable query Explain query SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.u_date AS u_date_5, t0.id AS id_6, t0.sira AS sira_7, t0.code AS code_8, t0.del AS del_9, t0.freeSample AS freeSample_10, t0.gap AS gap_11, t0.projects_slab AS projects_slab_12, t0.dummy AS dummy_13, t0.title AS title_14, t0.brand AS brand_15, t0.product_type AS product_type_16, t0.sub_title AS sub_title_17, t0.title_seo AS title_seo_18, t0.web_group_name AS web_group_name_19, t0.photo AS photo_20, t0.photo_title AS photo_title_21, t0.photo_sub_title AS photo_sub_title_22, t0.little_description AS little_description_23, t0.description AS description_24, t0.meta_title AS meta_title_25, t0.meta_keywords AS meta_keywords_26, t0.meta_description AS meta_description_27, t0.special_offer AS special_offer_28, t0.most_popular AS most_popular_29, t0.best_sellers AS best_sellers_30, t0.suggested_fixing AS suggested_fixing_31, t0.review_average AS review_average_32, t0.free_delivery AS free_delivery_33, t0.new_item AS new_item_34, t0.last_id AS last_id_35, t0.last_url AS last_url_36, t0.rss_xml AS rss_xml_37, t0.price AS price_38, t0.show_control AS show_control_39, t0.courier_option AS courier_option_40, t0.show_first AS show_first_41, t0.tile_sealer AS tile_sealer_42, t0.tile_adhesive AS tile_adhesive_43, t0.samples_weight AS samples_weight_44, t0.default_category AS default_category_45, t0.default_alt_category AS default_alt_category_46, t0.type AS type_47, t0.per AS per_48, t0.site_id AS site_id_49, t0.item_id AS item_id_50 FROM web_item_detail t0 INNER JOIN web_item_details_needs ON t0.id = web_item_details_needs.need_item_id WHERE web_item_details_needs.item_id = ? SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.u_date AS u_date_5, t0.id AS id_6, t0.sira AS sira_7, t0.code AS code_8, t0.del AS del_9, t0.freeSample AS freeSample_10, t0.gap AS gap_11, t0.projects_slab AS projects_slab_12, t0.dummy AS dummy_13, t0.title AS title_14, t0.brand AS brand_15, t0.product_type AS product_type_16, t0.sub_title AS sub_title_17, t0.title_seo AS title_seo_18, t0.web_group_name AS web_group_name_19, t0.photo AS photo_20, t0.photo_title AS photo_title_21, t0.photo_sub_title AS photo_sub_title_22, t0.little_description AS little_description_23, t0.description AS description_24, t0.meta_title AS meta_title_25, t0.meta_keywords AS meta_keywords_26, t0.meta_description AS meta_description_27, t0.special_offer AS special_offer_28, t0.most_popular AS most_popular_29, t0.best_sellers AS best_sellers_30, t0.suggested_fixing AS suggested_fixing_31, t0.review_average AS review_average_32, t0.free_delivery AS free_delivery_33, t0.new_item AS new_item_34, t0.last_id AS last_id_35, t0.last_url AS last_url_36, t0.rss_xml AS rss_xml_37, t0.price AS price_38, t0.show_control AS show_control_39, t0.courier_option AS courier_option_40, t0.show_first AS show_first_41, t0.tile_sealer AS tile_sealer_42, t0.tile_adhesive AS tile_adhesive_43, t0.samples_weight AS samples_weight_44, t0.default_category AS default_category_45, t0.default_alt_category AS default_alt_category_46, t0.type AS type_47, t0.per AS per_48, t0.site_id AS site_id_49, t0.item_id AS item_id_50 FROM web_item_detail t0 INNER JOIN web_item_details_needs ON t0.id = web_item_details_needs.need_item_id WHERE web_item_details_needs.item_id = 873;
10	0.91 ms	SELECT count(w0_.id) AS sclr_0 FROM web_item_detail w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.del = 0 AND w1_.id = ? AND w0_.web_group_name = ? Parameters: [`2 "ASH BLUE TUMBLED MARBLE"`] View formatted query View runnable query Explain query SELECT count(w0_.id) AS sclr_0 FROM web_item_detail w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.del = 0 AND w1_.id = ? AND w0_.web_group_name = ? SELECT count(w0_.id) AS sclr_0 FROM web_item_detail w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.del = 0 AND w1_.id = 2 AND w0_.web_group_name = 'ASH BLUE TUMBLED MARBLE';
11	1.54 ms	SELECT w0_.price AS price_0, w0_.old_price AS old_price_1, w0_.discount AS discount_2, w0_.show_control AS show_control_3 FROM web_item w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id INNER JOIN item i2_ ON w0_.item_id = i2_.id WHERE w0_.show_control = 1 AND i2_.status <> 2 AND w0_.del = 0 AND w1_.id = ? AND w0_.web_group_name = ? AND i2_.web_group_name = ? ORDER BY w0_.price + 0 ASC LIMIT 1 Parameters: [`2 "ASH BLUE TUMBLED MARBLE" "ASH BLUE TUMBLED MARBLE"`] View formatted query View runnable query Explain query SELECT w0_.price AS price_0, w0_.old_price AS old_price_1, w0_.discount AS discount_2, w0_.show_control AS show_control_3 FROM web_item w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id INNER JOIN item i2_ ON w0_.item_id = i2_.id WHERE w0_.show_control = 1 AND i2_.status <> 2 AND w0_.del = 0 AND w1_.id = ? AND w0_.web_group_name = ? AND i2_.web_group_name = ? ORDER BY w0_.price + 0 ASC LIMIT 1 SELECT w0_.price AS price_0, w0_.old_price AS old_price_1, w0_.discount AS discount_2, w0_.show_control AS show_control_3 FROM web_item w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id INNER JOIN item i2_ ON w0_.item_id = i2_.id WHERE w0_.show_control = 1 AND i2_.status <> 2 AND w0_.del = 0 AND w1_.id = 2 AND w0_.web_group_name = 'ASH BLUE TUMBLED MARBLE' AND i2_.web_group_name = 'ASH BLUE TUMBLED MARBLE' ORDER BY w0_.price + 0 ASC LIMIT 1;
12	0.41 ms	SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ? Parameters: [`838`] View formatted query View runnable query Explain query SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ? SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = 838;
13	1.12 ms	SELECT count(w0_.id) AS sclr_0 FROM web_item_detail w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.del = 0 AND w1_.id = ? AND w0_.web_group_name = ? Parameters: [`2 "CARIA LUNA TUMBLED MARBLE MOSAIC"`] View formatted query View runnable query Explain query SELECT count(w0_.id) AS sclr_0 FROM web_item_detail w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.del = 0 AND w1_.id = ? AND w0_.web_group_name = ? SELECT count(w0_.id) AS sclr_0 FROM web_item_detail w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.del = 0 AND w1_.id = 2 AND w0_.web_group_name = 'CARIA LUNA TUMBLED MARBLE MOSAIC';
14	2.34 ms	SELECT w0_.price AS price_0, w0_.old_price AS old_price_1, w0_.discount AS discount_2, w0_.show_control AS show_control_3 FROM web_item w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id INNER JOIN item i2_ ON w0_.item_id = i2_.id WHERE w0_.show_control = 1 AND i2_.status <> 2 AND w0_.del = 0 AND w1_.id = ? AND w0_.web_group_name = ? AND i2_.web_group_name = ? ORDER BY w0_.price + 0 ASC LIMIT 1 Parameters: [`2 "CARIA LUNA TUMBLED MARBLE MOSAIC" "CARIA LUNA TUMBLED MARBLE MOSAIC"`] View formatted query View runnable query Explain query SELECT w0_.price AS price_0, w0_.old_price AS old_price_1, w0_.discount AS discount_2, w0_.show_control AS show_control_3 FROM web_item w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id INNER JOIN item i2_ ON w0_.item_id = i2_.id WHERE w0_.show_control = 1 AND i2_.status <> 2 AND w0_.del = 0 AND w1_.id = ? AND w0_.web_group_name = ? AND i2_.web_group_name = ? ORDER BY w0_.price + 0 ASC LIMIT 1 SELECT w0_.price AS price_0, w0_.old_price AS old_price_1, w0_.discount AS discount_2, w0_.show_control AS show_control_3 FROM web_item w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id INNER JOIN item i2_ ON w0_.item_id = i2_.id WHERE w0_.show_control = 1 AND i2_.status <> 2 AND w0_.del = 0 AND w1_.id = 2 AND w0_.web_group_name = 'CARIA LUNA TUMBLED MARBLE MOSAIC' AND i2_.web_group_name = 'CARIA LUNA TUMBLED MARBLE MOSAIC' ORDER BY w0_.price + 0 ASC LIMIT 1;
15	0.37 ms	SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ? Parameters: [`308`] View formatted query View runnable query Explain query SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ? SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = 308;
16	1.04 ms	SELECT count(w0_.id) AS sclr_0 FROM web_item_detail w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.del = 0 AND w1_.id = ? AND w0_.web_group_name = ? Parameters: [`2 "CARIA LUNA TUMBLED MARBLE"`] View formatted query View runnable query Explain query SELECT count(w0_.id) AS sclr_0 FROM web_item_detail w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.del = 0 AND w1_.id = ? AND w0_.web_group_name = ? SELECT count(w0_.id) AS sclr_0 FROM web_item_detail w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.del = 0 AND w1_.id = 2 AND w0_.web_group_name = 'CARIA LUNA TUMBLED MARBLE';
17	3.59 ms	SELECT w0_.price AS price_0, w0_.old_price AS old_price_1, w0_.discount AS discount_2, w0_.show_control AS show_control_3 FROM web_item w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id INNER JOIN item i2_ ON w0_.item_id = i2_.id WHERE w0_.show_control = 1 AND i2_.status <> 2 AND w0_.del = 0 AND w1_.id = ? AND w0_.web_group_name = ? AND i2_.web_group_name = ? ORDER BY w0_.price + 0 ASC LIMIT 1 Parameters: [`2 "CARIA LUNA TUMBLED MARBLE" "CARIA LUNA TUMBLED MARBLE"`] View formatted query View runnable query Explain query SELECT w0_.price AS price_0, w0_.old_price AS old_price_1, w0_.discount AS discount_2, w0_.show_control AS show_control_3 FROM web_item w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id INNER JOIN item i2_ ON w0_.item_id = i2_.id WHERE w0_.show_control = 1 AND i2_.status <> 2 AND w0_.del = 0 AND w1_.id = ? AND w0_.web_group_name = ? AND i2_.web_group_name = ? ORDER BY w0_.price + 0 ASC LIMIT 1 SELECT w0_.price AS price_0, w0_.old_price AS old_price_1, w0_.discount AS discount_2, w0_.show_control AS show_control_3 FROM web_item w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id INNER JOIN item i2_ ON w0_.item_id = i2_.id WHERE w0_.show_control = 1 AND i2_.status <> 2 AND w0_.del = 0 AND w1_.id = 2 AND w0_.web_group_name = 'CARIA LUNA TUMBLED MARBLE' AND i2_.web_group_name = 'CARIA LUNA TUMBLED MARBLE' ORDER BY w0_.price + 0 ASC LIMIT 1;
18	0.66 ms	SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ? Parameters: [`310`] View formatted query View runnable query Explain query SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ? SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = 310;
19	1.09 ms	SELECT count(w0_.id) AS sclr_0 FROM web_item_detail w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.del = 0 AND w1_.id = ? AND w0_.web_group_name = ? Parameters: [`2 "TAURUS NERO TUMBLED"`] View formatted query View runnable query Explain query SELECT count(w0_.id) AS sclr_0 FROM web_item_detail w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.del = 0 AND w1_.id = ? AND w0_.web_group_name = ? SELECT count(w0_.id) AS sclr_0 FROM web_item_detail w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.del = 0 AND w1_.id = 2 AND w0_.web_group_name = 'TAURUS NERO TUMBLED';
20	1.92 ms	SELECT w0_.price AS price_0, w0_.old_price AS old_price_1, w0_.discount AS discount_2, w0_.show_control AS show_control_3 FROM web_item w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id INNER JOIN item i2_ ON w0_.item_id = i2_.id WHERE w0_.show_control = 1 AND i2_.status <> 2 AND w0_.del = 0 AND w1_.id = ? AND w0_.web_group_name = ? AND i2_.web_group_name = ? ORDER BY w0_.price + 0 ASC LIMIT 1 Parameters: [`2 "TAURUS NERO TUMBLED" "TAURUS NERO TUMBLED"`] View formatted query View runnable query Explain query SELECT w0_.price AS price_0, w0_.old_price AS old_price_1, w0_.discount AS discount_2, w0_.show_control AS show_control_3 FROM web_item w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id INNER JOIN item i2_ ON w0_.item_id = i2_.id WHERE w0_.show_control = 1 AND i2_.status <> 2 AND w0_.del = 0 AND w1_.id = ? AND w0_.web_group_name = ? AND i2_.web_group_name = ? ORDER BY w0_.price + 0 ASC LIMIT 1 SELECT w0_.price AS price_0, w0_.old_price AS old_price_1, w0_.discount AS discount_2, w0_.show_control AS show_control_3 FROM web_item w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id INNER JOIN item i2_ ON w0_.item_id = i2_.id WHERE w0_.show_control = 1 AND i2_.status <> 2 AND w0_.del = 0 AND w1_.id = 2 AND w0_.web_group_name = 'TAURUS NERO TUMBLED' AND i2_.web_group_name = 'TAURUS NERO TUMBLED' ORDER BY w0_.price + 0 ASC LIMIT 1;
21	0.37 ms	SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ? Parameters: [`83`] View formatted query View runnable query Explain query SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ? SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = 83;
22	1.52 ms	SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.u_date AS u_date_5, t0.id AS id_6, t0.sira AS sira_7, t0.code AS code_8, t0.del AS del_9, t0.freeSample AS freeSample_10, t0.gap AS gap_11, t0.projects_slab AS projects_slab_12, t0.dummy AS dummy_13, t0.title AS title_14, t0.brand AS brand_15, t0.product_type AS product_type_16, t0.sub_title AS sub_title_17, t0.title_seo AS title_seo_18, t0.web_group_name AS web_group_name_19, t0.photo AS photo_20, t0.photo_title AS photo_title_21, t0.photo_sub_title AS photo_sub_title_22, t0.little_description AS little_description_23, t0.description AS description_24, t0.meta_title AS meta_title_25, t0.meta_keywords AS meta_keywords_26, t0.meta_description AS meta_description_27, t0.special_offer AS special_offer_28, t0.most_popular AS most_popular_29, t0.best_sellers AS best_sellers_30, t0.suggested_fixing AS suggested_fixing_31, t0.review_average AS review_average_32, t0.free_delivery AS free_delivery_33, t0.new_item AS new_item_34, t0.last_id AS last_id_35, t0.last_url AS last_url_36, t0.rss_xml AS rss_xml_37, t0.price AS price_38, t0.show_control AS show_control_39, t0.courier_option AS courier_option_40, t0.show_first AS show_first_41, t0.tile_sealer AS tile_sealer_42, t0.tile_adhesive AS tile_adhesive_43, t0.samples_weight AS samples_weight_44, t0.default_category AS default_category_45, t0.default_alt_category AS default_alt_category_46, t0.type AS type_47, t0.per AS per_48, t0.site_id AS site_id_49, t0.item_id AS item_id_50 FROM web_item_detail t0 INNER JOIN web_item_details_fixings ON t0.id = web_item_details_fixings.fixing_item_id WHERE web_item_details_fixings.item_id = ? Parameters: [`873`] View formatted query View runnable query Explain query SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.u_date AS u_date_5, t0.id AS id_6, t0.sira AS sira_7, t0.code AS code_8, t0.del AS del_9, t0.freeSample AS freeSample_10, t0.gap AS gap_11, t0.projects_slab AS projects_slab_12, t0.dummy AS dummy_13, t0.title AS title_14, t0.brand AS brand_15, t0.product_type AS product_type_16, t0.sub_title AS sub_title_17, t0.title_seo AS title_seo_18, t0.web_group_name AS web_group_name_19, t0.photo AS photo_20, t0.photo_title AS photo_title_21, t0.photo_sub_title AS photo_sub_title_22, t0.little_description AS little_description_23, t0.description AS description_24, t0.meta_title AS meta_title_25, t0.meta_keywords AS meta_keywords_26, t0.meta_description AS meta_description_27, t0.special_offer AS special_offer_28, t0.most_popular AS most_popular_29, t0.best_sellers AS best_sellers_30, t0.suggested_fixing AS suggested_fixing_31, t0.review_average AS review_average_32, t0.free_delivery AS free_delivery_33, t0.new_item AS new_item_34, t0.last_id AS last_id_35, t0.last_url AS last_url_36, t0.rss_xml AS rss_xml_37, t0.price AS price_38, t0.show_control AS show_control_39, t0.courier_option AS courier_option_40, t0.show_first AS show_first_41, t0.tile_sealer AS tile_sealer_42, t0.tile_adhesive AS tile_adhesive_43, t0.samples_weight AS samples_weight_44, t0.default_category AS default_category_45, t0.default_alt_category AS default_alt_category_46, t0.type AS type_47, t0.per AS per_48, t0.site_id AS site_id_49, t0.item_id AS item_id_50 FROM web_item_detail t0 INNER JOIN web_item_details_fixings ON t0.id = web_item_details_fixings.fixing_item_id WHERE web_item_details_fixings.item_id = ? SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.u_date AS u_date_5, t0.id AS id_6, t0.sira AS sira_7, t0.code AS code_8, t0.del AS del_9, t0.freeSample AS freeSample_10, t0.gap AS gap_11, t0.projects_slab AS projects_slab_12, t0.dummy AS dummy_13, t0.title AS title_14, t0.brand AS brand_15, t0.product_type AS product_type_16, t0.sub_title AS sub_title_17, t0.title_seo AS title_seo_18, t0.web_group_name AS web_group_name_19, t0.photo AS photo_20, t0.photo_title AS photo_title_21, t0.photo_sub_title AS photo_sub_title_22, t0.little_description AS little_description_23, t0.description AS description_24, t0.meta_title AS meta_title_25, t0.meta_keywords AS meta_keywords_26, t0.meta_description AS meta_description_27, t0.special_offer AS special_offer_28, t0.most_popular AS most_popular_29, t0.best_sellers AS best_sellers_30, t0.suggested_fixing AS suggested_fixing_31, t0.review_average AS review_average_32, t0.free_delivery AS free_delivery_33, t0.new_item AS new_item_34, t0.last_id AS last_id_35, t0.last_url AS last_url_36, t0.rss_xml AS rss_xml_37, t0.price AS price_38, t0.show_control AS show_control_39, t0.courier_option AS courier_option_40, t0.show_first AS show_first_41, t0.tile_sealer AS tile_sealer_42, t0.tile_adhesive AS tile_adhesive_43, t0.samples_weight AS samples_weight_44, t0.default_category AS default_category_45, t0.default_alt_category AS default_alt_category_46, t0.type AS type_47, t0.per AS per_48, t0.site_id AS site_id_49, t0.item_id AS item_id_50 FROM web_item_detail t0 INNER JOIN web_item_details_fixings ON t0.id = web_item_details_fixings.fixing_item_id WHERE web_item_details_fixings.item_id = 873;
23	0.87 ms	SELECT count(w0_.id) AS sclr_0 FROM web_item_detail w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.del = 0 AND w1_.id = ? AND w0_.web_group_name = ? Parameters: [`2 "CERMIPLUS C2FT FLEXIBLE RAPID SET ADHESIVE 20KG - WHITE"`] View formatted query View runnable query Explain query SELECT count(w0_.id) AS sclr_0 FROM web_item_detail w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.del = 0 AND w1_.id = ? AND w0_.web_group_name = ? SELECT count(w0_.id) AS sclr_0 FROM web_item_detail w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.del = 0 AND w1_.id = 2 AND w0_.web_group_name = 'CERMIPLUS C2FT FLEXIBLE RAPID SET ADHESIVE 20KG - WHITE';
24	1.52 ms	SELECT w0_.price AS price_0, w0_.old_price AS old_price_1, w0_.discount AS discount_2, w0_.show_control AS show_control_3 FROM web_item w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id INNER JOIN item i2_ ON w0_.item_id = i2_.id WHERE w0_.show_control = 1 AND i2_.status <> 2 AND w0_.del = 0 AND w1_.id = ? AND w0_.web_group_name = ? AND i2_.web_group_name = ? ORDER BY w0_.price + 0 ASC LIMIT 1 Parameters: [`2 "CERMIPLUS C2FT FLEXIBLE RAPID SET ADHESIVE 20KG - WHITE" "CERMIPLUS C2FT FLEXIBLE RAPID SET ADHESIVE 20KG - WHITE"`] View formatted query View runnable query Explain query SELECT w0_.price AS price_0, w0_.old_price AS old_price_1, w0_.discount AS discount_2, w0_.show_control AS show_control_3 FROM web_item w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id INNER JOIN item i2_ ON w0_.item_id = i2_.id WHERE w0_.show_control = 1 AND i2_.status <> 2 AND w0_.del = 0 AND w1_.id = ? AND w0_.web_group_name = ? AND i2_.web_group_name = ? ORDER BY w0_.price + 0 ASC LIMIT 1 SELECT w0_.price AS price_0, w0_.old_price AS old_price_1, w0_.discount AS discount_2, w0_.show_control AS show_control_3 FROM web_item w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id INNER JOIN item i2_ ON w0_.item_id = i2_.id WHERE w0_.show_control = 1 AND i2_.status <> 2 AND w0_.del = 0 AND w1_.id = 2 AND w0_.web_group_name = 'CERMIPLUS C2FT FLEXIBLE RAPID SET ADHESIVE 20KG - WHITE' AND i2_.web_group_name = 'CERMIPLUS C2FT FLEXIBLE RAPID SET ADHESIVE 20KG - WHITE' ORDER BY w0_.price + 0 ASC LIMIT 1;
25	0.39 ms	SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ? Parameters: [`760`] View formatted query View runnable query Explain query SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ? SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = 760;
26	0.80 ms	SELECT count(w0_.id) AS sclr_0 FROM web_item_detail w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.del = 0 AND w1_.id = ? AND w0_.web_group_name = ? Parameters: [`2 "CERMIPLUS C2TE S1 FLEXIBLE STANDARD SET ADHESIVE"`] View formatted query View runnable query Explain query SELECT count(w0_.id) AS sclr_0 FROM web_item_detail w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.del = 0 AND w1_.id = ? AND w0_.web_group_name = ? SELECT count(w0_.id) AS sclr_0 FROM web_item_detail w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.del = 0 AND w1_.id = 2 AND w0_.web_group_name = 'CERMIPLUS C2TE S1 FLEXIBLE STANDARD SET ADHESIVE';
27	1.42 ms	SELECT w0_.price AS price_0, w0_.old_price AS old_price_1, w0_.discount AS discount_2, w0_.show_control AS show_control_3 FROM web_item w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id INNER JOIN item i2_ ON w0_.item_id = i2_.id WHERE w0_.show_control = 1 AND i2_.status <> 2 AND w0_.del = 0 AND w1_.id = ? AND w0_.web_group_name = ? AND i2_.web_group_name = ? ORDER BY w0_.price + 0 ASC LIMIT 1 Parameters: [`2 "CERMIPLUS C2TE S1 FLEXIBLE STANDARD SET ADHESIVE" "CERMIPLUS C2TE S1 FLEXIBLE STANDARD SET ADHESIVE"`] View formatted query View runnable query Explain query SELECT w0_.price AS price_0, w0_.old_price AS old_price_1, w0_.discount AS discount_2, w0_.show_control AS show_control_3 FROM web_item w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id INNER JOIN item i2_ ON w0_.item_id = i2_.id WHERE w0_.show_control = 1 AND i2_.status <> 2 AND w0_.del = 0 AND w1_.id = ? AND w0_.web_group_name = ? AND i2_.web_group_name = ? ORDER BY w0_.price + 0 ASC LIMIT 1 SELECT w0_.price AS price_0, w0_.old_price AS old_price_1, w0_.discount AS discount_2, w0_.show_control AS show_control_3 FROM web_item w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id INNER JOIN item i2_ ON w0_.item_id = i2_.id WHERE w0_.show_control = 1 AND i2_.status <> 2 AND w0_.del = 0 AND w1_.id = 2 AND w0_.web_group_name = 'CERMIPLUS C2TE S1 FLEXIBLE STANDARD SET ADHESIVE' AND i2_.web_group_name = 'CERMIPLUS C2TE S1 FLEXIBLE STANDARD SET ADHESIVE' ORDER BY w0_.price + 0 ASC LIMIT 1;
28	0.36 ms	SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ? Parameters: [`754`] View formatted query View runnable query Explain query SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ? SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = 754;
29	0.79 ms	SELECT count(w0_.id) AS sclr_0 FROM web_item_detail w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.del = 0 AND w1_.id = ? AND w0_.web_group_name = ? Parameters: [`2 "LTP GROUT PROTECTOR"`] View formatted query View runnable query Explain query SELECT count(w0_.id) AS sclr_0 FROM web_item_detail w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.del = 0 AND w1_.id = ? AND w0_.web_group_name = ? SELECT count(w0_.id) AS sclr_0 FROM web_item_detail w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.del = 0 AND w1_.id = 2 AND w0_.web_group_name = 'LTP GROUT PROTECTOR';
30	1.32 ms	SELECT w0_.price AS price_0, w0_.old_price AS old_price_1, w0_.discount AS discount_2, w0_.show_control AS show_control_3 FROM web_item w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id INNER JOIN item i2_ ON w0_.item_id = i2_.id WHERE w0_.show_control = 1 AND i2_.status <> 2 AND w0_.del = 0 AND w1_.id = ? AND w0_.web_group_name = ? AND i2_.web_group_name = ? ORDER BY w0_.price + 0 ASC LIMIT 1 Parameters: [`2 "LTP GROUT PROTECTOR" "LTP GROUT PROTECTOR"`] View formatted query View runnable query Explain query SELECT w0_.price AS price_0, w0_.old_price AS old_price_1, w0_.discount AS discount_2, w0_.show_control AS show_control_3 FROM web_item w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id INNER JOIN item i2_ ON w0_.item_id = i2_.id WHERE w0_.show_control = 1 AND i2_.status <> 2 AND w0_.del = 0 AND w1_.id = ? AND w0_.web_group_name = ? AND i2_.web_group_name = ? ORDER BY w0_.price + 0 ASC LIMIT 1 SELECT w0_.price AS price_0, w0_.old_price AS old_price_1, w0_.discount AS discount_2, w0_.show_control AS show_control_3 FROM web_item w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id INNER JOIN item i2_ ON w0_.item_id = i2_.id WHERE w0_.show_control = 1 AND i2_.status <> 2 AND w0_.del = 0 AND w1_.id = 2 AND w0_.web_group_name = 'LTP GROUT PROTECTOR' AND i2_.web_group_name = 'LTP GROUT PROTECTOR' ORDER BY w0_.price + 0 ASC LIMIT 1;
31	0.37 ms	SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ? Parameters: [`36`] View formatted query View runnable query Explain query SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ? SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = 36;
32	0.98 ms	SELECT count(w0_.id) AS sclr_0 FROM web_item_detail w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.del = 0 AND w1_.id = ? AND w0_.web_group_name = ? Parameters: [`2 "LTP MATTSTONE IMPREGNATING SEALER"`] View formatted query View runnable query Explain query SELECT count(w0_.id) AS sclr_0 FROM web_item_detail w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.del = 0 AND w1_.id = ? AND w0_.web_group_name = ? SELECT count(w0_.id) AS sclr_0 FROM web_item_detail w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.del = 0 AND w1_.id = 2 AND w0_.web_group_name = 'LTP MATTSTONE IMPREGNATING SEALER';
33	1.35 ms	SELECT w0_.price AS price_0, w0_.old_price AS old_price_1, w0_.discount AS discount_2, w0_.show_control AS show_control_3 FROM web_item w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id INNER JOIN item i2_ ON w0_.item_id = i2_.id WHERE w0_.show_control = 1 AND i2_.status <> 2 AND w0_.del = 0 AND w1_.id = ? AND w0_.web_group_name = ? AND i2_.web_group_name = ? ORDER BY w0_.price + 0 ASC LIMIT 1 Parameters: [`2 "LTP MATTSTONE IMPREGNATING SEALER" "LTP MATTSTONE IMPREGNATING SEALER"`] View formatted query View runnable query Explain query SELECT w0_.price AS price_0, w0_.old_price AS old_price_1, w0_.discount AS discount_2, w0_.show_control AS show_control_3 FROM web_item w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id INNER JOIN item i2_ ON w0_.item_id = i2_.id WHERE w0_.show_control = 1 AND i2_.status <> 2 AND w0_.del = 0 AND w1_.id = ? AND w0_.web_group_name = ? AND i2_.web_group_name = ? ORDER BY w0_.price + 0 ASC LIMIT 1 SELECT w0_.price AS price_0, w0_.old_price AS old_price_1, w0_.discount AS discount_2, w0_.show_control AS show_control_3 FROM web_item w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id INNER JOIN item i2_ ON w0_.item_id = i2_.id WHERE w0_.show_control = 1 AND i2_.status <> 2 AND w0_.del = 0 AND w1_.id = 2 AND w0_.web_group_name = 'LTP MATTSTONE IMPREGNATING SEALER' AND i2_.web_group_name = 'LTP MATTSTONE IMPREGNATING SEALER' ORDER BY w0_.price + 0 ASC LIMIT 1;
34	0.37 ms	SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ? Parameters: [`14`] View formatted query View runnable query Explain query SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ? SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = 14;
35	0.75 ms	SELECT count(w0_.id) AS sclr_0 FROM web_item_detail w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.del = 0 AND w1_.id = ? AND w0_.web_group_name = ? Parameters: [`2 "LTP WAXWASH MAINTENANCE PRODUCT"`] View formatted query View runnable query Explain query SELECT count(w0_.id) AS sclr_0 FROM web_item_detail w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.del = 0 AND w1_.id = ? AND w0_.web_group_name = ? SELECT count(w0_.id) AS sclr_0 FROM web_item_detail w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.del = 0 AND w1_.id = 2 AND w0_.web_group_name = 'LTP WAXWASH MAINTENANCE PRODUCT';
36	1.37 ms	SELECT w0_.price AS price_0, w0_.old_price AS old_price_1, w0_.discount AS discount_2, w0_.show_control AS show_control_3 FROM web_item w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id INNER JOIN item i2_ ON w0_.item_id = i2_.id WHERE w0_.show_control = 1 AND i2_.status <> 2 AND w0_.del = 0 AND w1_.id = ? AND w0_.web_group_name = ? AND i2_.web_group_name = ? ORDER BY w0_.price + 0 ASC LIMIT 1 Parameters: [`2 "LTP WAXWASH MAINTENANCE PRODUCT" "LTP WAXWASH MAINTENANCE PRODUCT"`] View formatted query View runnable query Explain query SELECT w0_.price AS price_0, w0_.old_price AS old_price_1, w0_.discount AS discount_2, w0_.show_control AS show_control_3 FROM web_item w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id INNER JOIN item i2_ ON w0_.item_id = i2_.id WHERE w0_.show_control = 1 AND i2_.status <> 2 AND w0_.del = 0 AND w1_.id = ? AND w0_.web_group_name = ? AND i2_.web_group_name = ? ORDER BY w0_.price + 0 ASC LIMIT 1 SELECT w0_.price AS price_0, w0_.old_price AS old_price_1, w0_.discount AS discount_2, w0_.show_control AS show_control_3 FROM web_item w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id INNER JOIN item i2_ ON w0_.item_id = i2_.id WHERE w0_.show_control = 1 AND i2_.status <> 2 AND w0_.del = 0 AND w1_.id = 2 AND w0_.web_group_name = 'LTP WAXWASH MAINTENANCE PRODUCT' AND i2_.web_group_name = 'LTP WAXWASH MAINTENANCE PRODUCT' ORDER BY w0_.price + 0 ASC LIMIT 1;
37	0.61 ms	SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ? Parameters: [`54`] View formatted query View runnable query Explain query SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ? SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = 54;
38	0.89 ms	SELECT i0_.code AS code_0 FROM web_item w1_ LEFT JOIN item i0_ ON w1_.item_id = i0_.id WHERE i0_.id = ? Parameters: [`873`] View formatted query View runnable query Explain query SELECT i0_.code AS code_0 FROM web_item w1_ LEFT JOIN item i0_ ON w1_.item_id = i0_.id WHERE i0_.id = ? SELECT i0_.code AS code_0 FROM web_item w1_ LEFT JOIN item i0_ ON w1_.item_id = i0_.id WHERE i0_.id = 873;
39	3.86 ms	SELECT w0_.created_at AS created_at_0, w0_.updated_at AS updated_at_1, w0_.created_by AS created_by_2, w0_.updated_by AS updated_by_3, w0_.u_date AS u_date_4, w0_.id AS id_5, w0_.sira AS sira_6, w0_.code AS code_7, w0_.del AS del_8, w0_.web_item_detail_id AS web_item_detail_id_9, w0_.web_item_info_options_id AS web_item_info_options_id_10 FROM web_item_info w0_ INNER JOIN web_item_info_option w1_ ON w0_.web_item_info_options_id = w1_.id WHERE w0_.web_item_detail_id = ? ORDER BY w1_.sira ASC, w1_.title ASC Parameters: [`873`] View formatted query View runnable query Explain query SELECT w0_.created_at AS created_at_0, w0_.updated_at AS updated_at_1, w0_.created_by AS created_by_2, w0_.updated_by AS updated_by_3, w0_.u_date AS u_date_4, w0_.id AS id_5, w0_.sira AS sira_6, w0_.code AS code_7, w0_.del AS del_8, w0_.web_item_detail_id AS web_item_detail_id_9, w0_.web_item_info_options_id AS web_item_info_options_id_10 FROM web_item_info w0_ INNER JOIN web_item_info_option w1_ ON w0_.web_item_info_options_id = w1_.id WHERE w0_.web_item_detail_id = ? ORDER BY w1_.sira ASC, w1_.title ASC SELECT w0_.created_at AS created_at_0, w0_.updated_at AS updated_at_1, w0_.created_by AS created_by_2, w0_.updated_by AS updated_by_3, w0_.u_date AS u_date_4, w0_.id AS id_5, w0_.sira AS sira_6, w0_.code AS code_7, w0_.del AS del_8, w0_.web_item_detail_id AS web_item_detail_id_9, w0_.web_item_info_options_id AS web_item_info_options_id_10 FROM web_item_info w0_ INNER JOIN web_item_info_option w1_ ON w0_.web_item_info_options_id = w1_.id WHERE w0_.web_item_detail_id = 873 ORDER BY w1_.sira ASC, w1_.title ASC;
40	0.38 ms	SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ? Parameters: [`873`] View formatted query View runnable query Explain query SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ? SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = 873;
41	1.67 ms	SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.u_date AS u_date_5, t0.id AS id_6, t0.sira AS sira_7, t0.code AS code_8, t0.del AS del_9, t0.web_item_detail_id AS web_item_detail_id_10, t0.web_care_delivery_id AS web_care_delivery_id_11 FROM web_item_care_delivery t0 WHERE t0.web_item_detail_id = ? Parameters: [`873`] View formatted query View runnable query Explain query SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.u_date AS u_date_5, t0.id AS id_6, t0.sira AS sira_7, t0.code AS code_8, t0.del AS del_9, t0.web_item_detail_id AS web_item_detail_id_10, t0.web_care_delivery_id AS web_care_delivery_id_11 FROM web_item_care_delivery t0 WHERE t0.web_item_detail_id = ? SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.u_date AS u_date_5, t0.id AS id_6, t0.sira AS sira_7, t0.code AS code_8, t0.del AS del_9, t0.web_item_detail_id AS web_item_detail_id_10, t0.web_care_delivery_id AS web_care_delivery_id_11 FROM web_item_care_delivery t0 WHERE t0.web_item_detail_id = 873;
42	0.74 ms	SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.u_date AS u_date_5, t0.id AS id_6, t0.sira AS sira_7, t0.code AS code_8, t0.del AS del_9, t0.title AS title_10, t0.titleSeo AS titleSeo_11, t0.infoTitle AS infoTitle_12, t0.description AS description_13, t0.type AS type_14, t0.infoIcon AS infoIcon_15, t0.main_id AS main_id_16, t0.site_id AS site_id_17 FROM web_care_delivery t0 WHERE t0.site_id = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.u_date AS u_date_5, t0.id AS id_6, t0.sira AS sira_7, t0.code AS code_8, t0.del AS del_9, t0.title AS title_10, t0.titleSeo AS titleSeo_11, t0.infoTitle AS infoTitle_12, t0.description AS description_13, t0.type AS type_14, t0.infoIcon AS infoIcon_15, t0.main_id AS main_id_16, t0.site_id AS site_id_17 FROM web_care_delivery t0 WHERE t0.site_id = ? SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.u_date AS u_date_5, t0.id AS id_6, t0.sira AS sira_7, t0.code AS code_8, t0.del AS del_9, t0.title AS title_10, t0.titleSeo AS titleSeo_11, t0.infoTitle AS infoTitle_12, t0.description AS description_13, t0.type AS type_14, t0.infoIcon AS infoIcon_15, t0.main_id AS main_id_16, t0.site_id AS site_id_17 FROM web_care_delivery t0 WHERE t0.site_id = 2;
43	0.39 ms	SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.u_date AS u_date_5, t0.id AS id_6, t0.sira AS sira_7, t0.code AS code_8, t0.del AS del_9, t0.pallet_kg AS pallet_kg_10, t0.weight_limit AS weight_limit_11, t0.financial_year_start AS financial_year_start_12, t0.financial_year_end AS financial_year_end_13, t0.voidDay1 AS voidDay1_14, t0.voidDay2 AS voidDay2_15, t0.voidDay3 AS voidDay3_16, t0.voidDay4 AS voidDay4_17, t0.voidDay5 AS voidDay5_18, t0.kdv_value AS kdv_value_19, t0.default_tax AS default_tax_20 FROM settings t0 WHERE t0.id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.u_date AS u_date_5, t0.id AS id_6, t0.sira AS sira_7, t0.code AS code_8, t0.del AS del_9, t0.pallet_kg AS pallet_kg_10, t0.weight_limit AS weight_limit_11, t0.financial_year_start AS financial_year_start_12, t0.financial_year_end AS financial_year_end_13, t0.voidDay1 AS voidDay1_14, t0.voidDay2 AS voidDay2_15, t0.voidDay3 AS voidDay3_16, t0.voidDay4 AS voidDay4_17, t0.voidDay5 AS voidDay5_18, t0.kdv_value AS kdv_value_19, t0.default_tax AS default_tax_20 FROM settings t0 WHERE t0.id = ? SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.u_date AS u_date_5, t0.id AS id_6, t0.sira AS sira_7, t0.code AS code_8, t0.del AS del_9, t0.pallet_kg AS pallet_kg_10, t0.weight_limit AS weight_limit_11, t0.financial_year_start AS financial_year_start_12, t0.financial_year_end AS financial_year_end_13, t0.voidDay1 AS voidDay1_14, t0.voidDay2 AS voidDay2_15, t0.voidDay3 AS voidDay3_16, t0.voidDay4 AS voidDay4_17, t0.voidDay5 AS voidDay5_18, t0.kdv_value AS kdv_value_19, t0.default_tax AS default_tax_20 FROM settings t0 WHERE t0.id = 1;

Database Connections

Name	Service
default	doctrine.dbal.default_connection
logging	doctrine.dbal.logging_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\WebCareDelivery	22
App\Entity\WebItemDetail	10
App\Entity\Item	10
App\Entity\WebItemInfo	9
App\Entity\WebItemInfoOption	9
App\Entity\WebItemCareDelivery	9
App\Entity\WebCategory	3
App\Entity\WebItemReview	3
App\Entity\WebSite	1
App\Entity\WebItem	1
App\Entity\Settings	1

Entities Mapping

Class	Mapping errors
App\Entity\BaseEntity	No errors.
App\Entity\WebSite	The mappings App\Entity\WebSite#webCategoryShows and App\Entity\WebCategoryBanner#webSite are inconsistent with each other.
App\Entity\Samples	No errors.
App\Entity\CustomerOrder	No errors.
App\Entity\CustomerProforma	The association App\Entity\CustomerProforma#customer refers to the inverse side field App\Entity\Customer#proforma which does not exist. The association App\Entity\CustomerProforma#paymentTerm refers to the inverse side field App\Entity\PaymentTerm#customerProforma which does not exist. The association App\Entity\CustomerProforma#shippingMethod refers to the inverse side field App\Entity\ShippingMethod#customerProforma which does not exist. The association App\Entity\CustomerProforma#orderStage refers to the inverse side field App\Entity\OrderStage#customerProforma which does not exist. The association App\Entity\CustomerProforma#warehouse refers to the inverse side field App\Entity\Warehouse#customerProforma which does not exist. The association App\Entity\CustomerProforma#contact refers to the inverse side field App\Entity\CustomerContact#customerProforma which does not exist. The association App\Entity\CustomerProforma#multiCurrency refers to the inverse side field App\Entity\MultiCurrency#customerProforma which does not exist. The association App\Entity\CustomerProforma#shipToList refers to the inverse side field App\Entity\CustomerShipToList#customerProforma which does not exist. The association App\Entity\CustomerProforma#postCode refers to the inverse side field App\Entity\PostCode#customerProforma which does not exist.
App\Entity\CustomerInvoice	No errors.
App\Entity\WebOrder	No errors.
App\Entity\WebCategoryBanner	The association App\Entity\WebCategoryBanner#category refers to the inverse side field App\Entity\Category#webCategoryBanners which does not exist.
App\Entity\WebFaq	No errors.
App\Entity\WebPageSource	No errors.
App\Entity\WebContactForm	No errors.
App\Entity\WebBanner	No errors.
App\Entity\WebBlogCategory	No errors.
App\Entity\WebBlog	No errors.
App\Entity\WebSocial	No errors.
App\Entity\WebItem	The association App\Entity\WebItem#categories refers to the inverse side field App\Entity\Category#webItems which does not exist.
App\Entity\WebItemDetail	The association App\Entity\WebItemDetail#item refers to the inverse side field App\Entity\Item#webItemDetails which does not exist. The association App\Entity\WebItemDetail#zoneCourier refers to the inverse side field App\Entity\ZoneCourier#webItemDetails which does not exist.
App\Entity\WebItemInfoOption	No errors.
App\Entity\WebLabel	No errors.
App\Entity\WebCareDelivery	No errors.
App\Entity\WebItemReview	No errors.
App\Entity\WebItemQuestion	No errors.
App\Entity\WebPage	No errors.
App\Entity\Customer	No errors.
App\Entity\CustomerContact	The mappings App\Entity\CustomerContact#customerNotes and App\Entity\CustomerNotes#contact are inconsistent with each other.
App\Entity\Item	The mappings App\Entity\Item#stockTakeItem and App\Entity\StockTransferItem#item are inconsistent with each other. The mappings App\Entity\Item#corporateItems and App\Entity\CorporateItem#item are inconsistent with each other. The association App\Entity\Item#defaultWarehouse refers to the inverse side field App\Entity\Warehouse#defaultWarehouseItem which does not exist. The association App\Entity\Item#accessoryItem refers to the inverse side field App\Entity\Item#accessoryItems which does not exist. The association App\Entity\Item#substituteItem refers to the inverse side field App\Entity\Item#substituteItems which does not exist.
App\Entity\WebBasket	The association App\Entity\WebBasket#user refers to the inverse side field App\Entity\User#webBaskets which does not exist.
App\Entity\WebCategory	The association App\Entity\WebCategory#webSite refers to the inverse side field App\Entity\WebSite#webCategories which does not exist.
App\Entity\ZoneCourier	No errors.
App\Entity\WebItemPhoto	No errors.
App\Entity\WebOrderItem	No errors.
App\Entity\SamplesItem	No errors.
App\Entity\WebItemInfo	No errors.
App\Entity\WebItemLabel	No errors.
App\Entity\WebItemCareDelivery	No errors.
App\Entity\WebItemDetailCategories	No errors.
App\Entity\WebCategoryShow	The association App\Entity\WebCategoryShow#category refers to the inverse side field App\Entity\Category#webCategoryShows which does not exist.
App\Entity\Category	No errors.
App\Entity\UnitMeasure	No errors.
App\Entity\ItemWarehouse	No errors.
App\Entity\UnitType	No errors.
App\Entity\Settings	No errors.

Symfony Profiler

GET https://teststonedeals.ionsis.co.uk/_fragment?_path=_format%3Dhtml%26_locale%3Den%26_controller%3DApp%255CController%255CDefaultController%253A%253AtagmanagerAc…

Configuration Settings

Theme

Page Width

Query Metrics

Queries

default connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping