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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
136.68 ms
(84.32%)
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
  7981
  183979
  191048
  260940
  280073
  334950
  358942
  391253
  395516
  395721
  395738
  397053
  400178
  400209
  401223
  402592
  402997
  403562
  404462
  404615
  405208
  407028
  407052
  407414
  407552
  407554
  407557
  409682
  409894
  410124
  411237
  412289
  412424
  413870
  427243
  427935
  429307
  430837
  433241
  442946
  443802
  446633
  447785
  451826
  454191
  457396
  460135
  466943
  466996
  468774
  469338
  471183
  474826
  475220
  477080
  483141
  484157
  484649
  484670
  485037
  486157
  486529
  492108
  495652
  502222
  502512
  511422
  511568
  511925
  518948
  519184
  523803
  531512
  533182
  554513
  557125
  565534
  582407
  585689
  590861
  591294
  592310
  598852
  601063
  603736
  605415
  632010
  653794
  663444
  663495
  665208
  666113
  667646
  677974
  687511
  687980
  699023
  699804
  710318
  712973
  713065
  714973
  719343
  724271
  724291
  728288
  732040
  745433
  751457
  770844
  789702
  790022
  792621
  807141
  811930
  813913
  814817
  815417
  815600
  820973
]
16.21 ms
(10.00%)
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
  400209
  454191
  601063
  603736
  411237
  815600
  451826
  466943
  466996
  511568
  519184
  531512
  557125
  677974
  719343
  590861
  407414
  395738
  395721
  598852
  724271
  469338
  486157
  474826
  477080
  511925
  582407
  667646
  663495
  554513
  728288
  409682
  484670
  485037
  483141
  492108
  433241
  395516
  442946
  484649
  495652
  502512
  591294
  446633
  412289
  409894
  334950
  663444
  404615
  484157
  405208
  407554
  413870
  712973
  724291
  404462
  502222
  391253
  397053
  402592
  407557
  427243
  460135
  565534
  402997
  407552
  401223
  427935
  407028
  511422
  400178
  410124
  820973
  447785
  665208
  699023
  699804
  585689
  605415
  770844
  789702
  745433
  751457
  358942
  429307
  430837
  632010
  518948
  486529
  471183
  183979
  403562
  407052
  412424
  814817
  815417
  457396
  468774
  475220
  653794
  687511
  713065
  592310
  792621
  811930
  790022
  807141
  732040
  710318
  714973
  280073
  260940
  443802
  7981
  191048
  813913
  523803
  533182
  666113
  687980
]
2.53 ms
(1.56%)
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
  7981
  183979
  191048
  260940
  280073
  334950
  358942
  391253
  395516
  395721
  395738
  397053
  400178
  400209
  401223
  402592
  402997
  403562
  404462
  404615
  405208
  407028
  407052
  407414
  407552
  407554
  407557
  409682
  409894
  410124
  411237
  412289
  412424
  413870
  427243
  427935
  429307
  430837
  433241
  442946
  443802
  446633
  447785
  451826
  454191
  457396
  460135
  466943
  466996
  468774
  469338
  471183
  474826
  475220
  477080
  483141
  484157
  484649
  484670
  485037
  486157
  486529
  492108
  495652
  502222
  502512
  511422
  511568
  511925
  518948
  519184
  523803
  531512
  533182
  554513
  557125
  565534
  582407
  585689
  590861
  591294
  592310
  598852
  601063
  603736
  605415
  632010
  653794
  663444
  663495
  665208
  666113
  667646
  677974
  687511
  687980
  699023
  699804
  710318
  712973
  713065
  714973
  719343
  724271
  724291
  728288
  732040
  745433
  751457
  770844
  789702
  790022
  792621
  807141
  811930
  813913
  814817
  815417
  815600
  820973
]
1.86 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "old mature ffm"
]
1.74 ms
(1.07%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.61 ms
(0.99%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "old mature жмж секс втро"
]
1.47 ms
(0.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "old mature жмж секс втро"
]

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.