GET https://search.jues.net/search/embeds/2?q=deep%20in%20sex

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
128.18 ms
(84.45%)
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
  386178
  390986
  393585
  401342
  401426
  401480
  401482
  401615
  402219
  403343
  404368
  406083
  406085
  411895
  415199
  415320
  417003
  417384
  417647
  417735
  418494
  418683
  423455
  423471
  424347
  427585
  427786
  429214
  440911
  442973
  446036
  446534
  451320
  454635
  456128
  457138
  457512
  458385
  460769
  461680
  464211
  465120
  468339
  470355
  475600
  476117
  476128
  477689
  478043
  479018
  479590
  485057
  488697
  492670
  496859
  497174
  500620
  504321
  508197
  516511
  518472
  520323
  525462
  531347
  531656
  533643
  542212
  551234
  554077
  559018
  564891
  566929
  581188
  582697
  585971
  587477
  591747
  592322
  592644
  604215
  606595
  615692
  621125
  635081
  642244
  661991
  668713
  670915
  673122
  682507
  693509
  699581
  716613
  719461
  719776
  719927
  722809
  732878
  737561
  744320
  757867
  760942
  761600
  765940
  767011
  770202
  776784
  781810
  782539
  783625
  789455
  795319
  805146
  805875
  806514
  806947
  817608
  818569
  821399
  822309
]
13.83 ms
(9.11%)
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
  508197
  497174
  670915
  767011
  446534
  554077
  699581
  673122
  760942
  822309
  635081
  782539
  757867
  661991
  693509
  458385
  591747
  402219
  592322
  765940
  496859
  642244
  604215
  744320
  776784
  423455
  737561
  488697
  817608
  783625
  795319
  682507
  401480
  719461
  606595
  468339
  500620
  806514
  806947
  465120
  417003
  592644
  761600
  475600
  585971
  386178
  551234
  559018
  542212
  460769
  406083
  818569
  716613
  429214
  477689
  390986
  446036
  504321
  464211
  411895
  461680
  401426
  722809
  401342
  415320
  470355
  566929
  587477
  520323
  401615
  417384
  457512
  516511
  581188
  427585
  531347
  564891
  479590
  404368
  451320
  417735
  427786
  415199
  492670
  485057
  478043
  401482
  615692
  479018
  424347
  417647
  533643
  531656
  418494
  418683
  582697
  456128
  525462
  442973
  457138
  476128
  805146
  518472
  406085
  440911
  476117
  732878
  393585
  454635
  621125
  781810
  770202
  423471
  719776
  805875
  821399
  403343
  668713
  719927
  789455
]
2.93 ms
(1.93%)
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
  386178
  390986
  393585
  401342
  401426
  401480
  401482
  401615
  402219
  403343
  404368
  406083
  406085
  411895
  415199
  415320
  417003
  417384
  417647
  417735
  418494
  418683
  423455
  423471
  424347
  427585
  427786
  429214
  440911
  442973
  446036
  446534
  451320
  454635
  456128
  457138
  457512
  458385
  460769
  461680
  464211
  465120
  468339
  470355
  475600
  476117
  476128
  477689
  478043
  479018
  479590
  485057
  488697
  492670
  496859
  497174
  500620
  504321
  508197
  516511
  518472
  520323
  525462
  531347
  531656
  533643
  542212
  551234
  554077
  559018
  564891
  566929
  581188
  582697
  585971
  587477
  591747
  592322
  592644
  604215
  606595
  615692
  621125
  635081
  642244
  661991
  668713
  670915
  673122
  682507
  693509
  699581
  716613
  719461
  719776
  719927
  722809
  732878
  737561
  744320
  757867
  760942
  761600
  765940
  767011
  770202
  776784
  781810
  782539
  783625
  789455
  795319
  805146
  805875
  806514
  806947
  817608
  818569
  821399
  822309
]
2.13 ms
(1.40%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "deep in sex"
]
1.70 ms
(1.12%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "deep секс"
]
1.63 ms
(1.07%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.40 ms
(0.92%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "deep секс"
]

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.