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\":\"91352365\"}' AND b0_.expire_at > '2025-05-28 15:49:09' 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 (410917, '{\"cmd\":\"details\",\"societe\":\"gf\",\"identifier\":\"91352365\"}', 'O:8:\"stdClass\":2:{s:4:\"data\";O:8:\"stdClass\":13:{s:3:\"uid\";s:34:\"20250430144241-738979-000030750148\";s:4:\"site\";s:30:\"https://www.lagazettefrance.fr\";s:9:\"nbannonce\";i:91352365;s:12:\"dateparution\";s:19:\"2025-05-12 13:01:10\";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:1149:\"<p class=\"STY17\">Avis est donn&eacute; de la constitution le 27.04.2025 de la Soci&eacute;t&eacute; civile immobili&egrave;re <strong>&quot;ZOSACE&quot; OBJET</strong>&nbsp;: acquisition, propri&eacute;t&eacute;, administration et exploitation par bail, location ou autrement, de tous terrains et de tous immeubles ; construction et restauration de tous immeubles commerciaux, professionnels et d&#39;habitation. <strong>SIEGE SOCIAL</strong>&nbsp;: ALBERT (Somme) 11 rue Carnot <strong>DUREE</strong>&nbsp;: 99 ans <strong>CAPITAL SOCIAL</strong>&nbsp;: 1 000&nbsp;&euro; divis&eacute; en 1 000 parts sociales d&#39;un euro, constitu&eacute; uniquement d&#39;apports en num&eacute;raire <strong>CESSION DE PARTS </strong>: les parts sociales ne peuvent &ecirc;tre c&eacute;d&eacute;es, m&ecirc;me entre associ&eacute;s ou entre ascendants et descendants et conjoints qu&#39;avec l&#39;agr&eacute;ment de la collectivit&eacute; des associ&eacute;s donn&eacute; par d&eacute;cision extraordinaire. <strong>GERANT</strong>&nbsp;: M. Olivier GUFFROY demeurant &agrave; ALBERT (Somme) 11 rue Carnot <strong>IMMATRICULATION</strong>&nbsp;: RCS AMIENS</p>\";s:9:\"plainText\";s:858:\"Avis est donné de la constitution le 27.04.2025 de la Société civile immobilière \"ZOSACE\" OBJET&nbsp;: acquisition, propriété, administration et exploitation par bail, location ou autrement, de tous terrains et de tous immeubles ; construction et restauration de tous immeubles commerciaux, professionnels et d\'habitation. SIEGE SOCIAL&nbsp;: ALBERT (Somme) 11 rue Carnot DUREE&nbsp;: 99 ans CAPITAL SOCIAL&nbsp;: 1 000&nbsp;€ divisé en 1 000 parts sociales d\'un euro, constitué uniquement d\'apports en numéraire CESSION DE PARTS : les parts sociales ne peuvent être cédées, même entre associés ou entre ascendants et descendants et conjoints qu\'avec l\'agrément de la collectivité des associés donné par décision extraordinaire. GERANT&nbsp;: M. Olivier GUFFROY demeurant à ALBERT (Somme) 11 rue Carnot IMMATRICULATION&nbsp;: RCS AMIENS\";s:4:\"logo\";s:31:\"20003944_GP_20250430144241.jpeg\";s:13:\"jugement_date\";s:0:\"\";s:7:\"societe\";s:11:\"3761 ZOSACE\";}s:6:\"status\";s:2:\"OK\";}', '2025-05-21 15:49:09', '2025-05-28 15:49:09');

"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 15:49:09' ORDER BY b0_.date_call DESC LIMIT 1;