Symfony Profiler

SELECT
  t1.date_creation AS date_creation_2,
  t1.date_maj AS date_maj_3,
  t1.id AS id_4,
  t1.prenom AS prenom_5,
  t1.nom AS nom_6,
  t1.adresse AS adresse_7,
  t1.code_postal AS code_postal_8,
  t1.ville AS ville_9,
  t1.tel_domicile AS tel_domicile_10,
  t1.tel_bureau AS tel_bureau_11,
  t1.tel_mobile AS tel_mobile_12,
  t1.note_tel_mobile AS note_tel_mobile_13,
  t1.tel_mobile2 AS tel_mobile2_14,
  t1.note_tel_mobile2 AS note_tel_mobile2_15,
  t1.email AS email_16,
  t1.email2 AS email2_17,
  t0.secteur AS secteur_18,
  t0.ville_rattachement AS ville_rattachement_19,
  t0.photo AS photo_20,
  t0.display_web AS display_web_21,
  t0.position AS position_22,
  t1.civilite_id AS civilite_id_23,
  t0.utilisateur_id AS utilisateur_id_24,
  t1.discr
FROM
  negociateur t0
  INNER JOIN personne t1 ON t0.id = t1.id
WHERE
  t0.display_web = ?
ORDER BY
  t0.position ASC,
  t1.id ASC

SELECT t1.date_creation AS date_creation_2, t1.date_maj AS date_maj_3, t1.id AS id_4, t1.prenom AS prenom_5, t1.nom AS nom_6, t1.adresse AS adresse_7, t1.code_postal AS code_postal_8, t1.ville AS ville_9, t1.tel_domicile AS tel_domicile_10, t1.tel_bureau AS tel_bureau_11, t1.tel_mobile AS tel_mobile_12, t1.note_tel_mobile AS note_tel_mobile_13, t1.tel_mobile2 AS tel_mobile2_14, t1.note_tel_mobile2 AS note_tel_mobile2_15, t1.email AS email_16, t1.email2 AS email2_17, t0.secteur AS secteur_18, t0.ville_rattachement AS ville_rattachement_19, t0.photo AS photo_20, t0.display_web AS display_web_21, t0.position AS position_22, t1.civilite_id AS civilite_id_23, t0.utilisateur_id AS utilisateur_id_24, t1.discr FROM negociateur t0 INNER JOIN personne t1 ON t0.id = t1.id WHERE t0.display_web = 1 ORDER BY t0.position ASC, t1.id ASC;

SELECT
  t0.id AS id_2,
  t0.username AS username_3,
  t0.username_canonical AS username_canonical_4,
  t0.email AS email_5,
  t0.email_canonical AS email_canonical_6,
  t0.enabled AS enabled_7,
  t0.salt AS salt_8,
  t0.password AS password_9,
  t0.last_login AS last_login_10,
  t0.confirmation_token AS confirmation_token_11,
  t0.password_requested_at AS password_requested_at_12,
  t0.roles AS roles_13,
  t0.discr,
  t1.prenom AS prenom_14,
  t1.nom AS nom_15,
  t1.tel AS tel_16
FROM
  fos_user t0
  LEFT JOIN utilisateur_site t1 ON t0.id = t1.id
WHERE
  t0.id = ?

SELECT t0.id AS id_2, t0.username AS username_3, t0.username_canonical AS username_canonical_4, t0.email AS email_5, t0.email_canonical AS email_canonical_6, t0.enabled AS enabled_7, t0.salt AS salt_8, t0.password AS password_9, t0.last_login AS last_login_10, t0.confirmation_token AS confirmation_token_11, t0.password_requested_at AS password_requested_at_12, t0.roles AS roles_13, t0.discr, t1.prenom AS prenom_14, t1.nom AS nom_15, t1.tel AS tel_16 FROM fos_user t0 LEFT JOIN utilisateur_site t1 ON t0.id = t1.id WHERE t0.id = 978;

