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

[
  "beauty blowjob chinese"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'beauty blowjob chinese' 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
  616114
  591278
  638276
  642442
  672261
  574467
  431664
  510183
  592734
  393129
  423132
  422747
  420027
  428358
  491512
  422769
  420067
  552899
  529436
  397128
  523916
  394376
  458094
  781488
  595252
  528066
  457761
  586635
  802111
  460051
  521048
  418648
  568034
  586639
  779560
  424726
  813787
  813803
  534815
  557211
  676241
  803268
  482824
  801890
  815137
  418323
  649559
  785525
  778383
  682936
  757362
  554425
  695725
  752596
  665781
  510266
  815096
  425786
  437828
  531083
  677712
  609121
  756113
  614603
  459524
  457981
  541849
  558201
  562149
  541863
  623261
]

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 (616114, 591278, 638276, 642442, 672261, 574467, 431664, 510183, 592734, 393129, 423132, 422747, 420027, 428358, 491512, 422769, 420067, 552899, 529436, 397128, 523916, 394376, 458094, 781488, 595252, 528066, 457761, 586635, 802111, 460051, 521048, 418648, 568034, 586639, 779560, 424726, 813787, 813803, 534815, 557211, 676241, 803268, 482824, 801890, 815137, 418323, 649559, 785525, 778383, 682936, 757362, 554425, 695725, 752596, 665781, 510266, 815096, 425786, 437828, 531083, 677712, 609121, 756113, 614603, 459524, 457981, 541849, 558201, 562149, 541863, 623261);

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
  393129
  394376
  397128
  418323
  418648
  420027
  420067
  422747
  422769
  423132
  424726
  425786
  428358
  431664
  437828
  457761
  457981
  458094
  459524
  460051
  482824
  491512
  510183
  510266
  521048
  523916
  528066
  529436
  531083
  534815
  541849
  541863
  552899
  554425
  557211
  558201
  562149
  568034
  574467
  586635
  586639
  591278
  592734
  595252
  609121
  614603
  616114
  623261
  638276
  642442
  649559
  665781
  672261
  676241
  677712
  682936
  695725
  752596
  756113
  757362
  778383
  779560
  781488
  785525
  801890
  802111
  803268
  813787
  813803
  815096
  815137
]

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 (393129, 394376, 397128, 418323, 418648, 420027, 420067, 422747, 422769, 423132, 424726, 425786, 428358, 431664, 437828, 457761, 457981, 458094, 459524, 460051, 482824, 491512, 510183, 510266, 521048, 523916, 528066, 529436, 531083, 534815, 541849, 541863, 552899, 554425, 557211, 558201, 562149, 568034, 574467, 586635, 586639, 591278, 592734, 595252, 609121, 614603, 616114, 623261, 638276, 642442, 649559, 665781, 672261, 676241, 677712, 682936, 695725, 752596, 756113, 757362, 778383, 779560, 781488, 785525, 801890, 802111, 803268, 813787, 813803, 815096, 815137);

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
  393129
  394376
  397128
  418323
  418648
  420027
  420067
  422747
  422769
  423132
  424726
  425786
  428358
  431664
  437828
  457761
  457981
  458094
  459524
  460051
  482824
  491512
  510183
  510266
  521048
  523916
  528066
  529436
  531083
  534815
  541849
  541863
  552899
  554425
  557211
  558201
  562149
  568034
  574467
  586635
  586639
  591278
  592734
  595252
  609121
  614603
  616114
  623261
  638276
  642442
  649559
  665781
  672261
  676241
  677712
  682936
  695725
  752596
  756113
  757362
  778383
  779560
  781488
  785525
  801890
  802111
  803268
  813787
  813803
  815096
  815137
]

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 (393129, 394376, 397128, 418323, 418648, 420027, 420067, 422747, 422769, 423132, 424726, 425786, 428358, 431664, 437828, 457761, 457981, 458094, 459524, 460051, 482824, 491512, 510183, 510266, 521048, 523916, 528066, 529436, 531083, 534815, 541849, 541863, 552899, 554425, 557211, 558201, 562149, 568034, 574467, 586635, 586639, 591278, 592734, 595252, 609121, 614603, 616114, 623261, 638276, 642442, 649559, 665781, 672261, 676241, 677712, 682936, 695725, 752596, 756113, 757362, 778383, 779560, 781488, 785525, 801890, 802111, 803268, 813787, 813803, 815096, 815137);

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

[
  "beauty минет оральн секс китаянк азиатк"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'beauty минет оральн секс китаянк азиатк';

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

[
  "beauty минет оральн секс китаянк азиатк"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'beauty минет оральн секс китаянк азиатк';

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 ?

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