Query Metrics
36
Database Queries
9
Different statements
29.72 ms
Query time
7
Invalid entities
Grouped Statements
| 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 |
|
| 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 |
|
| 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 |
|
| Klh\BookBundle\Entity\BookHistory | No errors. |
| Klh\BookBundle\Entity\RecoByUser |
|
| 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 |
|
| 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 |
|
| 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 |
|
| 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. |