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

[
  "dirty anal talk"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'dirty anal 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
  762981
  772661
  788210
  824167
  785855
  791353
  742415
  772635
  720029
  790133
  722532
  776289
  819751
  827432
  818551
  810298
  742327
  450683
  823940
  800633
  687844
  819777
  526449
  585017
  652760
  789856
  825907
  803035
  729231
  776926
  460503
  451514
  760951
  717849
  768739
  770387
  417334
  700932
  492138
  517332
  423580
  585959
  446562
  666816
  526070
  798219
  477147
  560969
  683054
  429909
  778119
  436942
  423572
  813532
  508701
  650174
  643112
  536689
  471108
  640759
  703364
  537672
  600995
  510898
  489061
  666819
  630221
  591197
  488957
  495400
]

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, 762981, 772661, 788210, 824167, 785855, 791353, 742415, 772635, 720029, 790133, 722532, 776289, 819751, 827432, 818551, 810298, 742327, 450683, 823940, 800633, 687844, 819777, 526449, 585017, 652760, 789856, 825907, 803035, 729231, 776926, 460503, 451514, 760951, 717849, 768739, 770387, 417334, 700932, 492138, 517332, 423580, 585959, 446562, 666816, 526070, 798219, 477147, 560969, 683054, 429909, 778119, 436942, 423572, 813532, 508701, 650174, 643112, 536689, 471108, 640759, 703364, 537672, 600995, 510898, 489061, 666819, 630221, 591197, 488957, 495400);

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
  417334
  423572
  423580
  429909
  436942
  446562
  450683
  451514
  460503
  471108
  477147
  488957
  489061
  492138
  495400
  508701
  510898
  517332
  526070
  526449
  536689
  537672
  560969
  585017
  585959
  591197
  600995
  630221
  640759
  643112
  650174
  652760
  666816
  666819
  683054
  687844
  700932
  703364
  717849
  720029
  722532
  729231
  742327
  742415
  760951
  762981
  768739
  770387
  772635
  772661
  776289
  776926
  778119
  785855
  788210
  789856
  790133
  791353
  798219
  800633
  803035
  810298
  813532
  818551
  819751
  819777
  823589
  823940
  824167
  825907
  827432
]

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 (417334, 423572, 423580, 429909, 436942, 446562, 450683, 451514, 460503, 471108, 477147, 488957, 489061, 492138, 495400, 508701, 510898, 517332, 526070, 526449, 536689, 537672, 560969, 585017, 585959, 591197, 600995, 630221, 640759, 643112, 650174, 652760, 666816, 666819, 683054, 687844, 700932, 703364, 717849, 720029, 722532, 729231, 742327, 742415, 760951, 762981, 768739, 770387, 772635, 772661, 776289, 776926, 778119, 785855, 788210, 789856, 790133, 791353, 798219, 800633, 803035, 810298, 813532, 818551, 819751, 819777, 823589, 823940, 824167, 825907, 827432);

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
  417334
  423572
  423580
  429909
  436942
  446562
  450683
  451514
  460503
  471108
  477147
  488957
  489061
  492138
  495400
  508701
  510898
  517332
  526070
  526449
  536689
  537672
  560969
  585017
  585959
  591197
  600995
  630221
  640759
  643112
  650174
  652760
  666816
  666819
  683054
  687844
  700932
  703364
  717849
  720029
  722532
  729231
  742327
  742415
  760951
  762981
  768739
  770387
  772635
  772661
  776289
  776926
  778119
  785855
  788210
  789856
  790133
  791353
  798219
  800633
  803035
  810298
  813532
  818551
  819751
  819777
  823589
  823940
  824167
  825907
  827432
]

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 (417334, 423572, 423580, 429909, 436942, 446562, 450683, 451514, 460503, 471108, 477147, 488957, 489061, 492138, 495400, 508701, 510898, 517332, 526070, 526449, 536689, 537672, 560969, 585017, 585959, 591197, 600995, 630221, 640759, 643112, 650174, 652760, 666816, 666819, 683054, 687844, 700932, 703364, 717849, 720029, 722532, 729231, 742327, 742415, 760951, 762981, 768739, 770387, 772635, 772661, 776289, 776926, 778119, 785855, 788210, 789856, 790133, 791353, 798219, 800633, 803035, 810298, 813532, 818551, 819751, 819777, 823589, 823940, 824167, 825907, 827432);

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

[
  "dirty анал talk"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'dirty анал talk';

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

[
  "dirty анал talk"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = '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 ?

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