Query Metrics
6
Database Queries
6
Different statements
4.22 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
1.63 ms (38.68%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.description AS description_4, t0.year AS year_5, t0.binding AS binding_6, t0.orientation AS orientation_7, t0.dimensions AS dimensions_8, t0.weight AS weight_9, t0.pages AS pages_10, t0.edition AS edition_11, t0.languages AS languages_12, t0.isbn_ean AS isbn_ean_13, t0.price AS price_14, t0.countries AS countries_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.created_by AS created_by_18, t0.updated_by AS updated_by_19 FROM books t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"getting-up-subway-graffiti-in-new-york"
]
|
0.83 ms (19.61%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.created_by AS created_by_5, t0.updated_by AS updated_by_6 FROM authors t0 INNER JOIN book_author ON t0.id = book_author.author_id WHERE book_author.book_id = ?
Parameters:
[
231
]
|
0.47 ms (11.05%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.country AS country_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM cities t0 INNER JOIN book_city ON t0.id = book_city.city_id WHERE book_city.book_id = ?
Parameters:
[
231
]
|
0.47 ms (11.03%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.created_by AS created_by_5, t0.updated_by AS updated_by_6 FROM publishers t0 INNER JOIN book_publisher ON t0.id = book_publisher.publisher_id WHERE book_publisher.book_id = ?
Parameters:
[
231
]
|
0.42 ms (9.98%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.book_id AS book_id_4 FROM book_links t0 WHERE t0.book_id = ?
Parameters:
[
231
]
|
0.41 ms (9.65%) |
1 |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.original_filename AS original_filename_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.book_id AS book_id_6, t0.created_by AS created_by_7, t0.updated_by AS updated_by_8 FROM book_images t0 WHERE t0.book_id = ?
Parameters:
[
231
]
|
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\Book | No errors. |
App\Entity\User | No errors. |
App\Entity\Author | No errors. |
App\Entity\Publisher | No errors. |
App\Entity\City | No errors. |
App\Entity\BookImage | No errors. |
App\Entity\BookLink | No errors. |
App\Entity\Video | No errors. |