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
  488527
  456547
  253445
  369353
  606332
  602770
  745679
  757538
  710255
  581317
  607627
  741917
  495646
  605267
  506842
  600849
  74508
  760281
  393029
  709851
  784816
  253654
  456542
  686863
  535632
  455026
  461841
  429861
  514145
  820787
  602835
  477603
  365295
  606331
  657405
  568023
  726239
  282666
  572110
  717517
  392079
  566895
  796427
  811323
  506207
  622950
  476418
  468706
  535229
  391964
  191189
  387175
  504145
  486011
  38890
  418627
  542099
  491172
  400817
  585121
  519211
  528524
  553432
  555595
  443685
  456328
  536819
  384059
  459748
  515433
  570277
  608930
  521131
  513047
]

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 (488527, 456547, 253445, 369353, 606332, 602770, 745679, 757538, 710255, 581317, 607627, 741917, 495646, 605267, 506842, 600849, 74508, 760281, 393029, 709851, 784816, 253654, 456542, 686863, 535632, 455026, 461841, 429861, 514145, 820787, 602835, 477603, 365295, 606331, 657405, 568023, 726239, 282666, 572110, 717517, 392079, 566895, 796427, 811323, 506207, 622950, 476418, 468706, 535229, 391964, 191189, 387175, 504145, 486011, 38890, 418627, 542099, 491172, 400817, 585121, 519211, 528524, 553432, 555595, 443685, 456328, 536819, 384059, 459748, 515433, 570277, 608930, 521131, 513047);

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
  38890
  74508
  191189
  253445
  253654
  282666
  365295
  369353
  384059
  387175
  391964
  392079
  393029
  400817
  418627
  429861
  443685
  455026
  456328
  456542
  456547
  459748
  461841
  468706
  476418
  477603
  486011
  488527
  491172
  495646
  504145
  506207
  506842
  513047
  514145
  515433
  519211
  521131
  528524
  535229
  535632
  536819
  542099
  553432
  555595
  566895
  568023
  570277
  572110
  581317
  585121
  600849
  602770
  602835
  605267
  606331
  606332
  607627
  608930
  622950
  657405
  686863
  709851
  710255
  717517
  726239
  741917
  745679
  757538
  760281
  784816
  796427
  811323
  820787
]

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 (38890, 74508, 191189, 253445, 253654, 282666, 365295, 369353, 384059, 387175, 391964, 392079, 393029, 400817, 418627, 429861, 443685, 455026, 456328, 456542, 456547, 459748, 461841, 468706, 476418, 477603, 486011, 488527, 491172, 495646, 504145, 506207, 506842, 513047, 514145, 515433, 519211, 521131, 528524, 535229, 535632, 536819, 542099, 553432, 555595, 566895, 568023, 570277, 572110, 581317, 585121, 600849, 602770, 602835, 605267, 606331, 606332, 607627, 608930, 622950, 657405, 686863, 709851, 710255, 717517, 726239, 741917, 745679, 757538, 760281, 784816, 796427, 811323, 820787);

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
  38890
  74508
  191189
  253445
  253654
  282666
  365295
  369353
  384059
  387175
  391964
  392079
  393029
  400817
  418627
  429861
  443685
  455026
  456328
  456542
  456547
  459748
  461841
  468706
  476418
  477603
  486011
  488527
  491172
  495646
  504145
  506207
  506842
  513047
  514145
  515433
  519211
  521131
  528524
  535229
  535632
  536819
  542099
  553432
  555595
  566895
  568023
  570277
  572110
  581317
  585121
  600849
  602770
  602835
  605267
  606331
  606332
  607627
  608930
  622950
  657405
  686863
  709851
  710255
  717517
  726239
  741917
  745679
  757538
  760281
  784816
  796427
  811323
  820787
]

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 (38890, 74508, 191189, 253445, 253654, 282666, 365295, 369353, 384059, 387175, 391964, 392079, 393029, 400817, 418627, 429861, 443685, 455026, 456328, 456542, 456547, 459748, 461841, 468706, 476418, 477603, 486011, 488527, 491172, 495646, 504145, 506207, 506842, 513047, 514145, 515433, 519211, 521131, 528524, 535229, 535632, 536819, 542099, 553432, 555595, 566895, 568023, 570277, 572110, 581317, 585121, 600849, 602770, 602835, 605267, 606331, 606332, 607627, 608930, 622950, 657405, 686863, 709851, 710255, 717517, 726239, 741917, 745679, 757538, 760281, 784816, 796427, 811323, 820787);

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
        ;