1 |
2.87 ms |
SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.name_original AS name_original_2, f0_.mime_type AS mime_type_3, f0_.path AS path_4, f0_.path_base AS path_base_5, f0_.category AS category_6, f0_.vehicle_id AS vehicle_id_7, f0_.article_id AS article_id_8 FROM file f0_ WHERE f0_.vehicle_id IS NULL AND f0_.path = ? AND f0_.category = ? ORDER BY f0_.name_original ASC
Parameters: [
"image/"
"carousel1"
]
SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.name_original AS name_original_2, f0_.mime_type AS mime_type_3, f0_.path AS path_4, f0_.path_base AS path_base_5, f0_.category AS category_6, f0_.vehicle_id AS vehicle_id_7, f0_.article_id AS article_id_8 FROM file f0_ WHERE f0_.vehicle_id IS NULL AND f0_.path = 'image/' AND f0_.category = 'carousel1' ORDER BY f0_.name_original ASC;
|
2 |
1.30 ms |
SELECT a0_.id AS id_0, a0_.heading AS heading_1, a0_.content AS content_2, a0_.created_at AS created_at_3, a0_.category AS category_4 FROM article a0_ WHERE a0_.category = ? ORDER BY a0_.created_at DESC LIMIT 1
SELECT a0_.id AS id_0, a0_.heading AS heading_1, a0_.content AS content_2, a0_.created_at AS created_at_3, a0_.category AS category_4 FROM article a0_ WHERE a0_.category = 'news' ORDER BY a0_.created_at DESC LIMIT 1;
|
3 |
1.09 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.name_original AS name_original_3, t0.mime_type AS mime_type_4, t0.path AS path_5, t0.path_base AS path_base_6, t0.category AS category_7, t0.vehicle_id AS vehicle_id_8, t0.article_id AS article_id_9 FROM file t0 WHERE t0.article_id = ? ORDER BY t0.name_original ASC
SELECT t0.id AS id_1, t0.name AS name_2, t0.name_original AS name_original_3, t0.mime_type AS mime_type_4, t0.path AS path_5, t0.path_base AS path_base_6, t0.category AS category_7, t0.vehicle_id AS vehicle_id_8, t0.article_id AS article_id_9 FROM file t0 WHERE t0.article_id = 3 ORDER BY t0.name_original ASC;
|
4 |
7.24 ms |
SELECT v0_.id AS id_0, v0_.construction_year AS construction_year_1, v0_.labeling AS labeling_2, v0_.article_number AS article_number_3, v0_.purchased_at AS purchased_at_4, v0_.storage_location AS storage_location_5, v0_.condition_rating AS condition_rating_6, v0_.approved AS approved_7, v0_.visible AS visible_8, v0_.status AS status_9, v0_.description AS description_10, v0_.brand_id AS brand_id_11, v0_.design_type_id AS design_type_id_12, v0_.bottom_embossing_id AS bottom_embossing_id_13, v0_.type_id AS type_id_14, v0_.tire_type_id AS tire_type_id_15, v0_.scale_id AS scale_id_16, v0_.series_id AS series_id_17, v0_.manufacturer_id AS manufacturer_id_18, v0_.category_id AS category_id_19 FROM vehicle v0_ INNER JOIN file f1_ ON v0_.id = f1_.vehicle_id WHERE v0_.approved = ? AND v0_.visible = ? ORDER BY v0_.purchased_at DESC LIMIT 1
SELECT v0_.id AS id_0, v0_.construction_year AS construction_year_1, v0_.labeling AS labeling_2, v0_.article_number AS article_number_3, v0_.purchased_at AS purchased_at_4, v0_.storage_location AS storage_location_5, v0_.condition_rating AS condition_rating_6, v0_.approved AS approved_7, v0_.visible AS visible_8, v0_.status AS status_9, v0_.description AS description_10, v0_.brand_id AS brand_id_11, v0_.design_type_id AS design_type_id_12, v0_.bottom_embossing_id AS bottom_embossing_id_13, v0_.type_id AS type_id_14, v0_.tire_type_id AS tire_type_id_15, v0_.scale_id AS scale_id_16, v0_.series_id AS series_id_17, v0_.manufacturer_id AS manufacturer_id_18, v0_.category_id AS category_id_19 FROM vehicle v0_ INNER JOIN file f1_ ON v0_.id = f1_.vehicle_id WHERE v0_.approved = 1 AND v0_.visible = 1 ORDER BY v0_.purchased_at DESC LIMIT 1;
|
5 |
1.17 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.name_original AS name_original_3, t0.mime_type AS mime_type_4, t0.path AS path_5, t0.path_base AS path_base_6, t0.category AS category_7, t0.vehicle_id AS vehicle_id_8, t0.article_id AS article_id_9 FROM file t0 WHERE t0.vehicle_id = ? ORDER BY t0.name_original ASC
SELECT t0.id AS id_1, t0.name AS name_2, t0.name_original AS name_original_3, t0.mime_type AS mime_type_4, t0.path AS path_5, t0.path_base AS path_base_6, t0.category AS category_7, t0.vehicle_id AS vehicle_id_8, t0.article_id AS article_id_9 FROM file t0 WHERE t0.vehicle_id = 1299 ORDER BY t0.name_original ASC;
|
6 |
1.28 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM brand t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM brand t0 WHERE t0.id = 85;
|
7 |
1.33 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM type t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM type t0 WHERE t0.id = 562;
|
8 |
2.00 ms |
SELECT a0_.id AS id_0, a0_.heading AS heading_1, a0_.content AS content_2, a0_.created_at AS created_at_3, a0_.category AS category_4 FROM article a0_ WHERE a0_.category = ? ORDER BY a0_.created_at DESC LIMIT 1
Parameters: [
"special"
]
SELECT a0_.id AS id_0, a0_.heading AS heading_1, a0_.content AS content_2, a0_.created_at AS created_at_3, a0_.category AS category_4 FROM article a0_ WHERE a0_.category = 'special' ORDER BY a0_.created_at DESC LIMIT 1;
|
9 |
1.23 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.name_original AS name_original_3, t0.mime_type AS mime_type_4, t0.path AS path_5, t0.path_base AS path_base_6, t0.category AS category_7, t0.vehicle_id AS vehicle_id_8, t0.article_id AS article_id_9 FROM file t0 WHERE t0.article_id = ? ORDER BY t0.name_original ASC
SELECT t0.id AS id_1, t0.name AS name_2, t0.name_original AS name_original_3, t0.mime_type AS mime_type_4, t0.path AS path_5, t0.path_base AS path_base_6, t0.category AS category_7, t0.vehicle_id AS vehicle_id_8, t0.article_id AS article_id_9 FROM file t0 WHERE t0.article_id = 4 ORDER BY t0.name_original ASC;
|