SELECT
  t0.id AS id_2,
  t0.username AS username_3,
  t0.username_canonical AS username_canonical_4,
  t0.email AS email_5,
  t0.email_canonical AS email_canonical_6,
  t0.enabled AS enabled_7,
  t0.salt AS salt_8,
  t0.password AS password_9,
  t0.last_login AS last_login_10,
  t0.confirmation_token AS confirmation_token_11,
  t0.password_requested_at AS password_requested_at_12,
  t0.roles AS roles_13,
  t0.discr,
  t1.prenom AS prenom_14,
  t1.nom AS nom_15,
  t1.tel AS tel_16
FROM
  fos_user t0
  LEFT JOIN utilisateur_site t1 ON t0.id = t1.id
WHERE
  t0.id = ?

SELECT t0.id AS id_2, t0.username AS username_3, t0.username_canonical AS username_canonical_4, t0.email AS email_5, t0.email_canonical AS email_canonical_6, t0.enabled AS enabled_7, t0.salt AS salt_8, t0.password AS password_9, t0.last_login AS last_login_10, t0.confirmation_token AS confirmation_token_11, t0.password_requested_at AS password_requested_at_12, t0.roles AS roles_13, t0.discr, t1.prenom AS prenom_14, t1.nom AS nom_15, t1.tel AS tel_16 FROM fos_user t0 LEFT JOIN utilisateur_site t1 ON t0.id = t1.id WHERE t0.id = 533;

SELECT
  t0.id AS id_2,
  t0.username AS username_3,
  t0.username_canonical AS username_canonical_4,
  t0.email AS email_5,
  t0.email_canonical AS email_canonical_6,
  t0.enabled AS enabled_7,
  t0.salt AS salt_8,
  t0.password AS password_9,
  t0.last_login AS last_login_10,
  t0.confirmation_token AS confirmation_token_11,
  t0.password_requested_at AS password_requested_at_12,
  t0.roles AS roles_13,
  t0.discr,
  t1.prenom AS prenom_14,
  t1.nom AS nom_15,
  t1.tel AS tel_16
FROM
  fos_user t0
  LEFT JOIN utilisateur_site t1 ON t0.id = t1.id
WHERE
  t0.id = ?

SELECT t0.id AS id_2, t0.username AS username_3, t0.username_canonical AS username_canonical_4, t0.email AS email_5, t0.email_canonical AS email_canonical_6, t0.enabled AS enabled_7, t0.salt AS salt_8, t0.password AS password_9, t0.last_login AS last_login_10, t0.confirmation_token AS confirmation_token_11, t0.password_requested_at AS password_requested_at_12, t0.roles AS roles_13, t0.discr, t1.prenom AS prenom_14, t1.nom AS nom_15, t1.tel AS tel_16 FROM fos_user t0 LEFT JOIN utilisateur_site t1 ON t0.id = t1.id WHERE t0.id = 983;

SELECT
  t0.id AS id_2,
  t0.username AS username_3,
  t0.username_canonical AS username_canonical_4,
  t0.email AS email_5,
  t0.email_canonical AS email_canonical_6,
  t0.enabled AS enabled_7,
  t0.salt AS salt_8,
  t0.password AS password_9,
  t0.last_login AS last_login_10,
  t0.confirmation_token AS confirmation_token_11,
  t0.password_requested_at AS password_requested_at_12,
  t0.roles AS roles_13,
  t0.discr,
  t1.prenom AS prenom_14,
  t1.nom AS nom_15,
  t1.tel AS tel_16
FROM
  fos_user t0
  LEFT JOIN utilisateur_site t1 ON t0.id = t1.id
WHERE
  t0.id = ?

SELECT t0.id AS id_2, t0.username AS username_3, t0.username_canonical AS username_canonical_4, t0.email AS email_5, t0.email_canonical AS email_canonical_6, t0.enabled AS enabled_7, t0.salt AS salt_8, t0.password AS password_9, t0.last_login AS last_login_10, t0.confirmation_token AS confirmation_token_11, t0.password_requested_at AS password_requested_at_12, t0.roles AS roles_13, t0.discr, t1.prenom AS prenom_14, t1.nom AS nom_15, t1.tel AS tel_16 FROM fos_user t0 LEFT JOIN utilisateur_site t1 ON t0.id = t1.id WHERE t0.id = 982;

