JezK

Edit File: killed_mysql_queries.log.1

2020-06-22 10:00:39 +0000 [info] killed_thread_id:5368837 user:kickowad_kickonN host:localhost db:kickowad_kickOn_futsal command:Query time:23 query:SELECT t.*,t.`image`, el.`trial_training_id`,`p`.name,`p`.profileimage,(SELECT COUNT(`trial_training_id`) FROM trial_training_like z WHERE `z`.`trial_training_id` = `t`.id AND `z`.type='like' AND `z`.trial_training_like='1') AS countlike ,(SELECT COUNT(`trial_training_id`) FROM trial_training_like z WHERE `z`.`trial_training_id` = `t`.id AND `z`.type='favorite' AND `z`.trial_training_like='1') AS countfavorite ,(SELECT COUNT(`trial_training_id`) FROM trial_training_like z WHERE `z`.`user_id` = '17332' AND `z`.type='like' AND `z`.trial_training_like='1' AND z.`trial_training_id`= t.`id`) AS mylike,(SELECT COUNT(`trial_training_id`) FROM trial_training_like z WHERE `z`.`user_id` = '17332' AND `z`.type='favorite' AND `z`.trial_training_like='1' AND z.`trial_training_id`= t.`id`) AS myfavorite FROM trial_training t LEFT JOIN trial_training_like el ON el.`trial_training_id`= t.`id` LEFT JOIN profile_master p ON p.`user_id`= t.`user_id` WHERE ( t.`trial_date` < '2020-06-22 00:00:00') AND t.`trial_training_status`='approved' GROUP BY `t`.id ORDER BY `t`.trial_date DESC LIMIT 0, 10 2020-06-22 14:09:26 +0000 [info] killed_thread_id:5531209 user:kickowad_kickonN host:localhost db:kickowad_kickOn_futsal command:Query time:22 query:SELECT t.*,t.`image`, el.`trial_training_id`,`p`.name,`p`.profileimage,(SELECT COUNT(`trial_training_id`) FROM trial_training_like z WHERE `z`.`trial_training_id` = `t`.id AND `z`.type='like' AND `z`.trial_training_like ='1') AS countlike ,(SELECT COUNT(`trial_training_id`) FROM trial_training_like z WHERE `z`.`trial_training_id` = `t`.id AND `z`.type='favorite' AND `z`.trial_training_like ='1') AS countfavorite ,(SELECT COUNT(`trial_training_id`) FROM trial_training_like z WHERE `z`.`user_id` = '18680' AND `z`.type='like' AND `z`.trial_training_like ='1' AND z.`trial_training_id`= t.`id`) AS mylike,(SELECT COUNT(`trial_training_id`) FROM trial_training_like z WHERE `z`.`user_id` = '18680' AND `z`.type='favorite' AND `z`.trial_training_like='1' AND z.`trial_training_id`= t.`id`) AS myfavorite, (((acos(sin((16.8523973*pi()/180)) * sin((t.area_latitute*pi()/180))+cos((16.8523973*pi()/180)) * cos((t.area_latitute*pi()/180)) * cos(((74.5814773- t.area_longitute)*pi()/180))))*180/pi())*60*1.1515*1.609344) as distance FROM trial_training t LEFT JOIN trial_training_like el ON el.`trial_training_id`= t.`id` LEFT JOIN profile_master p ON p.`user_id`= t.`user_id` WHERE t.`trial_training_status`='approved' AND t.trial_date <= CURRENT_DATE GROUP BY `t`.id ORDER BY t.trial_date DESC LIMIT 0, 10