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

[
  "vagina contractions"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'vagina contractions' 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
  514922
  793125
  631131
  801815
  748966
  825227
  399540
  508917
  31822
  819713
  544051
  610969
  796367
  728888
  706643
  616837
  399525
  693084
  756335
  806821
  748280
  399541
  825129
  584295
  397689
  796388
  435603
  607965
  689057
  729262
  435602
  445227
  800977
  750633
  435632
  490632
  508899
  634066
  513827
  514253
  527469
  446419
  810070
  442800
  748262
  768229
  707478
  510924
  710783
  768526
  773050
  444081
  435618
  435635
  420442
  617583
  510737
  579405
  614066
  451305
  802275
  488594
  505803
  647236
  520412
  486559
  474805
  500947
  619166
  618268
  511837
]

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 (514922, 793125, 631131, 801815, 748966, 825227, 399540, 508917, 31822, 819713, 544051, 610969, 796367, 728888, 706643, 616837, 399525, 693084, 756335, 806821, 748280, 399541, 825129, 584295, 397689, 796388, 435603, 607965, 689057, 729262, 435602, 445227, 800977, 750633, 435632, 490632, 508899, 634066, 513827, 514253, 527469, 446419, 810070, 442800, 748262, 768229, 707478, 510924, 710783, 768526, 773050, 444081, 435618, 435635, 420442, 617583, 510737, 579405, 614066, 451305, 802275, 488594, 505803, 647236, 520412, 486559, 474805, 500947, 619166, 618268, 511837);

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
  31822
  397689
  399525
  399540
  399541
  420442
  435602
  435603
  435618
  435632
  435635
  442800
  444081
  445227
  446419
  451305
  474805
  486559
  488594
  490632
  500947
  505803
  508899
  508917
  510737
  510924
  511837
  513827
  514253
  514922
  520412
  527469
  544051
  579405
  584295
  607965
  610969
  614066
  616837
  617583
  618268
  619166
  631131
  634066
  647236
  689057
  693084
  706643
  707478
  710783
  728888
  729262
  748262
  748280
  748966
  750633
  756335
  768229
  768526
  773050
  793125
  796367
  796388
  800977
  801815
  802275
  806821
  810070
  819713
  825129
  825227
]

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 (31822, 397689, 399525, 399540, 399541, 420442, 435602, 435603, 435618, 435632, 435635, 442800, 444081, 445227, 446419, 451305, 474805, 486559, 488594, 490632, 500947, 505803, 508899, 508917, 510737, 510924, 511837, 513827, 514253, 514922, 520412, 527469, 544051, 579405, 584295, 607965, 610969, 614066, 616837, 617583, 618268, 619166, 631131, 634066, 647236, 689057, 693084, 706643, 707478, 710783, 728888, 729262, 748262, 748280, 748966, 750633, 756335, 768229, 768526, 773050, 793125, 796367, 796388, 800977, 801815, 802275, 806821, 810070, 819713, 825129, 825227);

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
  31822
  397689
  399525
  399540
  399541
  420442
  435602
  435603
  435618
  435632
  435635
  442800
  444081
  445227
  446419
  451305
  474805
  486559
  488594
  490632
  500947
  505803
  508899
  508917
  510737
  510924
  511837
  513827
  514253
  514922
  520412
  527469
  544051
  579405
  584295
  607965
  610969
  614066
  616837
  617583
  618268
  619166
  631131
  634066
  647236
  689057
  693084
  706643
  707478
  710783
  728888
  729262
  748262
  748280
  748966
  750633
  756335
  768229
  768526
  773050
  793125
  796367
  796388
  800977
  801815
  802275
  806821
  810070
  819713
  825129
  825227
]

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 (31822, 397689, 399525, 399540, 399541, 420442, 435602, 435603, 435618, 435632, 435635, 442800, 444081, 445227, 446419, 451305, 474805, 486559, 488594, 490632, 500947, 505803, 508899, 508917, 510737, 510924, 511837, 513827, 514253, 514922, 520412, 527469, 544051, 579405, 584295, 607965, 610969, 614066, 616837, 617583, 618268, 619166, 631131, 634066, 647236, 689057, 693084, 706643, 707478, 710783, 728888, 729262, 748262, 748280, 748966, 750633, 756335, 768229, 768526, 773050, 793125, 796367, 796388, 800977, 801815, 802275, 806821, 810070, 819713, 825129, 825227);

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

[
  "вагин contractions"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'вагин contractions';

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

[
  "вагин contractions"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'вагин contractions';

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 ?

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