GET https://search.jues.net/search/embeds/5?q=dildo%20panties

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
167.98 ms
(83.91%)
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
  28892
  88436
  382581
  383285
  414122
  415300
  416685
  417580
  418219
  419282
  420686
  429601
  429892
  432656
  436054
  437717
  438880
  439240
  439322
  439993
  442431
  448791
  450889
  452881
  460038
  462848
  465470
  469124
  470479
  470838
  473395
  479936
  482291
  485297
  486510
  491007
  498110
  498112
  500338
  508423
  512005
  514240
  519379
  525431
  527285
  528318
  528608
  529053
  531844
  541451
  545455
  547480
  554582
  556425
  557650
  564501
  568301
  569281
  569575
  570115
  578731
  580018
  580190
  582303
  583283
  584418
  584806
  587081
  591482
  591527
  595256
  597190
  602189
  604662
  609097
  609574
  611274
  660385
  665958
  668970
  669073
  671018
  696866
  713501
  716241
  717514
  720200
  730767
  731605
  738822
  739145
  739156
  746364
  746515
  752617
  752660
  752677
  757226
  757434
  757448
  762230
  764426
  765179
  765712
  776007
  780192
  782274
  784030
  786895
  791376
  792700
  794041
  795373
  799696
  803624
  807050
  807590
  808144
  808337
  824191
]
19.14 ms
(9.56%)
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
  439993
  465470
  584806
  528318
  491007
  570115
  512005
  514240
  470838
  432656
  416685
  439240
  508423
  529053
  584418
  668970
  580018
  602189
  609574
  611274
  460038
  442431
  587081
  382581
  415300
  420686
  429601
  462848
  519379
  531844
  541451
  556425
  752677
  88436
  437717
  452881
  450889
  482291
  609097
  439322
  469124
  527285
  604662
  485297
  486510
  525431
  436054
  470479
  545455
  547480
  660385
  671018
  597190
  807590
  739145
  752660
  765712
  717514
  419282
  795373
  730767
  696866
  383285
  824191
  528608
  554582
  569575
  583283
  582303
  557650
  669073
  720200
  665958
  713501
  564501
  578731
  591482
  591527
  782274
  791376
  799696
  803624
  786895
  746515
  757434
  757448
  794041
  807050
  808144
  808337
  731605
  746364
  738822
  739156
  757226
  765179
  762230
  752617
  764426
  716241
  776007
  780192
  784030
  792700
  28892
  473395
  414122
  479936
  568301
  418219
  498112
  498110
  580190
  429892
  438880
  448791
  500338
  417580
  569281
  595256
]
4.48 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
  28892
  88436
  382581
  383285
  414122
  415300
  416685
  417580
  418219
  419282
  420686
  429601
  429892
  432656
  436054
  437717
  438880
  439240
  439322
  439993
  442431
  448791
  450889
  452881
  460038
  462848
  465470
  469124
  470479
  470838
  473395
  479936
  482291
  485297
  486510
  491007
  498110
  498112
  500338
  508423
  512005
  514240
  519379
  525431
  527285
  528318
  528608
  529053
  531844
  541451
  545455
  547480
  554582
  556425
  557650
  564501
  568301
  569281
  569575
  570115
  578731
  580018
  580190
  582303
  583283
  584418
  584806
  587081
  591482
  591527
  595256
  597190
  602189
  604662
  609097
  609574
  611274
  660385
  665958
  668970
  669073
  671018
  696866
  713501
  716241
  717514
  720200
  730767
  731605
  738822
  739145
  739156
  746364
  746515
  752617
  752660
  752677
  757226
  757434
  757448
  762230
  764426
  765179
  765712
  776007
  780192
  782274
  784030
  786895
  791376
  792700
  794041
  795373
  799696
  803624
  807050
  807590
  808144
  808337
  824191
]
2.39 ms
(1.20%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "дилд трусик нижн бел"
]
2.22 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "dildo panties"
]
2.00 ms
(1.00%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "дилд трусик нижн бел"
]
1.97 ms
(0.98%)
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.