GET https://www.renitadsilvabooks.com/books?tag=Joffe%20Book%20Prize%20Winner

Query Metrics

6 Database Queries
5 Different statements
2.41 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.50 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4 FROM tag t0 WHERE t0.title = ? LIMIT 1
Parameters:
[
  "Joffe Book Prize Winner"
]
2 0.54 ms
SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.isbn AS isbn_2, b0_.language AS language_3, b0_.sub_title AS sub_title_4, b0_.status AS status_5, b0_.status_visible AS status_visible_6, b0_.description AS description_7, b0_.created_at AS created_at_8, b0_.updated_at AS updated_at_9, b0_.click AS click_10, b0_.image AS image_11, b0_.book_feature AS book_feature_12, b0_.synopsis AS synopsis_13, b0_.number_of_pages AS number_of_pages_14, b0_.publication_date AS publication_date_15, b0_.category_id AS category_id_16, b0_.publisher_id AS publisher_id_17 FROM book b0_ LEFT JOIN book_tag b1_ ON b0_.id = b1_.book_id WHERE b0_.status = 1 AND b1_.tag_id = ?
Parameters:
[
  9
]
3 0.36 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.status AS status_2, c0_.created_at AS created_at_3, c0_.updated_at AS updated_at_4 FROM category c0_
Parameters:
[]
4 0.47 ms
SELECT t0.id AS id_1, t0.link AS link_2, t0.status AS status_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.book_id AS book_id_6, t0.shop_id AS shop_id_7 FROM book_shop t0 WHERE t0.book_id = ?
Parameters:
[
  2
]
5 0.30 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.status AS status_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM shop t0 WHERE t0.id = ?
Parameters:
[
  1
]
6 0.22 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.status AS status_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM shop t0 WHERE t0.id = ?
Parameters:
[
  4
]

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\Category No errors.
App\Entity\Book No errors.
App\Entity\Tag No errors.
App\Entity\BookTag No errors.
App\Entity\BlogTag No errors.
App\Entity\Publisher No errors.
App\Entity\BookShop No errors.
App\Entity\Testimonial No errors.
App\Entity\Shop No errors.
App\Entity\Blog No errors.