GET https://search.jues.net/search/embeds/6?q=solo%20teen%20girls

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
153.11 ms
(85.81%)
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
  29148
  61437
  163135
  381997
  385884
  385930
  401193
  402083
  411285
  412852
  416581
  416703
  417783
  420432
  428241
  430103
  439033
  439135
  443516
  454725
  475457
  478029
  483742
  484934
  500313
  510354
  515267
  517888
  521294
  527920
  528034
  529034
  531767
  533292
  534066
  536267
  536641
  538326
  539706
  542711
  548945
  565480
  576314
  577381
  577780
  581407
  584341
  584606
  586834
  592333
  594321
  598778
  600037
  600150
  600895
  606123
  607755
  608001
  617524
  628205
  630039
  644041
  644043
  650232
  657537
  661034
  662131
  666858
  670762
  671098
  683296
  684843
  684855
  684888
  693084
  701291
  702910
  703668
  705389
  706520
  711000
  717322
  739320
  742455
  743157
  743160
  743285
  745113
  749134
  749380
  750344
  750362
  751319
  751415
  751792
  751808
  756562
  756830
  757190
  758821
  773146
  774872
  780382
  780393
  780403
  783190
  783707
  783948
  785114
  785125
  786259
  792064
  803124
  804900
  807616
  808126
  808412
  809018
  812235
  819958
]
15.01 ms
(8.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
  757190
  758821
  739320
  751319
  751808
  743157
  756830
  630039
  644041
  644043
  706520
  711000
  780382
  783707
  783948
  792064
  804900
  163135
  401193
  381997
  510354
  430103
  411285
  385930
  61437
  517888
  661034
  628205
  534066
  484934
  439135
  416703
  443516
  428241
  416581
  417783
  439033
  529034
  483742
  412852
  581407
  385884
  29148
  819958
  475457
  536267
  539706
  515267
  533292
  538326
  584341
  650232
  657537
  662131
  684888
  705389
  684843
  684855
  693084
  717322
  586834
  598778
  600037
  600150
  607755
  606123
  594321
  774872
  780393
  785114
  785125
  786259
  808412
  780403
  751415
  751792
  783190
  807616
  812235
  749380
  745113
  756562
  773146
  743285
  749134
  608001
  617524
  702910
  703668
  803124
  808126
  683296
  750344
  742455
  536641
  527920
  521294
  576314
  584606
  592333
  500313
  528034
  577381
  577780
  420432
  402083
  531767
  548945
  666858
  671098
  670762
  600895
  809018
  750362
  743160
  701291
  478029
  454725
  565480
  542711
]
2.84 ms
(1.59%)
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
  29148
  61437
  163135
  381997
  385884
  385930
  401193
  402083
  411285
  412852
  416581
  416703
  417783
  420432
  428241
  430103
  439033
  439135
  443516
  454725
  475457
  478029
  483742
  484934
  500313
  510354
  515267
  517888
  521294
  527920
  528034
  529034
  531767
  533292
  534066
  536267
  536641
  538326
  539706
  542711
  548945
  565480
  576314
  577381
  577780
  581407
  584341
  584606
  586834
  592333
  594321
  598778
  600037
  600150
  600895
  606123
  607755
  608001
  617524
  628205
  630039
  644041
  644043
  650232
  657537
  661034
  662131
  666858
  670762
  671098
  683296
  684843
  684855
  684888
  693084
  701291
  702910
  703668
  705389
  706520
  711000
  717322
  739320
  742455
  743157
  743160
  743285
  745113
  749134
  749380
  750344
  750362
  751319
  751415
  751792
  751808
  756562
  756830
  757190
  758821
  773146
  774872
  780382
  780393
  780403
  783190
  783707
  783948
  785114
  785125
  786259
  792064
  803124
  804900
  807616
  808126
  808412
  809018
  812235
  819958
]
2.29 ms
(1.28%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "solo teen girls"
]
1.92 ms
(1.08%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "соло teen девушк"
]
1.71 ms
(0.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "соло teen девушк"
]
1.53 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.