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

[
  "british milf solo"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'british milf solo' 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
  720528
  603311
  776452
  603338
  720534
  718950
  790699
  570885
  706761
  603377
  620363
  785831
  744188
  475274
  603348
  640312
  777638
  176394
  381987
  714387
  593031
  811109
  807210
  808682
  652052
  519626
  542452
  554492
  715416
  777378
  385380
  435668
  546559
  618587
  803401
  808421
  770155
  476311
  660024
  607636
  603390
  798087
  776786
  541413
  559838
  812598
  405816
  537091
  607541
  630558
  603306
  805198
  806534
  808407
  750881
  587578
  419144
  716201
  420538
  500436
  515661
  517736
  515356
  581173
  551829
  611330
  587961
  750907
  752506
  607552
  630919
  515350
  797170
]

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 (720528, 603311, 776452, 603338, 720534, 718950, 790699, 570885, 706761, 603377, 620363, 785831, 744188, 475274, 603348, 640312, 777638, 176394, 381987, 714387, 593031, 811109, 807210, 808682, 652052, 519626, 542452, 554492, 715416, 777378, 385380, 435668, 546559, 618587, 803401, 808421, 770155, 476311, 660024, 607636, 603390, 798087, 776786, 541413, 559838, 812598, 405816, 537091, 607541, 630558, 603306, 805198, 806534, 808407, 750881, 587578, 419144, 716201, 420538, 500436, 515661, 517736, 515356, 581173, 551829, 611330, 587961, 750907, 752506, 607552, 630919, 515350, 797170);

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
  176394
  381987
  385380
  405816
  419144
  420538
  435668
  475274
  476311
  500436
  515350
  515356
  515661
  517736
  519626
  537091
  541413
  542452
  551829
  554492
  559838
  570885
  581173
  587578
  587961
  593031
  603306
  603311
  603338
  603348
  603377
  603390
  607541
  607552
  607636
  611330
  618587
  620363
  630558
  630919
  640312
  652052
  660024
  706761
  714387
  715416
  716201
  718950
  720528
  720534
  744188
  750881
  750907
  752506
  770155
  776452
  776786
  777378
  777638
  785831
  790699
  797170
  798087
  803401
  805198
  806534
  807210
  808407
  808421
  808682
  811109
  812598
]

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 (176394, 381987, 385380, 405816, 419144, 420538, 435668, 475274, 476311, 500436, 515350, 515356, 515661, 517736, 519626, 537091, 541413, 542452, 551829, 554492, 559838, 570885, 581173, 587578, 587961, 593031, 603306, 603311, 603338, 603348, 603377, 603390, 607541, 607552, 607636, 611330, 618587, 620363, 630558, 630919, 640312, 652052, 660024, 706761, 714387, 715416, 716201, 718950, 720528, 720534, 744188, 750881, 750907, 752506, 770155, 776452, 776786, 777378, 777638, 785831, 790699, 797170, 798087, 803401, 805198, 806534, 807210, 808407, 808421, 808682, 811109, 812598);

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
  176394
  381987
  385380
  405816
  419144
  420538
  435668
  475274
  476311
  500436
  515350
  515356
  515661
  517736
  519626
  537091
  541413
  542452
  551829
  554492
  559838
  570885
  581173
  587578
  587961
  593031
  603306
  603311
  603338
  603348
  603377
  603390
  607541
  607552
  607636
  611330
  618587
  620363
  630558
  630919
  640312
  652052
  660024
  706761
  714387
  715416
  716201
  718950
  720528
  720534
  744188
  750881
  750907
  752506
  770155
  776452
  776786
  777378
  777638
  785831
  790699
  797170
  798087
  803401
  805198
  806534
  807210
  808407
  808421
  808682
  811109
  812598
]

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 (176394, 381987, 385380, 405816, 419144, 420538, 435668, 475274, 476311, 500436, 515350, 515356, 515661, 517736, 519626, 537091, 541413, 542452, 551829, 554492, 559838, 570885, 581173, 587578, 587961, 593031, 603306, 603311, 603338, 603348, 603377, 603390, 607541, 607552, 607636, 611330, 618587, 620363, 630558, 630919, 640312, 652052, 660024, 706761, 714387, 715416, 716201, 718950, 720528, 720534, 744188, 750881, 750907, 752506, 770155, 776452, 776786, 777378, 777638, 785831, 790699, 797170, 798087, 803401, 805198, 806534, 807210, 808407, 808421, 808682, 811109, 812598);

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

[
  "british milf соло"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'british milf соло';

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

[
  "british milf соло"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'british milf соло';

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 ?

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