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

[
  "riding dick cowgirl"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'riding dick cowgirl' 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
  762575
  727923
  728720
  449998
  440779
  465708
  507287
  509917
  530049
  505526
  507283
  496747
  516537
  522188
  664223
  467065
  478238
  446206
  468829
  563757
  594554
  595097
  450829
  495002
  524297
  457559
  603786
  527382
  428115
  440954
  564832
  605702
  623412
  447722
  449556
  510975
  564859
  560792
  581232
  567525
  594460
  524042
  472544
  551125
  577439
  521091
  525332
  528157
  525398
  510413
  571762
  576970
  476634
  462537
  450025
  495706
  512733
  461159
  762217
  441697
  585400
  459077
  572328
  616778
  439372
  599370
  589086
  528040
  577658
  601430
  504693
  584422
]

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 (762575, 727923, 728720, 449998, 440779, 465708, 507287, 509917, 530049, 505526, 507283, 496747, 516537, 522188, 664223, 467065, 478238, 446206, 468829, 563757, 594554, 595097, 450829, 495002, 524297, 457559, 603786, 527382, 428115, 440954, 564832, 605702, 623412, 447722, 449556, 510975, 564859, 560792, 581232, 567525, 594460, 524042, 472544, 551125, 577439, 521091, 525332, 528157, 525398, 510413, 571762, 576970, 476634, 462537, 450025, 495706, 512733, 461159, 762217, 441697, 585400, 459077, 572328, 616778, 439372, 599370, 589086, 528040, 577658, 601430, 504693, 584422);

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
  428115
  439372
  440779
  440954
  441697
  446206
  447722
  449556
  449998
  450025
  450829
  457559
  459077
  461159
  462537
  465708
  467065
  468829
  472544
  476634
  478238
  495002
  495706
  496747
  504693
  505526
  507283
  507287
  509917
  510413
  510975
  512733
  516537
  521091
  522188
  524042
  524297
  525332
  525398
  527382
  528040
  528157
  530049
  551125
  560792
  563757
  564832
  564859
  567525
  571762
  572328
  576970
  577439
  577658
  581232
  584422
  585400
  589086
  594460
  594554
  595097
  599370
  601430
  603786
  605702
  616778
  623412
  664223
  727923
  728720
  762217
  762575
]

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 (428115, 439372, 440779, 440954, 441697, 446206, 447722, 449556, 449998, 450025, 450829, 457559, 459077, 461159, 462537, 465708, 467065, 468829, 472544, 476634, 478238, 495002, 495706, 496747, 504693, 505526, 507283, 507287, 509917, 510413, 510975, 512733, 516537, 521091, 522188, 524042, 524297, 525332, 525398, 527382, 528040, 528157, 530049, 551125, 560792, 563757, 564832, 564859, 567525, 571762, 572328, 576970, 577439, 577658, 581232, 584422, 585400, 589086, 594460, 594554, 595097, 599370, 601430, 603786, 605702, 616778, 623412, 664223, 727923, 728720, 762217, 762575);

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
  428115
  439372
  440779
  440954
  441697
  446206
  447722
  449556
  449998
  450025
  450829
  457559
  459077
  461159
  462537
  465708
  467065
  468829
  472544
  476634
  478238
  495002
  495706
  496747
  504693
  505526
  507283
  507287
  509917
  510413
  510975
  512733
  516537
  521091
  522188
  524042
  524297
  525332
  525398
  527382
  528040
  528157
  530049
  551125
  560792
  563757
  564832
  564859
  567525
  571762
  572328
  576970
  577439
  577658
  581232
  584422
  585400
  589086
  594460
  594554
  595097
  599370
  601430
  603786
  605702
  616778
  623412
  664223
  727923
  728720
  762217
  762575
]

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 (428115, 439372, 440779, 440954, 441697, 446206, 447722, 449556, 449998, 450025, 450829, 457559, 459077, 461159, 462537, 465708, 467065, 468829, 472544, 476634, 478238, 495002, 495706, 496747, 504693, 505526, 507283, 507287, 509917, 510413, 510975, 512733, 516537, 521091, 522188, 524042, 524297, 525332, 525398, 527382, 528040, 528157, 530049, 551125, 560792, 563757, 564832, 564859, 567525, 571762, 572328, 576970, 577439, 577658, 581232, 584422, 585400, 589086, 594460, 594554, 595097, 599370, 601430, 603786, 605702, 616778, 623412, 664223, 727923, 728720, 762217, 762575);

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

[
  "riding член cowgirl"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'riding член cowgirl';

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

[
  "riding член cowgirl"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'riding член cowgirl';