Query Metrics
6
Database Queries
6
Different statements
1.96 ms
Query time
1
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
0.84 ms (43.02%) |
1 |
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:
[
"223"
]
|
0.30 ms (15.43%) |
1 |
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:
[
223
]
|
0.26 ms (13.09%) |
1 |
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:
[
223
]
|
0.22 ms (11.20%) |
1 |
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:
[
223
]
|
0.17 ms (8.75%) |
1 |
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
]
|
0.17 ms (8.51%) |
1 |
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
]
|
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 |
|
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. |