https://afpma-webapp.e-conception.fr/generate-pdf/6

Query Metrics

6 Database Queries
6 Different statements
2.22 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 1.12 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.sub_title AS sub_title_3, t0.code AS code_4, t0.cut_in_blocks AS cut_in_blocks_5, t0.new AS new_6, t0.customizable AS customizable_7, t0.objectives AS objectives_8, t0.complementary_objectives AS complementary_objectives_9, t0.pedagogic_content AS pedagogic_content_10, t0.pluses AS pluses_11, t0.concerned_persons AS concerned_persons_12, t0.prerequisites AS prerequisites_13, t0.price AS price_14, t0.time AS time_15, t0.date AS date_16, t0.place AS place_17, t0.terms_of_access AS terms_of_access_18, t0.alternating_rythm AS alternating_rythm_19, t0.teaching_methods AS teaching_methods_20, t0.teaching_means AS teaching_means_21, t0.education_level AS education_level_22, t0.training_order AS training_order_23, t0.certification_name AS certification_name_24, t0.assessment_methods AS assessment_methods_25, t0.target_functions AS target_functions_26, t0.continuing_studies AS continuing_studies_27, t0.disabled_accessibility AS disabled_accessibility_28, t0.testimonials AS testimonials_29, t0.accessibility_text AS accessibility_text_30, t0.creation_date AS creation_date_31, t0.edit_date AS edit_date_32, t0.logo_display AS logo_display_33, t0.which_public AS which_public_34, t0.published AS published_35, t0.is_fiche AS is_fiche_36, t0.slug AS slug_37, t0.fiche_title AS fiche_title_38, t0.trainee_or_enterprise AS trainee_or_enterprise_39, t0.validity_date AS validity_date_40, t0.link_video AS link_video_41, t0.rncp_or_rs AS rncp_or_rs_42, t0.days AS days_43, t0.hours AS hours_44, t0.company_missions AS company_missions_45, t0.validity_date_rncp AS validity_date_rncp_46, t0.reset_date AS reset_date_47, t0.type_id AS type_id_48, t0.certification_type_id AS certification_type_id_49, t0.owner_id AS owner_id_50, t0.training_place_id AS training_place_id_51, t0.education_level_name_id AS education_level_name_id_52, t0.public_type_id AS public_type_id_53 FROM trainings t0 WHERE t0.id = ?
Parameters:
[
  "6"
]
2 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.media AS media_4, t0.description AS description_5, t0.media_url AS media_url_6 FROM domain t0 INNER JOIN trainings_domain ON t0.id = trainings_domain.domain_id WHERE trainings_domain.trainings_id = ?
Parameters:
[
  6
]
3 0.25 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.phone AS phone_7, t0.reset_password AS reset_password_8 FROM user t0 INNER JOIN commercials_trainings ON t0.id = commercials_trainings.user_id WHERE commercials_trainings.trainings_id = ?
Parameters:
[
  6
]
4 0.17 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM training_place t0 WHERE t0.id = ?
Parameters:
[
  10
]
5 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM device_and_training t0 INNER JOIN trainings_device_and_training ON t0.id = trainings_device_and_training.device_and_training_id WHERE trainings_device_and_training.trainings_id = ?
Parameters:
[
  6
]
6 0.17 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM education_level t0 WHERE t0.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\Trainings
  • The mappings App\Entity\Trainings#commercials and App\Entity\User#trainingsPedagogicals are inconsistent with each other.
App\Entity\Type No errors.
App\Entity\CertificationType No errors.
App\Entity\User No errors.
App\Entity\TrainingPlace No errors.
App\Entity\EducationLevel No errors.
App\Entity\PublicType No errors.
App\Entity\Domain No errors.
App\Entity\SubDomain No errors.
App\Entity\Keywords No errors.
App\Entity\DeviceAndTraining No errors.
App\Entity\Sessions No errors.
App\Entity\SubDomainOrder No errors.