Symfony Profiler

[
  "route" => "_api_/orders{._format}_get_collection"
  "route_parameters" => [
    "_route" => "_api_/orders{._format}_get_collection"
    "_controller" => "api_platform.symfony.main_controller"
    "_stateless" => true
    "_api_resource_class" => "App\Entity\Order"
    "_api_operation_name" => "_api_/orders{._format}_get_collection"
    "_format" => null
  ]
  "request_uri" => "https://www.lustra-bronza.ru/api/orders?itemsPerPage=10&order%5BdateAdded%5D=desc"
  "method" => "GET"
]

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

[
  "event" => "kernel.request"
  "listener" => "Symfony\UX\Turbo\Request\RequestListener::__invoke"
]

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

[
  "event" => "kernel.request"
  "listener" => "Nelmio\CorsBundle\EventListener\CorsListener::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" => "App\Theme\EventListener\ThemeListener::__invoke"
]

[
  "event" => "kernel.request"
  "listener" => "App\Theme\EventListener\ThemeListener::__invoke"
]

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

[
  "event" => "kernel.request"
  "listener" => "App\EventSubscriber\DeliveryContextSubscriber::onRequest"
]

[
  "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" => "App\EventSubscriber\DeliveryDefaultSubscriber::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\UX\LiveComponent\EventListener\LiveComponentSubscriber::onKernelRequest"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\UX\LiveComponent\EventListener\LiveComponentSubscriber::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\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" => "ContainerDRM9uSU\RequestPayloadValueResolverGhost01ca9cc::onKernelControllerArguments"
]

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

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3310
    "user" => "alex"
    "password" => "<redacted>"
    "driverOptions" => [
      1002 => "SET time_zone = '+00:00'"
    ]
    "defaultTableOptions" => []
    "dbname" => "lustra_bronza_new"
    "serverVersion" => "8.0"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT count(DISTINCT o0_.id) AS sclr_0 FROM `order` o0_ LEFT JOIN order_products o1_ ON o0_.id = o1_.orders_id LEFT JOIN order_product_options o2_ ON o1_.id = o2_.order_product_id LEFT JOIN `order_customer` o3_ ON o0_.customer_id = o3_.id LEFT JOIN order_delivery o4_ ON o0_.delivery_id = o4_.id LEFT JOIN fias f5_ ON o4_.city_id = f5_.fias_id LEFT JOIN users u6_ ON o0_.user_id = u6_.id"
]

[
  "sql" => "SELECT DISTINCT o0_.id AS id_0, o0_.date_added AS date_added_1 FROM `order` o0_ LEFT JOIN order_products o1_ ON o0_.id = o1_.orders_id LEFT JOIN order_product_options o2_ ON o1_.id = o2_.order_product_id LEFT JOIN `order_customer` o3_ ON o0_.customer_id = o3_.id LEFT JOIN order_delivery o4_ ON o0_.delivery_id = o4_.id LEFT JOIN fias f5_ ON o4_.city_id = f5_.fias_id LEFT JOIN users u6_ ON o0_.user_id = u6_.id ORDER BY o0_.date_added DESC LIMIT 10"
]

[
  "sql" => "SELECT o0_.id AS id_0, o0_.order_id AS order_id_1, o0_.date_added AS date_added_2, o0_.comment AS comment_3, o0_.status AS status_4, o0_.total AS total_5, o1_.id AS id_6, o1_.product_id AS product_id_7, o1_.product_name AS product_name_8, o1_.price AS price_9, o1_.quantity AS quantity_10, o1_.sale_price AS sale_price_11, o2_.id AS id_12, o2_.product_id AS product_id_13, o2_.option_name AS option_name_14, o2_.value AS value_15, o2_.price AS price_16, o3_.id AS id_17, o3_.name AS name_18, o3_.phone AS phone_19, o3_.email AS email_20, o3_.ip AS ip_21, o3_.user_agent AS user_agent_22, o3_.phone_normal AS phone_normal_23, o3_.comment AS comment_24, o4_.id AS id_25, o4_.type AS type_26, o4_.address AS address_27, o4_.city AS city_28, o4_.cost AS cost_29, o4_.pvz AS pvz_30, o4_.is_free AS is_free_31, o4_.is_custom_calculate AS is_custom_calculate_32, o4_.pricing_source AS pricing_source_33, o4_.pricing_trace AS pricing_trace_34, o4_.pvz_code AS pvz_code_35, o4_.delivery_date AS delivery_date_36, o4_.delivery_time AS delivery_time_37, f5_.fias_id AS fias_id_38, f5_.parent_id AS parent_id_39, f5_.postalcode AS postalcode_40, f5_.offname AS offname_41, f5_.shortname AS shortname_42, f5_.level AS level_43, u6_.id AS id_44, u6_.name AS name_45, u6_.first_name AS first_name_46, u6_.email AS email_47, u6_.phone AS phone_48, u6_.roles AS roles_49, u6_.password AS password_50, u6_.is_verified AS is_verified_51, u6_.failed_login_attempts AS failed_login_attempts_52, u6_.locked_until AS locked_until_53, u6_.last_login_at AS last_login_at_54, u6_.token_version AS token_version_55, o0_.customer_id AS customer_id_56, o0_.delivery_id AS delivery_id_57, o0_.user_id AS user_id_58, o1_.orders_id AS orders_id_59, o2_.order_product_id AS order_product_id_60, o4_.city_id AS city_id_61 FROM `order` o0_ LEFT JOIN order_products o1_ ON o0_.id = o1_.orders_id LEFT JOIN order_product_options o2_ ON o1_.id = o2_.order_product_id LEFT JOIN `order_customer` o3_ ON o0_.customer_id = o3_.id LEFT JOIN order_delivery o4_ ON o0_.delivery_id = o4_.id LEFT JOIN fias f5_ ON o4_.city_id = f5_.fias_id LEFT JOIN users u6_ ON o0_.user_id = u6_.id WHERE o0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY o0_.date_added DESC"
  "params" => [
    1 => 32
    2 => 31
    3 => 30
    4 => 29
    5 => 28
    6 => 27
    7 => 26
    8 => 25
    9 => 24
    10 => 23
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 1
    4 => 1
    5 => 1
    6 => 1
    7 => 1
    8 => 1
    9 => 1
    10 => 1
  ]
]

[
  "event" => "kernel.response"
  "listener" => "App\EventListener\CartCookieListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "App\EventListener\CartCookieListener::onKernelResponse"
]

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

[
  "event" => "kernel.response"
  "listener" => "Nelmio\CorsBundle\EventListener\CorsListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "App\EventSubscriber\CartCookieSubscriber::onResponse"
]

[
  "event" => "kernel.response"
  "listener" => "App\EventSubscriber\DeliveryContextSubscriber::onResponse"
]

[
  "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\UX\LiveComponent\EventListener\LiveComponentSubscriber::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\UX\LiveComponent\EventListener\LiveUrlSubscriber::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Nelmio\CorsBundle\EventListener\CacheableResponseVaryListener::onResponse"
]

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

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

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