Query Metrics
9
Database Queries
9
Different statements
5.77 ms
Query time
7
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
1.71 ms (29.62%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.photo AS photo_3, t0.date AS date_4, t0.text AS text_5 FROM news t0
Parameters:
[] |
0.88 ms (15.21%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.photo AS photo_4, t0.video AS video_5, t0.lien AS lien_6, t0.date AS date_7 FROM coup_de_projecteur t0
Parameters:
[] |
0.82 ms (14.16%) |
1 |
SELECT t0.id AS id_4, t0.gaeaUserId AS gaeaUserId_5, t0.username AS username_6, t0.role AS role_7, t0.token AS token_8, t0.emailValidated AS emailValidated_9, t0.actived AS actived_10, t0.inscription_date AS inscription_date_11, t0.avatar AS avatar_12, t0.connected AS connected_13, t0.firstname AS firstname_14, t0.lastname AS lastname_15, t0.discr, t1.email AS email_16, t1.street AS street_17, t1.streetnumber AS streetnumber_18, t1.postcode AS postcode_19, t1.city AS city_20, t1.region AS region_21, t1.country AS country_22, t1.phone AS phone_23, t1.date_birth AS date_birth_24, t2.name AS name_25, t2.certification AS certification_26, t2.niveau AS niveau_27, t2.influencezone AS influencezone_28, t2.street AS street_29, t2.streetnumber AS streetnumber_30, t2.postcode AS postcode_31, t2.city AS city_32, t2.region AS region_33, t2.country AS country_34, t2.phone AS phone_35, t2.wantevaluation AS wantevaluation_36, t2.description AS description_37, t2.vision AS vision_38, t2.socialreason AS socialreason_39, t2.urlwebsite AS urlwebsite_40, t2.urlfacebook AS urlfacebook_41, t2.urltwitter AS urltwitter_42, t2.urllinkedin AS urllinkedin_43, t2.slug AS slug_44, t2.starting_date AS starting_date_45, t2.package AS package_46, t2.image AS image_47, t2.latitude AS latitude_48, t2.longtitude AS longtitude_49, t2.activated AS activated_50, t3.name AS name_51, t3.description AS description_52, t3.street AS street_53, t3.streetnumber AS streetnumber_54, t3.postcode AS postcode_55, t3.city AS city_56, t3.region AS region_57, t3.country AS country_58, t3.phone AS phone_59, t3.vision AS vision_60, t3.urlwebsite AS urlwebsite_61, t3.slug AS slug_62, t3.latitude AS latitude_63, t3.longtitude AS longtitude_64, t3.activated AS activated_65 FROM userrv t0 LEFT JOIN person t1 ON t0.id = t1.id LEFT JOIN company t2 ON t0.id = t2.id LEFT JOIN town t3 ON t0.id = t3.id WHERE t0.id = ?
Parameters:
[
312
]
|
0.77 ms (13.29%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.lien AS lien_4, t0.date AS date_5, t0.photo AS photo_6 FROM sucess_story t0
Parameters:
[] |
0.62 ms (10.83%) |
1 |
SELECT t0.id AS id_1, t0.date AS date_2, t0.user_id AS user_id_3, t0.event_id AS event_id_4 FROM event_fav t0 WHERE t0.user_id IS NULL
Parameters:
[] |
0.45 ms (7.76%) |
1 |
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.description AS description_2, e0_.starting_date AS starting_date_3, e0_.finish_date AS finish_date_4, e0_.place AS place_5, e0_.type AS type_6, e0_.image AS image_7, e0_.user_id AS user_id_8 FROM event e0_ WHERE e0_.starting_date > ? ORDER BY e0_.starting_date ASC LIMIT 6
Parameters:
[
"2025-09-14 09:15:18"
]
|
0.24 ms (4.19%) |
1 |
SELECT t0.id AS id_1, t0.is_accepted AS is_accepted_2, t0.user AS user_3, t0.friend AS friend_4 FROM friendship t0 WHERE t0.friend IN (?)
Parameters:
[
312
]
|
0.16 ms (2.76%) |
1 |
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.description AS description_2, e0_.starting_date AS starting_date_3, e0_.finish_date AS finish_date_4, e0_.place AS place_5, e0_.type AS type_6, e0_.image AS image_7, e0_.user_id AS user_id_8 FROM event e0_ WHERE e0_.starting_date < ? ORDER BY e0_.starting_date DESC LIMIT 6
Parameters:
[
"2025-09-14 09:15:18"
]
|
0.13 ms (2.17%) |
1 |
SELECT t0.id AS id_1, t0.is_accepted AS is_accepted_2, t0.user AS user_3, t0.friend AS friend_4 FROM friendship t0 WHERE t0.user IN (?)
Parameters:
[
312
]
|
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\EventFav | No errors. |
App\Entity\User |
|
App\Entity\Event |
|
App\Entity\News | No errors. |
App\Entity\SucessStory | No errors. |
App\Entity\CoupDeProjecteur | No errors. |
App\Entity\Person |
|
App\Entity\Company |
|
App\Entity\Town |
|
App\Entity\ProductFav | No errors. |
App\Entity\Friendship | No errors. |
App\Entity\CompanyFav | No errors. |
App\Entity\Notification | No errors. |
App\Entity\UserPreference | No errors. |
App\Entity\FavoriteCategory | No errors. |
App\Entity\FavoriteCompany |
|
App\Entity\Product |
|
App\Entity\Category | No errors. |