Query Metrics
204
Database Queries
5
Different statements
76.65 ms
Query time
1
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
32.12 ms (41.91%) |
99 |
SELECT t0.id AS id_1, t0.livre_id AS livre_id_2, t0.auteur_id AS auteur_id_3 FROM lien_auteur_livre t0 WHERE t0.livre_id = ?
Parameters:
[
1924
]
|
|
19.51 ms (25.45%) |
72 |
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM auteur t0 WHERE t0.id = ?
Parameters:
[
14888
]
|
|
12.29 ms (16.03%) |
1 |
SELECT l0_.id AS id_0, l0_.titre AS titre_1, l0_.isbn AS isbn_2, l0_.numero AS numero_3, l0_.annee AS annee_4, l0_.cycle AS cycle_5, l0_.tome AS tome_6, l0_.pages AS pages_7, l0_.prixBase AS prixBase_8, l0_.cote AS cote_9, l0_.amazon AS amazon_10, l0_.poids AS poids_11, l0_.resume AS resume_12, l0_.image AS image_13, l0_.image_2 AS image_2_14, l0_.category_id AS category_id_15, l0_.collection_id AS collection_id_16, l0_.edition_id AS edition_id_17, l0_.monnaie_id AS monnaie_id_18 FROM livre l0_ WHERE l0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY l0_.titre ASC
Parameters:
[ 1924 2207 1320 1881 826 1882 1883 2061 1884 1957 1958 1959 1960 2216 1900 2274 2275 2276 2254 2255 2037 2256 2257 2252 2259 2260 2261 2253 2204 2282 2262 2263 2287 2267 1886 2219 2070 1899 2226 2031 2036 2152 1887 2120 2195 2196 2121 2122 2123 2124 2124 2125 2126 2127 2128 2129 2130 2131 2132 2133 2134 2135 2136 2197 2137 2138 2042 2043 2044 2045 2046 2047 2139 2140 2141 2142 2143 2198 2144 2145 2247 1933 2146 2229 2147 2242 2231 2148 2182 2212 1685 2210 2056 1971 2149 2029 2150 1986 2154 2155 ] |
|
7.47 ms (9.74%) |
30 |
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM edition t0 WHERE t0.id = ?
Parameters:
[
169
]
|
|
5.26 ms (6.87%) |
2 |
SELECT l.id, l.titre FROM livre l, lien_user_livre lul WHERE l.id = lul.livre_id AND lul.user_id = 2 Order By l.titre ASC
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 |
|---|---|
| App\Entity\Livre |
|
| App\Entity\Category | No errors. |
| App\Entity\Collection | No errors. |
| App\Entity\Edition | No errors. |
| App\Entity\Monnaie | No errors. |
| App\Entity\LienAuteurLivre | No errors. |
| App\Entity\LienUserLivre | No errors. |
| App\Entity\Auteur | No errors. |