Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs
• Events
• Routing
• Cache
• Translation 1
• Security
• Twig
• HTTP Client
• Doctrine 3
• Debug
• Messages
• Emails
• Notifications
• Serializer
• VichUploader
• Configuration

Query Metrics

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.price AS price_2, p0_.illustration AS illustration_3, p0_.weight AS weight_4, p0_.available AS available_5, p0_.short_description AS short_description_6, p0_.description AS description_7, p0_.tags AS tags_8, p0_.average_rating AS average_rating_9, p0_.ratings_count AS ratings_count_10, p0_.info AS info_11, p0_.stock AS stock_12, p0_.seller_id AS seller_id_13 FROM product p0_ WHERE p0_.average_rating IS NOT NULL AND p0_.available IS NOT NULL ORDER BY p0_.average_rating DESC, p0_.ratings_count DESC LIMIT 5

[]

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.price AS price_2,
  p0_.illustration AS illustration_3,
  p0_.weight AS weight_4,
  p0_.available AS available_5,
  p0_.short_description AS short_description_6,
  p0_.description AS description_7,
  p0_.tags AS tags_8,
  p0_.average_rating AS average_rating_9,
  p0_.ratings_count AS ratings_count_10,
  p0_.info AS info_11,
  p0_.stock AS stock_12,
  p0_.seller_id AS seller_id_13
FROM
  product p0_
WHERE
  p0_.average_rating IS NOT NULL
  AND p0_.available IS NOT NULL
ORDER BY
  p0_.average_rating DESC,
  p0_.ratings_count DESC
LIMIT
  5

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.price AS price_2, p0_.illustration AS illustration_3, p0_.weight AS weight_4, p0_.available AS available_5, p0_.short_description AS short_description_6, p0_.description AS description_7, p0_.tags AS tags_8, p0_.average_rating AS average_rating_9, p0_.ratings_count AS ratings_count_10, p0_.info AS info_11, p0_.stock AS stock_12, p0_.seller_id AS seller_id_13 FROM product p0_ WHERE p0_.average_rating IS NOT NULL AND p0_.available IS NOT NULL ORDER BY p0_.average_rating DESC, p0_.ratings_count DESC LIMIT 5;

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 = ?

[
  "ROLE_SHOPPER"
]

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 = ?

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 = 'ROLE_SHOPPER';

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 = ?

[
  1
]

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 = ?

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 = 1;