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

[
  "swallow a load"
]

SELECT
  `trend_id`
FROM
  `trend`
WHERE
  `subject` = ?
LIMIT
  1

SELECT `trend_id` FROM `trend` WHERE `subject` = 'swallow a load' 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
  521731
  769213
  741937
  391102
  530824
  769422
  776785
  764638
  760252
  577632
  437515
  518317
  528814
  612581
  509293
  487364
  824003
  792292
  593193
  733316
  737533
  708450
  581988
  516999
  553713
  774255
  733519
  786312
  733546
  553683
  714943
  800419
  810576
  765053
  710419
  652674
  636441
  794970
  810201
  748579
  769610
  717229
  568462
  713509
  784060
  738307
  641919
  738335
  767403
  774006
  774583
  783689
  790746
  668961
  407335
  437986
  813625
  716546
  450149
  653330
  718980
  613848
  598300
  763378
  764486
  708148
  780936
  422150
  541582
  725451
  510869
  722918
  437959
  521785
]

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 (521731, 769213, 741937, 391102, 530824, 769422, 776785, 764638, 760252, 577632, 437515, 518317, 528814, 612581, 509293, 487364, 824003, 792292, 593193, 733316, 737533, 708450, 581988, 516999, 553713, 774255, 733519, 786312, 733546, 553683, 714943, 800419, 810576, 765053, 710419, 652674, 636441, 794970, 810201, 748579, 769610, 717229, 568462, 713509, 784060, 738307, 641919, 738335, 767403, 774006, 774583, 783689, 790746, 668961, 407335, 437986, 813625, 716546, 450149, 653330, 718980, 613848, 598300, 763378, 764486, 708148, 780936, 422150, 541582, 725451, 510869, 722918, 437959, 521785);

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
  391102
  407335
  422150
  437515
  437959
  437986
  450149
  487364
  509293
  510869
  516999
  518317
  521731
  521785
  528814
  530824
  541582
  553683
  553713
  568462
  577632
  581988
  593193
  598300
  612581
  613848
  636441
  641919
  652674
  653330
  668961
  708148
  708450
  710419
  713509
  714943
  716546
  717229
  718980
  722918
  725451
  733316
  733519
  733546
  737533
  738307
  738335
  741937
  748579
  760252
  763378
  764486
  764638
  765053
  767403
  769213
  769422
  769610
  774006
  774255
  774583
  776785
  780936
  783689
  784060
  786312
  790746
  792292
  794970
  800419
  810201
  810576
  813625
  824003
]

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 (391102, 407335, 422150, 437515, 437959, 437986, 450149, 487364, 509293, 510869, 516999, 518317, 521731, 521785, 528814, 530824, 541582, 553683, 553713, 568462, 577632, 581988, 593193, 598300, 612581, 613848, 636441, 641919, 652674, 653330, 668961, 708148, 708450, 710419, 713509, 714943, 716546, 717229, 718980, 722918, 725451, 733316, 733519, 733546, 737533, 738307, 738335, 741937, 748579, 760252, 763378, 764486, 764638, 765053, 767403, 769213, 769422, 769610, 774006, 774255, 774583, 776785, 780936, 783689, 784060, 786312, 790746, 792292, 794970, 800419, 810201, 810576, 813625, 824003);

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
  391102
  407335
  422150
  437515
  437959
  437986
  450149
  487364
  509293
  510869
  516999
  518317
  521731
  521785
  528814
  530824
  541582
  553683
  553713
  568462
  577632
  581988
  593193
  598300
  612581
  613848
  636441
  641919
  652674
  653330
  668961
  708148
  708450
  710419
  713509
  714943
  716546
  717229
  718980
  722918
  725451
  733316
  733519
  733546
  737533
  738307
  738335
  741937
  748579
  760252
  763378
  764486
  764638
  765053
  767403
  769213
  769422
  769610
  774006
  774255
  774583
  776785
  780936
  783689
  784060
  786312
  790746
  792292
  794970
  800419
  810201
  810576
  813625
  824003
]

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 (391102, 407335, 422150, 437515, 437959, 437986, 450149, 487364, 509293, 510869, 516999, 518317, 521731, 521785, 528814, 530824, 541582, 553683, 553713, 568462, 577632, 581988, 593193, 598300, 612581, 613848, 636441, 641919, 652674, 653330, 668961, 708148, 708450, 710419, 713509, 714943, 716546, 717229, 718980, 722918, 725451, 733316, 733519, 733546, 737533, 738307, 738335, 741937, 748579, 760252, 763378, 764486, 764638, 765053, 767403, 769213, 769422, 769610, 774006, 774255, 774583, 776785, 780936, 783689, 784060, 786312, 790746, 792292, 794970, 800419, 810201, 810576, 813625, 824003);

SELECT `query_id` FROM `search_log` WHERE `query` = ?

[
  "глота load"
]

SELECT
  `query_id`
FROM
  `search_log`
WHERE
  `query` = ?

SELECT `query_id` FROM `search_log` WHERE `query` = 'глота load';

SELECT `trend_id` FROM `trend` WHERE `subject` = ?

[
  "глота load"
]

SELECT
  `trend_id`
FROM
  `trend`
WHERE
  `subject` = ?

SELECT `trend_id` FROM `trend` WHERE `subject` = 'глота load';

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 ?

[
  "swallow a load"
  "swallow a load"
  "swallow a load"
  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 ('swallow a load') AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST ('swallow a load')
              AND `query` <> 'swallow a load'
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT 20
        ;