GET https://search.jues.net/search/embeds/6?q=retro%20tits

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
142.77 ms
(83.57%)
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
  490025
  519246
  525749
  538870
  538891
  538948
  538952
  538960
  539516
  541369
  541597
  541764
  542489
  544325
  545345
  547912
  547980
  549938
  550149
  552060
  554541
  556777
  558715
  560084
  560091
  560920
  562779
  563445
  566622
  566624
  566892
  567395
  567729
  568265
  570571
  573392
  573787
  573792
  573855
  576645
  576667
  581350
  581353
  587735
  590914
  595386
  598427
  598597
  601166
  604985
  608344
  611030
  614327
  615926
  617800
  620159
  621322
  621698
  624474
  624792
  628297
  629955
  631255
  634692
  641747
  644261
  644688
  646942
  648211
  651163
  651888
  651889
  654130
  661899
  665651
  670393
  671927
  672754
  673497
  678432
  681085
  688248
  690833
  691518
  691991
  692013
  692319
  692349
  693039
  693869
  694206
  694207
  694455
  694528
  695941
  696240
  696322
  697258
  697262
  697774
  698590
  699581
  699744
  703085
  703088
  708790
  710540
  714504
  715097
  719062
  729245
  733118
  746837
  750064
  751748
  761483
  766671
  790393
  811940
  823358
]
16.62 ms
(9.73%)
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
  641747
  538960
  539516
  538891
  550149
  556777
  541369
  541597
  568265
  573787
  554541
  648211
  670393
  692349
  693039
  694455
  694528
  671927
  678432
  695941
  697258
  651163
  703085
  708790
  715097
  608344
  628297
  746837
  729245
  624792
  629955
  714504
  719062
  576645
  573392
  595386
  566622
  576667
  651888
  661899
  696322
  699581
  703088
  651889
  665651
  698590
  691991
  693869
  598427
  601166
  620159
  631255
  811940
  733118
  634692
  525749
  567729
  672754
  560920
  545345
  538952
  544325
  552060
  621322
  624474
  697262
  490025
  519246
  581350
  581353
  750064
  541764
  621698
  615926
  823358
  560091
  566892
  688248
  690833
  694206
  692013
  646942
  681085
  587735
  598597
  590914
  761483
  699744
  563445
  566624
  538948
  538870
  542489
  547980
  558715
  570571
  573792
  547912
  567395
  560084
  654130
  691518
  692319
  696240
  673497
  694207
  710540
  549938
  562779
  573855
  644688
  644261
  604985
  611030
  790393
  751748
  766671
  614327
  617800
  697774
]
4.29 ms
(2.51%)
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
  490025
  519246
  525749
  538870
  538891
  538948
  538952
  538960
  539516
  541369
  541597
  541764
  542489
  544325
  545345
  547912
  547980
  549938
  550149
  552060
  554541
  556777
  558715
  560084
  560091
  560920
  562779
  563445
  566622
  566624
  566892
  567395
  567729
  568265
  570571
  573392
  573787
  573792
  573855
  576645
  576667
  581350
  581353
  587735
  590914
  595386
  598427
  598597
  601166
  604985
  608344
  611030
  614327
  615926
  617800
  620159
  621322
  621698
  624474
  624792
  628297
  629955
  631255
  634692
  641747
  644261
  644688
  646942
  648211
  651163
  651888
  651889
  654130
  661899
  665651
  670393
  671927
  672754
  673497
  678432
  681085
  688248
  690833
  691518
  691991
  692013
  692319
  692349
  693039
  693869
  694206
  694207
  694455
  694528
  695941
  696240
  696322
  697258
  697262
  697774
  698590
  699581
  699744
  703085
  703088
  708790
  710540
  714504
  715097
  719062
  729245
  733118
  746837
  750064
  751748
  761483
  766671
  790393
  811940
  823358
]
2.07 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "retro tits"
]
1.80 ms
(1.05%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.71 ms
(1.00%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "ретр сиськ"
]
1.58 ms
(0.93%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.