2.24 ms (16.81%)
|
3 |
SELECT t0.id AS id_1, t0.image AS image_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.variant_id AS variant_id_5 FROM product_variant_image t0 WHERE t0.variant_id = ?
SELECT t0.id AS id_1, t0.image AS image_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.variant_id AS variant_id_5 FROM product_variant_image t0 WHERE t0.variant_id = 1;
|
1.98 ms (14.90%)
|
1 |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.product_id AS product_id_4, t0.attribute_value_id AS attribute_value_id_5 FROM product_attribute t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.product_id AS product_id_4, t0.attribute_value_id AS attribute_value_id_5 FROM product_attribute t0 WHERE t0.product_id = 1;
|
1.91 ms (14.37%)
|
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.video AS video_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.supplier_id AS supplier_id_8, t0.sub_category_id AS sub_category_id_9 FROM product t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.video AS video_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.supplier_id AS supplier_id_8, t0.sub_category_id AS sub_category_id_9 FROM product t0 WHERE t0.id = 1;
|
1.42 ms (10.65%)
|
1 |
SELECT t0.id AS id_1, t0.label AS label_2, t0.size AS size_3, t0.color AS color_4, t0.stock_quantity AS stock_quantity_5, t0.image_base AS image_base_6, t0.is_main AS is_main_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.product_id AS product_id_10 FROM product_variant t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.label AS label_2, t0.size AS size_3, t0.color AS color_4, t0.stock_quantity AS stock_quantity_5, t0.image_base AS image_base_6, t0.is_main AS is_main_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.product_id AS product_id_10 FROM product_variant t0 WHERE t0.product_id = 1;
|
1.20 ms (8.98%)
|
1 |
SELECT AVG(r0_.rating) AS sclr_0, COUNT(r0_.id) AS sclr_1 FROM review r0_ WHERE r0_.product_id = ?
SELECT AVG(r0_.rating) AS sclr_0, COUNT(r0_.id) AS sclr_1 FROM review r0_ WHERE r0_.product_id = 1;
|
1.14 ms (8.52%)
|
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM category t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM category t0 WHERE t0.id = 1;
|
0.78 ms (5.86%)
|
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.phone AS phone_3, t0.description AS description_4, t0.address AS address_5, t0.country AS country_6, t0.site_url AS site_url_7, t0.image AS image_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.user_id AS user_id_11 FROM supplier t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.phone AS phone_3, t0.description AS description_4, t0.address AS address_5, t0.country AS country_6, t0.site_url AS site_url_7, t0.image AS image_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.user_id AS user_id_11 FROM supplier t0 WHERE t0.id = 1;
|
0.73 ms (5.47%)
|
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.category_id AS category_id_7 FROM sub_category t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.category_id AS category_id_7 FROM sub_category t0 WHERE t0.id = 1;
|
0.72 ms (5.42%)
|
1 |
SELECT t0.id AS id_1, t0.rating AS rating_2, t0.comment AS comment_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.product_id AS product_id_6, t0.user_id AS user_id_7 FROM review t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.rating AS rating_2, t0.comment AS comment_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.product_id AS product_id_6, t0.user_id AS user_id_7 FROM review t0 WHERE t0.product_id = 1;
|
0.68 ms (5.08%)
|
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.discout_percentage AS discout_percentage_4, t0.start_at AS start_at_5, t0.end_at AS end_at_6, t0.image AS image_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.product_id AS product_id_10 FROM special_offer t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.discout_percentage AS discout_percentage_4, t0.start_at AS start_at_5, t0.end_at AS end_at_6, t0.image AS image_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.product_id AS product_id_10 FROM special_offer t0 WHERE t0.product_id = 1;
|
0.52 ms (3.92%)
|
1 |
SELECT t0.id AS id_1, t0.min_quantity AS min_quantity_2, t0.max_quantity AS max_quantity_3, t0.price AS price_4, t0.transit_price AS transit_price_5, t0.customs_price AS customs_price_6, t0.transaction_fees AS transaction_fees_7, t0.delivery_fees AS delivery_fees_8, t0.additional_fees AS additional_fees_9, t0.customs_tier AS customs_tier_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.product_id AS product_id_13 FROM product_price_tier t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.min_quantity AS min_quantity_2, t0.max_quantity AS max_quantity_3, t0.price AS price_4, t0.transit_price AS transit_price_5, t0.customs_price AS customs_price_6, t0.transaction_fees AS transaction_fees_7, t0.delivery_fees AS delivery_fees_8, t0.additional_fees AS additional_fees_9, t0.customs_tier AS customs_tier_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.product_id AS product_id_13 FROM product_price_tier t0 WHERE t0.product_id = 1;
|