Symfony Profiler

[
  "route" => "public_web_post_view"
  "route_parameters" => [
    "_route" => "public_web_post_view"
    "_controller" => "App\PostPublic\Controller\Post\View\ActionController"
    "_locale" => "ru"
    "publicKey" => "JZB3Ii_"
  ]
  "request_uri" => "https://search.jues.net/post/JZB3Ii_"
  "method" => "GET"
]

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

[
  "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\Bridge\Doctrine\Middleware\IdleConnection\Listener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "App\Infrastructure\EventListener\NormalizeUserQueryOnRequestEvent::__invoke"
]

[
  "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\LocaleListener::setDefaultLocale"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\FragmentListener::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\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"
]

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "188.208.197.146"
    "port" => 3306
    "user" => "test"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "search_project"
    "serverVersion" => "8.0.26"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`"
]

[
  "event" => "kernel.controller"
  "listener" => "App\Language\EventListener\CookieLangSwitcher::__invoke"
]

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

[
  "event" => "kernel.controller"
  "listener" => "App\Infrastructure\EventSubscriber\CleanFirstPageUrlSubscriber::redirectFirstPage"
]

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

[
  "sql" => "SELECT p.post_id, p.user_id, p.content_id, p.channel_id, p.public_key, p.cover, p.type, p.sexual_orientation, p.orientation, p.quality, p.noindex, p.nofollow, p.contents_num, p.duration, p.likes, p.dislikes, p.views, p.vote_rating, p.params, p.status, p.published_at, u.username, IFNULL(`r`.`title`, `f`.`title`) as `title`, IFNULL(`r`.`description`, `f`.`description`) as `description`, IFNULL(`r`.`custom1`, `f`.`custom1`) as `custom1`, IFNULL(`r`.`custom2`, `f`.`custom2`) as `custom2` FROM post p LEFT JOIN post_translation f ON `p`.`post_id` = `f`.`post_id` AND `f`.`lang_id`=? LEFT JOIN user u ON `p`.`user_id` = `u`.`user_id` LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id`  AND  `r`.`lang_id`=? WHERE `p`.`public_key` = ? LIMIT 1"
  "params" => [
    1 => 1
    2 => 2
    3 => "JZB3Ii_"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#610
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#610}
    3 => Doctrine\DBAL\ParameterType {#610}
  ]
]

