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

[
  "cum fucking"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'cum fucking' 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
  570737
  577544
  559112
  583037
  555120
  564494
  564880
  565000
  684704
  714307
  697006
  567678
  573334
  598184
  587519
  614857
  615774
  744316
  634688
  440662
  464486
  473691
  444781
  474897
  454865
  475195
  447079
  451018
  488249
  506148
  526452
  484127
  515614
  491725
  438001
  447265
  476903
  486601
  532349
  519851
  500583
  528329
  486866
  545009
  578445
  583448
  712879
  585798
  644276
  600200
  621796
  637741
  438045
  511827
  520428
  466376
  486862
  530757
  533073
  558614
  543731
  558338
  650127
  624921
  625556
  530000
  814903
  512848
  598494
  486864
  486868
  602446
  511231
  689013
  625359
  520232
]

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 (570737, 577544, 559112, 583037, 555120, 564494, 564880, 565000, 684704, 714307, 697006, 567678, 573334, 598184, 587519, 614857, 615774, 744316, 634688, 440662, 464486, 473691, 444781, 474897, 454865, 475195, 447079, 451018, 488249, 506148, 526452, 484127, 515614, 491725, 438001, 447265, 476903, 486601, 532349, 519851, 500583, 528329, 486866, 545009, 578445, 583448, 712879, 585798, 644276, 600200, 621796, 637741, 438045, 511827, 520428, 466376, 486862, 530757, 533073, 558614, 543731, 558338, 650127, 624921, 625556, 530000, 814903, 512848, 598494, 486864, 486868, 602446, 511231, 689013, 625359, 520232);

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
  438001
  438045
  440662
  444781
  447079
  447265
  451018
  454865
  464486
  466376
  473691
  474897
  475195
  476903
  484127
  486601
  486862
  486864
  486866
  486868
  488249
  491725
  500583
  506148
  511231
  511827
  512848
  515614
  519851
  520232
  520428
  526452
  528329
  530000
  530757
  532349
  533073
  543731
  545009
  555120
  558338
  558614
  559112
  564494
  564880
  565000
  567678
  570737
  573334
  577544
  578445
  583037
  583448
  585798
  587519
  598184
  598494
  600200
  602446
  614857
  615774
  621796
  624921
  625359
  625556
  634688
  637741
  644276
  650127
  684704
  689013
  697006
  712879
  714307
  744316
  814903
]

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 (438001, 438045, 440662, 444781, 447079, 447265, 451018, 454865, 464486, 466376, 473691, 474897, 475195, 476903, 484127, 486601, 486862, 486864, 486866, 486868, 488249, 491725, 500583, 506148, 511231, 511827, 512848, 515614, 519851, 520232, 520428, 526452, 528329, 530000, 530757, 532349, 533073, 543731, 545009, 555120, 558338, 558614, 559112, 564494, 564880, 565000, 567678, 570737, 573334, 577544, 578445, 583037, 583448, 585798, 587519, 598184, 598494, 600200, 602446, 614857, 615774, 621796, 624921, 625359, 625556, 634688, 637741, 644276, 650127, 684704, 689013, 697006, 712879, 714307, 744316, 814903);

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
  438001
  438045
  440662
  444781
  447079
  447265
  451018
  454865
  464486
  466376
  473691
  474897
  475195
  476903
  484127
  486601
  486862
  486864
  486866
  486868
  488249
  491725
  500583
  506148
  511231
  511827
  512848
  515614
  519851
  520232
  520428
  526452
  528329
  530000
  530757
  532349
  533073
  543731
  545009
  555120
  558338
  558614
  559112
  564494
  564880
  565000
  567678
  570737
  573334
  577544
  578445
  583037
  583448
  585798
  587519
  598184
  598494
  600200
  602446
  614857
  615774
  621796
  624921
  625359
  625556
  634688
  637741
  644276
  650127
  684704
  689013
  697006
  712879
  714307
  744316
  814903
]

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 (438001, 438045, 440662, 444781, 447079, 447265, 451018, 454865, 464486, 466376, 473691, 474897, 475195, 476903, 484127, 486601, 486862, 486864, 486866, 486868, 488249, 491725, 500583, 506148, 511231, 511827, 512848, 515614, 519851, 520232, 520428, 526452, 528329, 530000, 530757, 532349, 533073, 543731, 545009, 555120, 558338, 558614, 559112, 564494, 564880, 565000, 567678, 570737, 573334, 577544, 578445, 583037, 583448, 585798, 587519, 598184, 598494, 600200, 602446, 614857, 615774, 621796, 624921, 625359, 625556, 634688, 637741, 644276, 650127, 684704, 689013, 697006, 712879, 714307, 744316, 814903);

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

[
  "cum fucking"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'cum fucking';

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

[
  "cum fucking"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'cum fucking';