Query Metrics
10
Database Queries
7
Different statements
51.31 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 1.97 ms |
update bolt_content SET status = 'published', published_at = :now WHERE status = 'timed' AND published_at < :now
Parameters:
[ ":now" => Carbon\Carbon {#2660 : "2025-07-04 06:38:33" } ] |
2 | 14.86 ms |
update bolt_content SET status = 'held', depublished_at = :now WHERE status = 'published' AND depublished_at < :now
Parameters:
[ ":now" => Carbon\Carbon {#2660 : "2025-07-04 06:38:33" } ] |
3 | 0.38 ms |
update bolt_content SET status = 'published', published_at = :now WHERE status = 'timed' AND published_at < :now
Parameters:
[ ":now" => Carbon\Carbon {#2690 : "2025-07-04 06:38:33" } ] |
4 | 10.85 ms |
update bolt_content SET status = 'held', depublished_at = :now WHERE status = 'published' AND depublished_at < :now
Parameters:
[ ":now" => Carbon\Carbon {#2690 : "2025-07-04 06:38:33" } ] |
5 | 13.66 ms |
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
Parameters:
[ "{"cmd":"details","societe":"gf","identifier":"91365052"}" "2025-07-11 08:38:33" ] |
6 | 0.76 ms |
SELECT NEXTVAL('alis_cache_id_seq')
Parameters:
[] |
7 | 0.20 ms |
"START TRANSACTION"
Parameters:
[] |
8 | 0.46 ms |
INSERT INTO bolt_alis_cache (id, call, response, date_call, expire_at) VALUES (?, ?, ?, ?, ?)
Parameters:
[ 1 => 604397 2 => "{"cmd":"details","societe":"gf","identifier":"91365052"}" 3 => "O:8:"stdClass":2:{s:4:"data";O:8:"stdClass":13:{s:3:"uid";s:34:"20250612235502-122228-000016820447";s:4:"site";s:30:"https://www.lagazettefrance.fr";s:9:"nbannonce";i:91365052;s:12:"dateparution";s:19:"2025-06-13 13:02:36";s:7:"support";s:18:"lagazettefrance.fr";s:12:"isSupportWeb";b:1;s:11:"typeannonce";s:14:"AUTRE DECISION";s:11:"departement";s:9:"59 - Nord";s:8:"htmlText";s:667:"<p class="STY17"><strong>SAS O'BAS PRIX</strong>, 12 Rue René Fourchet, 59245 Recquignies, RCS VALENCIENNES 894 178 466. Alimentation générale, fruits et légumes, boucherie, pain, les produits non alimentaires de consommation courante, Solderie et Destockage, bazar cosmétiques et tous objets. Suivant jugement en date du 9/05/2023, le Tribunal de Commerce de Lille métropole a ouvert une procédure de Liquidation Judiciaire. A fixé provisoirement la date de cessation des paiements au 31/12/2022. A désigné la Selas M.J.S Partners, représentée par Me Nicolas Soinne, 65 boulevard de la République 59100 Roubaix en qualité de liquidateur Judiciaire.</p>";s:9:"plainText";s:629:"SAS O'BAS PRIX, 12 Rue René Fourchet, 59245 Recquignies, RCS VALENCIENNES 894 178 466. Alimentation générale, fruits et légumes, boucherie, pain, les produits non alimentaires de consommation courante, Solderie et Destockage, bazar cosmétiques et tous objets. Suivant jugement en date du 9/05/2023, le Tribunal de Commerce de Lille métropole a ouvert une procédure de Liquidation Judiciaire. A fixé provisoirement la date de cessation des paiements au 31/12/2022. A désigné la Selas M.J.S Partners, représentée par Me Nicolas Soinne, 65 boulevard de la République 59100 Roubaix en qualité de liquidateur Judiciaire.";s:4:"logo";N;s:13:"jugement_date";s:10:"09/05/2023";s:7:"societe";s:14:"SAS O'BAS PRIX";}s:6:"status";s:2:"OK";}" 4 => "2025-07-04 08:38:33" 5 => "2025-07-11 08:38:33" ] |
9 | 0.21 ms |
"COMMIT"
Parameters:
[] |
10 | 7.97 ms |
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
Parameters:
[ "{"reference":null,"typeannonce":"A606","typeannonceRC":null,"departement":"59","from":null,"to":null,"range":null,"support":null,"findLasts":null,"page":1,"itemsPerPage":10,"cmd":"search","societe":"ALL"}" "2025-07-04 08:38:33" ] |
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
Class | Mapping errors |
---|---|
Bolt\Entity\Content | No errors. |
Bolt\Entity\Taxonomy | No errors. |
App\Entity\Entreprises\Insee\Naf | No errors. |
App\Entity\Entreprises\Insee\Naf\Naf0201 | No errors. |
App\Entity\Entreprises\Departement | No errors. |
App\Entity\Entreprises\Region | No errors. |
App\Entity\Ville\VilleApi | No errors. |
Bolt\Entity\Media | No errors. |
Bolt\Entity\Relation | No errors. |
Bolt\Entity\User | No errors. |
App\Entity\Bookmark | No errors. |
App\Entity\AbonetUserCache | No errors. |
App\Entity\AlisCache | No errors. |
Bolt\Entity\Field | No errors. |