GET https://dev.vaigo.it/ricerca?category=%27city-car%27

Query Metrics

92 Database Queries
12 Different statements
47.99 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.82 ms
SELECT DISTINCT c0_.gearbox_slug AS gearbox_slug_0, c0_.gearbox AS gearbox_1 FROM offer o1_ LEFT JOIN car c0_ ON o1_.car_id = c0_.id WHERE o1_.published = 1 ORDER BY c0_.gearbox ASC
Parameters:
[]
2 1.87 ms
SELECT DISTINCT c0_.brand_slug AS brand_slug_0, c0_.brand_name AS brand_name_1 FROM offer o1_ LEFT JOIN car c0_ ON o1_.car_id = c0_.id WHERE o1_.published = 1 ORDER BY c0_.brand_name ASC
Parameters:
[]
3 2.71 ms
SELECT DISTINCT c0_.category_slug AS category_slug_0, c0_.category_name AS category_name_1 FROM offer o1_ LEFT JOIN car c0_ ON o1_.car_id = c0_.id ORDER BY c0_.category_name ASC
Parameters:
[]
4 2.47 ms
SELECT DISTINCT c0_.model_slug AS model_slug_0, c0_.model_name AS model_name_1 FROM offer o1_ LEFT JOIN car c0_ ON o1_.car_id = c0_.id ORDER BY c0_.model_name ASC
Parameters:
[]
5 1.48 ms
SELECT DISTINCT c0_.fuel_slug AS fuel_slug_0, c0_.fuel_name AS fuel_name_1 FROM offer o1_ LEFT JOIN car c0_ ON o1_.car_id = c0_.id ORDER BY c0_.fuel_name ASC
Parameters:
[]
6 2.50 ms
SELECT o0_.id AS id_0, o0_.webid AS webid_1, o0_.code AS code_2, o0_.price AS price_3, o0_.deposit AS deposit_4, o0_.duration AS duration_5, o0_.distance AS distance_6, o0_.notes AS notes_7, o0_.left_label AS left_label_8, o0_.right_label AS right_label_9, o0_.fast_delivery AS fast_delivery_10, o0_.delivery_time AS delivery_time_11, o0_.tag AS tag_12, o0_.secondary_tag AS secondary_tag_13, o0_.seolink AS seolink_14, o0_.status AS status_15, o0_.created_at AS created_at_16, o0_.updated_at AS updated_at_17, o0_.deleted_at AS deleted_at_18, o0_.featured AS featured_19, o0_.catalog AS catalog_20, o0_.published AS published_21, o0_.private AS private_22, o0_.for_company AS for_company_23, o0_.video_id AS video_id_24, o0_.last_import_at AS last_import_at_25, o0_.priority AS priority_26, o0_.adv AS adv_27, o0_.linear_badge AS linear_badge_28, o0_.linear_badge_color AS linear_badge_color_29, o0_.round_badge AS round_badge_30, o0_.round_badge_color AS round_badge_color_31, o0_.ribbon_badge AS ribbon_badge_32, o0_.ribbon_badge_color AS ribbon_badge_color_33, o0_.provider AS provider_34, o0_.image_lock AS image_lock_35, o0_.booked AS booked_36, o0_.booked_by AS booked_by_37, o0_.booked_at AS booked_at_38, o0_.car_id AS car_id_39 FROM offer o0_ LEFT JOIN car c1_ ON o0_.car_id = c1_.id WHERE o0_.published = 1 AND c1_.category_slug IN ('city-car') ORDER BY o0_.priority DESC, o0_.price ASC
Parameters:
[]
7 0.86 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.description AS description_4, t0.icon AS icon_5 FROM offer_service t0 INNER JOIN offer_service_relation ON t0.id = offer_service_relation.service_id WHERE offer_service_relation.offer_id = ?
Parameters:
[
  "732890cc-f77c-4662-8b17-51951f3637a7"
]
8 0.58 ms
SELECT t0.id AS id_1, t0.brand_name AS brand_name_2, t0.brand_slug AS brand_slug_3, t0.fuel_name AS fuel_name_4, t0.fuel_slug AS fuel_slug_5, t0.category_name AS category_name_6, t0.category_slug AS category_slug_7, t0.model_name AS model_name_8, t0.model_slug AS model_slug_9, t0.version AS version_10, t0.displacement AS displacement_11, t0.power AS power_12, t0.drive AS drive_13, t0.average_consumption AS average_consumption_14, t0.emission AS emission_15, t0.sizes AS sizes_16, t0.capacity AS capacity_17, t0.seats AS seats_18, t0.doors AS doors_19, t0.gearbox AS gearbox_20, t0.gearbox_slug AS gearbox_slug_21 FROM car t0 WHERE t0.id IN (?)
Parameters:
[
  "54774b70-470a-4f37-b9f1-ba45c4892164"
]
9 0.55 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.deposit AS deposit_3, t0.duration AS duration_4, t0.distance AS distance_5, t0.offer_id AS offer_id_6 FROM offer_variation t0 WHERE t0.offer_id IN (?)
Parameters:
[
  "732890cc-f77c-4662-8b17-51951f3637a7"
]
10 0.71 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.alt AS alt_3, t0.src AS src_4, t0.original_src AS original_src_5, t0.ordering AS ordering_6, t0.car_id AS car_id_7 FROM car_image t0 WHERE t0.car_id IN (?) ORDER BY t0.ordering ASC
Parameters:
[
  "54774b70-470a-4f37-b9f1-ba45c4892164"
]
11 0.61 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.description AS description_4, t0.icon AS icon_5 FROM offer_service t0 INNER JOIN offer_service_relation ON t0.id = offer_service_relation.service_id WHERE offer_service_relation.offer_id = ?
Parameters:
[
  "0985d3c8-24c1-4516-92ba-4cfd60a2cccf"
]
12 0.46 ms
SELECT t0.id AS id_1, t0.brand_name AS brand_name_2, t0.brand_slug AS brand_slug_3, t0.fuel_name AS fuel_name_4, t0.fuel_slug AS fuel_slug_5, t0.category_name AS category_name_6, t0.category_slug AS category_slug_7, t0.model_name AS model_name_8, t0.model_slug AS model_slug_9, t0.version AS version_10, t0.displacement AS displacement_11, t0.power AS power_12, t0.drive AS drive_13, t0.average_consumption AS average_consumption_14, t0.emission AS emission_15, t0.sizes AS sizes_16, t0.capacity AS capacity_17, t0.seats AS seats_18, t0.doors AS doors_19, t0.gearbox AS gearbox_20, t0.gearbox_slug AS gearbox_slug_21 FROM car t0 WHERE t0.id IN (?)
Parameters:
[
  "687073dc-7e75-410c-a371-b07ab79bb0c2"
]
13 0.40 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.deposit AS deposit_3, t0.duration AS duration_4, t0.distance AS distance_5, t0.offer_id AS offer_id_6 FROM offer_variation t0 WHERE t0.offer_id IN (?)
Parameters:
[
  "0985d3c8-24c1-4516-92ba-4cfd60a2cccf"
]
14 0.72 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.alt AS alt_3, t0.src AS src_4, t0.original_src AS original_src_5, t0.ordering AS ordering_6, t0.car_id AS car_id_7 FROM car_image t0 WHERE t0.car_id IN (?) ORDER BY t0.ordering ASC
Parameters:
[
  "687073dc-7e75-410c-a371-b07ab79bb0c2"
]
15 0.61 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.description AS description_4, t0.icon AS icon_5 FROM offer_service t0 INNER JOIN offer_service_relation ON t0.id = offer_service_relation.service_id WHERE offer_service_relation.offer_id = ?
Parameters:
[
  "651dc9d1-31d3-4df7-8c08-4c52d0b94b87"
]
16 0.50 ms
SELECT t0.id AS id_1, t0.brand_name AS brand_name_2, t0.brand_slug AS brand_slug_3, t0.fuel_name AS fuel_name_4, t0.fuel_slug AS fuel_slug_5, t0.category_name AS category_name_6, t0.category_slug AS category_slug_7, t0.model_name AS model_name_8, t0.model_slug AS model_slug_9, t0.version AS version_10, t0.displacement AS displacement_11, t0.power AS power_12, t0.drive AS drive_13, t0.average_consumption AS average_consumption_14, t0.emission AS emission_15, t0.sizes AS sizes_16, t0.capacity AS capacity_17, t0.seats AS seats_18, t0.doors AS doors_19, t0.gearbox AS gearbox_20, t0.gearbox_slug AS gearbox_slug_21 FROM car t0 WHERE t0.id IN (?)
Parameters:
[
  "3f581753-276c-462d-9289-86ed7de03c79"
]
17 0.50 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.deposit AS deposit_3, t0.duration AS duration_4, t0.distance AS distance_5, t0.offer_id AS offer_id_6 FROM offer_variation t0 WHERE t0.offer_id IN (?)
Parameters:
[
  "651dc9d1-31d3-4df7-8c08-4c52d0b94b87"
]
18 0.52 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.alt AS alt_3, t0.src AS src_4, t0.original_src AS original_src_5, t0.ordering AS ordering_6, t0.car_id AS car_id_7 FROM car_image t0 WHERE t0.car_id IN (?) ORDER BY t0.ordering ASC
Parameters:
[
  "3f581753-276c-462d-9289-86ed7de03c79"
]
19 0.44 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.description AS description_4, t0.icon AS icon_5 FROM offer_service t0 INNER JOIN offer_service_relation ON t0.id = offer_service_relation.service_id WHERE offer_service_relation.offer_id = ?
Parameters:
[
  "81f598d8-1bf8-4f5b-a9c9-7407a1fb179e"
]
20 0.36 ms
SELECT t0.id AS id_1, t0.brand_name AS brand_name_2, t0.brand_slug AS brand_slug_3, t0.fuel_name AS fuel_name_4, t0.fuel_slug AS fuel_slug_5, t0.category_name AS category_name_6, t0.category_slug AS category_slug_7, t0.model_name AS model_name_8, t0.model_slug AS model_slug_9, t0.version AS version_10, t0.displacement AS displacement_11, t0.power AS power_12, t0.drive AS drive_13, t0.average_consumption AS average_consumption_14, t0.emission AS emission_15, t0.sizes AS sizes_16, t0.capacity AS capacity_17, t0.seats AS seats_18, t0.doors AS doors_19, t0.gearbox AS gearbox_20, t0.gearbox_slug AS gearbox_slug_21 FROM car t0 WHERE t0.id IN (?)
Parameters:
[
  "3f86d4a6-2eab-49bd-9d19-3ba53e2d4ac0"
]
21 0.31 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.deposit AS deposit_3, t0.duration AS duration_4, t0.distance AS distance_5, t0.offer_id AS offer_id_6 FROM offer_variation t0 WHERE t0.offer_id IN (?)
Parameters:
[
  "81f598d8-1bf8-4f5b-a9c9-7407a1fb179e"
]
22 0.39 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.alt AS alt_3, t0.src AS src_4, t0.original_src AS original_src_5, t0.ordering AS ordering_6, t0.car_id AS car_id_7 FROM car_image t0 WHERE t0.car_id IN (?) ORDER BY t0.ordering ASC
Parameters:
[
  "3f86d4a6-2eab-49bd-9d19-3ba53e2d4ac0"
]
23 0.39 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.description AS description_4, t0.icon AS icon_5 FROM offer_service t0 INNER JOIN offer_service_relation ON t0.id = offer_service_relation.service_id WHERE offer_service_relation.offer_id = ?
Parameters:
[
  "4d60279e-6fb5-456c-a901-73271c123eeb"
]
24 0.29 ms
SELECT t0.id AS id_1, t0.brand_name AS brand_name_2, t0.brand_slug AS brand_slug_3, t0.fuel_name AS fuel_name_4, t0.fuel_slug AS fuel_slug_5, t0.category_name AS category_name_6, t0.category_slug AS category_slug_7, t0.model_name AS model_name_8, t0.model_slug AS model_slug_9, t0.version AS version_10, t0.displacement AS displacement_11, t0.power AS power_12, t0.drive AS drive_13, t0.average_consumption AS average_consumption_14, t0.emission AS emission_15, t0.sizes AS sizes_16, t0.capacity AS capacity_17, t0.seats AS seats_18, t0.doors AS doors_19, t0.gearbox AS gearbox_20, t0.gearbox_slug AS gearbox_slug_21 FROM car t0 WHERE t0.id IN (?)
Parameters:
[
  "1c5b32aa-e029-4dd1-bd3e-7c03beb52b00"
]
25 0.28 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.deposit AS deposit_3, t0.duration AS duration_4, t0.distance AS distance_5, t0.offer_id AS offer_id_6 FROM offer_variation t0 WHERE t0.offer_id IN (?)
Parameters:
[
  "4d60279e-6fb5-456c-a901-73271c123eeb"
]
26 0.31 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.alt AS alt_3, t0.src AS src_4, t0.original_src AS original_src_5, t0.ordering AS ordering_6, t0.car_id AS car_id_7 FROM car_image t0 WHERE t0.car_id IN (?) ORDER BY t0.ordering ASC
Parameters:
[
  "1c5b32aa-e029-4dd1-bd3e-7c03beb52b00"
]
27 0.38 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.description AS description_4, t0.icon AS icon_5 FROM offer_service t0 INNER JOIN offer_service_relation ON t0.id = offer_service_relation.service_id WHERE offer_service_relation.offer_id = ?
Parameters:
[
  "0d683ffc-a725-4b6c-bd31-49323a4de4a6"
]
28 0.33 ms
SELECT t0.id AS id_1, t0.brand_name AS brand_name_2, t0.brand_slug AS brand_slug_3, t0.fuel_name AS fuel_name_4, t0.fuel_slug AS fuel_slug_5, t0.category_name AS category_name_6, t0.category_slug AS category_slug_7, t0.model_name AS model_name_8, t0.model_slug AS model_slug_9, t0.version AS version_10, t0.displacement AS displacement_11, t0.power AS power_12, t0.drive AS drive_13, t0.average_consumption AS average_consumption_14, t0.emission AS emission_15, t0.sizes AS sizes_16, t0.capacity AS capacity_17, t0.seats AS seats_18, t0.doors AS doors_19, t0.gearbox AS gearbox_20, t0.gearbox_slug AS gearbox_slug_21 FROM car t0 WHERE t0.id IN (?)
Parameters:
[
  "1cb12255-80f7-4c93-92e4-cb794d95a26f"
]
29 0.38 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.deposit AS deposit_3, t0.duration AS duration_4, t0.distance AS distance_5, t0.offer_id AS offer_id_6 FROM offer_variation t0 WHERE t0.offer_id IN (?)
Parameters:
[
  "0d683ffc-a725-4b6c-bd31-49323a4de4a6"
]
30 0.36 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.alt AS alt_3, t0.src AS src_4, t0.original_src AS original_src_5, t0.ordering AS ordering_6, t0.car_id AS car_id_7 FROM car_image t0 WHERE t0.car_id IN (?) ORDER BY t0.ordering ASC
Parameters:
[
  "1cb12255-80f7-4c93-92e4-cb794d95a26f"
]
31 0.36 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.description AS description_4, t0.icon AS icon_5 FROM offer_service t0 INNER JOIN offer_service_relation ON t0.id = offer_service_relation.service_id WHERE offer_service_relation.offer_id = ?
Parameters:
[
  "d526d1ce-7523-4cdf-8d72-6ed5ece137a7"
]
32 0.35 ms
SELECT t0.id AS id_1, t0.brand_name AS brand_name_2, t0.brand_slug AS brand_slug_3, t0.fuel_name AS fuel_name_4, t0.fuel_slug AS fuel_slug_5, t0.category_name AS category_name_6, t0.category_slug AS category_slug_7, t0.model_name AS model_name_8, t0.model_slug AS model_slug_9, t0.version AS version_10, t0.displacement AS displacement_11, t0.power AS power_12, t0.drive AS drive_13, t0.average_consumption AS average_consumption_14, t0.emission AS emission_15, t0.sizes AS sizes_16, t0.capacity AS capacity_17, t0.seats AS seats_18, t0.doors AS doors_19, t0.gearbox AS gearbox_20, t0.gearbox_slug AS gearbox_slug_21 FROM car t0 WHERE t0.id IN (?)
Parameters:
[
  "c6e6a549-9245-4d91-bc6c-85891a688f7f"
]
33 0.28 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.deposit AS deposit_3, t0.duration AS duration_4, t0.distance AS distance_5, t0.offer_id AS offer_id_6 FROM offer_variation t0 WHERE t0.offer_id IN (?)
Parameters:
[
  "d526d1ce-7523-4cdf-8d72-6ed5ece137a7"
]
34 0.32 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.alt AS alt_3, t0.src AS src_4, t0.original_src AS original_src_5, t0.ordering AS ordering_6, t0.car_id AS car_id_7 FROM car_image t0 WHERE t0.car_id IN (?) ORDER BY t0.ordering ASC
Parameters:
[
  "c6e6a549-9245-4d91-bc6c-85891a688f7f"
]
35 0.36 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.description AS description_4, t0.icon AS icon_5 FROM offer_service t0 INNER JOIN offer_service_relation ON t0.id = offer_service_relation.service_id WHERE offer_service_relation.offer_id = ?
Parameters:
[
  "20f15b15-d92a-4e0d-90d8-e235223fd0ae"
]
36 0.34 ms
SELECT t0.id AS id_1, t0.brand_name AS brand_name_2, t0.brand_slug AS brand_slug_3, t0.fuel_name AS fuel_name_4, t0.fuel_slug AS fuel_slug_5, t0.category_name AS category_name_6, t0.category_slug AS category_slug_7, t0.model_name AS model_name_8, t0.model_slug AS model_slug_9, t0.version AS version_10, t0.displacement AS displacement_11, t0.power AS power_12, t0.drive AS drive_13, t0.average_consumption AS average_consumption_14, t0.emission AS emission_15, t0.sizes AS sizes_16, t0.capacity AS capacity_17, t0.seats AS seats_18, t0.doors AS doors_19, t0.gearbox AS gearbox_20, t0.gearbox_slug AS gearbox_slug_21 FROM car t0 WHERE t0.id IN (?)
Parameters:
[
  "0c7dfb1d-0400-4a5d-ab01-921b0b660b3d"
]
37 0.41 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.deposit AS deposit_3, t0.duration AS duration_4, t0.distance AS distance_5, t0.offer_id AS offer_id_6 FROM offer_variation t0 WHERE t0.offer_id IN (?)
Parameters:
[
  "20f15b15-d92a-4e0d-90d8-e235223fd0ae"
]
38 0.34 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.alt AS alt_3, t0.src AS src_4, t0.original_src AS original_src_5, t0.ordering AS ordering_6, t0.car_id AS car_id_7 FROM car_image t0 WHERE t0.car_id IN (?) ORDER BY t0.ordering ASC
Parameters:
[
  "0c7dfb1d-0400-4a5d-ab01-921b0b660b3d"
]
39 0.47 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.description AS description_4, t0.icon AS icon_5 FROM offer_service t0 INNER JOIN offer_service_relation ON t0.id = offer_service_relation.service_id WHERE offer_service_relation.offer_id = ?
Parameters:
[
  "413cdeb7-21bc-4671-bee7-4d4f0b20c6c2"
]
40 0.33 ms
SELECT t0.id AS id_1, t0.brand_name AS brand_name_2, t0.brand_slug AS brand_slug_3, t0.fuel_name AS fuel_name_4, t0.fuel_slug AS fuel_slug_5, t0.category_name AS category_name_6, t0.category_slug AS category_slug_7, t0.model_name AS model_name_8, t0.model_slug AS model_slug_9, t0.version AS version_10, t0.displacement AS displacement_11, t0.power AS power_12, t0.drive AS drive_13, t0.average_consumption AS average_consumption_14, t0.emission AS emission_15, t0.sizes AS sizes_16, t0.capacity AS capacity_17, t0.seats AS seats_18, t0.doors AS doors_19, t0.gearbox AS gearbox_20, t0.gearbox_slug AS gearbox_slug_21 FROM car t0 WHERE t0.id IN (?)
Parameters:
[
  "a61509f0-dd18-44ab-bcc7-7a8be34f14c8"
]
41 0.26 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.deposit AS deposit_3, t0.duration AS duration_4, t0.distance AS distance_5, t0.offer_id AS offer_id_6 FROM offer_variation t0 WHERE t0.offer_id IN (?)
Parameters:
[
  "413cdeb7-21bc-4671-bee7-4d4f0b20c6c2"
]
42 0.33 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.alt AS alt_3, t0.src AS src_4, t0.original_src AS original_src_5, t0.ordering AS ordering_6, t0.car_id AS car_id_7 FROM car_image t0 WHERE t0.car_id IN (?) ORDER BY t0.ordering ASC
Parameters:
[
  "a61509f0-dd18-44ab-bcc7-7a8be34f14c8"
]
43 0.61 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.description AS description_4, t0.icon AS icon_5 FROM offer_service t0 INNER JOIN offer_service_relation ON t0.id = offer_service_relation.service_id WHERE offer_service_relation.offer_id = ?
Parameters:
[
  "0a0b201a-7ffb-4862-9bd5-b04f3d37d1bd"
]
44 0.55 ms
SELECT t0.id AS id_1, t0.brand_name AS brand_name_2, t0.brand_slug AS brand_slug_3, t0.fuel_name AS fuel_name_4, t0.fuel_slug AS fuel_slug_5, t0.category_name AS category_name_6, t0.category_slug AS category_slug_7, t0.model_name AS model_name_8, t0.model_slug AS model_slug_9, t0.version AS version_10, t0.displacement AS displacement_11, t0.power AS power_12, t0.drive AS drive_13, t0.average_consumption AS average_consumption_14, t0.emission AS emission_15, t0.sizes AS sizes_16, t0.capacity AS capacity_17, t0.seats AS seats_18, t0.doors AS doors_19, t0.gearbox AS gearbox_20, t0.gearbox_slug AS gearbox_slug_21 FROM car t0 WHERE t0.id IN (?)
Parameters:
[
  "e1828db4-5e20-4c89-9b24-97285dfb2267"
]
45 0.66 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.deposit AS deposit_3, t0.duration AS duration_4, t0.distance AS distance_5, t0.offer_id AS offer_id_6 FROM offer_variation t0 WHERE t0.offer_id IN (?)
Parameters:
[
  "0a0b201a-7ffb-4862-9bd5-b04f3d37d1bd"
]
46 1.19 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.alt AS alt_3, t0.src AS src_4, t0.original_src AS original_src_5, t0.ordering AS ordering_6, t0.car_id AS car_id_7 FROM car_image t0 WHERE t0.car_id IN (?) ORDER BY t0.ordering ASC
Parameters:
[
  "e1828db4-5e20-4c89-9b24-97285dfb2267"
]
47 0.64 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.description AS description_4, t0.icon AS icon_5 FROM offer_service t0 INNER JOIN offer_service_relation ON t0.id = offer_service_relation.service_id WHERE offer_service_relation.offer_id = ?
Parameters:
[
  "2f8be7f4-a1b6-4427-8bf8-834e5777b33a"
]
48 0.48 ms
SELECT t0.id AS id_1, t0.brand_name AS brand_name_2, t0.brand_slug AS brand_slug_3, t0.fuel_name AS fuel_name_4, t0.fuel_slug AS fuel_slug_5, t0.category_name AS category_name_6, t0.category_slug AS category_slug_7, t0.model_name AS model_name_8, t0.model_slug AS model_slug_9, t0.version AS version_10, t0.displacement AS displacement_11, t0.power AS power_12, t0.drive AS drive_13, t0.average_consumption AS average_consumption_14, t0.emission AS emission_15, t0.sizes AS sizes_16, t0.capacity AS capacity_17, t0.seats AS seats_18, t0.doors AS doors_19, t0.gearbox AS gearbox_20, t0.gearbox_slug AS gearbox_slug_21 FROM car t0 WHERE t0.id IN (?)
Parameters:
[
  "1088bf69-5442-419f-bb50-c11aad99f0b5"
]
49 0.55 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.deposit AS deposit_3, t0.duration AS duration_4, t0.distance AS distance_5, t0.offer_id AS offer_id_6 FROM offer_variation t0 WHERE t0.offer_id IN (?)
Parameters:
[
  "2f8be7f4-a1b6-4427-8bf8-834e5777b33a"
]
50 0.66 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.alt AS alt_3, t0.src AS src_4, t0.original_src AS original_src_5, t0.ordering AS ordering_6, t0.car_id AS car_id_7 FROM car_image t0 WHERE t0.car_id IN (?) ORDER BY t0.ordering ASC
Parameters:
[
  "1088bf69-5442-419f-bb50-c11aad99f0b5"
]
51 0.52 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.description AS description_4, t0.icon AS icon_5 FROM offer_service t0 INNER JOIN offer_service_relation ON t0.id = offer_service_relation.service_id WHERE offer_service_relation.offer_id = ?
Parameters:
[
  "e8bf1649-177b-4c90-9d01-3da4a4c31c1e"
]
52 0.34 ms
SELECT t0.id AS id_1, t0.brand_name AS brand_name_2, t0.brand_slug AS brand_slug_3, t0.fuel_name AS fuel_name_4, t0.fuel_slug AS fuel_slug_5, t0.category_name AS category_name_6, t0.category_slug AS category_slug_7, t0.model_name AS model_name_8, t0.model_slug AS model_slug_9, t0.version AS version_10, t0.displacement AS displacement_11, t0.power AS power_12, t0.drive AS drive_13, t0.average_consumption AS average_consumption_14, t0.emission AS emission_15, t0.sizes AS sizes_16, t0.capacity AS capacity_17, t0.seats AS seats_18, t0.doors AS doors_19, t0.gearbox AS gearbox_20, t0.gearbox_slug AS gearbox_slug_21 FROM car t0 WHERE t0.id IN (?)
Parameters:
[
  "bca0e08c-daca-4954-a79f-03644df0bd92"
]
53 0.41 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.deposit AS deposit_3, t0.duration AS duration_4, t0.distance AS distance_5, t0.offer_id AS offer_id_6 FROM offer_variation t0 WHERE t0.offer_id IN (?)
Parameters:
[
  "e8bf1649-177b-4c90-9d01-3da4a4c31c1e"
]
54 0.42 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.alt AS alt_3, t0.src AS src_4, t0.original_src AS original_src_5, t0.ordering AS ordering_6, t0.car_id AS car_id_7 FROM car_image t0 WHERE t0.car_id IN (?) ORDER BY t0.ordering ASC
Parameters:
[
  "bca0e08c-daca-4954-a79f-03644df0bd92"
]
55 0.46 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.description AS description_4, t0.icon AS icon_5 FROM offer_service t0 INNER JOIN offer_service_relation ON t0.id = offer_service_relation.service_id WHERE offer_service_relation.offer_id = ?
Parameters:
[
  "e68d6904-5ca7-49b9-81e4-87ab5e05268c"
]
56 0.34 ms
SELECT t0.id AS id_1, t0.brand_name AS brand_name_2, t0.brand_slug AS brand_slug_3, t0.fuel_name AS fuel_name_4, t0.fuel_slug AS fuel_slug_5, t0.category_name AS category_name_6, t0.category_slug AS category_slug_7, t0.model_name AS model_name_8, t0.model_slug AS model_slug_9, t0.version AS version_10, t0.displacement AS displacement_11, t0.power AS power_12, t0.drive AS drive_13, t0.average_consumption AS average_consumption_14, t0.emission AS emission_15, t0.sizes AS sizes_16, t0.capacity AS capacity_17, t0.seats AS seats_18, t0.doors AS doors_19, t0.gearbox AS gearbox_20, t0.gearbox_slug AS gearbox_slug_21 FROM car t0 WHERE t0.id IN (?)
Parameters:
[
  "b16e3667-88f4-4e7b-a9c9-3eed6c22f3dc"
]
57 0.46 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.deposit AS deposit_3, t0.duration AS duration_4, t0.distance AS distance_5, t0.offer_id AS offer_id_6 FROM offer_variation t0 WHERE t0.offer_id IN (?)
Parameters:
[
  "e68d6904-5ca7-49b9-81e4-87ab5e05268c"
]
58 0.40 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.alt AS alt_3, t0.src AS src_4, t0.original_src AS original_src_5, t0.ordering AS ordering_6, t0.car_id AS car_id_7 FROM car_image t0 WHERE t0.car_id IN (?) ORDER BY t0.ordering ASC
Parameters:
[
  "b16e3667-88f4-4e7b-a9c9-3eed6c22f3dc"
]
59 0.46 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.description AS description_4, t0.icon AS icon_5 FROM offer_service t0 INNER JOIN offer_service_relation ON t0.id = offer_service_relation.service_id WHERE offer_service_relation.offer_id = ?
Parameters:
[
  "f5fef2d9-1748-471a-8843-4e7a5481c1af"
]
60 0.30 ms
SELECT t0.id AS id_1, t0.brand_name AS brand_name_2, t0.brand_slug AS brand_slug_3, t0.fuel_name AS fuel_name_4, t0.fuel_slug AS fuel_slug_5, t0.category_name AS category_name_6, t0.category_slug AS category_slug_7, t0.model_name AS model_name_8, t0.model_slug AS model_slug_9, t0.version AS version_10, t0.displacement AS displacement_11, t0.power AS power_12, t0.drive AS drive_13, t0.average_consumption AS average_consumption_14, t0.emission AS emission_15, t0.sizes AS sizes_16, t0.capacity AS capacity_17, t0.seats AS seats_18, t0.doors AS doors_19, t0.gearbox AS gearbox_20, t0.gearbox_slug AS gearbox_slug_21 FROM car t0 WHERE t0.id IN (?)
Parameters:
[
  "290ebfb3-53ec-4f7a-a6c9-c36a7dd4fa2c"
]
61 0.39 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.deposit AS deposit_3, t0.duration AS duration_4, t0.distance AS distance_5, t0.offer_id AS offer_id_6 FROM offer_variation t0 WHERE t0.offer_id IN (?)
Parameters:
[
  "f5fef2d9-1748-471a-8843-4e7a5481c1af"
]
62 0.35 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.alt AS alt_3, t0.src AS src_4, t0.original_src AS original_src_5, t0.ordering AS ordering_6, t0.car_id AS car_id_7 FROM car_image t0 WHERE t0.car_id IN (?) ORDER BY t0.ordering ASC
Parameters:
[
  "290ebfb3-53ec-4f7a-a6c9-c36a7dd4fa2c"
]
63 0.38 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.description AS description_4, t0.icon AS icon_5 FROM offer_service t0 INNER JOIN offer_service_relation ON t0.id = offer_service_relation.service_id WHERE offer_service_relation.offer_id = ?
Parameters:
[
  "c946d7d1-208a-4c8e-a1a2-6dcd9f212f51"
]
64 0.28 ms
SELECT t0.id AS id_1, t0.brand_name AS brand_name_2, t0.brand_slug AS brand_slug_3, t0.fuel_name AS fuel_name_4, t0.fuel_slug AS fuel_slug_5, t0.category_name AS category_name_6, t0.category_slug AS category_slug_7, t0.model_name AS model_name_8, t0.model_slug AS model_slug_9, t0.version AS version_10, t0.displacement AS displacement_11, t0.power AS power_12, t0.drive AS drive_13, t0.average_consumption AS average_consumption_14, t0.emission AS emission_15, t0.sizes AS sizes_16, t0.capacity AS capacity_17, t0.seats AS seats_18, t0.doors AS doors_19, t0.gearbox AS gearbox_20, t0.gearbox_slug AS gearbox_slug_21 FROM car t0 WHERE t0.id IN (?)
Parameters:
[
  "24f3fecd-5680-43a5-8e79-4758e27f988f"
]
65 0.51 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.deposit AS deposit_3, t0.duration AS duration_4, t0.distance AS distance_5, t0.offer_id AS offer_id_6 FROM offer_variation t0 WHERE t0.offer_id IN (?)
Parameters:
[
  "c946d7d1-208a-4c8e-a1a2-6dcd9f212f51"
]
66 0.43 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.alt AS alt_3, t0.src AS src_4, t0.original_src AS original_src_5, t0.ordering AS ordering_6, t0.car_id AS car_id_7 FROM car_image t0 WHERE t0.car_id IN (?) ORDER BY t0.ordering ASC
Parameters:
[
  "24f3fecd-5680-43a5-8e79-4758e27f988f"
]
67 0.42 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.description AS description_4, t0.icon AS icon_5 FROM offer_service t0 INNER JOIN offer_service_relation ON t0.id = offer_service_relation.service_id WHERE offer_service_relation.offer_id = ?
Parameters:
[
  "f7bc06ad-b9d8-4bbf-8ba4-e53cc57da8d0"
]
68 0.28 ms
SELECT t0.id AS id_1, t0.brand_name AS brand_name_2, t0.brand_slug AS brand_slug_3, t0.fuel_name AS fuel_name_4, t0.fuel_slug AS fuel_slug_5, t0.category_name AS category_name_6, t0.category_slug AS category_slug_7, t0.model_name AS model_name_8, t0.model_slug AS model_slug_9, t0.version AS version_10, t0.displacement AS displacement_11, t0.power AS power_12, t0.drive AS drive_13, t0.average_consumption AS average_consumption_14, t0.emission AS emission_15, t0.sizes AS sizes_16, t0.capacity AS capacity_17, t0.seats AS seats_18, t0.doors AS doors_19, t0.gearbox AS gearbox_20, t0.gearbox_slug AS gearbox_slug_21 FROM car t0 WHERE t0.id IN (?)
Parameters:
[
  "5b4ef5b6-1a06-4ffa-9528-9d85a137e6fa"
]
69 0.27 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.deposit AS deposit_3, t0.duration AS duration_4, t0.distance AS distance_5, t0.offer_id AS offer_id_6 FROM offer_variation t0 WHERE t0.offer_id IN (?)
Parameters:
[
  "f7bc06ad-b9d8-4bbf-8ba4-e53cc57da8d0"
]
70 0.31 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.alt AS alt_3, t0.src AS src_4, t0.original_src AS original_src_5, t0.ordering AS ordering_6, t0.car_id AS car_id_7 FROM car_image t0 WHERE t0.car_id IN (?) ORDER BY t0.ordering ASC
Parameters:
[
  "5b4ef5b6-1a06-4ffa-9528-9d85a137e6fa"
]
71 0.32 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.description AS description_4, t0.icon AS icon_5 FROM offer_service t0 INNER JOIN offer_service_relation ON t0.id = offer_service_relation.service_id WHERE offer_service_relation.offer_id = ?
Parameters:
[
  "631cd343-5b73-40b5-83e0-034e0ce80a20"
]
72 0.26 ms
SELECT t0.id AS id_1, t0.brand_name AS brand_name_2, t0.brand_slug AS brand_slug_3, t0.fuel_name AS fuel_name_4, t0.fuel_slug AS fuel_slug_5, t0.category_name AS category_name_6, t0.category_slug AS category_slug_7, t0.model_name AS model_name_8, t0.model_slug AS model_slug_9, t0.version AS version_10, t0.displacement AS displacement_11, t0.power AS power_12, t0.drive AS drive_13, t0.average_consumption AS average_consumption_14, t0.emission AS emission_15, t0.sizes AS sizes_16, t0.capacity AS capacity_17, t0.seats AS seats_18, t0.doors AS doors_19, t0.gearbox AS gearbox_20, t0.gearbox_slug AS gearbox_slug_21 FROM car t0 WHERE t0.id IN (?)
Parameters:
[
  "58823939-bb94-48ac-90f4-10bb5c4387c1"
]
73 0.31 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.deposit AS deposit_3, t0.duration AS duration_4, t0.distance AS distance_5, t0.offer_id AS offer_id_6 FROM offer_variation t0 WHERE t0.offer_id IN (?)
Parameters:
[
  "631cd343-5b73-40b5-83e0-034e0ce80a20"
]
74 0.33 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.alt AS alt_3, t0.src AS src_4, t0.original_src AS original_src_5, t0.ordering AS ordering_6, t0.car_id AS car_id_7 FROM car_image t0 WHERE t0.car_id IN (?) ORDER BY t0.ordering ASC
Parameters:
[
  "58823939-bb94-48ac-90f4-10bb5c4387c1"
]
75 0.34 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.description AS description_4, t0.icon AS icon_5 FROM offer_service t0 INNER JOIN offer_service_relation ON t0.id = offer_service_relation.service_id WHERE offer_service_relation.offer_id = ?
Parameters:
[
  "b4c833f2-3277-4437-92ac-a12456a1b25a"
]
76 0.27 ms
SELECT t0.id AS id_1, t0.brand_name AS brand_name_2, t0.brand_slug AS brand_slug_3, t0.fuel_name AS fuel_name_4, t0.fuel_slug AS fuel_slug_5, t0.category_name AS category_name_6, t0.category_slug AS category_slug_7, t0.model_name AS model_name_8, t0.model_slug AS model_slug_9, t0.version AS version_10, t0.displacement AS displacement_11, t0.power AS power_12, t0.drive AS drive_13, t0.average_consumption AS average_consumption_14, t0.emission AS emission_15, t0.sizes AS sizes_16, t0.capacity AS capacity_17, t0.seats AS seats_18, t0.doors AS doors_19, t0.gearbox AS gearbox_20, t0.gearbox_slug AS gearbox_slug_21 FROM car t0 WHERE t0.id IN (?)
Parameters:
[
  "ac8ee36d-ba0a-4798-bea8-d88be2228038"
]
77 0.32 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.deposit AS deposit_3, t0.duration AS duration_4, t0.distance AS distance_5, t0.offer_id AS offer_id_6 FROM offer_variation t0 WHERE t0.offer_id IN (?)
Parameters:
[
  "b4c833f2-3277-4437-92ac-a12456a1b25a"
]
78 0.28 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.alt AS alt_3, t0.src AS src_4, t0.original_src AS original_src_5, t0.ordering AS ordering_6, t0.car_id AS car_id_7 FROM car_image t0 WHERE t0.car_id IN (?) ORDER BY t0.ordering ASC
Parameters:
[
  "ac8ee36d-ba0a-4798-bea8-d88be2228038"
]
79 0.29 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.description AS description_4, t0.icon AS icon_5 FROM offer_service t0 INNER JOIN offer_service_relation ON t0.id = offer_service_relation.service_id WHERE offer_service_relation.offer_id = ?
Parameters:
[
  "fa0deb91-9512-4058-b1bd-145269aec9e8"
]
80 0.24 ms
SELECT t0.id AS id_1, t0.brand_name AS brand_name_2, t0.brand_slug AS brand_slug_3, t0.fuel_name AS fuel_name_4, t0.fuel_slug AS fuel_slug_5, t0.category_name AS category_name_6, t0.category_slug AS category_slug_7, t0.model_name AS model_name_8, t0.model_slug AS model_slug_9, t0.version AS version_10, t0.displacement AS displacement_11, t0.power AS power_12, t0.drive AS drive_13, t0.average_consumption AS average_consumption_14, t0.emission AS emission_15, t0.sizes AS sizes_16, t0.capacity AS capacity_17, t0.seats AS seats_18, t0.doors AS doors_19, t0.gearbox AS gearbox_20, t0.gearbox_slug AS gearbox_slug_21 FROM car t0 WHERE t0.id IN (?)
Parameters:
[
  "b58e5f45-626c-4b6b-aea0-be8328a5e365"
]
81 0.24 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.deposit AS deposit_3, t0.duration AS duration_4, t0.distance AS distance_5, t0.offer_id AS offer_id_6 FROM offer_variation t0 WHERE t0.offer_id IN (?)
Parameters:
[
  "fa0deb91-9512-4058-b1bd-145269aec9e8"
]
82 0.25 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.alt AS alt_3, t0.src AS src_4, t0.original_src AS original_src_5, t0.ordering AS ordering_6, t0.car_id AS car_id_7 FROM car_image t0 WHERE t0.car_id IN (?) ORDER BY t0.ordering ASC
Parameters:
[
  "b58e5f45-626c-4b6b-aea0-be8328a5e365"
]
83 0.31 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.description AS description_4, t0.icon AS icon_5 FROM offer_service t0 INNER JOIN offer_service_relation ON t0.id = offer_service_relation.service_id WHERE offer_service_relation.offer_id = ?
Parameters:
[
  "547c7704-a973-4f49-967a-3d8229dacff8"
]
84 0.25 ms
SELECT t0.id AS id_1, t0.brand_name AS brand_name_2, t0.brand_slug AS brand_slug_3, t0.fuel_name AS fuel_name_4, t0.fuel_slug AS fuel_slug_5, t0.category_name AS category_name_6, t0.category_slug AS category_slug_7, t0.model_name AS model_name_8, t0.model_slug AS model_slug_9, t0.version AS version_10, t0.displacement AS displacement_11, t0.power AS power_12, t0.drive AS drive_13, t0.average_consumption AS average_consumption_14, t0.emission AS emission_15, t0.sizes AS sizes_16, t0.capacity AS capacity_17, t0.seats AS seats_18, t0.doors AS doors_19, t0.gearbox AS gearbox_20, t0.gearbox_slug AS gearbox_slug_21 FROM car t0 WHERE t0.id IN (?)
Parameters:
[
  "45ad2d9b-626a-4694-a104-da12143f7a90"
]
85 0.30 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.deposit AS deposit_3, t0.duration AS duration_4, t0.distance AS distance_5, t0.offer_id AS offer_id_6 FROM offer_variation t0 WHERE t0.offer_id IN (?)
Parameters:
[
  "547c7704-a973-4f49-967a-3d8229dacff8"
]
86 0.33 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.alt AS alt_3, t0.src AS src_4, t0.original_src AS original_src_5, t0.ordering AS ordering_6, t0.car_id AS car_id_7 FROM car_image t0 WHERE t0.car_id IN (?) ORDER BY t0.ordering ASC
Parameters:
[
  "45ad2d9b-626a-4694-a104-da12143f7a90"
]
87 0.42 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.description AS description_4, t0.icon AS icon_5 FROM offer_service t0 INNER JOIN offer_service_relation ON t0.id = offer_service_relation.service_id WHERE offer_service_relation.offer_id = ?
Parameters:
[
  "86da97b4-f34a-4196-aac2-1a394ba6232e"
]
88 0.25 ms
SELECT t0.id AS id_1, t0.brand_name AS brand_name_2, t0.brand_slug AS brand_slug_3, t0.fuel_name AS fuel_name_4, t0.fuel_slug AS fuel_slug_5, t0.category_name AS category_name_6, t0.category_slug AS category_slug_7, t0.model_name AS model_name_8, t0.model_slug AS model_slug_9, t0.version AS version_10, t0.displacement AS displacement_11, t0.power AS power_12, t0.drive AS drive_13, t0.average_consumption AS average_consumption_14, t0.emission AS emission_15, t0.sizes AS sizes_16, t0.capacity AS capacity_17, t0.seats AS seats_18, t0.doors AS doors_19, t0.gearbox AS gearbox_20, t0.gearbox_slug AS gearbox_slug_21 FROM car t0 WHERE t0.id IN (?)
Parameters:
[
  "10c2fd39-5525-45df-97c3-a200b238455e"
]
89 0.33 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.deposit AS deposit_3, t0.duration AS duration_4, t0.distance AS distance_5, t0.offer_id AS offer_id_6 FROM offer_variation t0 WHERE t0.offer_id IN (?)
Parameters:
[
  "86da97b4-f34a-4196-aac2-1a394ba6232e"
]
90 0.34 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.alt AS alt_3, t0.src AS src_4, t0.original_src AS original_src_5, t0.ordering AS ordering_6, t0.car_id AS car_id_7 FROM car_image t0 WHERE t0.car_id IN (?) ORDER BY t0.ordering ASC
Parameters:
[
  "10c2fd39-5525-45df-97c3-a200b238455e"
]
91 0.39 ms
SELECT MIN(o0_.price) AS sclr_0 FROM offer o0_ WHERE o0_.published = 1
Parameters:
[]
92 0.30 ms
SELECT MAX(o0_.price) AS sclr_0 FROM offer o0_ WHERE o0_.published = 1
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.