GET https://search.jues.net/search/embeds/6?q=big%20natural%20gape

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
127.39 ms
(83.83%)
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
  118316
  387661
  401880
  415503
  416025
  433202
  453341
  474749
  491403
  513578
  531217
  545733
  545856
  545985
  546102
  548957
  549679
  556530
  559344
  559363
  560523
  565306
  578770
  578786
  585340
  588320
  589824
  591759
  593098
  600915
  601566
  604908
  606222
  609047
  610037
  613750
  617792
  625964
  626948
  628591
  630460
  630614
  634743
  638477
  660052
  662844
  665500
  669274
  669905
  671070
  675539
  688938
  704097
  710379
  714411
  715523
  718641
  718882
  720815
  722005
  728466
  728616
  733433
  736038
  740070
  742640
  742896
  744985
  745146
  746425
  752550
  753199
  753777
  755960
  756618
  756880
  757234
  760077
  760707
  767190
  768793
  777634
  778864
  781825
  781850
  784839
  786614
  786723
  791304
  791529
  792123
  793023
  793053
  794206
  796330
  796527
  796560
  796808
  800004
  801755
  802266
  802906
  804252
  804449
  804836
  808161
  808169
  808236
  814449
  814981
  817119
  819751
  821554
  823589
  824621
  824857
  825340
  826531
  826599
  827496
]
13.56 ms
(8.92%)
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
  720815
  669274
  671070
  660052
  545985
  578770
  600915
  609047
  630460
  593098
  589824
  638477
  777634
  793053
  804252
  781825
  791304
  808169
  736038
  755960
  757234
  796527
  808161
  808236
  744985
  756618
  742640
  742896
  634743
  714411
  784839
  791529
  794206
  796330
  796560
  796808
  802906
  415503
  606222
  387661
  819751
  821554
  827496
  817119
  823589
  824621
  825340
  559344
  675539
  662844
  669905
  548957
  578786
  588320
  591759
  625964
  585340
  601566
  802266
  804836
  740070
  786723
  752550
  768793
  710379
  778864
  786614
  792123
  793023
  801755
  826599
  814449
  824857
  704097
  688938
  546102
  613750
  760077
  728466
  733433
  728616
  745146
  753777
  626948
  718641
  722005
  118316
  401880
  753199
  559363
  628591
  746425
  767190
  474749
  814981
  513578
  826531
  531217
  545733
  545856
  715523
  604908
  610037
  617792
  630614
  800004
  756880
  804449
  760707
  549679
  491403
  560523
  556530
  718882
  781850
  453341
  433202
  416025
  565306
  665500
]
2.90 ms
(1.91%)
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
  118316
  387661
  401880
  415503
  416025
  433202
  453341
  474749
  491403
  513578
  531217
  545733
  545856
  545985
  546102
  548957
  549679
  556530
  559344
  559363
  560523
  565306
  578770
  578786
  585340
  588320
  589824
  591759
  593098
  600915
  601566
  604908
  606222
  609047
  610037
  613750
  617792
  625964
  626948
  628591
  630460
  630614
  634743
  638477
  660052
  662844
  665500
  669274
  669905
  671070
  675539
  688938
  704097
  710379
  714411
  715523
  718641
  718882
  720815
  722005
  728466
  728616
  733433
  736038
  740070
  742640
  742896
  744985
  745146
  746425
  752550
  753199
  753777
  755960
  756618
  756880
  757234
  760077
  760707
  767190
  768793
  777634
  778864
  781825
  781850
  784839
  786614
  786723
  791304
  791529
  792123
  793023
  793053
  794206
  796330
  796527
  796560
  796808
  800004
  801755
  802266
  802906
  804252
  804449
  804836
  808161
  808169
  808236
  814449
  814981
  817119
  819751
  821554
  823589
  824621
  824857
  825340
  826531
  826599
  827496
]
2.44 ms
(1.60%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.16 ms
(1.42%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big natural gape"
]
1.76 ms
(1.16%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие натуральная натуральные большая большие дырк"
]
1.75 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.