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

[
  "real blowjob home"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'real blowjob home' 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
  820164
  791230
  763462
  809965
  662443
  786227
  810195
  789837
  625503
  785794
  722253
  617388
  554621
  765084
  743196
  673908
  673880
  723189
  799446
  779806
  721978
  749769
  796734
  721610
  673836
  673860
  402597
  719112
  761777
  747563
  685823
  679306
  460581
  512373
  482922
  678696
  741076
  547903
  761899
  521991
  514608
  601880
  492222
  772763
  700724
  392665
  590622
  405426
  522208
  415834
  569629
  501250
  764652
  461388
  422141
  401757
  732905
  439808
  565937
  624489
  496585
  564132
  478969
  506794
  655591
  447095
  561273
  659215
  421878
  442613
  522374
  597015
]

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 (820164, 791230, 763462, 809965, 662443, 786227, 810195, 789837, 625503, 785794, 722253, 617388, 554621, 765084, 743196, 673908, 673880, 723189, 799446, 779806, 721978, 749769, 796734, 721610, 673836, 673860, 402597, 719112, 761777, 747563, 685823, 679306, 460581, 512373, 482922, 678696, 741076, 547903, 761899, 521991, 514608, 601880, 492222, 772763, 700724, 392665, 590622, 405426, 522208, 415834, 569629, 501250, 764652, 461388, 422141, 401757, 732905, 439808, 565937, 624489, 496585, 564132, 478969, 506794, 655591, 447095, 561273, 659215, 421878, 442613, 522374, 597015);

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
  392665
  401757
  402597
  405426
  415834
  421878
  422141
  439808
  442613
  447095
  460581
  461388
  478969
  482922
  492222
  496585
  501250
  506794
  512373
  514608
  521991
  522208
  522374
  547903
  554621
  561273
  564132
  565937
  569629
  590622
  597015
  601880
  617388
  624489
  625503
  655591
  659215
  662443
  673836
  673860
  673880
  673908
  678696
  679306
  685823
  700724
  719112
  721610
  721978
  722253
  723189
  732905
  741076
  743196
  747563
  749769
  761777
  761899
  763462
  764652
  765084
  772763
  779806
  785794
  786227
  789837
  791230
  796734
  799446
  809965
  810195
  820164
]

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 (392665, 401757, 402597, 405426, 415834, 421878, 422141, 439808, 442613, 447095, 460581, 461388, 478969, 482922, 492222, 496585, 501250, 506794, 512373, 514608, 521991, 522208, 522374, 547903, 554621, 561273, 564132, 565937, 569629, 590622, 597015, 601880, 617388, 624489, 625503, 655591, 659215, 662443, 673836, 673860, 673880, 673908, 678696, 679306, 685823, 700724, 719112, 721610, 721978, 722253, 723189, 732905, 741076, 743196, 747563, 749769, 761777, 761899, 763462, 764652, 765084, 772763, 779806, 785794, 786227, 789837, 791230, 796734, 799446, 809965, 810195, 820164);

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
  392665
  401757
  402597
  405426
  415834
  421878
  422141
  439808
  442613
  447095
  460581
  461388
  478969
  482922
  492222
  496585
  501250
  506794
  512373
  514608
  521991
  522208
  522374
  547903
  554621
  561273
  564132
  565937
  569629
  590622
  597015
  601880
  617388
  624489
  625503
  655591
  659215
  662443
  673836
  673860
  673880
  673908
  678696
  679306
  685823
  700724
  719112
  721610
  721978
  722253
  723189
  732905
  741076
  743196
  747563
  749769
  761777
  761899
  763462
  764652
  765084
  772763
  779806
  785794
  786227
  789837
  791230
  796734
  799446
  809965
  810195
  820164
]

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 (392665, 401757, 402597, 405426, 415834, 421878, 422141, 439808, 442613, 447095, 460581, 461388, 478969, 482922, 492222, 496585, 501250, 506794, 512373, 514608, 521991, 522208, 522374, 547903, 554621, 561273, 564132, 565937, 569629, 590622, 597015, 601880, 617388, 624489, 625503, 655591, 659215, 662443, 673836, 673860, 673880, 673908, 678696, 679306, 685823, 700724, 719112, 721610, 721978, 722253, 723189, 732905, 741076, 743196, 747563, 749769, 761777, 761899, 763462, 764652, 765084, 772763, 779806, 785794, 786227, 789837, 791230, 796734, 799446, 809965, 810195, 820164);

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

[
  "real минет оральн секс home"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'real минет оральн секс home';

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

[
  "real минет оральн секс home"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'real минет оральн секс home';

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 ?

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