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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
206.42 ms
(58.91%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "milf and teen"
]
119.41 ms
(34.08%)
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
  20617
  123000
  397263
  404462
  407732
  412227
  417339
  422415
  432416
  432537
  433366
  433395
  433866
  438047
  442336
  448635
  453219
  465723
  478483
  481678
  496540
  513323
  514237
  519202
  525457
  528921
  531008
  531909
  532705
  532806
  534361
  536141
  538721
  538781
  539157
  548218
  552298
  554504
  557547
  563834
  563870
  566561
  567008
  568651
  575041
  581632
  582735
  583731
  583992
  591110
  592310
  593809
  594170
  594177
  594499
  597514
  597682
  600142
  600468
  601154
  606408
  616464
  617537
  620908
  627863
  637110
  639825
  643777
  645003
  655132
  662900
  664094
  666728
  675539
  685618
  690315
  692174
  692528
  698289
  698302
  698959
  704560
  706319
  709623
  716129
  717877
  718884
  720190
  725129
  728035
  733041
  734326
  738835
  748368
  755164
  757035
  757085
  759602
  759874
  762526
  763054
  766610
  768018
  778387
  778867
  784307
  787491
  790878
  790958
  792733
  795303
  796196
  803294
  803378
  814237
  814711
  816607
  817705
  817711
  819743
]
14.58 ms
(4.16%)
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
  593809
  597682
  600142
  600468
  637110
  643777
  594499
  601154
  606408
  616464
  627863
  594170
  594177
  597514
  617537
  620908
  796196
  778867
  790958
  795303
  755164
  762526
  768018
  787491
  792733
  803294
  733041
  738835
  734326
  759602
  759874
  763054
  725129
  748368
  757035
  757085
  766610
  639825
  706319
  716129
  720190
  778387
  803378
  397263
  20617
  465723
  433366
  438047
  422415
  645003
  496540
  554504
  698302
  704560
  698289
  591110
  592310
  728035
  784307
  790878
  417339
  448635
  404462
  412227
  442336
  528921
  123000
  407732
  432416
  432537
  433866
  433395
  817711
  814237
  814711
  816607
  819743
  817705
  453219
  478483
  531909
  534361
  532806
  538721
  531008
  532705
  536141
  538781
  513323
  514237
  519202
  525457
  539157
  481678
  552298
  566561
  567008
  568651
  583731
  583992
  563834
  563870
  581632
  557547
  575041
  582735
  664094
  718884
  666728
  675539
  690315
  692528
  698959
  709623
  717877
  655132
  662900
  685618
  692174
  548218
]
3.03 ms
(0.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
  20617
  123000
  397263
  404462
  407732
  412227
  417339
  422415
  432416
  432537
  433366
  433395
  433866
  438047
  442336
  448635
  453219
  465723
  478483
  481678
  496540
  513323
  514237
  519202
  525457
  528921
  531008
  531909
  532705
  532806
  534361
  536141
  538721
  538781
  539157
  548218
  552298
  554504
  557547
  563834
  563870
  566561
  567008
  568651
  575041
  581632
  582735
  583731
  583992
  591110
  592310
  593809
  594170
  594177
  594499
  597514
  597682
  600142
  600468
  601154
  606408
  616464
  617537
  620908
  627863
  637110
  639825
  643777
  645003
  655132
  662900
  664094
  666728
  675539
  685618
  690315
  692174
  692528
  698289
  698302
  698959
  704560
  706319
  709623
  716129
  717877
  718884
  720190
  725129
  728035
  733041
  734326
  738835
  748368
  755164
  757035
  757085
  759602
  759874
  762526
  763054
  766610
  768018
  778387
  778867
  784307
  787491
  790878
  790958
  792733
  795303
  796196
  803294
  803378
  814237
  814711
  816607
  817705
  817711
  819743
]
2.56 ms
(0.73%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "milf teen"
]
2.32 ms
(0.66%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.10 ms
(0.60%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "milf teen"
]

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.