SELECT
  t0.id AS id_2,
  t0.username AS username_3,
  t0.username_canonical AS username_canonical_4,
  t0.email AS email_5,
  t0.email_canonical AS email_canonical_6,
  t0.enabled AS enabled_7,
  t0.salt AS salt_8,
  t0.password AS password_9,
  t0.last_login AS last_login_10,
  t0.confirmation_token AS confirmation_token_11,
  t0.password_requested_at AS password_requested_at_12,
  t0.roles AS roles_13,
  t0.discr,
  t1.prenom AS prenom_14,
  t1.nom AS nom_15,
  t1.tel AS tel_16
FROM
  fos_user t0
  LEFT JOIN utilisateur_site t1 ON t0.id = t1.id
WHERE
  t0.id = ?

SELECT t0.id AS id_2, t0.username AS username_3, t0.username_canonical AS username_canonical_4, t0.email AS email_5, t0.email_canonical AS email_canonical_6, t0.enabled AS enabled_7, t0.salt AS salt_8, t0.password AS password_9, t0.last_login AS last_login_10, t0.confirmation_token AS confirmation_token_11, t0.password_requested_at AS password_requested_at_12, t0.roles AS roles_13, t0.discr, t1.prenom AS prenom_14, t1.nom AS nom_15, t1.tel AS tel_16 FROM fos_user t0 LEFT JOIN utilisateur_site t1 ON t0.id = t1.id WHERE t0.id = 38;

SELECT
  t0.id AS id_2,
  t0.username AS username_3,
  t0.username_canonical AS username_canonical_4,
  t0.email AS email_5,
  t0.email_canonical AS email_canonical_6,
  t0.enabled AS enabled_7,
  t0.salt AS salt_8,
  t0.password AS password_9,
  t0.last_login AS last_login_10,
  t0.confirmation_token AS confirmation_token_11,
  t0.password_requested_at AS password_requested_at_12,
  t0.roles AS roles_13,
  t0.discr,
  t1.prenom AS prenom_14,
  t1.nom AS nom_15,
  t1.tel AS tel_16
FROM
  fos_user t0
  LEFT JOIN utilisateur_site t1 ON t0.id = t1.id
WHERE
  t0.id = ?

SELECT t0.id AS id_2, t0.username AS username_3, t0.username_canonical AS username_canonical_4, t0.email AS email_5, t0.email_canonical AS email_canonical_6, t0.enabled AS enabled_7, t0.salt AS salt_8, t0.password AS password_9, t0.last_login AS last_login_10, t0.confirmation_token AS confirmation_token_11, t0.password_requested_at AS password_requested_at_12, t0.roles AS roles_13, t0.discr, t1.prenom AS prenom_14, t1.nom AS nom_15, t1.tel AS tel_16 FROM fos_user t0 LEFT JOIN utilisateur_site t1 ON t0.id = t1.id WHERE t0.id = 324;

SELECT
  t0.id AS id_2,
  t0.username AS username_3,
  t0.username_canonical AS username_canonical_4,
  t0.email AS email_5,
  t0.email_canonical AS email_canonical_6,
  t0.enabled AS enabled_7,
  t0.salt AS salt_8,
  t0.password AS password_9,
  t0.last_login AS last_login_10,
  t0.confirmation_token AS confirmation_token_11,
  t0.password_requested_at AS password_requested_at_12,
  t0.roles AS roles_13,
  t0.discr,
  t1.prenom AS prenom_14,
  t1.nom AS nom_15,
  t1.tel AS tel_16
FROM
  fos_user t0
  LEFT JOIN utilisateur_site t1 ON t0.id = t1.id
WHERE
  t0.id = ?

