GET https://search.jues.net/search/embeds/10?q=wife%20russian

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
152.78 ms
(85.79%)
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
  233042
  365907
  382699
  391563
  391569
  391907
  411246
  411367
  414594
  424009
  427147
  429957
  432433
  433822
  439511
  444209
  455129
  464954
  466705
  467781
  470117
  470591
  473284
  475818
  475942
  477129
  477135
  482078
  512563
  533646
  533663
  533761
  533777
  539341
  543644
  546659
  548049
  550938
  557478
  558123
  560005
  568685
  571472
  577481
  588916
  595455
  603834
  614566
  626019
  650064
  656545
  662147
  666515
  668142
  673425
  685130
  685523
  704343
  709501
  709511
  712176
  713434
  714565
  714582
  714583
  714591
  714592
  714598
  722346
  722357
  722984
  723908
  723909
  729934
  731032
  731658
  731661
  735330
  736977
  739458
  741713
  741737
  747421
  755633
  758031
  758185
  758314
  761604
  761618
  761644
  761669
  761910
  762220
  762274
  764122
  764123
  764138
  764150
  768355
  775574
  775889
  778109
  778166
  778224
  778654
  780791
  780795
  784156
  787060
  788677
  790280
  791723
  791742
  796038
  809560
  811145
  811241
  827432
]
14.51 ms
(8.15%)
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
  533761
  391907
  473284
  546659
  588916
  475942
  411367
  424009
  439511
  482078
  427147
  512563
  685130
  761604
  391569
  411246
  414594
  429957
  827432
  470117
  477129
  533777
  533646
  533663
  539341
  470591
  477135
  571472
  543644
  548049
  558123
  568685
  577481
  650064
  673425
  685523
  714591
  719429
  722346
  662147
  666515
  668142
  704343
  713434
  714592
  714598
  722984
  656545
  709501
  712176
  714582
  714583
  550938
  557478
  560005
  626019
  595455
  614566
  586568
  603834
  775889
  790280
  796038
  811241
  775574
  780795
  723908
  729934
  736977
  741737
  755633
  758314
  761618
  761669
  764123
  791723
  791742
  809560
  731032
  731661
  741713
  747421
  762220
  762274
  723909
  731658
  735330
  768355
  761644
  764122
  764138
  739458
  758031
  758185
  761910
  764150
  709511
  714565
  722357
  778109
  778166
  778224
  778654
  780791
  784156
  787060
  788677
  811145
  233042
  382699
  433822
  455129
  464954
  475818
  432433
  466705
  467781
  365907
  391563
  444209
]
2.69 ms
(1.51%)
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
  233042
  365907
  382699
  391563
  391569
  391907
  411246
  411367
  414594
  424009
  427147
  429957
  432433
  433822
  439511
  444209
  455129
  464954
  466705
  467781
  470117
  470591
  473284
  475818
  475942
  477129
  477135
  482078
  512563
  533646
  533663
  533761
  533777
  539341
  543644
  546659
  548049
  550938
  557478
  558123
  560005
  568685
  571472
  577481
  588916
  595455
  603834
  614566
  626019
  650064
  656545
  662147
  666515
  668142
  673425
  685130
  685523
  704343
  709501
  709511
  712176
  713434
  714565
  714582
  714583
  714591
  714592
  714598
  722346
  722357
  722984
  723908
  723909
  729934
  731032
  731658
  731661
  735330
  736977
  739458
  741713
  741737
  747421
  755633
  758031
  758185
  758314
  761604
  761618
  761644
  761669
  761910
  762220
  762274
  764122
  764123
  764138
  764150
  768355
  775574
  775889
  778109
  778166
  778224
  778654
  780791
  780795
  784156
  787060
  788677
  790280
  791723
  791742
  796038
  809560
  811145
  811241
  827432
]
2.26 ms
(1.27%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.24 ms
(1.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "wife russian"
]
2.05 ms
(1.15%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен русск"
]
1.54 ms
(0.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.