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

[
  "ebony huge tits"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'ebony huge tits' 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
  464162
  486182
  732380
  524868
  482388
  815429
  534257
  732782
  559951
  456955
  428116
  415128
  530304
  425512
  651130
  424862
  499856
  642331
  398113
  618965
  739054
  737189
  808265
  741026
  494121
  408695
  517652
  816235
  615895
  802458
  741441
  564743
  426294
  565143
  810408
  567139
  530777
  533802
  676636
  524867
  491299
  816547
  485154
  645230
  803317
  583714
  633466
  497439
  406935
  814883
  518975
  556525
  518179
  557243
  508425
  807023
  519392
  578395
  465070
  567140
  699397
  674988
  639824
  666525
  560219
  649514
  420291
  623962
  675012
  427174
  460208
  603376
]

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 (464162, 486182, 732380, 524868, 482388, 815429, 534257, 732782, 559951, 456955, 428116, 415128, 530304, 425512, 651130, 424862, 499856, 642331, 398113, 618965, 739054, 737189, 808265, 741026, 494121, 408695, 517652, 816235, 615895, 802458, 741441, 564743, 426294, 565143, 810408, 567139, 530777, 533802, 676636, 524867, 491299, 816547, 485154, 645230, 803317, 583714, 633466, 497439, 406935, 814883, 518975, 556525, 518179, 557243, 508425, 807023, 519392, 578395, 465070, 567140, 699397, 674988, 639824, 666525, 560219, 649514, 420291, 623962, 675012, 427174, 460208, 603376);

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
  398113
  406935
  408695
  415128
  420291
  424862
  425512
  426294
  427174
  428116
  456955
  460208
  464162
  465070
  482388
  485154
  486182
  491299
  494121
  497439
  499856
  508425
  517652
  518179
  518975
  519392
  524867
  524868
  530304
  530777
  533802
  534257
  556525
  557243
  559951
  560219
  564743
  565143
  567139
  567140
  578395
  583714
  603376
  615895
  618965
  623962
  633466
  639824
  642331
  645230
  649514
  651130
  666525
  674988
  675012
  676636
  699397
  732380
  732782
  737189
  739054
  741026
  741441
  802458
  803317
  807023
  808265
  810408
  814883
  815429
  816235
  816547
]

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 (398113, 406935, 408695, 415128, 420291, 424862, 425512, 426294, 427174, 428116, 456955, 460208, 464162, 465070, 482388, 485154, 486182, 491299, 494121, 497439, 499856, 508425, 517652, 518179, 518975, 519392, 524867, 524868, 530304, 530777, 533802, 534257, 556525, 557243, 559951, 560219, 564743, 565143, 567139, 567140, 578395, 583714, 603376, 615895, 618965, 623962, 633466, 639824, 642331, 645230, 649514, 651130, 666525, 674988, 675012, 676636, 699397, 732380, 732782, 737189, 739054, 741026, 741441, 802458, 803317, 807023, 808265, 810408, 814883, 815429, 816235, 816547);

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
  398113
  406935
  408695
  415128
  420291
  424862
  425512
  426294
  427174
  428116
  456955
  460208
  464162
  465070
  482388
  485154
  486182
  491299
  494121
  497439
  499856
  508425
  517652
  518179
  518975
  519392
  524867
  524868
  530304
  530777
  533802
  534257
  556525
  557243
  559951
  560219
  564743
  565143
  567139
  567140
  578395
  583714
  603376
  615895
  618965
  623962
  633466
  639824
  642331
  645230
  649514
  651130
  666525
  674988
  675012
  676636
  699397
  732380
  732782
  737189
  739054
  741026
  741441
  802458
  803317
  807023
  808265
  810408
  814883
  815429
  816235
  816547
]

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 (398113, 406935, 408695, 415128, 420291, 424862, 425512, 426294, 427174, 428116, 456955, 460208, 464162, 465070, 482388, 485154, 486182, 491299, 494121, 497439, 499856, 508425, 517652, 518179, 518975, 519392, 524867, 524868, 530304, 530777, 533802, 534257, 556525, 557243, 559951, 560219, 564743, 565143, 567139, 567140, 578395, 583714, 603376, 615895, 618965, 623962, 633466, 639824, 642331, 645230, 649514, 651130, 666525, 674988, 675012, 676636, 699397, 732380, 732782, 737189, 739054, 741026, 741441, 802458, 803317, 807023, 808265, 810408, 814883, 815429, 816235, 816547);

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

[
  "чернокожая огромные сиськ"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'чернокожая огромные сиськ';

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

[
  "чернокожая огромные сиськ"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'чернокожая огромные сиськ';

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 ?

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