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

[
  "порнь вписка"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'порнь вписка' 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
  667130
  687859
  576138
  464778
  679149
  610725
  579009
  663832
  510381
  684421
  581139
  591175
  782361
  663758
  613882
  526302
  713989
  642121
  768744
  697506
  788006
  745708
  479288
  484024
  655529
  510387
  524095
  492043
  574079
  651780
  667043
  570110
  689933
  373494
  555654
  4297
  509758
  455315
  395788
  483258
  477924
  562254
  788007
  461401
  561865
  562257
  572819
  542964
  565406
  567810
  478556
  521972
  502973
  523302
  465189
  562256
  578363
  578380
  427515
  528648
  484830
  497563
  407819
  460695
  484228
  562245
  603236
  486391
  461420
  523301
  568450
  548490
]

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 (667130, 687859, 576138, 464778, 679149, 610725, 579009, 663832, 510381, 684421, 581139, 591175, 782361, 663758, 613882, 526302, 713989, 642121, 768744, 697506, 788006, 745708, 479288, 484024, 655529, 510387, 524095, 492043, 574079, 651780, 667043, 570110, 689933, 373494, 555654, 4297, 509758, 455315, 395788, 483258, 477924, 562254, 788007, 461401, 561865, 562257, 572819, 542964, 565406, 567810, 478556, 521972, 502973, 523302, 465189, 562256, 578363, 578380, 427515, 528648, 484830, 497563, 407819, 460695, 484228, 562245, 603236, 486391, 461420, 523301, 568450, 548490);

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
  4297
  373494
  395788
  407819
  427515
  455315
  460695
  461401
  461420
  464778
  465189
  477924
  478556
  479288
  483258
  484024
  484228
  484830
  486391
  492043
  497563
  502973
  509758
  510381
  510387
  521972
  523301
  523302
  524095
  526302
  528648
  542964
  548490
  555654
  561865
  562245
  562254
  562256
  562257
  565406
  567810
  568450
  570110
  572819
  574079
  576138
  578363
  578380
  579009
  581139
  591175
  603236
  610725
  613882
  642121
  651780
  655529
  663758
  663832
  667043
  667130
  679149
  684421
  687859
  689933
  697506
  713989
  745708
  768744
  782361
  788006
  788007
]

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 (4297, 373494, 395788, 407819, 427515, 455315, 460695, 461401, 461420, 464778, 465189, 477924, 478556, 479288, 483258, 484024, 484228, 484830, 486391, 492043, 497563, 502973, 509758, 510381, 510387, 521972, 523301, 523302, 524095, 526302, 528648, 542964, 548490, 555654, 561865, 562245, 562254, 562256, 562257, 565406, 567810, 568450, 570110, 572819, 574079, 576138, 578363, 578380, 579009, 581139, 591175, 603236, 610725, 613882, 642121, 651780, 655529, 663758, 663832, 667043, 667130, 679149, 684421, 687859, 689933, 697506, 713989, 745708, 768744, 782361, 788006, 788007);

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
  4297
  373494
  395788
  407819
  427515
  455315
  460695
  461401
  461420
  464778
  465189
  477924
  478556
  479288
  483258
  484024
  484228
  484830
  486391
  492043
  497563
  502973
  509758
  510381
  510387
  521972
  523301
  523302
  524095
  526302
  528648
  542964
  548490
  555654
  561865
  562245
  562254
  562256
  562257
  565406
  567810
  568450
  570110
  572819
  574079
  576138
  578363
  578380
  579009
  581139
  591175
  603236
  610725
  613882
  642121
  651780
  655529
  663758
  663832
  667043
  667130
  679149
  684421
  687859
  689933
  697506
  713989
  745708
  768744
  782361
  788006
  788007
]

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 (4297, 373494, 395788, 407819, 427515, 455315, 460695, 461401, 461420, 464778, 465189, 477924, 478556, 479288, 483258, 484024, 484228, 484830, 486391, 492043, 497563, 502973, 509758, 510381, 510387, 521972, 523301, 523302, 524095, 526302, 528648, 542964, 548490, 555654, 561865, 562245, 562254, 562256, 562257, 565406, 567810, 568450, 570110, 572819, 574079, 576138, 578363, 578380, 579009, 581139, 591175, 603236, 610725, 613882, 642121, 651780, 655529, 663758, 663832, 667043, 667130, 679149, 684421, 687859, 689933, 697506, 713989, 745708, 768744, 782361, 788006, 788007);

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

[
  "порн вписк"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'порн вписк';

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

[
  "порн вписк"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'порн вписк';

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 ?

[
  "порнь вписка"
  "порнь вписка"
  "порнь вписка"
  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 ('порнь вписка') AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST ('порнь вписка')
              AND `query` <> 'порнь вписка'
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT 20
        ;