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

[
  "boys fuck"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'boys fuck' 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
  460710
  453186
  550229
  496028
  458337
  485621
  517687
  470987
  484609
  391262
  620264
  510750
  484392
  514681
  443789
  518842
  484655
  468641
  445935
  470936
  479027
  526738
  483360
  625164
  471890
  449953
  466959
  479049
  559060
  411751
  443741
  460736
  484660
  435496
  484620
  467626
  462702
  470481
  484643
  484459
  484669
  423940
  443767
  382549
  465828
  464342
  476251
  525716
  528146
  646838
  484713
  454277
  484708
  521381
  484381
  570168
  466014
  466982
  516040
  584073
  466069
  486083
  460739
  484656
  485735
  634543
  602569
  428103
  600006
  515723
  549225
  546114
]

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 (460710, 453186, 550229, 496028, 458337, 485621, 517687, 470987, 484609, 391262, 620264, 510750, 484392, 514681, 443789, 518842, 484655, 468641, 445935, 470936, 479027, 526738, 483360, 625164, 471890, 449953, 466959, 479049, 559060, 411751, 443741, 460736, 484660, 435496, 484620, 467626, 462702, 470481, 484643, 484459, 484669, 423940, 443767, 382549, 465828, 464342, 476251, 525716, 528146, 646838, 484713, 454277, 484708, 521381, 484381, 570168, 466014, 466982, 516040, 584073, 466069, 486083, 460739, 484656, 485735, 634543, 602569, 428103, 600006, 515723, 549225, 546114);

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
  382549
  391262
  411751
  423940
  428103
  435496
  443741
  443767
  443789
  445935
  449953
  453186
  454277
  458337
  460710
  460736
  460739
  462702
  464342
  465828
  466014
  466069
  466959
  466982
  467626
  468641
  470481
  470936
  470987
  471890
  476251
  479027
  479049
  483360
  484381
  484392
  484459
  484609
  484620
  484643
  484655
  484656
  484660
  484669
  484708
  484713
  485621
  485735
  486083
  496028
  510750
  514681
  515723
  516040
  517687
  518842
  521381
  525716
  526738
  528146
  546114
  549225
  550229
  559060
  570168
  584073
  600006
  602569
  620264
  625164
  634543
  646838
]

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 (382549, 391262, 411751, 423940, 428103, 435496, 443741, 443767, 443789, 445935, 449953, 453186, 454277, 458337, 460710, 460736, 460739, 462702, 464342, 465828, 466014, 466069, 466959, 466982, 467626, 468641, 470481, 470936, 470987, 471890, 476251, 479027, 479049, 483360, 484381, 484392, 484459, 484609, 484620, 484643, 484655, 484656, 484660, 484669, 484708, 484713, 485621, 485735, 486083, 496028, 510750, 514681, 515723, 516040, 517687, 518842, 521381, 525716, 526738, 528146, 546114, 549225, 550229, 559060, 570168, 584073, 600006, 602569, 620264, 625164, 634543, 646838);

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
  382549
  391262
  411751
  423940
  428103
  435496
  443741
  443767
  443789
  445935
  449953
  453186
  454277
  458337
  460710
  460736
  460739
  462702
  464342
  465828
  466014
  466069
  466959
  466982
  467626
  468641
  470481
  470936
  470987
  471890
  476251
  479027
  479049
  483360
  484381
  484392
  484459
  484609
  484620
  484643
  484655
  484656
  484660
  484669
  484708
  484713
  485621
  485735
  486083
  496028
  510750
  514681
  515723
  516040
  517687
  518842
  521381
  525716
  526738
  528146
  546114
  549225
  550229
  559060
  570168
  584073
  600006
  602569
  620264
  625164
  634543
  646838
]

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 (382549, 391262, 411751, 423940, 428103, 435496, 443741, 443767, 443789, 445935, 449953, 453186, 454277, 458337, 460710, 460736, 460739, 462702, 464342, 465828, 466014, 466069, 466959, 466982, 467626, 468641, 470481, 470936, 470987, 471890, 476251, 479027, 479049, 483360, 484381, 484392, 484459, 484609, 484620, 484643, 484655, 484656, 484660, 484669, 484708, 484713, 485621, 485735, 486083, 496028, 510750, 514681, 515723, 516040, 517687, 518842, 521381, 525716, 526738, 528146, 546114, 549225, 550229, 559060, 570168, 584073, 600006, 602569, 620264, 625164, 634543, 646838);

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

[
  "boys секс"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'boys секс';

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

[
  "boys секс"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'boys секс';

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 ?

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