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

[
  "indian dick big"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'indian dick big' 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
  593247
  522010
  588005
  542578
  581124
  801234
  489183
  565784
  583575
  570423
  578285
  596517
  738636
  742043
  716974
  583541
  485140
  580866
  582297
  630092
  476564
  542224
  577101
  600464
  492136
  760068
  570747
  596966
  736226
  585328
  526601
  596956
  569947
  590975
  476225
  543794
  600804
  559315
  543929
  566563
  667253
  590265
  614376
  592364
  591750
  716965
  614041
  590344
  788132
  546119
  458197
  570148
  519589
  570426
  592363
  509591
  546113
  569956
  716980
  420516
  592318
  588620
  433047
  433040
  582371
  433038
  471780
  529184
  580201
  618575
  521807
  575710
  592170
  528146
  630781
  630859
  435066
  619571
  670564
  492445
  484299
  478651
  566566
  601101
]

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 (593247, 522010, 588005, 542578, 581124, 801234, 489183, 565784, 583575, 570423, 578285, 596517, 738636, 742043, 716974, 583541, 485140, 580866, 582297, 630092, 476564, 542224, 577101, 600464, 492136, 760068, 570747, 596966, 736226, 585328, 526601, 596956, 569947, 590975, 476225, 543794, 600804, 559315, 543929, 566563, 667253, 590265, 614376, 592364, 591750, 716965, 614041, 590344, 788132, 546119, 458197, 570148, 519589, 570426, 592363, 509591, 546113, 569956, 716980, 420516, 592318, 588620, 433047, 433040, 582371, 433038, 471780, 529184, 580201, 618575, 521807, 575710, 592170, 528146, 630781, 630859, 435066, 619571, 670564, 492445, 484299, 478651, 566566, 601101);

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
  420516
  433038
  433040
  433047
  435066
  458197
  471780
  476225
  476564
  478651
  484299
  485140
  489183
  492136
  492445
  509591
  519589
  521807
  522010
  526601
  528146
  529184
  542224
  542578
  543794
  543929
  546113
  546119
  559315
  565784
  566563
  566566
  569947
  569956
  570148
  570423
  570426
  570747
  575710
  577101
  578285
  580201
  580866
  581124
  582297
  582371
  583541
  583575
  585328
  588005
  588620
  590265
  590344
  590975
  591750
  592170
  592318
  592363
  592364
  593247
  596517
  596956
  596966
  600464
  600804
  601101
  614041
  614376
  618575
  619571
  630092
  630781
  630859
  667253
  670564
  716965
  716974
  716980
  736226
  738636
  742043
  760068
  788132
  801234
]

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 (420516, 433038, 433040, 433047, 435066, 458197, 471780, 476225, 476564, 478651, 484299, 485140, 489183, 492136, 492445, 509591, 519589, 521807, 522010, 526601, 528146, 529184, 542224, 542578, 543794, 543929, 546113, 546119, 559315, 565784, 566563, 566566, 569947, 569956, 570148, 570423, 570426, 570747, 575710, 577101, 578285, 580201, 580866, 581124, 582297, 582371, 583541, 583575, 585328, 588005, 588620, 590265, 590344, 590975, 591750, 592170, 592318, 592363, 592364, 593247, 596517, 596956, 596966, 600464, 600804, 601101, 614041, 614376, 618575, 619571, 630092, 630781, 630859, 667253, 670564, 716965, 716974, 716980, 736226, 738636, 742043, 760068, 788132, 801234);

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
  420516
  433038
  433040
  433047
  435066
  458197
  471780
  476225
  476564
  478651
  484299
  485140
  489183
  492136
  492445
  509591
  519589
  521807
  522010
  526601
  528146
  529184
  542224
  542578
  543794
  543929
  546113
  546119
  559315
  565784
  566563
  566566
  569947
  569956
  570148
  570423
  570426
  570747
  575710
  577101
  578285
  580201
  580866
  581124
  582297
  582371
  583541
  583575
  585328
  588005
  588620
  590265
  590344
  590975
  591750
  592170
  592318
  592363
  592364
  593247
  596517
  596956
  596966
  600464
  600804
  601101
  614041
  614376
  618575
  619571
  630092
  630781
  630859
  667253
  670564
  716965
  716974
  716980
  736226
  738636
  742043
  760068
  788132
  801234
]

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 (420516, 433038, 433040, 433047, 435066, 458197, 471780, 476225, 476564, 478651, 484299, 485140, 489183, 492136, 492445, 509591, 519589, 521807, 522010, 526601, 528146, 529184, 542224, 542578, 543794, 543929, 546113, 546119, 559315, 565784, 566563, 566566, 569947, 569956, 570148, 570423, 570426, 570747, 575710, 577101, 578285, 580201, 580866, 581124, 582297, 582371, 583541, 583575, 585328, 588005, 588620, 590265, 590344, 590975, 591750, 592170, 592318, 592363, 592364, 593247, 596517, 596956, 596966, 600464, 600804, 601101, 614041, 614376, 618575, 619571, 630092, 630781, 630859, 667253, 670564, 716965, 716974, 716980, 736226, 738636, 742043, 760068, 788132, 801234);

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

[
  "indian член большие"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'indian член большие';

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

[
  "indian член большие"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'indian член большие';