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

[
  "ass joi"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'ass joi' 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
  584300
  534311
  650274
  586393
  799164
  542142
  592671
  724854
  426297
  482623
  549740
  582470
  721296
  586441
  604804
  799176
  747094
  437244
  515403
  554548
  426657
  520552
  605183
  389982
  449963
  450259
  551768
  579506
  601228
  724948
  766374
  437807
  425088
  483957
  433556
  539355
  507340
  432185
  550533
  552373
  479582
  418367
  393572
  469459
  457620
  553845
  777406
  799175
  516873
  533030
  426647
  551824
  475475
  499701
  591161
  512738
  514687
  550530
  480576
  529378
  578323
  480356
  508300
  512230
  454568
  588144
  552401
  520995
  529355
  483709
  505891
  577822
  577556
  545828
]

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 (584300, 534311, 650274, 586393, 799164, 542142, 592671, 724854, 426297, 482623, 549740, 582470, 721296, 586441, 604804, 799176, 747094, 437244, 515403, 554548, 426657, 520552, 605183, 389982, 449963, 450259, 551768, 579506, 601228, 724948, 766374, 437807, 425088, 483957, 433556, 539355, 507340, 432185, 550533, 552373, 479582, 418367, 393572, 469459, 457620, 553845, 777406, 799175, 516873, 533030, 426647, 551824, 475475, 499701, 591161, 512738, 514687, 550530, 480576, 529378, 578323, 480356, 508300, 512230, 454568, 588144, 552401, 520995, 529355, 483709, 505891, 577822, 577556, 545828);

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
  389982
  393572
  418367
  425088
  426297
  426647
  426657
  432185
  433556
  437244
  437807
  449963
  450259
  454568
  457620
  469459
  475475
  479582
  480356
  480576
  482623
  483709
  483957
  499701
  505891
  507340
  508300
  512230
  512738
  514687
  515403
  516873
  520552
  520995
  529355
  529378
  533030
  534311
  539355
  542142
  545828
  549740
  550530
  550533
  551768
  551824
  552373
  552401
  553845
  554548
  577556
  577822
  578323
  579506
  582470
  584300
  586393
  586441
  588144
  591161
  592671
  601228
  604804
  605183
  650274
  721296
  724854
  724948
  747094
  766374
  777406
  799164
  799175
  799176
]

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 (389982, 393572, 418367, 425088, 426297, 426647, 426657, 432185, 433556, 437244, 437807, 449963, 450259, 454568, 457620, 469459, 475475, 479582, 480356, 480576, 482623, 483709, 483957, 499701, 505891, 507340, 508300, 512230, 512738, 514687, 515403, 516873, 520552, 520995, 529355, 529378, 533030, 534311, 539355, 542142, 545828, 549740, 550530, 550533, 551768, 551824, 552373, 552401, 553845, 554548, 577556, 577822, 578323, 579506, 582470, 584300, 586393, 586441, 588144, 591161, 592671, 601228, 604804, 605183, 650274, 721296, 724854, 724948, 747094, 766374, 777406, 799164, 799175, 799176);

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
  389982
  393572
  418367
  425088
  426297
  426647
  426657
  432185
  433556
  437244
  437807
  449963
  450259
  454568
  457620
  469459
  475475
  479582
  480356
  480576
  482623
  483709
  483957
  499701
  505891
  507340
  508300
  512230
  512738
  514687
  515403
  516873
  520552
  520995
  529355
  529378
  533030
  534311
  539355
  542142
  545828
  549740
  550530
  550533
  551768
  551824
  552373
  552401
  553845
  554548
  577556
  577822
  578323
  579506
  582470
  584300
  586393
  586441
  588144
  591161
  592671
  601228
  604804
  605183
  650274
  721296
  724854
  724948
  747094
  766374
  777406
  799164
  799175
  799176
]

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 (389982, 393572, 418367, 425088, 426297, 426647, 426657, 432185, 433556, 437244, 437807, 449963, 450259, 454568, 457620, 469459, 475475, 479582, 480356, 480576, 482623, 483709, 483957, 499701, 505891, 507340, 508300, 512230, 512738, 514687, 515403, 516873, 520552, 520995, 529355, 529378, 533030, 534311, 539355, 542142, 545828, 549740, 550530, 550533, 551768, 551824, 552373, 552401, 553845, 554548, 577556, 577822, 578323, 579506, 582470, 584300, 586393, 586441, 588144, 591161, 592671, 601228, 604804, 605183, 650274, 721296, 724854, 724948, 747094, 766374, 777406, 799164, 799175, 799176);

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

[
  "жоп joi"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'жоп joi';

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

[
  "жоп joi"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'жоп joi';

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 ?

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