Symfony Profiler

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

Query Metrics

SELECT COUNT(*) FROM acteur t0

[]

SELECT
  COUNT(*)
FROM
  acteur t0

SELECT COUNT(*) FROM acteur t0;

SELECT t0.id AS id_1, t0.date_collecte AS date_collecte_2, t0.denomination AS denomination_3, t0.sigle AS sigle_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.commune AS commune_7, t0.sous_prefecture_id AS sous_prefecture_id_8, t0.departement_id AS departement_id_9, t0.district_id AS district_id_10, t0.nom_enqueteur AS nom_enqueteur_11, t0.nom_repondant AS nom_repondant_12, t0.fonction_repondant AS fonction_repondant_13, t0.type_acteur_code AS type_acteur_code_14, t0.statut_juridique AS statut_juridique_15, t0.annee_creation AS annee_creation_16, t0.numero_rccm AS numero_rccm_17, t0.numero_ncc AS numero_ncc_18, t0.telephone AS telephone_19, t0.email AS email_20, t0.site_web AS site_web_21, t0.description AS description_22, t0.intrants AS intrants_23, t0.region_id AS region_id_24 FROM acteur t0 LIMIT 12 OFFSET 336

[]

SELECT
  t0.id AS id_1,
  t0.date_collecte AS date_collecte_2,
  t0.denomination AS denomination_3,
  t0.sigle AS sigle_4,
  t0.latitude AS latitude_5,
  t0.longitude AS longitude_6,
  t0.commune AS commune_7,
  t0.sous_prefecture_id AS sous_prefecture_id_8,
  t0.departement_id AS departement_id_9,
  t0.district_id AS district_id_10,
  t0.nom_enqueteur AS nom_enqueteur_11,
  t0.nom_repondant AS nom_repondant_12,
  t0.fonction_repondant AS fonction_repondant_13,
  t0.type_acteur_code AS type_acteur_code_14,
  t0.statut_juridique AS statut_juridique_15,
  t0.annee_creation AS annee_creation_16,
  t0.numero_rccm AS numero_rccm_17,
  t0.numero_ncc AS numero_ncc_18,
  t0.telephone AS telephone_19,
  t0.email AS email_20,
  t0.site_web AS site_web_21,
  t0.description AS description_22,
  t0.intrants AS intrants_23,
  t0.region_id AS region_id_24
FROM
  acteur t0
LIMIT
  12
OFFSET
  336

SELECT t0.id AS id_1, t0.date_collecte AS date_collecte_2, t0.denomination AS denomination_3, t0.sigle AS sigle_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.commune AS commune_7, t0.sous_prefecture_id AS sous_prefecture_id_8, t0.departement_id AS departement_id_9, t0.district_id AS district_id_10, t0.nom_enqueteur AS nom_enqueteur_11, t0.nom_repondant AS nom_repondant_12, t0.fonction_repondant AS fonction_repondant_13, t0.type_acteur_code AS type_acteur_code_14, t0.statut_juridique AS statut_juridique_15, t0.annee_creation AS annee_creation_16, t0.numero_rccm AS numero_rccm_17, t0.numero_ncc AS numero_ncc_18, t0.telephone AS telephone_19, t0.email AS email_20, t0.site_web AS site_web_21, t0.description AS description_22, t0.intrants AS intrants_23, t0.region_id AS region_id_24 FROM acteur t0 LIMIT 12 OFFSET 336;

SELECT DISTINCT d.id, d.nom FROM district d JOIN acteur a ON a.district_id = d.id ORDER BY d.nom

[]

SELECT
  DISTINCT d.id,
  d.nom
FROM
  district d
  JOIN acteur a ON a.district_id = d.id
ORDER BY
  d.nom

SELECT DISTINCT d.id, d.nom FROM district d JOIN acteur a ON a.district_id = d.id ORDER BY d.nom;

SELECT DISTINCT r.id, r.nom FROM region r JOIN acteur a ON a.region_id = r.id ORDER BY r.nom

[]

SELECT
  DISTINCT r.id,
  r.nom
FROM
  region r
  JOIN acteur a ON a.region_id = r.id
ORDER BY
  r.nom

SELECT DISTINCT r.id, r.nom FROM region r JOIN acteur a ON a.region_id = r.id ORDER BY r.nom;

SELECT DISTINCT dp.id, dp.nom FROM departement dp JOIN acteur a ON a.departement_id = dp.id ORDER BY dp.nom

[]

SELECT
  DISTINCT dp.id,
  dp.nom
FROM
  departement dp
  JOIN acteur a ON a.departement_id = dp.id
ORDER BY
  dp.nom

SELECT DISTINCT dp.id, dp.nom FROM departement dp JOIN acteur a ON a.departement_id = dp.id ORDER BY dp.nom;

SELECT DISTINCT sp.id, sp.nom FROM sous_prefecture sp JOIN acteur a ON a.sous_prefecture_id = sp.id ORDER BY sp.nom

[]

SELECT
  DISTINCT sp.id,
  sp.nom
FROM
  sous_prefecture sp
  JOIN acteur a ON a.sous_prefecture_id = sp.id
ORDER BY
  sp.nom

SELECT DISTINCT sp.id, sp.nom FROM sous_prefecture sp JOIN acteur a ON a.sous_prefecture_id = sp.id ORDER BY sp.nom;

SELECT DISTINCT a.commune FROM acteur a WHERE a.commune IS NOT NULL AND a.commune != "" ORDER BY a.commune

[]

SELECT
  DISTINCT a.commune
FROM
  acteur a
WHERE
  a.commune IS NOT NULL
  AND a.commune != ""
ORDER BY
  a.commune

SELECT DISTINCT a.commune FROM acteur a WHERE a.commune IS NOT NULL AND a.commune != "" ORDER BY a.commune;