| 1 |
1.07 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM type t0 WHERE t0.slug = ? LIMIT 1
Parameters: [
"136-evening-news-v…"
]
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM type t0 WHERE t0.slug = '136-evening-news-v…' LIMIT 1;
|
| 2 |
1.06 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM scale t0 WHERE t0.slug = ? LIMIT 1
Parameters: [
"42-0-084027778"
]
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM scale t0 WHERE t0.slug = '42-0-084027778' LIMIT 1;
|
| 3 |
0.94 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM brand t0 WHERE t0.slug = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM brand t0 WHERE t0.slug = '4-un…' LIMIT 1;
|
| 4 |
1.01 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM series t0 WHERE t0.slug = ? LIMIT 1
Parameters: [
"201-standar…"
]
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM series t0 WHERE t0.slug = '201-standar…' LIMIT 1;
|
| 5 |
1.81 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_.description_extra AS description_extra_11, v0_.brand_id AS brand_id_12, v0_.design_type_id AS design_type_id_13, v0_.bottom_embossing_id AS bottom_embossing_id_14, v0_.type_id AS type_id_15, v0_.tire_type_id AS tire_type_id_16, v0_.scale_id AS scale_id_17, v0_.series_id AS series_id_18, v0_.manufacturer_id AS manufacturer_id_19, v0_.category_id AS category_id_20 FROM vehicle v0_ LEFT JOIN scale s1_ ON v0_.scale_id = s1_.id LEFT JOIN series s2_ ON v0_.series_id = s2_.id WHERE s1_.slug = ? AND v0_.construction_year = ? AND v0_.visible = ? AND v0_.status = ? AND v0_.approved = ? ORDER BY s2_.name ASC LIMIT 50
Parameters: [
"42-0-084027778"
"2013"
1
"collection"
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_.description_extra AS description_extra_11, v0_.brand_id AS brand_id_12, v0_.design_type_id AS design_type_id_13, v0_.bottom_embossing_id AS bottom_embossing_id_14, v0_.type_id AS type_id_15, v0_.tire_type_id AS tire_type_id_16, v0_.scale_id AS scale_id_17, v0_.series_id AS series_id_18, v0_.manufacturer_id AS manufacturer_id_19, v0_.category_id AS category_id_20 FROM vehicle v0_ LEFT JOIN scale s1_ ON v0_.scale_id = s1_.id LEFT JOIN series s2_ ON v0_.series_id = s2_.id WHERE s1_.slug = '42-0-084027778' AND v0_.construction_year = '2013' AND v0_.visible = 1 AND v0_.status = 'collection' AND v0_.approved = 1 ORDER BY s2_.name ASC LIMIT 50;
|
| 6 |
1.47 ms |
SELECT COUNT(v0_.id) AS sclr_0 FROM vehicle v0_ LEFT JOIN scale s1_ ON v0_.scale_id = s1_.id LEFT JOIN series s2_ ON v0_.series_id = s2_.id WHERE s1_.slug = ? AND v0_.construction_year = ? AND v0_.visible = ? AND v0_.status = ? AND v0_.approved = ? ORDER BY s2_.name ASC
Parameters: [
"42-0-084027778"
"2013"
1
"collection"
1
]
SELECT COUNT(v0_.id) AS sclr_0 FROM vehicle v0_ LEFT JOIN scale s1_ ON v0_.scale_id = s1_.id LEFT JOIN series s2_ ON v0_.series_id = s2_.id WHERE s1_.slug = '42-0-084027778' AND v0_.construction_year = '2013' AND v0_.visible = 1 AND v0_.status = 'collection' AND v0_.approved = 1 ORDER BY s2_.name ASC;
|
| 7 |
1.01 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM type t0 WHERE t0.slug = ? LIMIT 1
Parameters: [
"136-evening-news-v…"
]
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM type t0 WHERE t0.slug = '136-evening-news-v…' LIMIT 1;
|
| 8 |
0.98 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM scale t0 WHERE t0.slug = ? LIMIT 1
Parameters: [
"42-0-084027778"
]
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM scale t0 WHERE t0.slug = '42-0-084027778' LIMIT 1;
|
| 9 |
0.94 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM series t0 WHERE t0.slug = ? LIMIT 1
Parameters: [
"201-standar…"
]
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM series t0 WHERE t0.slug = '201-standar…' LIMIT 1;
|
| 10 |
1.48 ms |
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.slug AS slug_2 FROM brand b0_ LEFT JOIN vehicle v1_ ON (v1_.brand_id = b0_.id) LEFT JOIN scale s2_ ON (s2_.id = v1_.scale_id) WHERE v1_.status = ? AND v1_.approved = ? AND v1_.visible = ? AND s2_.slug = ? AND v1_.construction_year = ? ORDER BY b0_.name ASC
Parameters: [
"collection"
1
1
"42-0-084027778"
"2013"
]
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.slug AS slug_2 FROM brand b0_ LEFT JOIN vehicle v1_ ON (v1_.brand_id = b0_.id) LEFT JOIN scale s2_ ON (s2_.id = v1_.scale_id) WHERE v1_.status = 'collection' AND v1_.approved = 1 AND v1_.visible = 1 AND s2_.slug = '42-0-084027778' AND v1_.construction_year = '2013' ORDER BY b0_.name ASC;
|
| 11 |
1.01 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM scale t0 WHERE t0.slug = ? LIMIT 1
Parameters: [
"42-0-084027778"
]
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM scale t0 WHERE t0.slug = '42-0-084027778' LIMIT 1;
|
| 12 |
0.98 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM brand t0 WHERE t0.slug = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM brand t0 WHERE t0.slug = '4-un…' LIMIT 1;
|
| 13 |
0.99 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM series t0 WHERE t0.slug = ? LIMIT 1
Parameters: [
"201-standar…"
]
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM series t0 WHERE t0.slug = '201-standar…' LIMIT 1;
|
| 14 |
1.55 ms |
SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.slug AS slug_2 FROM type t0_ LEFT JOIN vehicle v1_ ON (v1_.type_id = t0_.id) LEFT JOIN scale s2_ ON (s2_.id = v1_.scale_id) WHERE v1_.status = ? AND v1_.approved = ? AND v1_.visible = ? AND s2_.slug = ? AND v1_.construction_year = ? ORDER BY t0_.name ASC
Parameters: [
"collection"
1
1
"42-0-084027778"
"2013"
]
SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.slug AS slug_2 FROM type t0_ LEFT JOIN vehicle v1_ ON (v1_.type_id = t0_.id) LEFT JOIN scale s2_ ON (s2_.id = v1_.scale_id) WHERE v1_.status = 'collection' AND v1_.approved = 1 AND v1_.visible = 1 AND s2_.slug = '42-0-084027778' AND v1_.construction_year = '2013' ORDER BY t0_.name ASC;
|
| 15 |
0.95 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM type t0 WHERE t0.slug = ? LIMIT 1
Parameters: [
"136-evening-news-v…"
]
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM type t0 WHERE t0.slug = '136-evening-news-v…' LIMIT 1;
|
| 16 |
0.93 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM scale t0 WHERE t0.slug = ? LIMIT 1
Parameters: [
"42-0-084027778"
]
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM scale t0 WHERE t0.slug = '42-0-084027778' LIMIT 1;
|
| 17 |
0.93 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM brand t0 WHERE t0.slug = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM brand t0 WHERE t0.slug = '4-un…' LIMIT 1;
|
| 18 |
1.07 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM series t0 WHERE t0.slug = ? LIMIT 1
Parameters: [
"201-standar…"
]
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM series t0 WHERE t0.slug = '201-standar…' LIMIT 1;
|
| 19 |
1.68 ms |
SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.slug AS slug_2 FROM manufacturer m0_ LEFT JOIN vehicle v1_ ON (v1_.manufacturer_id = m0_.id) LEFT JOIN scale s2_ ON (s2_.id = v1_.scale_id) WHERE v1_.status = ? AND v1_.approved = ? AND v1_.visible = ? AND s2_.slug = ? AND v1_.construction_year = ? ORDER BY m0_.name ASC
Parameters: [
"collection"
1
1
"42-0-084027778"
"2013"
]
SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.slug AS slug_2 FROM manufacturer m0_ LEFT JOIN vehicle v1_ ON (v1_.manufacturer_id = m0_.id) LEFT JOIN scale s2_ ON (s2_.id = v1_.scale_id) WHERE v1_.status = 'collection' AND v1_.approved = 1 AND v1_.visible = 1 AND s2_.slug = '42-0-084027778' AND v1_.construction_year = '2013' ORDER BY m0_.name ASC;
|
| 20 |
1.07 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM type t0 WHERE t0.slug = ? LIMIT 1
Parameters: [
"136-evening-news-v…"
]
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM type t0 WHERE t0.slug = '136-evening-news-v…' LIMIT 1;
|
| 21 |
1.05 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM scale t0 WHERE t0.slug = ? LIMIT 1
Parameters: [
"42-0-084027778"
]
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM scale t0 WHERE t0.slug = '42-0-084027778' LIMIT 1;
|
| 22 |
1.01 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM brand t0 WHERE t0.slug = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM brand t0 WHERE t0.slug = '4-un…' LIMIT 1;
|
| 23 |
1.00 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM series t0 WHERE t0.slug = ? LIMIT 1
Parameters: [
"201-standar…"
]
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM series t0 WHERE t0.slug = '201-standar…' LIMIT 1;
|
| 24 |
1.59 ms |
SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.slug AS slug_2 FROM design_type d0_ LEFT JOIN vehicle v1_ ON (v1_.design_type_id = d0_.id) LEFT JOIN scale s2_ ON (s2_.id = v1_.scale_id) WHERE v1_.status = ? AND v1_.approved = ? AND v1_.visible = ? AND s2_.slug = ? AND v1_.construction_year = ? ORDER BY d0_.name ASC
Parameters: [
"collection"
1
1
"42-0-084027778"
"2013"
]
SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.slug AS slug_2 FROM design_type d0_ LEFT JOIN vehicle v1_ ON (v1_.design_type_id = d0_.id) LEFT JOIN scale s2_ ON (s2_.id = v1_.scale_id) WHERE v1_.status = 'collection' AND v1_.approved = 1 AND v1_.visible = 1 AND s2_.slug = '42-0-084027778' AND v1_.construction_year = '2013' ORDER BY d0_.name ASC;
|
| 25 |
0.94 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM type t0 WHERE t0.slug = ? LIMIT 1
Parameters: [
"136-evening-news-v…"
]
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM type t0 WHERE t0.slug = '136-evening-news-v…' LIMIT 1;
|
| 26 |
0.96 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM brand t0 WHERE t0.slug = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM brand t0 WHERE t0.slug = '4-un…' LIMIT 1;
|
| 27 |
0.94 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM series t0 WHERE t0.slug = ? LIMIT 1
Parameters: [
"201-standar…"
]
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM series t0 WHERE t0.slug = '201-standar…' LIMIT 1;
|
| 28 |
5.95 ms |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2 FROM scale s0_ LEFT JOIN vehicle v1_ ON (v1_.scale_id = s0_.id) WHERE v1_.status = ? AND v1_.approved = ? AND v1_.visible = ? AND v1_.construction_year = ? ORDER BY s0_.name ASC
Parameters: [
"collection"
1
1
"2013"
]
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2 FROM scale s0_ LEFT JOIN vehicle v1_ ON (v1_.scale_id = s0_.id) WHERE v1_.status = 'collection' AND v1_.approved = 1 AND v1_.visible = 1 AND v1_.construction_year = '2013' ORDER BY s0_.name ASC;
|
| 29 |
0.99 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM type t0 WHERE t0.slug = ? LIMIT 1
Parameters: [
"136-evening-news-v…"
]
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM type t0 WHERE t0.slug = '136-evening-news-v…' LIMIT 1;
|
| 30 |
1.43 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM scale t0 WHERE t0.slug = ? LIMIT 1
Parameters: [
"42-0-084027778"
]
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM scale t0 WHERE t0.slug = '42-0-084027778' LIMIT 1;
|
| 31 |
1.08 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM brand t0 WHERE t0.slug = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM brand t0 WHERE t0.slug = '4-un…' LIMIT 1;
|
| 32 |
1.60 ms |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2 FROM series s0_ LEFT JOIN vehicle v1_ ON (v1_.series_id = s0_.id) LEFT JOIN scale s2_ ON (s2_.id = v1_.scale_id) WHERE v1_.status = ? AND v1_.approved = ? AND v1_.visible = ? AND s2_.slug = ? AND v1_.construction_year = ? ORDER BY s0_.name ASC
Parameters: [
"collection"
1
1
"42-0-084027778"
"2013"
]
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2 FROM series s0_ LEFT JOIN vehicle v1_ ON (v1_.series_id = s0_.id) LEFT JOIN scale s2_ ON (s2_.id = v1_.scale_id) WHERE v1_.status = 'collection' AND v1_.approved = 1 AND v1_.visible = 1 AND s2_.slug = '42-0-084027778' AND v1_.construction_year = '2013' ORDER BY s0_.name ASC;
|
| 33 |
0.96 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM type t0 WHERE t0.slug = ? LIMIT 1
Parameters: [
"136-evening-news-v…"
]
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM type t0 WHERE t0.slug = '136-evening-news-v…' LIMIT 1;
|
| 34 |
0.97 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM scale t0 WHERE t0.slug = ? LIMIT 1
Parameters: [
"42-0-084027778"
]
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM scale t0 WHERE t0.slug = '42-0-084027778' LIMIT 1;
|
| 35 |
0.98 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM brand t0 WHERE t0.slug = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM brand t0 WHERE t0.slug = '4-un…' LIMIT 1;
|
| 36 |
0.95 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM series t0 WHERE t0.slug = ? LIMIT 1
Parameters: [
"201-standar…"
]
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM series t0 WHERE t0.slug = '201-standar…' LIMIT 1;
|
| 37 |
1.53 ms |
SELECT v0_.construction_year AS construction_year_0 FROM vehicle v0_ LEFT JOIN scale s1_ ON (s1_.id = v0_.scale_id) WHERE v0_.construction_year IS NOT NULL AND v0_.construction_year <> 0 AND v0_.status = ? AND v0_.approved = ? AND v0_.visible = ? AND s1_.slug = ? GROUP BY v0_.construction_year ORDER BY v0_.construction_year ASC
Parameters: [
"collection"
1
1
"42-0-084027778"
]
SELECT v0_.construction_year AS construction_year_0 FROM vehicle v0_ LEFT JOIN scale s1_ ON (s1_.id = v0_.scale_id) WHERE v0_.construction_year IS NOT NULL AND v0_.construction_year <> 0 AND v0_.status = 'collection' AND v0_.approved = 1 AND v0_.visible = 1 AND s1_.slug = '42-0-084027778' GROUP BY v0_.construction_year ORDER BY v0_.construction_year ASC;
|
| 38 |
1.03 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM brand t0 WHERE t0.slug = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM brand t0 WHERE t0.slug = '4-un…' LIMIT 1;
|
| 39 |
0.94 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM type t0 WHERE t0.slug = ? LIMIT 1
Parameters: [
"136-evening-news-v…"
]
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM type t0 WHERE t0.slug = '136-evening-news-v…' LIMIT 1;
|
| 40 |
1.04 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM scale t0 WHERE t0.slug = ? LIMIT 1
Parameters: [
"42-0-084027778"
]
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM scale t0 WHERE t0.slug = '42-0-084027778' LIMIT 1;
|
| 41 |
1.01 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM series t0 WHERE t0.slug = ? LIMIT 1
Parameters: [
"201-standar…"
]
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM series t0 WHERE t0.slug = '201-standar…' LIMIT 1;
|
| 42 |
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.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 = 2163 ORDER BY t0.name_original ASC;
|