Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
122.71 ms
(77.53%)
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
  98543
  401626
  406085
  409929
  414769
  415630
  419989
  425330
  426043
  427241
  428719
  439434
  441067
  442301
  442325
  442339
  442613
  442831
  443240
  443847
  445530
  451239
  454467
  455117
  457034
  457433
  457946
  461185
  461731
  461805
  461944
  465490
  465698
  470125
  470835
  471699
  472189
  474188
  474495
  475575
  475911
  476128
  477252
  479956
  482768
  486438
  486530
  488155
  488391
  488457
  495434
  496285
  498345
  498388
  501259
  502748
  504755
  505537
  506227
  508786
  510836
  512936
  513138
  514740
  515398
  516483
  516780
  516787
  517800
  517885
  519108
  519723
  519735
  521287
  521520
  522953
  523323
  523907
  524296
  525186
  525706
  525890
  526714
  526830
  526842
  526994
  527181
  528318
  529338
  529801
  529811
  531656
  532161
  532164
  532441
  533643
  537020
  537833
  542902
  543576
  549362
  549730
  555040
  562346
  578657
  580113
  595054
  602666
  603055
  612335
  625436
  626810
  634202
  635678
  645270
  646432
  663297
  680037
  689755
  750611
]
24.68 ms
(15.59%)
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
  474188
  479956
  425330
  443847
  461185
  461944
  470835
  442325
  442339
  443240
  471699
  516780
  522953
  526842
  528318
  498388
  502748
  517800
  517885
  519735
  506227
  516483
  523323
  525186
  537020
  488155
  495434
  510836
  513138
  526830
  526994
  527181
  414769
  486438
  532164
  612335
  525890
  519723
  98543
  415630
  409929
  427241
  442831
  428719
  663297
  465490
  445530
  461731
  465698
  472189
  477252
  512936
  533643
  498345
  505537
  529338
  529811
  532441
  532161
  515398
  529801
  531656
  537833
  470125
  488457
  543576
  578657
  580113
  549362
  555040
  562346
  542902
  549730
  680037
  645270
  646432
  689755
  625436
  626810
  595054
  634202
  602666
  603055
  635678
  750611
  426043
  475911
  457946
  401626
  455117
  474495
  419989
  461805
  451239
  457433
  475575
  521520
  523907
  525706
  526714
  508786
  521287
  488391
  514740
  496285
  516787
  406085
  439434
  441067
  442301
  442613
  454467
  457034
  476128
  482768
  486530
  504755
  519108
  524296
  501259
]
3.16 ms
(1.99%)
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
  98543
  401626
  406085
  409929
  414769
  415630
  419989
  425330
  426043
  427241
  428719
  439434
  441067
  442301
  442325
  442339
  442613
  442831
  443240
  443847
  445530
  451239
  454467
  455117
  457034
  457433
  457946
  461185
  461731
  461805
  461944
  465490
  465698
  470125
  470835
  471699
  472189
  474188
  474495
  475575
  475911
  476128
  477252
  479956
  482768
  486438
  486530
  488155
  488391
  488457
  495434
  496285
  498345
  498388
  501259
  502748
  504755
  505537
  506227
  508786
  510836
  512936
  513138
  514740
  515398
  516483
  516780
  516787
  517800
  517885
  519108
  519723
  519735
  521287
  521520
  522953
  523323
  523907
  524296
  525186
  525706
  525890
  526714
  526830
  526842
  526994
  527181
  528318
  529338
  529801
  529811
  531656
  532161
  532164
  532441
  533643
  537020
  537833
  542902
  543576
  549362
  549730
  555040
  562346
  578657
  580113
  595054
  602666
  603055
  612335
  625436
  626810
  634202
  635678
  645270
  646432
  663297
  680037
  689755
  750611
]
2.19 ms
(1.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "milf video"
]
2.13 ms
(1.35%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.73 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "milf video"
]
1.69 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "milf video"
]

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.