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\":\"91116769\"}' AND b0_.expire_at > '2025-06-13 23:02:05' 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 (499597, '{\"cmd\":\"details\",\"societe\":\"gf\",\"identifier\":\"91116769\"}', 'O:8:\"stdClass\":2:{s:4:\"data\";O:8:\"stdClass\":13:{s:3:\"uid\";s:34:\"20230307130114-130676-000091116769\";s:4:\"site\";s:26:\"https://www.gazetteoise.fr\";s:9:\"nbannonce\";i:91116769;s:12:\"dateparution\";s:19:\"2023-03-07 13:01:14\";s:7:\"support\";s:15:\"LA GAZETTE OISE\";s:12:\"isSupportWeb\";b:1;s:11:\"typeannonce\";s:11:\"RESUME AAPC\";s:11:\"departement\";s:9:\"60 - Oise\";s:8:\"htmlText\";s:1103:\"<p class=\"STY30\">REGION HAUTS-DE-FRANCE</p> <p class=\"TEXTE-CENTRE\">151 avenue 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=\"STY31\">AVIS D&#39;APPEL PUBLIC A LA CONCURRENCE</p> <p class=\"STY31\">March&eacute; de Service - Proc&eacute;dure adapt&eacute;e</p> <p class=\"STY17\">Objet du march&eacute; : 2023-0006 Assistance pour la conception, la r&eacute;alisation et la maintenance des applications et sites d&eacute;velopp&eacute;s sur la plateforme de gestion de contenu JPlatform. L&rsquo;int&eacute;gralit&eacute; de cet avis publi&eacute; au BOAMP pourra &ecirc;tre t&eacute;l&eacute;charg&eacute;e sur la plate-forme de la R&eacute;gion d&eacute;di&eacute;e aux march&eacute;s publics : https://www.hautsdefrance.fr/marches-publics-appels-d-offres/</p> <p class=\"STY17\">Date limite de r&eacute;ception des offres : 27/03/2023 &agrave; 12 H 00.</p> <p class=\"STY17\">Annonce BOAMP n&deg; 23-26174.</p> <p class=\"STY17\">Date d&rsquo;envoi de l&rsquo;avis : 27/02/2023.</p>\";s:9:\"plainText\";s:659:\"REGION HAUTS-DE-FRANCE 151 avenue Hoover 59555 Lille Cedex <br/> AVIS D\'APPEL PUBLIC A LA CONCURRENCE Marché de Service - Procédure adaptée Objet du marché : 2023-0006 Assistance pour la conception, la réalisation et la maintenance des applications et sites développés sur la plateforme de gestion de contenu JPlatform. L’intégralité de cet avis publié au BOAMP pourra être téléchargée sur la plate-forme 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 : 27/03/2023 à 12 H 00. Annonce BOAMP n° 23-26174. Date d’envoi de l’avis : 27/02/2023.\";s:4:\"logo\";s:30:\"613f01e35db72613f01e35db74.jpg\";s:13:\"jugement_date\";s:0:\"\";s:7:\"societe\";s:64:\"ASSISTANCE CONCEPTION APPLICATIONS ET SITES PLATEFORME JPLATFORM\";}s:6:\"status\";s:2:\"OK\";}', '2025-06-06 23:02:05', '2025-06-13 23:02:05');

"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\":\"60\",\"from\":null,\"to\":null,\"range\":null,\"support\":null,\"findLasts\":null,\"page\":1,\"itemsPerPage\":10,\"cmd\":\"search\",\"societe\":\"ALL\"}' AND b0_.expire_at > '2025-06-06 23:02:05' ORDER BY b0_.date_call DESC LIMIT 1;