GET https://search.jues.net/search/embeds/8?q=young%20vagina

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
136.21 ms
(82.67%)
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
  106162
  206386
  382372
  384238
  393737
  393745
  393759
  393790
  394186
  394224
  396270
  396894
  399267
  399456
  399865
  399888
  400422
  400450
  400609
  401120
  401213
  401898
  401976
  406817
  407383
  411715
  413174
  413468
  414498
  416303
  418646
  418867
  420600
  422589
  422684
  423243
  423260
  424173
  429317
  431452
  435498
  450313
  458601
  458602
  460036
  463161
  463182
  463262
  463750
  464290
  466635
  467152
  467324
  469898
  470289
  470734
  474108
  477986
  482386
  498025
  507360
  507379
  515091
  517867
  517997
  521225
  523025
  539942
  549300
  551066
  551762
  562375
  566549
  567391
  577189
  580670
  583262
  583856
  584524
  584666
  586015
  590244
  595363
  595451
  596353
  596585
  596669
  598450
  598462
  599729
  600040
  605515
  607735
  618050
  624831
  638623
  641739
  646270
  647657
  653496
  665496
  666124
  666767
  672744
  677311
  682515
  686652
  688606
  692880
  706641
  707881
  714357
  722050
  730492
  744095
  776468
  787931
  788647
  794610
  813905
]
17.46 ms
(10.60%)
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
  393759
  400422
  400450
  399865
  393737
  394186
  470734
  517867
  498025
  393745
  394224
  399456
  401976
  401898
  401120
  406817
  422684
  423243
  413468
  435498
  411715
  813905
  474108
  507379
  517997
  521225
  460036
  464290
  551066
  577189
  584666
  646270
  682515
  707881
  666124
  692880
  706641
  714357
  647657
  677311
  688606
  624831
  596585
  599729
  638623
  641739
  595451
  618050
  595363
  596353
  605515
  776468
  787931
  730492
  744095
  722050
  788647
  414498
  418646
  106162
  396894
  407383
  399267
  400609
  469898
  477986
  396270
  429317
  450313
  458601
  539942
  507360
  566549
  562375
  672744
  666767
  567391
  584524
  586015
  598450
  598462
  600040
  607735
  590244
  424173
  431452
  482386
  401213
  418867
  463161
  463182
  463750
  467152
  467324
  470289
  466635
  393790
  413174
  420600
  515091
  523025
  686652
  794610
  583856
  416303
  458602
  580670
  549300
  653496
  665496
  551762
  583262
  596669
  463262
  384238
  206386
  382372
  399888
  422589
  423260
]
4.05 ms
(2.46%)
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
  106162
  206386
  382372
  384238
  393737
  393745
  393759
  393790
  394186
  394224
  396270
  396894
  399267
  399456
  399865
  399888
  400422
  400450
  400609
  401120
  401213
  401898
  401976
  406817
  407383
  411715
  413174
  413468
  414498
  416303
  418646
  418867
  420600
  422589
  422684
  423243
  423260
  424173
  429317
  431452
  435498
  450313
  458601
  458602
  460036
  463161
  463182
  463262
  463750
  464290
  466635
  467152
  467324
  469898
  470289
  470734
  474108
  477986
  482386
  498025
  507360
  507379
  515091
  517867
  517997
  521225
  523025
  539942
  549300
  551066
  551762
  562375
  566549
  567391
  577189
  580670
  583262
  583856
  584524
  584666
  586015
  590244
  595363
  595451
  596353
  596585
  596669
  598450
  598462
  599729
  600040
  605515
  607735
  618050
  624831
  638623
  641739
  646270
  647657
  653496
  665496
  666124
  666767
  672744
  677311
  682515
  686652
  688606
  692880
  706641
  707881
  714357
  722050
  730492
  744095
  776468
  787931
  788647
  794610
  813905
]
2.02 ms
(1.22%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.94 ms
(1.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "young vagina"
]
1.66 ms
(1.01%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "young вагин"
]
1.42 ms
(0.86%)
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.