GET https://search.jues.net/search/embeds/7?q=hot%20solo%20ass

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
145.72 ms
(83.86%)
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
  384275
  410851
  415878
  419664
  426796
  428799
  443516
  447600
  448140
  448641
  448896
  449404
  450549
  454006
  454744
  454905
  456226
  458124
  458942
  459657
  461013
  466394
  466439
  466700
  468222
  468992
  469167
  469171
  469519
  482698
  484241
  484533
  488757
  489377
  498539
  507340
  511039
  512031
  513816
  513820
  515372
  516747
  524796
  525373
  526444
  526534
  537777
  539438
  541723
  542097
  547807
  550175
  550367
  552373
  552707
  553134
  554049
  554528
  559216
  559356
  562386
  564144
  567054
  568107
  568134
  575402
  577834
  577875
  579604
  580023
  580206
  580629
  582336
  583245
  589970
  594048
  596306
  596632
  596657
  601672
  604634
  604785
  604803
  607509
  607959
  611523
  615693
  617445
  618687
  621742
  625633
  626037
  629851
  642331
  646167
  661915
  664660
  669907
  708517
  709024
  735910
  738532
  741756
  750453
  752661
  752670
  757436
  760859
  763739
  774699
  777688
  785110
  800497
  804281
  807599
  809076
  810103
  812749
  813227
  825751
]
18.10 ms
(10.42%)
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
  468992
  542097
  559356
  575402
  601672
  604634
  807599
  804281
  448896
  458124
  469171
  513816
  604803
  507340
  580629
  552707
  580023
  580206
  596657
  466439
  513820
  498539
  618687
  760859
  468222
  469167
  456226
  410851
  415878
  825751
  482698
  454006
  454905
  469519
  484533
  450549
  466700
  459657
  526444
  539438
  537777
  559216
  567054
  568107
  562386
  579604
  577875
  646167
  669907
  664660
  708517
  661915
  550367
  582336
  596632
  611523
  617445
  626037
  607509
  629851
  642331
  607959
  777688
  785110
  809076
  810103
  774699
  741756
  812749
  738532
  735910
  750453
  757436
  763739
  615693
  621742
  813227
  419664
  426796
  428799
  458942
  461013
  466394
  525373
  526534
  484241
  524796
  515372
  512031
  550175
  554528
  564144
  568134
  583245
  552373
  554049
  709024
  553134
  577834
  594048
  596306
  604785
  589970
  625633
  800497
  752670
  448641
  384275
  454744
  516747
  488757
  541723
  489377
  752661
  443516
  447600
  448140
  449404
  511039
  547807
]
2.58 ms
(1.48%)
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
  384275
  410851
  415878
  419664
  426796
  428799
  443516
  447600
  448140
  448641
  448896
  449404
  450549
  454006
  454744
  454905
  456226
  458124
  458942
  459657
  461013
  466394
  466439
  466700
  468222
  468992
  469167
  469171
  469519
  482698
  484241
  484533
  488757
  489377
  498539
  507340
  511039
  512031
  513816
  513820
  515372
  516747
  524796
  525373
  526444
  526534
  537777
  539438
  541723
  542097
  547807
  550175
  550367
  552373
  552707
  553134
  554049
  554528
  559216
  559356
  562386
  564144
  567054
  568107
  568134
  575402
  577834
  577875
  579604
  580023
  580206
  580629
  582336
  583245
  589970
  594048
  596306
  596632
  596657
  601672
  604634
  604785
  604803
  607509
  607959
  611523
  615693
  617445
  618687
  621742
  625633
  626037
  629851
  642331
  646167
  661915
  664660
  669907
  708517
  709024
  735910
  738532
  741756
  750453
  752661
  752670
  757436
  760859
  763739
  774699
  777688
  785110
  800497
  804281
  807599
  809076
  810103
  812749
  813227
  825751
]
1.93 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hot solo ass"
]
1.87 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "hot соло жоп"
]
1.86 ms
(1.07%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.72 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "hot соло жоп"
]

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.