Symfony Profiler

[
  "route" => "public_web_search_embeds"
  "route_parameters" => [
    "_route" => "public_web_search_embeds"
    "page" => null
    "_controller" => "App\PostPublic\Controller\Embed\Search\ActionController"
    "_locale" => "ru"
  ]
  "request_uri" => "https://search.jues.net/search/embeds?q=%D0%BA%D0%B0%D0%B7%D0%B0%D1%85"
  "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 `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1"
  "params" => [
    1 => "казах"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1181
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1"
  "params" => [
    1 => b"\x01“\x08˜³0rO…òH\x1D9;\x1E9"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1181
      +name: "STRING"
    }
  ]
]

[
  "sql" => """
    \n
                SELECT COUNT(*) as `total_posts`\n
                FROM `trend_has_post` as `t0`\n
                INNER JOIN `post` as `p` ON (trend_id = ? AND p.post_id = t0.post_id)\n
                WHERE p.type = ? AND `p`.`status` = ?\n
            
    """
  "params" => [
    1 => b"\x01“\x08˜³0rO…òH\x1D9;\x1E9"
    2 => 0
    3 => 10
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1181
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1216
      +name: "INTEGER"
    }
    3 => Doctrine\DBAL\ParameterType {#1216}
  ]
]

[
  "sql" => """
    \n
                SELECT COUNT(*)\n
                FROM `trend_has_post` as `t0`\n
                INNER JOIN `post` as `p` ON (trend_id = ? AND p.post_id = t0.post_id)\n
                WHERE p.type = ? AND `p`.`status` = ? AND `t0`.`is_tested` = 1\n
            
    """
  "params" => [
    1 => b"\x01“\x08˜³0rO…òH\x1D9;\x1E9"
    2 => 0
    3 => 10
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1181
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1216
      +name: "INTEGER"
    }
    3 => Doctrine\DBAL\ParameterType {#1216}
  ]
]

[
  "sql" => "SELECT t0.post_id FROM trend_has_post t0 INNER JOIN post p ON trend_id = ? AND p.post_id = t0.post_id WHERE (p.type = ? AND p.status = ?) AND (t0.is_tested = 0) ORDER BY t0.ctr DESC LIMIT 120"
  "params" => [
    1 => b"\x01“\x08˜³0rO…òH\x1D9;\x1E9"
    2 => 0
    3 => 10
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1181
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1216
      +name: "INTEGER"
    }
    3 => Doctrine\DBAL\ParameterType {#1216}
  ]
]

[
  "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 => 470606
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1181
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1181}
    3 => Doctrine\DBAL\ParameterType {#1216
      +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 => 470606
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1181
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1181}
    3 => Doctrine\DBAL\ParameterType {#1216
      +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 => 470606
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1181
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1181}
    3 => Doctrine\DBAL\ParameterType {#1216
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT `query_id` FROM `search_log` WHERE `query` = ?"
  "params" => [
    1 => "каз"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1181
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT `trend_id` FROM `trend` WHERE `subject` = ?"
  "params" => [
    1 => "каз"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1181
      +name: "STRING"
    }
  ]
]

[
  "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 `query_id`, `cover`, `query`, MATCH (`query`) AGAINST (?) AS `relevance`\n
                FROM `search_log`\n
                WHERE MATCH (`query`) AGAINST (?)\n
                  AND `query` <> ?\n
                  AND `blocked` = 0\n
                ORDER BY `relevance` DESC\n
                LIMIT ?\n
            
    """
  "params" => [
    1 => "казах"
    2 => "казах"
    3 => "казах"
    4 => 20
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1181
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1181}
    3 => Doctrine\DBAL\ParameterType {#1181}
    4 => Doctrine\DBAL\ParameterType {#1216
      +name: "INTEGER"
    }
  ]
]

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

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