SELECT t0.id AS id_2, t0.username AS username_3, t0.username_canonical AS username_canonical_4, t0.email AS email_5, t0.email_canonical AS email_canonical_6, t0.enabled AS enabled_7, t0.salt AS salt_8, t0.password AS password_9, t0.last_login AS last_login_10, t0.confirmation_token AS confirmation_token_11, t0.password_requested_at AS password_requested_at_12, t0.roles AS roles_13, t0.discr, t1.prenom AS prenom_14, t1.nom AS nom_15, t1.tel AS tel_16 FROM fos_user t0 LEFT JOIN utilisateur_site t1 ON t0.id = t1.id WHERE t0.id = 976;

SELECT
  t0.id AS id_2,
  t0.username AS username_3,
  t0.username_canonical AS username_canonical_4,
  t0.email AS email_5,
  t0.email_canonical AS email_canonical_6,
  t0.enabled AS enabled_7,
  t0.salt AS salt_8,
  t0.password AS password_9,
  t0.last_login AS last_login_10,
  t0.confirmation_token AS confirmation_token_11,
  t0.password_requested_at AS password_requested_at_12,
  t0.roles AS roles_13,
  t0.discr,
  t1.prenom AS prenom_14,
  t1.nom AS nom_15,
  t1.tel AS tel_16
FROM
  fos_user t0
  LEFT JOIN utilisateur_site t1 ON t0.id = t1.id
WHERE
  t0.id = ?

SELECT t0.id AS id_2, t0.username AS username_3, t0.username_canonical AS username_canonical_4, t0.email AS email_5, t0.email_canonical AS email_canonical_6, t0.enabled AS enabled_7, t0.salt AS salt_8, t0.password AS password_9, t0.last_login AS last_login_10, t0.confirmation_token AS confirmation_token_11, t0.password_requested_at AS password_requested_at_12, t0.roles AS roles_13, t0.discr, t1.prenom AS prenom_14, t1.nom AS nom_15, t1.tel AS tel_16 FROM fos_user t0 LEFT JOIN utilisateur_site t1 ON t0.id = t1.id WHERE t0.id = 977;

SELECT
  t0.id AS id_2,
  t0.username AS username_3,
  t0.username_canonical AS username_canonical_4,
  t0.email AS email_5,
  t0.email_canonical AS email_canonical_6,
  t0.enabled AS enabled_7,
  t0.salt AS salt_8,
  t0.password AS password_9,
  t0.last_login AS last_login_10,
  t0.confirmation_token AS confirmation_token_11,
  t0.password_requested_at AS password_requested_at_12,
  t0.roles AS roles_13,
  t0.discr,
  t1.prenom AS prenom_14,
  t1.nom AS nom_15,
  t1.tel AS tel_16
FROM
  fos_user t0
  LEFT JOIN utilisateur_site t1 ON t0.id = t1.id
WHERE
  t0.id = ?

SELECT t0.id AS id_2, t0.username AS username_3, t0.username_canonical AS username_canonical_4, t0.email AS email_5, t0.email_canonical AS email_canonical_6, t0.enabled AS enabled_7, t0.salt AS salt_8, t0.password AS password_9, t0.last_login AS last_login_10, t0.confirmation_token AS confirmation_token_11, t0.password_requested_at AS password_requested_at_12, t0.roles AS roles_13, t0.discr, t1.prenom AS prenom_14, t1.nom AS nom_15, t1.tel AS tel_16 FROM fos_user t0 LEFT JOIN utilisateur_site t1 ON t0.id = t1.id WHERE t0.id = 825;

SELECT
  t0.id AS id_2,
  t0.username AS username_3,
  t0.username_canonical AS username_canonical_4,
  t0.email AS email_5,
  t0.email_canonical AS email_canonical_6,
  t0.enabled AS enabled_7,
  t0.salt AS salt_8,
  t0.password AS password_9,
  t0.last_login AS last_login_10,
  t0.confirmation_token AS confirmation_token_11,
  t0.password_requested_at AS password_requested_at_12,
  t0.roles AS roles_13,
  t0.discr,
  t1.prenom AS prenom_14,
  t1.nom AS nom_15,
  t1.tel AS tel_16
