GET https://search.jues.net/search/embeds/7?q=stepsister%20sex

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
212.47 ms
(59.15%)
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
  426769
  541494
  547992
  557224
  560863
  564391
  590840
  599032
  608806
  612494
  630230
  644855
  678249
  678651
  682179
  684367
  685411
  687850
  690652
  690728
  696904
  701963
  706174
  707076
  707596
  707684
  707882
  709365
  710123
  712640
  713830
  714914
  716240
  716561
  719452
  720269
  724300
  724837
  727695
  728935
  731245
  734536
  736502
  736642
  739437
  739607
  740298
  741200
  744073
  745241
  746304
  746882
  748328
  749107
  750519
  754268
  756316
  757666
  757744
  758066
  758506
  760197
  761765
  761799
  764193
  764240
  764383
  767680
  770343
  770714
  771079
  773661
  775550
  777294
  778417
  778452
  779111
  779925
  781412
  781588
  782117
  783084
  784166
  785815
  786205
  787904
  787988
  788666
  789140
  789149
  789411
  790942
  791047
  791843
  793396
  794448
  795791
  796894
  797064
  797820
  798869
  799863
  800642
  800943
  802515
  802856
  804547
  806240
  809969
  811117
  811479
  812470
  812881
  813495
  813703
  817020
  817343
  819378
  819868
  827589
]
125.97 ms
(35.07%)
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
  426769
  541494
  547992
  557224
  560863
  564391
  590840
  599032
  608806
  612494
  630230
  644855
  678249
  678651
  682179
  684367
  685411
  687850
  690652
  690728
  696904
  701963
  706174
  707076
  707596
  707684
  707882
  709365
  710123
  712640
  713830
  714914
  716240
  716561
  719452
  720269
  724300
  724837
  727695
  728935
  731245
  734536
  736502
  736642
  739437
  739607
  740298
  741200
  744073
  745241
  746304
  746882
  748328
  749107
  750519
  754268
  756316
  757666
  757744
  758066
  758506
  760197
  761765
  761799
  764193
  764240
  764383
  767680
  770343
  770714
  771079
  773661
  775550
  777294
  778417
  778452
  779111
  779925
  781412
  781588
  782117
  783084
  784166
  785815
  786205
  787904
  787988
  788666
  789140
  789149
  789411
  790942
  791047
  791843
  793396
  794448
  795791
  796894
  797064
  797820
  798869
  799863
  800642
  800943
  802515
  802856
  804547
  806240
  809969
  811117
  811479
  812470
  812881
  813495
  813703
  817020
  817343
  819378
  819868
  827589
]
14.13 ms
(3.93%)
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
  770343
  817343
  547992
  564391
  690652
  678651
  684367
  612494
  630230
  779111
  788666
  779925
  791047
  795791
  802856
  782117
  787988
  797820
  812470
  728935
  724300
  727695
  739437
  740298
  749107
  758066
  707684
  716561
  778452
  785815
  809969
  817020
  819378
  819868
  682179
  719452
  690728
  720269
  557224
  590840
  777294
  781588
  787904
  790942
  802515
  811479
  789140
  789149
  796894
  811117
  734536
  739607
  746304
  760197
  761799
  783084
  784166
  799863
  804547
  813495
  748328
  757744
  731245
  741200
  761765
  707882
  709365
  775550
  791843
  800943
  812881
  426769
  644855
  827589
  813703
  560863
  541494
  706174
  713830
  716240
  678249
  696904
  707596
  714914
  685411
  687850
  701963
  707076
  710123
  712640
  608806
  599032
  778417
  786205
  794448
  797064
  800642
  806240
  744073
  745241
  754268
  770714
  781412
  789411
  793396
  798869
  724837
  757666
  773661
  736502
  758506
  764240
  764383
  767680
  771079
  736642
  746882
  764193
  750519
  756316
]
1.84 ms
(0.51%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "stepsister sex"
]
1.78 ms
(0.49%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.70 ms
(0.47%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "stepsister секс"
]
1.29 ms
(0.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "stepsister секс"
]

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.