GET https://search.jues.net/search/embeds/10?q=sex%20retro

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
145.24 ms
(85.66%)
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
  409113
  492442
  538824
  538868
  541597
  542494
  542992
  544190
  544864
  548271
  550189
  550589
  553278
  560091
  560369
  563157
  566366
  566797
  566830
  567740
  568000
  570571
  573792
  573855
  573952
  574281
  580990
  581359
  581376
  581401
  586826
  587451
  592535
  597018
  603225
  605332
  617650
  618862
  618864
  620125
  621682
  622823
  628115
  629276
  630836
  630883
  644274
  644275
  644381
  645254
  646929
  648672
  648963
  649148
  649615
  651597
  651889
  652988
  654092
  667938
  668154
  668604
  670090
  670109
  671710
  671891
  672118
  673560
  674127
  681703
  685288
  690827
  690860
  691485
  691991
  692224
  692250
  692258
  692473
  694135
  694225
  694524
  695191
  695278
  696273
  696553
  697258
  697359
  698526
  698548
  698589
  699581
  699695
  699735
  699744
  699745
  699753
  700660
  703037
  703046
  703059
  703088
  703095
  703097
  703098
  703514
  705934
  714615
  716590
  717607
  722197
  726657
  729100
  730301
  763887
  765787
  770130
  784600
  811940
  817278
]
14.11 ms
(8.32%)
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
  703098
  649615
  651889
  651597
  621682
  703046
  541597
  560369
  691485
  692258
  692473
  697258
  698548
  699695
  685288
  695191
  699753
  630883
  630836
  784600
  765787
  699735
  409113
  560091
  690827
  717607
  691991
  695278
  644274
  698589
  703059
  703514
  817278
  542494
  542992
  581359
  671710
  692250
  705934
  649148
  670109
  674127
  694524
  697359
  645254
  692224
  618862
  603225
  770130
  726657
  763887
  699745
  703037
  703095
  570571
  573792
  548271
  648672
  652988
  667938
  671891
  681703
  668154
  672118
  696273
  714615
  716590
  646929
  648963
  654092
  670090
  673560
  694225
  573855
  573952
  592535
  586826
  587451
  618864
  622823
  729100
  730301
  700660
  722197
  538868
  538824
  492442
  544864
  553278
  550189
  550589
  566366
  580990
  690860
  694135
  699581
  703088
  703097
  668604
  696553
  698526
  563157
  567740
  605332
  628115
  597018
  644381
  811940
  617650
  620125
  629276
  644275
  699744
  581401
  566830
  568000
  574281
  581376
  544190
  566797
]
3.10 ms
(1.83%)
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
  409113
  492442
  538824
  538868
  541597
  542494
  542992
  544190
  544864
  548271
  550189
  550589
  553278
  560091
  560369
  563157
  566366
  566797
  566830
  567740
  568000
  570571
  573792
  573855
  573952
  574281
  580990
  581359
  581376
  581401
  586826
  587451
  592535
  597018
  603225
  605332
  617650
  618862
  618864
  620125
  621682
  622823
  628115
  629276
  630836
  630883
  644274
  644275
  644381
  645254
  646929
  648672
  648963
  649148
  649615
  651597
  651889
  652988
  654092
  667938
  668154
  668604
  670090
  670109
  671710
  671891
  672118
  673560
  674127
  681703
  685288
  690827
  690860
  691485
  691991
  692224
  692250
  692258
  692473
  694135
  694225
  694524
  695191
  695278
  696273
  696553
  697258
  697359
  698526
  698548
  698589
  699581
  699695
  699735
  699744
  699745
  699753
  700660
  703037
  703046
  703059
  703088
  703095
  703097
  703098
  703514
  705934
  714615
  716590
  717607
  722197
  726657
  729100
  730301
  763887
  765787
  770130
  784600
  811940
  817278
]
2.00 ms
(1.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sex retro"
]
1.85 ms
(1.09%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.74 ms
(1.03%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс ретр"
]
1.50 ms
(0.89%)
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.