GET https://search.jues.net/search/embeds/3?q=solo%20piss

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
167.55 ms
(83.48%)
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
  539328
  541741
  541750
  541784
  541788
  541790
  541795
  541798
  541803
  542454
  542717
  542718
  542720
  542728
  545940
  547408
  547416
  547441
  548891
  549034
  549037
  549040
  554682
  554683
  554707
  554733
  554828
  555315
  555780
  557965
  558631
  558893
  559423
  564281
  572262
  575253
  576484
  576506
  576559
  577010
  577026
  577028
  578718
  579675
  581557
  585057
  585802
  586127
  588858
  588939
  595491
  599242
  602215
  605262
  607714
  607906
  613161
  614201
  615533
  618144
  620911
  622115
  623343
  626402
  628592
  630963
  636624
  636644
  640046
  641604
  642103
  643656
  643706
  643737
  644663
  647726
  649442
  650742
  651784
  652799
  655531
  659472
  661591
  665071
  665975
  670263
  670404
  670450
  670465
  671977
  678003
  678761
  679280
  679630
  696098
  707971
  710224
  719435
  734827
  743993
  744010
  744551
  752667
  757230
  757257
  758797
  787858
  788112
  789678
  790102
  795990
  796338
  804304
  804403
  804408
  811873
  812312
  814157
  814160
  814172
]
20.21 ms
(10.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
  649442
  655531
  670450
  547441
  575253
  585802
  641604
  642103
  599242
  614201
  622115
  620911
  623343
  636644
  643706
  795990
  790102
  743993
  757230
  811873
  757257
  640046
  789678
  542728
  541741
  541803
  545940
  577010
  661591
  607714
  643656
  758797
  752667
  539328
  541750
  541790
  541798
  542720
  549037
  554707
  564281
  576506
  577026
  541788
  542454
  547416
  549034
  581557
  541795
  554683
  555315
  559423
  577028
  579675
  719435
  647726
  651784
  659472
  671977
  678003
  679280
  707971
  710224
  555780
  558631
  572262
  586127
  644663
  588858
  605262
  613161
  615533
  595491
  628592
  618144
  630963
  796338
  804403
  804408
  812312
  744010
  788112
  734827
  744551
  626402
  643737
  787858
  804304
  602215
  554733
  578718
  650742
  665975
  636624
  814160
  585057
  814157
  814172
  542717
  547408
  576484
  542718
  549040
  557965
  541784
  554828
  576559
  670404
  670465
  679630
  696098
  652799
  665071
  670263
  678761
  548891
  554682
  558893
  588939
  607906
]
4.44 ms
(2.21%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.64 ms
(1.32%)
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
  539328
  541741
  541750
  541784
  541788
  541790
  541795
  541798
  541803
  542454
  542717
  542718
  542720
  542728
  545940
  547408
  547416
  547441
  548891
  549034
  549037
  549040
  554682
  554683
  554707
  554733
  554828
  555315
  555780
  557965
  558631
  558893
  559423
  564281
  572262
  575253
  576484
  576506
  576559
  577010
  577026
  577028
  578718
  579675
  581557
  585057
  585802
  586127
  588858
  588939
  595491
  599242
  602215
  605262
  607714
  607906
  613161
  614201
  615533
  618144
  620911
  622115
  623343
  626402
  628592
  630963
  636624
  636644
  640046
  641604
  642103
  643656
  643706
  643737
  644663
  647726
  649442
  650742
  651784
  652799
  655531
  659472
  661591
  665071
  665975
  670263
  670404
  670450
  670465
  671977
  678003
  678761
  679280
  679630
  696098
  707971
  710224
  719435
  734827
  743993
  744010
  744551
  752667
  757230
  757257
  758797
  787858
  788112
  789678
  790102
  795990
  796338
  804304
  804403
  804408
  811873
  812312
  814157
  814160
  814172
]
2.35 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "solo piss"
]
1.85 ms
(0.92%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "соло писсинг"
]
1.66 ms
(0.83%)
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.