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

[
  "step sister sleeping"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'step sister sleeping' 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
  421338
  442952
  499959
  528122
  526247
  524163
  525145
  471628
  451838
  443482
  484499
  460119
  480654
  515023
  477414
  554008
  561183
  561177
  585323
  599734
  616481
  615438
  617203
  618465
  601953
  437613
  446608
  454876
  435020
  465738
  442402
  400341
  424995
  429695
  437555
  417438
  429782
  427332
  447825
  453437
  459533
  520885
  561155
  560489
  577468
  584560
  599376
  614060
  479632
  417839
  416039
  509819
  511078
  441447
  451380
  509384
  619849
  421043
  516128
  395452
  480087
  608111
  608737
  703268
  525142
  652289
  584752
  516876
  579732
  623615
  528116
  531920
  617205
]

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 (421338, 442952, 499959, 528122, 526247, 524163, 525145, 471628, 451838, 443482, 484499, 460119, 480654, 515023, 477414, 554008, 561183, 561177, 585323, 599734, 616481, 615438, 617203, 618465, 601953, 437613, 446608, 454876, 435020, 465738, 442402, 400341, 424995, 429695, 437555, 417438, 429782, 427332, 447825, 453437, 459533, 520885, 561155, 560489, 577468, 584560, 599376, 614060, 479632, 417839, 416039, 509819, 511078, 441447, 451380, 509384, 619849, 421043, 516128, 395452, 480087, 608111, 608737, 703268, 525142, 652289, 584752, 516876, 579732, 623615, 528116, 531920, 617205);

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
  395452
  400341
  416039
  417438
  417839
  421043
  421338
  424995
  427332
  429695
  429782
  435020
  437555
  437613
  441447
  442402
  442952
  443482
  446608
  447825
  451380
  451838
  453437
  454876
  459533
  460119
  465738
  471628
  477414
  479632
  480087
  480654
  484499
  499959
  509384
  509819
  511078
  515023
  516128
  516876
  520885
  524163
  525142
  525145
  526247
  528116
  528122
  531920
  554008
  560489
  561155
  561177
  561183
  577468
  579732
  584560
  584752
  585323
  599376
  599734
  601953
  608111
  608737
  614060
  615438
  616481
  617203
  617205
  618465
  619849
  623615
  652289
  703268
]

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 (395452, 400341, 416039, 417438, 417839, 421043, 421338, 424995, 427332, 429695, 429782, 435020, 437555, 437613, 441447, 442402, 442952, 443482, 446608, 447825, 451380, 451838, 453437, 454876, 459533, 460119, 465738, 471628, 477414, 479632, 480087, 480654, 484499, 499959, 509384, 509819, 511078, 515023, 516128, 516876, 520885, 524163, 525142, 525145, 526247, 528116, 528122, 531920, 554008, 560489, 561155, 561177, 561183, 577468, 579732, 584560, 584752, 585323, 599376, 599734, 601953, 608111, 608737, 614060, 615438, 616481, 617203, 617205, 618465, 619849, 623615, 652289, 703268);

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
  395452
  400341
  416039
  417438
  417839
  421043
  421338
  424995
  427332
  429695
  429782
  435020
  437555
  437613
  441447
  442402
  442952
  443482
  446608
  447825
  451380
  451838
  453437
  454876
  459533
  460119
  465738
  471628
  477414
  479632
  480087
  480654
  484499
  499959
  509384
  509819
  511078
  515023
  516128
  516876
  520885
  524163
  525142
  525145
  526247
  528116
  528122
  531920
  554008
  560489
  561155
  561177
  561183
  577468
  579732
  584560
  584752
  585323
  599376
  599734
  601953
  608111
  608737
  614060
  615438
  616481
  617203
  617205
  618465
  619849
  623615
  652289
  703268
]

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 (395452, 400341, 416039, 417438, 417839, 421043, 421338, 424995, 427332, 429695, 429782, 435020, 437555, 437613, 441447, 442402, 442952, 443482, 446608, 447825, 451380, 451838, 453437, 454876, 459533, 460119, 465738, 471628, 477414, 479632, 480087, 480654, 484499, 499959, 509384, 509819, 511078, 515023, 516128, 516876, 520885, 524163, 525142, 525145, 526247, 528116, 528122, 531920, 554008, 560489, 561155, 561177, 561183, 577468, 579732, 584560, 584752, 585323, 599376, 599734, 601953, 608111, 608737, 614060, 615438, 616481, 617203, 617205, 618465, 619849, 623615, 652289, 703268);

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

[
  "step sister спящ"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'step sister спящ';

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

[
  "step sister спящ"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'step sister спящ';

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 ?

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