Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
158.89 ms
(86.30%)
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
  130641
  382804
  384906
  389657
  415539
  505745
  521659
  522825
  531202
  531205
  531215
  531928
  534799
  534892
  539528
  543694
  546251
  549417
  564753
  574957
  586924
  592908
  596558
  597905
  598181
  600022
  600312
  603703
  607414
  623123
  625577
  632635
  637858
  638511
  644339
  645284
  654416
  654701
  655099
  655201
  655352
  656998
  657052
  657063
  657401
  657652
  657693
  658736
  670946
  677975
  678131
  683426
  693700
  694347
  695122
  698803
  699121
  706857
  707515
  707726
  717108
  719248
  719283
  721568
  724534
  726262
  728633
  730400
  730596
  731141
  732336
  734318
  735334
  735475
  738654
  743824
  745534
  747416
  750136
  752789
  753674
  755611
  759671
  762299
  762781
  764286
  764505
  767310
  768047
  772143
  773462
  773803
  777855
  780162
  794580
  801032
  810618
  811952
  814560
  817003
  817016
  817105
  817631
  817633
  817635
  818412
  818880
  819149
  819792
  820153
  820983
  821491
  822475
  823379
  826004
  826113
  826131
  827438
  828463
  828472
]
15.06 ms
(8.18%)
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
  773462
  773803
  801032
  574957
  600022
  632635
  818412
  818880
  534892
  683426
  655352
  753674
  828472
  654416
  657401
  717108
  656998
  657693
  743824
  726262
  767310
  644339
  531215
  531202
  600312
  384906
  817631
  814560
  826131
  521659
  531928
  694347
  677975
  693700
  794580
  772143
  645284
  817633
  531205
  678131
  826004
  415539
  695122
  603703
  522825
  819149
  817635
  724534
  823379
  821491
  819792
  822475
  539528
  658736
  719248
  698803
  706857
  625577
  637858
  731141
  759671
  738654
  764286
  735334
  707515
  719283
  382804
  820153
  564753
  638511
  811952
  768047
  810618
  130641
  817016
  827438
  817003
  828463
  534799
  549417
  654701
  655201
  707726
  657063
  657652
  699121
  655099
  657052
  721568
  597905
  623123
  596558
  777855
  728633
  747416
  755611
  762299
  730400
  735475
  745534
  762781
  764505
  730596
  732336
  734318
  752789
  750136
  389657
  820983
  817105
  826113
  505745
  543694
  546251
  670946
  586924
  607414
  598181
  592908
  780162
]
3.43 ms
(1.86%)
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
  130641
  382804
  384906
  389657
  415539
  505745
  521659
  522825
  531202
  531205
  531215
  531928
  534799
  534892
  539528
  543694
  546251
  549417
  564753
  574957
  586924
  592908
  596558
  597905
  598181
  600022
  600312
  603703
  607414
  623123
  625577
  632635
  637858
  638511
  644339
  645284
  654416
  654701
  655099
  655201
  655352
  656998
  657052
  657063
  657401
  657652
  657693
  658736
  670946
  677975
  678131
  683426
  693700
  694347
  695122
  698803
  699121
  706857
  707515
  707726
  717108
  719248
  719283
  721568
  724534
  726262
  728633
  730400
  730596
  731141
  732336
  734318
  735334
  735475
  738654
  743824
  745534
  747416
  750136
  752789
  753674
  755611
  759671
  762299
  762781
  764286
  764505
  767310
  768047
  772143
  773462
  773803
  777855
  780162
  794580
  801032
  810618
  811952
  814560
  817003
  817016
  817105
  817631
  817633
  817635
  818412
  818880
  819149
  819792
  820153
  820983
  821491
  822475
  823379
  826004
  826113
  826131
  827438
  828463
  828472
]
1.90 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big love"
]
1.79 ms
(0.97%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие love"
]
1.63 ms
(0.89%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.42 ms
(0.77%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большие love"
]

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.