Query Metrics
10
Database Queries
7
Different statements
83.77 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 {#2693 : "2025-07-22 19:51:50" } ] |
2 | 15.37 ms |
update bolt_content SET status = 'held', depublished_at = :now WHERE status = 'published' AND depublished_at < :now
Parameters:
[ ":now" => Carbon\Carbon {#2693 : "2025-07-22 19:51:50" } ] |
3 | 0.36 ms |
update bolt_content SET status = 'published', published_at = :now WHERE status = 'timed' AND published_at < :now
Parameters:
[ ":now" => Carbon\Carbon {#2686 : "2025-07-22 19:51:50" } ] |
4 | 10.99 ms |
update bolt_content SET status = 'held', depublished_at = :now WHERE status = 'published' AND depublished_at < :now
Parameters:
[ ":now" => Carbon\Carbon {#2686 : "2025-07-22 19:51:50" } ] |
5 | 47.37 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":"91306613"}" "2025-07-29 21:51:50" ] |
6 | 0.65 ms |
SELECT NEXTVAL('alis_cache_id_seq')
Parameters:
[] |
7 | 0.07 ms |
"START TRANSACTION"
Parameters:
[] |
8 | 0.25 ms |
INSERT INTO bolt_alis_cache (id, call, response, date_call, expire_at) VALUES (?, ?, ?, ?, ?)
Parameters:
[ 1 => 692061 2 => "{"cmd":"details","societe":"gf","identifier":"91306613"}" 3 => "O:8:"stdClass":2:{s:4:"data";O:8:"stdClass":13:{s:3:"uid";s:34:"20241219130112-786091-000091306613";s:4:"site";s:30:"https://www.picardiegazette.fr";s:9:"nbannonce";i:91306613;s:12:"dateparution";s:19:"2024-12-19 13:01:12";s:7:"support";s:19:"PICARDIE LA GAZETTE";s:12:"isSupportWeb";b:1;s:11:"typeannonce";s:25:"DEBUT DE LOCATION GERANCE";s:11:"departement";s:10:"80 - Somme";s:8:"htmlText";s:586:"<p class="STY17">Par acte SSP du 09/10/2024<br>AVS TAXI<br>Benoit SEGARD<br>36 Chant des linottes<br>80540 MOLLIENS DREUIL<br>SREN: 813 506 276 a donné location gérance à :<br>AMBULANCES DE MOLLIENS DREUIL<br>12 RUE DU GENERAL LECLERC<br>80540 MOLLIENS DREUIL<br>SIRET : 504 265 265 00026, son fonds de commerce de TAXI sis et exploité au 12 RUE DU GENERAL LECLERC 80540 MOLLIENS DREUIL.<br>Le présent contrat est consenti pour une durée de 5 ans à compter du 21/10/2024 au 20/10/2029, renouvelable par tacite reconduction.</p>";s:9:"plainText";s:493:"Par acte SSP du 09/10/2024 AVS TAXI Benoit SEGARD 36 Chant des linottes 80540 MOLLIENS DREUIL SREN: 813 506 276 a donné location gérance à : AMBULANCES DE MOLLIENS DREUIL 12 RUE DU GENERAL LECLERC 80540 MOLLIENS DREUIL SIRET : 504 265 265 00026, son fonds de commerce de TAXI sis et exploité au 12 RUE DU GENERAL LECLERC 80540 MOLLIENS DREUIL. Le présent contrat est consenti pour une durée de 5 ans à compter du 21/10/2024 au 20/10/2029, renouvelable par tacite reconduction.";s:4:"logo";N;s:13:"jugement_date";s:0:"";s:7:"societe";s:29:"AMBULANCES DE MOLLIENS DREUIL";}s:6:"status";s:2:"OK";}" 4 => "2025-07-22 21:51:50" 5 => "2025-07-29 21:51:50" ] |
9 | 0.10 ms |
"COMMIT"
Parameters:
[] |
10 | 6.47 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":"D210","typeannonceRC":null,"departement":"80","from":null,"to":null,"range":null,"support":null,"findLasts":null,"page":1,"itemsPerPage":10,"cmd":"search","societe":"ALL"}" "2025-07-22 21:51:50" ] |
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. |