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
  468714
  470792
  471699
  492177
  497663
  535414
  541332
  491220
  501866
  559822
  542070
  576353
  638532
  636274
  811032
  419674
  473083
  451816
  455096
  464620
  477967
  505999
  519492
  523992
  516021
  492597
  418833
  470375
  561850
  659554
  549500
  558976
  606704
  434870
  447890
  466273
  527560
  453840
  472237
  558614
  561671
  606695
  595494
  625663
  425214
  446369
  524969
  649123
  657296
  655431
  656465
  656768
  627632
  598031
  467967
  486110
  492598
  535011
  561837
  611028
  614521
  627654
  499863
  577909
  655609
  671403
  552946
  620263
  519345
  519842
  483328
  590667
  522049
  504518
]

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 (468714, 470792, 471699, 492177, 497663, 535414, 541332, 491220, 501866, 559822, 542070, 576353, 638532, 636274, 811032, 419674, 473083, 451816, 455096, 464620, 477967, 505999, 519492, 523992, 516021, 492597, 418833, 470375, 561850, 659554, 549500, 558976, 606704, 434870, 447890, 466273, 527560, 453840, 472237, 558614, 561671, 606695, 595494, 625663, 425214, 446369, 524969, 649123, 657296, 655431, 656465, 656768, 627632, 598031, 467967, 486110, 492598, 535011, 561837, 611028, 614521, 627654, 499863, 577909, 655609, 671403, 552946, 620263, 519345, 519842, 483328, 590667, 522049, 504518);

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
  418833
  419674
  425214
  434870
  446369
  447890
  451816
  453840
  455096
  464620
  466273
  467967
  468714
  470375
  470792
  471699
  472237
  473083
  477967
  483328
  486110
  491220
  492177
  492597
  492598
  497663
  499863
  501866
  504518
  505999
  516021
  519345
  519492
  519842
  522049
  523992
  524969
  527560
  535011
  535414
  541332
  542070
  549500
  552946
  558614
  558976
  559822
  561671
  561837
  561850
  576353
  577909
  590667
  595494
  598031
  606695
  606704
  611028
  614521
  620263
  625663
  627632
  627654
  636274
  638532
  649123
  655431
  655609
  656465
  656768
  657296
  659554
  671403
  811032
]

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 (418833, 419674, 425214, 434870, 446369, 447890, 451816, 453840, 455096, 464620, 466273, 467967, 468714, 470375, 470792, 471699, 472237, 473083, 477967, 483328, 486110, 491220, 492177, 492597, 492598, 497663, 499863, 501866, 504518, 505999, 516021, 519345, 519492, 519842, 522049, 523992, 524969, 527560, 535011, 535414, 541332, 542070, 549500, 552946, 558614, 558976, 559822, 561671, 561837, 561850, 576353, 577909, 590667, 595494, 598031, 606695, 606704, 611028, 614521, 620263, 625663, 627632, 627654, 636274, 638532, 649123, 655431, 655609, 656465, 656768, 657296, 659554, 671403, 811032);

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
  418833
  419674
  425214
  434870
  446369
  447890
  451816
  453840
  455096
  464620
  466273
  467967
  468714
  470375
  470792
  471699
  472237
  473083
  477967
  483328
  486110
  491220
  492177
  492597
  492598
  497663
  499863
  501866
  504518
  505999
  516021
  519345
  519492
  519842
  522049
  523992
  524969
  527560
  535011
  535414
  541332
  542070
  549500
  552946
  558614
  558976
  559822
  561671
  561837
  561850
  576353
  577909
  590667
  595494
  598031
  606695
  606704
  611028
  614521
  620263
  625663
  627632
  627654
  636274
  638532
  649123
  655431
  655609
  656465
  656768
  657296
  659554
  671403
  811032
]

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 (418833, 419674, 425214, 434870, 446369, 447890, 451816, 453840, 455096, 464620, 466273, 467967, 468714, 470375, 470792, 471699, 472237, 473083, 477967, 483328, 486110, 491220, 492177, 492597, 492598, 497663, 499863, 501866, 504518, 505999, 516021, 519345, 519492, 519842, 522049, 523992, 524969, 527560, 535011, 535414, 541332, 542070, 549500, 552946, 558614, 558976, 559822, 561671, 561837, 561850, 576353, 577909, 590667, 595494, 598031, 606695, 606704, 611028, 614521, 620263, 625663, 627632, 627654, 636274, 638532, 649123, 655431, 655609, 656465, 656768, 657296, 659554, 671403, 811032);

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
        ;