GET https://search.jues.net/search/embeds/3?q=hard%20wife

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
121.17 ms
(83.46%)
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
  478902
  495407
  506133
  511799
  514145
  531889
  533714
  537484
  544625
  545900
  552532
  555669
  558170
  564301
  565239
  566465
  585214
  585467
  586205
  590182
  590193
  602431
  602876
  610726
  613715
  615414
  622537
  628101
  628143
  630797
  631520
  635605
  647797
  661473
  678817
  679234
  679512
  687051
  688393
  691662
  698820
  698879
  708085
  710678
  716986
  716995
  720039
  720566
  722351
  723973
  724031
  724650
  726964
  729293
  729907
  734795
  737946
  742986
  746949
  747041
  756677
  757300
  759029
  761682
  761961
  764103
  774884
  775283
  775644
  778203
  779781
  779859
  787392
  787681
  788503
  789331
  789348
  789422
  789804
  790317
  793526
  793602
  793867
  794476
  794535
  794707
  795460
  796061
  796218
  796884
  797702
  800576
  801177
  804075
  804946
  807736
  808096
  811838
  816679
  817206
  817551
  817643
  819753
  820055
  820198
  823856
  824237
  824552
  824557
  824736
  825087
  825170
  825473
  825764
  825785
  825838
  826176
  826788
  827386
  827685
]
13.17 ms
(9.07%)
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
  825170
  823856
  824552
  824557
  478902
  565239
  566465
  722351
  564301
  615414
  602876
  779859
  788503
  793602
  794707
  796061
  801177
  789422
  804946
  723973
  724650
  726964
  747041
  761961
  756677
  737946
  610726
  631520
  778203
  787681
  811838
  537484
  807736
  742986
  746949
  514145
  506133
  817551
  824237
  825087
  817643
  819753
  820198
  824736
  825785
  826788
  827386
  816679
  820055
  825838
  826176
  817206
  825473
  825764
  827685
  531889
  533714
  511799
  495407
  552532
  555669
  558170
  544625
  647797
  661473
  679234
  679512
  708085
  687051
  688393
  691662
  698879
  710678
  716995
  720566
  678817
  698820
  716986
  720039
  545900
  585214
  586205
  590182
  590193
  602431
  613715
  628143
  630797
  635605
  585467
  622537
  628101
  774884
  779781
  787392
  789804
  793867
  794476
  794535
  795460
  796218
  800576
  804075
  808096
  775283
  775644
  789331
  789348
  790317
  793526
  796884
  797702
  724031
  729293
  729907
  734795
  757300
  759029
  761682
  764103
]
2.93 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
  478902
  495407
  506133
  511799
  514145
  531889
  533714
  537484
  544625
  545900
  552532
  555669
  558170
  564301
  565239
  566465
  585214
  585467
  586205
  590182
  590193
  602431
  602876
  610726
  613715
  615414
  622537
  628101
  628143
  630797
  631520
  635605
  647797
  661473
  678817
  679234
  679512
  687051
  688393
  691662
  698820
  698879
  708085
  710678
  716986
  716995
  720039
  720566
  722351
  723973
  724031
  724650
  726964
  729293
  729907
  734795
  737946
  742986
  746949
  747041
  756677
  757300
  759029
  761682
  761961
  764103
  774884
  775283
  775644
  778203
  779781
  779859
  787392
  787681
  788503
  789331
  789348
  789422
  789804
  790317
  793526
  793602
  793867
  794476
  794535
  794707
  795460
  796061
  796218
  796884
  797702
  800576
  801177
  804075
  804946
  807736
  808096
  811838
  816679
  817206
  817551
  817643
  819753
  820055
  820198
  823856
  824237
  824552
  824557
  824736
  825087
  825170
  825473
  825764
  825785
  825838
  826176
  826788
  827386
  827685
]
2.17 ms
(1.49%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hard wife"
]
2.10 ms
(1.45%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.94 ms
(1.33%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "hard жен"
]
1.71 ms
(1.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "hard жен"
]

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.