1
0.57 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . price AS price_3 , t0 . image AS image_4 , t0 . qty AS qty_5 , t0 . sku AS sku_6 , t0 . description AS description_7 , t0 . created_at AS created_at_8 , t0 . updated_at AS updated_at_9 , t0 . rating AS rating_10 , t0 . weight AS weight_11 , t0 . status AS status_12 , t0 . promotion AS promotion_13 , t0 . promotion_price AS promotion_price_14 , t0 . promotion_start_date AS promotion_start_date_15 , t0 . promotion_end_date AS promotion_end_date_16 , t0 . to_be_exposed AS to_be_exposed_17 , t0 . has_variants AS has_variants_18 , t0 . category_id AS category_id_19 , t0 . user_id AS user_id_20 , t0 . taxt_id AS taxt_id_21 FROM product t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . price AS price_3 , t0 . image AS image_4 , t0 . qty AS qty_5 , t0 . sku AS sku_6 , t0 . description AS description_7 , t0 . created_at AS created_at_8 , t0 . updated_at AS updated_at_9 , t0 . rating AS rating_10 , t0 . weight AS weight_11 , t0 . status AS status_12 , t0 . promotion AS promotion_13 , t0 . promotion_price AS promotion_price_14 , t0 . promotion_start_date AS promotion_start_date_15 , t0 . promotion_end_date AS promotion_end_date_16 , t0 . to_be_exposed AS to_be_exposed_17 , t0 . has_variants AS has_variants_18 , t0 . category_id AS category_id_19 , t0 . user_id AS user_id_20 , t0 . taxt_id AS taxt_id_21 FROM product t0 WHERE t0 . id = 27 ;
Copy
2
0.18 ms
SELECT r0_ . rating AS rating_0 , COUNT (r0_ . id ) AS sclr_1 FROM product p1_ INNER JOIN review r0_ ON p1_ . id = r0_ . product_id WHERE p1_ . id = ? GROUP BY r0_ . rating ORDER BY r0_ . rating DESC
SELECT r0_ . rating AS rating_0 , COUNT (r0_ . id ) AS sclr_1 FROM product p1_ INNER JOIN review r0_ ON p1_ . id = r0_ . product_id WHERE p1_ . id = 27 GROUP BY r0_ . rating ORDER BY r0_ . rating DESC ;
Copy
3
0.21 ms
SELECT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . price AS price_2 , p0_ . image AS image_3 , p0_ . qty AS qty_4 , p0_ . sku AS sku_5 , p0_ . description AS description_6 , p0_ . created_at AS created_at_7 , p0_ . updated_at AS updated_at_8 , p0_ . rating AS rating_9 , p0_ . weight AS weight_10 , p0_ . status AS status_11 , p0_ . promotion AS promotion_12 , p0_ . promotion_price AS promotion_price_13 , p0_ . promotion_start_date AS promotion_start_date_14 , p0_ . promotion_end_date AS promotion_end_date_15 , p0_ . to_be_exposed AS to_be_exposed_16 , p0_ . has_variants AS has_variants_17 , p0_ . category_id AS category_id_18 , p0_ . user_id AS user_id_19 , p0_ . taxt_id AS taxt_id_20 FROM product p0_ INNER JOIN category c1_ ON p0_ . category_id = c1_ . id WHERE c1_ . id = ?
SELECT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . price AS price_2 , p0_ . image AS image_3 , p0_ . qty AS qty_4 , p0_ . sku AS sku_5 , p0_ . description AS description_6 , p0_ . created_at AS created_at_7 , p0_ . updated_at AS updated_at_8 , p0_ . rating AS rating_9 , p0_ . weight AS weight_10 , p0_ . status AS status_11 , p0_ . promotion AS promotion_12 , p0_ . promotion_price AS promotion_price_13 , p0_ . promotion_start_date AS promotion_start_date_14 , p0_ . promotion_end_date AS promotion_end_date_15 , p0_ . to_be_exposed AS to_be_exposed_16 , p0_ . has_variants AS has_variants_17 , p0_ . category_id AS category_id_18 , p0_ . user_id AS user_id_19 , p0_ . taxt_id AS taxt_id_20 FROM product p0_ INNER JOIN category c1_ ON p0_ . category_id = c1_ . id WHERE c1_ . id = 7 ;
Copy
4
0.13 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . image AS image_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . user_id AS user_id_6 , t0 . parent_id AS parent_id_7 , t0 . category_id AS category_id_8 FROM category t0
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . image AS image_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . user_id AS user_id_6 , t0 . parent_id AS parent_id_7 , t0 . category_id AS category_id_8 FROM category t0 ;
Copy
5
0.12 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . content AS content_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . is_active AS is_active_6 , t0 . slug AS slug_7 FROM policy t0
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . content AS content_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . is_active AS is_active_6 , t0 . slug AS slug_7 FROM policy t0 ;
Copy
6
0.11 ms
SELECT t0 . id AS id_1 , t0 . filename AS filename_2 , t0 . is_main AS is_main_3 , t0 . product_id AS product_id_4 FROM image t0 WHERE t0 . product_id = ?
SELECT t0 . id AS id_1 , t0 . filename AS filename_2 , t0 . is_main AS is_main_3 , t0 . product_id AS product_id_4 FROM image t0 WHERE t0 . product_id = 27 ;
Copy
7
0.10 ms
SELECT t0 . id AS id_1 , t0 . text AS text_2 , t0 . rating AS rating_3 , t0 . created_at AS created_at_4 , t0 . product_id AS product_id_5 , t0 . user_id AS user_id_6 FROM review t0 WHERE t0 . product_id = ?
SELECT t0 . id AS id_1 , t0 . text AS text_2 , t0 . rating AS rating_3 , t0 . created_at AS created_at_4 , t0 . product_id AS product_id_5 , t0 . user_id AS user_id_6 FROM review t0 WHERE t0 . product_id = 27 ;
Copy
8
0.15 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . product_id AS product_id_3 FROM product_option t0 WHERE t0 . product_id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . product_id AS product_id_3 FROM product_option t0 WHERE t0 . product_id = 27 ;
Copy
9
0.10 ms
SELECT t0 . id AS id_1 , t0 . value AS value_2 , t0 . product_option_id AS product_option_id_3 FROM product_option_value t0 WHERE t0 . product_option_id = ?
SELECT t0 . id AS id_1 , t0 . value AS value_2 , t0 . product_option_id AS product_option_id_3 FROM product_option_value t0 WHERE t0 . product_option_id = 15 ;
Copy
10
0.09 ms
SELECT t0 . id AS id_1 , t0 . value AS value_2 , t0 . product_option_id AS product_option_id_3 FROM product_option_value t0 WHERE t0 . product_option_id = ?
SELECT t0 . id AS id_1 , t0 . value AS value_2 , t0 . product_option_id AS product_option_id_3 FROM product_option_value t0 WHERE t0 . product_option_id = 16 ;
Copy