Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
54.53 ms
(60.89%)
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
  420762
  443792
  445735
  445739
  446394
  447031
  447036
  452967
  458912
  461183
  467844
  479814
  482289
  496935
  497066
  501841
  511171
  517125
  517455
  517602
  517775
  524018
  525635
  529345
  542084
  542753
  542790
  558303
  561879
  568149
  571682
  580368
  585753
  593269
  594487
  603218
  612804
  619692
  621779
  622978
  623306
  624090
  627749
  634856
  697026
  720288
  761088
]
16.08 ms
(17.95%)
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:
[
  "fuck front husband"
  "fuck front husband"
  "fuck front husband"
  20
]
9.36 ms
(10.46%)
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
  542084
  568149
  497066
  461183
  621779
  761088
  558303
  697026
  612804
  467844
  561879
  511171
  585753
  420762
  458912
  452967
  542790
  624090
  445739
  517125
  501841
  627749
  479814
  525635
  517602
  594487
  443792
  496935
  571682
  542753
  445735
  720288
  482289
  622978
  447036
  619692
  580368
  446394
  517455
  447031
  623306
  603218
  529345
  593269
  634856
  524018
  517775
]
2.30 ms
(2.57%)
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
  420762
  443792
  445735
  445739
  446394
  447031
  447036
  452967
  458912
  461183
  467844
  479814
  482289
  496935
  497066
  501841
  511171
  517125
  517455
  517602
  517775
  524018
  525635
  529345
  542084
  542753
  542790
  558303
  561879
  568149
  571682
  580368
  585753
  593269
  594487
  603218
  612804
  619692
  621779
  622978
  623306
  624090
  627749
  634856
  697026
  720288
  761088
]
1.95 ms
(2.17%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс front husband"
]
1.93 ms
(2.15%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.76 ms
(1.97%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "fuck front husband"
]
1.64 ms
(1.83%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс front husband"
]

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.