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
  721571
  719825
  738586
  813831
  693484
  622287
  794490
  670836
  588977
  804092
  728937
  710127
  741467
  493776
  720774
  813816
  699658
  661335
  758956
  771510
  710534
  437316
  577125
  690841
  650636
  752965
  397811
  567927
  665930
  802832
  485077
  487934
  603129
  810997
  468984
  599267
  613640
  723540
  677707
  761556
  721393
  791604
  801235
  540541
  619718
  756345
  534581
  664192
  805039
  554169
  551931
  614689
  473939
  577080
  591794
  521679
  580670
  556626
  482034
  546749
  760403
  550355
  499812
  511402
  574023
  500590
  506088
  505811
  506133
  608772
  541614
  516214
  527431
  522977
  541631
]

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 (721571, 719825, 738586, 813831, 693484, 622287, 794490, 670836, 588977, 804092, 728937, 710127, 741467, 493776, 720774, 813816, 699658, 661335, 758956, 771510, 710534, 437316, 577125, 690841, 650636, 752965, 397811, 567927, 665930, 802832, 485077, 487934, 603129, 810997, 468984, 599267, 613640, 723540, 677707, 761556, 721393, 791604, 801235, 540541, 619718, 756345, 534581, 664192, 805039, 554169, 551931, 614689, 473939, 577080, 591794, 521679, 580670, 556626, 482034, 546749, 760403, 550355, 499812, 511402, 574023, 500590, 506088, 505811, 506133, 608772, 541614, 516214, 527431, 522977, 541631);

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
  397811
  437316
  468984
  473939
  482034
  485077
  487934
  493776
  499812
  500590
  505811
  506088
  506133
  511402
  516214
  521679
  522977
  527431
  534581
  540541
  541614
  541631
  546749
  550355
  551931
  554169
  556626
  567927
  574023
  577080
  577125
  580670
  588977
  591794
  599267
  603129
  608772
  613640
  614689
  619718
  622287
  650636
  661335
  664192
  665930
  670836
  677707
  690841
  693484
  699658
  710127
  710534
  719825
  720774
  721393
  721571
  723540
  728937
  741467
  752965
  756345
  758956
  760403
  761556
  771510
  791604
  794490
  801235
  802832
  804092
  805039
  810997
  813816
  813831
]

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 (397811, 437316, 468984, 473939, 482034, 485077, 487934, 493776, 499812, 500590, 505811, 506088, 506133, 511402, 516214, 521679, 522977, 527431, 534581, 540541, 541614, 541631, 546749, 550355, 551931, 554169, 556626, 567927, 574023, 577080, 577125, 580670, 588977, 591794, 599267, 603129, 608772, 613640, 614689, 619718, 622287, 650636, 661335, 664192, 665930, 670836, 677707, 690841, 693484, 699658, 710127, 710534, 719825, 720774, 721393, 721571, 723540, 728937, 741467, 752965, 756345, 758956, 760403, 761556, 771510, 791604, 794490, 801235, 802832, 804092, 805039, 810997, 813816, 813831);

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
  397811
  437316
  468984
  473939
  482034
  485077
  487934
  493776
  499812
  500590
  505811
  506088
  506133
  511402
  516214
  521679
  522977
  527431
  534581
  540541
  541614
  541631
  546749
  550355
  551931
  554169
  556626
  567927
  574023
  577080
  577125
  580670
  588977
  591794
  599267
  603129
  608772
  613640
  614689
  619718
  622287
  650636
  661335
  664192
  665930
  670836
  677707
  690841
  693484
  699658
  710127
  710534
  719825
  720774
  721393
  721571
  723540
  728937
  741467
  752965
  756345
  758956
  760403
  761556
  771510
  791604
  794490
  801235
  802832
  804092
  805039
  810997
  813816
  813831
]

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 (397811, 437316, 468984, 473939, 482034, 485077, 487934, 493776, 499812, 500590, 505811, 506088, 506133, 511402, 516214, 521679, 522977, 527431, 534581, 540541, 541614, 541631, 546749, 550355, 551931, 554169, 556626, 567927, 574023, 577080, 577125, 580670, 588977, 591794, 599267, 603129, 608772, 613640, 614689, 619718, 622287, 650636, 661335, 664192, 665930, 670836, 677707, 690841, 693484, 699658, 710127, 710534, 719825, 720774, 721393, 721571, 723540, 728937, 741467, 752965, 756345, 758956, 760403, 761556, 771510, 791604, 794490, 801235, 802832, 804092, 805039, 810997, 813816, 813831);

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
        ;