Query Metrics
7
Database Queries
5
Different statements
9.97 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 2.78 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.id = ?
Parameters:
[
"10"
]
|
2 | 0.52 ms |
"START TRANSACTION"
Parameters:
[] |
3 | 0.85 ms |
INSERT INTO banners (title, btnTitle, link, description, isEnabled, createdAt, lastUpdate, date, banner_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 => "Renforcement des capacités de l’administration communale et des élus locaux" 2 => "Lire l'article" 3 => "/article/10/renforcement-capacites-administration-communale-elus-locaux/" 4 => null 5 => 1 6 => null 7 => null 8 => "2019-06-11 22:10:00" 9 => 40 ] |
4 | 2.06 ms |
"COMMIT"
Parameters:
[] |
5 | 0.49 ms |
"START TRANSACTION"
Parameters:
[] |
6 | 0.88 ms |
INSERT INTO users_activities (object, objectID, action, info, date, user_id) VALUES (?, ?, ?, ?, ?, ?)
Parameters:
[ 1 => "App\Entity\Articles" 2 => 10 3 => "addtofront" 4 => "Ajout d'un article de la Une" 5 => "2025-07-14 21:27:03" 6 => null ] |
7 | 2.38 ms |
"COMMIT"
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\Articles | No errors. |
App\Entity\Users | No errors. |
App\Entity\OSFile | No errors. |
App\Entity\Picture | 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\Banners | No errors. |
App\Entity\UsersActivities | No errors. |