Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
145.63 ms
(85.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
  113322
  210281
  385915
  414734
  425887
  447493
  533204
  533896
  538935
  547265
  547314
  549385
  570772
  570774
  581357
  600374
  622354
  640125
  645344
  648213
  648852
  652903
  652904
  652906
  653258
  662038
  663963
  672105
  677114
  677737
  678565
  678576
  678578
  678586
  679044
  679060
  679061
  679078
  679079
  679082
  679096
  679132
  679135
  682802
  690800
  690834
  690855
  690913
  691497
  691523
  691530
  692253
  692261
  692330
  692336
  693037
  693041
  693057
  693860
  694023
  694052
  694073
  694083
  694222
  694455
  694458
  694476
  694485
  694522
  694528
  694540
  694555
  695188
  695196
  695236
  695620
  695621
  695631
  695635
  695919
  695928
  695932
  695941
  696354
  697273
  697790
  697971
  698517
  699689
  699708
  699731
  699743
  699757
  699767
  699778
  699779
  703437
  717735
  747312
  765157
  776206
  780541
  790025
  797681
  798969
  800944
  810922
  811489
  814280
  814763
  815238
  815309
  815721
  815774
  815793
  815965
  815979
  816544
  817828
  828845
]
13.86 ms
(8.18%)
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
  815721
  828845
  533204
  547314
  581357
  570772
  677737
  679132
  679135
  696354
  699767
  640125
  797681
  747312
  703437
  425887
  447493
  385915
  815774
  814280
  815238
  692261
  694083
  695919
  699689
  652904
  678565
  693057
  694476
  694540
  800944
  698517
  699708
  699731
  814763
  815309
  816544
  815793
  815965
  538935
  547265
  677114
  678578
  679044
  690800
  690855
  690913
  691523
  694522
  694528
  695196
  695631
  678586
  679060
  679096
  693860
  695621
  695928
  697273
  697790
  652906
  662038
  693041
  694073
  600374
  780541
  765157
  414734
  113322
  817828
  815979
  533896
  549385
  570774
  692253
  694052
  694455
  648213
  663963
  690834
  691530
  694023
  695941
  699743
  645344
  653258
  672105
  682802
  694458
  695635
  699778
  717735
  622354
  790025
  798969
  811489
  810922
  699757
  776206
  210281
  692330
  678576
  679061
  679078
  679079
  694222
  695188
  695236
  648852
  691497
  694555
  695620
  699779
  692336
  652903
  695932
  693037
  697971
  679082
  694485
]
3.28 ms
(1.93%)
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
  113322
  210281
  385915
  414734
  425887
  447493
  533204
  533896
  538935
  547265
  547314
  549385
  570772
  570774
  581357
  600374
  622354
  640125
  645344
  648213
  648852
  652903
  652904
  652906
  653258
  662038
  663963
  672105
  677114
  677737
  678565
  678576
  678578
  678586
  679044
  679060
  679061
  679078
  679079
  679082
  679096
  679132
  679135
  682802
  690800
  690834
  690855
  690913
  691497
  691523
  691530
  692253
  692261
  692330
  692336
  693037
  693041
  693057
  693860
  694023
  694052
  694073
  694083
  694222
  694455
  694458
  694476
  694485
  694522
  694528
  694540
  694555
  695188
  695196
  695236
  695620
  695621
  695631
  695635
  695919
  695928
  695932
  695941
  696354
  697273
  697790
  697971
  698517
  699689
  699708
  699731
  699743
  699757
  699767
  699778
  699779
  703437
  717735
  747312
  765157
  776206
  780541
  790025
  797681
  798969
  800944
  810922
  811489
  814280
  814763
  815238
  815309
  815721
  815774
  815793
  815965
  815979
  816544
  817828
  828845
]
1.98 ms
(1.17%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "scene секс"
]
1.73 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "scene sex"
]
1.62 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "scene секс"
]
1.46 ms
(0.86%)
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.