1
0.35 ms
SELECT DISTINCT p0_ . id AS id_0 , p0_ . title AS title_1 , p0_ . id AS id_2 FROM product p0_ ORDER BY p0_ . title ASC , p0_ . id DESC LIMIT 20
SELECT DISTINCT p0_ . id AS id_0 , p0_ . title AS title_1 , p0_ . id AS id_2 FROM product p0_ ORDER BY p0_ . title ASC , 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_ . title ASC , p0_ . id DESC
Parameters :
[
24
23
26
29
28
7
27
21
13
12
17
15
14
18
19
22
8
20
2
1
]
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 (24 , 23 , 26 , 29 , 28 , 7 , 27 , 21 , 13 , 12 , 17 , 15 , 14 , 18 , 19 , 22 , 8 , 20 , 2 , 1 ) ORDER BY p0_ . title ASC , p0_ . id DESC ;
Copy
3
0.15 ms
SELECT count (* ) AS sclr_0 FROM product p0_
SELECT count (* ) AS sclr_0 FROM product p0_ ;
Copy
4
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 = 24 ;
Copy
5
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 = 23 ;
Copy
6
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 = 26 ;
Copy
7
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 = 29 ;
Copy
8
0.18 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
9
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 = 7 ;
Copy
10
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 = 27 ;
Copy
11
0.18 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
12
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 = 13 ;
Copy
13
0.18 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
14
0.18 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.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
16
0.18 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
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 = 18 ;
Copy
18
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 = 19 ;
Copy
19
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 = 22 ;
Copy
20
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 = 8 ;
Copy
21
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 = 20 ;
Copy
22
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 = 2 ;
Copy
23
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 = 1 ;
Copy
24
0.31 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