Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
54.64 ms
(73.38%)
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
  33821
  34486
  336884
  405718
  423326
  445061
  464968
  482073
  489499
  489506
  489507
  489516
  489522
  489544
  489566
  489691
  491238
  491563
  514921
  532848
  534757
  557467
  569201
  569218
  605265
  606272
  606605
  626561
  643361
  676853
  680962
  682176
  713587
  714368
  760184
  760725
  774866
  784998
  789725
  800623
  808965
  811978
  815334
  819013
  827208
  828489
]
7.36 ms
(9.88%)
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
  680962
  682176
  811978
  789725
  676853
  605265
  569218
  643361
  808965
  514921
  774866
  714368
  557467
  532848
  569201
  828489
  336884
  760725
  815334
  819013
  827208
  34486
  713587
  33821
  464968
  626561
  606272
  800623
  760184
  491238
  423326
  784998
  606605
  489507
  445061
  534757
  489566
  491563
  489499
  405718
  482073
  489544
  489522
  489691
  489506
  489516
]
3.22 ms
(4.32%)
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:
[
  "deluxe"
  "deluxe"
  "deluxe"
  20
]
2.48 ms
(3.33%)
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
  33821
  34486
  336884
  405718
  423326
  445061
  464968
  482073
  489499
  489506
  489507
  489516
  489522
  489544
  489566
  489691
  491238
  491563
  514921
  532848
  534757
  557467
  569201
  569218
  605265
  606272
  606605
  626561
  643361
  676853
  680962
  682176
  713587
  714368
  760184
  760725
  774866
  784998
  789725
  800623
  808965
  811978
  815334
  819013
  827208
  828489
]
1.91 ms
(2.57%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "deluxe"
]
1.75 ms
(2.35%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "deluxe"
]
1.57 ms
(2.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "deluxe"
]
1.52 ms
(2.04%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]

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.