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

[
  "cum my panties"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'cum my panties' 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
  498289
  757145
  553970
  556524
  581719
  441971
  427068
  466706
  581128
  625556
  549083
  619003
  475506
  524481
  511507
  577095
  556997
  577261
  599744
  602695
  446212
  452766
  394737
  456350
  504946
  508478
  479165
  432690
  446921
  457873
  531384
  583577
  571126
  580672
  630461
  596714
  454035
  487393
  513157
  555025
  571829
  630328
  625520
  475208
  455451
  498825
  527359
  519510
  527794
  443420
  511919
  486876
  562869
  558183
  564880
  568914
  584421
  611290
  396526
  456268
  474279
  515893
  514375
  509672
  446431
  588070
  558338
  590599
  607176
  603878
  617597
  625861
  514782
]

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 (498289, 757145, 553970, 556524, 581719, 441971, 427068, 466706, 581128, 625556, 549083, 619003, 475506, 524481, 511507, 577095, 556997, 577261, 599744, 602695, 446212, 452766, 394737, 456350, 504946, 508478, 479165, 432690, 446921, 457873, 531384, 583577, 571126, 580672, 630461, 596714, 454035, 487393, 513157, 555025, 571829, 630328, 625520, 475208, 455451, 498825, 527359, 519510, 527794, 443420, 511919, 486876, 562869, 558183, 564880, 568914, 584421, 611290, 396526, 456268, 474279, 515893, 514375, 509672, 446431, 588070, 558338, 590599, 607176, 603878, 617597, 625861, 514782);

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
  394737
  396526
  427068
  432690
  441971
  443420
  446212
  446431
  446921
  452766
  454035
  455451
  456268
  456350
  457873
  466706
  474279
  475208
  475506
  479165
  486876
  487393
  498289
  498825
  504946
  508478
  509672
  511507
  511919
  513157
  514375
  514782
  515893
  519510
  524481
  527359
  527794
  531384
  549083
  553970
  555025
  556524
  556997
  558183
  558338
  562869
  564880
  568914
  571126
  571829
  577095
  577261
  580672
  581128
  581719
  583577
  584421
  588070
  590599
  596714
  599744
  602695
  603878
  607176
  611290
  617597
  619003
  625520
  625556
  625861
  630328
  630461
  757145
]

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 (394737, 396526, 427068, 432690, 441971, 443420, 446212, 446431, 446921, 452766, 454035, 455451, 456268, 456350, 457873, 466706, 474279, 475208, 475506, 479165, 486876, 487393, 498289, 498825, 504946, 508478, 509672, 511507, 511919, 513157, 514375, 514782, 515893, 519510, 524481, 527359, 527794, 531384, 549083, 553970, 555025, 556524, 556997, 558183, 558338, 562869, 564880, 568914, 571126, 571829, 577095, 577261, 580672, 581128, 581719, 583577, 584421, 588070, 590599, 596714, 599744, 602695, 603878, 607176, 611290, 617597, 619003, 625520, 625556, 625861, 630328, 630461, 757145);

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
  394737
  396526
  427068
  432690
  441971
  443420
  446212
  446431
  446921
  452766
  454035
  455451
  456268
  456350
  457873
  466706
  474279
  475208
  475506
  479165
  486876
  487393
  498289
  498825
  504946
  508478
  509672
  511507
  511919
  513157
  514375
  514782
  515893
  519510
  524481
  527359
  527794
  531384
  549083
  553970
  555025
  556524
  556997
  558183
  558338
  562869
  564880
  568914
  571126
  571829
  577095
  577261
  580672
  581128
  581719
  583577
  584421
  588070
  590599
  596714
  599744
  602695
  603878
  607176
  611290
  617597
  619003
  625520
  625556
  625861
  630328
  630461
  757145
]

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 (394737, 396526, 427068, 432690, 441971, 443420, 446212, 446431, 446921, 452766, 454035, 455451, 456268, 456350, 457873, 466706, 474279, 475208, 475506, 479165, 486876, 487393, 498289, 498825, 504946, 508478, 509672, 511507, 511919, 513157, 514375, 514782, 515893, 519510, 524481, 527359, 527794, 531384, 549083, 553970, 555025, 556524, 556997, 558183, 558338, 562869, 564880, 568914, 571126, 571829, 577095, 577261, 580672, 581128, 581719, 583577, 584421, 588070, 590599, 596714, 599744, 602695, 603878, 607176, 611290, 617597, 619003, 625520, 625556, 625861, 630328, 630461, 757145);

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

[
  "cum my трусик нижн бел"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'cum my трусик нижн бел';

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

[
  "cum my трусик нижн бел"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'cum my трусик нижн бел';

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 ?

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