GET https://search.jues.net/search/embeds/10?q=all%20girl

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
132.65 ms
(80.36%)
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
  314541
  388862
  393233
  415921
  416737
  418372
  418968
  425607
  430875
  431948
  434576
  435883
  437706
  437980
  453366
  455418
  457608
  462240
  466692
  467392
  469792
  484543
  486908
  487826
  490965
  499829
  500294
  501927
  504727
  510008
  510943
  517266
  520699
  525231
  532385
  534029
  540097
  540187
  544891
  546748
  548712
  548766
  550180
  559656
  561001
  567511
  569821
  571141
  571732
  573257
  574522
  587345
  594014
  595577
  598535
  604350
  608894
  623508
  624829
  631109
  641097
  643624
  648758
  653563
  656106
  660370
  662387
  665762
  674582
  676328
  677061
  684469
  684903
  686057
  688996
  692654
  694612
  695337
  696576
  706058
  711947
  712433
  713067
  714002
  715012
  715041
  718657
  718708
  720815
  722692
  741545
  743341
  747313
  747839
  752677
  753181
  754186
  755328
  765947
  770280
  775561
  775941
  776248
  777157
  788686
  791250
  795417
  797036
  803122
  806053
  806425
  807478
  808333
  809696
  814128
  814212
  823403
  825563
  827080
  827328
]
21.89 ms
(13.26%)
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
  753181
  755328
  765947
  430875
  437706
  425607
  823403
  457608
  466692
  534029
  532385
  571732
  676328
  711947
  648758
  684903
  686057
  559656
  571141
  574522
  643624
  623508
  775561
  791250
  807478
  754186
  809696
  435883
  453366
  467392
  418372
  415921
  814128
  469792
  544891
  548712
  718708
  653563
  692654
  706058
  587345
  594014
  595577
  604350
  775941
  795417
  797036
  806053
  770280
  803122
  393233
  314541
  416737
  814212
  827328
  825563
  525231
  540187
  499829
  540097
  490965
  548766
  561001
  712433
  665762
  722692
  718657
  546748
  608894
  641097
  598535
  624829
  631109
  788686
  776248
  808333
  743341
  806425
  747839
  752677
  747313
  741545
  777157
  434576
  462240
  486908
  487826
  501927
  520699
  388862
  431948
  437980
  418968
  827080
  484543
  455418
  510008
  504727
  517266
  510943
  500294
  550180
  573257
  567511
  660370
  688996
  720815
  662387
  677061
  684469
  695337
  696576
  714002
  656106
  674582
  694612
  713067
  715012
  715041
  569821
]
2.31 ms
(1.40%)
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
  314541
  388862
  393233
  415921
  416737
  418372
  418968
  425607
  430875
  431948
  434576
  435883
  437706
  437980
  453366
  455418
  457608
  462240
  466692
  467392
  469792
  484543
  486908
  487826
  490965
  499829
  500294
  501927
  504727
  510008
  510943
  517266
  520699
  525231
  532385
  534029
  540097
  540187
  544891
  546748
  548712
  548766
  550180
  559656
  561001
  567511
  569821
  571141
  571732
  573257
  574522
  587345
  594014
  595577
  598535
  604350
  608894
  623508
  624829
  631109
  641097
  643624
  648758
  653563
  656106
  660370
  662387
  665762
  674582
  676328
  677061
  684469
  684903
  686057
  688996
  692654
  694612
  695337
  696576
  706058
  711947
  712433
  713067
  714002
  715012
  715041
  718657
  718708
  720815
  722692
  741545
  743341
  747313
  747839
  752677
  753181
  754186
  755328
  765947
  770280
  775561
  775941
  776248
  777157
  788686
  791250
  795417
  797036
  803122
  806053
  806425
  807478
  808333
  809696
  814128
  814212
  823403
  825563
  827080
  827328
]
2.28 ms
(1.38%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.19 ms
(1.33%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "all girl"
]
1.92 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "all девушк"
]
1.82 ms
(1.10%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "all девушк"
]

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.