Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
130.11 ms
(81.82%)
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
  398426
  411998
  415539
  418363
  418596
  419061
  419758
  423329
  430700
  434322
  440625
  440824
  445471
  447810
  447896
  448832
  455217
  463842
  469738
  476797
  502043
  503405
  510396
  512928
  512975
  513572
  523027
  524696
  531097
  531155
  532651
  532676
  532791
  532812
  532847
  533013
  533920
  533978
  537760
  537863
  541832
  543868
  546110
  547434
  550397
  555291
  560949
  564551
  566855
  578823
  580035
  580107
  582323
  582540
  583913
  583982
  591959
  597204
  599976
  600297
  600355
  601613
  603258
  613146
  614858
  619703
  620794
  623262
  625696
  632571
  632617
  632659
  632663
  633123
  635275
  636295
  637044
  639745
  645861
  647859
  647994
  648853
  649596
  650305
  651631
  666586
  666850
  666853
  666906
  668534
  674986
  676623
  676632
  678153
  683261
  688108
  699397
  702677
  711283
  716160
  735546
  736674
  748504
  752597
  752647
  758097
  765218
  770102
  770242
  777533
  789469
  794824
  803455
  804464
  808341
  815017
  815849
  818327
  824035
  827326
]
19.44 ms
(12.23%)
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
  582323
  580035
  683261
  600355
  619703
  620794
  804464
  419758
  418596
  434322
  445471
  649596
  597204
  632571
  419061
  469738
  668534
  637044
  632659
  639745
  523027
  808341
  824035
  765218
  541832
  533978
  512928
  543868
  418363
  411998
  550397
  735546
  532847
  503405
  531097
  688108
  651631
  702677
  711283
  648853
  599976
  636295
  601613
  614858
  632663
  440824
  815017
  455217
  512975
  532676
  566855
  647994
  674986
  666853
  676632
  666586
  676623
  632617
  613146
  448832
  770242
  537863
  398426
  583913
  699397
  580107
  633123
  463842
  827326
  770102
  447810
  600297
  803455
  758097
  447896
  532651
  647859
  582540
  625696
  547434
  752647
  815849
  748504
  531155
  532812
  502043
  560949
  513572
  510396
  532791
  678153
  603258
  476797
  537760
  524696
  645861
  591959
  794824
  789469
  650305
  736674
  415539
  666906
  533920
  818327
  546110
  440625
  578823
  583982
  623262
  430700
  716160
  564551
  555291
  752597
  635275
  533013
  666850
  777533
  423329
]
2.57 ms
(1.61%)
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
  398426
  411998
  415539
  418363
  418596
  419061
  419758
  423329
  430700
  434322
  440625
  440824
  445471
  447810
  447896
  448832
  455217
  463842
  469738
  476797
  502043
  503405
  510396
  512928
  512975
  513572
  523027
  524696
  531097
  531155
  532651
  532676
  532791
  532812
  532847
  533013
  533920
  533978
  537760
  537863
  541832
  543868
  546110
  547434
  550397
  555291
  560949
  564551
  566855
  578823
  580035
  580107
  582323
  582540
  583913
  583982
  591959
  597204
  599976
  600297
  600355
  601613
  603258
  613146
  614858
  619703
  620794
  623262
  625696
  632571
  632617
  632659
  632663
  633123
  635275
  636295
  637044
  639745
  645861
  647859
  647994
  648853
  649596
  650305
  651631
  666586
  666850
  666853
  666906
  668534
  674986
  676623
  676632
  678153
  683261
  688108
  699397
  702677
  711283
  716160
  735546
  736674
  748504
  752597
  752647
  758097
  765218
  770102
  770242
  777533
  789469
  794824
  803455
  804464
  808341
  815017
  815849
  818327
  824035
  827326
]
2.00 ms
(1.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal squirt mature"
]
1.81 ms
(1.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "анал сквирт оргазм mature"
]
1.68 ms
(1.06%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал сквирт оргазм mature"
]
1.40 ms
(0.88%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.