GET https://search.jues.net/search/embeds/10?q=threesome%20bbc

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
127.90 ms
(80.97%)
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
  130105
  282010
  341675
  383987
  393590
  396581
  405891
  408601
  409886
  412189
  413944
  413950
  416351
  416365
  416975
  416992
  419123
  419358
  420139
  420768
  420925
  424523
  425332
  425709
  429762
  429805
  430504
  433747
  443094
  443476
  443651
  443661
  443991
  448987
  449933
  451620
  452139
  452606
  460099
  464359
  465025
  465649
  468628
  472286
  477391
  477470
  478608
  483536
  486788
  487150
  495397
  496551
  496900
  502703
  502890
  508547
  510284
  512452
  516045
  516776
  517612
  519107
  519108
  522130
  522871
  523561
  527888
  528886
  531540
  532984
  533353
  533364
  535358
  536631
  542975
  543234
  543877
  544474
  554472
  558447
  565102
  565460
  578488
  582800
  583478
  583923
  593238
  593886
  596616
  599852
  603539
  603605
  605663
  611571
  615711
  616617
  621962
  632692
  636292
  637103
  637145
  639731
  639742
  641986
  642775
  644961
  648838
  648889
  659283
  662048
  666872
  668528
  696203
  710794
  721617
  724271
  760794
  815697
  815735
  827915
]
18.76 ms
(11.88%)
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
  724271
  396581
  578488
  827915
  533353
  558447
  443094
  408601
  413950
  425332
  449933
  424523
  393590
  341675
  405891
  409886
  416365
  477391
  472286
  519107
  583923
  593238
  425709
  452139
  130105
  443661
  433747
  416351
  815735
  531540
  532984
  544474
  543877
  648838
  668528
  605663
  616617
  603539
  637145
  639742
  760794
  416992
  419358
  443651
  527888
  496900
  383987
  443991
  644961
  483536
  486788
  460099
  512452
  519108
  496551
  510284
  522130
  528886
  533364
  535358
  536631
  477470
  542975
  554472
  543234
  648889
  696203
  593886
  611571
  637103
  599852
  636292
  632692
  443476
  465649
  468628
  430504
  413944
  416975
  420768
  429762
  451620
  517612
  516045
  516776
  464359
  565460
  583478
  666872
  565102
  603605
  639731
  487150
  412189
  420139
  448987
  465025
  478608
  502703
  502890
  582800
  721617
  659283
  621962
  641986
  642775
  429805
  419123
  815697
  662048
  615711
  452606
  508547
  710794
  596616
  420925
  522871
  523561
  282010
  495397
]
3.90 ms
(2.47%)
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
  130105
  282010
  341675
  383987
  393590
  396581
  405891
  408601
  409886
  412189
  413944
  413950
  416351
  416365
  416975
  416992
  419123
  419358
  420139
  420768
  420925
  424523
  425332
  425709
  429762
  429805
  430504
  433747
  443094
  443476
  443651
  443661
  443991
  448987
  449933
  451620
  452139
  452606
  460099
  464359
  465025
  465649
  468628
  472286
  477391
  477470
  478608
  483536
  486788
  487150
  495397
  496551
  496900
  502703
  502890
  508547
  510284
  512452
  516045
  516776
  517612
  519107
  519108
  522130
  522871
  523561
  527888
  528886
  531540
  532984
  533353
  533364
  535358
  536631
  542975
  543234
  543877
  544474
  554472
  558447
  565102
  565460
  578488
  582800
  583478
  583923
  593238
  593886
  596616
  599852
  603539
  603605
  605663
  611571
  615711
  616617
  621962
  632692
  636292
  637103
  637145
  639731
  639742
  641986
  642775
  644961
  648838
  648889
  659283
  662048
  666872
  668528
  696203
  710794
  721617
  724271
  760794
  815697
  815735
  827915
]
2.02 ms
(1.28%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс втро bbc"
]
1.91 ms
(1.21%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.80 ms
(1.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "threesome bbc"
]
1.66 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс втро bbc"
]

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.