Query Metrics
2
Database Queries
2
Different statements
1.44 ms
Query time
0
Invalid entities
8
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.67 ms |
SELECT t0.id AS id_1, t0.token AS token_2, t0.duration_weeks AS duration_weeks_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.archived AS archived_6, t0.view_counter AS view_counter_7, t0.source AS source_8, t0.source_model AS source_model_9, t0.created_by_id AS created_by_id_10, t0.preferences_id AS preferences_id_11, t12.genders AS genders_13, t12.fitness_level AS fitness_level_14, t12.primary_goal AS primary_goal_15, t12.target_weight AS target_weight_16, t12.equipment_type AS equipment_type_17, t12.workout_days AS workout_days_18, t12.workout_duration AS workout_duration_19, t12.sedentary_level AS sedentary_level_20, t12.sleep_quality AS sleep_quality_21, t12.stress_level AS stress_level_22, t12.imbalances AS imbalances_23, t12.injuries AS injuries_24, t12.context AS context_25, t12.id AS id_26, t12.created_at AS created_at_27, t12.updated_at AS updated_at_28, t12.created_by_id AS created_by_id_29, t12.updated_by_id AS updated_by_id_30, t0.updated_by_id AS updated_by_id_31, t0.type, t0.visibility AS visibility_32, t0.start_at AS start_at_33, t0.end_at AS end_at_34, t0.assignee_id AS assignee_id_35, t0.free AS free_36, t0.pinned AS pinned_37, t0.published AS published_38, t0.published_at AS published_at_39, t0.publisher AS publisher_40 FROM program t0 LEFT JOIN training_preferences t12 ON t0.preferences_id = t12.id WHERE t0.token = ? AND t0.type IN ('user', 'template') LIMIT 1
Parameters:
[
"68629c85ddcde"
]
|
||||||||||||||||||||||
| 2 | 0.77 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.body AS body_6, t0.description AS description_7, t0.locale AS locale_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10, t0.translatable_id AS translatable_id_11, t0.type FROM program_translation t0 WHERE t0.translatable_id = ? AND t0.type IN ('template')
Parameters:
[
163
]
|
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\Entity\Training\Translation\ProgramTranslation | 4 |
| App\Entity\User | 2 |
| App\Entity\Training\Program | 1 |
| App\Entity\Training\TrainingPreferences | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Training\Program | No errors. |
| App\Entity\Model\TechnicalMetadata | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Training\TrainingPreferences | No errors. |
| App\Entity\Training\ProgramUser | No errors. |
| App\Entity\Training\ProgramTemplate | No errors. |
| App\Entity\Training\Workout | No errors. |
| Vich\UploaderBundle\Entity\File | No errors. |
| App\Entity\Media\Media | No errors. |
| App\Entity\Media\MediaImage | No errors. |
| App\Entity\Faq | No errors. |
| App\Entity\Training\Translation\ProgramTranslation | No errors. |
| App\Entity\Training\Translation\ProgramTemplateTranslation | No errors. |
| App\Entity\Training\Material | No errors. |