Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
54.50 ms
(57.72%)
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
  393055
  395970
  396253
  400497
  403588
  407524
  420767
  421287
  424746
  428895
  433359
  439560
  439571
  445200
  449886
  462515
  462545
  464327
  467009
  467405
  467975
  471494
  472793
  484583
  502326
  502530
  506669
  507596
  507711
  513506
  513521
  515494
  517841
  519023
  520870
  529162
  531316
  546114
  546124
  561577
  564825
  565786
  574527
  590966
  611375
  612381
  620309
  726508
  751565
]
18.48 ms
(19.57%)
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:
[
  "home young"
  "home young"
  "home young"
  20
]
11.19 ms
(11.86%)
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
  407524
  462545
  400497
  433359
  439560
  467405
  502530
  515494
  502326
  513521
  611375
  464327
  471494
  395970
  396253
  449886
  561577
  565786
  726508
  403588
  428895
  439571
  462515
  467975
  445200
  484583
  520870
  507596
  420767
  472793
  564825
  546124
  620309
  393055
  517841
  507711
  531316
  612381
  513506
  546114
  467009
  506669
  421287
  424746
  590966
  751565
  574527
  529162
  519023
]
2.66 ms
(2.82%)
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
  393055
  395970
  396253
  400497
  403588
  407524
  420767
  421287
  424746
  428895
  433359
  439560
  439571
  445200
  449886
  462515
  462545
  464327
  467009
  467405
  467975
  471494
  472793
  484583
  502326
  502530
  506669
  507596
  507711
  513506
  513521
  515494
  517841
  519023
  520870
  529162
  531316
  546114
  546124
  561577
  564825
  565786
  574527
  590966
  611375
  612381
  620309
  726508
  751565
]
2.04 ms
(2.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "home young"
]
2.02 ms
(2.14%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.85 ms
(1.96%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "home young"
]
1.67 ms
(1.77%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "home young"
]

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.