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
  530366
  544332
  681403
  793734
  755100
  760714
  774632
  804358
  788781
  734833
  812464
  588101
  637562
  734831
  746579
  753544
  697915
  813661
  681117
  708637
  637550
  795555
  805606
  807693
  802287
  786596
  800356
  795490
  709105
  805524
  769256
  755496
  714153
  440856
  686101
  697912
  708587
  786201
  795877
  734837
  805508
  474620
  602638
  799007
  800658
  812495
  756570
  773922
  523880
  568427
  572639
  674649
  604619
  810291
  755350
  523879
  582871
  759563
  522466
  562637
  706924
  633459
  452998
  523883
  512528
  512048
  569179
  733909
  569223
  575853
  523887
  523882
  625675
]

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 (530366, 544332, 681403, 793734, 755100, 760714, 774632, 804358, 788781, 734833, 812464, 588101, 637562, 734831, 746579, 753544, 697915, 813661, 681117, 708637, 637550, 795555, 805606, 807693, 802287, 786596, 800356, 795490, 709105, 805524, 769256, 755496, 714153, 440856, 686101, 697912, 708587, 786201, 795877, 734837, 805508, 474620, 602638, 799007, 800658, 812495, 756570, 773922, 523880, 568427, 572639, 674649, 604619, 810291, 755350, 523879, 582871, 759563, 522466, 562637, 706924, 633459, 452998, 523883, 512528, 512048, 569179, 733909, 569223, 575853, 523887, 523882, 625675);

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
  440856
  452998
  474620
  512048
  512528
  522466
  523879
  523880
  523882
  523883
  523887
  530366
  544332
  562637
  568427
  569179
  569223
  572639
  575853
  582871
  588101
  602638
  604619
  625675
  633459
  637550
  637562
  674649
  681117
  681403
  686101
  697912
  697915
  706924
  708587
  708637
  709105
  714153
  733909
  734831
  734833
  734837
  746579
  753544
  755100
  755350
  755496
  756570
  759563
  760714
  769256
  773922
  774632
  786201
  786596
  788781
  793734
  795490
  795555
  795877
  799007
  800356
  800658
  802287
  804358
  805508
  805524
  805606
  807693
  810291
  812464
  812495
  813661
]

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 (440856, 452998, 474620, 512048, 512528, 522466, 523879, 523880, 523882, 523883, 523887, 530366, 544332, 562637, 568427, 569179, 569223, 572639, 575853, 582871, 588101, 602638, 604619, 625675, 633459, 637550, 637562, 674649, 681117, 681403, 686101, 697912, 697915, 706924, 708587, 708637, 709105, 714153, 733909, 734831, 734833, 734837, 746579, 753544, 755100, 755350, 755496, 756570, 759563, 760714, 769256, 773922, 774632, 786201, 786596, 788781, 793734, 795490, 795555, 795877, 799007, 800356, 800658, 802287, 804358, 805508, 805524, 805606, 807693, 810291, 812464, 812495, 813661);

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
  440856
  452998
  474620
  512048
  512528
  522466
  523879
  523880
  523882
  523883
  523887
  530366
  544332
  562637
  568427
  569179
  569223
  572639
  575853
  582871
  588101
  602638
  604619
  625675
  633459
  637550
  637562
  674649
  681117
  681403
  686101
  697912
  697915
  706924
  708587
  708637
  709105
  714153
  733909
  734831
  734833
  734837
  746579
  753544
  755100
  755350
  755496
  756570
  759563
  760714
  769256
  773922
  774632
  786201
  786596
  788781
  793734
  795490
  795555
  795877
  799007
  800356
  800658
  802287
  804358
  805508
  805524
  805606
  807693
  810291
  812464
  812495
  813661
]

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 (440856, 452998, 474620, 512048, 512528, 522466, 523879, 523880, 523882, 523883, 523887, 530366, 544332, 562637, 568427, 569179, 569223, 572639, 575853, 582871, 588101, 602638, 604619, 625675, 633459, 637550, 637562, 674649, 681117, 681403, 686101, 697912, 697915, 706924, 708587, 708637, 709105, 714153, 733909, 734831, 734833, 734837, 746579, 753544, 755100, 755350, 755496, 756570, 759563, 760714, 769256, 773922, 774632, 786201, 786596, 788781, 793734, 795490, 795555, 795877, 799007, 800356, 800658, 802287, 804358, 805508, 805524, 805606, 807693, 810291, 812464, 812495, 813661);

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
        ;