GET https://www.entremums.com/bien-etre/vaisselle/3213

Query Metrics

9 Database Queries
4 Different statements
3.08 ms Query time
4 Invalid entities
30 Managed entities

Queries

Group similar statements

# Time Info
1 0.54 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM chogan_category t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "vaisselle"
]
2 0.31 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2 FROM chogan_category c0_ ORDER BY c0_.name ASC
Parameters:
[]
3 0.54 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.short_description AS short_description_2, c0_.description AS description_3, c0_.default_image AS default_image_4, c0_.available AS available_5, c0_.tags AS tags_6, c0_.video AS video_7, c0_.price AS price_8, c0_.info AS info_9, c0_.average_rating AS average_rating_10, c0_.ratings_count AS ratings_count_11, c0_.size AS size_12, c1_.id AS id_13, c1_.name AS name_14, c1_.slug AS slug_15, c0_.category_id AS category_id_16 FROM chogan_product c0_ LEFT JOIN chogan_category c1_ ON c0_.category_id = c1_.id WHERE c0_.category_id = ? LIMIT 12 OFFSET 38544
Parameters:
[
  21
]
4 0.36 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.short_description AS short_description_2, c0_.description AS description_3, c0_.default_image AS default_image_4, c0_.available AS available_5, c0_.tags AS tags_6, c0_.video AS video_7, c0_.price AS price_8, c0_.info AS info_9, c0_.average_rating AS average_rating_10, c0_.ratings_count AS ratings_count_11, c0_.size AS size_12, c1_.id AS id_13, c1_.name AS name_14, c1_.slug AS slug_15, c0_.category_id AS category_id_16 FROM chogan_product c0_ LEFT JOIN chogan_category c1_ ON c0_.category_id = c1_.id WHERE c0_.category_id = ? LIMIT 12 OFFSET 38544
Parameters:
[
  21
]
5 0.29 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.short_description AS short_description_2, c0_.description AS description_3, c0_.default_image AS default_image_4, c0_.available AS available_5, c0_.tags AS tags_6, c0_.video AS video_7, c0_.price AS price_8, c0_.info AS info_9, c0_.average_rating AS average_rating_10, c0_.ratings_count AS ratings_count_11, c0_.size AS size_12, c1_.id AS id_13, c1_.name AS name_14, c1_.slug AS slug_15, c0_.category_id AS category_id_16 FROM chogan_product c0_ LEFT JOIN chogan_category c1_ ON c0_.category_id = c1_.id WHERE c0_.category_id = ? LIMIT 12 OFFSET 38544
Parameters:
[
  21
]
6 0.29 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.short_description AS short_description_2, c0_.description AS description_3, c0_.default_image AS default_image_4, c0_.available AS available_5, c0_.tags AS tags_6, c0_.video AS video_7, c0_.price AS price_8, c0_.info AS info_9, c0_.average_rating AS average_rating_10, c0_.ratings_count AS ratings_count_11, c0_.size AS size_12, c1_.id AS id_13, c1_.name AS name_14, c1_.slug AS slug_15, c0_.category_id AS category_id_16 FROM chogan_product c0_ LEFT JOIN chogan_category c1_ ON c0_.category_id = c1_.id WHERE c0_.category_id = ? LIMIT 12 OFFSET 38544
Parameters:
[
  21
]
7 0.26 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.short_description AS short_description_2, c0_.description AS description_3, c0_.default_image AS default_image_4, c0_.available AS available_5, c0_.tags AS tags_6, c0_.video AS video_7, c0_.price AS price_8, c0_.info AS info_9, c0_.average_rating AS average_rating_10, c0_.ratings_count AS ratings_count_11, c0_.size AS size_12, c1_.id AS id_13, c1_.name AS name_14, c1_.slug AS slug_15, c0_.category_id AS category_id_16 FROM chogan_product c0_ LEFT JOIN chogan_category c1_ ON c0_.category_id = c1_.id WHERE c0_.category_id = ? LIMIT 12 OFFSET 38544
Parameters:
[
  21
]
8 0.27 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.short_description AS short_description_2, c0_.description AS description_3, c0_.default_image AS default_image_4, c0_.available AS available_5, c0_.tags AS tags_6, c0_.video AS video_7, c0_.price AS price_8, c0_.info AS info_9, c0_.average_rating AS average_rating_10, c0_.ratings_count AS ratings_count_11, c0_.size AS size_12, c1_.id AS id_13, c1_.name AS name_14, c1_.slug AS slug_15, c0_.category_id AS category_id_16 FROM chogan_product c0_ LEFT JOIN chogan_category c1_ ON c0_.category_id = c1_.id WHERE c0_.category_id = ? LIMIT 12 OFFSET 38544
Parameters:
[
  21
]
9 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.image AS image_4 FROM partner t0
Parameters:
[]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\ChoganCategory 29
App\Entity\Partner 1

Entities Mapping

Class Mapping errors
App\Entity\ChoganCategory No errors.
App\Entity\ChoganProduct No errors.
App\Entity\ChoganRating No errors.
App\Entity\ChoganIllustration
  • The association App\Entity\ChoganIllustration#color refers to the inverse side field App\Entity\ChoganColor#illustrations which does not exist.
App\Entity\ChoganFragrance No errors.
App\Entity\ChoganSize No errors.
App\Entity\User
  • The field App\Entity\User#roleEntities is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\Role#users does not contain the required 'mappedBy: "roleEntities"' attribute.
App\Entity\ChoganColor No errors.
App\Entity\Carrier No errors.
App\Entity\Chapter No errors.
App\Entity\ChoganOrder No errors.
App\Entity\Client No errors.
App\Entity\Company No errors.
App\Entity\Course No errors.
App\Entity\Document No errors.
App\Entity\Lesson No errors.
App\Entity\Order No errors.
App\Entity\OrderDetails No errors.
App\Entity\Partner No errors.
App\Entity\Product No errors.
App\Entity\Progress No errors.
App\Entity\Rating
  • The association App\Entity\Rating#user refers to the inverse side field App\Entity\User#ratings which does not exist.
App\Entity\ResetPasswordRequest No errors.
App\Entity\Role
  • The association App\Entity\Role#users refers to the inverse side field App\Entity\User#roles which does not exist.
App\Entity\WishlistItem No errors.
Vich\UploaderBundle\Entity\File No errors.