GET https://search.jues.net/search/embeds/3?q=ffm%20stockings%20longtest

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
172.16 ms
(87.77%)
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
  10065
  44968
  114730
  187567
  191393
  260962
  381875
  382437
  386658
  390144
  396692
  396951
  397373
  400896
  402657
  403283
  408692
  410397
  415105
  415573
  421204
  435341
  442238
  464209
  475078
  514801
  519219
  524969
  548522
  572535
  581483
  582407
  583873
  587263
  587505
  590904
  598811
  606496
  606575
  607202
  611317
  624225
  644388
  649902
  663884
  665296
  666149
  670276
  670769
  675971
  675986
  676402
  676808
  687511
  690093
  697278
  697414
  699686
  699723
  703207
  704268
  710407
  711275
  712466
  715550
  721842
  722489
  722822
  722895
  723507
  724411
  724641
  726654
  727831
  732742
  732793
  737893
  742088
  745062
  746574
  746876
  748185
  748715
  760812
  761073
  770300
  770833
  770836
  770856
  770878
  770895
  771971
  775137
  775970
  782002
  789694
  794795
  797870
  798641
  800300
  801484
  802113
  802117
  804773
  805779
  809440
  809636
  810606
  813228
  814242
  814349
  814396
  814432
  815052
  815087
  815110
  815124
  816085
  820881
  826280
]
15.16 ms
(7.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
  801484
  260962
  415105
  403283
  670769
  587505
  809636
  582407
  800300
  802113
  770878
  770856
  675986
  710407
  606496
  590904
  746876
  770300
  794795
  815124
  649902
  666149
  611317
  187567
  583873
  675971
  676402
  44968
  724411
  748715
  624225
  396951
  415573
  814432
  644388
  742088
  770895
  390144
  699686
  724641
  587263
  816085
  699723
  746574
  697278
  704268
  607202
  722489
  606575
  732742
  397373
  381875
  826280
  727831
  732793
  810606
  581483
  524969
  722822
  408692
  519219
  690093
  572535
  814396
  814242
  775970
  805779
  761073
  514801
  410397
  814349
  802117
  760812
  789694
  771971
  726654
  421204
  687511
  782002
  813228
  798641
  745062
  435341
  442238
  676808
  748185
  464209
  809440
  386658
  548522
  804773
  475078
  114730
  820881
  598811
  737893
  715550
  402657
  396692
  721842
  711275
  775137
  382437
  400896
  191393
  815087
  815052
  815110
  723507
  665296
  670276
  722895
  797870
  770836
  770833
  703207
  10065
  712466
  663884
  697414
]
2.60 ms
(1.32%)
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
  10065
  44968
  114730
  187567
  191393
  260962
  381875
  382437
  386658
  390144
  396692
  396951
  397373
  400896
  402657
  403283
  408692
  410397
  415105
  415573
  421204
  435341
  442238
  464209
  475078
  514801
  519219
  524969
  548522
  572535
  581483
  582407
  583873
  587263
  587505
  590904
  598811
  606496
  606575
  607202
  611317
  624225
  644388
  649902
  663884
  665296
  666149
  670276
  670769
  675971
  675986
  676402
  676808
  687511
  690093
  697278
  697414
  699686
  699723
  703207
  704268
  710407
  711275
  712466
  715550
  721842
  722489
  722822
  722895
  723507
  724411
  724641
  726654
  727831
  732742
  732793
  737893
  742088
  745062
  746574
  746876
  748185
  748715
  760812
  761073
  770300
  770833
  770836
  770856
  770878
  770895
  771971
  775137
  775970
  782002
  789694
  794795
  797870
  798641
  800300
  801484
  802113
  802117
  804773
  805779
  809440
  809636
  810606
  813228
  814242
  814349
  814396
  814432
  815052
  815087
  815110
  815124
  816085
  820881
  826280
]
1.89 ms
(0.96%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(0.83%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "ffm stockings longtest"
]
1.47 ms
(0.75%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жмж секс втро чулк нижн бел longtest"
]
1.27 ms
(0.65%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "жмж секс втро чулк нижн бел longtest"
]

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.