Symfony Profiler

[
  "route" => "frontend_search"
  "route_parameters" => [
    "_route" => "frontend_search"
    "_controller" => "App\Infrastructure\Controller\FrontendController::search"
  ]
  "request_uri" => "https://dev.vaigo.it/ricerca?category=%27city-car%27"
  "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 c1_.category_slug IN ('city-car') 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 => "0985d3c8-24c1-4516-92ba-4cfd60a2cccf"
  ]
  "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 => "687073dc-7e75-410c-a371-b07ab79bb0c2"
  ]
  "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 => "0985d3c8-24c1-4516-92ba-4cfd60a2cccf"
  ]
  "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 => "687073dc-7e75-410c-a371-b07ab79bb0c2"
  ]
  "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 => "81f598d8-1bf8-4f5b-a9c9-7407a1fb179e"
  ]
  "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 => "3f86d4a6-2eab-49bd-9d19-3ba53e2d4ac0"
  ]
  "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 => "81f598d8-1bf8-4f5b-a9c9-7407a1fb179e"
  ]
  "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 => "3f86d4a6-2eab-49bd-9d19-3ba53e2d4ac0"
  ]
  "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 => "0d683ffc-a725-4b6c-bd31-49323a4de4a6"
  ]
  "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 => "1cb12255-80f7-4c93-92e4-cb794d95a26f"
  ]
  "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 => "0d683ffc-a725-4b6c-bd31-49323a4de4a6"
  ]
  "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 => "1cb12255-80f7-4c93-92e4-cb794d95a26f"
  ]
  "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 => "20f15b15-d92a-4e0d-90d8-e235223fd0ae"
  ]
  "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 => "0c7dfb1d-0400-4a5d-ab01-921b0b660b3d"
  ]
  "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 => "20f15b15-d92a-4e0d-90d8-e235223fd0ae"
  ]
  "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 => "0c7dfb1d-0400-4a5d-ab01-921b0b660b3d"
  ]
  "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 => "0a0b201a-7ffb-4862-9bd5-b04f3d37d1bd"
  ]
  "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 => "e1828db4-5e20-4c89-9b24-97285dfb2267"
  ]
  "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 => "0a0b201a-7ffb-4862-9bd5-b04f3d37d1bd"
  ]
  "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 => "e1828db4-5e20-4c89-9b24-97285dfb2267"
  ]
  "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 => "2f8be7f4-a1b6-4427-8bf8-834e5777b33a"
  ]
  "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 => "1088bf69-5442-419f-bb50-c11aad99f0b5"
  ]
  "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 => "2f8be7f4-a1b6-4427-8bf8-834e5777b33a"
  ]
  "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 => "1088bf69-5442-419f-bb50-c11aad99f0b5"
  ]
  "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 => "e8bf1649-177b-4c90-9d01-3da4a4c31c1e"
  ]
  "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 => "bca0e08c-daca-4954-a79f-03644df0bd92"
  ]
  "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 => "e8bf1649-177b-4c90-9d01-3da4a4c31c1e"
  ]
  "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 => "bca0e08c-daca-4954-a79f-03644df0bd92"
  ]
  "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 => "e68d6904-5ca7-49b9-81e4-87ab5e05268c"
  ]
  "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 => "b16e3667-88f4-4e7b-a9c9-3eed6c22f3dc"
  ]
  "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 => "e68d6904-5ca7-49b9-81e4-87ab5e05268c"
  ]
  "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 => "b16e3667-88f4-4e7b-a9c9-3eed6c22f3dc"
  ]
  "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 => "f5fef2d9-1748-471a-8843-4e7a5481c1af"
  ]
  "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 => "290ebfb3-53ec-4f7a-a6c9-c36a7dd4fa2c"
  ]
  "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 => "f5fef2d9-1748-471a-8843-4e7a5481c1af"
  ]
  "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 => "290ebfb3-53ec-4f7a-a6c9-c36a7dd4fa2c"
  ]
  "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 => "c946d7d1-208a-4c8e-a1a2-6dcd9f212f51"
  ]
  "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 => "24f3fecd-5680-43a5-8e79-4758e27f988f"
  ]
  "types" => [
    1 => 2
  ]
]