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
  395672
  385408
  524338
  560390
  389729
  484562
  587072
  795737
  609584
  566801
  799105
  813451
  720511
  720468
  720516
  555182
  720514
  799018
  779557
  441994
  757070
  770231
  770131
  388318
  601840
  794623
  680888
  463295
  432695
  720529
  524805
  514823
  798081
  575696
  440835
  720545
  774764
  583607
  424425
  605480
  650576
  492049
  756388
  514776
  484014
  788602
  581292
  681895
  542530
  581098
  507582
  480553
  546713
  578285
  675523
  523840
  552812
  529153
  482317
  809932
  456999
  469500
  509384
  577393
  615689
  484249
  539651
  601551
  569967
  573742
  546058
  573315
  603035
  519242
]

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 (395672, 385408, 524338, 560390, 389729, 484562, 587072, 795737, 609584, 566801, 799105, 813451, 720511, 720468, 720516, 555182, 720514, 799018, 779557, 441994, 757070, 770231, 770131, 388318, 601840, 794623, 680888, 463295, 432695, 720529, 524805, 514823, 798081, 575696, 440835, 720545, 774764, 583607, 424425, 605480, 650576, 492049, 756388, 514776, 484014, 788602, 581292, 681895, 542530, 581098, 507582, 480553, 546713, 578285, 675523, 523840, 552812, 529153, 482317, 809932, 456999, 469500, 509384, 577393, 615689, 484249, 539651, 601551, 569967, 573742, 546058, 573315, 603035, 519242);

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
  385408
  388318
  389729
  395672
  424425
  432695
  440835
  441994
  456999
  463295
  469500
  480553
  482317
  484014
  484249
  484562
  492049
  507582
  509384
  514776
  514823
  519242
  523840
  524338
  524805
  529153
  539651
  542530
  546058
  546713
  552812
  555182
  560390
  566801
  569967
  573315
  573742
  575696
  577393
  578285
  581098
  581292
  583607
  587072
  601551
  601840
  603035
  605480
  609584
  615689
  650576
  675523
  680888
  681895
  720468
  720511
  720514
  720516
  720529
  720545
  756388
  757070
  770131
  770231
  774764
  779557
  788602
  794623
  795737
  798081
  799018
  799105
  809932
  813451
]

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 (385408, 388318, 389729, 395672, 424425, 432695, 440835, 441994, 456999, 463295, 469500, 480553, 482317, 484014, 484249, 484562, 492049, 507582, 509384, 514776, 514823, 519242, 523840, 524338, 524805, 529153, 539651, 542530, 546058, 546713, 552812, 555182, 560390, 566801, 569967, 573315, 573742, 575696, 577393, 578285, 581098, 581292, 583607, 587072, 601551, 601840, 603035, 605480, 609584, 615689, 650576, 675523, 680888, 681895, 720468, 720511, 720514, 720516, 720529, 720545, 756388, 757070, 770131, 770231, 774764, 779557, 788602, 794623, 795737, 798081, 799018, 799105, 809932, 813451);

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
  385408
  388318
  389729
  395672
  424425
  432695
  440835
  441994
  456999
  463295
  469500
  480553
  482317
  484014
  484249
  484562
  492049
  507582
  509384
  514776
  514823
  519242
  523840
  524338
  524805
  529153
  539651
  542530
  546058
  546713
  552812
  555182
  560390
  566801
  569967
  573315
  573742
  575696
  577393
  578285
  581098
  581292
  583607
  587072
  601551
  601840
  603035
  605480
  609584
  615689
  650576
  675523
  680888
  681895
  720468
  720511
  720514
  720516
  720529
  720545
  756388
  757070
  770131
  770231
  774764
  779557
  788602
  794623
  795737
  798081
  799018
  799105
  809932
  813451
]

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 (385408, 388318, 389729, 395672, 424425, 432695, 440835, 441994, 456999, 463295, 469500, 480553, 482317, 484014, 484249, 484562, 492049, 507582, 509384, 514776, 514823, 519242, 523840, 524338, 524805, 529153, 539651, 542530, 546058, 546713, 552812, 555182, 560390, 566801, 569967, 573315, 573742, 575696, 577393, 578285, 581098, 581292, 583607, 587072, 601551, 601840, 603035, 605480, 609584, 615689, 650576, 675523, 680888, 681895, 720468, 720511, 720514, 720516, 720529, 720545, 756388, 757070, 770131, 770231, 774764, 779557, 788602, 794623, 795737, 798081, 799018, 799105, 809932, 813451);

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
        ;