GET https://search.jues.net/search/embeds/4?q=milf%20inside

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
159.07 ms
(84.97%)
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
  411236
  422262
  422282
  426374
  448427
  456505
  457859
  462064
  469625
  470400
  477067
  483576
  485382
  488475
  495444
  501322
  506468
  508210
  511199
  512060
  515984
  523281
  535515
  544613
  545294
  553433
  554960
  556075
  557098
  574328
  575950
  581181
  583534
  589314
  589660
  591913
  592061
  592066
  602177
  603404
  607396
  620012
  628625
  632735
  655132
  660090
  665770
  666068
  667914
  668276
  668713
  683330
  697194
  705152
  710091
  710814
  710837
  714564
  714848
  715485
  715935
  718042
  719923
  720193
  720624
  724486
  726081
  728623
  730163
  731009
  733577
  736360
  737883
  738852
  742251
  742560
  742824
  744082
  748642
  752732
  752760
  755132
  761137
  761302
  765791
  767630
  768388
  773463
  785035
  788302
  789455
  793223
  794173
  794717
  795301
  795372
  796002
  800293
  800953
  801368
  801920
  804526
  807304
  807915
  807964
  811232
  814672
  814727
  814922
  815444
  815810
  815839
  818009
  819346
  819410
  820023
  823956
  824598
  827491
  827842
]
15.83 ms
(8.45%)
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
  824598
  827491
  819346
  820023
  815444
  815810
  823956
  483576
  501322
  511199
  515984
  535515
  488475
  544613
  575950
  557098
  554960
  574328
  668713
  710091
  714564
  660090
  697194
  710837
  714848
  715935
  655132
  718042
  556075
  581181
  592066
  602177
  620012
  589314
  603404
  628625
  632735
  589660
  591913
  592061
  793223
  800953
  804526
  807964
  796002
  801920
  724486
  728623
  730163
  737883
  752732
  755132
  785035
  788302
  789455
  794717
  801368
  807304
  811232
  726081
  731009
  733577
  736360
  748642
  752760
  767630
  768388
  742560
  761302
  773463
  742824
  744082
  765791
  738852
  742251
  607396
  710814
  794173
  795301
  795372
  807915
  477067
  523281
  485382
  422282
  448427
  495444
  506468
  720624
  800293
  761137
  512060
  426374
  411236
  422262
  814922
  814727
  819410
  814672
  815839
  818009
  827842
  457859
  470400
  456505
  469625
  462064
  508210
  545294
  583534
  553433
  665770
  683330
  715485
  719923
  667914
  668276
  705152
  720193
  666068
]
4.48 ms
(2.40%)
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
  411236
  422262
  422282
  426374
  448427
  456505
  457859
  462064
  469625
  470400
  477067
  483576
  485382
  488475
  495444
  501322
  506468
  508210
  511199
  512060
  515984
  523281
  535515
  544613
  545294
  553433
  554960
  556075
  557098
  574328
  575950
  581181
  583534
  589314
  589660
  591913
  592061
  592066
  602177
  603404
  607396
  620012
  628625
  632735
  655132
  660090
  665770
  666068
  667914
  668276
  668713
  683330
  697194
  705152
  710091
  710814
  710837
  714564
  714848
  715485
  715935
  718042
  719923
  720193
  720624
  724486
  726081
  728623
  730163
  731009
  733577
  736360
  737883
  738852
  742251
  742560
  742824
  744082
  748642
  752732
  752760
  755132
  761137
  761302
  765791
  767630
  768388
  773463
  785035
  788302
  789455
  793223
  794173
  794717
  795301
  795372
  796002
  800293
  800953
  801368
  801920
  804526
  807304
  807915
  807964
  811232
  814672
  814727
  814922
  815444
  815810
  815839
  818009
  819346
  819410
  820023
  823956
  824598
  827491
  827842
]
2.05 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "milf inside"
]
2.04 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "milf inside"
]
2.00 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "milf inside"
]
1.75 ms
(0.93%)
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.