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 virgin teens"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'russian virgin teens' 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
  501776
  501805
  413095
  677387
  447524
  447539
  473974
  475172
  508747
  518548
  519661
  501774
  527057
  515665
  552073
  671685
  654459
  559578
  565674
  586449
  398676
  520497
  489370
  501784
  514033
  489606
  526841
  771591
  553276
  576096
  552296
  447513
  447146
  447435
  555571
  565188
  565279
  672671
  659439
  551147
  592314
  608878
  596412
  386460
  384306
  435374
  463674
  476823
  455653
  501752
  501804
  490079
  586597
  554253
  558958
  677020
  569933
  501748
  501732
  513768
  593939
  677060
  558905
  517358
  529497
  589509
  618442
  619192
  623404
  599452
  603167
  677025
]

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 (501776, 501805, 413095, 677387, 447524, 447539, 473974, 475172, 508747, 518548, 519661, 501774, 527057, 515665, 552073, 671685, 654459, 559578, 565674, 586449, 398676, 520497, 489370, 501784, 514033, 489606, 526841, 771591, 553276, 576096, 552296, 447513, 447146, 447435, 555571, 565188, 565279, 672671, 659439, 551147, 592314, 608878, 596412, 386460, 384306, 435374, 463674, 476823, 455653, 501752, 501804, 490079, 586597, 554253, 558958, 677020, 569933, 501748, 501732, 513768, 593939, 677060, 558905, 517358, 529497, 589509, 618442, 619192, 623404, 599452, 603167, 677025);

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
  384306
  386460
  398676
  413095
  435374
  447146
  447435
  447513
  447524
  447539
  455653
  463674
  473974
  475172
  476823
  489370
  489606
  490079
  501732
  501748
  501752
  501774
  501776
  501784
  501804
  501805
  508747
  513768
  514033
  515665
  517358
  518548
  519661
  520497
  526841
  527057
  529497
  551147
  552073
  552296
  553276
  554253
  555571
  558905
  558958
  559578
  565188
  565279
  565674
  569933
  576096
  586449
  586597
  589509
  592314
  593939
  596412
  599452
  603167
  608878
  618442
  619192
  623404
  654459
  659439
  671685
  672671
  677020
  677025
  677060
  677387
  771591
]

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 (384306, 386460, 398676, 413095, 435374, 447146, 447435, 447513, 447524, 447539, 455653, 463674, 473974, 475172, 476823, 489370, 489606, 490079, 501732, 501748, 501752, 501774, 501776, 501784, 501804, 501805, 508747, 513768, 514033, 515665, 517358, 518548, 519661, 520497, 526841, 527057, 529497, 551147, 552073, 552296, 553276, 554253, 555571, 558905, 558958, 559578, 565188, 565279, 565674, 569933, 576096, 586449, 586597, 589509, 592314, 593939, 596412, 599452, 603167, 608878, 618442, 619192, 623404, 654459, 659439, 671685, 672671, 677020, 677025, 677060, 677387, 771591);

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
  384306
  386460
  398676
  413095
  435374
  447146
  447435
  447513
  447524
  447539
  455653
  463674
  473974
  475172
  476823
  489370
  489606
  490079
  501732
  501748
  501752
  501774
  501776
  501784
  501804
  501805
  508747
  513768
  514033
  515665
  517358
  518548
  519661
  520497
  526841
  527057
  529497
  551147
  552073
  552296
  553276
  554253
  555571
  558905
  558958
  559578
  565188
  565279
  565674
  569933
  576096
  586449
  586597
  589509
  592314
  593939
  596412
  599452
  603167
  608878
  618442
  619192
  623404
  654459
  659439
  671685
  672671
  677020
  677025
  677060
  677387
  771591
]

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 (384306, 386460, 398676, 413095, 435374, 447146, 447435, 447513, 447524, 447539, 455653, 463674, 473974, 475172, 476823, 489370, 489606, 490079, 501732, 501748, 501752, 501774, 501776, 501784, 501804, 501805, 508747, 513768, 514033, 515665, 517358, 518548, 519661, 520497, 526841, 527057, 529497, 551147, 552073, 552296, 553276, 554253, 555571, 558905, 558958, 559578, 565188, 565279, 565674, 569933, 576096, 586449, 586597, 589509, 592314, 593939, 596412, 599452, 603167, 608878, 618442, 619192, 623404, 654459, 659439, 671685, 672671, 677020, 677025, 677060, 677387, 771591);

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

[
  "русск virgin teens"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'русск virgin teens';

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

[
  "русск virgin teens"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'русск virgin teens';

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