Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
65.16 ms
(48.00%)
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:
[
  "amateur latin anal"
  "amateur latin anal"
  "amateur latin anal"
  20
]
52.98 ms
(39.03%)
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
  103696
  398833
  416029
  418697
  423332
  427203
  432647
  432696
  442095
  442107
  443218
  448756
  454924
  461845
  472781
  473166
  488817
  500758
  531840
  539030
  548443
  550899
  550902
  568289
  590365
  593964
  606346
  620480
  632121
  654914
  656635
  656916
  657543
  679653
  715098
  724102
  758832
  761366
  774698
  804708
  807123
  813883
]
7.79 ms
(5.74%)
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
  804708
  774698
  568289
  715098
  539030
  761366
  531840
  550902
  813883
  758832
  548443
  103696
  427203
  656916
  656635
  807123
  620480
  724102
  590365
  593964
  442107
  448756
  606346
  657543
  550899
  442095
  398833
  432696
  432647
  416029
  418697
  632121
  654914
  488817
  679653
  472781
  443218
  500758
  461845
  473166
  423332
  454924
]
2.72 ms
(2.00%)
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
  103696
  398833
  416029
  418697
  423332
  427203
  432647
  432696
  442095
  442107
  443218
  448756
  454924
  461845
  472781
  473166
  488817
  500758
  531840
  539030
  548443
  550899
  550902
  568289
  590365
  593964
  606346
  620480
  632121
  654914
  656635
  656916
  657543
  679653
  715098
  724102
  758832
  761366
  774698
  804708
  807123
  813883
]
2.12 ms
(1.56%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur latin anal"
]
1.92 ms
(1.42%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск latin анал"
]
1.64 ms
(1.21%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.40 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "любительск latin анал"
]

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.