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

[
  "молодую пышку в попу"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'молодую пышку в попу' 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
  450281
  503477
  490304
  638576
  420635
  444003
  382050
  698102
  410267
  543556
  533741
  588288
  414341
  432955
  445792
  452107
  568982
  441004
  405028
  468630
  814399
  481910
  615246
  523206
  594370
  414131
  412288
  502599
  450194
  560660
  567946
  457160
  619288
  456708
  637145
  556797
  604243
  512502
  569544
  671834
  610588
  595510
  535116
  742622
  624270
  599361
  651933
  595875
  439819
  627817
  543745
  605635
  410254
  428276
  622817
  544816
  425903
  824935
  696126
  485454
  637074
  500971
  422353
  677025
  502626
  614737
  445641
  578508
  750790
  477005
  448698
  473476
  574141
  538281
  607608
  589040
  454969
  484680
  622407
]

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 (450281, 503477, 490304, 638576, 420635, 444003, 382050, 698102, 410267, 543556, 533741, 588288, 414341, 432955, 445792, 452107, 568982, 441004, 405028, 468630, 814399, 481910, 615246, 523206, 594370, 414131, 412288, 502599, 450194, 560660, 567946, 457160, 619288, 456708, 637145, 556797, 604243, 512502, 569544, 671834, 610588, 595510, 535116, 742622, 624270, 599361, 651933, 595875, 439819, 627817, 543745, 605635, 410254, 428276, 622817, 544816, 425903, 824935, 696126, 485454, 637074, 500971, 422353, 677025, 502626, 614737, 445641, 578508, 750790, 477005, 448698, 473476, 574141, 538281, 607608, 589040, 454969, 484680, 622407);

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
  382050
  405028
  410254
  410267
  412288
  414131
  414341
  420635
  422353
  425903
  428276
  432955
  439819
  441004
  444003
  445641
  445792
  448698
  450194
  450281
  452107
  454969
  456708
  457160
  468630
  473476
  477005
  481910
  484680
  485454
  490304
  500971
  502599
  502626
  503477
  512502
  523206
  533741
  535116
  538281
  543556
  543745
  544816
  556797
  560660
  567946
  568982
  569544
  574141
  578508
  588288
  589040
  594370
  595510
  595875
  599361
  604243
  605635
  607608
  610588
  614737
  615246
  619288
  622407
  622817
  624270
  627817
  637074
  637145
  638576
  651933
  671834
  677025
  696126
  698102
  742622
  750790
  814399
  824935
]

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 (382050, 405028, 410254, 410267, 412288, 414131, 414341, 420635, 422353, 425903, 428276, 432955, 439819, 441004, 444003, 445641, 445792, 448698, 450194, 450281, 452107, 454969, 456708, 457160, 468630, 473476, 477005, 481910, 484680, 485454, 490304, 500971, 502599, 502626, 503477, 512502, 523206, 533741, 535116, 538281, 543556, 543745, 544816, 556797, 560660, 567946, 568982, 569544, 574141, 578508, 588288, 589040, 594370, 595510, 595875, 599361, 604243, 605635, 607608, 610588, 614737, 615246, 619288, 622407, 622817, 624270, 627817, 637074, 637145, 638576, 651933, 671834, 677025, 696126, 698102, 742622, 750790, 814399, 824935);

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
  382050
  405028
  410254
  410267
  412288
  414131
  414341
  420635
  422353
  425903
  428276
  432955
  439819
  441004
  444003
  445641
  445792
  448698
  450194
  450281
  452107
  454969
  456708
  457160
  468630
  473476
  477005
  481910
  484680
  485454
  490304
  500971
  502599
  502626
  503477
  512502
  523206
  533741
  535116
  538281
  543556
  543745
  544816
  556797
  560660
  567946
  568982
  569544
  574141
  578508
  588288
  589040
  594370
  595510
  595875
  599361
  604243
  605635
  607608
  610588
  614737
  615246
  619288
  622407
  622817
  624270
  627817
  637074
  637145
  638576
  651933
  671834
  677025
  696126
  698102
  742622
  750790
  814399
  824935
]

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 (382050, 405028, 410254, 410267, 412288, 414131, 414341, 420635, 422353, 425903, 428276, 432955, 439819, 441004, 444003, 445641, 445792, 448698, 450194, 450281, 452107, 454969, 456708, 457160, 468630, 473476, 477005, 481910, 484680, 485454, 490304, 500971, 502599, 502626, 503477, 512502, 523206, 533741, 535116, 538281, 543556, 543745, 544816, 556797, 560660, 567946, 568982, 569544, 574141, 578508, 588288, 589040, 594370, 595510, 595875, 599361, 604243, 605635, 607608, 610588, 614737, 615246, 619288, 622407, 622817, 624270, 627817, 637074, 637145, 638576, 651933, 671834, 677025, 696126, 698102, 742622, 750790, 814399, 824935);

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

[
  "молодая девушк полная анал"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'молодая девушк полная анал';

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

[
  "молодая девушк полная анал"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'молодая девушк полная анал';