Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
54.25 ms
(60.61%)
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
  391546
  398534
  446624
  453142
  454241
  454547
  456897
  463066
  464957
  465602
  466259
  466956
  468828
  483138
  483368
  487364
  493197
  498722
  499112
  511916
  519752
  524883
  526833
  526843
  529364
  531533
  537835
  537860
  545544
  549223
  552062
  554498
  559569
  559579
  562567
  572347
  573335
  612171
  616711
  617048
  712823
  723377
  730072
  731170
  801027
  817721
]
17.30 ms
(19.33%)
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:
[
  "granny slave"
  "granny slave"
  "granny slave"
  20
]
7.89 ms
(8.82%)
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
  398534
  554498
  562567
  731170
  549223
  723377
  456897
  466956
  524883
  801027
  817721
  483138
  454547
  531533
  453142
  465602
  537860
  712823
  391546
  468828
  529364
  537835
  552062
  612171
  730072
  466259
  545544
  454241
  493197
  559579
  617048
  487364
  519752
  446624
  464957
  483368
  572347
  559569
  511916
  526843
  499112
  526833
  573335
  463066
  498722
  616711
]
2.54 ms
(2.84%)
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
  391546
  398534
  446624
  453142
  454241
  454547
  456897
  463066
  464957
  465602
  466259
  466956
  468828
  483138
  483368
  487364
  493197
  498722
  499112
  511916
  519752
  524883
  526833
  526843
  529364
  531533
  537835
  537860
  545544
  549223
  552062
  554498
  559569
  559579
  562567
  572347
  573335
  612171
  616711
  617048
  712823
  723377
  730072
  731170
  801027
  817721
]
2.25 ms
(2.51%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "granny slave"
]
1.85 ms
(2.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "granny доминирован"
]
1.75 ms
(1.96%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.67 ms
(1.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "granny доминирован"
]

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.