GET https://search.jues.net/search/embeds/8?q=mature%20chubby%20doggy

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
135.85 ms
(83.50%)
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
  187353
  187843
  233617
  358193
  365875
  367962
  384128
  389757
  391344
  391651
  391923
  391955
  392004
  392019
  397850
  400892
  401843
  411321
  411350
  411820
  415753
  415782
  424032
  424449
  425997
  433341
  433353
  436138
  439634
  439722
  439758
  439856
  440639
  441000
  441280
  441359
  443292
  445397
  452931
  453348
  454399
  454560
  459951
  461039
  462348
  464975
  466314
  466877
  468269
  468369
  469390
  472007
  474109
  476349
  478384
  478450
  482490
  484373
  485870
  485943
  485970
  489105
  495444
  498422
  498702
  514488
  514761
  516480
  521220
  523834
  526737
  530474
  532271
  535587
  591833
  592904
  593044
  663866
  665366
  665448
  669776
  714510
  725185
  726486
  726502
  727032
  727507
  733148
  734822
  735888
  736219
  738462
  739608
  739962
  740958
  741506
  741752
  741784
  741787
  741794
  742274
  743786
  747054
  748391
  758283
  761046
  761056
  761164
  768366
  788300
  788542
  788546
  792670
  796072
  796566
  796807
  799351
  799962
  808241
  826267
]
16.86 ms
(10.36%)
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
  727507
  734822
  747054
  748391
  768366
  725185
  738462
  741787
  743786
  758283
  735888
  736219
  739608
  739962
  741506
  742274
  761164
  714510
  796807
  391923
  461039
  358193
  462348
  391651
  411350
  474109
  384128
  187843
  187353
  389757
  401843
  415782
  433341
  411820
  826267
  482490
  535587
  514761
  532271
  459951
  665448
  593044
  592904
  788300
  788542
  799351
  741752
  741784
  741794
  788546
  796072
  796566
  740958
  761046
  733148
  726486
  727032
  761056
  792670
  799962
  233617
  391955
  464975
  468369
  478384
  365875
  454560
  391344
  433353
  526737
  485870
  485970
  489105
  498702
  516480
  514488
  521220
  523834
  392019
  400892
  441359
  425997
  441280
  415753
  440639
  454399
  468269
  472007
  452931
  530474
  495444
  466314
  663866
  665366
  669776
  591833
  808241
  726502
  424032
  424449
  445397
  453348
  478450
  392004
  436138
  367962
  485943
  484373
  498422
  441000
  476349
  443292
  469390
  411321
  439634
  439758
  439856
  397850
  439722
  466877
]
2.59 ms
(1.59%)
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
  187353
  187843
  233617
  358193
  365875
  367962
  384128
  389757
  391344
  391651
  391923
  391955
  392004
  392019
  397850
  400892
  401843
  411321
  411350
  411820
  415753
  415782
  424032
  424449
  425997
  433341
  433353
  436138
  439634
  439722
  439758
  439856
  440639
  441000
  441280
  441359
  443292
  445397
  452931
  453348
  454399
  454560
  459951
  461039
  462348
  464975
  466314
  466877
  468269
  468369
  469390
  472007
  474109
  476349
  478384
  478450
  482490
  484373
  485870
  485943
  485970
  489105
  495444
  498422
  498702
  514488
  514761
  516480
  521220
  523834
  526737
  530474
  532271
  535587
  591833
  592904
  593044
  663866
  665366
  665448
  669776
  714510
  725185
  726486
  726502
  727032
  727507
  733148
  734822
  735888
  736219
  738462
  739608
  739962
  740958
  741506
  741752
  741784
  741787
  741794
  742274
  743786
  747054
  748391
  758283
  761046
  761056
  761164
  768366
  788300
  788542
  788546
  792670
  796072
  796566
  796807
  799351
  799962
  808241
  826267
]
2.16 ms
(1.33%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature chubby doggy"
]
2.00 ms
(1.23%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.72 ms
(1.06%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature chubby рак"
]
1.53 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mature chubby рак"
]

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.