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

[
  "sister in-law"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'sister in-law' 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
  605890
  799318
  727831
  761190
  794101
  397557
  544423
  570150
  595838
  813566
  453744
  629412
  748480
  807802
  397901
  458320
  530552
  528851
  556400
  636065
  586672
  591790
  754223
  750773
  756703
  760626
  604978
  456976
  518450
  797910
  700901
  401383
  427326
  478705
  504751
  498434
  504752
  528351
  564190
  559833
  667253
  605671
  760705
  478999
  428154
  511511
  528731
  461394
  585050
  453568
  457182
  453334
  564177
  583361
  601724
  592898
  608620
  538340
  492110
  504765
  464111
  513832
  561481
  519578
  543565
  504776
  553190
  493958
  729171
  725087
  742370
  479773
]

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 (605890, 799318, 727831, 761190, 794101, 397557, 544423, 570150, 595838, 813566, 453744, 629412, 748480, 807802, 397901, 458320, 530552, 528851, 556400, 636065, 586672, 591790, 754223, 750773, 756703, 760626, 604978, 456976, 518450, 797910, 700901, 401383, 427326, 478705, 504751, 498434, 504752, 528351, 564190, 559833, 667253, 605671, 760705, 478999, 428154, 511511, 528731, 461394, 585050, 453568, 457182, 453334, 564177, 583361, 601724, 592898, 608620, 538340, 492110, 504765, 464111, 513832, 561481, 519578, 543565, 504776, 553190, 493958, 729171, 725087, 742370, 479773);

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
  397557
  397901
  401383
  427326
  428154
  453334
  453568
  453744
  456976
  457182
  458320
  461394
  464111
  478705
  478999
  479773
  492110
  493958
  498434
  504751
  504752
  504765
  504776
  511511
  513832
  518450
  519578
  528351
  528731
  528851
  530552
  538340
  543565
  544423
  553190
  556400
  559833
  561481
  564177
  564190
  570150
  583361
  585050
  586672
  591790
  592898
  595838
  601724
  604978
  605671
  605890
  608620
  629412
  636065
  667253
  700901
  725087
  727831
  729171
  742370
  748480
  750773
  754223
  756703
  760626
  760705
  761190
  794101
  797910
  799318
  807802
  813566
]

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 (397557, 397901, 401383, 427326, 428154, 453334, 453568, 453744, 456976, 457182, 458320, 461394, 464111, 478705, 478999, 479773, 492110, 493958, 498434, 504751, 504752, 504765, 504776, 511511, 513832, 518450, 519578, 528351, 528731, 528851, 530552, 538340, 543565, 544423, 553190, 556400, 559833, 561481, 564177, 564190, 570150, 583361, 585050, 586672, 591790, 592898, 595838, 601724, 604978, 605671, 605890, 608620, 629412, 636065, 667253, 700901, 725087, 727831, 729171, 742370, 748480, 750773, 754223, 756703, 760626, 760705, 761190, 794101, 797910, 799318, 807802, 813566);

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
  397557
  397901
  401383
  427326
  428154
  453334
  453568
  453744
  456976
  457182
  458320
  461394
  464111
  478705
  478999
  479773
  492110
  493958
  498434
  504751
  504752
  504765
  504776
  511511
  513832
  518450
  519578
  528351
  528731
  528851
  530552
  538340
  543565
  544423
  553190
  556400
  559833
  561481
  564177
  564190
  570150
  583361
  585050
  586672
  591790
  592898
  595838
  601724
  604978
  605671
  605890
  608620
  629412
  636065
  667253
  700901
  725087
  727831
  729171
  742370
  748480
  750773
  754223
  756703
  760626
  760705
  761190
  794101
  797910
  799318
  807802
  813566
]

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 (397557, 397901, 401383, 427326, 428154, 453334, 453568, 453744, 456976, 457182, 458320, 461394, 464111, 478705, 478999, 479773, 492110, 493958, 498434, 504751, 504752, 504765, 504776, 511511, 513832, 518450, 519578, 528351, 528731, 528851, 530552, 538340, 543565, 544423, 553190, 556400, 559833, 561481, 564177, 564190, 570150, 583361, 585050, 586672, 591790, 592898, 595838, 601724, 604978, 605671, 605890, 608620, 629412, 636065, 667253, 700901, 725087, 727831, 729171, 742370, 748480, 750773, 754223, 756703, 760626, 760705, 761190, 794101, 797910, 799318, 807802, 813566);

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

[
  "sister law"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'sister law';

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

[
  "sister law"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'sister law';

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 ?

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