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

[
  "boy masturbation video"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'boy masturbation video' 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
  785459
  740709
  823900
  385852
  467677
  540712
  778177
  807248
  485294
  492342
  688252
  591571
  584033
  765641
  788620
  728945
  191495
  425573
  551236
  474893
  765627
  761843
  432991
  233365
  476522
  707509
  784012
  445713
  479908
  553708
  571167
  751332
  481609
  510572
  398268
  671175
  814252
  668141
  693990
  752450
  757975
  774949
  780267
  474891
  598207
  444043
  486866
  567381
  417010
  506911
  486173
  525233
  556009
  436796
  401199
  387366
  426179
  415761
  502477
  508048
  524296
  417099
  462526
  451050
  442189
  494290
  502482
  441402
  625437
  597542
  452097
]

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 (785459, 740709, 823900, 385852, 467677, 540712, 778177, 807248, 485294, 492342, 688252, 591571, 584033, 765641, 788620, 728945, 191495, 425573, 551236, 474893, 765627, 761843, 432991, 233365, 476522, 707509, 784012, 445713, 479908, 553708, 571167, 751332, 481609, 510572, 398268, 671175, 814252, 668141, 693990, 752450, 757975, 774949, 780267, 474891, 598207, 444043, 486866, 567381, 417010, 506911, 486173, 525233, 556009, 436796, 401199, 387366, 426179, 415761, 502477, 508048, 524296, 417099, 462526, 451050, 442189, 494290, 502482, 441402, 625437, 597542, 452097);

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
  233365
  385852
  387366
  398268
  401199
  415761
  417010
  417099
  425573
  426179
  432991
  436796
  441402
  442189
  444043
  445713
  451050
  452097
  462526
  467677
  474891
  474893
  476522
  479908
  481609
  485294
  486173
  486866
  492342
  494290
  502477
  502482
  506911
  508048
  510572
  524296
  525233
  540712
  551236
  553708
  556009
  567381
  571167
  584033
  591571
  597542
  598207
  625437
  668141
  671175
  688252
  693990
  707509
  728945
  740709
  751332
  752450
  757975
  761843
  765627
  765641
  774949
  778177
  780267
  784012
  785459
  788620
  807248
  814252
  823900
]

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, 233365, 385852, 387366, 398268, 401199, 415761, 417010, 417099, 425573, 426179, 432991, 436796, 441402, 442189, 444043, 445713, 451050, 452097, 462526, 467677, 474891, 474893, 476522, 479908, 481609, 485294, 486173, 486866, 492342, 494290, 502477, 502482, 506911, 508048, 510572, 524296, 525233, 540712, 551236, 553708, 556009, 567381, 571167, 584033, 591571, 597542, 598207, 625437, 668141, 671175, 688252, 693990, 707509, 728945, 740709, 751332, 752450, 757975, 761843, 765627, 765641, 774949, 778177, 780267, 784012, 785459, 788620, 807248, 814252, 823900);

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
  233365
  385852
  387366
  398268
  401199
  415761
  417010
  417099
  425573
  426179
  432991
  436796
  441402
  442189
  444043
  445713
  451050
  452097
  462526
  467677
  474891
  474893
  476522
  479908
  481609
  485294
  486173
  486866
  492342
  494290
  502477
  502482
  506911
  508048
  510572
  524296
  525233
  540712
  551236
  553708
  556009
  567381
  571167
  584033
  591571
  597542
  598207
  625437
  668141
  671175
  688252
  693990
  707509
  728945
  740709
  751332
  752450
  757975
  761843
  765627
  765641
  774949
  778177
  780267
  784012
  785459
  788620
  807248
  814252
  823900
]

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, 233365, 385852, 387366, 398268, 401199, 415761, 417010, 417099, 425573, 426179, 432991, 436796, 441402, 442189, 444043, 445713, 451050, 452097, 462526, 467677, 474891, 474893, 476522, 479908, 481609, 485294, 486173, 486866, 492342, 494290, 502477, 502482, 506911, 508048, 510572, 524296, 525233, 540712, 551236, 553708, 556009, 567381, 571167, 584033, 591571, 597542, 598207, 625437, 668141, 671175, 688252, 693990, 707509, 728945, 740709, 751332, 752450, 757975, 761843, 765627, 765641, 774949, 778177, 780267, 784012, 785459, 788620, 807248, 814252, 823900);

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

[
  "парен мастурбац video"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'парен мастурбац video';

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

[
  "парен мастурбац video"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'парен мастурбац video';

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 ?

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