Query Metrics
10
Database Queries
7
Different statements
67.22 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
31.78 ms (47.27%) |
2 |
update bolt_content SET status = 'held', depublished_at = :now WHERE status = 'published' AND depublished_at < :now
Parameters:
[ ":now" => Carbon\Carbon {#2691 : "2025-05-22 14:15:18" } ] |
30.78 ms (45.79%) |
2 |
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":"91346307"}" "2025-05-29 16:15:18" ] |
3.37 ms (5.01%) |
2 |
update bolt_content SET status = 'published', published_at = :now WHERE status = 'timed' AND published_at < :now
Parameters:
[ ":now" => Carbon\Carbon {#2691 : "2025-05-22 14:15:18" } ] |
0.56 ms (0.83%) |
1 |
SELECT NEXTVAL('alis_cache_id_seq')
Parameters:
[] |
0.42 ms (0.62%) |
1 |
INSERT INTO bolt_alis_cache (id, call, response, date_call, expire_at) VALUES (?, ?, ?, ?, ?)
Parameters:
[ 1 => 415848 2 => "{"cmd":"details","societe":"gf","identifier":"91346307"}" 3 => "O:8:"stdClass":2:{s:4:"data";O:8:"stdClass":13:{s:3:"uid";s:34:"20250409235502-914033-000055731198";s:4:"site";s:30:"https://www.lagazettefrance.fr";s:9:"nbannonce";i:91346307;s:12:"dateparution";s:19:"2025-04-10 13:02:13";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:"59 - Nord";s:8:"htmlText";s:286:"<p class="STY17"><strong>SAS DEMOS</strong>, 218 Rue de Lille, 59130 Lambersart, RCS LILLE MÉTROPOLE 849 450 911. Pré-presse, communication, publicité. Jugement en date du 28 mars 2025 prononçant la clôture de la procédure de liquidation judiciaire pour insuffisance d'actif .</p>";s:9:"plainText";s:248:"SAS DEMOS, 218 Rue de Lille, 59130 Lambersart, RCS LILLE MÉTROPOLE 849 450 911. Pré-presse, communication, publicité. Jugement en date du 28 mars 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:"28/03/2025";s:7:"societe";s:9:"SAS DEMOS";}s:6:"status";s:2:"OK";}" 4 => "2025-05-22 16:15:18" 5 => "2025-05-29 16:15:18" ] |
0.27 ms (0.40%) |
1 |
"COMMIT"
Parameters:
[] |
0.06 ms (0.09%) |
1 |
"START TRANSACTION"
Parameters:
[] |
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. |