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
  427187
  467505
  510259
  490370
  489474
  462845
  572513
  574559
  561645
  562775
  570604
  624550
  589731
  526087
  508273
  580980
  653458
  607027
  598646
  628355
  601949
  621352
  443822
  465605
  538234
  516442
  393715
  565946
  673775
  576157
  585210
  603888
  600403
  463900
  484249
  526246
  514311
  569885
  618442
  613275
  620882
  621992
  464887
  477125
  528096
  474744
  561458
  584422
  550415
  649080
  679567
  556036
  620100
  624214
  643252
  604003
  611986
  615621
  620546
  588897
  603167
  609248
  486678
  522930
  593499
  624109
  623168
  617165
  508673
  484331
  499136
  502512
  491854
  519617
]

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 (427187, 467505, 510259, 490370, 489474, 462845, 572513, 574559, 561645, 562775, 570604, 624550, 589731, 526087, 508273, 580980, 653458, 607027, 598646, 628355, 601949, 621352, 443822, 465605, 538234, 516442, 393715, 565946, 673775, 576157, 585210, 603888, 600403, 463900, 484249, 526246, 514311, 569885, 618442, 613275, 620882, 621992, 464887, 477125, 528096, 474744, 561458, 584422, 550415, 649080, 679567, 556036, 620100, 624214, 643252, 604003, 611986, 615621, 620546, 588897, 603167, 609248, 486678, 522930, 593499, 624109, 623168, 617165, 508673, 484331, 499136, 502512, 491854, 519617);

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
  393715
  427187
  443822
  462845
  463900
  464887
  465605
  467505
  474744
  477125
  484249
  484331
  486678
  489474
  490370
  491854
  499136
  502512
  508273
  508673
  510259
  514311
  516442
  519617
  522930
  526087
  526246
  528096
  538234
  550415
  556036
  561458
  561645
  562775
  565946
  569885
  570604
  572513
  574559
  576157
  580980
  584422
  585210
  588897
  589731
  593499
  598646
  600403
  601949
  603167
  603888
  604003
  607027
  609248
  611986
  613275
  615621
  617165
  618442
  620100
  620546
  620882
  621352
  621992
  623168
  624109
  624214
  624550
  628355
  643252
  649080
  653458
  673775
  679567
]

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 (393715, 427187, 443822, 462845, 463900, 464887, 465605, 467505, 474744, 477125, 484249, 484331, 486678, 489474, 490370, 491854, 499136, 502512, 508273, 508673, 510259, 514311, 516442, 519617, 522930, 526087, 526246, 528096, 538234, 550415, 556036, 561458, 561645, 562775, 565946, 569885, 570604, 572513, 574559, 576157, 580980, 584422, 585210, 588897, 589731, 593499, 598646, 600403, 601949, 603167, 603888, 604003, 607027, 609248, 611986, 613275, 615621, 617165, 618442, 620100, 620546, 620882, 621352, 621992, 623168, 624109, 624214, 624550, 628355, 643252, 649080, 653458, 673775, 679567);

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
  393715
  427187
  443822
  462845
  463900
  464887
  465605
  467505
  474744
  477125
  484249
  484331
  486678
  489474
  490370
  491854
  499136
  502512
  508273
  508673
  510259
  514311
  516442
  519617
  522930
  526087
  526246
  528096
  538234
  550415
  556036
  561458
  561645
  562775
  565946
  569885
  570604
  572513
  574559
  576157
  580980
  584422
  585210
  588897
  589731
  593499
  598646
  600403
  601949
  603167
  603888
  604003
  607027
  609248
  611986
  613275
  615621
  617165
  618442
  620100
  620546
  620882
  621352
  621992
  623168
  624109
  624214
  624550
  628355
  643252
  649080
  653458
  673775
  679567
]

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 (393715, 427187, 443822, 462845, 463900, 464887, 465605, 467505, 474744, 477125, 484249, 484331, 486678, 489474, 490370, 491854, 499136, 502512, 508273, 508673, 510259, 514311, 516442, 519617, 522930, 526087, 526246, 528096, 538234, 550415, 556036, 561458, 561645, 562775, 565946, 569885, 570604, 572513, 574559, 576157, 580980, 584422, 585210, 588897, 589731, 593499, 598646, 600403, 601949, 603167, 603888, 604003, 607027, 609248, 611986, 613275, 615621, 617165, 618442, 620100, 620546, 620882, 621352, 621992, 623168, 624109, 624214, 624550, 628355, 643252, 649080, 653458, 673775, 679567);

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
        ;