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

[
  "huge breasts"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'huge breasts' 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
  681146
  784213
  800002
  685814
  800414
  828712
  807222
  533816
  680630
  797314
  788504
  740842
  739561
  401431
  662887
  556362
  605160
  618998
  802274
  810704
  460598
  330420
  384494
  537857
  625467
  808752
  743834
  505583
  540252
  580850
  691598
  558315
  756025
  532392
  536141
  537875
  745308
  728042
  445083
  4450
  486877
  745312
  806599
  769411
  530569
  736289
  423307
  393688
  533809
  749883
  714931
  443327
  390021
  712956
  809634
  783327
  808062
  802071
  484911
  666730
  758264
  554933
  780664
  786247
  674941
  810009
  426446
  664593
  725492
  425507
  419022
  517652
]

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 (681146, 784213, 800002, 685814, 800414, 828712, 807222, 533816, 680630, 797314, 788504, 740842, 739561, 401431, 662887, 556362, 605160, 618998, 802274, 810704, 460598, 330420, 384494, 537857, 625467, 808752, 743834, 505583, 540252, 580850, 691598, 558315, 756025, 532392, 536141, 537875, 745308, 728042, 445083, 4450, 486877, 745312, 806599, 769411, 530569, 736289, 423307, 393688, 533809, 749883, 714931, 443327, 390021, 712956, 809634, 783327, 808062, 802071, 484911, 666730, 758264, 554933, 780664, 786247, 674941, 810009, 426446, 664593, 725492, 425507, 419022, 517652);

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
  4450
  330420
  384494
  390021
  393688
  401431
  419022
  423307
  425507
  426446
  443327
  445083
  460598
  484911
  486877
  505583
  517652
  530569
  532392
  533809
  533816
  536141
  537857
  537875
  540252
  554933
  556362
  558315
  580850
  605160
  618998
  625467
  662887
  664593
  666730
  674941
  680630
  681146
  685814
  691598
  712956
  714931
  725492
  728042
  736289
  739561
  740842
  743834
  745308
  745312
  749883
  756025
  758264
  769411
  780664
  783327
  784213
  786247
  788504
  797314
  800002
  800414
  802071
  802274
  806599
  807222
  808062
  808752
  809634
  810009
  810704
  828712
]

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 (4450, 330420, 384494, 390021, 393688, 401431, 419022, 423307, 425507, 426446, 443327, 445083, 460598, 484911, 486877, 505583, 517652, 530569, 532392, 533809, 533816, 536141, 537857, 537875, 540252, 554933, 556362, 558315, 580850, 605160, 618998, 625467, 662887, 664593, 666730, 674941, 680630, 681146, 685814, 691598, 712956, 714931, 725492, 728042, 736289, 739561, 740842, 743834, 745308, 745312, 749883, 756025, 758264, 769411, 780664, 783327, 784213, 786247, 788504, 797314, 800002, 800414, 802071, 802274, 806599, 807222, 808062, 808752, 809634, 810009, 810704, 828712);

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
  4450
  330420
  384494
  390021
  393688
  401431
  419022
  423307
  425507
  426446
  443327
  445083
  460598
  484911
  486877
  505583
  517652
  530569
  532392
  533809
  533816
  536141
  537857
  537875
  540252
  554933
  556362
  558315
  580850
  605160
  618998
  625467
  662887
  664593
  666730
  674941
  680630
  681146
  685814
  691598
  712956
  714931
  725492
  728042
  736289
  739561
  740842
  743834
  745308
  745312
  749883
  756025
  758264
  769411
  780664
  783327
  784213
  786247
  788504
  797314
  800002
  800414
  802071
  802274
  806599
  807222
  808062
  808752
  809634
  810009
  810704
  828712
]

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 (4450, 330420, 384494, 390021, 393688, 401431, 419022, 423307, 425507, 426446, 443327, 445083, 460598, 484911, 486877, 505583, 517652, 530569, 532392, 533809, 533816, 536141, 537857, 537875, 540252, 554933, 556362, 558315, 580850, 605160, 618998, 625467, 662887, 664593, 666730, 674941, 680630, 681146, 685814, 691598, 712956, 714931, 725492, 728042, 736289, 739561, 740842, 743834, 745308, 745312, 749883, 756025, 758264, 769411, 780664, 783327, 784213, 786247, 788504, 797314, 800002, 800414, 802071, 802274, 806599, 807222, 808062, 808752, 809634, 810009, 810704, 828712);

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

[
  "огромные breasts"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'огромные breasts';

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

[
  "огромные breasts"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'огромные breasts';

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 ?

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