Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
165.51 ms
(86.65%)
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
  27593
  34428
  98951
  384796
  386430
  386925
  389355
  390455
  392676
  394035
  396779
  407176
  425095
  428598
  442842
  447217
  454106
  459403
  466793
  490807
  505097
  511435
  515662
  528844
  530112
  531561
  535072
  535694
  535984
  539591
  544704
  546500
  546903
  547100
  548305
  549897
  570824
  571785
  578598
  582435
  584223
  595071
  595386
  595389
  595991
  601199
  613780
  618675
  623941
  627010
  633207
  634215
  639986
  647306
  672343
  693701
  695707
  709848
  720193
  721712
  723774
  726115
  730620
  732971
  738852
  751245
  752669
  757650
  757715
  758777
  759343
  759356
  760454
  762118
  765767
  767675
  768233
  768937
  770522
  787254
  787466
  787516
  793482
  793676
  793815
  796327
  796706
  799382
  800537
  801686
  802415
  803543
  803635
  803877
  804114
  804527
  804557
  804568
  806075
  806422
  807112
  807310
  807362
  807787
  811120
  811251
  811700
  817563
  817570
  819262
  824560
  824868
  824962
  826161
  828415
  828760
]
15.26 ms
(7.99%)
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
  799382
  800537
  767675
  793815
  796706
  762118
  738852
  757650
  757715
  618675
  801686
  811120
  407176
  490807
  802415
  793482
  390455
  571785
  613780
  98951
  768937
  34428
  386925
  819262
  824868
  466793
  530112
  535694
  721712
  695707
  720193
  693701
  578598
  595389
  595991
  634215
  787466
  807362
  811700
  804557
  806075
  806422
  803543
  759356
  765767
  770522
  633207
  803877
  804114
  807112
  425095
  428598
  454106
  824210
  828760
  828415
  726115
  822371
  539591
  549897
  27593
  824560
  793676
  732971
  759343
  751245
  822273
  822882
  623941
  389355
  442842
  459403
  447217
  511435
  528844
  535072
  535984
  505097
  531561
  544704
  546903
  582435
  584223
  672343
  709848
  595071
  601199
  595386
  627010
  804527
  804568
  768233
  787516
  803635
  752669
  758777
  760454
  796327
  807310
  807787
  392676
  515662
  723774
  386430
  384796
  394035
  396779
  817563
  817570
  824962
  547100
  546500
  548305
  570824
  647306
  639986
  787254
  811251
  730620
  826161
]
3.12 ms
(1.63%)
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
  27593
  34428
  98951
  384796
  386430
  386925
  389355
  390455
  392676
  394035
  396779
  407176
  425095
  428598
  442842
  447217
  454106
  459403
  466793
  490807
  505097
  511435
  515662
  528844
  530112
  531561
  535072
  535694
  535984
  539591
  544704
  546500
  546903
  547100
  548305
  549897
  570824
  571785
  578598
  582435
  584223
  595071
  595386
  595389
  595991
  601199
  613780
  618675
  623941
  627010
  633207
  634215
  639986
  647306
  672343
  693701
  695707
  709848
  720193
  721712
  723774
  726115
  730620
  732971
  738852
  751245
  752669
  757650
  757715
  758777
  759343
  759356
  760454
  762118
  765767
  767675
  768233
  768937
  770522
  787254
  787466
  787516
  793482
  793676
  793815
  796327
  796706
  799382
  800537
  801686
  802415
  803543
  803635
  803877
  804114
  804527
  804557
  804568
  806075
  806422
  807112
  807310
  807362
  807787
  811120
  811251
  811700
  817563
  817570
  819262
  824560
  824868
  824962
  826161
  828415
  828760
]
2.17 ms
(1.13%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.73 ms
(0.91%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "riding milf"
]
1.66 ms
(0.87%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "riding milf"
]
1.56 ms
(0.82%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "riding 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.