GET https://search.jues.net/search/embeds/2?q=sex-couple

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
142.26 ms
(86.64%)
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
  3371
  3826
  73571
  73672
  73774
  74302
  74426
  238771
  358879
  389661
  395939
  455746
  478103
  481088
  496385
  516738
  530615
  547259
  550546
  559087
  567465
  567471
  572590
  590654
  591939
  592542
  607055
  626187
  635647
  638524
  641200
  656219
  670079
  670754
  680606
  687132
  689167
  690494
  690925
  692154
  693437
  694164
  699162
  704432
  704434
  705365
  706439
  712520
  712812
  714229
  714252
  714693
  719283
  720987
  722440
  725079
  725766
  730792
  730840
  731142
  732336
  732827
  739688
  744376
  745857
  745882
  745904
  748841
  748844
  749779
  757937
  758235
  759051
  760219
  760510
  762019
  766253
  766303
  768029
  768565
  768841
  773473
  777949
  778175
  786158
  790395
  790718
  791310
  791795
  792028
  793860
  794157
  794523
  796554
  798940
  804917
  810393
  810586
  811209
  812086
  812264
  813456
  818431
  818844
  819050
  819079
  819998
  820689
  820749
  823812
  824516
  824539
  824701
  825118
  825775
  825867
  826755
  827448
  827471
  828397
]
11.47 ms
(6.99%)
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
  455746
  592542
  812086
  656219
  559087
  481088
  725079
  824516
  828397
  798940
  739688
  238771
  824539
  826755
  478103
  547259
  670754
  766253
  811209
  687132
  778175
  792028
  760510
  827448
  572590
  796554
  496385
  689167
  714252
  793860
  730840
  773473
  768565
  825775
  607055
  722440
  74302
  395939
  358879
  73672
  825118
  516738
  670079
  680606
  730792
  758235
  719283
  73774
  820749
  626187
  635647
  777949
  748841
  819050
  705365
  794157
  810586
  73571
  389661
  567471
  712812
  714229
  714693
  567465
  591939
  790395
  810393
  745882
  768841
  641200
  820689
  693437
  590654
  762019
  732336
  813456
  818844
  824701
  530615
  692154
  3826
  819079
  818431
  712520
  690494
  786158
  791310
  766303
  3371
  819998
  827471
  550546
  690925
  699162
  694164
  704434
  706439
  704432
  638524
  790718
  804917
  812264
  760219
  794523
  732827
  749779
  745857
  748844
  759051
  768029
  725766
  731142
  757937
  744376
  745904
  791795
  74426
  825867
  823812
  720987
]
2.84 ms
(1.73%)
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
  3371
  3826
  73571
  73672
  73774
  74302
  74426
  238771
  358879
  389661
  395939
  455746
  478103
  481088
  496385
  516738
  530615
  547259
  550546
  559087
  567465
  567471
  572590
  590654
  591939
  592542
  607055
  626187
  635647
  638524
  641200
  656219
  670079
  670754
  680606
  687132
  689167
  690494
  690925
  692154
  693437
  694164
  699162
  704432
  704434
  705365
  706439
  712520
  712812
  714229
  714252
  714693
  719283
  720987
  722440
  725079
  725766
  730792
  730840
  731142
  732336
  732827
  739688
  744376
  745857
  745882
  745904
  748841
  748844
  749779
  757937
  758235
  759051
  760219
  760510
  762019
  766253
  766303
  768029
  768565
  768841
  773473
  777949
  778175
  786158
  790395
  790718
  791310
  791795
  792028
  793860
  794157
  794523
  796554
  798940
  804917
  810393
  810586
  811209
  812086
  812264
  813456
  818431
  818844
  819050
  819079
  819998
  820689
  820749
  823812
  824516
  824539
  824701
  825118
  825775
  825867
  826755
  827448
  827471
  828397
]
2.24 ms
(1.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sex-couple"
]
1.98 ms
(1.21%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс couple"
]
1.72 ms
(1.05%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.69 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс couple"
]

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.