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

[
  "huge busty"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'huge 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
  465006
  472578
  647935
  690323
  587162
  607236
  610343
  401465
  413087
  449870
  465079
  454282
  459879
  465553
  526799
  487547
  397481
  414200
  415919
  415547
  424366
  815313
  464994
  501682
  531191
  531304
  518191
  528845
  577535
  553296
  581602
  584635
  615839
  794214
  439445
  453132
  413584
  479657
  454562
  456766
  417473
  446019
  529187
  431393
  432831
  471881
  510199
  536562
  536489
  645952
  446909
  451804
  409035
  448926
  523012
  447959
  473869
  573941
  708441
  629357
  585701
  428758
  471088
  527942
  526814
  416166
  454954
  446738
  579647
  678117
  674988
  419123
  477757
  527767
  414771
  543579
  558991
  675010
  609845
  530777
  561478
  409001
  512527
]

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 (465006, 472578, 647935, 690323, 587162, 607236, 610343, 401465, 413087, 449870, 465079, 454282, 459879, 465553, 526799, 487547, 397481, 414200, 415919, 415547, 424366, 815313, 464994, 501682, 531191, 531304, 518191, 528845, 577535, 553296, 581602, 584635, 615839, 794214, 439445, 453132, 413584, 479657, 454562, 456766, 417473, 446019, 529187, 431393, 432831, 471881, 510199, 536562, 536489, 645952, 446909, 451804, 409035, 448926, 523012, 447959, 473869, 573941, 708441, 629357, 585701, 428758, 471088, 527942, 526814, 416166, 454954, 446738, 579647, 678117, 674988, 419123, 477757, 527767, 414771, 543579, 558991, 675010, 609845, 530777, 561478, 409001, 512527);

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
  397481
  401465
  409001
  409035
  413087
  413584
  414200
  414771
  415547
  415919
  416166
  417473
  419123
  424366
  428758
  431393
  432831
  439445
  446019
  446738
  446909
  447959
  448926
  449870
  451804
  453132
  454282
  454562
  454954
  456766
  459879
  464994
  465006
  465079
  465553
  471088
  471881
  472578
  473869
  477757
  479657
  487547
  501682
  510199
  512527
  518191
  523012
  526799
  526814
  527767
  527942
  528845
  529187
  530777
  531191
  531304
  536489
  536562
  543579
  553296
  558991
  561478
  573941
  577535
  579647
  581602
  584635
  585701
  587162
  607236
  609845
  610343
  615839
  629357
  645952
  647935
  674988
  675010
  678117
  690323
  708441
  794214
  815313
]

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 (397481, 401465, 409001, 409035, 413087, 413584, 414200, 414771, 415547, 415919, 416166, 417473, 419123, 424366, 428758, 431393, 432831, 439445, 446019, 446738, 446909, 447959, 448926, 449870, 451804, 453132, 454282, 454562, 454954, 456766, 459879, 464994, 465006, 465079, 465553, 471088, 471881, 472578, 473869, 477757, 479657, 487547, 501682, 510199, 512527, 518191, 523012, 526799, 526814, 527767, 527942, 528845, 529187, 530777, 531191, 531304, 536489, 536562, 543579, 553296, 558991, 561478, 573941, 577535, 579647, 581602, 584635, 585701, 587162, 607236, 609845, 610343, 615839, 629357, 645952, 647935, 674988, 675010, 678117, 690323, 708441, 794214, 815313);

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
  397481
  401465
  409001
  409035
  413087
  413584
  414200
  414771
  415547
  415919
  416166
  417473
  419123
  424366
  428758
  431393
  432831
  439445
  446019
  446738
  446909
  447959
  448926
  449870
  451804
  453132
  454282
  454562
  454954
  456766
  459879
  464994
  465006
  465079
  465553
  471088
  471881
  472578
  473869
  477757
  479657
  487547
  501682
  510199
  512527
  518191
  523012
  526799
  526814
  527767
  527942
  528845
  529187
  530777
  531191
  531304
  536489
  536562
  543579
  553296
  558991
  561478
  573941
  577535
  579647
  581602
  584635
  585701
  587162
  607236
  609845
  610343
  615839
  629357
  645952
  647935
  674988
  675010
  678117
  690323
  708441
  794214
  815313
]

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 (397481, 401465, 409001, 409035, 413087, 413584, 414200, 414771, 415547, 415919, 416166, 417473, 419123, 424366, 428758, 431393, 432831, 439445, 446019, 446738, 446909, 447959, 448926, 449870, 451804, 453132, 454282, 454562, 454954, 456766, 459879, 464994, 465006, 465079, 465553, 471088, 471881, 472578, 473869, 477757, 479657, 487547, 501682, 510199, 512527, 518191, 523012, 526799, 526814, 527767, 527942, 528845, 529187, 530777, 531191, 531304, 536489, 536562, 543579, 553296, 558991, 561478, 573941, 577535, 579647, 581602, 584635, 585701, 587162, 607236, 609845, 610343, 615839, 629357, 645952, 647935, 674988, 675010, 678117, 690323, 708441, 794214, 815313);

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

[
  "огромные busty"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'огромные busty';

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

[
  "огромные busty"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'огромные busty';