Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
171.83 ms
(87.98%)
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
  173865
  329912
  346122
  387271
  389733
  413098
  416402
  419063
  425469
  446760
  455693
  468502
  482420
  482737
  483723
  484938
  494457
  499296
  501137
  505572
  509053
  512558
  521842
  523869
  535331
  535852
  540416
  541906
  543485
  545042
  545669
  545933
  548895
  553810
  558110
  560289
  570698
  586311
  593586
  597093
  604404
  607432
  609164
  609885
  635129
  636418
  642456
  649347
  650044
  652971
  667907
  680772
  690020
  694197
  700918
  716341
  718111
  725226
  726980
  728662
  729853
  729968
  730109
  734860
  742340
  744376
  746352
  746988
  754666
  757064
  759029
  759886
  760868
  765922
  766953
  769573
  775008
  784381
  788678
  791034
  795348
  795756
  795830
  795834
  799028
  800817
  800828
  801104
  801426
  801439
  801456
  802074
  802099
  802388
  803787
  804015
  809082
  809791
  810328
  810583
  811314
  817249
  818916
  824543
  824573
  825911
  825954
  826206
  826239
  826335
  827121
  827165
  827267
  827552
  828498
  828607
  828829
]
14.07 ms
(7.20%)
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
  825178
  827121
  827165
  827267
  827552
  818916
  824543
  824686
  825911
  826239
  826335
  824573
  825954
  828829
  828607
  828498
  482420
  499296
  540416
  509053
  535852
  468502
  543485
  545669
  545933
  541906
  548895
  558110
  700918
  650044
  667907
  649347
  716341
  718111
  553810
  642456
  597093
  586311
  636418
  775008
  795830
  801104
  801439
  802388
  809082
  810583
  800828
  801422
  801456
  802074
  804015
  729853
  729968
  746352
  759029
  760868
  784381
  795834
  802099
  803787
  725226
  746988
  757064
  730109
  734860
  742340
  754666
  766953
  744376
  765922
  769573
  788678
  795348
  795756
  800817
  801426
  810328
  387271
  173865
  416402
  826206
  817249
  501137
  545042
  694197
  652971
  680772
  811314
  728662
  759886
  726980
  635129
  799028
  809791
  505572
  560289
  690020
  604404
  609885
  593586
  607432
  791034
  425469
  419063
  523869
  609164
  512558
  494457
  570698
  482737
  346122
  446760
  483723
  484938
  521842
  413098
  455693
  535331
  329912
  389733
]
2.68 ms
(1.37%)
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
  173865
  329912
  346122
  387271
  389733
  413098
  416402
  419063
  425469
  446760
  455693
  468502
  482420
  482737
  483723
  484938
  494457
  499296
  501137
  505572
  509053
  512558
  521842
  523869
  535331
  535852
  540416
  541906
  543485
  545042
  545669
  545933
  548895
  553810
  558110
  560289
  570698
  586311
  593586
  597093
  604404
  607432
  609164
  609885
  635129
  636418
  642456
  649347
  650044
  652971
  667907
  680772
  690020
  694197
  700918
  716341
  718111
  725226
  726980
  728662
  729853
  729968
  730109
  734860
  742340
  744376
  746352
  746988
  754666
  757064
  759029
  759886
  760868
  765922
  766953
  769573
  775008
  784381
  788678
  791034
  795348
  795756
  795830
  795834
  799028
  800817
  800828
  801104
  801426
  801439
  801456
  802074
  802099
  802388
  803787
  804015
  809082
  809791
  810328
  810583
  811314
  817249
  818916
  824543
  824573
  825911
  825954
  826206
  826239
  826335
  827121
  827165
  827267
  827552
  828498
  828607
  828829
]
2.04 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "webcam brunette milf"
]
1.68 ms
(0.86%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "вебкамер черноволосая milf"
]
1.66 ms
(0.85%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.36 ms
(0.70%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "вебкамер черноволосая milf"
]

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.