Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
292.29 ms
(92.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
  542285
  542423
  542549
  545389
  545418
  554843
  559924
  569379
  575358
  576453
  581033
  589337
  593734
  597763
  599833
  600297
  601578
  604715
  605512
  606322
  607217
  608679
  610199
  612430
  614382
  615053
  618870
  626332
  629680
  630254
  630552
  632579
  632706
  632750
  637511
  639060
  639719
  639796
  640156
  641953
  642006
  642226
  642774
  645700
  646176
  647860
  650075
  650634
  666894
  671070
  671773
  672401
  672764
  678095
  680176
  685511
  690942
  704896
  710026
  714577
  715888
  719649
  719829
  721949
  724039
  726330
  727969
  728605
  729187
  732589
  732869
  734350
  734364
  736396
  736534
  736944
  737883
  738326
  738694
  741692
  744765
  745981
  747069
  747384
  748138
  751453
  752840
  753656
  753707
  757237
  757246
  758145
  758292
  768059
  775815
  788127
  789111
  793438
  793723
  794240
  796577
  797240
  799934
  800698
  800763
  800920
  807881
  809358
  809925
  811010
  814302
  817709
  817864
  817879
  818291
  819488
  820347
  824196
  827279
  827591
]
13.99 ms
(4.42%)
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
  542549
  646176
  639796
  600297
  610199
  738326
  814302
  672764
  710026
  757237
  768059
  775815
  576453
  632750
  793438
  807881
  736396
  800763
  809925
  737883
  789111
  732869
  599833
  820347
  817864
  729187
  753707
  678095
  666894
  827279
  575358
  607217
  744765
  647860
  680176
  601578
  632706
  752840
  747069
  819488
  612430
  732589
  745981
  824196
  827591
  719649
  719829
  685511
  690942
  554843
  753656
  751453
  738694
  758145
  608679
  545389
  641953
  639719
  630552
  639060
  642006
  589337
  818291
  704896
  618870
  734350
  715888
  559924
  642774
  581033
  671070
  597763
  630254
  788127
  797240
  799934
  736534
  793723
  727969
  800920
  721949
  626332
  757246
  726330
  640156
  605512
  604715
  637511
  632579
  796577
  714577
  593734
  736944
  748138
  614382
  671773
  672401
  642226
  809358
  817709
  817879
  569379
  650634
  606322
  629680
  724039
  758292
  542285
  645700
  650075
  615053
  794240
  728605
  734364
  741692
  800698
  811010
  545418
  542423
  747384
]
2.55 ms
(0.81%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "piss big tits"
]
2.44 ms
(0.77%)
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
  542285
  542423
  542549
  545389
  545418
  554843
  559924
  569379
  575358
  576453
  581033
  589337
  593734
  597763
  599833
  600297
  601578
  604715
  605512
  606322
  607217
  608679
  610199
  612430
  614382
  615053
  618870
  626332
  629680
  630254
  630552
  632579
  632706
  632750
  637511
  639060
  639719
  639796
  640156
  641953
  642006
  642226
  642774
  645700
  646176
  647860
  650075
  650634
  666894
  671070
  671773
  672401
  672764
  678095
  680176
  685511
  690942
  704896
  710026
  714577
  715888
  719649
  719829
  721949
  724039
  726330
  727969
  728605
  729187
  732589
  732869
  734350
  734364
  736396
  736534
  736944
  737883
  738326
  738694
  741692
  744765
  745981
  747069
  747384
  748138
  751453
  752840
  753656
  753707
  757237
  757246
  758145
  758292
  768059
  775815
  788127
  789111
  793438
  793723
  794240
  796577
  797240
  799934
  800698
  800763
  800920
  807881
  809358
  809925
  811010
  814302
  817709
  817864
  817879
  818291
  819488
  820347
  824196
  827279
  827591
]
1.97 ms
(0.62%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.85 ms
(0.58%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "писсинг большие сиськ"
]
1.72 ms
(0.54%)
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.