Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 7
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

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

[]

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

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;

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

[
  "disponible"
]

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

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 = 'disponible' ORDER BY t0.created_at DESC LIMIT 8;

SELECT COUNT(*) FROM objet_trouve t0

[]

SELECT
  COUNT(*)
FROM
  objet_trouve t0

SELECT COUNT(*) FROM objet_trouve t0;

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 = ?

[
  "CNI"
  "restitué"
]

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 = ?

SELECT count(o0_.id) AS sclr_0 FROM objet_trouve o0_ INNER JOIN categorie c1_ ON o0_.categorie_id = c1_.id WHERE c1_.nom = 'CNI' AND o0_.statut = 'restitué';

SELECT COUNT(*) FROM objet_trouve t0 WHERE t0.statut = ?

[
  "restitué"
]

SELECT
  COUNT(*)
FROM
  objet_trouve t0
WHERE
  t0.statut = ?

SELECT COUNT(*) FROM objet_trouve t0 WHERE t0.statut = 'restitué';

SELECT COUNT(*) FROM litige t0 WHERE t0.statut = ?

[
  "résolu"
]

SELECT
  COUNT(*)
FROM
  litige t0
WHERE
  t0.statut = ?

SELECT COUNT(*) FROM litige t0 WHERE t0.statut = 'résolu';

SELECT COUNT(*) FROM objet_trouve t0 WHERE t0.statut = ? AND t0.deleted_at IS NULL

[
  "en attente de validation"
]

SELECT
  COUNT(*)
FROM
  objet_trouve t0
WHERE
  t0.statut = ?
  AND t0.deleted_at IS NULL

SELECT COUNT(*) FROM objet_trouve t0 WHERE t0.statut = 'en attente de validation' AND t0.deleted_at IS NULL;

SELECT COUNT(*) FROM reclamation t0 WHERE t0.statut = ?

[
  "soumis"
]

SELECT
  COUNT(*)
FROM
  reclamation t0
WHERE
  t0.statut = ?

SELECT COUNT(*) FROM reclamation t0 WHERE t0.statut = 'soumis';

SELECT COUNT(*) FROM message_contact t0 WHERE t0.is_read = ?

[
  0
]

SELECT
  COUNT(*)
FROM
  message_contact t0
WHERE
  t0.is_read = ?

SELECT COUNT(*) FROM message_contact t0 WHERE t0.is_read = 0;