Symfony Profiler

Query Metrics

167 Database Queries

36 Different statements

172.21 ms Query time

33 Invalid entities

81 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 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 = ?
SELECT DATABASE()
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
SELECT DATABASE()
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
SELECT @@character_set_database, @@collation_database
SELECT DATABASE()
SELECT c.TABLE_NAME,
       c.COLUMN_NAME,
           IF(
        c.DATA_TYPE = 'longtext'
        AND EXISTS(
            SELECT * FROM information_schema.CHECK_CONSTRAINTS i_c
            WHERE i_c.CONSTRAINT_SCHEMA = 'dbs9323576'
            AND i_c.TABLE_NAME = c.TABLE_NAME
            AND i_c.CHECK_CLAUSE = CONCAT(
                'json_valid(`',
                    c.COLUMN_NAME,
                '`)'
            )
        ),
        'json',
        c.DATA_TYPE
    ),
       c.COLUMN_TYPE,
       c.CHARACTER_MAXIMUM_LENGTH,
       c.CHARACTER_OCTET_LENGTH,
       c.NUMERIC_PRECISION,
       c.NUMERIC_SCALE,
       c.IS_NULLABLE,
       c.COLUMN_DEFAULT,
       c.EXTRA,
       c.COLUMN_COMMENT,
       c.CHARACTER_SET_NAME,
       c.COLLATION_NAME
FROM information_schema.COLUMNS c
         INNER JOIN information_schema.TABLES t
                    ON t.TABLE_NAME = c.TABLE_NAME
WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ?
  AND t.TABLE_TYPE = 'BASE TABLE'
ORDER BY c.TABLE_NAME,
         c.ORDINAL_POSITION
SELECT DATABASE()
SELECT t.TABLE_NAME,
           t.ENGINE,
           t.AUTO_INCREMENT,
           t.TABLE_COMMENT,
           t.CREATE_OPTIONS,
           t.TABLE_COLLATION,
           ccsa.CHARACTER_SET_NAME
      FROM information_schema.TABLES t
        INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa
          ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE'
SELECT DATABASE()
SELECT tc.TABLE_NAME,
       tc.CONSTRAINT_NAME,
       kcu.COLUMN_NAME
FROM information_schema.TABLE_CONSTRAINTS tc
         INNER JOIN information_schema.KEY_COLUMN_USAGE kcu
                    ON kcu.TABLE_NAME = tc.TABLE_NAME
                        AND kcu.CONSTRAINT_NAME = tc.CONSTRAINT_NAME
WHERE tc.TABLE_SCHEMA = ? AND kcu.TABLE_SCHEMA = ? AND tc.TABLE_NAME = ?
  AND tc.CONSTRAINT_TYPE = 'PRIMARY KEY'
ORDER BY TABLE_NAME,
    kcu.ORDINAL_POSITION
SELECT DATABASE()
SELECT TABLE_NAME,
       INDEX_NAME,
       INDEX_TYPE,
       NON_UNIQUE,
       COLUMN_NAME,
       SUB_PART
FROM information_schema.STATISTICS
WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ?
  AND INDEX_NAME != 'PRIMARY'
ORDER BY TABLE_NAME,
    SEQ_IN_INDEX
SELECT DATABASE()
SELECT k.TABLE_NAME,
       k.CONSTRAINT_NAME,
       k.REFERENCED_TABLE_NAME,
       c.UPDATE_RULE,
       c.DELETE_RULE,
       k.COLUMN_NAME,
       k.REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE k
         INNER JOIN information_schema.REFERENTIAL_CONSTRAINTS c
                    ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME
                        AND c.TABLE_NAME = k.TABLE_NAME
WHERE k.TABLE_SCHEMA = ? AND c.CONSTRAINT_SCHEMA = ? AND k.TABLE_NAME = ?
  AND k.REFERENCED_COLUMN_NAME IS NOT NULL
ORDER BY k.TABLE_NAME,
         k.CONSTRAINT_NAME,
         k.ORDINAL_POSITION
SELECT * FROM doctrine_migration_versions
SELECT DATABASE()
SELECT COUNT(w0_.id) AS sclr_0 FROM web_basket w0_ WHERE w0_.userSession = ?
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.userSession AS userSession_10, t0.quantity AS quantity_11, t0.sqm AS sqm_12, t0.price AS price_13, t0.free_sample AS free_sample_14, t0.user_id AS user_id_15, t0.item_id AS item_id_16, t0.show_item_id AS show_item_id_17, t0.item_detail_id AS item_detail_id_18 FROM web_basket t0 WHERE t0.userSession = ?
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.facebook AS facebook_10, t0.pinterest AS pinterest_11, t0.twitter AS twitter_12, t0.linkedin AS linkedin_13, t0.instagram AS instagram_14, t0.site_id AS site_id_15 FROM web_social t0 WHERE t0.site_id = ? LIMIT 1
SELECT w0_.id AS id_0, w0_.group_status AS group_status_1, w0_.group_name AS group_name_2, w0_.title AS title_3, w0_.title_seo AS title_seo_4 FROM web_category w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id INNER JOIN web_category w2_ ON w0_.category_id = w2_.id WHERE w0_.status = 1 AND w0_.del = 0 AND w1_.id = ? AND w2_.category_id IS NULL ORDER BY w0_.sira ASC
SELECT w0_.id AS id_0, w0_.title AS title_1, w0_.group_status AS group_status_2, w0_.group_name AS group_name_3, w0_.title_seo AS title_seo_4 FROM web_category w0_ LEFT JOIN web_category w1_ ON w0_.category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.del = 0 AND w2_.id = ? AND w1_.id = ? ORDER BY w0_.sira ASC
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.id AS id_0, w0_.title AS title_1, w0_.group_status AS group_status_2, w0_.group_name AS group_name_3, w0_.title_seo AS title_seo_4 FROM web_category w0_ LEFT JOIN web_category w1_ ON w0_.category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.del = 0 AND w2_.id = ? AND w1_.id = ? ORDER BY w0_.sira ASC
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.id AS id_0, w0_.title AS title_1, w0_.group_status AS group_status_2, w0_.group_name AS group_name_3, w0_.title_seo AS title_seo_4 FROM web_category w0_ LEFT JOIN web_category w1_ ON w0_.category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.del = 0 AND w2_.id = ? AND w1_.id = ? ORDER BY w0_.sira ASC
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.id AS id_0, w0_.title AS title_1, w0_.group_status AS group_status_2, w0_.group_name AS group_name_3, w0_.title_seo AS title_seo_4 FROM web_category w0_ LEFT JOIN web_category w1_ ON w0_.category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.del = 0 AND w2_.id = ? AND w1_.id = ? ORDER BY w0_.sira ASC
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.id AS id_0, w0_.title AS title_1, w0_.group_status AS group_status_2, w0_.group_name AS group_name_3, w0_.title_seo AS title_seo_4 FROM web_category w0_ LEFT JOIN web_category w1_ ON w0_.category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.del = 0 AND w2_.id = ? AND w1_.id = ? ORDER BY w0_.sira ASC
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.id AS id_0, w0_.title AS title_1, w0_.group_status AS group_status_2, w0_.group_name AS group_name_3, w0_.title_seo AS title_seo_4 FROM web_category w0_ LEFT JOIN web_category w1_ ON w0_.category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.del = 0 AND w2_.id = ? AND w1_.id = ? ORDER BY w0_.sira ASC
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.id AS id_0, w0_.title AS title_1, w0_.group_status AS group_status_2, w0_.group_name AS group_name_3, w0_.title_seo AS title_seo_4 FROM web_category w0_ LEFT JOIN web_category w1_ ON w0_.category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.del = 0 AND w2_.id = ? AND w1_.id = ? ORDER BY w0_.sira ASC
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.id AS id_0, w0_.title AS title_1, w0_.group_status AS group_status_2, w0_.group_name AS group_name_3, w0_.title_seo AS title_seo_4 FROM web_category w0_ LEFT JOIN web_category w1_ ON w0_.category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.del = 0 AND w2_.id = ? AND w1_.id = ? ORDER BY w0_.sira ASC
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.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.titleSeo AS titleSeo_11, t0.description AS description_12, t0.type AS type_13, t0.upper_link AS upper_link_14, t0.meta_title AS meta_title_15, t0.meta_description AS meta_description_16, t0.site_id AS site_id_17 FROM web_page t0 WHERE t0.site_id = ? AND t0.del = ? AND t0.upper_link = ?
SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.company_description AS company_description_3, t0.company_email AS company_email_4, t0.company_phone AS company_phone_5, t0.company_fax AS company_fax_6, t0.company_address AS company_address_7, t0.company_address_html AS company_address_html_8, t0.company_logo AS company_logo_9, t0.copyright AS copyright_10, t0.auto_allocate AS auto_allocate_11, t0.cronjob_auto_allocate AS cronjob_auto_allocate_12, t0.cronjob_credit_hold AS cronjob_credit_hold_13, t0.exchange_rate_api AS exchange_rate_api_14, t0.coming_soon AS coming_soon_15, t0.coming_soon_date AS coming_soon_date_16, t0.maintenance_mode AS maintenance_mode_17, t0.custom_transaction AS custom_transaction_18, t0.transaction_entries AS transaction_entries_19, t0.api AS api_20, t0.login_captcha_key AS login_captcha_key_21, t0.login_captcha_id AS login_captcha_id_22, t0.dev_mod AS dev_mod_23, t0.developer_email AS developer_email_24, t0.ftp_username AS ftp_username_25, t0.ftp_hostname AS ftp_hostname_26, t0.ftp_password AS ftp_password_27, t0.ftp_port AS ftp_port_28 FROM system_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.photo AS photo_10, t0.photo_title AS photo_title_11, t0.photo_sub_title AS photo_sub_title_12, t0.web_item_id AS web_item_id_13, t0.web_item_detail_id AS web_item_detail_id_14 FROM web_item_photo t0 WHERE t0.web_item_detail_id = ? ORDER BY t0.sira ASC
SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1
SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1
SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1

