Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
140.17 ms
(84.16%)
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
  303771
  407007
  420719
  421428
  421543
  423482
  424353
  424384
  427367
  433539
  437381
  438353
  444086
  446387
  448468
  449431
  449863
  451421
  451785
  454922
  455813
  456171
  456504
  459669
  463132
  464491
  465541
  470226
  477775
  481194
  483188
  485247
  486613
  491010
  492288
  492308
  492564
  492911
  493209
  494645
  496148
  498896
  506442
  510744
  522225
  523231
  523248
  524255
  526147
  527072
  535206
  535572
  536060
  541393
  552858
  555321
  558562
  558630
  564742
  566858
  567311
  572649
  574421
  581745
  584441
  584465
  585922
  588231
  597674
  599501
  606054
  606604
  607526
  607964
  610931
  612131
  612458
  612476
  617435
  617865
  619718
  621104
  630129
  632562
  639124
  639873
  642092
  657781
  660032
  662055
  666706
  668776
  674285
  680588
  680820
  685943
  689436
  704079
  708505
  708989
  709217
  711637
  715834
  722149
  725152
  734164
  740814
  740848
  753190
  755652
  759659
  781272
  784792
  784958
  786856
  787520
  789756
  795725
  808154
  808343
]
15.86 ms
(9.52%)
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
  536060
  510744
  498896
  572649
  566858
  704079
  711637
  660032
  668776
  708505
  708989
  657781
  612476
  639124
  808343
  784958
  740814
  753190
  781272
  786856
  787520
  789756
  808154
  607526
  607964
  612131
  795725
  427367
  446387
  423482
  421543
  420719
  424384
  421428
  437381
  470226
  477775
  486613
  456504
  459669
  491010
  523248
  524255
  535572
  485247
  558630
  574421
  584441
  558562
  666706
  689436
  685943
  715834
  606604
  599501
  612458
  619718
  639873
  588231
  632562
  725152
  617865
  438353
  481194
  492911
  494645
  493209
  506442
  526147
  523231
  496148
  522225
  535206
  567311
  541393
  584465
  662055
  552858
  597674
  621104
  585922
  610931
  755652
  492564
  465541
  564742
  555321
  581745
  680820
  722149
  674285
  680588
  606054
  784792
  740848
  734164
  759659
  617435
  630129
  642092
  709217
  444086
  527072
  303771
  407007
  424353
  433539
  449431
  449863
  463132
  464491
  483188
  492288
  448468
  451421
  456171
  492308
  451785
  454922
  455813
]
3.47 ms
(2.08%)
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
  303771
  407007
  420719
  421428
  421543
  423482
  424353
  424384
  427367
  433539
  437381
  438353
  444086
  446387
  448468
  449431
  449863
  451421
  451785
  454922
  455813
  456171
  456504
  459669
  463132
  464491
  465541
  470226
  477775
  481194
  483188
  485247
  486613
  491010
  492288
  492308
  492564
  492911
  493209
  494645
  496148
  498896
  506442
  510744
  522225
  523231
  523248
  524255
  526147
  527072
  535206
  535572
  536060
  541393
  552858
  555321
  558562
  558630
  564742
  566858
  567311
  572649
  574421
  581745
  584441
  584465
  585922
  588231
  597674
  599501
  606054
  606604
  607526
  607964
  610931
  612131
  612458
  612476
  617435
  617865
  619718
  621104
  630129
  632562
  639124
  639873
  642092
  657781
  660032
  662055
  666706
  668776
  674285
  680588
  680820
  685943
  689436
  704079
  708505
  708989
  709217
  711637
  715834
  722149
  725152
  734164
  740814
  740848
  753190
  755652
  759659
  781272
  784792
  784958
  786856
  787520
  789756
  795725
  808154
  808343
]
1.92 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "мокрые в сперме"
]
1.84 ms
(1.10%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.67 ms
(1.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мокрые сперм"
]
1.64 ms
(0.98%)
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.