Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
141.22 ms
(86.01%)
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
  24356
  31941
  46053
  142809
  185855
  247896
  358398
  382115
  384556
  385104
  390169
  390642
  391931
  392748
  394764
  394780
  395513
  395554
  395679
  395733
  396906
  397482
  403376
  405556
  407637
  411592
  418921
  439728
  439765
  439795
  440651
  442612
  443158
  443744
  443833
  452085
  452093
  452146
  452637
  452968
  453129
  456611
  456616
  462695
  467120
  474151
  476303
  477524
  482379
  483149
  483350
  483628
  490210
  491360
  497516
  502249
  506000
  509043
  512531
  512955
  517021
  518839
  519316
  520911
  525557
  525890
  528081
  531370
  535264
  536298
  536939
  539154
  540568
  551953
  554922
  555320
  557965
  563182
  564811
  577076
  593808
  604928
  606066
  608047
  610061
  637511
  643284
  652799
  663941
  667541
  676252
  678757
  720297
  721489
  724039
  724607
  729842
  733122
  738382
  740147
  742742
  745326
  746819
  755810
  765313
  766584
  767078
  767279
  772998
  789005
  793898
  796807
  799359
  800347
  811813
  813817
  815598
  815912
  816508
  816558
]
13.52 ms
(8.23%)
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
  418921
  525890
  490210
  520911
  405556
  443833
  483149
  535264
  502249
  518839
  554922
  593808
  462695
  439765
  390642
  439795
  452093
  439728
  442612
  528081
  536939
  483628
  509043
  385104
  394780
  391931
  358398
  382115
  46053
  24356
  396906
  397482
  403376
  816558
  815912
  816508
  813817
  467120
  491360
  476303
  536298
  525557
  517021
  531370
  540568
  512531
  539154
  551953
  563182
  555320
  557965
  564811
  720297
  652799
  663941
  678757
  721489
  667541
  676252
  577076
  604928
  610061
  643284
  606066
  608047
  799359
  789005
  800347
  740147
  746819
  765313
  766584
  811813
  772998
  724039
  724607
  733122
  729842
  738382
  742742
  745326
  755810
  767078
  767279
  637511
  793898
  796807
  247896
  31941
  142809
  440651
  395554
  384556
  185855
  394764
  392748
  395513
  395679
  395733
  390169
  407637
  443744
  443158
  411592
  815598
  452146
  452637
  452968
  453129
  474151
  482379
  477524
  452085
  456611
  456616
  483350
  497516
  506000
  512955
  519316
]
3.21 ms
(1.95%)
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
  24356
  31941
  46053
  142809
  185855
  247896
  358398
  382115
  384556
  385104
  390169
  390642
  391931
  392748
  394764
  394780
  395513
  395554
  395679
  395733
  396906
  397482
  403376
  405556
  407637
  411592
  418921
  439728
  439765
  439795
  440651
  442612
  443158
  443744
  443833
  452085
  452093
  452146
  452637
  452968
  453129
  456611
  456616
  462695
  467120
  474151
  476303
  477524
  482379
  483149
  483350
  483628
  490210
  491360
  497516
  502249
  506000
  509043
  512531
  512955
  517021
  518839
  519316
  520911
  525557
  525890
  528081
  531370
  535264
  536298
  536939
  539154
  540568
  551953
  554922
  555320
  557965
  563182
  564811
  577076
  593808
  604928
  606066
  608047
  610061
  637511
  643284
  652799
  663941
  667541
  676252
  678757
  720297
  721489
  724039
  724607
  729842
  733122
  738382
  740147
  742742
  745326
  746819
  755810
  765313
  766584
  767078
  767279
  772998
  789005
  793898
  796807
  799359
  800347
  811813
  813817
  815598
  815912
  816508
  816558
]
1.68 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature shower"
]
1.66 ms
(1.01%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.57 ms
(0.96%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature shower"
]
1.35 ms
(0.82%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mature shower"
]

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.