Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
129.19 ms
(83.62%)
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
  233862
  358398
  391359
  393504
  400994
  401922
  404600
  409180
  411744
  418928
  428018
  429160
  429461
  443951
  446909
  451728
  452207
  461047
  464454
  465825
  465834
  466966
  471442
  475870
  476746
  479053
  483135
  484162
  484984
  491220
  501139
  512536
  519986
  523811
  525100
  525558
  526420
  529564
  534221
  534776
  535318
  546716
  551250
  557180
  559053
  562362
  567162
  567521
  568574
  569155
  570052
  571926
  575736
  576008
  576262
  576340
  594833
  595458
  605851
  618672
  624281
  637520
  649081
  649588
  651190
  663865
  663963
  664845
  665139
  665305
  667017
  670498
  670955
  686710
  692859
  699586
  704010
  704561
  709544
  710485
  712820
  712824
  712826
  712828
  713520
  714840
  717860
  721435
  721551
  722055
  722846
  722918
  723437
  727425
  729818
  734630
  744640
  747461
  763522
  774384
  782223
  788282
  788394
  788468
  794992
  795606
  799591
  800050
  801868
  802487
  804902
  806203
  807806
  810665
  813902
  814223
  814878
  817727
  820482
  825036
]
15.15 ms
(9.81%)
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
  814223
  814878
  452207
  476746
  479053
  525558
  501139
  525100
  464454
  551250
  569155
  570052
  576340
  546716
  568574
  692859
  699586
  713520
  664845
  712824
  714840
  721435
  649081
  651190
  710485
  712820
  571926
  594833
  595458
  637520
  618672
  605851
  810665
  799591
  729818
  763522
  704010
  712826
  712828
  722846
  722918
  391359
  404600
  466966
  475870
  428018
  400994
  465825
  465834
  443951
  529564
  519986
  483135
  484162
  484984
  491220
  446909
  393504
  358398
  409180
  813902
  825036
  817727
  461047
  534221
  559053
  557180
  663963
  665305
  649588
  663865
  670498
  709544
  782223
  794992
  795606
  788394
  801868
  734630
  788282
  788468
  802487
  804902
  727425
  744640
  747461
  774384
  722055
  723437
  800050
  806203
  807806
  233862
  411744
  535318
  401922
  418928
  429160
  429461
  820482
  451728
  471442
  512536
  523811
  534776
  526420
  576008
  562362
  575736
  576262
  667017
  721551
  665139
  670955
  704561
  717860
  686710
  567162
  567521
  624281
]
2.55 ms
(1.65%)
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
  233862
  358398
  391359
  393504
  400994
  401922
  404600
  409180
  411744
  418928
  428018
  429160
  429461
  443951
  446909
  451728
  452207
  461047
  464454
  465825
  465834
  466966
  471442
  475870
  476746
  479053
  483135
  484162
  484984
  491220
  501139
  512536
  519986
  523811
  525100
  525558
  526420
  529564
  534221
  534776
  535318
  546716
  551250
  557180
  559053
  562362
  567162
  567521
  568574
  569155
  570052
  571926
  575736
  576008
  576262
  576340
  594833
  595458
  605851
  618672
  624281
  637520
  649081
  649588
  651190
  663865
  663963
  664845
  665139
  665305
  667017
  670498
  670955
  686710
  692859
  699586
  704010
  704561
  709544
  710485
  712820
  712824
  712826
  712828
  713520
  714840
  717860
  721435
  721551
  722055
  722846
  722918
  723437
  727425
  729818
  734630
  744640
  747461
  763522
  774384
  782223
  788282
  788394
  788468
  794992
  795606
  799591
  800050
  801868
  802487
  804902
  806203
  807806
  810665
  813902
  814223
  814878
  817727
  820482
  825036
]
2.25 ms
(1.46%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "young hot"
]
2.07 ms
(1.34%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "young hot"
]
1.72 ms
(1.12%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.55 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "young hot"
]

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.