Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
127.69 ms
(85.53%)
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
  551113
  551811
  576918
  580853
  584961
  585944
  586934
  589857
  591818
  596441
  600993
  603567
  606064
  606358
  606516
  610642
  611144
  612586
  613879
  614560
  615922
  616243
  618961
  620908
  629964
  632048
  633602
  634941
  635835
  636472
  638184
  639574
  641567
  650058
  652850
  656096
  668750
  678586
  679044
  679049
  679067
  679096
  679114
  679135
  690834
  690855
  690913
  691458
  693039
  693041
  693860
  694052
  694495
  694522
  694562
  695405
  695621
  695631
  695634
  695635
  696097
  696278
  697373
  698548
  699390
  699743
  701535
  709358
  714954
  716288
  716640
  720008
  722448
  725540
  726365
  728022
  728850
  730222
  732551
  733500
  734929
  736107
  736844
  737328
  738054
  738462
  740461
  742551
  742906
  744677
  745488
  747503
  748304
  748689
  752509
  755358
  756373
  757680
  761077
  762339
  767066
  769828
  771038
  773388
  774251
  777957
  779187
  783381
  784388
  793231
  796101
  798993
  799448
  800319
  800750
  800971
  801053
  801440
  801733
  804503
]
11.09 ms
(7.43%)
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
  679044
  679067
  690855
  690913
  691458
  693039
  694052
  694495
  694522
  695405
  695631
  696278
  716640
  678586
  679096
  679114
  679135
  690834
  693860
  694562
  695621
  695634
  698548
  699390
  699743
  701535
  709358
  716288
  720008
  650058
  652850
  656096
  668750
  679049
  693041
  695635
  696097
  697373
  714954
  722448
  551113
  551811
  576918
  580853
  584961
  586934
  606064
  610642
  613879
  614560
  616243
  632048
  635835
  641567
  589857
  596441
  606358
  606516
  611144
  633602
  636472
  638184
  639574
  600993
  615922
  629964
  634941
  585944
  591818
  603567
  612586
  618961
  620908
  793231
  796101
  798993
  800319
  800971
  801053
  804503
  777957
  779187
  799448
  800750
  801440
  725540
  728850
  730222
  738054
  742906
  756373
  769828
  783381
  784388
  801733
  732551
  736844
  747503
  761077
  726365
  728022
  733500
  734929
  736107
  737328
  740461
  745488
  752509
  755358
  773388
  774251
  738462
  742551
  748304
  748689
  757680
  762339
  767066
  771038
  744677
]
2.84 ms
(1.90%)
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
  551113
  551811
  576918
  580853
  584961
  585944
  586934
  589857
  591818
  596441
  600993
  603567
  606064
  606358
  606516
  610642
  611144
  612586
  613879
  614560
  615922
  616243
  618961
  620908
  629964
  632048
  633602
  634941
  635835
  636472
  638184
  639574
  641567
  650058
  652850
  656096
  668750
  678586
  679044
  679049
  679067
  679096
  679114
  679135
  690834
  690855
  690913
  691458
  693039
  693041
  693860
  694052
  694495
  694522
  694562
  695405
  695621
  695631
  695634
  695635
  696097
  696278
  697373
  698548
  699390
  699743
  701535
  709358
  714954
  716288
  716640
  720008
  722448
  725540
  726365
  728022
  728850
  730222
  732551
  733500
  734929
  736107
  736844
  737328
  738054
  738462
  740461
  742551
  742906
  744677
  745488
  747503
  748304
  748689
  752509
  755358
  756373
  757680
  761077
  762339
  767066
  769828
  771038
  773388
  774251
  777957
  779187
  783381
  784388
  793231
  796101
  798993
  799448
  800319
  800750
  800971
  801053
  801440
  801733
  804503
]
2.42 ms
(1.62%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.32 ms
(1.55%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "два"
]
1.68 ms
(1.12%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "два"
]
1.26 ms
(0.84%)
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.