GET https://search.jues.net/search/embeds/10?q=milf%20mature%20riding

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
136.32 ms
(83.54%)
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
  479071
  490287
  495041
  508202
  514430
  517121
  519379
  523765
  523770
  524623
  525301
  526709
  527277
  530045
  530698
  530826
  531499
  531503
  533594
  534546
  534648
  536483
  537030
  537138
  540531
  542142
  542306
  545395
  545550
  546785
  547475
  547614
  555203
  555306
  555331
  555390
  555427
  555448
  555774
  556892
  564518
  566980
  567562
  568060
  573757
  574451
  574452
  577313
  577883
  579452
  580069
  582416
  583712
  586975
  587619
  588559
  589208
  589701
  591286
  592331
  593336
  600856
  601402
  602661
  605201
  612971
  613375
  614105
  614305
  614499
  618300
  620108
  622878
  624197
  629619
  635916
  648710
  660364
  660380
  660427
  662129
  664166
  664566
  665709
  666374
  670356
  671008
  672944
  690810
  692806
  695803
  696355
  699751
  708865
  710595
  718091
  718772
  726317
  729453
  732248
  733700
  741060
  745245
  749090
  761156
  767228
  774690
  777516
  784219
  785051
  789844
  791270
  793187
  793534
  796703
  800880
  802185
  804567
  808972
  810886
]
15.84 ms
(9.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
  508202
  525301
  530045
  495041
  519379
  523770
  533594
  534546
  536483
  517121
  526709
  527277
  530698
  530826
  540531
  514430
  523765
  524623
  531499
  531503
  534648
  537030
  537138
  479071
  490287
  547475
  568060
  573757
  583712
  545550
  555331
  555427
  564518
  577883
  582416
  542142
  542306
  545395
  555306
  555390
  556892
  566980
  567562
  577313
  579452
  648710
  660380
  662129
  666374
  672944
  695803
  699751
  718772
  660364
  660427
  664566
  665709
  670356
  671008
  690810
  692806
  696355
  708865
  664166
  710595
  718091
  546785
  547614
  555203
  555448
  555774
  574451
  574452
  580069
  600856
  602661
  612971
  614105
  622878
  586975
  587619
  588559
  589208
  589701
  593336
  601402
  614305
  620108
  624197
  591286
  592331
  605201
  614499
  629619
  635916
  613375
  618300
  796703
  800880
  804567
  808972
  774690
  777516
  785051
  791270
  793187
  802185
  810886
  726317
  729453
  733700
  741060
  745245
  749090
  767228
  784219
  789844
  793534
  732248
  761156
]
3.35 ms
(2.05%)
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
  479071
  490287
  495041
  508202
  514430
  517121
  519379
  523765
  523770
  524623
  525301
  526709
  527277
  530045
  530698
  530826
  531499
  531503
  533594
  534546
  534648
  536483
  537030
  537138
  540531
  542142
  542306
  545395
  545550
  546785
  547475
  547614
  555203
  555306
  555331
  555390
  555427
  555448
  555774
  556892
  564518
  566980
  567562
  568060
  573757
  574451
  574452
  577313
  577883
  579452
  580069
  582416
  583712
  586975
  587619
  588559
  589208
  589701
  591286
  592331
  593336
  600856
  601402
  602661
  605201
  612971
  613375
  614105
  614305
  614499
  618300
  620108
  622878
  624197
  629619
  635916
  648710
  660364
  660380
  660427
  662129
  664166
  664566
  665709
  666374
  670356
  671008
  672944
  690810
  692806
  695803
  696355
  699751
  708865
  710595
  718091
  718772
  726317
  729453
  732248
  733700
  741060
  745245
  749090
  761156
  767228
  774690
  777516
  784219
  785051
  789844
  791270
  793187
  793534
  796703
  800880
  802185
  804567
  808972
  810886
]
2.35 ms
(1.44%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "milf mature riding"
]
1.82 ms
(1.12%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "milf mature riding"
]
1.80 ms
(1.10%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.69 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "milf mature riding"
]

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.