Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
181.58 ms
(88.89%)
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
  3444
  24363
  131908
  290150
  387299
  394610
  396083
  397089
  397093
  398773
  402154
  404731
  417219
  417740
  426256
  466881
  469451
  469571
  471368
  489678
  495892
  504010
  509834
  523390
  528390
  528493
  533680
  541525
  542631
  548320
  548373
  557406
  558879
  559427
  562629
  562676
  568429
  568451
  568512
  569476
  569497
  569511
  577122
  583534
  584045
  588389
  590356
  591770
  594453
  601076
  601109
  602605
  602620
  606106
  606251
  606298
  606365
  606374
  606381
  606400
  606401
  606402
  606405
  606426
  606428
  606431
  606436
  606619
  606641
  607472
  613726
  616448
  618839
  630246
  637665
  638792
  649266
  654945
  660845
  661899
  666614
  708203
  709235
  709756
  710002
  710302
  714188
  717948
  721749
  723681
  729266
  742067
  746878
  750331
  755353
  760697
  761062
  761076
  766606
  769517
  769567
  774054
  786596
  794517
  794538
  794547
  795575
  796860
  800028
  801933
  804191
  807885
  810478
  810612
  814711
  817070
  817716
  817722
  818768
  824090
]
12.06 ms
(5.91%)
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
  810478
  810612
  746878
  774054
  396083
  24363
  814711
  591770
  794538
  750331
  795575
  761062
  638792
  533680
  541525
  661899
  649266
  654945
  606428
  606431
  637665
  607472
  666614
  387299
  824090
  471368
  601076
  709235
  495892
  601109
  817722
  469571
  569511
  606251
  606381
  807885
  769517
  760697
  804191
  761076
  131908
  569476
  548320
  710002
  397093
  817070
  466881
  583534
  606426
  606402
  794547
  800028
  796860
  290150
  542631
  660845
  562629
  606619
  618839
  606365
  590356
  613726
  606374
  710302
  509834
  397089
  404731
  426256
  709756
  786596
  606641
  801933
  394610
  3444
  489678
  562676
  569497
  606400
  588389
  794517
  729266
  548373
  558879
  708203
  606436
  606106
  766606
  742067
  594453
  602620
  402154
  559427
  568512
  602605
  568429
  606298
  606401
  630246
  755353
  818768
  398773
  417740
  417219
  817716
  469451
  504010
  523390
  528390
  528493
  557406
  568451
  577122
  717948
  721749
  714188
  584045
  616448
  606405
  723681
  769567
]
2.79 ms
(1.36%)
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
  3444
  24363
  131908
  290150
  387299
  394610
  396083
  397089
  397093
  398773
  402154
  404731
  417219
  417740
  426256
  466881
  469451
  469571
  471368
  489678
  495892
  504010
  509834
  523390
  528390
  528493
  533680
  541525
  542631
  548320
  548373
  557406
  558879
  559427
  562629
  562676
  568429
  568451
  568512
  569476
  569497
  569511
  577122
  583534
  584045
  588389
  590356
  591770
  594453
  601076
  601109
  602605
  602620
  606106
  606251
  606298
  606365
  606374
  606381
  606400
  606401
  606402
  606405
  606426
  606428
  606431
  606436
  606619
  606641
  607472
  613726
  616448
  618839
  630246
  637665
  638792
  649266
  654945
  660845
  661899
  666614
  708203
  709235
  709756
  710002
  710302
  714188
  717948
  721749
  723681
  729266
  742067
  746878
  750331
  755353
  760697
  761062
  761076
  766606
  769517
  769567
  774054
  786596
  794517
  794538
  794547
  795575
  796860
  800028
  801933
  804191
  807885
  810478
  810612
  814711
  817070
  817716
  817722
  818768
  824090
]
2.14 ms
(1.05%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "german домашн любительск"
]
2.14 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "german homemade"
]
1.86 ms
(0.91%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.71 ms
(0.84%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "german домашн любительск"
]

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.