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\":\"91369298\"}' AND b0_.expire_at > '2025-07-12 07:55:12' 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 (607664, '{\"cmd\":\"details\",\"societe\":\"gf\",\"identifier\":\"91369298\"}', 'O:8:\"stdClass\":2:{s:4:\"data\";O:8:\"stdClass\":13:{s:3:\"uid\";s:34:\"20250626105829-581935-000018484863\";s:4:\"site\";s:30:\"https://www.lagazettefrance.fr\";s:9:\"nbannonce\";i:91369298;s:12:\"dateparution\";s:19:\"2025-06-27 13:02:21\";s:7:\"support\";s:18:\"lagazettefrance.fr\";s:12:\"isSupportWeb\";b:1;s:11:\"typeannonce\";s:23:\"MODIFICATIONS MULTIPLES\";s:11:\"departement\";s:23:\"54 - Meurthe-et-Moselle\";s:8:\"htmlText\";s:857:\"<p class=\"STY17\"><br><strong>E.A.R.L. DE L&rsquo;ESCALE </strong><br>Entreprise Agricole &agrave; Responsabilit&eacute; Limit&eacute;e<br>Capital social&nbsp;: 198 100.00&nbsp;&euro;<br>Si&egrave;ge social&nbsp;: BOUXIERES-SOUS-FROIDMONT (54700), Ferme de l&rsquo;Alouette<br>R.C.S.&nbsp;: NANCY 514 932 771<br>Dans un proc&egrave;s-verbal en date du 1er juin 2025, l&rsquo;associ&eacute; unique de l&rsquo;E.A.R.L. DE L&rsquo;ESCALE a d&eacute;cid&eacute; la transformation de l&rsquo;E.A.R.L. en Soci&eacute;t&eacute; Civile d&rsquo;Exploitation Agricole&nbsp;:<br>Ancienne d&eacute;nomination&nbsp;: Exploitation Agricole &agrave; Responsabilit&eacute; limit&eacute;e DE L&rsquo;ESCALE.<br>Nouvelle d&eacute;nomination&nbsp;: Soci&eacute;t&eacute; Civile d&rsquo;Exploitation Agricole DE L&rsquo;ESCALE.<br>Pour avis et mention,<br>la g&eacute;rance.</p>\";s:9:\"plainText\";s:636:\"E.A.R.L. DE L’ESCALE Entreprise Agricole à Responsabilité Limitée Capital social&nbsp;: 198 100.00&nbsp;€ Siège social&nbsp;: BOUXIERES-SOUS-FROIDMONT (54700), Ferme de l’Alouette R.C.S.&nbsp;: NANCY 514 932 771 Dans un procès-verbal en date du 1er juin 2025, l’associé unique de l’E.A.R.L. DE L’ESCALE a décidé la transformation de l’E.A.R.L. en Société Civile d’Exploitation Agricole&nbsp;: Ancienne dénomination&nbsp;: Exploitation Agricole à Responsabilité limitée DE L’ESCALE. Nouvelle dénomination&nbsp;: Société Civile d’Exploitation Agricole DE L’ESCALE. Pour avis et mention, la gérance.\";s:4:\"logo\";s:28:\"18947_GP_20250626105829.jpeg\";s:13:\"jugement_date\";s:0:\"\";s:7:\"societe\";s:16:\"EARL DE L\'ESCALE\";}s:6:\"status\";s:2:\"OK\";}', '2025-07-05 07:55:12', '2025-07-12 07:55:12');

"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\":\"A220\",\"typeannonceRC\":null,\"departement\":\"54\",\"from\":null,\"to\":null,\"range\":null,\"support\":null,\"findLasts\":null,\"page\":1,\"itemsPerPage\":10,\"cmd\":\"search\",\"societe\":\"ALL\"}' AND b0_.expire_at > '2025-07-05 07:55:12' ORDER BY b0_.date_call DESC LIMIT 1;