Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
131.58 ms
(84.06%)
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
  123070
  142579
  274100
  391873
  392990
  398628
  398773
  419052
  431516
  453481
  454496
  462161
  463157
  464039
  464374
  470572
  471771
  473326
  475907
  477393
  491021
  497524
  504281
  504302
  504622
  508470
  509228
  509862
  517635
  520751
  533736
  533801
  534143
  534147
  535724
  536886
  543365
  543416
  544768
  545414
  547074
  548676
  563662
  566432
  589154
  592350
  593873
  595817
  596288
  603163
  605525
  606584
  607155
  610066
  613333
  613375
  618001
  622158
  644729
  649644
  653440
  663546
  670051
  670721
  675236
  675921
  675951
  676309
  676397
  676895
  676896
  684096
  692453
  694894
  699844
  707464
  709784
  712466
  712675
  714193
  714844
  714851
  715395
  715518
  716373
  716804
  724304
  724449
  729264
  731195
  737893
  741114
  759634
  759672
  766306
  767281
  773553
  773948
  773974
  773982
  775895
  775934
  776307
  779148
  787667
  787686
  790679
  792007
  793712
  796450
  797940
  798411
  801147
  801978
  806377
  809493
  811866
  812798
  814692
  819320
]
14.25 ms
(9.10%)
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
  622158
  618001
  566432
  670721
  707464
  712675
  563662
  644729
  724304
  610066
  504302
  814692
  534143
  545414
  649644
  653440
  775895
  787686
  766306
  606584
  398628
  391873
  142579
  398773
  431516
  464374
  535724
  536886
  543365
  547074
  676397
  692453
  712466
  676309
  714851
  675236
  676895
  694894
  699844
  716804
  592350
  596288
  595817
  605525
  613333
  809493
  775934
  792007
  729264
  767281
  773553
  787667
  759634
  759672
  773948
  773982
  731195
  741114
  773974
  715518
  776307
  790679
  812798
  477393
  462161
  504281
  464039
  684096
  811866
  475907
  463157
  544768
  663546
  603163
  491021
  470572
  454496
  533801
  471771
  548676
  670051
  796450
  419052
  819320
  517635
  520751
  504622
  509228
  533736
  534147
  543416
  709784
  715395
  675951
  714193
  714844
  716373
  675921
  676896
  589154
  593873
  607155
  613375
  793712
  801147
  801978
  798411
  797940
  724449
  737893
  779148
  806377
  453481
  473326
  509862
  508470
  497524
  123070
  392990
  274100
]
2.96 ms
(1.89%)
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
  123070
  142579
  274100
  391873
  392990
  398628
  398773
  419052
  431516
  453481
  454496
  462161
  463157
  464039
  464374
  470572
  471771
  473326
  475907
  477393
  491021
  497524
  504281
  504302
  504622
  508470
  509228
  509862
  517635
  520751
  533736
  533801
  534143
  534147
  535724
  536886
  543365
  543416
  544768
  545414
  547074
  548676
  563662
  566432
  589154
  592350
  593873
  595817
  596288
  603163
  605525
  606584
  607155
  610066
  613333
  613375
  618001
  622158
  644729
  649644
  653440
  663546
  670051
  670721
  675236
  675921
  675951
  676309
  676397
  676895
  676896
  684096
  692453
  694894
  699844
  707464
  709784
  712466
  712675
  714193
  714844
  714851
  715395
  715518
  716373
  716804
  724304
  724449
  729264
  731195
  737893
  741114
  759634
  759672
  766306
  767281
  773553
  773948
  773974
  773982
  775895
  775934
  776307
  779148
  787667
  787686
  790679
  792007
  793712
  796450
  797940
  798411
  801147
  801978
  806377
  809493
  811866
  812798
  814692
  819320
]
2.46 ms
(1.57%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домашн любительск группов"
]
2.01 ms
(1.28%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "домашняя групповую"
]
1.66 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "домашн любительск группов"
]
1.62 ms
(1.03%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.