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

[
  "pussy lips big"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'pussy lips big' 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
  468326
  471012
  621457
  540107
  529972
  588613
  803838
  499909
  628515
  451273
  540014
  580366
  650518
  700718
  430014
  514960
  631697
  488782
  625169
  432985
  629457
  498474
  652886
  603612
  482497
  615910
  705528
  445980
  468577
  516490
  468589
  487441
  534663
  484503
  653523
  557113
  424288
  575477
  571026
  710221
  809361
  439249
  439236
  448450
  402146
  429708
  486648
  587986
  452326
  472706
  518008
  625165
  569826
  554418
  622777
  525727
  382245
  525729
  463795
  548837
  584602
  588620
  479560
  521910
  498459
  588022
  627089
  523033
  596904
  512927
  604364
  562790
]

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 (468326, 471012, 621457, 540107, 529972, 588613, 803838, 499909, 628515, 451273, 540014, 580366, 650518, 700718, 430014, 514960, 631697, 488782, 625169, 432985, 629457, 498474, 652886, 603612, 482497, 615910, 705528, 445980, 468577, 516490, 468589, 487441, 534663, 484503, 653523, 557113, 424288, 575477, 571026, 710221, 809361, 439249, 439236, 448450, 402146, 429708, 486648, 587986, 452326, 472706, 518008, 625165, 569826, 554418, 622777, 525727, 382245, 525729, 463795, 548837, 584602, 588620, 479560, 521910, 498459, 588022, 627089, 523033, 596904, 512927, 604364, 562790);

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
  382245
  402146
  424288
  429708
  430014
  432985
  439236
  439249
  445980
  448450
  451273
  452326
  463795
  468326
  468577
  468589
  471012
  472706
  479560
  482497
  484503
  486648
  487441
  488782
  498459
  498474
  499909
  512927
  514960
  516490
  518008
  521910
  523033
  525727
  525729
  529972
  534663
  540014
  540107
  548837
  554418
  557113
  562790
  569826
  571026
  575477
  580366
  584602
  587986
  588022
  588613
  588620
  596904
  603612
  604364
  615910
  621457
  622777
  625165
  625169
  627089
  628515
  629457
  631697
  650518
  652886
  653523
  700718
  705528
  710221
  803838
  809361
]

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 (382245, 402146, 424288, 429708, 430014, 432985, 439236, 439249, 445980, 448450, 451273, 452326, 463795, 468326, 468577, 468589, 471012, 472706, 479560, 482497, 484503, 486648, 487441, 488782, 498459, 498474, 499909, 512927, 514960, 516490, 518008, 521910, 523033, 525727, 525729, 529972, 534663, 540014, 540107, 548837, 554418, 557113, 562790, 569826, 571026, 575477, 580366, 584602, 587986, 588022, 588613, 588620, 596904, 603612, 604364, 615910, 621457, 622777, 625165, 625169, 627089, 628515, 629457, 631697, 650518, 652886, 653523, 700718, 705528, 710221, 803838, 809361);

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
  382245
  402146
  424288
  429708
  430014
  432985
  439236
  439249
  445980
  448450
  451273
  452326
  463795
  468326
  468577
  468589
  471012
  472706
  479560
  482497
  484503
  486648
  487441
  488782
  498459
  498474
  499909
  512927
  514960
  516490
  518008
  521910
  523033
  525727
  525729
  529972
  534663
  540014
  540107
  548837
  554418
  557113
  562790
  569826
  571026
  575477
  580366
  584602
  587986
  588022
  588613
  588620
  596904
  603612
  604364
  615910
  621457
  622777
  625165
  625169
  627089
  628515
  629457
  631697
  650518
  652886
  653523
  700718
  705528
  710221
  803838
  809361
]

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 (382245, 402146, 424288, 429708, 430014, 432985, 439236, 439249, 445980, 448450, 451273, 452326, 463795, 468326, 468577, 468589, 471012, 472706, 479560, 482497, 484503, 486648, 487441, 488782, 498459, 498474, 499909, 512927, 514960, 516490, 518008, 521910, 523033, 525727, 525729, 529972, 534663, 540014, 540107, 548837, 554418, 557113, 562790, 569826, 571026, 575477, 580366, 584602, 587986, 588022, 588613, 588620, 596904, 603612, 604364, 615910, 621457, 622777, 625165, 625169, 627089, 628515, 629457, 631697, 650518, 652886, 653523, 700718, 705528, 710221, 803838, 809361);

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

[
  "pussy lips большие"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'pussy lips большие';

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

[
  "pussy lips большие"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'pussy lips большие';

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 ?

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