Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
176.01 ms
(89.68%)
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
  214238
  225633
  382652
  384516
  389226
  389782
  393039
  398496
  401089
  402138
  409931
  435497
  440646
  455843
  468985
  470820
  471992
  473284
  480902
  484374
  485019
  486694
  507172
  507208
  519762
  521317
  526487
  528720
  534344
  539463
  540782
  543452
  547649
  549439
  551040
  552577
  554975
  557270
  566923
  569906
  570646
  571575
  571863
  572818
  576304
  577146
  580903
  580996
  581318
  583277
  589717
  591319
  592966
  595964
  602692
  604064
  612688
  614170
  621707
  621712
  622038
  622888
  637608
  639632
  642979
  644101
  673574
  675709
  677934
  681699
  685527
  692744
  694153
  696529
  698246
  699136
  699651
  699670
  708842
  708843
  715415
  716159
  718741
  723549
  727392
  734349
  741225
  743188
  745146
  748163
  752919
  753702
  754651
  755857
  756895
  760781
  765942
  766766
  773470
  774209
  781017
  785221
  786811
  787795
  791804
  795956
  805847
  808214
  815660
  815726
  816844
  816855
  817948
  819096
  819117
  820534
  820982
  822154
  828398
]
10.44 ms
(5.32%)
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
  470820
  521317
  528720
  581318
  554975
  571863
  569906
  694153
  696529
  699651
  699670
  708842
  715415
  675709
  557270
  566923
  604064
  612688
  776494
  727392
  755857
  754651
  621707
  708843
  787795
  808214
  382652
  681699
  805847
  455843
  435497
  486694
  547649
  622888
  602692
  384516
  398496
  642979
  534344
  817948
  723549
  822154
  699136
  716159
  773470
  389226
  485019
  692744
  765942
  745146
  507172
  225633
  815660
  816844
  816855
  540782
  819096
  819117
  820534
  820982
  815726
  828398
  583277
  543452
  580903
  698246
  718741
  549439
  592966
  644101
  639632
  589717
  595964
  781017
  785221
  734349
  741225
  743188
  753702
  752919
  756895
  766766
  637608
  786811
  791804
  795956
  214238
  402138
  389782
  473284
  393039
  440646
  409931
  539463
  526487
  572818
  576304
  552577
  571575
  577146
  685527
  591319
  614170
  622038
  748163
  760781
  774209
  471992
  401089
  468985
  484374
  519762
  580996
  621712
  507208
  480902
  551040
  570646
  673574
  677934
]
2.25 ms
(1.15%)
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
  214238
  225633
  382652
  384516
  389226
  389782
  393039
  398496
  401089
  402138
  409931
  435497
  440646
  455843
  468985
  470820
  471992
  473284
  480902
  484374
  485019
  486694
  507172
  507208
  519762
  521317
  526487
  528720
  534344
  539463
  540782
  543452
  547649
  549439
  551040
  552577
  554975
  557270
  566923
  569906
  570646
  571575
  571863
  572818
  576304
  577146
  580903
  580996
  581318
  583277
  589717
  591319
  592966
  595964
  602692
  604064
  612688
  614170
  621707
  621712
  622038
  622888
  637608
  639632
  642979
  644101
  673574
  675709
  677934
  681699
  685527
  692744
  694153
  696529
  698246
  699136
  699651
  699670
  708842
  708843
  715415
  716159
  718741
  723549
  727392
  734349
  741225
  743188
  745146
  748163
  752919
  753702
  754651
  755857
  756895
  760781
  765942
  766766
  773470
  774209
  781017
  785221
  786811
  787795
  791804
  795956
  805847
  808214
  815660
  815726
  816844
  816855
  817948
  819096
  819117
  820534
  820982
  822154
  828398
]
2.24 ms
(1.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "public lick pussy"
]
1.98 ms
(1.01%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "на улиц лиза pussy"
]
1.70 ms
(0.87%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(0.83%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "на улиц лиза pussy"
]

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.