Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
207.68 ms
(59.85%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "волосатая vintage русск"
]
78.23 ms
(22.55%)
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
  429862
  443763
  474479
  474483
  526114
  543579
  543725
  543968
  543979
  544502
  546618
  546993
  547912
  547928
  547930
  549758
  549767
  549771
  549776
  549778
  551836
  557993
  558172
  559057
  559060
  559061
  559064
  559708
  560372
  563001
  563155
  563166
  566370
  567751
  568601
  569427
  572537
  574204
  576127
  576643
  596415
  597018
  597094
  598768
  608354
  609196
  615757
  617641
  644968
  662137
  671701
  699708
  714470
  729821
]
40.70 ms
(11.73%)
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:
[
  "hairy vintage russian"
  "hairy vintage russian"
  "hairy vintage russian"
  20
]
11.90 ms
(3.43%)
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
  576127
  526114
  559708
  546618
  598768
  699708
  429862
  714470
  547912
  549758
  597094
  559064
  551836
  596415
  597018
  543968
  671701
  544502
  543725
  543979
  608354
  729821
  549778
  557993
  563001
  547930
  547928
  559057
  563166
  474479
  549776
  566370
  549771
  568601
  563155
  576643
  567751
  569427
  443763
  559061
  474483
  644968
  549767
  559060
  574204
  558172
  572537
  615757
  560372
  546993
  617641
  662137
  543579
  609196
]
2.86 ms
(0.82%)
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
  429862
  443763
  474479
  474483
  526114
  543579
  543725
  543968
  543979
  544502
  546618
  546993
  547912
  547928
  547930
  549758
  549767
  549771
  549776
  549778
  551836
  557993
  558172
  559057
  559060
  559061
  559064
  559708
  560372
  563001
  563155
  563166
  566370
  567751
  568601
  569427
  572537
  574204
  576127
  576643
  596415
  597018
  597094
  598768
  608354
  609196
  615757
  617641
  644968
  662137
  671701
  699708
  714470
  729821
]
2.14 ms
(0.62%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hairy vintage russian"
]
1.84 ms
(0.53%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "волосатая vintage русск"
]
1.63 ms
(0.47%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.