GET https://search.jues.net/search/embeds/5?q=threesome%20asian

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
209.77 ms
(51.73%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "threesome asian"
]
172.13 ms
(42.45%)
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
  23104
  167756
  185223
  236863
  324183
  327318
  394376
  407522
  408601
  409878
  410366
  412583
  419126
  420185
  420192
  420216
  420252
  421310
  421318
  425435
  429425
  430444
  430828
  433229
  434553
  440692
  446505
  448811
  450822
  454147
  456628
  458429
  464949
  468666
  483560
  499791
  507609
  510589
  515881
  516291
  517857
  519171
  522977
  527669
  530434
  534804
  537113
  540200
  540905
  541215
  541774
  541885
  542189
  543888
  543919
  544281
  546219
  551957
  551989
  552004
  552012
  552198
  554905
  557509
  559162
  560215
  560217
  560230
  566849
  566908
  580270
  581898
  586623
  586886
  590859
  591585
  592708
  595121
  595761
  597239
  598865
  601125
  603193
  603576
  607705
  610247
  617191
  617487
  619199
  622655
  623599
  623644
  623818
  635484
  636285
  642069
  646004
  654297
  662069
  662071
  673053
  675934
  679055
  679061
  694610
  702075
  713474
  721795
  744441
  752596
  759473
  759548
  767162
  767190
  767327
  767857
  789831
  792554
  820590
  828868
]
15.06 ms
(3.71%)
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
  586623
  566908
  541215
  527669
  433229
  434553
  554905
  623818
  430828
  544281
  597239
  560217
  446505
  642069
  580270
  623644
  541885
  586886
  430444
  425435
  551989
  560215
  590859
  412583
  601125
  595761
  591585
  552004
  541774
  499791
  617191
  507609
  522977
  581898
  595121
  598865
  468666
  542189
  530434
  23104
  429425
  560230
  654297
  752596
  543888
  421310
  603193
  767162
  713474
  673053
  185223
  635484
  419126
  662069
  662071
  759548
  540200
  420252
  622655
  167756
  623599
  546219
  483560
  636285
  694610
  324183
  516291
  515881
  420216
  543919
  702075
  789831
  410366
  559162
  458429
  236863
  607705
  517857
  420192
  603576
  557509
  409878
  394376
  792554
  828868
  407522
  440692
  759473
  566849
  408601
  646004
  421318
  552198
  767857
  464949
  454147
  675934
  610247
  448811
  540905
  456628
  767327
  679061
  510589
  592708
  767190
  450822
  721795
  327318
  534804
  552012
  679055
  537113
  619199
  420185
  617487
  519171
  551957
  744441
  820590
]
2.61 ms
(0.64%)
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
  23104
  167756
  185223
  236863
  324183
  327318
  394376
  407522
  408601
  409878
  410366
  412583
  419126
  420185
  420192
  420216
  420252
  421310
  421318
  425435
  429425
  430444
  430828
  433229
  434553
  440692
  446505
  448811
  450822
  454147
  456628
  458429
  464949
  468666
  483560
  499791
  507609
  510589
  515881
  516291
  517857
  519171
  522977
  527669
  530434
  534804
  537113
  540200
  540905
  541215
  541774
  541885
  542189
  543888
  543919
  544281
  546219
  551957
  551989
  552004
  552012
  552198
  554905
  557509
  559162
  560215
  560217
  560230
  566849
  566908
  580270
  581898
  586623
  586886
  590859
  591585
  592708
  595121
  595761
  597239
  598865
  601125
  603193
  603576
  607705
  610247
  617191
  617487
  619199
  622655
  623599
  623644
  623818
  635484
  636285
  642069
  646004
  654297
  662069
  662071
  673053
  675934
  679055
  679061
  694610
  702075
  713474
  721795
  744441
  752596
  759473
  759548
  767162
  767190
  767327
  767857
  789831
  792554
  820590
  828868
]
2.18 ms
(0.54%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.95 ms
(0.48%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс втро азиатк"
]
1.82 ms
(0.45%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.