Query Metrics
17
Database Queries
4
Different statements
8.42 ms
Query time
0
Invalid entities
56
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.78 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
]
|
||||||||||||||||||||||||||||||||
| 2 | 1.88 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, c0_.typecamp_id AS typecamp_id_45, c0_.lieuxcamp_id AS lieuxcamp_id_46, c0_.commentary_id AS commentary_id_47, t1_.typeinscription_id AS typeinscription_id_48 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 WHERE c0_.archive <> ? AND c0_.date_debut >= ? AND c0_.date_debut <= ?
Parameters:
[ 2 "2026-01-01 00:00:00" "2026-12-31 23:59:59" ]
|
||||||||||||||||||||||||||||||||
| 3 | 0.59 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
]
|
||||||||||||||||||||||||||||||||
| 4 | 0.45 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
]
|
||||||||||||||||||||||||||||||||
| 5 | 0.43 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
]
|
||||||||||||||||||||||||||||||||
| 6 | 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:
[
217
]
|
||||||||||||||||||||||||||||||||
| 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:
[
218
]
|
||||||||||||||||||||||||||||||||
| 8 | 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:
[
219
]
|
||||||||||||||||||||||||||||||||
| 9 | 0.43 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
]
|
||||||||||||||||||||||||||||||||
| 10 | 0.38 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
]
|
||||||||||||||||||||||||||||||||
| 11 | 0.38 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
]
|
||||||||||||||||||||||||||||||||
| 12 | 0.38 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
]
|
||||||||||||||||||||||||||||||||
| 13 | 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:
[
224
]
|
||||||||||||||||||||||||||||||||
| 14 | 0.52 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:
[
376
]
|
||||||||||||||||||||||||||||||||
| 15 | 0.31 ms |
SELECT t0.nom AS nom_1, t0.description AS description_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM typeinscription t0 WHERE t0.id = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||||
| 16 | 0.24 ms |
SELECT t0.nom AS nom_1, t0.description AS description_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM typeinscription t0 WHERE t0.id = ?
Parameters:
[
2
]
|
||||||||||||||||||||||||||||||||
| 17 | 0.19 ms |
SELECT t0.nom AS nom_1, t0.description AS description_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM typeinscription t0 WHERE t0.id = ?
Parameters:
[
3
]
|
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\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. |