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
  691231
  753134
  663501
  672418
  553174
  553143
  712881
  633006
  517901
  579217
  553198
  553507
  780536
  547030
  553192
  553179
  553185
  665048
  727352
  553160
  646132
  553571
  710339
  663886
  513167
  550935
  553547
  736401
  773593
  402596
  689345
  499842
  546084
  558979
  759409
  515772
  667459
  607119
  733564
  562685
  660370
  553541
  568276
  477430
  484969
  527293
  533890
  476627
  553156
  557360
  553191
  553563
  553601
  756589
  790572
  603014
  672417
  491017
  491010
  553165
  676303
  469727
  566221
  564138
  594811
  599260
  504572
  506572
  592417
  473207
  501841
  562906
  565940
  530763
]

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 (691231, 753134, 663501, 672418, 553174, 553143, 712881, 633006, 517901, 579217, 553198, 553507, 780536, 547030, 553192, 553179, 553185, 665048, 727352, 553160, 646132, 553571, 710339, 663886, 513167, 550935, 553547, 736401, 773593, 402596, 689345, 499842, 546084, 558979, 759409, 515772, 667459, 607119, 733564, 562685, 660370, 553541, 568276, 477430, 484969, 527293, 533890, 476627, 553156, 557360, 553191, 553563, 553601, 756589, 790572, 603014, 672417, 491017, 491010, 553165, 676303, 469727, 566221, 564138, 594811, 599260, 504572, 506572, 592417, 473207, 501841, 562906, 565940, 530763);

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
  402596
  469727
  473207
  476627
  477430
  484969
  491010
  491017
  499842
  501841
  504572
  506572
  513167
  515772
  517901
  527293
  530763
  533890
  546084
  547030
  550935
  553143
  553156
  553160
  553165
  553174
  553179
  553185
  553191
  553192
  553198
  553507
  553541
  553547
  553563
  553571
  553601
  557360
  558979
  562685
  562906
  564138
  565940
  566221
  568276
  579217
  592417
  594811
  599260
  603014
  607119
  633006
  646132
  660370
  663501
  663886
  665048
  667459
  672417
  672418
  676303
  689345
  691231
  710339
  712881
  727352
  733564
  736401
  753134
  756589
  759409
  773593
  780536
  790572
]

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 (402596, 469727, 473207, 476627, 477430, 484969, 491010, 491017, 499842, 501841, 504572, 506572, 513167, 515772, 517901, 527293, 530763, 533890, 546084, 547030, 550935, 553143, 553156, 553160, 553165, 553174, 553179, 553185, 553191, 553192, 553198, 553507, 553541, 553547, 553563, 553571, 553601, 557360, 558979, 562685, 562906, 564138, 565940, 566221, 568276, 579217, 592417, 594811, 599260, 603014, 607119, 633006, 646132, 660370, 663501, 663886, 665048, 667459, 672417, 672418, 676303, 689345, 691231, 710339, 712881, 727352, 733564, 736401, 753134, 756589, 759409, 773593, 780536, 790572);

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
  402596
  469727
  473207
  476627
  477430
  484969
  491010
  491017
  499842
  501841
  504572
  506572
  513167
  515772
  517901
  527293
  530763
  533890
  546084
  547030
  550935
  553143
  553156
  553160
  553165
  553174
  553179
  553185
  553191
  553192
  553198
  553507
  553541
  553547
  553563
  553571
  553601
  557360
  558979
  562685
  562906
  564138
  565940
  566221
  568276
  579217
  592417
  594811
  599260
  603014
  607119
  633006
  646132
  660370
  663501
  663886
  665048
  667459
  672417
  672418
  676303
  689345
  691231
  710339
  712881
  727352
  733564
  736401
  753134
  756589
  759409
  773593
  780536
  790572
]

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 (402596, 469727, 473207, 476627, 477430, 484969, 491010, 491017, 499842, 501841, 504572, 506572, 513167, 515772, 517901, 527293, 530763, 533890, 546084, 547030, 550935, 553143, 553156, 553160, 553165, 553174, 553179, 553185, 553191, 553192, 553198, 553507, 553541, 553547, 553563, 553571, 553601, 557360, 558979, 562685, 562906, 564138, 565940, 566221, 568276, 579217, 592417, 594811, 599260, 603014, 607119, 633006, 646132, 660370, 663501, 663886, 665048, 667459, 672417, 672418, 676303, 689345, 691231, 710339, 712881, 727352, 733564, 736401, 753134, 756589, 759409, 773593, 780536, 790572);

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
        ;