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
  571907
  782500
  777230
  796212
  462575
  452861
  564087
  777270
  726887
  526744
  573416
  573892
  420486
  719197
  571874
  602656
  796207
  785945
  796206
  480011
  498921
  521972
  475907
  509495
  552216
  562287
  571526
  726882
  476935
  479242
  504295
  512429
  508053
  474955
  504276
  520123
  502092
  578365
  571629
  573630
  569134
  451813
  470676
  484559
  523535
  523600
  569097
  475428
  525211
  426719
  544386
  416252
  489691
  507961
  484649
  419443
  540955
  528803
  569413
  470291
  484673
  483388
  495741
  652931
  653325
  663347
  598080
  452168
  598142
  441024
  424364
  589207
  625001
]

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 (571907, 782500, 777230, 796212, 462575, 452861, 564087, 777270, 726887, 526744, 573416, 573892, 420486, 719197, 571874, 602656, 796207, 785945, 796206, 480011, 498921, 521972, 475907, 509495, 552216, 562287, 571526, 726882, 476935, 479242, 504295, 512429, 508053, 474955, 504276, 520123, 502092, 578365, 571629, 573630, 569134, 451813, 470676, 484559, 523535, 523600, 569097, 475428, 525211, 426719, 544386, 416252, 489691, 507961, 484649, 419443, 540955, 528803, 569413, 470291, 484673, 483388, 495741, 652931, 653325, 663347, 598080, 452168, 598142, 441024, 424364, 589207, 625001);

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
  416252
  419443
  420486
  424364
  426719
  441024
  451813
  452168
  452861
  462575
  470291
  470676
  474955
  475428
  475907
  476935
  479242
  480011
  483388
  484559
  484649
  484673
  489691
  495741
  498921
  502092
  504276
  504295
  507961
  508053
  509495
  512429
  520123
  521972
  523535
  523600
  525211
  526744
  528803
  540955
  544386
  552216
  562287
  564087
  569097
  569134
  569413
  571526
  571629
  571874
  571907
  573416
  573630
  573892
  578365
  589207
  598080
  598142
  602656
  625001
  652931
  653325
  663347
  719197
  726882
  726887
  777230
  777270
  782500
  785945
  796206
  796207
  796212
]

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 (416252, 419443, 420486, 424364, 426719, 441024, 451813, 452168, 452861, 462575, 470291, 470676, 474955, 475428, 475907, 476935, 479242, 480011, 483388, 484559, 484649, 484673, 489691, 495741, 498921, 502092, 504276, 504295, 507961, 508053, 509495, 512429, 520123, 521972, 523535, 523600, 525211, 526744, 528803, 540955, 544386, 552216, 562287, 564087, 569097, 569134, 569413, 571526, 571629, 571874, 571907, 573416, 573630, 573892, 578365, 589207, 598080, 598142, 602656, 625001, 652931, 653325, 663347, 719197, 726882, 726887, 777230, 777270, 782500, 785945, 796206, 796207, 796212);

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
  416252
  419443
  420486
  424364
  426719
  441024
  451813
  452168
  452861
  462575
  470291
  470676
  474955
  475428
  475907
  476935
  479242
  480011
  483388
  484559
  484649
  484673
  489691
  495741
  498921
  502092
  504276
  504295
  507961
  508053
  509495
  512429
  520123
  521972
  523535
  523600
  525211
  526744
  528803
  540955
  544386
  552216
  562287
  564087
  569097
  569134
  569413
  571526
  571629
  571874
  571907
  573416
  573630
  573892
  578365
  589207
  598080
  598142
  602656
  625001
  652931
  653325
  663347
  719197
  726882
  726887
  777230
  777270
  782500
  785945
  796206
  796207
  796212
]

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 (416252, 419443, 420486, 424364, 426719, 441024, 451813, 452168, 452861, 462575, 470291, 470676, 474955, 475428, 475907, 476935, 479242, 480011, 483388, 484559, 484649, 484673, 489691, 495741, 498921, 502092, 504276, 504295, 507961, 508053, 509495, 512429, 520123, 521972, 523535, 523600, 525211, 526744, 528803, 540955, 544386, 552216, 562287, 564087, 569097, 569134, 569413, 571526, 571629, 571874, 571907, 573416, 573630, 573892, 578365, 589207, 598080, 598142, 602656, 625001, 652931, 653325, 663347, 719197, 726882, 726887, 777230, 777270, 782500, 785945, 796206, 796207, 796212);

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
        ;