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

[
  "сперма струя"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'сперма струя' 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
  719205
  719146
  476704
  743685
  730212
  398643
  641517
  774408
  476713
  476825
  784912
  587995
  476778
  500957
  745746
  808665
  742651
  750916
  544515
  742641
  772270
  772274
  751972
  725073
  661904
  744577
  719152
  567983
  628673
  809367
  795601
  800193
  770776
  387173
  742657
  803909
  790603
  452416
  689164
  384132
  810042
  554846
  719314
  456062
  466903
  554850
  744855
  668780
  742622
  787065
  416873
  465235
  387399
  784626
  510994
  554722
  559502
  568111
  467885
  387556
  482237
  784750
  460804
  526774
  554743
  419113
  809290
  636479
  501313
  719333
  615717
  639060
  675010
  591959
  550531
]

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 (719205, 719146, 476704, 743685, 730212, 398643, 641517, 774408, 476713, 476825, 784912, 587995, 476778, 500957, 745746, 808665, 742651, 750916, 544515, 742641, 772270, 772274, 751972, 725073, 661904, 744577, 719152, 567983, 628673, 809367, 795601, 800193, 770776, 387173, 742657, 803909, 790603, 452416, 689164, 384132, 810042, 554846, 719314, 456062, 466903, 554850, 744855, 668780, 742622, 787065, 416873, 465235, 387399, 784626, 510994, 554722, 559502, 568111, 467885, 387556, 482237, 784750, 460804, 526774, 554743, 419113, 809290, 636479, 501313, 719333, 615717, 639060, 675010, 591959, 550531);

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
  384132
  387173
  387399
  387556
  398643
  416873
  419113
  452416
  456062
  460804
  465235
  466903
  467885
  476704
  476713
  476778
  476825
  482237
  500957
  501313
  510994
  526774
  544515
  550531
  554722
  554743
  554846
  554850
  559502
  567983
  568111
  587995
  591959
  615717
  628673
  636479
  639060
  641517
  661904
  668780
  675010
  689164
  719146
  719152
  719205
  719314
  719333
  725073
  730212
  742622
  742641
  742651
  742657
  743685
  744577
  744855
  745746
  750916
  751972
  770776
  772270
  774408
  784626
  784750
  784912
  787065
  790603
  795601
  800193
  803909
  808665
  809290
  809367
  810042
]

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 (384132, 387173, 387399, 387556, 398643, 416873, 419113, 452416, 456062, 460804, 465235, 466903, 467885, 476704, 476713, 476778, 476825, 482237, 500957, 501313, 510994, 526774, 544515, 550531, 554722, 554743, 554846, 554850, 559502, 567983, 568111, 587995, 591959, 615717, 628673, 636479, 639060, 641517, 661904, 668780, 675010, 689164, 719146, 719152, 719205, 719314, 719333, 725073, 730212, 742622, 742641, 742651, 742657, 743685, 744577, 744855, 745746, 750916, 751972, 770776, 772270, 774408, 784626, 784750, 784912, 787065, 790603, 795601, 800193, 803909, 808665, 809290, 809367, 810042);

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
  384132
  387173
  387399
  387556
  398643
  416873
  419113
  452416
  456062
  460804
  465235
  466903
  467885
  476704
  476713
  476778
  476825
  482237
  500957
  501313
  510994
  526774
  544515
  550531
  554722
  554743
  554846
  554850
  559502
  567983
  568111
  587995
  591959
  615717
  628673
  636479
  639060
  641517
  661904
  668780
  675010
  689164
  719146
  719152
  719205
  719314
  719333
  725073
  730212
  742622
  742641
  742651
  742657
  743685
  744577
  744855
  745746
  750916
  751972
  770776
  772270
  774408
  784626
  784750
  784912
  787065
  790603
  795601
  800193
  803909
  808665
  809290
  809367
  810042
]

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 (384132, 387173, 387399, 387556, 398643, 416873, 419113, 452416, 456062, 460804, 465235, 466903, 467885, 476704, 476713, 476778, 476825, 482237, 500957, 501313, 510994, 526774, 544515, 550531, 554722, 554743, 554846, 554850, 559502, 567983, 568111, 587995, 591959, 615717, 628673, 636479, 639060, 641517, 661904, 668780, 675010, 689164, 719146, 719152, 719205, 719314, 719333, 725073, 730212, 742622, 742641, 742651, 742657, 743685, 744577, 744855, 745746, 750916, 751972, 770776, 772270, 774408, 784626, 784750, 784912, 787065, 790603, 795601, 800193, 803909, 808665, 809290, 809367, 810042);

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 ?

[
  "сперма струя"
  "сперма струя"
  "сперма струя"
  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 ('сперма струя') AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST ('сперма струя')
              AND `query` <> 'сперма струя'
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT 20
        ;