Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
59.54 ms
(71.71%)
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
  385965
  390907
  401824
  408675
  448846
  457528
  461531
  462494
  469031
  469047
  469059
  475028
  475514
  483044
  486356
  489403
  518109
  518787
  529771
  536744
  551252
  563990
  565340
  566673
  567326
  569026
  588294
  599274
  611383
  620115
  623827
  665942
  688019
  717842
  719286
  721433
  748705
  752372
  768378
  769457
  771897
  779387
  783391
  783458
  788706
  790703
  790809
  793202
  805716
  808492
  825525
]
7.77 ms
(9.36%)
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:
[
  "kind girls"
  "kind girls"
  "kind girls"
  20
]
6.93 ms
(8.35%)
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
  565340
  825192
  771897
  825525
  551252
  611383
  385965
  688019
  788706
  783458
  529771
  793202
  486356
  390907
  752372
  779387
  790703
  783391
  489403
  469047
  665942
  808492
  769457
  805716
  721433
  469059
  469031
  457528
  566673
  768378
  620115
  461531
  719286
  790809
  717842
  518109
  401824
  563990
  623827
  567326
  748705
  475028
  462494
  518787
  448846
  475514
  569026
  599274
  483044
  588294
  408675
  536744
]
2.21 ms
(2.66%)
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
  385965
  390907
  401824
  408675
  448846
  457528
  461531
  462494
  469031
  469047
  469059
  475028
  475514
  483044
  486356
  489403
  518109
  518787
  529771
  536744
  551252
  563990
  565340
  566673
  567326
  569026
  588294
  599274
  611383
  620115
  623827
  665942
  688019
  717842
  719286
  721433
  748705
  752372
  768378
  769457
  771897
  779387
  783391
  783458
  788706
  790703
  790809
  793202
  805716
  808492
  825525
]
1.89 ms
(2.28%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "kind girls"
]
1.71 ms
(2.06%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "kind девушк"
]
1.51 ms
(1.81%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.47 ms
(1.77%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "kind девушк"
]

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.