Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
212.15 ms
(53.01%)
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
  420405
  422010
  422316
  493820
  521082
  523554
  531645
  533816
  533820
  536114
  536131
  538289
  550564
  550800
  558082
  573351
  575636
  577717
  581930
  583641
  588542
  591899
  594413
  595438
  604141
  607903
  617651
  621430
  621600
  621986
  628851
  636946
  648512
  648619
  651724
  654405
  654430
  657723
  659576
  660317
  660345
  661583
  664252
  665760
  671546
  677191
  678763
  678876
  693425
  708570
  709814
  713300
  714692
  715332
  718971
  719262
  721217
  721448
  722403
  722617
  722666
  722829
  723520
  724774
  726608
  728959
  732401
  736636
  740749
  742799
  742884
  746088
  746355
  747496
  748011
  748338
  750769
  751426
  752416
  753437
  753441
  753455
  753479
  754196
  757188
  757223
  760896
  762577
  764406
  766718
  767798
  767871
  769768
  773519
  775453
  775484
  776782
  782744
  785079
  785123
  786498
  789785
  792437
  795552
  801574
  803219
  803382
  805545
  810168
  811818
  817364
  817630
  817699
  817708
  817713
  818226
  818322
  822363
  825273
]
173.27 ms
(43.29%)
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
  420405
  422010
  422316
  493820
  521082
  523554
  531645
  533816
  533820
  536114
  536131
  538289
  550564
  550800
  558082
  573351
  575636
  577717
  581930
  583641
  588542
  591899
  594413
  595438
  604141
  607903
  617651
  621430
  621600
  621986
  628851
  636946
  648512
  648619
  651724
  654405
  654430
  657723
  659576
  660317
  660345
  661583
  664252
  665760
  671546
  677191
  678763
  678876
  693425
  708570
  709814
  713300
  714692
  715332
  718971
  719262
  721217
  721448
  722403
  722617
  722666
  722829
  723520
  724774
  726608
  728959
  732401
  736636
  740749
  742799
  742884
  746088
  746355
  747496
  748011
  748338
  750769
  751426
  752416
  753437
  753441
  753455
  753479
  754196
  757188
  757223
  760896
  762577
  764406
  766718
  767798
  767871
  769768
  773519
  775453
  775484
  776782
  782744
  785079
  785123
  786498
  789785
  792437
  795552
  801574
  803219
  803382
  805545
  810168
  811818
  817364
  817630
  817699
  817708
  817713
  818226
  818322
  822363
  825273
]
9.07 ms
(2.27%)
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
  422316
  420405
  422010
  817699
  818226
  818322
  822363
  723520
  817713
  817630
  817708
  825273
  817364
  493820
  521082
  536131
  533816
  533820
  536114
  523554
  531645
  538289
  573351
  575636
  577717
  581930
  583641
  550564
  558082
  648512
  651724
  659576
  664252
  677191
  678876
  693425
  648619
  661583
  665760
  678763
  708570
  709814
  713300
  714692
  721448
  722666
  722829
  654405
  654430
  657723
  660317
  660345
  671546
  715332
  721217
  722403
  722617
  550800
  591899
  594413
  607903
  621986
  595438
  621600
  628851
  588542
  636946
  604141
  621430
  775484
  776782
  785123
  786498
  792437
  801574
  803382
  805545
  775453
  795552
  803219
  752416
  753437
  757188
  773519
  782744
  785079
  789785
  810168
  811818
  728959
  732401
  742799
  746355
  747496
  748338
  751426
  753479
  736636
  748011
  753441
  754196
  757223
  760896
  764406
  766718
  769768
  726608
  742884
  746088
  750769
  753455
  767871
  770317
  724774
  740749
  762577
  767798
  617651
  718971
  719262
]
1.72 ms
(0.43%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "shaved teen pussy"
]
1.56 ms
(0.39%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "бритая teen pussy"
]
1.29 ms
(0.32%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.15 ms
(0.29%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "бритая teen 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.