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 big ass"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'indian big ass' 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
  573502
  577039
  596517
  614118
  621540
  591724
  740694
  803087
  742043
  772001
  814399
  493825
  543022
  546119
  588603
  630092
  492137
  521763
  559356
  508138
  660457
  485140
  582235
  481323
  507111
  577101
  580866
  559345
  667253
  582297
  590265
  614376
  589664
  760068
  736226
  527910
  788132
  590968
  575710
  539857
  546113
  590344
  433382
  476564
  570747
  542578
  569947
  569956
  589685
  590975
  615428
  596956
  600804
  489183
  500955
  433038
  592363
  476225
  570426
  433040
  526601
  592318
  471780
  420516
  543794
  592170
  583541
  509591
  580201
  433047
  472299
  521807
  433391
  614041
  519589
  484299
  528146
  670564
  601101
  630781
  492445
  478651
]

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 (573502, 577039, 596517, 614118, 621540, 591724, 740694, 803087, 742043, 772001, 814399, 493825, 543022, 546119, 588603, 630092, 492137, 521763, 559356, 508138, 660457, 485140, 582235, 481323, 507111, 577101, 580866, 559345, 667253, 582297, 590265, 614376, 589664, 760068, 736226, 527910, 788132, 590968, 575710, 539857, 546113, 590344, 433382, 476564, 570747, 542578, 569947, 569956, 589685, 590975, 615428, 596956, 600804, 489183, 500955, 433038, 592363, 476225, 570426, 433040, 526601, 592318, 471780, 420516, 543794, 592170, 583541, 509591, 580201, 433047, 472299, 521807, 433391, 614041, 519589, 484299, 528146, 670564, 601101, 630781, 492445, 478651);

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
  433382
  433391
  471780
  472299
  476225
  476564
  478651
  481323
  484299
  485140
  489183
  492137
  492445
  493825
  500955
  507111
  508138
  509591
  519589
  521763
  521807
  526601
  527910
  528146
  539857
  542578
  543022
  543794
  546113
  546119
  559345
  559356
  569947
  569956
  570426
  570747
  573502
  575710
  577039
  577101
  580201
  580866
  582235
  582297
  583541
  588603
  589664
  589685
  590265
  590344
  590968
  590975
  591724
  592170
  592318
  592363
  596517
  596956
  600804
  601101
  614041
  614118
  614376
  615428
  621540
  630092
  630781
  660457
  667253
  670564
  736226
  740694
  742043
  760068
  772001
  788132
  803087
  814399
]

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, 433382, 433391, 471780, 472299, 476225, 476564, 478651, 481323, 484299, 485140, 489183, 492137, 492445, 493825, 500955, 507111, 508138, 509591, 519589, 521763, 521807, 526601, 527910, 528146, 539857, 542578, 543022, 543794, 546113, 546119, 559345, 559356, 569947, 569956, 570426, 570747, 573502, 575710, 577039, 577101, 580201, 580866, 582235, 582297, 583541, 588603, 589664, 589685, 590265, 590344, 590968, 590975, 591724, 592170, 592318, 592363, 596517, 596956, 600804, 601101, 614041, 614118, 614376, 615428, 621540, 630092, 630781, 660457, 667253, 670564, 736226, 740694, 742043, 760068, 772001, 788132, 803087, 814399);

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
  433382
  433391
  471780
  472299
  476225
  476564
  478651
  481323
  484299
  485140
  489183
  492137
  492445
  493825
  500955
  507111
  508138
  509591
  519589
  521763
  521807
  526601
  527910
  528146
  539857
  542578
  543022
  543794
  546113
  546119
  559345
  559356
  569947
  569956
  570426
  570747
  573502
  575710
  577039
  577101
  580201
  580866
  582235
  582297
  583541
  588603
  589664
  589685
  590265
  590344
  590968
  590975
  591724
  592170
  592318
  592363
  596517
  596956
  600804
  601101
  614041
  614118
  614376
  615428
  621540
  630092
  630781
  660457
  667253
  670564
  736226
  740694
  742043
  760068
  772001
  788132
  803087
  814399
]

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, 433382, 433391, 471780, 472299, 476225, 476564, 478651, 481323, 484299, 485140, 489183, 492137, 492445, 493825, 500955, 507111, 508138, 509591, 519589, 521763, 521807, 526601, 527910, 528146, 539857, 542578, 543022, 543794, 546113, 546119, 559345, 559356, 569947, 569956, 570426, 570747, 573502, 575710, 577039, 577101, 580201, 580866, 582235, 582297, 583541, 588603, 589664, 589685, 590265, 590344, 590968, 590975, 591724, 592170, 592318, 592363, 596517, 596956, 600804, 601101, 614041, 614118, 614376, 615428, 621540, 630092, 630781, 660457, 667253, 670564, 736226, 740694, 742043, 760068, 772001, 788132, 803087, 814399);

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 большая большие жоп';