GET https://www.entremums.com/shop/produit/1

Query Metrics

5 Database Queries
5 Different statements
4.86 ms Query time
4 Invalid entities
4 Managed entities

Queries

Group similar statements

# Time Info
1 1.15 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.illustration AS illustration_4, t0.weight AS weight_5, t0.available AS available_6, t0.short_description AS short_description_7, t0.description AS description_8, t0.tags AS tags_9, t0.average_rating AS average_rating_10, t0.ratings_count AS ratings_count_11, t0.info AS info_12, t0.stock AS stock_13, t0.seller_id AS seller_id_14 FROM product t0 WHERE t0.id = ?
Parameters:
[
  "1"
]
2 1.56 ms
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.password AS password_2, u0_.first_name AS first_name_3, u0_.last_name AS last_name_4, u0_.phone AS phone_5, u0_.avatar AS avatar_6, u0_.is_verified AS is_verified_7, u0_.address AS address_8, u0_.address_box AS address_box_9, u0_.postal AS postal_10, u0_.city AS city_11, u0_.country AS country_12, u0_.company_id AS company_id_13 FROM `user` u0_ INNER JOIN user_role u2_ ON u0_.id = u2_.user_id INNER JOIN role r1_ ON r1_.id = u2_.role_id WHERE r1_.title = ?
Parameters:
[
  "ROLE_SHOPPER"
]
3 0.98 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.tva AS tva_3, t0.address AS address_4, t0.address_box AS address_box_5, t0.postal AS postal_6, t0.country AS country_7, t0.phone AS phone_8, t0.email AS email_9, t0.avatar AS avatar_10, t0.bio AS bio_11, t0.slug AS slug_12, t0.city AS city_13, t14.id AS id_15, t14.email AS email_16, t14.password AS password_17, t14.first_name AS first_name_18, t14.last_name AS last_name_19, t14.phone AS phone_20, t14.avatar AS avatar_21, t14.is_verified AS is_verified_22, t14.address AS address_23, t14.address_box AS address_box_24, t14.postal AS postal_25, t14.city AS city_26, t14.country AS country_27, t14.company_id AS company_id_28 FROM company t0 LEFT JOIN `user` t14 ON t14.company_id = t0.id WHERE t0.id = ?
Parameters:
[
  1
]
4 0.85 ms
SELECT t0.id AS id_1, t0.rating AS rating_2, t0.created_at AS created_at_3, t0.message AS message_4, t0.user_id AS user_id_5, t0.product_id AS product_id_6 FROM rating t0 WHERE t0.product_id = ?
Parameters:
[
  1
]
5 0.31 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\Product 1
App\Entity\User 1
App\Entity\Company 1
App\Entity\Partner 1

Entities Mapping

Class Mapping errors
App\Entity\Product 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\Rating
  • The association App\Entity\Rating#user refers to the inverse side field App\Entity\User#ratings which does not exist.
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\Company No errors.
App\Entity\ChoganOrder No errors.
App\Entity\Client No errors.
App\Entity\WishlistItem No errors.
App\Entity\Carrier No errors.
App\Entity\Chapter No errors.
App\Entity\ChoganCategory No errors.
App\Entity\ChoganColor No errors.
App\Entity\ChoganFragrance 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\ChoganProduct No errors.
App\Entity\ChoganRating No errors.
App\Entity\ChoganSize 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\Progress No errors.
App\Entity\ResetPasswordRequest No errors.
Vich\UploaderBundle\Entity\File No errors.