GET https://search.jues.net/search/embeds/3?q=desi%20homemade

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
150.20 ms
(86.28%)
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
  417366
  463137
  473825
  481644
  488924
  517811
  526437
  529848
  538264
  538474
  539432
  542537
  545149
  547225
  559342
  563276
  564403
  566937
  577175
  582026
  583567
  583662
  586954
  589650
  591897
  599619
  601791
  610138
  610993
  615995
  621548
  625210
  628631
  629276
  629544
  631144
  640148
  642280
  650596
  650649
  650681
  650687
  660032
  660687
  661580
  662874
  666114
  666120
  668553
  669250
  669283
  673668
  709715
  712082
  712252
  716977
  716979
  718369
  720165
  720168
  724583
  730970
  734708
  734800
  734814
  734978
  735781
  736198
  736204
  736224
  737261
  737272
  738125
  738145
  738463
  739071
  739717
  740698
  740721
  740755
  740757
  740758
  742101
  749516
  750514
  751667
  753226
  753733
  757516
  760338
  761365
  766263
  782015
  788429
  788550
  793142
  794752
  794807
  794964
  795469
  795837
  795896
  796787
  797087
  800445
  802402
  808097
  810012
  810928
  811151
  811285
  811418
  811911
  811927
  812050
  816670
  820096
  825333
  826883
]
13.06 ms
(7.50%)
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
  761365
  734814
  760338
  810012
  577175
  650681
  547225
  599619
  631144
  621548
  735781
  601791
  753226
  539432
  545149
  582026
  718369
  811151
  811285
  771975
  788550
  794752
  795837
  795896
  739071
  742101
  738463
  734800
  740757
  794807
  757516
  517811
  629544
  796787
  802402
  811418
  811927
  739717
  808097
  724583
  753733
  812050
  668553
  660032
  712252
  589650
  610993
  628631
  529848
  816670
  825333
  826883
  559342
  542537
  650649
  666114
  720168
  661580
  673668
  793142
  810928
  730970
  736198
  734978
  751667
  734708
  797087
  720165
  820096
  538474
  800445
  736224
  738145
  737272
  481644
  583662
  794964
  538264
  526437
  662874
  716979
  660687
  669250
  709715
  564403
  640148
  591897
  610138
  642280
  615995
  625210
  740755
  629276
  650596
  488924
  666120
  788429
  811911
  737261
  740721
  766263
  750514
  736204
  740698
  795469
  417366
  463137
  749516
  740758
  716977
  782015
  563276
  650687
  669283
  566937
  738125
  473825
  583567
  712082
  586954
]
3.39 ms
(1.94%)
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
  417366
  463137
  473825
  481644
  488924
  517811
  526437
  529848
  538264
  538474
  539432
  542537
  545149
  547225
  559342
  563276
  564403
  566937
  577175
  582026
  583567
  583662
  586954
  589650
  591897
  599619
  601791
  610138
  610993
  615995
  621548
  625210
  628631
  629276
  629544
  631144
  640148
  642280
  650596
  650649
  650681
  650687
  660032
  660687
  661580
  662874
  666114
  666120
  668553
  669250
  669283
  673668
  709715
  712082
  712252
  716977
  716979
  718369
  720165
  720168
  724583
  730970
  734708
  734800
  734814
  734978
  735781
  736198
  736204
  736224
  737261
  737272
  738125
  738145
  738463
  739071
  739717
  740698
  740721
  740755
  740757
  740758
  742101
  749516
  750514
  751667
  753226
  753733
  757516
  760338
  761365
  766263
  782015
  788429
  788550
  793142
  794752
  794807
  794964
  795469
  795837
  795896
  796787
  797087
  800445
  802402
  808097
  810012
  810928
  811151
  811285
  811418
  811911
  811927
  812050
  816670
  820096
  825333
  826883
]
2.13 ms
(1.23%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "desi домашн любительск"
]
1.87 ms
(1.08%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.87 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "desi homemade"
]
1.55 ms
(0.89%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "desi домашн любительск"
]

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.