Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
207.79 ms
(51.19%)
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
  432787
  449032
  449562
  450386
  452034
  452048
  454456
  459565
  466733
  472503
  472518
  482243
  484017
  493219
  495691
  495703
  495712
  495744
  496098
  496118
  499636
  502819
  504133
  504137
  504521
  512578
  514587
  516819
  519093
  519245
  522902
  524896
  543422
  543917
  552306
  567151
  568061
  569448
  591761
  595821
  600218
  622218
  637461
  640001
  642006
  642037
  670564
  675000
  676354
  676638
  752163
  807399
]
93.57 ms
(23.05%)
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
  432787
  449032
  449562
  450386
  452034
  452048
  454456
  459565
  466733
  472503
  472518
  482243
  484017
  493219
  495691
  495703
  495712
  495744
  496098
  496118
  499636
  502819
  504133
  504137
  504521
  512578
  514587
  516819
  519093
  519245
  522902
  524896
  543422
  543917
  552306
  567151
  568061
  569448
  591761
  595821
  600218
  622218
  637461
  640001
  642006
  642037
  670564
  675000
  676354
  676638
  752163
  807399
]
85.88 ms
(21.16%)
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:
[
  "sex swap"
  "sex swap"
  "sex swap"
  20
]
11.33 ms
(2.79%)
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
  676354
  495691
  496098
  472503
  591761
  595821
  752163
  472518
  449032
  637461
  495744
  622218
  499636
  516819
  519245
  519093
  514587
  459565
  512578
  807399
  496118
  504137
  449562
  454456
  495712
  502819
  543917
  640001
  504521
  543422
  482243
  670564
  493219
  522902
  432787
  524896
  495703
  466733
  450386
  567151
  676638
  452034
  504133
  552306
  600218
  452048
  642006
  642037
  675000
  568061
  569448
  484017
]
2.10 ms
(0.52%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс swap"
]
1.98 ms
(0.49%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.87 ms
(0.46%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sex swap"
]
1.38 ms
(0.34%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс swap"
]

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.