Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

6.12 ms Query time

3 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	4.33 ms	SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.image AS image_2, c0_.description AS description_3 FROM category c0_ LIMIT 3 Parameters: [] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.image AS image_2, c0_.description AS description_3 FROM category c0_ LIMIT 3 SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.image AS image_2, c0_.description AS description_3 FROM category c0_ LIMIT 3;
2	1.79 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_ WHERE p0_.category_id NOT IN (?, ?, ?) LIMIT 3 Parameters: [`1 2 3`] 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_ WHERE p0_.category_id NOT IN (?, ?, ?) LIMIT 3 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_ WHERE p0_.category_id NOT IN (1, 2, 3) LIMIT 3;

#▲

Time

Info

4.33 ms

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.image AS image_2, c0_.description AS description_3 FROM category c0_ LIMIT 3

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.image AS image_2,
  c0_.description AS description_3
FROM
  category c0_
LIMIT
  3

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.image AS image_2, c0_.description AS description_3 FROM category c0_ LIMIT 3;

1.79 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_ WHERE p0_.category_id NOT IN (?, ?, ?) LIMIT 3

Parameters:

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_
WHERE
  p0_.category_id NOT IN (?, ?, ?)
LIMIT
  3

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_ WHERE p0_.category_id NOT IN (1, 2, 3) LIMIT 3;

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\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\Product	The mappings App\Entity\Product#productWishlists and App\Entity\ProductWishlist#product are inconsistent with each other.
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/

Configuration Settings

Theme