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

[
  "horny fucking"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'horny 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
  423782
  462835
  476329
  476624
  467668
  420311
  463367
  510652
  522961
  488881
  524403
  407809
  815064
  447825
  455512
  493037
  475474
  518725
  531153
  525196
  525386
  551263
  714309
  714776
  649645
  680439
  584428
  593043
  598782
  623874
  810665
  792910
  802104
  726488
  726587
  412227
  522744
  529478
  407208
  420493
  475269
  493818
  466729
  491290
  512936
  513084
  522387
  524749
  560428
  544067
  564494
  488249
  483360
  500513
  438001
  528402
  528713
  536655
  662653
  614431
  633444
  444165
  425070
  456607
  511827
  525931
  501958
  492799
  558614
  571841
  556661
  633047
  591035
  556865
  564453
  454709
  560176
  610574
  635106
]

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 (423782, 462835, 476329, 476624, 467668, 420311, 463367, 510652, 522961, 488881, 524403, 407809, 815064, 447825, 455512, 493037, 475474, 518725, 531153, 525196, 525386, 551263, 714309, 714776, 649645, 680439, 584428, 593043, 598782, 623874, 810665, 792910, 802104, 726488, 726587, 412227, 522744, 529478, 407208, 420493, 475269, 493818, 466729, 491290, 512936, 513084, 522387, 524749, 560428, 544067, 564494, 488249, 483360, 500513, 438001, 528402, 528713, 536655, 662653, 614431, 633444, 444165, 425070, 456607, 511827, 525931, 501958, 492799, 558614, 571841, 556661, 633047, 591035, 556865, 564453, 454709, 560176, 610574, 635106);

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
  407208
  407809
  412227
  420311
  420493
  423782
  425070
  438001
  444165
  447825
  454709
  455512
  456607
  462835
  463367
  466729
  467668
  475269
  475474
  476329
  476624
  483360
  488249
  488881
  491290
  492799
  493037
  493818
  500513
  501958
  510652
  511827
  512936
  513084
  518725
  522387
  522744
  522961
  524403
  524749
  525196
  525386
  525931
  528402
  528713
  529478
  531153
  536655
  544067
  551263
  556661
  556865
  558614
  560176
  560428
  564453
  564494
  571841
  584428
  591035
  593043
  598782
  610574
  614431
  623874
  633047
  633444
  635106
  649645
  662653
  680439
  714309
  714776
  726488
  726587
  792910
  802104
  810665
  815064
]

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 (407208, 407809, 412227, 420311, 420493, 423782, 425070, 438001, 444165, 447825, 454709, 455512, 456607, 462835, 463367, 466729, 467668, 475269, 475474, 476329, 476624, 483360, 488249, 488881, 491290, 492799, 493037, 493818, 500513, 501958, 510652, 511827, 512936, 513084, 518725, 522387, 522744, 522961, 524403, 524749, 525196, 525386, 525931, 528402, 528713, 529478, 531153, 536655, 544067, 551263, 556661, 556865, 558614, 560176, 560428, 564453, 564494, 571841, 584428, 591035, 593043, 598782, 610574, 614431, 623874, 633047, 633444, 635106, 649645, 662653, 680439, 714309, 714776, 726488, 726587, 792910, 802104, 810665, 815064);

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
  407208
  407809
  412227
  420311
  420493
  423782
  425070
  438001
  444165
  447825
  454709
  455512
  456607
  462835
  463367
  466729
  467668
  475269
  475474
  476329
  476624
  483360
  488249
  488881
  491290
  492799
  493037
  493818
  500513
  501958
  510652
  511827
  512936
  513084
  518725
  522387
  522744
  522961
  524403
  524749
  525196
  525386
  525931
  528402
  528713
  529478
  531153
  536655
  544067
  551263
  556661
  556865
  558614
  560176
  560428
  564453
  564494
  571841
  584428
  591035
  593043
  598782
  610574
  614431
  623874
  633047
  633444
  635106
  649645
  662653
  680439
  714309
  714776
  726488
  726587
  792910
  802104
  810665
  815064
]

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 (407208, 407809, 412227, 420311, 420493, 423782, 425070, 438001, 444165, 447825, 454709, 455512, 456607, 462835, 463367, 466729, 467668, 475269, 475474, 476329, 476624, 483360, 488249, 488881, 491290, 492799, 493037, 493818, 500513, 501958, 510652, 511827, 512936, 513084, 518725, 522387, 522744, 522961, 524403, 524749, 525196, 525386, 525931, 528402, 528713, 529478, 531153, 536655, 544067, 551263, 556661, 556865, 558614, 560176, 560428, 564453, 564494, 571841, 584428, 591035, 593043, 598782, 610574, 614431, 623874, 633047, 633444, 635106, 649645, 662653, 680439, 714309, 714776, 726488, 726587, 792910, 802104, 810665, 815064);

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

[
  "horny fucking"
]

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

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

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

[
  "horny fucking"
]

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

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