Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
142.68 ms
(86.71%)
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
  365295
  399043
  399652
  400126
  402122
  403477
  404261
  408206
  411811
  416476
  419838
  427946
  433721
  444474
  445955
  446311
  452997
  457471
  467952
  471623
  475283
  484495
  485066
  507165
  513765
  518504
  519938
  520985
  521841
  531674
  533425
  542344
  543446
  545292
  546838
  550088
  565022
  573301
  573398
  579761
  580497
  584152
  586351
  597604
  600671
  601034
  607677
  610580
  618565
  623643
  634873
  635268
  676388
  716215
  720942
  725199
  728238
  732065
  733357
  735413
  753019
  754229
  757642
  759424
  759721
  774256
  779116
  784803
  787341
  790895
  797143
  797500
  797505
  798517
  799517
  799595
  800492
  801337
  801348
  804099
  804196
  805439
  806088
  807121
  809368
  811039
  811214
  811922
  812657
  812797
  812811
  812821
  813269
  813529
  814414
  815223
  815244
  815691
  815698
  815910
  816020
  817936
  817942
  817945
  818177
  818451
  818865
  819175
  820060
  820072
  821032
  821283
  821377
  821921
  822421
  822637
  823037
  823043
  823243
  824953
]
12.29 ms
(7.47%)
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
  550088
  573301
  584152
  676388
  635268
  634873
  790895
  800492
  804099
  799595
  798517
  399043
  403477
  521841
  419838
  452997
  779116
  720942
  822637
  759721
  411811
  601034
  400126
  618565
  812811
  416476
  445955
  507165
  818451
  404261
  457471
  787341
  797143
  815244
  815691
  817936
  531674
  573398
  811922
  784803
  757642
  754229
  732065
  759424
  799517
  807121
  365295
  815910
  813529
  467952
  805439
  812797
  518504
  579761
  818177
  821921
  797505
  408206
  546838
  580497
  565022
  607677
  623643
  801348
  475283
  444474
  542344
  812657
  735413
  610580
  520985
  399652
  533425
  545292
  600671
  809368
  812821
  402122
  820072
  471623
  513765
  484495
  817942
  818865
  823037
  823243
  814414
  817945
  815223
  816020
  819175
  821283
  822421
  821032
  543446
  716215
  586351
  597604
  797500
  804196
  806088
  811214
  725199
  753019
  728238
  733357
  801337
  813269
  815698
  821377
  824953
  820060
  774256
  446311
  433721
  823043
  811039
  427946
  485066
  519938
]
2.73 ms
(1.66%)
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
  365295
  399043
  399652
  400126
  402122
  403477
  404261
  408206
  411811
  416476
  419838
  427946
  433721
  444474
  445955
  446311
  452997
  457471
  467952
  471623
  475283
  484495
  485066
  507165
  513765
  518504
  519938
  520985
  521841
  531674
  533425
  542344
  543446
  545292
  546838
  550088
  565022
  573301
  573398
  579761
  580497
  584152
  586351
  597604
  600671
  601034
  607677
  610580
  618565
  623643
  634873
  635268
  676388
  716215
  720942
  725199
  728238
  732065
  733357
  735413
  753019
  754229
  757642
  759424
  759721
  774256
  779116
  784803
  787341
  790895
  797143
  797500
  797505
  798517
  799517
  799595
  800492
  801337
  801348
  804099
  804196
  805439
  806088
  807121
  809368
  811039
  811214
  811922
  812657
  812797
  812811
  812821
  813269
  813529
  814414
  815223
  815244
  815691
  815698
  815910
  816020
  817936
  817942
  817945
  818177
  818451
  818865
  819175
  820060
  820072
  821032
  821283
  821377
  821921
  822421
  822637
  823037
  823043
  823243
  824953
]
1.80 ms
(1.09%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mom латинская жоп"
]
1.77 ms
(1.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mom латинская жоп"
]
1.77 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mom latina ass"
]
1.51 ms
(0.92%)
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.