1
0.59 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . slug AS slug_3 , t0 . description AS description_4 , t0 . deleted_at AS deleted_at_5 , t0 . parent_id AS parent_id_6 FROM category t0 WHERE t0 . slug = ? AND t0 . deleted_at IS NULL LIMIT 1
Parameters :
[
"household-cleaning "
]
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . slug AS slug_3 , t0 . description AS description_4 , t0 . deleted_at AS deleted_at_5 , t0 . parent_id AS parent_id_6 FROM category t0 WHERE t0 . slug = 'household-cleaning' AND t0 . deleted_at IS NULL LIMIT 1 ;
Copy
2
0.90 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.57 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . description AS description_3 , t0 . price_amount AS price_amount_4 , t0 . price_unit AS price_unit_5 , t0 . deposit_amount AS deposit_amount_6 , t0 . manual_included AS manual_included_7 , t0 . consumables_policy AS consumables_policy_8 , t0 . created_at AS created_at_9 , t0 . updated_at AS updated_at_10 , t0 . deleted_at AS deleted_at_11 , t0 . view_count AS view_count_12 , t0 . owner_id AS owner_id_13 , t0 . city_id AS city_id_14 FROM product t0 INNER JOIN product_category ON t0 . id = product_category . product_id WHERE product_category . category_id = ?
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . description AS description_3 , t0 . price_amount AS price_amount_4 , t0 . price_unit AS price_unit_5 , t0 . deposit_amount AS deposit_amount_6 , t0 . manual_included AS manual_included_7 , t0 . consumables_policy AS consumables_policy_8 , t0 . created_at AS created_at_9 , t0 . updated_at AS updated_at_10 , t0 . deleted_at AS deleted_at_11 , t0 . view_count AS view_count_12 , t0 . owner_id AS owner_id_13 , t0 . city_id AS city_id_14 FROM product t0 INNER JOIN product_category ON t0 . id = product_category . product_id WHERE product_category . category_id = 1 ;
Copy
4
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 = 11 ORDER BY t0 . position ASC , t0 . id ASC ;
Copy
5
0.29 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . slug AS slug_3 , t0 . latitude AS latitude_4 , t0 . longitude AS longitude_5 , t0 . deleted_at AS deleted_at_6 FROM city t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . slug AS slug_3 , t0 . latitude AS latitude_4 , t0 . longitude AS longitude_5 , t0 . deleted_at AS deleted_at_6 FROM city t0 WHERE t0 . id = 50 ;
Copy
6
0.29 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