Symfony Profiler

[
  "route" => "_api_/transportations/{id}{._format}_get"
  "route_parameters" => [
    "_route" => "_api_/transportations/{id}{._format}_get"
    "_controller" => "api_platform.symfony.main_controller"
    "_stateless" => false
    "_api_resource_class" => "Greendot\EshopBundle\Entity\Project\Transportation"
    "_api_operation_name" => "_api_/transportations/{id}{._format}_get"
    "_format" => null
    "id" => "6&amp"
  ]
  "request_uri" => "https://proklima.greendot.cz/api/transportations/6&amp"
  "method" => "GET"
]

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "localhost"
    "port" => 3306
    "user" => "greendot"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "proklima_eshop"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.symbol AS symbol_2, c0_.rounding AS rounding_3, c0_.is_default AS is_default_4, c0_.default_locale AS default_locale_5, c0_.is_symbol_left AS is_symbol_left_6, c0_.is_deleted AS is_deleted_7 FROM currency c0_ WHERE c0_.default_locale = ? LIMIT 1"
  "params" => [
    1 => "cs"
  ]
  "types" => [
    1 => 2
  ]
]

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

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

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

[
  "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" => "Greendot\EshopBundle\I18n\ApiLocaleListener::onKernelRequest"
]

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

[
  "event" => "kernel.request"
  "listener" => "Greendot\EshopBundle\EventSubscriber\Decorated\LocaleAwareListenerDecorator::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" => "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::onKernelRequest"
]

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

[
  "event" => "kernel.controller"
  "listener" => "Nzo\UrlEncryptorBundle\Annotations\AnnotationResolver::onKernelController"
]

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

[
  "event" => "kernel.controller"
  "listener" => "Greendot\EshopBundle\EventSubscriber\BeforeControllerListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Greendot\EshopBundle\EventSubscriber\DisableListenersSubscriber::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Greendot\EshopBundle\EventSubscriber\AnonymousClientLogoutListener::onKernelController"
]

[
  "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" => "ContainerXoUkwCr\RequestPayloadValueResolverGhost01ca9cc::onKernelControllerArguments"
]

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

