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

[
  "pantyhose footjob"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'pantyhose footjob' 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
  741902
  122062
  500890
  432461
  556713
  546977
  695901
  433775
  432528
  594265
  432368
  816751
  828550
  755142
  755150
  661522
  391439
  768695
  828854
  828676
  823541
  551957
  663182
  753501
  433366
  824851
  760875
  767984
  432417
  432453
  828666
  536084
  696379
  750931
  432395
  800664
  736898
  760648
  432430
  524175
  681963
  560064
  432548
  433662
  346907
  636353
  432572
  433059
  432538
  432422
  432494
  432527
  432526
  770641
  797509
  555734
  760184
  536205
  432559
  788859
  584440
  750554
  433820
  477817
  540703
  523421
  516118
  484490
  784481
]

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 (741902, 122062, 500890, 432461, 556713, 546977, 695901, 433775, 432528, 594265, 432368, 816751, 828550, 755142, 755150, 661522, 391439, 768695, 828854, 828676, 823541, 551957, 663182, 753501, 433366, 824851, 760875, 767984, 432417, 432453, 828666, 536084, 696379, 750931, 432395, 800664, 736898, 760648, 432430, 524175, 681963, 560064, 432548, 433662, 346907, 636353, 432572, 433059, 432538, 432422, 432494, 432527, 432526, 770641, 797509, 555734, 760184, 536205, 432559, 788859, 584440, 750554, 433820, 477817, 540703, 523421, 516118, 484490, 784481);

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
  122062
  346907
  391439
  432368
  432395
  432417
  432422
  432430
  432453
  432461
  432494
  432526
  432527
  432528
  432538
  432548
  432559
  432572
  433059
  433366
  433662
  433775
  433820
  477817
  484490
  500890
  516118
  523421
  524175
  536084
  536205
  540703
  546977
  551957
  555734
  556713
  560064
  584440
  594265
  636353
  661522
  663182
  681963
  695901
  696379
  736898
  741902
  750554
  750931
  753501
  755142
  755150
  760184
  760648
  760875
  767984
  768695
  770641
  784481
  788859
  797509
  800664
  816751
  823541
  828550
  828666
  828676
  828854
]

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 (122062, 346907, 391439, 432368, 432395, 432417, 432422, 432430, 432453, 432461, 432494, 432526, 432527, 432528, 432538, 432548, 432559, 432572, 433059, 433366, 433662, 433775, 433820, 477817, 484490, 500890, 516118, 523421, 524175, 536084, 536205, 540703, 546977, 551957, 555734, 556713, 560064, 584440, 594265, 636353, 661522, 663182, 681963, 695901, 696379, 736898, 741902, 750554, 750931, 753501, 755142, 755150, 760184, 760648, 760875, 767984, 768695, 770641, 784481, 788859, 797509, 800664, 816751, 823541, 828550, 828666, 828676, 828854);

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
  122062
  346907
  391439
  432368
  432395
  432417
  432422
  432430
  432453
  432461
  432494
  432526
  432527
  432528
  432538
  432548
  432559
  432572
  433059
  433366
  433662
  433775
  433820
  477817
  484490
  500890
  516118
  523421
  524175
  536084
  536205
  540703
  546977
  551957
  555734
  556713
  560064
  584440
  594265
  636353
  661522
  663182
  681963
  695901
  696379
  736898
  741902
  750554
  750931
  753501
  755142
  755150
  760184
  760648
  760875
  767984
  768695
  770641
  784481
  788859
  797509
  800664
  816751
  823541
  828550
  828666
  828676
  828854
]

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 (122062, 346907, 391439, 432368, 432395, 432417, 432422, 432430, 432453, 432461, 432494, 432526, 432527, 432528, 432538, 432548, 432559, 432572, 433059, 433366, 433662, 433775, 433820, 477817, 484490, 500890, 516118, 523421, 524175, 536084, 536205, 540703, 546977, 551957, 555734, 556713, 560064, 584440, 594265, 636353, 661522, 663182, 681963, 695901, 696379, 736898, 741902, 750554, 750931, 753501, 755142, 755150, 760184, 760648, 760875, 767984, 768695, 770641, 784481, 788859, 797509, 800664, 816751, 823541, 828550, 828666, 828676, 828854);

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

[
  "pantyhose footjob"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'pantyhose footjob';

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

[
  "pantyhose footjob"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'pantyhose footjob';

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 ?

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