Symfony Profiler

update
  bolt_content
SET
  status = 'published',
  published_at = :now
WHERE
  status = 'timed'
  AND published_at < :now

update bolt_content SET status = 'published', published_at = :now  WHERE status = 'timed' AND published_at < :now;

update
  bolt_content
SET
  status = 'held',
  depublished_at = :now
WHERE
  status = 'published'
  AND depublished_at < :now

update bolt_content SET status = 'held', depublished_at = :now WHERE status = 'published' AND depublished_at < :now;

update
  bolt_content
SET
  status = 'published',
  published_at = :now
WHERE
  status = 'timed'
  AND published_at < :now

update bolt_content SET status = 'published', published_at = :now  WHERE status = 'timed' AND published_at < :now;

update
  bolt_content
SET
  status = 'held',
  depublished_at = :now
WHERE
  status = 'published'
  AND depublished_at < :now

update bolt_content SET status = 'held', depublished_at = :now WHERE status = 'published' AND depublished_at < :now;

SELECT
  b0_.id AS id_0,
  b0_.call AS call_1,
  b0_.response AS response_2,
  b0_.date_call AS date_call_3,
  b0_.expire_at AS expire_at_4
FROM
  bolt_alis_cache b0_
WHERE
  b0_.call = ?
  AND b0_.expire_at > ?
ORDER BY
  b0_.date_call DESC
LIMIT
  1

SELECT b0_.id AS id_0, b0_.call AS call_1, b0_.response AS response_2, b0_.date_call AS date_call_3, b0_.expire_at AS expire_at_4 FROM bolt_alis_cache b0_ WHERE b0_.call = '{\"cmd\":\"details\",\"societe\":\"gf\",\"identifier\":\"91357685\"}' AND b0_.expire_at > '2025-07-24 21:40:33' ORDER BY b0_.date_call DESC LIMIT 1;

SELECT
  NEXTVAL('alis_cache_id_seq')

SELECT NEXTVAL('alis_cache_id_seq');

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO bolt_alis_cache (
  id, call, response, date_call, expire_at
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO bolt_alis_cache (id, call, response, date_call, expire_at) VALUES (667836, '{\"cmd\":\"details\",\"societe\":\"gf\",\"identifier\":\"91357685\"}', 'O:8:\"stdClass\":2:{s:4:\"data\";O:8:\"stdClass\":13:{s:3:\"uid\";s:34:\"20250519182024-574454-000061066105\";s:4:\"site\";s:30:\"https://www.lagazettefrance.fr\";s:9:\"nbannonce\";i:91357685;s:12:\"dateparution\";s:19:\"2025-05-20 13:01:46\";s:7:\"support\";s:18:\"lagazettefrance.fr\";s:12:\"isSupportWeb\";b:1;s:11:\"typeannonce\";s:11:\"RESUME AAPC\";s:11:\"departement\";s:10:\"80 - Somme\";s:8:\"htmlText\";s:1489:\"<p class=\"STY24\"><strong>REGION HAUTS-DE-FRANCE</strong></p> <p class=\"TEXTE-CENTRE\">151 avenue du Pr&eacute;sident Hoover 59555 Lille Cedex</p> <p class=\"TEXTE-CENTRE\" style=\"color: rgb(0, 0, 255); font-family: verdana; text-align: center;\" title=\"STY9 - Filet\" class=\"STY9\"> </p> <p class=\"STY30\"><strong>AVIS D&#39;APPEL PUBLIC A LA CONCURRENCE</strong></p> <p class=\"STY30\"><strong>R&eacute;f&eacute;rence du march&eacute; : 2024-0103</strong></p> <p class=\"STY30\"><strong>March&eacute; de travaux -&nbsp;MAPA</strong></p> <p class=\"STY9\" style=\"color:#0000FF;font-family:\'verdana\';font-size:8;name:STY9;text-align:center;\" title=\"STY9 - Filet\" class=\"STY9\"> </p> <p class=\"STY17\"><strong>Objet du march&eacute; :</strong> Port de Boulogne-sur-Mer - Calais. Car&eacute;nage de la porte amont et g&eacute;nie civil de l&#39;&eacute;cluse Sanson &agrave; BOULOGNE SUR MER.</p> <p class=\"STY17\">L&#39;int&eacute;gralit&eacute; de cet avis publi&eacute; au BOAMP pourra &ecirc;tre t&eacute;l&eacute;charg&eacute; sur la plate-forme de d&eacute;mat&eacute;rialisation de la R&eacute;gion d&eacute;di&eacute;e aux march&eacute;s publics&nbsp;:</p> <p class=\"TEXTE-CENTRE\">https://www.hautsdefrance.fr/marches- publics-appels-d-offres/</p> <p class=\"STY17\"><strong>Date limite de r&eacute;ception des offres :</strong> 06/06/2025 &agrave; 12 H 00.</p> <p class=\"STY17\">Annonces BOAMP n&deg; 25-38046.</p> <p class=\"STY17\"><strong>Date d&#39;envoi de l&#39;avis&nbsp;:</strong> 16/05/2025.</p>\";s:9:\"plainText\";s:672:\"REGION HAUTS-DE-FRANCE 151 avenue du Président Hoover 59555 Lille Cedex <br/> AVIS D\'APPEL PUBLIC A LA CONCURRENCE Référence du marché : 2024-0103 Marché de travaux - MAPA <br/> Objet du marché : Port de Boulogne-sur-Mer - Calais. Carénage de la porte amont et génie civil de l\'écluse Sanson à BOULOGNE SUR MER. L\'intégralité de cet avis publié au BOAMP pourra être téléchargé sur la plate-forme de dématérialisation de la Région dédiée aux marchés publics : https://www.hautsdefrance.fr/marches- publics-appels-d-offres/ Date limite de réception des offres : 06/06/2025 à 12 H 00. Annonces BOAMP n° 25-38046. Date d\'envoi de l\'avis : 16/05/2025.\";s:4:\"logo\";s:30:\"613f01e35db72613f01e35db74.jpg\";s:13:\"jugement_date\";s:0:\"\";s:7:\"societe\";s:60:\"CARENAGE DE LA PORTE AMONT ET GENIE CIVIL DE L\'ECLUSE SANSON\";}s:6:\"status\";s:2:\"OK\";}', '2025-07-17 21:40:33', '2025-07-24 21:40:33');

"COMMIT"

"COMMIT";

SELECT
  b0_.id AS id_0,
  b0_.call AS call_1,
  b0_.response AS response_2,
  b0_.date_call AS date_call_3,
  b0_.expire_at AS expire_at_4
FROM
  bolt_alis_cache b0_
WHERE
  b0_.call = ?
  AND b0_.expire_at > ?
ORDER BY
  b0_.date_call DESC
LIMIT
  1

SELECT b0_.id AS id_0, b0_.call AS call_1, b0_.response AS response_2, b0_.date_call AS date_call_3, b0_.expire_at AS expire_at_4 FROM bolt_alis_cache b0_ WHERE b0_.call = '{\"reference\":null,\"typeannonce\":\"C460\",\"typeannonceRC\":null,\"departement\":\"80\",\"from\":null,\"to\":null,\"range\":null,\"support\":null,\"findLasts\":null,\"page\":1,\"itemsPerPage\":10,\"cmd\":\"search\",\"societe\":\"ALL\"}' AND b0_.expire_at > '2025-07-17 21:40:33' ORDER BY b0_.date_call DESC LIMIT 1;