Symfony Profiler

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

Query Metrics

SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`

[]

SELECT
  `lang_id`,
  `code`,
  `name`,
  `icon`
FROM
  `lang`

SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`;

SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1

[
  "hot italian"
]

SELECT
  `trend_id`
FROM
  `trend`
WHERE
  `subject` = ?
LIMIT
  1

SELECT `trend_id` FROM `trend` WHERE `subject` = 'hot italian' LIMIT 1;

SELECT p.post_id, p.user_id, p.content_id, p.public_key, p.search_field, p.cover, p.type, p.sexual_orientation, p.orientation, p.quality, p.noindex, p.nofollow, p.contents_num, p.duration, p.likes, p.dislikes, p.views, p.vote_rating, p.params, p.published_at, IFNULL(`r`.`title`, `f`.`title`) as `title`, IFNULL(`r`.`custom1`, `f`.`custom1`) as `custom1`, IFNULL(`r`.`custom2`, `f`.`custom2`) as `custom2` FROM post p LEFT JOIN post_translation f ON `p`.`post_id` = `f`.`post_id`  AND  `f`.`lang_id`=? LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id`  AND  `r`.`lang_id`=? WHERE p.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1
  2
  819066
  762945
  771556
  759480
  789289
  659247
  555011
  576988
  605948
  274930
  396287
  527999
  577386
  615751
  622981
  615726
  576628
  641683
  162721
  817633
  153602
  819152
  804639
  819153
  819160
  614950
  798753
  676793
  798870
  804615
  804399
  819157
  539557
  798845
  796514
  798837
  803822
  807854
  798826
  804648
  807861
  804394
  804614
  804652
  798829
  798833
  807869
  819759
  798818
  804303
  798750
  804396
  802251
  451235
  693341
  689442
  804638
  804644
  811259
  811366
  804380
  802278
  802288
  676799
  574153
  798770
  798846
  811335
  704010
  620135
  625171
  571241
  427209
  576711
]

SELECT
  p.post_id,
  p.user_id,
  p.content_id,
  p.public_key,
  p.search_field,
  p.cover,
  p.type,
  p.sexual_orientation,
  p.orientation,
  p.quality,
  p.noindex,
  p.nofollow,
  p.contents_num,
  p.duration,
  p.likes,
  p.dislikes,
  p.views,
  p.vote_rating,
  p.params,
  p.published_at,
  IFNULL(`r`.`title`, `f`.`title`) as `title`,
  IFNULL(`r`.`custom1`, `f`.`custom1`) as `custom1`,
  IFNULL(`r`.`custom2`, `f`.`custom2`) as `custom2`
FROM
  post p
  LEFT JOIN post_translation f ON `p`.`post_id` = `f`.`post_id`
  AND `f`.`lang_id` = ?
  LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id`
  AND `r`.`lang_id` = ?
WHERE
  p.post_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

SELECT p.post_id, p.user_id, p.content_id, p.public_key, p.search_field, p.cover, p.type, p.sexual_orientation, p.orientation, p.quality, p.noindex, p.nofollow, p.contents_num, p.duration, p.likes, p.dislikes, p.views, p.vote_rating, p.params, p.published_at, IFNULL(`r`.`title`, `f`.`title`) as `title`, IFNULL(`r`.`custom1`, `f`.`custom1`) as `custom1`, IFNULL(`r`.`custom2`, `f`.`custom2`) as `custom2` FROM post p LEFT JOIN post_translation f ON `p`.`post_id` = `f`.`post_id`  AND  `f`.`lang_id`=1 LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id`  AND  `r`.`lang_id`=2 WHERE p.post_id IN (819066, 762945, 771556, 759480, 789289, 659247, 555011, 576988, 605948, 274930, 396287, 527999, 577386, 615751, 622981, 615726, 576628, 641683, 162721, 817633, 153602, 819152, 804639, 819153, 819160, 614950, 798753, 676793, 798870, 804615, 804399, 819157, 539557, 798845, 796514, 798837, 803822, 807854, 798826, 804648, 807861, 804394, 804614, 804652, 798829, 798833, 807869, 819759, 798818, 804303, 798750, 804396, 802251, 451235, 693341, 689442, 804638, 804644, 811259, 811366, 804380, 802278, 802288, 676799, 574153, 798770, 798846, 811335, 704010, 620135, 625171, 571241, 427209, 576711);

SELECT pht.post_id, pht.tag_id, t.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_tag pht INNER JOIN tag t ON pht.tag_id = t.tag_id AND t.enabled = 1 LEFT JOIN tag_translation f ON t.tag_id = f.tag_id AND f.lang_id=? LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=? WHERE pht.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1
  2
  153602
  162721
  274930
  396287
  427209
  451235
  527999
  539557
  555011
  571241
  574153
  576628
  576711
  576988
  577386
  605948
  614950
  615726
  615751
  620135
  622981
  625171
  641683
  659247
  676793
  676799
  689442
  693341
  704010
  759480
  762945
  771556
  789289
  796514
  798750
  798753
  798770
  798818
  798826
  798829
  798833
  798837
  798845
  798846
  798870
  802251
  802278
  802288
  803822
  804303
  804380
  804394
  804396
  804399
  804614
  804615
  804638
  804639
  804644
  804648
  804652
  807854
  807861
  807869
  811259
  811335
  811366
  817633
  819066
  819152
  819153
  819157
  819160
  819759
]

SELECT
  pht.post_id,
  pht.tag_id,
  t.slug,
  IFNULL(`r`.`name`, `f`.`name`) as `name`
FROM
  post_has_tag pht
  INNER JOIN tag t ON pht.tag_id = t.tag_id
  AND t.enabled = 1
  LEFT JOIN tag_translation f ON t.tag_id = f.tag_id
  AND f.lang_id = ?
  LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id`
  AND `r`.`lang_id` = ?
