Symfony Profiler

SELECT
  id,
  code
FROM
  langue
WHERE
  actif = 1
  and (
    supprime = 0
    or supprime IS NULL
  )

SELECT id, code FROM langue WHERE actif = 1 and (supprime = 0 or supprime IS NULL);

SELECT
  versionapp,
  DATE_FORMAT(
    datemajversion, '%d/%m/%Y %H:%i'
  ) AS datemajversion
FROM
  parametre
WHERE
  (
    supprime = 0
    or supprime IS NULL
  )

SELECT versionapp, DATE_FORMAT(datemajversion, '%d/%m/%Y %H:%i') AS datemajversion FROM parametre WHERE (supprime = 0 or supprime IS NULL);

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.usermaj AS usermaj_3,
  t0.datemajutc AS datemajutc_4,
  t0.supprime AS supprime_5,
  t0.idgestion AS idgestion_6,
  t0.idmaitre AS idmaitre_7,
  t0.idrelay AS idrelay_8
FROM
  typeticket t0
WHERE
  t0.libelle = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.usermaj AS usermaj_3, t0.datemajutc AS datemajutc_4, t0.supprime AS supprime_5, t0.idgestion AS idgestion_6, t0.idmaitre AS idmaitre_7, t0.idrelay AS idrelay_8 FROM typeticket t0 WHERE t0.libelle = 'WhatsApp' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.usermaj AS usermaj_3,
  t0.datemajutc AS datemajutc_4,
  t0.supprime AS supprime_5,
  t0.idgestion AS idgestion_6,
  t0.idmaitre AS idmaitre_7,
  t0.idrelay AS idrelay_8
FROM
  typeticket t0
WHERE
  t0.libelle = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.usermaj AS usermaj_3, t0.datemajutc AS datemajutc_4, t0.supprime AS supprime_5, t0.idgestion AS idgestion_6, t0.idmaitre AS idmaitre_7, t0.idrelay AS idrelay_8 FROM typeticket t0 WHERE t0.libelle = 'WhatsApp' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.usermaj AS usermaj_3,
  t0.datemajutc AS datemajutc_4,
  t0.supprime AS supprime_5,
  t0.idgestion AS idgestion_6,
  t0.idmaitre AS idmaitre_7,
  t0.idrelay AS idrelay_8
FROM
  typeticket t0
WHERE
  t0.libelle = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.usermaj AS usermaj_3, t0.datemajutc AS datemajutc_4, t0.supprime AS supprime_5, t0.idgestion AS idgestion_6, t0.idmaitre AS idmaitre_7, t0.idrelay AS idrelay_8 FROM typeticket t0 WHERE t0.libelle = 'Mail' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.usermaj AS usermaj_3,
  t0.datemajutc AS datemajutc_4,
  t0.supprime AS supprime_5,
  t0.idgestion AS idgestion_6,
  t0.idmaitre AS idmaitre_7,
  t0.idrelay AS idrelay_8
FROM
  typeticket t0
