Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
126.59 ms
(77.44%)
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
  6953
  117958
  330420
  396015
  416056
  418834
  420139
  420226
  421591
  421665
  422163
  422273
  423620
  424581
  428124
  428397
  432837
  433209
  433211
  433244
  435100
  441838
  442493
  443992
  444018
  444022
  452862
  455494
  461287
  467935
  468373
  472647
  479821
  486742
  488247
  488803
  493657
  498638
  503441
  510413
  513342
  523783
  524955
  528191
  531560
  534096
  537968
  538045
  542089
  542093
  542548
  542582
  542782
  543023
  543045
  543097
  543184
  543615
  545713
  546763
  546794
  546941
  547256
  547423
  549686
  550240
  553328
  553975
  555096
  555891
  555917
  555937
  556406
  557611
  559047
  559139
  560599
  565828
  566636
  566998
  568420
  570149
  570775
  573311
  574908
  575878
  576723
  576920
  578009
  578174
  578490
  579434
  580138
  580261
  580340
  581281
  581370
  583999
  584004
  591623
  591782
  592854
  593238
  598253
  604527
  605107
  619065
  621374
  622601
  635486
  665929
  667875
  706373
  715671
  725221
  726267
  731683
  735909
  800585
  801287
]
25.40 ms
(15.54%)
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
  576920
  801287
  479821
  488803
  488247
  6953
  468373
  524955
  538045
  542782
  545713
  579434
  581370
  555891
  580261
  635486
  591782
  604527
  800585
  467935
  452862
  537968
  523783
  493657
  560599
  581281
  542548
  619065
  396015
  422163
  421665
  418834
  513342
  461287
  542582
  580138
  592854
  422273
  423620
  432837
  416056
  534096
  486742
  498638
  542089
  543615
  570775
  593238
  555937
  543097
  443992
  455494
  547256
  566998
  578009
  565828
  568420
  665929
  667875
  573311
  621374
  598253
  605107
  543023
  543045
  726267
  556406
  546794
  531560
  731683
  428397
  444018
  574908
  503441
  557611
  570149
  441838
  591623
  472647
  576723
  424581
  549686
  553328
  550240
  546763
  559047
  444022
  578490
  421591
  420226
  528191
  553975
  559139
  555917
  542093
  543184
  555096
  715671
  706373
  546941
  578174
  725221
  735909
  580340
  117958
  575878
  547423
  435100
  442493
  428124
  566636
  584004
  622601
  433209
  420139
  433244
  510413
  583999
  330420
  433211
]
3.16 ms
(1.93%)
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
  6953
  117958
  330420
  396015
  416056
  418834
  420139
  420226
  421591
  421665
  422163
  422273
  423620
  424581
  428124
  428397
  432837
  433209
  433211
  433244
  435100
  441838
  442493
  443992
  444018
  444022
  452862
  455494
  461287
  467935
  468373
  472647
  479821
  486742
  488247
  488803
  493657
  498638
  503441
  510413
  513342
  523783
  524955
  528191
  531560
  534096
  537968
  538045
  542089
  542093
  542548
  542582
  542782
  543023
  543045
  543097
  543184
  543615
  545713
  546763
  546794
  546941
  547256
  547423
  549686
  550240
  553328
  553975
  555096
  555891
  555917
  555937
  556406
  557611
  559047
  559139
  560599
  565828
  566636
  566998
  568420
  570149
  570775
  573311
  574908
  575878
  576723
  576920
  578009
  578174
  578490
  579434
  580138
  580261
  580340
  581281
  581370
  583999
  584004
  591623
  591782
  592854
  593238
  598253
  604527
  605107
  619065
  621374
  622601
  635486
  665929
  667875
  706373
  715671
  725221
  726267
  731683
  735909
  800585
  801287
]
3.02 ms
(1.84%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "большая дырка в члене…"
]
2.04 ms
(1.25%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большая большие дырк в член"
]
1.74 ms
(1.06%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.54 ms
(0.94%)
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.