Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
125.47 ms
(82.20%)
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
  86684
  123273
  233707
  396101
  411619
  423766
  425654
  429788
  443142
  444206
  447867
  450143
  450894
  456196
  456495
  458152
  458561
  459144
  461487
  461829
  462798
  463123
  463769
  465739
  468470
  470660
  472466
  474377
  474824
  475534
  478235
  478777
  478805
  482426
  484332
  486045
  486537
  487568
  489381
  490879
  491141
  491290
  491709
  491962
  492315
  493218
  494933
  499581
  504747
  506023
  506369
  507348
  509050
  509056
  510007
  510472
  510796
  511197
  511886
  512089
  513948
  516089
  516178
  517885
  518351
  518859
  519775
  520500
  520617
  521492
  521906
  523005
  526129
  527794
  541537
  541891
  542050
  545199
  546600
  546697
  546946
  551687
  552908
  554366
  555910
  556312
  557109
  561350
  563453
  565327
  565354
  565863
  568965
  570307
  570363
  571298
  571486
  571934
  580723
  598811
  625582
  626472
  631615
  672777
  678878
  703554
  712122
  712639
  721068
  723432
  724102
  726694
  739675
  741082
  766908
  783562
  784571
  788799
  792581
  798018
]
16.77 ms
(10.99%)
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
  542050
  546946
  557109
  565327
  568965
  571486
  541891
  556312
  561350
  463123
  396101
  456196
  470660
  472466
  504747
  521906
  484332
  490879
  510007
  510796
  518859
  458561
  458152
  233707
  507348
  506023
  506369
  519775
  489381
  492315
  86684
  462798
  463769
  411619
  520500
  511197
  499581
  527794
  450143
  474377
  551687
  571298
  570307
  678878
  721068
  703554
  712122
  723432
  631615
  783562
  798018
  741082
  456495
  423766
  443142
  482426
  494933
  511886
  512089
  520617
  461487
  486537
  555910
  565863
  552908
  571934
  545199
  672777
  546600
  554366
  563453
  570363
  580723
  766908
  474824
  478235
  459144
  425654
  468470
  509050
  509056
  513948
  523005
  491141
  491709
  487568
  516089
  444206
  447867
  478805
  546697
  625582
  465739
  450894
  478777
  516178
  517885
  526129
  493218
  510472
  518351
  486045
  491962
  598811
  123273
  491290
  521492
  565354
  429788
  541537
  712639
  784571
  726694
  724102
  739675
  626472
  788799
  792581
  461829
  475534
]
3.46 ms
(2.27%)
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
  86684
  123273
  233707
  396101
  411619
  423766
  425654
  429788
  443142
  444206
  447867
  450143
  450894
  456196
  456495
  458152
  458561
  459144
  461487
  461829
  462798
  463123
  463769
  465739
  468470
  470660
  472466
  474377
  474824
  475534
  478235
  478777
  478805
  482426
  484332
  486045
  486537
  487568
  489381
  490879
  491141
  491290
  491709
  491962
  492315
  493218
  494933
  499581
  504747
  506023
  506369
  507348
  509050
  509056
  510007
  510472
  510796
  511197
  511886
  512089
  513948
  516089
  516178
  517885
  518351
  518859
  519775
  520500
  520617
  521492
  521906
  523005
  526129
  527794
  541537
  541891
  542050
  545199
  546600
  546697
  546946
  551687
  552908
  554366
  555910
  556312
  557109
  561350
  563453
  565327
  565354
  565863
  568965
  570307
  570363
  571298
  571486
  571934
  580723
  598811
  625582
  626472
  631615
  672777
  678878
  703554
  712122
  712639
  721068
  723432
  724102
  726694
  739675
  741082
  766908
  783562
  784571
  788799
  792581
  798018
]
1.93 ms
(1.27%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "в комнате секс"
]
1.87 ms
(1.22%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(1.06%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "в комнат секс"
]
1.51 ms
(0.99%)
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.