Symfony Profiler

[
  "route" => "_api_/infrastructures{._format}_get_collection"
  "route_parameters" => [
    "_route" => "_api_/infrastructures{._format}_get_collection"
    "_controller" => "api_platform.symfony.main_controller"
    "_stateless" => null
    "_api_resource_class" => "App\Entity\Infrastructure"
    "_api_operation_name" => "_api_/infrastructures{._format}_get_collection"
    "_format" => null
  ]
  "request_uri" => "https://petrovskiy-tc.itlabs.top/api/infrastructures"
  "method" => "GET"
]

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

[
  "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\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" => "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelRequestPrettyUrls"
]

[
  "event" => "kernel.request"
  "listener" => "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::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"
]

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

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

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "shared-backend_petrovskiy"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "shared-backend_petrovskiy"
    "serverVersion" => "10.11.2-MariaDB"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT i0_.id AS id_0, i0_.title AS title_1, i0_.building AS building_2, i0_.search_aliases AS search_aliases_3, i0_.image AS image_4, i0_.created_at AS created_at_5, i0_.updated_at AS updated_at_6, f1_.id AS id_7, f1_.name AS name_8, f1_.map_image AS map_image_9, f1_.zoom_start AS zoom_start_10, f1_.created_at AS created_at_11, f1_.updated_at AS updated_at_12, c2_.id AS id_13, c2_.title AS title_14, c2_.image AS image_15, c2_.search_aliases AS search_aliases_16, c2_.created_at AS created_at_17, c2_.updated_at AS updated_at_18, i0_.floor_id AS floor_id_19, i0_.node_id AS node_id_20, i0_.area_id AS area_id_21, c2_.parent_id AS parent_id_22 FROM infrastructure i0_ LEFT JOIN floor f1_ ON i0_.floor_id = f1_.id LEFT JOIN infrastructure_category i3_ ON i0_.id = i3_.infrastructure_id LEFT JOIN category c2_ ON c2_.id = i3_.category_id ORDER BY i0_.id ASC"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.point_id AS point_id_2 FROM node t0 WHERE t0.id = ?"
  "params" => [
    1 => 848
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1821
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.x AS x_2, t0.y AS y_3, t0.floor_id AS floor_id_4 FROM point t0 WHERE t0.id = ?"
  "params" => [
    1 => 4025
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1821
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.point_id AS point_id_2 FROM node t0 WHERE t0.id = ?"
  "params" => [
    1 => 312
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1821
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.x AS x_2, t0.y AS y_3, t0.floor_id AS floor_id_4 FROM point t0 WHERE t0.id = ?"
  "params" => [
    1 => 3045
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1821
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.point_id AS point_id_2 FROM node t0 WHERE t0.id = ?"
  "params" => [
    1 => 840
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1821
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.x AS x_2, t0.y AS y_3, t0.floor_id AS floor_id_4 FROM point t0 WHERE t0.id = ?"
  "params" => [
    1 => 4001
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1821
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.point_id AS point_id_2 FROM node t0 WHERE t0.id = ?"
  "params" => [
    1 => 839
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1821
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.x AS x_2, t0.y AS y_3, t0.floor_id AS floor_id_4 FROM point t0 WHERE t0.id = ?"
  "params" => [
    1 => 4000
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1821
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.point_id AS point_id_2 FROM node t0 WHERE t0.id = ?"
  "params" => [
    1 => 304
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1821
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.x AS x_2, t0.y AS y_3, t0.floor_id AS floor_id_4 FROM point t0 WHERE t0.id = ?"
  "params" => [
    1 => 3037
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1821
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.point_id AS point_id_2 FROM node t0 WHERE t0.id = ?"
  "params" => [
    1 => 303
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1821
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.x AS x_2, t0.y AS y_3, t0.floor_id AS floor_id_4 FROM point t0 WHERE t0.id = ?"
  "params" => [
    1 => 3036
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1821
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.point_id AS point_id_2 FROM node t0 WHERE t0.id = ?"
  "params" => [
    1 => 362
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1821
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.x AS x_2, t0.y AS y_3, t0.floor_id AS floor_id_4 FROM point t0 WHERE t0.id = ?"
  "params" => [
    1 => 3099
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1821
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.point_id AS point_id_2 FROM node t0 WHERE t0.id = ?"
  "params" => [
    1 => 447
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1821
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.x AS x_2, t0.y AS y_3, t0.floor_id AS floor_id_4 FROM point t0 WHERE t0.id = ?"
  "params" => [
    1 => 3195
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1821
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.point_id AS point_id_2 FROM node t0 WHERE t0.id = ?"
  "params" => [
    1 => 702
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1821
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.x AS x_2, t0.y AS y_3, t0.floor_id AS floor_id_4 FROM point t0 WHERE t0.id = ?"
  "params" => [
    1 => 3536
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1821
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.point_id AS point_id_2 FROM node t0 WHERE t0.id = ?"
  "params" => [
    1 => 703
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1821
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.x AS x_2, t0.y AS y_3, t0.floor_id AS floor_id_4 FROM point t0 WHERE t0.id = ?"
  "params" => [
    1 => 3537
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1821
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.point_id AS point_id_2 FROM node t0 WHERE t0.id = ?"
  "params" => [
    1 => 704
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1821
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.x AS x_2, t0.y AS y_3, t0.floor_id AS floor_id_4 FROM point t0 WHERE t0.id = ?"
  "params" => [
    1 => 3538
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1821
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.point_id AS point_id_2 FROM node t0 WHERE t0.id = ?"
  "params" => [
    1 => 446
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1821
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.x AS x_2, t0.y AS y_3, t0.floor_id AS floor_id_4 FROM point t0 WHERE t0.id = ?"
  "params" => [
    1 => 3194
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1821
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.point_id AS point_id_2 FROM node t0 WHERE t0.id = ?"
  "params" => [
    1 => 263
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1821
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.x AS x_2, t0.y AS y_3, t0.floor_id AS floor_id_4 FROM point t0 WHERE t0.id = ?"
  "params" => [
    1 => 2770
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1821
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.point_id AS point_id_2 FROM node t0 WHERE t0.id = ?"
  "params" => [
    1 => 265
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1821
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.x AS x_2, t0.y AS y_3, t0.floor_id AS floor_id_4 FROM point t0 WHERE t0.id = ?"
  "params" => [
    1 => 2772
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1821
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.point_id AS point_id_2 FROM node t0 WHERE t0.id = ?"
  "params" => [
    1 => 270
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1821
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.x AS x_2, t0.y AS y_3, t0.floor_id AS floor_id_4 FROM point t0 WHERE t0.id = ?"
  "params" => [
    1 => 2777
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1821
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.point_id AS point_id_2 FROM node t0 WHERE t0.id = ?"
  "params" => [
    1 => 267
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1821
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.x AS x_2, t0.y AS y_3, t0.floor_id AS floor_id_4 FROM point t0 WHERE t0.id = ?"
  "params" => [
    1 => 2774
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1821
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.point_id AS point_id_2 FROM node t0 WHERE t0.id = ?"
  "params" => [
    1 => 810
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1821
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.x AS x_2, t0.y AS y_3, t0.floor_id AS floor_id_4 FROM point t0 WHERE t0.id = ?"
  "params" => [
    1 => 3732
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1821
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.point_id AS point_id_2 FROM node t0 WHERE t0.id = ?"
  "params" => [
    1 => 811
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1821
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.x AS x_2, t0.y AS y_3, t0.floor_id AS floor_id_4 FROM point t0 WHERE t0.id = ?"
  "params" => [
    1 => 3733
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1821
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.point_id AS point_id_2 FROM node t0 WHERE t0.id = ?"
  "params" => [
    1 => 517
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1821
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.x AS x_2, t0.y AS y_3, t0.floor_id AS floor_id_4 FROM point t0 WHERE t0.id = ?"
  "params" => [
    1 => 3265
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1821
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.point_id AS point_id_2 FROM node t0 WHERE t0.id = ?"
  "params" => [
    1 => 520
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1821
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.x AS x_2, t0.y AS y_3, t0.floor_id AS floor_id_4 FROM point t0 WHERE t0.id = ?"
  "params" => [
    1 => 3268
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1821
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.point_id AS point_id_2 FROM node t0 WHERE t0.id = ?"
  "params" => [
    1 => 813
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1821
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.x AS x_2, t0.y AS y_3, t0.floor_id AS floor_id_4 FROM point t0 WHERE t0.id = ?"
  "params" => [
    1 => 3779
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1821
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.point_id AS point_id_2 FROM node t0 WHERE t0.id = ?"
  "params" => [
    1 => 814
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1821
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.x AS x_2, t0.y AS y_3, t0.floor_id AS floor_id_4 FROM point t0 WHERE t0.id = ?"
  "params" => [
    1 => 3780
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1821
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.point_id AS point_id_2 FROM node t0 WHERE t0.id = ?"
  "params" => [
    1 => 821
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1821
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.x AS x_2, t0.y AS y_3, t0.floor_id AS floor_id_4 FROM point t0 WHERE t0.id = ?"
  "params" => [
    1 => 3811
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1821
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.point_id AS point_id_2 FROM node t0 WHERE t0.id = ?"
  "params" => [
    1 => 819
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1821
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.x AS x_2, t0.y AS y_3, t0.floor_id AS floor_id_4 FROM point t0 WHERE t0.id = ?"
  "params" => [
    1 => 3809
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1821
      +name: "INTEGER"
    }
  ]
]

[
  "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\Component\Security\Http\RememberMe\ResponseListener::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"
]