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

[
  "pickup granny"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'pickup granny' 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
  389391
  383565
  488024
  670498
  398555
  599794
  788177
  461367
  554524
  666809
  665513
  462256
  712806
  486494
  474859
  460395
  566171
  664283
  817963
  667294
  665419
  770117
  665115
  665391
  463163
  514335
  393441
  665867
  772883
  474870
  474115
  668861
  455051
  540509
  551924
  665229
  665850
  666123
  667209
  667317
  664840
  663439
  664836
  725369
  474876
  478573
  502024
  569419
  759658
  476262
  503828
  503842
  666138
  471890
  460186
  480291
  485733
  505642
  486483
  663420
  549234
  390929
  503553
  529312
  524900
  525138
  505688
  482367
  558286
  667695
  667646
  470685
  477200
  480290
]

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 (389391, 383565, 488024, 670498, 398555, 599794, 788177, 461367, 554524, 666809, 665513, 462256, 712806, 486494, 474859, 460395, 566171, 664283, 817963, 667294, 665419, 770117, 665115, 665391, 463163, 514335, 393441, 665867, 772883, 474870, 474115, 668861, 455051, 540509, 551924, 665229, 665850, 666123, 667209, 667317, 664840, 663439, 664836, 725369, 474876, 478573, 502024, 569419, 759658, 476262, 503828, 503842, 666138, 471890, 460186, 480291, 485733, 505642, 486483, 663420, 549234, 390929, 503553, 529312, 524900, 525138, 505688, 482367, 558286, 667695, 667646, 470685, 477200, 480290);

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
  383565
  389391
  390929
  393441
  398555
  455051
  460186
  460395
  461367
  462256
  463163
  470685
  471890
  474115
  474859
  474870
  474876
  476262
  477200
  478573
  480290
  480291
  482367
  485733
  486483
  486494
  488024
  502024
  503553
  503828
  503842
  505642
  505688
  514335
  524900
  525138
  529312
  540509
  549234
  551924
  554524
  558286
  566171
  569419
  599794
  663420
  663439
  664283
  664836
  664840
  665115
  665229
  665391
  665419
  665513
  665850
  665867
  666123
  666138
  666809
  667209
  667294
  667317
  667646
  667695
  668861
  670498
  712806
  725369
  759658
  770117
  772883
  788177
  817963
]

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 (383565, 389391, 390929, 393441, 398555, 455051, 460186, 460395, 461367, 462256, 463163, 470685, 471890, 474115, 474859, 474870, 474876, 476262, 477200, 478573, 480290, 480291, 482367, 485733, 486483, 486494, 488024, 502024, 503553, 503828, 503842, 505642, 505688, 514335, 524900, 525138, 529312, 540509, 549234, 551924, 554524, 558286, 566171, 569419, 599794, 663420, 663439, 664283, 664836, 664840, 665115, 665229, 665391, 665419, 665513, 665850, 665867, 666123, 666138, 666809, 667209, 667294, 667317, 667646, 667695, 668861, 670498, 712806, 725369, 759658, 770117, 772883, 788177, 817963);

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
  383565
  389391
  390929
  393441
  398555
  455051
  460186
  460395
  461367
  462256
  463163
  470685
  471890
  474115
  474859
  474870
  474876
  476262
  477200
  478573
  480290
  480291
  482367
  485733
  486483
  486494
  488024
  502024
  503553
  503828
  503842
  505642
  505688
  514335
  524900
  525138
  529312
  540509
  549234
  551924
  554524
  558286
  566171
  569419
  599794
  663420
  663439
  664283
  664836
  664840
  665115
  665229
  665391
  665419
  665513
  665850
  665867
  666123
  666138
  666809
  667209
  667294
  667317
  667646
  667695
  668861
  670498
  712806
  725369
  759658
  770117
  772883
  788177
  817963
]

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 (383565, 389391, 390929, 393441, 398555, 455051, 460186, 460395, 461367, 462256, 463163, 470685, 471890, 474115, 474859, 474870, 474876, 476262, 477200, 478573, 480290, 480291, 482367, 485733, 486483, 486494, 488024, 502024, 503553, 503828, 503842, 505642, 505688, 514335, 524900, 525138, 529312, 540509, 549234, 551924, 554524, 558286, 566171, 569419, 599794, 663420, 663439, 664283, 664836, 664840, 665115, 665229, 665391, 665419, 665513, 665850, 665867, 666123, 666138, 666809, 667209, 667294, 667317, 667646, 667695, 668861, 670498, 712806, 725369, 759658, 770117, 772883, 788177, 817963);

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

[
  "пикап granny"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'пикап granny';

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

[
  "пикап granny"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'пикап granny';

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 ?

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