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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
200.95 ms
(87.85%)
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
  23104
  24076
  24356
  24374
  50537
  185143
  190773
  191343
  312089
  335196
  385632
  391077
  391931
  394448
  396906
  397023
  401950
  404280
  408188
  440651
  446743
  460183
  469464
  472181
  473471
  473816
  481846
  491360
  493164
  495905
  496595
  509409
  512531
  514843
  517477
  518964
  521504
  536436
  537576
  541680
  543680
  544380
  563076
  569537
  574369
  582464
  582765
  592890
  596905
  604664
  604800
  605166
  607378
  618329
  620219
  633216
  634858
  636747
  639652
  642995
  653006
  701248
  702375
  709913
  712632
  712703
  714958
  715474
  716144
  718817
  721083
  725565
  726156
  727419
  734271
  741937
  744764
  746623
  752738
  753628
  755578
  757085
  765313
  769301
  781819
  785733
  789639
  791896
  792826
  793622
  793721
  798385
  801369
  801937
  804262
  805142
  805700
  806010
  806140
  806244
  806317
  806411
  807214
  808335
  809883
  810041
  811907
  811913
  814586
  814731
  817949
  818907
  819463
  821533
  823891
  824215
  824544
  826201
  826720
  828086
]
17.43 ms
(7.62%)
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
  397023
  385632
  446743
  563076
  391077
  493164
  536436
  521504
  312089
  826201
  821533
  823891
  537576
  544380
  712703
  792826
  744764
  726156
  472181
  495905
  514843
  818907
  819463
  824544
  721083
  709913
  604664
  607378
  801369
  801937
  807214
  394448
  481846
  517477
  582464
  574369
  592890
  634858
  806140
  725565
  633216
  460183
  404280
  496595
  391931
  24374
  24356
  50537
  396906
  408188
  824215
  826720
  814731
  817949
  814586
  469464
  491360
  509409
  518964
  512531
  582765
  541680
  569537
  543680
  712632
  718817
  653006
  714958
  716144
  605166
  618329
  620219
  604800
  636747
  639652
  642995
  596905
  806411
  808335
  811913
  793721
  804262
  806010
  806317
  765313
  785733
  793622
  798385
  805700
  809883
  811907
  734271
  741937
  752738
  753628
  769301
  755578
  757085
  701248
  702375
  715474
  791896
  805142
  806244
  810041
  335196
  401950
  440651
  473816
  24076
  191343
  473471
  828086
  781819
  727419
  746623
  789639
  185143
  190773
  23104
]
4.40 ms
(1.92%)
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
  23104
  24076
  24356
  24374
  50537
  185143
  190773
  191343
  312089
  335196
  385632
  391077
  391931
  394448
  396906
  397023
  401950
  404280
  408188
  440651
  446743
  460183
  469464
  472181
  473471
  473816
  481846
  491360
  493164
  495905
  496595
  509409
  512531
  514843
  517477
  518964
  521504
  536436
  537576
  541680
  543680
  544380
  563076
  569537
  574369
  582464
  582765
  592890
  596905
  604664
  604800
  605166
  607378
  618329
  620219
  633216
  634858
  636747
  639652
  642995
  653006
  701248
  702375
  709913
  712632
  712703
  714958
  715474
  716144
  718817
  721083
  725565
  726156
  727419
  734271
  741937
  744764
  746623
  752738
  753628
  755578
  757085
  765313
  769301
  781819
  785733
  789639
  791896
  792826
  793622
  793721
  798385
  801369
  801937
  804262
  805142
  805700
  806010
  806140
  806244
  806317
  806411
  807214
  808335
  809883
  810041
  811907
  811913
  814586
  814731
  817949
  818907
  819463
  821533
  823891
  824215
  824544
  826201
  826720
  828086
]
1.64 ms
(0.72%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "ван milf"
]
1.55 ms
(0.68%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "bathroom milf"
]
1.49 ms
(0.65%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.28 ms
(0.56%)
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.