Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.date_naissance AS date_naissance_4,
  t0.lieu_naissance AS lieu_naissance_5,
  t0.adresse AS adresse_6,
  t0.telephone AS telephone_7,
  t0.account_must_be_verified_before AS account_must_be_verified_before_8,
  t0.registration_token AS registration_token_9,
  t0.is_verified AS is_verified_10,
  t0.account_verified_at AS account_verified_at_11,
  t0.forgot_password_token AS forgot_password_token_12,
  t0.forgot_password_token_requested_at AS forgot_password_token_requested_at_13,
  t0.forgot_password_token_must_be_verified_before AS forgot_password_token_must_be_verified_before_14,
  t0.forgot_password_token_verified_at AS forgot_password_token_verified_at_15,
  t0.password AS password_16,
  t0.nom AS nom_17,
  t0.prenom AS prenom_18,
  t0.numero_piece_identite AS numero_piece_identite_19,
  t0.ville AS ville_20,
  t0.last_login AS last_login_21,
  t0.last_logout AS last_logout_22,
  t0.is_first_login AS is_first_login_23,
  t0.username AS username_24,
  t0.signature_file_name AS signature_file_name_25,
  t0.code_pin AS code_pin_26,
  t0.signataire_id AS signataire_id_27,
  t0.appelant_id AS appelant_id_28,
  t0.kyc_piece1 AS kyc_piece1_29,
  t0.kyc_piece2 AS kyc_piece2_30,
  t0.kyc_photo AS kyc_photo_31,
  t0.photo_profil AS photo_profil_32,
  t0.created_at AS created_at_33,
  t0.updated_at AS updated_at_34,
  t0.civilite_id AS civilite_id_35,
  t0.piece_itendite_id AS piece_itendite_id_36,
  t0.pays_id AS pays_id_37,
  t0.service_id AS service_id_38,
  t0.role_id AS role_id_39,
  t0.banque_id AS banque_id_40
FROM
  utilisateur t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.date_naissance AS date_naissance_4, t0.lieu_naissance AS lieu_naissance_5, t0.adresse AS adresse_6, t0.telephone AS telephone_7, t0.account_must_be_verified_before AS account_must_be_verified_before_8, t0.registration_token AS registration_token_9, t0.is_verified AS is_verified_10, t0.account_verified_at AS account_verified_at_11, t0.forgot_password_token AS forgot_password_token_12, t0.forgot_password_token_requested_at AS forgot_password_token_requested_at_13, t0.forgot_password_token_must_be_verified_before AS forgot_password_token_must_be_verified_before_14, t0.forgot_password_token_verified_at AS forgot_password_token_verified_at_15, t0.password AS password_16, t0.nom AS nom_17, t0.prenom AS prenom_18, t0.numero_piece_identite AS numero_piece_identite_19, t0.ville AS ville_20, t0.last_login AS last_login_21, t0.last_logout AS last_logout_22, t0.is_first_login AS is_first_login_23, t0.username AS username_24, t0.signature_file_name AS signature_file_name_25, t0.code_pin AS code_pin_26, t0.signataire_id AS signataire_id_27, t0.appelant_id AS appelant_id_28, t0.kyc_piece1 AS kyc_piece1_29, t0.kyc_piece2 AS kyc_piece2_30, t0.kyc_photo AS kyc_photo_31, t0.photo_profil AS photo_profil_32, t0.created_at AS created_at_33, t0.updated_at AS updated_at_34, t0.civilite_id AS civilite_id_35, t0.piece_itendite_id AS piece_itendite_id_36, t0.pays_id AS pays_id_37, t0.service_id AS service_id_38, t0.role_id AS role_id_39, t0.banque_id AS banque_id_40 FROM utilisateur t0 WHERE t0.id = 203;

SELECT
  d.denomination_sociale denomination,
  d.sigle,
  d.nom_commercial
FROM
  dossier_demande d
WHERE
  LOWER(d.denomination_sociale) = LOWER(:motcle)
  OR LOWER(d.nom_commercial) = LOWER(:motcle)
UNION
SELECT
  s.denomination_sociale denomination,
  s.sigle,
  s.nom_commercial
FROM
  statut s
WHERE
  LOWER(s.denomination_sociale) = LOWER(:motcle)
  OR LOWER(s.nom_commercial) = LOWER(:motcle)
UNION
SELECT
  r.nom_commercial denomination,
  null AS denomi,
  null AS sigle
FROM
  reservation r
WHERE
  LOWER(r.nom_commercial) = LOWER(:motcle)
UNION
SELECT
  a.denomination_sociale denomination,
  null AS denomi,
  null AS sigle
FROM
  archive_nom_commercial a
WHERE
  LOWER(a.denomination_sociale) = LOWER(:motcle)

SELECT d.denomination_sociale denomination,d.sigle,d.nom_commercial FROM dossier_demande d
				WHERE LOWER(d.denomination_sociale) =  LOWER('ENTREPRISE AB MATERIELS DE CONSTRUCTION') OR LOWER(d.nom_commercial) = LOWER('ENTREPRISE AB MATERIELS DE CONSTRUCTION')
			UNION 
				SELECT s.denomination_sociale denomination,s.sigle, s.nom_commercial FROM statut s
				WHERE LOWER(s.denomination_sociale) = LOWER('ENTREPRISE AB MATERIELS DE CONSTRUCTION') OR LOWER(s.nom_commercial) = LOWER('ENTREPRISE AB MATERIELS DE CONSTRUCTION')
			UNION 
				SELECT  r.nom_commercial denomination, null AS denomi, null AS sigle FROM reservation r 
				WHERE LOWER(r.nom_commercial) = LOWER('ENTREPRISE AB MATERIELS DE CONSTRUCTION') 
			UNION
				SELECT a.denomination_sociale denomination, null AS denomi, null AS sigle FROM archive_nom_commercial a
				WHERE LOWER(a.denomination_sociale) =  LOWER('ENTREPRISE AB MATERIELS DE CONSTRUCTION')  ;

