GET https://search.jues.net/search/embeds/5?q=small%20porn

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
363.50 ms
(93.36%)
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
  384325
  385478
  387522
  387846
  402034
  415524
  448623
  451566
  458753
  488715
  527486
  529017
  529020
  535320
  535637
  536740
  538197
  538209
  538218
  538240
  538370
  538376
  538455
  540918
  540925
  541132
  549323
  550813
  552637
  552952
  554415
  556521
  558958
  560766
  567408
  567765
  571623
  573065
  573127
  573587
  573603
  573630
  573647
  573720
  573873
  573952
  573960
  574481
  574512
  574580
  574813
  574882
  575087
  575104
  575165
  575464
  575493
  575505
  575522
  575748
  575784
  575792
  575799
  575803
  575811
  576046
  576047
  576079
  576345
  576358
  580101
  584813
  586654
  588222
  591684
  595161
  601597
  603004
  622403
  635902
  640737
  641737
  650104
  662033
  662047
  670373
  671760
  671816
  685892
  696228
  699919
  713676
  718197
  719383
  719456
  721209
  729345
  730946
  731816
  740758
  747371
  750571
  757094
  759668
  761626
  761655
  761888
  774022
  789283
  799349
  801232
  807519
  807967
  808255
  809121
  810665
  810985
  811527
  812288
  812335
]
16.17 ms
(4.15%)
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
  721209
  550813
  573952
  601597
  807519
  811527
  812335
  730946
  761888
  761626
  774022
  750571
  757094
  641737
  385478
  451566
  538240
  538209
  538370
  718197
  603004
  384325
  448623
  488715
  527486
  529017
  529020
  535320
  535637
  536740
  538455
  541132
  552952
  573720
  549323
  556521
  571623
  650104
  713676
  685892
  699919
  662033
  662047
  670373
  671760
  573647
  574813
  622403
  591684
  595161
  789283
  807967
  801232
  729345
  808255
  809121
  810985
  812288
  731816
  747371
  759668
  740758
  761655
  635902
  640737
  719383
  719456
  799349
  387846
  415524
  387522
  402034
  458753
  538218
  538197
  538376
  554415
  574882
  575464
  575505
  575522
  575799
  575811
  576046
  552637
  573603
  573960
  575165
  575803
  576358
  580101
  573127
  573587
  573630
  573873
  574512
  574580
  575104
  575748
  575784
  575792
  576047
  576345
  671816
  696228
  560766
  567408
  567765
  573065
  574481
  575493
  576079
  584813
  588222
  586654
  810665
  540918
  540925
  558958
  575087
]
2.73 ms
(0.70%)
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
  384325
  385478
  387522
  387846
  402034
  415524
  448623
  451566
  458753
  488715
  527486
  529017
  529020
  535320
  535637
  536740
  538197
  538209
  538218
  538240
  538370
  538376
  538455
  540918
  540925
  541132
  549323
  550813
  552637
  552952
  554415
  556521
  558958
  560766
  567408
  567765
  571623
  573065
  573127
  573587
  573603
  573630
  573647
  573720
  573873
  573952
  573960
  574481
  574512
  574580
  574813
  574882
  575087
  575104
  575165
  575464
  575493
  575505
  575522
  575748
  575784
  575792
  575799
  575803
  575811
  576046
  576047
  576079
  576345
  576358
  580101
  584813
  586654
  588222
  591684
  595161
  601597
  603004
  622403
  635902
  640737
  641737
  650104
  662033
  662047
  670373
  671760
  671816
  685892
  696228
  699919
  713676
  718197
  719383
  719456
  721209
  729345
  730946
  731816
  740758
  747371
  750571
  757094
  759668
  761626
  761655
  761888
  774022
  789283
  799349
  801232
  807519
  807967
  808255
  809121
  810665
  810985
  811527
  812288
  812335
]
2.01 ms
(0.52%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "small porn"
]
1.91 ms
(0.49%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "маленькая porn"
]
1.76 ms
(0.45%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.29 ms
(0.33%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "маленькая porn"
]

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.