FROM
  fos_user t0
  LEFT JOIN utilisateur_site t1 ON t0.id = t1.id
WHERE
  t0.id = ?

SELECT t0.id AS id_2, t0.username AS username_3, t0.username_canonical AS username_canonical_4, t0.email AS email_5, t0.email_canonical AS email_canonical_6, t0.enabled AS enabled_7, t0.salt AS salt_8, t0.password AS password_9, t0.last_login AS last_login_10, t0.confirmation_token AS confirmation_token_11, t0.password_requested_at AS password_requested_at_12, t0.roles AS roles_13, t0.discr, t1.prenom AS prenom_14, t1.nom AS nom_15, t1.tel AS tel_16 FROM fos_user t0 LEFT JOIN utilisateur_site t1 ON t0.id = t1.id WHERE t0.id = 979;

SELECT
  t0.id AS id_2,
  t0.username AS username_3,
  t0.username_canonical AS username_canonical_4,
  t0.email AS email_5,
  t0.email_canonical AS email_canonical_6,
  t0.enabled AS enabled_7,
  t0.salt AS salt_8,
  t0.password AS password_9,
  t0.last_login AS last_login_10,
  t0.confirmation_token AS confirmation_token_11,
  t0.password_requested_at AS password_requested_at_12,
  t0.roles AS roles_13,
  t0.discr,
  t1.prenom AS prenom_14,
  t1.nom AS nom_15,
  t1.tel AS tel_16
FROM
  fos_user t0
  LEFT JOIN utilisateur_site t1 ON t0.id = t1.id
WHERE
  t0.id = ?

SELECT t0.id AS id_2, t0.username AS username_3, t0.username_canonical AS username_canonical_4, t0.email AS email_5, t0.email_canonical AS email_canonical_6, t0.enabled AS enabled_7, t0.salt AS salt_8, t0.password AS password_9, t0.last_login AS last_login_10, t0.confirmation_token AS confirmation_token_11, t0.password_requested_at AS password_requested_at_12, t0.roles AS roles_13, t0.discr, t1.prenom AS prenom_14, t1.nom AS nom_15, t1.tel AS tel_16 FROM fos_user t0 LEFT JOIN utilisateur_site t1 ON t0.id = t1.id WHERE t0.id = 909;

SELECT
  t0.id AS id_2,
  t0.username AS username_3,
  t0.username_canonical AS username_canonical_4,
  t0.email AS email_5,
  t0.email_canonical AS email_canonical_6,
  t0.enabled AS enabled_7,
  t0.salt AS salt_8,
  t0.password AS password_9,
  t0.last_login AS last_login_10,
  t0.confirmation_token AS confirmation_token_11,
  t0.password_requested_at AS password_requested_at_12,
  t0.roles AS roles_13,
  t0.discr,
  t1.prenom AS prenom_14,
  t1.nom AS nom_15,
  t1.tel AS tel_16
FROM
  fos_user t0
  LEFT JOIN utilisateur_site t1 ON t0.id = t1.id
WHERE
  t0.id = ?

SELECT t0.id AS id_2, t0.username AS username_3, t0.username_canonical AS username_canonical_4, t0.email AS email_5, t0.email_canonical AS email_canonical_6, t0.enabled AS enabled_7, t0.salt AS salt_8, t0.password AS password_9, t0.last_login AS last_login_10, t0.confirmation_token AS confirmation_token_11, t0.password_requested_at AS password_requested_at_12, t0.roles AS roles_13, t0.discr, t1.prenom AS prenom_14, t1.nom AS nom_15, t1.tel AS tel_16 FROM fos_user t0 LEFT JOIN utilisateur_site t1 ON t0.id = t1.id WHERE t0.id = 995;

