Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
127.42 ms
(84.29%)
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
  385000
  388791
  415029
  418521
  419619
  423958
  427100
  440641
  452934
  455373
  457119
  470979
  487618
  488908
  488993
  490675
  492412
  494293
  505353
  506070
  507243
  510950
  517439
  517881
  529176
  533290
  537237
  540593
  544912
  546039
  555982
  563998
  569315
  590721
  590835
  591781
  599020
  600830
  602247
  602318
  603359
  606254
  607757
  607845
  610015
  612291
  615357
  615413
  617566
  618228
  626402
  628511
  630254
  634080
  637347
  637363
  638197
  643191
  643737
  644171
  651953
  664504
  666031
  666711
  669281
  680969
  683720
  698156
  706026
  708851
  710054
  711211
  714703
  719342
  720071
  726448
  727283
  730414
  731758
  733217
  740905
  742330
  742336
  743641
  746106
  748648
  749513
  750306
  750626
  750680
  766307
  772483
  774674
  776217
  781765
  783204
  784302
  787265
  788753
  792775
  794931
  795816
  795867
  795902
  798764
  800767
  801531
  801772
  802241
  802328
  803786
  804120
  806667
  807999
  810096
  812312
  812551
  816158
  816618
  826873
]
14.42 ms
(9.54%)
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
  457119
  669281
  630254
  388791
  555982
  792775
  743641
  533290
  800767
  772483
  783204
  804120
  599020
  795867
  529176
  569315
  590721
  490675
  507243
  418521
  419619
  455373
  427100
  510950
  517439
  816618
  826873
  452934
  488908
  494293
  540593
  537237
  563998
  651953
  714703
  720071
  666031
  706026
  708851
  719342
  680969
  710054
  544912
  602247
  638197
  643191
  600830
  607757
  615413
  617566
  618228
  637363
  607845
  610015
  615357
  628511
  644171
  590835
  591781
  612291
  637347
  794931
  798764
  807999
  810096
  781765
  788753
  802241
  803786
  812312
  742336
  750306
  750680
  787265
  795902
  801531
  802328
  812551
  749513
  730414
  731758
  748648
  726448
  742330
  746106
  727283
  740905
  766307
  602318
  626402
  634080
  643737
  711211
  784302
  795816
  806667
  385000
  517881
  698156
  666711
  683720
  750626
  774674
  506070
  733217
  423958
  816158
  492412
  505353
  487618
  488993
  546039
  664504
  606254
  603359
  776217
  801772
  415029
  440641
  470979
]
2.97 ms
(1.96%)
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
  385000
  388791
  415029
  418521
  419619
  423958
  427100
  440641
  452934
  455373
  457119
  470979
  487618
  488908
  488993
  490675
  492412
  494293
  505353
  506070
  507243
  510950
  517439
  517881
  529176
  533290
  537237
  540593
  544912
  546039
  555982
  563998
  569315
  590721
  590835
  591781
  599020
  600830
  602247
  602318
  603359
  606254
  607757
  607845
  610015
  612291
  615357
  615413
  617566
  618228
  626402
  628511
  630254
  634080
  637347
  637363
  638197
  643191
  643737
  644171
  651953
  664504
  666031
  666711
  669281
  680969
  683720
  698156
  706026
  708851
  710054
  711211
  714703
  719342
  720071
  726448
  727283
  730414
  731758
  733217
  740905
  742330
  742336
  743641
  746106
  748648
  749513
  750306
  750626
  750680
  766307
  772483
  774674
  776217
  781765
  783204
  784302
  787265
  788753
  792775
  794931
  795816
  795867
  795902
  798764
  800767
  801531
  801772
  802241
  802328
  803786
  804120
  806667
  807999
  810096
  812312
  812551
  816158
  816618
  826873
]
1.94 ms
(1.28%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.66 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hairy pussy masturbation"
]
1.46 ms
(0.96%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "волосатая pussy мастурбац"
]
1.30 ms
(0.86%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "волосатая pussy мастурбац"
]

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.