GET https://search.jues.net/search/embeds/6?q=teens%20first%20anal

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
190.66 ms
(87.65%)
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
  385706
  388434
  391113
  395661
  395698
  395756
  399722
  400682
  404753
  406339
  409615
  417317
  418846
  419033
  423464
  423620
  432552
  435022
  436437
  439138
  441402
  444912
  445411
  446158
  447441
  447719
  452648
  454101
  456263
  457882
  457893
  460697
  461554
  462787
  462804
  464580
  465790
  477004
  479756
  479759
  488537
  490823
  491573
  491947
  496164
  497371
  497697
  499902
  501534
  506073
  507685
  508754
  511955
  520777
  524070
  529054
  534032
  550294
  555571
  555851
  561830
  564039
  567335
  568122
  580623
  580631
  582708
  585417
  588014
  591259
  593167
  593766
  597260
  597264
  605322
  628116
  632638
  633772
  633776
  636987
  637141
  639254
  639804
  641886
  645232
  649140
  657127
  657128
  665717
  672686
  674713
  677364
  679190
  680161
  681505
  683963
  705828
  722199
  722264
  731303
  735703
  747136
  758190
  759340
  760975
  761562
  772708
  773664
  780597
  780637
  784161
  791604
  791686
  793901
  801927
  806325
  807554
  818377
  820774
  823427
]
16.75 ms
(7.70%)
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
  641886
  597264
  633772
  633776
  639804
  605322
  639254
  791686
  793901
  759340
  791604
  806325
  731303
  747136
  760975
  391113
  400682
  444912
  462804
  462787
  399722
  447441
  456263
  461554
  417317
  419033
  464580
  490823
  491947
  501534
  488537
  496164
  508754
  499902
  580623
  580631
  436437
  460697
  385706
  395698
  818377
  820774
  823427
  649140
  722264
  674713
  680161
  683963
  645232
  665717
  672686
  705828
  722199
  585417
  780597
  807554
  761562
  772708
  773664
  758190
  735703
  780637
  784161
  801927
  406339
  529054
  555571
  632638
  588014
  591259
  636987
  395661
  439138
  423620
  432552
  441402
  511955
  657127
  561830
  418846
  457882
  457893
  497697
  550294
  597260
  388434
  446158
  477004
  479756
  479759
  445411
  447719
  409615
  520777
  491573
  404753
  452648
  454101
  465790
  534032
  555851
  564039
  567335
  568122
  582708
  657128
  677364
  681505
  593766
  593167
  423464
  395756
  435022
  506073
  497371
  507685
  524070
  637141
  628116
  679190
]
3.24 ms
(1.49%)
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
  385706
  388434
  391113
  395661
  395698
  395756
  399722
  400682
  404753
  406339
  409615
  417317
  418846
  419033
  423464
  423620
  432552
  435022
  436437
  439138
  441402
  444912
  445411
  446158
  447441
  447719
  452648
  454101
  456263
  457882
  457893
  460697
  461554
  462787
  462804
  464580
  465790
  477004
  479756
  479759
  488537
  490823
  491573
  491947
  496164
  497371
  497697
  499902
  501534
  506073
  507685
  508754
  511955
  520777
  524070
  529054
  534032
  550294
  555571
  555851
  561830
  564039
  567335
  568122
  580623
  580631
  582708
  585417
  588014
  591259
  593167
  593766
  597260
  597264
  605322
  628116
  632638
  633772
  633776
  636987
  637141
  639254
  639804
  641886
  645232
  649140
  657127
  657128
  665717
  672686
  674713
  677364
  679190
  680161
  681505
  683963
  705828
  722199
  722264
  731303
  735703
  747136
  758190
  759340
  760975
  761562
  772708
  773664
  780597
  780637
  784161
  791604
  791686
  793901
  801927
  806325
  807554
  818377
  820774
  823427
]
2.16 ms
(0.99%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.16 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teens first anal"
]
1.41 ms
(0.65%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teens first анал"
]
1.15 ms
(0.53%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "teens first анал"
]

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.