Query Metrics
10
Database Queries
7
Different statements
57.83 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 2.49 ms |
update bolt_content SET status = 'published', published_at = :now WHERE status = 'timed' AND published_at < :now
Parameters:
[ ":now" => Carbon\Carbon {#2691 : "2025-05-22 03:14:58" } ] |
2 | 14.56 ms |
update bolt_content SET status = 'held', depublished_at = :now WHERE status = 'published' AND depublished_at < :now
Parameters:
[ ":now" => Carbon\Carbon {#2691 : "2025-05-22 03:14:58" } ] |
3 | 0.42 ms |
update bolt_content SET status = 'published', published_at = :now WHERE status = 'timed' AND published_at < :now
Parameters:
[ ":now" => Carbon\Carbon {#2684 : "2025-05-22 03:14:58" } ] |
4 | 11.15 ms |
update bolt_content SET status = 'held', depublished_at = :now WHERE status = 'published' AND depublished_at < :now
Parameters:
[ ":now" => Carbon\Carbon {#2684 : "2025-05-22 03:14:58" } ] |
5 | 17.49 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":"91358042"}" "2025-05-29 05:14:58" ] |
6 | 0.51 ms |
SELECT NEXTVAL('alis_cache_id_seq')
Parameters:
[] |
7 | 0.05 ms |
"START TRANSACTION"
Parameters:
[] |
8 | 0.44 ms |
INSERT INTO bolt_alis_cache (id, call, response, date_call, expire_at) VALUES (?, ?, ?, ?, ?)
Parameters:
[ 1 => 412633 2 => "{"cmd":"details","societe":"gf","identifier":"91358042"}" 3 => "O:8:"stdClass":2:{s:4:"data";O:8:"stdClass":13:{s:3:"uid";s:34:"20250520120101-851757-000091358042";s:4:"site";s:30:"https://www.lagazettefrance.fr";s:9:"nbannonce";i:91358042;s:12:"dateparution";s:19:"2025-05-21 13:03:46";s:7:"support";s:18:"lagazettefrance.fr";s:12:"isSupportWeb";b:1;s:11:"typeannonce";s:31:"DISSOLUTION-LIQUIDATION AMIABLE";s:11:"departement";s:18:"62 - Pas-de-Calais";s:8:"htmlText";s:830:"<p class="STY24">DUTOITPROXI</p> <p class="STY25">SARL au capital de 7500 euros<br>Siège social : 9 rue de la Peine - Appartement 1<br>62220 CARVIN<br>RCS ARRAS 882.493.638</p> <p class="STY9" style="color:#0000FF;font-family:'verdana';font-size:8;name:STY9;text-align:center;" title="STY9 - Filet" class="STY9"> </p> <p class="STY17">Suivant un procès-verbal en date du 20 Février 2024, l'associé unique décide à compter de ce jour, la dissolution anticipée de la société, fixe le siège de liquidation sis à BAUVIN (59221) 18 Résidence de l'Ecaille et nomme en qualité de liquidateur Monsieur Gauthier DUTOIT, domicilié à CARVIN (62220), 9 rue de la Peine, Appartement 1<br>Mention sera faite au RCS d'ARRAS.</p>";s:9:"plainText";s:518:"DUTOITPROXI SARL au capital de 7500 euros Siège social : 9 rue de la Peine - Appartement 1 62220 CARVIN RCS ARRAS 882.493.638 <br/> Suivant un procès-verbal en date du 20 Février 2024, l'associé unique décide à compter de ce jour, la dissolution anticipée de la société, fixe le siège de liquidation sis à BAUVIN (59221) 18 Résidence de l'Ecaille et nomme en qualité de liquidateur Monsieur Gauthier DUTOIT, domicilié à CARVIN (62220), 9 rue de la Peine, Appartement 1 Mention sera faite au RCS d'ARRAS.";s:4:"logo";N;s:13:"jugement_date";s:0:"";s:7:"societe";s:11:"DUTOITPROXO";}s:6:"status";s:2:"OK";}" 4 => "2025-05-22 05:14:58" 5 => "2025-05-29 05:14:58" ] |
9 | 0.20 ms |
"COMMIT"
Parameters:
[] |
10 | 10.51 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":"A410","typeannonceRC":null,"departement":"62","from":null,"to":null,"range":null,"support":null,"findLasts":null,"page":1,"itemsPerPage":10,"cmd":"search","societe":"ALL"}" "2025-05-22 05:14:59" ] |
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. |