SELECT
  d.denomination_sociale denomination
FROM
  dossier_demande d
WHERE
  SOUNDEX(
    LOWER(d.denomination_sociale)
  ) = SOUNDEX(
    LOWER(:motcle)
  )
  OR SOUNDEX(
    LOWER(d.nom_commercial)
  ) = SOUNDEX(
    LOWER(:motcle)
  )
UNION
SELECT
  s.denomination_sociale denomination
FROM
  statut s
WHERE
  SOUNDEX(
    LOWER(s.denomination_sociale)
  ) = SOUNDEX(
    LOWER(:motcle)
  )
  OR SOUNDEX(
    LOWER(s.nom_commercial)
  ) = SOUNDEX(
    LOWER(:motcle)
  )
UNION
SELECT
  r.nom_commercial denomination
FROM
  reservation r
WHERE
  SOUNDEX(
    LOWER(r.nom_commercial)
  ) = SOUNDEX(
    LOWER(:motcle)
  )
UNION
SELECT
  a.denomination_sociale denomination
FROM
  archive_nom_commercial a
WHERE
  SOUNDEX(
    LOWER(a.denomination_sociale)
  ) = SOUNDEX(
    LOWER(:motcle)
  )

SELECT d.denomination_sociale denomination 
				FROM dossier_demande d WHERE SOUNDEX(LOWER(d.denomination_sociale)) =  SOUNDEX(LOWER('ENTREPRISE AB MATERIELS DE CONSTRUCTION')) OR SOUNDEX(LOWER(d.nom_commercial)) = SOUNDEX(LOWER('ENTREPRISE AB MATERIELS DE CONSTRUCTION'))
			UNION 
				SELECT s.denomination_sociale denomination 
				FROM statut s WHERE SOUNDEX(LOWER(s.denomination_sociale)) = SOUNDEX(LOWER('ENTREPRISE AB MATERIELS DE CONSTRUCTION')) OR SOUNDEX(LOWER(s.nom_commercial)) = SOUNDEX(LOWER('ENTREPRISE AB MATERIELS DE CONSTRUCTION'))
			UNION 
				SELECT  r.nom_commercial denomination 
				FROM reservation r WHERE SOUNDEX(LOWER(r.nom_commercial)) = SOUNDEX(LOWER('ENTREPRISE AB MATERIELS DE CONSTRUCTION')) 
			UNION 
				SELECT  a.denomination_sociale denomination 
				FROM archive_nom_commercial a WHERE SOUNDEX(LOWER(a.denomination_sociale)) = SOUNDEX(LOWER('ENTREPRISE AB MATERIELS DE CONSTRUCTION')) ;

SELECT
  f.libelle,
  f.id,
  f.route,
  f.icon
FROM
  reference r
  INNER JOIN fonctionnalite f ON f.reference_id = r.id
  INNER JOIN groupe_fonctionnalite gf ON gf.fonctionnalite_id = f.id
  INNER JOIN groupe g ON gf.groupe_id = g.id
  INNER JOIN user_groupe ug ON ug.groupe_id = g.id
  INNER JOIN utilisateur u ON ug.utilisateur_id = u.id
WHERE
  r.code = :typeMenu
  AND u.id = :user
  AND r.isactif = 1
  AND f.isactif = 1
  AND g.isactif = 1

SELECT f.libelle, f.id,f.route, f.icon
                    FROM reference r
                    INNER JOIN fonctionnalite f ON f.reference_id = r.id
                    INNER JOIN groupe_fonctionnalite gf ON gf.fonctionnalite_id = f.id
                    INNER JOIN groupe g ON gf.groupe_id = g.id 
                    INNER JOIN user_groupe ug ON ug.groupe_id = g.id
                    INNER JOIN utilisateur u ON ug.utilisateur_id = u.id
                    WHERE r.code = 'sidebarmenu' AND u.id = 203
                        AND r.isactif = 1  AND f.isactif = 1 AND g.isactif = 1
                  
            ;

SELECT
  t0.id AS id_1,
  t0.telephone AS telephone_2,
  t0.email AS email_3,
  t0.adresse AS adresse_4
FROM
  contact t0
ORDER BY
  t0.id ASC
LIMIT
  1

SELECT t0.id AS id_1, t0.telephone AS telephone_2, t0.email AS email_3, t0.adresse AS adresse_4 FROM contact t0 ORDER BY t0.id ASC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.telephone AS telephone_2,
  t0.email AS email_3,
  t0.adresse AS adresse_4
FROM
  contact t0
ORDER BY
  t0.id ASC
LIMIT
  1

SELECT t0.id AS id_1, t0.telephone AS telephone_2, t0.email AS email_3, t0.adresse AS adresse_4 FROM contact t0 ORDER BY t0.id ASC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.telephone AS telephone_2,
  t0.email AS email_3,
  t0.adresse AS adresse_4
FROM
  contact t0
ORDER BY
  t0.id ASC
LIMIT
  1

SELECT t0.id AS id_1, t0.telephone AS telephone_2, t0.email AS email_3, t0.adresse AS adresse_4 FROM contact t0 ORDER BY t0.id ASC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.telephone AS telephone_2,
  t0.email AS email_3,
  t0.adresse AS adresse_4
FROM
  contact t0
ORDER BY
  t0.id ASC
LIMIT
  1

SELECT t0.id AS id_1, t0.telephone AS telephone_2, t0.email AS email_3, t0.adresse AS adresse_4 FROM contact t0 ORDER BY t0.id ASC LIMIT 1;