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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
123.79 ms
(83.47%)
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
  30791
  88614
  248347
  392937
  394514
  415977
  416293
  438478
  438655
  440706
  450302
  455591
  458203
  458757
  465481
  465482
  466402
  467560
  468228
  471082
  472181
  478521
  495879
  499587
  502823
  513602
  517238
  520911
  525890
  529692
  531370
  535985
  540568
  541795
  546316
  546972
  547007
  547416
  547684
  549031
  554977
  555131
  555315
  555963
  556543
  557295
  558623
  560028
  563628
  565082
  570940
  571708
  574050
  575279
  576540
  576599
  578148
  584481
  586167
  586199
  587787
  593798
  595166
  596194
  596845
  596968
  601872
  607118
  613158
  620754
  629731
  633092
  633716
  640859
  649363
  662897
  664535
  678780
  699534
  700830
  700907
  707236
  710224
  710465
  710564
  714399
  715413
  718036
  733415
  738694
  740569
  752194
  759132
  761944
  766450
  778866
  781928
  784005
  791033
  794019
  797336
  801799
  801810
  804448
  804614
  811215
  812751
  813791
  813963
  819349
  819810
  823890
  823990
  824000
  824103
  824563
  824663
  827182
  827297
  827627
]
14.53 ms
(9.80%)
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
  781928
  784005
  791033
  804448
  478521
  517238
  472181
  30791
  557295
  794019
  811215
  797336
  801799
  450302
  804614
  620754
  394514
  438655
  416293
  415977
  438478
  468228
  471082
  455591
  465482
  495879
  546316
  570940
  571708
  574050
  546972
  554977
  555131
  664535
  578148
  586167
  596968
  629731
  586199
  607118
  778866
  759132
  812751
  733415
  640859
  440706
  458757
  248347
  465481
  466402
  502823
  392937
  88614
  824103
  824663
  827627
  813791
  823890
  824000
  458203
  513602
  560028
  565082
  547007
  547416
  547684
  549031
  563628
  541795
  555315
  576540
  576599
  700907
  714399
  700830
  707236
  710465
  715413
  718036
  649363
  678780
  710224
  556543
  558623
  593798
  596194
  595166
  587787
  613158
  601872
  752194
  761944
  740569
  766450
  738694
  633092
  633716
  801810
  499587
  584481
  662897
  555963
  575279
  596845
  467560
  529692
  699534
  710564
  525890
  520911
  813963
  823990
  819810
  827182
  827297
  819349
  824563
  535985
  531370
  540568
]
2.76 ms
(1.86%)
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
  30791
  88614
  248347
  392937
  394514
  415977
  416293
  438478
  438655
  440706
  450302
  455591
  458203
  458757
  465481
  465482
  466402
  467560
  468228
  471082
  472181
  478521
  495879
  499587
  502823
  513602
  517238
  520911
  525890
  529692
  531370
  535985
  540568
  541795
  546316
  546972
  547007
  547416
  547684
  549031
  554977
  555131
  555315
  555963
  556543
  557295
  558623
  560028
  563628
  565082
  570940
  571708
  574050
  575279
  576540
  576599
  578148
  584481
  586167
  586199
  587787
  593798
  595166
  596194
  596845
  596968
  601872
  607118
  613158
  620754
  629731
  633092
  633716
  640859
  649363
  662897
  664535
  678780
  699534
  700830
  700907
  707236
  710224
  710465
  710564
  714399
  715413
  718036
  733415
  738694
  740569
  752194
  759132
  761944
  766450
  778866
  781928
  784005
  791033
  794019
  797336
  801799
  801810
  804448
  804614
  811215
  812751
  813791
  813963
  819349
  819810
  823890
  823990
  824000
  824103
  824563
  824663
  827182
  827297
  827627
]
2.21 ms
(1.49%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "solo milf bathroom"
]
1.80 ms
(1.21%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "соло milf ван"
]
1.63 ms
(1.10%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.59 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "соло milf ван"
]

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.