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

[
  "sex teaching"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'sex teaching' 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
  678243
  824741
  563838
  581279
  532278
  799477
  788877
  336687
  458708
  717817
  394409
  453893
  596165
  801593
  129902
  402260
  461836
  721418
  790013
  678313
  748158
  562350
  561464
  397616
  596166
  383993
  824427
  708422
  591953
  450147
  526457
  662385
  598962
  803076
  574231
  652689
  748139
  810312
  696973
  395695
  560335
  457826
  453020
  467427
  792531
  395679
  489396
  424929
  482296
  511328
  629421
  467445
  510690
  654914
  600686
  462491
  514838
  505403
  690034
  482539
  454421
  522733
  523043
  452581
  619423
  6741
  721617
  663947
  501148
  462451
  602960
  519037
  523356
  601231
]

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 (678243, 824741, 563838, 581279, 532278, 799477, 788877, 336687, 458708, 717817, 394409, 453893, 596165, 801593, 129902, 402260, 461836, 721418, 790013, 678313, 748158, 562350, 561464, 397616, 596166, 383993, 824427, 708422, 591953, 450147, 526457, 662385, 598962, 803076, 574231, 652689, 748139, 810312, 696973, 395695, 560335, 457826, 453020, 467427, 792531, 395679, 489396, 424929, 482296, 511328, 629421, 467445, 510690, 654914, 600686, 462491, 514838, 505403, 690034, 482539, 454421, 522733, 523043, 452581, 619423, 6741, 721617, 663947, 501148, 462451, 602960, 519037, 523356, 601231);

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
  6741
  129902
  336687
  383993
  394409
  395679
  395695
  397616
  402260
  424929
  450147
  452581
  453020
  453893
  454421
  457826
  458708
  461836
  462451
  462491
  467427
  467445
  482296
  482539
  489396
  501148
  505403
  510690
  511328
  514838
  519037
  522733
  523043
  523356
  526457
  532278
  560335
  561464
  562350
  563838
  574231
  581279
  591953
  596165
  596166
  598962
  600686
  601231
  602960
  619423
  629421
  652689
  654914
  662385
  663947
  678243
  678313
  690034
  696973
  708422
  717817
  721418
  721617
  748139
  748158
  788877
  790013
  792531
  799477
  801593
  803076
  810312
  824427
  824741
]

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 (6741, 129902, 336687, 383993, 394409, 395679, 395695, 397616, 402260, 424929, 450147, 452581, 453020, 453893, 454421, 457826, 458708, 461836, 462451, 462491, 467427, 467445, 482296, 482539, 489396, 501148, 505403, 510690, 511328, 514838, 519037, 522733, 523043, 523356, 526457, 532278, 560335, 561464, 562350, 563838, 574231, 581279, 591953, 596165, 596166, 598962, 600686, 601231, 602960, 619423, 629421, 652689, 654914, 662385, 663947, 678243, 678313, 690034, 696973, 708422, 717817, 721418, 721617, 748139, 748158, 788877, 790013, 792531, 799477, 801593, 803076, 810312, 824427, 824741);

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
  6741
  129902
  336687
  383993
  394409
  395679
  395695
  397616
  402260
  424929
  450147
  452581
  453020
  453893
  454421
  457826
  458708
  461836
  462451
  462491
  467427
  467445
  482296
  482539
  489396
  501148
  505403
  510690
  511328
  514838
  519037
  522733
  523043
  523356
  526457
  532278
  560335
  561464
  562350
  563838
  574231
  581279
  591953
  596165
  596166
  598962
  600686
  601231
  602960
  619423
  629421
  652689
  654914
  662385
  663947
  678243
  678313
  690034
  696973
  708422
  717817
  721418
  721617
  748139
  748158
  788877
  790013
  792531
  799477
  801593
  803076
  810312
  824427
  824741
]

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 (6741, 129902, 336687, 383993, 394409, 395679, 395695, 397616, 402260, 424929, 450147, 452581, 453020, 453893, 454421, 457826, 458708, 461836, 462451, 462491, 467427, 467445, 482296, 482539, 489396, 501148, 505403, 510690, 511328, 514838, 519037, 522733, 523043, 523356, 526457, 532278, 560335, 561464, 562350, 563838, 574231, 581279, 591953, 596165, 596166, 598962, 600686, 601231, 602960, 619423, 629421, 652689, 654914, 662385, 663947, 678243, 678313, 690034, 696973, 708422, 717817, 721418, 721617, 748139, 748158, 788877, 790013, 792531, 799477, 801593, 803076, 810312, 824427, 824741);

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

[
  "секс teaching"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'секс teaching';

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

[
  "секс teaching"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'секс teaching';

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 ?

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