Query Metrics

7 Database Queries
7 Different statements
185.62 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
159.99 ms
(86.19%)
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
  13011
  13258
  79388
  154374
  191487
  249637
  331119
  381752
  383075
  383326
  384803
  388028
  388774
  390180
  396609
  396720
  396722
  397781
  397849
  399089
  400787
  401203
  405848
  407429
  411684
  416063
  417050
  421761
  426249
  449868
  450241
  453134
  456902
  460194
  466499
  466968
  468483
  474852
  480929
  485354
  485795
  486788
  496329
  499274
  499556
  511844
  515698
  515777
  516021
  516686
  517610
  529202
  529286
  532926
  533196
  533529
  535749
  537840
  540528
  548568
  548575
  556428
  558074
  558440
  563478
  573230
  575020
  584214
  589576
  589674
  603387
  604083
  604574
  604597
  604610
  604905
  607459
  620147
  630194
  632681
  640798
  644309
  651601
  663895
  666584
  666850
  669771
  675008
  675010
  681257
  681301
  681596
  690786
  712788
  715533
  719004
  721060
  721830
  725451
  725633
  726165
  726665
  731888
  732292
  735942
  738821
  740903
  742880
  744624
  744654
  745245
  773796
  775202
  789692
  790814
  795515
  804758
  807641
  811826
  817351
]
16.41 ms
(8.84%)
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
  731888
  735942
  773796
  384803
  515777
  396609
  449868
  529286
  383075
  191487
  397849
  405848
  474852
  663895
  589576
  604083
  604597
  249637
  516686
  589674
  480929
  388774
  397781
  517610
  499274
  499556
  540528
  584214
  548575
  690786
  644309
  607459
  775202
  740903
  795515
  726165
  732292
  738821
  630194
  721060
  804758
  675010
  651601
  558440
  811826
  154374
  13011
  407429
  817351
  453134
  466499
  485795
  496329
  537840
  548568
  563478
  669771
  666584
  681596
  712788
  719004
  604905
  620147
  640798
  725633
  742880
  745245
  807641
  726665
  744654
  604610
  715533
  790814
  460194
  485354
  558074
  529202
  331119
  79388
  396722
  416063
  450241
  456902
  468483
  532926
  515698
  533529
  535749
  533196
  556428
  573230
  575020
  681257
  721830
  603387
  632681
  725451
  744624
  789692
  388028
  399089
  400787
  396720
  13258
  390180
  401203
  466968
  681301
  516021
  511844
  666850
  675008
  381752
  486788
  604574
  383326
  421761
  426249
  411684
  417050
]
2.95 ms
(1.59%)
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
  13011
  13258
  79388
  154374
  191487
  249637
  331119
  381752
  383075
  383326
  384803
  388028
  388774
  390180
  396609
  396720
  396722
  397781
  397849
  399089
  400787
  401203
  405848
  407429
  411684
  416063
  417050
  421761
  426249
  449868
  450241
  453134
  456902
  460194
  466499
  466968
  468483
  474852
  480929
  485354
  485795
  486788
  496329
  499274
  499556
  511844
  515698
  515777
  516021
  516686
  517610
  529202
  529286
  532926
  533196
  533529
  535749
  537840
  540528
  548568
  548575
  556428
  558074
  558440
  563478
  573230
  575020
  584214
  589576
  589674
  603387
  604083
  604574
  604597
  604610
  604905
  607459
  620147
  630194
  632681
  640798
  644309
  651601
  663895
  666584
  666850
  669771
  675008
  675010
  681257
  681301
  681596
  690786
  712788
  715533
  719004
  721060
  721830
  725451
  725633
  726165
  726665
  731888
  732292
  735942
  738821
  740903
  742880
  744624
  744654
  745245
  773796
  775202
  789692
  790814
  795515
  804758
  807641
  811826
  817351
]
1.67 ms
(0.90%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "black cock mature"
]
1.57 ms
(0.85%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "black cock mature"
]
1.52 ms
(0.82%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.52 ms
(0.82%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "black cock mature"
]

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.