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
  475122
  480919
  443639
  456220
  423626
  424672
  425638
  478715
  468554
  497775
  510106
  518397
  498825
  499025
  486606
  488937
  491440
  493460
  510126
  521916
  522090
  525663
  443644
  451772
  460860
  456124
  475056
  568837
  560169
  564602
  605918
  586023
  413524
  462824
  473799
  413505
  475166
  503553
  487758
  491676
  517287
  531078
  528402
  503662
  482367
  622772
  475267
  447010
  463772
  510042
  520522
  482778
  663421
  615770
  617784
  630265
  638303
  523392
  483473
  511678
  470288
  584602
  597532
  625968
  595905
  445833
  556323
  587886
  601991
  540511
  518592
  546757
  581571
  600035
  426654
  484299
  545643
  586628
  523995
  541804
]

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 (475122, 480919, 443639, 456220, 423626, 424672, 425638, 478715, 468554, 497775, 510106, 518397, 498825, 499025, 486606, 488937, 491440, 493460, 510126, 521916, 522090, 525663, 443644, 451772, 460860, 456124, 475056, 568837, 560169, 564602, 605918, 586023, 413524, 462824, 473799, 413505, 475166, 503553, 487758, 491676, 517287, 531078, 528402, 503662, 482367, 622772, 475267, 447010, 463772, 510042, 520522, 482778, 663421, 615770, 617784, 630265, 638303, 523392, 483473, 511678, 470288, 584602, 597532, 625968, 595905, 445833, 556323, 587886, 601991, 540511, 518592, 546757, 581571, 600035, 426654, 484299, 545643, 586628, 523995, 541804);

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
  413505
  413524
  423626
  424672
  425638
  426654
  443639
  443644
  445833
  447010
  451772
  456124
  456220
  460860
  462824
  463772
  468554
  470288
  473799
  475056
  475122
  475166
  475267
  478715
  480919
  482367
  482778
  483473
  484299
  486606
  487758
  488937
  491440
  491676
  493460
  497775
  498825
  499025
  503553
  503662
  510042
  510106
  510126
  511678
  517287
  518397
  518592
  520522
  521916
  522090
  523392
  523995
  525663
  528402
  531078
  540511
  541804
  545643
  546757
  556323
  560169
  564602
  568837
  581571
  584602
  586023
  586628
  587886
  595905
  597532
  600035
  601991
  605918
  615770
  617784
  622772
  625968
  630265
  638303
  663421
]

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 (413505, 413524, 423626, 424672, 425638, 426654, 443639, 443644, 445833, 447010, 451772, 456124, 456220, 460860, 462824, 463772, 468554, 470288, 473799, 475056, 475122, 475166, 475267, 478715, 480919, 482367, 482778, 483473, 484299, 486606, 487758, 488937, 491440, 491676, 493460, 497775, 498825, 499025, 503553, 503662, 510042, 510106, 510126, 511678, 517287, 518397, 518592, 520522, 521916, 522090, 523392, 523995, 525663, 528402, 531078, 540511, 541804, 545643, 546757, 556323, 560169, 564602, 568837, 581571, 584602, 586023, 586628, 587886, 595905, 597532, 600035, 601991, 605918, 615770, 617784, 622772, 625968, 630265, 638303, 663421);

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
  413505
  413524
  423626
  424672
  425638
  426654
  443639
  443644
  445833
  447010
  451772
  456124
  456220
  460860
  462824
  463772
  468554
  470288
  473799
  475056
  475122
  475166
  475267
  478715
  480919
  482367
  482778
  483473
  484299
  486606
  487758
  488937
  491440
  491676
  493460
  497775
  498825
  499025
  503553
  503662
  510042
  510106
  510126
  511678
  517287
  518397
  518592
  520522
  521916
  522090
  523392
  523995
  525663
  528402
  531078
  540511
  541804
  545643
  546757
  556323
  560169
  564602
  568837
  581571
  584602
  586023
  586628
  587886
  595905
  597532
  600035
  601991
  605918
  615770
  617784
  622772
  625968
  630265
  638303
  663421
]

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 (413505, 413524, 423626, 424672, 425638, 426654, 443639, 443644, 445833, 447010, 451772, 456124, 456220, 460860, 462824, 463772, 468554, 470288, 473799, 475056, 475122, 475166, 475267, 478715, 480919, 482367, 482778, 483473, 484299, 486606, 487758, 488937, 491440, 491676, 493460, 497775, 498825, 499025, 503553, 503662, 510042, 510106, 510126, 511678, 517287, 518397, 518592, 520522, 521916, 522090, 523392, 523995, 525663, 528402, 531078, 540511, 541804, 545643, 546757, 556323, 560169, 564602, 568837, 581571, 584602, 586023, 586628, 587886, 595905, 597532, 600035, 601991, 605918, 615770, 617784, 622772, 625968, 630265, 638303, 663421);

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` = 'водител';