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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
205.08 ms
(50.34%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
181.00 ms
(44.43%)
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
  10171
  185247
  385681
  390987
  403616
  406362
  425846
  490700
  496326
  507123
  544258
  556800
  563243
  604379
  604390
  618314
  625743
  636400
  648536
  650151
  664194
  675460
  675481
  675745
  677630
  679089
  680878
  685600
  686265
  689160
  694325
  697467
  699101
  700897
  702374
  705353
  706407
  707729
  712998
  713642
  714785
  716710
  718427
  721197
  725902
  727784
  729064
  729966
  733969
  734036
  734135
  734320
  734990
  739602
  740243
  741521
  751697
  752809
  752966
  759364
  762194
  763892
  764325
  766292
  767686
  767781
  770693
  772492
  773151
  773525
  776146
  779546
  780287
  782095
  783383
  783387
  783436
  783781
  790185
  791323
  792535
  793430
  793574
  794406
  796704
  799113
  799544
  799608
  800137
  800364
  803102
  803272
  805880
  813607
  815933
  816639
  816941
  817099
  817325
  817962
  818487
  818510
  819889
  820196
  820802
  821004
  821183
  821542
  822910
  823178
  823485
  825110
  825440
  825462
  825688
  826048
  826640
  826745
  827464
  827520
]
12.74 ms
(3.13%)
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
  648536
  675460
  679089
  707729
  700897
  618314
  783781
  780287
  796704
  799113
  734320
  767686
  772492
  793574
  800364
  805880
  729966
  740243
  752966
  739602
  767781
  725902
  716710
  776146
  783436
  799544
  803272
  425846
  779546
  604379
  705353
  185247
  675481
  793430
  727784
  762194
  721197
  406362
  825110
  821004
  686265
  689160
  664194
  625743
  794406
  783387
  792535
  733969
  734036
  759364
  729064
  751697
  763892
  741521
  718427
  385681
  10171
  823178
  819889
  490700
  507123
  496326
  694325
  697467
  702374
  636400
  782095
  791323
  773151
  783383
  790185
  403616
  816639
  816941
  818487
  826640
  817962
  827464
  827520
  823485
  815933
  544258
  699101
  680878
  712998
  604390
  800137
  803102
  734135
  770693
  773525
  799608
  764325
  752809
  734990
  766292
  390987
  826048
  813607
  817099
  820196
  825688
  826745
  818510
  820802
  822910
  817325
  821183
  821542
  825440
  825462
  563243
  556800
  650151
  677630
  706407
  714785
  675745
  713642
  685600
]
3.15 ms
(0.77%)
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
  10171
  185247
  385681
  390987
  403616
  406362
  425846
  490700
  496326
  507123
  544258
  556800
  563243
  604379
  604390
  618314
  625743
  636400
  648536
  650151
  664194
  675460
  675481
  675745
  677630
  679089
  680878
  685600
  686265
  689160
  694325
  697467
  699101
  700897
  702374
  705353
  706407
  707729
  712998
  713642
  714785
  716710
  718427
  721197
  725902
  727784
  729064
  729966
  733969
  734036
  734135
  734320
  734990
  739602
  740243
  741521
  751697
  752809
  752966
  759364
  762194
  763892
  764325
  766292
  767686
  767781
  770693
  772492
  773151
  773525
  776146
  779546
  780287
  782095
  783383
  783387
  783436
  783781
  790185
  791323
  792535
  793430
  793574
  794406
  796704
  799113
  799544
  799608
  800137
  800364
  803102
  803272
  805880
  813607
  815933
  816639
  816941
  817099
  817325
  817962
  818487
  818510
  819889
  820196
  820802
  821004
  821183
  821542
  822910
  823178
  823485
  825110
  825440
  825462
  825688
  826048
  826640
  826745
  827464
  827520
]
2.05 ms
(0.50%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "all sex"
]
1.89 ms
(0.46%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "all секс"
]
1.48 ms
(0.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "all секс"
]

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.