1
1.73 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . slug AS slug_3 , t0 . image AS image_4 , t0 . description AS description_5 FROM category t0
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . slug AS slug_3 , t0 . image AS image_4 , t0 . description AS description_5 FROM category t0 ;
Copy
2
0.58 ms
SELECT count (DISTINCT p0_ . id ) AS sclr_0 FROM product p0_ WHERE p0_ . is_active = 1
SELECT count (DISTINCT p0_ . id ) AS sclr_0 FROM product p0_ WHERE p0_ . is_active = 1 ;
Copy
3
0.39 ms
SELECT DISTINCT p0_ . id AS id_0 , p0_ . name AS name_1 FROM product p0_ WHERE p0_ . is_active = 1 ORDER BY p0_ . name ASC LIMIT 12
SELECT DISTINCT p0_ . id AS id_0 , p0_ . name AS name_1 FROM product p0_ WHERE p0_ . is_active = 1 ORDER BY p0_ . name ASC LIMIT 12 ;
Copy
4
0.64 ms
SELECT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . description AS description_2 , p0_ . price AS price_3 , p0_ . is_active AS is_active_4 , p0_ . slug AS slug_5 , p0_ . created_at AS created_at_6 , p0_ . stock AS stock_7 , p0_ . updated_at AS updated_at_8 , p0_ . features AS features_9 , p0_ . sku AS sku_10 , p0_ . sku_distributor AS sku_distributor_11 , p0_ . ean13 AS ean13_12 , p0_ . price_distributor AS price_distributor_13 , p0_ . tva AS tva_14 , p0_ . tva_distributor AS tva_distributor_15 , p0_ . weight AS weight_16 , p0_ . category_id AS category_id_17 , p0_ . brand_id AS brand_id_18 FROM product p0_ WHERE p0_ . is_active = 1 AND p0_ . id IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) ORDER BY p0_ . name ASC
Parameters :
[
8
29
34
35
28
36
31
6
30
33
32
2
]
SELECT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . description AS description_2 , p0_ . price AS price_3 , p0_ . is_active AS is_active_4 , p0_ . slug AS slug_5 , p0_ . created_at AS created_at_6 , p0_ . stock AS stock_7 , p0_ . updated_at AS updated_at_8 , p0_ . features AS features_9 , p0_ . sku AS sku_10 , p0_ . sku_distributor AS sku_distributor_11 , p0_ . ean13 AS ean13_12 , p0_ . price_distributor AS price_distributor_13 , p0_ . tva AS tva_14 , p0_ . tva_distributor AS tva_distributor_15 , p0_ . weight AS weight_16 , p0_ . category_id AS category_id_17 , p0_ . brand_id AS brand_id_18 FROM product p0_ WHERE p0_ . is_active = 1 AND p0_ . id IN (8 , 29 , 34 , 35 , 28 , 36 , 31 , 6 , 30 , 33 , 32 , 2 ) ORDER BY p0_ . name ASC ;
Copy
5
0.56 ms
SELECT t0 . id AS id_1 , t0 . path AS path_2 , t0 . thumbnail AS thumbnail_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . sort_order AS sort_order_6 , t0 . product_id AS product_id_7 FROM product_image t0 WHERE t0 . product_id = ? ORDER BY t0 . sort_order ASC
SELECT t0 . id AS id_1 , t0 . path AS path_2 , t0 . thumbnail AS thumbnail_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . sort_order AS sort_order_6 , t0 . product_id AS product_id_7 FROM product_image t0 WHERE t0 . product_id = 8 ORDER BY t0 . sort_order ASC ;
Copy
6
0.33 ms
SELECT t0 . id AS id_1 , t0 . path AS path_2 , t0 . thumbnail AS thumbnail_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . sort_order AS sort_order_6 , t0 . product_id AS product_id_7 FROM product_image t0 WHERE t0 . product_id = ? ORDER BY t0 . sort_order ASC
SELECT t0 . id AS id_1 , t0 . path AS path_2 , t0 . thumbnail AS thumbnail_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . sort_order AS sort_order_6 , t0 . product_id AS product_id_7 FROM product_image t0 WHERE t0 . product_id = 29 ORDER BY t0 . sort_order ASC ;
Copy
7
0.27 ms
SELECT t0 . id AS id_1 , t0 . path AS path_2 , t0 . thumbnail AS thumbnail_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . sort_order AS sort_order_6 , t0 . product_id AS product_id_7 FROM product_image t0 WHERE t0 . product_id = ? ORDER BY t0 . sort_order ASC
SELECT t0 . id AS id_1 , t0 . path AS path_2 , t0 . thumbnail AS thumbnail_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . sort_order AS sort_order_6 , t0 . product_id AS product_id_7 FROM product_image t0 WHERE t0 . product_id = 34 ORDER BY t0 . sort_order ASC ;
Copy
8
0.27 ms
SELECT t0 . id AS id_1 , t0 . path AS path_2 , t0 . thumbnail AS thumbnail_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . sort_order AS sort_order_6 , t0 . product_id AS product_id_7 FROM product_image t0 WHERE t0 . product_id = ? ORDER BY t0 . sort_order ASC
SELECT t0 . id AS id_1 , t0 . path AS path_2 , t0 . thumbnail AS thumbnail_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . sort_order AS sort_order_6 , t0 . product_id AS product_id_7 FROM product_image t0 WHERE t0 . product_id = 35 ORDER BY t0 . sort_order ASC ;
Copy
9
0.26 ms
SELECT t0 . id AS id_1 , t0 . path AS path_2 , t0 . thumbnail AS thumbnail_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . sort_order AS sort_order_6 , t0 . product_id AS product_id_7 FROM product_image t0 WHERE t0 . product_id = ? ORDER BY t0 . sort_order ASC
SELECT t0 . id AS id_1 , t0 . path AS path_2 , t0 . thumbnail AS thumbnail_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . sort_order AS sort_order_6 , t0 . product_id AS product_id_7 FROM product_image t0 WHERE t0 . product_id = 28 ORDER BY t0 . sort_order ASC ;
Copy
10
0.29 ms
SELECT t0 . id AS id_1 , t0 . path AS path_2 , t0 . thumbnail AS thumbnail_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . sort_order AS sort_order_6 , t0 . product_id AS product_id_7 FROM product_image t0 WHERE t0 . product_id = ? ORDER BY t0 . sort_order ASC
SELECT t0 . id AS id_1 , t0 . path AS path_2 , t0 . thumbnail AS thumbnail_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . sort_order AS sort_order_6 , t0 . product_id AS product_id_7 FROM product_image t0 WHERE t0 . product_id = 36 ORDER BY t0 . sort_order ASC ;
Copy
11
0.28 ms
SELECT t0 . id AS id_1 , t0 . path AS path_2 , t0 . thumbnail AS thumbnail_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . sort_order AS sort_order_6 , t0 . product_id AS product_id_7 FROM product_image t0 WHERE t0 . product_id = ? ORDER BY t0 . sort_order ASC
SELECT t0 . id AS id_1 , t0 . path AS path_2 , t0 . thumbnail AS thumbnail_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . sort_order AS sort_order_6 , t0 . product_id AS product_id_7 FROM product_image t0 WHERE t0 . product_id = 31 ORDER BY t0 . sort_order ASC ;
Copy
12
0.28 ms
SELECT t0 . id AS id_1 , t0 . path AS path_2 , t0 . thumbnail AS thumbnail_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . sort_order AS sort_order_6 , t0 . product_id AS product_id_7 FROM product_image t0 WHERE t0 . product_id = ? ORDER BY t0 . sort_order ASC
SELECT t0 . id AS id_1 , t0 . path AS path_2 , t0 . thumbnail AS thumbnail_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . sort_order AS sort_order_6 , t0 . product_id AS product_id_7 FROM product_image t0 WHERE t0 . product_id = 6 ORDER BY t0 . sort_order ASC ;
Copy
13
0.27 ms
SELECT t0 . id AS id_1 , t0 . path AS path_2 , t0 . thumbnail AS thumbnail_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . sort_order AS sort_order_6 , t0 . product_id AS product_id_7 FROM product_image t0 WHERE t0 . product_id = ? ORDER BY t0 . sort_order ASC
SELECT t0 . id AS id_1 , t0 . path AS path_2 , t0 . thumbnail AS thumbnail_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . sort_order AS sort_order_6 , t0 . product_id AS product_id_7 FROM product_image t0 WHERE t0 . product_id = 30 ORDER BY t0 . sort_order ASC ;
Copy
14
0.28 ms
SELECT t0 . id AS id_1 , t0 . path AS path_2 , t0 . thumbnail AS thumbnail_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . sort_order AS sort_order_6 , t0 . product_id AS product_id_7 FROM product_image t0 WHERE t0 . product_id = ? ORDER BY t0 . sort_order ASC
SELECT t0 . id AS id_1 , t0 . path AS path_2 , t0 . thumbnail AS thumbnail_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . sort_order AS sort_order_6 , t0 . product_id AS product_id_7 FROM product_image t0 WHERE t0 . product_id = 33 ORDER BY t0 . sort_order ASC ;
Copy
15
0.26 ms
SELECT t0 . id AS id_1 , t0 . path AS path_2 , t0 . thumbnail AS thumbnail_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . sort_order AS sort_order_6 , t0 . product_id AS product_id_7 FROM product_image t0 WHERE t0 . product_id = ? ORDER BY t0 . sort_order ASC
SELECT t0 . id AS id_1 , t0 . path AS path_2 , t0 . thumbnail AS thumbnail_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . sort_order AS sort_order_6 , t0 . product_id AS product_id_7 FROM product_image t0 WHERE t0 . product_id = 32 ORDER BY t0 . sort_order ASC ;
Copy
16
0.27 ms
SELECT t0 . id AS id_1 , t0 . path AS path_2 , t0 . thumbnail AS thumbnail_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . sort_order AS sort_order_6 , t0 . product_id AS product_id_7 FROM product_image t0 WHERE t0 . product_id = ? ORDER BY t0 . sort_order ASC
SELECT t0 . id AS id_1 , t0 . path AS path_2 , t0 . thumbnail AS thumbnail_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . sort_order AS sort_order_6 , t0 . product_id AS product_id_7 FROM product_image t0 WHERE t0 . product_id = 2 ORDER BY t0 . sort_order ASC ;
Copy