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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
137.17 ms
(83.02%)
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
  218026
  249637
  260940
  400753
  400932
  403162
  404217
  404568
  405054
  405061
  405848
  407515
  408460
  409119
  411638
  411681
  413263
  416820
  417889
  417897
  418478
  419378
  421557
  424782
  435624
  445728
  445733
  445751
  446932
  449011
  451602
  456628
  457192
  460689
  468046
  472317
  472445
  474621
  488897
  490265
  491378
  492338
  493203
  496552
  497776
  499334
  499889
  501233
  504876
  510270
  510282
  510394
  512652
  513357
  516685
  517184
  517857
  518493
  521928
  527029
  529243
  530492
  532888
  534041
  535542
  537899
  537925
  538360
  541252
  541434
  542854
  545117
  545470
  545586
  546828
  548580
  549314
  552266
  557136
  565391
  568185
  582012
  597753
  599916
  600429
  604508
  604550
  605617
  609682
  610284
  620794
  625448
  631908
  643050
  649975
  650165
  650487
  653956
  653972
  656639
  662143
  693383
  702557
  720111
  720115
  720291
  720393
  733573
  746417
  747004
  756430
  759472
  760791
  788283
  804491
  815789
  816086
  816949
  827854
  827876
]
16.20 ms
(9.80%)
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
  733573
  720111
  510282
  521928
  491378
  400932
  404217
  405848
  815789
  446932
  472445
  460689
  493203
  449011
  565391
  568185
  649975
  662143
  693383
  656639
  720393
  545117
  548580
  599916
  597753
  631908
  788283
  746417
  760791
  756430
  720291
  451602
  260940
  249637
  516685
  504876
  512652
  545586
  620794
  456628
  532888
  499334
  527029
  653956
  653972
  549314
  625448
  610284
  747004
  501233
  541252
  490265
  488897
  545470
  408460
  816086
  537925
  535542
  530492
  474621
  411681
  517857
  417889
  513357
  529243
  827876
  605617
  643050
  510394
  518493
  702557
  517184
  827854
  407515
  546828
  413263
  472317
  445751
  418478
  496552
  542854
  604508
  600429
  759472
  419378
  218026
  405061
  497776
  403162
  405054
  409119
  411638
  416820
  424782
  492338
  445733
  468046
  457192
  537899
  541434
  557136
  582012
  650487
  720115
  650165
  604550
  609682
  804491
  404568
  417897
  499889
  510270
  538360
  552266
  400753
  435624
  421557
  816949
  445728
  534041
]
4.18 ms
(2.53%)
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
  218026
  249637
  260940
  400753
  400932
  403162
  404217
  404568
  405054
  405061
  405848
  407515
  408460
  409119
  411638
  411681
  413263
  416820
  417889
  417897
  418478
  419378
  421557
  424782
  435624
  445728
  445733
  445751
  446932
  449011
  451602
  456628
  457192
  460689
  468046
  472317
  472445
  474621
  488897
  490265
  491378
  492338
  493203
  496552
  497776
  499334
  499889
  501233
  504876
  510270
  510282
  510394
  512652
  513357
  516685
  517184
  517857
  518493
  521928
  527029
  529243
  530492
  532888
  534041
  535542
  537899
  537925
  538360
  541252
  541434
  542854
  545117
  545470
  545586
  546828
  548580
  549314
  552266
  557136
  565391
  568185
  582012
  597753
  599916
  600429
  604508
  604550
  605617
  609682
  610284
  620794
  625448
  631908
  643050
  649975
  650165
  650487
  653956
  653972
  656639
  662143
  693383
  702557
  720111
  720115
  720291
  720393
  733573
  746417
  747004
  756430
  759472
  760791
  788283
  804491
  815789
  816086
  816949
  827854
  827876
]
2.48 ms
(1.50%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "threesome bbc"
]
2.13 ms
(1.29%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс втро bbc"
]
1.66 ms
(1.00%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.42 ms
(0.86%)
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.