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

[
  "big mommy pov"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'big mommy pov' 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
  816638
  724634
  718353
  663810
  824572
  809337
  814823
  811263
  631985
  629267
  739207
  796002
  791148
  716524
  531465
  631055
  434259
  407535
  664980
  696340
  426003
  625709
  563563
  815365
  539628
  459629
  450759
  453111
  476327
  425478
  728477
  593037
  433446
  742283
  492137
  434219
  416855
  476335
  442750
  416850
  460671
  471332
  503444
  462471
  449700
  605708
  610209
  570710
  421147
  531935
  451086
  472276
  461598
  568323
  680267
  435934
  519457
  521356
  525179
  519966
  521807
  468629
  458462
  524286
  448084
  456607
  470459
  460145
  442257
  525154
]

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 (816638, 724634, 718353, 663810, 824572, 809337, 814823, 811263, 631985, 629267, 739207, 796002, 791148, 716524, 531465, 631055, 434259, 407535, 664980, 696340, 426003, 625709, 563563, 815365, 539628, 459629, 450759, 453111, 476327, 425478, 728477, 593037, 433446, 742283, 492137, 434219, 416855, 476335, 442750, 416850, 460671, 471332, 503444, 462471, 449700, 605708, 610209, 570710, 421147, 531935, 451086, 472276, 461598, 568323, 680267, 435934, 519457, 521356, 525179, 519966, 521807, 468629, 458462, 524286, 448084, 456607, 470459, 460145, 442257, 525154);

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
  407535
  416850
  416855
  421147
  425478
  426003
  433446
  434219
  434259
  435934
  442257
  442750
  448084
  449700
  450759
  451086
  453111
  456607
  458462
  459629
  460145
  460671
  461598
  462471
  468629
  470459
  471332
  472276
  476327
  476335
  492137
  503444
  519457
  519966
  521356
  521807
  524286
  525154
  525179
  531465
  531935
  539628
  563563
  568323
  570710
  593037
  605708
  610209
  625709
  629267
  631055
  631985
  663810
  664980
  680267
  696340
  716524
  718353
  724634
  728477
  739207
  742283
  791148
  796002
  809337
  811263
  814823
  815365
  816638
  824572
]

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 (407535, 416850, 416855, 421147, 425478, 426003, 433446, 434219, 434259, 435934, 442257, 442750, 448084, 449700, 450759, 451086, 453111, 456607, 458462, 459629, 460145, 460671, 461598, 462471, 468629, 470459, 471332, 472276, 476327, 476335, 492137, 503444, 519457, 519966, 521356, 521807, 524286, 525154, 525179, 531465, 531935, 539628, 563563, 568323, 570710, 593037, 605708, 610209, 625709, 629267, 631055, 631985, 663810, 664980, 680267, 696340, 716524, 718353, 724634, 728477, 739207, 742283, 791148, 796002, 809337, 811263, 814823, 815365, 816638, 824572);

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
  407535
  416850
  416855
  421147
  425478
  426003
  433446
  434219
  434259
  435934
  442257
  442750
  448084
  449700
  450759
  451086
  453111
  456607
  458462
  459629
  460145
  460671
  461598
  462471
  468629
  470459
  471332
  472276
  476327
  476335
  492137
  503444
  519457
  519966
  521356
  521807
  524286
  525154
  525179
  531465
  531935
  539628
  563563
  568323
  570710
  593037
  605708
  610209
  625709
  629267
  631055
  631985
  663810
  664980
  680267
  696340
  716524
  718353
  724634
  728477
  739207
  742283
  791148
  796002
  809337
  811263
  814823
  815365
  816638
  824572
]

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 (407535, 416850, 416855, 421147, 425478, 426003, 433446, 434219, 434259, 435934, 442257, 442750, 448084, 449700, 450759, 451086, 453111, 456607, 458462, 459629, 460145, 460671, 461598, 462471, 468629, 470459, 471332, 472276, 476327, 476335, 492137, 503444, 519457, 519966, 521356, 521807, 524286, 525154, 525179, 531465, 531935, 539628, 563563, 568323, 570710, 593037, 605708, 610209, 625709, 629267, 631055, 631985, 663810, 664980, 680267, 696340, 716524, 718353, 724634, 728477, 739207, 742283, 791148, 796002, 809337, 811263, 814823, 815365, 816638, 824572);

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

[
  "большие mommy пов"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'большие mommy пов';

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

[
  "большие mommy пов"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'большие mommy пов';

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 ?

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