Symfony Profiler

[
  "route" => "public_web_movie_clip_view"
  "route_parameters" => [
    "_route" => "public_web_movie_clip_view"
    "_controller" => "App\MovieClip\Presentation\Controller\Public\View\ActionController"
    "_locale" => "ru"
    "publicKey" => "WFBcHFw"
  ]
  "request_uri" => "https://dev.muviki.cc/movie/WFBcHFw"
  "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" => "127.0.0.1"
    "port" => 3306
    "user" => "razrab"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "dev_muviki_cc"
    "serverVersion" => "8.0.40"
    "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 mc.clip_id, mc.user_id, mc.film_id, mc.public_key, mc.thumb_path, mc.preview_path, mc.duration, mc.quality, mc.is_vertical, mc.likes, mc.dislikes, mc.views, mc.status, mc.published_at, u.username, IFNULL(r.title, f.title) as title, IFNULL(r.description, f.description) as description FROM movie_clip mc LEFT JOIN movie_clip_translation f ON mc.clip_id = f.clip_id AND f.lang_id=? LEFT JOIN user u ON mc.user_id = u.user_id LEFT JOIN movie_clip_translation r ON mc.clip_id = r.clip_id  AND r.lang_id=? WHERE mc.public_key = ? LIMIT 1"
  "params" => [
    1 => 1
    2 => 2
    3 => "WFBcHFw"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#551
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#551}
    3 => Doctrine\DBAL\ParameterType {#551}
  ]
]

[
  "sql" => "    SELECT `path` FROM `movie_clip_media` WHERE `clip_id` = ?"
  "params" => [
    1 => b"""
      \x01Ž°\n
      ÅLs–¿PLºâ]\x16Ê
      """
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#551
      +name: "STRING"
    }
  ]
]

[
  "sql" => """
        SELECT film_id,\n
               original_title,\n
               title,\n
               poster_path,\n
               release_year\n
        FROM `film`\n
        WHERE `film_id` = ?
    """
  "params" => [
    1 => b"\x01–\x05\fÙér\x05£ªõR†)ä¦"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#551
      +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 `mchr`.`related_id`\n
                    FROM `movie_clip_has_related` as `mchr`\n
                    LEFT JOIN `movie_clip` as `mc` USING (`clip_id`)\n
                    WHERE `mchr`.`clip_id` = ? AND `mc`.`status` = ?\n
                    ORDER BY `mchr`.`relevance` DESC\n
                    LIMIT ?\n
                    OFFSET ?\n
                
    """
  "params" => [
    1 => b"""
      \x01Ž°\n
      ÅLs–¿PLºâ]\x16Ê
      """
    2 => 10
    3 => 24
    4 => 0
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#551
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#563
      +name: "INTEGER"
    }
    3 => Doctrine\DBAL\ParameterType {#563}
    4 => Doctrine\DBAL\ParameterType {#563}
  ]
]

[
  "sql" => "SELECT mc.clip_id, mc.film_id, mc.public_key, mc.thumb_path, mc.preview_path, mc.duration, mc.quality, mc.is_vertical, mc.likes, mc.dislikes, mc.views, mc.status, mc.published_at, f1.title as film_title, f1.original_title as film_original_title, f1.poster_path as film_poster_path, f1.release_year as film_release_year, IFNULL(r.title, f.title) as title FROM movie_clip mc LEFT JOIN movie_clip_translation f ON mc.clip_id = f.clip_id AND f.lang_id=? LEFT JOIN film f1 ON mc.film_id = f1.film_id LEFT JOIN movie_clip_translation r ON mc.clip_id = r.clip_id  AND r.lang_id=? WHERE mc.clip_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => 1
    2 => 2
    3 => b"""
      \x01Ž°\n
      ±õsL™Uâ\x05?¢Ì¹
      """
    4 => b"""
      \x01Ž°\n
      ×Os, )\x01\x13w\x1AÃá
      """
    5 => b"""
      \x01Ž°\n
      éÈqÓœ\ee.$Í¿0
      """
    6 => b"\x01Ž°\v\x05;pB¼µ¬_\x01‰\x1Eå"
    7 => b"\x01Ž°\vü|s\x12§eƒÐe÷-#"
    8 => b"\x01Ž°\f\x0Eúrhðc­\x14†7ä"
    9 => b"\x01Ž°\f!ôpÚ­Á­\x1C›øA+"
    10 => b"\x01Ž°\f:írÞ…ÇHë¢C<7"
    11 => b"\x01ŽÞ½¯¸s2Œ·`(¤¬år"
    12 => b"\x01Ž¯Ávrõ¹Ž÷ÌÁ¯\x03é"
    13 => b"\x01Ž¯®Ã\x02pi‰b:×=Žfž"
    14 => b"\x01Ž½ \x03³s\t€Ô§ ?‹Ÿ+"
    15 => b"\x01Ž¯Ðþbr~±\x01èÛ\x1C¥`%"
    16 => b"\x01Žã‹Å\x1Ar°°\x05\x16\x00ì9k+"
    17 => b"\x01Ž×YÏWs{œè½J\x1FK\x08‡"
    18 => b"\x01Ž×Xã!pSœ\x10\x18)K,V\x13"
    19 => b"\x01Ž½ÊîÒpY.\x17¶Te¥þ"
    20 => b"\x01Ž°UNVr¤‡‚s\x16]Õ\x17%"
    21 => b"\x01Ž°^;ßrM‹W‹–ã\x1FŠz"
    22 => b"\x01Ž°Uârpš¶ à4Q\x12aç"
    23 => b"\x01Ž°U¬’qÓ’ÑpëÊvQ\x1A"
    24 => b"\x01Ž°UŽås²ˆE\x002„˜\å"
    25 => b"\x01Ž°Up¸pŽ¸‡F`\x10\x02\eä"
    26 => b"\x01Ž¯¤\rªqþº\tKÓ\x1Eòsœ"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#563
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#551
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#994
      +name: "ASCII"
    }
    4 => Doctrine\DBAL\ParameterType {#994}
    5 => Doctrine\DBAL\ParameterType {#994}
    6 => Doctrine\DBAL\ParameterType {#994}
    7 => Doctrine\DBAL\ParameterType {#994}
    8 => Doctrine\DBAL\ParameterType {#994}
    9 => Doctrine\DBAL\ParameterType {#994}
    10 => Doctrine\DBAL\ParameterType {#994}
    11 => Doctrine\DBAL\ParameterType {#994}
    12 => Doctrine\DBAL\ParameterType {#994}
    13 => Doctrine\DBAL\ParameterType {#994}
    14 => Doctrine\DBAL\ParameterType {#994}
    15 => Doctrine\DBAL\ParameterType {#994}
    16 => Doctrine\DBAL\ParameterType {#994}
    17 => Doctrine\DBAL\ParameterType {#994}
    18 => Doctrine\DBAL\ParameterType {#994}
    19 => Doctrine\DBAL\ParameterType {#994}
    20 => Doctrine\DBAL\ParameterType {#994}
    21 => Doctrine\DBAL\ParameterType {#994}
    22 => Doctrine\DBAL\ParameterType {#994}
    23 => Doctrine\DBAL\ParameterType {#994}
    24 => Doctrine\DBAL\ParameterType {#994}
    25 => Doctrine\DBAL\ParameterType {#994}
    26 => Doctrine\DBAL\ParameterType {#994}
  ]
]

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

[
  "sql" => "    SELECT BIN_TO_UUID(`clip_id`) as `id` FROM movie_clip WHERE `public_key` = ?;"
  "params" => [
    1 => "WFBcHFw"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#551
      +name: "STRING"
    }
  ]
]