Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
61.06 ms
(65.60%)
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
  476270
  485569
  502210
  540136
  542456
  542722
  545403
  546614
  548226
  549511
  553674
  554709
  555615
  555616
  558264
  562111
  562157
  563333
  568375
  577052
  580976
  581182
  600778
  605290
  627835
  629575
  631879
  633193
  652779
  665326
  725527
  732869
  744568
  745998
  746091
  752840
  757569
  796577
  798387
  804418
  804437
  811916
  812217
  812225
  812230
  812242
  812245
  812246
  814166
]
13.27 ms
(14.25%)
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:
[
  "outdoor pissing"
  "outdoor pissing"
  "outdoor pissing"
  20
]
8.42 ms
(9.05%)
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
  562157
  555615
  627835
  629575
  549511
  757569
  542456
  485569
  812245
  798387
  665326
  812225
  812230
  745998
  633193
  540136
  812246
  568375
  814166
  554709
  804418
  744568
  542722
  600778
  812217
  812242
  581182
  558264
  631879
  605290
  562111
  545403
  804437
  555616
  811916
  746091
  732869
  577052
  553674
  752840
  580976
  652779
  796577
  725527
  502210
  563333
  476270
  546614
  548226
]
2.98 ms
(3.20%)
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
  476270
  485569
  502210
  540136
  542456
  542722
  545403
  546614
  548226
  549511
  553674
  554709
  555615
  555616
  558264
  562111
  562157
  563333
  568375
  577052
  580976
  581182
  600778
  605290
  627835
  629575
  631879
  633193
  652779
  665326
  725527
  732869
  744568
  745998
  746091
  752840
  757569
  796577
  798387
  804418
  804437
  811916
  812217
  812225
  812230
  812242
  812245
  812246
  814166
]
1.98 ms
(2.13%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "outdoor pissing"
]
1.98 ms
(2.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "outdoor pissing"
]
1.79 ms
(1.92%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "outdoor pissing"
]
1.61 ms
(1.73%)
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.