Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
130.25 ms
(82.26%)
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
  188062
  383987
  384998
  385296
  395552
  395687
  395727
  396742
  397306
  401127
  401842
  404939
  405012
  405028
  405093
  405176
  405222
  408601
  409995
  411717
  411747
  412262
  417897
  420762
  423657
  424470
  425332
  430072
  435624
  442494
  443726
  443806
  445896
  445971
  448215
  449060
  449933
  454065
  463073
  464703
  467614
  468039
  468637
  470643
  471881
  474635
  476257
  477549
  483581
  484402
  484739
  484767
  484821
  486589
  488805
  491859
  495014
  495905
  501931
  505012
  505625
  512181
  512215
  515165
  518493
  518547
  518588
  519038
  521805
  522592
  525133
  525701
  527888
  530500
  538190
  538360
  541605
  543376
  549500
  550764
  550781
  551991
  557526
  559918
  568480
  570394
  572027
  572550
  576634
  583503
  586673
  592403
  592530
  592533
  593541
  595798
  599844
  603628
  605617
  606778
  611571
  616025
  616336
  642378
  649186
  650459
  667898
  670959
  681833
  688045
  691200
  692237
  720245
  720885
  731877
  742849
  792554
  810013
  814850
  815490
]
17.57 ms
(11.09%)
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
  417897
  538190
  605617
  518493
  384998
  397306
  411717
  435624
  814850
  530500
  512215
  572550
  650459
  692237
  720245
  691200
  592533
  731877
  420762
  464703
  395727
  474635
  401842
  405093
  409995
  488805
  188062
  401127
  411747
  468637
  476257
  515165
  570394
  603628
  792554
  742849
  443806
  424470
  443726
  483581
  815490
  445896
  463073
  512181
  495905
  518547
  550764
  550781
  559918
  522592
  484767
  667898
  720885
  593541
  810013
  616336
  616025
  486589
  405176
  470643
  467614
  445971
  572027
  557526
  505012
  519038
  642378
  525701
  606778
  495014
  543376
  568480
  408601
  425332
  449933
  468039
  449060
  549500
  405222
  538360
  599844
  404939
  471881
  491859
  521805
  484821
  541605
  670959
  551991
  576634
  586673
  396742
  405028
  430072
  423657
  448215
  477549
  518588
  681833
  592530
  395552
  395687
  405012
  527888
  501931
  484402
  385296
  383987
  412262
  442494
  454065
  484739
  505625
  525133
  583503
  688045
  649186
  611571
  592403
  595798
]
3.10 ms
(1.96%)
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
  188062
  383987
  384998
  385296
  395552
  395687
  395727
  396742
  397306
  401127
  401842
  404939
  405012
  405028
  405093
  405176
  405222
  408601
  409995
  411717
  411747
  412262
  417897
  420762
  423657
  424470
  425332
  430072
  435624
  442494
  443726
  443806
  445896
  445971
  448215
  449060
  449933
  454065
  463073
  464703
  467614
  468039
  468637
  470643
  471881
  474635
  476257
  477549
  483581
  484402
  484739
  484767
  484821
  486589
  488805
  491859
  495014
  495905
  501931
  505012
  505625
  512181
  512215
  515165
  518493
  518547
  518588
  519038
  521805
  522592
  525133
  525701
  527888
  530500
  538190
  538360
  541605
  543376
  549500
  550764
  550781
  551991
  557526
  559918
  568480
  570394
  572027
  572550
  576634
  583503
  586673
  592403
  592530
  592533
  593541
  595798
  599844
  603628
  605617
  606778
  611571
  616025
  616336
  642378
  649186
  650459
  667898
  670959
  681833
  688045
  691200
  692237
  720245
  720885
  731877
  742849
  792554
  810013
  814850
  815490
]
2.11 ms
(1.33%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "волосатая мжм"
]
1.89 ms
(1.19%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "волосатая мжм секс втро"
]
1.85 ms
(1.17%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.59 ms
(1.00%)
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.