Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
140.30 ms
(82.33%)
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
  238715
  330409
  385454
  389766
  392558
  393042
  404394
  495884
  529682
  531391
  531704
  533269
  534015
  535349
  536823
  536973
  536976
  537765
  538733
  539528
  540519
  542878
  543427
  547092
  547252
  550486
  550552
  551024
  553212
  555164
  567125
  567953
  570693
  570893
  584400
  584864
  585295
  587457
  595848
  602271
  616963
  636926
  637549
  642640
  642903
  645259
  645533
  646040
  647770
  652563
  663552
  668556
  668827
  670069
  670716
  671875
  685114
  695594
  696265
  698213
  698353
  701018
  701230
  712621
  713411
  718400
  726996
  728906
  730949
  731347
  732658
  734596
  737429
  745567
  746347
  748088
  748102
  748627
  753067
  760969
  761405
  764086
  768783
  771145
  771695
  779147
  780735
  783732
  787901
  789644
  790935
  792244
  796498
  796785
  799783
  799823
  810545
  817764
  818853
  819316
  820748
  823933
  824658
  825108
  825409
  825456
  825460
  825615
  825822
  826183
  826255
  826445
  826536
  826551
  826820
  828148
  828248
  828495
]
18.01 ms
(10.57%)
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
  540519
  531391
  536823
  535349
  542878
  570893
  652563
  663552
  695594
  547252
  595848
  783732
  787901
  792244
  799783
  730949
  748088
  760969
  771145
  771695
  731347
  732658
  790935
  238715
  796785
  761405
  385454
  392558
  330409
  764086
  389766
  826228
  825822
  825108
  826255
  825409
  826183
  826551
  828248
  828148
  828495
  551024
  780735
  796498
  728906
  745567
  393042
  637549
  671875
  567953
  534015
  495884
  531704
  533269
  536976
  584864
  547092
  550552
  646040
  645259
  647770
  701018
  712621
  645533
  668556
  685114
  696265
  698213
  713411
  718400
  567125
  587457
  636926
  642903
  585295
  642640
  602271
  616963
  748627
  810545
  698353
  670069
  537765
  555164
  553212
  570693
  668827
  404394
  824658
  825456
  825460
  826536
  817764
  819316
  826820
  818853
  820748
  825386
  825615
  826445
  823933
  529682
  536973
  538733
  539528
  550486
  543427
  670716
  701230
  584400
  789644
  779147
  746347
  768783
  799823
  734596
  748102
  753067
  726996
  737429
]
4.01 ms
(2.35%)
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
  238715
  330409
  385454
  389766
  392558
  393042
  404394
  495884
  529682
  531391
  531704
  533269
  534015
  535349
  536823
  536973
  536976
  537765
  538733
  539528
  540519
  542878
  543427
  547092
  547252
  550486
  550552
  551024
  553212
  555164
  567125
  567953
  570693
  570893
  584400
  584864
  585295
  587457
  595848
  602271
  616963
  636926
  637549
  642640
  642903
  645259
  645533
  646040
  647770
  652563
  663552
  668556
  668827
  670069
  670716
  671875
  685114
  695594
  696265
  698213
  698353
  701018
  701230
  712621
  713411
  718400
  726996
  728906
  730949
  731347
  732658
  734596
  737429
  745567
  746347
  748088
  748102
  748627
  753067
  760969
  761405
  764086
  768783
  771145
  771695
  779147
  780735
  783732
  787901
  789644
  790935
  792244
  796498
  796785
  799783
  799823
  810545
  817764
  818853
  819316
  820748
  823933
  824658
  825108
  825409
  825456
  825460
  825615
  825822
  826183
  826255
  826445
  826536
  826551
  826820
  828148
  828248
  828495
]
2.18 ms
(1.28%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "черноволосая любительск"
]
2.13 ms
(1.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "brunette amateur"
]
1.94 ms
(1.14%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.83 ms
(1.07%)
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.