Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
279.70 ms
(83.13%)
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
  391048
  391950
  406289
  407759
  411770
  411946
  465952
  468505
  471009
  477556
  487348
  490598
  504030
  510945
  513135
  525884
  533594
  536731
  559430
  561529
  584053
  587207
  587961
  590720
  590721
  592975
  592998
  598242
  599238
  614835
  620145
  630105
  664498
  665101
  665197
  665213
  665214
  665357
  665456
  666130
  667868
  671466
  706895
  714336
  714380
  725428
  729935
  746110
  758097
  796714
  796778
  801560
  804444
  804602
  824320
]
36.00 ms
(10.70%)
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:
[
  "very hairy mature"
  "very hairy mature"
  "very hairy mature"
  20
]
9.46 ms
(2.81%)
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
  796714
  599238
  706895
  729935
  598242
  824320
  666130
  665456
  468505
  411770
  665213
  667868
  471009
  391950
  510945
  391048
  490598
  725428
  746110
  665197
  664498
  665101
  665214
  758097
  714336
  630105
  536731
  407759
  665357
  796778
  804444
  592975
  671466
  614835
  804602
  584053
  477556
  587961
  592998
  590720
  465952
  587207
  504030
  533594
  561529
  620145
  714380
  590721
  513135
  801560
  559430
  525884
  411946
  406289
  487348
]
3.20 ms
(0.95%)
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
  391048
  391950
  406289
  407759
  411770
  411946
  465952
  468505
  471009
  477556
  487348
  490598
  504030
  510945
  513135
  525884
  533594
  536731
  559430
  561529
  584053
  587207
  587961
  590720
  590721
  592975
  592998
  598242
  599238
  614835
  620145
  630105
  664498
  665101
  665197
  665213
  665214
  665357
  665456
  666130
  667868
  671466
  706895
  714336
  714380
  725428
  729935
  746110
  758097
  796714
  796778
  801560
  804444
  804602
  824320
]
2.30 ms
(0.68%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.00 ms
(0.60%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "very волосатая mature"
]
1.98 ms
(0.59%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "very hairy mature"
]
1.83 ms
(0.55%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "very волосатая mature"
]

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.