GET https://search.jues.net/search/embeds/9?q=mature%20young%20boy

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
174.75 ms
(85.47%)
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
  187595
  188129
  229834
  232940
  233683
  276696
  358449
  358481
  382289
  382434
  383205
  384878
  391247
  392031
  392672
  395515
  395556
  395660
  395955
  397224
  401200
  407707
  407708
  409935
  409940
  411703
  412083
  414038
  419518
  429461
  439525
  439607
  443154
  443953
  452252
  454879
  455961
  457988
  460761
  461071
  462085
  465147
  465512
  465791
  467048
  467418
  467550
  469370
  470272
  470416
  470959
  474091
  474123
  474875
  476257
  476350
  476363
  477705
  479043
  479133
  483108
  483139
  484397
  484648
  485763
  490878
  501519
  502738
  506051
  506211
  511522
  518842
  519739
  522003
  536330
  544859
  558005
  560394
  563063
  563209
  563421
  591245
  609274
  612868
  614476
  636039
  637403
  664975
  665219
  666130
  667661
  668181
  680704
  701444
  710579
  712331
  714640
  721427
  721463
  721502
  721735
  722240
  736386
  736402
  748226
  748244
  758436
  770178
  772113
  781701
  781740
  781741
  781745
  781746
  781761
  781980
  782225
  804006
  820384
  825238
]
18.99 ms
(9.29%)
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
  820384
  665219
  721463
  680704
  710579
  614476
  781746
  736386
  722240
  781745
  395955
  502738
  701444
  721502
  395556
  276696
  407707
  409940
  407708
  452252
  485763
  454879
  474123
  483108
  544859
  560394
  558005
  563209
  563421
  667661
  668181
  721427
  609274
  781761
  748226
  758436
  781741
  804006
  736402
  770178
  772113
  781980
  187595
  188129
  382289
  233683
  358449
  479133
  358481
  383205
  384878
  392031
  392672
  467550
  476363
  479043
  232940
  409935
  460761
  470959
  443154
  511522
  519739
  501519
  522003
  484397
  490878
  382434
  429461
  412083
  414038
  455961
  461071
  476257
  483139
  467418
  465147
  474091
  474875
  563063
  748244
  443953
  462085
  470272
  391247
  419518
  439525
  476350
  457988
  465791
  470416
  411703
  506051
  518842
  465512
  484648
  467048
  612868
  401200
  477705
  439607
  506211
  229834
  395515
  395660
  397224
  825238
  469370
  536330
  712331
  721735
  666130
  664975
  714640
  591245
  636039
  637403
  782225
  781701
  781740
]
3.68 ms
(1.80%)
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
  187595
  188129
  229834
  232940
  233683
  276696
  358449
  358481
  382289
  382434
  383205
  384878
  391247
  392031
  392672
  395515
  395556
  395660
  395955
  397224
  401200
  407707
  407708
  409935
  409940
  411703
  412083
  414038
  419518
  429461
  439525
  439607
  443154
  443953
  452252
  454879
  455961
  457988
  460761
  461071
  462085
  465147
  465512
  465791
  467048
  467418
  467550
  469370
  470272
  470416
  470959
  474091
  474123
  474875
  476257
  476350
  476363
  477705
  479043
  479133
  483108
  483139
  484397
  484648
  485763
  490878
  501519
  502738
  506051
  506211
  511522
  518842
  519739
  522003
  536330
  544859
  558005
  560394
  563063
  563209
  563421
  591245
  609274
  612868
  614476
  636039
  637403
  664975
  665219
  666130
  667661
  668181
  680704
  701444
  710579
  712331
  714640
  721427
  721463
  721502
  721735
  722240
  736386
  736402
  748226
  748244
  758436
  770178
  772113
  781701
  781740
  781741
  781745
  781746
  781761
  781980
  782225
  804006
  820384
  825238
]
2.06 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature young boy"
]
1.71 ms
(0.84%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.68 ms
(0.82%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature young парен"
]
1.58 ms
(0.77%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mature young парен"
]

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.