Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
72.56 ms
(58.76%)
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
  400517
  443775
  444238
  445396
  447810
  452041
  455912
  456437
  458555
  470596
  484472
  485703
  495703
  504139
  504165
  514404
  517556
  521453
  525089
  530373
  531172
  532954
  533697
  533746
  535620
  542960
  543652
  543731
  546761
  550230
  555805
  562358
  562368
  567581
  580263
  583500
  590411
  597963
  599964
  600354
  601584
  606467
  620098
  644971
  650155
  662137
  671863
  683261
  730798
  775848
  775866
  775958
  775963
  805487
  825812
]
29.48 ms
(23.88%)
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:
[
  "russian mature group"
  "russian mature group"
  "russian mature group"
  20
]
11.96 ms
(9.68%)
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
  517556
  445396
  444238
  650155
  470596
  644971
  580263
  606467
  775866
  775848
  775963
  400517
  443775
  504139
  550230
  485703
  546761
  542960
  825812
  514404
  531172
  533697
  535620
  567581
  600354
  775958
  456437
  452041
  484472
  620098
  543652
  495703
  532954
  543731
  683261
  590411
  447810
  455912
  530373
  662137
  555805
  458555
  805487
  525089
  730798
  601584
  599964
  562368
  597963
  671863
  583500
  504165
  533746
  562358
  521453
]
2.73 ms
(2.21%)
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
  400517
  443775
  444238
  445396
  447810
  452041
  455912
  456437
  458555
  470596
  484472
  485703
  495703
  504139
  504165
  514404
  517556
  521453
  525089
  530373
  531172
  532954
  533697
  533746
  535620
  542960
  543652
  543731
  546761
  550230
  555805
  562358
  562368
  567581
  580263
  583500
  590411
  597963
  599964
  600354
  601584
  606467
  620098
  644971
  650155
  662137
  671863
  683261
  730798
  775848
  775866
  775958
  775963
  805487
  825812
]
1.80 ms
(1.46%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск mature group"
]
1.71 ms
(1.39%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian mature group"
]
1.66 ms
(1.34%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.57 ms
(1.27%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск mature group"
]

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.