GET https://search.jues.net/search/embeds/6?q=creampie%20homemade

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
133.13 ms
(87.31%)
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
  401537
  459735
  514851
  523227
  529389
  533167
  533389
  535545
  536988
  537484
  539384
  547099
  550421
  550921
  552636
  565071
  579464
  579835
  584027
  585937
  591718
  591842
  593611
  593615
  600718
  608625
  633265
  633690
  636346
  636930
  645107
  648273
  653752
  655467
  656134
  656137
  656487
  656532
  656644
  663315
  666996
  670550
  674882
  676437
  680825
  680909
  689123
  689779
  689841
  692962
  695693
  696560
  698765
  700719
  703264
  703335
  706199
  707567
  709134
  710083
  713933
  715407
  716375
  716940
  718107
  718654
  718818
  719392
  720566
  723152
  725034
  737844
  746303
  753219
  759954
  760588
  761871
  761874
  766221
  767298
  767564
  775474
  776046
  777033
  781149
  784095
  786629
  786680
  787318
  789568
  791112
  791207
  791239
  791275
  791617
  791717
  792433
  792674
  792704
  792806
  795463
  796356
  797575
  797605
  797894
  797923
  800820
  801150
  802566
  802584
  803914
  810362
  810580
  810583
  810597
  813006
  813433
  824798
  825265
  825675
]
10.04 ms
(6.59%)
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
  825265
  824798
  825675
  459735
  514851
  716940
  718654
  720566
  723152
  781149
  791275
  795463
  796356
  797605
  810583
  776046
  791207
  791239
  791617
  792806
  797894
  797923
  801150
  746303
  767564
  784095
  786629
  791112
  791717
  792433
  792674
  797575
  800820
  802566
  803914
  810362
  813433
  725034
  737844
  761874
  759954
  761871
  767298
  753219
  760588
  766221
  775474
  786680
  787318
  789568
  792704
  802584
  810580
  810597
  813006
  715407
  680825
  777033
  401537
  523227
  533389
  529389
  535545
  533167
  536988
  537484
  539384
  550421
  584027
  550921
  565071
  579464
  579835
  645107
  653752
  656487
  666996
  689123
  689841
  706199
  713933
  716375
  718818
  719392
  648273
  655467
  656134
  656644
  674882
  680909
  689779
  692962
  695693
  703264
  703335
  707567
  710083
  656137
  656532
  663315
  670550
  676437
  696560
  698765
  700719
  709134
  718107
  547099
  552636
  585937
  591718
  591842
  633265
  633690
  636930
  593611
  593615
  600718
  608625
  636346
]
3.08 ms
(2.02%)
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
  401537
  459735
  514851
  523227
  529389
  533167
  533389
  535545
  536988
  537484
  539384
  547099
  550421
  550921
  552636
  565071
  579464
  579835
  584027
  585937
  591718
  591842
  593611
  593615
  600718
  608625
  633265
  633690
  636346
  636930
  645107
  648273
  653752
  655467
  656134
  656137
  656487
  656532
  656644
  663315
  666996
  670550
  674882
  676437
  680825
  680909
  689123
  689779
  689841
  692962
  695693
  696560
  698765
  700719
  703264
  703335
  706199
  707567
  709134
  710083
  713933
  715407
  716375
  716940
  718107
  718654
  718818
  719392
  720566
  723152
  725034
  737844
  746303
  753219
  759954
  760588
  761871
  761874
  766221
  767298
  767564
  775474
  776046
  777033
  781149
  784095
  786629
  786680
  787318
  789568
  791112
  791207
  791239
  791275
  791617
  791717
  792433
  792674
  792704
  792806
  795463
  796356
  797575
  797605
  797894
  797923
  800820
  801150
  802566
  802584
  803914
  810362
  810580
  810583
  810597
  813006
  813433
  824798
  825265
  825675
]
1.68 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "creampie homemade"
]
1.66 ms
(1.09%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.65 ms
(1.08%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "creampie домашн любительск"
]
1.24 ms
(0.81%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "creampie домашн любительск"
]

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.