Query Metrics

9 Database Queries
9 Different statements
66.17 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
36.37 ms
(54.96%)
1
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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  421234
  541575
  541699
  544366
  546993
  550864
  555055
  555421
  559350
  571135
  579707
  612904
  619455
  628632
  634145
  635275
  639292
  639796
  641978
  646176
  647860
  647885
  647948
  650127
  651599
  666901
  666902
  666904
  786525
]
11.66 ms
(17.62%)
1
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 ?
Parameters:
[
  "hairy pissing"
  "hairy pissing"
  "hairy pissing"
  20
]
6.98 ms
(10.55%)
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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  628632
  619455
  786525
  555421
  541575
  550864
  559350
  612904
  579707
  647885
  571135
  634145
  544366
  546993
  666904
  651599
  666901
  650127
  666902
  639292
  421234
  541699
  555055
  646176
  639796
  647948
  647860
  641978
  635275
]
2.43 ms
(3.68%)
1
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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  421234
  541575
  541699
  544366
  546993
  550864
  555055
  555421
  559350
  571135
  579707
  612904
  619455
  628632
  634145
  635275
  639292
  639796
  641978
  646176
  647860
  647885
  647948
  650127
  651599
  666901
  666902
  666904
  786525
]
2.03 ms
(3.06%)
1
SELECT 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1
Parameters:
[
  b"\x01\x07­÷Ìs©¤ËÞu\x1Do\x06÷"
]
1.82 ms
(2.75%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hairy pissing"
]
1.74 ms
(2.63%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "волосатая pissing"
]
1.68 ms
(2.54%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.46 ms
(2.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "волосатая pissing"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

No loaded entities.