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

[
  "teen love anal"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'teen love anal' LIMIT 1;

SELECT 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1

[
  b"\x01ö®─æ░s\x02îü╣"\v\x03ü."
]

SELECT
  1
FROM
  `trend_has_post`
WHERE
  `trend_id` = ?
LIMIT
  1

SELECT 1 FROM `trend_has_post` WHERE `trend_id` = 0x0194A9C491B073028C81B9220B03812E 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
  466178
  393531
  392333
  481148
  469007
  446514
  477242
  574629
  560608
  373884
  444215
  440649
  502817
  581850
  395973
  423039
  429479
  595900
  605371
  740920
  473167
  431038
  512129
  525411
  484301
  564859
  419607
  600045
  433199
  441448
  481151
  572772
  397373
  445226
  498260
  810848
  502115
  624127
  424341
  472539
  491248
  467724
  560616
  543477
  429817
  474279
  406685
  500896
  497837
  510004
  432771
  814245
  478044
  500798
  457232
  512844
  624223
  757355
  411320
  460296
  639718
  628072
  395913
  597975
  599124
  440876
  814239
  601628
  462527
  395981
  453768
  602739
  519248
  545803
  421890
  561684
  814235
  457165
  658082
  495753
  572003
  565186
  598199
]

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 (466178, 393531, 392333, 481148, 469007, 446514, 477242, 574629, 560608, 373884, 444215, 440649, 502817, 581850, 395973, 423039, 429479, 595900, 605371, 740920, 473167, 431038, 512129, 525411, 484301, 564859, 419607, 600045, 433199, 441448, 481151, 572772, 397373, 445226, 498260, 810848, 502115, 624127, 424341, 472539, 491248, 467724, 560616, 543477, 429817, 474279, 406685, 500896, 497837, 510004, 432771, 814245, 478044, 500798, 457232, 512844, 624223, 757355, 411320, 460296, 639718, 628072, 395913, 597975, 599124, 440876, 814239, 601628, 462527, 395981, 453768, 602739, 519248, 545803, 421890, 561684, 814235, 457165, 658082, 495753, 572003, 565186, 598199);

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
  373884
  392333
  393531
  395913
  395973
  395981
  397373
  406685
  411320
  419607
  421890
  423039
  424341
  429479
  429817
  431038
  432771
  433199
  440649
  440876
  441448
  444215
  445226
  446514
  453768
  457165
  457232
  460296
  462527
  466178
  467724
  469007
  472539
  473167
  474279
  477242
  478044
  481148
  481151
  484301
  491248
  495753
  497837
  498260
  500798
  500896
  502115
  502817
  510004
  512129
  512844
  519248
  525411
  543477
  545803
  560608
  560616
  561684
  564859
  565186
  572003
  572772
  574629
  581850
  595900
  597975
  598199
  599124
  600045
  601628
  602739
  605371
  624127
  624223
  628072
  639718
  658082
  740920
  757355
  810848
  814235
  814239
  814245
]

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 (373884, 392333, 393531, 395913, 395973, 395981, 397373, 406685, 411320, 419607, 421890, 423039, 424341, 429479, 429817, 431038, 432771, 433199, 440649, 440876, 441448, 444215, 445226, 446514, 453768, 457165, 457232, 460296, 462527, 466178, 467724, 469007, 472539, 473167, 474279, 477242, 478044, 481148, 481151, 484301, 491248, 495753, 497837, 498260, 500798, 500896, 502115, 502817, 510004, 512129, 512844, 519248, 525411, 543477, 545803, 560608, 560616, 561684, 564859, 565186, 572003, 572772, 574629, 581850, 595900, 597975, 598199, 599124, 600045, 601628, 602739, 605371, 624127, 624223, 628072, 639718, 658082, 740920, 757355, 810848, 814235, 814239, 814245);

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
  373884
  392333
  393531
  395913
  395973
  395981
  397373
  406685
  411320
  419607
  421890
  423039
  424341
  429479
  429817
  431038
  432771
  433199
  440649
  440876
  441448
  444215
  445226
  446514
  453768
  457165
  457232
  460296
  462527
  466178
  467724
  469007
  472539
  473167
  474279
  477242
  478044
  481148
  481151
  484301
  491248
  495753
  497837
  498260
  500798
  500896
  502115
  502817
  510004
  512129
  512844
  519248
  525411
  543477
  545803
  560608
  560616
  561684
  564859
  565186
  572003
  572772
  574629
  581850
  595900
  597975
  598199
  599124
  600045
  601628
  602739
  605371
  624127
  624223
  628072
  639718
  658082
  740920
  757355
  810848
  814235
  814239
  814245
]

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 (373884, 392333, 393531, 395913, 395973, 395981, 397373, 406685, 411320, 419607, 421890, 423039, 424341, 429479, 429817, 431038, 432771, 433199, 440649, 440876, 441448, 444215, 445226, 446514, 453768, 457165, 457232, 460296, 462527, 466178, 467724, 469007, 472539, 473167, 474279, 477242, 478044, 481148, 481151, 484301, 491248, 495753, 497837, 498260, 500798, 500896, 502115, 502817, 510004, 512129, 512844, 519248, 525411, 543477, 545803, 560608, 560616, 561684, 564859, 565186, 572003, 572772, 574629, 581850, 595900, 597975, 598199, 599124, 600045, 601628, 602739, 605371, 624127, 624223, 628072, 639718, 658082, 740920, 757355, 810848, 814235, 814239, 814245);

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

[
  "teen love анал"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'teen love анал';

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

[
  "teen love анал"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'teen love анал';