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\":\"91355190\"}' AND b0_.expire_at > '2025-05-28 16:07:59' 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 (410967, '{\"cmd\":\"details\",\"societe\":\"gf\",\"identifier\":\"91355190\"}', 'O:8:\"stdClass\":2:{s:4:\"data\";O:8:\"stdClass\":13:{s:3:\"uid\";s:34:\"20250512092750-219999-000032144757\";s:4:\"site\";s:30:\"https://www.lagazettefrance.fr\";s:9:\"nbannonce\";i:91355190;s:12:\"dateparution\";s:19:\"2025-05-13 20:01:02\";s:7:\"support\";s:18:\"lagazettefrance.fr\";s:12:\"isSupportWeb\";b:1;s:11:\"typeannonce\";s:16:\"CONSTITUTION SCI\";s:11:\"departement\";s:10:\"80 - Somme\";s:8:\"htmlText\";s:935:\"<p class=\"STY17\">Par acte SSP du 08/05/2025, il a &eacute;t&eacute; constitu&eacute; une SCI pr&eacute;sentant les caract&eacute;ristiques suivantes.</p> <p class=\"STY17\">D&eacute;nomination&nbsp;:</p> <p class=\"STY30\">SCI MAGE</p> <p class=\"STY17\">Objet social&nbsp;: L&#39;acquisition de tout immeuble ou terrain &agrave; b&acirc;tir ou non, l&#39;administration et l&#39;exploitation par bail, la location ou autrement desdits immeubles et de tous autres immeubles b&acirc;tis dont elle pourrait devenir propri&eacute;taire ult&eacute;rieurement, par voie d&#39;acquisition, &eacute;change, apport ou autrement. Si&egrave;ge social&nbsp;: 18 rue de l&#39;Abreuvoir 80000 AMIENS. Au capital de&nbsp;: 1&nbsp;000&nbsp;&euro;. Dur&eacute;e de la soci&eacute;t&eacute;&nbsp;: 99 ans &agrave; compter de son immatriculation au RCS d&#39;Amiens. G&eacute;rance&nbsp;: M. THOMAS Maxime demeurant 18 rue de l&#39;Abreuvoir 80000 AMIENS.</p>\";s:9:\"plainText\";s:674:\"Par acte SSP du 08/05/2025, il a été constitué une SCI présentant les caractéristiques suivantes. Dénomination : SCI MAGE Objet social : L\'acquisition de tout immeuble ou terrain à bâtir ou non, l\'administration et l\'exploitation par bail, la location ou autrement desdits immeubles et de tous autres immeubles bâtis dont elle pourrait devenir propriétaire ultérieurement, par voie d\'acquisition, échange, apport ou autrement. Siège social : 18 rue de l\'Abreuvoir 80000 AMIENS. Au capital de : 1 000 €. Durée de la société : 99 ans à compter de son immatriculation au RCS d\'Amiens. Gérance : M. THOMAS Maxime demeurant 18 rue de l\'Abreuvoir 80000 AMIENS.\";s:4:\"logo\";s:31:\"40023598_GP_20250512092750.jpeg\";s:13:\"jugement_date\";s:0:\"\";s:7:\"societe\";s:8:\"SCI MAGE\";}s:6:\"status\";s:2:\"OK\";}', '2025-05-21 16:07:59', '2025-05-28 16:07:59');

"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\":\"A108\",\"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-05-21 16:07:59' ORDER BY b0_.date_call DESC LIMIT 1;