Symfony Profiler

[
  "route" => "app_secretaire_consultation_show"
  "route_parameters" => [
    "_route" => "app_secretaire_consultation_show"
    "_controller" => "App\Controller\Secretaire\ConsultationController::show"
    "id" => "1"
  ]
  "request_uri" => "https://doc.gom.ma/secretaire/consultation/1"
  "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"
]

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

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "gomDoctor"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "gom_doctor"
    "serverVersion" => "10.6.22-MariaDB"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_5, t0.username AS username_6, t0.email AS email_7, t0.roles AS roles_8, t0.password AS password_9, t0.nom AS nom_10, t0.prenom AS prenom_11, t0.telephone AS telephone_12, t0.adresse AS adresse_13, t0.date_naissance AS date_naissance_14, t0.cin AS cin_15, t0.date_creation AS date_creation_16, t0.derniere_connexion AS derniere_connexion_17, t0.actif AS actif_18, t0.type, t1.specialite AS specialite_19, t1.numero_inpe AS numero_inpe_20, t1.biographie AS biographie_21, t1.tarif_consultation AS tarif_consultation_22, t2.numero_assurance_maladie AS numero_assurance_maladie_23, t2.type_assurance AS type_assurance_24, t2.antecedents_medicaux AS antecedents_medicaux_25, t2.allergies AS allergies_26, t2.groupe_sanguin AS groupe_sanguin_27, t2.profession AS profession_28, t2.responsable AS responsable_29, t2.sexe AS sexe_30, t2.antecedents_chirurgicaux AS antecedents_chirurgicaux_31, t2.antecedents_familiales AS antecedents_familiales_32, t2.note AS note_33, t3.poste AS poste_34, t4.poste AS poste_35, t4.date_embauche AS date_embauche_36, t4.competences AS competences_37 FROM `users` t0 LEFT JOIN medecins t1 ON t0.id = t1.id LEFT JOIN patients t2 ON t0.id = t2.id LEFT JOIN admins t3 ON t0.id = t3.id LEFT JOIN secretaire t4 ON t0.id = t4.id WHERE t0.id = ?"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => 1
  ]
]

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

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

[
  "sql" => "SELECT t0.id AS id_1, t0.date_consultation AS date_consultation_2, t0.diagnostic AS diagnostic_3, t0.notes AS notes_4, t0.montant AS montant_5, t0.statut AS statut_6, t0.poids AS poids_7, t0.taille AS taille_8, t0.temperature AS temperature_9, t0.frequence_cardiaque AS frequence_cardiaque_10, t0.glycemie AS glycemie_11, t0.pression_arterielle AS pression_arterielle_12, t0.examan_clinique AS examan_clinique_13, t0.rendez_vous_id AS rendez_vous_id_14, t0.salle_attente_id AS salle_attente_id_15, t0.patient_id AS patient_id_16, t0.medecin_id AS medecin_id_17, t18.id AS id_19, t18.montant AS montant_20, t18.date_paiement AS date_paiement_21, t18.methode AS methode_22, t18.reference AS reference_23, t18.recu_genere AS recu_genere_24, t18.notes AS notes_25, t18.montant_assurance AS montant_assurance_26, t18.montant_patient AS montant_patient_27, t18.consultation_id AS consultation_id_28, t0.consultation_motif_id AS consultation_motif_id_29 FROM consultations t0 LEFT JOIN paiements t18 ON t18.consultation_id = t0.id WHERE t0.id = ?"
  "params" => [
    1 => "1"
  ]
  "types" => [
    1 => 1
  ]
]

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

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

