Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
71.63 ms
(55.48%)
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
  397811
  398476
  403464
  407682
  413112
  414036
  418941
  435537
  443760
  460829
  472569
  474022
  486081
  500366
  500367
  505826
  515068
  518312
  523779
  532682
  533897
  533959
  549833
  557742
  561465
  567109
  576125
  584890
  586535
  603431
  613167
  623380
  713193
  714459
  714771
  715869
  718553
  730069
  734038
  740492
  741047
  747073
  755952
  768887
  785438
  790882
  796833
  796843
  798679
  800598
  801338
  806540
  808155
  808474
  813956
  825037
]
36.68 ms
(28.41%)
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:
[
  "pervert mature fuck"
  "pervert mature fuck"
  "pervert mature fuck"
  20
]
10.64 ms
(8.24%)
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
  747073
  806540
  718553
  800598
  714771
  755952
  398476
  825037
  801338
  808474
  713193
  397811
  730069
  561465
  741047
  768887
  790882
  785438
  584890
  576125
  443760
  474022
  403464
  407682
  413112
  549833
  486081
  798679
  714459
  505826
  515068
  813956
  613167
  557742
  586535
  414036
  740492
  435537
  533897
  796843
  796833
  460829
  472569
  715869
  808155
  532682
  734038
  603431
  518312
  523779
  533959
  418941
  500367
  500366
  623380
  567109
]
2.79 ms
(2.16%)
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
  397811
  398476
  403464
  407682
  413112
  414036
  418941
  435537
  443760
  460829
  472569
  474022
  486081
  500366
  500367
  505826
  515068
  518312
  523779
  532682
  533897
  533959
  549833
  557742
  561465
  567109
  576125
  584890
  586535
  603431
  613167
  623380
  713193
  714459
  714771
  715869
  718553
  730069
  734038
  740492
  741047
  747073
  755952
  768887
  785438
  790882
  796833
  796843
  798679
  800598
  801338
  806540
  808155
  808474
  813956
  825037
]
2.10 ms
(1.63%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pervert mature fuck"
]
1.82 ms
(1.41%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "pervert mature секс"
]
1.81 ms
(1.40%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(1.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "pervert 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.