Symfony Profiler

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

Query Metrics

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.initialprice AS initialprice_4, t0.reduceprice AS reduceprice_5, t0.publicationdate AS publicationdate_6, t0.link AS link_7, t0.delivery AS delivery_8, t0.image_filename AS image_filename_9, t0.is_active AS is_active_10, t0.is_published AS is_published_11, t0.user_id AS user_id_12 FROM deal t0 WHERE t0.id = ?

[
  "54"
]

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.initialprice AS initialprice_4,
  t0.reduceprice AS reduceprice_5,
  t0.publicationdate AS publicationdate_6,
  t0.link AS link_7,
  t0.delivery AS delivery_8,
  t0.image_filename AS image_filename_9,
  t0.is_active AS is_active_10,
  t0.is_published AS is_published_11,
  t0.user_id AS user_id_12
FROM
  deal t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.initialprice AS initialprice_4, t0.reduceprice AS reduceprice_5, t0.publicationdate AS publicationdate_6, t0.link AS link_7, t0.delivery AS delivery_8, t0.image_filename AS image_filename_9, t0.is_active AS is_active_10, t0.is_published AS is_published_11, t0.user_id AS user_id_12 FROM deal t0 WHERE t0.id = '54';

SELECT t0.id AS id_1, t0.content AS content_2, t0.comment_time AS comment_time_3, t0.user_id AS user_id_4, t0.deal_id AS deal_id_5, t0.parent_id AS parent_id_6 FROM COMMENT t0 WHERE t0.deal_id = ? AND t0.parent_id IS NULL

[
  54
]

SELECT
  t0.id AS id_1,
  t0.content AS content_2,
  t0.comment_time AS comment_time_3,
  t0.user_id AS user_id_4,
  t0.deal_id AS deal_id_5,
  t0.parent_id AS parent_id_6
FROM
  COMMENT t0
WHERE
  t0.deal_id = ?
  AND t0.parent_id IS NULL

SELECT t0.id AS id_1, t0.content AS content_2, t0.comment_time AS comment_time_3, t0.user_id AS user_id_4, t0.deal_id AS deal_id_5, t0.parent_id AS parent_id_6 FROM COMMENT t0 WHERE t0.deal_id = 54 AND t0.parent_id IS NULL;

SELECT COUNT(*) FROM vote t0 WHERE t0.deal_id = ? AND t0.type_vote = ?

[
  54
  "upvote"
]

SELECT
  COUNT(*)
FROM
  vote t0
WHERE
  t0.deal_id = ?
  AND t0.type_vote = ?

SELECT COUNT(*) FROM vote t0 WHERE t0.deal_id = 54 AND t0.type_vote = 'upvote';

SELECT COUNT(*) FROM vote t0 WHERE t0.deal_id = ? AND t0.type_vote = ?

[
  54
  "downvote"
]

SELECT
  COUNT(*)
FROM
  vote t0
WHERE
  t0.deal_id = ?
  AND t0.type_vote = ?

SELECT COUNT(*) FROM vote t0 WHERE t0.deal_id = 54 AND t0.type_vote = 'downvote';

SELECT t0.id AS id_1, t0.name_category AS name_category_2, t0.categories_id AS categories_id_3 FROM category t0 INNER JOIN deal_category ON t0.id = deal_category.category_id WHERE deal_category.deal_id = ?

[
  54
]

SELECT
  t0.id AS id_1,
  t0.name_category AS name_category_2,
  t0.categories_id AS categories_id_3
FROM
  category t0
  INNER JOIN deal_category ON t0.id = deal_category.category_id
WHERE
  deal_category.deal_id = ?

SELECT t0.id AS id_1, t0.name_category AS name_category_2, t0.categories_id AS categories_id_3 FROM category t0 INNER JOIN deal_category ON t0.id = deal_category.category_id WHERE deal_category.deal_id = 54;