Query Metrics
29
Database Queries
5
Different statements
16.03 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
11.39 ms (71.05%) |
23 |
SELECT t0.id AS id_1, t0.nom_site AS nom_site_2, t0.url AS url_3, t0.nom_logo AS nom_logo_4, t0.date_maj_logo AS date_maj_logo_5, t0.description AS description_6, t0.conditions_generales_services AS conditions_generales_services_7, t0.nom_img_description AS nom_img_description_8, t0.date_maj_description AS date_maj_description_9, t0.nom_structure AS nom_structure_10, t0.mail_reception_automatique AS mail_reception_automatique_11, t0.a_prix_commune AS a_prix_commune_12, t0.prix_par_quotients AS prix_par_quotients_13, t0.url_facebook AS url_facebook_14, t0.url_instagram AS url_instagram_15, t0.url_twitter AS url_twitter_16, t0.url_google_plus AS url_google_plus_17, t0.utilise_hebergements AS utilise_hebergements_18, t0.type_activite AS type_activite_19, t0.validation_reservation_par_defaut AS validation_reservation_par_defaut_20, t0.a_delai_blocage_reservation AS a_delai_blocage_reservation_21, t0.nbre_unites_temps_blocage_reservation AS nbre_unites_temps_blocage_reservation_22, t0.validation_annulation_par_defaut AS validation_annulation_par_defaut_23, t0.a_delai_blocage_annulation AS a_delai_blocage_annulation_24, t0.nbre_unites_temps_blocage_annulation AS nbre_unites_temps_blocage_annulation_25, t0.nbre_unites_temps_validite_avoir AS nbre_unites_temps_validite_avoir_26, t0.nom_responsable AS nom_responsable_27, t0.code_siren AS code_siren_28, t0.forme_juridique AS forme_juridique_29, t0.date_immatriculation AS date_immatriculation_30, t0.code_apenaf AS code_apenaf_31, t0.num_tva AS num_tva_32, t0.fonction_responsable AS fonction_responsable_33, t0.nom_directeur AS nom_directeur_34, t0.unite_presence_accueil AS unite_presence_accueil_35, t0.auto_increment_facture AS auto_increment_facture_36, t0.auto_increment_avoir AS auto_increment_avoir_37, t0.tva_applicable AS tva_applicable_38, t0.cle_publique_mailjet AS cle_publique_mailjet_39, t0.cle_secrete_mailjet AS cle_secrete_mailjet_40, t0.mail_envoi_mailjet AS mail_envoi_mailjet_41, t0.id_template_campagne AS id_template_campagne_42, t0.taux_tva AS taux_tva_43, t0.auto_increment_avoirs AS auto_increment_avoirs_44, t0.liste_attente AS liste_attente_45, t0.nbre_unites_temps_liste_attente AS nbre_unites_temps_liste_attente_46, t0.id_site_noyau AS id_site_noyau_47, t0.asso_token_api_basicompta AS asso_token_api_basicompta_48, t0.token_api_basicompta AS token_api_basicompta_49, t0.token_basicompta AS token_basicompta_50, t0.created_interco_basicompta AS created_interco_basicompta_51, t0.comptabilisation_heures_presence AS comptabilisation_heures_presence_52, t0.forfait_demi_journee AS forfait_demi_journee_53, t0.forfait_journee AS forfait_journee_54, t0.autorisation_paiements_plusieurs_fois AS autorisation_paiements_plusieurs_fois_55, t0.nbre_max_paiements_plusieurs_fois AS nbre_max_paiements_plusieurs_fois_56, t0.montant_minimum_paiements_plusieurs_fois AS montant_minimum_paiements_plusieurs_fois_57, t0.pourcentage_montant_initial_paiement_plusieurs_fois AS pourcentage_montant_initial_paiement_plusieurs_fois_58, t0.date_rapatriement_basicompta AS date_rapatriement_basicompta_59, t0.type_delai_blocage_accueil AS type_delai_blocage_accueil_60, t0.desactivation_qf AS desactivation_qf_61, t0.nom_tampon AS nom_tampon_62, t0.fonction_directeur AS fonction_directeur_63, t0.inscription_adultes AS inscription_adultes_64, t0.unite_presence_sejour AS unite_presence_sejour_65, t0.adhesions AS adhesions_66, t0.coordonnee_id AS coordonnee_id_67, t0.commune_rabais_id AS commune_rabais_id_68, t0.unite_temps_blocage_reservation_id AS unite_temps_blocage_reservation_id_69, t0.unite_temps_blocage_annulation_id AS unite_temps_blocage_annulation_id_70, t0.unite_temps_validite_avoir_id AS unite_temps_validite_avoir_id_71, t0.unite_temps_liste_attente_id AS unite_temps_liste_attente_id_72 FROM variables t0
Parameters:
[] |
|
1.96 ms (12.26%) |
2 |
SELECT DISTINCT c0_.id AS id_0, c0_.nom_categorie AS nom_categorie_1, c0_.description AS description_2, c0_.nom_image AS nom_image_3, c0_.updated_at AS updated_at_4, c0_.parent_categorie_id AS parent_categorie_id_5 FROM categorie c0_ INNER JOIN sejour s1_ ON c0_.id = s1_.categorie_id WHERE s1_.statut = ? AND s1_.date_fin >= CURRENT_DATE ORDER BY c0_.nom_categorie ASC
Parameters:
[
"publie"
]
|
|
1.09 ms (6.80%) |
2 |
SELECT t0.id AS id_1, t0.nom_site AS nom_site_2, t0.url AS url_3, t0.nom_logo AS nom_logo_4, t0.date_maj_logo AS date_maj_logo_5, t0.description AS description_6, t0.conditions_generales_services AS conditions_generales_services_7, t0.nom_img_description AS nom_img_description_8, t0.date_maj_description AS date_maj_description_9, t0.nom_structure AS nom_structure_10, t0.mail_reception_automatique AS mail_reception_automatique_11, t0.a_prix_commune AS a_prix_commune_12, t0.prix_par_quotients AS prix_par_quotients_13, t0.url_facebook AS url_facebook_14, t0.url_instagram AS url_instagram_15, t0.url_twitter AS url_twitter_16, t0.url_google_plus AS url_google_plus_17, t0.utilise_hebergements AS utilise_hebergements_18, t0.type_activite AS type_activite_19, t0.validation_reservation_par_defaut AS validation_reservation_par_defaut_20, t0.a_delai_blocage_reservation AS a_delai_blocage_reservation_21, t0.nbre_unites_temps_blocage_reservation AS nbre_unites_temps_blocage_reservation_22, t0.validation_annulation_par_defaut AS validation_annulation_par_defaut_23, t0.a_delai_blocage_annulation AS a_delai_blocage_annulation_24, t0.nbre_unites_temps_blocage_annulation AS nbre_unites_temps_blocage_annulation_25, t0.nbre_unites_temps_validite_avoir AS nbre_unites_temps_validite_avoir_26, t0.nom_responsable AS nom_responsable_27, t0.code_siren AS code_siren_28, t0.forme_juridique AS forme_juridique_29, t0.date_immatriculation AS date_immatriculation_30, t0.code_apenaf AS code_apenaf_31, t0.num_tva AS num_tva_32, t0.fonction_responsable AS fonction_responsable_33, t0.nom_directeur AS nom_directeur_34, t0.unite_presence_accueil AS unite_presence_accueil_35, t0.auto_increment_facture AS auto_increment_facture_36, t0.auto_increment_avoir AS auto_increment_avoir_37, t0.tva_applicable AS tva_applicable_38, t0.cle_publique_mailjet AS cle_publique_mailjet_39, t0.cle_secrete_mailjet AS cle_secrete_mailjet_40, t0.mail_envoi_mailjet AS mail_envoi_mailjet_41, t0.id_template_campagne AS id_template_campagne_42, t0.taux_tva AS taux_tva_43, t0.auto_increment_avoirs AS auto_increment_avoirs_44, t0.liste_attente AS liste_attente_45, t0.nbre_unites_temps_liste_attente AS nbre_unites_temps_liste_attente_46, t0.id_site_noyau AS id_site_noyau_47, t0.asso_token_api_basicompta AS asso_token_api_basicompta_48, t0.token_api_basicompta AS token_api_basicompta_49, t0.token_basicompta AS token_basicompta_50, t0.created_interco_basicompta AS created_interco_basicompta_51, t0.comptabilisation_heures_presence AS comptabilisation_heures_presence_52, t0.forfait_demi_journee AS forfait_demi_journee_53, t0.forfait_journee AS forfait_journee_54, t0.autorisation_paiements_plusieurs_fois AS autorisation_paiements_plusieurs_fois_55, t0.nbre_max_paiements_plusieurs_fois AS nbre_max_paiements_plusieurs_fois_56, t0.montant_minimum_paiements_plusieurs_fois AS montant_minimum_paiements_plusieurs_fois_57, t0.pourcentage_montant_initial_paiement_plusieurs_fois AS pourcentage_montant_initial_paiement_plusieurs_fois_58, t0.date_rapatriement_basicompta AS date_rapatriement_basicompta_59, t0.type_delai_blocage_accueil AS type_delai_blocage_accueil_60, t0.desactivation_qf AS desactivation_qf_61, t0.nom_tampon AS nom_tampon_62, t0.fonction_directeur AS fonction_directeur_63, t0.inscription_adultes AS inscription_adultes_64, t0.unite_presence_sejour AS unite_presence_sejour_65, t0.adhesions AS adhesions_66, t0.coordonnee_id AS coordonnee_id_67, t0.commune_rabais_id AS commune_rabais_id_68, t0.unite_temps_blocage_reservation_id AS unite_temps_blocage_reservation_id_69, t0.unite_temps_blocage_annulation_id AS unite_temps_blocage_annulation_id_70, t0.unite_temps_validite_avoir_id AS unite_temps_validite_avoir_id_71, t0.unite_temps_liste_attente_id AS unite_temps_liste_attente_id_72 FROM variables t0 WHERE t0.nom_img_description = ? LIMIT 1
Parameters:
[
"adobestock-184924497-623480185bed5756403784.png"
]
|
|
0.79 ms (4.96%) |
1 |
SELECT s0_.id AS id_0, s0_.nom_sejour AS nom_sejour_1, s0_.age_min AS age_min_2, s0_.age_max AS age_max_3, s0_.date_debut AS date_debut_4, s0_.date_fin AS date_fin_5, s0_.description AS description_6, s0_.nbplace AS nbplace_7, s0_.montant_acompte AS montant_acompte_8, s0_.hebergement AS hebergement_9, s0_.justificatif_suplementaire AS justificatif_suplementaire_10, s0_.nom_image_principale AS nom_image_principale_11, s0_.updated_at AS updated_at_12, s0_.type_activite AS type_activite_13, s0_.nb_places_prises AS nb_places_prises_14, s0_.date_delai_reservation AS date_delai_reservation_15, s0_.date_delai_annulation AS date_delai_annulation_16, s0_.statut AS statut_17, s0_.total_liste_attente AS total_liste_attente_18, s0_.recurrence AS recurrence_19, s0_.type_recurrence AS type_recurrence_20, s0_.numero_declaration_sdjes AS numero_declaration_sdjes_21, s0_.desactivation_fiche_sanitaire AS desactivation_fiche_sanitaire_22, s0_.categorie_id AS categorie_id_23, s0_.coordonnees_id AS coordonnees_id_24, s0_.semaine_recurrence_id AS semaine_recurrence_id_25 FROM sejour s0_ WHERE s0_.date_fin >= CURRENT_DATE AND s0_.statut = 'publie' ORDER BY s0_.date_debut ASC
Parameters:
[] |
|
0.79 ms (4.93%) |
1 |
SELECT s0_.id AS id_0, s0_.nom_sejour AS nom_sejour_1, s0_.age_min AS age_min_2, s0_.age_max AS age_max_3, s0_.date_debut AS date_debut_4, s0_.date_fin AS date_fin_5, s0_.description AS description_6, s0_.nbplace AS nbplace_7, s0_.montant_acompte AS montant_acompte_8, s0_.hebergement AS hebergement_9, s0_.justificatif_suplementaire AS justificatif_suplementaire_10, s0_.nom_image_principale AS nom_image_principale_11, s0_.updated_at AS updated_at_12, s0_.type_activite AS type_activite_13, s0_.nb_places_prises AS nb_places_prises_14, s0_.date_delai_reservation AS date_delai_reservation_15, s0_.date_delai_annulation AS date_delai_annulation_16, s0_.statut AS statut_17, s0_.total_liste_attente AS total_liste_attente_18, s0_.recurrence AS recurrence_19, s0_.type_recurrence AS type_recurrence_20, s0_.numero_declaration_sdjes AS numero_declaration_sdjes_21, s0_.desactivation_fiche_sanitaire AS desactivation_fiche_sanitaire_22, s0_.categorie_id AS categorie_id_23, s0_.coordonnees_id AS coordonnees_id_24, s0_.semaine_recurrence_id AS semaine_recurrence_id_25 FROM sejour s0_ GROUP BY s0_.categorie_id
Parameters:
[] |
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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Variables | No errors. |
| App\Entity\Coordonnees | No errors. |
| App\Entity\UniteTemps | No errors. |
| App\Entity\QuotientFamilial | No errors. |
| App\Entity\Commune | No errors. |
| App\Entity\Categorie | No errors. |
| App\Entity\Sejour | No errors. |
| App\Entity\Semaine | No errors. |
| App\Entity\InfoHebergement | No errors. |
| App\Entity\TypeJustificatif | No errors. |
| App\Entity\Image | No errors. |
| App\Entity\Tarif | No errors. |
| App\Entity\Reservation | No errors. |
| App\Entity\CreneauActivite | No errors. |
| App\Entity\RegleReduction | No errors. |
| App\Entity\Champ | No errors. |
| App\Entity\Animateur | No errors. |
| App\Entity\Adhesion | No errors. |