1 |
0.66 ms |
SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.slug AS slug_2, m0_.display_name AS display_name_3, m0_.model_code AS model_code_4, m0_.image_name AS image_name_5, m0_.image_original_name AS image_original_name_6, m0_.created_at AS created_at_7, m0_.updated_at AS updated_at_8, m0_.model_id AS model_id_9 FROM model_year m0_ INNER JOIN model m1_ ON m0_.model_id = m1_.id INNER JOIN maker m2_ ON m1_.maker_id = m2_.id WHERE m0_.slug = ? AND m1_.slug = ? AND m2_.slug = ?
Parameters: [
"c5-01-04"
"c5"
"citroen"
]
SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.slug AS slug_2, m0_.display_name AS display_name_3, m0_.model_code AS model_code_4, m0_.image_name AS image_name_5, m0_.image_original_name AS image_original_name_6, m0_.created_at AS created_at_7, m0_.updated_at AS updated_at_8, m0_.model_id AS model_id_9 FROM model_year m0_ INNER JOIN model m1_ ON m0_.model_id = m1_.id INNER JOIN maker m2_ ON m1_.maker_id = m2_.id WHERE m0_.slug = 'c5-01-04' AND m1_.slug = 'c5' AND m2_.slug = 'citroen';
|
2 |
1.27 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.sku AS sku_2, p0_.is_in_stock AS is_in_stock_3, p0_.car_position AS car_position_4, p0_.is_genuine AS is_genuine_5, c1_.display_name AS display_name_6, p2_.regular AS regular_7, p0_.slug AS slug_8 FROM product p0_ INNER JOIN category c1_ ON p0_.category_id = c1_.id INNER JOIN product_model_year p3_ ON p0_.id = p3_.product_id INNER JOIN price p2_ ON p0_.id = p2_.product_id WHERE p3_.model_year_id = ? ORDER BY p0_.name ASC
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.sku AS sku_2, p0_.is_in_stock AS is_in_stock_3, p0_.car_position AS car_position_4, p0_.is_genuine AS is_genuine_5, c1_.display_name AS display_name_6, p2_.regular AS regular_7, p0_.slug AS slug_8 FROM product p0_ INNER JOIN category c1_ ON p0_.category_id = c1_.id INNER JOIN product_model_year p3_ ON p0_.id = p3_.product_id INNER JOIN price p2_ ON p0_.id = p2_.product_id WHERE p3_.model_year_id = 591 ORDER BY p0_.name ASC;
|
3 |
0.50 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.display_name AS display_name_4, t0.is_visible AS is_visible_5, t0.group_name AS group_name_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.maker_id AS maker_id_9 FROM model t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.display_name AS display_name_4, t0.is_visible AS is_visible_5, t0.group_name AS group_name_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.maker_id AS maker_id_9 FROM model t0 WHERE t0.id = 369;
|
4 |
0.22 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.display_name AS display_name_4, t0.image_name AS image_name_5, t0.image_original_name AS image_original_name_6, t0.is_car_maker AS is_car_maker_7, t0.is_visible AS is_visible_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM maker t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.display_name AS display_name_4, t0.image_name AS image_name_5, t0.image_original_name AS image_original_name_6, t0.is_car_maker AS is_car_maker_7, t0.is_visible AS is_visible_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM maker t0 WHERE t0.id = 7;
|