1
1.24 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 DESC , p0_ . id DESC LIMIT 20 OFFSET 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 DESC , p0_ . id DESC LIMIT 20 OFFSET 20 ;
Copy
2
3.48 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 DESC , p0_ . id DESC
Parameters :
[
21
27
7
28
29
26
23
24
]
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 (21 , 27 , 7 , 28 , 29 , 26 , 23 , 24 ) ORDER BY p0_ . title DESC , p0_ . id DESC ;
Copy
3
3.09 ms
SELECT count (* ) AS sclr_0 FROM product p0_
SELECT count (* ) AS sclr_0 FROM product p0_ ;
Copy
4
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 = 21 ;
Copy
5
4.00 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
6
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 = 7 ;
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 = 28 ;
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 = 29 ;
Copy
9
6.25 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
10
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
11
0.34 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
2.73 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