GET https://search.jues.net/search/embeds/5?q=video%20ass

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
120.56 ms
(84.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
  4324
  144181
  362787
  387180
  401243
  402991
  415586
  423922
  434837
  444428
  451389
  452330
  470551
  471172
  475756
  480423
  507624
  514785
  532160
  532237
  535064
  539466
  540774
  546036
  548165
  550593
  551691
  551794
  553571
  554809
  566008
  567477
  567947
  572181
  576899
  585475
  592984
  596732
  601021
  605215
  605292
  611530
  617143
  617509
  620614
  626688
  629313
  629387
  631830
  635514
  636582
  639222
  646877
  651227
  652904
  656233
  656608
  662134
  663540
  666046
  670712
  676713
  677109
  683270
  691518
  692319
  693381
  694465
  694492
  695247
  696134
  698354
  698476
  700275
  702192
  702557
  706555
  707214
  707509
  714592
  714737
  716101
  721610
  722991
  723914
  729357
  733713
  735678
  740893
  742350
  744610
  749645
  751469
  753950
  755038
  757484
  762059
  765099
  765355
  765650
  770390
  770400
  775668
  779659
  787870
  789475
  793600
  793835
  803758
  803915
  804932
  806170
  807309
  808153
  809803
  809912
  810573
  811256
  811751
  818191
]
11.52 ms
(8.11%)
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
  540774
  532160
  532237
  535064
  539466
  576899
  551691
  546036
  677109
  683270
  691518
  692319
  695247
  700275
  707509
  651227
  656608
  670712
  676713
  693381
  694492
  696134
  702192
  702557
  706555
  714592
  666046
  698354
  716101
  548165
  554809
  585475
  617143
  629313
  631830
  635514
  636582
  592984
  601021
  596732
  617509
  620614
  626688
  775668
  787870
  803758
  804932
  807309
  809803
  811256
  779659
  789475
  793600
  729357
  740893
  757484
  810573
  762059
  765099
  765355
  765650
  733713
  753950
  755038
  749645
  770400
  721610
  722991
  803915
  806170
  808153
  809912
  514785
  401243
  475756
  550593
  646877
  663540
  572181
  639222
  611530
  605215
  629387
  735678
  742350
  714737
  470551
  444428
  723914
  770390
  4324
  551794
  694465
  707214
  652904
  553571
  567477
  744610
  698476
  423922
  387180
  402991
  434837
  452330
  451389
  567947
  656233
  662134
  793835
  144181
  362787
  415586
  818191
  480423
  471172
  507624
  566008
  605292
  811751
  751469
]
3.38 ms
(2.38%)
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
  4324
  144181
  362787
  387180
  401243
  402991
  415586
  423922
  434837
  444428
  451389
  452330
  470551
  471172
  475756
  480423
  507624
  514785
  532160
  532237
  535064
  539466
  540774
  546036
  548165
  550593
  551691
  551794
  553571
  554809
  566008
  567477
  567947
  572181
  576899
  585475
  592984
  596732
  601021
  605215
  605292
  611530
  617143
  617509
  620614
  626688
  629313
  629387
  631830
  635514
  636582
  639222
  646877
  651227
  652904
  656233
  656608
  662134
  663540
  666046
  670712
  676713
  677109
  683270
  691518
  692319
  693381
  694465
  694492
  695247
  696134
  698354
  698476
  700275
  702192
  702557
  706555
  707214
  707509
  714592
  714737
  716101
  721610
  722991
  723914
  729357
  733713
  735678
  740893
  742350
  744610
  749645
  751469
  753950
  755038
  757484
  762059
  765099
  765355
  765650
  770390
  770400
  775668
  779659
  787870
  789475
  793600
  793835
  803758
  803915
  804932
  806170
  807309
  808153
  809803
  809912
  810573
  811256
  811751
  818191
]
1.80 ms
(1.27%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.67 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "video ass"
]
1.66 ms
(1.17%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "video жоп"
]
1.49 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "video жоп"
]

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.