GET https://search.jues.net/search/embeds/4?q=caught%20big%20cock

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
119.46 ms
(81.94%)
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
  385605
  395559
  411730
  419078
  420261
  425828
  425839
  429815
  433781
  449605
  451165
  452716
  453854
  455809
  456022
  458855
  459245
  459313
  459574
  463188
  464928
  469596
  476946
  484159
  485909
  489389
  489678
  492147
  494281
  496293
  496310
  498872
  499710
  500770
  503171
  505953
  506818
  507208
  507897
  510728
  514590
  519511
  521796
  524404
  532042
  535101
  542185
  543451
  546690
  551942
  565014
  566924
  568411
  579823
  586341
  599672
  599695
  605408
  608398
  610114
  613190
  614419
  614980
  618760
  633535
  650880
  659401
  662213
  665220
  665503
  667546
  669507
  671373
  683599
  685106
  687942
  694006
  700707
  702819
  706993
  706997
  709503
  710571
  711320
  714565
  715258
  719443
  719707
  721598
  725092
  725461
  728839
  729180
  737037
  738001
  741523
  745603
  746497
  746645
  746878
  747544
  749412
  751215
  753748
  756289
  757104
  759316
  764122
  767060
  772970
  775249
  785103
  789471
  799619
  800084
  809937
  815522
  825884
]
16.54 ms
(11.34%)
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
  586341
  599672
  608398
  800084
  725092
  746645
  728839
  746878
  751215
  745603
  757104
  759316
  767060
  729180
  764122
  618760
  633535
  706993
  714565
  785103
  789471
  496310
  385605
  825884
  463188
  484159
  492147
  498872
  514590
  503171
  542185
  546690
  568411
  687942
  721598
  662213
  665503
  685106
  706997
  605408
  775249
  737037
  741523
  749412
  700707
  395559
  506818
  614980
  565014
  519511
  489389
  543451
  665220
  683599
  702819
  715258
  719707
  650880
  613190
  753748
  738001
  756289
  710571
  496293
  815522
  449605
  453854
  455809
  669507
  694006
  599695
  614419
  772970
  746497
  736904
  709503
  711320
  799619
  809937
  419078
  507897
  485909
  500770
  521796
  420261
  411730
  469596
  476946
  459245
  532042
  747544
  458855
  433781
  425828
  459574
  725461
  464928
  425839
  429815
  456022
  459313
  451165
  452716
  499710
  505953
  510728
  524404
  507208
  494281
  535101
  489678
  566924
  579823
  551942
  659401
  667546
  719443
  662145
  671373
  610114
]
2.60 ms
(1.78%)
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
  385605
  395559
  411730
  419078
  420261
  425828
  425839
  429815
  433781
  449605
  451165
  452716
  453854
  455809
  456022
  458855
  459245
  459313
  459574
  463188
  464928
  469596
  476946
  484159
  485909
  489389
  489678
  492147
  494281
  496293
  496310
  498872
  499710
  500770
  503171
  505953
  506818
  507208
  507897
  510728
  514590
  519511
  521796
  524404
  532042
  535101
  542185
  543451
  546690
  551942
  565014
  566924
  568411
  579823
  586341
  599672
  599695
  605408
  608398
  610114
  613190
  614419
  614980
  618760
  633535
  650880
  659401
  662213
  665220
  665503
  667546
  669507
  671373
  683599
  685106
  687942
  694006
  700707
  702819
  706993
  706997
  709503
  710571
  711320
  714565
  715258
  719443
  719707
  721598
  725092
  725461
  728839
  729180
  737037
  738001
  741523
  745603
  746497
  746645
  746878
  747544
  749412
  751215
  753748
  756289
  757104
  759316
  764122
  767060
  772970
  775249
  785103
  789471
  799619
  800084
  809937
  815522
  825884
]
2.01 ms
(1.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "caught big cock"
]
1.81 ms
(1.24%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.71 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "caught большие cock"
]
1.65 ms
(1.13%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "caught большие cock"
]

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.