Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
117.43 ms
(83.59%)
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
  385392
  389588
  454700
  466929
  480998
  483879
  491867
  493242
  507805
  510288
  514211
  532188
  536177
  536578
  537454
  538166
  539679
  543668
  549305
  549515
  556079
  556719
  557218
  558629
  564098
  566555
  567978
  571303
  576780
  580384
  581374
  583559
  587715
  588363
  604590
  632242
  632500
  634961
  647259
  651404
  651882
  656958
  660670
  661427
  663014
  664622
  665450
  665900
  668581
  668899
  671142
  671616
  672385
  679235
  681344
  682308
  682379
  685317
  691706
  693797
  697024
  697552
  698844
  705247
  706639
  709641
  715692
  716881
  719491
  719989
  720797
  725512
  727381
  729641
  730414
  730526
  730707
  730830
  733392
  733409
  733461
  734030
  734194
  734247
  740673
  749399
  749414
  750703
  753744
  755220
  756513
  757881
  760256
  761389
  764083
  768755
  795027
  795066
  799302
  800963
  808700
  812090
  813696
  814793
  815809
  817592
  819400
  819548
  821673
  822062
  822108
  822193
  823397
  823410
  825301
  825759
  826873
  827487
  827832
]
13.54 ms
(9.64%)
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
  538166
  727381
  389588
  823397
  825759
  480998
  483879
  491867
  536177
  507805
  510288
  532188
  537454
  556079
  566555
  719491
  672385
  716881
  647259
  663014
  715692
  719989
  632242
  634961
  733461
  730830
  768755
  755220
  764083
  730526
  761389
  632500
  679235
  734247
  705247
  709641
  750703
  749399
  697552
  734030
  385392
  817592
  825301
  827832
  576780
  720797
  656958
  587715
  588363
  799302
  795027
  795066
  756513
  757881
  760256
  740673
  454700
  493242
  725512
  514211
  571303
  466929
  733392
  564098
  681344
  539679
  558629
  800963
  808700
  729641
  733409
  753744
  734194
  749414
  822062
  730414
  604590
  819548
  826873
  536578
  549515
  812090
  730707
  819400
  821673
  822193
  822108
  827487
  815809
  813696
  814793
  823410
  567978
  583559
  543668
  549305
  556719
  581374
  557218
  580384
  651404
  660670
  661427
  664622
  665450
  665900
  668581
  671616
  682308
  685317
  697024
  698844
  706639
  651882
  668899
  671142
  682379
  688681
  691706
  693797
]
2.36 ms
(1.68%)
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
  385392
  389588
  454700
  466929
  480998
  483879
  491867
  493242
  507805
  510288
  514211
  532188
  536177
  536578
  537454
  538166
  539679
  543668
  549305
  549515
  556079
  556719
  557218
  558629
  564098
  566555
  567978
  571303
  576780
  580384
  581374
  583559
  587715
  588363
  604590
  632242
  632500
  634961
  647259
  651404
  651882
  656958
  660670
  661427
  663014
  664622
  665450
  665900
  668581
  668899
  671142
  671616
  672385
  679235
  681344
  682308
  682379
  685317
  691706
  693797
  697024
  697552
  698844
  705247
  706639
  709641
  715692
  716881
  719491
  719989
  720797
  725512
  727381
  729641
  730414
  730526
  730707
  730830
  733392
  733409
  733461
  734030
  734194
  734247
  740673
  749399
  749414
  750703
  753744
  755220
  756513
  757881
  760256
  761389
  764083
  768755
  795027
  795066
  799302
  800963
  808700
  812090
  813696
  814793
  815809
  817592
  819400
  819548
  821673
  822062
  822108
  822193
  823397
  823410
  825301
  825759
  826873
  827487
  827832
]
1.91 ms
(1.36%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.86 ms
(1.32%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "masturbation dick"
]
1.72 ms
(1.22%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "мастурбац член"
]
1.66 ms
(1.18%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.