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

[
  "maid asian"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'maid asian' 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
  793294
  761464
  773441
  813505
  750477
  622143
  449360
  565983
  565987
  423400
  465051
  504723
  531083
  603929
  586886
  589769
  816259
  458561
  531919
  535002
  567776
  550753
  593506
  630529
  460211
  519903
  567357
  423015
  820767
  814929
  459594
  564213
  722776
  623494
  643072
  601339
  603445
  623812
  556405
  457981
  428293
  623644
  609933
  511897
  557499
  812781
  468666
  421287
  821370
  529129
  559942
  827166
  588147
  807521
  416332
  472567
  152234
  652893
  825781
  584134
  568631
  501564
  529319
  503043
  804677
  519703
  538653
  621353
  517278
  808467
  553280
  561458
]

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 (793294, 761464, 773441, 813505, 750477, 622143, 449360, 565983, 565987, 423400, 465051, 504723, 531083, 603929, 586886, 589769, 816259, 458561, 531919, 535002, 567776, 550753, 593506, 630529, 460211, 519903, 567357, 423015, 820767, 814929, 459594, 564213, 722776, 623494, 643072, 601339, 603445, 623812, 556405, 457981, 428293, 623644, 609933, 511897, 557499, 812781, 468666, 421287, 821370, 529129, 559942, 827166, 588147, 807521, 416332, 472567, 152234, 652893, 825781, 584134, 568631, 501564, 529319, 503043, 804677, 519703, 538653, 621353, 517278, 808467, 553280, 561458);

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
  152234
  416332
  421287
  423015
  423400
  428293
  449360
  457981
  458561
  459594
  460211
  465051
  468666
  472567
  501564
  503043
  504723
  511897
  517278
  519703
  519903
  529129
  529319
  531083
  531919
  535002
  538653
  550753
  553280
  556405
  557499
  559942
  561458
  564213
  565983
  565987
  567357
  567776
  568631
  584134
  586886
  588147
  589769
  593506
  601339
  603445
  603929
  609933
  621353
  622143
  623494
  623644
  623812
  630529
  643072
  652893
  722776
  750477
  761464
  773441
  793294
  804677
  807521
  808467
  812781
  813505
  814929
  816259
  820767
  821370
  825781
  827166
]

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 (152234, 416332, 421287, 423015, 423400, 428293, 449360, 457981, 458561, 459594, 460211, 465051, 468666, 472567, 501564, 503043, 504723, 511897, 517278, 519703, 519903, 529129, 529319, 531083, 531919, 535002, 538653, 550753, 553280, 556405, 557499, 559942, 561458, 564213, 565983, 565987, 567357, 567776, 568631, 584134, 586886, 588147, 589769, 593506, 601339, 603445, 603929, 609933, 621353, 622143, 623494, 623644, 623812, 630529, 643072, 652893, 722776, 750477, 761464, 773441, 793294, 804677, 807521, 808467, 812781, 813505, 814929, 816259, 820767, 821370, 825781, 827166);

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
  152234
  416332
  421287
  423015
  423400
  428293
  449360
  457981
  458561
  459594
  460211
  465051
  468666
  472567
  501564
  503043
  504723
  511897
  517278
  519703
  519903
  529129
  529319
  531083
  531919
  535002
  538653
  550753
  553280
  556405
  557499
  559942
  561458
  564213
  565983
  565987
  567357
  567776
  568631
  584134
  586886
  588147
  589769
  593506
  601339
  603445
  603929
  609933
  621353
  622143
  623494
  623644
  623812
  630529
  643072
  652893
  722776
  750477
  761464
  773441
  793294
  804677
  807521
  808467
  812781
  813505
  814929
  816259
  820767
  821370
  825781
  827166
]

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 (152234, 416332, 421287, 423015, 423400, 428293, 449360, 457981, 458561, 459594, 460211, 465051, 468666, 472567, 501564, 503043, 504723, 511897, 517278, 519703, 519903, 529129, 529319, 531083, 531919, 535002, 538653, 550753, 553280, 556405, 557499, 559942, 561458, 564213, 565983, 565987, 567357, 567776, 568631, 584134, 586886, 588147, 589769, 593506, 601339, 603445, 603929, 609933, 621353, 622143, 623494, 623644, 623812, 630529, 643072, 652893, 722776, 750477, 761464, 773441, 793294, 804677, 807521, 808467, 812781, 813505, 814929, 816259, 820767, 821370, 825781, 827166);

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

[
  "горничн азиатк"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'горничн азиатк';

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

[
  "горничн азиатк"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'горничн азиатк';

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 ?

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