Query Metrics
2
Database Queries
2
Different statements
0.59 ms
Query time
0
Invalid entities
9
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.34 ms |
SELECT t0_.id AS id_0, t0_.status AS status_1, t0_.modality AS modality_2, t0_.level AS level_3, t0_.image_key AS image_key_4, t0_.price_cents AS price_cents_5, t0_.currency AS currency_6, t0_.duration_hours AS duration_hours_7, t0_.published_at AS published_at_8, t0_.created_at AS created_at_9, t0_.updated_at AS updated_at_10, t1_.id AS id_11, t1_.locale AS locale_12, t1_.title AS title_13, t1_.slug AS slug_14, t1_.summary AS summary_15, t1_.content AS content_16, t2_.id AS id_17, t2_.name AS name_18, t2_.logo_key AS logo_key_19, t3_.id AS id_20, t4_.id AS id_21, t4_.name AS name_22, t4_.photo_key AS photo_key_23, t5_.id AS id_24, t5_.locale AS locale_25, t5_.bio AS bio_26, t0_.institution_id AS institution_id_27, t1_.course_id AS course_id_28, t4_.profession_id AS profession_id_29, t5_.instructor_id AS instructor_id_30 FROM training_courses t0_ INNER JOIN training_course_translations t1_ ON t0_.id = t1_.course_id LEFT JOIN training_institutions t2_ ON t0_.institution_id = t2_.id LEFT JOIN training_course_specialties t6_ ON t0_.id = t6_.course_id LEFT JOIN training_specialties t3_ ON t3_.id = t6_.specialty_id LEFT JOIN training_course_instructors t7_ ON t0_.id = t7_.course_id LEFT JOIN training_instructors t4_ ON t4_.id = t7_.instructor_id LEFT JOIN training_instructor_translations t5_ ON t4_.id = t5_.instructor_id WHERE t0_.status = ? AND t1_.slug = ?
Parameters:
[ "published" "cirugia-oral-para-principiantes" ]
|
||||||||||||||||||||||||||||||
| 2 | 0.25 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.specialty_id AS specialty_id_4 FROM training_specialty_translations t0 WHERE t0.specialty_id = ?
Parameters:
[
b"\x01 _¶Ì,ts©\x01Dë¾Zºz"
]
|
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Training\Domain\InstructorTranslation | 2 |
| App\Training\Domain\SpecialtyTranslation | 2 |
| App\Training\Domain\Course | 1 |
| App\Training\Domain\CourseTranslation | 1 |
| App\Training\Domain\Institution | 1 |
| App\Training\Domain\Specialty | 1 |
| App\Training\Domain\Instructor | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Training\Domain\Course | No errors. |
| App\Training\Domain\CourseTranslation | No errors. |
| App\Training\Domain\Institution | No errors. |
| App\Training\Domain\Specialty | No errors. |
| App\Training\Domain\Instructor | No errors. |
| App\Training\Domain\InstructorTranslation | No errors. |
| App\Profession\Domain\Profession | No errors. |
| App\Training\Domain\ProfessionalProfile | No errors. |
| App\Training\Domain\SpecialtyTranslation | No errors. |