Symfony Profiler

[
  "route" => "frontend_search"
  "route_parameters" => [
    "_route" => "frontend_search"
    "_controller" => "App\Infrastructure\Controller\FrontendController::search"
  ]
  "request_uri" => "https://dev.vaigo.it/ricerca?options=%27private%27&page_title=Privati"
  "method" => "GET"
]

[
  "firewall_name" => "main"
  "authenticators" => 2
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\FormLoginAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\FormLoginAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\RememberMeAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\RememberMeAuthenticator"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\FragmentListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelRequest"
]

[
  "event" => "kernel.controller"
  "listener" => "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "ContainerRwxhccv\RequestPayloadValueResolverGhost3590451::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "leonori_dev_us"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "leonori_dev"
    "serverVersion" => "mariadb-10.5.17"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "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"
]

[
  "sql" => "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"
]

[
  "sql" => "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"
]

[
  "sql" => "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"
]

[
  "sql" => "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"
]

[
  "sql" => "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 o0_.private = 1 ORDER BY o0_.priority DESC, o0_.price ASC"
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "732890cc-f77c-4662-8b17-51951f3637a7"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 (?)"
  "params" => [
    1 => "54774b70-470a-4f37-b9f1-ba45c4892164"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 (?)"
  "params" => [
    1 => "732890cc-f77c-4662-8b17-51951f3637a7"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "54774b70-470a-4f37-b9f1-ba45c4892164"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "651dc9d1-31d3-4df7-8c08-4c52d0b94b87"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 (?)"
  "params" => [
    1 => "3f581753-276c-462d-9289-86ed7de03c79"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 (?)"
  "params" => [
    1 => "651dc9d1-31d3-4df7-8c08-4c52d0b94b87"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "3f581753-276c-462d-9289-86ed7de03c79"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "4d60279e-6fb5-456c-a901-73271c123eeb"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 (?)"
  "params" => [
    1 => "1c5b32aa-e029-4dd1-bd3e-7c03beb52b00"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 (?)"
  "params" => [
    1 => "4d60279e-6fb5-456c-a901-73271c123eeb"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "1c5b32aa-e029-4dd1-bd3e-7c03beb52b00"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "b409128e-b115-486f-84a1-63f27fb66250"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 (?)"
  "params" => [
    1 => "7e96092b-aa5c-494d-983b-3c847dc46fd3"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 (?)"
  "params" => [
    1 => "b409128e-b115-486f-84a1-63f27fb66250"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "7e96092b-aa5c-494d-983b-3c847dc46fd3"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "d526d1ce-7523-4cdf-8d72-6ed5ece137a7"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 (?)"
  "params" => [
    1 => "c6e6a549-9245-4d91-bc6c-85891a688f7f"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 (?)"
  "params" => [
    1 => "d526d1ce-7523-4cdf-8d72-6ed5ece137a7"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "c6e6a549-9245-4d91-bc6c-85891a688f7f"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "5030a390-8d9c-4cf6-8d67-8851dba13bc5"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 (?)"
  "params" => [
    1 => "7ec5218d-f6eb-4c3f-b093-02b197d84f20"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 (?)"
  "params" => [
    1 => "5030a390-8d9c-4cf6-8d67-8851dba13bc5"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "7ec5218d-f6eb-4c3f-b093-02b197d84f20"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "266ea71b-414d-40e6-8f2c-5fdae3266ac8"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 (?)"
  "params" => [
    1 => "2d105921-0bce-4c9e-92ea-4a726c8590b2"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 (?)"
  "params" => [
    1 => "266ea71b-414d-40e6-8f2c-5fdae3266ac8"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "2d105921-0bce-4c9e-92ea-4a726c8590b2"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "8ddf8c85-298d-4cd2-8d3d-531ad77cfef9"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 (?)"
  "params" => [
    1 => "95eb67e4-eb5a-41c0-9fca-5fc57a0ba124"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 (?)"
  "params" => [
    1 => "8ddf8c85-298d-4cd2-8d3d-531ad77cfef9"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "95eb67e4-eb5a-41c0-9fca-5fc57a0ba124"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "2eb2f038-bfbd-43f4-93ba-840bf157043c"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 (?)"
  "params" => [
    1 => "b415d7dd-833e-4e06-b60f-27427a09788e"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 (?)"
  "params" => [
    1 => "2eb2f038-bfbd-43f4-93ba-840bf157043c"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "b415d7dd-833e-4e06-b60f-27427a09788e"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "413cdeb7-21bc-4671-bee7-4d4f0b20c6c2"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 (?)"
  "params" => [
    1 => "a61509f0-dd18-44ab-bcc7-7a8be34f14c8"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 (?)"
  "params" => [
    1 => "413cdeb7-21bc-4671-bee7-4d4f0b20c6c2"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "a61509f0-dd18-44ab-bcc7-7a8be34f14c8"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "5ea7d844-a192-43e1-925f-ec7bcf7376d5"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 (?)"
  "params" => [
    1 => "138e943b-b045-481d-9467-55ce0b3b4332"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 (?)"
  "params" => [
    1 => "5ea7d844-a192-43e1-925f-ec7bcf7376d5"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "138e943b-b045-481d-9467-55ce0b3b4332"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "39e5bca8-6aa1-490a-a8be-b97a7babb7e4"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 (?)"
  "params" => [
    1 => "0a82da10-124f-424f-80b7-5e2898657480"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 (?)"
  "params" => [
    1 => "39e5bca8-6aa1-490a-a8be-b97a7babb7e4"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "0a82da10-124f-424f-80b7-5e2898657480"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "6e44309b-6ffe-4e5e-bf7a-e3db36ee0433"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 (?)"
  "params" => [
    1 => "f63cfff4-f0b5-4a02-a7e8-03b72a93496f"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 (?)"
  "params" => [
    1 => "6e44309b-6ffe-4e5e-bf7a-e3db36ee0433"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "f63cfff4-f0b5-4a02-a7e8-03b72a93496f"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "b6ac5eba-908b-46fc-96dc-8cae5bf4d608"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 (?)"
  "params" => [
    1 => "7e468f54-0dca-455d-91cd-ccd91dbd34fa"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 (?)"
  "params" => [
    1 => "b6ac5eba-908b-46fc-96dc-8cae5bf4d608"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "7e468f54-0dca-455d-91cd-ccd91dbd34fa"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "fb16d9af-3cde-41ca-8533-2c45172c3f93"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 (?)"
  "params" => [
    1 => "0d4dbb32-a06b-480d-a6f6-7295c87af208"
  ]
  "types" => [
    1 => 2
  ]
]