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
  150405
  130404
  58336
  61369
  382019
  715507
  603257
  454496
  386414
  453695
  739062
  414364
  443827
  486673
  491079
  429574
  518842
  122767
  474627
  399421
  746533
  467043
  447031
  66574
  15129
  474686
  463102
  444223
  129722
  447735
  483453
  511259
  557954
  443786
  445639
  450825
  400270
  451960
  465224
  480809
  474840
  391941
  437679
  426518
  595097
  400517
  129640
  404342
  465356
  474629
  435695
  634131
  506053
  467626
  520224
  516313
  490262
  454456
  484690
  454337
  678052
  514576
  677674
  443777
  446736
  467602
  485735
  504854
  613174
]

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 (150405, 130404, 58336, 61369, 382019, 715507, 603257, 454496, 386414, 453695, 739062, 414364, 443827, 486673, 491079, 429574, 518842, 122767, 474627, 399421, 746533, 467043, 447031, 66574, 15129, 474686, 463102, 444223, 129722, 447735, 483453, 511259, 557954, 443786, 445639, 450825, 400270, 451960, 465224, 480809, 474840, 391941, 437679, 426518, 595097, 400517, 129640, 404342, 465356, 474629, 435695, 634131, 506053, 467626, 520224, 516313, 490262, 454456, 484690, 454337, 678052, 514576, 677674, 443777, 446736, 467602, 485735, 504854, 613174);

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
  15129
  58336
  61369
  66574
  122767
  129640
  129722
  130404
  150405
  382019
  386414
  391941
  399421
  400270
  400517
  404342
  414364
  426518
  429574
  435695
  437679
  443777
  443786
  443827
  444223
  445639
  446736
  447031
  447735
  450825
  451960
  453695
  454337
  454456
  454496
  463102
  465224
  465356
  467043
  467602
  467626
  474627
  474629
  474686
  474840
  480809
  483453
  484690
  485735
  486673
  490262
  491079
  504854
  506053
  511259
  514576
  516313
  518842
  520224
  557954
  595097
  603257
  613174
  634131
  677674
  678052
  715507
  739062
  746533
]

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 (15129, 58336, 61369, 66574, 122767, 129640, 129722, 130404, 150405, 382019, 386414, 391941, 399421, 400270, 400517, 404342, 414364, 426518, 429574, 435695, 437679, 443777, 443786, 443827, 444223, 445639, 446736, 447031, 447735, 450825, 451960, 453695, 454337, 454456, 454496, 463102, 465224, 465356, 467043, 467602, 467626, 474627, 474629, 474686, 474840, 480809, 483453, 484690, 485735, 486673, 490262, 491079, 504854, 506053, 511259, 514576, 516313, 518842, 520224, 557954, 595097, 603257, 613174, 634131, 677674, 678052, 715507, 739062, 746533);

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
  15129
  58336
  61369
  66574
  122767
  129640
  129722
  130404
  150405
  382019
  386414
  391941
  399421
  400270
  400517
  404342
  414364
  426518
  429574
  435695
  437679
  443777
  443786
  443827
  444223
  445639
  446736
  447031
  447735
  450825
  451960
  453695
  454337
  454456
  454496
  463102
  465224
  465356
  467043
  467602
  467626
  474627
  474629
  474686
  474840
  480809
  483453
  484690
  485735
  486673
  490262
  491079
  504854
  506053
  511259
  514576
  516313
  518842
  520224
  557954
  595097
  603257
  613174
  634131
  677674
  678052
  715507
  739062
  746533
]

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 (15129, 58336, 61369, 66574, 122767, 129640, 129722, 130404, 150405, 382019, 386414, 391941, 399421, 400270, 400517, 404342, 414364, 426518, 429574, 435695, 437679, 443777, 443786, 443827, 444223, 445639, 446736, 447031, 447735, 450825, 451960, 453695, 454337, 454456, 454496, 463102, 465224, 465356, 467043, 467602, 467626, 474627, 474629, 474686, 474840, 480809, 483453, 484690, 485735, 486673, 490262, 491079, 504854, 506053, 511259, 514576, 516313, 518842, 520224, 557954, 595097, 603257, 613174, 634131, 677674, 678052, 715507, 739062, 746533);

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
        ;