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

[
  "perfect ass wife"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'perfect ass wife' 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
  624909
  586792
  590102
  473526
  437635
  456839
  514999
  513465
  514977
  520837
  621160
  453558
  498417
  629630
  463519
  416405
  498591
  523035
  511359
  504989
  427553
  723616
  459561
  478993
  479649
  540032
  485257
  655582
  604030
  709128
  514975
  488474
  437797
  516298
  523823
  518364
  503385
  589105
  613508
  479641
  489963
  498402
  548866
  520828
  581997
  589972
  489980
  440669
  624390
  497117
  510194
  520838
  483851
  493464
  515605
  596622
  637537
  627089
  477842
  811466
  486869
  601161
  564981
  588039
  529125
  581662
  573477
  521843
  516227
  420262
  523809
  589544
  618326
]

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 (624909, 586792, 590102, 473526, 437635, 456839, 514999, 513465, 514977, 520837, 621160, 453558, 498417, 629630, 463519, 416405, 498591, 523035, 511359, 504989, 427553, 723616, 459561, 478993, 479649, 540032, 485257, 655582, 604030, 709128, 514975, 488474, 437797, 516298, 523823, 518364, 503385, 589105, 613508, 479641, 489963, 498402, 548866, 520828, 581997, 589972, 489980, 440669, 624390, 497117, 510194, 520838, 483851, 493464, 515605, 596622, 637537, 627089, 477842, 811466, 486869, 601161, 564981, 588039, 529125, 581662, 573477, 521843, 516227, 420262, 523809, 589544, 618326);

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
  416405
  420262
  427553
  437635
  437797
  440669
  453558
  456839
  459561
  463519
  473526
  477842
  478993
  479641
  479649
  483851
  485257
  486869
  488474
  489963
  489980
  493464
  497117
  498402
  498417
  498591
  503385
  504989
  510194
  511359
  513465
  514975
  514977
  514999
  515605
  516227
  516298
  518364
  520828
  520837
  520838
  521843
  523035
  523809
  523823
  529125
  540032
  548866
  564981
  573477
  581662
  581997
  586792
  588039
  589105
  589544
  589972
  590102
  596622
  601161
  604030
  613508
  618326
  621160
  624390
  624909
  627089
  629630
  637537
  655582
  709128
  723616
  811466
]

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 (416405, 420262, 427553, 437635, 437797, 440669, 453558, 456839, 459561, 463519, 473526, 477842, 478993, 479641, 479649, 483851, 485257, 486869, 488474, 489963, 489980, 493464, 497117, 498402, 498417, 498591, 503385, 504989, 510194, 511359, 513465, 514975, 514977, 514999, 515605, 516227, 516298, 518364, 520828, 520837, 520838, 521843, 523035, 523809, 523823, 529125, 540032, 548866, 564981, 573477, 581662, 581997, 586792, 588039, 589105, 589544, 589972, 590102, 596622, 601161, 604030, 613508, 618326, 621160, 624390, 624909, 627089, 629630, 637537, 655582, 709128, 723616, 811466);

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
  416405
  420262
  427553
  437635
  437797
  440669
  453558
  456839
  459561
  463519
  473526
  477842
  478993
  479641
  479649
  483851
  485257
  486869
  488474
  489963
  489980
  493464
  497117
  498402
  498417
  498591
  503385
  504989
  510194
  511359
  513465
  514975
  514977
  514999
  515605
  516227
  516298
  518364
  520828
  520837
  520838
  521843
  523035
  523809
  523823
  529125
  540032
  548866
  564981
  573477
  581662
  581997
  586792
  588039
  589105
  589544
  589972
  590102
  596622
  601161
  604030
  613508
  618326
  621160
  624390
  624909
  627089
  629630
  637537
  655582
  709128
  723616
  811466
]

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 (416405, 420262, 427553, 437635, 437797, 440669, 453558, 456839, 459561, 463519, 473526, 477842, 478993, 479641, 479649, 483851, 485257, 486869, 488474, 489963, 489980, 493464, 497117, 498402, 498417, 498591, 503385, 504989, 510194, 511359, 513465, 514975, 514977, 514999, 515605, 516227, 516298, 518364, 520828, 520837, 520838, 521843, 523035, 523809, 523823, 529125, 540032, 548866, 564981, 573477, 581662, 581997, 586792, 588039, 589105, 589544, 589972, 590102, 596622, 601161, 604030, 613508, 618326, 621160, 624390, 624909, 627089, 629630, 637537, 655582, 709128, 723616, 811466);

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

[
  "perfect жоп жен"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'perfect жоп жен';

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

[
  "perfect жоп жен"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'perfect жоп жен';

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 ?

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