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

[
  "caught anal"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'caught anal' 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
  735515
  449872
  446612
  511828
  393105
  432982
  486810
  585477
  599677
  790882
  790409
  809782
  809899
  787120
  770270
  708810
  447735
  428488
  486077
  792619
  413960
  424995
  457991
  518049
  426476
  669240
  761620
  404952
  562637
  633533
  807985
  478186
  486380
  776481
  724758
  476333
  576636
  609221
  585395
  453187
  466204
  528163
  441978
  703480
  502762
  531090
  680671
  607470
  452594
  530483
  599725
  807407
  515833
  437137
  483897
  529177
  382498
  524322
  598863
  616956
  421155
  599726
  431422
  489729
  187962
  505679
  647960
  513017
  623727
  507681
  680267
  619527
  626944
  527966
]

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 (735515, 449872, 446612, 511828, 393105, 432982, 486810, 585477, 599677, 790882, 790409, 809782, 809899, 787120, 770270, 708810, 447735, 428488, 486077, 792619, 413960, 424995, 457991, 518049, 426476, 669240, 761620, 404952, 562637, 633533, 807985, 478186, 486380, 776481, 724758, 476333, 576636, 609221, 585395, 453187, 466204, 528163, 441978, 703480, 502762, 531090, 680671, 607470, 452594, 530483, 599725, 807407, 515833, 437137, 483897, 529177, 382498, 524322, 598863, 616956, 421155, 599726, 431422, 489729, 187962, 505679, 647960, 513017, 623727, 507681, 680267, 619527, 626944, 527966);

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
  187962
  382498
  393105
  404952
  413960
  421155
  424995
  426476
  428488
  431422
  432982
  437137
  441978
  446612
  447735
  449872
  452594
  453187
  457991
  466204
  476333
  478186
  483897
  486077
  486380
  486810
  489729
  502762
  505679
  507681
  511828
  513017
  515833
  518049
  524322
  527966
  528163
  529177
  530483
  531090
  562637
  576636
  585395
  585477
  598863
  599677
  599725
  599726
  607470
  609221
  616956
  619527
  623727
  626944
  633533
  647960
  669240
  680267
  680671
  703480
  708810
  724758
  735515
  761620
  770270
  776481
  787120
  790409
  790882
  792619
  807407
  807985
  809782
  809899
]

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 (187962, 382498, 393105, 404952, 413960, 421155, 424995, 426476, 428488, 431422, 432982, 437137, 441978, 446612, 447735, 449872, 452594, 453187, 457991, 466204, 476333, 478186, 483897, 486077, 486380, 486810, 489729, 502762, 505679, 507681, 511828, 513017, 515833, 518049, 524322, 527966, 528163, 529177, 530483, 531090, 562637, 576636, 585395, 585477, 598863, 599677, 599725, 599726, 607470, 609221, 616956, 619527, 623727, 626944, 633533, 647960, 669240, 680267, 680671, 703480, 708810, 724758, 735515, 761620, 770270, 776481, 787120, 790409, 790882, 792619, 807407, 807985, 809782, 809899);

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
  187962
  382498
  393105
  404952
  413960
  421155
  424995
  426476
  428488
  431422
  432982
  437137
  441978
  446612
  447735
  449872
  452594
  453187
  457991
  466204
  476333
  478186
  483897
  486077
  486380
  486810
  489729
  502762
  505679
  507681
  511828
  513017
  515833
  518049
  524322
  527966
  528163
  529177
  530483
  531090
  562637
  576636
  585395
  585477
  598863
  599677
  599725
  599726
  607470
  609221
  616956
  619527
  623727
  626944
  633533
  647960
  669240
  680267
  680671
  703480
  708810
  724758
  735515
  761620
  770270
  776481
  787120
  790409
  790882
  792619
  807407
  807985
  809782
  809899
]

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 (187962, 382498, 393105, 404952, 413960, 421155, 424995, 426476, 428488, 431422, 432982, 437137, 441978, 446612, 447735, 449872, 452594, 453187, 457991, 466204, 476333, 478186, 483897, 486077, 486380, 486810, 489729, 502762, 505679, 507681, 511828, 513017, 515833, 518049, 524322, 527966, 528163, 529177, 530483, 531090, 562637, 576636, 585395, 585477, 598863, 599677, 599725, 599726, 607470, 609221, 616956, 619527, 623727, 626944, 633533, 647960, 669240, 680267, 680671, 703480, 708810, 724758, 735515, 761620, 770270, 776481, 787120, 790409, 790882, 792619, 807407, 807985, 809782, 809899);

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

[
  "caught анал"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'caught анал';

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

[
  "caught анал"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'caught анал';

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 ?

[
  "caught anal"
  "caught anal"
  "caught anal"
  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 ('caught anal') AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST ('caught anal')
              AND `query` <> 'caught anal'
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT 20
        ;