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