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
  534959
  472937
  514294
  331382
  382697
  390205
  444734
  482659
  440620
  204545
  532425
  386218
  494678
  387470
  402676
  462828
  578075
  483230
  811554
  731546
  789662
  429486
  454079
  457175
  594797
  594773
  466694
  485358
  402123
  430785
  594880
  485083
  561901
  449872
  559609
  563524
  641464
  572838
  558128
  470172
  191179
  513483
  469764
  542193
  452030
  467146
  382637
  578106
  583729
  504825
  607083
  467293
  526268
  561632
  594830
  409640
  446006
  484368
  563513
  451795
  522878
  581663
  499824
  421398
  561814
  561853
  476147
  492606
  589127
]

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 (534959, 472937, 514294, 331382, 382697, 390205, 444734, 482659, 440620, 204545, 532425, 386218, 494678, 387470, 402676, 462828, 578075, 483230, 811554, 731546, 789662, 429486, 454079, 457175, 594797, 594773, 466694, 485358, 402123, 430785, 594880, 485083, 561901, 449872, 559609, 563524, 641464, 572838, 558128, 470172, 191179, 513483, 469764, 542193, 452030, 467146, 382637, 578106, 583729, 504825, 607083, 467293, 526268, 561632, 594830, 409640, 446006, 484368, 563513, 451795, 522878, 581663, 499824, 421398, 561814, 561853, 476147, 492606, 589127);

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
  191179
  204545
  331382
  382637
  382697
  386218
  387470
  390205
  402123
  402676
  409640
  421398
  429486
  430785
  440620
  444734
  446006
  449872
  451795
  452030
  454079
  457175
  462828
  466694
  467146
  467293
  469764
  470172
  472937
  476147
  482659
  483230
  484368
  485083
  485358
  492606
  494678
  499824
  504825
  513483
  514294
  522878
  526268
  532425
  534959
  542193
  558128
  559609
  561632
  561814
  561853
  561901
  563513
  563524
  572838
  578075
  578106
  581663
  583729
  589127
  594773
  594797
  594830
  594880
  607083
  641464
  731546
  789662
  811554
]

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 (191179, 204545, 331382, 382637, 382697, 386218, 387470, 390205, 402123, 402676, 409640, 421398, 429486, 430785, 440620, 444734, 446006, 449872, 451795, 452030, 454079, 457175, 462828, 466694, 467146, 467293, 469764, 470172, 472937, 476147, 482659, 483230, 484368, 485083, 485358, 492606, 494678, 499824, 504825, 513483, 514294, 522878, 526268, 532425, 534959, 542193, 558128, 559609, 561632, 561814, 561853, 561901, 563513, 563524, 572838, 578075, 578106, 581663, 583729, 589127, 594773, 594797, 594830, 594880, 607083, 641464, 731546, 789662, 811554);

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
  191179
  204545
  331382
  382637
  382697
  386218
  387470
  390205
  402123
  402676
  409640
  421398
  429486
  430785
  440620
  444734
  446006
  449872
  451795
  452030
  454079
  457175
  462828
  466694
  467146
  467293
  469764
  470172
  472937
  476147
  482659
  483230
  484368
  485083
  485358
  492606
  494678
  499824
  504825
  513483
  514294
  522878
  526268
  532425
  534959
  542193
  558128
  559609
  561632
  561814
  561853
  561901
  563513
  563524
  572838
  578075
  578106
  581663
  583729
  589127
  594773
  594797
  594830
  594880
  607083
  641464
  731546
  789662
  811554
]

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 (191179, 204545, 331382, 382637, 382697, 386218, 387470, 390205, 402123, 402676, 409640, 421398, 429486, 430785, 440620, 444734, 446006, 449872, 451795, 452030, 454079, 457175, 462828, 466694, 467146, 467293, 469764, 470172, 472937, 476147, 482659, 483230, 484368, 485083, 485358, 492606, 494678, 499824, 504825, 513483, 514294, 522878, 526268, 532425, 534959, 542193, 558128, 559609, 561632, 561814, 561853, 561901, 563513, 563524, 572838, 578075, 578106, 581663, 583729, 589127, 594773, 594797, 594830, 594880, 607083, 641464, 731546, 789662, 811554);

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
        ;