Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
60.95 ms
(62.23%)
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
  383948
  398577
  398799
  420520
  432692
  444662
  446264
  446550
  446551
  446552
  446553
  457697
  457713
  457735
  457774
  457792
  459171
  469228
  469239
  469243
  469254
  471172
  473575
  486818
  512367
  513286
  516772
  518151
  519811
  519815
  528681
  531054
  537780
  537787
  537788
  553545
  558448
  571828
  584136
  608363
  625140
  639635
  678692
  692122
  713963
  714602
  795021
  805038
  806761
]
15.99 ms
(16.33%)
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:
[
  "spy public toilet"
  "spy public toilet"
  "spy public toilet"
  20
]
9.05 ms
(9.24%)
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
  714602
  692122
  513286
  531054
  639635
  398577
  383948
  398799
  678692
  795021
  469228
  469239
  469243
  537788
  537787
  713963
  608363
  457713
  444662
  805038
  471172
  528681
  420520
  457697
  558448
  469254
  519815
  446552
  446551
  537780
  806761
  446264
  457792
  446553
  486818
  519811
  571828
  446550
  518151
  457735
  459171
  553545
  512367
  457774
  516772
  432692
  473575
  625140
  584136
]
3.34 ms
(3.41%)
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
  383948
  398577
  398799
  420520
  432692
  444662
  446264
  446550
  446551
  446552
  446553
  457697
  457713
  457735
  457774
  457792
  459171
  469228
  469239
  469243
  469254
  471172
  473575
  486818
  512367
  513286
  516772
  518151
  519811
  519815
  528681
  531054
  537780
  537787
  537788
  553545
  558448
  571828
  584136
  608363
  625140
  639635
  678692
  692122
  713963
  714602
  795021
  805038
  806761
]
2.44 ms
(2.49%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "spy на улиц туалет"
]
2.18 ms
(2.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "spy public toilet"
]
2.06 ms
(2.11%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.92 ms
(1.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "spy на улиц туалет"
]

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.