GET https://test.objetstrouves221.com/

Query Metrics

9 Database Queries
9 Different statements
8.96 ms Query time
0 Invalid entities
1 Managed entities

Queries

Group similar statements

# Time Info
1 0.59 ms
SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.email_principal AS email_principal_3, t0.email_contact AS email_contact_4, t0.telephone AS telephone_5, t0.whatsapp AS whatsapp_6, t0.adresse AS adresse_7, t0.facebook AS facebook_8, t0.instagram AS instagram_9, t0.twitter AS twitter_10, t0.is_maintenance_mode AS is_maintenance_mode_11, t0.maintenance_message AS maintenance_message_12, t0.logo AS logo_13, t0.description AS description_14 FROM global_setting t0 LIMIT 1
Parameters:
[]
2 0.73 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.lieu_trouve AS lieu_trouve_4, t0.created_at AS created_at_5, t0.trouve_at AS trouve_at_6, t0.restitution_at AS restitution_at_7, t0.reference AS reference_8, t0.moderated_at AS moderated_at_9, t0.raison_refus AS raison_refus_10, t0.statut AS statut_11, t0.deleted_at AS deleted_at_12, t0.user_id AS user_id_13, t0.moderated_by_admin_id AS moderated_by_admin_id_14, t0.preuves_restitution_id AS preuves_restitution_id_15, t0.categorie_id AS categorie_id_16, t0.deposeur_id AS deposeur_id_17 FROM objet_trouve t0 WHERE t0.statut = ? ORDER BY t0.created_at DESC LIMIT 8
Parameters:
[
  "disponible"
]
3 0.84 ms
SELECT COUNT(*) FROM objet_trouve t0
Parameters:
[]
4 1.99 ms
SELECT count(o0_.id) AS sclr_0 FROM objet_trouve o0_ INNER JOIN categorie c1_ ON o0_.categorie_id = c1_.id WHERE c1_.nom = ? AND o0_.statut = ?
Parameters:
[
  "CNI"
  "restitué"
]
5 0.56 ms
SELECT COUNT(*) FROM objet_trouve t0 WHERE t0.statut = ?
Parameters:
[
  "restitué"
]
6 1.72 ms
SELECT COUNT(*) FROM litige t0 WHERE t0.statut = ?
Parameters:
[
  "résolu"
]
7 0.80 ms
SELECT COUNT(*) FROM objet_trouve t0 WHERE t0.statut = ? AND t0.deleted_at IS NULL
Parameters:
[
  "en attente de validation"
]
8 1.03 ms
SELECT COUNT(*) FROM reclamation t0 WHERE t0.statut = ?
Parameters:
[
  "soumis"
]
9 0.70 ms
SELECT COUNT(*) FROM message_contact t0 WHERE t0.is_read = ?
Parameters:
[
  0
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\GlobalSetting 1

Entities Mapping

Class Mapping errors
App\Entity\GlobalSetting No errors.
App\Entity\ObjetTrouve No errors.
App\Entity\User No errors.
App\Entity\PreuveRestitution No errors.
App\Entity\Categorie No errors.
App\Entity\Deposeur No errors.
App\Entity\Litige No errors.
App\Entity\Reclamation No errors.
App\Entity\MessageContact No errors.