Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
58.26 ms
(61.86%)
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
  365056
  393338
  403035
  405815
  422610
  428329
  429182
  436953
  448580
  461253
  483754
  491379
  512162
  514375
  533058
  536666
  542418
  568303
  581929
  586889
  591857
  604475
  613800
  626283
  643169
  666662
  673339
  690217
  721395
  722816
  738433
  744596
  750560
  753383
  776831
  781305
  798467
  801277
  803267
  803836
  803837
  803838
  804352
  810936
  824355
  828015
]
17.53 ms
(18.62%)
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:
[
  "shaved pierced pussy"
  "shaved pierced pussy"
  "shaved pierced pussy"
  20
]
8.61 ms
(9.14%)
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
  803836
  738433
  803838
  803837
  828015
  673339
  781305
  824355
  690217
  403035
  436953
  722816
  750560
  776831
  803267
  428329
  666662
  798467
  804352
  365056
  591857
  753383
  744596
  461253
  533058
  405815
  429182
  568303
  643169
  604475
  491379
  448580
  801277
  721395
  542418
  626283
  613800
  810936
  422610
  512162
  483754
  393338
  581929
  586889
  536666
  514375
]
2.57 ms
(2.73%)
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
  365056
  393338
  403035
  405815
  422610
  428329
  429182
  436953
  448580
  461253
  483754
  491379
  512162
  514375
  533058
  536666
  542418
  568303
  581929
  586889
  591857
  604475
  613800
  626283
  643169
  666662
  673339
  690217
  721395
  722816
  738433
  744596
  750560
  753383
  776831
  781305
  798467
  801277
  803267
  803836
  803837
  803838
  804352
  810936
  824355
  828015
]
2.06 ms
(2.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "shaved pierced pussy"
]
1.89 ms
(2.01%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "бритая pierced pussy"
]
1.64 ms
(1.74%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.61 ms
(1.71%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "бритая pierced pussy"
]

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.