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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
227.08 ms
(40.07%)
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
  739437
  740298
  749107
  758066
  707684
  716561
  778452
  785815
  809969
  817020
  557911
  682179
  719452
  690728
  720269
  660798
  718916
  557224
  614001
  590840
  777294
  781588
  787904
  790942
  802515
  811479
  776117
  789140
  789149
  796894
  811117
  734536
  739607
  746304
  760197
  784166
  799863
  800128
  804547
  813495
  748328
  757744
  731245
  741200
  761765
  707882
  709365
  775550
  795387
  800943
  809942
  812881
  644855
  827589
  813703
  560863
  541494
  700086
  706174
  713830
  716240
  650070
  678249
  696904
  707596
  714914
  685411
  687850
  689962
  701963
  707076
  710123
  712640
  608806
  609065
  599032
  639915
  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
  764180
  765686
  768203
  700382
  713670
  778029
  645913
  825519
  814170
  817819
  825005
  813977
  819664
  819873
  825196
]
210.86 ms
(37.21%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
119.59 ms
(21.10%)
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
  541494
  557224
  560863
  590840
  599032
  608806
  609065
  614001
  639915
  644855
  645913
  650070
  660798
  678249
  682179
  685411
  687850
  689962
  690728
  696904
  700086
  700382
  701963
  706174
  707076
  707596
  707684
  707882
  709365
  710123
  712640
  713670
  713830
  714914
  716240
  716561
  718916
  719452
  720269
  724837
  731245
  734536
  736502
  736642
  739437
  739607
  740298
  741200
  744073
  745241
  746304
  746882
  748328
  749107
  750519
  754268
  756316
  757666
  757744
  758066
  758506
  760197
  761765
  764180
  764193
  764240
  764383
  765686
  767680
  768203
  770714
  771079
  773661
  775550
  776117
  777294
  778029
  778417
  778452
  781412
  781588
  784166
  785815
  786205
  787904
  789140
  789149
  789411
  790942
  793396
  794448
  795387
  796894
  797064
  798869
  799863
  800128
  800642
  800943
  802515
  804547
  806240
  809942
  809969
  811117
  811479
  812881
  813495
  813703
  813977
  814170
  817020
  817819
  819664
  819873
  825005
  825196
  825519
  827589
]
3.22 ms
(0.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
  541494
  557224
  560863
  590840
  599032
  608806
  609065
  614001
  639915
  644855
  645913
  650070
  660798
  678249
  682179
  685411
  687850
  689962
  690728
  696904
  700086
  700382
  701963
  706174
  707076
  707596
  707684
  707882
  709365
  710123
  712640
  713670
  713830
  714914
  716240
  716561
  718916
  719452
  720269
  724837
  731245
  734536
  736502
  736642
  739437
  739607
  740298
  741200
  744073
  745241
  746304
  746882
  748328
  749107
  750519
  754268
  756316
  757666
  757744
  758066
  758506
  760197
  761765
  764180
  764193
  764240
  764383
  765686
  767680
  768203
  770714
  771079
  773661
  775550
  776117
  777294
  778029
  778417
  778452
  781412
  781588
  784166
  785815
  786205
  787904
  789140
  789149
  789411
  790942
  793396
  794448
  795387
  796894
  797064
  798869
  799863
  800128
  800642
  800943
  802515
  804547
  806240
  809942
  809969
  811117
  811479
  812881
  813495
  813703
  813977
  814170
  817020
  817819
  819664
  819873
  825005
  825196
  825519
  827589
]
2.13 ms
(0.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sex stepsister"
]
1.94 ms
(0.34%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс stepsister"
]
1.91 ms
(0.34%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.