Howdy folks! My users have noticed that the dashboard has gotten increasingly slower, taking several seconds to completely load (I think historically it's always been slow, but recently people have come out of the woodwork to complain). I noticed in the MySQL "High Cost SQL Statements" most of them are a very similar SELECT COUNT or SELECT DISTINCTROW which on average takes around 3 or 4 seconds to complete.
Our setup is apache + mod_wsgi, MySQL InnoDB database. An example of the first ~20 or so rows that MySQL says are "high cost" are attached (note that times are in microseconds) Happy to provide more info, and thanks in advanced! -- Supercharge your Review Board with Power Pack: https://www.reviewboard.org/powerpack/ Want us to host Review Board for you? Check out RBCommons: https://rbcommons.com/ Happy user? Let us know! https://www.reviewboard.org/users/ --- You received this message because you are subscribed to the Google Groups "Review Board Community" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
Query,Full Table Scan,Executed (#),Errors (#),Warnings (#),Total Time,Max Time,Avg Time,Rows Sent (#),Avg. Rows Sent (#),Rows Scanned (#),Avg. Rows Scanned (#),Temp. Tables (#) SELECT COUNT ( DISTINCTROW `reviews_reviewrequest` . `id` ) FROM `reviews_reviewrequest` INNER JOIN `auth_user` ON ( `reviews_reviewrequest` . `submitter_id` = `auth_user` . `id` ) LEFT OUTER JOIN `reviews_reviewrequest_target_people` ON ( `reviews_reviewrequest` . `id` = `reviews_reviewrequest_target_people` . `reviewrequest_id` ) LEFT OUTER JOIN `reviews_reviewrequest_target_groups` ON ( `reviews_reviewrequest` . `id` = `reviews_reviewrequest_target_groups` . `reviewrequest_id` ) LEFT OUTER JOIN `accounts_profile_starred_review_requests` ON ( `reviews_reviewrequest` . `id` = `accounts_profile_starred_review_requests` . `reviewrequest_id` ) WHERE ( ( `reviews_reviewrequest` . `public` = ? OR `reviews_reviewrequest` . `submitter_id` = ? ) AND `auth_user` . `is_active` = ? AND `reviews_reviewrequest` . `status` = ? AND `reviews_reviewrequest` . `local_site_id` IS NULL AND ( `reviews_reviewrequest_target_people` . `user_id` = ? OR `reviews_reviewrequest_target_groups` . `group_id` IN (...) OR `accounts_profile_starred_review_requests` . `profile_id` = ? ) AND ,,69553,1,0,2.86803E+11,75910190.32,4123522.02,69553,1,9381694476,134886,100532 SELECT COUNT ( DISTINCTROW `reviews_reviewrequest` . `id` ) FROM `reviews_reviewrequest` INNER JOIN `auth_user` ON ( `reviews_reviewrequest` . `submitter_id` = `auth_user` . `id` ) LEFT OUTER JOIN `reviews_reviewrequest_target_people` ON ( `reviews_reviewrequest` . `id` = `reviews_reviewrequest_target_people` . `reviewrequest_id` ) LEFT OUTER JOIN `reviews_reviewrequest_target_groups` ON ( `reviews_reviewrequest` . `id` = `reviews_reviewrequest_target_groups` . `reviewrequest_id` ) LEFT OUTER JOIN `accounts_profile_starred_review_requests` ON ( `reviews_reviewrequest` . `id` = `accounts_profile_starred_review_requests` . `reviewrequest_id` ) WHERE ( ( `reviews_reviewrequest` . `public` = ? OR `reviews_reviewrequest` . `submitter_id` = ? ) AND `auth_user` . `is_active` = ? AND `reviews_reviewrequest` . `status` = ? AND `reviews_reviewrequest` . `local_site_id` IS NULL AND ( `reviews_reviewrequest_target_people` . `user_id` = ? OR `reviews_reviewrequest_target_groups` . `group_id` IN (?) OR `accounts_profile_starred_review_requests` . `profile_id` = ? ) AND ,,58915,0,0,2.42122E+11,77549288.2,4109689.27,58915,1,8210335156,139359,99326 "SELECT DISTINCTROW `reviews_reviewrequest` . `id` , `reviews_reviewrequest` . `description` , `reviews_reviewrequest` . `description_rich_text` , `reviews_reviewrequest` . `testing_done` , `reviews_reviewrequest` . `testing_done_rich_text` , `reviews_reviewrequest` . `bugs_closed` , `reviews_reviewrequest` . `branch` , `reviews_reviewrequest` . `commit_id` , `reviews_reviewrequest` . `extra_data` , `reviews_reviewrequest` . `rich_text` , `reviews_reviewrequest` . `summary` , `reviews_reviewrequest` . `submitter_id` , `reviews_reviewrequest` . `time_added` , `reviews_reviewrequest` . `last_updated` , `reviews_reviewrequest` . `status` , `reviews_reviewrequest` . `public` , `reviews_reviewrequest` . `changenum` , `reviews_reviewrequest` . `repository_id` , `reviews_reviewrequest` . `email_message_id` , `reviews_reviewrequest` . `time_emailed` , `reviews_reviewrequest` . `diffset_history_id` , `reviews_reviewrequest` . `last_review_timestamp` , `reviews_reviewrequest` . ",*,17175,0,0,1.57455E+11,181180256,9167663.68,533120,31,15093158090,878786,17567 SELECT COUNT ( DISTINCTROW `reviews_reviewrequest` . `id` ) FROM `reviews_reviewrequest` INNER JOIN `auth_user` ON ( `reviews_reviewrequest` . `submitter_id` = `auth_user` . `id` ) LEFT OUTER JOIN `reviews_reviewrequest_target_people` ON ( `reviews_reviewrequest` . `id` = `reviews_reviewrequest_target_people` . `reviewrequest_id` ) LEFT OUTER JOIN `accounts_profile_starred_review_requests` ON ( `reviews_reviewrequest` . `id` = `accounts_profile_starred_review_requests` . `reviewrequest_id` ) WHERE ( ( `reviews_reviewrequest` . `public` = ? OR `reviews_reviewrequest` . `submitter_id` = ? ) AND `auth_user` . `is_active` = ? AND `reviews_reviewrequest` . `status` = ? AND `reviews_reviewrequest` . `local_site_id` IS NULL AND ( `reviews_reviewrequest_target_people` . `user_id` = ? OR `accounts_profile_starred_review_requests` . `profile_id` = ? ) AND NOT ( `reviews_reviewrequest` . `id` IN ( SELECT `U0` . `review_request_id` FROM `accounts_reviewrequestvisit` `U0` WHERE ( `U0` . `user_id` = ? AND NOT ( `U0` . `visibility` = ? ) ) ) ) AND `reviews_reviewrequest` ,,19399,2,0,63087471732,69324864.32,3252099.17,19399,1,533684699,27511,38798 "SELECT DISTINCTROW `reviews_reviewrequest` . `id` , `reviews_reviewrequest` . `last_updated` FROM `reviews_reviewrequest` INNER JOIN `auth_user` ON ( `reviews_reviewrequest` . `submitter_id` = `auth_user` . `id` ) LEFT OUTER JOIN `reviews_reviewrequest_target_people` ON ( `reviews_reviewrequest` . `id` = `reviews_reviewrequest_target_people` . `reviewrequest_id` ) LEFT OUTER JOIN `reviews_reviewrequest_target_groups` ON ( `reviews_reviewrequest` . `id` = `reviews_reviewrequest_target_groups` . `reviewrequest_id` ) LEFT OUTER JOIN `accounts_profile_starred_review_requests` ON ( `reviews_reviewrequest` . `id` = `accounts_profile_starred_review_requests` . `reviewrequest_id` ) WHERE ( ( `reviews_reviewrequest` . `public` = ? OR `reviews_reviewrequest` . `submitter_id` = ? ) AND `auth_user` . `is_active` = ? AND `reviews_reviewrequest` . `status` = ? AND `reviews_reviewrequest` . `local_site_id` IS NULL AND ( `reviews_reviewrequest_target_people` . `user_id` = ? OR `reviews_reviewrequest_target_groups` . `group_id` IN (?) OR ",,17574,0,0,54191996056,49562287.66,3083646.07,245928,14,714540815,40659,30726 "SELECT DISTINCTROW `reviews_reviewrequest` . `id` , `reviews_reviewrequest` . `last_updated` , `reviews_reviewrequest` . `summary` FROM `reviews_reviewrequest` INNER JOIN `auth_user` ON ( `reviews_reviewrequest` . `submitter_id` = `auth_user` . `id` ) LEFT OUTER JOIN `reviews_reviewrequest_target_people` ON ( `reviews_reviewrequest` . `id` = `reviews_reviewrequest_target_people` . `reviewrequest_id` ) LEFT OUTER JOIN `reviews_reviewrequest_target_groups` ON ( `reviews_reviewrequest` . `id` = `reviews_reviewrequest_target_groups` . `reviewrequest_id` ) LEFT OUTER JOIN `accounts_profile_starred_review_requests` ON ( `reviews_reviewrequest` . `id` = `accounts_profile_starred_review_requests` . `reviewrequest_id` ) WHERE ( ( `reviews_reviewrequest` . `public` = ? OR `reviews_reviewrequest` . `submitter_id` = ? ) AND `auth_user` . `is_active` = ? AND `reviews_reviewrequest` . `status` = ? AND `reviews_reviewrequest` . `local_site_id` IS NULL AND ( `reviews_reviewrequest_target_people` . `user_id` = ? OR `reviews_reviewrequest_target_groups` . ",,16129,0,0,48868970886,33986564.38,3029882.25,197403,12,655852752,40663,27437 SELECT COUNT ( DISTINCTROW `reviews_reviewrequest` . `id` ) FROM `reviews_reviewrequest` INNER JOIN `auth_user` ON ( `reviews_reviewrequest` . `submitter_id` = `auth_user` . `id` ) LEFT OUTER JOIN `reviews_reviewrequest_target_people` ON ( `reviews_reviewrequest` . `id` = `reviews_reviewrequest_target_people` . `reviewrequest_id` ) LEFT OUTER JOIN `reviews_reviewrequest_target_groups` ON ( `reviews_reviewrequest` . `id` = `reviews_reviewrequest_target_groups` . `reviewrequest_id` ) LEFT OUTER JOIN `accounts_profile_starred_review_requests` ON ( `reviews_reviewrequest` . `id` = `accounts_profile_starred_review_requests` . `reviewrequest_id` ) WHERE ( ( `reviews_reviewrequest` . `public` = ? OR `reviews_reviewrequest` . `submitter_id` = ? ) AND `auth_user` . `is_active` = ? AND `reviews_reviewrequest` . `status` = ? AND `reviews_reviewrequest` . `local_site_id` IS NULL AND ( `reviews_reviewrequest_target_people` . `user_id` = ? OR `accounts_profile_starred_review_requests` . `profile_id` = ? ) AND NOT ( `reviews_reviewrequest` . `id` IN ( SELECT `U0` . ,,13691,0,0,47343201510,75191638.33,3457979.8,13691,1,555959787,40608,27382 "SELECT DISTINCTROW `reviews_reviewrequest` . `id` , `reviews_reviewrequest` . `last_updated` FROM `reviews_reviewrequest` INNER JOIN `auth_user` ON ( `reviews_reviewrequest` . `submitter_id` = `auth_user` . `id` ) LEFT OUTER JOIN `reviews_reviewrequest_target_people` ON ( `reviews_reviewrequest` . `id` = `reviews_reviewrequest_target_people` . `reviewrequest_id` ) LEFT OUTER JOIN `reviews_reviewrequest_target_groups` ON ( `reviews_reviewrequest` . `id` = `reviews_reviewrequest_target_groups` . `reviewrequest_id` ) LEFT OUTER JOIN `accounts_profile_starred_review_requests` ON ( `reviews_reviewrequest` . `id` = `accounts_profile_starred_review_requests` . `reviewrequest_id` ) WHERE ( ( `reviews_reviewrequest` . `public` = ? OR `reviews_reviewrequest` . `submitter_id` = ? ) AND `auth_user` . `is_active` = ? AND `reviews_reviewrequest` . `status` = ? AND `reviews_reviewrequest` . `local_site_id` IS NULL AND ( `reviews_reviewrequest_target_people` . `user_id` = ? OR `reviews_reviewrequest_target_groups` . `group_id` IN (...) OR ",,15614,0,0,47013985067,53720693.92,3011014.8,425741,27,635233634,40684,20005 "SELECT DISTINCTROW `reviews_reviewrequest` . `id` , `reviews_reviewrequest` . `last_updated` , `reviews_reviewrequest` . `time_added` FROM `reviews_reviewrequest` INNER JOIN `auth_user` ON ( `reviews_reviewrequest` . `submitter_id` = `auth_user` . `id` ) LEFT OUTER JOIN `reviews_reviewrequest_target_people` ON ( `reviews_reviewrequest` . `id` = `reviews_reviewrequest_target_people` . `reviewrequest_id` ) LEFT OUTER JOIN `reviews_reviewrequest_target_groups` ON ( `reviews_reviewrequest` . `id` = `reviews_reviewrequest_target_groups` . `reviewrequest_id` ) LEFT OUTER JOIN `accounts_profile_starred_review_requests` ON ( `reviews_reviewrequest` . `id` = `accounts_profile_starred_review_requests` . `reviewrequest_id` ) WHERE ( ( `reviews_reviewrequest` . `public` = ? OR `reviews_reviewrequest` . `submitter_id` = ? ) AND `auth_user` . `is_active` = ? AND `reviews_reviewrequest` . `status` = ? AND `reviews_reviewrequest` . `local_site_id` IS NULL AND ( `reviews_reviewrequest_target_people` . `user_id` = ? OR `reviews_reviewrequest_target_groups` . ",,13653,0,0,42395397503,69455026.91,3105207.46,308688,23,554502791,40614,23811 SELECT COUNT ( DISTINCTROW `reviews_reviewrequest` . `id` ) FROM `reviews_reviewrequest` LEFT OUTER JOIN `scmtools_repository` ON ( `reviews_reviewrequest` . `repository_id` = `scmtools_repository` . `id` ) LEFT OUTER JOIN `reviews_reviewrequest_target_groups` ON ( `reviews_reviewrequest` . `id` = `reviews_reviewrequest_target_groups` . `reviewrequest_id` ) LEFT OUTER JOIN `reviews_group` ON ( `reviews_reviewrequest_target_groups` . `group_id` = `reviews_group` . `id` ) WHERE ( `reviews_reviewrequest` . `public` = ? AND `reviews_reviewrequest` . `local_site_id` IS NULL AND ( `reviews_reviewrequest` . `repository_id` IS NULL OR `scmtools_repository` . `public` = ? ) AND ( `reviews_reviewrequest_target_groups` . `group_id` IS NULL OR `reviews_group` . `invite_only` = ? ) AND `reviews_reviewrequest` . `local_site_id` IS NULL ) ,,2384,0,0,36642528314,224237759.5,15370188.05,2384,1,2364989751,992026,2384 "SELECT DISTINCTROW `reviews_reviewrequest` . `id` , `reviews_reviewrequest` . `time_added` , `reviews_reviewrequest` . `summary` FROM `reviews_reviewrequest` INNER JOIN `auth_user` ON ( `reviews_reviewrequest` . `submitter_id` = `auth_user` . `id` ) LEFT OUTER JOIN `reviews_reviewrequest_target_people` ON ( `reviews_reviewrequest` . `id` = `reviews_reviewrequest_target_people` . `reviewrequest_id` ) LEFT OUTER JOIN `reviews_reviewrequest_target_groups` ON ( `reviews_reviewrequest` . `id` = `reviews_reviewrequest_target_groups` . `reviewrequest_id` ) LEFT OUTER JOIN `accounts_profile_starred_review_requests` ON ( `reviews_reviewrequest` . `id` = `accounts_profile_starred_review_requests` . `reviewrequest_id` ) WHERE ( ( `reviews_reviewrequest` . `public` = ? OR `reviews_reviewrequest` . `submitter_id` = ? ) AND `auth_user` . `is_active` = ? AND `reviews_reviewrequest` . `status` = ? AND `reviews_reviewrequest` . `local_site_id` IS NULL AND ( `reviews_reviewrequest_target_people` . `user_id` = ? OR `reviews_reviewrequest_target_groups` . ",,12026,0,0,35747861572,60996194.93,2972547.94,212287,18,488857769,40650,17289 "SELECT DISTINCTROW `reviews_reviewrequest` . `id` , `reviews_reviewrequest` . `last_updated` FROM `reviews_reviewrequest` LEFT OUTER JOIN `scmtools_repository` ON ( `reviews_reviewrequest` . `repository_id` = `scmtools_repository` . `id` ) LEFT OUTER JOIN `reviews_reviewrequest_target_groups` ON ( `reviews_reviewrequest` . `id` = `reviews_reviewrequest_target_groups` . `reviewrequest_id` ) LEFT OUTER JOIN `reviews_group` ON ( `reviews_reviewrequest_target_groups` . `group_id` = `reviews_group` . `id` ) WHERE ( `reviews_reviewrequest` . `public` = ? AND `reviews_reviewrequest` . `local_site_id` IS NULL AND ( `reviews_reviewrequest` . `repository_id` IS NULL OR `scmtools_repository` . `public` = ? ) AND ( `reviews_reviewrequest_target_groups` . `group_id` IS NULL OR `reviews_group` . `invite_only` = ? ) AND `reviews_reviewrequest` . `local_site_id` IS NULL ) ORDER BY `reviews_reviewrequest` . `last_updated` DESC LIMIT ? ",,2384,0,0,29915672569,88042807.71,12548520.37,119200,50,2897118530,1215234,2384 "SELECT DISTINCTROW `reviews_reviewrequest` . `id` , `reviews_reviewrequest` . `last_updated` FROM `reviews_reviewrequest` INNER JOIN `auth_user` ON ( `reviews_reviewrequest` . `submitter_id` = `auth_user` . `id` ) LEFT OUTER JOIN `reviews_reviewrequest_target_people` ON ( `reviews_reviewrequest` . `id` = `reviews_reviewrequest_target_people` . `reviewrequest_id` ) LEFT OUTER JOIN `reviews_reviewrequest_target_groups` ON ( `reviews_reviewrequest` . `id` = `reviews_reviewrequest_target_groups` . `reviewrequest_id` ) LEFT OUTER JOIN `accounts_profile_starred_review_requests` ON ( `reviews_reviewrequest` . `id` = `accounts_profile_starred_review_requests` . `reviewrequest_id` ) WHERE ( ( `reviews_reviewrequest` . `public` = ? OR `reviews_reviewrequest` . `submitter_id` = ? ) AND `auth_user` . `is_active` = ? AND `reviews_reviewrequest` . `status` = ? AND `reviews_reviewrequest` . `local_site_id` IS NULL AND ( `reviews_reviewrequest_target_people` . `user_id` = ? OR `accounts_profile_starred_review_requests` . `profile_id` = ? ) AND NOT ( ",,9569,0,0,29287502431,55186402.42,3060664.9,217826,23,387829761,40530,19138 "SELECT DISTINCTROW `reviews_reviewrequest` . `id` , `reviews_reviewrequest` . `summary` , `reviews_reviewrequest` . `last_updated` FROM `reviews_reviewrequest` INNER JOIN `auth_user` ON ( `reviews_reviewrequest` . `submitter_id` = `auth_user` . `id` ) LEFT OUTER JOIN `reviews_reviewrequest_target_people` ON ( `reviews_reviewrequest` . `id` = `reviews_reviewrequest_target_people` . `reviewrequest_id` ) LEFT OUTER JOIN `reviews_reviewrequest_target_groups` ON ( `reviews_reviewrequest` . `id` = `reviews_reviewrequest_target_groups` . `reviewrequest_id` ) LEFT OUTER JOIN `accounts_profile_starred_review_requests` ON ( `reviews_reviewrequest` . `id` = `accounts_profile_starred_review_requests` . `reviewrequest_id` ) WHERE ( ( `reviews_reviewrequest` . `public` = ? OR `reviews_reviewrequest` . `submitter_id` = ? ) AND `auth_user` . `is_active` = ? AND `reviews_reviewrequest` . `status` = ? AND `reviews_reviewrequest` . `local_site_id` IS NULL AND ( `reviews_reviewrequest_target_people` . `user_id` = ? OR `reviews_reviewrequest_target_groups` . ",,7703,0,0,23846219558,52497143.8,3095705.51,56303,7,313181368,40657,14715 SELECT COUNT ( DISTINCTROW `reviews_reviewrequest` . `id` ) FROM `reviews_reviewrequest` INNER JOIN `auth_user` ON ( `reviews_reviewrequest` . `submitter_id` = `auth_user` . `id` ) LEFT OUTER JOIN `reviews_reviewrequest_target_people` ON ( `reviews_reviewrequest` . `id` = `reviews_reviewrequest_target_people` . `reviewrequest_id` ) LEFT OUTER JOIN `reviews_reviewrequest_target_groups` ON ( `reviews_reviewrequest` . `id` = `reviews_reviewrequest_target_groups` . `reviewrequest_id` ) LEFT OUTER JOIN `accounts_profile_starred_review_requests` ON ( `reviews_reviewrequest` . `id` = `accounts_profile_starred_review_requests` . `reviewrequest_id` ) WHERE ( ( `reviews_reviewrequest` . `public` = ? OR `reviews_reviewrequest` . `submitter_id` = ? ) AND `auth_user` . `is_active` = ? AND `reviews_reviewrequest` . `status` = ? AND `reviews_reviewrequest` . `local_site_id` IS NULL AND ( `reviews_reviewrequest_target_people` . `user_id` = ? OR `accounts_profile_starred_review_requests` . `profile_id` = ? ) AND ( `reviews_reviewrequest` . `submitter_id` = ? OR ( ( ,,2235,0,0,23100104883,157773958.6,10335617.4,2235,1,2014361200,901280,2235 "SELECT DISTINCTROW `reviews_reviewrequest` . `id` , `reviews_reviewrequest` . `last_updated` , `auth_user` . `username` FROM `reviews_reviewrequest` INNER JOIN `auth_user` ON ( `reviews_reviewrequest` . `submitter_id` = `auth_user` . `id` ) LEFT OUTER JOIN `reviews_reviewrequest_target_people` ON ( `reviews_reviewrequest` . `id` = `reviews_reviewrequest_target_people` . `reviewrequest_id` ) LEFT OUTER JOIN `reviews_reviewrequest_target_groups` ON ( `reviews_reviewrequest` . `id` = `reviews_reviewrequest_target_groups` . `reviewrequest_id` ) LEFT OUTER JOIN `accounts_profile_starred_review_requests` ON ( `reviews_reviewrequest` . `id` = `accounts_profile_starred_review_requests` . `reviewrequest_id` ) WHERE ( ( `reviews_reviewrequest` . `public` = ? OR `reviews_reviewrequest` . `submitter_id` = ? ) AND `auth_user` . `is_active` = ? AND `reviews_reviewrequest` . `status` = ? AND `reviews_reviewrequest` . `local_site_id` IS NULL AND ( `reviews_reviewrequest_target_people` . `user_id` = ? OR `reviews_reviewrequest_target_groups` . `group_id` IN ( ? ",,7234,0,0,22207185384,18547638.87,3069834.86,333009,46,293594327,40585,14436 SELECT COUNT ( DISTINCTROW `reviews_reviewrequest` . `id` ) FROM `reviews_reviewrequest` INNER JOIN `auth_user` ON ( `reviews_reviewrequest` . `submitter_id` = `auth_user` . `id` ) LEFT OUTER JOIN `reviews_reviewrequest_target_people` ON ( `reviews_reviewrequest` . `id` = `reviews_reviewrequest_target_people` . `reviewrequest_id` ) LEFT OUTER JOIN `accounts_profile_starred_review_requests` ON ( `reviews_reviewrequest` . `id` = `accounts_profile_starred_review_requests` . `reviewrequest_id` ) WHERE ( ( `reviews_reviewrequest` . `public` = ? OR `reviews_reviewrequest` . `submitter_id` = ? ) AND `auth_user` . `is_active` = ? AND `reviews_reviewrequest` . `status` = ? AND `reviews_reviewrequest` . `local_site_id` IS NULL AND ( `reviews_reviewrequest_target_people` . `user_id` = ? OR `accounts_profile_starred_review_requests` . `profile_id` = ? ) AND `reviews_reviewrequest` . `local_site_id` IS NULL ) ,,6973,0,0,21386737166,48861700.15,3067078.33,6973,1,191762777,27501,6973 "SELECT DISTINCTROW `reviews_reviewrequest` . `id` , `reviews_reviewrequest` . `time_added` , `reviews_reviewrequest` . `last_updated` FROM `reviews_reviewrequest` INNER JOIN `auth_user` ON ( `reviews_reviewrequest` . `submitter_id` = `auth_user` . `id` ) LEFT OUTER JOIN `reviews_reviewrequest_target_people` ON ( `reviews_reviewrequest` . `id` = `reviews_reviewrequest_target_people` . `reviewrequest_id` ) LEFT OUTER JOIN `reviews_reviewrequest_target_groups` ON ( `reviews_reviewrequest` . `id` = `reviews_reviewrequest_target_groups` . `reviewrequest_id` ) LEFT OUTER JOIN `accounts_profile_starred_review_requests` ON ( `reviews_reviewrequest` . `id` = `accounts_profile_starred_review_requests` . `reviewrequest_id` ) WHERE ( ( `reviews_reviewrequest` . `public` = ? OR `reviews_reviewrequest` . `submitter_id` = ? ) AND `auth_user` . `is_active` = ? AND `reviews_reviewrequest` . `status` = ? AND `reviews_reviewrequest` . `local_site_id` IS NULL AND ( `reviews_reviewrequest_target_people` . `user_id` = ? OR `reviews_reviewrequest_target_groups` . ",,6167,0,0,19537671081,47342033.04,3168099.74,151610,25,250473118,40615,8361
