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

[
  "riding dildo milf"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'riding dildo milf' 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
  191495
  391704
  429577
  429954
  463973
  389966
  803524
  452640
  508909
  514652
  547576
  604667
  397876
  533928
  533846
  699397
  586933
  814958
  523196
  529205
  555104
  716550
  664192
  665662
  692314
  582336
  589349
  626593
  604109
  586407
  724264
  796057
  728229
  758079
  787336
  454943
  450023
  522184
  516574
  588068
  787435
  680428
  424679
  450287
  500907
  559228
  717550
  595176
  389729
  583508
  418963
  429563
  586859
  785500
  810822
  500477
  472621
  580286
  595165
  702061
  492701
  394514
  649949
  427000
  622366
  515667
  550571
  581013
  589064
  446002
  452797
  500734
  522157
]

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 (191495, 391704, 429577, 429954, 463973, 389966, 803524, 452640, 508909, 514652, 547576, 604667, 397876, 533928, 533846, 699397, 586933, 814958, 523196, 529205, 555104, 716550, 664192, 665662, 692314, 582336, 589349, 626593, 604109, 586407, 724264, 796057, 728229, 758079, 787336, 454943, 450023, 522184, 516574, 588068, 787435, 680428, 424679, 450287, 500907, 559228, 717550, 595176, 389729, 583508, 418963, 429563, 586859, 785500, 810822, 500477, 472621, 580286, 595165, 702061, 492701, 394514, 649949, 427000, 622366, 515667, 550571, 581013, 589064, 446002, 452797, 500734, 522157);

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
  191495
  389729
  389966
  391704
  394514
  397876
  418963
  424679
  427000
  429563
  429577
  429954
  446002
  450023
  450287
  452640
  452797
  454943
  463973
  472621
  492701
  500477
  500734
  500907
  508909
  514652
  515667
  516574
  522157
  522184
  523196
  529205
  533846
  533928
  547576
  550571
  555104
  559228
  580286
  581013
  582336
  583508
  586407
  586859
  586933
  588068
  589064
  589349
  595165
  595176
  604109
  604667
  622366
  626593
  649949
  664192
  665662
  680428
  692314
  699397
  702061
  716550
  717550
  724264
  728229
  758079
  785500
  787336
  787435
  796057
  803524
  810822
  814958
]

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 (191495, 389729, 389966, 391704, 394514, 397876, 418963, 424679, 427000, 429563, 429577, 429954, 446002, 450023, 450287, 452640, 452797, 454943, 463973, 472621, 492701, 500477, 500734, 500907, 508909, 514652, 515667, 516574, 522157, 522184, 523196, 529205, 533846, 533928, 547576, 550571, 555104, 559228, 580286, 581013, 582336, 583508, 586407, 586859, 586933, 588068, 589064, 589349, 595165, 595176, 604109, 604667, 622366, 626593, 649949, 664192, 665662, 680428, 692314, 699397, 702061, 716550, 717550, 724264, 728229, 758079, 785500, 787336, 787435, 796057, 803524, 810822, 814958);

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
  191495
  389729
  389966
  391704
  394514
  397876
  418963
  424679
  427000
  429563
  429577
  429954
  446002
  450023
  450287
  452640
  452797
  454943
  463973
  472621
  492701
  500477
  500734
  500907
  508909
  514652
  515667
  516574
  522157
  522184
  523196
  529205
  533846
  533928
  547576
  550571
  555104
  559228
  580286
  581013
  582336
  583508
  586407
  586859
  586933
  588068
  589064
  589349
  595165
  595176
  604109
  604667
  622366
  626593
  649949
  664192
  665662
  680428
  692314
  699397
  702061
  716550
  717550
  724264
  728229
  758079
  785500
  787336
  787435
  796057
  803524
  810822
  814958
]

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 (191495, 389729, 389966, 391704, 394514, 397876, 418963, 424679, 427000, 429563, 429577, 429954, 446002, 450023, 450287, 452640, 452797, 454943, 463973, 472621, 492701, 500477, 500734, 500907, 508909, 514652, 515667, 516574, 522157, 522184, 523196, 529205, 533846, 533928, 547576, 550571, 555104, 559228, 580286, 581013, 582336, 583508, 586407, 586859, 586933, 588068, 589064, 589349, 595165, 595176, 604109, 604667, 622366, 626593, 649949, 664192, 665662, 680428, 692314, 699397, 702061, 716550, 717550, 724264, 728229, 758079, 785500, 787336, 787435, 796057, 803524, 810822, 814958);

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

[
  "riding дилд milf"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'riding дилд milf';

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

[
  "riding дилд milf"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'riding дилд milf';

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 ?

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