GET https://search.jues.net/search/embeds/6?q=homemade%20asshole

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
380.83 ms
(94.18%)
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
  389794
  428611
  435401
  441407
  441413
  451881
  452932
  459963
  462232
  468211
  471045
  471687
  475605
  478842
  480496
  480502
  487389
  490660
  492750
  497641
  498557
  499651
  509112
  510547
  511672
  515965
  519772
  540945
  541670
  546924
  548149
  553732
  564830
  566914
  576517
  579684
  582187
  585356
  591058
  592712
  595459
  605669
  606365
  608472
  619168
  621250
  639225
  642861
  646877
  647433
  654916
  656921
  657484
  660059
  662165
  687083
  687363
  691450
  703619
  704184
  704186
  710159
  712877
  716825
  721166
  726596
  726867
  727805
  728620
  728771
  734853
  736257
  740093
  743611
  749694
  750198
  751958
  756551
  758780
  758789
  759895
  761018
  761597
  762296
  763516
  763769
  765339
  765374
  765743
  766107
  767163
  768233
  769859
  770522
  773271
  775561
  778879
  778943
  781056
  783364
  788187
  788830
  788839
  790542
  791014
  794037
  794917
  796204
  797189
  797386
  799949
  802062
  803108
  804314
  804646
  808725
  809371
  813624
  814355
  814356
]
13.53 ms
(3.35%)
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
  750198
  763516
  763769
  639225
  778879
  498557
  751958
  499651
  441413
  814356
  814355
  487389
  459963
  462232
  471687
  480496
  471045
  478842
  511672
  509112
  510547
  566914
  541670
  576517
  582187
  716825
  721166
  797189
  797386
  802062
  790542
  804646
  759895
  791014
  794917
  761597
  762296
  765374
  766107
  770522
  783364
  804314
  808725
  468211
  475605
  492750
  548149
  654916
  704186
  704184
  710159
  660059
  687363
  606365
  621250
  605669
  642861
  727805
  452932
  519772
  546924
  657484
  691450
  592712
  619168
  435401
  758780
  389794
  441407
  428611
  813624
  451881
  480502
  490660
  515965
  553732
  540945
  564830
  646877
  703619
  647433
  656921
  662165
  687083
  712877
  579684
  595459
  591058
  585356
  775561
  781056
  788187
  778943
  788830
  788839
  796204
  799949
  740093
  743611
  758789
  765339
  768233
  794037
  726867
  728620
  761018
  767163
  736257
  769859
  728771
  734853
  749694
  756551
  765743
  773271
  726596
  803108
  809371
  497641
  608472
]
3.39 ms
(0.84%)
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
  389794
  428611
  435401
  441407
  441413
  451881
  452932
  459963
  462232
  468211
  471045
  471687
  475605
  478842
  480496
  480502
  487389
  490660
  492750
  497641
  498557
  499651
  509112
  510547
  511672
  515965
  519772
  540945
  541670
  546924
  548149
  553732
  564830
  566914
  576517
  579684
  582187
  585356
  591058
  592712
  595459
  605669
  606365
  608472
  619168
  621250
  639225
  642861
  646877
  647433
  654916
  656921
  657484
  660059
  662165
  687083
  687363
  691450
  703619
  704184
  704186
  710159
  712877
  716825
  721166
  726596
  726867
  727805
  728620
  728771
  734853
  736257
  740093
  743611
  749694
  750198
  751958
  756551
  758780
  758789
  759895
  761018
  761597
  762296
  763516
  763769
  765339
  765374
  765743
  766107
  767163
  768233
  769859
  770522
  773271
  775561
  778879
  778943
  781056
  783364
  788187
  788830
  788839
  790542
  791014
  794037
  794917
  796204
  797189
  797386
  799949
  802062
  803108
  804314
  804646
  808725
  809371
  813624
  814355
  814356
]
2.09 ms
(0.52%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "homemade asshole"
]
1.64 ms
(0.41%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домашн любительск asshole"
]
1.52 ms
(0.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "домашн любительск asshole"
]
1.34 ms
(0.33%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]

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.