GET https://search.jues.net/search/embeds/7?q=busty%20girl

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
213.47 ms
(58.29%)
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
  23003
  34369
  172191
  191069
  199346
  222222
  285404
  383667
  384543
  397771
  401364
  405972
  415354
  451009
  471987
  485168
  487143
  533190
  533811
  533813
  536468
  536567
  537758
  538687
  540192
  543958
  543998
  548587
  552187
  554436
  556600
  565082
  565128
  569725
  573351
  580730
  585896
  591121
  594186
  594233
  607434
  611410
  612869
  612991
  617861
  623596
  629852
  639882
  643454
  663810
  663979
  665970
  668706
  673176
  677749
  678924
  689340
  697085
  698991
  713369
  715457
  716315
  718746
  727685
  728551
  737402
  737422
  742045
  743869
  750543
  752103
  754487
  758675
  759799
  768053
  770177
  770689
  771944
  772071
  772637
  780037
  781842
  784001
  784379
  784639
  791198
  792786
  795537
  796278
  796567
  796717
  798337
  798373
  799141
  799622
  799717
  800214
  804485
  805544
  805625
  807003
  807583
  808087
  808301
  808351
  808509
  808561
  809323
  811968
  816904
  817661
  818599
  819989
  821515
  822921
  823156
  824104
  825519
  828833
]
127.91 ms
(34.93%)
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
  23003
  34369
  172191
  191069
  199346
  222222
  285404
  383667
  384543
  397771
  401364
  405972
  415354
  451009
  471987
  485168
  487143
  533190
  533811
  533813
  536468
  536567
  537758
  538687
  540192
  543958
  543998
  548587
  552187
  554436
  556600
  565082
  565128
  569725
  573351
  580730
  585896
  591121
  594186
  594233
  607434
  611410
  612869
  612991
  617861
  623596
  629852
  639882
  643454
  663810
  663979
  665970
  668706
  673176
  677749
  678924
  689340
  697085
  698991
  713369
  715457
  716315
  718746
  727685
  728551
  737402
  737422
  742045
  743869
  750543
  752103
  754487
  758675
  759799
  768053
  770177
  770689
  771944
  772071
  772637
  780037
  781842
  784001
  784379
  784639
  791198
  792786
  795537
  796278
  796567
  796717
  798337
  798373
  799141
  799622
  799717
  800214
  804485
  805544
  805625
  807003
  807583
  808087
  808301
  808351
  808509
  808561
  809323
  811968
  816904
  817661
  818599
  819989
  821515
  822921
  823156
  824104
  825519
  828833
]
17.11 ms
(4.67%)
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
  172191
  34369
  405972
  817661
  818599
  819989
  825519
  823156
  822921
  816904
  821515
  828833
  537758
  487143
  485168
  540192
  533190
  543958
  554436
  565082
  573351
  543998
  548587
  565128
  580730
  663810
  698991
  715457
  716315
  663979
  665970
  668706
  673176
  569725
  617861
  612991
  623596
  591121
  611410
  629852
  643454
  594186
  594233
  780037
  796278
  796567
  799622
  799717
  800214
  798337
  804485
  805625
  808301
  808351
  811968
  727685
  728551
  743869
  758675
  771944
  781842
  795537
  796717
  808087
  759799
  752103
  768053
  772071
  742045
  750543
  772918
  697085
  792786
  808509
  809323
  401364
  199346
  222222
  397771
  191069
  23003
  824104
  451009
  471987
  533811
  536468
  536567
  538687
  533813
  552187
  556600
  718746
  689340
  713369
  677749
  678924
  585896
  607434
  612869
  791198
  799141
  807003
  808561
  772637
  805544
  737402
  737422
  754487
  770177
  770689
  639882
  784001
  784379
  784639
  798373
  807583
  285404
  383667
  384543
  415354
]
2.15 ms
(0.59%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.02 ms
(0.55%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "busty girl"
]
1.91 ms
(0.52%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "busty девушк"
]
1.65 ms
(0.45%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "busty девушк"
]

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.