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 busty"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'cum busty' 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
  456936
  482039
  418877
  444260
  446560
  452585
  479343
  522767
  486574
  509074
  513583
  519339
  519953
  485803
  500446
  506227
  483867
  529153
  191179
  414200
  443420
  447947
  501682
  514047
  537946
  528838
  528845
  565283
  580978
  566326
  584635
  581199
  594975
  604907
  808077
  457319
  424387
  456766
  481670
  452593
  472114
  528164
  488391
  486953
  500059
  426197
  448922
  510199
  526819
  538676
  526367
  526369
  476801
  541336
  647847
  651285
  569581
  623618
  447917
  486869
  523806
  486877
  710524
  575716
  452286
  493464
  526814
  486875
  519556
  512848
  416426
  535808
  609906
  486871
  548696
  516904
  587248
  572344
]

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 (456936, 482039, 418877, 444260, 446560, 452585, 479343, 522767, 486574, 509074, 513583, 519339, 519953, 485803, 500446, 506227, 483867, 529153, 191179, 414200, 443420, 447947, 501682, 514047, 537946, 528838, 528845, 565283, 580978, 566326, 584635, 581199, 594975, 604907, 808077, 457319, 424387, 456766, 481670, 452593, 472114, 528164, 488391, 486953, 500059, 426197, 448922, 510199, 526819, 538676, 526367, 526369, 476801, 541336, 647847, 651285, 569581, 623618, 447917, 486869, 523806, 486877, 710524, 575716, 452286, 493464, 526814, 486875, 519556, 512848, 416426, 535808, 609906, 486871, 548696, 516904, 587248, 572344);

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
  191179
  414200
  416426
  418877
  424387
  426197
  443420
  444260
  446560
  447917
  447947
  448922
  452286
  452585
  452593
  456766
  456936
  457319
  472114
  476801
  479343
  481670
  482039
  483867
  485803
  486574
  486869
  486871
  486875
  486877
  486953
  488391
  493464
  500059
  500446
  501682
  506227
  509074
  510199
  512848
  513583
  514047
  516904
  519339
  519556
  519953
  522767
  523806
  526367
  526369
  526814
  526819
  528164
  528838
  528845
  529153
  535808
  537946
  538676
  541336
  548696
  565283
  566326
  569581
  572344
  575716
  580978
  581199
  584635
  587248
  594975
  604907
  609906
  623618
  647847
  651285
  710524
  808077
]

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 (191179, 414200, 416426, 418877, 424387, 426197, 443420, 444260, 446560, 447917, 447947, 448922, 452286, 452585, 452593, 456766, 456936, 457319, 472114, 476801, 479343, 481670, 482039, 483867, 485803, 486574, 486869, 486871, 486875, 486877, 486953, 488391, 493464, 500059, 500446, 501682, 506227, 509074, 510199, 512848, 513583, 514047, 516904, 519339, 519556, 519953, 522767, 523806, 526367, 526369, 526814, 526819, 528164, 528838, 528845, 529153, 535808, 537946, 538676, 541336, 548696, 565283, 566326, 569581, 572344, 575716, 580978, 581199, 584635, 587248, 594975, 604907, 609906, 623618, 647847, 651285, 710524, 808077);

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
  191179
  414200
  416426
  418877
  424387
  426197
  443420
  444260
  446560
  447917
  447947
  448922
  452286
  452585
  452593
  456766
  456936
  457319
  472114
  476801
  479343
  481670
  482039
  483867
  485803
  486574
  486869
  486871
  486875
  486877
  486953
  488391
  493464
  500059
  500446
  501682
  506227
  509074
  510199
  512848
  513583
  514047
  516904
  519339
  519556
  519953
  522767
  523806
  526367
  526369
  526814
  526819
  528164
  528838
  528845
  529153
  535808
  537946
  538676
  541336
  548696
  565283
  566326
  569581
  572344
  575716
  580978
  581199
  584635
  587248
  594975
  604907
  609906
  623618
  647847
  651285
  710524
  808077
]

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 (191179, 414200, 416426, 418877, 424387, 426197, 443420, 444260, 446560, 447917, 447947, 448922, 452286, 452585, 452593, 456766, 456936, 457319, 472114, 476801, 479343, 481670, 482039, 483867, 485803, 486574, 486869, 486871, 486875, 486877, 486953, 488391, 493464, 500059, 500446, 501682, 506227, 509074, 510199, 512848, 513583, 514047, 516904, 519339, 519556, 519953, 522767, 523806, 526367, 526369, 526814, 526819, 528164, 528838, 528845, 529153, 535808, 537946, 538676, 541336, 548696, 565283, 566326, 569581, 572344, 575716, 580978, 581199, 584635, 587248, 594975, 604907, 609906, 623618, 647847, 651285, 710524, 808077);

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

[
  "cum busty"
]

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

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

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

[
  "cum busty"
]

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

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