GET https://search.jues.net/search/embeds/6?q=piss%20girl

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
204.42 ms
(54.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "piss girl"
]
149.22 ms
(39.57%)
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
  541784
  541787
  541788
  541790
  541793
  541798
  542447
  542454
  542717
  542718
  542720
  544244
  547408
  547411
  547416
  547441
  547515
  548301
  549037
  549040
  550201
  554682
  554683
  554686
  554707
  554724
  554828
  555226
  555315
  555780
  555967
  558893
  559423
  561046
  564281
  570159
  574342
  576484
  576559
  577026
  581557
  585057
  585802
  588858
  595699
  598267
  599934
  601513
  605067
  607906
  613161
  615533
  617570
  620911
  626402
  627833
  627835
  628368
  629646
  630963
  632565
  632697
  633768
  634382
  640037
  641667
  643013
  649556
  650700
  651147
  651784
  659009
  661654
  670263
  670404
  670465
  671054
  671792
  678761
  678820
  679630
  679810
  680126
  680185
  680189
  691337
  696098
  709444
  710224
  716161
  716600
  718782
  719435
  720446
  724731
  727045
  733381
  733840
  736558
  740835
  749801
  749924
  751357
  751606
  752859
  763741
  763852
  787916
  788112
  795990
  796338
  804304
  804403
  804408
  810892
  812312
  814157
  814172
  823943
  827941
]
14.26 ms
(3.78%)
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
  651147
  680126
  628368
  814172
  542717
  574342
  558893
  752859
  541798
  542720
  549037
  554707
  564281
  541788
  544244
  554683
  559423
  719435
  651784
  661654
  634382
  630963
  796338
  804403
  804408
  812312
  626402
  804304
  814157
  670404
  679630
  670263
  554724
  598267
  736558
  632565
  541793
  547515
  555226
  547411
  541787
  548301
  716600
  547441
  554686
  585802
  629646
  620911
  795990
  733381
  724731
  740835
  576484
  542718
  541784
  561046
  576559
  670465
  696098
  554682
  607906
  627835
  640037
  787916
  751357
  617570
  716161
  632697
  641667
  749924
  633768
  542447
  601513
  679810
  605067
  680185
  733840
  555967
  550201
  570159
  599934
  595699
  763741
  643013
  718782
  585057
  547408
  549040
  554828
  678820
  678761
  810892
  763852
  627833
  671792
  827941
  659009
  671054
  720446
  649556
  680189
  823943
  541790
  577026
  542454
  547416
  581557
  555315
  709444
  650700
  691337
  710224
  555780
  588858
  613161
  615533
  788112
  751606
  727045
  749801
]
3.41 ms
(0.91%)
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
  541784
  541787
  541788
  541790
  541793
  541798
  542447
  542454
  542717
  542718
  542720
  544244
  547408
  547411
  547416
  547441
  547515
  548301
  549037
  549040
  550201
  554682
  554683
  554686
  554707
  554724
  554828
  555226
  555315
  555780
  555967
  558893
  559423
  561046
  564281
  570159
  574342
  576484
  576559
  577026
  581557
  585057
  585802
  588858
  595699
  598267
  599934
  601513
  605067
  607906
  613161
  615533
  617570
  620911
  626402
  627833
  627835
  628368
  629646
  630963
  632565
  632697
  633768
  634382
  640037
  641667
  643013
  649556
  650700
  651147
  651784
  659009
  661654
  670263
  670404
  670465
  671054
  671792
  678761
  678820
  679630
  679810
  680126
  680185
  680189
  691337
  696098
  709444
  710224
  716161
  716600
  718782
  719435
  720446
  724731
  727045
  733381
  733840
  736558
  740835
  749801
  749924
  751357
  751606
  752859
  763741
  763852
  787916
  788112
  795990
  796338
  804304
  804403
  804408
  810892
  812312
  814157
  814172
  823943
  827941
]
2.05 ms
(0.54%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "писсинг девушк"
]
2.04 ms
(0.54%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.73 ms
(0.46%)
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.