Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
60.78 ms
(72.20%)
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
  427107
  450875
  457509
  460766
  462494
  466920
  467312
  467319
  467323
  467331
  474307
  480672
  485319
  500976
  504402
  513505
  524831
  528878
  557984
  558069
  563876
  580341
  590378
  590414
  590490
  596541
  602561
  603517
  605690
  615658
  685699
  687962
  709083
  721411
  732887
  739346
  765809
  766275
  780088
  783817
  788488
  791904
  816088
  818220
  818832
  825568
  828730
]
8.04 ms
(9.55%)
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
  721411
  828730
  825568
  791904
  739346
  816088
  590414
  788488
  818832
  603517
  732887
  766275
  783817
  818220
  467323
  563876
  590378
  780088
  685699
  474307
  467331
  504402
  580341
  687962
  709083
  457509
  450875
  558069
  765809
  466920
  467312
  460766
  485319
  557984
  590490
  602561
  605690
  462494
  480672
  524831
  596541
  615658
  427107
  467319
  513505
  528878
  500976
]
3.90 ms
(4.63%)
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:
[
  "debts"
  "debts"
  "debts"
  20
]
3.59 ms
(4.26%)
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
  427107
  450875
  457509
  460766
  462494
  466920
  467312
  467319
  467323
  467331
  474307
  480672
  485319
  500976
  504402
  513505
  524831
  528878
  557984
  558069
  563876
  580341
  590378
  590414
  590490
  596541
  602561
  603517
  605690
  615658
  685699
  687962
  709083
  721411
  732887
  739346
  765809
  766275
  780088
  783817
  788488
  791904
  816088
  818220
  818832
  825568
  828730
]
2.11 ms
(2.50%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "debts"
]
2.09 ms
(2.49%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.90 ms
(2.26%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "debts"
]
1.79 ms
(2.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "debts"
]

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.