GET https://search.jues.net/search/embeds/2?q=milf%20solo%20hot

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
167.59 ms
(85.87%)
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
  384400
  397869
  401970
  428710
  448907
  450583
  466031
  475280
  475419
  475727
  495204
  505771
  507631
  516057
  524476
  531758
  535318
  537048
  538152
  539557
  540556
  540563
  540691
  541793
  547520
  556040
  558623
  558726
  568133
  573169
  575897
  579706
  583178
  587241
  587787
  589626
  589894
  592872
  596513
  602320
  636493
  639221
  640375
  641346
  642201
  643287
  650051
  653348
  655295
  658468
  664175
  699232
  700042
  702864
  704100
  706761
  708626
  711777
  714461
  714707
  717541
  737889
  739964
  740552
  741243
  746425
  758318
  760685
  763870
  765179
  766441
  769382
  772552
  777789
  780309
  781310
  781862
  784672
  786368
  789473
  791332
  791863
  792237
  793194
  794019
  794968
  796190
  796391
  796514
  798826
  798829
  798870
  799037
  801799
  802288
  803767
  803826
  803841
  804345
  804394
  804399
  804440
  804614
  804644
  804648
  804652
  807861
  808306
  808951
  819153
  819157
  819160
  819181
  819222
  819232
  819256
  824104
  825767
  826142
  826508
]
16.64 ms
(8.53%)
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
  708626
  711777
  642201
  794968
  796391
  798870
  808306
  741243
  758318
  699232
  804440
  535318
  766441
  819232
  516057
  808951
  804399
  804644
  802288
  475280
  781862
  819256
  824104
  539557
  540691
  556040
  655295
  714707
  640375
  796514
  746425
  740552
  739964
  798826
  804648
  507631
  397869
  401970
  819181
  826142
  819222
  825767
  524476
  495204
  531758
  537048
  540563
  475727
  541793
  547520
  706761
  653348
  658468
  589626
  592872
  596513
  791863
  792237
  777789
  791332
  804345
  781310
  784672
  789473
  796190
  760685
  763870
  780309
  793194
  819157
  636493
  807861
  769382
  428710
  384400
  450583
  714461
  700042
  717541
  573169
  643287
  639221
  794019
  786368
  803841
  804652
  799037
  801799
  803767
  803826
  765179
  772552
  798829
  505771
  804394
  804614
  737889
  641346
  475419
  826508
  819153
  819160
  466031
  448907
  540556
  538152
  575897
  583178
  558726
  568133
  579706
  702864
  704100
  650051
  664175
  558623
  587241
  602320
  587787
  589894
]
3.20 ms
(1.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
  384400
  397869
  401970
  428710
  448907
  450583
  466031
  475280
  475419
  475727
  495204
  505771
  507631
  516057
  524476
  531758
  535318
  537048
  538152
  539557
  540556
  540563
  540691
  541793
  547520
  556040
  558623
  558726
  568133
  573169
  575897
  579706
  583178
  587241
  587787
  589626
  589894
  592872
  596513
  602320
  636493
  639221
  640375
  641346
  642201
  643287
  650051
  653348
  655295
  658468
  664175
  699232
  700042
  702864
  704100
  706761
  708626
  711777
  714461
  714707
  717541
  737889
  739964
  740552
  741243
  746425
  758318
  760685
  763870
  765179
  766441
  769382
  772552
  777789
  780309
  781310
  781862
  784672
  786368
  789473
  791332
  791863
  792237
  793194
  794019
  794968
  796190
  796391
  796514
  798826
  798829
  798870
  799037
  801799
  802288
  803767
  803826
  803841
  804345
  804394
  804399
  804440
  804614
  804644
  804648
  804652
  807861
  808306
  808951
  819153
  819157
  819160
  819181
  819222
  819232
  819256
  824104
  825767
  826142
  826508
]
2.08 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "milf соло hot"
]
1.98 ms
(1.02%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.94 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "milf solo hot"
]
1.73 ms
(0.89%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "milf соло hot"
]

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.