Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
76.89 ms
(67.73%)
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
  426062
  448083
  503561
  507284
  509698
  525784
  528010
  530659
  531115
  531118
  533760
  536789
  537654
  539203
  540338
  541197
  541201
  545341
  545409
  545418
  550124
  552414
  553650
  569581
  574718
  582323
  600297
  604051
  609604
  616869
  622407
  626364
  627807
  628332
  628333
  628371
  628383
  630550
  631194
  631195
  632978
  633451
  633796
  634153
  637021
  638298
  639719
  641975
  642032
  642066
  643098
  645276
  645284
  666892
  666895
  666903
  676112
  685714
  695122
  696213
  696582
  707391
]
16.29 ms
(14.35%)
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:
[
  "cum rough"
  "cum rough"
  "cum rough"
  20
]
11.30 ms
(9.95%)
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
  509698
  531115
  507284
  533760
  550124
  553650
  541201
  574718
  666903
  552414
  569581
  631195
  616869
  609604
  426062
  448083
  503561
  528010
  537654
  540338
  536789
  582323
  541197
  676112
  685714
  637021
  642066
  627807
  633796
  525784
  531118
  545341
  696582
  645276
  666892
  634153
  633451
  643098
  626364
  631194
  641975
  666895
  696213
  645284
  695122
  630550
  638298
  642032
  604051
  600297
  632978
  539203
  530659
  545409
  707391
  622407
  628332
  628383
  639719
  628371
  545418
  628333
]
2.09 ms
(1.84%)
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
  426062
  448083
  503561
  507284
  509698
  525784
  528010
  530659
  531115
  531118
  533760
  536789
  537654
  539203
  540338
  541197
  541201
  545341
  545409
  545418
  550124
  552414
  553650
  569581
  574718
  582323
  600297
  604051
  609604
  616869
  622407
  626364
  627807
  628332
  628333
  628371
  628383
  630550
  631194
  631195
  632978
  633451
  633796
  634153
  637021
  638298
  639719
  641975
  642032
  642066
  643098
  645276
  645284
  666892
  666895
  666903
  676112
  685714
  695122
  696213
  696582
  707391
]
1.84 ms
(1.62%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "cum rough"
]
1.74 ms
(1.54%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "cum rough"
]
1.72 ms
(1.52%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.65 ms
(1.45%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "cum rough"
]

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.