GET https://demo.appanaia.com/keep-alive

Query Metrics

4 Database Queries
4 Different statements
1.57 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
0.80 ms
(51.14%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.last_email_verification_send AS last_email_verification_send_5, t0.organization_id AS organization_id_6, t7.id AS id_8, t7.company_name AS company_name_9, t7.website AS website_10, t7.address AS address_11, t7.phone AS phone_12, t7.contact_email AS contact_email_13, t7.opening_hours AS opening_hours_14, t7.siret AS siret_15, t7.ape_naf AS ape_naf_16, t7.declaration_number AS declaration_number_17, t7.region AS region_18, t7.tva AS tva_19, t7.manager_lastname AS manager_lastname_20, t7.manager_firstname AS manager_firstname_21, t7.logo_path AS logo_path_22, t7.thumbnail_path AS thumbnail_path_23, t7.stamp_path AS stamp_path_24, t7.signature_path AS signature_path_25, t7.qualiopi_certified AS qualiopi_certified_26, t7.certificate_number AS certificate_number_27, t7.visibility AS visibility_28, t7.completed_after_registration AS completed_after_registration_29, t7.enabled AS enabled_30, t7.stripe_id AS stripe_id_31, t7.verified AS verified_32, t7.created_at AS created_at_33, t7.trial_days AS trial_days_34, t7.subscription_email AS subscription_email_35, t7.notif_sent AS notif_sent_36, t7.actions_nature AS actions_nature_37, t7.activate_qualiopi_mention AS activate_qualiopi_mention_38, t7.qualiopi_certificate_path AS qualiopi_certificate_path_39, t0.former_id AS former_id_40, t41.id AS id_42, t41.firstname AS firstname_43, t41.lastname AS lastname_44, t41.email AS email_45, t41.phone AS phone_46, t41.main_activity AS main_activity_47, t41.title AS title_48, t41.quality AS quality_49, t41.business_activity AS business_activity_50, t41.professionnal_career AS professionnal_career_51, t41.formation AS formation_52, t41.continuous_formation AS continuous_formation_53, t41.cv_path AS cv_path_54, t41.signature_path AS signature_path_55, t41.diploma_path AS diploma_path_56, t41.status AS status_57, t41.organization_id AS organization_id_58 FROM user t0 LEFT JOIN organization t7 ON t0.organization_id = t7.id LEFT JOIN former t41 ON t0.former_id = t41.id WHERE t0.id = ?
Parameters:
[
  1
]
0.39 ms
(24.97%)
1
SELECT t0.id AS id_1, t0.date_last_update AS date_last_update_2, t0.bases AS bases_3, t0.infos_given_to_intern AS infos_given_to_intern_4, t0.infos_required_from_intern AS infos_required_from_intern_5, t0.health AS health_6, t0.health_general_principles AS health_general_principles_7, t0.health_fire_instructions AS health_fire_instructions_8, t0.health_alcohol AS health_alcohol_9, t0.health_smoke AS health_smoke_10, t0.health_animals AS health_animals_11, t0.health_accident AS health_accident_12, t0.general_discipline_follow_up AS general_discipline_follow_up_13, t0.general_discipline_attendance AS general_discipline_attendance_14, t0.general_discipline_offices_access AS general_discipline_offices_access_15, t0.general_discipline_dress AS general_discipline_dress_16, t0.general_discipline_behaviour AS general_discipline_behaviour_17, t0.general_discipline_use_equipment AS general_discipline_use_equipment_18, t0.general_discipline_participation AS general_discipline_participation_19, t0.general_discipline_copyright AS general_discipline_copyright_20, t0.discipline_penalties AS discipline_penalties_21, t0.representation_interns AS representation_interns_22, t0.publication_internal_rules AS publication_internal_rules_23, t0.complaints_procedure AS complaints_procedure_24, t0.file_path AS file_path_25, t0.organization_id AS organization_id_26 FROM internal_rules t0 WHERE t0.organization_id = ?
Parameters:
[
  1
]
0.21 ms
(13.47%)
1
SELECT t0.id AS id_1, t0.date_last_update AS date_last_update_2, t0.context AS context_3, t0.definition AS definition_4, t0.commitment AS commitment_5, t0.identifying_needs AS identifying_needs_6, t0.adaptations AS adaptations_7, t0.accessibility AS accessibility_8, t0.awareness AS awareness_9, t0.referent AS referent_10, t0.network_partners AS network_partners_11, t0.file_path AS file_path_12, t0.organization_id AS organization_id_13 FROM handicap_policy t0 WHERE t0.organization_id = ?
Parameters:
[
  1
]
0.16 ms
(10.41%)
1
SELECT t0.id AS id_1, t0.enabled AS enabled_2, t0.slug AS slug_3, t0.organization_id AS organization_id_4 FROM website t0 WHERE t0.organization_id = ?
Parameters:
[
  1
]

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\User No errors.
App\Entity\Organization No errors.
App\Entity\Former No errors.
App\Entity\Ticket No errors.
App\Entity\Message No errors.
App\Entity\Formation No errors.
App\Entity\Convention No errors.
App\Entity\Intern No errors.
App\Entity\FormationSession No errors.
App\Entity\FormationEntry
  • The mappings App\Entity\FormationEntry#internList and App\Entity\Intern#formationEntries are inconsistent with each other.
  • If association App\Entity\FormationEntry#internList is many-to-many, then the inversed side App\Entity\Intern#formationEntries has to be many-to-many as well.
App\Entity\FormationLeaving No errors.
App\Entity\SatisfactionForm No errors.
App\Entity\EvaluationModel No errors.
App\Entity\Attendance No errors.
App\Entity\Emargement No errors.
App\Entity\Subscription No errors.
App\Entity\InternalRules No errors.
App\Entity\HandicapPolicy No errors.
App\Entity\Website No errors.
App\Entity\Report No errors.