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
  724312
  456788
  430142
  524457
  656407
  587038
  591735
  630204
  427668
  454536
  501139
  515038
  581712
  465079
  526363
  459054
  462273
  472129
  490505
  586903
  455398
  476465
  446694
  462505
  525121
  572731
  635582
  637469
  597432
  605941
  465993
  499471
  514379
  487120
  571696
  603193
  553204
  555873
  446157
  468964
  452039
  477034
  524765
  533133
  568502
  460995
  472712
  462930
  581423
  584886
  625450
  422656
  518018
  526492
  577031
  580321
  465823
  451576
  592408
  585431
  496865
  667985
  595923
  544012
  544788
  583508
  449784
  533370
  579389
  583139
  494694
  599987
  553272
  642662
]

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 (724312, 456788, 430142, 524457, 656407, 587038, 591735, 630204, 427668, 454536, 501139, 515038, 581712, 465079, 526363, 459054, 462273, 472129, 490505, 586903, 455398, 476465, 446694, 462505, 525121, 572731, 635582, 637469, 597432, 605941, 465993, 499471, 514379, 487120, 571696, 603193, 553204, 555873, 446157, 468964, 452039, 477034, 524765, 533133, 568502, 460995, 472712, 462930, 581423, 584886, 625450, 422656, 518018, 526492, 577031, 580321, 465823, 451576, 592408, 585431, 496865, 667985, 595923, 544012, 544788, 583508, 449784, 533370, 579389, 583139, 494694, 599987, 553272, 642662);

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
  422656
  427668
  430142
  446157
  446694
  449784
  451576
  452039
  454536
  455398
  456788
  459054
  460995
  462273
  462505
  462930
  465079
  465823
  465993
  468964
  472129
  472712
  476465
  477034
  487120
  490505
  494694
  496865
  499471
  501139
  514379
  515038
  518018
  524457
  524765
  525121
  526363
  526492
  533133
  533370
  544012
  544788
  553204
  553272
  555873
  568502
  571696
  572731
  577031
  579389
  580321
  581423
  581712
  583139
  583508
  584886
  585431
  586903
  587038
  591735
  592408
  595923
  597432
  599987
  603193
  605941
  625450
  630204
  635582
  637469
  642662
  656407
  667985
  724312
]

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 (422656, 427668, 430142, 446157, 446694, 449784, 451576, 452039, 454536, 455398, 456788, 459054, 460995, 462273, 462505, 462930, 465079, 465823, 465993, 468964, 472129, 472712, 476465, 477034, 487120, 490505, 494694, 496865, 499471, 501139, 514379, 515038, 518018, 524457, 524765, 525121, 526363, 526492, 533133, 533370, 544012, 544788, 553204, 553272, 555873, 568502, 571696, 572731, 577031, 579389, 580321, 581423, 581712, 583139, 583508, 584886, 585431, 586903, 587038, 591735, 592408, 595923, 597432, 599987, 603193, 605941, 625450, 630204, 635582, 637469, 642662, 656407, 667985, 724312);

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
  422656
  427668
  430142
  446157
  446694
  449784
  451576
  452039
  454536
  455398
  456788
  459054
  460995
  462273
  462505
  462930
  465079
  465823
  465993
  468964
  472129
  472712
  476465
  477034
  487120
  490505
  494694
  496865
  499471
  501139
  514379
  515038
  518018
  524457
  524765
  525121
  526363
  526492
  533133
  533370
  544012
  544788
  553204
  553272
  555873
  568502
  571696
  572731
  577031
  579389
  580321
  581423
  581712
  583139
  583508
  584886
  585431
  586903
  587038
  591735
  592408
  595923
  597432
  599987
  603193
  605941
  625450
  630204
  635582
  637469
  642662
  656407
  667985
  724312
]

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 (422656, 427668, 430142, 446157, 446694, 449784, 451576, 452039, 454536, 455398, 456788, 459054, 460995, 462273, 462505, 462930, 465079, 465823, 465993, 468964, 472129, 472712, 476465, 477034, 487120, 490505, 494694, 496865, 499471, 501139, 514379, 515038, 518018, 524457, 524765, 525121, 526363, 526492, 533133, 533370, 544012, 544788, 553204, 553272, 555873, 568502, 571696, 572731, 577031, 579389, 580321, 581423, 581712, 583139, 583508, 584886, 585431, 586903, 587038, 591735, 592408, 595923, 597432, 599987, 603193, 605941, 625450, 630204, 635582, 637469, 642662, 656407, 667985, 724312);

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
        ;