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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
209.00 ms
(58.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "milf ride"
]
119.52 ms
(33.68%)
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
  52454
  233446
  385245
  385596
  394012
  398364
  405488
  406765
  407187
  435503
  438028
  440943
  441570
  457036
  474248
  475282
  475699
  479123
  492304
  493443
  495234
  498210
  506697
  511378
  522474
  531457
  540808
  542493
  547142
  552370
  556761
  560369
  564287
  577458
  587299
  588652
  590765
  595131
  595255
  596389
  596884
  597917
  598095
  599786
  600238
  600912
  604909
  605060
  605892
  606933
  612482
  613690
  616879
  618553
  631728
  636141
  640302
  645365
  648810
  650598
  650935
  668794
  670208
  671725
  672147
  681508
  704558
  712116
  715485
  717064
  718130
  718822
  724188
  727548
  730297
  733387
  738468
  741186
  743010
  748653
  755203
  755843
  757274
  757483
  759490
  759739
  760598
  762437
  765725
  766696
  768387
  781785
  785094
  785188
  788128
  790165
  790889
  792419
  792608
  792618
  794439
  796326
  798822
  798829
  801513
  803877
  804000
  804005
  804394
  805291
  807861
  807876
  813206
  813688
  815345
  815446
  815823
  817571
  817834
  825611
]
17.66 ms
(4.98%)
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
  506697
  385245
  405488
  790889
  798829
  233446
  768387
  785094
  385596
  394012
  817834
  825611
  560369
  681508
  704558
  712116
  556761
  588652
  600912
  599786
  598095
  605060
  596884
  792419
  796326
  794439
  724188
  733387
  741186
  757274
  788128
  790165
  792608
  755843
  727548
  738468
  730297
  618553
  804000
  587299
  807876
  441570
  815446
  540808
  475282
  645365
  717064
  671725
  672147
  718130
  596389
  631728
  590765
  640302
  595131
  600238
  804005
  801513
  748653
  760598
  766696
  792618
  805291
  813206
  743010
  807861
  498210
  406765
  407187
  815823
  648810
  668794
  715485
  718822
  650598
  650935
  605892
  636141
  595255
  613690
  606933
  798822
  804394
  759490
  762437
  759739
  755203
  757483
  765725
  612482
  803877
  479123
  438028
  495234
  435503
  493443
  547142
  597917
  604909
  440943
  522474
  52454
  398364
  817571
  813688
  815345
  474248
  457036
  475699
  492304
  511378
  531457
  564287
  542493
  577458
  670208
  552370
  616879
  781785
  785188
]
3.33 ms
(0.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
  52454
  233446
  385245
  385596
  394012
  398364
  405488
  406765
  407187
  435503
  438028
  440943
  441570
  457036
  474248
  475282
  475699
  479123
  492304
  493443
  495234
  498210
  506697
  511378
  522474
  531457
  540808
  542493
  547142
  552370
  556761
  560369
  564287
  577458
  587299
  588652
  590765
  595131
  595255
  596389
  596884
  597917
  598095
  599786
  600238
  600912
  604909
  605060
  605892
  606933
  612482
  613690
  616879
  618553
  631728
  636141
  640302
  645365
  648810
  650598
  650935
  668794
  670208
  671725
  672147
  681508
  704558
  712116
  715485
  717064
  718130
  718822
  724188
  727548
  730297
  733387
  738468
  741186
  743010
  748653
  755203
  755843
  757274
  757483
  759490
  759739
  760598
  762437
  765725
  766696
  768387
  781785
  785094
  785188
  788128
  790165
  790889
  792419
  792608
  792618
  794439
  796326
  798822
  798829
  801513
  803877
  804000
  804005
  804394
  805291
  807861
  807876
  813206
  813688
  815345
  815446
  815823
  817571
  817834
  825611
]
1.98 ms
(0.56%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "milf ride"
]
1.70 ms
(0.48%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "milf ride"
]
1.64 ms
(0.46%)
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.