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

[
  "link in"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'link in' 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
  621369
  464689
  803055
  633816
  613755
  531255
  535500
  566009
  642601
  540832
  529815
  530346
  534867
  565999
  585828
  636954
  631012
  531662
  682846
  652368
  616634
  784480
  532672
  554788
  566005
  633477
  621026
  459325
  565991
  653079
  650143
  629356
  772976
  743506
  459120
  524337
  527887
  566015
  566016
  579672
  579797
  565996
  791117
  530434
  538547
  566011
  565998
  566008
  687060
  653801
  566001
  592814
  526441
  535116
  530282
  559909
  566014
  630908
  629394
  528504
  505340
  600347
  630910
  457759
  530079
  566002
  566074
  566003
  630575
  618272
  604790
  707370
  457758
  603776
]

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 (621369, 464689, 803055, 633816, 613755, 531255, 535500, 566009, 642601, 540832, 529815, 530346, 534867, 565999, 585828, 636954, 631012, 531662, 682846, 652368, 616634, 784480, 532672, 554788, 566005, 633477, 621026, 459325, 565991, 653079, 650143, 629356, 772976, 743506, 459120, 524337, 527887, 566015, 566016, 579672, 579797, 565996, 791117, 530434, 538547, 566011, 565998, 566008, 687060, 653801, 566001, 592814, 526441, 535116, 530282, 559909, 566014, 630908, 629394, 528504, 505340, 600347, 630910, 457759, 530079, 566002, 566074, 566003, 630575, 618272, 604790, 707370, 457758, 603776);

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
  457758
  457759
  459120
  459325
  464689
  505340
  524337
  526441
  527887
  528504
  529815
  530079
  530282
  530346
  530434
  531255
  531662
  532672
  534867
  535116
  535500
  538547
  540832
  554788
  559909
  565991
  565996
  565998
  565999
  566001
  566002
  566003
  566005
  566008
  566009
  566011
  566014
  566015
  566016
  566074
  579672
  579797
  585828
  592814
  600347
  603776
  604790
  613755
  616634
  618272
  621026
  621369
  629356
  629394
  630575
  630908
  630910
  631012
  633477
  633816
  636954
  642601
  650143
  652368
  653079
  653801
  682846
  687060
  707370
  743506
  772976
  784480
  791117
  803055
]

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 (457758, 457759, 459120, 459325, 464689, 505340, 524337, 526441, 527887, 528504, 529815, 530079, 530282, 530346, 530434, 531255, 531662, 532672, 534867, 535116, 535500, 538547, 540832, 554788, 559909, 565991, 565996, 565998, 565999, 566001, 566002, 566003, 566005, 566008, 566009, 566011, 566014, 566015, 566016, 566074, 579672, 579797, 585828, 592814, 600347, 603776, 604790, 613755, 616634, 618272, 621026, 621369, 629356, 629394, 630575, 630908, 630910, 631012, 633477, 633816, 636954, 642601, 650143, 652368, 653079, 653801, 682846, 687060, 707370, 743506, 772976, 784480, 791117, 803055);

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
  457758
  457759
  459120
  459325
  464689
  505340
  524337
  526441
  527887
  528504
  529815
  530079
  530282
  530346
  530434
  531255
  531662
  532672
  534867
  535116
  535500
  538547
  540832
  554788
  559909
  565991
  565996
  565998
  565999
  566001
  566002
  566003
  566005
  566008
  566009
  566011
  566014
  566015
  566016
  566074
  579672
  579797
  585828
  592814
  600347
  603776
  604790
  613755
  616634
  618272
  621026
  621369
  629356
  629394
  630575
  630908
  630910
  631012
  633477
  633816
  636954
  642601
  650143
  652368
  653079
  653801
  682846
  687060
  707370
  743506
  772976
  784480
  791117
  803055
]

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 (457758, 457759, 459120, 459325, 464689, 505340, 524337, 526441, 527887, 528504, 529815, 530079, 530282, 530346, 530434, 531255, 531662, 532672, 534867, 535116, 535500, 538547, 540832, 554788, 559909, 565991, 565996, 565998, 565999, 566001, 566002, 566003, 566005, 566008, 566009, 566011, 566014, 566015, 566016, 566074, 579672, 579797, 585828, 592814, 600347, 603776, 604790, 613755, 616634, 618272, 621026, 621369, 629356, 629394, 630575, 630908, 630910, 631012, 633477, 633816, 636954, 642601, 650143, 652368, 653079, 653801, 682846, 687060, 707370, 743506, 772976, 784480, 791117, 803055);

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

[
  "link"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'link';

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

[
  "link"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'link';

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 ?

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