GET https://search.jues.net/search/embeds/7?q=pov%20step%20sister

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
124.82 ms
(80.16%)
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
  418591
  419361
  421043
  421357
  422028
  422044
  426779
  427327
  430324
  433140
  433888
  434951
  435064
  437658
  441447
  443482
  445890
  448074
  448213
  449398
  450339
  450418
  451380
  453434
  453732
  455660
  456072
  456811
  457319
  461603
  464152
  467657
  471761
  471780
  472147
  477890
  478818
  483216
  490370
  494815
  497935
  499757
  500268
  500420
  502453
  502598
  503216
  504772
  504906
  505081
  507771
  509384
  509818
  510256
  510832
  511544
  514357
  514624
  514829
  516128
  516786
  519510
  520310
  520395
  520587
  520828
  521797
  523492
  524094
  524187
  524199
  524535
  525142
  525259
  526467
  528201
  528766
  528842
  528918
  543133
  548870
  553648
  557236
  558863
  559566
  559696
  559757
  561162
  561338
  562637
  563553
  564701
  564801
  565138
  565399
  571333
  580135
  580217
  584716
  584752
  586734
  587397
  587853
  591637
  599326
  599725
  601053
  601886
  602603
  602984
  604038
  608111
  610808
  615429
  615765
  616905
  620644
  621454
  622668
  636154
]
21.92 ms
(14.08%)
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
  505081
  483216
  503216
  514624
  514829
  519510
  520395
  520587
  524199
  524094
  610808
  433140
  421043
  564801
  524187
  608111
  621454
  523492
  622668
  419361
  441447
  430324
  456811
  461603
  450418
  451380
  453732
  456072
  464152
  472147
  509384
  528842
  510256
  471761
  543133
  558863
  559566
  562637
  561338
  559757
  580217
  584716
  599725
  587397
  587853
  448074
  448213
  449398
  453434
  457319
  467657
  421357
  427327
  443482
  434951
  500420
  516128
  490370
  504906
  511544
  526467
  504772
  510832
  514357
  502598
  553648
  516786
  528201
  561162
  494815
  502453
  525142
  584752
  602603
  586734
  620644
  455660
  437658
  478818
  418591
  450339
  507771
  525259
  500268
  557236
  565399
  615429
  521797
  564701
  426779
  499757
  528918
  565138
  520828
  509818
  563553
  602984
  433888
  559696
  548870
  435064
  445890
  477890
  524535
  580135
  601053
  422028
  528766
  571333
  591637
  604038
  615765
  422044
  520310
  471780
  497935
  616905
  636154
  599326
  601886
]
2.61 ms
(1.68%)
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
  418591
  419361
  421043
  421357
  422028
  422044
  426779
  427327
  430324
  433140
  433888
  434951
  435064
  437658
  441447
  443482
  445890
  448074
  448213
  449398
  450339
  450418
  451380
  453434
  453732
  455660
  456072
  456811
  457319
  461603
  464152
  467657
  471761
  471780
  472147
  477890
  478818
  483216
  490370
  494815
  497935
  499757
  500268
  500420
  502453
  502598
  503216
  504772
  504906
  505081
  507771
  509384
  509818
  510256
  510832
  511544
  514357
  514624
  514829
  516128
  516786
  519510
  520310
  520395
  520587
  520828
  521797
  523492
  524094
  524187
  524199
  524535
  525142
  525259
  526467
  528201
  528766
  528842
  528918
  543133
  548870
  553648
  557236
  558863
  559566
  559696
  559757
  561162
  561338
  562637
  563553
  564701
  564801
  565138
  565399
  571333
  580135
  580217
  584716
  584752
  586734
  587397
  587853
  591637
  599326
  599725
  601053
  601886
  602603
  602984
  604038
  608111
  610808
  615429
  615765
  616905
  620644
  621454
  622668
  636154
]
1.83 ms
(1.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pov step sister"
]
1.69 ms
(1.09%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "пов step sister"
]
1.43 ms
(0.92%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "пов step sister"
]
1.41 ms
(0.91%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.