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
  578390
  444320
  547905
  523508
  540953
  108029
  543822
  396441
  475517
  626274
  782634
  425566
  393582
  445349
  579382
  457411
  479048
  626814
  729460
  551232
  807768
  470609
  497171
  426105
  447013
  551241
  585776
  627748
  496135
  484014
  497578
  527822
  578393
  571689
  578372
  544393
  546022
  663897
  569278
  428418
  454269
  486392
  484387
  454268
  474029
  485511
  503549
  535577
  516062
  557998
  608160
  605143
  667486
  565110
  571102
  447010
  454293
  521176
  520851
  523307
  546993
  582789
  661272
  462279
  484463
  562831
  565351
  557387
  507376
  454213
  634495
]

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 (578390, 444320, 547905, 523508, 540953, 108029, 543822, 396441, 475517, 626274, 782634, 425566, 393582, 445349, 579382, 457411, 479048, 626814, 729460, 551232, 807768, 470609, 497171, 426105, 447013, 551241, 585776, 627748, 496135, 484014, 497578, 527822, 578393, 571689, 578372, 544393, 546022, 663897, 569278, 428418, 454269, 486392, 484387, 454268, 474029, 485511, 503549, 535577, 516062, 557998, 608160, 605143, 667486, 565110, 571102, 447010, 454293, 521176, 520851, 523307, 546993, 582789, 661272, 462279, 484463, 562831, 565351, 557387, 507376, 454213, 634495);

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
  108029
  393582
  396441
  425566
  426105
  428418
  444320
  445349
  447010
  447013
  454213
  454268
  454269
  454293
  457411
  462279
  470609
  474029
  475517
  479048
  484014
  484387
  484463
  485511
  486392
  496135
  497171
  497578
  503549
  507376
  516062
  520851
  521176
  523307
  523508
  527822
  535577
  540953
  543822
  544393
  546022
  546993
  547905
  551232
  551241
  557387
  557998
  562831
  565110
  565351
  569278
  571102
  571689
  578372
  578390
  578393
  579382
  582789
  585776
  605143
  608160
  626274
  626814
  627748
  634495
  661272
  663897
  667486
  729460
  782634
  807768
]

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 (108029, 393582, 396441, 425566, 426105, 428418, 444320, 445349, 447010, 447013, 454213, 454268, 454269, 454293, 457411, 462279, 470609, 474029, 475517, 479048, 484014, 484387, 484463, 485511, 486392, 496135, 497171, 497578, 503549, 507376, 516062, 520851, 521176, 523307, 523508, 527822, 535577, 540953, 543822, 544393, 546022, 546993, 547905, 551232, 551241, 557387, 557998, 562831, 565110, 565351, 569278, 571102, 571689, 578372, 578390, 578393, 579382, 582789, 585776, 605143, 608160, 626274, 626814, 627748, 634495, 661272, 663897, 667486, 729460, 782634, 807768);

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
  108029
  393582
  396441
  425566
  426105
  428418
  444320
  445349
  447010
  447013
  454213
  454268
  454269
  454293
  457411
  462279
  470609
  474029
  475517
  479048
  484014
  484387
  484463
  485511
  486392
  496135
  497171
  497578
  503549
  507376
  516062
  520851
  521176
  523307
  523508
  527822
  535577
  540953
  543822
  544393
  546022
  546993
  547905
  551232
  551241
  557387
  557998
  562831
  565110
  565351
  569278
  571102
  571689
  578372
  578390
  578393
  579382
  582789
  585776
  605143
  608160
  626274
  626814
  627748
  634495
  661272
  663897
  667486
  729460
  782634
  807768
]

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 (108029, 393582, 396441, 425566, 426105, 428418, 444320, 445349, 447010, 447013, 454213, 454268, 454269, 454293, 457411, 462279, 470609, 474029, 475517, 479048, 484014, 484387, 484463, 485511, 486392, 496135, 497171, 497578, 503549, 507376, 516062, 520851, 521176, 523307, 523508, 527822, 535577, 540953, 543822, 544393, 546022, 546993, 547905, 551232, 551241, 557387, 557998, 562831, 565110, 565351, 569278, 571102, 571689, 578372, 578390, 578393, 579382, 582789, 585776, 605143, 608160, 626274, 626814, 627748, 634495, 661272, 663897, 667486, 729460, 782634, 807768);

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
        ;