Symfony Profiler

[
  "route" => "app_post_index"
  "route_parameters" => [
    "_route" => "app_post_index"
    "_controller" => "App\Controller\HomeController::postlist"
    "_locale" => "kk"
    "type" => "post"
  ]
  "request_uri" => "https://qarlygash.qr-pib.kz/post/?page=52"
  "method" => "GET"
]

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

[
  "firewall_name" => "main"
  "authenticator" => "App\Security\AppCustomAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "App\Security\AppCustomAuthenticator"
]

[
  "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\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" => "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventListener\DoctrineFilterListener::onKernelController"
]

[
  "event" => "kernel.request"
  "listener" => "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Stof\DoctrineExtensionsBundle\EventListener\LocaleListener::onKernelRequest"
]

[
  "event" => "kernel.controller"
  "listener" => "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelController"
]

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

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

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

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController"
]

[
  "params" => [
    "url" => "<redacted>"
    "driver" => "pdo_mysql"
    "host" => "192.168.15.152"
    "port" => 3306
    "user" => "qrpibkz_read"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "qrpibkz"
    "serverVersion" => "10"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT n0_.id AS id_0, n0_.body AS body_1, n0_.domain AS domain_2, n0_.created_by AS created_by_3, n0_.updated_by AS updated_by_4 FROM nav n0_ WHERE (n0_.domain = ?) AND (n0_.domain = 'qarlygash.qr-pib.kz')"
  "params" => [
    1 => "qarlygash.qr-pib.kz"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?"
  "params" => [
    1 => "14"
    2 => "kk"
    3 => "App\Entity\Nav"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "App\EventListener\NavigationListener::onKernelController"
]

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

[
  "event" => "kernel.controller_arguments"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\SecurityListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\IsGrantedListener::onKernelControllerArguments"
]

[
  "event" => "knp_pager.before"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Sortable\SortableSubscriber::before"
]

[
  "event" => "knp_pager.before"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Filtration\FiltrationSubscriber::before"
]

[
  "event" => "knp_pager.before"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\PaginationSubscriber::before"
]

[
  "sql" => "SELECT count(DISTINCT p0_.id) AS sclr_0 FROM post p0_ INNER JOIN ext_translations t1_ ON t1_.locale = 'kk' AND t1_.field = 'title' AND t1_.object_class = 'App\\Entity\\Post' AND t1_.foreign_key = p0_.id INNER JOIN ext_translations t2_ ON t2_.locale = 'kk' AND t2_.field = 'content' AND t2_.object_class = 'App\\Entity\\Post' AND t2_.foreign_key = p0_.id WHERE (p0_.type = ? AND t1_.content <> '' AND p0_.is_active = 1 AND p0_.published_at < CURRENT_TIMESTAMP) AND (p0_.domain = 'qarlygash.qr-pib.kz') AND (p0_.deleted_at IS NULL)"
  "params" => [
    1 => "post"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT DISTINCT p0_.id AS id_0, p0_.published_at AS published_at_1 FROM post p0_ INNER JOIN ext_translations t1_ ON t1_.locale = 'kk' AND t1_.field = 'title' AND t1_.object_class = 'App\\Entity\\Post' AND t1_.foreign_key = p0_.id INNER JOIN ext_translations t2_ ON t2_.locale = 'kk' AND t2_.field = 'content' AND t2_.object_class = 'App\\Entity\\Post' AND t2_.foreign_key = p0_.id WHERE (p0_.type = ? AND t1_.content <> '' AND p0_.is_active = 1 AND p0_.published_at < CURRENT_TIMESTAMP) AND (p0_.domain = 'qarlygash.qr-pib.kz') AND (p0_.deleted_at IS NULL) ORDER BY p0_.published_at DESC LIMIT 10 OFFSET 510"
  "params" => [
    1 => "post"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.published_at AS published_at_1, t1_.content AS title_2, p0_.slug AS slug_3, p0_.summary AS summary_4, t2_.content AS content_5, p0_.is_active AS is_active_6, p0_.type AS type_7, p0_.template AS template_8, p0_.counter AS counter_9, p0_.modified_at AS modified_at_10, p0_.id_old AS id_old_11, p0_.template_old AS template_old_12, p0_.is_slider_active AS is_slider_active_13, p0_.domain AS domain_14, p0_.created_at AS created_at_15, p0_.updated_at AS updated_at_16, p0_.deleted_at AS deleted_at_17, p0_.author_id AS author_id_18, p0_.parent_id AS parent_id_19, p0_.created_by AS created_by_20, p0_.updated_by AS updated_by_21 FROM post p0_ INNER JOIN ext_translations t1_ ON t1_.locale = 'kk' AND t1_.field = 'title' AND t1_.object_class = 'App\\Entity\\Post' AND t1_.foreign_key = p0_.id INNER JOIN ext_translations t2_ ON t2_.locale = 'kk' AND t2_.field = 'content' AND t2_.object_class = 'App\\Entity\\Post' AND t2_.foreign_key = p0_.id WHERE (p0_.type = ? AND t1_.content <> '' AND p0_.is_active = 1 AND p0_.published_at < CURRENT_TIMESTAMP AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (p0_.domain = 'qarlygash.qr-pib.kz') AND (p0_.deleted_at IS NULL) ORDER BY p0_.published_at DESC"
  "params" => [
    1 => "post"
    2 => 14908
    3 => 14910
    4 => 14904
    5 => 14902
    6 => 14900
    7 => 14898
    8 => 14906
    9 => 14896
    10 => 14894
    11 => 14890
  ]
  "types" => [
    1 => 2
    2 => 1
    3 => 1
    4 => 1
    5 => 1
    6 => 1
    7 => 1
    8 => 1
    9 => 1
    10 => 1
    11 => 1
  ]
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QueryBuilderSubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ODM\MongoDB\QueryBuilderSubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ODM\PHPCR\QueryBuilderSubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\DBALQueryBuilderSubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Sortable\Doctrine\ORM\QuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Sortable\Doctrine\ODM\MongoDB\QuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Sortable\ElasticaQuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Sortable\PropelQuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Sortable\SolariumQuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Sortable\ArraySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Filtration\Doctrine\ORM\QuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Filtration\PropelQuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Callback\CallbackSubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ODM\MongoDB\QuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ODM\PHPCR\QuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\CollectionSubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\PropelQuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\SolariumQuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\ElasticaQuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\ArraySubscriber::items"
]

[
  "event" => "knp_pager.pagination"
  "listener" => "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::pagination"
]

[
  "event" => "knp_pager.pagination"
  "listener" => "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::pagination"
]

[
  "event" => "knp_pager.pagination"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\PaginationSubscriber::pagination"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.path AS path_2, t0.image_name AS image_name_3, t0.image_size AS image_size_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.domain AS domain_7, t0.post_id AS post_id_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10 FROM attachment t0 WHERE t0.post_id = ? AND ((t0.domain = 'qarlygash.qr-pib.kz'))"
  "params" => [
    1 => 14908
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.path AS path_2, t0.image_name AS image_name_3, t0.image_size AS image_size_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.domain AS domain_7, t0.post_id AS post_id_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10 FROM attachment t0 WHERE t0.post_id = ? AND ((t0.domain = 'qarlygash.qr-pib.kz'))"
  "params" => [
    1 => 14910
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.path AS path_2, t0.image_name AS image_name_3, t0.image_size AS image_size_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.domain AS domain_7, t0.post_id AS post_id_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10 FROM attachment t0 WHERE t0.post_id = ? AND ((t0.domain = 'qarlygash.qr-pib.kz'))"
  "params" => [
    1 => 14904
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.path AS path_2, t0.image_name AS image_name_3, t0.image_size AS image_size_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.domain AS domain_7, t0.post_id AS post_id_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10 FROM attachment t0 WHERE t0.post_id = ? AND ((t0.domain = 'qarlygash.qr-pib.kz'))"
  "params" => [
    1 => 14902
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.path AS path_2, t0.image_name AS image_name_3, t0.image_size AS image_size_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.domain AS domain_7, t0.post_id AS post_id_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10 FROM attachment t0 WHERE t0.post_id = ? AND ((t0.domain = 'qarlygash.qr-pib.kz'))"
  "params" => [
    1 => 14900
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.path AS path_2, t0.image_name AS image_name_3, t0.image_size AS image_size_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.domain AS domain_7, t0.post_id AS post_id_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10 FROM attachment t0 WHERE t0.post_id = ? AND ((t0.domain = 'qarlygash.qr-pib.kz'))"
  "params" => [
    1 => 14898
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.path AS path_2, t0.image_name AS image_name_3, t0.image_size AS image_size_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.domain AS domain_7, t0.post_id AS post_id_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10 FROM attachment t0 WHERE t0.post_id = ? AND ((t0.domain = 'qarlygash.qr-pib.kz'))"
  "params" => [
    1 => 14906
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.path AS path_2, t0.image_name AS image_name_3, t0.image_size AS image_size_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.domain AS domain_7, t0.post_id AS post_id_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10 FROM attachment t0 WHERE t0.post_id = ? AND ((t0.domain = 'qarlygash.qr-pib.kz'))"
  "params" => [
    1 => 14896
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.path AS path_2, t0.image_name AS image_name_3, t0.image_size AS image_size_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.domain AS domain_7, t0.post_id AS post_id_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10 FROM attachment t0 WHERE t0.post_id = ? AND ((t0.domain = 'qarlygash.qr-pib.kz'))"
  "params" => [
    1 => 14894
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.path AS path_2, t0.image_name AS image_name_3, t0.image_size AS image_size_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.domain AS domain_7, t0.post_id AS post_id_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10 FROM attachment t0 WHERE t0.post_id = ? AND ((t0.domain = 'qarlygash.qr-pib.kz'))"
  "params" => [
    1 => 14890
  ]
  "types" => [
    1 => 1
  ]
]

[
  "event" => "kernel.response"
  "listener" => "App\EventListener\SessionListener::onKernelController"
]

[
  "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" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelResponse"
]

[
  "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" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest"
]