Symfony Profiler

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\":\"91365059\"}' AND b0_.expire_at > '2025-07-23 10:54:00' ORDER BY b0_.date_call DESC LIMIT 1;

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;

SELECT
  NEXTVAL('alis_cache_id_seq')

SELECT NEXTVAL('alis_cache_id_seq');

"COMMIT"

"COMMIT";

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 (656980, '{\"cmd\":\"details\",\"societe\":\"gf\",\"identifier\":\"91365059\"}', 'O:8:\"stdClass\":2:{s:4:\"data\";O:8:\"stdClass\":13:{s:3:\"uid\";s:34:\"20250612235502-232568-000096409368\";s:4:\"site\";s:30:\"https://www.lagazettefrance.fr\";s:9:\"nbannonce\";i:91365059;s:12:\"dateparution\";s:19:\"2025-06-13 13:02:39\";s:7:\"support\";s:18:\"lagazettefrance.fr\";s:12:\"isSupportWeb\";b:1;s:11:\"typeannonce\";s:33:\"CLOTURE POUR INSUFFISANCE D\'ACTIF\";s:11:\"departement\";s:9:\"60 - Oise\";s:8:\"htmlText\";s:356:\"<p class=\"STY17\"><strong>SARL DELMOTTE FRERES</strong>, 10 Rue du Village, 60220 Broquiers, RCS BEAUVAIS 538 402 983. Plomberie, installation et entretien de chauffage, ramonage, carrelage. Jugement du tribunal de Commerce de Beauvais en date du 10 juin 2025 prononçant la clôture de la procédure de liquidation judiciaire pour insuffisance d\'actif.</p>\";s:9:\"plainText\";s:318:\"SARL DELMOTTE FRERES, 10 Rue du Village, 60220 Broquiers, RCS BEAUVAIS 538 402 983. Plomberie, installation et entretien de chauffage, ramonage, carrelage. Jugement du tribunal de Commerce de Beauvais en date du 10 juin 2025 prononçant la clôture de la procédure de liquidation judiciaire pour insuffisance d\'actif.\";s:4:\"logo\";N;s:13:\"jugement_date\";s:10:\"10/06/2025\";s:7:\"societe\";s:20:\"SARL DELMOTTE FRERES\";}s:6:\"status\";s:2:\"OK\";}', '2025-07-16 10:54:01', '2025-07-23 10:54:00');

"START TRANSACTION"

"START TRANSACTION";