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
  443017
  471920
  520812
  389492
  522047
  772434
  541816
  552308
  511903
  803142
  612512
  407400
  529214
  555626
  570024
  545247
  388979
  768500
  491970
  605613
  411243
  559024
  503035
  523758
  390762
  461029
  525220
  465997
  669877
  522799
  454485
  466481
  546930
  439751
  559930
  443292
  464272
  634746
  561863
  601935
  627383
  519713
  476438
  573746
  504723
  623326
  559927
  550353
  611369
  654552
  572120
  481507
  563223
  537596
  612099
  481295
  527268
  601827
  584637
  526833
  604919
  601995
  543881
  623168
  624214
  519617
  623727
  624109
  591438
  624217
  624215
  601985
  546701
  669188
]

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 (443017, 471920, 520812, 389492, 522047, 772434, 541816, 552308, 511903, 803142, 612512, 407400, 529214, 555626, 570024, 545247, 388979, 768500, 491970, 605613, 411243, 559024, 503035, 523758, 390762, 461029, 525220, 465997, 669877, 522799, 454485, 466481, 546930, 439751, 559930, 443292, 464272, 634746, 561863, 601935, 627383, 519713, 476438, 573746, 504723, 623326, 559927, 550353, 611369, 654552, 572120, 481507, 563223, 537596, 612099, 481295, 527268, 601827, 584637, 526833, 604919, 601995, 543881, 623168, 624214, 519617, 623727, 624109, 591438, 624217, 624215, 601985, 546701, 669188);

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
  388979
  389492
  390762
  407400
  411243
  439751
  443017
  443292
  454485
  461029
  464272
  465997
  466481
  471920
  476438
  481295
  481507
  491970
  503035
  504723
  511903
  519617
  519713
  520812
  522047
  522799
  523758
  525220
  526833
  527268
  529214
  537596
  541816
  543881
  545247
  546701
  546930
  550353
  552308
  555626
  559024
  559927
  559930
  561863
  563223
  570024
  572120
  573746
  584637
  591438
  601827
  601935
  601985
  601995
  604919
  605613
  611369
  612099
  612512
  623168
  623326
  623727
  624109
  624214
  624215
  624217
  627383
  634746
  654552
  669188
  669877
  768500
  772434
  803142
]

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 (388979, 389492, 390762, 407400, 411243, 439751, 443017, 443292, 454485, 461029, 464272, 465997, 466481, 471920, 476438, 481295, 481507, 491970, 503035, 504723, 511903, 519617, 519713, 520812, 522047, 522799, 523758, 525220, 526833, 527268, 529214, 537596, 541816, 543881, 545247, 546701, 546930, 550353, 552308, 555626, 559024, 559927, 559930, 561863, 563223, 570024, 572120, 573746, 584637, 591438, 601827, 601935, 601985, 601995, 604919, 605613, 611369, 612099, 612512, 623168, 623326, 623727, 624109, 624214, 624215, 624217, 627383, 634746, 654552, 669188, 669877, 768500, 772434, 803142);

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
  388979
  389492
  390762
  407400
  411243
  439751
  443017
  443292
  454485
  461029
  464272
  465997
  466481
  471920
  476438
  481295
  481507
  491970
  503035
  504723
  511903
  519617
  519713
  520812
  522047
  522799
  523758
  525220
  526833
  527268
  529214
  537596
  541816
  543881
  545247
  546701
  546930
  550353
  552308
  555626
  559024
  559927
  559930
  561863
  563223
  570024
  572120
  573746
  584637
  591438
  601827
  601935
  601985
  601995
  604919
  605613
  611369
  612099
  612512
  623168
  623326
  623727
  624109
  624214
  624215
  624217
  627383
  634746
  654552
  669188
  669877
  768500
  772434
  803142
]

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 (388979, 389492, 390762, 407400, 411243, 439751, 443017, 443292, 454485, 461029, 464272, 465997, 466481, 471920, 476438, 481295, 481507, 491970, 503035, 504723, 511903, 519617, 519713, 520812, 522047, 522799, 523758, 525220, 526833, 527268, 529214, 537596, 541816, 543881, 545247, 546701, 546930, 550353, 552308, 555626, 559024, 559927, 559930, 561863, 563223, 570024, 572120, 573746, 584637, 591438, 601827, 601935, 601985, 601995, 604919, 605613, 611369, 612099, 612512, 623168, 623326, 623727, 624109, 624214, 624215, 624217, 627383, 634746, 654552, 669188, 669877, 768500, 772434, 803142);

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
        ;