Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
74.77 ms
(69.65%)
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
  91344
  391993
  419453
  430559
  440890
  456509
  462585
  472957
  484157
  484969
  507186
  510138
  513002
  515652
  524457
  525982
  528672
  528686
  542926
  548922
  563134
  580874
  586394
  597157
  605087
  616207
  617336
  620188
  626993
  637156
  652961
  659033
  660649
  661381
  671563
  689871
  713963
  718029
  725417
  736017
  741737
  752131
  782997
  783907
  784670
  785682
  785759
  793008
  808149
  808154
  812509
  823827
  824255
]
14.30 ms
(13.33%)
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
  548922
  616207
  823827
  91344
  661381
  652961
  782997
  808149
  785759
  824255
  718029
  785682
  812509
  793008
  689871
  626993
  528672
  671563
  785681
  725417
  528686
  660649
  713963
  617336
  620188
  783907
  741737
  808154
  752131
  605087
  391993
  784670
  736017
  472957
  586394
  484969
  580874
  525982
  515652
  419453
  507186
  659033
  637156
  456509
  542926
  462585
  510138
  513002
  524457
  597157
  430559
  563134
  440890
  484157
]
8.62 ms
(8.03%)
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:
[
  "balcony masturbation"
  "balcony masturbation"
  "balcony masturbation"
  20
]
2.53 ms
(2.36%)
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
  91344
  391993
  419453
  430559
  440890
  456509
  462585
  472957
  484157
  484969
  507186
  510138
  513002
  515652
  524457
  525982
  528672
  528686
  542926
  548922
  563134
  580874
  586394
  597157
  605087
  616207
  617336
  620188
  626993
  637156
  652961
  659033
  660649
  661381
  671563
  689871
  713963
  718029
  725417
  736017
  741737
  752131
  782997
  783907
  784670
  785682
  785759
  793008
  808149
  808154
  812509
  823827
  824255
]
2.38 ms
(2.22%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "balcony masturbation"
]
1.71 ms
(1.59%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.55 ms
(1.45%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "balcony мастурбац"
]
1.47 ms
(1.37%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "balcony мастурбац"
]

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.