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

[
  "doggy style boobs"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'doggy style boobs' 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
  663866
  662454
  711569
  579578
  640260
  788810
  726502
  733480
  769290
  725514
  758224
  720645
  819262
  457603
  634671
  515065
  694142
  499054
  684704
  631701
  739557
  492088
  456730
  458882
  509867
  697457
  564048
  564054
  584453
  607181
  615170
  741504
  385265
  385963
  440629
  458080
  742636
  761039
  451115
  555984
  681539
  391277
  514711
  469009
  501681
  385141
  588956
  439749
  514264
  439731
  24931
  389364
  563880
  563883
  609161
  591022
  597207
  514375
  415576
  425660
  416397
  447895
  604901
  440631
  571734
  454107
  507640
  518586
  554770
  447679
  504610
  562790
]

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 (663866, 662454, 711569, 579578, 640260, 788810, 726502, 733480, 769290, 725514, 758224, 720645, 819262, 457603, 634671, 515065, 694142, 499054, 684704, 631701, 739557, 492088, 456730, 458882, 509867, 697457, 564048, 564054, 584453, 607181, 615170, 741504, 385265, 385963, 440629, 458080, 742636, 761039, 451115, 555984, 681539, 391277, 514711, 469009, 501681, 385141, 588956, 439749, 514264, 439731, 24931, 389364, 563880, 563883, 609161, 591022, 597207, 514375, 415576, 425660, 416397, 447895, 604901, 440631, 571734, 454107, 507640, 518586, 554770, 447679, 504610, 562790);

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
  24931
  385141
  385265
  385963
  389364
  391277
  415576
  416397
  425660
  439731
  439749
  440629
  440631
  447679
  447895
  451115
  454107
  456730
  457603
  458080
  458882
  469009
  492088
  499054
  501681
  504610
  507640
  509867
  514264
  514375
  514711
  515065
  518586
  554770
  555984
  562790
  563880
  563883
  564048
  564054
  571734
  579578
  584453
  588956
  591022
  597207
  604901
  607181
  609161
  615170
  631701
  634671
  640260
  662454
  663866
  681539
  684704
  694142
  697457
  711569
  720645
  725514
  726502
  733480
  739557
  741504
  742636
  758224
  761039
  769290
  788810
  819262
]

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 (24931, 385141, 385265, 385963, 389364, 391277, 415576, 416397, 425660, 439731, 439749, 440629, 440631, 447679, 447895, 451115, 454107, 456730, 457603, 458080, 458882, 469009, 492088, 499054, 501681, 504610, 507640, 509867, 514264, 514375, 514711, 515065, 518586, 554770, 555984, 562790, 563880, 563883, 564048, 564054, 571734, 579578, 584453, 588956, 591022, 597207, 604901, 607181, 609161, 615170, 631701, 634671, 640260, 662454, 663866, 681539, 684704, 694142, 697457, 711569, 720645, 725514, 726502, 733480, 739557, 741504, 742636, 758224, 761039, 769290, 788810, 819262);

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
  24931
  385141
  385265
  385963
  389364
  391277
  415576
  416397
  425660
  439731
  439749
  440629
  440631
  447679
  447895
  451115
  454107
  456730
  457603
  458080
  458882
  469009
  492088
  499054
  501681
  504610
  507640
  509867
  514264
  514375
  514711
  515065
  518586
  554770
  555984
  562790
  563880
  563883
  564048
  564054
  571734
  579578
  584453
  588956
  591022
  597207
  604901
  607181
  609161
  615170
  631701
  634671
  640260
  662454
  663866
  681539
  684704
  694142
  697457
  711569
  720645
  725514
  726502
  733480
  739557
  741504
  742636
  758224
  761039
  769290
  788810
  819262
]

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 (24931, 385141, 385265, 385963, 389364, 391277, 415576, 416397, 425660, 439731, 439749, 440629, 440631, 447679, 447895, 451115, 454107, 456730, 457603, 458080, 458882, 469009, 492088, 499054, 501681, 504610, 507640, 509867, 514264, 514375, 514711, 515065, 518586, 554770, 555984, 562790, 563880, 563883, 564048, 564054, 571734, 579578, 584453, 588956, 591022, 597207, 604901, 607181, 609161, 615170, 631701, 634671, 640260, 662454, 663866, 681539, 684704, 694142, 697457, 711569, 720645, 725514, 726502, 733480, 739557, 741504, 742636, 758224, 761039, 769290, 788810, 819262);

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

[
  "рак style boobs"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'рак style boobs';

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

[
  "рак style boobs"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'рак style boobs';

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 ?

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