Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
166.42 ms
(87.60%)
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
  383599
  402190
  403215
  410851
  416585
  418102
  418111
  418142
  421199
  426826
  427396
  428280
  434313
  434314
  434327
  434335
  434349
  434365
  435171
  435395
  435553
  437970
  439243
  446543
  448758
  451273
  451852
  456219
  466467
  466564
  467908
  467923
  469460
  477249
  485470
  497665
  500957
  505747
  511372
  517108
  517798
  538537
  539370
  545001
  547734
  547762
  550817
  550938
  578866
  582569
  583774
  588201
  589626
  591476
  593285
  595028
  596240
  604865
  605711
  613572
  625779
  630270
  636414
  643005
  644870
  647330
  650719
  650895
  660620
  666502
  670460
  677843
  687388
  696499
  697768
  701233
  708062
  708678
  726122
  736017
  738496
  738503
  749571
  751637
  753199
  766152
  768517
  773283
  782096
  784125
  784626
  784844
  786711
  787522
  791113
  793132
  794058
  795406
  797082
  798832
  801783
  801810
  803046
  803626
  804246
  805146
  806943
  807011
  807586
  807827
  808652
  808665
  809009
  809631
  811221
  812050
  814202
  821198
  824119
  824754
]
14.32 ms
(7.54%)
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
  435553
  434327
  477249
  505747
  439243
  446543
  630270
  784626
  808652
  811221
  786711
  437970
  821198
  794058
  784125
  812050
  547762
  596240
  426826
  595028
  578866
  643005
  795406
  418102
  773283
  696499
  644870
  666502
  804246
  416585
  434349
  434314
  410851
  809009
  738496
  403215
  517108
  604865
  435395
  708062
  545001
  782096
  806943
  809631
  402190
  650895
  467923
  751637
  814202
  550938
  768517
  500957
  726122
  824754
  582569
  650719
  589626
  801783
  766152
  824119
  613572
  803626
  791113
  677843
  456219
  466467
  807011
  435171
  448758
  517798
  539370
  593285
  807827
  797082
  636414
  421199
  427396
  469460
  787522
  749571
  605711
  538537
  550817
  803046
  583774
  805146
  466564
  511372
  428280
  485470
  588201
  738503
  497665
  647330
  736017
  660620
  383599
  418111
  451852
  467908
  434313
  434365
  418142
  451273
  434335
  687388
  625779
  708678
  784844
  793132
  697768
  801810
  670460
  808665
  807586
  753199
  701233
  591476
  798832
  547734
]
2.44 ms
(1.29%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "tits solo squirt"
]
2.30 ms
(1.21%)
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
  383599
  402190
  403215
  410851
  416585
  418102
  418111
  418142
  421199
  426826
  427396
  428280
  434313
  434314
  434327
  434335
  434349
  434365
  435171
  435395
  435553
  437970
  439243
  446543
  448758
  451273
  451852
  456219
  466467
  466564
  467908
  467923
  469460
  477249
  485470
  497665
  500957
  505747
  511372
  517108
  517798
  538537
  539370
  545001
  547734
  547762
  550817
  550938
  578866
  582569
  583774
  588201
  589626
  591476
  593285
  595028
  596240
  604865
  605711
  613572
  625779
  630270
  636414
  643005
  644870
  647330
  650719
  650895
  660620
  666502
  670460
  677843
  687388
  696499
  697768
  701233
  708062
  708678
  726122
  736017
  738496
  738503
  749571
  751637
  753199
  766152
  768517
  773283
  782096
  784125
  784626
  784844
  786711
  787522
  791113
  793132
  794058
  795406
  797082
  798832
  801783
  801810
  803046
  803626
  804246
  805146
  806943
  807011
  807586
  807827
  808652
  808665
  809009
  809631
  811221
  812050
  814202
  821198
  824119
  824754
]
1.55 ms
(0.81%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сиськ соло сквирт оргазм"
]
1.49 ms
(0.78%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.46 ms
(0.77%)
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.