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

[
  "big booty pawg"
]

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

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

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

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

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

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

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

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

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

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 ?

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