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

[
  "group swallow"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'group swallow' 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
  677783
  696213
  645284
  646427
  695122
  634115
  638298
  634774
  639796
  615717
  630764
  599922
  600218
  632978
  635215
  644916
  531155
  531420
  545389
  545410
  647948
  651674
  676428
  685701
  695181
  707391
  666880
  666894
  695123
  545372
  599880
  599927
  600252
  628332
  628336
  630533
  630546
  634140
  636306
  639334
  641953
  600021
  600360
  599865
  628383
  636300
  639719
  639745
  601578
  628371
  630552
  634218
  637148
  641996
  529794
  533746
  529792
  545460
  559178
  647860
  648257
  666850
  628333
  630531
  633435
  633502
  639751
  641978
  637413
  630280
  533915
  635275
  617420
]

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 (677783, 696213, 645284, 646427, 695122, 634115, 638298, 634774, 639796, 615717, 630764, 599922, 600218, 632978, 635215, 644916, 531155, 531420, 545389, 545410, 647948, 651674, 676428, 685701, 695181, 707391, 666880, 666894, 695123, 545372, 599880, 599927, 600252, 628332, 628336, 630533, 630546, 634140, 636306, 639334, 641953, 600021, 600360, 599865, 628383, 636300, 639719, 639745, 601578, 628371, 630552, 634218, 637148, 641996, 529794, 533746, 529792, 545460, 559178, 647860, 648257, 666850, 628333, 630531, 633435, 633502, 639751, 641978, 637413, 630280, 533915, 635275, 617420);

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
  529792
  529794
  531155
  531420
  533746
  533915
  545372
  545389
  545410
  545460
  559178
  599865
  599880
  599922
  599927
  600021
  600218
  600252
  600360
  601578
  615717
  617420
  628332
  628333
  628336
  628371
  628383
  630280
  630531
  630533
  630546
  630552
  630764
  632978
  633435
  633502
  634115
  634140
  634218
  634774
  635215
  635275
  636300
  636306
  637148
  637413
  638298
  639334
  639719
  639745
  639751
  639796
  641953
  641978
  641996
  644916
  645284
  646427
  647860
  647948
  648257
  651674
  666850
  666880
  666894
  676428
  677783
  685701
  695122
  695123
  695181
  696213
  707391
]

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 (529792, 529794, 531155, 531420, 533746, 533915, 545372, 545389, 545410, 545460, 559178, 599865, 599880, 599922, 599927, 600021, 600218, 600252, 600360, 601578, 615717, 617420, 628332, 628333, 628336, 628371, 628383, 630280, 630531, 630533, 630546, 630552, 630764, 632978, 633435, 633502, 634115, 634140, 634218, 634774, 635215, 635275, 636300, 636306, 637148, 637413, 638298, 639334, 639719, 639745, 639751, 639796, 641953, 641978, 641996, 644916, 645284, 646427, 647860, 647948, 648257, 651674, 666850, 666880, 666894, 676428, 677783, 685701, 695122, 695123, 695181, 696213, 707391);

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
  529792
  529794
  531155
  531420
  533746
  533915
  545372
  545389
  545410
  545460
  559178
  599865
  599880
  599922
  599927
  600021
  600218
  600252
  600360
  601578
  615717
  617420
  628332
  628333
  628336
  628371
  628383
  630280
  630531
  630533
  630546
  630552
  630764
  632978
  633435
  633502
  634115
  634140
  634218
  634774
  635215
  635275
  636300
  636306
  637148
  637413
  638298
  639334
  639719
  639745
  639751
  639796
  641953
  641978
  641996
  644916
  645284
  646427
  647860
  647948
  648257
  651674
  666850
  666880
  666894
  676428
  677783
  685701
  695122
  695123
  695181
  696213
  707391
]

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 (529792, 529794, 531155, 531420, 533746, 533915, 545372, 545389, 545410, 545460, 559178, 599865, 599880, 599922, 599927, 600021, 600218, 600252, 600360, 601578, 615717, 617420, 628332, 628333, 628336, 628371, 628383, 630280, 630531, 630533, 630546, 630552, 630764, 632978, 633435, 633502, 634115, 634140, 634218, 634774, 635215, 635275, 636300, 636306, 637148, 637413, 638298, 639334, 639719, 639745, 639751, 639796, 641953, 641978, 641996, 644916, 645284, 646427, 647860, 647948, 648257, 651674, 666850, 666880, 666894, 676428, 677783, 685701, 695122, 695123, 695181, 696213, 707391);

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

[
  "group глота"
]

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

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

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

[
  "group глота"
]

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

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

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 ?

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