Query Metrics
60
Database Queries
12
Different statements
32.22 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.66 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.02 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 | 1.42 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.40 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.32 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 | 1.74 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.67 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.42 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.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:
[
"d1706eef-50a6-4d68-adfa-13fec982d8fa"
]
|
| 10 | 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:
[
"47c04a6f-128f-4c30-aaec-0b60a7081568"
]
|
| 11 | 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:
[
"bcc6ed0a-4eb2-4f44-8f7b-642a2f666eee"
]
|
| 12 | 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:
[
"cb8fd8f2-33a1-4c63-b052-ecd3ed08a838"
]
|
| 13 | 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:
[
"bcc6ed0a-4eb2-4f44-8f7b-642a2f666eee"
]
|
| 14 | 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:
[
"cb8fd8f2-33a1-4c63-b052-ecd3ed08a838"
]
|
| 15 | 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:
[
"3a2d2d1d-55ba-4071-959d-dcf125e4bf43"
]
|
| 16 | 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:
[
"e228bcb1-b496-469e-a3f1-0eda07f83848"
]
|
| 17 | 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:
[
"3a2d2d1d-55ba-4071-959d-dcf125e4bf43"
]
|
| 18 | 0.38 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.51 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.40 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.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:
[
"e37749f0-2084-4acb-be07-53bfa873d6d2"
]
|
| 22 | 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:
[
"ff0bc158-259f-4ce5-82a0-5d0192a95a5b"
]
|
| 23 | 0.53 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.73 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.72 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.55 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.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:
[
"9c23d591-5c12-4fc8-9454-790e399ab303"
]
|
| 28 | 0.43 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.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:
[
"9c23d591-5c12-4fc8-9454-790e399ab303"
]
|
| 30 | 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:
[
"b7d397a5-78c9-4ee1-abb2-7b7cb53cfcbb"
]
|
| 31 | 0.74 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.57 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.57 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.46 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.60 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.44 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.53 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.44 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.58 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.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:
[
"acb25428-7da2-4339-a1de-32abea326160"
]
|
| 41 | 0.35 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.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:
[
"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.32 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.44 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.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:
[
"a45e6db0-2cf0-4136-87e0-06b92e518343"
]
|
| 48 | 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:
[
"e6c6b398-7636-453f-952c-a41887603bbf"
]
|
| 49 | 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:
[
"a45e6db0-2cf0-4136-87e0-06b92e518343"
]
|
| 50 | 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:
[
"e6c6b398-7636-453f-952c-a41887603bbf"
]
|
| 51 | 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:
[
"89e5cbd0-b659-4355-a50f-c92cba65dd1e"
]
|
| 52 | 0.32 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.35 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.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:
[
"558c20e6-b577-45a4-b867-a407f4992a27"
]
|
| 55 | 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:
[
"f1249ebb-6f24-413d-aa34-2414d8e3cc57"
]
|
| 56 | 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:
[
"f5f28ffe-d801-4943-8e18-44aabe9be606"
]
|
| 57 | 0.34 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.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:
[
"f5f28ffe-d801-4943-8e18-44aabe9be606"
]
|
| 59 | 0.37 ms |
SELECT MIN(o0_.price) AS sclr_0 FROM offer o0_ WHERE o0_.published = 1
Parameters:
[] |
| 60 | 0.33 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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Domain\Offer\Entity\Offer | No errors. |
| App\Domain\Offer\Entity\Car | No errors. |
| App\Domain\Offer\Entity\Variation | No errors. |
| App\Domain\Offer\Entity\Service | No errors. |
| App\Domain\Offer\Entity\CarImage | No errors. |