Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
203.41 ms
(89.34%)
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
  12203
  382692
  392909
  395920
  401940
  402458
  423094
  440261
  446061
  446626
  451591
  457701
  462273
  462285
  462352
  471992
  472305
  472859
  472972
  485917
  489648
  493260
  495331
  497519
  503308
  506518
  512948
  513458
  516692
  518308
  522857
  531290
  534539
  540705
  541568
  547429
  548113
  554892
  555066
  558903
  560696
  561097
  568477
  571221
  577678
  581006
  590372
  590461
  590795
  605218
  614237
  617711
  626400
  628258
  628656
  629656
  648674
  656804
  660441
  663747
  671247
  680797
  685466
  685513
  685523
  685524
  693496
  694288
  696103
  707323
  710400
  714033
  714037
  714056
  717543
  719249
  721885
  721909
  722014
  726878
  727796
  729929
  734386
  736444
  739151
  745081
  745912
  747098
  747129
  747503
  749204
  751441
  758028
  760924
  761152
  761157
  761160
  762771
  764868
  766692
  766696
  768042
  768759
  769104
  772960
  775203
  776918
  778867
  778989
  778992
  784298
  784816
  786790
  787013
  794116
  800304
  805241
  817375
  819005
  819020
]
14.00 ms
(6.15%)
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
  693496
  778989
  696103
  778867
  560696
  714033
  776918
  819020
  547429
  402458
  462285
  768042
  761160
  382692
  648674
  629656
  590372
  794116
  736444
  769104
  749204
  762771
  714037
  660441
  721909
  577678
  531290
  714056
  590795
  747129
  555066
  446626
  707323
  495331
  745081
  772960
  462352
  568477
  758028
  503308
  656804
  628258
  617711
  721885
  512948
  541568
  558903
  605218
  440261
  719249
  768759
  472305
  571221
  395920
  685513
  457701
  729929
  761157
  497519
  671247
  554892
  614237
  747503
  726878
  764868
  745912
  766692
  493260
  819005
  760924
  423094
  747098
  522857
  778992
  506518
  472859
  446061
  451591
  680797
  685466
  685524
  401940
  817375
  548113
  800304
  472972
  581006
  513458
  462273
  787013
  739151
  561097
  784298
  518308
  12203
  734386
  722014
  485917
  516692
  626400
  751441
  761152
  710400
  489648
  392909
  534539
  663747
  694288
  717543
  628656
  784816
  786790
  805241
  766696
  727796
  775203
  540705
  685523
  590461
  471992
]
3.35 ms
(1.47%)
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
  12203
  382692
  392909
  395920
  401940
  402458
  423094
  440261
  446061
  446626
  451591
  457701
  462273
  462285
  462352
  471992
  472305
  472859
  472972
  485917
  489648
  493260
  495331
  497519
  503308
  506518
  512948
  513458
  516692
  518308
  522857
  531290
  534539
  540705
  541568
  547429
  548113
  554892
  555066
  558903
  560696
  561097
  568477
  571221
  577678
  581006
  590372
  590461
  590795
  605218
  614237
  617711
  626400
  628258
  628656
  629656
  648674
  656804
  660441
  663747
  671247
  680797
  685466
  685513
  685523
  685524
  693496
  694288
  696103
  707323
  710400
  714033
  714037
  714056
  717543
  719249
  721885
  721909
  722014
  726878
  727796
  729929
  734386
  736444
  739151
  745081
  745912
  747098
  747129
  747503
  749204
  751441
  758028
  760924
  761152
  761157
  761160
  762771
  764868
  766692
  766696
  768042
  768759
  769104
  772960
  775203
  776918
  778867
  778989
  778992
  784298
  784816
  786790
  787013
  794116
  800304
  805241
  817375
  819005
  819020
]
2.05 ms
(0.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "public wife anal"
]
1.82 ms
(0.80%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "на улиц жен анал"
]
1.71 ms
(0.75%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.36 ms
(0.60%)
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.