WHERE
  t0.libelle = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.usermaj AS usermaj_3, t0.datemajutc AS datemajutc_4, t0.supprime AS supprime_5, t0.idgestion AS idgestion_6, t0.idmaitre AS idmaitre_7, t0.idrelay AS idrelay_8 FROM typeticket t0 WHERE t0.libelle = 'Application' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.numserie AS numserie_2,
  t0.type AS type_3,
  t0.numwhatsapp AS numwhatsapp_4,
  t0.pays AS pays_5,
  t0.site AS site_6,
  t0.numsim AS numsim_7,
  t0.datederniereinfo AS datederniereinfo_8,
  t0.datemiseenservice AS datemiseenservice_9,
  t0.alive AS alive_10,
  t0.o2h2 AS o2h2_11,
  t0.h2r AS h2r_12,
  t0.comp AS comp_13,
  t0.nivelec AS nivelec_14,
  t0.power AS power_15,
  t0.ximg AS ximg_16,
  t0.yimg AS yimg_17,
  t0.datesendalive AS datesendalive_18,
  t0.nivdiw AS nivdiw_19,
  t0.codeassociation AS codeassociation_20,
  t0.versiongensrelay AS versiongensrelay_21,
  t0.typemodule AS typemodule_22,
  t0.datederniereinfoip AS datederniereinfoip_23,
  t0.datederniereinfosms AS datederniereinfosms_24,
  t0.clepublique AS clepublique_25,
  t0.aliveip AS aliveip_26,
  t0.alivesms AS alivesms_27,
  t0.datesendaliveip AS datesendaliveip_28,
  t0.datesendalivesms AS datesendalivesms_29,
  t0.visuel AS visuel_30,
  t0.tempvisuel AS tempvisuel_31,
  t0.dateconf AS dateconf_32,
  t0.usermaj AS usermaj_33,
  t0.datemajutc AS datemajutc_34,
  t0.supprime AS supprime_35,
  t0.connexiongestion AS connexiongestion_36,
  t0.idgestion AS idgestion_37,
  t0.idmaitre AS idmaitre_38,
  t0.idrelay AS idrelay_39,
  t0.modelegenerateur_id AS modelegenerateur_id_40,
  t0.typemodulecomgenerateur_id AS typemodulecomgenerateur_id_41,
  t0.client_id AS client_id_42
FROM
  generateur t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.numserie AS numserie_2, t0.type AS type_3, t0.numwhatsapp AS numwhatsapp_4, t0.pays AS pays_5, t0.site AS site_6, t0.numsim AS numsim_7, t0.datederniereinfo AS datederniereinfo_8, t0.datemiseenservice AS datemiseenservice_9, t0.alive AS alive_10, t0.o2h2 AS o2h2_11, t0.h2r AS h2r_12, t0.comp AS comp_13, t0.nivelec AS nivelec_14, t0.power AS power_15, t0.ximg AS ximg_16, t0.yimg AS yimg_17, t0.datesendalive AS datesendalive_18, t0.nivdiw AS nivdiw_19, t0.codeassociation AS codeassociation_20, t0.versiongensrelay AS versiongensrelay_21, t0.typemodule AS typemodule_22, t0.datederniereinfoip AS datederniereinfoip_23, t0.datederniereinfosms AS datederniereinfosms_24, t0.clepublique AS clepublique_25, t0.aliveip AS aliveip_26, t0.alivesms AS alivesms_27, t0.datesendaliveip AS datesendaliveip_28, t0.datesendalivesms AS datesendalivesms_29, t0.visuel AS visuel_30, t0.tempvisuel AS tempvisuel_31, t0.dateconf AS dateconf_32, t0.usermaj AS usermaj_33, t0.datemajutc AS datemajutc_34, t0.supprime AS supprime_35, t0.connexiongestion AS connexiongestion_36, t0.idgestion AS idgestion_37, t0.idmaitre AS idmaitre_38, t0.idrelay AS idrelay_39, t0.modelegenerateur_id AS modelegenerateur_id_40, t0.typemodulecomgenerateur_id AS typemodulecomgenerateur_id_41, t0.client_id AS client_id_42 FROM generateur t0 WHERE t0.id = '138';

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.username_canonical AS username_canonical_3,
  t0.email AS email_4,
  t0.email_canonical AS email_canonical_5,
  t0.enabled AS enabled_6,
  t0.salt AS salt_7,
  t0.password AS password_8,
  t0.last_login AS last_login_9,
  t0.locked AS locked_10,
  t0.expired AS expired_11,
  t0.expires_at AS expires_at_12,
  t0.confirmation_token AS confirmation_token_13,
  t0.password_requested_at AS password_requested_at_14,
  t0.roles AS roles_15,
  t0.credentials_expired AS credentials_expired_16,
  t0.credentials_expire_at AS credentials_expire_at_17,
  t0.nom AS nom_18,
  t0.prenom AS prenom_19,
  t0.administrateur AS administrateur_20,
  t0.codelangue AS codelangue_21,
  t0.numsim AS numsim_22,
  t0.alertesms AS alertesms_23,
  t0.alertemail AS alertemail_24,
  t0.supadmin AS supadmin_25,
  t0.usermaj AS usermaj_26,
  t0.datemajutc AS datemajutc_27,
  t0.supprime AS supprime_28,
  t0.idgestion AS idgestion_29,
  t0.idmaitre AS idmaitre_30,
  t0.idrelay AS idrelay_31,
  t0.client_id AS client_id_32
