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

[
  "real housewife"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'real housewife' 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
  484844
  485604
  427326
  482774
  446737
  526382
  517281
  647610
  563251
  577454
  584217
  622866
  591052
  603742
  591494
  609838
  614954
  809228
  414845
  439809
  465996
  414384
  463090
  461388
  421861
  435046
  523429
  522208
  516822
  482538
  527519
  484440
  713065
  591452
  591468
  438767
  439712
  465348
  481995
  439685
  455333
  516740
  517885
  516483
  496585
  463980
  485527
  513832
  561273
  564977
  690034
  642359
  609197
  428965
  429006
  454425
  415697
  421876
  439770
  473463
  502191
  483644
  519512
  522733
  442613
  455351
  464724
  574833
  684694
  589674
  442804
  478379
  421878
  465075
  439813
  519589
  564743
  491782
  446894
  584236
  544686
  562790
  549736
]

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 (484844, 485604, 427326, 482774, 446737, 526382, 517281, 647610, 563251, 577454, 584217, 622866, 591052, 603742, 591494, 609838, 614954, 809228, 414845, 439809, 465996, 414384, 463090, 461388, 421861, 435046, 523429, 522208, 516822, 482538, 527519, 484440, 713065, 591452, 591468, 438767, 439712, 465348, 481995, 439685, 455333, 516740, 517885, 516483, 496585, 463980, 485527, 513832, 561273, 564977, 690034, 642359, 609197, 428965, 429006, 454425, 415697, 421876, 439770, 473463, 502191, 483644, 519512, 522733, 442613, 455351, 464724, 574833, 684694, 589674, 442804, 478379, 421878, 465075, 439813, 519589, 564743, 491782, 446894, 584236, 544686, 562790, 549736);

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
  414384
  414845
  415697
  421861
  421876
  421878
  427326
  428965
  429006
  435046
  438767
  439685
  439712
  439770
  439809
  439813
  442613
  442804
  446737
  446894
  454425
  455333
  455351
  461388
  463090
  463980
  464724
  465075
  465348
  465996
  473463
  478379
  481995
  482538
  482774
  483644
  484440
  484844
  485527
  485604
  491782
  496585
  502191
  513832
  516483
  516740
  516822
  517281
  517885
  519512
  519589
  522208
  522733
  523429
  526382
  527519
  544686
  549736
  561273
  562790
  563251
  564743
  564977
  574833
  577454
  584217
  584236
  589674
  591052
  591452
  591468
  591494
  603742
  609197
  609838
  614954
  622866
  642359
  647610
  684694
  690034
  713065
  809228
]

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 (414384, 414845, 415697, 421861, 421876, 421878, 427326, 428965, 429006, 435046, 438767, 439685, 439712, 439770, 439809, 439813, 442613, 442804, 446737, 446894, 454425, 455333, 455351, 461388, 463090, 463980, 464724, 465075, 465348, 465996, 473463, 478379, 481995, 482538, 482774, 483644, 484440, 484844, 485527, 485604, 491782, 496585, 502191, 513832, 516483, 516740, 516822, 517281, 517885, 519512, 519589, 522208, 522733, 523429, 526382, 527519, 544686, 549736, 561273, 562790, 563251, 564743, 564977, 574833, 577454, 584217, 584236, 589674, 591052, 591452, 591468, 591494, 603742, 609197, 609838, 614954, 622866, 642359, 647610, 684694, 690034, 713065, 809228);

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
  414384
  414845
  415697
  421861
  421876
  421878
  427326
  428965
  429006
  435046
  438767
  439685
  439712
  439770
  439809
  439813
  442613
  442804
  446737
  446894
  454425
  455333
  455351
  461388
  463090
  463980
  464724
  465075
  465348
  465996
  473463
  478379
  481995
  482538
  482774
  483644
  484440
  484844
  485527
  485604
  491782
  496585
  502191
  513832
  516483
  516740
  516822
  517281
  517885
  519512
  519589
  522208
  522733
  523429
  526382
  527519
  544686
  549736
  561273
  562790
  563251
  564743
  564977
  574833
  577454
  584217
  584236
  589674
  591052
  591452
  591468
  591494
  603742
  609197
  609838
  614954
  622866
  642359
  647610
  684694
  690034
  713065
  809228
]

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 (414384, 414845, 415697, 421861, 421876, 421878, 427326, 428965, 429006, 435046, 438767, 439685, 439712, 439770, 439809, 439813, 442613, 442804, 446737, 446894, 454425, 455333, 455351, 461388, 463090, 463980, 464724, 465075, 465348, 465996, 473463, 478379, 481995, 482538, 482774, 483644, 484440, 484844, 485527, 485604, 491782, 496585, 502191, 513832, 516483, 516740, 516822, 517281, 517885, 519512, 519589, 522208, 522733, 523429, 526382, 527519, 544686, 549736, 561273, 562790, 563251, 564743, 564977, 574833, 577454, 584217, 584236, 589674, 591052, 591452, 591468, 591494, 603742, 609197, 609838, 614954, 622866, 642359, 647610, 684694, 690034, 713065, 809228);

SELECT `query_id` FROM `search_log` WHERE `query` = ?

[
  "real housewife"
]

SELECT
  `query_id`
FROM
  `search_log`
WHERE
  `query` = ?

SELECT `query_id` FROM `search_log` WHERE `query` = 'real housewife';

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

[
  "real housewife"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'real housewife';