GET http://185.25.50.116:8080/books/5000km

Query Metrics

6 Database Queries
6 Different statements
4.12 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.85 ms
(44.81%)
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:
[
  "5000km"
]
0.77 ms
(18.76%)
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:
[
  107
]
0.44 ms
(10.78%)
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:
[
  107
]
0.40 ms
(9.73%)
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:
[
  107
]
0.35 ms
(8.42%)
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:
[
  107
]
0.31 ms
(7.50%)
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:
[
  107
]

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.