Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
116.47 ms
(84.89%)
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
  3786
  91829
  358193
  382816
  392043
  393423
  394064
  395349
  398930
  405974
  428087
  458948
  459451
  494681
  497841
  514196
  534719
  535152
  538114
  565895
  568184
  575000
  575680
  585785
  588119
  590060
  590176
  590584
  592680
  593887
  596335
  596965
  597218
  601455
  612535
  615256
  619563
  620568
  627279
  633903
  634007
  635019
  635404
  636430
  636585
  642143
  645509
  648952
  649276
  650696
  650746
  651917
  652109
  652338
  653174
  665601
  665954
  691207
  691676
  706816
  708664
  710123
  710278
  711102
  711278
  713830
  717927
  719823
  726283
  726578
  737240
  738887
  738957
  740632
  747068
  755726
  759752
  762609
  764384
  764856
  765279
  765997
  767465
  767861
  768445
  769289
  770455
  774218
  775442
  778184
  778287
  778513
  778597
  778667
  779233
  779577
  780257
  780401
  780882
  782383
  782390
  783530
  783658
  785740
  789082
  789355
  789411
  789911
  790250
  790772
  790936
  797188
  797344
  797889
  802893
  827222
]
11.09 ms
(8.08%)
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
  565895
  575000
  645509
  652338
  665954
  706816
  710278
  713830
  648952
  652109
  653174
  691207
  650696
  665601
  710123
  717927
  575680
  596335
  597218
  620568
  590060
  592680
  634007
  636585
  590584
  612535
  635019
  593887
  596965
  619563
  627279
  790772
  797344
  767421
  789411
  797889
  755726
  615256
  635404
  708664
  711278
  780257
  789355
  585785
  738887
  642143
  797188
  769527
  3786
  405974
  428087
  827222
  538114
  494681
  534719
  651917
  711102
  650746
  719823
  633903
  636430
  783658
  790936
  775442
  782383
  782390
  765279
  789082
  802893
  769289
  740632
  747068
  762609
  764896
  768445
  759752
  764384
  764856
  765782
  767465
  770455
  778287
  778667
  779233
  780882
  785740
  458948
  778184
  588119
  497841
  91829
  393423
  394064
  395349
  459451
  780401
  726283
  765997
  783530
  789911
  790250
  774218
  778513
  778597
  382816
  392043
  649276
  726578
  737240
  358193
  514196
  779577
  568184
  398930
  738957
  535152
  601455
  691676
  590176
  767861
]
2.57 ms
(1.87%)
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
  3786
  91829
  358193
  382816
  392043
  393423
  394064
  395349
  398930
  405974
  428087
  458948
  459451
  494681
  497841
  514196
  534719
  535152
  538114
  565895
  568184
  575000
  575680
  585785
  588119
  590060
  590176
  590584
  592680
  593887
  596335
  596965
  597218
  601455
  612535
  615256
  619563
  620568
  627279
  633903
  634007
  635019
  635404
  636430
  636585
  642143
  645509
  648952
  649276
  650696
  650746
  651917
  652109
  652338
  653174
  665601
  665954
  691207
  691676
  706816
  708664
  710123
  710278
  711102
  711278
  713830
  717927
  719823
  726283
  726578
  737240
  738887
  738957
  740632
  747068
  755726
  759752
  762609
  764384
  764856
  765279
  765997
  767465
  767861
  768445
  769289
  770455
  774218
  775442
  778184
  778287
  778513
  778597
  778667
  779233
  779577
  780257
  780401
  780882
  782383
  782390
  783530
  783658
  785740
  789082
  789355
  789411
  789911
  790250
  790772
  790936
  797188
  797344
  797889
  802893
  827222
]
1.92 ms
(1.40%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "изменяет мужу частное…"
]
1.88 ms
(1.37%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.81 ms
(1.32%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен жен любительск"
]
1.46 ms
(1.06%)
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.