Symfony Profiler

[
  "route" => "app_applicant_show"
  "route_parameters" => [
    "_route" => "app_applicant_show"
    "_controller" => "App\Controller\ApplicantController::show"
    "id" => "91"
  ]
  "request_uri" => "http://rad-sdsc.ucsd.edu/applicant/91"
  "method" => "GET"
]

[
  "key" => "_security_main"
  "token_class" => "Symfony\Component\Security\Http\Authenticator\Token\PostAuthenticationToken"
]

[
  "firewall_name" => "main"
  "authenticator" => "App\Security\CustomAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "App\Security\CustomAuthenticator"
]

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

[
  "params" => [
    "url" => "<redacted>"
    "driver" => "pdo_pgsql"
    "host" => "127.0.0.1"
    "port" => 5432
    "user" => "radfluro"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "fellowapp27"
    "serverVersion" => "13"
    "charset" => "utf8"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4 FROM my_user t0 WHERE t0.id = ?"
  "params" => [
    1 => 24
  ]
  "types" => [
    1 => 1
  ]
]

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

[
  "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" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "deliam"
]

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

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.address AS address_4, t0.degree AS degree_5, t0.current_position AS current_position_6, t0.division AS division_7, t0.application_form AS application_form_8, t0.personal AS personal_9, t0.cv AS cv_10, t0.usmle AS usmle_11, t0.dean_letter AS dean_letter_12, t0.med_school_d AS med_school_d_13, t0.ref1_name AS ref1_name_14, t0.ref1_email AS ref1_email_15, t0.ref1_letter AS ref1_letter_16, t0.ref2_name AS ref2_name_17, t0.ref2_email AS ref2_email_18, t0.ref2_letter AS ref2_letter_19, t0.ref3_name AS ref3_name_20, t0.ref3_email AS ref3_email_21, t0.ref3_letter AS ref3_letter_22, t0.phone AS phone_23, t0.status AS status_24, t0.notes AS notes_25, t0.ref_lt_num AS ref_lt_num_26 FROM applicant t0 WHERE t0.id = ?"
  "params" => [
    1 => "91"
  ]
  "types" => [
    1 => 1
  ]
]

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

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController"
]

[
  "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" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\SecurityListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\IsGrantedListener::onKernelControllerArguments"
]

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

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

[
  "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.name AS name_2, t0.email AS email_3, t0.affiliation AS affiliation_4, t0.job_title AS job_title_5, t0.phone AS phone_6, t0.address AS address_7, t0.ref_letter AS ref_letter_8, t0.applicant_id AS applicant_id_9 FROM refrence t0 WHERE t0.applicant_id = ?"
  "params" => [
    1 => 91
  ]
  "types" => [
    1 => 1
  ]
]

[
  "key" => "_security_main"
]

[
  "sql" => """
    SELECT quote_ident(table_name) AS table_name,\n
                           table_schema AS schema_name\n
                    FROM   information_schema.tables\n
                    WHERE  table_schema NOT LIKE 'pg\_%'\n
                    AND    table_schema != 'information_schema'\n
                    AND    table_name != 'geometry_columns'\n
                    AND    table_name != 'spatial_ref_sys'\n
                    AND    table_type != 'VIEW'
    """
]

[
  "sql" => """
    SELECT schema_name\n
    FROM   information_schema.schemata\n
    WHERE  schema_name NOT LIKE 'pg\_%'\n
    AND    schema_name != 'information_schema'
    """
]

[
  "sql" => "SHOW search_path"
]

[
  "sql" => """
    SELECT quote_ident(table_name) AS table_name,\n
                           table_schema AS schema_name\n
                    FROM   information_schema.tables\n
                    WHERE  table_schema NOT LIKE 'pg\_%'\n
                    AND    table_schema != 'information_schema'\n
                    AND    table_name != 'geometry_columns'\n
                    AND    table_name != 'spatial_ref_sys'\n
                    AND    table_type != 'VIEW'
    """
]

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

