GET https://search.jues.net/search/embeds/9?q=teen%20close%20up

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
116.44 ms
(84.41%)
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
  546247
  549123
  557068
  559406
  567849
  568102
  569633
  575600
  592283
  593611
  594287
  594410
  595442
  607265
  608532
  616837
  617355
  623195
  626524
  628448
  628850
  629226
  634649
  636884
  643605
  646092
  648620
  649678
  652419
  654105
  655170
  655265
  656290
  656599
  656622
  656663
  657134
  657175
  657216
  657217
  657227
  659184
  660867
  662138
  663169
  663314
  665995
  667087
  668343
  669267
  670014
  670711
  671255
  671258
  672629
  672669
  673711
  674396
  674848
  674873
  675842
  676740
  677470
  679655
  679663
  680236
  681196
  681787
  681805
  682991
  683282
  684885
  685548
  685810
  686728
  687525
  687718
  688760
  688927
  688960
  690173
  690429
  690443
  690892
  691190
  691511
  691738
  691971
  692091
  692646
  694437
  694580
  694592
  696404
  703324
  710083
  712181
  713674
  713913
  715004
  715020
  715055
  715827
  716047
  716316
  717256
  717359
  717469
  717499
  717907
  718260
  719344
  719650
  720130
  720408
  720748
  722444
  723161
  723269
  723434
]
11.56 ms
(8.38%)
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
  656599
  657134
  662138
  663169
  663314
  665995
  668343
  671258
  672629
  673711
  677470
  679655
  680236
  681787
  683282
  685810
  687718
  688760
  691511
  691738
  694437
  694580
  717499
  720408
  722444
  646092
  649678
  652419
  655170
  656290
  656663
  657175
  657227
  660867
  669267
  670014
  671255
  674396
  674873
  675842
  676740
  679663
  681805
  688927
  688960
  690173
  690443
  691971
  692091
  692646
  703324
  710083
  712181
  713674
  713913
  715055
  716047
  716316
  717359
  717907
  719344
  719650
  720130
  723161
  723269
  648620
  654105
  655265
  656622
  657216
  657217
  659184
  667087
  670711
  672669
  674848
  681196
  682991
  684885
  685548
  686728
  687525
  690429
  690892
  691190
  694592
  696404
  715004
  715020
  715827
  717256
  717469
  718260
  720748
  723434
  546247
  549123
  557068
  559406
  567849
  568102
  569633
  575600
  594287
  594410
  608532
  617355
  626524
  628448
  628850
  629226
  634649
  636884
  643605
  592283
  593611
  595442
  607265
  616837
  623195
]
3.10 ms
(2.24%)
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
  546247
  549123
  557068
  559406
  567849
  568102
  569633
  575600
  592283
  593611
  594287
  594410
  595442
  607265
  608532
  616837
  617355
  623195
  626524
  628448
  628850
  629226
  634649
  636884
  643605
  646092
  648620
  649678
  652419
  654105
  655170
  655265
  656290
  656599
  656622
  656663
  657134
  657175
  657216
  657217
  657227
  659184
  660867
  662138
  663169
  663314
  665995
  667087
  668343
  669267
  670014
  670711
  671255
  671258
  672629
  672669
  673711
  674396
  674848
  674873
  675842
  676740
  677470
  679655
  679663
  680236
  681196
  681787
  681805
  682991
  683282
  684885
  685548
  685810
  686728
  687525
  687718
  688760
  688927
  688960
  690173
  690429
  690443
  690892
  691190
  691511
  691738
  691971
  692091
  692646
  694437
  694580
  694592
  696404
  703324
  710083
  712181
  713674
  713913
  715004
  715020
  715055
  715827
  716047
  716316
  717256
  717359
  717469
  717499
  717907
  718260
  719344
  719650
  720130
  720408
  720748
  722444
  723161
  723269
  723434
]
2.03 ms
(1.47%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teen close up"
]
1.88 ms
(1.36%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.65 ms
(1.20%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teen close up"
]
1.29 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "teen close up"
]

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.