Query Metrics
6
Database Queries
6
Different statements
1.66 ms
Query time
0
Invalid entities
9
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.49 ms |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.date AS date_4, t0.video_file_name AS video_file_name_5, t0.video_link AS video_link_6, t0.views AS views_7 FROM media t0 ORDER BY t0.date DESC
Parameters:
[]
|
||||||||||||||||||||||
| 2 | 0.44 ms |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.photos AS photos_4, t0.date AS date_5, t0.created_at AS created_at_6, t0.tags AS tags_7, t0.views AS views_8, t0.likes AS likes_9, t0.downloads AS downloads_10, t0.secteur_id AS secteur_id_11, t0.evenement_id AS evenement_id_12, t0.region_id AS region_id_13 FROM galerie_photo t0 ORDER BY t0.id DESC
Parameters:
[]
|
||||||||||||||||||||||
| 3 | 0.32 ms |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.date AS date_4, t0.nbtelechargement AS nbtelechargement_5, t0.photo AS photo_6, t0.fichier AS fichier_7, t0.updated_at AS updated_at_8, t0.tags AS tags_9, t0.type_id AS type_id_10 FROM document_media t0 ORDER BY t0.id DESC
Parameters:
[]
|
||||||||||||||||||||||
| 4 | 0.18 ms |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.date AS date_4, t0.video_file_name AS video_file_name_5, t0.video_link AS video_link_6, t0.views AS views_7 FROM media t0 ORDER BY t0.date DESC LIMIT 1
Parameters:
[]
|
||||||||||||||||||||||
| 5 | 0.12 ms |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.photos AS photos_4, t0.date AS date_5, t0.created_at AS created_at_6, t0.tags AS tags_7, t0.views AS views_8, t0.likes AS likes_9, t0.downloads AS downloads_10, t0.secteur_id AS secteur_id_11, t0.evenement_id AS evenement_id_12, t0.region_id AS region_id_13 FROM galerie_photo t0 ORDER BY t0.created_at DESC LIMIT 1
Parameters:
[]
|
||||||||||||||||||||||
| 6 | 0.11 ms |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.date AS date_4, t0.nbtelechargement AS nbtelechargement_5, t0.photo AS photo_6, t0.fichier AS fichier_7, t0.updated_at AS updated_at_8, t0.tags AS tags_9, t0.type_id AS type_id_10 FROM document_media t0 ORDER BY t0.date DESC LIMIT 1
Parameters:
[]
|
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\DocumentMedia | 2 |
| App\Entity\TypeDocument | 2 |
| App\Entity\Media | 1 |
| App\Entity\GaleriePhoto | 1 |
| App\Entity\Sector | 1 |
| App\Entity\Evenement | 1 |
| App\Entity\Region | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Media | No errors. |
| App\Entity\GaleriePhoto | No errors. |
| App\Entity\Sector | No errors. |
| App\Entity\Evenement | No errors. |
| App\Entity\Region | No errors. |
| App\Entity\DocumentMedia | No errors. |
| App\Entity\TypeDocument | No errors. |