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

[
  "pussy shows"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'pussy shows' 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
  679365
  668701
  549253
  557300
  576848
  614865
  641481
  739500
  772893
  390815
  392418
  473914
  455357
  473420
  489075
  518542
  514621
  571809
  468148
  474989
  501723
  523366
  529858
  505523
  552791
  550827
  611268
  612226
  605255
  593091
  806323
  810986
  428424
  466995
  414516
  476387
  472555
  463426
  522894
  442370
  496553
  524416
  529176
  526679
  563073
  567248
  574768
  636367
  614857
  510425
  512479
  493961
  504423
  526536
  524903
  712995
  592495
  407549
  474394
  412367
  529033
  519549
  525332
  521448
  580860
  552987
  601381
  613489
  416867
  469039
  518220
  583622
  576157
  524896
  529293
  631968
  587264
]

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 (679365, 668701, 549253, 557300, 576848, 614865, 641481, 739500, 772893, 390815, 392418, 473914, 455357, 473420, 489075, 518542, 514621, 571809, 468148, 474989, 501723, 523366, 529858, 505523, 552791, 550827, 611268, 612226, 605255, 593091, 806323, 810986, 428424, 466995, 414516, 476387, 472555, 463426, 522894, 442370, 496553, 524416, 529176, 526679, 563073, 567248, 574768, 636367, 614857, 510425, 512479, 493961, 504423, 526536, 524903, 712995, 592495, 407549, 474394, 412367, 529033, 519549, 525332, 521448, 580860, 552987, 601381, 613489, 416867, 469039, 518220, 583622, 576157, 524896, 529293, 631968, 587264);

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
  390815
  392418
  407549
  412367
  414516
  416867
  428424
  442370
  455357
  463426
  466995
  468148
  469039
  472555
  473420
  473914
  474394
  474989
  476387
  489075
  493961
  496553
  501723
  504423
  505523
  510425
  512479
  514621
  518220
  518542
  519549
  521448
  522894
  523366
  524416
  524896
  524903
  525332
  526536
  526679
  529033
  529176
  529293
  529858
  549253
  550827
  552791
  552987
  557300
  563073
  567248
  571809
  574768
  576157
  576848
  580860
  583622
  587264
  592495
  593091
  601381
  605255
  611268
  612226
  613489
  614857
  614865
  631968
  636367
  641481
  668701
  679365
  712995
  739500
  772893
  806323
  810986
]

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 (390815, 392418, 407549, 412367, 414516, 416867, 428424, 442370, 455357, 463426, 466995, 468148, 469039, 472555, 473420, 473914, 474394, 474989, 476387, 489075, 493961, 496553, 501723, 504423, 505523, 510425, 512479, 514621, 518220, 518542, 519549, 521448, 522894, 523366, 524416, 524896, 524903, 525332, 526536, 526679, 529033, 529176, 529293, 529858, 549253, 550827, 552791, 552987, 557300, 563073, 567248, 571809, 574768, 576157, 576848, 580860, 583622, 587264, 592495, 593091, 601381, 605255, 611268, 612226, 613489, 614857, 614865, 631968, 636367, 641481, 668701, 679365, 712995, 739500, 772893, 806323, 810986);

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
  390815
  392418
  407549
  412367
  414516
  416867
  428424
  442370
  455357
  463426
  466995
  468148
  469039
  472555
  473420
  473914
  474394
  474989
  476387
  489075
  493961
  496553
  501723
  504423
  505523
  510425
  512479
  514621
  518220
  518542
  519549
  521448
  522894
  523366
  524416
  524896
  524903
  525332
  526536
  526679
  529033
  529176
  529293
  529858
  549253
  550827
  552791
  552987
  557300
  563073
  567248
  571809
  574768
  576157
  576848
  580860
  583622
  587264
  592495
  593091
  601381
  605255
  611268
  612226
  613489
  614857
  614865
  631968
  636367
  641481
  668701
  679365
  712995
  739500
  772893
  806323
  810986
]

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 (390815, 392418, 407549, 412367, 414516, 416867, 428424, 442370, 455357, 463426, 466995, 468148, 469039, 472555, 473420, 473914, 474394, 474989, 476387, 489075, 493961, 496553, 501723, 504423, 505523, 510425, 512479, 514621, 518220, 518542, 519549, 521448, 522894, 523366, 524416, 524896, 524903, 525332, 526536, 526679, 529033, 529176, 529293, 529858, 549253, 550827, 552791, 552987, 557300, 563073, 567248, 571809, 574768, 576157, 576848, 580860, 583622, 587264, 592495, 593091, 601381, 605255, 611268, 612226, 613489, 614857, 614865, 631968, 636367, 641481, 668701, 679365, 712995, 739500, 772893, 806323, 810986);

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

[
  "pussy shows"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'pussy shows';

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

[
  "pussy shows"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'pussy shows';