Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
155.31 ms
(85.04%)
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
  96100
  96231
  97401
  210072
  325910
  383387
  387301
  390362
  390538
  396334
  397302
  407290
  408443
  420201
  420471
  446359
  448874
  513106
  516644
  527627
  532916
  533867
  540334
  546022
  547997
  551239
  551976
  554745
  558843
  569202
  576359
  584007
  584696
  588262
  591192
  597269
  597275
  598484
  598569
  600366
  601512
  603170
  609277
  610847
  614186
  617620
  624788
  626310
  628321
  630234
  630902
  633493
  633776
  634161
  641928
  643725
  644679
  645093
  645132
  646228
  648554
  649935
  650827
  651062
  651855
  651856
  652978
  653728
  654294
  668527
  670040
  670965
  672984
  674508
  677730
  680121
  680192
  680202
  681053
  681235
  687185
  690809
  692506
  695125
  696355
  696865
  698096
  699694
  705737
  715497
  716373
  720050
  720239
  721538
  723714
  725407
  729123
  732071
  742848
  745404
  745550
  746852
  769209
  775862
  784254
  786255
  788174
  790679
  792356
  793712
  798411
  801942
  809525
  811270
  811486
  817451
  818297
  818470
  823920
  827201
]
16.77 ms
(9.18%)
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
  554745
  674508
  690809
  645093
  653728
  681053
  696865
  698096
  603170
  624788
  723714
  769209
  390362
  420201
  597269
  598484
  775862
  96100
  387301
  817451
  551239
  551976
  546022
  547997
  584007
  651855
  652978
  681235
  677730
  695125
  721538
  558843
  634161
  746852
  742848
  601512
  446359
  396334
  527627
  513106
  383387
  97401
  96231
  420471
  448874
  540334
  516644
  532916
  569202
  649935
  651062
  670040
  672984
  680192
  680202
  699694
  650827
  651856
  670965
  687185
  668527
  680121
  720050
  576359
  600366
  591192
  597275
  614186
  633776
  609277
  630234
  630902
  801942
  745404
  732071
  626310
  633493
  407290
  390538
  408443
  325910
  823920
  827201
  818297
  818470
  533867
  584696
  646228
  715497
  648554
  654294
  692506
  696355
  716373
  645132
  720239
  598569
  610847
  644679
  588262
  643725
  617620
  628321
  641928
  784254
  786255
  788174
  793712
  809525
  811270
  798411
  725407
  729123
  745550
  811486
  705737
  790679
  792356
  397302
  210072
]
3.36 ms
(1.84%)
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
  96100
  96231
  97401
  210072
  325910
  383387
  387301
  390362
  390538
  396334
  397302
  407290
  408443
  420201
  420471
  446359
  448874
  513106
  516644
  527627
  532916
  533867
  540334
  546022
  547997
  551239
  551976
  554745
  558843
  569202
  576359
  584007
  584696
  588262
  591192
  597269
  597275
  598484
  598569
  600366
  601512
  603170
  609277
  610847
  614186
  617620
  624788
  626310
  628321
  630234
  630902
  633493
  633776
  634161
  641928
  643725
  644679
  645093
  645132
  646228
  648554
  649935
  650827
  651062
  651855
  651856
  652978
  653728
  654294
  668527
  670040
  670965
  672984
  674508
  677730
  680121
  680192
  680202
  681053
  681235
  687185
  690809
  692506
  695125
  696355
  696865
  698096
  699694
  705737
  715497
  716373
  720050
  720239
  721538
  723714
  725407
  729123
  732071
  742848
  745404
  745550
  746852
  769209
  775862
  784254
  786255
  788174
  790679
  792356
  793712
  798411
  801942
  809525
  811270
  811486
  817451
  818297
  818470
  823920
  827201
]
2.28 ms
(1.25%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.71 ms
(0.94%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "девушк gangbang"
]
1.70 ms
(0.93%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "girl gangbang"
]
1.50 ms
(0.82%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "девушк gangbang"
]

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.