Query Metrics
8
Database Queries
7
Different statements
30.17 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 5.44 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.btnTitle AS btnTitle_3, t0.link AS link_4, t0.description AS description_5, t0.isEnabled AS isEnabled_6, t0.createdAt AS createdAt_7, t0.lastUpdate AS lastUpdate_8, t0.date AS date_9, t0.banner_id AS banner_id_10 FROM banners t0 WHERE t0.isEnabled = ? ORDER BY t0.id DESC LIMIT 1
Parameters:
[
1
]
|
| 2 | 12.90 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.content AS content_4, t0.slug AS slug_5, t0.createdAt AS createdAt_6, t0.lastUpdate AS lastUpdate_7, t0.date AS date_8, t0.isEnabled AS isEnabled_9, t0.isOnFrontPage AS isOnFrontPage_10, t0.isVisible AS isVisible_11, t0.isDeleted AS isDeleted_12, t0.youtube AS youtube_13, t0.flickr AS flickr_14, t0.URL AS URL_15, t0.soundcloud AS soundcloud_16, t0.updatedBy AS updatedBy_17, t0.banner_id AS banner_id_18, t19.target AS target_20, t19.thumbnailDir AS thumbnailDir_21, t19.hasThumbnail AS hasThumbnail_22, t19.id AS id_23, t19.pages AS pages_24, t19.downloads AS downloads_25, t19.reading AS reading_26, t19.name AS name_27, t19.dir AS dir_28, t19.source AS source_29, t19.size AS size_30, t19.is_enabled AS is_enabled_31, t19.is_deleted AS is_deleted_32, t19.last_update AS last_update_33, t19.created_at AS created_at_34, t19.formatSize AS formatSize_35, t19.mimetype AS mimetype_36, t0.category_id AS category_id_37, t38.id AS id_39, t38.name AS name_40, t38.slug AS slug_41, t38.description AS description_42, t38.banner_id AS banner_id_43, t0.type_id AS type_id_44, t45.id AS id_46, t45.name AS name_47, t45.slug AS slug_48, t0.user_id AS user_id_49, t50.id AS id_51, t50.fName AS fName_52, t50.lName AS lName_53, t50.phone AS phone_54, t50.createdAt AS createdAt_55, t50.lastLogin AS lastLogin_56, t50.password AS password_57, t50.token AS token_58, t50.sex AS sex_59, t50.isEnabled AS isEnabled_60, t50.email AS email_61, t50.profile_id AS profile_id_62, t0.album_id AS album_id_63, t64.id AS id_65, t64.title AS title_66, t64.isEnabled AS isEnabled_67, t0.biblio_id AS biblio_id_68, t69.id AS id_70, t69.title AS title_71, t69.isEnabled AS isEnabled_72 FROM articles t0 LEFT JOIN picture t19 ON t0.banner_id = t19.id LEFT JOIN articles_categories t38 ON t0.category_id = t38.id LEFT JOIN articles_types t45 ON t0.type_id = t45.id LEFT JOIN users t50 ON t0.user_id = t50.id LEFT JOIN albums t64 ON t0.album_id = t64.id LEFT JOIN biblios t69 ON t0.biblio_id = t69.id WHERE t0.isEnabled = ? ORDER BY t0.date DESC LIMIT 3
Parameters:
[
1
]
|
| 3 | 2.94 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.description AS description_3, t0.details AS details_4, t0.slug AS slug_5, t0.is_enabled AS is_enabled_6, t0.created_at AS created_at_7, t0.has_registration AS has_registration_8, t0.banner_id AS banner_id_9, t0.album_id AS album_id_10, t0.user_id AS user_id_11 FROM formations t0 WHERE t0.is_enabled = ?
Parameters:
[
1
]
|
| 4 | 2.95 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.titleAlt AS titleAlt_3, t0.pictureTitle AS pictureTitle_4, t0.pictureSubtitle AS pictureSubtitle_5, t0.description AS description_6, t0.content AS content_7, t0.slug AS slug_8, t0.lastUpdate AS lastUpdate_9, t0.date AS date_10, t0.isEnabled AS isEnabled_11, t0.createdBy AS createdBy_12, t0.updatedBy AS updatedBy_13, t0.user_id AS user_id_14, t0.picture_id AS picture_id_15, t0.banner_id AS banner_id_16 FROM pages t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"a-propos"
]
|
| 5 | 1.14 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.description AS description_3, t0.details AS details_4, t0.slug AS slug_5, t0.is_enabled AS is_enabled_6, t0.created_at AS created_at_7, t0.has_registration AS has_registration_8, t0.banner_id AS banner_id_9, t0.album_id AS album_id_10, t0.user_id AS user_id_11 FROM formations t0 WHERE t0.is_enabled = ?
Parameters:
[
1
]
|
| 6 | 2.64 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.description AS description_3, t0.slug AS slug_4, t0.is_enabled AS is_enabled_5 FROM StructuresCategories t0 WHERE t0.is_enabled = ?
Parameters:
[
1
]
|
| 7 | 0.55 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.banner_id AS banner_id_5 FROM articles_categories t0
Parameters:
[] |
| 8 | 1.60 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:
[] |
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\Banners | No errors. |
| App\Entity\OSFile | No errors. |
| App\Entity\Picture | No errors. |
| App\Entity\Articles | No errors. |
| App\Entity\Users | No errors. |
| App\Entity\ArticlesCategories | No errors. |
| App\Entity\ArticlesTypes | No errors. |
| App\Entity\Profiles | No errors. |
| App\Entity\Albums | No errors. |
| App\Entity\Biblios | No errors. |
| App\Entity\Tags | No errors. |
| App\Entity\Formations | No errors. |
| App\Entity\FormationsThematics | No errors. |
| App\Entity\Registrations | No errors. |
| App\Entity\FormationsSessions | No errors. |
| App\Entity\Pages | No errors. |
| App\Entity\StructuresCategories | No errors. |
| App\Entity\ResourcesCategories | No errors. |
| App\Entity\Resources | No errors. |