Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
175.06 ms
(87.01%)
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
  21506
  384808
  400137
  401159
  402659
  403031
  414164
  414177
  415735
  416385
  417745
  420101
  422351
  425682
  427523
  428159
  428596
  430397
  433572
  440691
  443061
  446126
  446359
  446900
  447551
  448859
  451410
  453785
  454092
  459499
  459506
  460450
  460629
  461591
  461655
  463298
  465964
  466022
  466700
  466781
  466886
  469171
  473761
  475876
  480089
  480885
  483613
  488561
  494402
  495588
  499378
  504578
  506218
  512826
  513002
  513098
  514387
  514388
  518555
  520421
  521964
  523182
  523761
  531907
  538638
  539699
  542818
  542831
  543435
  551202
  556935
  561077
  561885
  562265
  562327
  566170
  566642
  567735
  571062
  574490
  575506
  576368
  576445
  582944
  583629
  590123
  594212
  594518
  594525
  596161
  597269
  603108
  624231
  632169
  635141
  650160
  652913
  668533
  678915
  696949
  712158
  716118
  720188
  720211
  723492
  732681
  743120
  752164
  758024
  774178
  776126
  784256
  784744
  790501
  803454
  806668
  811994
  812364
  820594
  823519
]
16.07 ms
(7.99%)
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
  635141
  784256
  784744
  488561
  446900
  460629
  454092
  594518
  806668
  416385
  400137
  428159
  523182
  514388
  463298
  461591
  414164
  506218
  543435
  556935
  561077
  582944
  696949
  594212
  594525
  752164
  774178
  433572
  443061
  460450
  414177
  422351
  499378
  440691
  415735
  428596
  430397
  461655
  448859
  465964
  466700
  531907
  542831
  576445
  551202
  561885
  562327
  571062
  575506
  576368
  542818
  712158
  678915
  720211
  562265
  566642
  567735
  574490
  590123
  603108
  596161
  597269
  776126
  811994
  812364
  732681
  743120
  790501
  758024
  624231
  720188
  723492
  803454
  446126
  473761
  480885
  425682
  446359
  459506
  466781
  469171
  401159
  420101
  451410
  403031
  480089
  417745
  447551
  459499
  466022
  475876
  514387
  520421
  521964
  494402
  504578
  513002
  518555
  523761
  483613
  512826
  632169
  513098
  384808
  21506
  402659
  427523
  820594
  823519
  453785
  466886
  539699
  538638
  495588
  566170
  583629
  650160
  652913
  668533
  716118
]
2.60 ms
(1.29%)
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
  21506
  384808
  400137
  401159
  402659
  403031
  414164
  414177
  415735
  416385
  417745
  420101
  422351
  425682
  427523
  428159
  428596
  430397
  433572
  440691
  443061
  446126
  446359
  446900
  447551
  448859
  451410
  453785
  454092
  459499
  459506
  460450
  460629
  461591
  461655
  463298
  465964
  466022
  466700
  466781
  466886
  469171
  473761
  475876
  480089
  480885
  483613
  488561
  494402
  495588
  499378
  504578
  506218
  512826
  513002
  513098
  514387
  514388
  518555
  520421
  521964
  523182
  523761
  531907
  538638
  539699
  542818
  542831
  543435
  551202
  556935
  561077
  561885
  562265
  562327
  566170
  566642
  567735
  571062
  574490
  575506
  576368
  576445
  582944
  583629
  590123
  594212
  594518
  594525
  596161
  597269
  603108
  624231
  632169
  635141
  650160
  652913
  668533
  678915
  696949
  712158
  716118
  720188
  720211
  723492
  732681
  743120
  752164
  758024
  774178
  776126
  784256
  784744
  790501
  803454
  806668
  811994
  812364
  820594
  823519
]
2.30 ms
(1.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hot teen tits"
]
1.83 ms
(0.91%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "hot teen сиськ"
]
1.71 ms
(0.85%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(0.81%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "hot teen сиськ"
]

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.