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

[
  "teen xxx video"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'teen xxx video' 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
  397045
  441402
  448108
  472338
  478471
  479352
  497579
  503688
  517868
  484819
  490866
  496810
  514383
  507801
  536388
  514638
  429208
  450418
  540167
  500772
  500726
  502499
  493231
  690936
  694058
  614693
  435157
  474897
  430559
  439029
  492196
  513485
  395915
  88373
  439434
  513049
  529342
  647320
  696233
  593958
  599887
  644526
  420918
  401199
  420206
  474901
  493803
  524322
  493963
  523749
  494784
  500758
  515202
  442726
  434702
  522876
  495220
  532703
  539240
  477762
  598144
  462526
  452965
  513575
  521489
  523021
  583994
  627144
  508497
  532597
  419132
  514800
  603002
  497865
  514648
  502482
  514640
  597282
  598724
  597542
  594228
  538803
  515187
  529290
  510668
]

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 (397045, 441402, 448108, 472338, 478471, 479352, 497579, 503688, 517868, 484819, 490866, 496810, 514383, 507801, 536388, 514638, 429208, 450418, 540167, 500772, 500726, 502499, 493231, 690936, 694058, 614693, 435157, 474897, 430559, 439029, 492196, 513485, 395915, 88373, 439434, 513049, 529342, 647320, 696233, 593958, 599887, 644526, 420918, 401199, 420206, 474901, 493803, 524322, 493963, 523749, 494784, 500758, 515202, 442726, 434702, 522876, 495220, 532703, 539240, 477762, 598144, 462526, 452965, 513575, 521489, 523021, 583994, 627144, 508497, 532597, 419132, 514800, 603002, 497865, 514648, 502482, 514640, 597282, 598724, 597542, 594228, 538803, 515187, 529290, 510668);

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
  88373
  395915
  397045
  401199
  419132
  420206
  420918
  429208
  430559
  434702
  435157
  439029
  439434
  441402
  442726
  448108
  450418
  452965
  462526
  472338
  474897
  474901
  477762
  478471
  479352
  484819
  490866
  492196
  493231
  493803
  493963
  494784
  495220
  496810
  497579
  497865
  500726
  500758
  500772
  502482
  502499
  503688
  507801
  508497
  510668
  513049
  513485
  513575
  514383
  514638
  514640
  514648
  514800
  515187
  515202
  517868
  521489
  522876
  523021
  523749
  524322
  529290
  529342
  532597
  532703
  536388
  538803
  539240
  540167
  583994
  593958
  594228
  597282
  597542
  598144
  598724
  599887
  603002
  614693
  627144
  644526
  647320
  690936
  694058
  696233
]

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 (88373, 395915, 397045, 401199, 419132, 420206, 420918, 429208, 430559, 434702, 435157, 439029, 439434, 441402, 442726, 448108, 450418, 452965, 462526, 472338, 474897, 474901, 477762, 478471, 479352, 484819, 490866, 492196, 493231, 493803, 493963, 494784, 495220, 496810, 497579, 497865, 500726, 500758, 500772, 502482, 502499, 503688, 507801, 508497, 510668, 513049, 513485, 513575, 514383, 514638, 514640, 514648, 514800, 515187, 515202, 517868, 521489, 522876, 523021, 523749, 524322, 529290, 529342, 532597, 532703, 536388, 538803, 539240, 540167, 583994, 593958, 594228, 597282, 597542, 598144, 598724, 599887, 603002, 614693, 627144, 644526, 647320, 690936, 694058, 696233);

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
  88373
  395915
  397045
  401199
  419132
  420206
  420918
  429208
  430559
  434702
  435157
  439029
  439434
  441402
  442726
  448108
  450418
  452965
  462526
  472338
  474897
  474901
  477762
  478471
  479352
  484819
  490866
  492196
  493231
  493803
  493963
  494784
  495220
  496810
  497579
  497865
  500726
  500758
  500772
  502482
  502499
  503688
  507801
  508497
  510668
  513049
  513485
  513575
  514383
  514638
  514640
  514648
  514800
  515187
  515202
  517868
  521489
  522876
  523021
  523749
  524322
  529290
  529342
  532597
  532703
  536388
  538803
  539240
  540167
  583994
  593958
  594228
  597282
  597542
  598144
  598724
  599887
  603002
  614693
  627144
  644526
  647320
  690936
  694058
  696233
]

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 (88373, 395915, 397045, 401199, 419132, 420206, 420918, 429208, 430559, 434702, 435157, 439029, 439434, 441402, 442726, 448108, 450418, 452965, 462526, 472338, 474897, 474901, 477762, 478471, 479352, 484819, 490866, 492196, 493231, 493803, 493963, 494784, 495220, 496810, 497579, 497865, 500726, 500758, 500772, 502482, 502499, 503688, 507801, 508497, 510668, 513049, 513485, 513575, 514383, 514638, 514640, 514648, 514800, 515187, 515202, 517868, 521489, 522876, 523021, 523749, 524322, 529290, 529342, 532597, 532703, 536388, 538803, 539240, 540167, 583994, 593958, 594228, 597282, 597542, 598144, 598724, 599887, 603002, 614693, 627144, 644526, 647320, 690936, 694058, 696233);

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

[
  "teen xxx video"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'teen xxx video';

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

[
  "teen xxx video"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'teen xxx video';