WHERE
  pht.post_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

SELECT pht.post_id, pht.tag_id, t.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_tag pht INNER JOIN tag t ON pht.tag_id = t.tag_id AND t.enabled = 1 LEFT JOIN tag_translation f ON t.tag_id = f.tag_id AND f.lang_id=1 LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=2 WHERE pht.post_id IN (153602, 162721, 274930, 396287, 427209, 451235, 527999, 539557, 555011, 571241, 574153, 576628, 576711, 576988, 577386, 605948, 614950, 615726, 615751, 620135, 622981, 625171, 641683, 659247, 676793, 676799, 689442, 693341, 704010, 759480, 762945, 771556, 789289, 796514, 798750, 798753, 798770, 798818, 798826, 798829, 798833, 798837, 798845, 798846, 798870, 802251, 802278, 802288, 803822, 804303, 804380, 804394, 804396, 804399, 804614, 804615, 804638, 804639, 804644, 804648, 804652, 807854, 807861, 807869, 811259, 811335, 811366, 817633, 819066, 819152, 819153, 819157, 819160, 819759);

SELECT phc.post_id, phc.category_id, c.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_category phc INNER JOIN category c ON phc.category_id = c.category_id AND c.enabled = 1 LEFT JOIN category_translation f ON c.category_id = f.category_id  AND  f.lang_id=? LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id`  AND  `r`.`lang_id`=? WHERE phc.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1
  2
  153602
  162721
  274930
  396287
  427209
  451235
  527999
  539557
  555011
  571241
  574153
  576628
  576711
  576988
  577386
  605948
  614950
  615726
  615751
  620135
  622981
  625171
  641683
  659247
  676793
  676799
  689442
  693341
  704010
  759480
  762945
  771556
  789289
  796514
  798750
  798753
  798770
  798818
  798826
  798829
  798833
  798837
  798845
  798846
  798870
  802251
  802278
  802288
  803822
  804303
  804380
  804394
  804396
  804399
  804614
  804615
  804638
  804639
  804644
  804648
  804652
  807854
  807861
  807869
  811259
  811335
  811366
  817633
  819066
  819152
  819153
  819157
  819160
  819759
]

SELECT
  phc.post_id,
  phc.category_id,
  c.slug,
  IFNULL(`r`.`name`, `f`.`name`) as `name`
FROM
  post_has_category phc
  INNER JOIN category c ON phc.category_id = c.category_id
  AND c.enabled = 1
  LEFT JOIN category_translation f ON c.category_id = f.category_id
  AND f.lang_id = ?
  LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id`
  AND `r`.`lang_id` = ?
WHERE
  phc.post_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

SELECT phc.post_id, phc.category_id, c.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_category phc INNER JOIN category c ON phc.category_id = c.category_id AND c.enabled = 1 LEFT JOIN category_translation f ON c.category_id = f.category_id  AND  f.lang_id=1 LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id`  AND  `r`.`lang_id`=2 WHERE phc.post_id IN (153602, 162721, 274930, 396287, 427209, 451235, 527999, 539557, 555011, 571241, 574153, 576628, 576711, 576988, 577386, 605948, 614950, 615726, 615751, 620135, 622981, 625171, 641683, 659247, 676793, 676799, 689442, 693341, 704010, 759480, 762945, 771556, 789289, 796514, 798750, 798753, 798770, 798818, 798826, 798829, 798833, 798837, 798845, 798846, 798870, 802251, 802278, 802288, 803822, 804303, 804380, 804394, 804396, 804399, 804614, 804615, 804638, 804639, 804644, 804648, 804652, 807854, 807861, 807869, 811259, 811335, 811366, 817633, 819066, 819152, 819153, 819157, 819160, 819759);

SELECT `query_id` FROM `search_log` WHERE `query` = ?

[
  "hot italian"
]

SELECT
  `query_id`
FROM
  `search_log`
WHERE
  `query` = ?

SELECT `query_id` FROM `search_log` WHERE `query` = 'hot italian';

SELECT `trend_id` FROM `trend` WHERE `subject` = ?

[
  "hot italian"
]

SELECT
  `trend_id`
FROM
  `trend`
WHERE
  `subject` = ?

SELECT `trend_id` FROM `trend` WHERE `subject` = 'hot italian';

SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST (?) AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST (?)
              AND `query` <> ?
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT ?

[
  "hot italian"
  "hot italian"
  "hot italian"
  20
]

SELECT
  `query_id`,
  `cover`,
  `query`,
  MATCH (`query`) AGAINST (?) AS `relevance`
FROM
  `search_log`
WHERE
  MATCH (`query`) AGAINST (?)
  AND `query` <> ?
  AND `blocked` = 0
ORDER BY
  `relevance` DESC
LIMIT
  ?

SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST ('hot italian') AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST ('hot italian')
              AND `query` <> 'hot italian'
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT 20
        ;