Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
136.43 ms
(82.49%)
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
  13229
  391861
  391980
  392607
  411344
  423783
  430374
  434286
  434358
  434364
  434367
  434374
  439156
  439545
  440824
  440833
  440876
  444168
  444527
  461605
  466294
  467868
  467872
  467878
  467882
  467888
  467905
  468142
  468363
  474206
  476033
  478010
  480680
  493258
  494231
  502868
  505281
  505724
  505771
  508778
  509659
  510898
  511057
  511372
  511520
  513568
  513670
  514042
  519362
  530011
  531524
  533697
  547757
  547800
  547808
  547811
  547979
  549724
  550216
  552585
  555133
  555984
  558073
  560021
  594788
  594861
  595438
  600004
  604662
  605739
  609085
  631937
  636295
  650155
  658797
  659938
  669884
  669893
  669907
  683261
  712546
  718768
  718788
  725223
  731813
  734868
  735974
  736905
  741699
  742602
  744427
  744786
  750699
  750701
  751572
  751587
  751600
  764963
  768049
  774575
  776940
  778941
  783312
  792343
  794364
  794720
  794773
  795935
  795956
  802282
  803396
  803880
  805151
  806973
  810132
  810896
  811296
  816169
  816170
  824299
]
18.11 ms
(10.95%)
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
  778941
  751572
  776940
  505724
  734868
  434358
  439156
  513568
  478010
  731813
  391861
  712546
  430374
  461605
  467888
  502868
  802282
  810896
  669893
  468142
  555133
  631937
  811296
  467872
  768049
  511372
  440876
  750699
  816169
  816170
  725223
  434374
  467882
  444527
  494231
  13229
  468363
  605739
  806973
  718768
  774575
  519362
  511520
  493258
  550216
  440833
  803880
  423783
  533697
  750701
  444168
  810132
  744427
  751600
  736905
  751587
  391980
  467878
  434364
  434286
  508778
  794364
  794773
  795956
  555984
  474206
  735974
  513670
  547757
  560021
  467905
  480680
  600004
  547811
  558073
  744786
  531524
  510898
  439545
  434367
  411344
  683261
  511057
  669907
  669884
  792343
  805151
  783312
  741699
  547800
  718788
  594861
  604662
  594788
  530011
  476033
  650155
  595438
  764963
  509659
  547979
  659938
  742602
  636295
  392607
  549724
  467868
  514042
  547808
  505281
  609085
  658797
  794720
  795935
  552585
  466294
  440824
  824299
  803396
  505771
]
4.52 ms
(2.73%)
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
  13229
  391861
  391980
  392607
  411344
  423783
  430374
  434286
  434358
  434364
  434367
  434374
  439156
  439545
  440824
  440833
  440876
  444168
  444527
  461605
  466294
  467868
  467872
  467878
  467882
  467888
  467905
  468142
  468363
  474206
  476033
  478010
  480680
  493258
  494231
  502868
  505281
  505724
  505771
  508778
  509659
  510898
  511057
  511372
  511520
  513568
  513670
  514042
  519362
  530011
  531524
  533697
  547757
  547800
  547808
  547811
  547979
  549724
  550216
  552585
  555133
  555984
  558073
  560021
  594788
  594861
  595438
  600004
  604662
  605739
  609085
  631937
  636295
  650155
  658797
  659938
  669884
  669893
  669907
  683261
  712546
  718768
  718788
  725223
  731813
  734868
  735974
  736905
  741699
  742602
  744427
  744786
  750699
  750701
  751572
  751587
  751600
  764963
  768049
  774575
  776940
  778941
  783312
  792343
  794364
  794720
  794773
  795935
  795956
  802282
  803396
  803880
  805151
  806973
  810132
  810896
  811296
  816169
  816170
  824299
]
2.09 ms
(1.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "русские зрелые оргазмы"
]
1.53 ms
(0.93%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск зрелая женщин оргазм"
]
1.49 ms
(0.90%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.22 ms
(0.74%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.