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

[
  "sex sperma"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'sex sperma' 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
  477605
  337226
  791049
  630306
  756023
  753250
  783701
  717992
  259942
  261058
  408178
  825216
  746056
  555342
  555464
  798773
  816707
  260036
  474243
  705159
  627860
  717718
  548523
  430456
  424490
  606253
  470345
  555250
  629530
  386367
  391045
  555324
  555223
  555213
  467909
  260158
  513663
  555765
  606077
  619623
  480275
  260962
  714658
  796509
  540115
  383408
  555758
  619629
  456814
  495244
  555393
  555209
  555360
  555358
  546043
  555329
  555727
  553271
  518757
  606208
  461287
  644982
  457077
  555325
  542786
  502144
  465153
  510813
  631468
  564863
  463105
  544800
]

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 (477605, 337226, 791049, 630306, 756023, 753250, 783701, 717992, 259942, 261058, 408178, 825216, 746056, 555342, 555464, 798773, 816707, 260036, 474243, 705159, 627860, 717718, 548523, 430456, 424490, 606253, 470345, 555250, 629530, 386367, 391045, 555324, 555223, 555213, 467909, 260158, 513663, 555765, 606077, 619623, 480275, 260962, 714658, 796509, 540115, 383408, 555758, 619629, 456814, 495244, 555393, 555209, 555360, 555358, 546043, 555329, 555727, 553271, 518757, 606208, 461287, 644982, 457077, 555325, 542786, 502144, 465153, 510813, 631468, 564863, 463105, 544800);

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
  259942
  260036
  260158
  260962
  261058
  337226
  383408
  386367
  391045
  408178
  424490
  430456
  456814
  457077
  461287
  463105
  465153
  467909
  470345
  474243
  477605
  480275
  495244
  502144
  510813
  513663
  518757
  540115
  542786
  544800
  546043
  548523
  553271
  555209
  555213
  555223
  555250
  555324
  555325
  555329
  555342
  555358
  555360
  555393
  555464
  555727
  555758
  555765
  564863
  606077
  606208
  606253
  619623
  619629
  627860
  630306
  631468
  644982
  705159
  714658
  717718
  717992
  746056
  753250
  756023
  783701
  791049
  796509
  798773
  816707
  825216
]

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 (259942, 260036, 260158, 260962, 261058, 337226, 383408, 386367, 391045, 408178, 424490, 430456, 456814, 457077, 461287, 463105, 465153, 467909, 470345, 474243, 477605, 480275, 495244, 502144, 510813, 513663, 518757, 540115, 542786, 544800, 546043, 548523, 553271, 555209, 555213, 555223, 555250, 555324, 555325, 555329, 555342, 555358, 555360, 555393, 555464, 555727, 555758, 555765, 564863, 606077, 606208, 606253, 619623, 619629, 627860, 630306, 631468, 644982, 705159, 714658, 717718, 717992, 746056, 753250, 756023, 783701, 791049, 796509, 798773, 816707, 825216);

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
  259942
  260036
  260158
  260962
  261058
  337226
  383408
  386367
  391045
  408178
  424490
  430456
  456814
  457077
  461287
  463105
  465153
  467909
  470345
  474243
  477605
  480275
  495244
  502144
  510813
  513663
  518757
  540115
  542786
  544800
  546043
  548523
  553271
  555209
  555213
  555223
  555250
  555324
  555325
  555329
  555342
  555358
  555360
  555393
  555464
  555727
  555758
  555765
  564863
  606077
  606208
  606253
  619623
  619629
  627860
  630306
  631468
  644982
  705159
  714658
  717718
  717992
  746056
  753250
  756023
  783701
  791049
  796509
  798773
  816707
  825216
]

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 (259942, 260036, 260158, 260962, 261058, 337226, 383408, 386367, 391045, 408178, 424490, 430456, 456814, 457077, 461287, 463105, 465153, 467909, 470345, 474243, 477605, 480275, 495244, 502144, 510813, 513663, 518757, 540115, 542786, 544800, 546043, 548523, 553271, 555209, 555213, 555223, 555250, 555324, 555325, 555329, 555342, 555358, 555360, 555393, 555464, 555727, 555758, 555765, 564863, 606077, 606208, 606253, 619623, 619629, 627860, 630306, 631468, 644982, 705159, 714658, 717718, 717992, 746056, 753250, 756023, 783701, 791049, 796509, 798773, 816707, 825216);

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

[
  "секс sperma"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'секс sperma';

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

[
  "секс sperma"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'секс sperma';

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 ?

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