[
  "sql" => "SELECT t0.id AS id_1, t0.use_header AS use_header_2, t0.use_footer AS use_footer_3, t0.app_name AS app_name_4, t0.logo AS logo_5, t0.updated_at AS updated_at_6, t0.email AS email_7, t0.telephone AS telephone_8, t0.header_code AS header_code_9, t0.footer_code AS footer_code_10, t0.adresse AS adresse_11 FROM setting t0 LIMIT 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 t1.id AS id_2, t1.username AS username_3, t1.email AS email_4, t1.roles AS roles_5, t1.password AS password_6, t1.nom AS nom_7, t1.prenom AS prenom_8, t1.telephone AS telephone_9, t1.adresse AS adresse_10, t1.date_naissance AS date_naissance_11, t1.cin AS cin_12, t1.date_creation AS date_creation_13, t1.derniere_connexion AS derniere_connexion_14, t1.actif AS actif_15, t0.numero_assurance_maladie AS numero_assurance_maladie_16, t0.type_assurance AS type_assurance_17, t0.antecedents_medicaux AS antecedents_medicaux_18, t0.allergies AS allergies_19, t0.groupe_sanguin AS groupe_sanguin_20, t0.profession AS profession_21, t0.responsable AS responsable_22, t0.sexe AS sexe_23, t0.antecedents_chirurgicaux AS antecedents_chirurgicaux_24, t0.antecedents_familiales AS antecedents_familiales_25, t0.note AS note_26, t1.type FROM patients t0 INNER JOIN `users` t1 ON t0.id = t1.id WHERE t1.id = ?"
  "params" => [
    1 => 12
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.notes AS notes_3, t0.patient_id AS patient_id_4 FROM dossiers_medicaux t0 WHERE t0.patient_id = ?"
  "params" => [
    1 => 12
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t1.id AS id_2, t1.username AS username_3, t1.email AS email_4, t1.roles AS roles_5, t1.password AS password_6, t1.nom AS nom_7, t1.prenom AS prenom_8, t1.telephone AS telephone_9, t1.adresse AS adresse_10, t1.date_naissance AS date_naissance_11, t1.cin AS cin_12, t1.date_creation AS date_creation_13, t1.derniere_connexion AS derniere_connexion_14, t1.actif AS actif_15, t0.specialite AS specialite_16, t0.numero_inpe AS numero_inpe_17, t0.biographie AS biographie_18, t0.tarif_consultation AS tarif_consultation_19, t1.type FROM medecins t0 INNER JOIN `users` t1 ON t0.id = t1.id WHERE t1.id = ?"
  "params" => [
    1 => 7
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prix AS prix_3, t0.active AS active_4 FROM consultation_motif t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.date_expiration AS date_expiration_3, t0.notes_generales AS notes_generales_4, t0.consultation_id AS consultation_id_5, t0.patient_id AS patient_id_6, t0.medecin_id AS medecin_id_7 FROM ordonnances t0 WHERE t0.consultation_id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.posologie AS posologie_2, t0.duree AS duree_3, t0.instructions AS instructions_4, t0.quantite AS quantite_5, t0.ordonnance_id AS ordonnance_id_6, t0.medicament_id AS medicament_id_7 FROM prescriptions t0 WHERE t0.ordonnance_id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.type AS type_2, t0.description AS description_3, t0.instructions AS instructions_4, t0.urgence AS urgence_5, t0.renseignements_cliniques AS renseignements_cliniques_6, t0.ordonnance_id AS ordonnance_id_7, t0.consultation_id AS consultation_id_8 FROM demandes_analyse t0 WHERE t0.ordonnance_id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.type AS type_2, t0.description AS description_3, t0.instructions AS instructions_4, t0.urgence AS urgence_5, t0.renseignements_cliniques AS renseignements_cliniques_6, t0.ordonnance_id AS ordonnance_id_7, t0.consultation_id AS consultation_id_8 FROM demandes_analyse t0 WHERE t0.consultation_id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom AS nom_2, t0.abrev AS abrev_3 FROM analyse t0 INNER JOIN demande_analyse_analyse ON t0.id = demande_analyse_analyse.analyse_id WHERE demande_analyse_analyse.demande_analyse_id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.type AS type_2, t0.partie AS partie_3, t0.description AS description_4, t0.instructions AS instructions_5, t0.urgence AS urgence_6, t0.renseignements_cliniques AS renseignements_cliniques_7, t0.ordonnance_id AS ordonnance_id_8, t0.consultation_id AS consultation_id_9 FROM demandes_radio t0 WHERE t0.consultation_id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.type AS type_2, t0.partie AS partie_3, t0.description AS description_4, t0.instructions AS instructions_5, t0.urgence AS urgence_6, t0.renseignements_cliniques AS renseignements_cliniques_7, t0.ordonnance_id AS ordonnance_id_8, t0.consultation_id AS consultation_id_9 FROM demandes_radio t0 WHERE t0.ordonnance_id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "key" => "_security_main"
]

[
  "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\Security\Http\RememberMe\ResponseListener::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"
]