Explain Statement

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	users		ALL	PRIMARY,un_user_id,un_account_verified,un_row_status				904	95.26	Using where; Using temporary; Using filesort
1	PRIMARY	eu		eq_ref	by_user_id,entity_id_idx	by_user_id	4	socialcxn_live_v1.users.id	1	100	
1	PRIMARY	users_role		ref	user_id_idx	user_id_idx	4	socialcxn_live_v1.users.id	1	100	
1	PRIMARY	roles		eq_ref	PRIMARY,sr_id	PRIMARY	4	socialcxn_live_v1.users_role.role_id	1	100	
1	PRIMARY	influencers		eq_ref	PRIMARY,en_entity_id,created_by_idx,updated_by_idx,industry_id_idx,rating_list,en_enitity_name,en_entity_type,en_country_id,en_city_id,en_state_id,en_profile_pic_id,en_total_rating_cout,en_row_status	PRIMARY	4	socialcxn_live_v1.eu.entity_id	1	94.88	Using where
1	PRIMARY	rating		eq_ref	PRIMARY,cxnrank_id	PRIMARY	4	socialcxn_live_v1.influencers.rating_id	1	100	
1	PRIMARY	countries		eq_ref	PRIMARY,co_country_id	PRIMARY	4	socialcxn_live_v1.influencers.country_id	1	100	Using where
1	PRIMARY	states		eq_ref	PRIMARY,st_state_id	PRIMARY	4	socialcxn_live_v1.influencers.states_id	1	100	Using where
1	PRIMARY	cities		eq_ref	PRIMARY,ct_city_id	PRIMARY	4	socialcxn_live_v1.influencers.city_id	1	100	Using where
1	PRIMARY	influencers_audience_location		ref	inf_audloc_id	inf_audloc_id	5	socialcxn_live_v1.users.id	2	100	
1	PRIMARY	audience_countries		eq_ref	PRIMARY,co_country_id	PRIMARY	4	socialcxn_live_v1.influencers_audience_location.country_id	1	100	
1	PRIMARY	audience_states		eq_ref	PRIMARY,st_state_id	PRIMARY	4	socialcxn_live_v1.influencers_audience_location.state_id	1	100	
1	PRIMARY	audience_cities		eq_ref	PRIMARY,ct_city_id	PRIMARY	4	socialcxn_live_v1.influencers_audience_location.city_id	1	100	
1	PRIMARY	influencer_interests		ref	interest_entity_id	interest_entity_id	5	socialcxn_live_v1.eu.entity_id	4	100	
1	PRIMARY	interest_groups		eq_ref	PRIMARY,ig_id	PRIMARY	4	socialcxn_live_v1.influencer_interests.interest_groups_id	1	100	
1	PRIMARY	social_stats		ref	fk_influencer_socialstats_user_id	fk_influencer_socialstats_user_id	5	socialcxn_live_v1.users.id	2	100	
1	PRIMARY	setup_socialmedia_channels		eq_ref	PRIMARY,smc_id	PRIMARY	4	socialcxn_live_v1.social_stats.setup_socialmedia_channel_id	1	100	
1	PRIMARY	social_engagement_levels		eq_ref	PRIMARY,el_id	PRIMARY	4	socialcxn_live_v1.social_stats.setup_social_engagement_rate_id	1	100	Using where; Using index
1	PRIMARY	influencer_objectives		ref	entity_id	entity_id	5	socialcxn_live_v1.eu.entity_id	1	100	
1	PRIMARY	setup_influencer_types		eq_ref	PRIMARY,sit_id	PRIMARY	4	socialcxn_live_v1.influencer_objectives.objectives_id	1	100	Using index
1	PRIMARY	profile_attachments		eq_ref	PRIMARY,fa_id	PRIMARY	4	socialcxn_live_v1.influencers.profile_pic_id	1	100	Using index
1	PRIMARY	profile_attachments_thumbnails		ref	file_attachments_id	file_attachments_id	4	socialcxn_live_v1.profile_attachments.id	5	100	Using index
36	DEPENDENT SUBQUERY	favourite_influencers		ref	fav_entity_id,fav_influencer_user_id	fav_entity_id	5	const	1	10	Using where
35	DEPENDENT SUBQUERY	ssc		ref	PRIMARY,smc_id,smc_code_name	smc_code_name	48	const	1	100	Using index; Using temporary; Using filesort
35	DEPENDENT SUBQUERY	social_influencers		eq_ref	PRIMARY,en_entity_id	PRIMARY	4	func	1	100	Using index
35	DEPENDENT SUBQUERY	seu		ref	by_user_id,entity_id_idx	entity_id_idx	4	func	1	100	Using index condition
35	DEPENDENT SUBQUERY	social_users		eq_ref	PRIMARY,un_user_id	PRIMARY	4	socialcxn_live_v1.seu.user_id	1	100	Using index
35	DEPENDENT SUBQUERY	sss		ref	fk_fk_socialmedia_channel_id,fk_influencer_socialstats_user_id	fk_influencer_socialstats_user_id	5	socialcxn_live_v1.seu.user_id	2	20	Using where
35	DEPENDENT SUBQUERY	social_engagement_levels		eq_ref	PRIMARY,el_id	PRIMARY	4	socialcxn_live_v1.sss.setup_social_engagement_rate_id	1	100	Using where
34	DEPENDENT SUBQUERY	ssc		ref	PRIMARY,smc_id,smc_code_name	smc_code_name	48	const	1	100	Using index; Using temporary; Using filesort
34	DEPENDENT SUBQUERY	social_influencers		eq_ref	PRIMARY,en_entity_id	PRIMARY	4	func	1	100	Using index
34	DEPENDENT SUBQUERY	seu		ref	by_user_id,entity_id_idx	entity_id_idx	4	func	1	100	Using index condition
34	DEPENDENT SUBQUERY	social_users		eq_ref	PRIMARY,un_user_id	PRIMARY	4	socialcxn_live_v1.seu.user_id	1	100	Using index
34	DEPENDENT SUBQUERY	sss		ref	fk_fk_socialmedia_channel_id,fk_influencer_socialstats_user_id	fk_influencer_socialstats_user_id	5	socialcxn_live_v1.seu.user_id	2	20	Using where
34	DEPENDENT SUBQUERY	social_engagement_levels		eq_ref	PRIMARY,el_id	PRIMARY	4	socialcxn_live_v1.sss.setup_social_engagement_rate_id	1	100	Using where
33	DEPENDENT SUBQUERY	ssc		ref	PRIMARY,smc_id,smc_code_name	smc_code_name	48	const	1	100	Using index; Using temporary; Using filesort
33	DEPENDENT SUBQUERY	social_influencers		eq_ref	PRIMARY,en_entity_id	PRIMARY	4	func	1	100	Using index
33	DEPENDENT SUBQUERY	seu		ref	by_user_id,entity_id_idx	entity_id_idx	4	func	1	100	Using index condition
33	DEPENDENT SUBQUERY	social_users		eq_ref	PRIMARY,un_user_id	PRIMARY	4	socialcxn_live_v1.seu.user_id	1	100	Using index
33	DEPENDENT SUBQUERY	sss		ref	fk_fk_socialmedia_channel_id,fk_influencer_socialstats_user_id	fk_influencer_socialstats_user_id	5	socialcxn_live_v1.seu.user_id	2	20	Using where
33	DEPENDENT SUBQUERY	social_engagement_levels		eq_ref	PRIMARY,el_id	PRIMARY	4	socialcxn_live_v1.sss.setup_social_engagement_rate_id	1	100	Using where; Using index
32	DEPENDENT SUBQUERY	ssc		ref	PRIMARY,smc_id,smc_code_name	smc_code_name	48	const	1	100	Using index; Using temporary; Using filesort
32	DEPENDENT SUBQUERY	social_influencers		eq_ref	PRIMARY,en_entity_id	PRIMARY	4	func	1	100	Using index
32	DEPENDENT SUBQUERY	seu		ref	by_user_id,entity_id_idx	entity_id_idx	4	func	1	100	Using index condition
32	DEPENDENT SUBQUERY	social_users		eq_ref	PRIMARY,un_user_id	PRIMARY	4	socialcxn_live_v1.seu.user_id	1	100	Using index
32	DEPENDENT SUBQUERY	sss		ref	fk_fk_socialmedia_channel_id,fk_influencer_socialstats_user_id	fk_influencer_socialstats_user_id	5	socialcxn_live_v1.seu.user_id	2	20	Using where
32	DEPENDENT SUBQUERY	social_engagement_levels		eq_ref	PRIMARY,el_id	PRIMARY	4	socialcxn_live_v1.sss.setup_social_engagement_rate_id	1	100	Using where
31	DEPENDENT SUBQUERY	ssc		ref	PRIMARY,smc_id,smc_code_name	smc_code_name	48	const	1	100	Using index; Using temporary; Using filesort
31	DEPENDENT SUBQUERY	social_influencers		eq_ref	PRIMARY,en_entity_id	PRIMARY	4	func	1	100	Using index
31	DEPENDENT SUBQUERY	seu		ref	by_user_id,entity_id_idx	entity_id_idx	4	func	1	100	Using index condition
31	DEPENDENT SUBQUERY	social_users		eq_ref	PRIMARY,un_user_id	PRIMARY	4	socialcxn_live_v1.seu.user_id	1	100	Using index
31	DEPENDENT SUBQUERY	sss		ref	fk_fk_socialmedia_channel_id,fk_influencer_socialstats_user_id	fk_influencer_socialstats_user_id	5	socialcxn_live_v1.seu.user_id	2	20	Using where
31	DEPENDENT SUBQUERY	social_engagement_levels		eq_ref	PRIMARY,el_id	PRIMARY	4	socialcxn_live_v1.sss.setup_social_engagement_rate_id	1	100	Using where
30	DEPENDENT SUBQUERY	ssc		ref	PRIMARY,smc_id,smc_code_name	smc_code_name	48	const	1	100	Using index; Using temporary; Using filesort
30	DEPENDENT SUBQUERY	social_influencers		eq_ref	PRIMARY,en_entity_id	PRIMARY	4	func	1	100	Using index
30	DEPENDENT SUBQUERY	seu		ref	by_user_id,entity_id_idx	entity_id_idx	4	func	1	100	Using index condition
30	DEPENDENT SUBQUERY	social_users		eq_ref	PRIMARY,un_user_id	PRIMARY	4	socialcxn_live_v1.seu.user_id	1	100	Using index
30	DEPENDENT SUBQUERY	sss		ref	fk_fk_socialmedia_channel_id,fk_influencer_socialstats_user_id	fk_influencer_socialstats_user_id	5	socialcxn_live_v1.seu.user_id	2	20	Using where
30	DEPENDENT SUBQUERY	social_engagement_levels		eq_ref	PRIMARY,el_id	PRIMARY	4	socialcxn_live_v1.sss.setup_social_engagement_rate_id	1	100	Using where; Using index
29	DEPENDENT SUBQUERY	ssc		ref	PRIMARY,smc_id,smc_code_name	smc_code_name	48	const	1	100	Using index; Using temporary; Using filesort
29	DEPENDENT SUBQUERY	social_influencers		eq_ref	PRIMARY,en_entity_id	PRIMARY	4	func	1	100	Using index
29	DEPENDENT SUBQUERY	seu		ref	by_user_id,entity_id_idx	entity_id_idx	4	func	1	100	Using index condition
29	DEPENDENT SUBQUERY	social_users		eq_ref	PRIMARY,un_user_id	PRIMARY	4	socialcxn_live_v1.seu.user_id	1	100	Using index
29	DEPENDENT SUBQUERY	sss		ref	fk_fk_socialmedia_channel_id,fk_influencer_socialstats_user_id	fk_influencer_socialstats_user_id	5	socialcxn_live_v1.seu.user_id	2	20	Using where
29	DEPENDENT SUBQUERY	social_engagement_levels		eq_ref	PRIMARY,el_id	PRIMARY	4	socialcxn_live_v1.sss.setup_social_engagement_rate_id	1	100	Using where
28	DEPENDENT SUBQUERY	ssc		ref	PRIMARY,smc_id,smc_code_name	smc_code_name	48	const	1	100	Using index; Using temporary; Using filesort
28	DEPENDENT SUBQUERY	social_influencers		eq_ref	PRIMARY,en_entity_id	PRIMARY	4	func	1	100	Using index
28	DEPENDENT SUBQUERY	seu		ref	by_user_id,entity_id_idx	entity_id_idx	4	func	1	100	Using index condition
28	DEPENDENT SUBQUERY	social_users		eq_ref	PRIMARY,un_user_id	PRIMARY	4	socialcxn_live_v1.seu.user_id	1	100	Using index
28	DEPENDENT SUBQUERY	sss		ref	fk_fk_socialmedia_channel_id,fk_influencer_socialstats_user_id	fk_influencer_socialstats_user_id	5	socialcxn_live_v1.seu.user_id	2	20	Using where
28	DEPENDENT SUBQUERY	social_engagement_levels		eq_ref	PRIMARY,el_id	PRIMARY	4	socialcxn_live_v1.sss.setup_social_engagement_rate_id	1	100	Using where
27	DEPENDENT SUBQUERY	ssc		ref	PRIMARY,smc_id,smc_code_name	smc_code_name	48	const	1	100	Using index; Using temporary; Using filesort
27	DEPENDENT SUBQUERY	social_influencers		eq_ref	PRIMARY,en_entity_id	PRIMARY	4	func	1	100	Using index
27	DEPENDENT SUBQUERY	seu		ref	by_user_id,entity_id_idx	entity_id_idx	4	func	1	100	Using index condition
27	DEPENDENT SUBQUERY	social_users		eq_ref	PRIMARY,un_user_id	PRIMARY	4	socialcxn_live_v1.seu.user_id	1	100	Using index
27	DEPENDENT SUBQUERY	sss		ref	fk_fk_socialmedia_channel_id,fk_influencer_socialstats_user_id	fk_influencer_socialstats_user_id	5	socialcxn_live_v1.seu.user_id	2	20	Using where
27	DEPENDENT SUBQUERY	social_engagement_levels		eq_ref	PRIMARY,el_id	PRIMARY	4	socialcxn_live_v1.sss.setup_social_engagement_rate_id	1	100	Using where; Using index
26	DEPENDENT SUBQUERY	ssc		ref	PRIMARY,smc_id,smc_code_name	smc_code_name	48	const	1	100	Using index; Using temporary; Using filesort
26	DEPENDENT SUBQUERY	social_influencers		eq_ref	PRIMARY,en_entity_id	PRIMARY	4	func	1	100	Using index
26	DEPENDENT SUBQUERY	seu		ref	by_user_id,entity_id_idx	entity_id_idx	4	func	1	100	Using index condition
26	DEPENDENT SUBQUERY	social_users		eq_ref	PRIMARY,un_user_id	PRIMARY	4	socialcxn_live_v1.seu.user_id	1	100	Using index
26	DEPENDENT SUBQUERY	sss		ref	fk_fk_socialmedia_channel_id,fk_influencer_socialstats_user_id	fk_influencer_socialstats_user_id	5	socialcxn_live_v1.seu.user_id	2	20	Using where
26	DEPENDENT SUBQUERY	social_engagement_levels		eq_ref	PRIMARY,el_id	PRIMARY	4	socialcxn_live_v1.sss.setup_social_engagement_rate_id	1	100	Using where
25	DEPENDENT SUBQUERY	ssc		ref	PRIMARY,smc_id,smc_code_name	smc_code_name	48	const	1	100	Using index; Using temporary; Using filesort
25	DEPENDENT SUBQUERY	social_influencers		eq_ref	PRIMARY,en_entity_id	PRIMARY	4	func	1	100	Using index
25	DEPENDENT SUBQUERY	seu		ref	by_user_id,entity_id_idx	entity_id_idx	4	func	1	100	Using index condition
25	DEPENDENT SUBQUERY	social_users		eq_ref	PRIMARY,un_user_id	PRIMARY	4	socialcxn_live_v1.seu.user_id	1	100	Using index
25	DEPENDENT SUBQUERY	sss		ref	fk_fk_socialmedia_channel_id,fk_influencer_socialstats_user_id	fk_influencer_socialstats_user_id	5	socialcxn_live_v1.seu.user_id	2	20	Using where
25	DEPENDENT SUBQUERY	social_engagement_levels		eq_ref	PRIMARY,el_id	PRIMARY	4	socialcxn_live_v1.sss.setup_social_engagement_rate_id	1	100	Using where
24	DEPENDENT SUBQUERY	ssc		ref	PRIMARY,smc_id,smc_code_name	smc_code_name	48	const	1	100	Using index; Using temporary; Using filesort
24	DEPENDENT SUBQUERY	social_influencers		eq_ref	PRIMARY,en_entity_id	PRIMARY	4	func	1	100	Using index
24	DEPENDENT SUBQUERY	seu		ref	by_user_id,entity_id_idx	entity_id_idx	4	func	1	100	Using index condition
24	DEPENDENT SUBQUERY	social_users		eq_ref	PRIMARY,un_user_id	PRIMARY	4	socialcxn_live_v1.seu.user_id	1	100	Using index
24	DEPENDENT SUBQUERY	sss		ref	fk_fk_socialmedia_channel_id,fk_influencer_socialstats_user_id	fk_influencer_socialstats_user_id	5	socialcxn_live_v1.seu.user_id	2	20	Using where
24	DEPENDENT SUBQUERY	social_engagement_levels		eq_ref	PRIMARY,el_id	PRIMARY	4	socialcxn_live_v1.sss.setup_social_engagement_rate_id	1	100	Using where; Using index
23	DEPENDENT SUBQUERY	ssc		ref	PRIMARY,smc_id,smc_code_name	smc_code_name	48	const	1	100	Using index; Using temporary; Using filesort
23	DEPENDENT SUBQUERY	social_influencers		eq_ref	PRIMARY,en_entity_id	PRIMARY	4	func	1	100	Using index
23	DEPENDENT SUBQUERY	seu		ref	by_user_id,entity_id_idx	entity_id_idx	4	func	1	100	Using index condition
23	DEPENDENT SUBQUERY	social_users		eq_ref	PRIMARY,un_user_id	PRIMARY	4	socialcxn_live_v1.seu.user_id	1	100	Using index
23	DEPENDENT SUBQUERY	sss		ref	fk_fk_socialmedia_channel_id,fk_influencer_socialstats_user_id	fk_influencer_socialstats_user_id	5	socialcxn_live_v1.seu.user_id	2	20	Using where
23	DEPENDENT SUBQUERY	social_engagement_levels		eq_ref	PRIMARY,el_id	PRIMARY	4	socialcxn_live_v1.sss.setup_social_engagement_rate_id	1	100	Using where
22	DEPENDENT SUBQUERY	ssc		ref	PRIMARY,smc_id,smc_code_name	smc_code_name	48	const	1	100	Using index; Using temporary; Using filesort
22	DEPENDENT SUBQUERY	social_influencers		eq_ref	PRIMARY,en_entity_id	PRIMARY	4	func	1	100	Using index
22	DEPENDENT SUBQUERY	seu		ref	by_user_id,entity_id_idx	entity_id_idx	4	func	1	100	Using index condition
22	DEPENDENT SUBQUERY	social_users		eq_ref	PRIMARY,un_user_id	PRIMARY	4	socialcxn_live_v1.seu.user_id	1	100	Using index
22	DEPENDENT SUBQUERY	sss		ref	fk_fk_socialmedia_channel_id,fk_influencer_socialstats_user_id	fk_influencer_socialstats_user_id	5	socialcxn_live_v1.seu.user_id	2	20	Using where
22	DEPENDENT SUBQUERY	social_engagement_levels		eq_ref	PRIMARY,el_id	PRIMARY	4	socialcxn_live_v1.sss.setup_social_engagement_rate_id	1	100	Using where
21	DEPENDENT SUBQUERY	ssc		ref	PRIMARY,smc_id,smc_code_name	smc_code_name	48	const	1	100	Using index; Using temporary; Using filesort
21	DEPENDENT SUBQUERY	social_influencers		eq_ref	PRIMARY,en_entity_id	PRIMARY	4	func	1	100	Using index
21	DEPENDENT SUBQUERY	seu		ref	by_user_id,entity_id_idx	entity_id_idx	4	func	1	100	Using index condition
21	DEPENDENT SUBQUERY	social_users		eq_ref	PRIMARY,un_user_id	PRIMARY	4	socialcxn_live_v1.seu.user_id	1	100	Using index
21	DEPENDENT SUBQUERY	sss		ref	fk_fk_socialmedia_channel_id,fk_influencer_socialstats_user_id	fk_influencer_socialstats_user_id	5	socialcxn_live_v1.seu.user_id	2	20	Using where
21	DEPENDENT SUBQUERY	social_engagement_levels		eq_ref	PRIMARY,el_id	PRIMARY	4	socialcxn_live_v1.sss.setup_social_engagement_rate_id	1	100	Using where; Using index
20	DEPENDENT SUBQUERY	ssc		ref	PRIMARY,smc_id,smc_code_name	smc_code_name	48	const	1	100	Using index; Using temporary; Using filesort
20	DEPENDENT SUBQUERY	social_influencers		eq_ref	PRIMARY,en_entity_id	PRIMARY	4	func	1	100	Using index
20	DEPENDENT SUBQUERY	seu		ref	by_user_id,entity_id_idx	entity_id_idx	4	func	1	100	Using index condition
20	DEPENDENT SUBQUERY	social_users		eq_ref	PRIMARY,un_user_id	PRIMARY	4	socialcxn_live_v1.seu.user_id	1	100	Using index
20	DEPENDENT SUBQUERY	sss		ref	fk_fk_socialmedia_channel_id,fk_influencer_socialstats_user_id	fk_influencer_socialstats_user_id	5	socialcxn_live_v1.seu.user_id	2	20	Using where
20	DEPENDENT SUBQUERY	social_engagement_levels		eq_ref	PRIMARY,el_id	PRIMARY	4	socialcxn_live_v1.sss.setup_social_engagement_rate_id	1	100	Using where
19	DEPENDENT SUBQUERY	ssc		ref	PRIMARY,smc_id,smc_code_name	smc_code_name	48	const	1	100	Using index; Using temporary; Using filesort
19	DEPENDENT SUBQUERY	social_influencers		eq_ref	PRIMARY,en_entity_id	PRIMARY	4	func	1	100	Using index
19	DEPENDENT SUBQUERY	seu		ref	by_user_id,entity_id_idx	entity_id_idx	4	func	1	100	Using index condition
19	DEPENDENT SUBQUERY	social_users		eq_ref	PRIMARY,un_user_id	PRIMARY	4	socialcxn_live_v1.seu.user_id	1	100	Using index
19	DEPENDENT SUBQUERY	sss		ref	fk_fk_socialmedia_channel_id,fk_influencer_socialstats_user_id	fk_influencer_socialstats_user_id	5	socialcxn_live_v1.seu.user_id	2	20	Using where
19	DEPENDENT SUBQUERY	social_engagement_levels		eq_ref	PRIMARY,el_id	PRIMARY	4	socialcxn_live_v1.sss.setup_social_engagement_rate_id	1	100	Using where
18	DEPENDENT SUBQUERY	ssc		ref	PRIMARY,smc_id,smc_code_name	smc_code_name	48	const	1	100	Using index; Using temporary; Using filesort
18	DEPENDENT SUBQUERY	social_influencers		eq_ref	PRIMARY,en_entity_id	PRIMARY	4	func	1	100	Using index
18	DEPENDENT SUBQUERY	seu		ref	by_user_id,entity_id_idx	entity_id_idx	4	func	1	100	Using index condition
18	DEPENDENT SUBQUERY	social_users		eq_ref	PRIMARY,un_user_id	PRIMARY	4	socialcxn_live_v1.seu.user_id	1	100	Using index
18	DEPENDENT SUBQUERY	sss		ref	fk_fk_socialmedia_channel_id,fk_influencer_socialstats_user_id	fk_influencer_socialstats_user_id	5	socialcxn_live_v1.seu.user_id	2	20	Using where
18	DEPENDENT SUBQUERY	social_engagement_levels		eq_ref	PRIMARY,el_id	PRIMARY	4	socialcxn_live_v1.sss.setup_social_engagement_rate_id	1	100	Using where; Using index
17	DEPENDENT SUBQUERY	ssc		ref	PRIMARY,smc_id,smc_code_name	smc_code_name	48	const	1	100	Using index; Using temporary; Using filesort
17	DEPENDENT SUBQUERY	social_influencers		eq_ref	PRIMARY,en_entity_id	PRIMARY	4	func	1	100	Using index
17	DEPENDENT SUBQUERY	seu		ref	by_user_id,entity_id_idx	entity_id_idx	4	func	1	100	Using index condition
17	DEPENDENT SUBQUERY	social_users		eq_ref	PRIMARY,un_user_id	PRIMARY	4	socialcxn_live_v1.seu.user_id	1	100	Using index
17	DEPENDENT SUBQUERY	sss		ref	fk_fk_socialmedia_channel_id,fk_influencer_socialstats_user_id	fk_influencer_socialstats_user_id	5	socialcxn_live_v1.seu.user_id	2	20	Using where
17	DEPENDENT SUBQUERY	social_engagement_levels		eq_ref	PRIMARY,el_id	PRIMARY	4	socialcxn_live_v1.sss.setup_social_engagement_rate_id	1	100	Using where
16	DEPENDENT SUBQUERY	ssc		ref	PRIMARY,smc_id,smc_code_name	smc_code_name	48	const	1	100	Using index; Using temporary; Using filesort
16	DEPENDENT SUBQUERY	social_influencers		eq_ref	PRIMARY,en_entity_id	PRIMARY	4	func	1	100	Using index
16	DEPENDENT SUBQUERY	seu		ref	by_user_id,entity_id_idx	entity_id_idx	4	func	1	100	Using index condition
16	DEPENDENT SUBQUERY	social_users		eq_ref	PRIMARY,un_user_id	PRIMARY	4	socialcxn_live_v1.seu.user_id	1	100	Using index
16	DEPENDENT SUBQUERY	sss		ref	fk_fk_socialmedia_channel_id,fk_influencer_socialstats_user_id	fk_influencer_socialstats_user_id	5	socialcxn_live_v1.seu.user_id	2	20	Using where
16	DEPENDENT SUBQUERY	social_engagement_levels		eq_ref	PRIMARY,el_id	PRIMARY	4	socialcxn_live_v1.sss.setup_social_engagement_rate_id	1	100	Using where
15	DEPENDENT SUBQUERY	ssc		ref	PRIMARY,smc_id,smc_code_name	smc_code_name	48	const	1	100	Using index; Using temporary; Using filesort
15	DEPENDENT SUBQUERY	social_influencers		eq_ref	PRIMARY,en_entity_id	PRIMARY	4	func	1	100	Using index
15	DEPENDENT SUBQUERY	seu		ref	by_user_id,entity_id_idx	entity_id_idx	4	func	1	100	Using index condition
15	DEPENDENT SUBQUERY	social_users		eq_ref	PRIMARY,un_user_id	PRIMARY	4	socialcxn_live_v1.seu.user_id	1	100	Using index
15	DEPENDENT SUBQUERY	sss		ref	fk_fk_socialmedia_channel_id,fk_influencer_socialstats_user_id	fk_influencer_socialstats_user_id	5	socialcxn_live_v1.seu.user_id	2	20	Using where
15	DEPENDENT SUBQUERY	social_engagement_levels		eq_ref	PRIMARY,el_id	PRIMARY	4	socialcxn_live_v1.sss.setup_social_engagement_rate_id	1	100	Using where; Using index
14	DEPENDENT SUBQUERY	ssc		ref	PRIMARY,smc_id,smc_code_name	smc_code_name	48	const	1	100	Using index; Using temporary; Using filesort
14	DEPENDENT SUBQUERY	social_influencers		eq_ref	PRIMARY,en_entity_id	PRIMARY	4	func	1	100	Using index
14	DEPENDENT SUBQUERY	seu		ref	by_user_id,entity_id_idx	entity_id_idx	4	func	1	100	Using index condition
14	DEPENDENT SUBQUERY	social_users		eq_ref	PRIMARY,un_user_id	PRIMARY	4	socialcxn_live_v1.seu.user_id	1	100	Using index
14	DEPENDENT SUBQUERY	sss		ref	fk_fk_socialmedia_channel_id,fk_influencer_socialstats_user_id	fk_influencer_socialstats_user_id	5	socialcxn_live_v1.seu.user_id	2	20	Using where
14	DEPENDENT SUBQUERY	social_engagement_levels		eq_ref	PRIMARY,el_id	PRIMARY	4	socialcxn_live_v1.sss.setup_social_engagement_rate_id	1	100	Using where
13	DEPENDENT SUBQUERY	ssc		ref	PRIMARY,smc_id,smc_code_name	smc_code_name	48	const	1	100	Using index; Using temporary; Using filesort
13	DEPENDENT SUBQUERY	social_influencers		eq_ref	PRIMARY,en_entity_id	PRIMARY	4	func	1	100	Using index
13	DEPENDENT SUBQUERY	seu		ref	by_user_id,entity_id_idx	entity_id_idx	4	func	1	100	Using index condition
13	DEPENDENT SUBQUERY	social_users		eq_ref	PRIMARY,un_user_id	PRIMARY	4	socialcxn_live_v1.seu.user_id	1	100	Using index
13	DEPENDENT SUBQUERY	sss		ref	fk_fk_socialmedia_channel_id,fk_influencer_socialstats_user_id	fk_influencer_socialstats_user_id	5	socialcxn_live_v1.seu.user_id	2	20	Using where
13	DEPENDENT SUBQUERY	social_engagement_levels		eq_ref	PRIMARY,el_id	PRIMARY	4	socialcxn_live_v1.sss.setup_social_engagement_rate_id	1	100	Using where
12	DEPENDENT SUBQUERY	ssc		ref	PRIMARY,smc_id,smc_code_name	smc_code_name	48	const	1	100	Using index; Using temporary; Using filesort
12	DEPENDENT SUBQUERY	social_influencers		eq_ref	PRIMARY,en_entity_id	PRIMARY	4	func	1	100	Using index
12	DEPENDENT SUBQUERY	seu		ref	by_user_id,entity_id_idx	entity_id_idx	4	func	1	100	Using index condition
12	DEPENDENT SUBQUERY	social_users		eq_ref	PRIMARY,un_user_id	PRIMARY	4	socialcxn_live_v1.seu.user_id	1	100	Using index
12	DEPENDENT SUBQUERY	sss		ref	fk_fk_socialmedia_channel_id,fk_influencer_socialstats_user_id	fk_influencer_socialstats_user_id	5	socialcxn_live_v1.seu.user_id	2	20	Using where
12	DEPENDENT SUBQUERY	social_engagement_levels		eq_ref	PRIMARY,el_id	PRIMARY	4	socialcxn_live_v1.sss.setup_social_engagement_rate_id	1	100	Using where; Using index
11	DEPENDENT SUBQUERY	ssc		ref	PRIMARY,smc_id,smc_code_name	smc_code_name	48	const	1	100	Using index; Using temporary; Using filesort
11	DEPENDENT SUBQUERY	social_influencers		eq_ref	PRIMARY,en_entity_id	PRIMARY	4	func	1	100	Using index
11	DEPENDENT SUBQUERY	seu		ref	by_user_id,entity_id_idx	entity_id_idx	4	func	1	100	Using index condition
11	DEPENDENT SUBQUERY	social_users		eq_ref	PRIMARY,un_user_id	PRIMARY	4	socialcxn_live_v1.seu.user_id	1	100	Using index
11	DEPENDENT SUBQUERY	sss		ref	fk_fk_socialmedia_channel_id,fk_influencer_socialstats_user_id	fk_influencer_socialstats_user_id	5	socialcxn_live_v1.seu.user_id	2	20	Using where
10	DEPENDENT SUBQUERY	ssc		ref	PRIMARY,smc_id,smc_code_name	smc_code_name	48	const	1	100	Using index; Using temporary; Using filesort
10	DEPENDENT SUBQUERY	social_influencers		eq_ref	PRIMARY,en_entity_id	PRIMARY	4	func	1	100	Using index
10	DEPENDENT SUBQUERY	seu		ref	by_user_id,entity_id_idx	entity_id_idx	4	func	1	100	Using index condition
10	DEPENDENT SUBQUERY	social_users		eq_ref	PRIMARY,un_user_id	PRIMARY	4	socialcxn_live_v1.seu.user_id	1	100	Using index
10	DEPENDENT SUBQUERY	sss		ref	fk_fk_socialmedia_channel_id,fk_influencer_socialstats_user_id	fk_influencer_socialstats_user_id	5	socialcxn_live_v1.seu.user_id	2	20	Using where
9	DEPENDENT SUBQUERY	ssc		ref	PRIMARY,smc_id,smc_code_name	smc_code_name	48	const	1	100	Using index; Using temporary; Using filesort
9	DEPENDENT SUBQUERY	social_influencers		eq_ref	PRIMARY,en_entity_id	PRIMARY	4	func	1	100	Using index
9	DEPENDENT SUBQUERY	seu		ref	by_user_id,entity_id_idx	entity_id_idx	4	func	1	100	Using index condition
9	DEPENDENT SUBQUERY	social_users		eq_ref	PRIMARY,un_user_id	PRIMARY	4	socialcxn_live_v1.seu.user_id	1	100	Using index
9	DEPENDENT SUBQUERY	sss		ref	fk_fk_socialmedia_channel_id,fk_influencer_socialstats_user_id	fk_influencer_socialstats_user_id	5	socialcxn_live_v1.seu.user_id	2	20	Using where
8	DEPENDENT SUBQUERY	ssc		ref	PRIMARY,smc_id,smc_code_name	smc_code_name	48	const	1	100	Using index; Using temporary; Using filesort
8	DEPENDENT SUBQUERY	social_influencers		eq_ref	PRIMARY,en_entity_id	PRIMARY	4	func	1	100	Using index
8	DEPENDENT SUBQUERY	seu		ref	by_user_id,entity_id_idx	entity_id_idx	4	func	1	100	Using index condition
8	DEPENDENT SUBQUERY	social_users		eq_ref	PRIMARY,un_user_id	PRIMARY	4	socialcxn_live_v1.seu.user_id	1	100	Using index
8	DEPENDENT SUBQUERY	sss		ref	fk_fk_socialmedia_channel_id,fk_influencer_socialstats_user_id	fk_influencer_socialstats_user_id	5	socialcxn_live_v1.seu.user_id	2	20	Using where
7	DEPENDENT SUBQUERY	ssc		ref	PRIMARY,smc_id,smc_code_name	smc_code_name	48	const	1	100	Using index; Using temporary; Using filesort
7	DEPENDENT SUBQUERY	social_influencers		eq_ref	PRIMARY,en_entity_id	PRIMARY	4	func	1	100	Using index
7	DEPENDENT SUBQUERY	seu		ref	by_user_id,entity_id_idx	entity_id_idx	4	func	1	100	Using index condition
7	DEPENDENT SUBQUERY	social_users		eq_ref	PRIMARY,un_user_id	PRIMARY	4	socialcxn_live_v1.seu.user_id	1	100	Using index
7	DEPENDENT SUBQUERY	sss		ref	fk_fk_socialmedia_channel_id,fk_influencer_socialstats_user_id	fk_influencer_socialstats_user_id	5	socialcxn_live_v1.seu.user_id	2	20	Using where
6	DEPENDENT SUBQUERY	ssc		ref	PRIMARY,smc_id,smc_code_name	smc_code_name	48	const	1	100	Using index; Using temporary; Using filesort
6	DEPENDENT SUBQUERY	social_influencers		eq_ref	PRIMARY,en_entity_id	PRIMARY	4	func	1	100	Using index
6	DEPENDENT SUBQUERY	seu		ref	by_user_id,entity_id_idx	entity_id_idx	4	func	1	100	Using index condition
6	DEPENDENT SUBQUERY	social_users		eq_ref	PRIMARY,un_user_id	PRIMARY	4	socialcxn_live_v1.seu.user_id	1	100	Using index
6	DEPENDENT SUBQUERY	sss		ref	fk_fk_socialmedia_channel_id,fk_influencer_socialstats_user_id	fk_influencer_socialstats_user_id	5	socialcxn_live_v1.seu.user_id	2	20	Using where
5	DEPENDENT SUBQUERY	ssc		ref	PRIMARY,smc_id,smc_code_name	smc_code_name	48	const	1	100	Using index; Using temporary; Using filesort
5	DEPENDENT SUBQUERY	social_influencers		eq_ref	PRIMARY,en_entity_id	PRIMARY	4	func	1	100	Using index
5	DEPENDENT SUBQUERY	seu		ref	by_user_id,entity_id_idx	entity_id_idx	4	func	1	100	Using index condition
5	DEPENDENT SUBQUERY	social_users		eq_ref	PRIMARY,un_user_id	PRIMARY	4	socialcxn_live_v1.seu.user_id	1	100	Using index
5	DEPENDENT SUBQUERY	sss		ref	fk_fk_socialmedia_channel_id,fk_influencer_socialstats_user_id	fk_influencer_socialstats_user_id	5	socialcxn_live_v1.seu.user_id	2	20	Using where
4	DEPENDENT SUBQUERY	ssc		ref	PRIMARY,smc_id,smc_code_name	smc_code_name	48	const	1	100	Using index; Using temporary; Using filesort
4	DEPENDENT SUBQUERY	social_influencers		eq_ref	PRIMARY,en_entity_id	PRIMARY	4	func	1	100	Using index
4	DEPENDENT SUBQUERY	seu		ref	by_user_id,entity_id_idx	entity_id_idx	4	func	1	100	Using index condition
4	DEPENDENT SUBQUERY	social_users		eq_ref	PRIMARY,un_user_id	PRIMARY	4	socialcxn_live_v1.seu.user_id	1	100	Using index
4	DEPENDENT SUBQUERY	sss		ref	fk_fk_socialmedia_channel_id,fk_influencer_socialstats_user_id	fk_influencer_socialstats_user_id	5	socialcxn_live_v1.seu.user_id	2	20	Using where
3	DEPENDENT SUBQUERY	social_influencers		eq_ref	PRIMARY,en_entity_id	PRIMARY	4	func	1	100	Using index
3	DEPENDENT SUBQUERY	seu		ref	by_user_id,entity_id_idx	entity_id_idx	4	func	1	100	Using index condition
3	DEPENDENT SUBQUERY	social_users		eq_ref	PRIMARY,un_user_id	PRIMARY	4	socialcxn_live_v1.seu.user_id	1	100	Using index
3	DEPENDENT SUBQUERY	sss		ref	fk_influencer_socialstats_user_id	fk_influencer_socialstats_user_id	5	socialcxn_live_v1.seu.user_id	2	100	
3	DEPENDENT SUBQUERY	ssc		eq_ref	PRIMARY,smc_id	PRIMARY	4	socialcxn_live_v1.sss.setup_socialmedia_channel_id	1	100	Using index
2	DEPENDENT SUBQUERY	coi		ref	coi_user_id	coi_user_id	5	func	3	10	Using where
2	DEPENDENT SUBQUERY	campaigns_influencers		eq_ref	PRIMARY,en_entity_id	PRIMARY	4	func	1	100	Using where; Using index
2	DEPENDENT SUBQUERY	influencer_users		eq_ref	PRIMARY,un_user_id	PRIMARY	4	func	1	100	Using where; Using index
2	DEPENDENT SUBQUERY	seu		eq_ref	PRIMARY	PRIMARY	4	func	1	100	Using where; Using index