http://www.repertoirevert.org/fr/actualites

Query Metrics

9 Database Queries
9 Different statements
6.89 ms Query time
7 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.61 ms
(23.34%)
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:
[]
1.24 ms
(18.03%)
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.97 ms
(14.09%)
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.93 ms
(13.55%)
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.66 ms
(9.63%)
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 04:05:50"
]
0.59 ms
(8.59%)
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.46 ms
(6.70%)
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.25 ms
(3.56%)
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
]
0.17 ms
(2.52%)
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 04:05:50"
]

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
  • The mappings App\Entity\User#favoriteCompanies and App\Entity\FavoriteCompany#company are inconsistent with each other.
App\Entity\Event
  • The field App\Entity\Event#eventFavEvents is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\EventFav#event does not contain the required 'inversedBy="eventFavEvents"' attribute.
App\Entity\News No errors.
App\Entity\SucessStory No errors.
App\Entity\CoupDeProjecteur No errors.
App\Entity\Person
  • The mappings App\Entity\Person#favoriteCompanies and App\Entity\FavoriteCompany#company are inconsistent with each other.
App\Entity\Company
  • The mappings App\Entity\Company#favoriteCompanies and App\Entity\FavoriteCompany#company are inconsistent with each other.
App\Entity\Town
  • The mappings App\Entity\Town#favoriteCompanies and App\Entity\FavoriteCompany#company are inconsistent with each other.
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
  • The mappings App\Entity\FavoriteCompany#user and App\Entity\User#favoriteCompanies are inconsistent with each other.
App\Entity\Product
  • The field App\Entity\Product#subcategories is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\Subcategory#products does not contain the required 'mappedBy="subcategories"' attribute.
App\Entity\Category No errors.