Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
55.99 ms
(57.62%)
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
  393692
  419276
  436452
  437808
  439244
  443335
  444321
  453469
  459690
  463325
  470231
  473412
  477246
  483352
  484899
  487921
  495163
  499288
  504553
  504662
  508353
  508938
  510573
  511370
  519679
  519760
  528437
  529134
  545379
  551816
  561346
  562223
  568569
  568573
  586219
  591341
  594179
  594239
  594245
  597075
  600013
  600433
  602168
  613850
  626247
  634894
  717535
  752684
  756768
]
21.70 ms
(22.34%)
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:
[
  "fingering teen"
  "fingering teen"
  "fingering teen"
  20
]
10.76 ms
(11.07%)
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
  473412
  459690
  717535
  568569
  594245
  613850
  634894
  752684
  463325
  393692
  437808
  484899
  504553
  499288
  504662
  528437
  443335
  508938
  510573
  529134
  545379
  562223
  594179
  600433
  756768
  436452
  439244
  419276
  470231
  487921
  508353
  444321
  551816
  600013
  602168
  477246
  453469
  568573
  626247
  483352
  495163
  519679
  591341
  511370
  561346
  594239
  586219
  597075
  519760
]
1.99 ms
(2.05%)
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
  393692
  419276
  436452
  437808
  439244
  443335
  444321
  453469
  459690
  463325
  470231
  473412
  477246
  483352
  484899
  487921
  495163
  499288
  504553
  504662
  508353
  508938
  510573
  511370
  519679
  519760
  528437
  529134
  545379
  551816
  561346
  562223
  568569
  568573
  586219
  591341
  594179
  594239
  594245
  597075
  600013
  600433
  602168
  613850
  626247
  634894
  717535
  752684
  756768
]
1.89 ms
(1.94%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.83 ms
(1.89%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "fingering teen"
]
1.52 ms
(1.56%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "fingering teen"
]
1.49 ms
(1.54%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "fingering teen"
]

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.