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\":\"20241018130245-929983-000091289981\"}' AND b0_.expire_at > '2025-07-29 08:39:10' 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 (687902, '{\"cmd\":\"details\",\"societe\":\"gf\",\"identifier\":\"20241018130245-929983-000091289981\"}', 'O:8:\"stdClass\":2:{s:4:\"data\";O:8:\"stdClass\":13:{s:3:\"uid\";s:34:\"20241018130245-929983-000091289981\";s:4:\"site\";s:30:\"https://www.picardiegazette.fr\";s:9:\"nbannonce\";i:91289981;s:12:\"dateparution\";s:19:\"2024-10-18 13:02:45\";s:7:\"support\";s:19:\"PICARDIE LA GAZETTE\";s:12:\"isSupportWeb\";b:1;s:11:\"typeannonce\";s:24:\"Mouvement des Dirigeants\";s:11:\"departement\";s:10:\"80 - Somme\";s:8:\"htmlText\";s:611:\"<p class=\"STY17\">La Soci&eacute;t&eacute; &laquo; KHB IMMOBILIER &raquo;, Soci&eacute;t&eacute; &agrave; Responsabilit&eacute; Limit&eacute;e, au capital de 300 Euros. Si&egrave;ge social&nbsp;: 23, rue Georges Cl&eacute;menceau 80200 PERONNE. 894.494.608 RCS AMIENS. Aux termes de l&rsquo;AGE des Associ&eacute;s en date du 14 octobre 2024, il a &eacute;t&eacute; d&eacute;cid&eacute;&nbsp;: -De prendre acte de la d&eacute;mission de Monsieur Olivier HAUDIQUET de ses fonctions de Co-g&eacute;rant. L&rsquo;article 22 des statuts en est cons&eacute;cutivement modifi&eacute;. Pour avis. La G&eacute;rance.</p>\";s:9:\"plainText\";s:458:\"La Société « KHB IMMOBILIER », Société à Responsabilité Limitée, au capital de 300 Euros. Siège social&nbsp;: 23, rue Georges Clémenceau 80200 PERONNE. 894.494.608 RCS AMIENS. Aux termes de l’AGE des Associés en date du 14 octobre 2024, il a été décidé&nbsp;: -De prendre acte de la démission de Monsieur Olivier HAUDIQUET de ses fonctions de Co-gérant. L’article 22 des statuts en est consécutivement modifié. Pour avis. La Gérance.\";s:4:\"logo\";s:28:\"12333_GP_20241017112203.jpeg\";s:13:\"jugement_date\";s:0:\"\";s:7:\"societe\";s:36:\"GL200910 KHB IMMOBILIER / DEM GERANT\";}s:6:\"status\";s:2:\"OK\";}', '2025-07-22 08:39:10', '2025-07-29 08:39:10');

"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\":null,\"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-22 08:39:10' ORDER BY b0_.date_call DESC LIMIT 1;