GET https://search.jues.net/search/embeds/4?q=extreme%20cum

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
132.19 ms
(82.38%)
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
  391147
  397906
  423424
  426197
  428257
  429799
  439514
  444851
  448354
  467882
  473413
  475404
  475984
  477097
  477812
  481602
  483553
  486767
  486831
  488551
  496484
  497675
  498391
  500929
  507661
  512934
  521256
  524859
  525744
  528055
  529425
  530484
  531118
  531136
  532743
  534993
  535005
  535038
  541099
  542583
  542595
  550124
  555106
  569213
  581938
  581949
  583085
  586294
  590367
  591680
  592661
  594338
  600274
  600356
  604080
  606143
  614597
  621482
  627362
  628396
  630524
  630550
  631249
  632978
  633451
  634787
  639027
  640800
  641975
  642006
  642032
  642037
  642038
  643098
  645276
  645284
  647914
  648846
  675002
  692718
  694953
  695815
  696582
  698879
  710805
  712667
  717845
  718629
  727739
  733594
  736643
  748406
  748609
  764654
  771171
  778531
  779781
  779859
  782301
  783812
  783831
  785500
  787414
  787467
  790317
  791795
  792173
  792408
  794090
  796155
  796218
  797461
  798307
  800565
  800576
  803466
  808426
  810388
  825764
]
17.16 ms
(10.69%)
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
  498391
  534993
  535005
  507661
  521256
  530484
  555106
  583085
  648846
  675002
  621482
  604080
  785500
  807580
  467882
  481602
  439514
  475404
  486831
  488551
  497675
  512934
  528055
  477097
  642006
  642037
  532743
  496484
  500929
  525744
  529425
  694953
  692718
  710805
  717845
  581938
  586294
  600274
  600356
  590367
  594338
  606143
  792173
  794090
  796155
  798307
  800565
  782301
  803466
  810388
  797461
  748609
  771171
  764654
  778531
  779859
  531118
  531136
  696582
  645276
  630524
  628396
  633451
  643098
  641975
  627362
  733594
  727739
  614597
  825764
  569213
  695815
  698879
  779781
  796218
  800576
  783831
  787414
  790317
  783812
  792408
  808426
  736643
  748406
  712667
  718629
  787467
  791795
  397906
  423424
  426197
  429799
  428257
  444851
  448354
  473413
  486767
  535038
  477812
  550124
  542583
  542595
  647914
  631249
  634787
  640800
  639027
  642038
  475984
  483553
  524859
  391147
  645284
  591680
  630550
  642032
  632978
  541099
  581949
  592661
]
3.36 ms
(2.09%)
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
  391147
  397906
  423424
  426197
  428257
  429799
  439514
  444851
  448354
  467882
  473413
  475404
  475984
  477097
  477812
  481602
  483553
  486767
  486831
  488551
  496484
  497675
  498391
  500929
  507661
  512934
  521256
  524859
  525744
  528055
  529425
  530484
  531118
  531136
  532743
  534993
  535005
  535038
  541099
  542583
  542595
  550124
  555106
  569213
  581938
  581949
  583085
  586294
  590367
  591680
  592661
  594338
  600274
  600356
  604080
  606143
  614597
  621482
  627362
  628396
  630524
  630550
  631249
  632978
  633451
  634787
  639027
  640800
  641975
  642006
  642032
  642037
  642038
  643098
  645276
  645284
  647914
  648846
  675002
  692718
  694953
  695815
  696582
  698879
  710805
  712667
  717845
  718629
  727739
  733594
  736643
  748406
  748609
  764654
  771171
  778531
  779781
  779859
  782301
  783812
  783831
  785500
  787414
  787467
  790317
  791795
  792173
  792408
  794090
  796155
  796218
  797461
  798307
  800565
  800576
  803466
  808426
  810388
  825764
]
2.04 ms
(1.27%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "хардкор cum"
]
1.95 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "хардкор cum"
]
1.90 ms
(1.18%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.87 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "extreme cum"
]

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.