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
  428124
  453797
  458337
  473388
  454727
  458984
  462000
  553654
  541575
  448213
  469313
  470130
  470593
  474481
  414375
  418952
  421820
  450953
  453671
  464132
  504297
  506906
  508185
  512410
  491554
  493066
  496975
  506146
  492972
  524111
  490671
  507641
  426456
  444400
  472655
  492531
  486812
  476801
  478638
  490451
  549767
  432510
  439578
  465350
  469763
  426203
  463772
  466015
  499785
  502974
  514125
  491878
  570616
  666405
  449170
  517088
  535488
  486875
  566304
  590135
  463900
  468965
  439372
  528452
  564981
  619110
  620044
  599694
  505891
  547241
  580766
  653405
  610035
  622229
  601538
  496853
  657067
  662378
  527124
]

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 (428124, 453797, 458337, 473388, 454727, 458984, 462000, 553654, 541575, 448213, 469313, 470130, 470593, 474481, 414375, 418952, 421820, 450953, 453671, 464132, 504297, 506906, 508185, 512410, 491554, 493066, 496975, 506146, 492972, 524111, 490671, 507641, 426456, 444400, 472655, 492531, 486812, 476801, 478638, 490451, 549767, 432510, 439578, 465350, 469763, 426203, 463772, 466015, 499785, 502974, 514125, 491878, 570616, 666405, 449170, 517088, 535488, 486875, 566304, 590135, 463900, 468965, 439372, 528452, 564981, 619110, 620044, 599694, 505891, 547241, 580766, 653405, 610035, 622229, 601538, 496853, 657067, 662378, 527124);

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
  414375
  418952
  421820
  426203
  426456
  428124
  432510
  439372
  439578
  444400
  448213
  449170
  450953
  453671
  453797
  454727
  458337
  458984
  462000
  463772
  463900
  464132
  465350
  466015
  468965
  469313
  469763
  470130
  470593
  472655
  473388
  474481
  476801
  478638
  486812
  486875
  490451
  490671
  491554
  491878
  492531
  492972
  493066
  496853
  496975
  499785
  502974
  504297
  505891
  506146
  506906
  507641
  508185
  512410
  514125
  517088
  524111
  527124
  528452
  535488
  541575
  547241
  549767
  553654
  564981
  566304
  570616
  580766
  590135
  599694
  601538
  610035
  619110
  620044
  622229
  653405
  657067
  662378
  666405
]

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 (414375, 418952, 421820, 426203, 426456, 428124, 432510, 439372, 439578, 444400, 448213, 449170, 450953, 453671, 453797, 454727, 458337, 458984, 462000, 463772, 463900, 464132, 465350, 466015, 468965, 469313, 469763, 470130, 470593, 472655, 473388, 474481, 476801, 478638, 486812, 486875, 490451, 490671, 491554, 491878, 492531, 492972, 493066, 496853, 496975, 499785, 502974, 504297, 505891, 506146, 506906, 507641, 508185, 512410, 514125, 517088, 524111, 527124, 528452, 535488, 541575, 547241, 549767, 553654, 564981, 566304, 570616, 580766, 590135, 599694, 601538, 610035, 619110, 620044, 622229, 653405, 657067, 662378, 666405);

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
  414375
  418952
  421820
  426203
  426456
  428124
  432510
  439372
  439578
  444400
  448213
  449170
  450953
  453671
  453797
  454727
  458337
  458984
  462000
  463772
  463900
  464132
  465350
  466015
  468965
  469313
  469763
  470130
  470593
  472655
  473388
  474481
  476801
  478638
  486812
  486875
  490451
  490671
  491554
  491878
  492531
  492972
  493066
  496853
  496975
  499785
  502974
  504297
  505891
  506146
  506906
  507641
  508185
  512410
  514125
  517088
  524111
  527124
  528452
  535488
  541575
  547241
  549767
  553654
  564981
  566304
  570616
  580766
  590135
  599694
  601538
  610035
  619110
  620044
  622229
  653405
  657067
  662378
  666405
]

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 (414375, 418952, 421820, 426203, 426456, 428124, 432510, 439372, 439578, 444400, 448213, 449170, 450953, 453671, 453797, 454727, 458337, 458984, 462000, 463772, 463900, 464132, 465350, 466015, 468965, 469313, 469763, 470130, 470593, 472655, 473388, 474481, 476801, 478638, 486812, 486875, 490451, 490671, 491554, 491878, 492531, 492972, 493066, 496853, 496975, 499785, 502974, 504297, 505891, 506146, 506906, 507641, 508185, 512410, 514125, 517088, 524111, 527124, 528452, 535488, 541575, 547241, 549767, 553654, 564981, 566304, 570616, 580766, 590135, 599694, 601538, 610035, 619110, 620044, 622229, 653405, 657067, 662378, 666405);

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` = 'положен';