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

[
  "granny anus"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'granny anus' 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
  458014
  187840
  804940
  398530
  485713
  474496
  442634
  485715
  498228
  402876
  154133
  780724
  188062
  476164
  468127
  662898
  735442
  385991
  398567
  439813
  388729
  450108
  545985
  733265
  395465
  407760
  474836
  515693
  506066
  636466
  794669
  745951
  387951
  388732
  460040
  496346
  489313
  549255
  420152
  411820
  424248
  549228
  445666
  521123
  390447
  397849
  452637
  453471
  459643
  465592
  476262
  523564
  469575
  475676
  678794
  387856
  388785
  446536
  159305
  463260
  411736
  488370
  476239
  458623
  650614
  453100
  466989
  484624
  470685
  521131
  474125
  550434
  483355
]

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

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
  411736
  411820
  420152
  424248
  439813
  442634
  445666
  446536
  450108
  452637
  453100
  453471
  458014
  458623
  459643
  460040
  463260
  465592
  466989
  468127
  469575
  470685
  474125
  474496
  474836
  475676
  476164
  476239
  476262
  483355
  484624
  485713
  485715
  488370
  489313
  496346
  498228
  506066
  515693
  521123
  521131
  523564
  545985
  549228
  549255
  550434
  636466
  650614
  662898
  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, 411736, 411820, 420152, 424248, 439813, 442634, 445666, 446536, 450108, 452637, 453100, 453471, 458014, 458623, 459643, 460040, 463260, 465592, 466989, 468127, 469575, 470685, 474125, 474496, 474836, 475676, 476164, 476239, 476262, 483355, 484624, 485713, 485715, 488370, 489313, 496346, 498228, 506066, 515693, 521123, 521131, 523564, 545985, 549228, 549255, 550434, 636466, 650614, 662898, 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
  411736
  411820
  420152
  424248
  439813
  442634
  445666
  446536
  450108
  452637
  453100
  453471
  458014
  458623
  459643
  460040
  463260
  465592
  466989
  468127
  469575
  470685
  474125
  474496
  474836
  475676
  476164
  476239
  476262
  483355
  484624
  485713
  485715
  488370
  489313
  496346
  498228
  506066
  515693
  521123
  521131
  523564
  545985
  549228
  549255
  550434
  636466
  650614
  662898
  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, 411736, 411820, 420152, 424248, 439813, 442634, 445666, 446536, 450108, 452637, 453100, 453471, 458014, 458623, 459643, 460040, 463260, 465592, 466989, 468127, 469575, 470685, 474125, 474496, 474836, 475676, 476164, 476239, 476262, 483355, 484624, 485713, 485715, 488370, 489313, 496346, 498228, 506066, 515693, 521123, 521131, 523564, 545985, 549228, 549255, 550434, 636466, 650614, 662898, 678794, 733265, 735442, 745951, 780724, 794669, 804940);

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

[
  "granny анус"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'granny анус';

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

[
  "granny анус"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'granny анус';

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 ?

[
  "granny anus"
  "granny anus"
  "granny anus"
  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 ('granny anus') AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST ('granny anus')
              AND `query` <> 'granny anus'
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT 20
        ;