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

[
  "sluts anal"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'sluts anal' 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
  473172
  532772
  576689
  804464
  415112
  681014
  423424
  825812
  533538
  536610
  532264
  674978
  629298
  617418
  717318
  475971
  446738
  531259
  427530
  492364
  545803
  577349
  577371
  688369
  511812
  644925
  451867
  530503
  534968
  531235
  563536
  676112
  676623
  599912
  634778
  621722
  556785
  544838
  650198
  584059
  625342
  433319
  518490
  448840
  677784
  473871
  415109
  540339
  535026
  537199
  678126
  676026
  457793
  433229
  577350
  614747
  464887
  530061
  639739
  676638
  470064
  531065
  675017
  433260
  679019
  681104
  583550
  528361
  590866
  617423
  510757
  496086
  642746
]

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 (473172, 532772, 576689, 804464, 415112, 681014, 423424, 825812, 533538, 536610, 532264, 674978, 629298, 617418, 717318, 475971, 446738, 531259, 427530, 492364, 545803, 577349, 577371, 688369, 511812, 644925, 451867, 530503, 534968, 531235, 563536, 676112, 676623, 599912, 634778, 621722, 556785, 544838, 650198, 584059, 625342, 433319, 518490, 448840, 677784, 473871, 415109, 540339, 535026, 537199, 678126, 676026, 457793, 433229, 577350, 614747, 464887, 530061, 639739, 676638, 470064, 531065, 675017, 433260, 679019, 681104, 583550, 528361, 590866, 617423, 510757, 496086, 642746);

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
  415109
  415112
  423424
  427530
  433229
  433260
  433319
  446738
  448840
  451867
  457793
  464887
  470064
  473172
  473871
  475971
  492364
  496086
  510757
  511812
  518490
  528361
  530061
  530503
  531065
  531235
  531259
  532264
  532772
  533538
  534968
  535026
  536610
  537199
  540339
  544838
  545803
  556785
  563536
  576689
  577349
  577350
  577371
  583550
  584059
  590866
  599912
  614747
  617418
  617423
  621722
  625342
  629298
  634778
  639739
  642746
  644925
  650198
  674978
  675017
  676026
  676112
  676623
  676638
  677784
  678126
  679019
  681014
  681104
  688369
  717318
  804464
  825812
]

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 (415109, 415112, 423424, 427530, 433229, 433260, 433319, 446738, 448840, 451867, 457793, 464887, 470064, 473172, 473871, 475971, 492364, 496086, 510757, 511812, 518490, 528361, 530061, 530503, 531065, 531235, 531259, 532264, 532772, 533538, 534968, 535026, 536610, 537199, 540339, 544838, 545803, 556785, 563536, 576689, 577349, 577350, 577371, 583550, 584059, 590866, 599912, 614747, 617418, 617423, 621722, 625342, 629298, 634778, 639739, 642746, 644925, 650198, 674978, 675017, 676026, 676112, 676623, 676638, 677784, 678126, 679019, 681014, 681104, 688369, 717318, 804464, 825812);

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
  415109
  415112
  423424
  427530
  433229
  433260
  433319
  446738
  448840
  451867
  457793
  464887
  470064
  473172
  473871
  475971
  492364
  496086
  510757
  511812
  518490
  528361
  530061
  530503
  531065
  531235
  531259
  532264
  532772
  533538
  534968
  535026
  536610
  537199
  540339
  544838
  545803
  556785
  563536
  576689
  577349
  577350
  577371
  583550
  584059
  590866
  599912
  614747
  617418
  617423
  621722
  625342
  629298
  634778
  639739
  642746
  644925
  650198
  674978
  675017
  676026
  676112
  676623
  676638
  677784
  678126
  679019
  681014
  681104
  688369
  717318
  804464
  825812
]

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 (415109, 415112, 423424, 427530, 433229, 433260, 433319, 446738, 448840, 451867, 457793, 464887, 470064, 473172, 473871, 475971, 492364, 496086, 510757, 511812, 518490, 528361, 530061, 530503, 531065, 531235, 531259, 532264, 532772, 533538, 534968, 535026, 536610, 537199, 540339, 544838, 545803, 556785, 563536, 576689, 577349, 577350, 577371, 583550, 584059, 590866, 599912, 614747, 617418, 617423, 621722, 625342, 629298, 634778, 639739, 642746, 644925, 650198, 674978, 675017, 676026, 676112, 676623, 676638, 677784, 678126, 679019, 681014, 681104, 688369, 717318, 804464, 825812);

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

[
  "sluts анал"
]

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

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

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

[
  "sluts анал"
]

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

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

SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST (?) AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST (?)
              AND `query` <> ?
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT ?

[
  "sluts anal"
  "sluts anal"
  "sluts anal"
  20
]

SELECT
  `query_id`,
  `cover`,
  `query`,
  MATCH (`query`) AGAINST (?) AS `relevance`
FROM
  `search_log`
WHERE
  MATCH (`query`) AGAINST (?)
  AND `query` <> ?
  AND `blocked` = 0
ORDER BY
  `relevance` DESC
LIMIT
  ?

SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST ('sluts anal') AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST ('sluts anal')
              AND `query` <> 'sluts anal'
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT 20
        ;