Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
76.29 ms
(69.17%)
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
  370755
  407156
  407800
  410352
  429461
  430546
  446034
  447865
  449508
  449512
  455294
  457422
  459651
  464596
  467657
  468012
  468533
  469017
  470829
  471617
  471809
  472147
  475483
  478453
  498469
  501713
  509702
  510463
  516885
  517749
  519212
  523255
  523811
  523815
  523822
  534312
  534625
  535369
  536538
  536657
  537670
  542965
  543772
  544420
  545300
  557163
  567779
  571029
  588411
  593425
  596330
  615378
  617115
  623200
  650419
  752700
  788260
]
12.21 ms
(11.08%)
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
  517749
  370755
  407800
  429461
  455294
  457422
  468533
  446034
  447865
  449512
  464596
  472147
  523811
  523255
  471809
  544420
  542965
  596330
  615378
  623200
  617115
  788260
  478453
  467657
  459651
  471617
  501713
  498469
  430546
  410352
  449508
  475483
  519212
  567779
  571029
  588411
  752700
  407156
  468012
  509702
  523815
  470829
  535369
  536657
  537670
  650419
  557163
  469017
  510463
  534625
  534312
  516885
  536538
  545300
  523822
  543772
  593425
]
11.03 ms
(10.00%)
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:
[
  "super boobs"
  "super boobs"
  "super boobs"
  20
]
2.96 ms
(2.68%)
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
  370755
  407156
  407800
  410352
  429461
  430546
  446034
  447865
  449508
  449512
  455294
  457422
  459651
  464596
  467657
  468012
  468533
  469017
  470829
  471617
  471809
  472147
  475483
  478453
  498469
  501713
  509702
  510463
  516885
  517749
  519212
  523255
  523811
  523815
  523822
  534312
  534625
  535369
  536538
  536657
  537670
  542965
  543772
  544420
  545300
  557163
  567779
  571029
  588411
  593425
  596330
  615378
  617115
  623200
  650419
  752700
  788260
]
2.15 ms
(1.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "super boobs"
]
1.97 ms
(1.79%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "super boobs"
]
1.89 ms
(1.71%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "super boobs"
]
1.79 ms
(1.62%)
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.