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

[
  "hard anal pov"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'hard anal pov' 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
  479212
  589573
  421580
  441843
  424341
  520781
  421663
  445646
  456480
  761189
  418551
  465239
  558886
  598190
  599345
  561441
  440339
  482221
  496526
  605762
  522759
  526951
  452299
  425332
  519962
  424261
  478257
  463024
  512761
  640837
  620266
  456812
  529143
  599124
  524142
  647897
  593764
  597892
  618673
  459513
  485061
  567757
  452324
  737015
  420472
  502817
  598762
  459535
  440824
  761129
  532380
  521132
  705099
  445649
  558543
  457955
  649587
  469597
  558566
  689436
  598466
  455980
  462623
  502779
  462618
  419956
  533707
  619527
  582697
  464977
  552348
  551816
  424190
  568078
  604743
  457975
  477114
  492169
]

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 (479212, 589573, 421580, 441843, 424341, 520781, 421663, 445646, 456480, 761189, 418551, 465239, 558886, 598190, 599345, 561441, 440339, 482221, 496526, 605762, 522759, 526951, 452299, 425332, 519962, 424261, 478257, 463024, 512761, 640837, 620266, 456812, 529143, 599124, 524142, 647897, 593764, 597892, 618673, 459513, 485061, 567757, 452324, 737015, 420472, 502817, 598762, 459535, 440824, 761129, 532380, 521132, 705099, 445649, 558543, 457955, 649587, 469597, 558566, 689436, 598466, 455980, 462623, 502779, 462618, 419956, 533707, 619527, 582697, 464977, 552348, 551816, 424190, 568078, 604743, 457975, 477114, 492169);

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
  418551
  419956
  420472
  421580
  421663
  424190
  424261
  424341
  425332
  440339
  440824
  441843
  445646
  445649
  452299
  452324
  455980
  456480
  456812
  457955
  457975
  459513
  459535
  462618
  462623
  463024
  464977
  465239
  469597
  477114
  478257
  479212
  482221
  485061
  492169
  496526
  502779
  502817
  512761
  519962
  520781
  521132
  522759
  524142
  526951
  529143
  532380
  533707
  551816
  552348
  558543
  558566
  558886
  561441
  567757
  568078
  582697
  589573
  593764
  597892
  598190
  598466
  598762
  599124
  599345
  604743
  605762
  618673
  619527
  620266
  640837
  647897
  649587
  689436
  705099
  737015
  761129
  761189
]

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 (418551, 419956, 420472, 421580, 421663, 424190, 424261, 424341, 425332, 440339, 440824, 441843, 445646, 445649, 452299, 452324, 455980, 456480, 456812, 457955, 457975, 459513, 459535, 462618, 462623, 463024, 464977, 465239, 469597, 477114, 478257, 479212, 482221, 485061, 492169, 496526, 502779, 502817, 512761, 519962, 520781, 521132, 522759, 524142, 526951, 529143, 532380, 533707, 551816, 552348, 558543, 558566, 558886, 561441, 567757, 568078, 582697, 589573, 593764, 597892, 598190, 598466, 598762, 599124, 599345, 604743, 605762, 618673, 619527, 620266, 640837, 647897, 649587, 689436, 705099, 737015, 761129, 761189);

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
  418551
  419956
  420472
  421580
  421663
  424190
  424261
  424341
  425332
  440339
  440824
  441843
  445646
  445649
  452299
  452324
  455980
  456480
  456812
  457955
  457975
  459513
  459535
  462618
  462623
  463024
  464977
  465239
  469597
  477114
  478257
  479212
  482221
  485061
  492169
  496526
  502779
  502817
  512761
  519962
  520781
  521132
  522759
  524142
  526951
  529143
  532380
  533707
  551816
  552348
  558543
  558566
  558886
  561441
  567757
  568078
  582697
  589573
  593764
  597892
  598190
  598466
  598762
  599124
  599345
  604743
  605762
  618673
  619527
  620266
  640837
  647897
  649587
  689436
  705099
  737015
  761129
  761189
]

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 (418551, 419956, 420472, 421580, 421663, 424190, 424261, 424341, 425332, 440339, 440824, 441843, 445646, 445649, 452299, 452324, 455980, 456480, 456812, 457955, 457975, 459513, 459535, 462618, 462623, 463024, 464977, 465239, 469597, 477114, 478257, 479212, 482221, 485061, 492169, 496526, 502779, 502817, 512761, 519962, 520781, 521132, 522759, 524142, 526951, 529143, 532380, 533707, 551816, 552348, 558543, 558566, 558886, 561441, 567757, 568078, 582697, 589573, 593764, 597892, 598190, 598466, 598762, 599124, 599345, 604743, 605762, 618673, 619527, 620266, 640837, 647897, 649587, 689436, 705099, 737015, 761129, 761189);

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

[
  "hard анал пов"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'hard анал пов';

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

[
  "hard анал пов"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'hard анал пов';