[
  "sql" => """
    SELECT\n
                        a.attnum,\n
                        quote_ident(a.attname) AS field,\n
                        t.typname AS type,\n
                        format_type(a.atttypid, a.atttypmod) AS complete_type,\n
                        (SELECT tc.collcollate FROM pg_catalog.pg_collation tc WHERE tc.oid = a.attcollation) AS collation,\n
                        (SELECT t1.typname FROM pg_catalog.pg_type t1 WHERE t1.oid = t.typbasetype) AS domain_type,\n
                        (SELECT format_type(t2.typbasetype, t2.typtypmod) FROM\n
                          pg_catalog.pg_type t2 WHERE t2.typtype = 'd' AND t2.oid = a.atttypid) AS domain_complete_type,\n
                        a.attnotnull AS isnotnull,\n
                        (SELECT 't'\n
                         FROM pg_index\n
                         WHERE c.oid = pg_index.indrelid\n
                            AND pg_index.indkey[0] = a.attnum\n
                            AND pg_index.indisprimary = 't'\n
                        ) AS pri,\n
                        (SELECT pg_get_expr(adbin, adrelid)\n
                         FROM pg_attrdef\n
                         WHERE c.oid = pg_attrdef.adrelid\n
                            AND pg_attrdef.adnum=a.attnum\n
                        ) AS default,\n
                        (SELECT pg_description.description\n
                            FROM pg_description WHERE pg_description.objoid = c.oid AND a.attnum = pg_description.objsubid\n
                        ) AS comment\n
                        FROM pg_attribute a, pg_class c, pg_type t, pg_namespace n\n
                        WHERE n.nspname NOT IN ('pg_catalog', 'information_schema', 'pg_toast') AND c.relname = 'doctrine_migration_versions' AND n.nspname = ANY(current_schemas(false))\n
                            AND a.attnum > 0\n
                            AND a.attrelid = c.oid\n
                            AND a.atttypid = t.oid\n
                            AND n.oid = c.relnamespace\n
                        ORDER BY a.attnum
    """
]

[
  "sql" => """
    SELECT quote_ident(r.conname) as conname, pg_catalog.pg_get_constraintdef(r.oid, true) as condef\n
                      FROM pg_catalog.pg_constraint r\n
                      WHERE r.conrelid =\n
                      (\n
                          SELECT c.oid\n
                          FROM pg_catalog.pg_class c, pg_catalog.pg_namespace n\n
                          WHERE n.nspname NOT IN ('pg_catalog', 'information_schema', 'pg_toast') AND c.relname = 'doctrine_migration_versions' AND n.nspname = ANY(current_schemas(false)) AND n.oid = c.relnamespace\n
                      )\n
                      AND r.contype = 'f'
    """
]

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

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

[
  "sql" => """
    SELECT quote_ident(relname) as relname, pg_index.indisunique, pg_index.indisprimary,\n
                           pg_index.indkey, pg_index.indrelid,\n
                           pg_get_expr(indpred, indrelid) AS where\n
                     FROM pg_class, pg_index\n
                     WHERE oid IN (\n
                        SELECT indexrelid\n
                        FROM pg_index si, pg_class sc, pg_namespace sn\n
                        WHERE sn.nspname NOT IN ('pg_catalog', 'information_schema', 'pg_toast') AND sc.relname = 'doctrine_migration_versions' AND sn.nspname = ANY(current_schemas(false))\n
                        AND sc.oid=si.indrelid AND sc.relnamespace = sn.oid\n
                     ) AND pg_index.indexrelid = oid
    """
]

[
  "sql" => "SELECT attnum, attname FROM pg_attribute WHERE attrelid=24837 AND attnum IN (1) ORDER BY attnum ASC"
]

[
  "sql" => "SELECT obj_description('doctrine_migration_versions'::regclass) AS table_comment;"
]

[
  "sql" => "SELECT * FROM doctrine_migration_versions"
]

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

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelFinishRequest"
]

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

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\StreamedResponseListener::onKernelResponse"
]

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

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DisallowRobotsIndexingListener::onResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelResponse"
]

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

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\RememberMe\ResponseListener::onKernelResponse"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest"
]