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

[
  "office boss hidden"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'office boss hidden' 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
  630848
  702379
  727495
  701230
  793366
  760882
  702355
  818750
  714558
  438110
  541406
  701160
  698614
  644640
  494678
  471966
  397904
  698618
  746066
  827203
  804979
  625282
  472303
  428155
  555652
  805124
  486233
  619683
  438011
  485069
  795435
  734630
  425870
  437985
  711589
  490816
  498846
  509167
  609402
  456188
  694122
  698356
  826593
  787276
  604783
  443974
  588345
  805125
  545909
  526884
  642934
  455619
  526882
  599588
  727006
  500720
  615838
  493914
  721773
  552754
  456194
  600800
  748799
  459256
  526877
  596557
  771757
  521168
  447971
  444734
  494680
  508293
  520930
]

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 (630848, 702379, 727495, 701230, 793366, 760882, 702355, 818750, 714558, 438110, 541406, 701160, 698614, 644640, 494678, 471966, 397904, 698618, 746066, 827203, 804979, 625282, 472303, 428155, 555652, 805124, 486233, 619683, 438011, 485069, 795435, 734630, 425870, 437985, 711589, 490816, 498846, 509167, 609402, 456188, 694122, 698356, 826593, 787276, 604783, 443974, 588345, 805125, 545909, 526884, 642934, 455619, 526882, 599588, 727006, 500720, 615838, 493914, 721773, 552754, 456194, 600800, 748799, 459256, 526877, 596557, 771757, 521168, 447971, 444734, 494680, 508293, 520930);

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
  397904
  425870
  428155
  437985
  438011
  438110
  443974
  444734
  447971
  455619
  456188
  456194
  459256
  471966
  472303
  485069
  486233
  490816
  493914
  494678
  494680
  498846
  500720
  508293
  509167
  520930
  521168
  526877
  526882
  526884
  541406
  545909
  552754
  555652
  588345
  596557
  599588
  600800
  604783
  609402
  615838
  619683
  625282
  630848
  642934
  644640
  694122
  698356
  698614
  698618
  701160
  701230
  702355
  702379
  711589
  714558
  721773
  727006
  727495
  734630
  746066
  748799
  760882
  771757
  787276
  793366
  795435
  804979
  805124
  805125
  818750
  826593
  827203
]

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 (397904, 425870, 428155, 437985, 438011, 438110, 443974, 444734, 447971, 455619, 456188, 456194, 459256, 471966, 472303, 485069, 486233, 490816, 493914, 494678, 494680, 498846, 500720, 508293, 509167, 520930, 521168, 526877, 526882, 526884, 541406, 545909, 552754, 555652, 588345, 596557, 599588, 600800, 604783, 609402, 615838, 619683, 625282, 630848, 642934, 644640, 694122, 698356, 698614, 698618, 701160, 701230, 702355, 702379, 711589, 714558, 721773, 727006, 727495, 734630, 746066, 748799, 760882, 771757, 787276, 793366, 795435, 804979, 805124, 805125, 818750, 826593, 827203);

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
  397904
  425870
  428155
  437985
  438011
  438110
  443974
  444734
  447971
  455619
  456188
  456194
  459256
  471966
  472303
  485069
  486233
  490816
  493914
  494678
  494680
  498846
  500720
  508293
  509167
  520930
  521168
  526877
  526882
  526884
  541406
  545909
  552754
  555652
  588345
  596557
  599588
  600800
  604783
  609402
  615838
  619683
  625282
  630848
  642934
  644640
  694122
  698356
  698614
  698618
  701160
  701230
  702355
  702379
  711589
  714558
  721773
  727006
  727495
  734630
  746066
  748799
  760882
  771757
  787276
  793366
  795435
  804979
  805124
  805125
  818750
  826593
  827203
]

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 (397904, 425870, 428155, 437985, 438011, 438110, 443974, 444734, 447971, 455619, 456188, 456194, 459256, 471966, 472303, 485069, 486233, 490816, 493914, 494678, 494680, 498846, 500720, 508293, 509167, 520930, 521168, 526877, 526882, 526884, 541406, 545909, 552754, 555652, 588345, 596557, 599588, 600800, 604783, 609402, 615838, 619683, 625282, 630848, 642934, 644640, 694122, 698356, 698614, 698618, 701160, 701230, 702355, 702379, 711589, 714558, 721773, 727006, 727495, 734630, 746066, 748799, 760882, 771757, 787276, 793366, 795435, 804979, 805124, 805125, 818750, 826593, 827203);

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

[
  "секретарш boss скрыт"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'секретарш boss скрыт';

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

[
  "секретарш boss скрыт"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'секретарш boss скрыт';

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 ?

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