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

[
  "pawg big booty"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'pawg big booty' 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
  440642
  530300
  639669
  738851
  729241
  804429
  690711
  626731
  812877
  590071
  556285
  797641
  806198
  809254
  750042
  403999
  633428
  589993
  826055
  762926
  440635
  587320
  801302
  536978
  804393
  401429
  548164
  480735
  530315
  720342
  781907
  415039
  820718
  530298
  450280
  751880
  401443
  807104
  442025
  437480
  448740
  415028
  765245
  595333
  440637
  419308
  583291
  639648
  639666
  717869
  419468
  475277
  429245
  482714
  445922
  425394
  482761
  450274
  562062
  444456
  528533
  650488
  464097
  530846
  472469
  463280
  530852
  809272
  459513
  448954
  427543
  526951
  698124
  527908
]

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 (440642, 530300, 639669, 738851, 729241, 804429, 690711, 626731, 812877, 590071, 556285, 797641, 806198, 809254, 750042, 403999, 633428, 589993, 826055, 762926, 440635, 587320, 801302, 536978, 804393, 401429, 548164, 480735, 530315, 720342, 781907, 415039, 820718, 530298, 450280, 751880, 401443, 807104, 442025, 437480, 448740, 415028, 765245, 595333, 440637, 419308, 583291, 639648, 639666, 717869, 419468, 475277, 429245, 482714, 445922, 425394, 482761, 450274, 562062, 444456, 528533, 650488, 464097, 530846, 472469, 463280, 530852, 809272, 459513, 448954, 427543, 526951, 698124, 527908);

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
  401429
  401443
  403999
  415028
  415039
  419308
  419468
  425394
  427543
  429245
  437480
  440635
  440637
  440642
  442025
  444456
  445922
  448740
  448954
  450274
  450280
  459513
  463280
  464097
  472469
  475277
  480735
  482714
  482761
  526951
  527908
  528533
  530298
  530300
  530315
  530846
  530852
  536978
  548164
  556285
  562062
  583291
  587320
  589993
  590071
  595333
  626731
  633428
  639648
  639666
  639669
  650488
  690711
  698124
  717869
  720342
  729241
  738851
  750042
  751880
  765245
  781907
  797641
  801302
  804393
  804429
  806198
  807104
  809254
  809272
  812877
  820718
  826055
]

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 (401429, 401443, 403999, 415028, 415039, 419308, 419468, 425394, 427543, 429245, 437480, 440635, 440637, 440642, 442025, 444456, 445922, 448740, 448954, 450274, 450280, 459513, 463280, 464097, 472469, 475277, 480735, 482714, 482761, 526951, 527908, 528533, 530298, 530300, 530315, 530846, 530852, 536978, 548164, 556285, 562062, 583291, 587320, 589993, 590071, 595333, 626731, 633428, 639648, 639666, 639669, 650488, 690711, 698124, 717869, 720342, 729241, 738851, 750042, 751880, 765245, 781907, 797641, 801302, 804393, 804429, 806198, 807104, 809254, 809272, 812877, 820718, 826055);

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
  401429
  401443
  403999
  415028
  415039
  419308
  419468
  425394
  427543
  429245
  437480
  440635
  440637
  440642
  442025
  444456
  445922
  448740
  448954
  450274
  450280
  459513
  463280
  464097
  472469
  475277
  480735
  482714
  482761
  526951
  527908
  528533
  530298
  530300
  530315
  530846
  530852
  536978
  548164
  556285
  562062
  583291
  587320
  589993
  590071
  595333
  626731
  633428
  639648
  639666
  639669
  650488
  690711
  698124
  717869
  720342
  729241
  738851
  750042
  751880
  765245
  781907
  797641
  801302
  804393
  804429
  806198
  807104
  809254
  809272
  812877
  820718
  826055
]

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 (401429, 401443, 403999, 415028, 415039, 419308, 419468, 425394, 427543, 429245, 437480, 440635, 440637, 440642, 442025, 444456, 445922, 448740, 448954, 450274, 450280, 459513, 463280, 464097, 472469, 475277, 480735, 482714, 482761, 526951, 527908, 528533, 530298, 530300, 530315, 530846, 530852, 536978, 548164, 556285, 562062, 583291, 587320, 589993, 590071, 595333, 626731, 633428, 639648, 639666, 639669, 650488, 690711, 698124, 717869, 720342, 729241, 738851, 750042, 751880, 765245, 781907, 797641, 801302, 804393, 804429, 806198, 807104, 809254, 809272, 812877, 820718, 826055);

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

[
  "pawg большие booty"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'pawg большие booty';

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

[
  "pawg большие booty"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'pawg большие booty';

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 ?

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