Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
139.62 ms
(84.89%)
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
  4306
  383323
  393641
  396797
  397087
  397970
  398354
  398693
  399300
  415658
  418060
  418357
  420078
  425157
  433619
  434899
  436343
  436953
  437417
  439417
  441425
  441427
  441467
  441595
  441808
  442475
  443865
  443897
  445355
  447090
  448483
  448496
  448573
  449144
  449541
  451133
  451277
  451406
  452636
  453820
  458448
  459863
  464655
  465233
  469421
  477702
  478841
  486135
  487567
  490171
  493618
  494635
  506616
  508104
  508876
  512297
  513921
  514845
  519840
  521050
  525942
  529879
  559535
  564118
  568807
  569623
  582549
  583279
  584305
  594897
  597213
  599653
  601587
  608311
  617590
  619192
  626002
  626725
  631334
  632541
  633036
  644738
  656607
  665435
  668942
  681208
  690618
  690886
  691180
  701535
  707450
  710620
  711328
  711375
  720197
  725971
  730305
  734964
  747461
  757630
  759321
  760471
  761144
  761801
  763445
  766191
  767682
  773853
  779753
  781210
  785600
  787739
  787868
  790119
  791060
  791074
  791834
  811279
  816606
  827977
]
12.58 ms
(7.65%)
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
  448483
  487567
  773853
  631334
  442475
  568807
  453820
  494635
  514845
  529879
  594897
  633036
  707450
  779753
  785600
  730305
  767682
  787739
  790119
  761144
  781210
  811279
  508876
  525942
  766191
  449144
  760471
  439417
  447090
  599653
  451133
  619192
  506616
  720197
  690886
  425157
  393641
  441467
  445355
  827977
  601587
  787868
  763445
  711375
  441425
  448573
  469421
  519840
  513921
  521050
  383323
  397087
  397970
  398693
  434899
  433619
  816606
  464655
  448496
  451406
  583279
  656607
  690618
  681208
  691180
  701535
  710620
  711328
  668942
  632541
  644738
  791074
  791834
  734964
  747461
  725971
  757630
  436953
  441808
  418060
  437417
  486135
  396797
  441427
  441595
  451277
  459863
  465233
  617590
  490171
  564118
  584305
  759321
  761801
  399300
  415658
  559535
  512297
  569623
  608311
  597213
  626002
  626725
  791060
  477702
  420078
  436343
  478841
  449541
  508104
  582549
  665435
  4306
  398354
  443865
  418357
  493618
  458448
  443897
  452636
]
3.44 ms
(2.09%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "молодая девушк жен красивая"
]
3.37 ms
(2.05%)
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
  4306
  383323
  393641
  396797
  397087
  397970
  398354
  398693
  399300
  415658
  418060
  418357
  420078
  425157
  433619
  434899
  436343
  436953
  437417
  439417
  441425
  441427
  441467
  441595
  441808
  442475
  443865
  443897
  445355
  447090
  448483
  448496
  448573
  449144
  449541
  451133
  451277
  451406
  452636
  453820
  458448
  459863
  464655
  465233
  469421
  477702
  478841
  486135
  487567
  490171
  493618
  494635
  506616
  508104
  508876
  512297
  513921
  514845
  519840
  521050
  525942
  529879
  559535
  564118
  568807
  569623
  582549
  583279
  584305
  594897
  597213
  599653
  601587
  608311
  617590
  619192
  626002
  626725
  631334
  632541
  633036
  644738
  656607
  665435
  668942
  681208
  690618
  690886
  691180
  701535
  707450
  710620
  711328
  711375
  720197
  725971
  730305
  734964
  747461
  757630
  759321
  760471
  761144
  761801
  763445
  766191
  767682
  773853
  779753
  781210
  785600
  787739
  787868
  790119
  791060
  791074
  791834
  811279
  816606
  827977
]
2.07 ms
(1.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "молодая соседка красивая"
]
1.90 ms
(1.15%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.49 ms
(0.90%)
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.