Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
61.06 ms
(61.00%)
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
  413662
  414155
  414157
  418149
  419567
  420313
  424198
  424228
  429362
  443247
  449072
  465127
  471331
  473096
  473104
  473933
  475110
  477146
  485592
  490592
  499365
  510938
  512934
  514941
  520164
  528995
  529205
  530415
  531594
  547189
  547566
  554837
  571698
  575666
  577309
  579517
  589991
  594820
  597828
  598651
  600025
  600319
  600414
  604943
  605094
  605145
  609889
  645893
  739949
  740375
  808150
  810889
]
21.34 ms
(21.32%)
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:
[
  "skinny ugly solo"
  "skinny ugly solo"
  "skinny ugly solo"
  20
]
7.84 ms
(7.83%)
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
  600414
  810889
  600025
  598651
  739949
  589991
  547189
  530415
  554837
  597828
  808150
  449072
  473104
  600319
  605145
  465127
  485592
  413662
  420313
  577309
  740375
  414155
  473096
  528995
  547566
  571698
  473933
  575666
  604943
  609889
  429362
  520164
  514941
  471331
  424228
  424198
  475110
  477146
  418149
  419567
  529205
  645893
  594820
  490592
  499365
  531594
  510938
  579517
  605094
  512934
  414157
  443247
]
2.76 ms
(2.76%)
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
  413662
  414155
  414157
  418149
  419567
  420313
  424198
  424228
  429362
  443247
  449072
  465127
  471331
  473096
  473104
  473933
  475110
  477146
  485592
  490592
  499365
  510938
  512934
  514941
  520164
  528995
  529205
  530415
  531594
  547189
  547566
  554837
  571698
  575666
  577309
  579517
  589991
  594820
  597828
  598651
  600025
  600319
  600414
  604943
  605094
  605145
  609889
  645893
  739949
  740375
  808150
  810889
]
1.96 ms
(1.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "skinny ugly solo"
]
1.81 ms
(1.81%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "худые ugly соло"
]
1.69 ms
(1.69%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "худые ugly соло"
]
1.64 ms
(1.64%)
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.