FROM
  user t0
WHERE
  t0.id = ?
  AND t0.username = ?
  AND t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.username AS username_2, t0.username_canonical AS username_canonical_3, t0.email AS email_4, t0.email_canonical AS email_canonical_5, t0.enabled AS enabled_6, t0.salt AS salt_7, t0.password AS password_8, t0.last_login AS last_login_9, t0.locked AS locked_10, t0.expired AS expired_11, t0.expires_at AS expires_at_12, t0.confirmation_token AS confirmation_token_13, t0.password_requested_at AS password_requested_at_14, t0.roles AS roles_15, t0.credentials_expired AS credentials_expired_16, t0.credentials_expire_at AS credentials_expire_at_17, t0.nom AS nom_18, t0.prenom AS prenom_19, t0.administrateur AS administrateur_20, t0.codelangue AS codelangue_21, t0.numsim AS numsim_22, t0.alertesms AS alertesms_23, t0.alertemail AS alertemail_24, t0.supadmin AS supadmin_25, t0.usermaj AS usermaj_26, t0.datemajutc AS datemajutc_27, t0.supprime AS supprime_28, t0.idgestion AS idgestion_29, t0.idmaitre AS idmaitre_30, t0.idrelay AS idrelay_31, t0.client_id AS client_id_32 FROM user t0 WHERE t0.id = '118' AND t0.username = 'solene' AND t0.email = 'solene@qosinus.com' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.idexterne AS idexterne_2,
  t0.objet AS objet_3,
  t0.datecrea AS datecrea_4,
  t0.datederniermessage AS datederniermessage_5,
  t0.datemaj AS datemaj_6,
  t0.datecloture AS datecloture_7,
  t0.cloture AS cloture_8,
  t0.usermaj AS usermaj_9,
  t0.datemajutc AS datemajutc_10,
  t0.supprime AS supprime_11,
  t0.typeticket_id AS typeticket_id_12,
  t0.utilisateurmaj_id AS utilisateurmaj_id_13,
  t0.utilisateurcloture_id AS utilisateurcloture_id_14,
  t0.generateur_id AS generateur_id_15
FROM
  ticket t0
WHERE
  t0.generateur_id = ?
  AND t0.cloture = ?
ORDER BY
  t0.datemaj DESC

SELECT t0.id AS id_1, t0.idexterne AS idexterne_2, t0.objet AS objet_3, t0.datecrea AS datecrea_4, t0.datederniermessage AS datederniermessage_5, t0.datemaj AS datemaj_6, t0.datecloture AS datecloture_7, t0.cloture AS cloture_8, t0.usermaj AS usermaj_9, t0.datemajutc AS datemajutc_10, t0.supprime AS supprime_11, t0.typeticket_id AS typeticket_id_12, t0.utilisateurmaj_id AS utilisateurmaj_id_13, t0.utilisateurcloture_id AS utilisateurcloture_id_14, t0.generateur_id AS generateur_id_15 FROM ticket t0 WHERE t0.generateur_id = 138 AND t0.cloture = '0' ORDER BY t0.datemaj DESC;

SELECT
  t0.id AS id_1,
  t0.idexterne AS idexterne_2,
  t0.nom AS nom_3,
  t0.prenom AS prenom_4,
  t0.email AS email_5,
  t0.telephone AS telephone_6,
  t0.message AS message_7,
  t0.datecrea AS datecrea_8,
  t0.fromsagim AS fromsagim_9,
  t0.usermaj AS usermaj_10,
  t0.datemajutc AS datemajutc_11,
  t0.supprime AS supprime_12,
  t0.typeticketmessage_id AS typeticketmessage_id_13,
  t0.ticket_id AS ticket_id_14
