Query Metrics
5
Database Queries
5
Different statements
6.47 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 3.73 ms |
SELECT t0.youtube AS youtube_1, t0.id AS id_2, t0.title AS title_3, t0.description AS description_4, t0.content AS content_5, t0.slug AS slug_6, t0.date AS date_7, t0.createdAt AS createdAt_8, t0.lastUpdate AS lastUpdate_9, t0.isEnabled AS isEnabled_10, t0.file_id AS file_id_11, t0.biblio_id AS biblio_id_12, t0.category_id AS category_id_13, t14.id AS id_15, t14.label AS label_16, t14.description AS description_17, t14.slug AS slug_18, t14.isEnabled AS isEnabled_19, t0.banner_id AS banner_id_20, t21.target AS target_22, t21.thumbnailDir AS thumbnailDir_23, t21.hasThumbnail AS hasThumbnail_24, t21.id AS id_25, t21.pages AS pages_26, t21.downloads AS downloads_27, t21.reading AS reading_28, t21.name AS name_29, t21.dir AS dir_30, t21.source AS source_31, t21.size AS size_32, t21.is_enabled AS is_enabled_33, t21.is_deleted AS is_deleted_34, t21.last_update AS last_update_35, t21.created_at AS created_at_36, t21.formatSize AS formatSize_37, t21.mimetype AS mimetype_38, t0.sector_id AS sector_id_39, t0.user_id AS user_id_40, t41.id AS id_42, t41.fName AS fName_43, t41.lName AS lName_44, t41.phone AS phone_45, t41.createdAt AS createdAt_46, t41.lastLogin AS lastLogin_47, t41.password AS password_48, t41.token AS token_49, t41.sex AS sex_50, t41.isEnabled AS isEnabled_51, t41.email AS email_52, t41.profile_id AS profile_id_53, t0.updatedBy AS updatedBy_54 FROM videos t0 LEFT JOIN videos_categories t14 ON t0.category_id = t14.id LEFT JOIN picture t21 ON t0.banner_id = t21.id LEFT JOIN users t41 ON t0.user_id = t41.id WHERE t0.isEnabled = ? ORDER BY t0.id DESC
Parameters:
[
1
]
|
| 2 | 0.69 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.isEnabled AS isEnabled_5, t0.banner_id AS banner_id_6 FROM articles_categories t0 WHERE t0.isEnabled = ?
Parameters:
[
1
]
|
| 3 | 0.83 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.description AS description_3, t0.slug AS slug_4, t0.isEnabled AS isEnabled_5 FROM opportunities_categories t0 WHERE t0.isEnabled = ?
Parameters:
[
1
]
|
| 4 | 0.58 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.description AS description_3, t0.slug AS slug_4 FROM resources_categories t0
Parameters:
[] |
| 5 | 0.64 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.description AS description_3, t0.slug AS slug_4, t0.isEnabled AS isEnabled_5 FROM videos_categories t0 WHERE t0.isEnabled = ?
Parameters:
[
1
]
|
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\OSEntity | No errors. |
| App\Entity\Videos | No errors. |
| App\Entity\OSFile | No errors. |
| App\Entity\File | No errors. |
| App\Entity\Biblios | No errors. |
| App\Entity\VideosCategories | No errors. |
| App\Entity\Picture | No errors. |
| App\Entity\Sectors | No errors. |
| App\Entity\Users | No errors. |
| App\Entity\Profiles | No errors. |
| App\Entity\Tags | No errors. |
| App\Entity\ArticlesCategories | No errors. |
| App\Entity\Articles | No errors. |
| App\Entity\OpportunitiesCategories | No errors. |
| App\Entity\ResourcesCategories | No errors. |
| App\Entity\ArticlesTypes | No errors. |
| App\Entity\Albums | No errors. |
| App\Entity\Resources | No errors. |
| App\Entity\Subscribers | No errors. |