Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
183.78 ms
(87.57%)
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
  166675
  400486
  418566
  421914
  422141
  422151
  422152
  423311
  424124
  426414
  439743
  440265
  440414
  440441
  440580
  440890
  440900
  440954
  442629
  443161
  443166
  443182
  451494
  454801
  460046
  461843
  463313
  464853
  465382
  466799
  468129
  470609
  471786
  472652
  474146
  474778
  478983
  481644
  484440
  488948
  490158
  493083
  503954
  509609
  513498
  516483
  520998
  523514
  526393
  530318
  531377
  534207
  539531
  554353
  560968
  565275
  577602
  583096
  583564
  603601
  604221
  605956
  610118
  625435
  631865
  635133
  656219
  669189
  670084
  670715
  685061
  694568
  699090
  714602
  716570
  716877
  718235
  719294
  720612
  724681
  727451
  727783
  728905
  729789
  730104
  730478
  730641
  735920
  737468
  738420
  746453
  751958
  756875
  757910
  759014
  768047
  769291
  771412
  775826
  779410
  790831
  791709
  794421
  794516
  794709
  795771
  798884
  800024
  801500
  802044
  813667
  814762
  814763
  815442
  815917
  815973
  816001
  816568
  816951
  817688
]
16.13 ms
(7.69%)
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
  534207
  539531
  554353
  699090
  716877
  718235
  714602
  694568
  635133
  631865
  603601
  779410
  794516
  794709
  800024
  790831
  791709
  795771
  724681
  728905
  738420
  730478
  746453
  737468
  768047
  771412
  610118
  798884
  801500
  802044
  440414
  440580
  440890
  443182
  423311
  816568
  464853
  474146
  530318
  520998
  583096
  656219
  685061
  670084
  605956
  604221
  625435
  751958
  769291
  759014
  443161
  443166
  466799
  400486
  418566
  426414
  460046
  493083
  523514
  440954
  454801
  560968
  727783
  461843
  516483
  440900
  463313
  488948
  424124
  474778
  465382
  468129
  421914
  816951
  490158
  583564
  794421
  513498
  166675
  478983
  481644
  670715
  719294
  757910
  756875
  470609
  451494
  526393
  422151
  813667
  814762
  816001
  814763
  815973
  817688
  815917
  503954
  531377
  577602
  716570
  720612
  729789
  730641
  727451
  775826
  440265
  440441
  442629
  471786
  509609
  484440
  422152
  422141
  815442
  472652
  669189
  565275
  730104
  735920
  439743
]
4.08 ms
(1.94%)
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
  166675
  400486
  418566
  421914
  422141
  422151
  422152
  423311
  424124
  426414
  439743
  440265
  440414
  440441
  440580
  440890
  440900
  440954
  442629
  443161
  443166
  443182
  451494
  454801
  460046
  461843
  463313
  464853
  465382
  466799
  468129
  470609
  471786
  472652
  474146
  474778
  478983
  481644
  484440
  488948
  490158
  493083
  503954
  509609
  513498
  516483
  520998
  523514
  526393
  530318
  531377
  534207
  539531
  554353
  560968
  565275
  577602
  583096
  583564
  603601
  604221
  605956
  610118
  625435
  631865
  635133
  656219
  669189
  670084
  670715
  685061
  694568
  699090
  714602
  716570
  716877
  718235
  719294
  720612
  724681
  727451
  727783
  728905
  729789
  730104
  730478
  730641
  735920
  737468
  738420
  746453
  751958
  756875
  757910
  759014
  768047
  769291
  771412
  775826
  779410
  790831
  791709
  794421
  794516
  794709
  795771
  798884
  800024
  801500
  802044
  813667
  814762
  814763
  815442
  815917
  815973
  816001
  816568
  816951
  817688
]
1.60 ms
(0.76%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.56 ms
(0.74%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мам женщин real"
]
1.39 ms
(0.66%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mother real"
]
1.32 ms
(0.63%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "мам женщин real"
]

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.