Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
61.30 ms
(55.11%)
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
  396526
  402876
  432522
  439723
  445733
  445739
  458986
  481602
  485161
  495014
  496647
  503855
  505172
  506496
  507946
  508421
  509221
  519093
  524440
  524859
  528815
  528921
  540164
  542583
  545747
  545763
  556330
  568053
  573238
  578204
  596865
  597028
  599880
  599955
  600019
  601114
  603907
  617214
  618378
  631908
  633806
  634153
  637741
  642039
  666850
  720938
  755030
  798666
  808077
]
28.79 ms
(25.88%)
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 black"
  "cum black"
  "cum black"
  20
]
11.26 ms
(10.12%)
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
  505172
  509221
  666850
  402876
  485161
  503855
  528815
  508421
  540164
  578204
  596865
  631908
  798666
  755030
  432522
  528921
  445733
  507946
  524440
  556330
  573238
  720938
  808077
  396526
  445739
  481602
  506496
  542583
  545747
  601114
  637741
  617214
  633806
  458986
  495014
  496647
  519093
  524859
  568053
  597028
  439723
  599955
  618378
  634153
  600019
  545763
  599880
  642039
  603907
]
2.41 ms
(2.17%)
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
  396526
  402876
  432522
  439723
  445733
  445739
  458986
  481602
  485161
  495014
  496647
  503855
  505172
  506496
  507946
  508421
  509221
  519093
  524440
  524859
  528815
  528921
  540164
  542583
  545747
  545763
  556330
  568053
  573238
  578204
  596865
  597028
  599880
  599955
  600019
  601114
  603907
  617214
  618378
  631908
  633806
  634153
  637741
  642039
  666850
  720938
  755030
  798666
  808077
]
2.33 ms
(2.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "cum black"
]
1.83 ms
(1.64%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "cum black"
]
1.70 ms
(1.53%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "cum black"
]
1.62 ms
(1.46%)
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.