Query Metrics
8
Database Queries
8
Different statements
9.69 ms
Query time
1
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.30 ms |
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
]
|
| 2 | 0.24 ms |
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
]
|
| 3 | 0.13 ms |
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
]
|
| 4 | 0.10 ms |
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
]
|
| 5 | 0.37 ms |
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"
]
|
| 6 | 0.18 ms |
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
]
|
| 7 | 0.20 ms |
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
]
|
| 8 | 8.17 ms |
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
]
|
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 |
|
| 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. |