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
  595382
  576345
  612857
  611369
  590628
  697161
  558468
  662396
  578758
  559699
  521468
  551491
  812108
  741063
  633895
  441213
  549167
  444647
  460674
  475206
  520902
  522003
  382881
  504861
  546906
  599549
  482251
  475011
  424105
  444958
  488059
  624340
  623471
  420262
  509336
  560853
  560766
  403319
  507627
  527872
  552367
  591632
  491652
  529244
  482910
  515189
  406042
  545832
  651904
  510887
  610197
  484581
  523030
  488033
  577823
  578859
  616738
  601956
  405804
  508236
  498043
  524524
  548067
  595369
  599103
  618793
  463957
  467981
  516254
  512952
  525745
  610606
  521159
  491802
]

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 (595382, 576345, 612857, 611369, 590628, 697161, 558468, 662396, 578758, 559699, 521468, 551491, 812108, 741063, 633895, 441213, 549167, 444647, 460674, 475206, 520902, 522003, 382881, 504861, 546906, 599549, 482251, 475011, 424105, 444958, 488059, 624340, 623471, 420262, 509336, 560853, 560766, 403319, 507627, 527872, 552367, 591632, 491652, 529244, 482910, 515189, 406042, 545832, 651904, 510887, 610197, 484581, 523030, 488033, 577823, 578859, 616738, 601956, 405804, 508236, 498043, 524524, 548067, 595369, 599103, 618793, 463957, 467981, 516254, 512952, 525745, 610606, 521159, 491802);

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
  382881
  403319
  405804
  406042
  420262
  424105
  441213
  444647
  444958
  460674
  463957
  467981
  475011
  475206
  482251
  482910
  484581
  488033
  488059
  491652
  491802
  498043
  504861
  507627
  508236
  509336
  510887
  512952
  515189
  516254
  520902
  521159
  521468
  522003
  523030
  524524
  525745
  527872
  529244
  545832
  546906
  548067
  549167
  551491
  552367
  558468
  559699
  560766
  560853
  576345
  577823
  578758
  578859
  590628
  591632
  595369
  595382
  599103
  599549
  601956
  610197
  610606
  611369
  612857
  616738
  618793
  623471
  624340
  633895
  651904
  662396
  697161
  741063
  812108
]

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 (382881, 403319, 405804, 406042, 420262, 424105, 441213, 444647, 444958, 460674, 463957, 467981, 475011, 475206, 482251, 482910, 484581, 488033, 488059, 491652, 491802, 498043, 504861, 507627, 508236, 509336, 510887, 512952, 515189, 516254, 520902, 521159, 521468, 522003, 523030, 524524, 525745, 527872, 529244, 545832, 546906, 548067, 549167, 551491, 552367, 558468, 559699, 560766, 560853, 576345, 577823, 578758, 578859, 590628, 591632, 595369, 595382, 599103, 599549, 601956, 610197, 610606, 611369, 612857, 616738, 618793, 623471, 624340, 633895, 651904, 662396, 697161, 741063, 812108);

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
  382881
  403319
  405804
  406042
  420262
  424105
  441213
  444647
  444958
  460674
  463957
  467981
  475011
  475206
  482251
  482910
  484581
  488033
  488059
  491652
  491802
  498043
  504861
  507627
  508236
  509336
  510887
  512952
  515189
  516254
  520902
  521159
  521468
  522003
  523030
  524524
  525745
  527872
  529244
  545832
  546906
  548067
  549167
  551491
  552367
  558468
  559699
  560766
  560853
  576345
  577823
  578758
  578859
  590628
  591632
  595369
  595382
  599103
  599549
  601956
  610197
  610606
  611369
  612857
  616738
  618793
  623471
  624340
  633895
  651904
  662396
  697161
  741063
  812108
]

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 (382881, 403319, 405804, 406042, 420262, 424105, 441213, 444647, 444958, 460674, 463957, 467981, 475011, 475206, 482251, 482910, 484581, 488033, 488059, 491652, 491802, 498043, 504861, 507627, 508236, 509336, 510887, 512952, 515189, 516254, 520902, 521159, 521468, 522003, 523030, 524524, 525745, 527872, 529244, 545832, 546906, 548067, 549167, 551491, 552367, 558468, 559699, 560766, 560853, 576345, 577823, 578758, 578859, 590628, 591632, 595369, 595382, 599103, 599549, 601956, 610197, 610606, 611369, 612857, 616738, 618793, 623471, 624340, 633895, 651904, 662396, 697161, 741063, 812108);

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
        ;