Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
197.20 ms
(89.88%)
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
  383582
  411220
  420167
  462654
  463509
  487198
  488368
  488886
  495410
  495585
  498231
  499361
  506068
  508227
  511952
  513162
  516016
  532367
  533101
  535395
  537352
  539789
  547385
  552810
  553482
  554916
  558691
  568987
  578792
  586255
  586268
  586285
  592618
  592987
  595386
  604706
  609589
  609967
  611532
  613625
  617614
  618545
  618858
  625107
  625724
  632754
  635893
  638574
  641334
  641539
  644051
  644138
  650294
  662117
  673608
  678205
  678704
  682532
  694420
  697869
  702274
  704942
  707876
  709013
  710356
  712609
  715036
  716572
  716790
  720343
  724120
  727970
  729738
  733521
  734952
  737882
  739604
  739782
  740731
  742046
  743048
  743831
  746270
  750098
  753050
  757754
  757909
  763442
  765640
  766056
  766469
  770071
  771260
  772157
  772522
  774256
  785212
  789145
  791124
  794436
  794954
  795636
  796354
  797496
  797516
  797882
  800946
  801327
  802005
  803963
  807778
  808636
  810086
  814115
  817243
  820540
  823238
  824541
  826028
]
13.27 ms
(6.05%)
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
  740731
  784830
  794954
  796354
  810086
  750098
  707876
  595386
  820540
  554916
  709013
  632754
  697869
  533101
  710356
  694420
  625107
  791124
  766056
  771260
  772522
  513162
  753050
  814115
  516016
  662117
  592987
  635893
  785212
  737882
  383582
  495410
  535395
  586268
  808636
  650294
  743048
  774256
  789145
  797882
  801327
  770071
  715036
  678205
  682532
  617614
  618545
  613625
  727970
  537352
  641539
  539789
  508227
  488368
  824541
  704942
  609589
  729738
  803963
  743831
  763442
  739604
  702274
  487198
  498231
  586285
  739782
  511952
  552810
  641334
  797516
  802005
  807778
  495585
  532367
  797496
  795636
  733521
  826028
  800946
  765640
  644051
  553482
  463509
  586255
  611532
  794436
  411220
  568987
  638574
  724120
  817243
  609967
  644138
  772157
  757754
  499361
  558691
  712609
  420167
  462654
  547385
  488886
  823238
  578792
  742046
  757909
  506068
  673608
  678704
  716790
  720343
  618858
  592618
  604706
  625724
  766469
  734952
  746270
  716572
]
2.64 ms
(1.20%)
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
  383582
  411220
  420167
  462654
  463509
  487198
  488368
  488886
  495410
  495585
  498231
  499361
  506068
  508227
  511952
  513162
  516016
  532367
  533101
  535395
  537352
  539789
  547385
  552810
  553482
  554916
  558691
  568987
  578792
  586255
  586268
  586285
  592618
  592987
  595386
  604706
  609589
  609967
  611532
  613625
  617614
  618545
  618858
  625107
  625724
  632754
  635893
  638574
  641334
  641539
  644051
  644138
  650294
  662117
  673608
  678205
  678704
  682532
  694420
  697869
  702274
  704942
  707876
  709013
  710356
  712609
  715036
  716572
  716790
  720343
  724120
  727970
  729738
  733521
  734952
  737882
  739604
  739782
  740731
  742046
  743048
  743831
  746270
  750098
  753050
  757754
  757909
  763442
  765640
  766056
  766469
  770071
  771260
  772157
  772522
  774256
  785212
  789145
  791124
  794436
  794954
  795636
  796354
  797496
  797516
  797882
  800946
  801327
  802005
  803963
  807778
  808636
  810086
  814115
  817243
  820540
  823238
  824541
  826028
]
1.64 ms
(0.75%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "neighbor big tits"
]
1.56 ms
(0.71%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "neighbor большие сиськ"
]
1.56 ms
(0.71%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.54 ms
(0.70%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "neighbor большие сиськ"
]

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.