Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
193.80 ms
(88.60%)
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
  391530
  391976
  398519
  403067
  410799
  411511
  415358
  418277
  418436
  420548
  420865
  431758
  433959
  435405
  437705
  438055
  448752
  453616
  460474
  462284
  464572
  477194
  479110
  479215
  483946
  498670
  503462
  506483
  514685
  517835
  521036
  522347
  522675
  530161
  532614
  542439
  542752
  545182
  546660
  552371
  555075
  555096
  565884
  567193
  575687
  583408
  586543
  588365
  590998
  591064
  595308
  599388
  600888
  602487
  605046
  612339
  616103
  617605
  626120
  626345
  626713
  630445
  635801
  636658
  638181
  644641
  648976
  651408
  653891
  668766
  671679
  674587
  685131
  691759
  693331
  695824
  700828
  700941
  707483
  709244
  709655
  710504
  719131
  726535
  726686
  731129
  733545
  739622
  739899
  740805
  741819
  744818
  746618
  747044
  747543
  750093
  759722
  762899
  765384
  768085
  770563
  771529
  773022
  773876
  774966
  777316
  778752
  781185
  782979
  783256
  785178
  790508
  791134
  794921
  795234
  796107
  799818
  800425
  809614
  810556
]
14.33 ms
(6.55%)
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
  791134
  794921
  777316
  770563
  785178
  744818
  773022
  726535
  726686
  733545
  747543
  768085
  741819
  747044
  759722
  773876
  731129
  739899
  740805
  750093
  771529
  616103
  781185
  783256
  799818
  391976
  420548
  410799
  438055
  477194
  522347
  644641
  599388
  567193
  420865
  522675
  530161
  503462
  517835
  506483
  521036
  532614
  575687
  542439
  545182
  546660
  552371
  555096
  565884
  583408
  668766
  691759
  700941
  707483
  648976
  651408
  653891
  671679
  674587
  709655
  588365
  638181
  595308
  626120
  630445
  586543
  612339
  617605
  626345
  635801
  600888
  626713
  636658
  800425
  602487
  709244
  710504
  418277
  498670
  433959
  437705
  464572
  483946
  460474
  514685
  462284
  479110
  685131
  693331
  700828
  695824
  555075
  590998
  591064
  605046
  790508
  809614
  778752
  795234
  746618
  762899
  782979
  739622
  765384
  719131
  774966
  796107
  810556
  431758
  398519
  435405
  391530
  411511
  453616
  415358
  418436
  448752
  479215
  403067
  542752
]
3.18 ms
(1.45%)
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
  391530
  391976
  398519
  403067
  410799
  411511
  415358
  418277
  418436
  420548
  420865
  431758
  433959
  435405
  437705
  438055
  448752
  453616
  460474
  462284
  464572
  477194
  479110
  479215
  483946
  498670
  503462
  506483
  514685
  517835
  521036
  522347
  522675
  530161
  532614
  542439
  542752
  545182
  546660
  552371
  555075
  555096
  565884
  567193
  575687
  583408
  586543
  588365
  590998
  591064
  595308
  599388
  600888
  602487
  605046
  612339
  616103
  617605
  626120
  626345
  626713
  630445
  635801
  636658
  638181
  644641
  648976
  651408
  653891
  668766
  671679
  674587
  685131
  691759
  693331
  695824
  700828
  700941
  707483
  709244
  709655
  710504
  719131
  726535
  726686
  731129
  733545
  739622
  739899
  740805
  741819
  744818
  746618
  747044
  747543
  750093
  759722
  762899
  765384
  768085
  770563
  771529
  773022
  773876
  774966
  777316
  778752
  781185
  782979
  783256
  785178
  790508
  791134
  794921
  795234
  796107
  799818
  800425
  809614
  810556
]
2.05 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "homemade suck"
]
1.94 ms
(0.89%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домашн любительск suck"
]
1.84 ms
(0.84%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.61 ms
(0.73%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "домашн любительск suck"
]

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.