1
0.90 ms
SELECT p0_ . id AS id_0 , p0_ . title AS title_1 , p0_ . description AS description_2 , p0_ . price_amount AS price_amount_3 , p0_ . price_unit AS price_unit_4 , p0_ . deposit_amount AS deposit_amount_5 , p0_ . manual_included AS manual_included_6 , p0_ . consumables_policy AS consumables_policy_7 , p0_ . created_at AS created_at_8 , p0_ . updated_at AS updated_at_9 , p0_ . deleted_at AS deleted_at_10 , p0_ . view_count AS view_count_11 , c1_ . id AS id_12 , c1_ . name AS name_13 , c1_ . slug AS slug_14 , c1_ . description AS description_15 , c1_ . deleted_at AS deleted_at_16 , c2_ . id AS id_17 , c2_ . name AS name_18 , c2_ . slug AS slug_19 , c2_ . latitude AS latitude_20 , c2_ . longitude AS longitude_21 , c2_ . deleted_at AS deleted_at_22 , p0_ . owner_id AS owner_id_23 , p0_ . city_id AS city_id_24 , c1_ . parent_id AS parent_id_25 FROM product p0_ LEFT JOIN product_category p3_ ON p0_ . id = p3_ . product_id LEFT JOIN category c1_ ON c1_ . id = p3_ . category_id LEFT JOIN city c2_ ON p0_ . city_id = c2_ . id WHERE p0_ . deleted_at IS NULL ORDER BY p0_ . updated_at DESC LIMIT 50
SELECT p0_ . id AS id_0 , p0_ . title AS title_1 , p0_ . description AS description_2 , p0_ . price_amount AS price_amount_3 , p0_ . price_unit AS price_unit_4 , p0_ . deposit_amount AS deposit_amount_5 , p0_ . manual_included AS manual_included_6 , p0_ . consumables_policy AS consumables_policy_7 , p0_ . created_at AS created_at_8 , p0_ . updated_at AS updated_at_9 , p0_ . deleted_at AS deleted_at_10 , p0_ . view_count AS view_count_11 , c1_ . id AS id_12 , c1_ . name AS name_13 , c1_ . slug AS slug_14 , c1_ . description AS description_15 , c1_ . deleted_at AS deleted_at_16 , c2_ . id AS id_17 , c2_ . name AS name_18 , c2_ . slug AS slug_19 , c2_ . latitude AS latitude_20 , c2_ . longitude AS longitude_21 , c2_ . deleted_at AS deleted_at_22 , p0_ . owner_id AS owner_id_23 , p0_ . city_id AS city_id_24 , c1_ . parent_id AS parent_id_25 FROM product p0_ LEFT JOIN product_category p3_ ON p0_ . id = p3_ . product_id LEFT JOIN category c1_ ON c1_ . id = p3_ . category_id LEFT JOIN city c2_ ON p0_ . city_id = c2_ . id WHERE p0_ . deleted_at IS NULL ORDER BY p0_ . updated_at DESC LIMIT 50 ;
Copy
2
0.69 ms
SELECT c0_ . id AS id_0 , c0_ . name AS name_1 , c0_ . slug AS slug_2 , c0_ . description AS description_3 , c0_ . deleted_at AS deleted_at_4 , c0_ . parent_id AS parent_id_5 FROM category c0_ WHERE c0_ . deleted_at IS NULL ORDER BY c0_ . name ASC
SELECT c0_ . id AS id_0 , c0_ . name AS name_1 , c0_ . slug AS slug_2 , c0_ . description AS description_3 , c0_ . deleted_at AS deleted_at_4 , c0_ . parent_id AS parent_id_5 FROM category c0_ WHERE c0_ . deleted_at IS NULL ORDER BY c0_ . name ASC ;
Copy
3
0.56 ms
SELECT c0_ . id AS id_0 , c0_ . name AS name_1 , c0_ . slug AS slug_2 , c0_ . latitude AS latitude_3 , c0_ . longitude AS longitude_4 , c0_ . deleted_at AS deleted_at_5 FROM city c0_ WHERE c0_ . deleted_at IS NULL ORDER BY c0_ . name ASC
SELECT c0_ . id AS id_0 , c0_ . name AS name_1 , c0_ . slug AS slug_2 , c0_ . latitude AS latitude_3 , c0_ . longitude AS longitude_4 , c0_ . deleted_at AS deleted_at_5 FROM city c0_ WHERE c0_ . deleted_at IS NULL ORDER BY c0_ . name ASC ;
Copy
4
0.61 ms
SELECT t0 . id AS id_1 , t0 . path AS path_2 , t0 . position AS position_3 , t0 . product_id AS product_id_4 FROM product_image t0 WHERE t0 . product_id = ? ORDER BY t0 . position ASC , t0 . id ASC
SELECT t0 . id AS id_1 , t0 . path AS path_2 , t0 . position AS position_3 , t0 . product_id AS product_id_4 FROM product_image t0 WHERE t0 . product_id = 5 ORDER BY t0 . position ASC , t0 . id ASC ;
Copy
5
0.52 ms
SELECT t0 . id AS id_1 , t0 . path AS path_2 , t0 . position AS position_3 , t0 . product_id AS product_id_4 FROM product_image t0 WHERE t0 . product_id = ? ORDER BY t0 . position ASC , t0 . id ASC
SELECT t0 . id AS id_1 , t0 . path AS path_2 , t0 . position AS position_3 , t0 . product_id AS product_id_4 FROM product_image t0 WHERE t0 . product_id = 8 ORDER BY t0 . position ASC , t0 . id ASC ;
Copy
6
0.40 ms
SELECT t0 . id AS id_1 , t0 . path AS path_2 , t0 . position AS position_3 , t0 . product_id AS product_id_4 FROM product_image t0 WHERE t0 . product_id = ? ORDER BY t0 . position ASC , t0 . id ASC
SELECT t0 . id AS id_1 , t0 . path AS path_2 , t0 . position AS position_3 , t0 . product_id AS product_id_4 FROM product_image t0 WHERE t0 . product_id = 3 ORDER BY t0 . position ASC , t0 . id ASC ;
Copy
7
0.47 ms
SELECT t0 . id AS id_1 , t0 . path AS path_2 , t0 . position AS position_3 , t0 . product_id AS product_id_4 FROM product_image t0 WHERE t0 . product_id = ? ORDER BY t0 . position ASC , t0 . id ASC
SELECT t0 . id AS id_1 , t0 . path AS path_2 , t0 . position AS position_3 , t0 . product_id AS product_id_4 FROM product_image t0 WHERE t0 . product_id = 2 ORDER BY t0 . position ASC , t0 . id ASC ;
Copy
8
0.46 ms
SELECT t0 . id AS id_1 , t0 . path AS path_2 , t0 . position AS position_3 , t0 . product_id AS product_id_4 FROM product_image t0 WHERE t0 . product_id = ? ORDER BY t0 . position ASC , t0 . id ASC
SELECT t0 . id AS id_1 , t0 . path AS path_2 , t0 . position AS position_3 , t0 . product_id AS product_id_4 FROM product_image t0 WHERE t0 . product_id = 18 ORDER BY t0 . position ASC , t0 . id ASC ;
Copy
9
0.48 ms
SELECT t0 . id AS id_1 , t0 . path AS path_2 , t0 . position AS position_3 , t0 . product_id AS product_id_4 FROM product_image t0 WHERE t0 . product_id = ? ORDER BY t0 . position ASC , t0 . id ASC
SELECT t0 . id AS id_1 , t0 . path AS path_2 , t0 . position AS position_3 , t0 . product_id AS product_id_4 FROM product_image t0 WHERE t0 . product_id = 17 ORDER BY t0 . position ASC , t0 . id ASC ;
Copy
10
0.46 ms
SELECT t0 . id AS id_1 , t0 . path AS path_2 , t0 . position AS position_3 , t0 . product_id AS product_id_4 FROM product_image t0 WHERE t0 . product_id = ? ORDER BY t0 . position ASC , t0 . id ASC
SELECT t0 . id AS id_1 , t0 . path AS path_2 , t0 . position AS position_3 , t0 . product_id AS product_id_4 FROM product_image t0 WHERE t0 . product_id = 1 ORDER BY t0 . position ASC , t0 . id ASC ;
Copy
11
0.47 ms
SELECT t0 . id AS id_1 , t0 . path AS path_2 , t0 . position AS position_3 , t0 . product_id AS product_id_4 FROM product_image t0 WHERE t0 . product_id = ? ORDER BY t0 . position ASC , t0 . id ASC
SELECT t0 . id AS id_1 , t0 . path AS path_2 , t0 . position AS position_3 , t0 . product_id AS product_id_4 FROM product_image t0 WHERE t0 . product_id = 6 ORDER BY t0 . position ASC , t0 . id ASC ;
Copy
12
0.45 ms
SELECT t0 . id AS id_1 , t0 . path AS path_2 , t0 . position AS position_3 , t0 . product_id AS product_id_4 FROM product_image t0 WHERE t0 . product_id = ? ORDER BY t0 . position ASC , t0 . id ASC
SELECT t0 . id AS id_1 , t0 . path AS path_2 , t0 . position AS position_3 , t0 . product_id AS product_id_4 FROM product_image t0 WHERE t0 . product_id = 7 ORDER BY t0 . position ASC , t0 . id ASC ;
Copy
13
0.50 ms
SELECT t0 . id AS id_1 , t0 . path AS path_2 , t0 . position AS position_3 , t0 . product_id AS product_id_4 FROM product_image t0 WHERE t0 . product_id = ? ORDER BY t0 . position ASC , t0 . id ASC
SELECT t0 . id AS id_1 , t0 . path AS path_2 , t0 . position AS position_3 , t0 . product_id AS product_id_4 FROM product_image t0 WHERE t0 . product_id = 4 ORDER BY t0 . position ASC , t0 . id ASC ;
Copy
14
0.38 ms
SELECT t0 . id AS id_1 , t0 . path AS path_2 , t0 . position AS position_3 , t0 . product_id AS product_id_4 FROM product_image t0 WHERE t0 . product_id = ? ORDER BY t0 . position ASC , t0 . id ASC
SELECT t0 . id AS id_1 , t0 . path AS path_2 , t0 . position AS position_3 , t0 . product_id AS product_id_4 FROM product_image t0 WHERE t0 . product_id = 9 ORDER BY t0 . position ASC , t0 . id ASC ;
Copy
15
0.43 ms
SELECT t0 . id AS id_1 , t0 . path AS path_2 , t0 . position AS position_3 , t0 . product_id AS product_id_4 FROM product_image t0 WHERE t0 . product_id = ? ORDER BY t0 . position ASC , t0 . id ASC
SELECT t0 . id AS id_1 , t0 . path AS path_2 , t0 . position AS position_3 , t0 . product_id AS product_id_4 FROM product_image t0 WHERE t0 . product_id = 10 ORDER BY t0 . position ASC , t0 . id ASC ;
Copy
16
0.44 ms
SELECT t0 . id AS id_1 , t0 . path AS path_2 , t0 . position AS position_3 , t0 . product_id AS product_id_4 FROM product_image t0 WHERE t0 . product_id = ? ORDER BY t0 . position ASC , t0 . id ASC
SELECT t0 . id AS id_1 , t0 . path AS path_2 , t0 . position AS position_3 , t0 . product_id AS product_id_4 FROM product_image t0 WHERE t0 . product_id = 11 ORDER BY t0 . position ASC , t0 . id ASC ;
Copy
17
0.44 ms
SELECT t0 . id AS id_1 , t0 . path AS path_2 , t0 . position AS position_3 , t0 . product_id AS product_id_4 FROM product_image t0 WHERE t0 . product_id = ? ORDER BY t0 . position ASC , t0 . id ASC
SELECT t0 . id AS id_1 , t0 . path AS path_2 , t0 . position AS position_3 , t0 . product_id AS product_id_4 FROM product_image t0 WHERE t0 . product_id = 12 ORDER BY t0 . position ASC , t0 . id ASC ;
Copy
18
0.46 ms
SELECT t0 . id AS id_1 , t0 . path AS path_2 , t0 . position AS position_3 , t0 . product_id AS product_id_4 FROM product_image t0 WHERE t0 . product_id = ? ORDER BY t0 . position ASC , t0 . id ASC
SELECT t0 . id AS id_1 , t0 . path AS path_2 , t0 . position AS position_3 , t0 . product_id AS product_id_4 FROM product_image t0 WHERE t0 . product_id = 13 ORDER BY t0 . position ASC , t0 . id ASC ;
Copy
19
0.51 ms
SELECT t0 . id AS id_1 , t0 . path AS path_2 , t0 . position AS position_3 , t0 . product_id AS product_id_4 FROM product_image t0 WHERE t0 . product_id = ? ORDER BY t0 . position ASC , t0 . id ASC
SELECT t0 . id AS id_1 , t0 . path AS path_2 , t0 . position AS position_3 , t0 . product_id AS product_id_4 FROM product_image t0 WHERE t0 . product_id = 14 ORDER BY t0 . position ASC , t0 . id ASC ;
Copy
20
0.45 ms
SELECT t0 . id AS id_1 , t0 . path AS path_2 , t0 . position AS position_3 , t0 . product_id AS product_id_4 FROM product_image t0 WHERE t0 . product_id = ? ORDER BY t0 . position ASC , t0 . id ASC
SELECT t0 . id AS id_1 , t0 . path AS path_2 , t0 . position AS position_3 , t0 . product_id AS product_id_4 FROM product_image t0 WHERE t0 . product_id = 15 ORDER BY t0 . position ASC , t0 . id ASC ;
Copy
21
0.43 ms
SELECT t0 . id AS id_1 , t0 . path AS path_2 , t0 . position AS position_3 , t0 . product_id AS product_id_4 FROM product_image t0 WHERE t0 . product_id = ? ORDER BY t0 . position ASC , t0 . id ASC
SELECT t0 . id AS id_1 , t0 . path AS path_2 , t0 . position AS position_3 , t0 . product_id AS product_id_4 FROM product_image t0 WHERE t0 . product_id = 16 ORDER BY t0 . position ASC , t0 . id ASC ;
Copy