0.81 ms (33.34%)
1
SELECT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . slug AS slug_2 , p0_ . description AS description_3 , p0_ . price AS price_4 , p0_ . stock AS stock_5 , p0_ . is_available AS is_available_6 , p0_ . is_featured AS is_featured_7 , p0_ . is_personalizable AS is_personalizable_8 , p0_ . materials AS materials_9 , p0_ . dimensions AS dimensions_10 , p0_ . created_at AS created_at_11 , p0_ . updated_at AS updated_at_12 , p0_ . main_category_id AS main_category_id_13 FROM product p0_ LEFT JOIN product_categories p2_ ON p0_ . id = p2_ . product_id LEFT JOIN category c1_ ON c1_ . id = p2_ . category_id WHERE (p0_ . main_category_id = ? OR c1_ . id = ? ) AND p0_ . is_available = ? ORDER BY p0_ . created_at DESC
SELECT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . slug AS slug_2 , p0_ . description AS description_3 , p0_ . price AS price_4 , p0_ . stock AS stock_5 , p0_ . is_available AS is_available_6 , p0_ . is_featured AS is_featured_7 , p0_ . is_personalizable AS is_personalizable_8 , p0_ . materials AS materials_9 , p0_ . dimensions AS dimensions_10 , p0_ . created_at AS created_at_11 , p0_ . updated_at AS updated_at_12 , p0_ . main_category_id AS main_category_id_13 FROM product p0_ LEFT JOIN product_categories p2_ ON p0_ . id = p2_ . product_id LEFT JOIN category c1_ ON c1_ . id = p2_ . category_id WHERE (p0_ . main_category_id = 93 OR c1_ . id = 93 ) AND p0_ . is_available = 1 ORDER BY p0_ . created_at DESC ;
Copy
0.76 ms (31.25%)
1
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . slug AS slug_3 , t0 . description AS description_4 , t0 . created_at AS created_at_5 , t0 . parent_id AS parent_id_6 FROM category t0 WHERE t0 . slug = ? LIMIT 1
Parameters :
[
"accessoires-enfants "
]
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . slug AS slug_3 , t0 . description AS description_4 , t0 . created_at AS created_at_5 , t0 . parent_id AS parent_id_6 FROM category t0 WHERE t0 . slug = 'accessoires-enfants' LIMIT 1 ;
Copy
0.75 ms (30.50%)
7
SELECT t0 . id AS id_1 , t0 . filename AS filename_2 , t0 . alt_text AS alt_text_3 , t0 . is_main AS is_main_4 , t0 . position AS position_5 , t0 . created_at AS created_at_6 , t0 . product_id AS product_id_7 FROM product_image t0 WHERE t0 . product_id = ?
SELECT t0 . id AS id_1 , t0 . filename AS filename_2 , t0 . alt_text AS alt_text_3 , t0 . is_main AS is_main_4 , t0 . position AS position_5 , t0 . created_at AS created_at_6 , t0 . product_id AS product_id_7 FROM product_image t0 WHERE t0 . product_id = 155 ;
Copy
0.12 ms (4.91%)
1
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . slug AS slug_3 , t0 . description AS description_4 , t0 . created_at AS created_at_5 , t0 . parent_id AS parent_id_6 FROM category t0
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . slug AS slug_3 , t0 . description AS description_4 , t0 . created_at AS created_at_5 , t0 . parent_id AS parent_id_6 FROM category t0 ;
Copy