Query Metrics
20
Database Queries
1
Different statements
6.62 ms
Query time
1
Invalid entities
0
Managed entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.64 ms |
SELECT h0_.date_constatation AS date_constatation_0, h0_.valeur_constatation AS valeur_constatation_1 FROM histo_indice h0_ LEFT JOIN fonds f1_ ON h0_.id_fonds = f1_.id WHERE f1_.slug = ? ORDER BY h0_.date_constatation DESC LIMIT 1
Parameters:
[
"allocation-long-terme-2"
]
|
| 2 | 0.37 ms |
SELECT h0_.date_constatation AS date_constatation_0, h0_.valeur_constatation AS valeur_constatation_1 FROM histo_indice h0_ LEFT JOIN fonds f1_ ON h0_.id_fonds = f1_.id WHERE f1_.slug = ? ORDER BY h0_.date_constatation DESC LIMIT 1
Parameters:
[
"actif-general"
]
|
| 3 | 0.33 ms |
SELECT h0_.date_constatation AS date_constatation_0, h0_.valeur_constatation AS valeur_constatation_1 FROM histo_indice h0_ LEFT JOIN fonds f1_ ON h0_.id_fonds = f1_.id WHERE f1_.slug = ? ORDER BY h0_.date_constatation DESC LIMIT 1
Parameters:
[
"suravenir-opportunites"
]
|
| 4 | 0.32 ms |
SELECT h0_.date_constatation AS date_constatation_0, h0_.valeur_constatation AS valeur_constatation_1 FROM histo_indice h0_ LEFT JOIN fonds f1_ ON h0_.id_fonds = f1_.id WHERE f1_.slug = ? ORDER BY h0_.date_constatation DESC LIMIT 1
Parameters:
[
"suravenir-rendement"
]
|
| 5 | 0.27 ms |
SELECT h0_.date_constatation AS date_constatation_0, h0_.valeur_constatation AS valeur_constatation_1 FROM histo_indice h0_ LEFT JOIN fonds f1_ ON h0_.id_fonds = f1_.id WHERE f1_.slug = ? ORDER BY h0_.date_constatation DESC LIMIT 1
Parameters:
[
"netissima"
]
|
| 6 | 0.27 ms |
SELECT h0_.date_constatation AS date_constatation_0, h0_.valeur_constatation AS valeur_constatation_1 FROM histo_indice h0_ LEFT JOIN fonds f1_ ON h0_.id_fonds = f1_.id WHERE f1_.slug = ? ORDER BY h0_.date_constatation DESC LIMIT 1
Parameters:
[
"eurossima"
]
|
| 7 | 0.36 ms |
SELECT h0_.date_constatation AS date_constatation_0, h0_.valeur_constatation AS valeur_constatation_1 FROM histo_indice h0_ LEFT JOIN fonds f1_ ON h0_.id_fonds = f1_.id WHERE f1_.slug = ? ORDER BY h0_.date_constatation DESC LIMIT 1
Parameters:
[
"securite-pierre-euro"
]
|
| 8 | 0.37 ms |
SELECT h0_.date_constatation AS date_constatation_0, h0_.valeur_constatation AS valeur_constatation_1 FROM histo_indice h0_ LEFT JOIN fonds f1_ ON h0_.id_fonds = f1_.id WHERE f1_.slug = ? ORDER BY h0_.date_constatation DESC LIMIT 1
Parameters:
[
"securite-flex-euros"
]
|
| 9 | 0.28 ms |
SELECT h0_.date_constatation AS date_constatation_0, h0_.valeur_constatation AS valeur_constatation_1 FROM histo_indice h0_ LEFT JOIN fonds f1_ ON h0_.id_fonds = f1_.id WHERE f1_.slug = ? ORDER BY h0_.date_constatation DESC LIMIT 1
Parameters:
[
"fonds-euro-perp"
]
|
| 10 | 0.30 ms |
SELECT h0_.date_constatation AS date_constatation_0, h0_.valeur_constatation AS valeur_constatation_1 FROM histo_indice h0_ LEFT JOIN fonds f1_ ON h0_.id_fonds = f1_.id WHERE f1_.slug = ? ORDER BY h0_.date_constatation DESC LIMIT 1
Parameters:
[
"fonds-euro-eres"
]
|
| 11 | 0.30 ms |
SELECT h0_.date_constatation AS date_constatation_0, h0_.valeur_constatation AS valeur_constatation_1 FROM histo_indice h0_ LEFT JOIN fonds f1_ ON h0_.id_fonds = f1_.id WHERE f1_.slug = ? ORDER BY h0_.date_constatation DESC LIMIT 1
Parameters:
[
"fonds-euro-eres-rente"
]
|
| 12 | 0.36 ms |
SELECT h0_.date_constatation AS date_constatation_0, h0_.valeur_constatation AS valeur_constatation_1 FROM histo_indice h0_ LEFT JOIN fonds f1_ ON h0_.id_fonds = f1_.id WHERE f1_.slug = ? ORDER BY h0_.date_constatation DESC LIMIT 1
Parameters:
[
"fonds-euro-lignage"
]
|
| 13 | 0.31 ms |
SELECT h0_.date_constatation AS date_constatation_0, h0_.valeur_constatation AS valeur_constatation_1 FROM histo_indice h0_ LEFT JOIN fonds f1_ ON h0_.id_fonds = f1_.id WHERE f1_.slug = ? ORDER BY h0_.date_constatation DESC LIMIT 1
Parameters:
[
"fonds-euro-gaipare"
]
|
| 14 | 0.30 ms |
SELECT h0_.date_constatation AS date_constatation_0, h0_.valeur_constatation AS valeur_constatation_1 FROM histo_indice h0_ LEFT JOIN fonds f1_ ON h0_.id_fonds = f1_.id WHERE f1_.slug = ? ORDER BY h0_.date_constatation DESC LIMIT 1
Parameters:
[
"moyenne-euro-perp"
]
|
| 15 | 0.27 ms |
SELECT h0_.date_constatation AS date_constatation_0, h0_.valeur_constatation AS valeur_constatation_1 FROM histo_indice h0_ LEFT JOIN fonds f1_ ON h0_.id_fonds = f1_.id WHERE f1_.slug = ? ORDER BY h0_.date_constatation DESC LIMIT 1
Parameters:
[
"moyenne-euro-av"
]
|
| 16 | 0.34 ms |
SELECT h0_.date_constatation AS date_constatation_0, h0_.valeur_constatation AS valeur_constatation_1 FROM histo_indice h0_ LEFT JOIN fonds f1_ ON h0_.id_fonds = f1_.id WHERE f1_.slug = ? ORDER BY h0_.date_constatation DESC LIMIT 1
Parameters:
[
"apicil-euro-garanti"
]
|
| 17 | 0.34 ms |
SELECT h0_.date_constatation AS date_constatation_0, h0_.valeur_constatation AS valeur_constatation_1 FROM histo_indice h0_ LEFT JOIN fonds f1_ ON h0_.id_fonds = f1_.id WHERE f1_.slug = ? ORDER BY h0_.date_constatation DESC LIMIT 1
Parameters:
[
"fonds-euro-swisslife"
]
|
| 18 | 0.30 ms |
SELECT h0_.date_constatation AS date_constatation_0, h0_.valeur_constatation AS valeur_constatation_1 FROM histo_indice h0_ LEFT JOIN fonds f1_ ON h0_.id_fonds = f1_.id WHERE f1_.slug = ? ORDER BY h0_.date_constatation DESC LIMIT 1
Parameters:
[
"fonds-euro-per-nouvelle-generation"
]
|
| 19 | 0.31 ms |
SELECT h0_.date_constatation AS date_constatation_0, h0_.valeur_constatation AS valeur_constatation_1 FROM histo_indice h0_ LEFT JOIN fonds f1_ ON h0_.id_fonds = f1_.id WHERE f1_.slug = ? ORDER BY h0_.date_constatation DESC LIMIT 1
Parameters:
[
"suravenir-rendement-per"
]
|
| 20 | 0.28 ms |
SELECT h0_.date_constatation AS date_constatation_0, h0_.valeur_constatation AS valeur_constatation_1 FROM histo_indice h0_ LEFT JOIN fonds f1_ ON h0_.id_fonds = f1_.id WHERE f1_.slug = ? ORDER BY h0_.date_constatation DESC LIMIT 1
Parameters:
[
"fonds-euro-nouvelle-generation-1"
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| puf | doctrine.dbal.puf_connection |
| sel | doctrine.dbal.sel_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
| puf | doctrine.orm.puf_entity_manager |
| sel | doctrine.orm.sel_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|
puf entity manager
| Class | Amount of managed objects |
|---|
sel entity manager
| Class | Amount of managed objects |
|---|
Entities Mapping
default entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\HistoIndice | No errors. |
| App\Entity\Fonds |
|
puf entity manager
No loaded entities.
sel entity manager
No loaded entities.