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
  641192
  657156
  769011
  773421
  776937
  731247
  731243
  716050
  721556
  506287
  785488
  794752
  728326
  736225
  613765
  737276
  641830
  464580
  775382
  588014
  788552
  761497
  734961
  736222
  791097
  632540
  794823
  736241
  727575
  731224
  794847
  680266
  720284
  591897
  800404
  768654
  520790
  574643
  677899
  754160
  720132
  492495
  547865
  593787
  522053
  620499
  573917
  785319
  684305
  552978
  559938
  606697
  491802
  637243
  609292
  499867
  654552
  655615
  617006
  576723
  663930
  582631
  599404
  511837
  657438
  599512
  611900
  622778
  520697
  540141
  560511
]

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 (641192, 657156, 769011, 773421, 776937, 731247, 731243, 716050, 721556, 506287, 785488, 794752, 728326, 736225, 613765, 737276, 641830, 464580, 775382, 588014, 788552, 761497, 734961, 736222, 791097, 632540, 794823, 736241, 727575, 731224, 794847, 680266, 720284, 591897, 800404, 768654, 520790, 574643, 677899, 754160, 720132, 492495, 547865, 593787, 522053, 620499, 573917, 785319, 684305, 552978, 559938, 606697, 491802, 637243, 609292, 499867, 654552, 655615, 617006, 576723, 663930, 582631, 599404, 511837, 657438, 599512, 611900, 622778, 520697, 540141, 560511);

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
  464580
  491802
  492495
  499867
  506287
  511837
  520697
  520790
  522053
  540141
  547865
  552978
  559938
  560511
  573917
  574643
  576723
  582631
  588014
  591897
  593787
  599404
  599512
  606697
  609292
  611900
  613765
  617006
  620499
  622778
  632540
  637243
  641192
  641830
  654552
  655615
  657156
  657438
  663930
  677899
  680266
  684305
  716050
  720132
  720284
  721556
  727575
  728326
  731224
  731243
  731247
  734961
  736222
  736225
  736241
  737276
  754160
  761497
  768654
  769011
  773421
  775382
  776937
  785319
  785488
  788552
  791097
  794752
  794823
  794847
  800404
]

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 (464580, 491802, 492495, 499867, 506287, 511837, 520697, 520790, 522053, 540141, 547865, 552978, 559938, 560511, 573917, 574643, 576723, 582631, 588014, 591897, 593787, 599404, 599512, 606697, 609292, 611900, 613765, 617006, 620499, 622778, 632540, 637243, 641192, 641830, 654552, 655615, 657156, 657438, 663930, 677899, 680266, 684305, 716050, 720132, 720284, 721556, 727575, 728326, 731224, 731243, 731247, 734961, 736222, 736225, 736241, 737276, 754160, 761497, 768654, 769011, 773421, 775382, 776937, 785319, 785488, 788552, 791097, 794752, 794823, 794847, 800404);

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
  464580
  491802
  492495
  499867
  506287
  511837
  520697
  520790
  522053
  540141
  547865
  552978
  559938
  560511
  573917
  574643
  576723
  582631
  588014
  591897
  593787
  599404
  599512
  606697
  609292
  611900
  613765
  617006
  620499
  622778
  632540
  637243
  641192
  641830
  654552
  655615
  657156
  657438
  663930
  677899
  680266
  684305
  716050
  720132
  720284
  721556
  727575
  728326
  731224
  731243
  731247
  734961
  736222
  736225
  736241
  737276
  754160
  761497
  768654
  769011
  773421
  775382
  776937
  785319
  785488
  788552
  791097
  794752
  794823
  794847
  800404
]

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 (464580, 491802, 492495, 499867, 506287, 511837, 520697, 520790, 522053, 540141, 547865, 552978, 559938, 560511, 573917, 574643, 576723, 582631, 588014, 591897, 593787, 599404, 599512, 606697, 609292, 611900, 613765, 617006, 620499, 622778, 632540, 637243, 641192, 641830, 654552, 655615, 657156, 657438, 663930, 677899, 680266, 684305, 716050, 720132, 720284, 721556, 727575, 728326, 731224, 731243, 731247, 734961, 736222, 736225, 736241, 737276, 754160, 761497, 768654, 769011, 773421, 775382, 776937, 785319, 785488, 788552, 791097, 794752, 794823, 794847, 800404);

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
        ;