SELECT
  t0.id AS id_2,
  t0.username AS username_3,
  t0.username_canonical AS username_canonical_4,
  t0.email AS email_5,
  t0.email_canonical AS email_canonical_6,
  t0.enabled AS enabled_7,
  t0.salt AS salt_8,
  t0.password AS password_9,
  t0.last_login AS last_login_10,
  t0.confirmation_token AS confirmation_token_11,
  t0.password_requested_at AS password_requested_at_12,
  t0.roles AS roles_13,
  t0.discr,
  t1.prenom AS prenom_14,
  t1.nom AS nom_15,
  t1.tel AS tel_16
FROM
  fos_user t0
  LEFT JOIN utilisateur_site t1 ON t0.id = t1.id
WHERE
  t0.id = ?

SELECT t0.id AS id_2, t0.username AS username_3, t0.username_canonical AS username_canonical_4, t0.email AS email_5, t0.email_canonical AS email_canonical_6, t0.enabled AS enabled_7, t0.salt AS salt_8, t0.password AS password_9, t0.last_login AS last_login_10, t0.confirmation_token AS confirmation_token_11, t0.password_requested_at AS password_requested_at_12, t0.roles AS roles_13, t0.discr, t1.prenom AS prenom_14, t1.nom AS nom_15, t1.tel AS tel_16 FROM fos_user t0 LEFT JOIN utilisateur_site t1 ON t0.id = t1.id WHERE t0.id = 1208;

SELECT
  t0.id AS id_2,
  t0.username AS username_3,
  t0.username_canonical AS username_canonical_4,
  t0.email AS email_5,
  t0.email_canonical AS email_canonical_6,
  t0.enabled AS enabled_7,
  t0.salt AS salt_8,
  t0.password AS password_9,
  t0.last_login AS last_login_10,
  t0.confirmation_token AS confirmation_token_11,
  t0.password_requested_at AS password_requested_at_12,
  t0.roles AS roles_13,
  t0.discr,
  t1.prenom AS prenom_14,
  t1.nom AS nom_15,
  t1.tel AS tel_16
FROM
  fos_user t0
  LEFT JOIN utilisateur_site t1 ON t0.id = t1.id
WHERE
  t0.id = ?

SELECT t0.id AS id_2, t0.username AS username_3, t0.username_canonical AS username_canonical_4, t0.email AS email_5, t0.email_canonical AS email_canonical_6, t0.enabled AS enabled_7, t0.salt AS salt_8, t0.password AS password_9, t0.last_login AS last_login_10, t0.confirmation_token AS confirmation_token_11, t0.password_requested_at AS password_requested_at_12, t0.roles AS roles_13, t0.discr, t1.prenom AS prenom_14, t1.nom AS nom_15, t1.tel AS tel_16 FROM fos_user t0 LEFT JOIN utilisateur_site t1 ON t0.id = t1.id WHERE t0.id = 1209;

SELECT
  MIN(o0_.ca12mois_montant) AS sclr_0
FROM
  offre o0_
WHERE
  o0_.display_site = 1
  AND o0_.archive = 0

SELECT MIN(o0_.ca12mois_montant) AS sclr_0 FROM offre o0_ WHERE o0_.display_site = 1 AND o0_.archive = 0;

SELECT
  MAX(o0_.ca12mois_montant) AS sclr_0
FROM
  offre o0_
WHERE
  o0_.display_site = 1
  AND o0_.archive = 0

SELECT MAX(o0_.ca12mois_montant) AS sclr_0 FROM offre o0_ WHERE o0_.display_site = 1 AND o0_.archive = 0;

SELECT
  r0_.id AS id_0,
  r0_.nom AS nom_1,
  r0_.abreviation AS abreviation_2,
  r0_.code AS code_3,
  r0_.centroid AS centroid_4,
  r0_.position AS position_5
FROM
  region r0_
ORDER BY
  r0_.nom ASC

SELECT r0_.id AS id_0, r0_.nom AS nom_1, r0_.abreviation AS abreviation_2, r0_.code AS code_3, r0_.centroid AS centroid_4, r0_.position AS position_5 FROM region r0_ ORDER BY r0_.nom ASC;