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

[
  "ass lick worship"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'ass lick worship' 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
  551912
  548879
  614942
  662909
  593360
  742333
  532718
  517018
  460969
  812116
  803149
  782769
  6997
  424870
  532464
  482590
  732212
  736266
  616400
  413612
  12880
  427142
  650489
  541509
  448043
  482573
  426413
  578002
  604657
  747566
  770607
  472216
  533264
  733271
  521221
  470364
  343369
  727571
  732236
  621519
  539086
  521233
  419840
  430361
  446090
  556450
  738022
  516975
  446783
  586026
  576519
  464209
  450286
  827299
  589673
  540095
  417084
  426734
  439492
  548876
  521201
  592244
  12887
  446509
  444280
  420106
  576514
  651660
  761463
  523169
  597134
  494233
]

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 (551912, 548879, 614942, 662909, 593360, 742333, 532718, 517018, 460969, 812116, 803149, 782769, 6997, 424870, 532464, 482590, 732212, 736266, 616400, 413612, 12880, 427142, 650489, 541509, 448043, 482573, 426413, 578002, 604657, 747566, 770607, 472216, 533264, 733271, 521221, 470364, 343369, 727571, 732236, 621519, 539086, 521233, 419840, 430361, 446090, 556450, 738022, 516975, 446783, 586026, 576519, 464209, 450286, 827299, 589673, 540095, 417084, 426734, 439492, 548876, 521201, 592244, 12887, 446509, 444280, 420106, 576514, 651660, 761463, 523169, 597134, 494233);

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
  6997
  12880
  12887
  343369
  413612
  417084
  419840
  420106
  424870
  426413
  426734
  427142
  430361
  439492
  444280
  446090
  446509
  446783
  448043
  450286
  460969
  464209
  470364
  472216
  482573
  482590
  494233
  516975
  517018
  521201
  521221
  521233
  523169
  532464
  532718
  533264
  539086
  540095
  541509
  548876
  548879
  551912
  556450
  576514
  576519
  578002
  586026
  589673
  592244
  593360
  597134
  604657
  614942
  616400
  621519
  650489
  651660
  662909
  727571
  732212
  732236
  733271
  736266
  738022
  742333
  747566
  761463
  770607
  782769
  803149
  812116
  827299
]

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 (6997, 12880, 12887, 343369, 413612, 417084, 419840, 420106, 424870, 426413, 426734, 427142, 430361, 439492, 444280, 446090, 446509, 446783, 448043, 450286, 460969, 464209, 470364, 472216, 482573, 482590, 494233, 516975, 517018, 521201, 521221, 521233, 523169, 532464, 532718, 533264, 539086, 540095, 541509, 548876, 548879, 551912, 556450, 576514, 576519, 578002, 586026, 589673, 592244, 593360, 597134, 604657, 614942, 616400, 621519, 650489, 651660, 662909, 727571, 732212, 732236, 733271, 736266, 738022, 742333, 747566, 761463, 770607, 782769, 803149, 812116, 827299);

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
  6997
  12880
  12887
  343369
  413612
  417084
  419840
  420106
  424870
  426413
  426734
  427142
  430361
  439492
  444280
  446090
  446509
  446783
  448043
  450286
  460969
  464209
  470364
  472216
  482573
  482590
  494233
  516975
  517018
  521201
  521221
  521233
  523169
  532464
  532718
  533264
  539086
  540095
  541509
  548876
  548879
  551912
  556450
  576514
  576519
  578002
  586026
  589673
  592244
  593360
  597134
  604657
  614942
  616400
  621519
  650489
  651660
  662909
  727571
  732212
  732236
  733271
  736266
  738022
  742333
  747566
  761463
  770607
  782769
  803149
  812116
  827299
]

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 (6997, 12880, 12887, 343369, 413612, 417084, 419840, 420106, 424870, 426413, 426734, 427142, 430361, 439492, 444280, 446090, 446509, 446783, 448043, 450286, 460969, 464209, 470364, 472216, 482573, 482590, 494233, 516975, 517018, 521201, 521221, 521233, 523169, 532464, 532718, 533264, 539086, 540095, 541509, 548876, 548879, 551912, 556450, 576514, 576519, 578002, 586026, 589673, 592244, 593360, 597134, 604657, 614942, 616400, 621519, 650489, 651660, 662909, 727571, 732212, 732236, 733271, 736266, 738022, 742333, 747566, 761463, 770607, 782769, 803149, 812116, 827299);

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

[
  "жоп лиза worship"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'жоп лиза worship';

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

[
  "жоп лиза worship"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'жоп лиза worship';

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 ?

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