[
  "sql" => "SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.description AS description_2, t0_.description_mail AS description_mail_3, t0_.description_duration AS description_duration_4, t0_.html AS html_5, t0_.icon AS icon_6, t0_.duration AS duration_7, t0_.squence AS squence_8, t0_.country AS country_9, t0_.state_url AS state_url_10, t0_.is_enabled AS is_enabled_11, t0_.token AS token_12, t0_.secret_key AS secret_key_13, t0_.transportation_action AS transportation_action_14, t0_.transportation_api AS transportation_api_15, t0_.export_names AS export_names_16, p1_.id AS id_17, p1_.name AS name_18, p1_.description AS description_19, p1_.descrition_mail AS descrition_mail_20, p1_.description_duration AS description_duration_21, p1_.html AS html_22, p1_.icon AS icon_23, p1_.duration AS duration_24, p1_.sequence AS sequence_25, p1_.country AS country_26, p1_.is_enabled AS is_enabled_27, p1_.action_group AS action_group_28, p1_.account AS account_29, p1_.bank_number AS bank_number_30, p1_.iban AS iban_31, p1_.bank_name AS bank_name_32, p1_.payment_technical_action AS payment_technical_action_33, p1_.export_names AS export_names_34, h2_.id AS id_35, h2_.price AS price_36, h2_.free_from_price AS free_from_price_37, h2_.discount AS discount_38, h2_.vat AS vat_39, h2_.valid_from AS valid_from_40, h2_.valid_until AS valid_until_41, h2_.created AS created_42, t3_.id AS id_43, t3_.name AS name_44, t3_.description AS description_45, t3_.icon AS icon_46, t3_.country AS country_47, h2_.transportation_id AS transportation_id_48, h2_.payment_type_id AS payment_type_id_49 FROM transportation t0_ LEFT JOIN transportation_payment_type t4_ ON t0_.id = t4_.transportation_id LEFT JOIN payment_type p1_ ON p1_.id = t4_.payment_type_id LEFT JOIN handling_price h2_ ON t0_.id = h2_.transportation_id LEFT JOIN transportation_transportation_group t5_ ON t0_.id = t5_.transportation_id LEFT JOIN transportation_group t3_ ON t3_.id = t5_.transportation_group_id WHERE (t0_.id = ?) AND (t0_.is_enabled = true)"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT s0_.value AS value_0 FROM settings s0_ WHERE s0_.name = ? ORDER BY s0_.name ASC LIMIT 1"
  "params" => [
    1 => "after_registration_discount"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT h0_.id AS id_0, h0_.price AS price_1, h0_.free_from_price AS free_from_price_2, h0_.discount AS discount_3, h0_.vat AS vat_4, h0_.valid_from AS valid_from_5, h0_.valid_until AS valid_until_6, h0_.created AS created_7, h0_.transportation_id AS transportation_id_8, h0_.payment_type_id AS payment_type_id_9 FROM handling_price h0_ WHERE h0_.transportation_id = ? AND h0_.valid_from <= ? AND (h0_.valid_until >= ? OR h0_.valid_until IS NULL)"
  "params" => [
    1 => 6
    2 => "2026-07-02 21:13:30"
    3 => "2026-07-02 21:13:30"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT h0_.id AS id_0, h0_.price AS price_1, h0_.free_from_price AS free_from_price_2, h0_.discount AS discount_3, h0_.vat AS vat_4, h0_.valid_from AS valid_from_5, h0_.valid_until AS valid_until_6, h0_.created AS created_7, h0_.transportation_id AS transportation_id_8, h0_.payment_type_id AS payment_type_id_9 FROM handling_price h0_ WHERE h0_.transportation_id = ? AND h0_.valid_from <= ? AND (h0_.valid_until >= ? OR h0_.valid_until IS NULL)"
  "params" => [
    1 => 6
    2 => "2026-07-02 21:13:30"
    3 => "2026-07-02 21:13:30"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT h0_.id AS id_0, h0_.price AS price_1, h0_.free_from_price AS free_from_price_2, h0_.discount AS discount_3, h0_.vat AS vat_4, h0_.valid_from AS valid_from_5, h0_.valid_until AS valid_until_6, h0_.created AS created_7, h0_.transportation_id AS transportation_id_8, h0_.payment_type_id AS payment_type_id_9 FROM handling_price h0_ WHERE h0_.payment_type_id = ? AND h0_.valid_from <= ? AND (h0_.valid_until >= ? OR h0_.valid_until IS NULL)"
  "params" => [
    1 => 1
    2 => "2026-07-02 21:13:30"
    3 => "2026-07-02 21:13:30"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT h0_.id AS id_0, h0_.price AS price_1, h0_.free_from_price AS free_from_price_2, h0_.discount AS discount_3, h0_.vat AS vat_4, h0_.valid_from AS valid_from_5, h0_.valid_until AS valid_until_6, h0_.created AS created_7, h0_.transportation_id AS transportation_id_8, h0_.payment_type_id AS payment_type_id_9 FROM handling_price h0_ WHERE h0_.payment_type_id = ? AND h0_.valid_from <= ? AND (h0_.valid_until >= ? OR h0_.valid_until IS NULL)"
  "params" => [
    1 => 2
    2 => "2026-07-02 21:13:30"
    3 => "2026-07-02 21:13:30"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT h0_.id AS id_0, h0_.price AS price_1, h0_.free_from_price AS free_from_price_2, h0_.discount AS discount_3, h0_.vat AS vat_4, h0_.valid_from AS valid_from_5, h0_.valid_until AS valid_until_6, h0_.created AS created_7, h0_.transportation_id AS transportation_id_8, h0_.payment_type_id AS payment_type_id_9 FROM handling_price h0_ WHERE h0_.payment_type_id = ? AND h0_.valid_from <= ? AND (h0_.valid_until >= ? OR h0_.valid_until IS NULL)"
  "params" => [
    1 => 3
    2 => "2026-07-02 21:13:30"
    3 => "2026-07-02 21:13:30"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "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\Security\Http\Firewall\ContextListener::onKernelResponse"
]

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

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\WebLink\EventListener\AddLinkHeaderListener::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" => "Greendot\EshopBundle\Affiliate\AffiliateOrderEventSubscriber::setAffiliateCookies"
]

[
  "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\WebpackEncoreBundle\EventListener\ResetAssetsEventListener::resetAssets"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Greendot\EshopBundle\EventSubscriber\Decorated\LocaleAwareListenerDecorator::onKernelFinishRequest"
]