GET https://search.jues.net/search/embeds/5?q=doggystyle%20ass

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
203.25 ms
(88.41%)
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
  92019
  229704
  337190
  385073
  418553
  422005
  423550
  438032
  441748
  443493
  444236
  450139
  452662
  454472
  455165
  455649
  459323
  475177
  478709
  482876
  500877
  508265
  526871
  529699
  540132
  544979
  545030
  545303
  546620
  551588
  551729
  554862
  555672
  574469
  577267
  578535
  579977
  584170
  584583
  585571
  588531
  588618
  590041
  592149
  605180
  605924
  616832
  617509
  618494
  625360
  628596
  630704
  631113
  633856
  635860
  636050
  636062
  636505
  640319
  640827
  642176
  643071
  646052
  646624
  646719
  662394
  662925
  675581
  676430
  686101
  691432
  697219
  700930
  707149
  707457
  708052
  708194
  708254
  711327
  713473
  715952
  716669
  717187
  724396
  726920
  727535
  728225
  733041
  733995
  735581
  738836
  739906
  740175
  740959
  742312
  743806
  750342
  759702
  760241
  760874
  761314
  761698
  766600
  769287
  774610
  778410
  782594
  783671
  784197
  785962
  789927
  791531
  794877
  795998
  796158
  800390
  800586
  802806
  812359
  824031
]
15.86 ms
(6.90%)
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
  691432
  707149
  716669
  577267
  584583
  592149
  625360
  636050
  640319
  588531
  630704
  631113
  618494
  633856
  636505
  789927
  800586
  794877
  750342
  760241
  784197
  726920
  733041
  739906
  760874
  724396
  740175
  769287
  738836
  761314
  635860
  697219
  713473
  778410
  785962
  791531
  802806
  812359
  455165
  508265
  422005
  454472
  545030
  642176
  616832
  766600
  795998
  735581
  733995
  743806
  759702
  92019
  686101
  590041
  443493
  700930
  782594
  727535
  475177
  455649
  482876
  418553
  450139
  540132
  551729
  584170
  554862
  646624
  717187
  585571
  728225
  761698
  441748
  438032
  444236
  526871
  544979
  551588
  742312
  800390
  452662
  385073
  229704
  337190
  423550
  824031
  478709
  459323
  500877
  529699
  555672
  578535
  546620
  574469
  579977
  646052
  646719
  708194
  708254
  711327
  675581
  707457
  708052
  662394
  662925
  676430
  715952
  545303
  628596
  605924
  640827
  643071
  636062
  588618
  605180
  617509
  796158
  774610
  783671
  740959
]
3.29 ms
(1.43%)
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
  92019
  229704
  337190
  385073
  418553
  422005
  423550
  438032
  441748
  443493
  444236
  450139
  452662
  454472
  455165
  455649
  459323
  475177
  478709
  482876
  500877
  508265
  526871
  529699
  540132
  544979
  545030
  545303
  546620
  551588
  551729
  554862
  555672
  574469
  577267
  578535
  579977
  584170
  584583
  585571
  588531
  588618
  590041
  592149
  605180
  605924
  616832
  617509
  618494
  625360
  628596
  630704
  631113
  633856
  635860
  636050
  636062
  636505
  640319
  640827
  642176
  643071
  646052
  646624
  646719
  662394
  662925
  675581
  676430
  686101
  691432
  697219
  700930
  707149
  707457
  708052
  708194
  708254
  711327
  713473
  715952
  716669
  717187
  724396
  726920
  727535
  728225
  733041
  733995
  735581
  738836
  739906
  740175
  740959
  742312
  743806
  750342
  759702
  760241
  760874
  761314
  761698
  766600
  769287
  774610
  778410
  782594
  783671
  784197
  785962
  789927
  791531
  794877
  795998
  796158
  800390
  800586
  802806
  812359
  824031
]
2.21 ms
(0.96%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "doggystyle жоп"
]
2.07 ms
(0.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "doggystyle ass"
]
1.65 ms
(0.72%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.56 ms
(0.68%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "doggystyle жоп"
]

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.