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

[
  "first bbc anal"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'first bbc anal' 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
  634199
  634556
  443476
  475479
  531215
  404732
  680206
  679816
  550307
  642775
  677773
  678127
  680203
  642691
  632979
  624175
  640797
  396746
  674962
  443480
  416365
  531116
  679728
  678533
  593886
  633798
  636303
  631193
  414621
  474621
  677294
  708447
  637044
  633749
  634118
  467608
  591612
  537660
  531097
  533645
  530499
  537672
  650774
  630297
  633795
  637121
  641678
  623198
  628091
  633753
  633799
  642043
  637036
  538803
  424876
  649525
  599913
  637101
  537648
  643103
  412189
  645019
  668505
  592034
  637442
  634218
  628082
  553272
  633449
  521576
  667736
  678097
  628117
]

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 (634199, 634556, 443476, 475479, 531215, 404732, 680206, 679816, 550307, 642775, 677773, 678127, 680203, 642691, 632979, 624175, 640797, 396746, 674962, 443480, 416365, 531116, 679728, 678533, 593886, 633798, 636303, 631193, 414621, 474621, 677294, 708447, 637044, 633749, 634118, 467608, 591612, 537660, 531097, 533645, 530499, 537672, 650774, 630297, 633795, 637121, 641678, 623198, 628091, 633753, 633799, 642043, 637036, 538803, 424876, 649525, 599913, 637101, 537648, 643103, 412189, 645019, 668505, 592034, 637442, 634218, 628082, 553272, 633449, 521576, 667736, 678097, 628117);

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
  396746
  404732
  412189
  414621
  416365
  424876
  443476
  443480
  467608
  474621
  475479
  521576
  530499
  531097
  531116
  531215
  533645
  537648
  537660
  537672
  538803
  550307
  553272
  591612
  592034
  593886
  599913
  623198
  624175
  628082
  628091
  628117
  630297
  631193
  632979
  633449
  633749
  633753
  633795
  633798
  633799
  634118
  634199
  634218
  634556
  636303
  637036
  637044
  637101
  637121
  637442
  640797
  641678
  642043
  642691
  642775
  643103
  645019
  649525
  650774
  667736
  668505
  674962
  677294
  677773
  678097
  678127
  678533
  679728
  679816
  680203
  680206
  708447
]

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 (396746, 404732, 412189, 414621, 416365, 424876, 443476, 443480, 467608, 474621, 475479, 521576, 530499, 531097, 531116, 531215, 533645, 537648, 537660, 537672, 538803, 550307, 553272, 591612, 592034, 593886, 599913, 623198, 624175, 628082, 628091, 628117, 630297, 631193, 632979, 633449, 633749, 633753, 633795, 633798, 633799, 634118, 634199, 634218, 634556, 636303, 637036, 637044, 637101, 637121, 637442, 640797, 641678, 642043, 642691, 642775, 643103, 645019, 649525, 650774, 667736, 668505, 674962, 677294, 677773, 678097, 678127, 678533, 679728, 679816, 680203, 680206, 708447);

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
  396746
  404732
  412189
  414621
  416365
  424876
  443476
  443480
  467608
  474621
  475479
  521576
  530499
  531097
  531116
  531215
  533645
  537648
  537660
  537672
  538803
  550307
  553272
  591612
  592034
  593886
  599913
  623198
  624175
  628082
  628091
  628117
  630297
  631193
  632979
  633449
  633749
  633753
  633795
  633798
  633799
  634118
  634199
  634218
  634556
  636303
  637036
  637044
  637101
  637121
  637442
  640797
  641678
  642043
  642691
  642775
  643103
  645019
  649525
  650774
  667736
  668505
  674962
  677294
  677773
  678097
  678127
  678533
  679728
  679816
  680203
  680206
  708447
]

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 (396746, 404732, 412189, 414621, 416365, 424876, 443476, 443480, 467608, 474621, 475479, 521576, 530499, 531097, 531116, 531215, 533645, 537648, 537660, 537672, 538803, 550307, 553272, 591612, 592034, 593886, 599913, 623198, 624175, 628082, 628091, 628117, 630297, 631193, 632979, 633449, 633749, 633753, 633795, 633798, 633799, 634118, 634199, 634218, 634556, 636303, 637036, 637044, 637101, 637121, 637442, 640797, 641678, 642043, 642691, 642775, 643103, 645019, 649525, 650774, 667736, 668505, 674962, 677294, 677773, 678097, 678127, 678533, 679728, 679816, 680203, 680206, 708447);

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

[
  "first bbc анал"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'first bbc анал';

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

[
  "first bbc анал"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'first bbc анал';

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 ?

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