GET https://search.jues.net/search/embeds/5?q=cum%20amateur

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
155.19 ms
(85.78%)
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
  394579
  421144
  422129
  423431
  434517
  437946
  441815
  447815
  450448
  452694
  459368
  465287
  466458
  479608
  485255
  489260
  493034
  500500
  502103
  508374
  517908
  518173
  540245
  555661
  557922
  559616
  564336
  575539
  585905
  588868
  590604
  593810
  597187
  605675
  614832
  614847
  617061
  623972
  626074
  626839
  627362
  628630
  628702
  629665
  634614
  647359
  653952
  654230
  662062
  662894
  674826
  675410
  687376
  689970
  692710
  693848
  697400
  698245
  708208
  712526
  715012
  722124
  727739
  728167
  731148
  732605
  733594
  734140
  735446
  738325
  739080
  740954
  741760
  741832
  742290
  743422
  747406
  747677
  750711
  753672
  754113
  760940
  761325
  761889
  763955
  765365
  769339
  771324
  773789
  775292
  776138
  777103
  777166
  777482
  778619
  780965
  782738
  783271
  785841
  785924
  787556
  790869
  791250
  793500
  794680
  795015
  795811
  796202
  797668
  799174
  803316
  804081
  805733
  807223
  810788
  811146
  813100
  814675
  828519
]
15.60 ms
(8.62%)
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
  750711
  747677
  740954
  466458
  493034
  687376
  662894
  693848
  697400
  783271
  810788
  811146
  813100
  761889
  773789
  753672
  754113
  778619
  795811
  807223
  662062
  722124
  452694
  564336
  653952
  675410
  674826
  712526
  614847
  628702
  629665
  588868
  593810
  627362
  628630
  614832
  508374
  555661
  785924
  777103
  795015
  805733
  732605
  741832
  765365
  780965
  785841
  423431
  450448
  500500
  559616
  715012
  617061
  634614
  775292
  777166
  731148
  743422
  794680
  735446
  782738
  799174
  441815
  394579
  479608
  692710
  708208
  585905
  623972
  689970
  597187
  791250
  793500
  797668
  790869
  804081
  763955
  738325
  422129
  459368
  814675
  517908
  557922
  654230
  647359
  776138
  796202
  734140
  741760
  761325
  769339
  803316
  739080
  760940
  771324
  733594
  728167
  727739
  742290
  747406
  698245
  777482
  787556
  447815
  421144
  518173
  575539
  828519
  540245
  489260
  605675
  626839
  590604
  626074
  825734
  434517
  437946
  465287
  485255
  502103
]
2.88 ms
(1.59%)
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
  394579
  421144
  422129
  423431
  434517
  437946
  441815
  447815
  450448
  452694
  459368
  465287
  466458
  479608
  485255
  489260
  493034
  500500
  502103
  508374
  517908
  518173
  540245
  555661
  557922
  559616
  564336
  575539
  585905
  588868
  590604
  593810
  597187
  605675
  614832
  614847
  617061
  623972
  626074
  626839
  627362
  628630
  628702
  629665
  634614
  647359
  653952
  654230
  662062
  662894
  674826
  675410
  687376
  689970
  692710
  693848
  697400
  698245
  708208
  712526
  715012
  722124
  727739
  728167
  731148
  732605
  733594
  734140
  735446
  738325
  739080
  740954
  741760
  741832
  742290
  743422
  747406
  747677
  750711
  753672
  754113
  760940
  761325
  761889
  763955
  765365
  769339
  771324
  773789
  775292
  776138
  777103
  777166
  777482
  778619
  780965
  782738
  783271
  785841
  785924
  787556
  790869
  791250
  793500
  794680
  795015
  795811
  796202
  797668
  799174
  803316
  804081
  805733
  807223
  810788
  811146
  813100
  814675
  828519
]
2.05 ms
(1.13%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.02 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "cum amateur"
]
1.73 ms
(0.96%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "cum любительск"
]
1.43 ms
(0.79%)
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.