GET https://search.jues.net/search/embeds/3?q=body%20sex

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
119.92 ms
(85.91%)
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
  39478
  163116
  256898
  365314
  382158
  396762
  412237
  423019
  426104
  427749
  429298
  436632
  441802
  470014
  501118
  513935
  521952
  529415
  532536
  552092
  552838
  567295
  570852
  577226
  577293
  583656
  584849
  587663
  589991
  596969
  599075
  610342
  616615
  618192
  619600
  620029
  621092
  622986
  636261
  641171
  642115
  644010
  645400
  652274
  662437
  670187
  693250
  695029
  697853
  702134
  708495
  708747
  709074
  709090
  709155
  711606
  713667
  714578
  719535
  720791
  721909
  725353
  726788
  733041
  734472
  735964
  736535
  739222
  744170
  747840
  749595
  751289
  756187
  756994
  758494
  759460
  761586
  763518
  765890
  768200
  771166
  771847
  772063
  773576
  773621
  775617
  778255
  778350
  780249
  781055
  782430
  784340
  791122
  791337
  791598
  797661
  798121
  799075
  799892
  802455
  802760
  805160
  805654
  807364
  807536
  808740
  811338
  811537
  813116
  813616
  814278
  815781
  816804
  818866
  819144
  819197
  821231
  821760
  824468
  825572
]
10.02 ms
(7.18%)
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
  736535
  382158
  814278
  815781
  501118
  567295
  583656
  739222
  756187
  773576
  765890
  642115
  163116
  365314
  412237
  824468
  708747
  670187
  695029
  702134
  709074
  709155
  778255
  791122
  798121
  751289
  771166
  761586
  708495
  713667
  711606
  725353
  773621
  470014
  441802
  427749
  825572
  813616
  819197
  821231
  821760
  552092
  577293
  570852
  693250
  720791
  662437
  719535
  587663
  589991
  636261
  622986
  619600
  620029
  781055
  791598
  799892
  778350
  744170
  784340
  802760
  808740
  811338
  733041
  747840
  763518
  797661
  759460
  735964
  756994
  818866
  552838
  577226
  584849
  618192
  616615
  811537
  758494
  771847
  39478
  819144
  529415
  521952
  714578
  644010
  610342
  599075
  621092
  813116
  805654
  768200
  791337
  807536
  726788
  641171
  802455
  807364
  396762
  426104
  256898
  423019
  429298
  816804
  513935
  532536
  645400
  697853
  652274
  709090
  596969
  780249
  799075
  734472
  782430
  805160
  749595
  772063
  721909
  775617
  436632
]
2.44 ms
(1.75%)
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
  39478
  163116
  256898
  365314
  382158
  396762
  412237
  423019
  426104
  427749
  429298
  436632
  441802
  470014
  501118
  513935
  521952
  529415
  532536
  552092
  552838
  567295
  570852
  577226
  577293
  583656
  584849
  587663
  589991
  596969
  599075
  610342
  616615
  618192
  619600
  620029
  621092
  622986
  636261
  641171
  642115
  644010
  645400
  652274
  662437
  670187
  693250
  695029
  697853
  702134
  708495
  708747
  709074
  709090
  709155
  711606
  713667
  714578
  719535
  720791
  721909
  725353
  726788
  733041
  734472
  735964
  736535
  739222
  744170
  747840
  749595
  751289
  756187
  756994
  758494
  759460
  761586
  763518
  765890
  768200
  771166
  771847
  772063
  773576
  773621
  775617
  778255
  778350
  780249
  781055
  782430
  784340
  791122
  791337
  791598
  797661
  798121
  799075
  799892
  802455
  802760
  805160
  805654
  807364
  807536
  808740
  811338
  811537
  813116
  813616
  814278
  815781
  816804
  818866
  819144
  819197
  821231
  821760
  824468
  825572
]
2.00 ms
(1.43%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "body sex"
]
1.95 ms
(1.40%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.75 ms
(1.26%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "body секс"
]
1.50 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "body секс"
]

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.