Symfony Profiler

[
  "route" => "data_product_category"
  "route_parameters" => [
    "_route" => "data_product_category"
    "_controller" => "App\ProductCategory\Controller\ProductCategoryController"
  ]
  "request_uri" => "https://2025-mu.release.sb.paritet.sprintf.ru/product_category"
  "method" => "GET"
]

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

[
  "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" => "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::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" => "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" => "ContainerQ8fLo0c\RequestPayloadValueResolverGhost01ca9cc::onKernelControllerArguments"
]

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

[
  "event" => "Symfony\UX\TwigComponent\Event\PreCreateForRenderEvent"
  "listener" => "Symfony\UX\LiveComponent\EventListener\InterceptChildComponentRenderSubscriber::preComponentCreated"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PreMountEvent"
  "listener" => "Symfony\UX\LiveComponent\EventListener\DataModelPropsSubscriber::onPreMount"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PostMountEvent"
  "listener" => "Symfony\UX\LiveComponent\EventListener\RequestInitializeSubscriber::onPostMount"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PostMountEvent"
  "listener" => "Symfony\UX\LiveComponent\EventListener\DeferLiveComponentSubscriber::onPostMount"
]

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_pgsql"
    "idle_connection_ttl" => 600
    "host" => "postgres"
    "port" => 5432
    "user" => "bridge"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "bridge"
    "serverVersion" => "15"
    "charset" => "utf8"
  ]
]

[
  "sql" => "SELECT p0_.domain AS domain_0, p0_.name AS name_1, p0_.api_key AS api_key_2, p0_.updated_at AS updated_at_3, p0_.id AS id_4, p0_.deleted_at AS deleted_at_5, p0_.legal_id AS legal_id_6, p0_.city_id AS city_id_7 FROM projects p0_ WHERE (p0_.deleted_at IS NULL)"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PreRenderEvent"
  "listener" => "Symfony\UX\TwigComponent\EventListener\TwigComponentLoggerListener::onPreRender"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PreRenderEvent"
  "listener" => "App\AssortmentPlan\EntityTable\AssortmentPlanEntityTable::onPreRender"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PreRenderEvent"
  "listener" => "App\Infrastructure\EntityTable\Component\EntityTableComponent::onPreRender"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PreRenderEvent"
  "listener" => "Symfony\UX\LiveComponent\EventListener\AddLiveAttributesSubscriber::onPreRender"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PreRenderEvent"
  "listener" => "Symfony\UX\LiveComponent\EventListener\DeferLiveComponentSubscriber::onPreRender"
]

[
  "sql" => "SELECT DISTINCT id_1, MIN(sclr_2) AS dctrn_minrownum FROM (SELECT p0_.updated_at AS updated_at_0, p0_.id AS id_1, ROW_NUMBER() OVER(ORDER BY p0_.project_id ASC) AS sclr_2 FROM project_category_products p0_) dctrn_result GROUP BY id_1 ORDER BY dctrn_minrownum ASC LIMIT 25"
]

[
  "sql" => "SELECT p0_.updated_at AS updated_at_0, p0_.id AS id_1, p0_.project_id AS project_id_2, p0_.product_category_id AS product_category_id_3, p0_.product_id AS product_id_4 FROM project_category_products p0_ WHERE p0_.id IN (?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.project_id ASC"
  "params" => [
    1 => "b4d6306f-d615-40cd-8721-349bcba26501"
    2 => "73d84181-f937-4d9e-8322-bef078fea425"
    3 => "2e0e91e5-5056-4da3-92e3-4c93cc9a7bd6"
    4 => "2bc9c00d-e3e7-41eb-9600-4c1e6fe8ae25"
    5 => "53f77aa2-1c14-43b5-ae2a-d6f22b2382a0"
    6 => "0a7d84bf-f1a8-4a75-a6c5-a3c7c3d7c378"
    7 => "f7256f48-764c-48c1-9986-3cb482ab2b6f"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
  ]
]

[
  "sql" => "SELECT t0.lft AS lft_1, t0.rgt AS rgt_2, t0.lvl AS lvl_3, t0.name AS name_4, t0.slug AS slug_5, t0.id AS id_6, t0.prt AS prt_7, t0.project_id AS project_id_8, t0.tree_root AS tree_root_9 FROM categories_all t0 WHERE t0.id = ?"
  "params" => [
    1 => "1f0adb7f-5768-6516-bf71-278e933446f6"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.updated_at AS updated_at_2, t0.id AS id_3, t0.deleted_at AS deleted_at_4, t0.product_type_id AS product_type_id_5, t0.brand_id AS brand_id_6 FROM products t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))"
  "params" => [
    1 => "1df45d75-bf6a-458a-86bb-aab2d770c9d7"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.updated_at AS updated_at_2, t0.id AS id_3, t0.deleted_at AS deleted_at_4, t0.product_type_id AS product_type_id_5, t0.brand_id AS brand_id_6 FROM products t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))"
  "params" => [
    1 => "3576bf0c-7daa-4a0f-8b40-777a44f3ae9d"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.updated_at AS updated_at_2, t0.id AS id_3, t0.deleted_at AS deleted_at_4, t0.product_type_id AS product_type_id_5, t0.brand_id AS brand_id_6 FROM products t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))"
  "params" => [
    1 => "37758d8c-f1e3-4349-b3d6-890d9303f44e"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.updated_at AS updated_at_2, t0.id AS id_3, t0.deleted_at AS deleted_at_4, t0.product_type_id AS product_type_id_5, t0.brand_id AS brand_id_6 FROM products t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))"
  "params" => [
    1 => "5153e619-86e3-481f-8743-c36a5dfb45c5"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.updated_at AS updated_at_2, t0.id AS id_3, t0.deleted_at AS deleted_at_4, t0.product_type_id AS product_type_id_5, t0.brand_id AS brand_id_6 FROM products t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))"
  "params" => [
    1 => "9b75f464-cf66-4042-a94d-cdeda4f92220"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.updated_at AS updated_at_2, t0.id AS id_3, t0.deleted_at AS deleted_at_4, t0.product_type_id AS product_type_id_5, t0.brand_id AS brand_id_6 FROM products t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))"
  "params" => [
    1 => "ddded8b0-1ac9-423b-a78c-a14605b8a26b"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.updated_at AS updated_at_2, t0.id AS id_3, t0.deleted_at AS deleted_at_4, t0.product_type_id AS product_type_id_5, t0.brand_id AS brand_id_6 FROM products t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))"
  "params" => [
    1 => "e4b6d9ba-b559-4fc8-b468-f192817f9b92"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_1 FROM (SELECT p0_.updated_at AS updated_at_0, p0_.id AS id_1 FROM project_category_products p0_ ORDER BY p0_.project_id ASC) dctrn_result) dctrn_table"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PostRenderEvent"
  "listener" => "Symfony\UX\LiveComponent\EventListener\ResetDeterministicIdSubscriber::onPostRender"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PostRenderEvent"
  "listener" => "Symfony\UX\TwigComponent\EventListener\TwigComponentLoggerListener::onPostRender"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::onKernelResponse"
]

[
  "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" => "Nelmio\CorsBundle\EventListener\CorsListener::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\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\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest"
]

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