[
  "sql" => "SELECT pc.content_id, pc.post_id, pc.path, pc.width, pc.height FROM post_content pc WHERE pc.post_id IN (?)"
  "params" => [
    1 => 517040
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#622
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT pht.post_id, pht.tag_id, t.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_tag pht INNER JOIN tag t ON pht.tag_id = t.tag_id AND t.enabled = 1 LEFT JOIN tag_translation f ON t.tag_id = f.tag_id AND f.lang_id=? LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=? WHERE pht.post_id IN (?)"
  "params" => [
    1 => 1
    2 => 2
    3 => 517040
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#610
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#610}
    3 => Doctrine\DBAL\ParameterType {#622
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT phc.post_id, phc.category_id, c.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_category phc INNER JOIN category c ON phc.category_id = c.category_id AND c.enabled = 1 LEFT JOIN category_translation f ON c.category_id = f.category_id  AND  f.lang_id=? LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id`  AND  `r`.`lang_id`=? WHERE phc.post_id IN (?)"
  "params" => [
    1 => 1
    2 => 2
    3 => 517040
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#610
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#610}
    3 => Doctrine\DBAL\ParameterType {#622
      +name: "INTEGER"
    }
  ]
]

[
  "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\Bridge\Doctrine\Middleware\IdleConnection\Listener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "App\Infrastructure\EventListener\NormalizeUserQueryOnRequestEvent::__invoke"
]

[
  "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\LocaleListener::setDefaultLocale"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\FragmentListener::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\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.controller"
  "listener" => "App\Language\EventListener\CookieLangSwitcher::__invoke"
]

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

[
  "event" => "kernel.controller"
  "listener" => "App\Infrastructure\EventSubscriber\CleanFirstPageUrlSubscriber::redirectFirstPage"
]

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

[
  "sql" => """
    \n
                    SELECT `phr`.`related_id`\n
                    FROM `post_has_related` as `phr`\n
                    LEFT JOIN `post` as `p` USING (`post_id`)\n
                    WHERE `phr`.`post_id` = ? AND `p`.`status` = ?\n
                    LIMIT ?\n
                    OFFSET ?\n
                
    """
  "params" => [
    1 => 517040
    2 => 10
    3 => 3
    4 => 0
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#622
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#622}
    3 => Doctrine\DBAL\ParameterType {#622}
    4 => Doctrine\DBAL\ParameterType {#622}
  ]
]

[
  "sql" => "SELECT p.post_id, p.user_id, p.content_id, p.public_key, p.search_field, p.cover, p.type, p.sexual_orientation, p.orientation, p.quality, p.noindex, p.nofollow, p.contents_num, p.duration, p.likes, p.dislikes, p.views, p.vote_rating, p.params, p.published_at, IFNULL(`r`.`title`, `f`.`title`) as `title`, IFNULL(`r`.`custom1`, `f`.`custom1`) as `custom1`, IFNULL(`r`.`custom2`, `f`.`custom2`) as `custom2` FROM post p LEFT JOIN post_translation f ON `p`.`post_id` = `f`.`post_id`  AND  `f`.`lang_id`=? LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id`  AND  `r`.`lang_id`=? WHERE p.post_id IN (?, ?, ?)"
  "params" => [
    1 => 1
    2 => 2
    3 => 401637
    4 => 405438
    5 => 416012
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#610
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#610}
    3 => Doctrine\DBAL\ParameterType {#622
      +name: "INTEGER"
    }
    4 => Doctrine\DBAL\ParameterType {#622}
    5 => Doctrine\DBAL\ParameterType {#622}
  ]
]

[
  "sql" => "SELECT pht.post_id, pht.tag_id, t.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_tag pht INNER JOIN tag t ON pht.tag_id = t.tag_id AND t.enabled = 1 LEFT JOIN tag_translation f ON t.tag_id = f.tag_id AND f.lang_id=? LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=? WHERE pht.post_id IN (?, ?, ?)"
  "params" => [
    1 => 1
    2 => 2
    3 => 401637
    4 => 405438
    5 => 416012
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#610
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#610}
    3 => Doctrine\DBAL\ParameterType {#622
      +name: "INTEGER"
    }
    4 => Doctrine\DBAL\ParameterType {#622}
    5 => Doctrine\DBAL\ParameterType {#622}
  ]
]

[
  "sql" => "SELECT phc.post_id, phc.category_id, c.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_category phc INNER JOIN category c ON phc.category_id = c.category_id AND c.enabled = 1 LEFT JOIN category_translation f ON c.category_id = f.category_id  AND  f.lang_id=? LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id`  AND  `r`.`lang_id`=? WHERE phc.post_id IN (?, ?, ?)"
  "params" => [
    1 => 1
    2 => 2
    3 => 401637
    4 => 405438
    5 => 416012
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#610
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#610}
    3 => Doctrine\DBAL\ParameterType {#622
      +name: "INTEGER"
    }
    4 => Doctrine\DBAL\ParameterType {#622}
    5 => Doctrine\DBAL\ParameterType {#622}
  ]
]

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

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

[
  "event" => "kernel.controller_arguments"
  "listener" => "App\Infrastructure\EventSubscriber\ResponseCacheSubscriber::cache"
]

[
  "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" => "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\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" => "App\PostPublic\EventListener\IncrPostViewOnFinishRequestSubscriber::__invoke"
]

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

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

[
  "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\Bridge\Doctrine\Middleware\IdleConnection\Listener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "App\Infrastructure\EventListener\NormalizeUserQueryOnRequestEvent::__invoke"
]

[
  "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\LocaleListener::setDefaultLocale"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\FragmentListener::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\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.controller"
  "listener" => "App\Language\EventListener\CookieLangSwitcher::__invoke"
]

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

[
  "event" => "kernel.controller"
  "listener" => "App\Infrastructure\EventSubscriber\CleanFirstPageUrlSubscriber::redirectFirstPage"
]

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

[
  "sql" => """
    \n
                    SELECT `phr`.`related_id`\n
                    FROM `post_has_related` as `phr`\n
                    LEFT JOIN `post` as `p` USING (`post_id`)\n
                    WHERE `phr`.`post_id` = ? AND `p`.`status` = ?\n
                    LIMIT ?\n
                    OFFSET ?\n
                
    """
  "params" => [
    1 => 517040
    2 => 10
    3 => 30
    4 => 3
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#622
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#622}
    3 => Doctrine\DBAL\ParameterType {#622}
    4 => Doctrine\DBAL\ParameterType {#622}
  ]
]

[
  "sql" => "SELECT p.post_id, p.user_id, p.content_id, p.public_key, p.search_field, p.cover, p.type, p.sexual_orientation, p.orientation, p.quality, p.noindex, p.nofollow, p.contents_num, p.duration, p.likes, p.dislikes, p.views, p.vote_rating, p.params, p.published_at, IFNULL(`r`.`title`, `f`.`title`) as `title`, IFNULL(`r`.`custom1`, `f`.`custom1`) as `custom1`, IFNULL(`r`.`custom2`, `f`.`custom2`) as `custom2` FROM post p LEFT JOIN post_translation f ON `p`.`post_id` = `f`.`post_id`  AND  `f`.`lang_id`=? LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id`  AND  `r`.`lang_id`=? WHERE p.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => 1
    2 => 2
    3 => 420540
    4 => 425622
    5 => 431302
    6 => 435479
    7 => 446706
    8 => 448404
    9 => 450797
    10 => 452149
    11 => 452511
    12 => 462459
    13 => 464379
    14 => 465831
    15 => 471806
    16 => 472909
    17 => 474447
    18 => 474761
    19 => 485134
    20 => 485216
    21 => 491359
    22 => 491784
    23 => 493221
    24 => 496103
    25 => 499787
    26 => 502510
    27 => 508737
    28 => 513940
    29 => 519940
    30 => 520876
    31 => 523352
    32 => 525152
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#610
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#610}
    3 => Doctrine\DBAL\ParameterType {#622
      +name: "INTEGER"
    }
    4 => Doctrine\DBAL\ParameterType {#622}
    5 => Doctrine\DBAL\ParameterType {#622}
    6 => Doctrine\DBAL\ParameterType {#622}
    7 => Doctrine\DBAL\ParameterType {#622}
    8 => Doctrine\DBAL\ParameterType {#622}
    9 => Doctrine\DBAL\ParameterType {#622}
    10 => Doctrine\DBAL\ParameterType {#622}
    11 => Doctrine\DBAL\ParameterType {#622}
    12 => Doctrine\DBAL\ParameterType {#622}
    13 => Doctrine\DBAL\ParameterType {#622}
    14 => Doctrine\DBAL\ParameterType {#622}
    15 => Doctrine\DBAL\ParameterType {#622}
    16 => Doctrine\DBAL\ParameterType {#622}
    17 => Doctrine\DBAL\ParameterType {#622}
    18 => Doctrine\DBAL\ParameterType {#622}
    19 => Doctrine\DBAL\ParameterType {#622}
    20 => Doctrine\DBAL\ParameterType {#622}
    21 => Doctrine\DBAL\ParameterType {#622}
    22 => Doctrine\DBAL\ParameterType {#622}
    23 => Doctrine\DBAL\ParameterType {#622}
    24 => Doctrine\DBAL\ParameterType {#622}
    25 => Doctrine\DBAL\ParameterType {#622}
    26 => Doctrine\DBAL\ParameterType {#622}
    27 => Doctrine\DBAL\ParameterType {#622}
    28 => Doctrine\DBAL\ParameterType {#622}
    29 => Doctrine\DBAL\ParameterType {#622}
    30 => Doctrine\DBAL\ParameterType {#622}
    31 => Doctrine\DBAL\ParameterType {#622}
    32 => Doctrine\DBAL\ParameterType {#622}
  ]
]

[
  "sql" => "SELECT pht.post_id, pht.tag_id, t.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_tag pht INNER JOIN tag t ON pht.tag_id = t.tag_id AND t.enabled = 1 LEFT JOIN tag_translation f ON t.tag_id = f.tag_id AND f.lang_id=? LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=? WHERE pht.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => 1
    2 => 2
    3 => 420540
    4 => 425622
    5 => 431302
    6 => 435479
    7 => 446706
    8 => 448404
    9 => 450797
    10 => 452149
    11 => 452511
    12 => 462459
    13 => 464379
    14 => 465831
    15 => 471806
    16 => 472909
    17 => 474447
    18 => 474761
    19 => 485134
    20 => 485216
    21 => 491359
    22 => 491784
    23 => 493221
    24 => 496103
    25 => 499787
    26 => 502510
    27 => 508737
    28 => 513940
    29 => 519940
    30 => 520876
    31 => 523352
    32 => 525152
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#610
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#610}
    3 => Doctrine\DBAL\ParameterType {#622
      +name: "INTEGER"
    }
    4 => Doctrine\DBAL\ParameterType {#622}
    5 => Doctrine\DBAL\ParameterType {#622}
    6 => Doctrine\DBAL\ParameterType {#622}
    7 => Doctrine\DBAL\ParameterType {#622}
    8 => Doctrine\DBAL\ParameterType {#622}
    9 => Doctrine\DBAL\ParameterType {#622}
    10 => Doctrine\DBAL\ParameterType {#622}
    11 => Doctrine\DBAL\ParameterType {#622}
    12 => Doctrine\DBAL\ParameterType {#622}
    13 => Doctrine\DBAL\ParameterType {#622}
    14 => Doctrine\DBAL\ParameterType {#622}
    15 => Doctrine\DBAL\ParameterType {#622}
    16 => Doctrine\DBAL\ParameterType {#622}
    17 => Doctrine\DBAL\ParameterType {#622}
    18 => Doctrine\DBAL\ParameterType {#622}
    19 => Doctrine\DBAL\ParameterType {#622}
    20 => Doctrine\DBAL\ParameterType {#622}
    21 => Doctrine\DBAL\ParameterType {#622}
    22 => Doctrine\DBAL\ParameterType {#622}
    23 => Doctrine\DBAL\ParameterType {#622}
    24 => Doctrine\DBAL\ParameterType {#622}
    25 => Doctrine\DBAL\ParameterType {#622}
    26 => Doctrine\DBAL\ParameterType {#622}
    27 => Doctrine\DBAL\ParameterType {#622}
    28 => Doctrine\DBAL\ParameterType {#622}
    29 => Doctrine\DBAL\ParameterType {#622}
    30 => Doctrine\DBAL\ParameterType {#622}
    31 => Doctrine\DBAL\ParameterType {#622}
    32 => Doctrine\DBAL\ParameterType {#622}
  ]
]

[
  "sql" => "SELECT phc.post_id, phc.category_id, c.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_category phc INNER JOIN category c ON phc.category_id = c.category_id AND c.enabled = 1 LEFT JOIN category_translation f ON c.category_id = f.category_id  AND  f.lang_id=? LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id`  AND  `r`.`lang_id`=? WHERE phc.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => 1
    2 => 2
    3 => 420540
    4 => 425622
    5 => 431302
    6 => 435479
    7 => 446706
    8 => 448404
    9 => 450797
    10 => 452149
    11 => 452511
    12 => 462459
    13 => 464379
    14 => 465831
    15 => 471806
    16 => 472909
    17 => 474447
    18 => 474761
    19 => 485134
    20 => 485216
    21 => 491359
    22 => 491784
    23 => 493221
    24 => 496103
    25 => 499787
    26 => 502510
    27 => 508737
    28 => 513940
    29 => 519940
    30 => 520876
    31 => 523352
    32 => 525152
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#610
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#610}
    3 => Doctrine\DBAL\ParameterType {#622
      +name: "INTEGER"
    }
    4 => Doctrine\DBAL\ParameterType {#622}
    5 => Doctrine\DBAL\ParameterType {#622}
    6 => Doctrine\DBAL\ParameterType {#622}
    7 => Doctrine\DBAL\ParameterType {#622}
    8 => Doctrine\DBAL\ParameterType {#622}
    9 => Doctrine\DBAL\ParameterType {#622}
    10 => Doctrine\DBAL\ParameterType {#622}
    11 => Doctrine\DBAL\ParameterType {#622}
    12 => Doctrine\DBAL\ParameterType {#622}
    13 => Doctrine\DBAL\ParameterType {#622}
    14 => Doctrine\DBAL\ParameterType {#622}
    15 => Doctrine\DBAL\ParameterType {#622}
    16 => Doctrine\DBAL\ParameterType {#622}
    17 => Doctrine\DBAL\ParameterType {#622}
    18 => Doctrine\DBAL\ParameterType {#622}
    19 => Doctrine\DBAL\ParameterType {#622}
    20 => Doctrine\DBAL\ParameterType {#622}
    21 => Doctrine\DBAL\ParameterType {#622}
    22 => Doctrine\DBAL\ParameterType {#622}
    23 => Doctrine\DBAL\ParameterType {#622}
    24 => Doctrine\DBAL\ParameterType {#622}
    25 => Doctrine\DBAL\ParameterType {#622}
    26 => Doctrine\DBAL\ParameterType {#622}
    27 => Doctrine\DBAL\ParameterType {#622}
    28 => Doctrine\DBAL\ParameterType {#622}
    29 => Doctrine\DBAL\ParameterType {#622}
    30 => Doctrine\DBAL\ParameterType {#622}
    31 => Doctrine\DBAL\ParameterType {#622}
    32 => Doctrine\DBAL\ParameterType {#622}
  ]
]

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

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

[
  "event" => "kernel.controller_arguments"
  "listener" => "App\Infrastructure\EventSubscriber\ResponseCacheSubscriber::cache"
]

[
  "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" => "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\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" => "App\PostPublic\EventListener\IncrPostViewOnFinishRequestSubscriber::__invoke"
]

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

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

[
  "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\Bridge\Doctrine\Middleware\IdleConnection\Listener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "App\Infrastructure\EventListener\NormalizeUserQueryOnRequestEvent::__invoke"
]

[
  "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\LocaleListener::setDefaultLocale"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\FragmentListener::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\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.controller"
  "listener" => "App\Language\EventListener\CookieLangSwitcher::__invoke"
]

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

[
  "event" => "kernel.controller"
  "listener" => "App\Infrastructure\EventSubscriber\CleanFirstPageUrlSubscriber::redirectFirstPage"
]

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

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

[
  "event" => "kernel.controller_arguments"
  "listener" => "App\Infrastructure\EventSubscriber\ResponseCacheSubscriber::cache"
]

[
  "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" => "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\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" => "App\PostPublic\EventListener\IncrPostViewOnFinishRequestSubscriber::__invoke"
]

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

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

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

[
  "sql" => "UPDATE `post` SET `views` = `views` + 1 WHERE `public_key` = ?"
  "params" => [
    1 => "JZB3Ii_"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#610
      +name: "STRING"
    }
  ]
]

[
  "event" => "kernel.finish_request"
  "listener" => "App\PostPublic\EventListener\IncrPostViewOnFinishRequestSubscriber::__invoke"
]

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

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