Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
100.70 ms
(79.83%)
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
  416128
  419628
  431975
  438898
  451521
  453694
  454354
  457372
  457853
  458578
  458601
  458602
  459944
  460600
  461904
  468044
  468965
  468990
  469116
  470028
  472454
  474020
  477579
  483506
  487262
  489298
  489301
  489330
  491599
  491963
  493980
  494266
  496718
  504787
  506023
  506552
  509292
  514110
  514916
  516782
  516794
  517392
  517417
  517596
  517599
  524029
  524284
  524327
  524543
  524859
  527005
  527152
  528053
  531187
  538170
  540549
  542784
  555885
  555979
  565923
  571680
  571696
  573354
  582229
  583335
  583964
  591155
  591338
  591929
  593689
  595601
  598334
  598915
  604050
  611339
  617167
  625093
  626015
  639060
  666869
  672887
  687544
  698933
]
14.49 ms
(11.48%)
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
  458602
  493980
  489298
  458578
  477579
  538170
  555979
  591338
  487262
  527152
  626015
  504787
  595601
  457372
  582229
  454354
  591155
  517417
  416128
  458601
  506552
  666869
  517392
  494266
  591929
  474020
  524859
  514916
  453694
  491599
  687544
  672887
  565923
  598334
  459944
  514110
  472454
  528053
  524327
  555885
  457853
  509292
  625093
  506023
  571696
  460600
  524543
  517599
  489301
  469116
  527005
  431975
  483506
  489330
  438898
  517596
  573354
  540549
  604050
  524029
  451521
  496718
  524284
  516794
  470028
  468044
  468990
  461904
  542784
  491963
  516782
  698933
  468965
  598915
  583335
  571680
  583964
  593689
  611339
  617167
  531187
  639060
  419628
]
2.09 ms
(1.66%)
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
  416128
  419628
  431975
  438898
  451521
  453694
  454354
  457372
  457853
  458578
  458601
  458602
  459944
  460600
  461904
  468044
  468965
  468990
  469116
  470028
  472454
  474020
  477579
  483506
  487262
  489298
  489301
  489330
  491599
  491963
  493980
  494266
  496718
  504787
  506023
  506552
  509292
  514110
  514916
  516782
  516794
  517392
  517417
  517596
  517599
  524029
  524284
  524327
  524543
  524859
  527005
  527152
  528053
  531187
  538170
  540549
  542784
  555885
  555979
  565923
  571680
  571696
  573354
  582229
  583335
  583964
  591155
  591338
  591929
  593689
  595601
  598334
  598915
  604050
  611339
  617167
  625093
  626015
  639060
  666869
  672887
  687544
  698933
]
2.04 ms
(1.62%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pregnant big tits"
]
1.89 ms
(1.50%)
1
SELECT 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1
Parameters:
[
  b"\x01\x7F\x03µ\x16rB…ýѶ­\x07¯Ú"
]
1.75 ms
(1.39%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "беремен большие сиськ"
]
1.63 ms
(1.29%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.55 ms
(1.23%)
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.