Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
106.95 ms
(68.02%)
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
  401917
  405708
  422512
  422513
  426021
  428334
  445993
  459527
  474536
  476409
  478647
  479942
  480856
  481134
  482686
  484870
  490201
  491556
  504170
  506467
  509083
  521126
  521526
  521581
  523300
  524628
  526104
  529114
  530061
  530637
  531065
  537207
  538803
  541866
  543508
  552658
  555948
  558847
  575116
  575783
  576083
  580256
  581384
  586600
  598545
  602017
  605456
  609735
]
29.15 ms
(18.54%)
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:
[
  "pickup teen"
  "pickup teen"
  "pickup teen"
  20
]
10.81 ms
(6.87%)
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
  476409
  478647
  482686
  537207
  521526
  481134
  555948
  575116
  580256
  605456
  521581
  401917
  543508
  602017
  598545
  459527
  490201
  524628
  531065
  530061
  575783
  521126
  484870
  479942
  445993
  541866
  552658
  581384
  480856
  530637
  526104
  576083
  609735
  405708
  504170
  523300
  509083
  428334
  586600
  474536
  426021
  491556
  529114
  422513
  506467
  422512
  558847
  538803
]
3.29 ms
(2.09%)
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
  401917
  405708
  422512
  422513
  426021
  428334
  445993
  459527
  474536
  476409
  478647
  479942
  480856
  481134
  482686
  484870
  490201
  491556
  504170
  506467
  509083
  521126
  521526
  521581
  523300
  524628
  526104
  529114
  530061
  530637
  531065
  537207
  538803
  541866
  543508
  552658
  555948
  558847
  575116
  575783
  576083
  580256
  581384
  586600
  598545
  602017
  605456
  609735
]
2.05 ms
(1.30%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pickup teen"
]
1.73 ms
(1.10%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "пикап teen"
]
1.73 ms
(1.10%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.53 ms
(0.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "пикап teen"
]

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.