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

[
  "russian gangbang homemade"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'russian gangbang homemade' 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
  708144
  716804
  470617
  560451
  422257
  470047
  484387
  484563
  431805
  443761
  544181
  451574
  506259
  476015
  543658
  484693
  546671
  490762
  696870
  699844
  485703
  534143
  696865
  556431
  598569
  446314
  614627
  566432
  567539
  391941
  745404
  692450
  470631
  619204
  455611
  423940
  603891
  569593
  551170
  775960
  775967
  382381
  484392
  484389
  545377
  775848
  547997
  591804
  775866
  755176
  775963
  546993
  567581
  557938
  716030
  775958
  540955
  590560
  576052
  560446
  600061
  714511
  671863
  557985
  730798
  521866
  621612
  603906
  587864
]

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 (708144, 716804, 470617, 560451, 422257, 470047, 484387, 484563, 431805, 443761, 544181, 451574, 506259, 476015, 543658, 484693, 546671, 490762, 696870, 699844, 485703, 534143, 696865, 556431, 598569, 446314, 614627, 566432, 567539, 391941, 745404, 692450, 470631, 619204, 455611, 423940, 603891, 569593, 551170, 775960, 775967, 382381, 484392, 484389, 545377, 775848, 547997, 591804, 775866, 755176, 775963, 546993, 567581, 557938, 716030, 775958, 540955, 590560, 576052, 560446, 600061, 714511, 671863, 557985, 730798, 521866, 621612, 603906, 587864);

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
  382381
  391941
  422257
  423940
  431805
  443761
  446314
  451574
  455611
  470047
  470617
  470631
  476015
  484387
  484389
  484392
  484563
  484693
  485703
  490762
  506259
  521866
  534143
  540955
  543658
  544181
  545377
  546671
  546993
  547997
  551170
  556431
  557938
  557985
  560446
  560451
  566432
  567539
  567581
  569593
  576052
  587864
  590560
  591804
  598569
  600061
  603891
  603906
  614627
  619204
  621612
  671863
  692450
  696865
  696870
  699844
  708144
  714511
  716030
  716804
  730798
  745404
  755176
  775848
  775866
  775958
  775960
  775963
  775967
]

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 (382381, 391941, 422257, 423940, 431805, 443761, 446314, 451574, 455611, 470047, 470617, 470631, 476015, 484387, 484389, 484392, 484563, 484693, 485703, 490762, 506259, 521866, 534143, 540955, 543658, 544181, 545377, 546671, 546993, 547997, 551170, 556431, 557938, 557985, 560446, 560451, 566432, 567539, 567581, 569593, 576052, 587864, 590560, 591804, 598569, 600061, 603891, 603906, 614627, 619204, 621612, 671863, 692450, 696865, 696870, 699844, 708144, 714511, 716030, 716804, 730798, 745404, 755176, 775848, 775866, 775958, 775960, 775963, 775967);

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
  382381
  391941
  422257
  423940
  431805
  443761
  446314
  451574
  455611
  470047
  470617
  470631
  476015
  484387
  484389
  484392
  484563
  484693
  485703
  490762
  506259
  521866
  534143
  540955
  543658
  544181
  545377
  546671
  546993
  547997
  551170
  556431
  557938
  557985
  560446
  560451
  566432
  567539
  567581
  569593
  576052
  587864
  590560
  591804
  598569
  600061
  603891
  603906
  614627
  619204
  621612
  671863
  692450
  696865
  696870
  699844
  708144
  714511
  716030
  716804
  730798
  745404
  755176
  775848
  775866
  775958
  775960
  775963
  775967
]

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 (382381, 391941, 422257, 423940, 431805, 443761, 446314, 451574, 455611, 470047, 470617, 470631, 476015, 484387, 484389, 484392, 484563, 484693, 485703, 490762, 506259, 521866, 534143, 540955, 543658, 544181, 545377, 546671, 546993, 547997, 551170, 556431, 557938, 557985, 560446, 560451, 566432, 567539, 567581, 569593, 576052, 587864, 590560, 591804, 598569, 600061, 603891, 603906, 614627, 619204, 621612, 671863, 692450, 696865, 696870, 699844, 708144, 714511, 716030, 716804, 730798, 745404, 755176, 775848, 775866, 775958, 775960, 775963, 775967);

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

[
  "русск gangbang домашн любительск"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'русск gangbang домашн любительск';

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

[
  "русск gangbang домашн любительск"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'русск gangbang домашн любительск';

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 ?

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