https://www.dejalu.fr/app_dev.php/robert-walser/livres

Query Metrics

36 Database Queries
9 Different statements
29.72 ms Query time
7 Invalid entities

Grouped Statements

Show all queries

Time Count Info
8.96 ms
(30.15%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.ancestor_id AS ancestor_id_4 FROM author t0 WHERE t0.slug = ?
Parameters: [0 => robert-walser]
5.23 ms
(17.59%)
10
SELECT b0_.name AS name_0 FROM interaction i1_ LEFT JOIN book b2_ ON i1_.book_id = b2_.id LEFT JOIN book b3_ ON b2_.book_parent_id = b3_.id LEFT JOIN bookshelf b0_ ON i1_.bookshelf_id = b0_.id LEFT JOIN user u4_ ON b0_.user_id = u4_.id WHERE u4_.id = ? AND (b2_.uniqid = ? OR b3_.uniqid = ?)
Parameters: [0 => null, 1 => -U-bVsqdsCgC, 2 => -U-bVsqdsCgC]
4.90 ms
(16.47%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.ancestor_id AS ancestor_id_4 FROM author t0 WHERE t0.slug = ? LIMIT 1
Parameters: [0 => robert-walser]
4.06 ms
(13.65%)
10
SELECT t0.id AS id_1, t0.creation_date AS creation_date_2, t0.name AS name_3, t0.slug AS slug_4, t0.category_parent_id AS category_parent_id_5 FROM category t0 INNER JOIN category_book ON t0.id = category_book.category_id WHERE category_book.book_id = ?
Parameters: [0 => 14624]
4.04 ms
(13.61%)
10
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.ancestor_id AS ancestor_id_4 FROM author t0 INNER JOIN author_book ON t0.id = author_book.author_id WHERE author_book.book_id = ?
Parameters: [0 => 14624]
1.35 ms
(4.54%)
1
SELECT b0_.id AS id_0, b0_.uniqid AS uniqid_1, b0_.title AS title_2, b0_.subtitle AS subtitle_3, b0_.publisher AS publisher_4, b0_.published_date AS published_date_5, b0_.page_count AS page_count_6, b0_.description AS description_7, b0_.picture_url AS picture_url_8, b0_.language AS language_9, b0_.creation_date AS creation_date_10, b0_.last_edit_date AS last_edit_date_11, b0_.who AS who_12, b0_.checked AS checked_13, b0_.favorite_dl AS favorite_dl_14, b0_.favorite_dl_date AS favorite_dl_date_15, b0_.slug AS slug_16, b0_.note_average AS note_average_17, b0_.note_total AS note_total_18, b0_.vues AS vues_19, b0_.vues_from_child AS vues_from_child_20, b0_.added_by AS added_by_21, b0_.added_isbn AS added_isbn_22, b0_.checked_by_moderator AS checked_by_moderator_23, b0_.list_of_memos AS list_of_memos_24, b0_.cover_id AS cover_id_25, b0_.book_parent_id AS book_parent_id_26, b0_.precommande_id AS precommande_id_27 FROM book b0_ LEFT JOIN author_book a2_ ON b0_.id = a2_.book_id LEFT JOIN author a1_ ON a1_.id = a2_.author_id WHERE a1_.id IN (?) AND b0_.book_parent_id IS NULL
Parameters: [ 0 => [ 0 => 7844 ] ]
0.47 ms
(1.59%)
1
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.description AS description_2, b0_.picture_url AS picture_url_3, b0_.creation_date AS creation_date_4, b0_.systempj AS systempj_5, b0_.visibility AS visibility_6, b0_.slug AS slug_7, b0_.snapshot_by_show_1 AS snapshot_by_show_1_8 FROM bookshelf b0_ WHERE b0_.user_id = ? AND b0_.systempj = ?
Parameters: [0 => null, 1 => 0]
0.40 ms
(1.34%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.ancestor_id AS ancestor_id_4 FROM author t0 WHERE t0.ancestor_id = ?
Parameters: [0 => 7844]
0.31 ms
(1.06%)
1
SELECT t0.id AS id_1, t0.creation_date AS creation_date_2, t0.name AS name_3, t0.slug AS slug_4, t0.category_parent_id AS category_parent_id_5 FROM category t0 WHERE t0.id = ?
Parameters: [0 => 724]

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
PubliBundle\Entity\Command No errors.
Klh\ClubBundle\Entity\Experience No errors.
Klh\BookBundle\Entity\Interaction No errors.
Klh\ApiBundle\Entity\MemoBook No errors.
Klh\BookBundle\Entity\Book No errors.
Klh\BookBundle\Entity\Note No errors.
Klh\BookBundle\Entity\Bookshelf No errors.
Klh\ClubBundle\Entity\ClubBookshelf No errors.
Klh\ClubBundle\Entity\Club
  • The field Klh\ClubBundle\Entity\Club#members is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Klh\ClubBundle\Entity\Member#club does not contain the required 'inversedBy="members"' attribute.
  • The mappings Klh\ClubBundle\Entity\Club#experiencesDraft and Klh\ExperienceBundle\Entity\ExperienceDraft#club are inconsistent with each other.
FOS\MessageBundle\Entity\Message No errors.
MessageBundle\Entity\Message No errors.
FOS\MessageBundle\Entity\MessageMetadata No errors.
MessageBundle\Entity\MessageMetaData No errors.
FOS\MessageBundle\Entity\Thread No errors.
MessageBundle\Entity\Thread No errors.
FOS\MessageBundle\Entity\ThreadMetadata No errors.
MessageBundle\Entity\ThreadMetaData No errors.
FOS\UserBundle\Model\User No errors.
UserBundle\Entity\User
  • The association UserBundle\Entity\User#bookHistory refers to the owning side field Klh\BookBundle\Entity\BookHistory#reader which does not exist.
UserBundle\Entity\Website No errors.
UserBundle\Entity\Subscription No errors.
UserBundle\Entity\SocialAccount No errors.
UserBundle\Entity\Hobby No errors.
PubliBundle\Entity\Activity No errors.
PubliBundle\Entity\Contact No errors.
Klh\BookBundle\Entity\Category No errors.
Klh\BookBundle\Entity\BookPending No errors.
Klh\BookBundle\Entity\Author No errors.
Klh\BookBundle\Entity\Identifier No errors.
Klh\BookBundle\Entity\BookRequest
  • The association Klh\BookBundle\Entity\BookRequest#user refers to the inverse side field UserBundle\Entity\User#bookRequest which does not exist.
Klh\BookBundle\Entity\BookHistory No errors.
Klh\BookBundle\Entity\RecoByUser
  • The association Klh\BookBundle\Entity\RecoByUser#book refers to the inverse side field Klh\BookBundle\Entity\Book#bookRecommandation which does not exist.
Klh\BookBundle\Entity\BookSuggest No errors.
Klh\NewsletterBundle\Entity\inscription No errors.
Klh\CommentBundle\Entity\Comment No errors.
Klh\CommentBundle\Entity\LikeComment No errors.
Klh\EventBundle\Entity\Event No errors.
Klh\EventBundle\Entity\EventComment No errors.
Klh\EventBundle\Entity\EventNote No errors.
Klh\EventBundle\Entity\EventAddToClubBookshelf No errors.
Klh\EventBundle\Entity\EventAddTo No errors.
Klh\CoreBundle\Entity\Picture No errors.
Klh\CoreBundle\Entity\Cover No errors.
Klh\CoreBundle\Entity\Precommande No errors.
Mgilet\NotificationBundle\Entity\NotifiableEntity No errors.
Mgilet\NotificationBundle\Entity\Notification No errors.
Mgilet\NotificationBundle\Entity\NotifiableNotification No errors.
NotificationBundle\Entity\NotificationOption No errors.
Klh\ClubBundle\Entity\SondageQuestion No errors.
Klh\ClubBundle\Entity\News
  • The mappings Klh\ClubBundle\Entity\News#extras and Klh\ClubBundle\Entity\Extra#post are inconsistent with each other.
Klh\ClubBundle\Entity\Place No errors.
Klh\ClubBundle\Entity\Media No errors.
Klh\ClubBundle\Entity\ClubStatus No errors.
Klh\ClubBundle\Entity\Member No errors.
Klh\ClubBundle\Entity\WebSiteClubLivresque No errors.
Klh\ClubBundle\Entity\Invitation No errors.
Klh\ClubBundle\Entity\Extra
  • The association Klh\ClubBundle\Entity\Extra#post refers to the inverse side field Klh\ClubBundle\Entity\News#extralinks which does not exist.
Klh\ClubBundle\Entity\Survey No errors.
Klh\ClubBundle\Entity\LikeNews No errors.
Klh\ClubBundle\Entity\NewsComments No errors.
Klh\ClubBundle\Entity\SurveyResponse No errors.
Klh\ClubBundle\Entity\SondageAnswer No errors.
Klh\ClubBundle\Entity\ClubRequest No errors.
Klh\ExperienceBundle\Entity\ExperienceDraft
  • The association Klh\ExperienceBundle\Entity\ExperienceDraft#club refers to the inverse side field Klh\ClubBundle\Entity\Club#experiences_draft which does not exist.
Klh\DebateBundle\Entity\DebateSynthesis No errors.
Klh\DebateBundle\Entity\DebateArgument No errors.
Klh\PaymentBundle\Entity\Invoice No errors.
Klh\ApiBundle\Entity\Reponse No errors.
Klh\ApiBundle\Entity\Defi No errors.
Klh\ApiBundle\Entity\DefiWebsite No errors.
Klh\ApiBundle\Entity\DefiParticipant No errors.
Klh\ApiBundle\Entity\DefiTheme No errors.
Klh\ApiBundle\Entity\DefiThemeBook No errors.
Klh\ApiBundle\Entity\Discussion No errors.
Klh\ApiBundle\Entity\Sondage No errors.
Klh\ApiBundle\Entity\Reaction No errors.
Klh\ApiBundle\Entity\BookImport No errors.
FOS\UserBundle\Model\Group No errors.