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
  487758
  399422
  473634
  396629
  570941
  384588
  706889
  411626
  489921
  570942
  460682
  420311
  525884
  414133
  445464
  563729
  466813
  475688
  420280
  460680
  580921
  397019
  467050
  472698
  474194
  464364
  469558
  413534
  407501
  426294
  443405
  462701
  475680
  382502
  474813
  472665
  463976
  413461
  427561
  423641
  469285
  474114
  525490
  526983
  510233
  527476
  475660
  405252
  460908
  470918
  420178
  472640
  618622
  426295
  425967
  463803
  474087
  584366
  615913
  467066
  464944
  502467
  418522
  482304
  496554
  453409
  427364
  414131
  475891
]

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 (487758, 399422, 473634, 396629, 570941, 384588, 706889, 411626, 489921, 570942, 460682, 420311, 525884, 414133, 445464, 563729, 466813, 475688, 420280, 460680, 580921, 397019, 467050, 472698, 474194, 464364, 469558, 413534, 407501, 426294, 443405, 462701, 475680, 382502, 474813, 472665, 463976, 413461, 427561, 423641, 469285, 474114, 525490, 526983, 510233, 527476, 475660, 405252, 460908, 470918, 420178, 472640, 618622, 426295, 425967, 463803, 474087, 584366, 615913, 467066, 464944, 502467, 418522, 482304, 496554, 453409, 427364, 414131, 475891);

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
  382502
  384588
  396629
  397019
  399422
  405252
  407501
  411626
  413461
  413534
  414131
  414133
  418522
  420178
  420280
  420311
  423641
  425967
  426294
  426295
  427364
  427561
  443405
  445464
  453409
  460680
  460682
  460908
  462701
  463803
  463976
  464364
  464944
  466813
  467050
  467066
  469285
  469558
  470918
  472640
  472665
  472698
  473634
  474087
  474114
  474194
  474813
  475660
  475680
  475688
  475891
  482304
  487758
  489921
  496554
  502467
  510233
  525490
  525884
  526983
  527476
  563729
  570941
  570942
  580921
  584366
  615913
  618622
  706889
]

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 (382502, 384588, 396629, 397019, 399422, 405252, 407501, 411626, 413461, 413534, 414131, 414133, 418522, 420178, 420280, 420311, 423641, 425967, 426294, 426295, 427364, 427561, 443405, 445464, 453409, 460680, 460682, 460908, 462701, 463803, 463976, 464364, 464944, 466813, 467050, 467066, 469285, 469558, 470918, 472640, 472665, 472698, 473634, 474087, 474114, 474194, 474813, 475660, 475680, 475688, 475891, 482304, 487758, 489921, 496554, 502467, 510233, 525490, 525884, 526983, 527476, 563729, 570941, 570942, 580921, 584366, 615913, 618622, 706889);

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
  382502
  384588
  396629
  397019
  399422
  405252
  407501
  411626
  413461
  413534
  414131
  414133
  418522
  420178
  420280
  420311
  423641
  425967
  426294
  426295
  427364
  427561
  443405
  445464
  453409
  460680
  460682
  460908
  462701
  463803
  463976
  464364
  464944
  466813
  467050
  467066
  469285
  469558
  470918
  472640
  472665
  472698
  473634
  474087
  474114
  474194
  474813
  475660
  475680
  475688
  475891
  482304
  487758
  489921
  496554
  502467
  510233
  525490
  525884
  526983
  527476
  563729
  570941
  570942
  580921
  584366
  615913
  618622
  706889
]

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 (382502, 384588, 396629, 397019, 399422, 405252, 407501, 411626, 413461, 413534, 414131, 414133, 418522, 420178, 420280, 420311, 423641, 425967, 426294, 426295, 427364, 427561, 443405, 445464, 453409, 460680, 460682, 460908, 462701, 463803, 463976, 464364, 464944, 466813, 467050, 467066, 469285, 469558, 470918, 472640, 472665, 472698, 473634, 474087, 474114, 474194, 474813, 475660, 475680, 475688, 475891, 482304, 487758, 489921, 496554, 502467, 510233, 525490, 525884, 526983, 527476, 563729, 570941, 570942, 580921, 584366, 615913, 618622, 706889);

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
        ;