Query Metrics
10
Database Queries
7
Different statements
54.77 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
26.91 ms (49.12%) |
2 |
update bolt_content SET status = 'held', depublished_at = :now WHERE status = 'published' AND depublished_at < :now
Parameters:
[ ":now" => Carbon\Carbon {#2691 : "2025-05-23 00:58:52" } ] |
23.69 ms (43.24%) |
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":"91358739"}" "2025-05-30 02:58:52" ] |
2.80 ms (5.11%) |
2 |
update bolt_content SET status = 'published', published_at = :now WHERE status = 'timed' AND published_at < :now
Parameters:
[ ":now" => Carbon\Carbon {#2691 : "2025-05-23 00:58:52" } ] |
0.74 ms (1.36%) |
1 |
SELECT NEXTVAL('alis_cache_id_seq')
Parameters:
[] |
0.34 ms (0.62%) |
1 |
INSERT INTO bolt_alis_cache (id, call, response, date_call, expire_at) VALUES (?, ?, ?, ?, ?)
Parameters:
[ 1 => 418181 2 => "{"cmd":"details","societe":"gf","identifier":"91358739"}" 3 => "O:8:"stdClass":2:{s:4:"data";O:8:"stdClass":13:{s:3:"uid";s:34:"20250521235507-528658-000058880958";s:4:"site";s:30:"https://www.lagazettefrance.fr";s:9:"nbannonce";i:91358739;s:12:"dateparution";s:19:"2025-05-22 13:02:14";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:317:"<p class="STY17"><strong>SAS DGPL DEVELOPPEMENT</strong>, 3 Clos des Cornouillers, 59270 Bailleul, RCS DUNKERQUE 949 053 490. l'acquisition, la propriété et la gestion d'un portefeuille de valeurs mobilière. Jugement prononçant la clôture de la procédure de liquidation judiciaire pour insuffisance d'actif.</p>";s:9:"plainText";s:279:"SAS DGPL DEVELOPPEMENT, 3 Clos des Cornouillers, 59270 Bailleul, RCS DUNKERQUE 949 053 490. l'acquisition, la propriété et la gestion d'un portefeuille de valeurs mobilière. Jugement 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:"15/05/2025";s:7:"societe";s:22:"SAS DGPL DEVELOPPEMENT";}s:6:"status";s:2:"OK";}" 4 => "2025-05-23 02:58:52" 5 => "2025-05-30 02:58:52" ] |
0.22 ms (0.40%) |
1 |
"COMMIT"
Parameters:
[] |
0.08 ms (0.14%) |
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. |