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\":\"91336330\"}' AND b0_.expire_at > '2025-05-25 18:36:19' 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 (401582, '{\"cmd\":\"details\",\"societe\":\"gf\",\"identifier\":\"91336330\"}', 'O:8:\"stdClass\":2:{s:4:\"data\";O:8:\"stdClass\":13:{s:3:\"uid\";s:34:\"20250312150101-467171-000091336330\";s:4:\"site\";s:30:\"https://www.lagazettefrance.fr\";s:9:\"nbannonce\";i:91336330;s:12:\"dateparution\";s:19:\"2025-03-13 13:01:48\";s:7:\"support\";s:18:\"lagazettefrance.fr\";s:12:\"isSupportWeb\";b:1;s:11:\"typeannonce\";s:15:\"AVIS DE CESSION\";s:11:\"departement\";s:19:\"76 - Seine-Maritime\";s:8:\"htmlText\";s:1339:\"<p class=\"STY17\">Par acte SSP du 03/02/2025 &agrave; PARIS, enregistr&eacute; au SIE de PARIS ST SULPICE, le 05/02/2025, Dossier n&deg;202500004305, R&eacute;f&eacute;rence 7584P61 2025 A 00484, la Soci&eacute;t&eacute; <strong>PHARMACIE MAKHOUL</strong>, SARL au capital de 10.000 &euro;, ayant son si&egrave;ge social route de dieppe - 76119 Varengeville-sur-Mer, 508 165 198 RCS de Dieppe.</p> <p class=\"STY17\">A c&eacute;d&eacute; &agrave; la <strong>SELARL PHARMACIE DE VARENGEVILLE</strong> au capital de 100.000 &euro;, ayant son si&egrave;ge social 71 route de Dieppe- 76119 Varengeville-sur-Mer, en cours d&#39;immatriculation au RCS de Dieppe, un fonds de commerce d&#39;Officine de pharmacie, comprenant les &eacute;l&eacute;ments du fonds de commerce tels qu&#39;&eacute;num&eacute;r&eacute;s dans la vente sis 71 route de Dieppe - 76119 Varengeville-sur-Mer, moyennant le prix de 580.000 &euro;.</p> <p class=\"STY17\">La date d&#39;entr&eacute;e en jouissance : 01/04/2025.</p> <p class=\"STY17\">Les oppositions sont re&ccedil;ues dans les 10 jours de la derni&egrave;re date des publicit&eacute;s l&eacute;gales aux adresses suivantes : SELARL ACW CONSEIL 137 boulevard Raspail - 75006 Paris pour la correspondance et &agrave; l&#39;Etude AUBERT LEFEBVRE et ASSOCIES 14 rue Desmarets - 76200 Dieppe pour la validit&eacute;.</p>\";s:9:\"plainText\";s:1051:\"Par acte SSP du 03/02/2025 à PARIS, enregistré au SIE de PARIS ST SULPICE, le 05/02/2025, Dossier n°202500004305, Référence 7584P61 2025 A 00484, la Société PHARMACIE MAKHOUL, SARL au capital de 10.000 €, ayant son siège social route de dieppe - 76119 Varengeville-sur-Mer, 508 165 198 RCS de Dieppe. A cédé à la SELARL PHARMACIE DE VARENGEVILLE au capital de 100.000 €, ayant son siège social 71 route de Dieppe- 76119 Varengeville-sur-Mer, en cours d\'immatriculation au RCS de Dieppe, un fonds de commerce d\'Officine de pharmacie, comprenant les éléments du fonds de commerce tels qu\'énumérés dans la vente sis 71 route de Dieppe - 76119 Varengeville-sur-Mer, moyennant le prix de 580.000 €. La date d\'entrée en jouissance : 01/04/2025. Les oppositions sont reçues dans les 10 jours de la dernière date des publicités légales aux adresses suivantes : SELARL ACW CONSEIL 137 boulevard Raspail - 75006 Paris pour la correspondance et à l\'Etude AUBERT LEFEBVRE et ASSOCIES 14 rue Desmarets - 76200 Dieppe pour la validité.\";s:4:\"logo\";N;s:13:\"jugement_date\";s:0:\"\";s:7:\"societe\";s:17:\"PHARMACIE MAKHOUL\";}s:6:\"status\";s:2:\"OK\";}', '2025-05-18 18:36:19', '2025-05-25 18:36:19');

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