GET https://dev.vaigo.it/ricerca?category=%27veicoli-commerciali%27

Query Metrics

60 Database Queries
12 Different statements
35.78 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 2.49 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.38 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.15 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 1.94 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 2.11 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.15 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 ('veicoli-commerciali') ORDER BY o0_.priority DESC, o0_.price ASC
Parameters:
[]
7 0.73 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:
[
  "d1706eef-50a6-4d68-adfa-13fec982d8fa"
]
8 0.41 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:
[
  "47c04a6f-128f-4c30-aaec-0b60a7081568"
]
9 0.43 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:
[
  "d1706eef-50a6-4d68-adfa-13fec982d8fa"
]
10 0.41 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:
[
  "47c04a6f-128f-4c30-aaec-0b60a7081568"
]
11 0.40 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:
[
  "bcc6ed0a-4eb2-4f44-8f7b-642a2f666eee"
]
12 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:
[
  "cb8fd8f2-33a1-4c63-b052-ecd3ed08a838"
]
13 0.47 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:
[
  "bcc6ed0a-4eb2-4f44-8f7b-642a2f666eee"
]
14 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:
[
  "cb8fd8f2-33a1-4c63-b052-ecd3ed08a838"
]
15 0.37 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:
[
  "3a2d2d1d-55ba-4071-959d-dcf125e4bf43"
]
16 0.31 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:
[
  "e228bcb1-b496-469e-a3f1-0eda07f83848"
]
17 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:
[
  "3a2d2d1d-55ba-4071-959d-dcf125e4bf43"
]
18 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:
[
  "e228bcb1-b496-469e-a3f1-0eda07f83848"
]
19 0.41 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:
[
  "e37749f0-2084-4acb-be07-53bfa873d6d2"
]
20 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:
[
  "ff0bc158-259f-4ce5-82a0-5d0192a95a5b"
]
21 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:
[
  "e37749f0-2084-4acb-be07-53bfa873d6d2"
]
22 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:
[
  "ff0bc158-259f-4ce5-82a0-5d0192a95a5b"
]
23 0.37 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:
[
  "8a09b9ee-1e0a-44f3-8c31-1265646a3550"
]
24 0.31 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:
[
  "6191e20a-38e8-4391-b2d3-7efcb1998e38"
]
25 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:
[
  "8a09b9ee-1e0a-44f3-8c31-1265646a3550"
]
26 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:
[
  "6191e20a-38e8-4391-b2d3-7efcb1998e38"
]
27 0.40 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:
[
  "9c23d591-5c12-4fc8-9454-790e399ab303"
]
28 0.38 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:
[
  "b7d397a5-78c9-4ee1-abb2-7b7cb53cfcbb"
]
29 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:
[
  "9c23d591-5c12-4fc8-9454-790e399ab303"
]
30 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:
[
  "b7d397a5-78c9-4ee1-abb2-7b7cb53cfcbb"
]
31 0.43 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:
[
  "6f68c179-6260-4cee-9e58-b9f4d6ddc417"
]
32 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:
[
  "be0b1e39-6357-4bac-822c-f158d59ed7d4"
]
33 0.45 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:
[
  "6f68c179-6260-4cee-9e58-b9f4d6ddc417"
]
34 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:
[
  "be0b1e39-6357-4bac-822c-f158d59ed7d4"
]
35 0.41 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:
[
  "e8cb79ca-c6dc-4598-9d8c-bf42c8c597d0"
]
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:
[
  "023b6337-491f-4c62-9333-5cbe2dd2fab1"
]
37 0.48 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:
[
  "e8cb79ca-c6dc-4598-9d8c-bf42c8c597d0"
]
38 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:
[
  "023b6337-491f-4c62-9333-5cbe2dd2fab1"
]
39 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:
[
  "5c976ddb-e675-4bec-9206-7c88d26ad829"
]
40 0.38 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:
[
  "acb25428-7da2-4339-a1de-32abea326160"
]
41 0.36 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:
[
  "5c976ddb-e675-4bec-9206-7c88d26ad829"
]
42 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:
[
  "acb25428-7da2-4339-a1de-32abea326160"
]
43 0.40 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:
[
  "591bf67a-7299-42e4-857f-420b9a680b94"
]
44 0.37 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:
[
  "e7c83050-68b1-44a6-9cf8-338d621b26e5"
]
45 0.43 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:
[
  "591bf67a-7299-42e4-857f-420b9a680b94"
]
46 0.37 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:
[
  "e7c83050-68b1-44a6-9cf8-338d621b26e5"
]
47 0.80 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:
[
  "a45e6db0-2cf0-4136-87e0-06b92e518343"
]
48 0.60 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:
[
  "e6c6b398-7636-453f-952c-a41887603bbf"
]
49 0.67 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:
[
  "a45e6db0-2cf0-4136-87e0-06b92e518343"
]
50 0.53 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:
[
  "e6c6b398-7636-453f-952c-a41887603bbf"
]
51 0.65 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:
[
  "89e5cbd0-b659-4355-a50f-c92cba65dd1e"
]
52 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:
[
  "558c20e6-b577-45a4-b867-a407f4992a27"
]
53 0.56 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:
[
  "89e5cbd0-b659-4355-a50f-c92cba65dd1e"
]
54 0.49 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:
[
  "558c20e6-b577-45a4-b867-a407f4992a27"
]
55 0.59 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:
[
  "f1249ebb-6f24-413d-aa34-2414d8e3cc57"
]
56 0.39 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:
[
  "f5f28ffe-d801-4943-8e18-44aabe9be606"
]
57 0.63 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:
[
  "f1249ebb-6f24-413d-aa34-2414d8e3cc57"
]
58 0.45 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:
[
  "f5f28ffe-d801-4943-8e18-44aabe9be606"
]
59 0.69 ms
SELECT MIN(o0_.price) AS sclr_0 FROM offer o0_ WHERE o0_.published = 1
Parameters:
[]
60 0.56 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.