1
0.42 ms
SELECT DISTINCT p0_ . id AS id_0 , p0_ . price AS price_1 , p0_ . id AS id_2 FROM product p0_ ORDER BY p0_ . price ASC , p0_ . id DESC LIMIT 20
SELECT DISTINCT p0_ . id AS id_0 , p0_ . price AS price_1 , p0_ . id AS id_2 FROM product p0_ ORDER BY p0_ . price ASC , p0_ . id DESC LIMIT 20 ;
Copy
2
0.37 ms
SELECT p0_ . id AS id_0 , p0_ . title AS title_1 , p0_ . price_with_share AS price_with_share_2 , p0_ . price AS price_3 , p0_ . image AS image_4 , p0_ . description AS description_5 FROM product p0_ WHERE p0_ . id IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) ORDER BY p0_ . price ASC , p0_ . id DESC
Parameters :
[
27
23
16
3
5
4
28
14
26
1
2
9
8
6
15
20
19
17
24
18
]
SELECT p0_ . id AS id_0 , p0_ . title AS title_1 , p0_ . price_with_share AS price_with_share_2 , p0_ . price AS price_3 , p0_ . image AS image_4 , p0_ . description AS description_5 FROM product p0_ WHERE p0_ . id IN (27 , 23 , 16 , 3 , 5 , 4 , 28 , 14 , 26 , 1 , 2 , 9 , 8 , 6 , 15 , 20 , 19 , 17 , 24 , 18 ) ORDER BY p0_ . price ASC , p0_ . id DESC ;
Copy
3
0.19 ms
SELECT count (* ) AS sclr_0 FROM product p0_
SELECT count (* ) AS sclr_0 FROM product p0_ ;
Copy
4
0.32 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 FROM shop_categories t0 INNER JOIN product_category ON t0 . id = product_category . category_id WHERE product_category . product_id = ?
SELECT t0 . id AS id_1 , t0 . title AS title_2 FROM shop_categories t0 INNER JOIN product_category ON t0 . id = product_category . category_id WHERE product_category . product_id = 27 ;
Copy
5
0.21 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 FROM shop_categories t0 INNER JOIN product_category ON t0 . id = product_category . category_id WHERE product_category . product_id = ?
SELECT t0 . id AS id_1 , t0 . title AS title_2 FROM shop_categories t0 INNER JOIN product_category ON t0 . id = product_category . category_id WHERE product_category . product_id = 23 ;
Copy
6
0.20 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 FROM shop_categories t0 INNER JOIN product_category ON t0 . id = product_category . category_id WHERE product_category . product_id = ?
SELECT t0 . id AS id_1 , t0 . title AS title_2 FROM shop_categories t0 INNER JOIN product_category ON t0 . id = product_category . category_id WHERE product_category . product_id = 16 ;
Copy
7
0.20 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 FROM shop_categories t0 INNER JOIN product_category ON t0 . id = product_category . category_id WHERE product_category . product_id = ?
SELECT t0 . id AS id_1 , t0 . title AS title_2 FROM shop_categories t0 INNER JOIN product_category ON t0 . id = product_category . category_id WHERE product_category . product_id = 3 ;
Copy
8
0.19 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 FROM shop_categories t0 INNER JOIN product_category ON t0 . id = product_category . category_id WHERE product_category . product_id = ?
SELECT t0 . id AS id_1 , t0 . title AS title_2 FROM shop_categories t0 INNER JOIN product_category ON t0 . id = product_category . category_id WHERE product_category . product_id = 5 ;
Copy
9
0.28 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 FROM shop_categories t0 INNER JOIN product_category ON t0 . id = product_category . category_id WHERE product_category . product_id = ?
SELECT t0 . id AS id_1 , t0 . title AS title_2 FROM shop_categories t0 INNER JOIN product_category ON t0 . id = product_category . category_id WHERE product_category . product_id = 4 ;
Copy
10
0.20 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 FROM shop_categories t0 INNER JOIN product_category ON t0 . id = product_category . category_id WHERE product_category . product_id = ?
SELECT t0 . id AS id_1 , t0 . title AS title_2 FROM shop_categories t0 INNER JOIN product_category ON t0 . id = product_category . category_id WHERE product_category . product_id = 28 ;
Copy
11
0.19 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 FROM shop_categories t0 INNER JOIN product_category ON t0 . id = product_category . category_id WHERE product_category . product_id = ?
SELECT t0 . id AS id_1 , t0 . title AS title_2 FROM shop_categories t0 INNER JOIN product_category ON t0 . id = product_category . category_id WHERE product_category . product_id = 14 ;
Copy
12
0.38 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 FROM shop_categories t0 INNER JOIN product_category ON t0 . id = product_category . category_id WHERE product_category . product_id = ?
SELECT t0 . id AS id_1 , t0 . title AS title_2 FROM shop_categories t0 INNER JOIN product_category ON t0 . id = product_category . category_id WHERE product_category . product_id = 26 ;
Copy
13
0.22 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 FROM shop_categories t0 INNER JOIN product_category ON t0 . id = product_category . category_id WHERE product_category . product_id = ?
SELECT t0 . id AS id_1 , t0 . title AS title_2 FROM shop_categories t0 INNER JOIN product_category ON t0 . id = product_category . category_id WHERE product_category . product_id = 1 ;
Copy
14
0.22 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 FROM shop_categories t0 INNER JOIN product_category ON t0 . id = product_category . category_id WHERE product_category . product_id = ?
SELECT t0 . id AS id_1 , t0 . title AS title_2 FROM shop_categories t0 INNER JOIN product_category ON t0 . id = product_category . category_id WHERE product_category . product_id = 2 ;
Copy
15
0.23 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 FROM shop_categories t0 INNER JOIN product_category ON t0 . id = product_category . category_id WHERE product_category . product_id = ?
SELECT t0 . id AS id_1 , t0 . title AS title_2 FROM shop_categories t0 INNER JOIN product_category ON t0 . id = product_category . category_id WHERE product_category . product_id = 9 ;
Copy
16
0.21 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 FROM shop_categories t0 INNER JOIN product_category ON t0 . id = product_category . category_id WHERE product_category . product_id = ?
SELECT t0 . id AS id_1 , t0 . title AS title_2 FROM shop_categories t0 INNER JOIN product_category ON t0 . id = product_category . category_id WHERE product_category . product_id = 8 ;
Copy
17
0.21 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 FROM shop_categories t0 INNER JOIN product_category ON t0 . id = product_category . category_id WHERE product_category . product_id = ?
SELECT t0 . id AS id_1 , t0 . title AS title_2 FROM shop_categories t0 INNER JOIN product_category ON t0 . id = product_category . category_id WHERE product_category . product_id = 6 ;
Copy
18
0.67 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 FROM shop_categories t0 INNER JOIN product_category ON t0 . id = product_category . category_id WHERE product_category . product_id = ?
SELECT t0 . id AS id_1 , t0 . title AS title_2 FROM shop_categories t0 INNER JOIN product_category ON t0 . id = product_category . category_id WHERE product_category . product_id = 15 ;
Copy
19
0.86 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 FROM shop_categories t0 INNER JOIN product_category ON t0 . id = product_category . category_id WHERE product_category . product_id = ?
SELECT t0 . id AS id_1 , t0 . title AS title_2 FROM shop_categories t0 INNER JOIN product_category ON t0 . id = product_category . category_id WHERE product_category . product_id = 20 ;
Copy
20
0.28 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 FROM shop_categories t0 INNER JOIN product_category ON t0 . id = product_category . category_id WHERE product_category . product_id = ?
SELECT t0 . id AS id_1 , t0 . title AS title_2 FROM shop_categories t0 INNER JOIN product_category ON t0 . id = product_category . category_id WHERE product_category . product_id = 19 ;
Copy
21
0.60 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 FROM shop_categories t0 INNER JOIN product_category ON t0 . id = product_category . category_id WHERE product_category . product_id = ?
SELECT t0 . id AS id_1 , t0 . title AS title_2 FROM shop_categories t0 INNER JOIN product_category ON t0 . id = product_category . category_id WHERE product_category . product_id = 17 ;
Copy
22
0.55 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 FROM shop_categories t0 INNER JOIN product_category ON t0 . id = product_category . category_id WHERE product_category . product_id = ?
SELECT t0 . id AS id_1 , t0 . title AS title_2 FROM shop_categories t0 INNER JOIN product_category ON t0 . id = product_category . category_id WHERE product_category . product_id = 24 ;
Copy
23
0.21 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 FROM shop_categories t0 INNER JOIN product_category ON t0 . id = product_category . category_id WHERE product_category . product_id = ?
SELECT t0 . id AS id_1 , t0 . title AS title_2 FROM shop_categories t0 INNER JOIN product_category ON t0 . id = product_category . category_id WHERE product_category . product_id = 18 ;
Copy
24
0.37 ms
SELECT t0 . id AS id_1 , t0 . full_name AS full_name_2 , t0 . slug AS slug_3 , t0 . photo AS photo_4 , t0 . list_photo AS list_photo_5 , t0 . list_description AS list_description_6 , t0 . short_description AS short_description_7 , t0 . left_description AS left_description_8 , t0 . right_description AS right_description_9 , t0 . years_experience AS years_experience_10 FROM doctor t0 ORDER BY t0 . full_name ASC
SELECT t0 . id AS id_1 , t0 . full_name AS full_name_2 , t0 . slug AS slug_3 , t0 . photo AS photo_4 , t0 . list_photo AS list_photo_5 , t0 . list_description AS list_description_6 , t0 . short_description AS short_description_7 , t0 . left_description AS left_description_8 , t0 . right_description AS right_description_9 , t0 . years_experience AS years_experience_10 FROM doctor t0 ORDER BY t0 . full_name ASC ;
Copy