GET https://search.jues.net/search/embeds/7?q=boy%20cum

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
155.04 ms
(82.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
  69704
  76122
  271638
  382154
  389482
  396303
  397299
  398177
  398625
  398742
  399899
  400465
  407283
  409685
  410848
  411635
  411702
  414962
  415831
  419185
  420154
  422498
  423637
  423736
  423748
  424830
  425459
  425745
  428403
  432228
  433049
  433433
  435744
  436490
  437013
  437152
  438413
  441654
  442879
  444791
  447050
  447183
  447692
  448468
  448657
  450413
  451878
  453145
  455657
  455900
  457012
  457886
  459080
  460380
  461162
  462216
  463236
  463352
  463592
  465267
  465905
  466275
  469500
  475061
  475469
  479487
  484279
  485720
  486860
  488807
  492974
  494095
  494163
  496230
  496495
  501352
  508167
  508371
  521194
  542082
  542104
  544509
  549155
  552366
  555089
  556012
  556888
  557405
  558828
  559258
  560045
  560627
  561332
  561358
  561912
  563398
  563670
  564076
  565086
  566584
  567733
  571254
  571713
  573330
  575177
  575503
  576342
  577413
  585123
  590493
  596763
  720624
  743494
  777192
  779578
  783197
  786127
  786455
  796212
  804726
]
20.96 ms
(11.20%)
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
  777192
  779578
  783197
  786127
  796212
  804726
  462216
  398625
  398742
  399899
  423637
  425459
  463236
  69704
  76122
  414962
  433433
  590493
  542082
  486860
  382154
  585123
  466275
  521194
  271638
  389482
  396303
  397299
  398177
  400465
  409685
  415831
  424830
  425745
  433049
  420154
  432228
  419185
  423748
  438413
  441654
  410848
  411702
  435744
  437013
  411635
  422498
  423736
  428403
  436490
  437152
  442879
  444791
  447692
  450413
  453145
  455900
  459080
  469500
  475469
  485720
  448468
  451878
  457012
  460380
  463592
  465267
  465905
  479487
  484279
  488807
  447050
  447183
  448657
  455657
  457886
  492974
  496495
  508167
  494095
  508371
  494163
  501352
  496230
  461162
  463352
  475061
  542104
  544509
  552366
  556888
  560045
  560627
  571254
  571713
  575503
  555089
  563398
  564076
  561332
  561912
  565086
  575177
  576342
  720624
  549155
  556012
  557405
  558828
  559258
  561358
  563670
  566584
  567733
  573330
  577413
  596763
  743494
  786455
  407283
]
3.47 ms
(1.86%)
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
  69704
  76122
  271638
  382154
  389482
  396303
  397299
  398177
  398625
  398742
  399899
  400465
  407283
  409685
  410848
  411635
  411702
  414962
  415831
  419185
  420154
  422498
  423637
  423736
  423748
  424830
  425459
  425745
  428403
  432228
  433049
  433433
  435744
  436490
  437013
  437152
  438413
  441654
  442879
  444791
  447050
  447183
  447692
  448468
  448657
  450413
  451878
  453145
  455657
  455900
  457012
  457886
  459080
  460380
  461162
  462216
  463236
  463352
  463592
  465267
  465905
  466275
  469500
  475061
  475469
  479487
  484279
  485720
  486860
  488807
  492974
  494095
  494163
  496230
  496495
  501352
  508167
  508371
  521194
  542082
  542104
  544509
  549155
  552366
  555089
  556012
  556888
  557405
  558828
  559258
  560045
  560627
  561332
  561358
  561912
  563398
  563670
  564076
  565086
  566584
  567733
  571254
  571713
  573330
  575177
  575503
  576342
  577413
  585123
  590493
  596763
  720624
  743494
  777192
  779578
  783197
  786127
  786455
  796212
  804726
]
2.13 ms
(1.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "boy cum"
]
1.92 ms
(1.03%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.91 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "парен cum"
]
1.67 ms
(0.89%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "парен cum"
]

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.