Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
74.28 ms
(48.65%)
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
  451926
  451932
  451935
  451943
  451946
  451970
  451974
  452025
  452048
  452057
  452061
  452115
  452149
  452156
  452157
  452511
  496771
  534785
  537727
  541630
  541631
  541634
  541640
  541651
  541664
  541683
  541721
  541752
  541753
  541764
  541808
  541822
  541828
  541831
  541833
  542188
  542189
  542191
  542194
  592486
  641767
  649559
  656206
  716323
  750060
  750064
  788291
  800230
  802835
  814129
]
55.54 ms
(36.38%)
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:
[
  "mom full hd"
  "mom full hd"
  "mom full hd"
  20
]
14.54 ms
(9.52%)
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
  537727
  656206
  641767
  750060
  814129
  800230
  802835
  750064
  788291
  541752
  542191
  716323
  541683
  534785
  541764
  541634
  541753
  649559
  452025
  541828
  592486
  541808
  541640
  541664
  542188
  451926
  452157
  451946
  452057
  452156
  451932
  541721
  452115
  541822
  451970
  452511
  541631
  451943
  451935
  452149
  496771
  542194
  452061
  541651
  452048
  451974
  541831
  541630
  541833
  542189
]
1.96 ms
(1.28%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mom full hd"
]
1.86 ms
(1.22%)
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
  451926
  451932
  451935
  451943
  451946
  451970
  451974
  452025
  452048
  452057
  452061
  452115
  452149
  452156
  452157
  452511
  496771
  534785
  537727
  541630
  541631
  541634
  541640
  541651
  541664
  541683
  541721
  541752
  541753
  541764
  541808
  541822
  541828
  541831
  541833
  542188
  542189
  542191
  542194
  592486
  641767
  649559
  656206
  716323
  750060
  750064
  788291
  800230
  802835
  814129
]
1.59 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mom full hd"
]
1.55 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mom full hd"
]
1.37 ms
(0.90%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]

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.