Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
131.00 ms
(83.33%)
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
  330354
  391951
  396574
  397325
  415529
  426728
  427709
  432749
  441424
  455888
  461933
  461935
  464239
  469732
  478651
  484440
  490778
  490800
  509163
  517834
  533276
  537504
  542348
  549277
  555215
  557018
  564344
  569736
  570930
  578131
  580606
  582096
  583086
  583909
  589325
  593562
  607301
  607802
  621404
  622477
  623542
  634735
  644149
  651097
  652276
  664712
  664755
  665404
  667244
  674023
  675745
  680229
  680282
  684305
  713159
  713301
  714949
  715700
  717664
  717712
  719916
  722148
  724030
  724519
  726888
  726932
  728410
  729666
  730392
  731280
  731311
  733339
  734331
  734411
  734928
  734961
  736222
  736231
  742852
  743044
  743654
  745227
  750156
  753316
  755408
  757795
  758096
  758593
  758929
  760892
  765248
  766681
  766883
  767417
  769864
  771737
  775043
  775382
  779681
  779730
  781327
  785684
  786749
  786940
  788552
  788858
  791097
  797705
  799516
  799668
  800466
  801225
  802207
  802328
  802668
  802825
  817182
  820011
  824167
  826834
]
15.59 ms
(9.91%)
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
  634735
  802207
  758593
  397325
  713159
  652276
  667244
  675745
  674023
  722148
  644149
  775043
  779730
  730392
  724519
  719916
  330354
  580606
  583086
  664712
  549277
  582096
  775382
  781327
  726888
  750156
  745227
  757795
  743654
  802668
  753316
  461933
  665404
  799516
  396574
  817182
  555215
  427709
  824167
  717712
  779681
  432749
  684305
  826834
  583909
  680229
  717664
  607802
  785684
  788552
  797705
  802825
  736231
  771737
  800466
  802328
  726932
  731280
  758929
  734928
  621404
  484440
  415529
  820011
  517834
  714949
  664755
  715700
  622477
  589325
  788858
  734411
  742852
  786940
  728410
  731311
  734961
  729666
  461935
  478651
  651097
  623542
  733339
  441424
  607301
  801225
  765248
  743044
  455888
  557018
  564344
  569736
  713301
  786749
  734331
  766883
  769864
  767417
  490800
  490778
  509163
  537504
  680282
  578131
  593562
  799668
  724030
  736222
  766681
  755408
  760892
  758096
  791097
  391951
  426728
  464239
  469732
  533276
  570930
  542348
]
2.99 ms
(1.90%)
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
  330354
  391951
  396574
  397325
  415529
  426728
  427709
  432749
  441424
  455888
  461933
  461935
  464239
  469732
  478651
  484440
  490778
  490800
  509163
  517834
  533276
  537504
  542348
  549277
  555215
  557018
  564344
  569736
  570930
  578131
  580606
  582096
  583086
  583909
  589325
  593562
  607301
  607802
  621404
  622477
  623542
  634735
  644149
  651097
  652276
  664712
  664755
  665404
  667244
  674023
  675745
  680229
  680282
  684305
  713159
  713301
  714949
  715700
  717664
  717712
  719916
  722148
  724030
  724519
  726888
  726932
  728410
  729666
  730392
  731280
  731311
  733339
  734331
  734411
  734928
  734961
  736222
  736231
  742852
  743044
  743654
  745227
  750156
  753316
  755408
  757795
  758096
  758593
  758929
  760892
  765248
  766681
  766883
  767417
  769864
  771737
  775043
  775382
  779681
  779730
  781327
  785684
  786749
  786940
  788552
  788858
  791097
  797705
  799516
  799668
  800466
  801225
  802207
  802328
  802668
  802825
  817182
  820011
  824167
  826834
]
2.14 ms
(1.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "ебля с криками"
]
2.01 ms
(1.28%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.84 ms
(1.17%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс крича вперв"
]
1.64 ms
(1.04%)
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.