1 |
0.60 ms |
SELECT c0_.id AS id_0, c0_.first_name AS first_name_1, c0_.last_name AS last_name_2, c0_.text_comment AS text_comment_3, c0_.created_at AS created_at_4 FROM comment c0_ ORDER BY c0_.id ASC LIMIT 3
SELECT c0_.id AS id_0, c0_.first_name AS first_name_1, c0_.last_name AS last_name_2, c0_.text_comment AS text_comment_3, c0_.created_at AS created_at_4 FROM comment c0_ ORDER BY c0_.id ASC LIMIT 3;
|
2 |
0.46 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.name_arb AS name_arb_3 FROM category t0
SELECT t0.id AS id_1, t0.name AS name_2, t0.name_arb AS name_arb_3 FROM category t0;
|
3 |
0.56 ms |
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.name_arb AS name_arb_2, p0_.description AS description_3, p0_.description_arb AS description_arb_4, p0_.price AS price_5, p0_.promo AS promo_6, p0_.stockage AS stockage_7, i1_.id AS id_8, i1_.name AS name_9, c2_.id AS id_10, c2_.name AS name_11, c2_.name_arb AS name_arb_12 FROM product p0_ INNER JOIN image i1_ ON p0_.id = i1_.product_id INNER JOIN category c2_ ON p0_.category_id = c2_.id WHERE p0_.category_id = ?) dctrn_result_inner ORDER BY id_0 DESC) dctrn_result LIMIT 15
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.name_arb AS name_arb_2, p0_.description AS description_3, p0_.description_arb AS description_arb_4, p0_.price AS price_5, p0_.promo AS promo_6, p0_.stockage AS stockage_7, i1_.id AS id_8, i1_.name AS name_9, c2_.id AS id_10, c2_.name AS name_11, c2_.name_arb AS name_arb_12 FROM product p0_ INNER JOIN image i1_ ON p0_.id = i1_.product_id INNER JOIN category c2_ ON p0_.category_id = c2_.id WHERE p0_.category_id = 15) dctrn_result_inner ORDER BY id_0 DESC) dctrn_result LIMIT 15;
|
4 |
0.56 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.name_arb AS name_arb_2, p0_.description AS description_3, p0_.description_arb AS description_arb_4, p0_.price AS price_5, p0_.promo AS promo_6, p0_.stockage AS stockage_7, i1_.id AS id_8, i1_.name AS name_9, c2_.id AS id_10, c2_.name AS name_11, c2_.name_arb AS name_arb_12, p0_.category_id AS category_id_13, i1_.product_id AS product_id_14 FROM product p0_ INNER JOIN image i1_ ON p0_.id = i1_.product_id INNER JOIN category c2_ ON p0_.category_id = c2_.id WHERE p0_.category_id = ? AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.id DESC
Parameters: [
15
244
241
239
238
236
235
234
233
232
231
230
229
228
227
226
]
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.name_arb AS name_arb_2, p0_.description AS description_3, p0_.description_arb AS description_arb_4, p0_.price AS price_5, p0_.promo AS promo_6, p0_.stockage AS stockage_7, i1_.id AS id_8, i1_.name AS name_9, c2_.id AS id_10, c2_.name AS name_11, c2_.name_arb AS name_arb_12, p0_.category_id AS category_id_13, i1_.product_id AS product_id_14 FROM product p0_ INNER JOIN image i1_ ON p0_.id = i1_.product_id INNER JOIN category c2_ ON p0_.category_id = c2_.id WHERE p0_.category_id = 15 AND p0_.id IN (244, 241, 239, 238, 236, 235, 234, 233, 232, 231, 230, 229, 228, 227, 226) ORDER BY p0_.id DESC;
|
5 |
0.43 ms |
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, price_5 FROM (SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.name_arb AS name_arb_2, p0_.description AS description_3, p0_.description_arb AS description_arb_4, p0_.price AS price_5, p0_.promo AS promo_6, p0_.stockage AS stockage_7, i1_.id AS id_8, i1_.name AS name_9, c2_.id AS id_10, c2_.name AS name_11, c2_.name_arb AS name_arb_12 FROM product p0_ INNER JOIN image i1_ ON p0_.id = i1_.product_id INNER JOIN category c2_ ON p0_.category_id = c2_.id WHERE p0_.category_id = ?) dctrn_result_inner ORDER BY price_5 ASC) dctrn_result LIMIT 15
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, price_5 FROM (SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.name_arb AS name_arb_2, p0_.description AS description_3, p0_.description_arb AS description_arb_4, p0_.price AS price_5, p0_.promo AS promo_6, p0_.stockage AS stockage_7, i1_.id AS id_8, i1_.name AS name_9, c2_.id AS id_10, c2_.name AS name_11, c2_.name_arb AS name_arb_12 FROM product p0_ INNER JOIN image i1_ ON p0_.id = i1_.product_id INNER JOIN category c2_ ON p0_.category_id = c2_.id WHERE p0_.category_id = 16) dctrn_result_inner ORDER BY price_5 ASC) dctrn_result LIMIT 15;
|
6 |
0.47 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.name_arb AS name_arb_2, p0_.description AS description_3, p0_.description_arb AS description_arb_4, p0_.price AS price_5, p0_.promo AS promo_6, p0_.stockage AS stockage_7, i1_.id AS id_8, i1_.name AS name_9, c2_.id AS id_10, c2_.name AS name_11, c2_.name_arb AS name_arb_12, p0_.category_id AS category_id_13, i1_.product_id AS product_id_14 FROM product p0_ INNER JOIN image i1_ ON p0_.id = i1_.product_id INNER JOIN category c2_ ON p0_.category_id = c2_.id WHERE p0_.category_id = ? AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.price ASC
Parameters: [
16
216
213
217
218
210
211
215
209
214
212
219
]
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.name_arb AS name_arb_2, p0_.description AS description_3, p0_.description_arb AS description_arb_4, p0_.price AS price_5, p0_.promo AS promo_6, p0_.stockage AS stockage_7, i1_.id AS id_8, i1_.name AS name_9, c2_.id AS id_10, c2_.name AS name_11, c2_.name_arb AS name_arb_12, p0_.category_id AS category_id_13, i1_.product_id AS product_id_14 FROM product p0_ INNER JOIN image i1_ ON p0_.id = i1_.product_id INNER JOIN category c2_ ON p0_.category_id = c2_.id WHERE p0_.category_id = 16 AND p0_.id IN (216, 213, 217, 218, 210, 211, 215, 209, 214, 212, 219) ORDER BY p0_.price ASC;
|
7 |
0.54 ms |
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, price_5 FROM (SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.name_arb AS name_arb_2, p0_.description AS description_3, p0_.description_arb AS description_arb_4, p0_.price AS price_5, p0_.promo AS promo_6, p0_.stockage AS stockage_7, i1_.id AS id_8, i1_.name AS name_9, c2_.id AS id_10, c2_.name AS name_11, c2_.name_arb AS name_arb_12 FROM product p0_ INNER JOIN image i1_ ON p0_.id = i1_.product_id INNER JOIN category c2_ ON p0_.category_id = c2_.id WHERE p0_.category_id = ?) dctrn_result_inner ORDER BY price_5 ASC) dctrn_result LIMIT 15
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, price_5 FROM (SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.name_arb AS name_arb_2, p0_.description AS description_3, p0_.description_arb AS description_arb_4, p0_.price AS price_5, p0_.promo AS promo_6, p0_.stockage AS stockage_7, i1_.id AS id_8, i1_.name AS name_9, c2_.id AS id_10, c2_.name AS name_11, c2_.name_arb AS name_arb_12 FROM product p0_ INNER JOIN image i1_ ON p0_.id = i1_.product_id INNER JOIN category c2_ ON p0_.category_id = c2_.id WHERE p0_.category_id = 3) dctrn_result_inner ORDER BY price_5 ASC) dctrn_result LIMIT 15;
|
8 |
0.41 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.name_arb AS name_arb_2, p0_.description AS description_3, p0_.description_arb AS description_arb_4, p0_.price AS price_5, p0_.promo AS promo_6, p0_.stockage AS stockage_7, i1_.id AS id_8, i1_.name AS name_9, c2_.id AS id_10, c2_.name AS name_11, c2_.name_arb AS name_arb_12, p0_.category_id AS category_id_13, i1_.product_id AS product_id_14 FROM product p0_ INNER JOIN image i1_ ON p0_.id = i1_.product_id INNER JOIN category c2_ ON p0_.category_id = c2_.id WHERE p0_.category_id = ? AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.price ASC
Parameters: [
3
81
80
86
83
120
182
188
100
101
117
196
78
110
205
114
]
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.name_arb AS name_arb_2, p0_.description AS description_3, p0_.description_arb AS description_arb_4, p0_.price AS price_5, p0_.promo AS promo_6, p0_.stockage AS stockage_7, i1_.id AS id_8, i1_.name AS name_9, c2_.id AS id_10, c2_.name AS name_11, c2_.name_arb AS name_arb_12, p0_.category_id AS category_id_13, i1_.product_id AS product_id_14 FROM product p0_ INNER JOIN image i1_ ON p0_.id = i1_.product_id INNER JOIN category c2_ ON p0_.category_id = c2_.id WHERE p0_.category_id = 3 AND p0_.id IN (81, 80, 86, 83, 120, 182, 188, 100, 101, 117, 196, 78, 110, 205, 114) ORDER BY p0_.price ASC;
|
9 |
0.35 ms |
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, price_5 FROM (SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.name_arb AS name_arb_2, p0_.description AS description_3, p0_.description_arb AS description_arb_4, p0_.price AS price_5, p0_.promo AS promo_6, p0_.stockage AS stockage_7, i1_.id AS id_8, i1_.name AS name_9, c2_.id AS id_10, c2_.name AS name_11, c2_.name_arb AS name_arb_12 FROM product p0_ INNER JOIN image i1_ ON p0_.id = i1_.product_id INNER JOIN category c2_ ON p0_.category_id = c2_.id WHERE p0_.category_id = ?) dctrn_result_inner ORDER BY price_5 ASC) dctrn_result LIMIT 15
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, price_5 FROM (SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.name_arb AS name_arb_2, p0_.description AS description_3, p0_.description_arb AS description_arb_4, p0_.price AS price_5, p0_.promo AS promo_6, p0_.stockage AS stockage_7, i1_.id AS id_8, i1_.name AS name_9, c2_.id AS id_10, c2_.name AS name_11, c2_.name_arb AS name_arb_12 FROM product p0_ INNER JOIN image i1_ ON p0_.id = i1_.product_id INNER JOIN category c2_ ON p0_.category_id = c2_.id WHERE p0_.category_id = 9) dctrn_result_inner ORDER BY price_5 ASC) dctrn_result LIMIT 15;
|
10 |
0.50 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.name_arb AS name_arb_2, p0_.description AS description_3, p0_.description_arb AS description_arb_4, p0_.price AS price_5, p0_.promo AS promo_6, p0_.stockage AS stockage_7, i1_.id AS id_8, i1_.name AS name_9, c2_.id AS id_10, c2_.name AS name_11, c2_.name_arb AS name_arb_12, p0_.category_id AS category_id_13, i1_.product_id AS product_id_14 FROM product p0_ INNER JOIN image i1_ ON p0_.id = i1_.product_id INNER JOIN category c2_ ON p0_.category_id = c2_.id WHERE p0_.category_id = ? AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.price ASC
Parameters: [
9
43
48
49
50
51
46
27
47
36
45
32
65
28
29
33
]
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.name_arb AS name_arb_2, p0_.description AS description_3, p0_.description_arb AS description_arb_4, p0_.price AS price_5, p0_.promo AS promo_6, p0_.stockage AS stockage_7, i1_.id AS id_8, i1_.name AS name_9, c2_.id AS id_10, c2_.name AS name_11, c2_.name_arb AS name_arb_12, p0_.category_id AS category_id_13, i1_.product_id AS product_id_14 FROM product p0_ INNER JOIN image i1_ ON p0_.id = i1_.product_id INNER JOIN category c2_ ON p0_.category_id = c2_.id WHERE p0_.category_id = 9 AND p0_.id IN (43, 48, 49, 50, 51, 46, 27, 47, 36, 45, 32, 65, 28, 29, 33) ORDER BY p0_.price ASC;
|
11 |
0.30 ms |
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, price_5 FROM (SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.name_arb AS name_arb_2, p0_.description AS description_3, p0_.description_arb AS description_arb_4, p0_.price AS price_5, p0_.promo AS promo_6, p0_.stockage AS stockage_7, i1_.id AS id_8, i1_.name AS name_9, c2_.id AS id_10, c2_.name AS name_11, c2_.name_arb AS name_arb_12 FROM product p0_ INNER JOIN image i1_ ON p0_.id = i1_.product_id INNER JOIN category c2_ ON p0_.category_id = c2_.id WHERE p0_.category_id = ?) dctrn_result_inner ORDER BY price_5 ASC) dctrn_result LIMIT 15
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, price_5 FROM (SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.name_arb AS name_arb_2, p0_.description AS description_3, p0_.description_arb AS description_arb_4, p0_.price AS price_5, p0_.promo AS promo_6, p0_.stockage AS stockage_7, i1_.id AS id_8, i1_.name AS name_9, c2_.id AS id_10, c2_.name AS name_11, c2_.name_arb AS name_arb_12 FROM product p0_ INNER JOIN image i1_ ON p0_.id = i1_.product_id INNER JOIN category c2_ ON p0_.category_id = c2_.id WHERE p0_.category_id = 5) dctrn_result_inner ORDER BY price_5 ASC) dctrn_result LIMIT 15;
|
12 |
0.37 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.name_arb AS name_arb_2, p0_.description AS description_3, p0_.description_arb AS description_arb_4, p0_.price AS price_5, p0_.promo AS promo_6, p0_.stockage AS stockage_7, i1_.id AS id_8, i1_.name AS name_9, c2_.id AS id_10, c2_.name AS name_11, c2_.name_arb AS name_arb_12, p0_.category_id AS category_id_13, i1_.product_id AS product_id_14 FROM product p0_ INNER JOIN image i1_ ON p0_.id = i1_.product_id INNER JOIN category c2_ ON p0_.category_id = c2_.id WHERE p0_.category_id = ? AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.price ASC
Parameters: [
5
155
16
156
220
157
154
133
123
121
221
122
]
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.name_arb AS name_arb_2, p0_.description AS description_3, p0_.description_arb AS description_arb_4, p0_.price AS price_5, p0_.promo AS promo_6, p0_.stockage AS stockage_7, i1_.id AS id_8, i1_.name AS name_9, c2_.id AS id_10, c2_.name AS name_11, c2_.name_arb AS name_arb_12, p0_.category_id AS category_id_13, i1_.product_id AS product_id_14 FROM product p0_ INNER JOIN image i1_ ON p0_.id = i1_.product_id INNER JOIN category c2_ ON p0_.category_id = c2_.id WHERE p0_.category_id = 5 AND p0_.id IN (155, 16, 156, 220, 157, 154, 133, 123, 121, 221, 122) ORDER BY p0_.price ASC;
|