Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
122.54 ms
(80.96%)
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
  4311
  233335
  391572
  417293
  420003
  420577
  423957
  425541
  446492
  451701
  453767
  457018
  458360
  458642
  466398
  469620
  476297
  476487
  476758
  483218
  493777
  526303
  533706
  536062
  542701
  545770
  545906
  546059
  546360
  546629
  547786
  548387
  555001
  555005
  559396
  560981
  564688
  565080
  565657
  567240
  568591
  571432
  572361
  572690
  573279
  574408
  574609
  578005
  578169
  581514
  585735
  588695
  593774
  601606
  608814
  620259
  623745
  624599
  631341
  641128
  649329
  663842
  666464
  670272
  673420
  678698
  683305
  685381
  685422
  685509
  685524
  690746
  695788
  701888
  714865
  729205
  731652
  733661
  734140
  736847
  737095
  742405
  745963
  747429
  754657
  758182
  760428
  761607
  762193
  763876
  764173
  765112
  766011
  768042
  768453
  768491
  768643
  769133
  769141
  769409
  779255
  779637
  782184
  784319
  788072
  790307
  792307
  794073
  795803
  804924
  809551
  819945
  823647
  824084
  825719
  827564
  827937
  828151
  828563
]
20.48 ms
(13.53%)
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
  545906
  578005
  663842
  649329
  673919
  683305
  685381
  685422
  685524
  695788
  701888
  567240
  588695
  601606
  608814
  623745
  809551
  779255
  731652
  737095
  784319
  788072
  794073
  762193
  766011
  768453
  729205
  733661
  768042
  736847
  768491
  747429
  758182
  761607
  764173
  714865
  782184
  233335
  420577
  417293
  533706
  742405
  458360
  391572
  819945
  823647
  825719
  827937
  457018
  571432
  4311
  827564
  824084
  828151
  828563
  565080
  631341
  790307
  795803
  804924
  792307
  768643
  769141
  769133
  754657
  745963
  446492
  458642
  483218
  476297
  493777
  526303
  536062
  545770
  546360
  546629
  565657
  574408
  546059
  578169
  542701
  548387
  555001
  560981
  572361
  572690
  673420
  678698
  685509
  690746
  666464
  670272
  547786
  555005
  559396
  564688
  568591
  573279
  574609
  581514
  585735
  593774
  620259
  624599
  641128
  779637
  734140
  760428
  769409
  765112
  763876
  420003
  423957
  451701
  466398
  476487
  425541
  453767
  469620
  476758
]
2.41 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
  4311
  233335
  391572
  417293
  420003
  420577
  423957
  425541
  446492
  451701
  453767
  457018
  458360
  458642
  466398
  469620
  476297
  476487
  476758
  483218
  493777
  526303
  533706
  536062
  542701
  545770
  545906
  546059
  546360
  546629
  547786
  548387
  555001
  555005
  559396
  560981
  564688
  565080
  565657
  567240
  568591
  571432
  572361
  572690
  573279
  574408
  574609
  578005
  578169
  581514
  585735
  588695
  593774
  601606
  608814
  620259
  623745
  624599
  631341
  641128
  649329
  663842
  666464
  670272
  673420
  678698
  683305
  685381
  685422
  685509
  685524
  690746
  695788
  701888
  714865
  729205
  731652
  733661
  734140
  736847
  737095
  742405
  745963
  747429
  754657
  758182
  760428
  761607
  762193
  763876
  764173
  765112
  766011
  768042
  768453
  768491
  768643
  769133
  769141
  769409
  779255
  779637
  782184
  784319
  788072
  790307
  792307
  794073
  795803
  804924
  809551
  819945
  823647
  824084
  825719
  827564
  827937
  828151
  828563
]
1.66 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "крупно русское"
]
1.56 ms
(1.03%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "крупныйпла русск"
]
1.42 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "крупныйпла русск"
]
1.30 ms
(0.86%)
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.