Query Metrics

8 Database Queries
8 Different statements
91.25 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
62.59 ms
(68.59%)
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
  402715
  410058
  418896
  421537
  427543
  437387
  439434
  441466
  444440
  444456
  448954
  451010
  453683
  454397
  455411
  455436
  457998
  459513
  459612
  463280
  471148
  472665
  473461
  494492
  500764
  500854
  505460
  511464
  514908
  515999
  517405
  520671
  526951
  527908
  549754
  564244
  571751
  575822
  576970
  578723
  579701
  584245
  584887
  586071
  588877
  591033
  591997
  592188
  592229
  592621
  651609
  698124
  761039
  809272
]
10.32 ms
(11.31%)
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
  578723
  586071
  592621
  473461
  402715
  418896
  517405
  500764
  500854
  439434
  591997
  437387
  441466
  514908
  584245
  651609
  592229
  457998
  472665
  576970
  571751
  761039
  549754
  459612
  451010
  471148
  520671
  579701
  575822
  809272
  463280
  454397
  455436
  592188
  515999
  588877
  448954
  444440
  444456
  459513
  564244
  453683
  505460
  698124
  455411
  591033
  511464
  410058
  427543
  526951
  421537
  584887
  494492
  527908
]
8.70 ms
(9.53%)
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:
[
  "homemade pawg"
  "homemade pawg"
  "homemade pawg"
  20
]
2.53 ms
(2.77%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.10 ms
(2.30%)
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
  402715
  410058
  418896
  421537
  427543
  437387
  439434
  441466
  444440
  444456
  448954
  451010
  453683
  454397
  455411
  455436
  457998
  459513
  459612
  463280
  471148
  472665
  473461
  494492
  500764
  500854
  505460
  511464
  514908
  515999
  517405
  520671
  526951
  527908
  549754
  564244
  571751
  575822
  576970
  578723
  579701
  584245
  584887
  586071
  588877
  591033
  591997
  592188
  592229
  592621
  651609
  698124
  761039
  809272
]
2.07 ms
(2.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "homemade pawg"
]
1.58 ms
(1.73%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домашн любительск pawg"
]
1.37 ms
(1.50%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "домашн любительск pawg"
]

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.