Query Metrics
7
Database Queries
5
Different statements
8.35 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
5.56 ms (66.57%) |
2 |
"COMMIT"
Parameters:
[] |
|
1.20 ms (14.35%) |
1 |
SELECT t0.opening_date AS opening_date_1, t0.closing_date AS closing_date_2, t0.structure AS structure_3, t0.place AS place_4, t0.submission_link AS submission_link_5, t0.submission_btn_title AS submission_btn_title_6, t0.id AS id_7, t0.title AS title_8, t0.description AS description_9, t0.content AS content_10, t0.slug AS slug_11, t0.date AS date_12, t0.createdAt AS createdAt_13, t0.lastUpdate AS lastUpdate_14, t0.isEnabled AS isEnabled_15, t0.biblio_id AS biblio_id_16, t17.id AS id_18, t17.title AS title_19, t17.isEnabled AS isEnabled_20, t0.category_id AS category_id_21, t22.id AS id_23, t22.label AS label_24, t22.description AS description_25, t22.slug AS slug_26, t22.isEnabled AS isEnabled_27, t0.type_id AS type_id_28, t0.banner_id AS banner_id_29, t30.target AS target_31, t30.thumbnailDir AS thumbnailDir_32, t30.hasThumbnail AS hasThumbnail_33, t30.id AS id_34, t30.pages AS pages_35, t30.downloads AS downloads_36, t30.reading AS reading_37, t30.name AS name_38, t30.dir AS dir_39, t30.source AS source_40, t30.size AS size_41, t30.is_enabled AS is_enabled_42, t30.is_deleted AS is_deleted_43, t30.last_update AS last_update_44, t30.created_at AS created_at_45, t30.formatSize AS formatSize_46, t30.mimetype AS mimetype_47, t0.sector_id AS sector_id_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.updatedBy AS updatedBy_63 FROM opportunities t0 LEFT JOIN biblios t17 ON t0.biblio_id = t17.id LEFT JOIN opportunities_categories t22 ON t0.category_id = t22.id LEFT JOIN picture t30 ON t0.banner_id = t30.id LEFT JOIN users t50 ON t0.user_id = t50.id WHERE t0.id = ?
Parameters:
[
"4"
]
|
|
0.64 ms (7.70%) |
2 |
"START TRANSACTION"
Parameters:
[] |
|
0.51 ms (6.14%) |
1 |
UPDATE opportunities SET isEnabled = ? WHERE id = ?
Parameters:
[ 0 4 ] |
|
0.44 ms (5.23%) |
1 |
INSERT INTO users_activities (object, objectID, action, info, date, user_id) VALUES (?, ?, ?, ?, ?, ?)
Parameters:
[ "App\Entity\Opportunities" 4 "enable" "Activation/désactivation d'un projet" "2026-02-06 09:10:57" null ] |
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\Opportunities | No errors. |
| App\Entity\Biblios | No errors. |
| App\Entity\OpportunitiesCategories | No errors. |
| App\Entity\OpportunitiesTypes | No errors. |
| App\Entity\OSFile | 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\File | No errors. |
| App\Entity\UsersActivities | No errors. |