GET https://search.jues.net/search/embeds/2?q=anal-pantyhose

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
203.48 ms
(88.79%)
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
  6656
  7390
  55731
  316153
  386083
  389351
  389757
  390264
  390934
  397325
  397848
  402896
  404386
  410308
  422477
  423886
  429863
  432580
  439806
  439856
  442545
  447600
  451473
  452260
  455603
  456573
  457468
  458178
  470166
  470948
  470964
  480385
  480389
  482522
  485363
  490899
  490904
  493308
  515720
  515866
  517204
  529437
  532780
  536440
  544834
  552482
  553660
  555091
  557027
  564393
  564394
  568643
  574422
  584101
  586962
  588363
  592536
  598958
  603807
  604257
  604270
  617044
  618808
  618843
  620253
  674328
  677357
  695724
  727040
  728170
  728379
  729277
  731898
  737910
  740908
  741896
  742729
  742880
  746570
  750550
  755164
  757077
  757099
  758693
  759702
  765403
  765459
  765718
  766710
  768031
  773912
  777058
  778215
  781049
  782294
  784162
  785558
  787567
  788852
  792986
  795296
  795731
  796050
  796081
  797390
  799701
  800573
  800697
  801294
  801298
  803920
  807383
  811102
  811925
  812018
  814906
  816985
  818051
  828457
  828549
]
15.18 ms
(6.62%)
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
  617044
  755164
  402896
  493308
  695724
  800573
  742729
  795731
  728170
  757099
  6656
  564394
  604270
  618808
  536440
  482522
  553660
  564393
  765403
  727040
  458178
  485363
  515720
  750550
  757077
  800697
  731898
  759702
  480389
  584101
  788852
  386083
  432580
  470964
  592536
  741896
  389351
  740908
  604257
  765459
  620253
  457468
  811102
  456573
  814906
  737910
  742880
  768031
  389757
  598958
  777058
  828457
  390264
  568643
  422477
  452260
  410308
  828549
  439856
  7390
  555091
  447600
  557027
  423886
  429863
  55731
  439806
  470948
  778215
  397848
  442545
  674328
  618843
  480385
  532780
  807383
  785558
  490899
  677357
  544834
  784162
  766710
  782294
  574422
  517204
  603807
  811925
  781049
  801298
  796081
  803920
  455603
  470166
  451473
  490904
  796050
  792986
  552482
  529437
  588363
  746570
  758693
  816985
  797390
  729277
  390934
  818051
  787567
  765718
  404386
  799701
  801294
  812018
  795296
  728379
  773912
  397325
  586962
  316153
  515866
]
2.81 ms
(1.22%)
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
  6656
  7390
  55731
  316153
  386083
  389351
  389757
  390264
  390934
  397325
  397848
  402896
  404386
  410308
  422477
  423886
  429863
  432580
  439806
  439856
  442545
  447600
  451473
  452260
  455603
  456573
  457468
  458178
  470166
  470948
  470964
  480385
  480389
  482522
  485363
  490899
  490904
  493308
  515720
  515866
  517204
  529437
  532780
  536440
  544834
  552482
  553660
  555091
  557027
  564393
  564394
  568643
  574422
  584101
  586962
  588363
  592536
  598958
  603807
  604257
  604270
  617044
  618808
  618843
  620253
  674328
  677357
  695724
  727040
  728170
  728379
  729277
  731898
  737910
  740908
  741896
  742729
  742880
  746570
  750550
  755164
  757077
  757099
  758693
  759702
  765403
  765459
  765718
  766710
  768031
  773912
  777058
  778215
  781049
  782294
  784162
  785558
  787567
  788852
  792986
  795296
  795731
  796050
  796081
  797390
  799701
  800573
  800697
  801294
  801298
  803920
  807383
  811102
  811925
  812018
  814906
  816985
  818051
  828457
  828549
]
2.28 ms
(1.00%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal-pantyhose"
]
1.84 ms
(0.80%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.80 ms
(0.79%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал pantyhose"
]
1.78 ms
(0.78%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "анал pantyhose"
]

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.