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

[
  "vip sex"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'vip sex' 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
  600421
  610600
  585704
  626758
  573383
  520949
  599840
  587852
  599255
  605395
  602929
  470288
  559444
  419101
  558305
  581965
  401049
  475122
  511678
  723875
  817936
  734679
  781639
  783322
  785232
  758892
  683608
  697052
  811460
  814136
  467372
  796166
  799225
  734880
  705136
  588958
  804734
  569388
  770277
  642578
  564736
  747885
  617122
  533328
  828403
  519171
  213932
  719776
  815392
  436845
  467355
  401251
  782602
  595025
  623231
  549166
  787544
  444980
  787393
  527904
  422043
  503725
  634770
  595176
  426663
  422824
  497480
  517329
  407292
  594960
  442556
  520522
  516839
  550829
]

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 (600421, 610600, 585704, 626758, 573383, 520949, 599840, 587852, 599255, 605395, 602929, 470288, 559444, 419101, 558305, 581965, 401049, 475122, 511678, 723875, 817936, 734679, 781639, 783322, 785232, 758892, 683608, 697052, 811460, 814136, 467372, 796166, 799225, 734880, 705136, 588958, 804734, 569388, 770277, 642578, 564736, 747885, 617122, 533328, 828403, 519171, 213932, 719776, 815392, 436845, 467355, 401251, 782602, 595025, 623231, 549166, 787544, 444980, 787393, 527904, 422043, 503725, 634770, 595176, 426663, 422824, 497480, 517329, 407292, 594960, 442556, 520522, 516839, 550829);

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
  213932
  401049
  401251
  407292
  419101
  422043
  422824
  426663
  436845
  442556
  444980
  467355
  467372
  470288
  475122
  497480
  503725
  511678
  516839
  517329
  519171
  520522
  520949
  527904
  533328
  549166
  550829
  558305
  559444
  564736
  569388
  573383
  581965
  585704
  587852
  588958
  594960
  595025
  595176
  599255
  599840
  600421
  602929
  605395
  610600
  617122
  623231
  626758
  634770
  642578
  683608
  697052
  705136
  719776
  723875
  734679
  734880
  747885
  758892
  770277
  781639
  782602
  783322
  785232
  787393
  787544
  796166
  799225
  804734
  811460
  814136
  815392
  817936
  828403
]

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 (213932, 401049, 401251, 407292, 419101, 422043, 422824, 426663, 436845, 442556, 444980, 467355, 467372, 470288, 475122, 497480, 503725, 511678, 516839, 517329, 519171, 520522, 520949, 527904, 533328, 549166, 550829, 558305, 559444, 564736, 569388, 573383, 581965, 585704, 587852, 588958, 594960, 595025, 595176, 599255, 599840, 600421, 602929, 605395, 610600, 617122, 623231, 626758, 634770, 642578, 683608, 697052, 705136, 719776, 723875, 734679, 734880, 747885, 758892, 770277, 781639, 782602, 783322, 785232, 787393, 787544, 796166, 799225, 804734, 811460, 814136, 815392, 817936, 828403);

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
  213932
  401049
  401251
  407292
  419101
  422043
  422824
  426663
  436845
  442556
  444980
  467355
  467372
  470288
  475122
  497480
  503725
  511678
  516839
  517329
  519171
  520522
  520949
  527904
  533328
  549166
  550829
  558305
  559444
  564736
  569388
  573383
  581965
  585704
  587852
  588958
  594960
  595025
  595176
  599255
  599840
  600421
  602929
  605395
  610600
  617122
  623231
  626758
  634770
  642578
  683608
  697052
  705136
  719776
  723875
  734679
  734880
  747885
  758892
  770277
  781639
  782602
  783322
  785232
  787393
  787544
  796166
  799225
  804734
  811460
  814136
  815392
  817936
  828403
]

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 (213932, 401049, 401251, 407292, 419101, 422043, 422824, 426663, 436845, 442556, 444980, 467355, 467372, 470288, 475122, 497480, 503725, 511678, 516839, 517329, 519171, 520522, 520949, 527904, 533328, 549166, 550829, 558305, 559444, 564736, 569388, 573383, 581965, 585704, 587852, 588958, 594960, 595025, 595176, 599255, 599840, 600421, 602929, 605395, 610600, 617122, 623231, 626758, 634770, 642578, 683608, 697052, 705136, 719776, 723875, 734679, 734880, 747885, 758892, 770277, 781639, 782602, 783322, 785232, 787393, 787544, 796166, 799225, 804734, 811460, 814136, 815392, 817936, 828403);

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

[
  "vip секс"
]

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

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

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

[
  "vip секс"
]

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

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

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 ?

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