GET https://dev.admin-cerebralvaud.ch/inscriptions/gestion/2026/toutes/participant

Response
200 OK
Browse referrer URL
IP
2a02:1210:782c:7700:1081:3efe:ad5c:7061
Profiled on
Token
25ab10

Query Metrics

25 Database Queries
6 Different statements
16.60 ms Query time
0 Invalid entities
60 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.54 ms 
SELECT t0.photo AS photo_1, t0.avs AS avs_2, t0.login AS login_3, t0.password AS password_4, t0.regime_alimentaire AS regime_alimentaire_5, t0.regime_alimentaire_autre AS regime_alimentaire_autre_6, t0.archive AS archive_7, t0.casier_judiciaire AS casier_judiciaire_8, t0.autorisation_travail AS autorisation_travail_9, t0.iban AS iban_10, t0.admin AS admin_11, t0.permis_conduire AS permis_conduire_12, t0.date_delivrance AS date_delivrance_13, t0.categorie_permis AS categorie_permis_14, t0.autorisation_conduire AS autorisation_conduire_15, t0.declaration_engagement AS declaration_engagement_16, t0.formation_incendie AS formation_incendie_17, t0.date_formation_incendie AS date_formation_incendie_18, t0.date_formation_cerebral AS date_formation_cerebral_19, t0.date_formation_abus AS date_formation_abus_20, t0.document_autorisation_travail AS document_autorisation_travail_21, t0.contrat AS contrat_22, t0.date_autorisation AS date_autorisation_23, t0.date_autorisationtravail AS date_autorisationtravail_24, t0.date_echeancepermis AS date_echeancepermis_25, t0.date_signaturecontratravail AS date_signaturecontratravail_26, t0.date_signaturedeclaengagement AS date_signaturedeclaengagement_27, t0.nationalite AS nationalite_28, t0.pays AS pays_29, t0.formation_base AS formation_base_30, t0.profession AS profession_31, t0.prevention_abus AS prevention_abus_32, t0.contrat_signe AS contrat_signe_33, t0.contrat_engagement AS contrat_engagement_34, t0.roles AS roles_35, t0.documents AS documents_36, t0.carnet_bord AS carnet_bord_37, t0.remarque AS remarque_38, t0.remarque_formations AS remarque_formations_39, t0.remarque_autorisations AS remarque_autorisations_40, t0.date_engagement AS date_engagement_41, t0.titre AS titre_42, t0.nom AS nom_43, t0.prenom AS prenom_44, t0.adresse AS adresse_45, t0.adresse2 AS adresse2_46, t0.npa AS npa_47, t0.ville AS ville_48, t0.email AS email_49, t0.telephone AS telephone_50, t0.journal AS journal_51, t0.ag AS ag_52, t0.categorie AS categorie_53, t0.type_membre AS type_membre_54, t0.datenaissance AS datenaissance_55, t0.date_entree_mbr AS date_entree_mbr_56, t0.datesortie AS datesortie_57, t0.id AS id_58, t0.created_at AS created_at_59, t0.updated_at AS updated_at_60 FROM user t0 WHERE t0.id = ?
Parameters: 
[
  126
]
View formatted query    View runnable query    Explain query    View query backtrace
2 2.15 ms 
SELECT DISTINCT c0_.titre AS titre_0, c0_.date_debut AS date_debut_1, c0_.date_fin AS date_fin_2, c0_.nombre_jours AS nombre_jours_3, c0_.nombre_nuits AS nombre_nuits_4, c0_.nombre_places AS nombre_places_5, c0_.nombre_places_urgence AS nombre_places_urgence_6, c0_.date_seance_information AS date_seance_information_7, c0_.horaire_debut_accompagnant AS horaire_debut_accompagnant_8, c0_.horaire_debut_vacancier AS horaire_debut_vacancier_9, c0_.horaire_fin_accompagnant AS horaire_fin_accompagnant_10, c0_.horaire_fin_vacancier AS horaire_fin_vacancier_11, c0_.archive AS archive_12, c0_.documents AS documents_13, c0_.inscription_ouvert AS inscription_ouvert_14, c0_.id AS id_15, c0_.created_at AS created_at_16, c0_.updated_at AS updated_at_17, t1_.nom AS nom_18, t1_.description AS description_19, t1_.weekend AS weekend_20, t1_.slug AS slug_21, t1_.categorie AS categorie_22, t1_.id AS id_23, t1_.created_at AS created_at_24, t1_.updated_at AS updated_at_25, l2_.nom AS nom_26, l2_.description AS description_27, l2_.documents AS documents_28, l2_.id AS id_29, l2_.created_at AS created_at_30, l2_.updated_at AS updated_at_31, c3_.commresp AS commresp_32, c3_.commacc AS commacc_33, c3_.commveille AS commveille_34, c3_.commcuisine AS commcuisine_35, c3_.commchauffeur AS commchauffeur_36, c3_.commanim AS commanim_37, c3_.commciv AS commciv_38, c3_.commbene AS commbene_39, c3_.commstage AS commstage_40, c3_.commproche AS commproche_41, c3_.id AS id_42, c3_.created_at AS created_at_43, c3_.updated_at AS updated_at_44, t4_.nom AS nom_45, t4_.description AS description_46, t4_.id AS id_47, t4_.created_at AS created_at_48, t4_.updated_at AS updated_at_49, c0_.typecamp_id AS typecamp_id_50, c0_.lieuxcamp_id AS lieuxcamp_id_51, c0_.commentary_id AS commentary_id_52, t1_.typeinscription_id AS typeinscription_id_53 FROM camp c0_ LEFT JOIN typecamp t1_ ON c0_.typecamp_id = t1_.id LEFT JOIN lieuxcamp l2_ ON c0_.lieuxcamp_id = l2_.id LEFT JOIN commentary c3_ ON c0_.commentary_id = c3_.id LEFT JOIN typeinscription t4_ ON t1_.typeinscription_id = t4_.id WHERE c0_.archive <> ? AND c0_.date_debut >= ? AND c0_.date_debut <= ? ORDER BY t4_.id ASC
Parameters: 
[
  2
  "2026-01-01 00:00:00"
  "2026-12-31 23:59:59"
]
View formatted query    View runnable query    Explain query    View query backtrace
3 2.21 ms 
SELECT i0_.remarque AS remarque_0, i0_.inscrire AS inscrire_1, i0_.priorite AS priorite_2, i0_.approve AS approve_3, i0_.frequence AS frequence_4, i0_.frequence_txt AS frequence_txt_5, i0_.nombre_camps AS nombre_camps_6, i0_.status AS status_7, i0_.post AS post_8, i0_.id AS id_9, i0_.created_at AS created_at_10, i0_.updated_at AS updated_at_11, c1_.titre AS titre_12, c1_.date_debut AS date_debut_13, c1_.date_fin AS date_fin_14, c1_.nombre_jours AS nombre_jours_15, c1_.nombre_nuits AS nombre_nuits_16, c1_.nombre_places AS nombre_places_17, c1_.nombre_places_urgence AS nombre_places_urgence_18, c1_.date_seance_information AS date_seance_information_19, c1_.horaire_debut_accompagnant AS horaire_debut_accompagnant_20, c1_.horaire_debut_vacancier AS horaire_debut_vacancier_21, c1_.horaire_fin_accompagnant AS horaire_fin_accompagnant_22, c1_.horaire_fin_vacancier AS horaire_fin_vacancier_23, c1_.archive AS archive_24, c1_.documents AS documents_25, c1_.inscription_ouvert AS inscription_ouvert_26, c1_.id AS id_27, c1_.created_at AS created_at_28, c1_.updated_at AS updated_at_29, i0_.camp_id AS camp_id_30, i0_.vacancier_id AS vacancier_id_31, i0_.user_id AS user_id_32, c1_.typecamp_id AS typecamp_id_33, c1_.lieuxcamp_id AS lieuxcamp_id_34, c1_.commentary_id AS commentary_id_35 FROM inscription i0_ LEFT JOIN camp c1_ ON i0_.camp_id = c1_.id WHERE c1_.id = ?
Parameters: 
[
  214
]
View formatted query    View runnable query    Explain query    View query backtrace
4 0.41 ms 
SELECT i0_.remarque AS remarque_0, i0_.inscrire AS inscrire_1, i0_.priorite AS priorite_2, i0_.approve AS approve_3, i0_.frequence AS frequence_4, i0_.frequence_txt AS frequence_txt_5, i0_.nombre_camps AS nombre_camps_6, i0_.status AS status_7, i0_.post AS post_8, i0_.id AS id_9, i0_.created_at AS created_at_10, i0_.updated_at AS updated_at_11, c1_.titre AS titre_12, c1_.date_debut AS date_debut_13, c1_.date_fin AS date_fin_14, c1_.nombre_jours AS nombre_jours_15, c1_.nombre_nuits AS nombre_nuits_16, c1_.nombre_places AS nombre_places_17, c1_.nombre_places_urgence AS nombre_places_urgence_18, c1_.date_seance_information AS date_seance_information_19, c1_.horaire_debut_accompagnant AS horaire_debut_accompagnant_20, c1_.horaire_debut_vacancier AS horaire_debut_vacancier_21, c1_.horaire_fin_accompagnant AS horaire_fin_accompagnant_22, c1_.horaire_fin_vacancier AS horaire_fin_vacancier_23, c1_.archive AS archive_24, c1_.documents AS documents_25, c1_.inscription_ouvert AS inscription_ouvert_26, c1_.id AS id_27, c1_.created_at AS created_at_28, c1_.updated_at AS updated_at_29, i0_.camp_id AS camp_id_30, i0_.vacancier_id AS vacancier_id_31, i0_.user_id AS user_id_32, c1_.typecamp_id AS typecamp_id_33, c1_.lieuxcamp_id AS lieuxcamp_id_34, c1_.commentary_id AS commentary_id_35 FROM inscription i0_ LEFT JOIN camp c1_ ON i0_.camp_id = c1_.id WHERE c1_.id = ?
Parameters: 
[
  221
]
View formatted query    View runnable query    Explain query    View query backtrace
5 0.39 ms 
SELECT i0_.remarque AS remarque_0, i0_.inscrire AS inscrire_1, i0_.priorite AS priorite_2, i0_.approve AS approve_3, i0_.frequence AS frequence_4, i0_.frequence_txt AS frequence_txt_5, i0_.nombre_camps AS nombre_camps_6, i0_.status AS status_7, i0_.post AS post_8, i0_.id AS id_9, i0_.created_at AS created_at_10, i0_.updated_at AS updated_at_11, c1_.titre AS titre_12, c1_.date_debut AS date_debut_13, c1_.date_fin AS date_fin_14, c1_.nombre_jours AS nombre_jours_15, c1_.nombre_nuits AS nombre_nuits_16, c1_.nombre_places AS nombre_places_17, c1_.nombre_places_urgence AS nombre_places_urgence_18, c1_.date_seance_information AS date_seance_information_19, c1_.horaire_debut_accompagnant AS horaire_debut_accompagnant_20, c1_.horaire_debut_vacancier AS horaire_debut_vacancier_21, c1_.horaire_fin_accompagnant AS horaire_fin_accompagnant_22, c1_.horaire_fin_vacancier AS horaire_fin_vacancier_23, c1_.archive AS archive_24, c1_.documents AS documents_25, c1_.inscription_ouvert AS inscription_ouvert_26, c1_.id AS id_27, c1_.created_at AS created_at_28, c1_.updated_at AS updated_at_29, i0_.camp_id AS camp_id_30, i0_.vacancier_id AS vacancier_id_31, i0_.user_id AS user_id_32, c1_.typecamp_id AS typecamp_id_33, c1_.lieuxcamp_id AS lieuxcamp_id_34, c1_.commentary_id AS commentary_id_35 FROM inscription i0_ LEFT JOIN camp c1_ ON i0_.camp_id = c1_.id WHERE c1_.id = ?
Parameters: 
[
  222
]
View formatted query    View runnable query    Explain query    View query backtrace
6 0.33 ms 
SELECT i0_.remarque AS remarque_0, i0_.inscrire AS inscrire_1, i0_.priorite AS priorite_2, i0_.approve AS approve_3, i0_.frequence AS frequence_4, i0_.frequence_txt AS frequence_txt_5, i0_.nombre_camps AS nombre_camps_6, i0_.status AS status_7, i0_.post AS post_8, i0_.id AS id_9, i0_.created_at AS created_at_10, i0_.updated_at AS updated_at_11, c1_.titre AS titre_12, c1_.date_debut AS date_debut_13, c1_.date_fin AS date_fin_14, c1_.nombre_jours AS nombre_jours_15, c1_.nombre_nuits AS nombre_nuits_16, c1_.nombre_places AS nombre_places_17, c1_.nombre_places_urgence AS nombre_places_urgence_18, c1_.date_seance_information AS date_seance_information_19, c1_.horaire_debut_accompagnant AS horaire_debut_accompagnant_20, c1_.horaire_debut_vacancier AS horaire_debut_vacancier_21, c1_.horaire_fin_accompagnant AS horaire_fin_accompagnant_22, c1_.horaire_fin_vacancier AS horaire_fin_vacancier_23, c1_.archive AS archive_24, c1_.documents AS documents_25, c1_.inscription_ouvert AS inscription_ouvert_26, c1_.id AS id_27, c1_.created_at AS created_at_28, c1_.updated_at AS updated_at_29, i0_.camp_id AS camp_id_30, i0_.vacancier_id AS vacancier_id_31, i0_.user_id AS user_id_32, c1_.typecamp_id AS typecamp_id_33, c1_.lieuxcamp_id AS lieuxcamp_id_34, c1_.commentary_id AS commentary_id_35 FROM inscription i0_ LEFT JOIN camp c1_ ON i0_.camp_id = c1_.id WHERE c1_.id = ?
Parameters: 
[
  224
]
View formatted query    View runnable query    Explain query    View query backtrace
7 0.37 ms 
SELECT i0_.remarque AS remarque_0, i0_.inscrire AS inscrire_1, i0_.priorite AS priorite_2, i0_.approve AS approve_3, i0_.frequence AS frequence_4, i0_.frequence_txt AS frequence_txt_5, i0_.nombre_camps AS nombre_camps_6, i0_.status AS status_7, i0_.post AS post_8, i0_.id AS id_9, i0_.created_at AS created_at_10, i0_.updated_at AS updated_at_11, c1_.titre AS titre_12, c1_.date_debut AS date_debut_13, c1_.date_fin AS date_fin_14, c1_.nombre_jours AS nombre_jours_15, c1_.nombre_nuits AS nombre_nuits_16, c1_.nombre_places AS nombre_places_17, c1_.nombre_places_urgence AS nombre_places_urgence_18, c1_.date_seance_information AS date_seance_information_19, c1_.horaire_debut_accompagnant AS horaire_debut_accompagnant_20, c1_.horaire_debut_vacancier AS horaire_debut_vacancier_21, c1_.horaire_fin_accompagnant AS horaire_fin_accompagnant_22, c1_.horaire_fin_vacancier AS horaire_fin_vacancier_23, c1_.archive AS archive_24, c1_.documents AS documents_25, c1_.inscription_ouvert AS inscription_ouvert_26, c1_.id AS id_27, c1_.created_at AS created_at_28, c1_.updated_at AS updated_at_29, i0_.camp_id AS camp_id_30, i0_.vacancier_id AS vacancier_id_31, i0_.user_id AS user_id_32, c1_.typecamp_id AS typecamp_id_33, c1_.lieuxcamp_id AS lieuxcamp_id_34, c1_.commentary_id AS commentary_id_35 FROM inscription i0_ LEFT JOIN camp c1_ ON i0_.camp_id = c1_.id WHERE c1_.id = ?
Parameters: 
[
  215
]
View formatted query    View runnable query    Explain query    View query backtrace
8 0.35 ms 
SELECT i0_.remarque AS remarque_0, i0_.inscrire AS inscrire_1, i0_.priorite AS priorite_2, i0_.approve AS approve_3, i0_.frequence AS frequence_4, i0_.frequence_txt AS frequence_txt_5, i0_.nombre_camps AS nombre_camps_6, i0_.status AS status_7, i0_.post AS post_8, i0_.id AS id_9, i0_.created_at AS created_at_10, i0_.updated_at AS updated_at_11, c1_.titre AS titre_12, c1_.date_debut AS date_debut_13, c1_.date_fin AS date_fin_14, c1_.nombre_jours AS nombre_jours_15, c1_.nombre_nuits AS nombre_nuits_16, c1_.nombre_places AS nombre_places_17, c1_.nombre_places_urgence AS nombre_places_urgence_18, c1_.date_seance_information AS date_seance_information_19, c1_.horaire_debut_accompagnant AS horaire_debut_accompagnant_20, c1_.horaire_debut_vacancier AS horaire_debut_vacancier_21, c1_.horaire_fin_accompagnant AS horaire_fin_accompagnant_22, c1_.horaire_fin_vacancier AS horaire_fin_vacancier_23, c1_.archive AS archive_24, c1_.documents AS documents_25, c1_.inscription_ouvert AS inscription_ouvert_26, c1_.id AS id_27, c1_.created_at AS created_at_28, c1_.updated_at AS updated_at_29, i0_.camp_id AS camp_id_30, i0_.vacancier_id AS vacancier_id_31, i0_.user_id AS user_id_32, c1_.typecamp_id AS typecamp_id_33, c1_.lieuxcamp_id AS lieuxcamp_id_34, c1_.commentary_id AS commentary_id_35 FROM inscription i0_ LEFT JOIN camp c1_ ON i0_.camp_id = c1_.id WHERE c1_.id = ?
Parameters: 
[
  217
]
View formatted query    View runnable query    Explain query    View query backtrace
9 0.35 ms 
SELECT i0_.remarque AS remarque_0, i0_.inscrire AS inscrire_1, i0_.priorite AS priorite_2, i0_.approve AS approve_3, i0_.frequence AS frequence_4, i0_.frequence_txt AS frequence_txt_5, i0_.nombre_camps AS nombre_camps_6, i0_.status AS status_7, i0_.post AS post_8, i0_.id AS id_9, i0_.created_at AS created_at_10, i0_.updated_at AS updated_at_11, c1_.titre AS titre_12, c1_.date_debut AS date_debut_13, c1_.date_fin AS date_fin_14, c1_.nombre_jours AS nombre_jours_15, c1_.nombre_nuits AS nombre_nuits_16, c1_.nombre_places AS nombre_places_17, c1_.nombre_places_urgence AS nombre_places_urgence_18, c1_.date_seance_information AS date_seance_information_19, c1_.horaire_debut_accompagnant AS horaire_debut_accompagnant_20, c1_.horaire_debut_vacancier AS horaire_debut_vacancier_21, c1_.horaire_fin_accompagnant AS horaire_fin_accompagnant_22, c1_.horaire_fin_vacancier AS horaire_fin_vacancier_23, c1_.archive AS archive_24, c1_.documents AS documents_25, c1_.inscription_ouvert AS inscription_ouvert_26, c1_.id AS id_27, c1_.created_at AS created_at_28, c1_.updated_at AS updated_at_29, i0_.camp_id AS camp_id_30, i0_.vacancier_id AS vacancier_id_31, i0_.user_id AS user_id_32, c1_.typecamp_id AS typecamp_id_33, c1_.lieuxcamp_id AS lieuxcamp_id_34, c1_.commentary_id AS commentary_id_35 FROM inscription i0_ LEFT JOIN camp c1_ ON i0_.camp_id = c1_.id WHERE c1_.id = ?
Parameters: 
[
  218
]
View formatted query    View runnable query    Explain query    View query backtrace
10 0.32 ms 
SELECT i0_.remarque AS remarque_0, i0_.inscrire AS inscrire_1, i0_.priorite AS priorite_2, i0_.approve AS approve_3, i0_.frequence AS frequence_4, i0_.frequence_txt AS frequence_txt_5, i0_.nombre_camps AS nombre_camps_6, i0_.status AS status_7, i0_.post AS post_8, i0_.id AS id_9, i0_.created_at AS created_at_10, i0_.updated_at AS updated_at_11, c1_.titre AS titre_12, c1_.date_debut AS date_debut_13, c1_.date_fin AS date_fin_14, c1_.nombre_jours AS nombre_jours_15, c1_.nombre_nuits AS nombre_nuits_16, c1_.nombre_places AS nombre_places_17, c1_.nombre_places_urgence AS nombre_places_urgence_18, c1_.date_seance_information AS date_seance_information_19, c1_.horaire_debut_accompagnant AS horaire_debut_accompagnant_20, c1_.horaire_debut_vacancier AS horaire_debut_vacancier_21, c1_.horaire_fin_accompagnant AS horaire_fin_accompagnant_22, c1_.horaire_fin_vacancier AS horaire_fin_vacancier_23, c1_.archive AS archive_24, c1_.documents AS documents_25, c1_.inscription_ouvert AS inscription_ouvert_26, c1_.id AS id_27, c1_.created_at AS created_at_28, c1_.updated_at AS updated_at_29, i0_.camp_id AS camp_id_30, i0_.vacancier_id AS vacancier_id_31, i0_.user_id AS user_id_32, c1_.typecamp_id AS typecamp_id_33, c1_.lieuxcamp_id AS lieuxcamp_id_34, c1_.commentary_id AS commentary_id_35 FROM inscription i0_ LEFT JOIN camp c1_ ON i0_.camp_id = c1_.id WHERE c1_.id = ?
Parameters: 
[
  223
]
View formatted query    View runnable query    Explain query    View query backtrace
11 0.34 ms 
SELECT i0_.remarque AS remarque_0, i0_.inscrire AS inscrire_1, i0_.priorite AS priorite_2, i0_.approve AS approve_3, i0_.frequence AS frequence_4, i0_.frequence_txt AS frequence_txt_5, i0_.nombre_camps AS nombre_camps_6, i0_.status AS status_7, i0_.post AS post_8, i0_.id AS id_9, i0_.created_at AS created_at_10, i0_.updated_at AS updated_at_11, c1_.titre AS titre_12, c1_.date_debut AS date_debut_13, c1_.date_fin AS date_fin_14, c1_.nombre_jours AS nombre_jours_15, c1_.nombre_nuits AS nombre_nuits_16, c1_.nombre_places AS nombre_places_17, c1_.nombre_places_urgence AS nombre_places_urgence_18, c1_.date_seance_information AS date_seance_information_19, c1_.horaire_debut_accompagnant AS horaire_debut_accompagnant_20, c1_.horaire_debut_vacancier AS horaire_debut_vacancier_21, c1_.horaire_fin_accompagnant AS horaire_fin_accompagnant_22, c1_.horaire_fin_vacancier AS horaire_fin_vacancier_23, c1_.archive AS archive_24, c1_.documents AS documents_25, c1_.inscription_ouvert AS inscription_ouvert_26, c1_.id AS id_27, c1_.created_at AS created_at_28, c1_.updated_at AS updated_at_29, i0_.camp_id AS camp_id_30, i0_.vacancier_id AS vacancier_id_31, i0_.user_id AS user_id_32, c1_.typecamp_id AS typecamp_id_33, c1_.lieuxcamp_id AS lieuxcamp_id_34, c1_.commentary_id AS commentary_id_35 FROM inscription i0_ LEFT JOIN camp c1_ ON i0_.camp_id = c1_.id WHERE c1_.id = ?
Parameters: 
[
  216
]
View formatted query    View runnable query    Explain query    View query backtrace
12 0.33 ms 
SELECT i0_.remarque AS remarque_0, i0_.inscrire AS inscrire_1, i0_.priorite AS priorite_2, i0_.approve AS approve_3, i0_.frequence AS frequence_4, i0_.frequence_txt AS frequence_txt_5, i0_.nombre_camps AS nombre_camps_6, i0_.status AS status_7, i0_.post AS post_8, i0_.id AS id_9, i0_.created_at AS created_at_10, i0_.updated_at AS updated_at_11, c1_.titre AS titre_12, c1_.date_debut AS date_debut_13, c1_.date_fin AS date_fin_14, c1_.nombre_jours AS nombre_jours_15, c1_.nombre_nuits AS nombre_nuits_16, c1_.nombre_places AS nombre_places_17, c1_.nombre_places_urgence AS nombre_places_urgence_18, c1_.date_seance_information AS date_seance_information_19, c1_.horaire_debut_accompagnant AS horaire_debut_accompagnant_20, c1_.horaire_debut_vacancier AS horaire_debut_vacancier_21, c1_.horaire_fin_accompagnant AS horaire_fin_accompagnant_22, c1_.horaire_fin_vacancier AS horaire_fin_vacancier_23, c1_.archive AS archive_24, c1_.documents AS documents_25, c1_.inscription_ouvert AS inscription_ouvert_26, c1_.id AS id_27, c1_.created_at AS created_at_28, c1_.updated_at AS updated_at_29, i0_.camp_id AS camp_id_30, i0_.vacancier_id AS vacancier_id_31, i0_.user_id AS user_id_32, c1_.typecamp_id AS typecamp_id_33, c1_.lieuxcamp_id AS lieuxcamp_id_34, c1_.commentary_id AS commentary_id_35 FROM inscription i0_ LEFT JOIN camp c1_ ON i0_.camp_id = c1_.id WHERE c1_.id = ?
Parameters: 
[
  219
]
View formatted query    View runnable query    Explain query    View query backtrace
13 0.42 ms 
SELECT i0_.remarque AS remarque_0, i0_.inscrire AS inscrire_1, i0_.priorite AS priorite_2, i0_.approve AS approve_3, i0_.frequence AS frequence_4, i0_.frequence_txt AS frequence_txt_5, i0_.nombre_camps AS nombre_camps_6, i0_.status AS status_7, i0_.post AS post_8, i0_.id AS id_9, i0_.created_at AS created_at_10, i0_.updated_at AS updated_at_11, c1_.titre AS titre_12, c1_.date_debut AS date_debut_13, c1_.date_fin AS date_fin_14, c1_.nombre_jours AS nombre_jours_15, c1_.nombre_nuits AS nombre_nuits_16, c1_.nombre_places AS nombre_places_17, c1_.nombre_places_urgence AS nombre_places_urgence_18, c1_.date_seance_information AS date_seance_information_19, c1_.horaire_debut_accompagnant AS horaire_debut_accompagnant_20, c1_.horaire_debut_vacancier AS horaire_debut_vacancier_21, c1_.horaire_fin_accompagnant AS horaire_fin_accompagnant_22, c1_.horaire_fin_vacancier AS horaire_fin_vacancier_23, c1_.archive AS archive_24, c1_.documents AS documents_25, c1_.inscription_ouvert AS inscription_ouvert_26, c1_.id AS id_27, c1_.created_at AS created_at_28, c1_.updated_at AS updated_at_29, i0_.camp_id AS camp_id_30, i0_.vacancier_id AS vacancier_id_31, i0_.user_id AS user_id_32, c1_.typecamp_id AS typecamp_id_33, c1_.lieuxcamp_id AS lieuxcamp_id_34, c1_.commentary_id AS commentary_id_35 FROM inscription i0_ LEFT JOIN camp c1_ ON i0_.camp_id = c1_.id WHERE c1_.id = ?
Parameters: 
[
  220
]
View formatted query    View runnable query    Explain query    View query backtrace
14 0.69 ms 
SELECT t0.login AS login_1, t0.password AS password_2, t0.medicament AS medicament_3, t0.nomparent1 AS nomparent1_4, t0.prenomparent1 AS prenomparent1_5, t0.adresseparent1 AS adresseparent1_6, t0.telephoneparent1 AS telephoneparent1_7, t0.nomparent2 AS nomparent2_8, t0.prenomparent2 AS prenomparent2_9, t0.adresseparent2 AS adresseparent2_10, t0.emailparent2 AS emailparent2_11, t0.mobilite AS mobilite_12, t0.datentree AS datentree_13, t0.photo AS photo_14, t0.remarque AS remarque_15, t0.membre AS membre_16, t0.photo_autorisee AS photo_autorisee_17, t0.diffusion_autorisee AS diffusion_autorisee_18, t0.api AS api_19, t0.ssi AS ssi_20, t0.avs AS avs_21, t0.regime_alimentaire AS regime_alimentaire_22, t0.regime_alimentaire_autre AS regime_alimentaire_autre_23, t0.adresse_facturation AS adresse_facturation_24, t0.psa_autres AS psa_autres_25, t0.archive AS archive_26, t0.diagnostic AS diagnostic_27, t0.nomcurateur AS nomcurateur_28, t0.prenomcurateur AS prenomcurateur_29, t0.adressecurateur AS adressecurateur_30, t0.email_curateur AS email_curateur_31, t0.telephonecurateur AS telephonecurateur_32, t0.taux_encadrement AS taux_encadrement_33, t0.emailparent1 AS emailparent1_34, t0.telephoneparent2 AS telephoneparent2_35, t0.urgence AS urgence_36, t0.moyens_auxiliaires AS moyens_auxiliaires_37, t0.roles AS roles_38, t0.representant_legal AS representant_legal_39, t0.visite AS visite_40, t0.consistance AS consistance_41, t0.epilepsie AS epilepsie_42, t0.domiciliation AS domiciliation_43, t0.allergie AS allergie_44, t0.genre AS genre_45, t0.documents AS documents_46, t0.nom_groupe AS nom_groupe_47, t0.email_groupe AS email_groupe_48, t0.telephone_groupe AS telephone_groupe_49, t0.carnet_bord AS carnet_bord_50, t0.poste AS poste_51, t0.region AS region_52, t0.type_handicap AS type_handicap_53, t0.envoi_mail AS envoi_mail_54, t0.titre AS titre_55, t0.nom AS nom_56, t0.prenom AS prenom_57, t0.adresse AS adresse_58, t0.adresse2 AS adresse2_59, t0.npa AS npa_60, t0.ville AS ville_61, t0.email AS email_62, t0.telephone AS telephone_63, t0.journal AS journal_64, t0.ag AS ag_65, t0.categorie AS categorie_66, t0.type_membre AS type_membre_67, t0.datenaissance AS datenaissance_68, t0.date_entree_mbr AS date_entree_mbr_69, t0.datesortie AS datesortie_70, t0.id AS id_71, t0.created_at AS created_at_72, t0.updated_at AS updated_at_73, t0.carnet_sante_id AS carnet_sante_id_74, t0.psa_id AS psa_id_75, t0.institution_id AS institution_id_76 FROM vacancier t0 WHERE t0.id = ?
Parameters: 
[
  164
]
View formatted query    View runnable query    Explain query    View query backtrace
15 0.53 ms 
SELECT t0.login AS login_1, t0.password AS password_2, t0.medicament AS medicament_3, t0.nomparent1 AS nomparent1_4, t0.prenomparent1 AS prenomparent1_5, t0.adresseparent1 AS adresseparent1_6, t0.telephoneparent1 AS telephoneparent1_7, t0.nomparent2 AS nomparent2_8, t0.prenomparent2 AS prenomparent2_9, t0.adresseparent2 AS adresseparent2_10, t0.emailparent2 AS emailparent2_11, t0.mobilite AS mobilite_12, t0.datentree AS datentree_13, t0.photo AS photo_14, t0.remarque AS remarque_15, t0.membre AS membre_16, t0.photo_autorisee AS photo_autorisee_17, t0.diffusion_autorisee AS diffusion_autorisee_18, t0.api AS api_19, t0.ssi AS ssi_20, t0.avs AS avs_21, t0.regime_alimentaire AS regime_alimentaire_22, t0.regime_alimentaire_autre AS regime_alimentaire_autre_23, t0.adresse_facturation AS adresse_facturation_24, t0.psa_autres AS psa_autres_25, t0.archive AS archive_26, t0.diagnostic AS diagnostic_27, t0.nomcurateur AS nomcurateur_28, t0.prenomcurateur AS prenomcurateur_29, t0.adressecurateur AS adressecurateur_30, t0.email_curateur AS email_curateur_31, t0.telephonecurateur AS telephonecurateur_32, t0.taux_encadrement AS taux_encadrement_33, t0.emailparent1 AS emailparent1_34, t0.telephoneparent2 AS telephoneparent2_35, t0.urgence AS urgence_36, t0.moyens_auxiliaires AS moyens_auxiliaires_37, t0.roles AS roles_38, t0.representant_legal AS representant_legal_39, t0.visite AS visite_40, t0.consistance AS consistance_41, t0.epilepsie AS epilepsie_42, t0.domiciliation AS domiciliation_43, t0.allergie AS allergie_44, t0.genre AS genre_45, t0.documents AS documents_46, t0.nom_groupe AS nom_groupe_47, t0.email_groupe AS email_groupe_48, t0.telephone_groupe AS telephone_groupe_49, t0.carnet_bord AS carnet_bord_50, t0.poste AS poste_51, t0.region AS region_52, t0.type_handicap AS type_handicap_53, t0.envoi_mail AS envoi_mail_54, t0.titre AS titre_55, t0.nom AS nom_56, t0.prenom AS prenom_57, t0.adresse AS adresse_58, t0.adresse2 AS adresse2_59, t0.npa AS npa_60, t0.ville AS ville_61, t0.email AS email_62, t0.telephone AS telephone_63, t0.journal AS journal_64, t0.ag AS ag_65, t0.categorie AS categorie_66, t0.type_membre AS type_membre_67, t0.datenaissance AS datenaissance_68, t0.date_entree_mbr AS date_entree_mbr_69, t0.datesortie AS datesortie_70, t0.id AS id_71, t0.created_at AS created_at_72, t0.updated_at AS updated_at_73, t0.carnet_sante_id AS carnet_sante_id_74, t0.psa_id AS psa_id_75, t0.institution_id AS institution_id_76 FROM vacancier t0 WHERE t0.id = ?
Parameters: 
[
  163
]
View formatted query    View runnable query    Explain query    View query backtrace
16 0.45 ms 
SELECT t0.login AS login_1, t0.password AS password_2, t0.medicament AS medicament_3, t0.nomparent1 AS nomparent1_4, t0.prenomparent1 AS prenomparent1_5, t0.adresseparent1 AS adresseparent1_6, t0.telephoneparent1 AS telephoneparent1_7, t0.nomparent2 AS nomparent2_8, t0.prenomparent2 AS prenomparent2_9, t0.adresseparent2 AS adresseparent2_10, t0.emailparent2 AS emailparent2_11, t0.mobilite AS mobilite_12, t0.datentree AS datentree_13, t0.photo AS photo_14, t0.remarque AS remarque_15, t0.membre AS membre_16, t0.photo_autorisee AS photo_autorisee_17, t0.diffusion_autorisee AS diffusion_autorisee_18, t0.api AS api_19, t0.ssi AS ssi_20, t0.avs AS avs_21, t0.regime_alimentaire AS regime_alimentaire_22, t0.regime_alimentaire_autre AS regime_alimentaire_autre_23, t0.adresse_facturation AS adresse_facturation_24, t0.psa_autres AS psa_autres_25, t0.archive AS archive_26, t0.diagnostic AS diagnostic_27, t0.nomcurateur AS nomcurateur_28, t0.prenomcurateur AS prenomcurateur_29, t0.adressecurateur AS adressecurateur_30, t0.email_curateur AS email_curateur_31, t0.telephonecurateur AS telephonecurateur_32, t0.taux_encadrement AS taux_encadrement_33, t0.emailparent1 AS emailparent1_34, t0.telephoneparent2 AS telephoneparent2_35, t0.urgence AS urgence_36, t0.moyens_auxiliaires AS moyens_auxiliaires_37, t0.roles AS roles_38, t0.representant_legal AS representant_legal_39, t0.visite AS visite_40, t0.consistance AS consistance_41, t0.epilepsie AS epilepsie_42, t0.domiciliation AS domiciliation_43, t0.allergie AS allergie_44, t0.genre AS genre_45, t0.documents AS documents_46, t0.nom_groupe AS nom_groupe_47, t0.email_groupe AS email_groupe_48, t0.telephone_groupe AS telephone_groupe_49, t0.carnet_bord AS carnet_bord_50, t0.poste AS poste_51, t0.region AS region_52, t0.type_handicap AS type_handicap_53, t0.envoi_mail AS envoi_mail_54, t0.titre AS titre_55, t0.nom AS nom_56, t0.prenom AS prenom_57, t0.adresse AS adresse_58, t0.adresse2 AS adresse2_59, t0.npa AS npa_60, t0.ville AS ville_61, t0.email AS email_62, t0.telephone AS telephone_63, t0.journal AS journal_64, t0.ag AS ag_65, t0.categorie AS categorie_66, t0.type_membre AS type_membre_67, t0.datenaissance AS datenaissance_68, t0.date_entree_mbr AS date_entree_mbr_69, t0.datesortie AS datesortie_70, t0.id AS id_71, t0.created_at AS created_at_72, t0.updated_at AS updated_at_73, t0.carnet_sante_id AS carnet_sante_id_74, t0.psa_id AS psa_id_75, t0.institution_id AS institution_id_76 FROM vacancier t0 WHERE t0.id = ?
Parameters: 
[
  161
]
View formatted query    View runnable query    Explain query    View query backtrace
17 0.46 ms 
SELECT t0.login AS login_1, t0.password AS password_2, t0.medicament AS medicament_3, t0.nomparent1 AS nomparent1_4, t0.prenomparent1 AS prenomparent1_5, t0.adresseparent1 AS adresseparent1_6, t0.telephoneparent1 AS telephoneparent1_7, t0.nomparent2 AS nomparent2_8, t0.prenomparent2 AS prenomparent2_9, t0.adresseparent2 AS adresseparent2_10, t0.emailparent2 AS emailparent2_11, t0.mobilite AS mobilite_12, t0.datentree AS datentree_13, t0.photo AS photo_14, t0.remarque AS remarque_15, t0.membre AS membre_16, t0.photo_autorisee AS photo_autorisee_17, t0.diffusion_autorisee AS diffusion_autorisee_18, t0.api AS api_19, t0.ssi AS ssi_20, t0.avs AS avs_21, t0.regime_alimentaire AS regime_alimentaire_22, t0.regime_alimentaire_autre AS regime_alimentaire_autre_23, t0.adresse_facturation AS adresse_facturation_24, t0.psa_autres AS psa_autres_25, t0.archive AS archive_26, t0.diagnostic AS diagnostic_27, t0.nomcurateur AS nomcurateur_28, t0.prenomcurateur AS prenomcurateur_29, t0.adressecurateur AS adressecurateur_30, t0.email_curateur AS email_curateur_31, t0.telephonecurateur AS telephonecurateur_32, t0.taux_encadrement AS taux_encadrement_33, t0.emailparent1 AS emailparent1_34, t0.telephoneparent2 AS telephoneparent2_35, t0.urgence AS urgence_36, t0.moyens_auxiliaires AS moyens_auxiliaires_37, t0.roles AS roles_38, t0.representant_legal AS representant_legal_39, t0.visite AS visite_40, t0.consistance AS consistance_41, t0.epilepsie AS epilepsie_42, t0.domiciliation AS domiciliation_43, t0.allergie AS allergie_44, t0.genre AS genre_45, t0.documents AS documents_46, t0.nom_groupe AS nom_groupe_47, t0.email_groupe AS email_groupe_48, t0.telephone_groupe AS telephone_groupe_49, t0.carnet_bord AS carnet_bord_50, t0.poste AS poste_51, t0.region AS region_52, t0.type_handicap AS type_handicap_53, t0.envoi_mail AS envoi_mail_54, t0.titre AS titre_55, t0.nom AS nom_56, t0.prenom AS prenom_57, t0.adresse AS adresse_58, t0.adresse2 AS adresse2_59, t0.npa AS npa_60, t0.ville AS ville_61, t0.email AS email_62, t0.telephone AS telephone_63, t0.journal AS journal_64, t0.ag AS ag_65, t0.categorie AS categorie_66, t0.type_membre AS type_membre_67, t0.datenaissance AS datenaissance_68, t0.date_entree_mbr AS date_entree_mbr_69, t0.datesortie AS datesortie_70, t0.id AS id_71, t0.created_at AS created_at_72, t0.updated_at AS updated_at_73, t0.carnet_sante_id AS carnet_sante_id_74, t0.psa_id AS psa_id_75, t0.institution_id AS institution_id_76 FROM vacancier t0 WHERE t0.id = ?
Parameters: 
[
  160
]
View formatted query    View runnable query    Explain query    View query backtrace
18 0.55 ms 
SELECT t0.archive AS archive_1, t0.telmobile AS telmobile_2, t0.email2 AS email2_3, t0.date_adhesion AS date_adhesion_4, t0.membre_fondation AS membre_fondation_5, t0.diagnostic AS diagnostic_6, t0.remarque AS remarque_7, t0.nom_enfant AS nom_enfant_8, t0.date_naissance_enfant AS date_naissance_enfant_9, t0.email_groupe AS email_groupe_10, t0.type_handicap AS type_handicap_11, t0.diagnostic_enfant AS diagnostic_enfant_12, t0.remarque_enfant AS remarque_enfant_13, t0.titre AS titre_14, t0.nom AS nom_15, t0.prenom AS prenom_16, t0.adresse AS adresse_17, t0.adresse2 AS adresse2_18, t0.npa AS npa_19, t0.ville AS ville_20, t0.email AS email_21, t0.telephone AS telephone_22, t0.journal AS journal_23, t0.ag AS ag_24, t0.categorie AS categorie_25, t0.type_membre AS type_membre_26, t0.datenaissance AS datenaissance_27, t0.date_entree_mbr AS date_entree_mbr_28, t0.datesortie AS datesortie_29, t0.id AS id_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.institution_id AS institution_id_33 FROM membre t0 INNER JOIN parents_enfants ON t0.id = parents_enfants.membre_id WHERE parents_enfants.vacancier_id = ?
Parameters: 
[
  161
]
View formatted query    View runnable query    Explain query    View query backtrace
19 1.08 ms 
SELECT t0.iga_transports AS iga_transports_1, t0.iga_transports_remarque AS iga_transports_remarque_2, t0.iga_harnais AS iga_harnais_3, t0.iga_maladies AS iga_maladies_4, t0.iga_trouble AS iga_trouble_5, t0.iga_trouble_description AS iga_trouble_description_6, t0.iga_habitudes AS iga_habitudes_7, t0.iga_attentif AS iga_attentif_8, t0.iga_documents AS iga_documents_9, t0.epi_acitve AS epi_acitve_10, t0.epi_stable AS epi_stable_11, t0.epi_frequences AS epi_frequences_12, t0.epi_declencheur AS epi_declencheur_13, t0.epi_deroulement AS epi_deroulement_14, t0.epi_medicament_urgence AS epi_medicament_urgence_15, t0.epi_medicament_donner AS epi_medicament_donner_16, t0.epi_attention AS epi_attention_17, t0.epi_remarque AS epi_remarque_18, t0.epi_documents AS epi_documents_19, t0.ali_regime_alimentaire AS ali_regime_alimentaire_20, t0.ali_regime_alimentaire_autre AS ali_regime_alimentaire_autre_21, t0.ali_consistance AS ali_consistance_22, t0.ali_constistance_remarque AS ali_constistance_remarque_23, t0.ali_allergie AS ali_allergie_24, t0.ali_intolerance AS ali_intolerance_25, t0.ali_eviter AS ali_eviter_26, t0.ali_aime AS ali_aime_27, t0.ali_aime_pas AS ali_aime_pas_28, t0.ali_assiette AS ali_assiette_29, t0.ali_assiette_auxiliaire AS ali_assiette_auxiliaire_30, t0.ali_assiette_autre AS ali_assiette_autre_31, t0.ali_assiette_remarque AS ali_assiette_remarque_32, t0.ali_position AS ali_position_33, t0.ali_manger_aide AS ali_manger_aide_34, t0.ali_manger_aide_remarque AS ali_manger_aide_remarque_35, t0.ali_main AS ali_main_36, t0.ali_quantite AS ali_quantite_37, t0.ali_quantite_remarque AS ali_quantite_remarque_38, t0.ali_refus AS ali_refus_39, t0.ali_refus_minutes AS ali_refus_minutes_40, t0.ali_refus_autre AS ali_refus_autre_41, t0.ali_refus_remarque AS ali_refus_remarque_42, t0.ali_resservir AS ali_resservir_43, t0.ali_resservir_autre AS ali_resservir_autre_44, t0.ali_boisson AS ali_boisson_45, t0.ali_boisson_epais AS ali_boisson_epais_46, t0.ali_boisson_autre AS ali_boisson_autre_47, t0.ali_boire_aide AS ali_boire_aide_48, t0.ali_boisson_aime AS ali_boisson_aime_49, t0.ali_boisson_supporte_pas AS ali_boisson_supporte_pas_50, t0.ali_boire_quantite AS ali_boire_quantite_51, t0.ali_boire_astuce AS ali_boire_astuce_52, t0.ali_boisson_alcool AS ali_boisson_alcool_53, t0.ali_boisson_alcool_quantite AS ali_boisson_alcool_quantite_54, t0.ali_boisson_remarque AS ali_boisson_remarque_55, t0.ali_peg_util AS ali_peg_util_56, t0.ali_peg_util_manger AS ali_peg_util_manger_57, t0.ali_peg_util_manger_moins AS ali_peg_util_manger_moins_58, t0.ali_peg_util_manger_autre AS ali_peg_util_manger_autre_59, t0.ali_peg_util_manger_machine AS ali_peg_util_manger_machine_60, t0.ali_peg_util_manger_machine_rem AS ali_peg_util_manger_machine_rem_61, t0.ali_peg_util_boire AS ali_peg_util_boire_62, t0.ali_peg_util_boire_min_normal AS ali_peg_util_boire_min_normal_63, t0.ali_peg_util_boire_min_canicule AS ali_peg_util_boire_min_canicule_64, t0.ali_peg_util_boire_max AS ali_peg_util_boire_max_65, t0.ali_peg_util_boire_max_rem AS ali_peg_util_boire_max_rem_66, t0.ali_peg_util_boire_machine AS ali_peg_util_boire_machine_67, t0.ali_peg_util_boire_machine_rem AS ali_peg_util_boire_machine_rem_68, t0.ali_peg_habitue_fixe AS ali_peg_habitue_fixe_69, t0.ali_peg_habitue_quantite AS ali_peg_habitue_quantite_70, t0.ali_peg_habitue_heure1 AS ali_peg_habitue_heure1_71, t0.ali_peg_habitue_heure2 AS ali_peg_habitue_heure2_72, t0.ali_peg_habitue_heure3 AS ali_peg_habitue_heure3_73, t0.ali_peg_habitue_heure4 AS ali_peg_habitue_heure4_74, t0.ali_peg_habitue_heure5 AS ali_peg_habitue_heure5_75, t0.ali_peg_habitue_quantite1 AS ali_peg_habitue_quantite1_76, t0.ali_peg_habitue_quantite2 AS ali_peg_habitue_quantite2_77, t0.ali_peg_habitue_quantite3 AS ali_peg_habitue_quantite3_78, t0.ali_peg_habitue_quantite4 AS ali_peg_habitue_quantite4_79, t0.ali_peg_habitue_quantite5 AS ali_peg_habitue_quantite5_80, t0.ali_peg_habitue_eau1 AS ali_peg_habitue_eau1_81, t0.ali_peg_habitue_eau2 AS ali_peg_habitue_eau2_82, t0.ali_peg_habitue_eau3 AS ali_peg_habitue_eau3_83, t0.ali_peg_habitue_eau4 AS ali_peg_habitue_eau4_84, t0.ali_peg_habitue_eau5 AS ali_peg_habitue_eau5_85, t0.ali_peg_habitue_rem AS ali_peg_habitue_rem_86, t0.ali_peg_rem_generale AS ali_peg_rem_generale_87, t0.ali_div_medoc_prendre AS ali_div_medoc_prendre_88, t0.ali_div_rem AS ali_div_rem_89, t0.ali_documents AS ali_documents_90, t0.pro_jour AS pro_jour_91, t0.pro_jour_sortie AS pro_jour_sortie_92, t0.pro_nuit AS pro_nuit_93, t0.pro_pipi AS pro_pipi_94, t0.pro_pipi_autre AS pro_pipi_autre_95, t0.pro_caca AS pro_caca_96, t0.pro_caca_autre AS pro_caca_autre_97, t0.pro_precis AS pro_precis_98, t0.pro_precis_heure AS pro_precis_heure_99, t0.pro_precis_duree AS pro_precis_duree_100, t0.pro_demande_wc AS pro_demande_wc_101, t0.pro_demande_wc_rem AS pro_demande_wc_rem_102, t0.pro_rappel_wc AS pro_rappel_wc_103, t0.pro_precis_aide AS pro_precis_aide_104, t0.pro_protection_change AS pro_protection_change_105, t0.pro_constipation AS pro_constipation_106, t0.pro_constipation_val AS pro_constipation_val_107, t0.pro_constipation_protocole AS pro_constipation_protocole_108, t0.pro_remarque AS pro_remarque_109, t0.pro_documents AS pro_documents_110, t0.hyg_douche AS hyg_douche_111, t0.hyg_douche_jours AS hyg_douche_jours_112, t0.hyg_aide AS hyg_aide_113, t0.hyg_aide_seul AS hyg_aide_seul_114, t0.hyg_douche_pos AS hyg_douche_pos_115, t0.hyg_habiller AS hyg_habiller_116, t0.hyg_habiller_rem AS hyg_habiller_rem_117, t0.hyg_attention AS hyg_attention_118, t0.mob_activite AS mob_activite_119, t0.mob_activite_sortie AS mob_activite_sortie_120, t0.mob_activite_autre AS mob_activite_autre_121, t0.mob_transfert AS mob_transfert_122, t0.mob_transfert_autre AS mob_transfert_autre_123, t0.mob_transfert_tige AS mob_transfert_tige_124, t0.mob_transfert_attention AS mob_transfert_attention_125, t0.mob_transfert_remarque AS mob_transfert_remarque_126, t0.mob_position AS mob_position_127, t0.mob_position_confort AS mob_position_confort_128, t0.mob_position_horaire AS mob_position_horaire_129, t0.mob_position_confort_remarque AS mob_position_confort_remarque_130, t0.mob_position_aux AS mob_position_aux_131, t0.mob_position_aux_autre AS mob_position_aux_autre_132, t0.mob_position_remarque AS mob_position_remarque_133, t0.mob_documents AS mob_documents_134, t0.com_moyen AS com_moyen_135, t0.com_envie AS com_envie_136, t0.com_douleur AS com_douleur_137, t0.com_ouinon AS com_ouinon_138, t0.com_pleure AS com_pleure_139, t0.com_langage AS com_langage_140, t0.com_corps AS com_corps_141, t0.com_aide AS com_aide_142, t0.com_aide_type AS com_aide_type_143, t0.com_rem AS com_rem_144, t0.com_vision AS com_vision_145, t0.com_vision_bien AS com_vision_bien_146, t0.com_vision_rem AS com_vision_rem_147, t0.com_vision_seul AS com_vision_seul_148, t0.com_vision_seul_rem AS com_vision_seul_rem_149, t0.com_audio AS com_audio_150, t0.com_audio_bien AS com_audio_bien_151, t0.com_audio_rem AS com_audio_rem_152, t0.com_documents AS com_documents_153, t0.som_dort AS som_dort_154, t0.som_sieste AS som_sieste_155, t0.som_vacances AS som_vacances_156, t0.som_position AS som_position_157, t0.som_besoin AS som_besoin_158, t0.som_besoin_autre AS som_besoin_autre_159, t0.som_rituel AS som_rituel_160, t0.som_reveil AS som_reveil_161, t0.som_cauchemar AS som_cauchemar_162, t0.som_remarque AS som_remarque_163, t0.som_veilleur_changer AS som_veilleur_changer_164, t0.som_veilleur_tournee AS som_veilleur_tournee_165, t0.som_veilleur_partage AS som_veilleur_partage_166, t0.som_veilleur_partage_mixte AS som_veilleur_partage_mixte_167, t0.som_veilleur_remarque AS som_veilleur_remarque_168, t0.int_loisir AS int_loisir_169, t0.int_interesse AS int_interesse_170, t0.int_aime_pas AS int_aime_pas_171, t0.int_interet AS int_interet_172, t0.int_piscine AS int_piscine_173, t0.int_piscine_materiel AS int_piscine_materiel_174, t0.int_equitation AS int_equitation_175, t0.int_altitude AS int_altitude_176, t0.int_telepherique AS int_telepherique_177, t0.int_malade AS int_malade_178, t0.int_soleil AS int_soleil_179, t0.int_foule AS int_foule_180, t0.int_bruit AS int_bruit_181, t0.int_feux AS int_feux_182, t0.int_bateau AS int_bateau_183, t0.int_animaux AS int_animaux_184, t0.int_animaux_val AS int_animaux_val_185, t0.int_poils AS int_poils_186, t0.int_poils_val AS int_poils_val_187, t0.div_attitude_rea AS div_attitude_rea_188, t0.div_covid_vac AS div_covid_vac_189, t0.div_covid_derniere AS div_covid_derniere_190, t0.div_antecedent AS div_antecedent_191, t0.div_documents AS div_documents_192, t0.id AS id_193, t0.created_at AS created_at_194, t0.updated_at AS updated_at_195 FROM carnetsante t0 WHERE t0.id = ?
Parameters: 
[
  161
]
View formatted query    View runnable query    Explain query    View query backtrace
20 0.46 ms 
SELECT t0.archive AS archive_1, t0.telmobile AS telmobile_2, t0.email2 AS email2_3, t0.date_adhesion AS date_adhesion_4, t0.membre_fondation AS membre_fondation_5, t0.diagnostic AS diagnostic_6, t0.remarque AS remarque_7, t0.nom_enfant AS nom_enfant_8, t0.date_naissance_enfant AS date_naissance_enfant_9, t0.email_groupe AS email_groupe_10, t0.type_handicap AS type_handicap_11, t0.diagnostic_enfant AS diagnostic_enfant_12, t0.remarque_enfant AS remarque_enfant_13, t0.titre AS titre_14, t0.nom AS nom_15, t0.prenom AS prenom_16, t0.adresse AS adresse_17, t0.adresse2 AS adresse2_18, t0.npa AS npa_19, t0.ville AS ville_20, t0.email AS email_21, t0.telephone AS telephone_22, t0.journal AS journal_23, t0.ag AS ag_24, t0.categorie AS categorie_25, t0.type_membre AS type_membre_26, t0.datenaissance AS datenaissance_27, t0.date_entree_mbr AS date_entree_mbr_28, t0.datesortie AS datesortie_29, t0.id AS id_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.institution_id AS institution_id_33 FROM membre t0 INNER JOIN parents_enfants ON t0.id = parents_enfants.membre_id WHERE parents_enfants.vacancier_id = ?
Parameters: 
[
  163
]
View formatted query    View runnable query    Explain query    View query backtrace
21 1.07 ms 
SELECT t0.iga_transports AS iga_transports_1, t0.iga_transports_remarque AS iga_transports_remarque_2, t0.iga_harnais AS iga_harnais_3, t0.iga_maladies AS iga_maladies_4, t0.iga_trouble AS iga_trouble_5, t0.iga_trouble_description AS iga_trouble_description_6, t0.iga_habitudes AS iga_habitudes_7, t0.iga_attentif AS iga_attentif_8, t0.iga_documents AS iga_documents_9, t0.epi_acitve AS epi_acitve_10, t0.epi_stable AS epi_stable_11, t0.epi_frequences AS epi_frequences_12, t0.epi_declencheur AS epi_declencheur_13, t0.epi_deroulement AS epi_deroulement_14, t0.epi_medicament_urgence AS epi_medicament_urgence_15, t0.epi_medicament_donner AS epi_medicament_donner_16, t0.epi_attention AS epi_attention_17, t0.epi_remarque AS epi_remarque_18, t0.epi_documents AS epi_documents_19, t0.ali_regime_alimentaire AS ali_regime_alimentaire_20, t0.ali_regime_alimentaire_autre AS ali_regime_alimentaire_autre_21, t0.ali_consistance AS ali_consistance_22, t0.ali_constistance_remarque AS ali_constistance_remarque_23, t0.ali_allergie AS ali_allergie_24, t0.ali_intolerance AS ali_intolerance_25, t0.ali_eviter AS ali_eviter_26, t0.ali_aime AS ali_aime_27, t0.ali_aime_pas AS ali_aime_pas_28, t0.ali_assiette AS ali_assiette_29, t0.ali_assiette_auxiliaire AS ali_assiette_auxiliaire_30, t0.ali_assiette_autre AS ali_assiette_autre_31, t0.ali_assiette_remarque AS ali_assiette_remarque_32, t0.ali_position AS ali_position_33, t0.ali_manger_aide AS ali_manger_aide_34, t0.ali_manger_aide_remarque AS ali_manger_aide_remarque_35, t0.ali_main AS ali_main_36, t0.ali_quantite AS ali_quantite_37, t0.ali_quantite_remarque AS ali_quantite_remarque_38, t0.ali_refus AS ali_refus_39, t0.ali_refus_minutes AS ali_refus_minutes_40, t0.ali_refus_autre AS ali_refus_autre_41, t0.ali_refus_remarque AS ali_refus_remarque_42, t0.ali_resservir AS ali_resservir_43, t0.ali_resservir_autre AS ali_resservir_autre_44, t0.ali_boisson AS ali_boisson_45, t0.ali_boisson_epais AS ali_boisson_epais_46, t0.ali_boisson_autre AS ali_boisson_autre_47, t0.ali_boire_aide AS ali_boire_aide_48, t0.ali_boisson_aime AS ali_boisson_aime_49, t0.ali_boisson_supporte_pas AS ali_boisson_supporte_pas_50, t0.ali_boire_quantite AS ali_boire_quantite_51, t0.ali_boire_astuce AS ali_boire_astuce_52, t0.ali_boisson_alcool AS ali_boisson_alcool_53, t0.ali_boisson_alcool_quantite AS ali_boisson_alcool_quantite_54, t0.ali_boisson_remarque AS ali_boisson_remarque_55, t0.ali_peg_util AS ali_peg_util_56, t0.ali_peg_util_manger AS ali_peg_util_manger_57, t0.ali_peg_util_manger_moins AS ali_peg_util_manger_moins_58, t0.ali_peg_util_manger_autre AS ali_peg_util_manger_autre_59, t0.ali_peg_util_manger_machine AS ali_peg_util_manger_machine_60, t0.ali_peg_util_manger_machine_rem AS ali_peg_util_manger_machine_rem_61, t0.ali_peg_util_boire AS ali_peg_util_boire_62, t0.ali_peg_util_boire_min_normal AS ali_peg_util_boire_min_normal_63, t0.ali_peg_util_boire_min_canicule AS ali_peg_util_boire_min_canicule_64, t0.ali_peg_util_boire_max AS ali_peg_util_boire_max_65, t0.ali_peg_util_boire_max_rem AS ali_peg_util_boire_max_rem_66, t0.ali_peg_util_boire_machine AS ali_peg_util_boire_machine_67, t0.ali_peg_util_boire_machine_rem AS ali_peg_util_boire_machine_rem_68, t0.ali_peg_habitue_fixe AS ali_peg_habitue_fixe_69, t0.ali_peg_habitue_quantite AS ali_peg_habitue_quantite_70, t0.ali_peg_habitue_heure1 AS ali_peg_habitue_heure1_71, t0.ali_peg_habitue_heure2 AS ali_peg_habitue_heure2_72, t0.ali_peg_habitue_heure3 AS ali_peg_habitue_heure3_73, t0.ali_peg_habitue_heure4 AS ali_peg_habitue_heure4_74, t0.ali_peg_habitue_heure5 AS ali_peg_habitue_heure5_75, t0.ali_peg_habitue_quantite1 AS ali_peg_habitue_quantite1_76, t0.ali_peg_habitue_quantite2 AS ali_peg_habitue_quantite2_77, t0.ali_peg_habitue_quantite3 AS ali_peg_habitue_quantite3_78, t0.ali_peg_habitue_quantite4 AS ali_peg_habitue_quantite4_79, t0.ali_peg_habitue_quantite5 AS ali_peg_habitue_quantite5_80, t0.ali_peg_habitue_eau1 AS ali_peg_habitue_eau1_81, t0.ali_peg_habitue_eau2 AS ali_peg_habitue_eau2_82, t0.ali_peg_habitue_eau3 AS ali_peg_habitue_eau3_83, t0.ali_peg_habitue_eau4 AS ali_peg_habitue_eau4_84, t0.ali_peg_habitue_eau5 AS ali_peg_habitue_eau5_85, t0.ali_peg_habitue_rem AS ali_peg_habitue_rem_86, t0.ali_peg_rem_generale AS ali_peg_rem_generale_87, t0.ali_div_medoc_prendre AS ali_div_medoc_prendre_88, t0.ali_div_rem AS ali_div_rem_89, t0.ali_documents AS ali_documents_90, t0.pro_jour AS pro_jour_91, t0.pro_jour_sortie AS pro_jour_sortie_92, t0.pro_nuit AS pro_nuit_93, t0.pro_pipi AS pro_pipi_94, t0.pro_pipi_autre AS pro_pipi_autre_95, t0.pro_caca AS pro_caca_96, t0.pro_caca_autre AS pro_caca_autre_97, t0.pro_precis AS pro_precis_98, t0.pro_precis_heure AS pro_precis_heure_99, t0.pro_precis_duree AS pro_precis_duree_100, t0.pro_demande_wc AS pro_demande_wc_101, t0.pro_demande_wc_rem AS pro_demande_wc_rem_102, t0.pro_rappel_wc AS pro_rappel_wc_103, t0.pro_precis_aide AS pro_precis_aide_104, t0.pro_protection_change AS pro_protection_change_105, t0.pro_constipation AS pro_constipation_106, t0.pro_constipation_val AS pro_constipation_val_107, t0.pro_constipation_protocole AS pro_constipation_protocole_108, t0.pro_remarque AS pro_remarque_109, t0.pro_documents AS pro_documents_110, t0.hyg_douche AS hyg_douche_111, t0.hyg_douche_jours AS hyg_douche_jours_112, t0.hyg_aide AS hyg_aide_113, t0.hyg_aide_seul AS hyg_aide_seul_114, t0.hyg_douche_pos AS hyg_douche_pos_115, t0.hyg_habiller AS hyg_habiller_116, t0.hyg_habiller_rem AS hyg_habiller_rem_117, t0.hyg_attention AS hyg_attention_118, t0.mob_activite AS mob_activite_119, t0.mob_activite_sortie AS mob_activite_sortie_120, t0.mob_activite_autre AS mob_activite_autre_121, t0.mob_transfert AS mob_transfert_122, t0.mob_transfert_autre AS mob_transfert_autre_123, t0.mob_transfert_tige AS mob_transfert_tige_124, t0.mob_transfert_attention AS mob_transfert_attention_125, t0.mob_transfert_remarque AS mob_transfert_remarque_126, t0.mob_position AS mob_position_127, t0.mob_position_confort AS mob_position_confort_128, t0.mob_position_horaire AS mob_position_horaire_129, t0.mob_position_confort_remarque AS mob_position_confort_remarque_130, t0.mob_position_aux AS mob_position_aux_131, t0.mob_position_aux_autre AS mob_position_aux_autre_132, t0.mob_position_remarque AS mob_position_remarque_133, t0.mob_documents AS mob_documents_134, t0.com_moyen AS com_moyen_135, t0.com_envie AS com_envie_136, t0.com_douleur AS com_douleur_137, t0.com_ouinon AS com_ouinon_138, t0.com_pleure AS com_pleure_139, t0.com_langage AS com_langage_140, t0.com_corps AS com_corps_141, t0.com_aide AS com_aide_142, t0.com_aide_type AS com_aide_type_143, t0.com_rem AS com_rem_144, t0.com_vision AS com_vision_145, t0.com_vision_bien AS com_vision_bien_146, t0.com_vision_rem AS com_vision_rem_147, t0.com_vision_seul AS com_vision_seul_148, t0.com_vision_seul_rem AS com_vision_seul_rem_149, t0.com_audio AS com_audio_150, t0.com_audio_bien AS com_audio_bien_151, t0.com_audio_rem AS com_audio_rem_152, t0.com_documents AS com_documents_153, t0.som_dort AS som_dort_154, t0.som_sieste AS som_sieste_155, t0.som_vacances AS som_vacances_156, t0.som_position AS som_position_157, t0.som_besoin AS som_besoin_158, t0.som_besoin_autre AS som_besoin_autre_159, t0.som_rituel AS som_rituel_160, t0.som_reveil AS som_reveil_161, t0.som_cauchemar AS som_cauchemar_162, t0.som_remarque AS som_remarque_163, t0.som_veilleur_changer AS som_veilleur_changer_164, t0.som_veilleur_tournee AS som_veilleur_tournee_165, t0.som_veilleur_partage AS som_veilleur_partage_166, t0.som_veilleur_partage_mixte AS som_veilleur_partage_mixte_167, t0.som_veilleur_remarque AS som_veilleur_remarque_168, t0.int_loisir AS int_loisir_169, t0.int_interesse AS int_interesse_170, t0.int_aime_pas AS int_aime_pas_171, t0.int_interet AS int_interet_172, t0.int_piscine AS int_piscine_173, t0.int_piscine_materiel AS int_piscine_materiel_174, t0.int_equitation AS int_equitation_175, t0.int_altitude AS int_altitude_176, t0.int_telepherique AS int_telepherique_177, t0.int_malade AS int_malade_178, t0.int_soleil AS int_soleil_179, t0.int_foule AS int_foule_180, t0.int_bruit AS int_bruit_181, t0.int_feux AS int_feux_182, t0.int_bateau AS int_bateau_183, t0.int_animaux AS int_animaux_184, t0.int_animaux_val AS int_animaux_val_185, t0.int_poils AS int_poils_186, t0.int_poils_val AS int_poils_val_187, t0.div_attitude_rea AS div_attitude_rea_188, t0.div_covid_vac AS div_covid_vac_189, t0.div_covid_derniere AS div_covid_derniere_190, t0.div_antecedent AS div_antecedent_191, t0.div_documents AS div_documents_192, t0.id AS id_193, t0.created_at AS created_at_194, t0.updated_at AS updated_at_195 FROM carnetsante t0 WHERE t0.id = ?
Parameters: 
[
  163
]
View formatted query    View runnable query    Explain query    View query backtrace
22 0.43 ms 
SELECT t0.archive AS archive_1, t0.telmobile AS telmobile_2, t0.email2 AS email2_3, t0.date_adhesion AS date_adhesion_4, t0.membre_fondation AS membre_fondation_5, t0.diagnostic AS diagnostic_6, t0.remarque AS remarque_7, t0.nom_enfant AS nom_enfant_8, t0.date_naissance_enfant AS date_naissance_enfant_9, t0.email_groupe AS email_groupe_10, t0.type_handicap AS type_handicap_11, t0.diagnostic_enfant AS diagnostic_enfant_12, t0.remarque_enfant AS remarque_enfant_13, t0.titre AS titre_14, t0.nom AS nom_15, t0.prenom AS prenom_16, t0.adresse AS adresse_17, t0.adresse2 AS adresse2_18, t0.npa AS npa_19, t0.ville AS ville_20, t0.email AS email_21, t0.telephone AS telephone_22, t0.journal AS journal_23, t0.ag AS ag_24, t0.categorie AS categorie_25, t0.type_membre AS type_membre_26, t0.datenaissance AS datenaissance_27, t0.date_entree_mbr AS date_entree_mbr_28, t0.datesortie AS datesortie_29, t0.id AS id_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.institution_id AS institution_id_33 FROM membre t0 INNER JOIN parents_enfants ON t0.id = parents_enfants.membre_id WHERE parents_enfants.vacancier_id = ?
Parameters: 
[
  164
]
View formatted query    View runnable query    Explain query    View query backtrace
23 0.96 ms 
SELECT t0.iga_transports AS iga_transports_1, t0.iga_transports_remarque AS iga_transports_remarque_2, t0.iga_harnais AS iga_harnais_3, t0.iga_maladies AS iga_maladies_4, t0.iga_trouble AS iga_trouble_5, t0.iga_trouble_description AS iga_trouble_description_6, t0.iga_habitudes AS iga_habitudes_7, t0.iga_attentif AS iga_attentif_8, t0.iga_documents AS iga_documents_9, t0.epi_acitve AS epi_acitve_10, t0.epi_stable AS epi_stable_11, t0.epi_frequences AS epi_frequences_12, t0.epi_declencheur AS epi_declencheur_13, t0.epi_deroulement AS epi_deroulement_14, t0.epi_medicament_urgence AS epi_medicament_urgence_15, t0.epi_medicament_donner AS epi_medicament_donner_16, t0.epi_attention AS epi_attention_17, t0.epi_remarque AS epi_remarque_18, t0.epi_documents AS epi_documents_19, t0.ali_regime_alimentaire AS ali_regime_alimentaire_20, t0.ali_regime_alimentaire_autre AS ali_regime_alimentaire_autre_21, t0.ali_consistance AS ali_consistance_22, t0.ali_constistance_remarque AS ali_constistance_remarque_23, t0.ali_allergie AS ali_allergie_24, t0.ali_intolerance AS ali_intolerance_25, t0.ali_eviter AS ali_eviter_26, t0.ali_aime AS ali_aime_27, t0.ali_aime_pas AS ali_aime_pas_28, t0.ali_assiette AS ali_assiette_29, t0.ali_assiette_auxiliaire AS ali_assiette_auxiliaire_30, t0.ali_assiette_autre AS ali_assiette_autre_31, t0.ali_assiette_remarque AS ali_assiette_remarque_32, t0.ali_position AS ali_position_33, t0.ali_manger_aide AS ali_manger_aide_34, t0.ali_manger_aide_remarque AS ali_manger_aide_remarque_35, t0.ali_main AS ali_main_36, t0.ali_quantite AS ali_quantite_37, t0.ali_quantite_remarque AS ali_quantite_remarque_38, t0.ali_refus AS ali_refus_39, t0.ali_refus_minutes AS ali_refus_minutes_40, t0.ali_refus_autre AS ali_refus_autre_41, t0.ali_refus_remarque AS ali_refus_remarque_42, t0.ali_resservir AS ali_resservir_43, t0.ali_resservir_autre AS ali_resservir_autre_44, t0.ali_boisson AS ali_boisson_45, t0.ali_boisson_epais AS ali_boisson_epais_46, t0.ali_boisson_autre AS ali_boisson_autre_47, t0.ali_boire_aide AS ali_boire_aide_48, t0.ali_boisson_aime AS ali_boisson_aime_49, t0.ali_boisson_supporte_pas AS ali_boisson_supporte_pas_50, t0.ali_boire_quantite AS ali_boire_quantite_51, t0.ali_boire_astuce AS ali_boire_astuce_52, t0.ali_boisson_alcool AS ali_boisson_alcool_53, t0.ali_boisson_alcool_quantite AS ali_boisson_alcool_quantite_54, t0.ali_boisson_remarque AS ali_boisson_remarque_55, t0.ali_peg_util AS ali_peg_util_56, t0.ali_peg_util_manger AS ali_peg_util_manger_57, t0.ali_peg_util_manger_moins AS ali_peg_util_manger_moins_58, t0.ali_peg_util_manger_autre AS ali_peg_util_manger_autre_59, t0.ali_peg_util_manger_machine AS ali_peg_util_manger_machine_60, t0.ali_peg_util_manger_machine_rem AS ali_peg_util_manger_machine_rem_61, t0.ali_peg_util_boire AS ali_peg_util_boire_62, t0.ali_peg_util_boire_min_normal AS ali_peg_util_boire_min_normal_63, t0.ali_peg_util_boire_min_canicule AS ali_peg_util_boire_min_canicule_64, t0.ali_peg_util_boire_max AS ali_peg_util_boire_max_65, t0.ali_peg_util_boire_max_rem AS ali_peg_util_boire_max_rem_66, t0.ali_peg_util_boire_machine AS ali_peg_util_boire_machine_67, t0.ali_peg_util_boire_machine_rem AS ali_peg_util_boire_machine_rem_68, t0.ali_peg_habitue_fixe AS ali_peg_habitue_fixe_69, t0.ali_peg_habitue_quantite AS ali_peg_habitue_quantite_70, t0.ali_peg_habitue_heure1 AS ali_peg_habitue_heure1_71, t0.ali_peg_habitue_heure2 AS ali_peg_habitue_heure2_72, t0.ali_peg_habitue_heure3 AS ali_peg_habitue_heure3_73, t0.ali_peg_habitue_heure4 AS ali_peg_habitue_heure4_74, t0.ali_peg_habitue_heure5 AS ali_peg_habitue_heure5_75, t0.ali_peg_habitue_quantite1 AS ali_peg_habitue_quantite1_76, t0.ali_peg_habitue_quantite2 AS ali_peg_habitue_quantite2_77, t0.ali_peg_habitue_quantite3 AS ali_peg_habitue_quantite3_78, t0.ali_peg_habitue_quantite4 AS ali_peg_habitue_quantite4_79, t0.ali_peg_habitue_quantite5 AS ali_peg_habitue_quantite5_80, t0.ali_peg_habitue_eau1 AS ali_peg_habitue_eau1_81, t0.ali_peg_habitue_eau2 AS ali_peg_habitue_eau2_82, t0.ali_peg_habitue_eau3 AS ali_peg_habitue_eau3_83, t0.ali_peg_habitue_eau4 AS ali_peg_habitue_eau4_84, t0.ali_peg_habitue_eau5 AS ali_peg_habitue_eau5_85, t0.ali_peg_habitue_rem AS ali_peg_habitue_rem_86, t0.ali_peg_rem_generale AS ali_peg_rem_generale_87, t0.ali_div_medoc_prendre AS ali_div_medoc_prendre_88, t0.ali_div_rem AS ali_div_rem_89, t0.ali_documents AS ali_documents_90, t0.pro_jour AS pro_jour_91, t0.pro_jour_sortie AS pro_jour_sortie_92, t0.pro_nuit AS pro_nuit_93, t0.pro_pipi AS pro_pipi_94, t0.pro_pipi_autre AS pro_pipi_autre_95, t0.pro_caca AS pro_caca_96, t0.pro_caca_autre AS pro_caca_autre_97, t0.pro_precis AS pro_precis_98, t0.pro_precis_heure AS pro_precis_heure_99, t0.pro_precis_duree AS pro_precis_duree_100, t0.pro_demande_wc AS pro_demande_wc_101, t0.pro_demande_wc_rem AS pro_demande_wc_rem_102, t0.pro_rappel_wc AS pro_rappel_wc_103, t0.pro_precis_aide AS pro_precis_aide_104, t0.pro_protection_change AS pro_protection_change_105, t0.pro_constipation AS pro_constipation_106, t0.pro_constipation_val AS pro_constipation_val_107, t0.pro_constipation_protocole AS pro_constipation_protocole_108, t0.pro_remarque AS pro_remarque_109, t0.pro_documents AS pro_documents_110, t0.hyg_douche AS hyg_douche_111, t0.hyg_douche_jours AS hyg_douche_jours_112, t0.hyg_aide AS hyg_aide_113, t0.hyg_aide_seul AS hyg_aide_seul_114, t0.hyg_douche_pos AS hyg_douche_pos_115, t0.hyg_habiller AS hyg_habiller_116, t0.hyg_habiller_rem AS hyg_habiller_rem_117, t0.hyg_attention AS hyg_attention_118, t0.mob_activite AS mob_activite_119, t0.mob_activite_sortie AS mob_activite_sortie_120, t0.mob_activite_autre AS mob_activite_autre_121, t0.mob_transfert AS mob_transfert_122, t0.mob_transfert_autre AS mob_transfert_autre_123, t0.mob_transfert_tige AS mob_transfert_tige_124, t0.mob_transfert_attention AS mob_transfert_attention_125, t0.mob_transfert_remarque AS mob_transfert_remarque_126, t0.mob_position AS mob_position_127, t0.mob_position_confort AS mob_position_confort_128, t0.mob_position_horaire AS mob_position_horaire_129, t0.mob_position_confort_remarque AS mob_position_confort_remarque_130, t0.mob_position_aux AS mob_position_aux_131, t0.mob_position_aux_autre AS mob_position_aux_autre_132, t0.mob_position_remarque AS mob_position_remarque_133, t0.mob_documents AS mob_documents_134, t0.com_moyen AS com_moyen_135, t0.com_envie AS com_envie_136, t0.com_douleur AS com_douleur_137, t0.com_ouinon AS com_ouinon_138, t0.com_pleure AS com_pleure_139, t0.com_langage AS com_langage_140, t0.com_corps AS com_corps_141, t0.com_aide AS com_aide_142, t0.com_aide_type AS com_aide_type_143, t0.com_rem AS com_rem_144, t0.com_vision AS com_vision_145, t0.com_vision_bien AS com_vision_bien_146, t0.com_vision_rem AS com_vision_rem_147, t0.com_vision_seul AS com_vision_seul_148, t0.com_vision_seul_rem AS com_vision_seul_rem_149, t0.com_audio AS com_audio_150, t0.com_audio_bien AS com_audio_bien_151, t0.com_audio_rem AS com_audio_rem_152, t0.com_documents AS com_documents_153, t0.som_dort AS som_dort_154, t0.som_sieste AS som_sieste_155, t0.som_vacances AS som_vacances_156, t0.som_position AS som_position_157, t0.som_besoin AS som_besoin_158, t0.som_besoin_autre AS som_besoin_autre_159, t0.som_rituel AS som_rituel_160, t0.som_reveil AS som_reveil_161, t0.som_cauchemar AS som_cauchemar_162, t0.som_remarque AS som_remarque_163, t0.som_veilleur_changer AS som_veilleur_changer_164, t0.som_veilleur_tournee AS som_veilleur_tournee_165, t0.som_veilleur_partage AS som_veilleur_partage_166, t0.som_veilleur_partage_mixte AS som_veilleur_partage_mixte_167, t0.som_veilleur_remarque AS som_veilleur_remarque_168, t0.int_loisir AS int_loisir_169, t0.int_interesse AS int_interesse_170, t0.int_aime_pas AS int_aime_pas_171, t0.int_interet AS int_interet_172, t0.int_piscine AS int_piscine_173, t0.int_piscine_materiel AS int_piscine_materiel_174, t0.int_equitation AS int_equitation_175, t0.int_altitude AS int_altitude_176, t0.int_telepherique AS int_telepherique_177, t0.int_malade AS int_malade_178, t0.int_soleil AS int_soleil_179, t0.int_foule AS int_foule_180, t0.int_bruit AS int_bruit_181, t0.int_feux AS int_feux_182, t0.int_bateau AS int_bateau_183, t0.int_animaux AS int_animaux_184, t0.int_animaux_val AS int_animaux_val_185, t0.int_poils AS int_poils_186, t0.int_poils_val AS int_poils_val_187, t0.div_attitude_rea AS div_attitude_rea_188, t0.div_covid_vac AS div_covid_vac_189, t0.div_covid_derniere AS div_covid_derniere_190, t0.div_antecedent AS div_antecedent_191, t0.div_documents AS div_documents_192, t0.id AS id_193, t0.created_at AS created_at_194, t0.updated_at AS updated_at_195 FROM carnetsante t0 WHERE t0.id = ?
Parameters: 
[
  164
]
View formatted query    View runnable query    Explain query    View query backtrace
24 0.45 ms 
SELECT t0.archive AS archive_1, t0.telmobile AS telmobile_2, t0.email2 AS email2_3, t0.date_adhesion AS date_adhesion_4, t0.membre_fondation AS membre_fondation_5, t0.diagnostic AS diagnostic_6, t0.remarque AS remarque_7, t0.nom_enfant AS nom_enfant_8, t0.date_naissance_enfant AS date_naissance_enfant_9, t0.email_groupe AS email_groupe_10, t0.type_handicap AS type_handicap_11, t0.diagnostic_enfant AS diagnostic_enfant_12, t0.remarque_enfant AS remarque_enfant_13, t0.titre AS titre_14, t0.nom AS nom_15, t0.prenom AS prenom_16, t0.adresse AS adresse_17, t0.adresse2 AS adresse2_18, t0.npa AS npa_19, t0.ville AS ville_20, t0.email AS email_21, t0.telephone AS telephone_22, t0.journal AS journal_23, t0.ag AS ag_24, t0.categorie AS categorie_25, t0.type_membre AS type_membre_26, t0.datenaissance AS datenaissance_27, t0.date_entree_mbr AS date_entree_mbr_28, t0.datesortie AS datesortie_29, t0.id AS id_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.institution_id AS institution_id_33 FROM membre t0 INNER JOIN parents_enfants ON t0.id = parents_enfants.membre_id WHERE parents_enfants.vacancier_id = ?
Parameters: 
[
  160
]
View formatted query    View runnable query    Explain query    View query backtrace
25 0.94 ms 
SELECT t0.iga_transports AS iga_transports_1, t0.iga_transports_remarque AS iga_transports_remarque_2, t0.iga_harnais AS iga_harnais_3, t0.iga_maladies AS iga_maladies_4, t0.iga_trouble AS iga_trouble_5, t0.iga_trouble_description AS iga_trouble_description_6, t0.iga_habitudes AS iga_habitudes_7, t0.iga_attentif AS iga_attentif_8, t0.iga_documents AS iga_documents_9, t0.epi_acitve AS epi_acitve_10, t0.epi_stable AS epi_stable_11, t0.epi_frequences AS epi_frequences_12, t0.epi_declencheur AS epi_declencheur_13, t0.epi_deroulement AS epi_deroulement_14, t0.epi_medicament_urgence AS epi_medicament_urgence_15, t0.epi_medicament_donner AS epi_medicament_donner_16, t0.epi_attention AS epi_attention_17, t0.epi_remarque AS epi_remarque_18, t0.epi_documents AS epi_documents_19, t0.ali_regime_alimentaire AS ali_regime_alimentaire_20, t0.ali_regime_alimentaire_autre AS ali_regime_alimentaire_autre_21, t0.ali_consistance AS ali_consistance_22, t0.ali_constistance_remarque AS ali_constistance_remarque_23, t0.ali_allergie AS ali_allergie_24, t0.ali_intolerance AS ali_intolerance_25, t0.ali_eviter AS ali_eviter_26, t0.ali_aime AS ali_aime_27, t0.ali_aime_pas AS ali_aime_pas_28, t0.ali_assiette AS ali_assiette_29, t0.ali_assiette_auxiliaire AS ali_assiette_auxiliaire_30, t0.ali_assiette_autre AS ali_assiette_autre_31, t0.ali_assiette_remarque AS ali_assiette_remarque_32, t0.ali_position AS ali_position_33, t0.ali_manger_aide AS ali_manger_aide_34, t0.ali_manger_aide_remarque AS ali_manger_aide_remarque_35, t0.ali_main AS ali_main_36, t0.ali_quantite AS ali_quantite_37, t0.ali_quantite_remarque AS ali_quantite_remarque_38, t0.ali_refus AS ali_refus_39, t0.ali_refus_minutes AS ali_refus_minutes_40, t0.ali_refus_autre AS ali_refus_autre_41, t0.ali_refus_remarque AS ali_refus_remarque_42, t0.ali_resservir AS ali_resservir_43, t0.ali_resservir_autre AS ali_resservir_autre_44, t0.ali_boisson AS ali_boisson_45, t0.ali_boisson_epais AS ali_boisson_epais_46, t0.ali_boisson_autre AS ali_boisson_autre_47, t0.ali_boire_aide AS ali_boire_aide_48, t0.ali_boisson_aime AS ali_boisson_aime_49, t0.ali_boisson_supporte_pas AS ali_boisson_supporte_pas_50, t0.ali_boire_quantite AS ali_boire_quantite_51, t0.ali_boire_astuce AS ali_boire_astuce_52, t0.ali_boisson_alcool AS ali_boisson_alcool_53, t0.ali_boisson_alcool_quantite AS ali_boisson_alcool_quantite_54, t0.ali_boisson_remarque AS ali_boisson_remarque_55, t0.ali_peg_util AS ali_peg_util_56, t0.ali_peg_util_manger AS ali_peg_util_manger_57, t0.ali_peg_util_manger_moins AS ali_peg_util_manger_moins_58, t0.ali_peg_util_manger_autre AS ali_peg_util_manger_autre_59, t0.ali_peg_util_manger_machine AS ali_peg_util_manger_machine_60, t0.ali_peg_util_manger_machine_rem AS ali_peg_util_manger_machine_rem_61, t0.ali_peg_util_boire AS ali_peg_util_boire_62, t0.ali_peg_util_boire_min_normal AS ali_peg_util_boire_min_normal_63, t0.ali_peg_util_boire_min_canicule AS ali_peg_util_boire_min_canicule_64, t0.ali_peg_util_boire_max AS ali_peg_util_boire_max_65, t0.ali_peg_util_boire_max_rem AS ali_peg_util_boire_max_rem_66, t0.ali_peg_util_boire_machine AS ali_peg_util_boire_machine_67, t0.ali_peg_util_boire_machine_rem AS ali_peg_util_boire_machine_rem_68, t0.ali_peg_habitue_fixe AS ali_peg_habitue_fixe_69, t0.ali_peg_habitue_quantite AS ali_peg_habitue_quantite_70, t0.ali_peg_habitue_heure1 AS ali_peg_habitue_heure1_71, t0.ali_peg_habitue_heure2 AS ali_peg_habitue_heure2_72, t0.ali_peg_habitue_heure3 AS ali_peg_habitue_heure3_73, t0.ali_peg_habitue_heure4 AS ali_peg_habitue_heure4_74, t0.ali_peg_habitue_heure5 AS ali_peg_habitue_heure5_75, t0.ali_peg_habitue_quantite1 AS ali_peg_habitue_quantite1_76, t0.ali_peg_habitue_quantite2 AS ali_peg_habitue_quantite2_77, t0.ali_peg_habitue_quantite3 AS ali_peg_habitue_quantite3_78, t0.ali_peg_habitue_quantite4 AS ali_peg_habitue_quantite4_79, t0.ali_peg_habitue_quantite5 AS ali_peg_habitue_quantite5_80, t0.ali_peg_habitue_eau1 AS ali_peg_habitue_eau1_81, t0.ali_peg_habitue_eau2 AS ali_peg_habitue_eau2_82, t0.ali_peg_habitue_eau3 AS ali_peg_habitue_eau3_83, t0.ali_peg_habitue_eau4 AS ali_peg_habitue_eau4_84, t0.ali_peg_habitue_eau5 AS ali_peg_habitue_eau5_85, t0.ali_peg_habitue_rem AS ali_peg_habitue_rem_86, t0.ali_peg_rem_generale AS ali_peg_rem_generale_87, t0.ali_div_medoc_prendre AS ali_div_medoc_prendre_88, t0.ali_div_rem AS ali_div_rem_89, t0.ali_documents AS ali_documents_90, t0.pro_jour AS pro_jour_91, t0.pro_jour_sortie AS pro_jour_sortie_92, t0.pro_nuit AS pro_nuit_93, t0.pro_pipi AS pro_pipi_94, t0.pro_pipi_autre AS pro_pipi_autre_95, t0.pro_caca AS pro_caca_96, t0.pro_caca_autre AS pro_caca_autre_97, t0.pro_precis AS pro_precis_98, t0.pro_precis_heure AS pro_precis_heure_99, t0.pro_precis_duree AS pro_precis_duree_100, t0.pro_demande_wc AS pro_demande_wc_101, t0.pro_demande_wc_rem AS pro_demande_wc_rem_102, t0.pro_rappel_wc AS pro_rappel_wc_103, t0.pro_precis_aide AS pro_precis_aide_104, t0.pro_protection_change AS pro_protection_change_105, t0.pro_constipation AS pro_constipation_106, t0.pro_constipation_val AS pro_constipation_val_107, t0.pro_constipation_protocole AS pro_constipation_protocole_108, t0.pro_remarque AS pro_remarque_109, t0.pro_documents AS pro_documents_110, t0.hyg_douche AS hyg_douche_111, t0.hyg_douche_jours AS hyg_douche_jours_112, t0.hyg_aide AS hyg_aide_113, t0.hyg_aide_seul AS hyg_aide_seul_114, t0.hyg_douche_pos AS hyg_douche_pos_115, t0.hyg_habiller AS hyg_habiller_116, t0.hyg_habiller_rem AS hyg_habiller_rem_117, t0.hyg_attention AS hyg_attention_118, t0.mob_activite AS mob_activite_119, t0.mob_activite_sortie AS mob_activite_sortie_120, t0.mob_activite_autre AS mob_activite_autre_121, t0.mob_transfert AS mob_transfert_122, t0.mob_transfert_autre AS mob_transfert_autre_123, t0.mob_transfert_tige AS mob_transfert_tige_124, t0.mob_transfert_attention AS mob_transfert_attention_125, t0.mob_transfert_remarque AS mob_transfert_remarque_126, t0.mob_position AS mob_position_127, t0.mob_position_confort AS mob_position_confort_128, t0.mob_position_horaire AS mob_position_horaire_129, t0.mob_position_confort_remarque AS mob_position_confort_remarque_130, t0.mob_position_aux AS mob_position_aux_131, t0.mob_position_aux_autre AS mob_position_aux_autre_132, t0.mob_position_remarque AS mob_position_remarque_133, t0.mob_documents AS mob_documents_134, t0.com_moyen AS com_moyen_135, t0.com_envie AS com_envie_136, t0.com_douleur AS com_douleur_137, t0.com_ouinon AS com_ouinon_138, t0.com_pleure AS com_pleure_139, t0.com_langage AS com_langage_140, t0.com_corps AS com_corps_141, t0.com_aide AS com_aide_142, t0.com_aide_type AS com_aide_type_143, t0.com_rem AS com_rem_144, t0.com_vision AS com_vision_145, t0.com_vision_bien AS com_vision_bien_146, t0.com_vision_rem AS com_vision_rem_147, t0.com_vision_seul AS com_vision_seul_148, t0.com_vision_seul_rem AS com_vision_seul_rem_149, t0.com_audio AS com_audio_150, t0.com_audio_bien AS com_audio_bien_151, t0.com_audio_rem AS com_audio_rem_152, t0.com_documents AS com_documents_153, t0.som_dort AS som_dort_154, t0.som_sieste AS som_sieste_155, t0.som_vacances AS som_vacances_156, t0.som_position AS som_position_157, t0.som_besoin AS som_besoin_158, t0.som_besoin_autre AS som_besoin_autre_159, t0.som_rituel AS som_rituel_160, t0.som_reveil AS som_reveil_161, t0.som_cauchemar AS som_cauchemar_162, t0.som_remarque AS som_remarque_163, t0.som_veilleur_changer AS som_veilleur_changer_164, t0.som_veilleur_tournee AS som_veilleur_tournee_165, t0.som_veilleur_partage AS som_veilleur_partage_166, t0.som_veilleur_partage_mixte AS som_veilleur_partage_mixte_167, t0.som_veilleur_remarque AS som_veilleur_remarque_168, t0.int_loisir AS int_loisir_169, t0.int_interesse AS int_interesse_170, t0.int_aime_pas AS int_aime_pas_171, t0.int_interet AS int_interet_172, t0.int_piscine AS int_piscine_173, t0.int_piscine_materiel AS int_piscine_materiel_174, t0.int_equitation AS int_equitation_175, t0.int_altitude AS int_altitude_176, t0.int_telepherique AS int_telepherique_177, t0.int_malade AS int_malade_178, t0.int_soleil AS int_soleil_179, t0.int_foule AS int_foule_180, t0.int_bruit AS int_bruit_181, t0.int_feux AS int_feux_182, t0.int_bateau AS int_bateau_183, t0.int_animaux AS int_animaux_184, t0.int_animaux_val AS int_animaux_val_185, t0.int_poils AS int_poils_186, t0.int_poils_val AS int_poils_val_187, t0.div_attitude_rea AS div_attitude_rea_188, t0.div_covid_vac AS div_covid_vac_189, t0.div_covid_derniere AS div_covid_derniere_190, t0.div_antecedent AS div_antecedent_191, t0.div_documents AS div_documents_192, t0.id AS id_193, t0.created_at AS created_at_194, t0.updated_at AS updated_at_195 FROM carnetsante t0 WHERE t0.id = ?
Parameters: 
[
  160
]
View formatted query    View runnable query    Explain query    View query backtrace

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Inscription 29
App\Entity\Camp 11
App\Entity\LieuxCamp 4
App\Entity\Vacancier 4
App\Entity\CarnetSante 4
App\Entity\TypeCamp 3
App\Entity\TypeInscription 3
App\Entity\User 2

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Camp No errors.
App\Entity\TypeCamp No errors.
App\Entity\LieuxCamp No errors.
App\Entity\Commentary No errors.
App\Entity\TypeInscription No errors.
App\Entity\Inscription No errors.
App\Entity\Vacancier No errors.
App\Entity\CarnetSante No errors.
App\Entity\Psa No errors.
App\Entity\Institution No errors.
App\Entity\Membre No errors.