Query Metrics
10
Database Queries
7
Different statements
57.73 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 2.13 ms |
update bolt_content SET status = 'published', published_at = :now WHERE status = 'timed' AND published_at < :now
Parameters:
[ ":now" => Carbon\Carbon {#2660 : "2025-06-13 02:21:11" } ] |
2 | 14.53 ms |
update bolt_content SET status = 'held', depublished_at = :now WHERE status = 'published' AND depublished_at < :now
Parameters:
[ ":now" => Carbon\Carbon {#2660 : "2025-06-13 02:21:11" } ] |
3 | 0.36 ms |
update bolt_content SET status = 'published', published_at = :now WHERE status = 'timed' AND published_at < :now
Parameters:
[ ":now" => Carbon\Carbon {#2690 : "2025-06-13 02:21:11" } ] |
4 | 10.31 ms |
update bolt_content SET status = 'held', depublished_at = :now WHERE status = 'published' AND depublished_at < :now
Parameters:
[ ":now" => Carbon\Carbon {#2690 : "2025-06-13 02:21:11" } ] |
5 | 18.35 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":"20241023130122-850983-000091288531"}" "2025-06-20 04:21:11" ] |
6 | 0.52 ms |
SELECT NEXTVAL('alis_cache_id_seq')
Parameters:
[] |
7 | 0.05 ms |
"START TRANSACTION"
Parameters:
[] |
8 | 0.28 ms |
INSERT INTO bolt_alis_cache (id, call, response, date_call, expire_at) VALUES (?, ?, ?, ?, ?)
Parameters:
[ 1 => 520809 2 => "{"cmd":"details","societe":"gf","identifier":"20241023130122-850983-000091288531"}" 3 => "O:8:"stdClass":2:{s:4:"data";O:8:"stdClass":13:{s:3:"uid";s:34:"20241023130122-850983-000091288531";s:4:"site";s:30:"https://www.picardiegazette.fr";s:9:"nbannonce";i:91288531;s:12:"dateparution";s:19:"2024-10-23 13:01:22";s:7:"support";s:19:"PICARDIE LA GAZETTE";s:12:"isSupportWeb";b:1;s:11:"typeannonce";s:31:"DISSOLUTION-LIQUIDATION AMIABLE";s:11:"departement";s:10:"80 - Somme";s:8:"htmlText";s:599:"<p class="STY17"><strong>CHUNG WU</strong><br>SAS au capital de 2.000€<br>Siège social : 2 AV PAUL DOUMER 80500 MONTDIDIER<br>RCS 888 062 833 AMIENS<br>L'AGE du 30/04/2024 a décidé la dissolution de la société et sa mise en liquidation amiable, nommé liquidateur M GUO SYLVAIN, 25 RUE DU DOCTEUR MENARD 93160 NOISY LE GRAND et fixé le siège de la liquidation au siège social. La correspondance sera adressée au 93 BOULEVARD DE SEBASTOPOL, Boîte aux lettres N°6 75002 PARIS.<br>Mention au RCS de AMIENS</p>";s:9:"plainText";s:471:"CHUNG WU SAS au capital de 2.000€ Siège social : 2 AV PAUL DOUMER 80500 MONTDIDIER RCS 888 062 833 AMIENS L'AGE du 30/04/2024 a décidé la dissolution de la société et sa mise en liquidation amiable, nommé liquidateur M GUO SYLVAIN, 25 RUE DU DOCTEUR MENARD 93160 NOISY LE GRAND et fixé le siège de la liquidation au siège social. La correspondance sera adressée au 93 BOULEVARD DE SEBASTOPOL, Boîte aux lettres N°6 75002 PARIS. Mention au RCS de AMIENS";s:4:"logo";N;s:13:"jugement_date";s:0:"";s:7:"societe";s:8:"CHUNG WU";}s:6:"status";s:2:"OK";}" 4 => "2025-06-13 04:21:11" 5 => "2025-06-20 04:21:11" ] |
9 | 0.39 ms |
"COMMIT"
Parameters:
[] |
10 | 10.81 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":"80","from":null,"to":null,"range":null,"support":null,"findLasts":null,"page":1,"itemsPerPage":10,"cmd":"search","societe":"ALL"}" "2025-06-13 04:21:11" ] |
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. |