Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

1 Database Queries

1 Different statements

2.19 ms Query time

3 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	2.19 ms	SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.illustration AS illustration_3, p0_.subtitle AS subtitle_4, p0_.description AS description_5, p0_.price AS price_6, p0_.category_id AS category_id_7 FROM product p0_ INNER JOIN category c1_ ON p0_.category_id = c1_.id WHERE c1_.name = ? Parameters: [`"Boissons"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.illustration AS illustration_3, p0_.subtitle AS subtitle_4, p0_.description AS description_5, p0_.price AS price_6, p0_.category_id AS category_id_7 FROM product p0_ INNER JOIN category c1_ ON p0_.category_id = c1_.id WHERE c1_.name = ? SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.illustration AS illustration_3, p0_.subtitle AS subtitle_4, p0_.description AS description_5, p0_.price AS price_6, p0_.category_id AS category_id_7 FROM product p0_ INNER JOIN category c1_ ON p0_.category_id = c1_.id WHERE c1_.name = 'Boissons';

#▲

Time

Info

2.19 ms

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.illustration AS illustration_3, p0_.subtitle AS subtitle_4, p0_.description AS description_5, p0_.price AS price_6, p0_.category_id AS category_id_7 FROM product p0_ INNER JOIN category c1_ ON p0_.category_id = c1_.id WHERE c1_.name = ?

Parameters:

[
  "Boissons"
]

View formatted query View runnable query Explain query

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.slug AS slug_2,
  p0_.illustration AS illustration_3,
  p0_.subtitle AS subtitle_4,
  p0_.description AS description_5,
  p0_.price AS price_6,
  p0_.category_id AS category_id_7
FROM
  product p0_
  INNER JOIN category c1_ ON p0_.category_id = c1_.id
WHERE
  c1_.name = ?

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.illustration AS illustration_3, p0_.subtitle AS subtitle_4, p0_.description AS description_5, p0_.price AS price_6, p0_.category_id AS category_id_7 FROM product p0_ INNER JOIN category c1_ ON p0_.category_id = c1_.id WHERE c1_.name = 'Boissons';

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\Product	The mappings App\Entity\Product#productWishlists and App\Entity\ProductWishlist#product are inconsistent with each other.
App\Entity\Category	The field App\Entity\Category#products is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Product#category does not contain the required 'inversedBy="products"' attribute.
App\Entity\ProductWishlist	The association App\Entity\ProductWishlist#product refers to the inverse side field App\Entity\Product#productWishlist which does not exist.

Symfony Profiler

http://laboutiquebelge.gabriel-cassano.be/product_by_category/Boissons

Configuration Settings

Theme