1
0.33 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 DESC , 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 DESC , p0_ . id DESC LIMIT 20 ;
Copy
2
0.38 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 DESC , p0_ . id DESC
Parameters :
[
13
12
11
10
22
21
29
24
18
7
17
20
19
15
6
9
8
2
1
26
]
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 (13 , 12 , 11 , 10 , 22 , 21 , 29 , 24 , 18 , 7 , 17 , 20 , 19 , 15 , 6 , 9 , 8 , 2 , 1 , 26 ) ORDER BY p0_ . price DESC , p0_ . id DESC ;
Copy
3
0.22 ms
SELECT count (* ) AS sclr_0 FROM product p0_
SELECT count (* ) AS sclr_0 FROM product p0_ ;
Copy
4
0.29 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 = 13 ;
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 = 12 ;
Copy
6
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 = 11 ;
Copy
7
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 = 10 ;
Copy
8
0.37 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 = 22 ;
Copy
9
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 = 21 ;
Copy
10
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 = 29 ;
Copy
11
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 = 24 ;
Copy
12
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 = 18 ;
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 = 7 ;
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 = 17 ;
Copy
15
0.24 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
16
0.24 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
17
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 = 15 ;
Copy
18
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 = 6 ;
Copy
19
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 = 9 ;
Copy
20
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
21
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 = 2 ;
Copy
22
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 = 1 ;
Copy
23
0.24 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
24
0.34 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