FROM
  ticketmessage t0
WHERE
  t0.ticket_id = ?
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.idexterne AS idexterne_2, t0.nom AS nom_3, t0.prenom AS prenom_4, t0.email AS email_5, t0.telephone AS telephone_6, t0.message AS message_7, t0.datecrea AS datecrea_8, t0.fromsagim AS fromsagim_9, t0.usermaj AS usermaj_10, t0.datemajutc AS datemajutc_11, t0.supprime AS supprime_12, t0.typeticketmessage_id AS typeticketmessage_id_13, t0.ticket_id AS ticket_id_14 FROM ticketmessage t0 WHERE t0.ticket_id = 178 ORDER BY t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.idexterne AS idexterne_2,
  t0.objet AS objet_3,
  t0.datecrea AS datecrea_4,
  t0.datederniermessage AS datederniermessage_5,
  t0.datemaj AS datemaj_6,
  t0.datecloture AS datecloture_7,
  t0.cloture AS cloture_8,
  t0.usermaj AS usermaj_9,
  t0.datemajutc AS datemajutc_10,
  t0.supprime AS supprime_11,
  t0.typeticket_id AS typeticket_id_12,
  t0.utilisateurmaj_id AS utilisateurmaj_id_13,
  t0.utilisateurcloture_id AS utilisateurcloture_id_14,
  t0.generateur_id AS generateur_id_15
FROM
  ticket t0
WHERE
  t0.generateur_id = ?
  AND t0.cloture = ?
ORDER BY
  t0.datemaj DESC

SELECT t0.id AS id_1, t0.idexterne AS idexterne_2, t0.objet AS objet_3, t0.datecrea AS datecrea_4, t0.datederniermessage AS datederniermessage_5, t0.datemaj AS datemaj_6, t0.datecloture AS datecloture_7, t0.cloture AS cloture_8, t0.usermaj AS usermaj_9, t0.datemajutc AS datemajutc_10, t0.supprime AS supprime_11, t0.typeticket_id AS typeticket_id_12, t0.utilisateurmaj_id AS utilisateurmaj_id_13, t0.utilisateurcloture_id AS utilisateurcloture_id_14, t0.generateur_id AS generateur_id_15 FROM ticket t0 WHERE t0.generateur_id = 138 AND t0.cloture = '1' ORDER BY t0.datemaj DESC;

SELECT
  t0.id AS id_1,
  t0.idexterne AS idexterne_2,
  t0.nom AS nom_3,
  t0.prenom AS prenom_4,
  t0.email AS email_5,
  t0.telephone AS telephone_6,
  t0.message AS message_7,
  t0.datecrea AS datecrea_8,
  t0.fromsagim AS fromsagim_9,
  t0.usermaj AS usermaj_10,
  t0.datemajutc AS datemajutc_11,
  t0.supprime AS supprime_12,
  t0.typeticketmessage_id AS typeticketmessage_id_13,
  t0.ticket_id AS ticket_id_14
FROM
  ticketmessage t0
WHERE
  t0.ticket_id = ?
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.idexterne AS idexterne_2, t0.nom AS nom_3, t0.prenom AS prenom_4, t0.email AS email_5, t0.telephone AS telephone_6, t0.message AS message_7, t0.datecrea AS datecrea_8, t0.fromsagim AS fromsagim_9, t0.usermaj AS usermaj_10, t0.datemajutc AS datemajutc_11, t0.supprime AS supprime_12, t0.typeticketmessage_id AS typeticketmessage_id_13, t0.ticket_id AS ticket_id_14 FROM ticketmessage t0 WHERE t0.ticket_id = 166 ORDER BY t0.id ASC;