GET https://search.jues.net/search/embeds/9?q=sex%20ass

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
177.87 ms
(86.61%)
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
  82091
  100665
  109043
  391704
  394162
  400728
  421574
  438552
  441610
  447171
  451146
  454479
  457857
  458233
  459137
  465172
  468744
  472650
  479183
  481626
  484827
  485723
  486053
  497635
  498832
  500043
  500696
  508208
  508871
  514073
  516714
  518963
  519468
  519971
  524340
  524621
  527045
  528426
  535007
  535628
  536377
  540891
  542264
  554626
  573183
  576139
  585799
  586095
  591736
  591800
  592857
  599640
  603239
  603302
  604293
  604660
  606338
  607062
  608905
  613021
  615983
  616849
  623423
  625937
  644641
  645255
  652602
  652701
  655458
  663964
  671205
  679661
  680443
  684145
  687838
  693496
  693897
  695562
  710887
  712795
  714014
  716720
  722273
  724304
  726248
  737164
  738480
  742622
  744665
  747090
  761608
  763547
  765317
  765465
  769071
  770401
  774690
  775231
  783430
  784396
  785201
  787719
  790499
  791916
  792638
  794290
  794867
  796052
  797191
  800275
  803706
  804754
  810107
  811010
  812929
  812993
  817238
  820625
  823154
]
16.74 ms
(8.15%)
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
  459137
  500696
  810107
  508871
  540891
  695562
  722273
  607062
  804754
  671205
  769071
  716720
  625937
  524621
  519971
  394162
  485723
  528426
  693897
  680443
  586095
  608905
  775231
  737164
  738480
  765317
  792638
  794290
  109043
  391704
  82091
  784396
  623423
  747090
  100665
  479183
  679661
  693496
  652701
  796052
  447171
  785201
  812929
  724304
  618229
  458233
  421574
  820625
  484827
  508208
  535628
  655458
  663964
  710887
  763547
  644641
  800275
  438552
  481626
  535007
  712795
  726248
  812993
  603302
  516714
  603239
  652602
  817238
  454479
  518963
  500043
  527045
  536377
  554626
  591800
  599640
  606338
  790499
  744665
  791916
  823154
  787719
  451146
  465172
  576139
  645255
  592857
  613021
  615983
  604660
  742622
  797191
  803706
  761608
  811010
  457857
  524340
  486053
  573183
  783430
  770401
  542264
  468744
  497635
  514073
  472650
  687838
  604293
  585799
  591736
  616849
  794867
  774690
  765465
  498832
  519468
  714014
  684145
  400728
  441610
]
3.22 ms
(1.57%)
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
  82091
  100665
  109043
  391704
  394162
  400728
  421574
  438552
  441610
  447171
  451146
  454479
  457857
  458233
  459137
  465172
  468744
  472650
  479183
  481626
  484827
  485723
  486053
  497635
  498832
  500043
  500696
  508208
  508871
  514073
  516714
  518963
  519468
  519971
  524340
  524621
  527045
  528426
  535007
  535628
  536377
  540891
  542264
  554626
  573183
  576139
  585799
  586095
  591736
  591800
  592857
  599640
  603239
  603302
  604293
  604660
  606338
  607062
  608905
  613021
  615983
  616849
  623423
  625937
  644641
  645255
  652602
  652701
  655458
  663964
  671205
  679661
  680443
  684145
  687838
  693496
  693897
  695562
  710887
  712795
  714014
  716720
  722273
  724304
  726248
  737164
  738480
  742622
  744665
  747090
  761608
  763547
  765317
  765465
  769071
  770401
  774690
  775231
  783430
  784396
  785201
  787719
  790499
  791916
  792638
  794290
  794867
  796052
  797191
  800275
  803706
  804754
  810107
  811010
  812929
  812993
  817238
  820625
  823154
]
2.19 ms
(1.07%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.01 ms
(0.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sex ass"
]
1.81 ms
(0.88%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс жоп"
]
1.54 ms
(0.75%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.