Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
56.26 ms
(60.21%)
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
  188699
  365872
  390455
  391564
  397191
  443387
  452886
  453190
  469590
  471442
  482490
  497236
  511066
  511259
  518223
  537251
  547427
  555233
  565828
  566763
  579746
  581004
  582235
  604424
  611413
  614381
  614392
  620240
  626351
  637460
  646929
  667897
  705705
  731345
  735353
  757245
  766692
  788505
  800311
  801696
  817276
  817412
  823719
  828315
]
18.89 ms
(20.22%)
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:
[
  "dogging mature outdoor"
  "dogging mature outdoor"
  "dogging mature outdoor"
  20
]
8.02 ms
(8.58%)
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
  828315
  788505
  823719
  581004
  646929
  766692
  365872
  735353
  801696
  667897
  611413
  757245
  614392
  620240
  391564
  817276
  705705
  390455
  397191
  482490
  188699
  566763
  626351
  547427
  443387
  817412
  452886
  614381
  800311
  731345
  471442
  555233
  469590
  511259
  565828
  604424
  497236
  582235
  579746
  453190
  518223
  511066
  637460
  537251
]
2.70 ms
(2.89%)
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
  188699
  365872
  390455
  391564
  397191
  443387
  452886
  453190
  469590
  471442
  482490
  497236
  511066
  511259
  518223
  537251
  547427
  555233
  565828
  566763
  579746
  581004
  582235
  604424
  611413
  614381
  614392
  620240
  626351
  637460
  646929
  667897
  705705
  731345
  735353
  757245
  766692
  788505
  800311
  801696
  817276
  817412
  823719
  828315
]
2.14 ms
(2.29%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "dogging mature outdoor"
]
1.95 ms
(2.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "dogging mature outdoor"
]
1.91 ms
(2.05%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "dogging mature outdoor"
]
1.55 ms
(1.66%)
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.