GET https://search.jues.net/search/embeds?q=desi%20indian%20sex

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
161.04 ms
(85.23%)
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
  473825
  481644
  513843
  520474
  526437
  533289
  538264
  544876
  563276
  570151
  577101
  587268
  590265
  591897
  611493
  614376
  621548
  640148
  650551
  650666
  650681
  655523
  667253
  668960
  669252
  669260
  685318
  705262
  716965
  716968
  716970
  716974
  716979
  717274
  717278
  717476
  720165
  720168
  724583
  725366
  727262
  728134
  731224
  731298
  734174
  734779
  734794
  734800
  734978
  735781
  736204
  736205
  736224
  736226
  736695
  737256
  737272
  737770
  737995
  738125
  738127
  738147
  738148
  738172
  739093
  740274
  740687
  740698
  740726
  740740
  740755
  740758
  740770
  740777
  742113
  743005
  747241
  750507
  753733
  755520
  757575
  760381
  762771
  762774
  782314
  784290
  788441
  788550
  788551
  788797
  788985
  794818
  794986
  795469
  795880
  796242
  796787
  796822
  797303
  800090
  800768
  803154
  803164
  808097
  810012
  810924
  811151
  811927
  813677
  813680
  813691
  814502
  819302
  820096
  824910
  825954
  826282
  827996
  828215
  828328
]
15.91 ms
(8.42%)
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
  740740
  824910
  727262
  736205
  544876
  591897
  813691
  784290
  810012
  736226
  747241
  716970
  740770
  740687
  737995
  825954
  739093
  810924
  738172
  731224
  731298
  827996
  828328
  737272
  738127
  794986
  795880
  797303
  740274
  734794
  717476
  755520
  788797
  737256
  828215
  738148
  655523
  669252
  796242
  734174
  725366
  738147
  814502
  669260
  650551
  740777
  788985
  813680
  762774
  685318
  782314
  800768
  740726
  788551
  736695
  813677
  800090
  750507
  716968
  743005
  611493
  737770
  742113
  757575
  826282
  819302
  734779
  762771
  587268
  796787
  811151
  788550
  735781
  734800
  621548
  811927
  724583
  753733
  650681
  808097
  734978
  705262
  820096
  720168
  736224
  788441
  533289
  740698
  538264
  526437
  736204
  716979
  640148
  740755
  740758
  720165
  795469
  481644
  803154
  473825
  563276
  650666
  794818
  803164
  570151
  717278
  728134
  668960
  760381
  513843
  738125
  716974
  796822
  577101
  716965
  717274
  590265
  520474
  667253
  614376
]
4.38 ms
(2.32%)
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
  473825
  481644
  513843
  520474
  526437
  533289
  538264
  544876
  563276
  570151
  577101
  587268
  590265
  591897
  611493
  614376
  621548
  640148
  650551
  650666
  650681
  655523
  667253
  668960
  669252
  669260
  685318
  705262
  716965
  716968
  716970
  716974
  716979
  717274
  717278
  717476
  720165
  720168
  724583
  725366
  727262
  728134
  731224
  731298
  734174
  734779
  734794
  734800
  734978
  735781
  736204
  736205
  736224
  736226
  736695
  737256
  737272
  737770
  737995
  738125
  738127
  738147
  738148
  738172
  739093
  740274
  740687
  740698
  740726
  740740
  740755
  740758
  740770
  740777
  742113
  743005
  747241
  750507
  753733
  755520
  757575
  760381
  762771
  762774
  782314
  784290
  788441
  788550
  788551
  788797
  788985
  794818
  794986
  795469
  795880
  796242
  796787
  796822
  797303
  800090
  800768
  803154
  803164
  808097
  810012
  810924
  811151
  811927
  813677
  813680
  813691
  814502
  819302
  820096
  824910
  825954
  826282
  827996
  828215
  828328
]
2.34 ms
(1.24%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "desi indian sex"
]
1.82 ms
(0.96%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "desi indian секс"
]
1.80 ms
(0.95%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.67 ms
(0.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "desi indian секс"
]

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.