Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
127.41 ms
(80.80%)
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
  399824
  400958
  400965
  401500
  401880
  406171
  408460
  410682
  415618
  426009
  427101
  428257
  428328
  429088
  429761
  429764
  431540
  432883
  433279
  433312
  439010
  439858
  440041
  442216
  443103
  443433
  445739
  446167
  448562
  451266
  451620
  452483
  453162
  454364
  456244
  457007
  457293
  458063
  465971
  468680
  473392
  478044
  483553
  485899
  486082
  487087
  487197
  489120
  490507
  500268
  500335
  501313
  507646
  513664
  514443
  515690
  515793
  515892
  517329
  519392
  520714
  523856
  524072
  525462
  530633
  530805
  531177
  532349
  532785
  537674
  552401
  554805
  557249
  559942
  561073
  564541
  571327
  572544
  575806
  578258
  585999
  586033
  588071
  592332
  594406
  596437
  604295
  606801
  610607
  616315
  619692
  620783
  627725
  632561
  633798
  634163
  634185
  637125
  641702
  641986
  643415
  647877
  648499
  650016
  675021
  676624
  677293
  678067
  678089
  678141
  678495
  683259
  696518
  699610
  700294
  704528
  720927
  731921
  732069
  799985
]
19.43 ms
(12.32%)
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
  704528
  696518
  552401
  586033
  594406
  616315
  634163
  641702
  637125
  620783
  643415
  731921
  799985
  732069
  610607
  700294
  445739
  448562
  400958
  428328
  465971
  432883
  439010
  451266
  433279
  439858
  440041
  443433
  457293
  473392
  456244
  500335
  486082
  513664
  514443
  524072
  487087
  517329
  400965
  408460
  429088
  442216
  410682
  428257
  429764
  431540
  451620
  487197
  452483
  478044
  537674
  530633
  532349
  532785
  515690
  515892
  520714
  531177
  578258
  564541
  575806
  559942
  650016
  678067
  683259
  648499
  675021
  676624
  677293
  720927
  572544
  588071
  596437
  634185
  641986
  585999
  633798
  592332
  632561
  604295
  606801
  619692
  427101
  399824
  457007
  458063
  401500
  401880
  426009
  468680
  523856
  489120
  525462
  483553
  490507
  500268
  507646
  433312
  557249
  627725
  515793
  406171
  415618
  443103
  429761
  454364
  446167
  485899
  453162
  519392
  501313
  530805
  561073
  554805
  571327
  647877
  678089
  678141
  699610
  678495
]
2.83 ms
(1.80%)
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
  399824
  400958
  400965
  401500
  401880
  406171
  408460
  410682
  415618
  426009
  427101
  428257
  428328
  429088
  429761
  429764
  431540
  432883
  433279
  433312
  439010
  439858
  440041
  442216
  443103
  443433
  445739
  446167
  448562
  451266
  451620
  452483
  453162
  454364
  456244
  457007
  457293
  458063
  465971
  468680
  473392
  478044
  483553
  485899
  486082
  487087
  487197
  489120
  490507
  500268
  500335
  501313
  507646
  513664
  514443
  515690
  515793
  515892
  517329
  519392
  520714
  523856
  524072
  525462
  530633
  530805
  531177
  532349
  532785
  537674
  552401
  554805
  557249
  559942
  561073
  564541
  571327
  572544
  575806
  578258
  585999
  586033
  588071
  592332
  594406
  596437
  604295
  606801
  610607
  616315
  619692
  620783
  627725
  632561
  633798
  634163
  634185
  637125
  641702
  641986
  643415
  647877
  648499
  650016
  675021
  676624
  677293
  678067
  678089
  678141
  678495
  683259
  696518
  699610
  700294
  704528
  720927
  731921
  732069
  799985
]
2.27 ms
(1.44%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "slut teen"
]
1.94 ms
(1.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "slut teen"
]
1.94 ms
(1.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "slut teen"
]
1.86 ms
(1.18%)
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.