Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
158.33 ms
(84.61%)
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
  80653
  81565
  385912
  465409
  484363
  523988
  530333
  533211
  539619
  542464
  544264
  544276
  544342
  544359
  544575
  548234
  548271
  549280
  549309
  549323
  549325
  549875
  549899
  551706
  556985
  560084
  566797
  570811
  572598
  572604
  583899
  586826
  588635
  591228
  592472
  599698
  611144
  621695
  629942
  649989
  668441
  674317
  678563
  678577
  679055
  679088
  679093
  679099
  685472
  687098
  690827
  690860
  690896
  691485
  691514
  691533
  692224
  692250
  692258
  692259
  692265
  692324
  692804
  693862
  693866
  694071
  694206
  694225
  694492
  694524
  694538
  694564
  695191
  695241
  695278
  695280
  696273
  696350
  696553
  697258
  697261
  697278
  697359
  697374
  697717
  697828
  698398
  698405
  698511
  698526
  698548
  698583
  698589
  699390
  699684
  699686
  699695
  699723
  699734
  699735
  699744
  699745
  699753
  699762
  699765
  702524
  704268
  709313
  711574
  712698
  720738
  728050
  729957
  738501
  738769
  744278
  756426
  780050
  791424
  799567
]
17.74 ms
(9.48%)
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
  542464
  549280
  572604
  560084
  678577
  696350
  712698
  678563
  687098
  691533
  694492
  697717
  690896
  692265
  695241
  698405
  549875
  592472
  599698
  621695
  738501
  738769
  629942
  698511
  698583
  570811
  691485
  692258
  674317
  697258
  698548
  699390
  699695
  695191
  699753
  611144
  699735
  80653
  465409
  530333
  544264
  548271
  551706
  694538
  679093
  696273
  691514
  694225
  549899
  583899
  586826
  591228
  588635
  799567
  791424
  756426
  744278
  699765
  702524
  711574
  699686
  690827
  692324
  693866
  695280
  668441
  697374
  699723
  679055
  694071
  694564
  695278
  729957
  697278
  698398
  698589
  704268
  484363
  544359
  679088
  692250
  699684
  694524
  697359
  692224
  572598
  780050
  728050
  699745
  699762
  81565
  523988
  548234
  544342
  679099
  690860
  697828
  720738
  692259
  697261
  685472
  692804
  696553
  698526
  699734
  699744
  385912
  533211
  539619
  549325
  544575
  549309
  549323
  566797
  544276
  556985
  649989
  693862
  694206
  709313
]
3.71 ms
(1.98%)
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
  80653
  81565
  385912
  465409
  484363
  523988
  530333
  533211
  539619
  542464
  544264
  544276
  544342
  544359
  544575
  548234
  548271
  549280
  549309
  549323
  549325
  549875
  549899
  551706
  556985
  560084
  566797
  570811
  572598
  572604
  583899
  586826
  588635
  591228
  592472
  599698
  611144
  621695
  629942
  649989
  668441
  674317
  678563
  678577
  679055
  679088
  679093
  679099
  685472
  687098
  690827
  690860
  690896
  691485
  691514
  691533
  692224
  692250
  692258
  692259
  692265
  692324
  692804
  693862
  693866
  694071
  694206
  694225
  694492
  694524
  694538
  694564
  695191
  695241
  695278
  695280
  696273
  696350
  696553
  697258
  697261
  697278
  697359
  697374
  697717
  697828
  698398
  698405
  698511
  698526
  698548
  698583
  698589
  699390
  699684
  699686
  699695
  699723
  699734
  699735
  699744
  699745
  699753
  699762
  699765
  702524
  704268
  709313
  711574
  712698
  720738
  728050
  729957
  738501
  738769
  744278
  756426
  780050
  791424
  799567
]
1.98 ms
(1.06%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сцен секс"
]
1.97 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "сцена секса"
]
1.74 ms
(0.93%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.67 ms
(0.89%)
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.