GET https://search.jues.net/search/embeds/7?q=homemade%20asshole

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
192.36 ms
(86.20%)
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
  282264
  401628
  416537
  420849
  420877
  423364
  428582
  434709
  441353
  452822
  452847
  453209
  461707
  462791
  463326
  468326
  468426
  471532
  474913
  475335
  477537
  479215
  480498
  493749
  493754
  493763
  500948
  500965
  510549
  528052
  530936
  534587
  534600
  535427
  538266
  544200
  547583
  550919
  560931
  568093
  569150
  570934
  571117
  578630
  585345
  591736
  591805
  594002
  594340
  595573
  595683
  601014
  604293
  604366
  610526
  611024
  613004
  618670
  618997
  628522
  644798
  646876
  650024
  660367
  662162
  663181
  672307
  673833
  679500
  695900
  703582
  704178
  705466
  715050
  715106
  715368
  717366
  720411
  724734
  726974
  727743
  729287
  729337
  732067
  733220
  733265
  733700
  740879
  749676
  750213
  750301
  756693
  758790
  758799
  759961
  761048
  761203
  764151
  766099
  769071
  774688
  777631
  783069
  785580
  785610
  791840
  793013
  794355
  795686
  796297
  799947
  799987
  800489
  800565
  801640
  804568
  805513
  808463
  810036
  811445
]
19.50 ms
(8.74%)
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
  610526
  500948
  578630
  695900
  704178
  585345
  604293
  618670
  618997
  591736
  594002
  594340
  611024
  644798
  604366
  777631
  750213
  758790
  538266
  282264
  416537
  468426
  471532
  493749
  510549
  569150
  679500
  720411
  705466
  628522
  595573
  793013
  799987
  804568
  810036
  800489
  801640
  733265
  740879
  764151
  794355
  811445
  766099
  732067
  749676
  750301
  759961
  761203
  715050
  774688
  791840
  796297
  799947
  805513
  468326
  480498
  428582
  462791
  479215
  534600
  477537
  570934
  672307
  703582
  568093
  601014
  401628
  420849
  423364
  434709
  441353
  420877
  474913
  493763
  452822
  452847
  453209
  461707
  493754
  528052
  500965
  534587
  530936
  535427
  463326
  475335
  547583
  544200
  550919
  571117
  660367
  662162
  715368
  646876
  663181
  673833
  715106
  717366
  650024
  560931
  595683
  613004
  591805
  785580
  800565
  795686
  724734
  726974
  727743
  733700
  758799
  783069
  785610
  808463
  729337
  756693
  761048
  769071
  729287
  733220
]
3.64 ms
(1.63%)
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
  282264
  401628
  416537
  420849
  420877
  423364
  428582
  434709
  441353
  452822
  452847
  453209
  461707
  462791
  463326
  468326
  468426
  471532
  474913
  475335
  477537
  479215
  480498
  493749
  493754
  493763
  500948
  500965
  510549
  528052
  530936
  534587
  534600
  535427
  538266
  544200
  547583
  550919
  560931
  568093
  569150
  570934
  571117
  578630
  585345
  591736
  591805
  594002
  594340
  595573
  595683
  601014
  604293
  604366
  610526
  611024
  613004
  618670
  618997
  628522
  644798
  646876
  650024
  660367
  662162
  663181
  672307
  673833
  679500
  695900
  703582
  704178
  705466
  715050
  715106
  715368
  717366
  720411
  724734
  726974
  727743
  729287
  729337
  732067
  733220
  733265
  733700
  740879
  749676
  750213
  750301
  756693
  758790
  758799
  759961
  761048
  761203
  764151
  766099
  769071
  774688
  777631
  783069
  785580
  785610
  791840
  793013
  794355
  795686
  796297
  799947
  799987
  800489
  800565
  801640
  804568
  805513
  808463
  810036
  811445
]
2.02 ms
(0.90%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.99 ms
(0.89%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "homemade asshole"
]
1.90 ms
(0.85%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домашн любительск asshole"
]
1.73 ms
(0.78%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "домашн любительск asshole"
]

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.