Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
148.34 ms
(87.18%)
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
  6670
  33113
  106162
  188669
  389024
  389667
  391588
  395959
  398201
  398816
  399853
  400426
  401134
  401344
  404693
  404765
  404845
  415978
  417647
  418411
  419855
  422519
  422566
  422575
  422604
  422609
  423000
  423039
  423245
  423261
  423263
  424622
  428018
  443150
  451741
  453624
  463927
  464580
  468756
  480006
  482801
  485085
  494697
  511268
  512049
  512868
  533760
  537893
  541324
  543863
  550207
  556015
  559507
  560430
  568058
  581168
  584539
  597267
  598067
  598319
  598537
  604142
  611001
  612082
  617408
  618916
  624282
  628380
  628419
  632028
  634510
  636998
  640773
  640784
  644291
  644636
  645951
  651161
  660963
  666968
  672709
  677125
  677955
  680186
  685001
  686658
  687262
  691992
  691993
  703089
  706946
  714500
  717916
  718525
  719067
  721717
  721846
  726461
  729920
  732055
  733909
  735524
  742422
  744753
  753260
  760963
  790867
  800266
  801165
  807985
  810032
  811425
  811669
  811678
  811944
  814266
  815329
  815483
  817448
  819579
]
12.97 ms
(7.62%)
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
  453624
  511268
  398201
  423261
  424622
  651161
  597267
  744753
  810032
  790867
  395959
  464580
  721846
  814266
  533760
  634510
  640784
  389667
  604142
  729920
  584539
  742422
  398816
  672709
  644636
  718525
  680186
  817448
  660963
  560430
  687262
  640773
  801165
  807985
  714500
  404693
  419855
  417647
  685001
  666968
  418411
  415978
  636998
  404765
  703089
  482801
  721717
  612082
  628380
  451741
  598537
  33113
  512868
  677125
  611001
  800266
  422609
  537893
  541324
  811669
  401344
  422575
  556015
  717916
  677955
  617408
  463927
  188669
  691993
  632028
  401134
  645951
  644291
  618916
  726461
  735524
  106162
  480006
  624282
  559507
  6670
  550207
  400426
  423245
  543863
  598067
  733909
  404845
  389024
  399853
  423039
  422566
  423000
  815329
  512049
  719067
  598319
  760963
  391588
  423263
  422604
  428018
  443150
  468756
  485085
  494697
  819579
  815483
  706946
  686658
  691992
  811425
  811678
  753260
  811944
  732055
  628419
  422519
  581168
  568058
]
2.69 ms
(1.58%)
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
  6670
  33113
  106162
  188669
  389024
  389667
  391588
  395959
  398201
  398816
  399853
  400426
  401134
  401344
  404693
  404765
  404845
  415978
  417647
  418411
  419855
  422519
  422566
  422575
  422604
  422609
  423000
  423039
  423245
  423261
  423263
  424622
  428018
  443150
  451741
  453624
  463927
  464580
  468756
  480006
  482801
  485085
  494697
  511268
  512049
  512868
  533760
  537893
  541324
  543863
  550207
  556015
  559507
  560430
  568058
  581168
  584539
  597267
  598067
  598319
  598537
  604142
  611001
  612082
  617408
  618916
  624282
  628380
  628419
  632028
  634510
  636998
  640773
  640784
  644291
  644636
  645951
  651161
  660963
  666968
  672709
  677125
  677955
  680186
  685001
  686658
  687262
  691992
  691993
  703089
  706946
  714500
  717916
  718525
  719067
  721717
  721846
  726461
  729920
  732055
  733909
  735524
  742422
  744753
  753260
  760963
  790867
  800266
  801165
  807985
  810032
  811425
  811669
  811678
  811944
  814266
  815329
  815483
  817448
  819579
]
1.90 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "young anal sex"
]
1.54 ms
(0.91%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "young анал секс"
]
1.38 ms
(0.81%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.32 ms
(0.78%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "young анал секс"
]

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.