Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
99.89 ms
(78.13%)
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
  10778
  383360
  414957
  421192
  425331
  450238
  453195
  454026
  456240
  458027
  478950
  489995
  490075
  493240
  498114
  512184
  514328
  514653
  519016
  526636
  527155
  527986
  538432
  554213
  555023
  568335
  571679
  573356
  584786
  586511
  609813
  611389
  613709
  617199
  626839
  628724
  630050
  635842
  655939
  680216
  693898
  715176
  724699
  760937
  764243
  770137
  771822
  772591
  783697
  787823
  788123
  788247
  791368
  791658
  798686
  801638
  801762
  801776
  814931
  820165
]
11.79 ms
(9.22%)
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
  801776
  788123
  791658
  787823
  724699
  10778
  573356
  613709
  770137
  820165
  512184
  655939
  764243
  771822
  383360
  760937
  538432
  693898
  611389
  635842
  801638
  772591
  715176
  788247
  798686
  783697
  801762
  458027
  421192
  454026
  514328
  554213
  628724
  630050
  617199
  414957
  490075
  527155
  526636
  626839
  791368
  425331
  453195
  814931
  489995
  478950
  493240
  586511
  609813
  450238
  498114
  527986
  568335
  680216
  584786
  456240
  555023
  514653
  519016
  571679
]
3.87 ms
(3.03%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "longer"
]
3.19 ms
(2.50%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "longer"
]
2.95 ms
(2.31%)
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:
[
  "longer"
  "longer"
  "longer"
  20
]
2.37 ms
(1.85%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "longer"
]
2.08 ms
(1.62%)
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
  10778
  383360
  414957
  421192
  425331
  450238
  453195
  454026
  456240
  458027
  478950
  489995
  490075
  493240
  498114
  512184
  514328
  514653
  519016
  526636
  527155
  527986
  538432
  554213
  555023
  568335
  571679
  573356
  584786
  586511
  609813
  611389
  613709
  617199
  626839
  628724
  630050
  635842
  655939
  680216
  693898
  715176
  724699
  760937
  764243
  770137
  771822
  772591
  783697
  787823
  788123
  788247
  791368
  791658
  798686
  801638
  801762
  801776
  814931
  820165
]
1.72 ms
(1.34%)
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.