GET https://search.jues.net/search/embeds/10?q=homemade%20old

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
217.96 ms
(90.22%)
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
  389044
  389730
  396300
  400375
  400484
  401820
  402859
  418654
  422421
  427449
  429216
  438276
  458628
  461973
  464293
  465387
  469898
  469912
  473314
  489155
  489156
  492665
  493934
  511109
  526035
  526265
  529820
  532416
  533464
  533708
  536217
  537767
  539352
  544879
  544910
  552491
  553775
  553776
  567622
  577900
  579204
  580466
  583274
  587091
  589931
  590478
  592648
  593932
  593999
  594108
  595470
  603471
  603787
  604000
  607086
  611056
  614820
  616855
  620967
  621359
  622518
  623346
  624099
  624487
  628824
  629116
  630002
  639960
  644707
  647547
  647762
  648670
  650731
  650765
  657246
  659064
  669652
  672706
  683724
  685892
  687913
  696107
  698488
  699420
  707506
  708389
  709065
  709179
  711249
  716396
  716675
  717191
  742809
  742873
  743952
  754778
  757891
  762248
  762739
  764044
  775279
  785003
  785492
  786713
  787616
  793075
  795120
  796102
  796418
  802820
  814419
  817048
  818054
  818186
  824090
  824250
  824568
  825789
  827842
  827919
]
12.58 ms
(5.21%)
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
  754778
  757891
  762248
  711249
  717191
  775279
  785492
  786713
  796102
  796418
  438276
  400375
  400484
  469912
  464293
  429216
  827842
  827919
  492665
  489156
  526035
  511109
  533464
  529820
  532416
  579204
  553776
  567622
  577900
  650731
  669652
  709065
  647762
  657246
  659064
  672706
  685892
  696107
  707506
  709179
  647547
  648670
  590478
  593932
  593999
  594108
  603787
  614820
  644707
  587091
  603471
  616855
  621359
  639960
  589931
  620967
  592648
  622518
  623346
  785003
  764044
  743952
  629116
  698488
  473314
  607086
  787616
  418654
  624099
  389044
  802820
  742809
  611056
  401820
  402859
  824090
  533708
  526265
  493934
  580466
  683724
  650765
  708389
  553775
  630002
  628824
  793075
  762739
  795120
  699420
  604000
  427449
  465387
  595470
  742873
  716396
  461973
  469898
  716675
  624487
  583274
  687913
  389730
  396300
  422421
  814419
  824250
  825789
  817048
  818054
  824568
  818186
  458628
  489155
  536217
  537767
  539352
  544879
  544910
  552491
]
3.42 ms
(1.41%)
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
  389044
  389730
  396300
  400375
  400484
  401820
  402859
  418654
  422421
  427449
  429216
  438276
  458628
  461973
  464293
  465387
  469898
  469912
  473314
  489155
  489156
  492665
  493934
  511109
  526035
  526265
  529820
  532416
  533464
  533708
  536217
  537767
  539352
  544879
  544910
  552491
  553775
  553776
  567622
  577900
  579204
  580466
  583274
  587091
  589931
  590478
  592648
  593932
  593999
  594108
  595470
  603471
  603787
  604000
  607086
  611056
  614820
  616855
  620967
  621359
  622518
  623346
  624099
  624487
  628824
  629116
  630002
  639960
  644707
  647547
  647762
  648670
  650731
  650765
  657246
  659064
  669652
  672706
  683724
  685892
  687913
  696107
  698488
  699420
  707506
  708389
  709065
  709179
  711249
  716396
  716675
  717191
  742809
  742873
  743952
  754778
  757891
  762248
  762739
  764044
  775279
  785003
  785492
  786713
  787616
  793075
  795120
  796102
  796418
  802820
  814419
  817048
  818054
  818186
  824090
  824250
  824568
  825789
  827842
  827919
]
2.04 ms
(0.84%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домашн любительск old"
]
2.03 ms
(0.84%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "homemade old"
]
1.83 ms
(0.76%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.74 ms
(0.72%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "домашн любительск old"
]

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.