Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
77.91 ms
(64.48%)
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
  437530
  443792
  445735
  445739
  447031
  447036
  447143
  452967
  453558
  461183
  467844
  472665
  479814
  482289
  496935
  497066
  501841
  511171
  517125
  517455
  517602
  517775
  524018
  525635
  526182
  527032
  527230
  529345
  542084
  542753
  542790
  558303
  561879
  565651
  568149
  571682
  580368
  585753
  593269
  594487
  603218
  619692
  620670
  622978
  623306
  624090
  627749
  634856
  697026
  720288
  725601
  761088
  788881
]
18.03 ms
(14.92%)
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:
[
  "wife front husband"
  "wife front husband"
  "wife front husband"
  20
]
15.13 ms
(12.52%)
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
  527230
  620670
  725601
  542084
  761088
  447143
  561879
  558303
  697026
  437530
  527032
  467844
  542790
  585753
  565651
  788881
  594487
  479814
  526182
  461183
  517602
  511171
  445739
  496935
  517125
  482289
  452967
  624090
  627749
  420762
  472665
  619692
  568149
  497066
  720288
  622978
  447036
  453558
  445735
  542753
  571682
  580368
  517455
  623306
  501841
  443792
  525635
  447031
  603218
  593269
  634856
  524018
  529345
  517775
]
2.72 ms
(2.25%)
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
  437530
  443792
  445735
  445739
  447031
  447036
  447143
  452967
  453558
  461183
  467844
  472665
  479814
  482289
  496935
  497066
  501841
  511171
  517125
  517455
  517602
  517775
  524018
  525635
  526182
  527032
  527230
  529345
  542084
  542753
  542790
  558303
  561879
  565651
  568149
  571682
  580368
  585753
  593269
  594487
  603218
  619692
  620670
  622978
  623306
  624090
  627749
  634856
  697026
  720288
  725601
  761088
  788881
]
2.17 ms
(1.80%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "wife front husband"
]
2.14 ms
(1.77%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.48 ms
(1.23%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен front husband"
]
1.25 ms
(1.03%)
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.