GET https://demo.appanaia.com/formateurs/2?page=1

Query Metrics

8 Database Queries
8 Different statements
9.69 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
8.17 ms
(84.28%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.file_path AS file_path_3, t0.intern_id AS intern_id_4, t0.former_id AS former_id_5, t0.formation_id AS formation_id_6, t0.ticket_id AS ticket_id_7 FROM document t0 WHERE t0.former_id = ?
Parameters:
[
  2
]
0.37 ms
(3.87%)
1
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.email AS email_4, t0.phone AS phone_5, t0.main_activity AS main_activity_6, t0.title AS title_7, t0.quality AS quality_8, t0.business_activity AS business_activity_9, t0.professionnal_career AS professionnal_career_10, t0.formation AS formation_11, t0.continuous_formation AS continuous_formation_12, t0.cv_path AS cv_path_13, t0.signature_path AS signature_path_14, t0.diploma_path AS diploma_path_15, t0.status AS status_16, t0.organization_id AS organization_id_17, t18.id AS id_19, t18.email AS email_20, t18.roles AS roles_21, t18.password AS password_22, t18.last_email_verification_send AS last_email_verification_send_23, t18.organization_id AS organization_id_24, t18.former_id AS former_id_25 FROM former t0 LEFT JOIN user t18 ON t18.former_id = t0.id WHERE t0.id = ?
Parameters:
[
  "2"
]
0.30 ms
(3.12%)
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.24 ms
(2.45%)
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.20 ms
(2.01%)
1
SELECT t0.id AS id_1, t0.picture_path AS picture_path_2, t0.name AS name_3, t0.description AS description_4, t0.hour_duration AS hour_duration_5, t0.day_duration AS day_duration_6, t0.place AS place_7, t0.intern_profile AS intern_profile_8, t0.requirements AS requirements_9, t0.pre_tax_price AS pre_tax_price_10, t0.including_tax_price AS including_tax_price_11, t0.tva AS tva_12, t0.general_goals AS general_goals_13, t0.training_goals AS training_goals_14, t0.content AS content_15, t0.access_terms AS access_terms_16, t0.learning_resources AS learning_resources_17, t0.technical_resources AS technical_resources_18, t0.handicapped_access AS handicapped_access_19, t0.organization_terms AS organization_terms_20, t0.full_learning_resources AS full_learning_resources_21, t0.tracking AS tracking_22, t0.evaluation_system AS evaluation_system_23, t0.summary AS summary_24, t0.document_version AS document_version_25, t0.date AS date_26, t0.program_path AS program_path_27, t0.color AS color_28, t0.certification AS certification_29, t0.infos_certification AS infos_certification_30, t0.on_quote AS on_quote_31, t0.former_id AS former_id_32, t0.organization_id AS organization_id_33, t34.id AS id_35, t34.company_name AS company_name_36, t34.website AS website_37, t34.address AS address_38, t34.phone AS phone_39, t34.contact_email AS contact_email_40, t34.opening_hours AS opening_hours_41, t34.siret AS siret_42, t34.ape_naf AS ape_naf_43, t34.declaration_number AS declaration_number_44, t34.region AS region_45, t34.tva AS tva_46, t34.manager_lastname AS manager_lastname_47, t34.manager_firstname AS manager_firstname_48, t34.logo_path AS logo_path_49, t34.thumbnail_path AS thumbnail_path_50, t34.stamp_path AS stamp_path_51, t34.signature_path AS signature_path_52, t34.qualiopi_certified AS qualiopi_certified_53, t34.certificate_number AS certificate_number_54, t34.visibility AS visibility_55, t34.completed_after_registration AS completed_after_registration_56, t34.enabled AS enabled_57, t34.stripe_id AS stripe_id_58, t34.verified AS verified_59, t34.created_at AS created_at_60, t34.trial_days AS trial_days_61, t34.subscription_email AS subscription_email_62, t34.notif_sent AS notif_sent_63, t34.actions_nature AS actions_nature_64, t34.activate_qualiopi_mention AS activate_qualiopi_mention_65, t34.qualiopi_certificate_path AS qualiopi_certificate_path_66, t0.website_id AS website_id_67 FROM formation t0 LEFT JOIN organization t34 ON t0.organization_id = t34.id WHERE t0.former_id = ?
Parameters:
[
  2
]
0.18 ms
(1.87%)
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.organization_id = ?
Parameters:
[
  1
]
0.13 ms
(1.37%)
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.10 ms
(1.03%)
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.
App\Entity\Document No errors.
App\Entity\FormationSessionFormer No errors.
App\Entity\Prepositioning No errors.