Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
155.71 ms
(86.39%)
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
  282504
  382353
  396011
  396056
  396592
  401117
  404349
  404371
  415155
  415203
  417485
  418411
  418808
  424996
  433206
  442493
  446862
  447537
  458251
  459437
  463839
  463917
  463965
  468591
  470299
  471601
  474585
  474590
  474600
  477734
  478480
  482081
  483053
  484752
  485249
  485565
  486077
  488298
  488700
  491736
  491941
  492746
  495213
  501649
  501653
  503947
  509746
  512014
  513729
  516848
  517106
  520542
  521899
  529846
  539280
  542516
  547380
  560416
  560937
  561837
  565245
  566786
  567776
  571217
  571750
  574502
  586596
  588257
  589196
  593729
  596672
  597242
  597251
  597269
  598084
  598086
  598554
  600192
  600320
  601644
  604147
  604371
  610555
  619221
  628375
  629174
  630529
  632614
  632695
  636026
  636272
  647910
  649180
  651855
  651856
  659394
  661456
  664558
  677677
  693325
  702699
  703101
  714463
  720188
  720211
  720875
  722891
  725640
  732681
  733863
  736042
  741909
  746802
  752721
  796719
  800610
  810709
  811863
  814554
  823398
]
14.01 ms
(7.77%)
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
  482081
  415203
  458251
  396056
  512014
  521899
  516848
  485565
  517106
  484752
  501649
  561837
  596672
  814554
  636026
  619221
  733863
  542516
  396592
  401117
  404371
  442493
  424996
  446862
  468591
  474585
  404349
  459437
  463839
  474590
  477734
  382353
  470299
  418808
  478480
  483053
  495213
  488700
  491941
  492746
  501653
  513729
  503947
  565245
  610555
  396011
  547380
  604371
  746802
  752721
  810709
  488298
  796719
  471601
  415155
  509746
  566786
  529846
  586596
  632614
  593729
  632695
  433206
  417485
  486077
  474600
  282504
  418411
  463917
  463965
  447537
  539280
  485249
  520542
  823398
  702699
  560937
  629174
  741909
  567776
  560416
  571217
  661456
  647910
  649180
  651855
  651856
  659394
  693325
  720211
  677677
  714463
  600320
  630529
  597242
  597251
  598084
  598086
  600192
  604147
  597269
  636272
  589196
  601644
  628375
  732681
  736042
  725640
  703101
  720188
  720875
  722891
  800610
  811863
  664558
  571750
  574502
  598554
  588257
  491736
]
2.69 ms
(1.49%)
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
  282504
  382353
  396011
  396056
  396592
  401117
  404349
  404371
  415155
  415203
  417485
  418411
  418808
  424996
  433206
  442493
  446862
  447537
  458251
  459437
  463839
  463917
  463965
  468591
  470299
  471601
  474585
  474590
  474600
  477734
  478480
  482081
  483053
  484752
  485249
  485565
  486077
  488298
  488700
  491736
  491941
  492746
  495213
  501649
  501653
  503947
  509746
  512014
  513729
  516848
  517106
  520542
  521899
  529846
  539280
  542516
  547380
  560416
  560937
  561837
  565245
  566786
  567776
  571217
  571750
  574502
  586596
  588257
  589196
  593729
  596672
  597242
  597251
  597269
  598084
  598086
  598554
  600192
  600320
  601644
  604147
  604371
  610555
  619221
  628375
  629174
  630529
  632614
  632695
  636026
  636272
  647910
  649180
  651855
  651856
  659394
  661456
  664558
  677677
  693325
  702699
  703101
  714463
  720188
  720211
  720875
  722891
  725640
  732681
  733863
  736042
  741909
  746802
  752721
  796719
  800610
  810709
  811863
  814554
  823398
]
2.23 ms
(1.24%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "small big anal"
]
1.92 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "маленькая большие анал"
]
1.85 ms
(1.03%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.82 ms
(1.01%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.