GET https://search.jues.net/search/embeds/4?q=wife%20masturbate

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
124.63 ms
(82.25%)
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
  418024
  418158
  423812
  423814
  426121
  426127
  426894
  427144
  435560
  438447
  438646
  438957
  448752
  459622
  459721
  466379
  472672
  479585
  484277
  484923
  486840
  486928
  486933
  489797
  494175
  494176
  494193
  499568
  502823
  503487
  508986
  510166
  516548
  517878
  524562
  527271
  527821
  527828
  528390
  541478
  552371
  553746
  554545
  556756
  557873
  560681
  562464
  563592
  568809
  572190
  575988
  577105
  579381
  579448
  580355
  586298
  586689
  587504
  588767
  593289
  599377
  599679
  601174
  601555
  605706
  606912
  607118
  612715
  614600
  619678
  626383
  627344
  629108
  632090
  632177
  634951
  644178
  663281
  663544
  666496
  670853
  674474
  680570
  689862
  689864
  708585
  712423
  714188
  714534
  715483
  717116
  725527
  726506
  731165
  734008
  734144
  741217
  746124
  746125
  746512
  746719
  747226
  749038
  751354
  753051
  760178
  763931
  769567
  777006
  777733
  782096
  783211
  790459
  790710
  793116
  794251
  796096
  797341
  802083
  810395
]
16.97 ms
(11.20%)
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
  459721
  472672
  516548
  557873
  560681
  568809
  572190
  663281
  689864
  712423
  714534
  586298
  629108
  593289
  627344
  810395
  726506
  734008
  746125
  783211
  793116
  734144
  731165
  749038
  746512
  746719
  747226
  746124
  751354
  632177
  715483
  717116
  438646
  459622
  426894
  438957
  448752
  427144
  486933
  666496
  605706
  494193
  644178
  763931
  486840
  484923
  494176
  527271
  528390
  541478
  554545
  563592
  579381
  577105
  579448
  580355
  552371
  562464
  663544
  670853
  680570
  689862
  708585
  714188
  553746
  575988
  599377
  612715
  586689
  599679
  606912
  619678
  626383
  587504
  601555
  607118
  614600
  634951
  782096
  790459
  777006
  794251
  796096
  802083
  741217
  760178
  797341
  753051
  769567
  777733
  790710
  466379
  479585
  426121
  423812
  426127
  435560
  438447
  418024
  503487
  527828
  489797
  494175
  502823
  508986
  517878
  486928
  524562
  484277
  527821
  632090
  418158
  556756
  588767
  423814
  499568
  674474
  601174
  725527
  510166
]
2.34 ms
(1.55%)
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
  418024
  418158
  423812
  423814
  426121
  426127
  426894
  427144
  435560
  438447
  438646
  438957
  448752
  459622
  459721
  466379
  472672
  479585
  484277
  484923
  486840
  486928
  486933
  489797
  494175
  494176
  494193
  499568
  502823
  503487
  508986
  510166
  516548
  517878
  524562
  527271
  527821
  527828
  528390
  541478
  552371
  553746
  554545
  556756
  557873
  560681
  562464
  563592
  568809
  572190
  575988
  577105
  579381
  579448
  580355
  586298
  586689
  587504
  588767
  593289
  599377
  599679
  601174
  601555
  605706
  606912
  607118
  612715
  614600
  619678
  626383
  627344
  629108
  632090
  632177
  634951
  644178
  663281
  663544
  666496
  670853
  674474
  680570
  689862
  689864
  708585
  712423
  714188
  714534
  715483
  717116
  725527
  726506
  731165
  734008
  734144
  741217
  746124
  746125
  746512
  746719
  747226
  749038
  751354
  753051
  760178
  763931
  769567
  777006
  777733
  782096
  783211
  790459
  790710
  793116
  794251
  796096
  797341
  802083
  810395
]
2.09 ms
(1.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "wife masturbate"
]
2.00 ms
(1.32%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.75 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "жен masturbate"
]
1.74 ms
(1.15%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен masturbate"
]

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.