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

[
  "mature dirty talk"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'mature dirty talk' 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
  823589
  804580
  796819
  555198
  90091
  824167
  791353
  827972
  742415
  804251
  555464
  806489
  823940
  800633
  504012
  606134
  593083
  768862
  471977
  810298
  819751
  827432
  802907
  742327
  506765
  803516
  513976
  825907
  819777
  526449
  552579
  552581
  590539
  803035
  791917
  517332
  531993
  460503
  683047
  555448
  574406
  595087
  796441
  730338
  451514
  517299
  796831
  506252
  458760
  492138
  554544
  471108
  527847
  526070
  543317
  585959
  798219
  746126
  602793
  477147
  577433
  813532
  423572
  508701
  591197
  537672
  525727
  536689
  590425
  600995
  589683
  510898
]

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 (823589, 804580, 796819, 555198, 90091, 824167, 791353, 827972, 742415, 804251, 555464, 806489, 823940, 800633, 504012, 606134, 593083, 768862, 471977, 810298, 819751, 827432, 802907, 742327, 506765, 803516, 513976, 825907, 819777, 526449, 552579, 552581, 590539, 803035, 791917, 517332, 531993, 460503, 683047, 555448, 574406, 595087, 796441, 730338, 451514, 517299, 796831, 506252, 458760, 492138, 554544, 471108, 527847, 526070, 543317, 585959, 798219, 746126, 602793, 477147, 577433, 813532, 423572, 508701, 591197, 537672, 525727, 536689, 590425, 600995, 589683, 510898);

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
  90091
  423572
  451514
  458760
  460503
  471108
  471977
  477147
  492138
  504012
  506252
  506765
  508701
  510898
  513976
  517299
  517332
  525727
  526070
  526449
  527847
  531993
  536689
  537672
  543317
  552579
  552581
  554544
  555198
  555448
  555464
  574406
  577433
  585959
  589683
  590425
  590539
  591197
  593083
  595087
  600995
  602793
  606134
  683047
  730338
  742327
  742415
  746126
  768862
  791353
  791917
  796441
  796819
  796831
  798219
  800633
  802907
  803035
  803516
  804251
  804580
  806489
  810298
  813532
  819751
  819777
  823589
  823940
  824167
  825907
  827432
  827972
]

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 (90091, 423572, 451514, 458760, 460503, 471108, 471977, 477147, 492138, 504012, 506252, 506765, 508701, 510898, 513976, 517299, 517332, 525727, 526070, 526449, 527847, 531993, 536689, 537672, 543317, 552579, 552581, 554544, 555198, 555448, 555464, 574406, 577433, 585959, 589683, 590425, 590539, 591197, 593083, 595087, 600995, 602793, 606134, 683047, 730338, 742327, 742415, 746126, 768862, 791353, 791917, 796441, 796819, 796831, 798219, 800633, 802907, 803035, 803516, 804251, 804580, 806489, 810298, 813532, 819751, 819777, 823589, 823940, 824167, 825907, 827432, 827972);

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
  90091
  423572
  451514
  458760
  460503
  471108
  471977
  477147
  492138
  504012
  506252
  506765
  508701
  510898
  513976
  517299
  517332
  525727
  526070
  526449
  527847
  531993
  536689
  537672
  543317
  552579
  552581
  554544
  555198
  555448
  555464
  574406
  577433
  585959
  589683
  590425
  590539
  591197
  593083
  595087
  600995
  602793
  606134
  683047
  730338
  742327
  742415
  746126
  768862
  791353
  791917
  796441
  796819
  796831
  798219
  800633
  802907
  803035
  803516
  804251
  804580
  806489
  810298
  813532
  819751
  819777
  823589
  823940
  824167
  825907
  827432
  827972
]

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 (90091, 423572, 451514, 458760, 460503, 471108, 471977, 477147, 492138, 504012, 506252, 506765, 508701, 510898, 513976, 517299, 517332, 525727, 526070, 526449, 527847, 531993, 536689, 537672, 543317, 552579, 552581, 554544, 555198, 555448, 555464, 574406, 577433, 585959, 589683, 590425, 590539, 591197, 593083, 595087, 600995, 602793, 606134, 683047, 730338, 742327, 742415, 746126, 768862, 791353, 791917, 796441, 796819, 796831, 798219, 800633, 802907, 803035, 803516, 804251, 804580, 806489, 810298, 813532, 819751, 819777, 823589, 823940, 824167, 825907, 827432, 827972);

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

[
  "mature dirty talk"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'mature dirty talk';

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

[
  "mature dirty talk"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'mature dirty talk';

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 ?

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