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
  388691
  496670
  426813
  755733
  461448
  721489
  668140
  563137
  512239
  479088
  463232
  475843
  498255
  572171
  517872
  437258
  500024
  495483
  432325
  562887
  575084
  455482
  523163
  517316
  579215
  433064
  521391
  479352
  513616
  578724
  561659
  496956
  501282
  526278
  682719
  493236
  563221
  518798
  506287
  563146
  511528
  563133
  604097
  504864
  563223
  658269
  467428
  558863
  508489
  510501
  486116
  512698
  452553
  608407
  614521
  506081
  527355
  555870
  584105
  599368
  465394
  659842
  655410
  659323
  608560
  618334
  598158
  585144
  613179
  653244
  608771
]

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 (388691, 496670, 426813, 755733, 461448, 721489, 668140, 563137, 512239, 479088, 463232, 475843, 498255, 572171, 517872, 437258, 500024, 495483, 432325, 562887, 575084, 455482, 523163, 517316, 579215, 433064, 521391, 479352, 513616, 578724, 561659, 496956, 501282, 526278, 682719, 493236, 563221, 518798, 506287, 563146, 511528, 563133, 604097, 504864, 563223, 658269, 467428, 558863, 508489, 510501, 486116, 512698, 452553, 608407, 614521, 506081, 527355, 555870, 584105, 599368, 465394, 659842, 655410, 659323, 608560, 618334, 598158, 585144, 613179, 653244, 608771);

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
  388691
  426813
  432325
  433064
  437258
  452553
  455482
  461448
  463232
  465394
  467428
  475843
  479088
  479352
  486116
  493236
  495483
  496670
  496956
  498255
  500024
  501282
  504864
  506081
  506287
  508489
  510501
  511528
  512239
  512698
  513616
  517316
  517872
  518798
  521391
  523163
  526278
  527355
  555870
  558863
  561659
  562887
  563133
  563137
  563146
  563221
  563223
  572171
  575084
  578724
  579215
  584105
  585144
  598158
  599368
  604097
  608407
  608560
  608771
  613179
  614521
  618334
  653244
  655410
  658269
  659323
  659842
  668140
  682719
  721489
  755733
]

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 (388691, 426813, 432325, 433064, 437258, 452553, 455482, 461448, 463232, 465394, 467428, 475843, 479088, 479352, 486116, 493236, 495483, 496670, 496956, 498255, 500024, 501282, 504864, 506081, 506287, 508489, 510501, 511528, 512239, 512698, 513616, 517316, 517872, 518798, 521391, 523163, 526278, 527355, 555870, 558863, 561659, 562887, 563133, 563137, 563146, 563221, 563223, 572171, 575084, 578724, 579215, 584105, 585144, 598158, 599368, 604097, 608407, 608560, 608771, 613179, 614521, 618334, 653244, 655410, 658269, 659323, 659842, 668140, 682719, 721489, 755733);

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
  388691
  426813
  432325
  433064
  437258
  452553
  455482
  461448
  463232
  465394
  467428
  475843
  479088
  479352
  486116
  493236
  495483
  496670
  496956
  498255
  500024
  501282
  504864
  506081
  506287
  508489
  510501
  511528
  512239
  512698
  513616
  517316
  517872
  518798
  521391
  523163
  526278
  527355
  555870
  558863
  561659
  562887
  563133
  563137
  563146
  563221
  563223
  572171
  575084
  578724
  579215
  584105
  585144
  598158
  599368
  604097
  608407
  608560
  608771
  613179
  614521
  618334
  653244
  655410
  658269
  659323
  659842
  668140
  682719
  721489
  755733
]

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 (388691, 426813, 432325, 433064, 437258, 452553, 455482, 461448, 463232, 465394, 467428, 475843, 479088, 479352, 486116, 493236, 495483, 496670, 496956, 498255, 500024, 501282, 504864, 506081, 506287, 508489, 510501, 511528, 512239, 512698, 513616, 517316, 517872, 518798, 521391, 523163, 526278, 527355, 555870, 558863, 561659, 562887, 563133, 563137, 563146, 563221, 563223, 572171, 575084, 578724, 579215, 584105, 585144, 598158, 599368, 604097, 608407, 608560, 608771, 613179, 614521, 618334, 653244, 655410, 658269, 659323, 659842, 668140, 682719, 721489, 755733);

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
        ;