1SET SESSION DEFAULT_STORAGE_ENGINE='InnoDB';
2set @innodb_stats_persistent_save= @@innodb_stats_persistent;
3set @innodb_stats_persistent_sample_pages_save=
4@@innodb_stats_persistent_sample_pages;
5set global innodb_stats_persistent= 1;
6set global innodb_stats_persistent_sample_pages=100;
7set optimizer_use_condition_selectivity=1;
8analyze SELECT sysapproval_approver0.`sys_id`
9FROM   ((sysapproval_approver sysapproval_approver0
10INNER JOIN task task1
11ON sysapproval_approver0.`sysapproval` = task1.`sys_id`
12                    AND (( task1.`sys_domain_path` = '/'
13                            OR task1.`sys_domain_path` LIKE '!!!/!!#/!!$/%'
14                            OR task1.`sys_domain_path` LIKE '!!!/!!!/%' )))
15INNER JOIN task task2
16ON task1.`parent` = task2.`sys_id`
17                   AND (( task2.`sys_domain_path` = '/'
18                           OR task2.`sys_domain_path` LIKE '!!!/!!#/!!$/%'
19                           OR task2.`sys_domain_path` LIKE '!!!/!!!/%' )))
20WHERE  task2.`sys_id` LIKE '8e7792a7dbfffb00fff8a345ca961934%'
21       AND ( sysapproval_approver0.`sys_domain_path` = '/'
22              OR sysapproval_approver0.`sys_domain_path` LIKE '!!!/!!#/!!$/%'
23              OR sysapproval_approver0.`sys_domain_path` LIKE '!!!/!!!/%' )
24ORDER  BY sysapproval_approver0.`order`
25LIMIT  0, 50 ;
26id	select_type	table	type	possible_keys	key	key_len	ref	rows	r_rows	filtered	r_filtered	Extra
271	SIMPLE	task2	range	PRIMARY,sys_class_name_2,sys_domain_path	PRIMARY	96	NULL	1	0.00	100.00	100.00	Using where; Using temporary; Using filesort
281	SIMPLE	task1	ref	PRIMARY,task_parent,sys_class_name_2,sys_domain_path	task_parent	99	test.task2.sys_id	1	NULL	100.00	NULL	Using index condition; Using where
291	SIMPLE	sysapproval_approver0	ref	sysapproval_approver_ref5,sys_domain_path,sysapproval_approver_CHG1975376	sysapproval_approver_ref5	99	test.task1.sys_id	1	NULL	100.00	NULL	Using index condition; Using where
30set optimizer_use_condition_selectivity=4;
31analyze SELECT sysapproval_approver0.`sys_id`
32FROM   ((sysapproval_approver sysapproval_approver0
33INNER JOIN task task1
34ON sysapproval_approver0.`sysapproval` = task1.`sys_id`
35                    AND (( task1.`sys_domain_path` = '/'
36                            OR task1.`sys_domain_path` LIKE '!!!/!!#/!!$/%'
37                            OR task1.`sys_domain_path` LIKE '!!!/!!!/%' )))
38INNER JOIN task task2
39ON task1.`parent` = task2.`sys_id`
40                   AND (( task2.`sys_domain_path` = '/'
41                           OR task2.`sys_domain_path` LIKE '!!!/!!#/!!$/%'
42                           OR task2.`sys_domain_path` LIKE '!!!/!!!/%' )))
43WHERE  task2.`sys_id` LIKE '8e7792a7dbfffb00fff8a345ca961934%'
44       AND ( sysapproval_approver0.`sys_domain_path` = '/'
45              OR sysapproval_approver0.`sys_domain_path` LIKE '!!!/!!#/!!$/%'
46              OR sysapproval_approver0.`sys_domain_path` LIKE '!!!/!!!/%' )
47ORDER  BY sysapproval_approver0.`order`
48LIMIT  0, 50 ;
49id	select_type	table	type	possible_keys	key	key_len	ref	rows	r_rows	filtered	r_filtered	Extra
501	SIMPLE	task2	range	PRIMARY,sys_class_name_2,sys_domain_path	PRIMARY	96	NULL	1	0.00	98.00	100.00	Using where; Using temporary; Using filesort
511	SIMPLE	task1	ref	PRIMARY,task_parent,sys_class_name_2,sys_domain_path	task_parent	99	test.task2.sys_id	1	NULL	100.00	NULL	Using index condition; Using where
521	SIMPLE	sysapproval_approver0	ref	sysapproval_approver_ref5,sys_domain_path,sysapproval_approver_CHG1975376	sysapproval_approver_ref5	99	test.task1.sys_id	1	NULL	100.00	NULL	Using index condition; Using where
53drop table sysapproval_approver,task;
54set global innodb_stats_persistent= @innodb_stats_persistent_save;
55set global innodb_stats_persistent_sample_pages=
56@innodb_stats_persistent_sample_pages_save;
57