Symfony Profiler

[
  "route" => "app_keyword_public_index"
  "route_parameters" => [
    "_route" => "app_keyword_public_index"
    "_controller" => "App\Controller\KeywordController::index_public"
  ]
  "request_uri" => "https://researching.dev-investigacion.ing.uc.cl/keyword/public?query=Panel%20Data"
  "method" => "GET"
]

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

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\UX\Turbo\Request\RequestListener::__invoke"
]

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

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

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::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\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" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController"
]

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

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

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

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

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "researching_user"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "researching"
    "serverVersion" => "5.7.40"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT k0_.id AS id_0, k0_.keyword AS keyword_1, k0_.in_stop_list AS in_stop_list_2, k0_.sort AS sort_3, p1_.id AS id_4, p1_.title AS title_5, p1_.ut AS ut_6, p1_.doctype AS doctype_7, p1_.pages AS pages_8, p1_.issue AS issue_9, p1_.volume AS volume_10, p1_.published_month AS published_month_11, p1_.published_year AS published_year_12, p1_.doi AS doi_13, p1_.issn AS issn_14, p1_.isbn AS isbn_15, p1_.updated_date AS updated_date_16, p1_.abstract AS abstract_17, p1_.times_cited AS times_cited_18, p1_.funding_text AS funding_text_19, p1_.interdisciplinary AS interdisciplinary_20, p1_.validated AS validated_21, p1_.siding_id AS siding_id_22, p1_.public_comments AS public_comments_23, p1_.private_comments AS private_comments_24, p1_.publication_type AS publication_type_25, p2_.id AS id_26, p2_.firstname AS firstname_27, p2_.lastname AS lastname_28, p2_.participation AS participation_29, p2_.master_student AS master_student_30, p2_.phd_student AS phd_student_31, p2_.uc_not_ing AS uc_not_ing_32, p2_.postdoc AS postdoc_33, a3_.id AS id_34, a3_.researcher_id AS researcher_id_35, a3_.daisng_id AS daisng_id_36, a3_.bio AS bio_37, a3_.vigent AS vigent_38 FROM keyword k0_ INNER JOIN keyword_publication k4_ ON k0_.id = k4_.keyword_id INNER JOIN publication p1_ ON p1_.id = k4_.publication_id INNER JOIN publication_author p2_ ON p1_.id = p2_.publication_id INNER JOIN author a3_ ON p2_.author_id = a3_.id WHERE p1_.validated = 1 AND a3_.vigent = 1 AND k0_.keyword LIKE ? ORDER BY k0_.sort ASC) dctrn_result) dctrn_table"
  "params" => [
    1 => "%Panel Data%"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "sql" => "SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, sort_3 FROM (SELECT k0_.id AS id_0, k0_.keyword AS keyword_1, k0_.in_stop_list AS in_stop_list_2, k0_.sort AS sort_3, p1_.id AS id_4, p1_.title AS title_5, p1_.ut AS ut_6, p1_.doctype AS doctype_7, p1_.pages AS pages_8, p1_.issue AS issue_9, p1_.volume AS volume_10, p1_.published_month AS published_month_11, p1_.published_year AS published_year_12, p1_.doi AS doi_13, p1_.issn AS issn_14, p1_.isbn AS isbn_15, p1_.updated_date AS updated_date_16, p1_.abstract AS abstract_17, p1_.times_cited AS times_cited_18, p1_.funding_text AS funding_text_19, p1_.interdisciplinary AS interdisciplinary_20, p1_.validated AS validated_21, p1_.siding_id AS siding_id_22, p1_.public_comments AS public_comments_23, p1_.private_comments AS private_comments_24, p1_.publication_type AS publication_type_25, p2_.id AS id_26, p2_.firstname AS firstname_27, p2_.lastname AS lastname_28, p2_.participation AS participation_29, p2_.master_student AS master_student_30, p2_.phd_student AS phd_student_31, p2_.uc_not_ing AS uc_not_ing_32, p2_.postdoc AS postdoc_33, a3_.id AS id_34, a3_.researcher_id AS researcher_id_35, a3_.daisng_id AS daisng_id_36, a3_.bio AS bio_37, a3_.vigent AS vigent_38 FROM keyword k0_ INNER JOIN keyword_publication k4_ ON k0_.id = k4_.keyword_id INNER JOIN publication p1_ ON p1_.id = k4_.publication_id INNER JOIN publication_author p2_ ON p1_.id = p2_.publication_id INNER JOIN author a3_ ON p2_.author_id = a3_.id WHERE p1_.validated = 1 AND a3_.vigent = 1 AND k0_.keyword LIKE ?) dctrn_result_inner ORDER BY sort_3 ASC) dctrn_result LIMIT 4"
  "params" => [
    1 => "%Panel Data%"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT DATABASE()"
]

[
  "sql" => """
    SELECT TABLE_NAME\n
    FROM information_schema.TABLES\n
    WHERE TABLE_SCHEMA = ?\n
      AND TABLE_TYPE = 'BASE TABLE'\n
    ORDER BY TABLE_NAME
    """
  "params" => [
    1 => "researching"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT DATABASE()"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::onKernelResponse"
]

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