Symfony Profiler

[
  "route" => "data_shops"
  "route_parameters" => [
    "_route" => "data_shops"
    "_controller" => "App\Shop\Controller\ShopsController"
  ]
  "request_uri" => "https://2025-mu.release.sb.paritet.sprintf.ru/directory/shops"
  "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"
]

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

[
  "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 DISTINCT id_7, MIN(sclr_9) AS dctrn_minrownum FROM (SELECT s0_.address AS address_0, s0_.address_text AS address_text_1, s0_.point AS point_2, s0_.phone AS phone_3, s0_.phones AS phones_4, s0_.email AS email_5, s0_.updated_at AS updated_at_6, s0_.id AS id_7, s0_.deleted_at AS deleted_at_8, ROW_NUMBER() OVER(ORDER BY c1_.name ASC, s0_.address_text ASC) AS sclr_9 FROM shops s0_ LEFT JOIN cities c1_ ON s0_.city_id = c1_.id AND (c1_.deleted_at IS NULL) WHERE (s0_.deleted_at IS NULL)) dctrn_result GROUP BY id_7 ORDER BY dctrn_minrownum ASC LIMIT 25"
]

[
  "sql" => "SELECT s0_.address AS address_0, s0_.address_text AS address_text_1, s0_.point AS point_2, s0_.phone AS phone_3, s0_.phones AS phones_4, s0_.email AS email_5, s0_.updated_at AS updated_at_6, s0_.id AS id_7, s0_.deleted_at AS deleted_at_8, s0_.city_id AS city_id_9 FROM shops s0_ LEFT JOIN cities c1_ ON s0_.city_id = c1_.id AND (c1_.deleted_at IS NULL) WHERE (s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (s0_.deleted_at IS NULL) ORDER BY c1_.name ASC, s0_.address_text ASC"
  "params" => [
    1 => "10ecdabc-b33d-4ce3-b2a8-f46a09cc98f6"
    2 => "6f111056-e9cf-4a03-ab91-f6206b551fd8"
    3 => "da62b91d-f581-4f39-a8d4-50248f383519"
    4 => "5a6625f5-4e71-4131-add2-b7e85c741099"
    5 => "33619c40-1877-4bda-b8d1-ba8f39815132"
    6 => "0fb2c29b-435f-4afd-a2ae-eed46114b06c"
    7 => "38ee642e-37e6-4a88-8ba6-bc7a021e47c4"
    8 => "edd00af2-78ee-4880-9dd1-b845f87f290f"
    9 => "4893ffdd-f246-41d2-8820-13ea03db1517"
    10 => "9836e10a-0aea-4dec-81ff-2c32b5d51aed"
    11 => "5094480c-c893-4d41-85ea-fcf96c45bf49"
    12 => "24b07c3b-9bf2-4e23-91ce-6747f1424acd"
    13 => "64ec6067-19db-463d-96fe-55fa03a1749b"
    14 => "648a0938-6a7a-4166-92f6-48d6b0223327"
    15 => "73d648cb-9c13-4d91-ae01-d8738c2667b5"
    16 => "4c371217-f077-46b4-990a-f3c630d0de81"
    17 => "97fbde3e-63cb-4f8a-b0f1-9ba1d26e3426"
    18 => "8c86e44d-5f27-4aee-af58-e404d3da29af"
    19 => "30b5131b-bf3d-44a9-8e49-423ca7fd202c"
    20 => "15450ed2-7195-4528-b424-a4b5d9d0645f"
    21 => "4762414e-6030-47d3-98ad-86987e4a1bb2"
    22 => "a4be2658-e003-45cd-82fa-cc874776a064"
    23 => "0cb09bc6-3a5a-4947-9b51-f2444a5762a2"
    24 => "f1570be1-087f-4184-8b55-74908acbca38"
    25 => "ee428f23-466c-4349-bcb6-dae05c78746d"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 2
    9 => 2
    10 => 2
    11 => 2
    12 => 2
    13 => 2
    14 => 2
    15 => 2
    16 => 2
    17 => 2
    18 => 2
    19 => 2
    20 => 2
    21 => 2
    22 => 2
    23 => 2
    24 => 2
    25 => 2
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.okato AS okato_2, t0.name_full AS name_full_3, t0.name_eng AS name_eng_4, t0.updated_at AS updated_at_5, t0.id AS id_6, t0.deleted_at AS deleted_at_7, t0.region_id AS region_id_8 FROM cities t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))"
  "params" => [
    1 => "c1c7cbeb-fbff-4f58-9384-3f26f5810a79"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.okato AS okato_2, t0.name_full AS name_full_3, t0.name_eng AS name_eng_4, t0.updated_at AS updated_at_5, t0.id AS id_6, t0.deleted_at AS deleted_at_7, t0.region_id AS region_id_8 FROM cities t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))"
  "params" => [
    1 => "8b37b71e-4409-4997-8d00-f0e5f8f04bed"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.okato AS okato_2, t0.name_full AS name_full_3, t0.name_eng AS name_eng_4, t0.updated_at AS updated_at_5, t0.id AS id_6, t0.deleted_at AS deleted_at_7, t0.region_id AS region_id_8 FROM cities t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))"
  "params" => [
    1 => "d7505210-a0c5-4218-9385-5af1e36705ab"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.okato AS okato_2, t0.name_full AS name_full_3, t0.name_eng AS name_eng_4, t0.updated_at AS updated_at_5, t0.id AS id_6, t0.deleted_at AS deleted_at_7, t0.region_id AS region_id_8 FROM cities t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))"
  "params" => [
    1 => "0a78a503-ec54-42b9-b00e-eed54ddc2b4a"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.okato AS okato_2, t0.name_full AS name_full_3, t0.name_eng AS name_eng_4, t0.updated_at AS updated_at_5, t0.id AS id_6, t0.deleted_at AS deleted_at_7, t0.region_id AS region_id_8 FROM cities t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))"
  "params" => [
    1 => "528a117b-4b27-4f7e-b162-60e7d2e42c84"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.okato AS okato_2, t0.name_full AS name_full_3, t0.name_eng AS name_eng_4, t0.updated_at AS updated_at_5, t0.id AS id_6, t0.deleted_at AS deleted_at_7, t0.region_id AS region_id_8 FROM cities t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))"
  "params" => [
    1 => "16f8ac31-2a2f-4396-825e-9b598141978d"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.okato AS okato_2, t0.name_full AS name_full_3, t0.name_eng AS name_eng_4, t0.updated_at AS updated_at_5, t0.id AS id_6, t0.deleted_at AS deleted_at_7, t0.region_id AS region_id_8 FROM cities t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))"
  "params" => [
    1 => "05a560f3-6b8c-4813-a20b-553a2f4ca413"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.okato AS okato_2, t0.name_full AS name_full_3, t0.name_eng AS name_eng_4, t0.updated_at AS updated_at_5, t0.id AS id_6, t0.deleted_at AS deleted_at_7, t0.region_id AS region_id_8 FROM cities t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))"
  "params" => [
    1 => "ce0737a3-ec6c-4467-8881-812b9a4d6bf2"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.okato AS okato_2, t0.name_full AS name_full_3, t0.name_eng AS name_eng_4, t0.updated_at AS updated_at_5, t0.id AS id_6, t0.deleted_at AS deleted_at_7, t0.region_id AS region_id_8 FROM cities t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))"
  "params" => [
    1 => "c36a8422-c4c3-4866-9d41-2a2e837c4d9d"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.okato AS okato_2, t0.name_full AS name_full_3, t0.name_eng AS name_eng_4, t0.updated_at AS updated_at_5, t0.id AS id_6, t0.deleted_at AS deleted_at_7, t0.region_id AS region_id_8 FROM cities t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))"
  "params" => [
    1 => "b7322156-0471-4fa0-95b9-d0300cff249b"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.okato AS okato_2, t0.name_full AS name_full_3, t0.name_eng AS name_eng_4, t0.updated_at AS updated_at_5, t0.id AS id_6, t0.deleted_at AS deleted_at_7, t0.region_id AS region_id_8 FROM cities t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))"
  "params" => [
    1 => "d2f0fe49-ab21-45f1-86e9-347ee1390fdc"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.okato AS okato_2, t0.name_full AS name_full_3, t0.name_eng AS name_eng_4, t0.updated_at AS updated_at_5, t0.id AS id_6, t0.deleted_at AS deleted_at_7, t0.region_id AS region_id_8 FROM cities t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))"
  "params" => [
    1 => "49abd619-3141-4a52-8fa2-534b605c6fd9"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.okato AS okato_2, t0.name_full AS name_full_3, t0.name_eng AS name_eng_4, t0.updated_at AS updated_at_5, t0.id AS id_6, t0.deleted_at AS deleted_at_7, t0.region_id AS region_id_8 FROM cities t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))"
  "params" => [
    1 => "80a3d9c3-eeec-4719-b5b0-9eb588db4735"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.okato AS okato_2, t0.name_full AS name_full_3, t0.name_eng AS name_eng_4, t0.updated_at AS updated_at_5, t0.id AS id_6, t0.deleted_at AS deleted_at_7, t0.region_id AS region_id_8 FROM cities t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))"
  "params" => [
    1 => "186c2360-3103-4cf1-a529-af5ea0392091"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.okato AS okato_2, t0.name_full AS name_full_3, t0.name_eng AS name_eng_4, t0.updated_at AS updated_at_5, t0.id AS id_6, t0.deleted_at AS deleted_at_7, t0.region_id AS region_id_8 FROM cities t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))"
  "params" => [
    1 => "1fa1cfd8-bd67-4058-8ed3-b81e52ee450a"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.okato AS okato_2, t0.name_full AS name_full_3, t0.name_eng AS name_eng_4, t0.updated_at AS updated_at_5, t0.id AS id_6, t0.deleted_at AS deleted_at_7, t0.region_id AS region_id_8 FROM cities t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))"
  "params" => [
    1 => "45aadcb6-3b47-4671-b011-d3066d144c0d"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_7 FROM (SELECT s0_.address AS address_0, s0_.address_text AS address_text_1, s0_.point AS point_2, s0_.phone AS phone_3, s0_.phones AS phones_4, s0_.email AS email_5, s0_.updated_at AS updated_at_6, s0_.id AS id_7, s0_.deleted_at AS deleted_at_8 FROM shops s0_ LEFT JOIN cities c1_ ON s0_.city_id = c1_.id AND (c1_.deleted_at IS NULL) WHERE (s0_.deleted_at IS NULL) ORDER BY c1_.name ASC, s0_.address_text 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"
]