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

[
  "anal in woods"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'anal in woods' 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
  396698
  815013
  815019
  614253
  736444
  469503
  655601
  551081
  641938
  815024
  604475
  815007
  614220
  708790
  815003
  614186
  543556
  786757
  786493
  815017
  705753
  564646
  720408
  563866
  821559
  801265
  786047
  719303
  779979
  823413
  659956
  705731
  663747
  821942
  824580
  826135
  820919
  800304
  699517
  761147
  705710
  738674
  614142
  660029
  614244
  633119
  492559
  562265
  804765
  619012
  79913
  423920
  472345
  521970
  710085
  604278
  614344
  431979
  623333
  631937
  816007
  619802
  474013
  561096
  603317
  564566
  517869
  520839
  521866
  464326
  528929
  528925
  525082
]

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 (396698, 815013, 815019, 614253, 736444, 469503, 655601, 551081, 641938, 815024, 604475, 815007, 614220, 708790, 815003, 614186, 543556, 786757, 786493, 815017, 705753, 564646, 720408, 563866, 821559, 801265, 786047, 719303, 779979, 823413, 659956, 705731, 663747, 821942, 824580, 826135, 820919, 800304, 699517, 761147, 705710, 738674, 614142, 660029, 614244, 633119, 492559, 562265, 804765, 619012, 79913, 423920, 472345, 521970, 710085, 604278, 614344, 431979, 623333, 631937, 816007, 619802, 474013, 561096, 603317, 564566, 517869, 520839, 521866, 464326, 528929, 528925, 525082);

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
  79913
  396698
  423920
  431979
  464326
  469503
  472345
  474013
  492559
  517869
  520839
  521866
  521970
  525082
  528925
  528929
  543556
  551081
  561096
  562265
  563866
  564566
  564646
  603317
  604278
  604475
  614142
  614186
  614220
  614244
  614253
  614344
  619012
  619802
  623333
  631937
  633119
  641938
  655601
  659956
  660029
  663747
  699517
  705710
  705731
  705753
  708790
  710085
  719303
  720408
  736444
  738674
  761147
  779979
  786047
  786493
  786757
  800304
  801265
  804765
  815003
  815007
  815013
  815017
  815019
  815024
  816007
  820919
  821559
  821942
  823413
  824580
  826135
]

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 (79913, 396698, 423920, 431979, 464326, 469503, 472345, 474013, 492559, 517869, 520839, 521866, 521970, 525082, 528925, 528929, 543556, 551081, 561096, 562265, 563866, 564566, 564646, 603317, 604278, 604475, 614142, 614186, 614220, 614244, 614253, 614344, 619012, 619802, 623333, 631937, 633119, 641938, 655601, 659956, 660029, 663747, 699517, 705710, 705731, 705753, 708790, 710085, 719303, 720408, 736444, 738674, 761147, 779979, 786047, 786493, 786757, 800304, 801265, 804765, 815003, 815007, 815013, 815017, 815019, 815024, 816007, 820919, 821559, 821942, 823413, 824580, 826135);

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
  79913
  396698
  423920
  431979
  464326
  469503
  472345
  474013
  492559
  517869
  520839
  521866
  521970
  525082
  528925
  528929
  543556
  551081
  561096
  562265
  563866
  564566
  564646
  603317
  604278
  604475
  614142
  614186
  614220
  614244
  614253
  614344
  619012
  619802
  623333
  631937
  633119
  641938
  655601
  659956
  660029
  663747
  699517
  705710
  705731
  705753
  708790
  710085
  719303
  720408
  736444
  738674
  761147
  779979
  786047
  786493
  786757
  800304
  801265
  804765
  815003
  815007
  815013
  815017
  815019
  815024
  816007
  820919
  821559
  821942
  823413
  824580
  826135
]

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 (79913, 396698, 423920, 431979, 464326, 469503, 472345, 474013, 492559, 517869, 520839, 521866, 521970, 525082, 528925, 528929, 543556, 551081, 561096, 562265, 563866, 564566, 564646, 603317, 604278, 604475, 614142, 614186, 614220, 614244, 614253, 614344, 619012, 619802, 623333, 631937, 633119, 641938, 655601, 659956, 660029, 663747, 699517, 705710, 705731, 705753, 708790, 710085, 719303, 720408, 736444, 738674, 761147, 779979, 786047, 786493, 786757, 800304, 801265, 804765, 815003, 815007, 815013, 815017, 815019, 815024, 816007, 820919, 821559, 821942, 823413, 824580, 826135);

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

[
  "анал woods"
]

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

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

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

[
  "анал woods"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'анал woods';

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 ?

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