Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
127.24 ms
(83.55%)
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
  398992
  412419
  456849
  460691
  468123
  472788
  474959
  477185
  477565
  478758
  479067
  481663
  483038
  488520
  492416
  494596
  499210
  501480
  507080
  512670
  513876
  514659
  515984
  519927
  520405
  530395
  537645
  542766
  545014
  545785
  547931
  553443
  554866
  556319
  560460
  561124
  564006
  567343
  567600
  568314
  573362
  577460
  578717
  578737
  578760
  578770
  578898
  581305
  581632
  582356
  583981
  586560
  586765
  587677
  587727
  592728
  594772
  594910
  595811
  599209
  602970
  604985
  604997
  605009
  605544
  605553
  607029
  635481
  636510
  638441
  646240
  647308
  651026
  651227
  661954
  663328
  664842
  665276
  666068
  670090
  676157
  677133
  686095
  694135
  695784
  695799
  704878
  712670
  713444
  721712
  722534
  725930
  730753
  730943
  732551
  732577
  732792
  732938
  733521
  733577
  734413
  736401
  738868
  742692
  745019
  746837
  747901
  748711
  755447
  759413
  759760
  760217
  766514
  773947
  789976
  797164
  800014
  807544
  815233
  815517
]
15.06 ms
(9.89%)
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
  604985
  604997
  605009
  730943
  733577
  733521
  738868
  545785
  514659
  766514
  578760
  483038
  460691
  547931
  578898
  815233
  537645
  530395
  564006
  577460
  677133
  664842
  676157
  594910
  595811
  594772
  586765
  587727
  800014
  736401
  746837
  789976
  797164
  732551
  745019
  747901
  725930
  759413
  713444
  722534
  412419
  472788
  542766
  694135
  721712
  695784
  666068
  638441
  759760
  507080
  474959
  481663
  513876
  515984
  554866
  545014
  599209
  602970
  734413
  732792
  773947
  732938
  398992
  573362
  468123
  605544
  456849
  499210
  556319
  663328
  635481
  636510
  730753
  760217
  748711
  755447
  488520
  477185
  520405
  578737
  578770
  586560
  732577
  567343
  686095
  519927
  501480
  583981
  592728
  605553
  477565
  578717
  581305
  651026
  661954
  567600
  607029
  742692
  807544
  815517
  492416
  494596
  512670
  478758
  479067
  553443
  568314
  581632
  646240
  665276
  695799
  651227
  704878
  712670
  647308
  670090
  560460
  561124
  582356
  587677
]
3.07 ms
(2.01%)
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
  398992
  412419
  456849
  460691
  468123
  472788
  474959
  477185
  477565
  478758
  479067
  481663
  483038
  488520
  492416
  494596
  499210
  501480
  507080
  512670
  513876
  514659
  515984
  519927
  520405
  530395
  537645
  542766
  545014
  545785
  547931
  553443
  554866
  556319
  560460
  561124
  564006
  567343
  567600
  568314
  573362
  577460
  578717
  578737
  578760
  578770
  578898
  581305
  581632
  582356
  583981
  586560
  586765
  587677
  587727
  592728
  594772
  594910
  595811
  599209
  602970
  604985
  604997
  605009
  605544
  605553
  607029
  635481
  636510
  638441
  646240
  647308
  651026
  651227
  661954
  663328
  664842
  665276
  666068
  670090
  676157
  677133
  686095
  694135
  695784
  695799
  704878
  712670
  713444
  721712
  722534
  725930
  730753
  730943
  732551
  732577
  732792
  732938
  733521
  733577
  734413
  736401
  738868
  742692
  745019
  746837
  747901
  748711
  755447
  759413
  759760
  760217
  766514
  773947
  789976
  797164
  800014
  807544
  815233
  815517
]
1.93 ms
(1.27%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "wife milf cuckold"
]
1.76 ms
(1.16%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен milf куколд"
]
1.75 ms
(1.15%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.49 ms
(0.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "жен 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.