Symfony Profiler

[
  "route" => "app_author_public_show"
  "route_parameters" => [
    "_route" => "app_author_public_show"
    "_controller" => "App\Controller\AuthorController::show_public"
    "id" => "188"
  ]
  "request_uri" => "https://researching.dev-investigacion.ing.uc.cl/author/public/188"
  "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"
]

[
  "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 t0.id AS id_1, t0.researcher_id AS researcher_id_2, t0.daisng_id AS daisng_id_3, t0.bio AS bio_4, t0.vigent AS vigent_5, t0.user_id AS user_id_6 FROM author t0 WHERE t0.id = ?"
  "params" => [
    1 => "188"
  ]
  "types" => [
    1 => 1
  ]
]

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

[
  "sql" => "SELECT CONCAT(e0_.firstname, ' ', e0_.lastname) AS sclr_0, COUNT(p1_.id) AS sclr_1, CONCAT(e0_.gender, ' p(', e0_.gender_probability, ')') AS sclr_2, e0_.id AS id_3 FROM external_author e0_ INNER JOIN publication_author p2_ ON e0_.id = p2_.external_author_id INNER JOIN publication p1_ ON p2_.publication_id = p1_.id INNER JOIN publication_author p3_ ON p1_.id = p3_.publication_id INNER JOIN author a4_ ON p3_.author_id = a4_.id WHERE a4_.id = ? AND p1_.validated = 1 GROUP BY e0_.id ORDER BY COUNT(p1_.id) DESC"
  "params" => [
    1 => 188
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = ?"
  "params" => [
    1 => 11699
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = ?"
  "params" => [
    1 => 14509
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = ?"
  "params" => [
    1 => 14510
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = ?"
  "params" => [
    1 => 11698
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT CONCAT(u0_.name, ' ', u0_.last_name) AS sclr_0, COUNT(a1_.id) AS sclr_1, a1_.id AS id_2, a1_.vigent AS vigent_3 FROM author a1_ INNER JOIN publication_author p2_ ON a1_.id = p2_.author_id INNER JOIN publication p3_ ON p2_.publication_id = p3_.id INNER JOIN publication_author p4_ ON p3_.id = p4_.publication_id INNER JOIN author a5_ ON p4_.author_id = a5_.id INNER JOIN `user` u0_ ON a1_.user_id = u0_.id WHERE a5_.id = ? AND a1_.id <> a5_.id AND p3_.validated = 1 GROUP BY a1_.id, u0_.name, u0_.last_name ORDER BY COUNT(a1_.id) DESC"
  "params" => [
    1 => 188
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.participation AS participation_4, t0.master_student AS master_student_5, t0.phd_student AS phd_student_6, t0.uc_not_ing AS uc_not_ing_7, t0.postdoc AS postdoc_8, t0.author_id AS author_id_9, t0.publication_id AS publication_id_10, t0.external_author_id AS external_author_id_11 FROM publication_author t0 WHERE t0.author_id = ?"
  "params" => [
    1 => 188
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.ut AS ut_3, t0.doctype AS doctype_4, t0.pages AS pages_5, t0.issue AS issue_6, t0.volume AS volume_7, t0.published_month AS published_month_8, t0.published_year AS published_year_9, t0.doi AS doi_10, t0.issn AS issn_11, t0.isbn AS isbn_12, t0.updated_date AS updated_date_13, t0.abstract AS abstract_14, t0.times_cited AS times_cited_15, t0.funding_text AS funding_text_16, t0.interdisciplinary AS interdisciplinary_17, t0.validated AS validated_18, t0.siding_id AS siding_id_19, t0.public_comments AS public_comments_20, t0.private_comments AS private_comments_21, t0.publication_type AS publication_type_22, t0.journal_id AS journal_id_23, t0.publisher_id AS publisher_id_24 FROM publication t0 WHERE t0.id = ?"
  "params" => [
    1 => 2695
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.keyword AS keyword_2, t0.in_stop_list AS in_stop_list_3, t0.sort AS sort_4 FROM keyword t0 INNER JOIN keyword_publication ON t0.id = keyword_publication.keyword_id WHERE keyword_publication.publication_id = ?"
  "params" => [
    1 => 2695
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.ut AS ut_3, t0.doctype AS doctype_4, t0.pages AS pages_5, t0.issue AS issue_6, t0.volume AS volume_7, t0.published_month AS published_month_8, t0.published_year AS published_year_9, t0.doi AS doi_10, t0.issn AS issn_11, t0.isbn AS isbn_12, t0.updated_date AS updated_date_13, t0.abstract AS abstract_14, t0.times_cited AS times_cited_15, t0.funding_text AS funding_text_16, t0.interdisciplinary AS interdisciplinary_17, t0.validated AS validated_18, t0.siding_id AS siding_id_19, t0.public_comments AS public_comments_20, t0.private_comments AS private_comments_21, t0.publication_type AS publication_type_22, t0.journal_id AS journal_id_23, t0.publisher_id AS publisher_id_24 FROM publication t0 WHERE t0.id = ?"
  "params" => [
    1 => 3451
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.keyword AS keyword_2, t0.in_stop_list AS in_stop_list_3, t0.sort AS sort_4 FROM keyword t0 INNER JOIN keyword_publication ON t0.id = keyword_publication.keyword_id WHERE keyword_publication.publication_id = ?"
  "params" => [
    1 => 3451
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.participation AS participation_4, t0.master_student AS master_student_5, t0.phd_student AS phd_student_6, t0.uc_not_ing AS uc_not_ing_7, t0.postdoc AS postdoc_8, t0.author_id AS author_id_9, t0.publication_id AS publication_id_10, t0.external_author_id AS external_author_id_11 FROM publication_author t0 WHERE t0.publication_id = ?"
  "params" => [
    1 => 2695
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = ?"
  "params" => [
    1 => 24848
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = ?"
  "params" => [
    1 => 24849
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = ?"
  "params" => [
    1 => 24850
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.participation AS participation_4, t0.master_student AS master_student_5, t0.phd_student AS phd_student_6, t0.uc_not_ing AS uc_not_ing_7, t0.postdoc AS postdoc_8, t0.author_id AS author_id_9, t0.publication_id AS publication_id_10, t0.external_author_id AS external_author_id_11 FROM publication_author t0 WHERE t0.publication_id = ?"
  "params" => [
    1 => 3451
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = ?"
  "params" => [
    1 => 31357
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = ?"
  "params" => [
    1 => 31358
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = ?"
  "params" => [
    1 => 31359
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.last_name AS last_name_6, t0.rut AS rut_7, t0.sex AS sex_8, t0.photo AS photo_9, t10.id AS id_11, t10.researcher_id AS researcher_id_12, t10.daisng_id AS daisng_id_13, t10.bio AS bio_14, t10.vigent AS vigent_15, t10.user_id AS user_id_16 FROM `user` t0 LEFT JOIN author t10 ON t10.user_id = t0.id WHERE t0.id = ?"
  "params" => [
    1 => 192
  ]
  "types" => [
    1 => 1
  ]
]

[
  "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 t0.id AS id_1, t0.research_line AS research_line_2, t0.sort AS sort_3 FROM research_line t0 INNER JOIN author_research_line ON t0.id = author_research_line.research_line_id WHERE author_research_line.author_id = ?"
  "params" => [
    1 => 188
  ]
  "types" => [
    1 => 1
  ]
]

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