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

[
  "наталью"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'наталью' 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
  755094
  705241
  783127
  776695
  606144
  789788
  755028
  781401
  648521
  592717
  809118
  742246
  701315
  743294
  735818
  747420
  800337
  665615
  703040
  589444
  754977
  705676
  602159
  74588
  539379
  499545
  541990
  708120
  661055
  608938
  737863
  766199
  776053
  463394
  457806
  435413
  493700
  561377
  645813
  599831
  808066
  479949
  524366
  532752
  485492
  560116
  705180
  592393
  475201
  462338
  434327
  479496
  441563
  455758
  430806
  430916
  494097
  557377
  600318
  444903
  479964
  553765
  635923
  477930
  478293
  519299
  495584
  574908
  687500
  601674
  602984
  644925
  494694
]

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 (755094, 705241, 783127, 776695, 606144, 789788, 755028, 781401, 648521, 592717, 809118, 742246, 701315, 743294, 735818, 747420, 800337, 665615, 703040, 589444, 754977, 705676, 602159, 74588, 539379, 499545, 541990, 708120, 661055, 608938, 737863, 766199, 776053, 463394, 457806, 435413, 493700, 561377, 645813, 599831, 808066, 479949, 524366, 532752, 485492, 560116, 705180, 592393, 475201, 462338, 434327, 479496, 441563, 455758, 430806, 430916, 494097, 557377, 600318, 444903, 479964, 553765, 635923, 477930, 478293, 519299, 495584, 574908, 687500, 601674, 602984, 644925, 494694);

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
  74588
  430806
  430916
  434327
  435413
  441563
  444903
  455758
  457806
  462338
  463394
  475201
  477930
  478293
  479496
  479949
  479964
  485492
  493700
  494097
  494694
  495584
  499545
  519299
  524366
  532752
  539379
  541990
  553765
  557377
  560116
  561377
  574908
  589444
  592393
  592717
  599831
  600318
  601674
  602159
  602984
  606144
  608938
  635923
  644925
  645813
  648521
  661055
  665615
  687500
  701315
  703040
  705180
  705241
  705676
  708120
  735818
  737863
  742246
  743294
  747420
  754977
  755028
  755094
  766199
  776053
  776695
  781401
  783127
  789788
  800337
  808066
  809118
]

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 (74588, 430806, 430916, 434327, 435413, 441563, 444903, 455758, 457806, 462338, 463394, 475201, 477930, 478293, 479496, 479949, 479964, 485492, 493700, 494097, 494694, 495584, 499545, 519299, 524366, 532752, 539379, 541990, 553765, 557377, 560116, 561377, 574908, 589444, 592393, 592717, 599831, 600318, 601674, 602159, 602984, 606144, 608938, 635923, 644925, 645813, 648521, 661055, 665615, 687500, 701315, 703040, 705180, 705241, 705676, 708120, 735818, 737863, 742246, 743294, 747420, 754977, 755028, 755094, 766199, 776053, 776695, 781401, 783127, 789788, 800337, 808066, 809118);

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
  74588
  430806
  430916
  434327
  435413
  441563
  444903
  455758
  457806
  462338
  463394
  475201
  477930
  478293
  479496
  479949
  479964
  485492
  493700
  494097
  494694
  495584
  499545
  519299
  524366
  532752
  539379
  541990
  553765
  557377
  560116
  561377
  574908
  589444
  592393
  592717
  599831
  600318
  601674
  602159
  602984
  606144
  608938
  635923
  644925
  645813
  648521
  661055
  665615
  687500
  701315
  703040
  705180
  705241
  705676
  708120
  735818
  737863
  742246
  743294
  747420
  754977
  755028
  755094
  766199
  776053
  776695
  781401
  783127
  789788
  800337
  808066
  809118
]

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 (74588, 430806, 430916, 434327, 435413, 441563, 444903, 455758, 457806, 462338, 463394, 475201, 477930, 478293, 479496, 479949, 479964, 485492, 493700, 494097, 494694, 495584, 499545, 519299, 524366, 532752, 539379, 541990, 553765, 557377, 560116, 561377, 574908, 589444, 592393, 592717, 599831, 600318, 601674, 602159, 602984, 606144, 608938, 635923, 644925, 645813, 648521, 661055, 665615, 687500, 701315, 703040, 705180, 705241, 705676, 708120, 735818, 737863, 742246, 743294, 747420, 754977, 755028, 755094, 766199, 776053, 776695, 781401, 783127, 789788, 800337, 808066, 809118);

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

[
  "натал"
]

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

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

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

[
  "натал"
]

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

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

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 ?

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