Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
123.28 ms
(83.28%)
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
  398193
  402531
  406890
  413472
  418365
  422426
  433404
  434836
  434889
  435500
  436060
  438060
  440290
  443271
  445052
  447830
  448843
  450149
  450779
  455900
  456797
  458427
  458511
  459346
  459969
  462362
  463562
  463618
  463912
  470053
  471772
  474813
  489259
  497234
  498076
  500553
  502778
  505550
  510704
  512599
  517169
  522936
  529542
  530216
  539372
  540539
  542079
  546868
  546870
  549142
  552333
  556553
  560791
  562424
  569565
  571322
  579877
  584127
  591507
  591827
  593669
  600364
  602593
  610708
  618104
  625582
  641227
  650034
  650177
  660606
  676436
  683664
  696734
  708450
  709819
  718980
  719837
  723155
  723432
  724209
  725458
  726907
  728756
  730607
  731037
  731381
  735834
  735867
  735948
  737287
  738335
  738336
  746604
  752876
  755483
  759653
  760252
  761949
  763561
  766333
  767213
  767399
  767454
  768724
  774563
  774833
  781056
  790746
  791359
  800611
  803202
  803222
  803258
  803604
  806797
  808095
  808535
  811906
  814111
  814925
]
14.97 ms
(10.11%)
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
  768724
  730607
  738335
  735834
  737287
  746604
  767399
  728756
  731381
  738336
  766333
  641227
  696734
  790746
  440290
  602593
  814925
  500553
  562424
  676436
  569565
  610708
  774833
  800611
  803202
  767454
  791359
  735948
  760252
  763561
  398193
  434836
  463912
  522936
  683664
  723432
  781056
  808535
  767213
  755483
  402531
  406890
  530216
  413472
  422426
  433404
  447830
  448843
  450149
  459969
  470053
  579877
  708450
  723155
  709819
  718980
  546868
  618104
  811906
  726907
  735867
  752876
  759653
  761949
  803258
  803604
  806797
  808095
  418365
  463618
  450779
  497234
  434889
  814111
  455900
  456797
  462362
  529542
  489259
  542079
  556553
  584127
  546870
  549142
  650034
  660606
  719837
  571322
  591827
  593669
  803222
  774563
  731037
  725458
  463562
  436060
  438060
  474813
  435500
  471772
  512599
  459346
  458511
  505550
  517169
  539372
  552333
  650177
  560791
  591507
  625582
  443271
  502778
  510704
  498076
  458427
  540539
  600364
  724209
  445052
]
2.44 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
  398193
  402531
  406890
  413472
  418365
  422426
  433404
  434836
  434889
  435500
  436060
  438060
  440290
  443271
  445052
  447830
  448843
  450149
  450779
  455900
  456797
  458427
  458511
  459346
  459969
  462362
  463562
  463618
  463912
  470053
  471772
  474813
  489259
  497234
  498076
  500553
  502778
  505550
  510704
  512599
  517169
  522936
  529542
  530216
  539372
  540539
  542079
  546868
  546870
  549142
  552333
  556553
  560791
  562424
  569565
  571322
  579877
  584127
  591507
  591827
  593669
  600364
  602593
  610708
  618104
  625582
  641227
  650034
  650177
  660606
  676436
  683664
  696734
  708450
  709819
  718980
  719837
  723155
  723432
  724209
  725458
  726907
  728756
  730607
  731037
  731381
  735834
  735867
  735948
  737287
  738335
  738336
  746604
  752876
  755483
  759653
  760252
  761949
  763561
  766333
  767213
  767399
  767454
  768724
  774563
  774833
  781056
  790746
  791359
  800611
  803202
  803222
  803258
  803604
  806797
  808095
  808535
  811906
  814111
  814925
]
2.13 ms
(1.44%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "cum load"
]
1.79 ms
(1.21%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "cum load"
]
1.74 ms
(1.18%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.68 ms
(1.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "cum load"
]

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.