Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
137.95 ms
(86.37%)
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
  69956
  382955
  384415
  388423
  388883
  389122
  401641
  402034
  407282
  410073
  420782
  429512
  433033
  458766
  460104
  467796
  467798
  478295
  478406
  480829
  489894
  506883
  508166
  517491
  519160
  538930
  539243
  539483
  551645
  552255
  558998
  563706
  568728
  579375
  583176
  583471
  585047
  593776
  595117
  595314
  602675
  606143
  608357
  609676
  615386
  617592
  619521
  621109
  626327
  629653
  636501
  636508
  639116
  648599
  648630
  660692
  661637
  662089
  662921
  666080
  674263
  678992
  687717
  688190
  688969
  693789
  697327
  697462
  700305
  707175
  707629
  709452
  715563
  718875
  721749
  722687
  723965
  724437
  727087
  731111
  731825
  736151
  737121
  739699
  740508
  740577
  742414
  747249
  747571
  755165
  756251
  757455
  758154
  759666
  759747
  761167
  761705
  768078
  768722
  769346
  771332
  773620
  778288
  784261
  785625
  788854
  793836
  794530
  794539
  794585
  799164
  800186
  801322
  802815
  803417
  810572
  813718
  816708
  824067
  825487
]
12.25 ms
(7.67%)
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
  568728
  579375
  648599
  697327
  707629
  648630
  707175
  615386
  595314
  617592
  595117
  778288
  731825
  759666
  724437
  759747
  768722
  773620
  740508
  747571
  740577
  768078
  769346
  788854
  799164
  388883
  467796
  69956
  407282
  402034
  384415
  410073
  813718
  824067
  478295
  480829
  489894
  460104
  517491
  539483
  539243
  506883
  519160
  558998
  583176
  583471
  552255
  709452
  715563
  666080
  721749
  674263
  678992
  722687
  551645
  593776
  608357
  626327
  619521
  606143
  609676
  800186
  802815
  784261
  794530
  810572
  727087
  742414
  757455
  761167
  761705
  731111
  756251
  771332
  747249
  736151
  739699
  755165
  758154
  700305
  801322
  382955
  389122
  388423
  478406
  467798
  433033
  458766
  508166
  401641
  429512
  420782
  585047
  816708
  825487
  538930
  563706
  662089
  687717
  693789
  718875
  660692
  661637
  688969
  697462
  662921
  688190
  621109
  629653
  636501
  639116
  602675
  636508
  794585
  803417
  785625
  737121
  793836
  794539
  723965
]
3.04 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
  69956
  382955
  384415
  388423
  388883
  389122
  401641
  402034
  407282
  410073
  420782
  429512
  433033
  458766
  460104
  467796
  467798
  478295
  478406
  480829
  489894
  506883
  508166
  517491
  519160
  538930
  539243
  539483
  551645
  552255
  558998
  563706
  568728
  579375
  583176
  583471
  585047
  593776
  595117
  595314
  602675
  606143
  608357
  609676
  615386
  617592
  619521
  621109
  626327
  629653
  636501
  636508
  639116
  648599
  648630
  660692
  661637
  662089
  662921
  666080
  674263
  678992
  687717
  688190
  688969
  693789
  697327
  697462
  700305
  707175
  707629
  709452
  715563
  718875
  721749
  722687
  723965
  724437
  727087
  731111
  731825
  736151
  737121
  739699
  740508
  740577
  742414
  747249
  747571
  755165
  756251
  757455
  758154
  759666
  759747
  761167
  761705
  768078
  768722
  769346
  771332
  773620
  778288
  784261
  785625
  788854
  793836
  794530
  794539
  794585
  799164
  800186
  801322
  802815
  803417
  810572
  813718
  816708
  824067
  825487
]
1.96 ms
(1.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "tits cumshot"
]
1.61 ms
(1.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сиськ cumshot"
]
1.60 ms
(1.00%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.30 ms
(0.81%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "сиськ cumshot"
]

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.