Query Metrics

9 Database Queries
9 Different statements
84.28 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
63.59 ms
(75.46%)
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
  321814
  384317
  387545
  395646
  396589
  399388
  400128
  404353
  404952
  406836
  414301
  420040
  425609
  434282
  445479
  449115
  462207
  469064
  491351
  504417
  517836
  564776
  589600
  606489
  654201
  759996
  761574
  783252
  790669
  815213
  817896
  820509
  821704
]
6.93 ms
(8.22%)
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
  783252
  790669
  420040
  406836
  759996
  321814
  761574
  491351
  404952
  564776
  654201
  589600
  504417
  434282
  817896
  821704
  384317
  517836
  815213
  820509
  387545
  606489
  400128
  396589
  395646
  404353
  445479
  399388
  462207
  469064
  425609
  449115
  414301
]
3.51 ms
(4.16%)
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:
[
  "aidra fox"
  "aidra fox"
  "aidra fox"
  20
]
2.10 ms
(2.49%)
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
  321814
  384317
  387545
  395646
  396589
  399388
  400128
  404353
  404952
  406836
  414301
  420040
  425609
  434282
  445479
  449115
  462207
  469064
  491351
  504417
  517836
  564776
  589600
  606489
  654201
  759996
  761574
  783252
  790669
  815213
  817896
  820509
  821704
]
1.92 ms
(2.28%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "aidra fox"
]
1.71 ms
(2.03%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.64 ms
(1.94%)
1
SELECT 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1
Parameters:
[
  b"\x01•}‡l>p\x06µ5=8O¾\e\x06"
]
1.63 ms
(1.94%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "aidrafox"
]
1.25 ms
(1.49%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "aidrafox"
]

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.