Symfony Profiler

SELECT 
  t0.username AS username_1, 
  t0.username_canonical AS username_canonical_2, 
  t0.email AS email_3, 
  t0.email_canonical AS email_canonical_4, 
  t0.enabled AS enabled_5, 
  t0.salt AS salt_6, 
  t0.password AS password_7, 
  t0.last_login AS last_login_8, 
  t0.confirmation_token AS confirmation_token_9, 
  t0.password_requested_at AS password_requested_at_10, 
  t0.roles AS roles_11, 
  t0.iid_user AS iid_user_12, 
  t0.ctype_res AS ctype_res_13, 
  t0.iid_res AS iid_res_14, 
  t0.lpeutchangerprofil AS lpeutchangerprofil_15 
FROM 
  Paa_Securite.Users t0 
WHERE 
  t0.username_canonical = ? 
LIMIT 
  1

SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.iid_user AS iid_user_12, t0.ctype_res AS ctype_res_13, t0.iid_res AS iid_res_14, t0.lpeutchangerprofil AS lpeutchangerprofil_15 FROM Paa_Securite.Users t0 WHERE t0.username_canonical = 'sdsd' LIMIT 1;

SELECT 
  t0.iid_adresseIP AS iid_adresseip_1, 
  t0.ip AS ip_2, 
  t0.tbanissement AS tbanissement_3, 
  t0.bAuMoinsUneAuthentificationReussie AS baumoinsuneauthentificationreussie_4 
FROM 
  Paa_Securite.adressesIP t0 
WHERE 
  t0.ip = ? 
LIMIT 
  1

SELECT t0.iid_adresseIP AS iid_adresseip_1, t0.ip AS ip_2, t0.tbanissement AS tbanissement_3, t0.bAuMoinsUneAuthentificationReussie AS baumoinsuneauthentificationreussie_4 FROM Paa_Securite.adressesIP t0 WHERE t0.ip = '146.70.68.198' LIMIT 1;

SELECT 
  NEXTVAL(
    'paa_securite.adressesip_evenements_iid_evenement_seq'
  )

SELECT NEXTVAL('paa_securite.adressesip_evenements_iid_evenement_seq');

SELECT 
  NEXTVAL(
    'paa_securite.adressesip_iid_adresseip_seq'
  )

SELECT NEXTVAL('paa_securite.adressesip_iid_adresseip_seq');

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO Paa_Securite.adressesIP (
  iid_adresseIP, ip, tbanissement, bAuMoinsUneAuthentificationReussie
) 
VALUES 
  (?, ?, ?, ?)

INSERT INTO Paa_Securite.adressesIP (iid_adresseIP, ip, tbanissement, bAuMoinsUneAuthentificationReussie) VALUES (5622, '146.70.68.198', NULL, NULL);

INSERT INTO Paa_Securite.adressesIP_Evenements (
  iid_evenement, iadresseip, tevenement, 
  itypeevenement, cdescevenement
) 
VALUES 
  (?, ?, ?, ?, ?)

INSERT INTO Paa_Securite.adressesIP_Evenements (iid_evenement, iadresseip, tevenement, itypeevenement, cdescevenement) VALUES (1214042, 5622, '2025-04-26 01:13:23', 2, 'sdsd');

"COMMIT"

"COMMIT";

delete from 
  paa_securite.adressesIP_Evenements 
Where 
  extract(
    epoch 
    from 
      current_timestamp - tEvenement
  ) > 24 * 60 * 60;

delete from paa_securite.adressesIP_Evenements Where extract(epoch from current_timestamp - tEvenement) > 24 * 60 * 60 ;;

select 
  count(*) 
from 
  paa_securite.adressesIP_Evenements 
Where 
  iAdresseIP = : adresseIP 
  And extract(
    epoch 
    from 
      current_timestamp - tEvenement
  ) < : nbHeures * 60 * 60;

select count(*) from paa_securite.adressesIP_Evenements Where iAdresseIP = 5622 And extract(epoch from current_timestamp - tEvenement) < 24 * 60 * 60;;

delete from 
  paa_securite.adressesIP_Evenements 
Where 
  extract(
    epoch 
    from 
      current_timestamp - tEvenement
  ) > 24 * 60 * 60;

delete from paa_securite.adressesIP_Evenements Where extract(epoch from current_timestamp - tEvenement) > 24 * 60 * 60 ;;

select 
  count(*) 
from 
  paa_securite.adressesIP_Evenements 
Where 
  iAdresseIP = : adresseIP 
  And extract(
    epoch 
    from 
      current_timestamp - tEvenement
  ) < : nbHeures * 60 * 60;

select count(*) from paa_securite.adressesIP_Evenements Where iAdresseIP = 5622 And extract(epoch from current_timestamp - tEvenement) < 1 * 60 * 60;;