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

[
  "old german"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'old german' 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
  674473
  564597
  599609
  806084
  744265
  750876
  761275
  729635
  742199
  780690
  417738
  426005
  471413
  401221
  471512
  413087
  453338
  388792
  534178
  508818
  401203
  401228
  428514
  428512
  455961
  483103
  474877
  509993
  522847
  554465
  564602
  588343
  610607
  625798
  457988
  446085
  528906
  486055
  383943
  412132
  466943
  485481
  512541
  495148
  554388
  559124
  602668
  614017
  428522
  464965
  428520
  518031
  387905
  428533
  465549
  485098
  478459
  569520
  600503
  805874
  401933
  401064
  428509
  523706
  506467
  428531
  456915
  482555
  447930
  518858
  512539
  480749
  559120
  583527
  554391
  594431
  599659
  395666
  491782
  483802
  416886
  528788
  551913
  521159
]

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 (674473, 564597, 599609, 806084, 744265, 750876, 761275, 729635, 742199, 780690, 417738, 426005, 471413, 401221, 471512, 413087, 453338, 388792, 534178, 508818, 401203, 401228, 428514, 428512, 455961, 483103, 474877, 509993, 522847, 554465, 564602, 588343, 610607, 625798, 457988, 446085, 528906, 486055, 383943, 412132, 466943, 485481, 512541, 495148, 554388, 559124, 602668, 614017, 428522, 464965, 428520, 518031, 387905, 428533, 465549, 485098, 478459, 569520, 600503, 805874, 401933, 401064, 428509, 523706, 506467, 428531, 456915, 482555, 447930, 518858, 512539, 480749, 559120, 583527, 554391, 594431, 599659, 395666, 491782, 483802, 416886, 528788, 551913, 521159);

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
  383943
  387905
  388792
  395666
  401064
  401203
  401221
  401228
  401933
  412132
  413087
  416886
  417738
  426005
  428509
  428512
  428514
  428520
  428522
  428531
  428533
  446085
  447930
  453338
  455961
  456915
  457988
  464965
  465549
  466943
  471413
  471512
  474877
  478459
  480749
  482555
  483103
  483802
  485098
  485481
  486055
  491782
  495148
  506467
  508818
  509993
  512539
  512541
  518031
  518858
  521159
  522847
  523706
  528788
  528906
  534178
  551913
  554388
  554391
  554465
  559120
  559124
  564597
  564602
  569520
  583527
  588343
  594431
  599609
  599659
  600503
  602668
  610607
  614017
  625798
  674473
  729635
  742199
  744265
  750876
  761275
  780690
  805874
  806084
]

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 (383943, 387905, 388792, 395666, 401064, 401203, 401221, 401228, 401933, 412132, 413087, 416886, 417738, 426005, 428509, 428512, 428514, 428520, 428522, 428531, 428533, 446085, 447930, 453338, 455961, 456915, 457988, 464965, 465549, 466943, 471413, 471512, 474877, 478459, 480749, 482555, 483103, 483802, 485098, 485481, 486055, 491782, 495148, 506467, 508818, 509993, 512539, 512541, 518031, 518858, 521159, 522847, 523706, 528788, 528906, 534178, 551913, 554388, 554391, 554465, 559120, 559124, 564597, 564602, 569520, 583527, 588343, 594431, 599609, 599659, 600503, 602668, 610607, 614017, 625798, 674473, 729635, 742199, 744265, 750876, 761275, 780690, 805874, 806084);

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
  383943
  387905
  388792
  395666
  401064
  401203
  401221
  401228
  401933
  412132
  413087
  416886
  417738
  426005
  428509
  428512
  428514
  428520
  428522
  428531
  428533
  446085
  447930
  453338
  455961
  456915
  457988
  464965
  465549
  466943
  471413
  471512
  474877
  478459
  480749
  482555
  483103
  483802
  485098
  485481
  486055
  491782
  495148
  506467
  508818
  509993
  512539
  512541
  518031
  518858
  521159
  522847
  523706
  528788
  528906
  534178
  551913
  554388
  554391
  554465
  559120
  559124
  564597
  564602
  569520
  583527
  588343
  594431
  599609
  599659
  600503
  602668
  610607
  614017
  625798
  674473
  729635
  742199
  744265
  750876
  761275
  780690
  805874
  806084
]

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 (383943, 387905, 388792, 395666, 401064, 401203, 401221, 401228, 401933, 412132, 413087, 416886, 417738, 426005, 428509, 428512, 428514, 428520, 428522, 428531, 428533, 446085, 447930, 453338, 455961, 456915, 457988, 464965, 465549, 466943, 471413, 471512, 474877, 478459, 480749, 482555, 483103, 483802, 485098, 485481, 486055, 491782, 495148, 506467, 508818, 509993, 512539, 512541, 518031, 518858, 521159, 522847, 523706, 528788, 528906, 534178, 551913, 554388, 554391, 554465, 559120, 559124, 564597, 564602, 569520, 583527, 588343, 594431, 599609, 599659, 600503, 602668, 610607, 614017, 625798, 674473, 729635, 742199, 744265, 750876, 761275, 780690, 805874, 806084);

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

[
  "old german"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'old german';

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

[
  "old german"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'old german';