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
  799878
  560013
  633557
  484549
  385442
  494198
  761228
  506575
  667916
  659434
  802009
  444150
  308331
  429198
  503020
  423804
  726049
  503771
  752800
  509214
  488905
  644854
  505462
  483330
  565382
  601863
  550946
  755819
  523938
  524580
  578060
  553642
  551042
  494591
  570756
  527163
  649136
  550601
  436427
  524226
  511882
  635687
  426722
  457708
  490529
  486459
  539057
  586578
  493933
  469381
  569082
  482847
  451064
  565362
  395573
  540247
  502538
  555429
  527975
  527560
  523161
  562361
  486199
  564918
  595885
  593008
  591169
  622838
  662137
  590448
  562258
  627725
  650224
]

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 (799878, 560013, 633557, 484549, 385442, 494198, 761228, 506575, 667916, 659434, 802009, 444150, 308331, 429198, 503020, 423804, 726049, 503771, 752800, 509214, 488905, 644854, 505462, 483330, 565382, 601863, 550946, 755819, 523938, 524580, 578060, 553642, 551042, 494591, 570756, 527163, 649136, 550601, 436427, 524226, 511882, 635687, 426722, 457708, 490529, 486459, 539057, 586578, 493933, 469381, 569082, 482847, 451064, 565362, 395573, 540247, 502538, 555429, 527975, 527560, 523161, 562361, 486199, 564918, 595885, 593008, 591169, 622838, 662137, 590448, 562258, 627725, 650224);

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
  308331
  385442
  395573
  423804
  426722
  429198
  436427
  444150
  451064
  457708
  469381
  482847
  483330
  484549
  486199
  486459
  488905
  490529
  493933
  494198
  494591
  502538
  503020
  503771
  505462
  506575
  509214
  511882
  523161
  523938
  524226
  524580
  527163
  527560
  527975
  539057
  540247
  550601
  550946
  551042
  553642
  555429
  560013
  562258
  562361
  564918
  565362
  565382
  569082
  570756
  578060
  586578
  590448
  591169
  593008
  595885
  601863
  622838
  627725
  633557
  635687
  644854
  649136
  650224
  659434
  662137
  667916
  726049
  752800
  755819
  761228
  799878
  802009
]

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 (308331, 385442, 395573, 423804, 426722, 429198, 436427, 444150, 451064, 457708, 469381, 482847, 483330, 484549, 486199, 486459, 488905, 490529, 493933, 494198, 494591, 502538, 503020, 503771, 505462, 506575, 509214, 511882, 523161, 523938, 524226, 524580, 527163, 527560, 527975, 539057, 540247, 550601, 550946, 551042, 553642, 555429, 560013, 562258, 562361, 564918, 565362, 565382, 569082, 570756, 578060, 586578, 590448, 591169, 593008, 595885, 601863, 622838, 627725, 633557, 635687, 644854, 649136, 650224, 659434, 662137, 667916, 726049, 752800, 755819, 761228, 799878, 802009);

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
  308331
  385442
  395573
  423804
  426722
  429198
  436427
  444150
  451064
  457708
  469381
  482847
  483330
  484549
  486199
  486459
  488905
  490529
  493933
  494198
  494591
  502538
  503020
  503771
  505462
  506575
  509214
  511882
  523161
  523938
  524226
  524580
  527163
  527560
  527975
  539057
  540247
  550601
  550946
  551042
  553642
  555429
  560013
  562258
  562361
  564918
  565362
  565382
  569082
  570756
  578060
  586578
  590448
  591169
  593008
  595885
  601863
  622838
  627725
  633557
  635687
  644854
  649136
  650224
  659434
  662137
  667916
  726049
  752800
  755819
  761228
  799878
  802009
]

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 (308331, 385442, 395573, 423804, 426722, 429198, 436427, 444150, 451064, 457708, 469381, 482847, 483330, 484549, 486199, 486459, 488905, 490529, 493933, 494198, 494591, 502538, 503020, 503771, 505462, 506575, 509214, 511882, 523161, 523938, 524226, 524580, 527163, 527560, 527975, 539057, 540247, 550601, 550946, 551042, 553642, 555429, 560013, 562258, 562361, 564918, 565362, 565382, 569082, 570756, 578060, 586578, 590448, 591169, 593008, 595885, 601863, 622838, 627725, 633557, 635687, 644854, 649136, 650224, 659434, 662137, 667916, 726049, 752800, 755819, 761228, 799878, 802009);

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
        ;