Symfony Profiler

[
  "route" => "page_column_page"
  "route_parameters" => [
    "_route" => "page_column_page"
    "_controller" => "App\Controller\ColumnController::show"
    "category" => "reform"
    "name" => "crimeprevention"
  ]
  "request_uri" => "http://staging.usui-home.co.jp/column/reform/crimeprevention"
  "method" => "GET"
]

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

[
  "firewall_name" => "main"
  "authenticator" => "Sword\SwordBundle\Security\UserAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Sword\SwordBundle\Security\UserAuthenticator"
]

[
  "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" => "Sword\SwordBundle\EventListener\WordpressLoggedInStatusCheckEventSubscriber::checkWordpressLoggedInStatus"
]

[
  "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" => "App\EventSubscriber\TwigEventSubscriber::onKernelController"
]

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

[
  "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" => "ContainerNR2fKu8\RequestPayloadValueResolverGhost3590451::onKernelControllerArguments"
]

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

[
  "params" => [
    "url" => null
    "dbname" => "staging_usui_home"
    "host" => "usui-home.c7zexpbaxibr.ap-northeast-1.rds.amazonaws.com"
    "user" => "wordpress"
    "password" => "<redacted>"
    "charset" => "utf8mb4"
    "driver" => "mysqli"
    "port" => null
    "driverOptions" => []
    "serverVersion" => "8.1.26"
    "defaultTableOptions" => []
  ]
]

[
  "sql" => "SELECT p.id, p.post_type, p.post_name, p.post_title, p.post_status, p.post_excerpt, p.post_date, p.post_modified, p.post_content, MAX(CASE WHEN pm_self.meta_key = '_thumbnail_id' THEN pm_self.meta_value END) AS `thumbnail_id`, category.term_id AS category_id, category.name AS category_name, category.slug AS category_slug FROM wp_posts p LEFT JOIN wp_postmeta pm_self ON p.id = pm_self.post_id INNER JOIN wp_term_relationships tr_0 ON p.id = tr_0.object_id INNER JOIN wp_term_taxonomy tt_0 ON tr_0.term_taxonomy_id = tt_0.term_taxonomy_id INNER JOIN wp_terms category ON tt_0.term_id = category.term_id WHERE (p.post_type = ?) AND (p.post_type = ?) AND (p.post_status = ?) AND (p.post_name = ?) AND (tt_0.taxonomy = ?) GROUP BY p.id, p.post_type, p.post_name, p.post_title, p.post_status, p.post_excerpt, p.post_date, p.post_modified, p.post_content, category_id, category_name, category_slug LIMIT 1"
  "params" => [
    1 => "column"
    2 => "column"
    3 => "publish"
    4 => "crimeprevention"
    5 => "column_category"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT p.id, p.post_author, p.post_date, p.post_date_gmt, p.post_content, p.post_title, p.post_excerpt, p.post_status, p.comment_status, p.ping_status, p.post_password, p.post_name, p.to_ping, p.pinged, p.post_modified, p.post_modified_gmt, p.post_content_filtered, p.post_parent, p.guid, p.menu_order, p.post_type, p.post_mime_type, p.comment_count, MAX(CASE WHEN pm_self.meta_key = '_wp_attached_file' THEN pm_self.meta_value END) AS `attached_file`, MAX(CASE WHEN pm_self.meta_key = '_wp_attachment_metadata' THEN pm_self.meta_value END) AS `attachment_metadata` FROM wp_posts p LEFT JOIN wp_postmeta pm_self ON p.id = pm_self.post_id WHERE (p.post_type = ?) AND (p.id = ?) GROUP BY p.id, p.post_author, p.post_date, p.post_date_gmt, p.post_content, p.post_title, p.post_excerpt, p.post_status, p.comment_status, p.ping_status, p.post_password, p.post_name, p.to_ping, p.pinged, p.post_modified, p.post_modified_gmt, p.post_content_filtered, p.post_parent, p.guid, p.menu_order, p.post_type, p.post_mime_type, p.comment_count, p.id LIMIT 1"
  "params" => [
    1 => "attachment"
    2 => "3557"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT p.term_id, p.name, p.slug, tt.taxonomy, tt.term_taxonomy_id, tt.count FROM wp_terms p INNER JOIN wp_term_taxonomy tt ON p.term_id = tt.term_id INNER JOIN wp_term_relationships tr_0 ON tt.term_taxonomy_id = tr_0.term_taxonomy_id INNER JOIN wp_posts p_0 ON tr_0.object_id = p_0.id LEFT JOIN wp_postmeta pm_0 ON p_0.id = pm_0.post_id WHERE (p_0.id = ?) AND (taxonomy = ?) GROUP BY p.term_id, p.name, p.slug, p_0.id, tt.taxonomy"
  "params" => [
    1 => "1369"
    2 => "column_tag"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "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.response"
  "listener" => "Sword\SwordBundle\EventListener\WordpressTerminateEventListener::onResponse"
]

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