Symfony Profiler

[
  "route" => "app_dashboard"
  "route_parameters" => [
    "_route" => "app_dashboard"
    "_controller" => "App\Controller\DashboardController::index"
  ]
  "request_uri" => "https://gestelcon.com.ar/"
  "method" => "GET"
]

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

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

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

[
  "key" => "_security_main"
  "token_class" => "Symfony\Component\Security\Core\Authentication\Token\UsernamePasswordToken"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "usuario_gestelcon"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "gestelconpilar"
    "serverVersion" => "8.0.43"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.celular AS celular_5, t0.fecha_creacion AS fecha_creacion_6, t0.fecha_ultimo_acceso AS fecha_ultimo_acceso_7, t0.fecha_ultimo_cambio_password AS fecha_ultimo_cambio_password_8, t0.modulo_activo AS modulo_activo_9, t0.falta_de_pago AS falta_de_pago_10, t0.token_password AS token_password_11, t0.token_fecha AS token_fecha_12, t0.organizacion_activa_id AS organizacion_activa_id_13, t0.membresia_activa_id AS membresia_activa_id_14 FROM user t0 WHERE t0.id = ?"
  "params" => [
    1 => 111
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.roles AS roles_2, t0.ultima_actividad AS ultima_actividad_3, t0.activo AS activo_4, t0.fecha_expiracion AS fecha_expiracion_5, t0.usuario_id AS usuario_id_6, t0.organizacion_id AS organizacion_id_7, t0.medico_id AS medico_id_8 FROM membresia t0 WHERE t0.id = ?"
  "params" => [
    1 => 66
  ]
  "types" => [
    1 => 1
  ]
]

[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "nicolas.olivera.31@gmail.com"
]

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

[
  "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" => "App\EventSubscriber\ApiSecuritySubscriber::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" => "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::onKernelRequest"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController"
]

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

[
  "event" => "kernel.controller"
  "listener" => "DH\AuditorBundle\Event\ViewerEventSubscriber::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" => "Container5X53X97\RequestPayloadValueResolverGhost3590451::onKernelControllerArguments"
]

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

[
  "sql" => "SELECT t0_.id AS id_0, t0_.dia AS dia_1, t0_.duracion AS duracion_2, t0_.sobre_turno AS sobre_turno_3, t0_.url_meet AS url_meet_4, t0_.observaciones AS observaciones_5, t0_.estado AS estado_6, t0_.origen AS origen_7, t0_.orden_de_llegada AS orden_de_llegada_8, t0_.recordatorio_enviado AS recordatorio_enviado_9, t0_.fecha_actualizacion AS fecha_actualizacion_10, t0_.medico_id AS medico_id_11, t0_.paciente_id AS paciente_id_12, t0_.establecimiento_id AS establecimiento_id_13, t0_.motivo_id AS motivo_id_14, t0_.modalidad AS modalidad_15, t0_.aplicacion_id AS aplicacion_id_16, t0_.derivado_por_id AS derivado_por_id_17, t0_.usuario_id AS usuario_id_18, t0_.organizacion AS organizacion_19, t0_.evolucion_paciente_id AS evolucion_paciente_id_20, t0_.estacion_id AS estacion_id_21 FROM turnos t0_ WHERE t0_.organizacion = ? AND t0_.estado < ? AND DATE_ADD(t0_.dia, INTERVAL t0_.duracion MINUTE) <= DATE_SUB(CURRENT_TIMESTAMP, INTERVAL ? HOUR)"
  "params" => [
    1 => 1
    2 => 7
    3 => 6
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.apellido AS apellido_2, t0.nombre AS nombre_3, t0.nro_doc AS nro_doc_4, t0.fecha_nacimiento AS fecha_nacimiento_5, t0.hijos AS hijos_6, t0.calle AS calle_7, t0.domicilio_nro AS domicilio_nro_8, t0.piso AS piso_9, t0.dpto AS dpto_10, t0.plan_obra_social AS plan_obra_social_11, t0.nro_afiliado AS nro_afiliado_12, t0.celular AS celular_13, t0.email AS email_14, t0.fecha_primera_consulta AS fecha_primera_consulta_15, t0.foto AS foto_16, t0.observacion_personal AS observacion_personal_17, t0.antecedentes_de_jerarquia AS antecedentes_de_jerarquia_18, t0.medicacion_habitual AS medicacion_habitual_19, t0.factores_riesgo AS factores_riesgo_20, t0.estudios AS estudios_21, t0.hta AS hta_22, t0.dbt AS dbt_23, t0.dlp AS dlp_24, t0.tbq AS tbq_25, t0.consentimiento_email AS consentimiento_email_26, t0.genero_id AS genero_id_27, t0.estado_civil_id AS estado_civil_id_28, t0.localidad_id AS localidad_id_29, t0.obra_social_id AS obra_social_id_30, t0.organizacion AS organizacion_31 FROM pacientes t0 WHERE t0.id = ?"
  "params" => [
    1 => 27673
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.apellido AS apellido_2, t0.nombre AS nombre_3, t0.matricula AS matricula_4, t0.tratamiento AS tratamiento_5, t0.duracion_turno AS duracion_turno_6, t0.activo AS activo_7, t0.visible AS visible_8, t0.url_meet_predefinida AS url_meet_predefinida_9, t0.fecha_actualizacion_url_meet AS fecha_actualizacion_url_meet_10, t0.obras_sociales_config AS obras_sociales_config_11, t0.profesion_id AS profesion_id_12, t0.horario_id AS horario_id_13, t0.organizacion AS organizacion_14 FROM medicos t0 WHERE t0.id = ?"
  "params" => [
    1 => 130
  ]
  "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 m0_.id AS id_0, m0_.apellido AS apellido_1, m0_.nombre AS nombre_2, m0_.matricula AS matricula_3, m0_.tratamiento AS tratamiento_4, m0_.duracion_turno AS duracion_turno_5, m0_.activo AS activo_6, m0_.visible AS visible_7, m0_.url_meet_predefinida AS url_meet_predefinida_8, m0_.fecha_actualizacion_url_meet AS fecha_actualizacion_url_meet_9, m0_.obras_sociales_config AS obras_sociales_config_10, m0_.profesion_id AS profesion_id_11, m0_.horario_id AS horario_id_12, m0_.organizacion AS organizacion_13 FROM medicos m0_ WHERE m0_.activo = 1 AND m0_.organizacion = ? ORDER BY m0_.apellido ASC, m0_.nombre ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "event" => "knp_pager.before"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Sortable\SortableSubscriber::before"
]

[
  "event" => "knp_pager.before"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Filtration\FiltrationSubscriber::before"
]

[
  "event" => "knp_pager.before"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\PaginationSubscriber::before"
]

[
  "sql" => "SELECT count(DISTINCT t0_.id) AS sclr_0 FROM turnos t0_ LEFT JOIN medicos m1_ ON t0_.medico_id = m1_.id LEFT JOIN pacientes p2_ ON t0_.paciente_id = p2_.id WHERE t0_.estado < ? AND t0_.organizacion = ? AND t0_.dia > DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 666 HOUR) AND m1_.id IN (?, ?, ?)"
  "params" => [
    1 => 7
    2 => 1
    3 => 130
    4 => 131
    5 => 129
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 1
    4 => 1
    5 => 1
  ]
]

[
  "sql" => "SELECT DISTINCT t0_.id AS id_0, t0_.dia AS dia_1 FROM turnos t0_ LEFT JOIN medicos m1_ ON t0_.medico_id = m1_.id LEFT JOIN pacientes p2_ ON t0_.paciente_id = p2_.id WHERE t0_.estado < ? AND t0_.organizacion = ? AND t0_.dia > DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 666 HOUR) AND m1_.id IN (?, ?, ?) ORDER BY t0_.dia ASC LIMIT 20"
  "params" => [
    1 => 7
    2 => 1
    3 => 130
    4 => 131
    5 => 129
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 1
    4 => 1
    5 => 1
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.dia AS dia_1, t0_.duracion AS duracion_2, t0_.sobre_turno AS sobre_turno_3, t0_.url_meet AS url_meet_4, t0_.observaciones AS observaciones_5, t0_.estado AS estado_6, t0_.origen AS origen_7, t0_.orden_de_llegada AS orden_de_llegada_8, t0_.recordatorio_enviado AS recordatorio_enviado_9, t0_.fecha_actualizacion AS fecha_actualizacion_10, m1_.id AS id_11, m1_.apellido AS apellido_12, m1_.nombre AS nombre_13, m1_.matricula AS matricula_14, m1_.tratamiento AS tratamiento_15, m1_.duracion_turno AS duracion_turno_16, m1_.activo AS activo_17, m1_.visible AS visible_18, m1_.url_meet_predefinida AS url_meet_predefinida_19, m1_.fecha_actualizacion_url_meet AS fecha_actualizacion_url_meet_20, m1_.obras_sociales_config AS obras_sociales_config_21, p2_.id AS id_22, p2_.apellido AS apellido_23, p2_.nombre AS nombre_24, p2_.nro_doc AS nro_doc_25, p2_.fecha_nacimiento AS fecha_nacimiento_26, p2_.hijos AS hijos_27, p2_.calle AS calle_28, p2_.domicilio_nro AS domicilio_nro_29, p2_.piso AS piso_30, p2_.dpto AS dpto_31, p2_.plan_obra_social AS plan_obra_social_32, p2_.nro_afiliado AS nro_afiliado_33, p2_.celular AS celular_34, p2_.email AS email_35, p2_.fecha_primera_consulta AS fecha_primera_consulta_36, p2_.foto AS foto_37, p2_.observacion_personal AS observacion_personal_38, p2_.antecedentes_de_jerarquia AS antecedentes_de_jerarquia_39, p2_.medicacion_habitual AS medicacion_habitual_40, p2_.factores_riesgo AS factores_riesgo_41, p2_.estudios AS estudios_42, p2_.hta AS hta_43, p2_.dbt AS dbt_44, p2_.dlp AS dlp_45, p2_.tbq AS tbq_46, p2_.consentimiento_email AS consentimiento_email_47, t0_.medico_id AS medico_id_48, t0_.paciente_id AS paciente_id_49, t0_.establecimiento_id AS establecimiento_id_50, t0_.motivo_id AS motivo_id_51, t0_.modalidad AS modalidad_52, t0_.aplicacion_id AS aplicacion_id_53, t0_.derivado_por_id AS derivado_por_id_54, t0_.usuario_id AS usuario_id_55, t0_.organizacion AS organizacion_56, t0_.evolucion_paciente_id AS evolucion_paciente_id_57, t0_.estacion_id AS estacion_id_58, m1_.profesion_id AS profesion_id_59, m1_.horario_id AS horario_id_60, m1_.organizacion AS organizacion_61, p2_.genero_id AS genero_id_62, p2_.estado_civil_id AS estado_civil_id_63, p2_.localidad_id AS localidad_id_64, p2_.obra_social_id AS obra_social_id_65, p2_.organizacion AS organizacion_66 FROM turnos t0_ LEFT JOIN medicos m1_ ON t0_.medico_id = m1_.id LEFT JOIN pacientes p2_ ON t0_.paciente_id = p2_.id WHERE t0_.estado < ? AND t0_.organizacion = ? AND t0_.dia > DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 666 HOUR) AND m1_.id IN (?, ?, ?) AND t0_.id IN (?, ?, ?, ?, ?) ORDER BY t0_.dia ASC"
  "params" => [
    1 => 7
    2 => 1
    3 => 130
    4 => 131
    5 => 129
    6 => 100950
    7 => 100951
    8 => 100947
    9 => 100948
    10 => 100949
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 1
    4 => 1
    5 => 1
    6 => 1
    7 => 1
    8 => 1
    9 => 1
    10 => 1
  ]
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QueryBuilderSubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ODM\MongoDB\QueryBuilderSubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ODM\PHPCR\QueryBuilderSubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\DBALQueryBuilderSubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Sortable\Doctrine\ORM\QuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Sortable\Doctrine\ODM\MongoDB\QuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Sortable\ElasticaQuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Sortable\PropelQuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Sortable\SolariumQuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Sortable\ArraySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Filtration\Doctrine\ORM\QuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Filtration\PropelQuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Callback\CallbackSubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ODM\MongoDB\QuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ODM\PHPCR\QuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\CollectionSubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\PropelQuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\SolariumQuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\ElasticaQuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\ArraySubscriber::items"
]

[
  "event" => "knp_pager.pagination"
  "listener" => "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::pagination"
]

[
  "event" => "knp_pager.pagination"
  "listener" => "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::pagination"
]

[
  "event" => "knp_pager.pagination"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\PaginationSubscriber::pagination"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.activo AS activo_3, t0.visible AS visible_4, t0.fn_practicas AS fn_practicas_5, t0.fn_ia AS fn_ia_6, t0.organizacion_id AS organizacion_id_7, t0.cuestionario_id AS cuestionario_id_8 FROM estacion t0 WHERE t0.organizacion_id = ? AND t0.activo = ? ORDER BY t0.nombre ASC"
  "params" => [
    1 => 1
    2 => 1
  ]
  "types" => [
    1 => 1
    2 => 5
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.fecha_creacion AS fecha_creacion_3, t0.fecha_actualizacion AS fecha_actualizacion_4, t0.fecha_expiracion AS fecha_expiracion_5, t0.modulo_ambulatorio AS modulo_ambulatorio_6, t0.modulo_internacion AS modulo_internacion_7, t0.modulo_circuito AS modulo_circuito_8, t0.modulo_caja AS modulo_caja_9, t0.modulo_portal AS modulo_portal_10, t0.modulo_llamador AS modulo_llamador_11, t0.max_usuarios AS max_usuarios_12, t0.max_establecimientos AS max_establecimientos_13, t0.configuracion AS configuracion_14, t0.activo AS activo_15, t0.portal_slug AS portal_slug_16, t0.configuracion_obras_sociales AS configuracion_obras_sociales_17, t0.configuracion_profesiones AS configuracion_profesiones_18, t0.configuracion_especialidades AS configuracion_especialidades_19, t0.configuracion_practicas_medicas AS configuracion_practicas_medicas_20 FROM organizacion t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "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"
]

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

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

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

[
  "sql" => "SELECT t0.id AS id_1, t0.roles AS roles_2, t0.ultima_actividad AS ultima_actividad_3, t0.activo AS activo_4, t0.fecha_expiracion AS fecha_expiracion_5, t0.usuario_id AS usuario_id_6, t0.organizacion_id AS organizacion_id_7, t0.medico_id AS medico_id_8 FROM membresia t0 WHERE t0.usuario_id = ?"
  "params" => [
    1 => 111
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.cuit AS cuit_3, t0.organizacion AS organizacion_4 FROM obra_social t0 WHERE t0.id = ?"
  "params" => [
    1 => 1387
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.activo AS activo_3, t0.visible AS visible_4, t0.estado_al_finalizar AS estado_al_finalizar_5, t0.periodicidad AS periodicidad_6, t0.organizacion AS organizacion_7 FROM motivos_consulta t0 WHERE t0.id = ?"
  "params" => [
    1 => 80
  ]
  "types" => [
    1 => 1
  ]
]

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

[
  "sql" => "SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.activo AS activo_3, t0.organizacion AS organizacion_4 FROM establecimientos t0 WHERE t0.id = ?"
  "params" => [
    1 => 19
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.organizacion AS organizacion_3 FROM profesion t0 WHERE t0.id = ?"
  "params" => [
    1 => 67
  ]
  "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"
]

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

[
  "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.nombre AS nombre_2, t0.activo AS activo_3, t0.visible AS visible_4, t0.estado_al_finalizar AS estado_al_finalizar_5, t0.periodicidad AS periodicidad_6, t0.organizacion AS organizacion_7 FROM motivos_consulta t0 WHERE t0.id = ?"
  "params" => [
    1 => 82
  ]
  "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"
]

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

[
  "key" => "usuarios_activos"
]

[
  "sql" => "SELECT COUNT(m0_.id) AS sclr_0 FROM membresia m0_ WHERE m0_.ultima_actividad >= ?"
  "params" => [
    1 => "2026-01-17 16:56:08"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "key" => "_security_main"
]

[
  "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\Mercure\EventSubscriber\SetCookieSubscriber::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\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest"
]