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

[
  "pussy first"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'pussy first' 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
  603693
  640763
  606578
  428993
  402232
  474621
  442973
  420206
  454924
  463478
  478184
  480439
  439693
  495734
  495406
  520473
  525043
  418427
  476399
  478473
  531215
  531165
  527387
  533512
  534028
  494622
  506195
  530376
  460282
  559453
  566736
  704248
  710524
  721846
  582217
  603009
  637121
  637034
  637044
  599826
  600503
  800588
  634118
  395648
  437811
  434275
  497311
  449784
  471612
  534229
  535259
  512539
  526906
  473739
  649525
  633718
  603536
  627144
  628117
  727812
  424360
  466979
  500477
  498036
  659419
  565245
  599922
  609729
  483802
  561853
  574546
  667736
  650313
  625437
  600360
  609275
  460212
  494617
  424837
  515568
  517246
  600011
  523924
]

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 (603693, 640763, 606578, 428993, 402232, 474621, 442973, 420206, 454924, 463478, 478184, 480439, 439693, 495734, 495406, 520473, 525043, 418427, 476399, 478473, 531215, 531165, 527387, 533512, 534028, 494622, 506195, 530376, 460282, 559453, 566736, 704248, 710524, 721846, 582217, 603009, 637121, 637034, 637044, 599826, 600503, 800588, 634118, 395648, 437811, 434275, 497311, 449784, 471612, 534229, 535259, 512539, 526906, 473739, 649525, 633718, 603536, 627144, 628117, 727812, 424360, 466979, 500477, 498036, 659419, 565245, 599922, 609729, 483802, 561853, 574546, 667736, 650313, 625437, 600360, 609275, 460212, 494617, 424837, 515568, 517246, 600011, 523924);

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
  395648
  402232
  418427
  420206
  424360
  424837
  428993
  434275
  437811
  439693
  442973
  449784
  454924
  460212
  460282
  463478
  466979
  471612
  473739
  474621
  476399
  478184
  478473
  480439
  483802
  494617
  494622
  495406
  495734
  497311
  498036
  500477
  506195
  512539
  515568
  517246
  520473
  523924
  525043
  526906
  527387
  530376
  531165
  531215
  533512
  534028
  534229
  535259
  559453
  561853
  565245
  566736
  574546
  582217
  599826
  599922
  600011
  600360
  600503
  603009
  603536
  603693
  606578
  609275
  609729
  625437
  627144
  628117
  633718
  634118
  637034
  637044
  637121
  640763
  649525
  650313
  659419
  667736
  704248
  710524
  721846
  727812
  800588
]

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 (395648, 402232, 418427, 420206, 424360, 424837, 428993, 434275, 437811, 439693, 442973, 449784, 454924, 460212, 460282, 463478, 466979, 471612, 473739, 474621, 476399, 478184, 478473, 480439, 483802, 494617, 494622, 495406, 495734, 497311, 498036, 500477, 506195, 512539, 515568, 517246, 520473, 523924, 525043, 526906, 527387, 530376, 531165, 531215, 533512, 534028, 534229, 535259, 559453, 561853, 565245, 566736, 574546, 582217, 599826, 599922, 600011, 600360, 600503, 603009, 603536, 603693, 606578, 609275, 609729, 625437, 627144, 628117, 633718, 634118, 637034, 637044, 637121, 640763, 649525, 650313, 659419, 667736, 704248, 710524, 721846, 727812, 800588);

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
  395648
  402232
  418427
  420206
  424360
  424837
  428993
  434275
  437811
  439693
  442973
  449784
  454924
  460212
  460282
  463478
  466979
  471612
  473739
  474621
  476399
  478184
  478473
  480439
  483802
  494617
  494622
  495406
  495734
  497311
  498036
  500477
  506195
  512539
  515568
  517246
  520473
  523924
  525043
  526906
  527387
  530376
  531165
  531215
  533512
  534028
  534229
  535259
  559453
  561853
  565245
  566736
  574546
  582217
  599826
  599922
  600011
  600360
  600503
  603009
  603536
  603693
  606578
  609275
  609729
  625437
  627144
  628117
  633718
  634118
  637034
  637044
  637121
  640763
  649525
  650313
  659419
  667736
  704248
  710524
  721846
  727812
  800588
]

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 (395648, 402232, 418427, 420206, 424360, 424837, 428993, 434275, 437811, 439693, 442973, 449784, 454924, 460212, 460282, 463478, 466979, 471612, 473739, 474621, 476399, 478184, 478473, 480439, 483802, 494617, 494622, 495406, 495734, 497311, 498036, 500477, 506195, 512539, 515568, 517246, 520473, 523924, 525043, 526906, 527387, 530376, 531165, 531215, 533512, 534028, 534229, 535259, 559453, 561853, 565245, 566736, 574546, 582217, 599826, 599922, 600011, 600360, 600503, 603009, 603536, 603693, 606578, 609275, 609729, 625437, 627144, 628117, 633718, 634118, 637034, 637044, 637121, 640763, 649525, 650313, 659419, 667736, 704248, 710524, 721846, 727812, 800588);

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

[
  "pussy first"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'pussy first';

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

[
  "pussy first"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'pussy first';