Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 8
• 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 count(DISTINCT o0_.id) AS sclr_0 FROM objet_trouve o0_ LEFT JOIN categorie c1_ ON o0_.categorie_id = c1_.id LEFT JOIN `user` u2_ ON o0_.user_id = u2_.id WHERE o0_.deleted_at IS NULL AND o0_.statut = ? AND c1_.nom <> ?

[
  "disponible"
  "CNI"
]

SELECT
  count(DISTINCT o0_.id) AS sclr_0
FROM
  objet_trouve o0_
  LEFT JOIN categorie c1_ ON o0_.categorie_id = c1_.id
  LEFT JOIN `user` u2_ ON o0_.user_id = u2_.id
WHERE
  o0_.deleted_at IS NULL
  AND o0_.statut = ?
  AND c1_.nom <> ?

SELECT count(DISTINCT o0_.id) AS sclr_0 FROM objet_trouve o0_ LEFT JOIN categorie c1_ ON o0_.categorie_id = c1_.id LEFT JOIN `user` u2_ ON o0_.user_id = u2_.id WHERE o0_.deleted_at IS NULL AND o0_.statut = 'disponible' AND c1_.nom <> 'CNI';

SELECT DISTINCT o0_.id AS id_0, o0_.created_at AS created_at_1 FROM objet_trouve o0_ LEFT JOIN categorie c1_ ON o0_.categorie_id = c1_.id LEFT JOIN `user` u2_ ON o0_.user_id = u2_.id WHERE o0_.deleted_at IS NULL AND o0_.statut = ? AND c1_.nom <> ? ORDER BY o0_.created_at DESC LIMIT 2

[
  "disponible"
  "CNI"
]

SELECT
  DISTINCT o0_.id AS id_0,
  o0_.created_at AS created_at_1
FROM
  objet_trouve o0_
  LEFT JOIN categorie c1_ ON o0_.categorie_id = c1_.id
  LEFT JOIN `user` u2_ ON o0_.user_id = u2_.id
WHERE
  o0_.deleted_at IS NULL
  AND o0_.statut = ?
  AND c1_.nom <> ?
ORDER BY
  o0_.created_at DESC
LIMIT
  2

SELECT DISTINCT o0_.id AS id_0, o0_.created_at AS created_at_1 FROM objet_trouve o0_ LEFT JOIN categorie c1_ ON o0_.categorie_id = c1_.id LEFT JOIN `user` u2_ ON o0_.user_id = u2_.id WHERE o0_.deleted_at IS NULL AND o0_.statut = 'disponible' AND c1_.nom <> 'CNI' ORDER BY o0_.created_at DESC LIMIT 2;

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.statut AS statut_5, t0.deleted_at AS deleted_at_6, t0.icon AS icon_7, t0.created_by_admin_id AS created_by_admin_id_8, t0.deleted_by_admin_id AS deleted_by_admin_id_9 FROM categorie t0

[]

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.description AS description_3,
  t0.created_at AS created_at_4,
  t0.statut AS statut_5,
  t0.deleted_at AS deleted_at_6,
  t0.icon AS icon_7,
  t0.created_by_admin_id AS created_by_admin_id_8,
  t0.deleted_by_admin_id AS deleted_by_admin_id_9
FROM
  categorie t0

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.statut AS statut_5, t0.deleted_at AS deleted_at_6, t0.icon AS icon_7, t0.created_by_admin_id AS created_by_admin_id_8, t0.deleted_by_admin_id AS deleted_by_admin_id_9 FROM categorie t0;

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;