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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
167.24 ms
(84.98%)
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
  66768
  170836
  187723
  232953
  310683
  359075
  382091
  382284
  382746
  383390
  385632
  387377
  388329
  388604
  395943
  397362
  398956
  400994
  407777
  407779
  410237
  411688
  413068
  439488
  443762
  453438
  453681
  453702
  454222
  455048
  456897
  457458
  462101
  462690
  465788
  465949
  466319
  467445
  467449
  471883
  474427
  474485
  475870
  477965
  478793
  480731
  484426
  484462
  484665
  486821
  490918
  493098
  506045
  518852
  525488
  537985
  539358
  546930
  551574
  554389
  557310
  557991
  558021
  560414
  561589
  561598
  563064
  563127
  563196
  592914
  601853
  645840
  663368
  663485
  664281
  665415
  665483
  667593
  667868
  687555
  707282
  708125
  710445
  710485
  710587
  714646
  718499
  718563
  721413
  726572
  726588
  730550
  741653
  743803
  748130
  748232
  770151
  774766
  776742
  781659
  781678
  781688
  781706
  781731
  781757
  782158
  782183
  789292
  789526
  789534
  792588
  808500
  811469
  816792
  817308
  818656
  818921
  820283
  823691
  824145
]
19.00 ms
(9.65%)
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
  382746
  710587
  781706
  781731
  782158
  782183
  781678
  781688
  726588
  726572
  741653
  808500
  187723
  398956
  395943
  665415
  592914
  789534
  748130
  789526
  748232
  743803
  710445
  387377
  439488
  466319
  474485
  454222
  490918
  484426
  310683
  397362
  818921
  824145
  537985
  563064
  667593
  721413
  667868
  708125
  718499
  718563
  776742
  781757
  811469
  730550
  770151
  781659
  359075
  385632
  561589
  557310
  601853
  382284
  388604
  407779
  411688
  407777
  453702
  462690
  453438
  453681
  456897
  493098
  455048
  457458
  465788
  525488
  474427
  558021
  546930
  551574
  563196
  663485
  663368
  710485
  557991
  477965
  471883
  475870
  383390
  413068
  478793
  400994
  443762
  467449
  480731
  467445
  484462
  486821
  506045
  382091
  687555
  792588
  484665
  518852
  410237
  563127
  66768
  465949
  554389
  462101
  388329
  816792
  823691
  820283
  539358
  560414
  561598
  707282
  664281
  714646
  170836
  232953
  818656
  817308
  665483
  645840
  789292
  774766
]
3.65 ms
(1.85%)
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
  66768
  170836
  187723
  232953
  310683
  359075
  382091
  382284
  382746
  383390
  385632
  387377
  388329
  388604
  395943
  397362
  398956
  400994
  407777
  407779
  410237
  411688
  413068
  439488
  443762
  453438
  453681
  453702
  454222
  455048
  456897
  457458
  462101
  462690
  465788
  465949
  466319
  467445
  467449
  471883
  474427
  474485
  475870
  477965
  478793
  480731
  484426
  484462
  484665
  486821
  490918
  493098
  506045
  518852
  525488
  537985
  539358
  546930
  551574
  554389
  557310
  557991
  558021
  560414
  561589
  561598
  563064
  563127
  563196
  592914
  601853
  645840
  663368
  663485
  664281
  665415
  665483
  667593
  667868
  687555
  707282
  708125
  710445
  710485
  710587
  714646
  718499
  718563
  721413
  726572
  726588
  730550
  741653
  743803
  748130
  748232
  770151
  774766
  776742
  781659
  781678
  781688
  781706
  781731
  781757
  782158
  782183
  789292
  789526
  789534
  792588
  808500
  811469
  816792
  817308
  818656
  818921
  820283
  823691
  824145
]
2.18 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature young boy"
]
1.71 ms
(0.87%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature young парен"
]
1.57 ms
(0.80%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.45 ms
(0.74%)
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.