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 hardcore squirting"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'teen hardcore squirting' 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
  411212
  720756
  693502
  545224
  682986
  418035
  715790
  414253
  818475
  725630
  545465
  797006
  510402
  416691
  622509
  634157
  421152
  540269
  413432
  534386
  415303
  410690
  415294
  493696
  523205
  801655
  420295
  547496
  613860
  806591
  413833
  497667
  731692
  421520
  719333
  425820
  462379
  527428
  588071
  604061
  628398
  530269
  437864
  504488
  429278
  720281
  799768
  591680
  633734
  533944
  599990
  531908
  443333
  741310
  556505
  666525
  602614
  619175
  675008
  426220
  516889
  575445
  528361
  556741
  475304
  614029
  653452
  453368
  437810
  448821
  532834
  598844
]

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 (411212, 720756, 693502, 545224, 682986, 418035, 715790, 414253, 818475, 725630, 545465, 797006, 510402, 416691, 622509, 634157, 421152, 540269, 413432, 534386, 415303, 410690, 415294, 493696, 523205, 801655, 420295, 547496, 613860, 806591, 413833, 497667, 731692, 421520, 719333, 425820, 462379, 527428, 588071, 604061, 628398, 530269, 437864, 504488, 429278, 720281, 799768, 591680, 633734, 533944, 599990, 531908, 443333, 741310, 556505, 666525, 602614, 619175, 675008, 426220, 516889, 575445, 528361, 556741, 475304, 614029, 653452, 453368, 437810, 448821, 532834, 598844);

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
  410690
  411212
  413432
  413833
  414253
  415294
  415303
  416691
  418035
  420295
  421152
  421520
  425820
  426220
  429278
  437810
  437864
  443333
  448821
  453368
  462379
  475304
  493696
  497667
  504488
  510402
  516889
  523205
  527428
  528361
  530269
  531908
  532834
  533944
  534386
  540269
  545224
  545465
  547496
  556505
  556741
  575445
  588071
  591680
  598844
  599990
  602614
  604061
  613860
  614029
  619175
  622509
  628398
  633734
  634157
  653452
  666525
  675008
  682986
  693502
  715790
  719333
  720281
  720756
  725630
  731692
  741310
  797006
  799768
  801655
  806591
  818475
]

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 (410690, 411212, 413432, 413833, 414253, 415294, 415303, 416691, 418035, 420295, 421152, 421520, 425820, 426220, 429278, 437810, 437864, 443333, 448821, 453368, 462379, 475304, 493696, 497667, 504488, 510402, 516889, 523205, 527428, 528361, 530269, 531908, 532834, 533944, 534386, 540269, 545224, 545465, 547496, 556505, 556741, 575445, 588071, 591680, 598844, 599990, 602614, 604061, 613860, 614029, 619175, 622509, 628398, 633734, 634157, 653452, 666525, 675008, 682986, 693502, 715790, 719333, 720281, 720756, 725630, 731692, 741310, 797006, 799768, 801655, 806591, 818475);

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
  410690
  411212
  413432
  413833
  414253
  415294
  415303
  416691
  418035
  420295
  421152
  421520
  425820
  426220
  429278
  437810
  437864
  443333
  448821
  453368
  462379
  475304
  493696
  497667
  504488
  510402
  516889
  523205
  527428
  528361
  530269
  531908
  532834
  533944
  534386
  540269
  545224
  545465
  547496
  556505
  556741
  575445
  588071
  591680
  598844
  599990
  602614
  604061
  613860
  614029
  619175
  622509
  628398
  633734
  634157
  653452
  666525
  675008
  682986
  693502
  715790
  719333
  720281
  720756
  725630
  731692
  741310
  797006
  799768
  801655
  806591
  818475
]

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 (410690, 411212, 413432, 413833, 414253, 415294, 415303, 416691, 418035, 420295, 421152, 421520, 425820, 426220, 429278, 437810, 437864, 443333, 448821, 453368, 462379, 475304, 493696, 497667, 504488, 510402, 516889, 523205, 527428, 528361, 530269, 531908, 532834, 533944, 534386, 540269, 545224, 545465, 547496, 556505, 556741, 575445, 588071, 591680, 598844, 599990, 602614, 604061, 613860, 614029, 619175, 622509, 628398, 633734, 634157, 653452, 666525, 675008, 682986, 693502, 715790, 719333, 720281, 720756, 725630, 731692, 741310, 797006, 799768, 801655, 806591, 818475);

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

[
  "teen хардкор squirting"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'teen хардкор squirting';

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

[
  "teen хардкор squirting"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'teen хардкор squirting';

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