#▲	Time	Info
1	0.70 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	4.08 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: [`"silver-shadow-grey-marble-tile-honed" 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 = 'silver-shadow-grey-marble-tile-honed' AND t0.site_id = 2 AND t0.del = 0 LIMIT 1;
3	0.73 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.64 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	4.03 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: [`870`] 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 = 870 LIMIT 1;
6	2.78 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: [`870 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 = 870 AND t0.status = 1 AND t0.del = 0 AND t0.site_id = 2 ORDER BY t0.id DESC;
7	3.80 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: [`870 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 = 870 AND t0.status = 1 AND t0.del = 0 AND t0.site_id = 2 ORDER BY t0.id DESC;
8	4.38 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 "SILVER SHADOW HONED MARBLE" 870`] 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 = 'SILVER SHADOW HONED MARBLE' AND w6_.id = 870 GROUP BY w0_.id ORDER BY w0_.price + 0 ASC, w0_.size_name ASC;
9	2.63 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: [`870`] 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 = 870;
10	1.45 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 "SILVER CLASSIC HONED 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 = 'SILVER CLASSIC HONED MARBLE';
11	2.46 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 "SILVER CLASSIC HONED MARBLE" "SILVER CLASSIC HONED 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 = 'SILVER CLASSIC HONED MARBLE' AND i2_.web_group_name = 'SILVER CLASSIC HONED MARBLE' ORDER BY w0_.price + 0 ASC LIMIT 1;
12	0.87 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: [`485`] 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 = 485;
13	1.82 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 "SILVER MOON HONED MARBLE HERRINGBONE"`] 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 = 'SILVER MOON HONED MARBLE HERRINGBONE';
14	3.61 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 "SILVER MOON HONED MARBLE HERRINGBONE" "SILVER MOON HONED MARBLE HERRINGBONE"`] 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 = 'SILVER MOON HONED MARBLE HERRINGBONE' AND i2_.web_group_name = 'SILVER MOON HONED MARBLE HERRINGBONE' ORDER BY w0_.price + 0 ASC LIMIT 1;
15	0.73 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: [`724`] 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 = 724;
16	1.89 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 "SILVER MOON HONED MOSAIC HEXAGON"`] 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 = 'SILVER MOON HONED MOSAIC HEXAGON';
17	3.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 "SILVER MOON HONED MOSAIC HEXAGON" "SILVER MOON HONED MOSAIC HEXAGON"`] 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 = 'SILVER MOON HONED MOSAIC HEXAGON' AND i2_.web_group_name = 'SILVER MOON HONED MOSAIC HEXAGON' ORDER BY w0_.price + 0 ASC LIMIT 1;
18	0.49 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: [`512`] 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 = 512;
19	1.10 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 "SILVER MOON HONED MARBLE HEXAGON"`] 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 = 'SILVER MOON HONED MARBLE HEXAGON';
20	1.85 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 "SILVER MOON HONED MARBLE HEXAGON" "SILVER MOON HONED MARBLE HEXAGON"`] 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 = 'SILVER MOON HONED MARBLE HEXAGON' AND i2_.web_group_name = 'SILVER MOON HONED MARBLE HEXAGON' ORDER BY w0_.price + 0 ASC LIMIT 1;
21	0.46 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: [`866`] 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 = 866;
22	1.11 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 "SILVER MOON HONED 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 = 'SILVER MOON HONED MARBLE';
23	1.89 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 "SILVER MOON HONED MARBLE" "SILVER MOON HONED 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 = 'SILVER MOON HONED MARBLE' AND i2_.web_group_name = 'SILVER MOON HONED MARBLE' ORDER BY w0_.price + 0 ASC LIMIT 1;
24	0.45 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: [`122`] 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 = 122;
25	0.99 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 "SILVER LIGHT HONED 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 = 'SILVER LIGHT HONED MARBLE';
26	1.36 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 "SILVER LIGHT HONED MARBLE" "SILVER LIGHT HONED 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 = 'SILVER LIGHT HONED MARBLE' AND i2_.web_group_name = 'SILVER LIGHT HONED MARBLE' ORDER BY w0_.price + 0 ASC LIMIT 1;
27	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: [`342`] 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 = 342;
28	1.62 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: [`870`] 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 = 870;
29	0.93 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';
30	1.38 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;
31	0.34 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;
32	0.82 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';
33	1.47 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;
34	0.42 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;
35	0.86 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';
36	1.40 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;
37	0.40 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;
38	0.78 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';
39	1.38 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;
40	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: [`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;
41	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 "NICOBOND GROUTPRO FLEXIBLE"`] 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 = 'NICOBOND GROUTPRO FLEXIBLE';
42	1.38 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 "NICOBOND GROUTPRO FLEXIBLE" "NICOBOND GROUTPRO FLEXIBLE"`] 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 = 'NICOBOND GROUTPRO FLEXIBLE' AND i2_.web_group_name = 'NICOBOND GROUTPRO FLEXIBLE' ORDER BY w0_.price + 0 ASC LIMIT 1;
43	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: [`854`] 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 = 854;
44	0.82 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: [`870`] 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 = 870;
45	3.23 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: [`870`] 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 = 870 ORDER BY w1_.sira ASC, w1_.title ASC;
46	0.42 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: [`870`] 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 = 870;
47	1.64 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: [`870`] 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 = 870;
48	0.64 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;
49	0.41 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;
50	0.27 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
51	2.43 ms	SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME Parameters: [`"dbs9323576"`] View formatted query View runnable query Explain query SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'dbs9323576' AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME;
52	0.19 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
53	2.75 ms	SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME Parameters: [`"dbs9323576"`] View formatted query View runnable query Explain query SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'dbs9323576' AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME;
54	0.24 ms	SELECT @@character_set_database, @@collation_database Parameters: [] View formatted query View runnable query Explain query SELECT @@character_set_database, @@collation_database SELECT @@character_set_database, @@collation_database;
55	0.23 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
56	3.49 ms	SELECT c.TABLE_NAME, c.COLUMN_NAME, IF( c.DATA_TYPE = 'longtext' AND EXISTS( SELECT * FROM information_schema.CHECK_CONSTRAINTS i_c WHERE i_c.CONSTRAINT_SCHEMA = 'dbs9323576' AND i_c.TABLE_NAME = c.TABLE_NAME AND i_c.CHECK_CLAUSE = CONCAT( 'json_valid(`', c.COLUMN_NAME, '`)' ) ), 'json', c.DATA_TYPE ), c.COLUMN_TYPE, c.CHARACTER_MAXIMUM_LENGTH, c.CHARACTER_OCTET_LENGTH, c.NUMERIC_PRECISION, c.NUMERIC_SCALE, c.IS_NULLABLE, c.COLUMN_DEFAULT, c.EXTRA, c.COLUMN_COMMENT, c.CHARACTER_SET_NAME, c.COLLATION_NAME FROM information_schema.COLUMNS c INNER JOIN information_schema.TABLES t ON t.TABLE_NAME = c.TABLE_NAME WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE' ORDER BY c.TABLE_NAME, c.ORDINAL_POSITION Parameters: [`"dbs9323576" "dbs9323576" "doctrine_migration_versions"`] View formatted query View runnable query Explain query SELECT c.TABLE_NAME, c.COLUMN_NAME, IF( c.DATA_TYPE = 'longtext' AND EXISTS( SELECT * FROM information_schema.CHECK_CONSTRAINTS i_c WHERE i_c.CONSTRAINT_SCHEMA = 'dbs9323576' AND i_c.TABLE_NAME = c.TABLE_NAME AND i_c.CHECK_CLAUSE = CONCAT( 'json_valid(`', c.COLUMN_NAME, '`)' ) ), 'json', c.DATA_TYPE ), c.COLUMN_TYPE, c.CHARACTER_MAXIMUM_LENGTH, c.CHARACTER_OCTET_LENGTH, c.NUMERIC_PRECISION, c.NUMERIC_SCALE, c.IS_NULLABLE, c.COLUMN_DEFAULT, c.EXTRA, c.COLUMN_COMMENT, c.CHARACTER_SET_NAME, c.COLLATION_NAME FROM information_schema.COLUMNS c INNER JOIN information_schema.TABLES t ON t.TABLE_NAME = c.TABLE_NAME WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE' ORDER BY c.TABLE_NAME, c.ORDINAL_POSITION SELECT c.TABLE_NAME, c.COLUMN_NAME, IF( c.DATA_TYPE = 'longtext' AND EXISTS( SELECT * FROM information_schema.CHECK_CONSTRAINTS i_c WHERE i_c.CONSTRAINT_SCHEMA = 'dbs9323576' AND i_c.TABLE_NAME = c.TABLE_NAME AND i_c.CHECK_CLAUSE = CONCAT( 'json_valid(`', c.COLUMN_NAME, '`)' ) ), 'json', c.DATA_TYPE ), c.COLUMN_TYPE, c.CHARACTER_MAXIMUM_LENGTH, c.CHARACTER_OCTET_LENGTH, c.NUMERIC_PRECISION, c.NUMERIC_SCALE, c.IS_NULLABLE, c.COLUMN_DEFAULT, c.EXTRA, c.COLUMN_COMMENT, c.CHARACTER_SET_NAME, c.COLLATION_NAME FROM information_schema.COLUMNS c INNER JOIN information_schema.TABLES t ON t.TABLE_NAME = c.TABLE_NAME WHERE c.TABLE_SCHEMA = 'dbs9323576' AND t.TABLE_SCHEMA = 'dbs9323576' AND t.TABLE_NAME = 'doctrine_migration_versions' AND t.TABLE_TYPE = 'BASE TABLE' ORDER BY c.TABLE_NAME, c.ORDINAL_POSITION;
57	0.40 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
58	3.37 ms	SELECT t.TABLE_NAME, t.ENGINE, t.AUTO_INCREMENT, t.TABLE_COMMENT, t.CREATE_OPTIONS, t.TABLE_COLLATION, ccsa.CHARACTER_SET_NAME FROM information_schema.TABLES t INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE' Parameters: [`"dbs9323576" "doctrine_migration_versions"`] View formatted query View runnable query Explain query SELECT t.TABLE_NAME, t.ENGINE, t.AUTO_INCREMENT, t.TABLE_COMMENT, t.CREATE_OPTIONS, t.TABLE_COLLATION, ccsa.CHARACTER_SET_NAME FROM information_schema.TABLES t INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE' SELECT t.TABLE_NAME, t.ENGINE, t.AUTO_INCREMENT, t.TABLE_COMMENT, t.CREATE_OPTIONS, t.TABLE_COLLATION, ccsa.CHARACTER_SET_NAME FROM information_schema.TABLES t INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = 'dbs9323576' AND t.TABLE_NAME = 'doctrine_migration_versions' AND t.TABLE_TYPE = 'BASE TABLE';
59	0.44 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
60	7.47 ms	SELECT tc.TABLE_NAME, tc.CONSTRAINT_NAME, kcu.COLUMN_NAME FROM information_schema.TABLE_CONSTRAINTS tc INNER JOIN information_schema.KEY_COLUMN_USAGE kcu ON kcu.TABLE_NAME = tc.TABLE_NAME AND kcu.CONSTRAINT_NAME = tc.CONSTRAINT_NAME WHERE tc.TABLE_SCHEMA = ? AND kcu.TABLE_SCHEMA = ? AND tc.TABLE_NAME = ? AND tc.CONSTRAINT_TYPE = 'PRIMARY KEY' ORDER BY TABLE_NAME, kcu.ORDINAL_POSITION Parameters: [`"dbs9323576" "dbs9323576" "doctrine_migration_versions"`] View formatted query View runnable query Explain query SELECT tc.TABLE_NAME, tc.CONSTRAINT_NAME, kcu.COLUMN_NAME FROM information_schema.TABLE_CONSTRAINTS tc INNER JOIN information_schema.KEY_COLUMN_USAGE kcu ON kcu.TABLE_NAME = tc.TABLE_NAME AND kcu.CONSTRAINT_NAME = tc.CONSTRAINT_NAME WHERE tc.TABLE_SCHEMA = ? AND kcu.TABLE_SCHEMA = ? AND tc.TABLE_NAME = ? AND tc.CONSTRAINT_TYPE = 'PRIMARY KEY' ORDER BY TABLE_NAME, kcu.ORDINAL_POSITION SELECT tc.TABLE_NAME, tc.CONSTRAINT_NAME, kcu.COLUMN_NAME FROM information_schema.TABLE_CONSTRAINTS tc INNER JOIN information_schema.KEY_COLUMN_USAGE kcu ON kcu.TABLE_NAME = tc.TABLE_NAME AND kcu.CONSTRAINT_NAME = tc.CONSTRAINT_NAME WHERE tc.TABLE_SCHEMA = 'dbs9323576' AND kcu.TABLE_SCHEMA = 'dbs9323576' AND tc.TABLE_NAME = 'doctrine_migration_versions' AND tc.CONSTRAINT_TYPE = 'PRIMARY KEY' ORDER BY TABLE_NAME, kcu.ORDINAL_POSITION;
61	0.31 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
62	0.49 ms	SELECT TABLE_NAME, INDEX_NAME, INDEX_TYPE, NON_UNIQUE, COLUMN_NAME, SUB_PART FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? AND INDEX_NAME != 'PRIMARY' ORDER BY TABLE_NAME, SEQ_IN_INDEX Parameters: [`"dbs9323576" "doctrine_migration_versions"`] View formatted query View runnable query Explain query SELECT TABLE_NAME, INDEX_NAME, INDEX_TYPE, NON_UNIQUE, COLUMN_NAME, SUB_PART FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? AND INDEX_NAME != 'PRIMARY' ORDER BY TABLE_NAME, SEQ_IN_INDEX SELECT TABLE_NAME, INDEX_NAME, INDEX_TYPE, NON_UNIQUE, COLUMN_NAME, SUB_PART FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = 'dbs9323576' AND TABLE_NAME = 'doctrine_migration_versions' AND INDEX_NAME != 'PRIMARY' ORDER BY TABLE_NAME, SEQ_IN_INDEX;
63	0.26 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
64	5.08 ms	SELECT k.TABLE_NAME, k.CONSTRAINT_NAME, k.REFERENCED_TABLE_NAME, c.UPDATE_RULE, c.DELETE_RULE, k.COLUMN_NAME, k.REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE k INNER JOIN information_schema.REFERENTIAL_CONSTRAINTS c ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME AND c.TABLE_NAME = k.TABLE_NAME WHERE k.TABLE_SCHEMA = ? AND c.CONSTRAINT_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL ORDER BY k.TABLE_NAME, k.CONSTRAINT_NAME, k.ORDINAL_POSITION Parameters: [`"dbs9323576" "dbs9323576" "doctrine_migration_versions"`] View formatted query View runnable query Explain query SELECT k.TABLE_NAME, k.CONSTRAINT_NAME, k.REFERENCED_TABLE_NAME, c.UPDATE_RULE, c.DELETE_RULE, k.COLUMN_NAME, k.REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE k INNER JOIN information_schema.REFERENTIAL_CONSTRAINTS c ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME AND c.TABLE_NAME = k.TABLE_NAME WHERE k.TABLE_SCHEMA = ? AND c.CONSTRAINT_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL ORDER BY k.TABLE_NAME, k.CONSTRAINT_NAME, k.ORDINAL_POSITION SELECT k.TABLE_NAME, k.CONSTRAINT_NAME, k.REFERENCED_TABLE_NAME, c.UPDATE_RULE, c.DELETE_RULE, k.COLUMN_NAME, k.REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE k INNER JOIN information_schema.REFERENTIAL_CONSTRAINTS c ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME AND c.TABLE_NAME = k.TABLE_NAME WHERE k.TABLE_SCHEMA = 'dbs9323576' AND c.CONSTRAINT_SCHEMA = 'dbs9323576' AND k.TABLE_NAME = 'doctrine_migration_versions' AND k.REFERENCED_COLUMN_NAME IS NOT NULL ORDER BY k.TABLE_NAME, k.CONSTRAINT_NAME, k.ORDINAL_POSITION;
65	0.32 ms	SELECT * FROM doctrine_migration_versions Parameters: [] View formatted query View runnable query Explain query SELECT * FROM doctrine_migration_versions SELECT * FROM doctrine_migration_versions;
66	0.23 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
67	8.50 ms	SELECT COUNT(w0_.id) AS sclr_0 FROM web_basket w0_ WHERE w0_.userSession = ? Parameters: [`"b7759fc0004100c345e6df93aa8ca3e5"`] View formatted query View runnable query Explain query SELECT COUNT(w0_.id) AS sclr_0 FROM web_basket w0_ WHERE w0_.userSession = ? SELECT COUNT(w0_.id) AS sclr_0 FROM web_basket w0_ WHERE w0_.userSession = 'b7759fc0004100c345e6df93aa8ca3e5';
68	16.32 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.userSession AS userSession_10, t0.quantity AS quantity_11, t0.sqm AS sqm_12, t0.price AS price_13, t0.free_sample AS free_sample_14, t0.user_id AS user_id_15, t0.item_id AS item_id_16, t0.show_item_id AS show_item_id_17, t0.item_detail_id AS item_detail_id_18 FROM web_basket t0 WHERE t0.userSession = ? Parameters: [`"b7759fc0004100c345e6df93aa8ca3e5"`] 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.userSession AS userSession_10, t0.quantity AS quantity_11, t0.sqm AS sqm_12, t0.price AS price_13, t0.free_sample AS free_sample_14, t0.user_id AS user_id_15, t0.item_id AS item_id_16, t0.show_item_id AS show_item_id_17, t0.item_detail_id AS item_detail_id_18 FROM web_basket t0 WHERE t0.userSession = ? 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.userSession AS userSession_10, t0.quantity AS quantity_11, t0.sqm AS sqm_12, t0.price AS price_13, t0.free_sample AS free_sample_14, t0.user_id AS user_id_15, t0.item_id AS item_id_16, t0.show_item_id AS show_item_id_17, t0.item_detail_id AS item_detail_id_18 FROM web_basket t0 WHERE t0.userSession = 'b7759fc0004100c345e6df93aa8ca3e5';
69	0.48 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.facebook AS facebook_10, t0.pinterest AS pinterest_11, t0.twitter AS twitter_12, t0.linkedin AS linkedin_13, t0.instagram AS instagram_14, t0.site_id AS site_id_15 FROM web_social t0 WHERE t0.site_id = ? LIMIT 1 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.facebook AS facebook_10, t0.pinterest AS pinterest_11, t0.twitter AS twitter_12, t0.linkedin AS linkedin_13, t0.instagram AS instagram_14, t0.site_id AS site_id_15 FROM web_social t0 WHERE t0.site_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.facebook AS facebook_10, t0.pinterest AS pinterest_11, t0.twitter AS twitter_12, t0.linkedin AS linkedin_13, t0.instagram AS instagram_14, t0.site_id AS site_id_15 FROM web_social t0 WHERE t0.site_id = 2 LIMIT 1;
70	0.85 ms	SELECT w0_.id AS id_0, w0_.group_status AS group_status_1, w0_.group_name AS group_name_2, w0_.title AS title_3, w0_.title_seo AS title_seo_4 FROM web_category w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id INNER JOIN web_category w2_ ON w0_.category_id = w2_.id WHERE w0_.status = 1 AND w0_.del = 0 AND w1_.id = ? AND w2_.category_id IS NULL ORDER BY w0_.sira ASC Parameters: [`2`] View formatted query View runnable query Explain query SELECT w0_.id AS id_0, w0_.group_status AS group_status_1, w0_.group_name AS group_name_2, w0_.title AS title_3, w0_.title_seo AS title_seo_4 FROM web_category w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id INNER JOIN web_category w2_ ON w0_.category_id = w2_.id WHERE w0_.status = 1 AND w0_.del = 0 AND w1_.id = ? AND w2_.category_id IS NULL ORDER BY w0_.sira ASC SELECT w0_.id AS id_0, w0_.group_status AS group_status_1, w0_.group_name AS group_name_2, w0_.title AS title_3, w0_.title_seo AS title_seo_4 FROM web_category w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id INNER JOIN web_category w2_ ON w0_.category_id = w2_.id WHERE w0_.status = 1 AND w0_.del = 0 AND w1_.id = 2 AND w2_.category_id IS NULL ORDER BY w0_.sira ASC;
71	0.54 ms	SELECT w0_.id AS id_0, w0_.title AS title_1, w0_.group_status AS group_status_2, w0_.group_name AS group_name_3, w0_.title_seo AS title_seo_4 FROM web_category w0_ LEFT JOIN web_category w1_ ON w0_.category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.del = 0 AND w2_.id = ? AND w1_.id = ? ORDER BY w0_.sira ASC Parameters: [`2 46`] View formatted query View runnable query Explain query SELECT w0_.id AS id_0, w0_.title AS title_1, w0_.group_status AS group_status_2, w0_.group_name AS group_name_3, w0_.title_seo AS title_seo_4 FROM web_category w0_ LEFT JOIN web_category w1_ ON w0_.category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.del = 0 AND w2_.id = ? AND w1_.id = ? ORDER BY w0_.sira ASC SELECT w0_.id AS id_0, w0_.title AS title_1, w0_.group_status AS group_status_2, w0_.group_name AS group_name_3, w0_.title_seo AS title_seo_4 FROM web_category w0_ LEFT JOIN web_category w1_ ON w0_.category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.del = 0 AND w2_.id = 2 AND w1_.id = 46 ORDER BY w0_.sira ASC;
72	0.41 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 101`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 101 LIMIT 1;
73	0.36 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 99`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 99 LIMIT 1;
74	0.35 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 104`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 104 LIMIT 1;
75	0.40 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 103`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 103 LIMIT 1;
76	0.40 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 116`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 116 LIMIT 1;
77	0.41 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 111`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 111 LIMIT 1;
78	0.33 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 102`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 102 LIMIT 1;
79	0.37 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 98`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 98 LIMIT 1;
80	0.47 ms	SELECT w0_.id AS id_0, w0_.title AS title_1, w0_.group_status AS group_status_2, w0_.group_name AS group_name_3, w0_.title_seo AS title_seo_4 FROM web_category w0_ LEFT JOIN web_category w1_ ON w0_.category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.del = 0 AND w2_.id = ? AND w1_.id = ? ORDER BY w0_.sira ASC Parameters: [`2 42`] View formatted query View runnable query Explain query SELECT w0_.id AS id_0, w0_.title AS title_1, w0_.group_status AS group_status_2, w0_.group_name AS group_name_3, w0_.title_seo AS title_seo_4 FROM web_category w0_ LEFT JOIN web_category w1_ ON w0_.category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.del = 0 AND w2_.id = ? AND w1_.id = ? ORDER BY w0_.sira ASC SELECT w0_.id AS id_0, w0_.title AS title_1, w0_.group_status AS group_status_2, w0_.group_name AS group_name_3, w0_.title_seo AS title_seo_4 FROM web_category w0_ LEFT JOIN web_category w1_ ON w0_.category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.del = 0 AND w2_.id = 2 AND w1_.id = 42 ORDER BY w0_.sira ASC;
81	0.40 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 115`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 115 LIMIT 1;
82	0.34 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 105`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 105 LIMIT 1;
83	0.33 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 106`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 106 LIMIT 1;
84	0.34 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 214`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 214 LIMIT 1;
85	0.34 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 211`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 211 LIMIT 1;
86	0.38 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 224`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 224 LIMIT 1;
87	0.36 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 114`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 114 LIMIT 1;
88	0.34 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 107`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 107 LIMIT 1;
89	0.52 ms	SELECT w0_.id AS id_0, w0_.title AS title_1, w0_.group_status AS group_status_2, w0_.group_name AS group_name_3, w0_.title_seo AS title_seo_4 FROM web_category w0_ LEFT JOIN web_category w1_ ON w0_.category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.del = 0 AND w2_.id = ? AND w1_.id = ? ORDER BY w0_.sira ASC Parameters: [`2 43`] View formatted query View runnable query Explain query SELECT w0_.id AS id_0, w0_.title AS title_1, w0_.group_status AS group_status_2, w0_.group_name AS group_name_3, w0_.title_seo AS title_seo_4 FROM web_category w0_ LEFT JOIN web_category w1_ ON w0_.category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.del = 0 AND w2_.id = ? AND w1_.id = ? ORDER BY w0_.sira ASC SELECT w0_.id AS id_0, w0_.title AS title_1, w0_.group_status AS group_status_2, w0_.group_name AS group_name_3, w0_.title_seo AS title_seo_4 FROM web_category w0_ LEFT JOIN web_category w1_ ON w0_.category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.del = 0 AND w2_.id = 2 AND w1_.id = 43 ORDER BY w0_.sira ASC;
90	0.38 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 154`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 154 LIMIT 1;
91	0.36 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 152`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 152 LIMIT 1;
92	0.51 ms	SELECT w0_.id AS id_0, w0_.title AS title_1, w0_.group_status AS group_status_2, w0_.group_name AS group_name_3, w0_.title_seo AS title_seo_4 FROM web_category w0_ LEFT JOIN web_category w1_ ON w0_.category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.del = 0 AND w2_.id = ? AND w1_.id = ? ORDER BY w0_.sira ASC Parameters: [`2 158`] View formatted query View runnable query Explain query SELECT w0_.id AS id_0, w0_.title AS title_1, w0_.group_status AS group_status_2, w0_.group_name AS group_name_3, w0_.title_seo AS title_seo_4 FROM web_category w0_ LEFT JOIN web_category w1_ ON w0_.category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.del = 0 AND w2_.id = ? AND w1_.id = ? ORDER BY w0_.sira ASC SELECT w0_.id AS id_0, w0_.title AS title_1, w0_.group_status AS group_status_2, w0_.group_name AS group_name_3, w0_.title_seo AS title_seo_4 FROM web_category w0_ LEFT JOIN web_category w1_ ON w0_.category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.del = 0 AND w2_.id = 2 AND w1_.id = 158 ORDER BY w0_.sira ASC;
93	0.35 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 218`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 218 LIMIT 1;
94	0.38 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 159`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 159 LIMIT 1;
95	0.35 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 160`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 160 LIMIT 1;
96	0.40 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 161`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 161 LIMIT 1;
97	0.36 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 162`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 162 LIMIT 1;
98	0.42 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 225`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 225 LIMIT 1;
99	0.34 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 163`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 163 LIMIT 1;
100	0.35 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 212`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 212 LIMIT 1;
101	0.35 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 221`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 221 LIMIT 1;
102	0.38 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 164`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 164 LIMIT 1;
103	0.35 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 165`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 165 LIMIT 1;
104	0.37 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 166`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 166 LIMIT 1;
105	0.35 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 167`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 167 LIMIT 1;
106	0.37 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 168`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 168 LIMIT 1;
107	0.35 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 169`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 169 LIMIT 1;
108	0.35 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 170`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 170 LIMIT 1;
109	0.35 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 171`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 171 LIMIT 1;
110	0.51 ms	SELECT w0_.id AS id_0, w0_.title AS title_1, w0_.group_status AS group_status_2, w0_.group_name AS group_name_3, w0_.title_seo AS title_seo_4 FROM web_category w0_ LEFT JOIN web_category w1_ ON w0_.category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.del = 0 AND w2_.id = ? AND w1_.id = ? ORDER BY w0_.sira ASC Parameters: [`2 172`] View formatted query View runnable query Explain query SELECT w0_.id AS id_0, w0_.title AS title_1, w0_.group_status AS group_status_2, w0_.group_name AS group_name_3, w0_.title_seo AS title_seo_4 FROM web_category w0_ LEFT JOIN web_category w1_ ON w0_.category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.del = 0 AND w2_.id = ? AND w1_.id = ? ORDER BY w0_.sira ASC SELECT w0_.id AS id_0, w0_.title AS title_1, w0_.group_status AS group_status_2, w0_.group_name AS group_name_3, w0_.title_seo AS title_seo_4 FROM web_category w0_ LEFT JOIN web_category w1_ ON w0_.category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.del = 0 AND w2_.id = 2 AND w1_.id = 172 ORDER BY w0_.sira ASC;
111	0.40 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 219`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 219 LIMIT 1;
112	0.42 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 173`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 173 LIMIT 1;
113	0.39 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 174`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 174 LIMIT 1;
114	0.34 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 175`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 175 LIMIT 1;
115	0.33 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 176`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 176 LIMIT 1;
116	0.38 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 226`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 226 LIMIT 1;
117	0.38 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 177`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 177 LIMIT 1;
118	0.34 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 213`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 213 LIMIT 1;
119	0.36 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 222`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 222 LIMIT 1;
120	0.35 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 178`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 178 LIMIT 1;
121	0.40 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 179`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 179 LIMIT 1;
122	0.36 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 180`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 180 LIMIT 1;
123	0.32 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 181`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 181 LIMIT 1;
124	0.36 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 182`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 182 LIMIT 1;
125	0.34 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 183`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 183 LIMIT 1;
126	0.35 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 184`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 184 LIMIT 1;
127	0.32 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 185`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 185 LIMIT 1;
128	0.53 ms	SELECT w0_.id AS id_0, w0_.title AS title_1, w0_.group_status AS group_status_2, w0_.group_name AS group_name_3, w0_.title_seo AS title_seo_4 FROM web_category w0_ LEFT JOIN web_category w1_ ON w0_.category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.del = 0 AND w2_.id = ? AND w1_.id = ? ORDER BY w0_.sira ASC Parameters: [`2 186`] View formatted query View runnable query Explain query SELECT w0_.id AS id_0, w0_.title AS title_1, w0_.group_status AS group_status_2, w0_.group_name AS group_name_3, w0_.title_seo AS title_seo_4 FROM web_category w0_ LEFT JOIN web_category w1_ ON w0_.category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.del = 0 AND w2_.id = ? AND w1_.id = ? ORDER BY w0_.sira ASC SELECT w0_.id AS id_0, w0_.title AS title_1, w0_.group_status AS group_status_2, w0_.group_name AS group_name_3, w0_.title_seo AS title_seo_4 FROM web_category w0_ LEFT JOIN web_category w1_ ON w0_.category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.del = 0 AND w2_.id = 2 AND w1_.id = 186 ORDER BY w0_.sira ASC;
129	0.41 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 187`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 187 LIMIT 1;
130	0.36 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 188`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 188 LIMIT 1;
131	0.33 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 189`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 189 LIMIT 1;
132	0.36 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 215`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 215 LIMIT 1;
133	0.37 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 190`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 190 LIMIT 1;
134	0.33 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 191`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 191 LIMIT 1;
135	0.31 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 192`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 192 LIMIT 1;
136	0.34 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 193`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 193 LIMIT 1;
137	0.37 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 194`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 194 LIMIT 1;
138	0.33 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 195`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 195 LIMIT 1;
139	0.32 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 196`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 196 LIMIT 1;
140	0.39 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 197`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 197 LIMIT 1;
141	0.51 ms	SELECT w0_.id AS id_0, w0_.title AS title_1, w0_.group_status AS group_status_2, w0_.group_name AS group_name_3, w0_.title_seo AS title_seo_4 FROM web_category w0_ LEFT JOIN web_category w1_ ON w0_.category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.del = 0 AND w2_.id = ? AND w1_.id = ? ORDER BY w0_.sira ASC Parameters: [`2 198`] View formatted query View runnable query Explain query SELECT w0_.id AS id_0, w0_.title AS title_1, w0_.group_status AS group_status_2, w0_.group_name AS group_name_3, w0_.title_seo AS title_seo_4 FROM web_category w0_ LEFT JOIN web_category w1_ ON w0_.category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.del = 0 AND w2_.id = ? AND w1_.id = ? ORDER BY w0_.sira ASC SELECT w0_.id AS id_0, w0_.title AS title_1, w0_.group_status AS group_status_2, w0_.group_name AS group_name_3, w0_.title_seo AS title_seo_4 FROM web_category w0_ LEFT JOIN web_category w1_ ON w0_.category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.del = 0 AND w2_.id = 2 AND w1_.id = 198 ORDER BY w0_.sira ASC;
142	0.40 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 220`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 220 LIMIT 1;
143	0.36 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 199`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 199 LIMIT 1;
144	0.35 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 227`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 227 LIMIT 1;
145	0.33 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 200`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 200 LIMIT 1;
146	0.59 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 216`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 216 LIMIT 1;
147	0.40 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 223`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 223 LIMIT 1;
148	0.52 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 202`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 202 LIMIT 1;
149	0.34 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 201`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 201 LIMIT 1;
150	0.37 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 203`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 203 LIMIT 1;
151	0.35 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 204`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 204 LIMIT 1;
152	0.33 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 205`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 205 LIMIT 1;
153	0.34 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 206`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 206 LIMIT 1;
154	0.32 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 207`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 207 LIMIT 1;
155	0.34 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 217`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 217 LIMIT 1;
156	0.34 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 209`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 209 LIMIT 1;
157	0.47 ms	SELECT w0_.id AS id_0, w0_.title AS title_1, w0_.group_status AS group_status_2, w0_.group_name AS group_name_3, w0_.title_seo AS title_seo_4 FROM web_category w0_ LEFT JOIN web_category w1_ ON w0_.category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.del = 0 AND w2_.id = ? AND w1_.id = ? ORDER BY w0_.sira ASC Parameters: [`2 49`] View formatted query View runnable query Explain query SELECT w0_.id AS id_0, w0_.title AS title_1, w0_.group_status AS group_status_2, w0_.group_name AS group_name_3, w0_.title_seo AS title_seo_4 FROM web_category w0_ LEFT JOIN web_category w1_ ON w0_.category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.del = 0 AND w2_.id = ? AND w1_.id = ? ORDER BY w0_.sira ASC SELECT w0_.id AS id_0, w0_.title AS title_1, w0_.group_status AS group_status_2, w0_.group_name AS group_name_3, w0_.title_seo AS title_seo_4 FROM web_category w0_ LEFT JOIN web_category w1_ ON w0_.category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.del = 0 AND w2_.id = 2 AND w1_.id = 49 ORDER BY w0_.sira ASC;
158	0.36 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 117`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 117 LIMIT 1;
159	0.37 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 120`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 120 LIMIT 1;
160	0.42 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 118`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 118 LIMIT 1;
161	0.55 ms	SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 Parameters: [`2 119`] View formatted query View runnable query Explain query SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1 SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = 2 AND w1_.id = 119 LIMIT 1;
162	0.54 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.description AS description_12, t0.type AS type_13, t0.upper_link AS upper_link_14, t0.meta_title AS meta_title_15, t0.meta_description AS meta_description_16, t0.site_id AS site_id_17 FROM web_page t0 WHERE t0.site_id = ? AND t0.del = ? AND t0.upper_link = ? Parameters: [`2 0 "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.title AS title_10, t0.titleSeo AS titleSeo_11, t0.description AS description_12, t0.type AS type_13, t0.upper_link AS upper_link_14, t0.meta_title AS meta_title_15, t0.meta_description AS meta_description_16, t0.site_id AS site_id_17 FROM web_page t0 WHERE t0.site_id = ? AND t0.del = ? AND t0.upper_link = ? 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.description AS description_12, t0.type AS type_13, t0.upper_link AS upper_link_14, t0.meta_title AS meta_title_15, t0.meta_description AS meta_description_16, t0.site_id AS site_id_17 FROM web_page t0 WHERE t0.site_id = 2 AND t0.del = 0 AND t0.upper_link = '1';
163	0.59 ms	SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.company_description AS company_description_3, t0.company_email AS company_email_4, t0.company_phone AS company_phone_5, t0.company_fax AS company_fax_6, t0.company_address AS company_address_7, t0.company_address_html AS company_address_html_8, t0.company_logo AS company_logo_9, t0.copyright AS copyright_10, t0.auto_allocate AS auto_allocate_11, t0.cronjob_auto_allocate AS cronjob_auto_allocate_12, t0.cronjob_credit_hold AS cronjob_credit_hold_13, t0.exchange_rate_api AS exchange_rate_api_14, t0.coming_soon AS coming_soon_15, t0.coming_soon_date AS coming_soon_date_16, t0.maintenance_mode AS maintenance_mode_17, t0.custom_transaction AS custom_transaction_18, t0.transaction_entries AS transaction_entries_19, t0.api AS api_20, t0.login_captcha_key AS login_captcha_key_21, t0.login_captcha_id AS login_captcha_id_22, t0.dev_mod AS dev_mod_23, t0.developer_email AS developer_email_24, t0.ftp_username AS ftp_username_25, t0.ftp_hostname AS ftp_hostname_26, t0.ftp_password AS ftp_password_27, t0.ftp_port AS ftp_port_28 FROM system_settings t0 WHERE t0.id = ? Parameters: [`0`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.company_description AS company_description_3, t0.company_email AS company_email_4, t0.company_phone AS company_phone_5, t0.company_fax AS company_fax_6, t0.company_address AS company_address_7, t0.company_address_html AS company_address_html_8, t0.company_logo AS company_logo_9, t0.copyright AS copyright_10, t0.auto_allocate AS auto_allocate_11, t0.cronjob_auto_allocate AS cronjob_auto_allocate_12, t0.cronjob_credit_hold AS cronjob_credit_hold_13, t0.exchange_rate_api AS exchange_rate_api_14, t0.coming_soon AS coming_soon_15, t0.coming_soon_date AS coming_soon_date_16, t0.maintenance_mode AS maintenance_mode_17, t0.custom_transaction AS custom_transaction_18, t0.transaction_entries AS transaction_entries_19, t0.api AS api_20, t0.login_captcha_key AS login_captcha_key_21, t0.login_captcha_id AS login_captcha_id_22, t0.dev_mod AS dev_mod_23, t0.developer_email AS developer_email_24, t0.ftp_username AS ftp_username_25, t0.ftp_hostname AS ftp_hostname_26, t0.ftp_password AS ftp_password_27, t0.ftp_port AS ftp_port_28 FROM system_settings t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.company_description AS company_description_3, t0.company_email AS company_email_4, t0.company_phone AS company_phone_5, t0.company_fax AS company_fax_6, t0.company_address AS company_address_7, t0.company_address_html AS company_address_html_8, t0.company_logo AS company_logo_9, t0.copyright AS copyright_10, t0.auto_allocate AS auto_allocate_11, t0.cronjob_auto_allocate AS cronjob_auto_allocate_12, t0.cronjob_credit_hold AS cronjob_credit_hold_13, t0.exchange_rate_api AS exchange_rate_api_14, t0.coming_soon AS coming_soon_15, t0.coming_soon_date AS coming_soon_date_16, t0.maintenance_mode AS maintenance_mode_17, t0.custom_transaction AS custom_transaction_18, t0.transaction_entries AS transaction_entries_19, t0.api AS api_20, t0.login_captcha_key AS login_captcha_key_21, t0.login_captcha_id AS login_captcha_id_22, t0.dev_mod AS dev_mod_23, t0.developer_email AS developer_email_24, t0.ftp_username AS ftp_username_25, t0.ftp_hostname AS ftp_hostname_26, t0.ftp_password AS ftp_password_27, t0.ftp_port AS ftp_port_28 FROM system_settings t0 WHERE t0.id = 0;
164	2.63 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.photo AS photo_10, t0.photo_title AS photo_title_11, t0.photo_sub_title AS photo_sub_title_12, t0.web_item_id AS web_item_id_13, t0.web_item_detail_id AS web_item_detail_id_14 FROM web_item_photo t0 WHERE t0.web_item_detail_id = ? ORDER BY t0.sira ASC Parameters: [`870`] 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.photo AS photo_10, t0.photo_title AS photo_title_11, t0.photo_sub_title AS photo_sub_title_12, t0.web_item_id AS web_item_id_13, t0.web_item_detail_id AS web_item_detail_id_14 FROM web_item_photo t0 WHERE t0.web_item_detail_id = ? ORDER BY t0.sira 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.photo AS photo_10, t0.photo_title AS photo_title_11, t0.photo_sub_title AS photo_sub_title_12, t0.web_item_id AS web_item_id_13, t0.web_item_detail_id AS web_item_detail_id_14 FROM web_item_photo t0 WHERE t0.web_item_detail_id = 870 ORDER BY t0.sira ASC;
165	2.83 ms	SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1 Parameters: [`485 2`] View formatted query View runnable query Explain query SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1 SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = 485 AND w1_.id = 2 AND w0_.status = 1;
166	2.56 ms	SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1 Parameters: [`724 2`] View formatted query View runnable query Explain query SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1 SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = 724 AND w1_.id = 2 AND w0_.status = 1;
167	2.50 ms	SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1 Parameters: [`512 2`] View formatted query View runnable query Explain query SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1 SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = 512 AND w1_.id = 2 AND w0_.status = 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	12
App\Entity\Item	12
App\Entity\WebItemInfo	8
App\Entity\WebItemInfoOption	8
App\Entity\WebItemCareDelivery	8
App\Entity\WebCategory	3
App\Entity\WebItemReview	2
App\Entity\WebSite	1
App\Entity\WebItem	1
App\Entity\Settings	1
App\Entity\WebSocial	1
App\Entity\SystemSettings	1
App\Entity\WebItemPhoto	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.
App\Entity\CustomerReceipt	No errors.
App\Entity\CustomerShipToList	No errors.
App\Entity\WebPalletZone	The association App\Entity\WebPalletZone#accountCode refers to the inverse side field App\Entity\AccountCode#webPalletZone which does not exist.
App\Entity\CustomerOrderItem	No errors.
App\Entity\CustomerOrderAddress	No errors.
App\Entity\CustomerOrderDelivery	No errors.
App\Entity\CustomerOrderImages	No errors.
App\Entity\StockTransferItem	No errors.
App\Entity\PurchaseOrder	No errors.
App\Entity\User	The association App\Entity\User#warehouse refers to the inverse side field App\Entity\Warehouse#user which does not exist. The association App\Entity\User#logs refers to the owning side field App\Entity\Log#user which is not defined as association, but as field. The association App\Entity\User#logs refers to the owning side field App\Entity\Log#user which does not exist.
App\Entity\StockTransfer	No errors.
App\Entity\PaymentTerm	No errors.
App\Entity\ShippingMethod	No errors.
App\Entity\OrderStage	The association App\Entity\OrderStage#customerInvoice refers to the owning side field App\Entity\CustomerInvoice#orderStage which does not exist.
App\Entity\Warehouse	The association App\Entity\Warehouse#stockAdjustment refers to the owning side field App\Entity\StockAdjustment#warehouse which does not exist.
App\Entity\MultiCurrency	The mappings App\Entity\MultiCurrency#suppliers and App\Entity\Supplier#multiCurrency are inconsistent with each other.
App\Entity\PostCode	No errors.
App\Entity\CustomerProformaItem	No errors.
App\Entity\CustomerProformaAddress	No errors.
App\Entity\CustomerProformaDelivery	No errors.
App\Entity\CustomerInvoiceItem	No errors.
App\Entity\CustomerInvoiceAddress	No errors.
App\Entity\CustomerInvoiceDelivery	No errors.
App\Entity\CustomerAllocate	No errors.
App\Entity\Journal	No errors.
App\Entity\CustomerRma	No errors.
App\Entity\CustomerCreditMemo	No errors.
App\Entity\PurchaseInvoice	No errors.
App\Entity\WebOrderQuestionAnswers	No errors.
App\Entity\EmailSended	No errors.
App\Entity\CustomerAuthorizedPerson	No errors.
App\Entity\CustomerNotes	The association App\Entity\CustomerNotes#contact refers to the inverse side field App\Entity\CustomerContact#notes which does not exist.
App\Entity\CustomerExNotes	No errors.
App\Entity\SpecialPricing	No errors.
App\Entity\CustomerRefund	The association App\Entity\CustomerRefund#pettyCashAccount refers to the inverse side field App\Entity\PettyCashAccount#customerRefund which does not exist.
App\Entity\CustomerAllocation	No errors.
App\Entity\CustomerMerchandising	No errors.
App\Entity\ApiUser	No errors.
App\Entity\CustomerType	No errors.
App\Entity\Country	No errors.
App\Entity\SalesRepresentative	No errors.
App\Entity\TaxDescription	The association App\Entity\TaxDescription#pettyCashPaymentExpenses refers to the owning side field App\Entity\PettyCashPaymentExpenses#tax which is not defined as association, but as field. The association App\Entity\TaxDescription#pettyCashPaymentExpenses refers to the owning side field App\Entity\PettyCashPaymentExpenses#tax which does not exist. The association App\Entity\TaxDescription#pettyCashReceiptExpenses refers to the owning side field App\Entity\PettyCashReceiptExpenses#tax which is not defined as association, but as field. The association App\Entity\TaxDescription#pettyCashReceiptExpenses refers to the owning side field App\Entity\PettyCashReceiptExpenses#tax which does not exist.
App\Entity\AccountCode	The mappings App\Entity\AccountCode#pettyCashReceiptExpenses and App\Entity\PettyCashPaymentExpenses#accountCode are inconsistent with each other.
App\Entity\JobTitle	No errors.
App\Entity\ItemSupplier	No errors.
App\Entity\PurchaseOrderRequisitionItem	No errors.
App\Entity\PurchaseOrderItem	No errors.
App\Entity\GoodsReceivedItem	No errors.
App\Entity\ReturnToSupplierItem	No errors.
App\Entity\CustomerRmaItem	No errors.
App\Entity\CustomerCreditMemoItem	No errors.
App\Entity\GroupItem	No errors.
App\Entity\StockAdjustmentItem	No errors.
App\Entity\PurchaseInvoiceItem	No errors.
App\Entity\DebitMemoItem	No errors.
App\Entity\ItemCosts	No errors.
App\Entity\CorporateItem	No errors.
App\Entity\CorporateItemDetail	No errors.
App\Entity\CostingMethod	No errors.
App\Entity\ServiceLevel	No errors.
App\Entity\SystemSettings	No errors.
App\Entity\BankAccount	No errors.
App\Entity\PettyCashAccount	No errors.
App\Entity\PaymentType	No errors.
App\Entity\BankReconciliation	No errors.
App\Entity\DepositReceipts	The association App\Entity\DepositReceipts#bankAccount refers to the inverse side field App\Entity\BankAccount#depositReceipts which does not exist. The association App\Entity\DepositReceipts#multiCurrency refers to the inverse side field App\Entity\MultiCurrency#depositReceipts which does not exist.
App\Entity\PurchaseOrderRequisition	No errors.
App\Entity\GoodsReceived	No errors.
App\Entity\Supplier	The association App\Entity\Supplier#multiCurrency refers to the inverse side field App\Entity\MultiCurrency#supplier which does not exist.
App\Entity\SupplierContact	The association App\Entity\SupplierContact#country refers to the inverse side field App\Entity\Country#supplierDefaultContact which does not exist.
App\Entity\LogKayitlari	No errors.
App\Entity\UserRole	No errors.
App\Entity\Log	No errors.
App\Entity\ReturnToSupplier	No errors.
App\Entity\DebitMemo	No errors.
App\Entity\SupplierPayment	No errors.
App\Entity\SupplierRefund	No errors.
App\Entity\ShippingMethodType	No errors.
App\Entity\WarehouseAuthorizedPerson	No errors.
App\Entity\CustomerRmaDelivery	No errors.
App\Entity\CustomerCreditMemoDelivery	No errors.
App\Entity\StockAdjustment	No errors.
App\Entity\StockTake	No errors.
App\Entity\OpeningBalanceCustomer	The association App\Entity\OpeningBalanceCustomer#customer refers to the inverse side field App\Entity\Customer#openingBalance which does not exist.
App\Entity\OpeningBalanceSupplier	No errors.
App\Entity\OpeningBalanceBank	No errors.
App\Entity\JournalItems	No errors.
App\Entity\BankPayment	No errors.
App\Entity\BankReceipt	No errors.
App\Entity\PettyCashPayment	No errors.
App\Entity\PettyCashReceipt	No errors.
App\Entity\TransferFund	No errors.
App\Entity\ZonePallet	No errors.
App\Entity\JournalType	No errors.
App\Entity\OpeningBalanceStocks	The association App\Entity\OpeningBalanceStocks#multiCurrency refers to the inverse side field App\Entity\MultiCurrency#openingBalanceStocks which does not exist.
App\Entity\CustomerRmaAddress	No errors.
App\Entity\CustomerCreditMemoAddress	No errors.
App\Entity\Allocate	No errors.
App\Entity\PurchaseInvoiceExpenses	No errors.
App\Entity\PurchaseInvoiceAddress	No errors.
App\Entity\WebOrderQuestions	No errors.
App\Entity\EmailSendedAttachments	No errors.
App\Entity\Merchandising	No errors.
App\Entity\SubCrm	The association App\Entity\SubCrm#webSite refers to the inverse side field App\Entity\WebSite#subCrm which does not exist.
App\Entity\ApiUserRole	No errors.
App\Entity\Shipping	No errors.
App\Entity\Bank	No errors.
App\Entity\DebitMemoExpenses	No errors.
App\Entity\PettyCashPaymentExpenses	The mappings App\Entity\PettyCashPaymentExpenses#taxCode and App\Entity\TaxDescription#pettyCashPaymentExpenses are inconsistent with each other.
App\Entity\PettyCashReceiptExpenses	The mappings App\Entity\PettyCashReceiptExpenses#taxCode and App\Entity\TaxDescription#pettyCashReceiptExpenses are inconsistent with each other.
App\Entity\BankPaymentExpenses	The association App\Entity\BankPaymentExpenses#taxCode refers to the inverse side field App\Entity\TaxDescription#bankPaymentExpenses which does not exist.
App\Entity\BankReceiptExpenses	The association App\Entity\BankReceiptExpenses#taxCode refers to the inverse side field App\Entity\TaxDescription#bankReceiptExpenses which does not exist.
App\Entity\AccountGroup	No errors.
App\Entity\AccountSubGroup	No errors.
App\Entity\AccountType	No errors.
App\Entity\CorporateItemPhoto	No errors.
App\Entity\CorporateLanguage	No errors.
App\Entity\CorporateCategory	The association App\Entity\CorporateCategory#corporateItems refers to the owning side field App\Entity\CorporateItem#categories which does not exist.
App\Entity\CorporateItemInfo	No errors.
App\Entity\CorporateItemTechnical	No errors.
App\Entity\CorporateItemSize	No errors.
App\Entity\EmailSettings	No errors.
App\Entity\Allocation	No errors.
App\Entity\SupplierNotes	No errors.
App\Entity\LogIslemleri	No errors.
App\Entity\RoutePermissions	The association App\Entity\RoutePermissions#route refers to the inverse side field App\Entity\Routes#role which does not exist.
App\Entity\Routes	The mappings App\Entity\Routes#permissions and App\Entity\RoutePermissions#route are inconsistent with each other.
App\Entity\StockTakeItem	No errors.
App\Entity\CorporateItemInfoOption	No errors.
App\Entity\CorporateCategoryBanner	The association App\Entity\CorporateCategoryBanner#category refers to the inverse side field App\Entity\Category#corporateCategoryBanners which does not exist.
App\Entity\IonicCrmCollections	No errors.
App\Entity\IonicCrmTeam	No errors.
App\Entity\IonicCrmTeamPage	No errors.
App\Entity\IonicCrmMenu	No errors.
App\Entity\IonicCrmCollectionBanner	No errors.
App\Entity\IonicCrmBanner	No errors.
App\Entity\IonicCrmStories	No errors.
App\Entity\IonicCrmTags	No errors.
App\Entity\IonicCrmPages	No errors.
App\Entity\IonicCrmFooter	No errors.
App\Entity\CorporateSize	No errors.
App\Entity\EmailAttachments	No errors.
App\Entity\RouteGroups	No errors.
App\Entity\IonicCrmCollectionImages	No errors.
App\Entity\IonicCrmStoryImages	No errors.
App\Entity\IonicCrmPageImages	No errors.

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Queries

default connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping