GET https://search.jues.net/search/embeds/7?q=finger%20fuck

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
150.76 ms
(86.24%)
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
  386627
  386771
  402905
  418774
  435583
  447771
  451247
  456664
  456911
  459163
  460084
  461571
  462475
  463986
  465727
  468479
  470731
  476054
  482411
  483051
  483561
  489101
  489818
  491583
  496746
  502318
  502793
  503577
  505665
  506130
  506664
  510224
  511387
  511636
  512220
  515275
  515330
  515878
  516701
  518081
  520534
  521633
  523175
  523196
  525904
  526009
  526152
  526253
  527616
  528223
  528430
  530050
  532595
  534119
  535372
  537091
  537848
  548537
  548692
  549105
  549367
  550761
  551778
  552697
  555578
  556345
  559601
  564198
  564218
  565110
  565770
  565896
  566344
  566651
  568481
  568569
  569163
  570185
  573400
  575009
  575196
  576514
  578132
  578493
  579987
  580746
  582390
  582799
  582872
  584021
  585964
  586588
  587801
  593651
  594293
  598370
  599519
  600762
  602602
  603302
  603931
  610006
  612962
  617012
  619612
  625227
  636409
  646205
  651668
  654521
  664312
  669276
  672372
  677147
  678738
  681027
  690828
  727639
  734842
  775183
]
14.85 ms
(8.50%)
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
  526009
  526152
  565770
  564198
  575009
  646205
  550761
  552697
  566344
  570185
  578132
  593651
  599519
  594293
  727639
  418774
  526253
  528430
  456664
  462475
  459163
  510224
  512220
  537848
  528223
  535372
  502318
  518081
  559601
  564218
  576514
  578493
  582390
  555578
  579987
  549105
  565896
  582872
  672372
  664312
  568569
  619612
  585964
  610006
  617012
  734842
  461571
  402905
  489818
  463986
  468479
  483561
  460084
  491583
  447771
  496746
  511387
  537091
  520534
  532595
  506664
  551778
  556345
  573400
  565110
  566651
  580746
  548537
  549367
  568481
  569163
  575196
  654521
  678738
  681027
  669276
  677147
  690828
  651668
  548692
  582799
  584021
  600762
  603931
  636409
  587801
  598370
  603302
  586588
  602602
  612962
  625227
  775183
  456911
  476054
  435583
  470731
  511636
  523175
  483051
  503577
  386627
  386771
  482411
  465727
  451247
  489101
  534119
  502793
  505665
  506130
  516701
  521633
  523196
  525904
  527616
  530050
  515275
  515330
  515878
]
2.75 ms
(1.57%)
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
  386627
  386771
  402905
  418774
  435583
  447771
  451247
  456664
  456911
  459163
  460084
  461571
  462475
  463986
  465727
  468479
  470731
  476054
  482411
  483051
  483561
  489101
  489818
  491583
  496746
  502318
  502793
  503577
  505665
  506130
  506664
  510224
  511387
  511636
  512220
  515275
  515330
  515878
  516701
  518081
  520534
  521633
  523175
  523196
  525904
  526009
  526152
  526253
  527616
  528223
  528430
  530050
  532595
  534119
  535372
  537091
  537848
  548537
  548692
  549105
  549367
  550761
  551778
  552697
  555578
  556345
  559601
  564198
  564218
  565110
  565770
  565896
  566344
  566651
  568481
  568569
  569163
  570185
  573400
  575009
  575196
  576514
  578132
  578493
  579987
  580746
  582390
  582799
  582872
  584021
  585964
  586588
  587801
  593651
  594293
  598370
  599519
  600762
  602602
  603302
  603931
  610006
  612962
  617012
  619612
  625227
  636409
  646205
  651668
  654521
  664312
  669276
  672372
  677147
  678738
  681027
  690828
  727639
  734842
  775183
]
1.77 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "finger fuck"
]
1.67 ms
(0.95%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "палец секс"
]
1.59 ms
(0.91%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.44 ms
(0.82%)
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.