Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
140.48 ms
(69.46%)
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
  386017
  389976
  392751
  398237
  400942
  414157
  424613
  427185
  434070
  434124
  445945
  454140
  461208
  463231
  464971
  466646
  467046
  468004
  468284
  470024
  470195
  471001
  471029
  472683
  474315
  475672
  490595
  492182
  494547
  495277
  514450
  529650
  543623
  544871
  548946
  562155
  576484
  576614
  583197
  584366
  585851
  587235
  590981
  603567
  610198
  615073
  620908
  634071
  640477
  642022
  649306
  653192
  710937
  733396
  739774
  742310
  752090
  757197
  760686
  761269
  826356
]
42.00 ms
(20.77%)
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:
[
  "соло волосатых 2"
  "соло волосатых 2"
  "соло волосатых 2"
  20
]
10.10 ms
(4.99%)
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
  398237
  739774
  529650
  562155
  576484
  610198
  742310
  761269
  757197
  548946
  710937
  752090
  603567
  620908
  576614
  544871
  640477
  392751
  653192
  615073
  826356
  649306
  590981
  760686
  467046
  468284
  427185
  471029
  587235
  733396
  490595
  386017
  470195
  642022
  492182
  468004
  389976
  514450
  474315
  400942
  461208
  470024
  472683
  434070
  634071
  463231
  583197
  454140
  494547
  495277
  543623
  434124
  424613
  475672
  466646
  471001
  585851
  445945
  464971
  584366
  414157
]
2.86 ms
(1.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
  386017
  389976
  392751
  398237
  400942
  414157
  424613
  427185
  434070
  434124
  445945
  454140
  461208
  463231
  464971
  466646
  467046
  468004
  468284
  470024
  470195
  471001
  471029
  472683
  474315
  475672
  490595
  492182
  494547
  495277
  514450
  529650
  543623
  544871
  548946
  562155
  576484
  576614
  583197
  584366
  585851
  587235
  590981
  603567
  610198
  615073
  620908
  634071
  640477
  642022
  649306
  653192
  710937
  733396
  739774
  742310
  752090
  757197
  760686
  761269
  826356
]
1.92 ms
(0.95%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.87 ms
(0.92%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "соло волосатых 2"
]
1.56 ms
(0.77%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "соло волосатая два"
]
1.46 ms
(0.72%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "соло волосатая два"
]

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.