Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
137.34 ms
(86.41%)
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
  21956
  119798
  208504
  311884
  382101
  383704
  387180
  404532
  422103
  423983
  425843
  429800
  438450
  443502
  451730
  461239
  466654
  488788
  490847
  501055
  512649
  514922
  517665
  519758
  521795
  522006
  523304
  531019
  531885
  533768
  533914
  535034
  535187
  535710
  539965
  542905
  544896
  548155
  550030
  552462
  553587
  553876
  556184
  558483
  558631
  564027
  574189
  598240
  599954
  601439
  601811
  603377
  609725
  614222
  615965
  616140
  617496
  624698
  630211
  636708
  645354
  647383
  648433
  648453
  652952
  671534
  679230
  683270
  690013
  692001
  693940
  696304
  699900
  700246
  700860
  706384
  706847
  713327
  715988
  719647
  721003
  721390
  722305
  724972
  735876
  737055
  739245
  751592
  755484
  758370
  759817
  760472
  762598
  771726
  774824
  775657
  776137
  778396
  779177
  780851
  781481
  782521
  783309
  783672
  784369
  785039
  785042
  786200
  786779
  787477
  796043
  798591
  799162
  806753
  809954
  812628
  814195
  819164
  823348
  824951
]
11.21 ms
(7.05%)
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
  624698
  706847
  796043
  311884
  531885
  700860
  609725
  598240
  759817
  531019
  786200
  533768
  751592
  774824
  671534
  696304
  806753
  785042
  517665
  535034
  553876
  548155
  715988
  556184
  601439
  784369
  780851
  809954
  648433
  776137
  783672
  735876
  699900
  382101
  814195
  574189
  739245
  779177
  512649
  645354
  558631
  722305
  692001
  786779
  521795
  533914
  539965
  700246
  617496
  755484
  775657
  799162
  721003
  601811
  636708
  798591
  21956
  387180
  383704
  208504
  823348
  603377
  615965
  630211
  812628
  781481
  758370
  771726
  721390
  690013
  713327
  553587
  760472
  616140
  544896
  706384
  550030
  490847
  438450
  514922
  542905
  719647
  737055
  787477
  519758
  679230
  614222
  782521
  466654
  404532
  119798
  522006
  819164
  824951
  501055
  461239
  564027
  762598
  724972
  778396
  422103
  599954
  535187
  535710
  652952
  785039
  783309
  423983
  451730
  558483
  488788
  683270
  647383
  429800
  425843
  443502
  523304
  552462
  693940
  648453
]
3.05 ms
(1.92%)
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
  21956
  119798
  208504
  311884
  382101
  383704
  387180
  404532
  422103
  423983
  425843
  429800
  438450
  443502
  451730
  461239
  466654
  488788
  490847
  501055
  512649
  514922
  517665
  519758
  521795
  522006
  523304
  531019
  531885
  533768
  533914
  535034
  535187
  535710
  539965
  542905
  544896
  548155
  550030
  552462
  553587
  553876
  556184
  558483
  558631
  564027
  574189
  598240
  599954
  601439
  601811
  603377
  609725
  614222
  615965
  616140
  617496
  624698
  630211
  636708
  645354
  647383
  648433
  648453
  652952
  671534
  679230
  683270
  690013
  692001
  693940
  696304
  699900
  700246
  700860
  706384
  706847
  713327
  715988
  719647
  721003
  721390
  722305
  724972
  735876
  737055
  739245
  751592
  755484
  758370
  759817
  760472
  762598
  771726
  774824
  775657
  776137
  778396
  779177
  780851
  781481
  782521
  783309
  783672
  784369
  785039
  785042
  786200
  786779
  787477
  796043
  798591
  799162
  806753
  809954
  812628
  814195
  819164
  823348
  824951
]
2.05 ms
(1.29%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "dance girls"
]
1.77 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "танец девушк"
]
1.76 ms
(1.11%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "танец девушк"
]
1.76 ms
(1.11%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.