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

[
  "orgasm milf mom"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'orgasm milf mom' 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
  478986
  514731
  522711
  453702
  796642
  527641
  521698
  452975
  456061
  525728
  526821
  547751
  547779
  573194
  677838
  803756
  807589
  756609
  812426
  478985
  437434
  495617
  487548
  502729
  519717
  478991
  524497
  541118
  556645
  575031
  573760
  685836
  704218
  594491
  602578
  738503
  766335
  432334
  427592
  461843
  493816
  487228
  483392
  508737
  485057
  485064
  535076
  531214
  507557
  472544
  556646
  577620
  642022
  625165
  513328
  516039
  524075
  427946
  440620
  632038
  637741
  499089
  496518
  537672
  537670
  600995
  427981
  561970
  639810
  525226
  428761
  447679
  513001
  526220
]

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 (478986, 514731, 522711, 453702, 796642, 527641, 521698, 452975, 456061, 525728, 526821, 547751, 547779, 573194, 677838, 803756, 807589, 756609, 812426, 478985, 437434, 495617, 487548, 502729, 519717, 478991, 524497, 541118, 556645, 575031, 573760, 685836, 704218, 594491, 602578, 738503, 766335, 432334, 427592, 461843, 493816, 487228, 483392, 508737, 485057, 485064, 535076, 531214, 507557, 472544, 556646, 577620, 642022, 625165, 513328, 516039, 524075, 427946, 440620, 632038, 637741, 499089, 496518, 537672, 537670, 600995, 427981, 561970, 639810, 525226, 428761, 447679, 513001, 526220);

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
  427592
  427946
  427981
  428761
  432334
  437434
  440620
  447679
  452975
  453702
  456061
  461843
  472544
  478985
  478986
  478991
  483392
  485057
  485064
  487228
  487548
  493816
  495617
  496518
  499089
  502729
  507557
  508737
  513001
  513328
  514731
  516039
  519717
  521698
  522711
  524075
  524497
  525226
  525728
  526220
  526821
  527641
  531214
  535076
  537670
  537672
  541118
  547751
  547779
  556645
  556646
  561970
  573194
  573760
  575031
  577620
  594491
  600995
  602578
  625165
  632038
  637741
  639810
  642022
  677838
  685836
  704218
  738503
  756609
  766335
  803756
  807589
  812426
]

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 (427592, 427946, 427981, 428761, 432334, 437434, 440620, 447679, 452975, 453702, 456061, 461843, 472544, 478985, 478986, 478991, 483392, 485057, 485064, 487228, 487548, 493816, 495617, 496518, 499089, 502729, 507557, 508737, 513001, 513328, 514731, 516039, 519717, 521698, 522711, 524075, 524497, 525226, 525728, 526220, 526821, 527641, 531214, 535076, 537670, 537672, 541118, 547751, 547779, 556645, 556646, 561970, 573194, 573760, 575031, 577620, 594491, 600995, 602578, 625165, 632038, 637741, 639810, 642022, 677838, 685836, 704218, 738503, 756609, 766335, 803756, 807589, 812426);

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
  427592
  427946
  427981
  428761
  432334
  437434
  440620
  447679
  452975
  453702
  456061
  461843
  472544
  478985
  478986
  478991
  483392
  485057
  485064
  487228
  487548
  493816
  495617
  496518
  499089
  502729
  507557
  508737
  513001
  513328
  514731
  516039
  519717
  521698
  522711
  524075
  524497
  525226
  525728
  526220
  526821
  527641
  531214
  535076
  537670
  537672
  541118
  547751
  547779
  556645
  556646
  561970
  573194
  573760
  575031
  577620
  594491
  600995
  602578
  625165
  632038
  637741
  639810
  642022
  677838
  685836
  704218
  738503
  756609
  766335
  803756
  807589
  812426
]

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 (427592, 427946, 427981, 428761, 432334, 437434, 440620, 447679, 452975, 453702, 456061, 461843, 472544, 478985, 478986, 478991, 483392, 485057, 485064, 487228, 487548, 493816, 495617, 496518, 499089, 502729, 507557, 508737, 513001, 513328, 514731, 516039, 519717, 521698, 522711, 524075, 524497, 525226, 525728, 526220, 526821, 527641, 531214, 535076, 537670, 537672, 541118, 547751, 547779, 556645, 556646, 561970, 573194, 573760, 575031, 577620, 594491, 600995, 602578, 625165, 632038, 637741, 639810, 642022, 677838, 685836, 704218, 738503, 756609, 766335, 803756, 807589, 812426);

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

[
  "orgasm milf mom"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'orgasm milf mom';

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

[
  "orgasm milf mom"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'orgasm milf mom';

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 ?

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