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

[
  "pee solo"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'pee solo' 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
  749129
  770039
  633182
  720446
  540132
  539287
  577019
  575326
  575026
  680778
  671780
  671782
  568293
  598048
  628747
  790124
  810076
  540139
  540159
  671991
  692714
  554684
  597763
  610199
  630254
  803700
  807834
  757569
  710471
  714737
  554714
  571708
  671791
  680937
  670266
  670402
  554717
  578148
  601684
  632991
  596244
  604660
  633206
  595605
  811876
  743512
  791916
  391586
  471006
  466384
  541741
  545940
  567498
  584379
  581182
  583084
  583355
  671785
  673941
  710221
  586218
  600636
  600428
  643656
  758797
  555055
  563939
  582666
  578642
  620395
  616349
  636624
  542724
  574398
]

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 (749129, 770039, 633182, 720446, 540132, 539287, 577019, 575326, 575026, 680778, 671780, 671782, 568293, 598048, 628747, 790124, 810076, 540139, 540159, 671991, 692714, 554684, 597763, 610199, 630254, 803700, 807834, 757569, 710471, 714737, 554714, 571708, 671791, 680937, 670266, 670402, 554717, 578148, 601684, 632991, 596244, 604660, 633206, 595605, 811876, 743512, 791916, 391586, 471006, 466384, 541741, 545940, 567498, 584379, 581182, 583084, 583355, 671785, 673941, 710221, 586218, 600636, 600428, 643656, 758797, 555055, 563939, 582666, 578642, 620395, 616349, 636624, 542724, 574398);

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
  391586
  466384
  471006
  539287
  540132
  540139
  540159
  541741
  542724
  545940
  554684
  554714
  554717
  555055
  563939
  567498
  568293
  571708
  574398
  575026
  575326
  577019
  578148
  578642
  581182
  582666
  583084
  583355
  584379
  586218
  595605
  596244
  597763
  598048
  600428
  600636
  601684
  604660
  610199
  616349
  620395
  628747
  630254
  632991
  633182
  633206
  636624
  643656
  670266
  670402
  671780
  671782
  671785
  671791
  671991
  673941
  680778
  680937
  692714
  710221
  710471
  714737
  720446
  743512
  749129
  757569
  758797
  770039
  790124
  791916
  803700
  807834
  810076
  811876
]

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 (391586, 466384, 471006, 539287, 540132, 540139, 540159, 541741, 542724, 545940, 554684, 554714, 554717, 555055, 563939, 567498, 568293, 571708, 574398, 575026, 575326, 577019, 578148, 578642, 581182, 582666, 583084, 583355, 584379, 586218, 595605, 596244, 597763, 598048, 600428, 600636, 601684, 604660, 610199, 616349, 620395, 628747, 630254, 632991, 633182, 633206, 636624, 643656, 670266, 670402, 671780, 671782, 671785, 671791, 671991, 673941, 680778, 680937, 692714, 710221, 710471, 714737, 720446, 743512, 749129, 757569, 758797, 770039, 790124, 791916, 803700, 807834, 810076, 811876);

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
  391586
  466384
  471006
  539287
  540132
  540139
  540159
  541741
  542724
  545940
  554684
  554714
  554717
  555055
  563939
  567498
  568293
  571708
  574398
  575026
  575326
  577019
  578148
  578642
  581182
  582666
  583084
  583355
  584379
  586218
  595605
  596244
  597763
  598048
  600428
  600636
  601684
  604660
  610199
  616349
  620395
  628747
  630254
  632991
  633182
  633206
  636624
  643656
  670266
  670402
  671780
  671782
  671785
  671791
  671991
  673941
  680778
  680937
  692714
  710221
  710471
  714737
  720446
  743512
  749129
  757569
  758797
  770039
  790124
  791916
  803700
  807834
  810076
  811876
]

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 (391586, 466384, 471006, 539287, 540132, 540139, 540159, 541741, 542724, 545940, 554684, 554714, 554717, 555055, 563939, 567498, 568293, 571708, 574398, 575026, 575326, 577019, 578148, 578642, 581182, 582666, 583084, 583355, 584379, 586218, 595605, 596244, 597763, 598048, 600428, 600636, 601684, 604660, 610199, 616349, 620395, 628747, 630254, 632991, 633182, 633206, 636624, 643656, 670266, 670402, 671780, 671782, 671785, 671791, 671991, 673941, 680778, 680937, 692714, 710221, 710471, 714737, 720446, 743512, 749129, 757569, 758797, 770039, 790124, 791916, 803700, 807834, 810076, 811876);

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

[
  "pee соло"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'pee соло';

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

[
  "pee соло"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'pee соло';

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 ?

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