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

[
  "solo big booty"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'solo 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
  749379
  468192
  386939
  398858
  437480
  446017
  540107
  795393
  787867
  465680
  444449
  444923
  440637
  442645
  512035
  480359
  484710
  552507
  562745
  584968
  592189
  796705
  444423
  751470
  444419
  580234
  459472
  454652
  429245
  427339
  465690
  513795
  809009
  727997
  438531
  465728
  528143
  464031
  519309
  467112
  454688
  587977
  603768
  599239
  806931
  527450
  471080
  450274
  510844
  588608
  529326
  718785
  447352
  507643
  468241
  444918
  452703
  796646
  515052
  515350
  438013
  548837
  576805
  457950
  528322
  524687
  453408
  507640
  580223
  620330
  473391
  520911
  598870
]

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 (749379, 468192, 386939, 398858, 437480, 446017, 540107, 795393, 787867, 465680, 444449, 444923, 440637, 442645, 512035, 480359, 484710, 552507, 562745, 584968, 592189, 796705, 444423, 751470, 444419, 580234, 459472, 454652, 429245, 427339, 465690, 513795, 809009, 727997, 438531, 465728, 528143, 464031, 519309, 467112, 454688, 587977, 603768, 599239, 806931, 527450, 471080, 450274, 510844, 588608, 529326, 718785, 447352, 507643, 468241, 444918, 452703, 796646, 515052, 515350, 438013, 548837, 576805, 457950, 528322, 524687, 453408, 507640, 580223, 620330, 473391, 520911, 598870);

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
  386939
  398858
  427339
  429245
  437480
  438013
  438531
  440637
  442645
  444419
  444423
  444449
  444918
  444923
  446017
  447352
  450274
  452703
  453408
  454652
  454688
  457950
  459472
  464031
  465680
  465690
  465728
  467112
  468192
  468241
  471080
  473391
  480359
  484710
  507640
  507643
  510844
  512035
  513795
  515052
  515350
  519309
  520911
  524687
  527450
  528143
  528322
  529326
  540107
  548837
  552507
  562745
  576805
  580223
  580234
  584968
  587977
  588608
  592189
  598870
  599239
  603768
  620330
  718785
  727997
  749379
  751470
  787867
  795393
  796646
  796705
  806931
  809009
]

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 (386939, 398858, 427339, 429245, 437480, 438013, 438531, 440637, 442645, 444419, 444423, 444449, 444918, 444923, 446017, 447352, 450274, 452703, 453408, 454652, 454688, 457950, 459472, 464031, 465680, 465690, 465728, 467112, 468192, 468241, 471080, 473391, 480359, 484710, 507640, 507643, 510844, 512035, 513795, 515052, 515350, 519309, 520911, 524687, 527450, 528143, 528322, 529326, 540107, 548837, 552507, 562745, 576805, 580223, 580234, 584968, 587977, 588608, 592189, 598870, 599239, 603768, 620330, 718785, 727997, 749379, 751470, 787867, 795393, 796646, 796705, 806931, 809009);

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
  386939
  398858
  427339
  429245
  437480
  438013
  438531
  440637
  442645
  444419
  444423
  444449
  444918
  444923
  446017
  447352
  450274
  452703
  453408
  454652
  454688
  457950
  459472
  464031
  465680
  465690
  465728
  467112
  468192
  468241
  471080
  473391
  480359
  484710
  507640
  507643
  510844
  512035
  513795
  515052
  515350
  519309
  520911
  524687
  527450
  528143
  528322
  529326
  540107
  548837
  552507
  562745
  576805
  580223
  580234
  584968
  587977
  588608
  592189
  598870
  599239
  603768
  620330
  718785
  727997
  749379
  751470
  787867
  795393
  796646
  796705
  806931
  809009
]

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 (386939, 398858, 427339, 429245, 437480, 438013, 438531, 440637, 442645, 444419, 444423, 444449, 444918, 444923, 446017, 447352, 450274, 452703, 453408, 454652, 454688, 457950, 459472, 464031, 465680, 465690, 465728, 467112, 468192, 468241, 471080, 473391, 480359, 484710, 507640, 507643, 510844, 512035, 513795, 515052, 515350, 519309, 520911, 524687, 527450, 528143, 528322, 529326, 540107, 548837, 552507, 562745, 576805, 580223, 580234, 584968, 587977, 588608, 592189, 598870, 599239, 603768, 620330, 718785, 727997, 749379, 751470, 787867, 795393, 796646, 796705, 806931, 809009);

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

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

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

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

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

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

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'соло большие 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 ?

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