GET http://185.25.50.116:8080/books?limit_book=25&page_book=9&sort_book%5Btitle%5D=desc

Query Metrics

3 Database Queries
3 Different statements
14.63 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
6.92 ms
(47.25%)
1
SELECT count(DISTINCT b0_.id) AS sclr_0 FROM books b0_ LEFT JOIN book_author b2_ ON b0_.id = b2_.book_id LEFT JOIN authors a1_ ON a1_.id = b2_.author_id LEFT JOIN book_publisher b4_ ON b0_.id = b4_.book_id LEFT JOIN publishers p3_ ON p3_.id = b4_.publisher_id
Parameters:
[]
4.81 ms
(32.89%)
1
SELECT DISTINCT b0_.id AS id_0, b0_.title AS title_1 FROM books b0_ LEFT JOIN book_author b2_ ON b0_.id = b2_.book_id LEFT JOIN authors a1_ ON a1_.id = b2_.author_id LEFT JOIN book_publisher b4_ ON b0_.id = b4_.book_id LEFT JOIN publishers p3_ ON p3_.id = b4_.publisher_id ORDER BY b0_.title DESC LIMIT 25 OFFSET 200
Parameters:
[]
2.91 ms
(19.86%)
1
SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.slug AS slug_2, b0_.description AS description_3, b0_.year AS year_4, b0_.binding AS binding_5, b0_.orientation AS orientation_6, b0_.dimensions AS dimensions_7, b0_.weight AS weight_8, b0_.pages AS pages_9, b0_.edition AS edition_10, b0_.languages AS languages_11, b0_.isbn_ean AS isbn_ean_12, b0_.price AS price_13, b0_.countries AS countries_14, b0_.created_at AS created_at_15, b0_.updated_at AS updated_at_16, a1_.id AS id_17, a1_.name AS name_18, a1_.created_at AS created_at_19, a1_.updated_at AS updated_at_20, p2_.id AS id_21, p2_.name AS name_22, p2_.created_at AS created_at_23, p2_.updated_at AS updated_at_24, b0_.created_by AS created_by_25, b0_.updated_by AS updated_by_26, a1_.created_by AS created_by_27, a1_.updated_by AS updated_by_28, p2_.created_by AS created_by_29, p2_.updated_by AS updated_by_30 FROM books b0_ LEFT JOIN book_author b3_ ON b0_.id = b3_.book_id LEFT JOIN authors a1_ ON a1_.id = b3_.author_id LEFT JOIN book_publisher b4_ ON b0_.id = b4_.book_id LEFT JOIN publishers p2_ ON p2_.id = b4_.publisher_id WHERE b0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY b0_.title DESC
Parameters:
[
  102
  163
  46
  61
  29
  151
  150
  149
  148
  112
  44
  45
  146
  193
  145
  144
  138
  143
  134
  142
  137
  136
  259
  135
  133
]

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\Author No errors.
App\Entity\Publisher No errors.
App\Entity\User No errors.
App\Entity\City No errors.
App\Entity\BookImage No errors.
App\Entity\BookLink No errors.