GET https://search.jues.net/search/embeds/9?q=pissing%20wife

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
132.35 ms
(83.74%)
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
  382578
  403215
  426510
  427716
  441080
  441849
  456244
  458379
  460860
  462377
  464727
  497667
  509919
  514240
  535411
  538854
  539319
  541575
  542425
  542434
  542724
  545982
  546993
  547805
  547815
  548422
  550864
  553674
  554826
  554998
  555055
  555154
  555784
  562049
  567277
  567457
  567725
  568777
  570735
  571135
  574369
  578642
  578718
  579707
  580368
  581929
  582666
  584539
  584950
  588202
  588398
  590716
  592890
  595699
  597224
  597873
  598193
  598658
  599987
  600438
  600636
  601655
  606235
  606317
  607238
  610012
  612904
  613644
  614346
  615602
  615605
  618177
  618622
  619091
  619204
  620395
  623135
  628332
  628632
  629967
  630850
  637245
  637592
  639060
  641644
  641778
  647995
  650109
  659034
  672761
  673941
  677892
  681546
  683054
  685127
  687960
  692042
  696202
  704952
  707557
  716765
  718745
  718766
  718782
  725461
  729251
  749087
  751567
  752667
  758797
  763741
  775212
  786525
  790193
  795723
  811466
  812564
  825762
]
15.25 ms
(9.65%)
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
  677892
  685127
  692042
  704952
  673941
  681546
  562049
  574369
  592890
  600636
  613644
  615605
  619091
  630850
  610012
  615602
  614346
  619204
  588202
  597224
  606235
  790193
  812564
  751567
  795723
  725461
  758797
  752667
  607238
  403215
  427716
  382578
  441080
  441849
  590716
  672761
  547815
  729251
  553674
  775212
  542724
  426510
  825762
  568777
  584950
  555055
  582666
  542434
  547805
  548422
  555784
  578718
  696202
  716765
  718766
  659034
  554998
  578642
  588398
  600438
  628632
  606317
  620395
  637245
  598658
  786525
  623135
  509919
  535411
  595699
  687960
  641778
  460860
  458379
  471695
  542425
  554826
  567457
  541575
  567725
  550864
  581929
  718745
  647995
  612904
  597873
  598193
  749087
  763741
  718782
  462377
  456244
  497667
  464727
  580368
  579707
  545982
  567277
  683054
  650109
  555154
  571135
  618622
  811466
  570735
  514240
  546993
  601655
  641644
  637592
  629967
  538854
  707557
  539319
  599987
  639060
  584539
  628332
  618177
]
2.78 ms
(1.76%)
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
  382578
  403215
  426510
  427716
  441080
  441849
  456244
  458379
  460860
  462377
  464727
  497667
  509919
  514240
  535411
  538854
  539319
  541575
  542425
  542434
  542724
  545982
  546993
  547805
  547815
  548422
  550864
  553674
  554826
  554998
  555055
  555154
  555784
  562049
  567277
  567457
  567725
  568777
  570735
  571135
  574369
  578642
  578718
  579707
  580368
  581929
  582666
  584539
  584950
  588202
  588398
  590716
  592890
  595699
  597224
  597873
  598193
  598658
  599987
  600438
  600636
  601655
  606235
  606317
  607238
  610012
  612904
  613644
  614346
  615602
  615605
  618177
  618622
  619091
  619204
  620395
  623135
  628332
  628632
  629967
  630850
  637245
  637592
  639060
  641644
  641778
  647995
  650109
  659034
  672761
  673941
  677892
  681546
  683054
  685127
  687960
  692042
  696202
  704952
  707557
  716765
  718745
  718766
  718782
  725461
  729251
  749087
  751567
  752667
  758797
  763741
  775212
  786525
  790193
  795723
  811466
  812564
  825762
]
1.98 ms
(1.25%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.97 ms
(1.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pissing wife"
]
1.89 ms
(1.19%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "pissing жен"
]
1.82 ms
(1.15%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "pissing жен"
]

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.