Symfony Profiler

[
  "route" => "app_device_model_detail"
  "route_parameters" => [
    "_route" => "app_device_model_detail"
    "_controller" => "App\Controller\StorefrontController::deviceModelDetail"
    "id" => "16"
  ]
  "request_uri" => "https://rental.florianbirkenberger.de/modell/16"
  "method" => "GET"
]

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

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

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

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

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

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

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

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "mysql"
    "port" => 3306
    "user" => "rental"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "rental"
    "charset" => "utf8mb4"
    "serverVersion" => "8.4"
  ]
]

[
  "sql" => "INSERT INTO analytics_event (event_type, context, route, event_date, created_at) VALUES (?, ?, ?, ?, ?)"
  "params" => [
    1 => "page_view"
    2 => "{"path":"\/modell\/16","route":"app_device_model_detail"}"
    3 => "app_device_model_detail"
    4 => "2026-05-26"
    5 => "2026-05-26 20:12:25"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#568
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#568}
    3 => Doctrine\DBAL\ParameterType {#568}
    4 => Doctrine\DBAL\ParameterType {#568}
    5 => Doctrine\DBAL\ParameterType {#568}
  ]
]

[
  "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\Bridge\Doctrine\Middleware\IdleConnection\Listener::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\RouterListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventSubscriber\LocaleSubscriber::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::onKernelRequestPrettyUrls"
]

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

[
  "event" => "kernel.request"
  "listener" => "App\EventSubscriber\PageViewTrackingSubscriber::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"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.name_en AS name_en_3, t0.description AS description_4, t0.description_en AS description_en_5, t0.manufacturer AS manufacturer_6, t0.model AS model_7, t0.image_path AS image_path_8, t0.notes AS notes_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.category_id AS category_id_12, t0.main_image_id AS main_image_id_13 FROM device_model t0 WHERE t0.id = ?"
  "params" => [
    1 => "16"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#570
      +name: "INTEGER"
    }
  ]
]

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

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

[
  "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" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments"
]

[
  "sql" => "SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.description AS description_2, d0_.inventory_number AS inventory_number_3, d0_.serial_number AS serial_number_4, d0_.manufacturer AS manufacturer_5, d0_.model AS model_6, d0_.status AS status_7, d0_.image_path AS image_path_8, d0_.notes AS notes_9, d0_.created_at AS created_at_10, d0_.updated_at AS updated_at_11, d0_.category_id AS category_id_12, d0_.device_model_id AS device_model_id_13 FROM device d0_ WHERE d0_.device_model_id = ? AND d0_.status <> ? ORDER BY d0_.inventory_number ASC"
  "params" => [
    1 => 16
    2 => "retired"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#570
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#568
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT b0_.id AS id_0, b0_.pickup_at AS pickup_at_1, b0_.return_at AS return_at_2, b0_.actual_return_at AS actual_return_at_3, b0_.overdue_notified_at AS overdue_notified_at_4, b0_.status AS status_5, b0_.notes AS notes_6, b0_.staff_notes AS staff_notes_7, b0_.created_at AS created_at_8, b0_.updated_at AS updated_at_9, b0_.locker_pickup_requested AS locker_pickup_requested_10, b0_.locker_return_requested AS locker_return_requested_11, b0_.terms_accepted_at AS terms_accepted_at_12, b0_.user_id AS user_id_13, b0_.device_id AS device_id_14 FROM booking b0_ WHERE b0_.device_id IN (?) AND b0_.status NOT IN (?, ?) AND b0_.pickup_at < ? AND b0_.return_at > ? ORDER BY b0_.pickup_at ASC"
  "params" => [
    1 => 16
    2 => "cancelled"
    3 => "returned"
    4 => "2026-06-25 00:30:00"
    5 => "2026-05-25 23:30:00"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#570
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#568
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#568}
    4 => Doctrine\DBAL\ParameterType {#568}
    5 => Doctrine\DBAL\ParameterType {#568}
  ]
]

[
  "sql" => "SELECT o0_.id AS id_0, o0_.day_of_week AS day_of_week_1, o0_.open_time AS open_time_2, o0_.close_time AS close_time_3, o0_.is_active AS is_active_4 FROM opening_hours o0_ WHERE o0_.is_active = 1 ORDER BY o0_.day_of_week ASC, o0_.open_time ASC"
]

[
  "sql" => "SELECT b0_.device_id AS sclr_0 FROM booking b0_ WHERE b0_.device_id IN (?) AND b0_.status IN (?, ?) AND b0_.actual_return_at IS NULL AND b0_.return_at < ? GROUP BY b0_.device_id"
  "params" => [
    1 => 16
    2 => "active"
    3 => "overdue"
    4 => "2026-05-26 20:12:25"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#570
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#568
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#568}
    4 => Doctrine\DBAL\ParameterType {#568}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.inventory_number AS inventory_number_4, t0.serial_number AS serial_number_5, t0.manufacturer AS manufacturer_6, t0.model AS model_7, t0.status AS status_8, t0.image_path AS image_path_9, t0.notes AS notes_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.category_id AS category_id_13, t0.device_model_id AS device_model_id_14 FROM device t0 WHERE t0.device_model_id = ? ORDER BY t0.inventory_number ASC"
  "params" => [
    1 => 16
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#570
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT COUNT(b0_.id) AS sclr_0 FROM booking b0_ WHERE b0_.device_id = ? AND b0_.status IN (?, ?) AND b0_.actual_return_at IS NULL AND b0_.return_at < ?"
  "params" => [
    1 => 16
    2 => "active"
    3 => "overdue"
    4 => "2026-05-26 20:12:25"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#570
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#568
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#568}
    4 => Doctrine\DBAL\ParameterType {#568}
  ]
]

[
  "sql" => "SELECT COUNT(b0_.id) AS sclr_0 FROM booking b0_ WHERE b0_.device_id = ? AND b0_.status IN (?, ?) AND b0_.actual_return_at IS NULL AND b0_.return_at < ?"
  "params" => [
    1 => 16
    2 => "active"
    3 => "overdue"
    4 => "2026-05-26 20:12:25"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#570
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#568
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#568}
    4 => Doctrine\DBAL\ParameterType {#568}
  ]
]

[
  "sql" => "SELECT COUNT(b0_.id) AS sclr_0 FROM booking b0_ WHERE b0_.device_id = ? AND b0_.status NOT IN (?, ?) AND b0_.pickup_at < ? AND b0_.return_at > ?"
  "params" => [
    1 => 16
    2 => "cancelled"
    3 => "returned"
    4 => "2026-05-26 20:13:25"
    5 => "2026-05-26 20:12:25"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#570
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#568
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#568}
    4 => Doctrine\DBAL\ParameterType {#568}
    5 => Doctrine\DBAL\ParameterType {#568}
  ]
]

[
  "sql" => "SELECT MIN(b0_.pickup_at) AS sclr_0 FROM booking b0_ WHERE b0_.device_id = ? AND b0_.status NOT IN (?, ?) AND b0_.pickup_at > ?"
  "params" => [
    1 => 16
    2 => "cancelled"
    3 => "returned"
    4 => "2026-05-26 20:12:25"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#570
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#568
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#568}
    4 => Doctrine\DBAL\ParameterType {#568}
  ]
]

[
  "sql" => "SELECT o0_.id AS id_0, o0_.day_of_week AS day_of_week_1, o0_.open_time AS open_time_2, o0_.close_time AS close_time_3, o0_.is_active AS is_active_4 FROM opening_hours o0_ WHERE o0_.is_active = 1 ORDER BY o0_.day_of_week ASC, o0_.open_time ASC"
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.block_key AS block_key_1, t0_.label AS label_2, t0_.text_de AS text_de_3, t0_.text_en AS text_en_4, t0_.notes AS notes_5, t0_.created_at AS created_at_6, t0_.updated_at AS updated_at_7 FROM text_block t0_ ORDER BY t0_.block_key ASC"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.name_en AS name_en_3, t0.description AS description_4, t0.description_en AS description_en_5, t0.slug AS slug_6, t0.icon AS icon_7, t0.sort_order AS sort_order_8 FROM category t0 WHERE t0.id = ?"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#570
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.image_path AS image_path_2, t0.alt_text AS alt_text_3, t0.sort_order AS sort_order_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.device_model_id AS device_model_id_7, t0.media_asset_id AS media_asset_id_8 FROM device_model_image t0 WHERE t0.device_model_id = ? ORDER BY t0.sort_order ASC, t0.id ASC"
  "params" => [
    1 => 16
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#570
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.name_en AS name_en_3, t0.description AS description_4, t0.description_en AS description_en_5, t0.manufacturer AS manufacturer_6, t0.model AS model_7, t0.image_path AS image_path_8, t0.notes AS notes_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.category_id AS category_id_12, t0.main_image_id AS main_image_id_13 FROM device_model t0 INNER JOIN device_model_recommended ON t0.id = device_model_recommended.device_model_target WHERE device_model_recommended.device_model_source = ?"
  "params" => [
    1 => 16
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#570
      +name: "INTEGER"
    }
  ]
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Csrf\SameOriginCsrfTokenManager::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse"
]

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

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\RememberMe\ResponseListener::onKernelResponse"
]

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

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse"
]

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

[
  "event" => "kernel.response"
  "listener" => "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DisallowRobotsIndexingListener::onResponse"
]

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

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

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

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

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