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 ass cam"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'teen ass cam' 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
  30841
  652954
  677354
  529810
  669545
  582735
  544204
  720232
  454799
  598728
  412515
  575798
  568262
  580230
  509837
  428932
  434900
  483469
  527920
  417486
  453820
  530934
  598469
  552235
  597825
  428848
  453223
  550480
  615730
  529149
  420434
  423725
  476774
  468423
  446497
  480428
  388803
  406105
  430397
  595867
  727794
  756845
  423913
  513219
  453208
  302443
  426611
  475876
  475237
  392498
  574846
  559673
  583687
  429946
  430261
  521353
  512512
  429931
  416794
  482687
  552480
  548749
  452496
  571193
  474361
  470012
  460321
  429933
  405709
  491707
  507514
  446745
  603002
  584887
]

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 (30841, 652954, 677354, 529810, 669545, 582735, 544204, 720232, 454799, 598728, 412515, 575798, 568262, 580230, 509837, 428932, 434900, 483469, 527920, 417486, 453820, 530934, 598469, 552235, 597825, 428848, 453223, 550480, 615730, 529149, 420434, 423725, 476774, 468423, 446497, 480428, 388803, 406105, 430397, 595867, 727794, 756845, 423913, 513219, 453208, 302443, 426611, 475876, 475237, 392498, 574846, 559673, 583687, 429946, 430261, 521353, 512512, 429931, 416794, 482687, 552480, 548749, 452496, 571193, 474361, 470012, 460321, 429933, 405709, 491707, 507514, 446745, 603002, 584887);

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
  30841
  302443
  388803
  392498
  405709
  406105
  412515
  416794
  417486
  420434
  423725
  423913
  426611
  428848
  428932
  429931
  429933
  429946
  430261
  430397
  434900
  446497
  446745
  452496
  453208
  453223
  453820
  454799
  460321
  468423
  470012
  474361
  475237
  475876
  476774
  480428
  482687
  483469
  491707
  507514
  509837
  512512
  513219
  521353
  527920
  529149
  529810
  530934
  544204
  548749
  550480
  552235
  552480
  559673
  568262
  571193
  574846
  575798
  580230
  582735
  583687
  584887
  595867
  597825
  598469
  598728
  603002
  615730
  652954
  669545
  677354
  720232
  727794
  756845
]

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 (30841, 302443, 388803, 392498, 405709, 406105, 412515, 416794, 417486, 420434, 423725, 423913, 426611, 428848, 428932, 429931, 429933, 429946, 430261, 430397, 434900, 446497, 446745, 452496, 453208, 453223, 453820, 454799, 460321, 468423, 470012, 474361, 475237, 475876, 476774, 480428, 482687, 483469, 491707, 507514, 509837, 512512, 513219, 521353, 527920, 529149, 529810, 530934, 544204, 548749, 550480, 552235, 552480, 559673, 568262, 571193, 574846, 575798, 580230, 582735, 583687, 584887, 595867, 597825, 598469, 598728, 603002, 615730, 652954, 669545, 677354, 720232, 727794, 756845);

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
  30841
  302443
  388803
  392498
  405709
  406105
  412515
  416794
  417486
  420434
  423725
  423913
  426611
  428848
  428932
  429931
  429933
  429946
  430261
  430397
  434900
  446497
  446745
  452496
  453208
  453223
  453820
  454799
  460321
  468423
  470012
  474361
  475237
  475876
  476774
  480428
  482687
  483469
  491707
  507514
  509837
  512512
  513219
  521353
  527920
  529149
  529810
  530934
  544204
  548749
  550480
  552235
  552480
  559673
  568262
  571193
  574846
  575798
  580230
  582735
  583687
  584887
  595867
  597825
  598469
  598728
  603002
  615730
  652954
  669545
  677354
  720232
  727794
  756845
]

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 (30841, 302443, 388803, 392498, 405709, 406105, 412515, 416794, 417486, 420434, 423725, 423913, 426611, 428848, 428932, 429931, 429933, 429946, 430261, 430397, 434900, 446497, 446745, 452496, 453208, 453223, 453820, 454799, 460321, 468423, 470012, 474361, 475237, 475876, 476774, 480428, 482687, 483469, 491707, 507514, 509837, 512512, 513219, 521353, 527920, 529149, 529810, 530934, 544204, 548749, 550480, 552235, 552480, 559673, 568262, 571193, 574846, 575798, 580230, 582735, 583687, 584887, 595867, 597825, 598469, 598728, 603002, 615730, 652954, 669545, 677354, 720232, 727794, 756845);

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

[
  "teen жоп cam"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'teen жоп cam';

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

[
  "teen жоп cam"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'teen жоп cam';

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 ?

[
  "teen ass cam"
  "teen ass cam"
  "teen ass cam"
  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 ('teen ass cam') AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST ('teen ass cam')
              AND `query` <> 'teen ass cam'
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT 20
        ;