Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
80.82 ms
(53.88%)
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:
[
  "stockings milfs anal"
  "stockings milfs anal"
  "stockings milfs anal"
  20
]
49.48 ms
(32.99%)
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
  188556
  358887
  420212
  425945
  445644
  447898
  448810
  448887
  450792
  452255
  465153
  466268
  467955
  468829
  477058
  477587
  477868
  483355
  484762
  530011
  531524
  536359
  541419
  556876
  591324
  645861
  645936
  717034
  717897
  742926
  747468
  748365
  756243
  801907
  802343
  806060
  814526
  814794
  816319
  816340
]
9.27 ms
(6.18%)
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
  756243
  717897
  748365
  531524
  816319
  358887
  468829
  814794
  802343
  530011
  742926
  448887
  591324
  556876
  816340
  467955
  806060
  814526
  477868
  717034
  477587
  477058
  450792
  747468
  484762
  447898
  188556
  420212
  445644
  465153
  452255
  425945
  645936
  536359
  541419
  448810
  645861
  466268
  483355
  801907
]
2.72 ms
(1.81%)
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
  188556
  358887
  420212
  425945
  445644
  447898
  448810
  448887
  450792
  452255
  465153
  466268
  467955
  468829
  477058
  477587
  477868
  483355
  484762
  530011
  531524
  536359
  541419
  556876
  591324
  645861
  645936
  717034
  717897
  742926
  747468
  748365
  756243
  801907
  802343
  806060
  814526
  814794
  816319
  816340
]
2.30 ms
(1.53%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "stockings milfs anal"
]
1.91 ms
(1.27%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.85 ms
(1.23%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "чулк нижн бел milfs анал"
]
1.66 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "чулк нижн бел milfs анал"
]

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.