GET https://search.jues.net/search/embeds/3?q=rough%20homemade

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
206.33 ms
(55.49%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "rough homemade"
]
145.61 ms
(39.16%)
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
  423498
  444064
  452288
  455888
  460122
  462192
  487646
  510928
  514463
  525576
  542297
  542968
  554978
  563064
  578656
  578732
  588593
  593756
  604420
  609854
  620864
  624761
  627528
  646075
  651588
  654882
  655241
  665922
  676346
  686177
  690032
  692722
  696892
  700178
  700804
  703979
  705315
  713168
  717259
  719813
  720171
  721252
  726818
  728996
  737444
  738191
  738410
  739008
  739230
  740859
  741314
  741320
  741587
  742233
  743786
  744692
  745610
  748075
  750432
  750940
  751130
  753779
  757298
  758020
  759913
  759931
  762710
  762920
  763331
  764485
  764692
  767053
  767548
  767971
  771400
  771568
  771752
  771784
  772251
  775496
  777133
  777212
  777230
  777887
  778637
  778796
  779266
  779948
  780628
  782436
  783225
  783379
  783547
  784189
  789063
  789493
  792015
  792113
  792252
  793412
  794204
  794990
  795379
  796769
  797083
  797428
  799433
  799731
  801655
  802608
  804868
  807059
  808767
  813453
  813535
  817754
  817755
  820032
  823174
  825282
]
11.87 ms
(3.19%)
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
  777230
  778796
  782436
  792113
  797083
  737444
  740859
  748075
  771400
  767548
  745610
  728996
  739008
  741320
  753779
  771784
  690032
  823174
  452288
  510928
  514463
  563064
  692722
  780628
  783225
  793412
  802608
  738410
  764485
  799731
  807059
  751130
  741314
  741587
  762920
  763331
  792015
  792252
  794204
  795379
  804868
  627528
  700804
  654882
  487646
  542297
  542968
  651588
  665922
  676346
  700178
  703979
  705315
  713168
  646075
  655241
  686177
  578656
  578732
  593756
  620864
  624761
  779266
  813453
  738191
  696892
  783547
  462192
  423498
  820032
  588593
  794990
  759913
  604420
  455888
  460122
  750940
  817755
  825282
  817754
  525576
  554978
  717259
  721252
  719813
  775496
  777133
  778637
  813535
  777212
  779948
  789063
  797428
  801655
  742233
  750432
  759931
  783379
  784189
  789493
  796769
  799433
  744692
  767053
  771568
  726818
  739230
  743786
  757298
  762710
  772251
  758020
  767971
  771752
  720171
  777887
  808767
  444064
  764692
  609854
]
2.75 ms
(0.74%)
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
  423498
  444064
  452288
  455888
  460122
  462192
  487646
  510928
  514463
  525576
  542297
  542968
  554978
  563064
  578656
  578732
  588593
  593756
  604420
  609854
  620864
  624761
  627528
  646075
  651588
  654882
  655241
  665922
  676346
  686177
  690032
  692722
  696892
  700178
  700804
  703979
  705315
  713168
  717259
  719813
  720171
  721252
  726818
  728996
  737444
  738191
  738410
  739008
  739230
  740859
  741314
  741320
  741587
  742233
  743786
  744692
  745610
  748075
  750432
  750940
  751130
  753779
  757298
  758020
  759913
  759931
  762710
  762920
  763331
  764485
  764692
  767053
  767548
  767971
  771400
  771568
  771752
  771784
  772251
  775496
  777133
  777212
  777230
  777887
  778637
  778796
  779266
  779948
  780628
  782436
  783225
  783379
  783547
  784189
  789063
  789493
  792015
  792113
  792252
  793412
  794204
  794990
  795379
  796769
  797083
  797428
  799433
  799731
  801655
  802608
  804868
  807059
  808767
  813453
  813535
  817754
  817755
  820032
  823174
  825282
]
1.81 ms
(0.49%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "rough домашн любительск"
]
1.76 ms
(0.47%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "rough домашн любительск"
]
1.68 ms
(0.45%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]

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.