GET https://search.jues.net/search/embeds/3?q=mature%20suck

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
123.18 ms
(80.93%)
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
  80709
  389921
  397269
  397906
  403562
  404519
  405507
  411864
  414317
  415787
  417292
  418966
  421913
  423971
  424129
  424194
  437663
  439546
  439609
  440537
  440874
  443472
  443793
  443961
  445350
  448558
  452297
  454951
  455206
  455974
  457114
  458873
  460642
  464532
  466274
  468934
  469967
  474446
  474874
  479060
  481315
  483145
  484628
  485084
  489060
  491168
  491628
  494191
  494192
  494204
  497793
  499712
  502579
  506043
  506079
  514736
  518325
  518859
  519357
  521529
  522482
  523189
  525882
  528386
  528443
  530001
  532101
  533603
  554511
  557150
  557182
  560412
  562604
  565339
  569315
  573230
  574414
  579221
  579574
  580424
  581749
  589688
  589695
  590286
  593003
  593018
  593029
  596787
  597162
  597207
  598840
  602676
  628037
  657774
  665238
  666784
  726519
  726528
  726538
  726713
  742891
  744624
  748375
  751572
  756083
  763741
  774980
  776448
  789225
  794943
  796014
  796084
  796091
  796798
  796877
  807133
  808681
  813532
  814859
  814971
]
18.32 ms
(12.04%)
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
  789225
  796091
  808681
  423971
  474446
  454951
  466274
  481315
  494191
  522482
  519357
  411864
  443472
  554511
  452297
  439609
  483145
  528386
  557182
  666784
  593018
  474874
  80709
  414317
  445350
  464532
  469967
  521529
  557150
  579574
  565339
  573230
  579221
  598840
  628037
  589688
  602676
  590286
  596787
  597162
  774980
  796014
  742891
  726538
  748375
  756083
  744624
  776448
  794943
  796084
  807133
  424129
  458873
  525882
  533603
  494192
  491628
  494204
  485084
  518859
  389921
  397269
  597207
  484628
  404519
  403562
  418966
  814971
  468934
  479060
  506079
  499712
  506043
  580424
  560412
  665238
  574414
  593003
  796798
  726519
  726713
  751572
  796877
  440874
  443793
  443961
  439546
  421913
  424194
  415787
  440537
  518325
  502579
  455206
  405507
  417292
  437663
  460642
  532101
  562604
  581749
  657774
  569315
  589695
  593029
  813532
  726528
  763741
  455974
  457114
  448558
  530001
  489060
  491168
  497793
  397906
  814859
  514736
  523189
  528443
]
3.35 ms
(2.20%)
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
  80709
  389921
  397269
  397906
  403562
  404519
  405507
  411864
  414317
  415787
  417292
  418966
  421913
  423971
  424129
  424194
  437663
  439546
  439609
  440537
  440874
  443472
  443793
  443961
  445350
  448558
  452297
  454951
  455206
  455974
  457114
  458873
  460642
  464532
  466274
  468934
  469967
  474446
  474874
  479060
  481315
  483145
  484628
  485084
  489060
  491168
  491628
  494191
  494192
  494204
  497793
  499712
  502579
  506043
  506079
  514736
  518325
  518859
  519357
  521529
  522482
  523189
  525882
  528386
  528443
  530001
  532101
  533603
  554511
  557150
  557182
  560412
  562604
  565339
  569315
  573230
  574414
  579221
  579574
  580424
  581749
  589688
  589695
  590286
  593003
  593018
  593029
  596787
  597162
  597207
  598840
  602676
  628037
  657774
  665238
  666784
  726519
  726528
  726538
  726713
  742891
  744624
  748375
  751572
  756083
  763741
  774980
  776448
  789225
  794943
  796014
  796084
  796091
  796798
  796877
  807133
  808681
  813532
  814859
  814971
]
2.03 ms
(1.33%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature suck"
]
1.99 ms
(1.31%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.70 ms
(1.12%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature suck"
]
1.64 ms
(1.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mature suck"
]

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.