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

[
  "2000 год"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = '2000 год' 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
  541620
  574398
  558071
  559741
  581908
  582694
  558417
  687006
  449191
  453434
  460444
  422409
  453499
  481346
  507778
  511938
  483598
  505919
  509842
  486349
  507346
  426544
  478668
  532665
  469116
  574204
  576651
  564863
  605499
  604409
  631981
  470762
  451171
  454238
  455337
  523913
  490894
  506820
  510886
  509002
  465024
  525626
  525662
  535084
  576325
  582217
  617175
  424437
  416233
  508554
  484383
  508725
  452895
  574149
  584760
  696499
  648853
  611567
  451132
  541095
  541593
  542956
  582236
  541594
  507494
  582730
  578467
  582137
  596515
  514741
  573212
  586628
  541688
  542199
  585725
]

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 (541620, 574398, 558071, 559741, 581908, 582694, 558417, 687006, 449191, 453434, 460444, 422409, 453499, 481346, 507778, 511938, 483598, 505919, 509842, 486349, 507346, 426544, 478668, 532665, 469116, 574204, 576651, 564863, 605499, 604409, 631981, 470762, 451171, 454238, 455337, 523913, 490894, 506820, 510886, 509002, 465024, 525626, 525662, 535084, 576325, 582217, 617175, 424437, 416233, 508554, 484383, 508725, 452895, 574149, 584760, 696499, 648853, 611567, 451132, 541095, 541593, 542956, 582236, 541594, 507494, 582730, 578467, 582137, 596515, 514741, 573212, 586628, 541688, 542199, 585725);

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
  416233
  422409
  424437
  426544
  449191
  451132
  451171
  452895
  453434
  453499
  454238
  455337
  460444
  465024
  469116
  470762
  478668
  481346
  483598
  484383
  486349
  490894
  505919
  506820
  507346
  507494
  507778
  508554
  508725
  509002
  509842
  510886
  511938
  514741
  523913
  525626
  525662
  532665
  535084
  541095
  541593
  541594
  541620
  541688
  542199
  542956
  558071
  558417
  559741
  564863
  573212
  574149
  574204
  574398
  576325
  576651
  578467
  581908
  582137
  582217
  582236
  582694
  582730
  584760
  585725
  586628
  596515
  604409
  605499
  611567
  617175
  631981
  648853
  687006
  696499
]

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 (416233, 422409, 424437, 426544, 449191, 451132, 451171, 452895, 453434, 453499, 454238, 455337, 460444, 465024, 469116, 470762, 478668, 481346, 483598, 484383, 486349, 490894, 505919, 506820, 507346, 507494, 507778, 508554, 508725, 509002, 509842, 510886, 511938, 514741, 523913, 525626, 525662, 532665, 535084, 541095, 541593, 541594, 541620, 541688, 542199, 542956, 558071, 558417, 559741, 564863, 573212, 574149, 574204, 574398, 576325, 576651, 578467, 581908, 582137, 582217, 582236, 582694, 582730, 584760, 585725, 586628, 596515, 604409, 605499, 611567, 617175, 631981, 648853, 687006, 696499);

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
  416233
  422409
  424437
  426544
  449191
  451132
  451171
  452895
  453434
  453499
  454238
  455337
  460444
  465024
  469116
  470762
  478668
  481346
  483598
  484383
  486349
  490894
  505919
  506820
  507346
  507494
  507778
  508554
  508725
  509002
  509842
  510886
  511938
  514741
  523913
  525626
  525662
  532665
  535084
  541095
  541593
  541594
  541620
  541688
  542199
  542956
  558071
  558417
  559741
  564863
  573212
  574149
  574204
  574398
  576325
  576651
  578467
  581908
  582137
  582217
  582236
  582694
  582730
  584760
  585725
  586628
  596515
  604409
  605499
  611567
  617175
  631981
  648853
  687006
  696499
]

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 (416233, 422409, 424437, 426544, 449191, 451132, 451171, 452895, 453434, 453499, 454238, 455337, 460444, 465024, 469116, 470762, 478668, 481346, 483598, 484383, 486349, 490894, 505919, 506820, 507346, 507494, 507778, 508554, 508725, 509002, 509842, 510886, 511938, 514741, 523913, 525626, 525662, 532665, 535084, 541095, 541593, 541594, 541620, 541688, 542199, 542956, 558071, 558417, 559741, 564863, 573212, 574149, 574204, 574398, 576325, 576651, 578467, 581908, 582137, 582217, 582236, 582694, 582730, 584760, 585725, 586628, 596515, 604409, 605499, 611567, 617175, 631981, 648853, 687006, 696499);

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 ?

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