GET https://search.jues.net/search/embeds/8?q=brunette%20maid

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
150.73 ms
(86.07%)
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
  172420
  177522
  376519
  382132
  382215
  382881
  384258
  385323
  390951
  395856
  409080
  409300
  411333
  416974
  418270
  420407
  424032
  439613
  446920
  449716
  452130
  453167
  455373
  455605
  458561
  458873
  459238
  461234
  461490
  464408
  465073
  465996
  470522
  472153
  472426
  472530
  472849
  473447
  476425
  478324
  478620
  483983
  487892
  490177
  491542
  509642
  510098
  511793
  521501
  525373
  525743
  526058
  530783
  545069
  551443
  551916
  557930
  565965
  567035
  570636
  571234
  574825
  580950
  585377
  602663
  620607
  621719
  626442
  639128
  642227
  642412
  645890
  650162
  651530
  651645
  656453
  665237
  667207
  669758
  685113
  691538
  695850
  696282
  701187
  705320
  706013
  712624
  712673
  713088
  718677
  721084
  725532
  729748
  732171
  735088
  736046
  736477
  738291
  738376
  739941
  749583
  760714
  771626
  772896
  775739
  778041
  787451
  788603
  789451
  801436
  803352
  806088
  807393
  807809
  809288
  810978
  811140
  812012
  812262
  816507
]
13.96 ms
(7.97%)
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
  645890
  651645
  685113
  691538
  706013
  712624
  650162
  651530
  656453
  665237
  667207
  669758
  695850
  696282
  712673
  713088
  718677
  545069
  570636
  621719
  626442
  642227
  642412
  602663
  639128
  620607
  788603
  803352
  806088
  807809
  812262
  801436
  729748
  787451
  807393
  811140
  812012
  735088
  738291
  738376
  749583
  736477
  739941
  760714
  725532
  732171
  771626
  772896
  701187
  721084
  775739
  778041
  789451
  809288
  382132
  490177
  382881
  416974
  409300
  816507
  452130
  453167
  483983
  449716
  461234
  473447
  455605
  458561
  470522
  472530
  487892
  511793
  465073
  574825
  551443
  557930
  571234
  705320
  565965
  567035
  736046
  810978
  390951
  409080
  411333
  424032
  458873
  461490
  464408
  420407
  459238
  465996
  478324
  418270
  455373
  446920
  472426
  476425
  478620
  472153
  510098
  521501
  525373
  526058
  491542
  472849
  525743
  530783
  551916
  580950
  585377
  395856
  439613
  509642
  384258
  385323
  172420
  177522
  376519
  382215
]
2.92 ms
(1.67%)
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
  172420
  177522
  376519
  382132
  382215
  382881
  384258
  385323
  390951
  395856
  409080
  409300
  411333
  416974
  418270
  420407
  424032
  439613
  446920
  449716
  452130
  453167
  455373
  455605
  458561
  458873
  459238
  461234
  461490
  464408
  465073
  465996
  470522
  472153
  472426
  472530
  472849
  473447
  476425
  478324
  478620
  483983
  487892
  490177
  491542
  509642
  510098
  511793
  521501
  525373
  525743
  526058
  530783
  545069
  551443
  551916
  557930
  565965
  567035
  570636
  571234
  574825
  580950
  585377
  602663
  620607
  621719
  626442
  639128
  642227
  642412
  645890
  650162
  651530
  651645
  656453
  665237
  667207
  669758
  685113
  691538
  695850
  696282
  701187
  705320
  706013
  712624
  712673
  713088
  718677
  721084
  725532
  729748
  732171
  735088
  736046
  736477
  738291
  738376
  739941
  749583
  760714
  771626
  772896
  775739
  778041
  787451
  788603
  789451
  801436
  803352
  806088
  807393
  807809
  809288
  810978
  811140
  812012
  812262
  816507
]
2.09 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "brunette maid"
]
2.08 ms
(1.19%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "черноволосая горничн"
]
1.66 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "черноволосая горничн"
]
1.66 ms
(0.95%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]

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.