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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
145.80 ms
(82.80%)
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
  193883
  385254
  385342
  396098
  399563
  409405
  447658
  464235
  471931
  498896
  507261
  507835
  533680
  547884
  556522
  561908
  563707
  566290
  567738
  572219
  574988
  576254
  577638
  598182
  607650
  609835
  610601
  619961
  626196
  626571
  630289
  634648
  634995
  644006
  649266
  652911
  653488
  656518
  664532
  665346
  688307
  690450
  693898
  702143
  702284
  703646
  711585
  711862
  712231
  712634
  716754
  717147
  720966
  722274
  722877
  723326
  729115
  729601
  729842
  731185
  731360
  734407
  734609
  734778
  735747
  738035
  741854
  742251
  742712
  745173
  745413
  745536
  747082
  754191
  754260
  757866
  758963
  760048
  761623
  765759
  765898
  768337
  768796
  768929
  778683
  778823
  781749
  782774
  783138
  783737
  785233
  786352
  787490
  787590
  787918
  788729
  789950
  790464
  791839
  793922
  794477
  795095
  795669
  795739
  795776
  796247
  796778
  797796
  799836
  800118
  800301
  800342
  804125
  813288
  813541
  815325
  818010
  819655
  824133
  828865
]
19.68 ms
(11.18%)
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
  619961
  634995
  598182
  799836
  783737
  745173
  760048
  787490
  787918
  795669
  745536
  768796
  734609
  745413
  729842
  735747
  761623
  702143
  717147
  782774
  783138
  385254
  556522
  800342
  396098
  828865
  574988
  665346
  409405
  567738
  788729
  742712
  498896
  507261
  572219
  652911
  547884
  791839
  758963
  747082
  716754
  471931
  626196
  787590
  796778
  781749
  813541
  729601
  757866
  702284
  819655
  464235
  656518
  688307
  711585
  634648
  795095
  813288
  794477
  734407
  795739
  800118
  800301
  734778
  765759
  768337
  815325
  818010
  561908
  566290
  664532
  711862
  712231
  609835
  626571
  741854
  754191
  793922
  797796
  729115
  765898
  738035
  742251
  768929
  607650
  703646
  723326
  778683
  795776
  804125
  507835
  720966
  722877
  563707
  576254
  796247
  789950
  399563
  385342
  193883
  533680
  690450
  653488
  649266
  610601
  778823
  824133
  447658
  577638
  722274
  693898
  712634
  630289
  644006
  785233
  786352
  790464
  731360
  754260
  731185
]
3.15 ms
(1.79%)
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
  193883
  385254
  385342
  396098
  399563
  409405
  447658
  464235
  471931
  498896
  507261
  507835
  533680
  547884
  556522
  561908
  563707
  566290
  567738
  572219
  574988
  576254
  577638
  598182
  607650
  609835
  610601
  619961
  626196
  626571
  630289
  634648
  634995
  644006
  649266
  652911
  653488
  656518
  664532
  665346
  688307
  690450
  693898
  702143
  702284
  703646
  711585
  711862
  712231
  712634
  716754
  717147
  720966
  722274
  722877
  723326
  729115
  729601
  729842
  731185
  731360
  734407
  734609
  734778
  735747
  738035
  741854
  742251
  742712
  745173
  745413
  745536
  747082
  754191
  754260
  757866
  758963
  760048
  761623
  765759
  765898
  768337
  768796
  768929
  778683
  778823
  781749
  782774
  783138
  783737
  785233
  786352
  787490
  787590
  787918
  788729
  789950
  790464
  791839
  793922
  794477
  795095
  795669
  795739
  795776
  796247
  796778
  797796
  799836
  800118
  800301
  800342
  804125
  813288
  813541
  815325
  818010
  819655
  824133
  828865
]
2.15 ms
(1.22%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.09 ms
(1.19%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "have sex"
]
1.71 ms
(0.97%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "have секс"
]
1.50 ms
(0.85%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "have секс"
]

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.