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
  445666
  458014
  474836
  460040
  411736
  187840
  498228
  453471
  465592
  476262
  804940
  388729
  447796
  450108
  188062
  488370
  476239
  474496
  388732
  496346
  470685
  485715
  549228
  397849
  402876
  452637
  388785
  474125
  154133
  780724
  677971
  476164
  549255
  521131
  453100
  662898
  735442
  385991
  398567
  398530
  485713
  545985
  733265
  395465
  407760
  409931
  515693
  506066
  636466
  794669
  745951
  387951
  466989
  483355
  442634
  411820
  424248
  521123
  390447
  413465
  459643
  523564
  469575
  475676
  678794
  387856
  446536
  159305
  426550
  443148
  650614
  468127
  413972
  533534
]

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 (445666, 458014, 474836, 460040, 411736, 187840, 498228, 453471, 465592, 476262, 804940, 388729, 447796, 450108, 188062, 488370, 476239, 474496, 388732, 496346, 470685, 485715, 549228, 397849, 402876, 452637, 388785, 474125, 154133, 780724, 677971, 476164, 549255, 521131, 453100, 662898, 735442, 385991, 398567, 398530, 485713, 545985, 733265, 395465, 407760, 409931, 515693, 506066, 636466, 794669, 745951, 387951, 466989, 483355, 442634, 411820, 424248, 521123, 390447, 413465, 459643, 523564, 469575, 475676, 678794, 387856, 446536, 159305, 426550, 443148, 650614, 468127, 413972, 533534);

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
  154133
  159305
  187840
  188062
  385991
  387856
  387951
  388729
  388732
  388785
  390447
  395465
  397849
  398530
  398567
  402876
  407760
  409931
  411736
  411820
  413465
  413972
  424248
  426550
  442634
  443148
  445666
  446536
  447796
  450108
  452637
  453100
  453471
  458014
  459643
  460040
  465592
  466989
  468127
  469575
  470685
  474125
  474496
  474836
  475676
  476164
  476239
  476262
  483355
  485713
  485715
  488370
  496346
  498228
  506066
  515693
  521123
  521131
  523564
  533534
  545985
  549228
  549255
  636466
  650614
  662898
  677971
  678794
  733265
  735442
  745951
  780724
  794669
  804940
]

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 (154133, 159305, 187840, 188062, 385991, 387856, 387951, 388729, 388732, 388785, 390447, 395465, 397849, 398530, 398567, 402876, 407760, 409931, 411736, 411820, 413465, 413972, 424248, 426550, 442634, 443148, 445666, 446536, 447796, 450108, 452637, 453100, 453471, 458014, 459643, 460040, 465592, 466989, 468127, 469575, 470685, 474125, 474496, 474836, 475676, 476164, 476239, 476262, 483355, 485713, 485715, 488370, 496346, 498228, 506066, 515693, 521123, 521131, 523564, 533534, 545985, 549228, 549255, 636466, 650614, 662898, 677971, 678794, 733265, 735442, 745951, 780724, 794669, 804940);

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
  154133
  159305
  187840
  188062
  385991
  387856
  387951
  388729
  388732
  388785
  390447
  395465
  397849
  398530
  398567
  402876
  407760
  409931
  411736
  411820
  413465
  413972
  424248
  426550
  442634
  443148
  445666
  446536
  447796
  450108
  452637
  453100
  453471
  458014
  459643
  460040
  465592
  466989
  468127
  469575
  470685
  474125
  474496
  474836
  475676
  476164
  476239
  476262
  483355
  485713
  485715
  488370
  496346
  498228
  506066
  515693
  521123
  521131
  523564
  533534
  545985
  549228
  549255
  636466
  650614
  662898
  677971
  678794
  733265
  735442
  745951
  780724
  794669
  804940
]

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 (154133, 159305, 187840, 188062, 385991, 387856, 387951, 388729, 388732, 388785, 390447, 395465, 397849, 398530, 398567, 402876, 407760, 409931, 411736, 411820, 413465, 413972, 424248, 426550, 442634, 443148, 445666, 446536, 447796, 450108, 452637, 453100, 453471, 458014, 459643, 460040, 465592, 466989, 468127, 469575, 470685, 474125, 474496, 474836, 475676, 476164, 476239, 476262, 483355, 485713, 485715, 488370, 496346, 498228, 506066, 515693, 521123, 521131, 523564, 533534, 545985, 549228, 549255, 636466, 650614, 662898, 677971, 678794, 733265, 735442, 745951, 780724, 794669, 804940);

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
        ;