Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
210.69 ms
(62.77%)
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
  517796
  520879
  539295
  543678
  551535
  554683
  554686
  554707
  568293
  573386
  579856
  588391
  605060
  618129
  627131
  628565
  641313
  657777
  697284
  701194
  709298
  710584
  727017
  727042
  734364
  738564
  738675
  738694
  746021
  751170
  751360
  751384
  751390
  752477
  754209
  754477
  797250
  797255
  801810
  804422
  811844
  811852
  811862
  811876
  811880
  811882
  811889
  811891
  811896
  811900
  811902
  811905
  811907
  812279
  814706
]
97.95 ms
(29.18%)
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
  517796
  520879
  539295
  543678
  551535
  554683
  554686
  554707
  568293
  573386
  579856
  588391
  605060
  618129
  627131
  628565
  641313
  657777
  697284
  701194
  709298
  710584
  727017
  727042
  734364
  738564
  738675
  738694
  746021
  751170
  751360
  751384
  751390
  752477
  754209
  754477
  797250
  797255
  801810
  804422
  811844
  811852
  811862
  811876
  811880
  811882
  811889
  811891
  811896
  811900
  811902
  811905
  811907
  812279
  814706
]
10.52 ms
(3.13%)
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
  811844
  568293
  641313
  754477
  804422
  814706
  811891
  811880
  657777
  554686
  543678
  573386
  554707
  554683
  520879
  811900
  579856
  751390
  628565
  627131
  811902
  752477
  697284
  618129
  746021
  709298
  811907
  811876
  539295
  517796
  588391
  812279
  754209
  811905
  797255
  811852
  751384
  738694
  801810
  811896
  605060
  738675
  751360
  727042
  710584
  811882
  751170
  727017
  701194
  811862
  811889
  797250
  738564
  734364
  551535
]
9.47 ms
(2.82%)
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:
[
  "hidden toilet piss"
  "hidden toilet piss"
  "hidden toilet piss"
  20
]
2.01 ms
(0.60%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.75 ms
(0.52%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hidden toilet piss"
]
1.72 ms
(0.51%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "скрыт туалет писсинг"
]
1.53 ms
(0.46%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.