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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
119.82 ms
(83.68%)
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
  315815
  388685
  399426
  418389
  424917
  425079
  437330
  437996
  438212
  445551
  457642
  458248
  458723
  462481
  482247
  484300
  497117
  503075
  507890
  509967
  516427
  516444
  522653
  523473
  523494
  529134
  549495
  555971
  556268
  561948
  565195
  567185
  569164
  573391
  581191
  581237
  588134
  601940
  601947
  615265
  618738
  621356
  621447
  621721
  623299
  625088
  629667
  632418
  636118
  636977
  644049
  644115
  649268
  650062
  656830
  667014
  670319
  672820
  688279
  689514
  693256
  710858
  713362
  716929
  716980
  719813
  721575
  722084
  723742
  724739
  724820
  727331
  730524
  731280
  734350
  738780
  745872
  748939
  754060
  757180
  757519
  757587
  758397
  760436
  762174
  762304
  766484
  766494
  768244
  768340
  773552
  775312
  775646
  778054
  778074
  778639
  778758
  779255
  780015
  785946
  786883
  787821
  788550
  789755
  792277
  792328
  793775
  800643
  803308
  806217
  808042
  809964
  810559
  813098
  814499
  816152
  821827
  827271
  827881
  827910
]
13.56 ms
(9.47%)
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
  555971
  567185
  716980
  425079
  458723
  779255
  766494
  730524
  758397
  762174
  722084
  809964
  457642
  507890
  621356
  625088
  484300
  445551
  462481
  516444
  497117
  522653
  523494
  523473
  529134
  561948
  573391
  601940
  424917
  503075
  438212
  827271
  816152
  827910
  482247
  581191
  656830
  670319
  716929
  588134
  621447
  636118
  629667
  644049
  644115
  803308
  789755
  792328
  806217
  813098
  724739
  731280
  757519
  727331
  762304
  745872
  757587
  621721
  775312
  778074
  778639
  601947
  437996
  516427
  388685
  827881
  814499
  556268
  649268
  710858
  632418
  793775
  775646
  786883
  808042
  810559
  760436
  748939
  724820
  768244
  787821
  800643
  418389
  792277
  315815
  650062
  688279
  723742
  458248
  581237
  719813
  768340
  509967
  549495
  667014
  672820
  693256
  689514
  569164
  615265
  618738
  623299
  785946
  788550
  738780
  754060
  399426
  821827
  713362
  721575
  636977
  778054
  778758
  766484
  757180
  773552
  734350
  780015
  565195
  437330
]
2.68 ms
(1.87%)
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
  315815
  388685
  399426
  418389
  424917
  425079
  437330
  437996
  438212
  445551
  457642
  458248
  458723
  462481
  482247
  484300
  497117
  503075
  507890
  509967
  516427
  516444
  522653
  523473
  523494
  529134
  549495
  555971
  556268
  561948
  565195
  567185
  569164
  573391
  581191
  581237
  588134
  601940
  601947
  615265
  618738
  621356
  621447
  621721
  623299
  625088
  629667
  632418
  636118
  636977
  644049
  644115
  649268
  650062
  656830
  667014
  670319
  672820
  688279
  689514
  693256
  710858
  713362
  716929
  716980
  719813
  721575
  722084
  723742
  724739
  724820
  727331
  730524
  731280
  734350
  738780
  745872
  748939
  754060
  757180
  757519
  757587
  758397
  760436
  762174
  762304
  766484
  766494
  768244
  768340
  773552
  775312
  775646
  778054
  778074
  778639
  778758
  779255
  780015
  785946
  786883
  787821
  788550
  789755
  792277
  792328
  793775
  800643
  803308
  806217
  808042
  809964
  810559
  813098
  814499
  816152
  821827
  827271
  827881
  827910
]
1.96 ms
(1.37%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.90 ms
(1.33%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "step sex sister"
]
1.71 ms
(1.19%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "step секс sister"
]
1.55 ms
(1.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "step секс sister"
]

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.