mysql> set profiling=1; mysql> set profiling=1; Query OK, 0 rows affected (0.00 sec) mysql> SELECT DISTINCT g.* FROM groups g,hosts_groups hg,hosts h WHERE ((g.groupid BETWEEN 100000000000000 AND 199999999999999) OR (g.groupid BETWEEN 200000000000000 AND 299999999999999)) AND hg.groupid=g.groupid AND h.hostid=hg.hostid AND h.status=0 AND EXISTS( SELECT DISTINCT i.itemid FROM items i, graphs_items gi WHERE i.hostid=hg.hostid AND i.itemid=gi.itemid); +-----------------+--------------------------------------------+----------+ | groupid | name | internal | +-----------------+--------------------------------------------+----------+ | 100100000000008 | | 0 | | 100100000000015 | | 0 | | 100100000000030 | | 0 | | 100100000000027 | | 0 | | 100100000000036 | REMOVED :-) | 0 | | 100100000000022 | | 0 | | 100100000000050 | | 0 | | 100100000000024 | | 0 | | 100100000000025 | | 0 | | 100100000000049 | | 0 | | 100100000000026 | | 0 | | 100100000000032 | | 0 | | 100100000000043 | | 0 | | 100100000000044 | | 0 | | 100100000000052 | | 0 | | 100100000000051 | | 0 | | 100100000000005 | | 1 | | 100100000000045 | | 0 | | 100100000000028 | | 0 | | 100100000000029 | | 0 | | 100100000000035 | | 0 | | 100100000000047 | | 0 | | 100100000000048 | | 0 | | 100100000000055 | | 0 | | 100100000000054 | | 0 | | 100100000000042 | | 0 | | 100100000000010 | | 0 | | 200200000000007 | | 0 | | 200200000000008 | | 0 | | 200100000000001 | | 0 | | 200200000000006 | | 0 | | 200200000000002 | | 0 | +-----------------+--------------------------------------------+----------+ 32 rows in set (4.84 sec) mysql> show profile; +--------------------------------+----------+ | Status | Duration | +--------------------------------+----------+ | starting | 0.000052 | | Waiting for query cache lock | 0.000022 | | checking query cache for query | 0.000102 | | checking permissions | 0.000021 | | checking permissions | 0.000018 | | checking permissions | 0.000017 | | checking permissions | 0.000018 | | checking permissions | 0.000023 | | Opening tables | 0.000050 | | System lock | 0.000026 | | Waiting for query cache lock | 0.000193 | | init | 0.000066 | | optimizing | 0.000033 | | statistics | 0.000121 | | preparing | 0.000044 | | Creating tmp table | 0.000054 | | executing | 0.000019 | | Copying to tmp table | 0.000044 | | optimizing | 0.000026 | | statistics | 0.000037 | | preparing | 0.000028 | | Creating tmp table | 0.000036 | | executing | 0.000019 | | Copying to tmp table | 0.020143 | | Sending data | 0.000044 | | executing | 0.000019 | | Copying to tmp table | 0.017187 | | Sending data | 0.000039 | | executing | 0.000019 | | Copying to tmp table | 0.016919 | | Sending data | 0.000036 | | executing | 0.000019 | | Copying to tmp table | 0.017211 | | Sending data | 0.000038 | | executing | 0.000018 | | Copying to tmp table | 0.016928 | | Sending data | 0.000044 | | executing | 0.000023 | | Copying to tmp table | 0.017071 | | Sending data | 0.000036 | | executing | 0.000019 | | Copying to tmp table | 0.016939 | | Sending data | 0.000035 | | executing | 0.000019 | | Copying to tmp table | 0.016915 | | Sending data | 0.000041 | | executing | 0.000019 | | Copying to tmp table | 0.016961 | | Sending data | 0.000028 | | executing | 0.000018 | | Copying to tmp table | 0.016878 | | Sending data | 0.000035 | | executing | 0.000018 | | Copying to tmp table | 0.016974 | | Sending data | 0.000029 | | executing | 0.000018 | | Copying to tmp table | 0.017038 | | Sending data | 0.000035 | | executing | 0.000019 | | Copying to tmp table | 0.016842 | | Sending data | 0.000041 | | executing | 0.000020 | | Copying to tmp table | 0.016885 | | Sending data | 0.000035 | | executing | 0.000019 | | Copying to tmp table | 0.016872 | | Sending data | 0.000034 | | executing | 0.000018 | | Copying to tmp table | 0.016933 | | Sending data | 0.000034 | | executing | 0.000018 | | Copying to tmp table | 0.016928 | | Sending data | 0.000038 | | executing | 0.000019 | | Copying to tmp table | 0.016946 | | Sending data | 0.000037 | | executing | 0.000018 | | Copying to tmp table | 0.016784 | | Sending data | 0.000036 | | executing | 0.000019 | | Copying to tmp table | 0.017173 | | Sending data | 0.000036 | | executing | 0.000018 | | Copying to tmp table | 0.016998 | | Sending data | 0.000041 | | executing | 0.000018 | | Copying to tmp table | 0.016921 | | Sending data | 0.000058 | | executing | 0.000021 | | Copying to tmp table | 0.016943 | | Sending data | 0.000037 | | executing | 0.000019 | | Copying to tmp table | 0.016983 | | Sending data | 0.000040 | | executing | 0.000019 | | Copying to tmp table | 0.016865 | | Sending data | 0.000038 | | executing | 0.000024 | | Copying to tmp table | 0.016997 | | Sending data | 0.000038 | | executing | 0.000021 | | Copying to tmp table | 0.016874 | | Sending data | 0.000037 | | executing | 0.000019 | | Copying to tmp table | 0.016829 | | Sending data | 0.000034 | | executing | 0.000018 | | Copying to tmp table | 0.016866 | | Sending data | 0.000034 | | executing | 0.000018 | | Copying to tmp table | 0.016873 | | Sending data | 0.000036 | | executing | 0.000018 | | Copying to tmp table | 0.016919 | | Sending data | 0.000034 | | executing | 0.000019 | | Copying to tmp table | 0.016920 | | Sending data | 0.000033 | | executing | 0.000019 | | Copying to tmp table | 0.016946 | | Sending data | 0.000037 | | executing | 0.000021 | | Copying to tmp table | 0.016964 | | Sending data | 0.000039 | | executing | 0.000019 | | Copying to tmp table | 0.017117 | | Sending data | 0.000036 | | executing | 0.000018 | | Copying to tmp table | 0.016874 | | Sending data | 0.000038 | | executing | 0.000018 | | Copying to tmp table | 0.016867 | | Sending data | 0.000036 | | executing | 0.000019 | | Copying to tmp table | 0.017072 | | Sending data | 0.000035 | | executing | 0.000022 | | Copying to tmp table | 0.016895 | | Sending data | 0.000038 | | executing | 0.000019 | | Copying to tmp table | 0.016881 | | Sending data | 0.000034 | | executing | 0.000018 | | Copying to tmp table | 0.017021 | | Sending data | 0.000035 | | executing | 0.000019 | | Copying to tmp table | 0.016926 | | Sending data | 0.000039 | | executing | 0.000018 | | Copying to tmp table | 0.016968 | | Sending data | 0.000034 | | executing | 0.000018 | | Copying to tmp table | 0.017004 | | Sending data | 0.000034 | | executing | 0.000020 | | Copying to tmp table | 0.016970 | | Sending data | 0.000037 | | executing | 0.000021 | | Copying to tmp table | 0.017120 | | Sending data | 0.000036 | | executing | 0.000021 | | Copying to tmp table | 0.017200 | | Sending data | 0.000037 | | executing | 0.000018 | | Copying to tmp table | 0.017105 | | Sending data | 0.000038 | | executing | 0.000019 | | Copying to tmp table | 0.016871 | | Sending data | 0.000051 | | executing | 0.000019 | | Copying to tmp table | 0.010674 | | Sending data | 0.000031 | | executing | 0.000012 | | Copying to tmp table | 0.009831 | | Sending data | 0.000025 | | executing | 0.000012 | | Copying to tmp table | 0.009953 | | Sending data | 0.000029 | | executing | 0.000015 | | Copying to tmp table | 0.009802 | | Sending data | 0.000024 | | executing | 0.000012 | | Copying to tmp table | 0.009985 | | Sending data | 0.000022 | | executing | 0.000014 | | Copying to tmp table | 0.009891 | | Sending data | 0.000026 | | executing | 0.000012 | | Copying to tmp table | 0.009897 | | Sending data | 0.000022 | | executing | 0.000012 | | Copying to tmp table | 0.010117 | | Sending data | 0.000027 | | executing | 0.000012 | | Copying to tmp table | 0.000792 | | Sending data | 0.000044 | | executing | 0.000016 | | Copying to tmp table | 0.000774 | | Sending data | 0.000027 | | executing | 0.000012 | | Copying to tmp table | 0.000790 | | Sending data | 0.000044 | | executing | 0.000013 | | Copying to tmp table | 0.000806 | | Sending data | 0.000025 | | executing | 0.000059 | | Copying to tmp table | 0.000773 | | Sending data | 0.000363 | | executing | 0.000015 | | Copying to tmp table | 0.000776 | | Sending data | 0.000029 | | executing | 0.000012 | | Copying to tmp table | 0.000764 | | Sending data | 0.000032 | | executing | 0.000012 | | Copying to tmp table | 0.000756 | | Sending data | 0.000048 | | executing | 0.000016 | | Copying to tmp table | 0.000767 | | Sending data | 0.000028 | | executing | 0.000014 | | Copying to tmp table | 0.000778 | | Sending data | 0.000028 | | executing | 0.000012 | | Copying to tmp table | 0.000766 | | Sending data | 0.000027 | | executing | 0.000015 | | Copying to tmp table | 0.000767 | | Sending data | 0.000029 | | executing | 0.000012 | | Copying to tmp table | 0.000774 | | Sending data | 0.000029 | | executing | 0.000012 | | Copying to tmp table | 0.000764 | | Sending data | 0.000026 | | executing | 0.000012 | | Copying to tmp table | 0.000877 | | Sending data | 0.000025 | | executing | 0.000012 | | Copying to tmp table | 0.000766 | | Sending data | 0.000028 | | executing | 0.000015 | | Copying to tmp table | 0.000752 | | Sending data | 0.000030 | | executing | 0.000012 | | Copying to tmp table | 0.000786 | | Sending data | 0.000032 | | executing | 0.000013 | | Copying to tmp table | 0.000782 | | Sending data | 0.000025 | | executing | 0.000012 | | Copying to tmp table | 0.000810 | | Sending data | 0.000025 | | executing | 0.000012 | | Copying to tmp table | 0.000778 | | Sending data | 0.000030 | | executing | 0.000013 | | Copying to tmp table | 0.000745 | | Sending data | 0.000026 | | executing | 0.000012 | | Copying to tmp table | 0.000786 | | Sending data | 0.000071 | | executing | 0.000015 | | Copying to tmp table | 0.000745 | | Sending data | 0.000024 | | executing | 0.000012 | | Copying to tmp table | 0.000746 | | Sending data | 0.000029 | | executing | 0.000021 | | Copying to tmp table | 0.000751 | | Sending data | 0.000024 | | executing | 0.000014 | | Copying to tmp table | 0.000752 | | Sending data | 0.000024 | | executing | 0.000012 | | Copying to tmp table | 0.000774 | | Sending data | 0.000028 | | executing | 0.000012 | | Copying to tmp table | 0.000762 | | Sending data | 0.000031 | | executing | 0.000012 | | Copying to tmp table | 0.000767 | | Sending data | 0.000026 | | executing | 0.000012 | | Copying to tmp table | 0.000754 | | Sending data | 0.000024 | | executing | 0.000011 | | Copying to tmp table | 0.000775 | | Sending data | 0.000027 | | executing | 0.000012 | | Copying to tmp table | 0.000764 | | Sending data | 0.000028 | | executing | 0.000012 | | Copying to tmp table | 0.000761 | | Sending data | 0.000024 | | executing | 0.000012 | | Copying to tmp table | 0.000763 | | Sending data | 0.000030 | | executing | 0.000012 | | Copying to tmp table | 0.000757 | | Sending data | 0.000038 | | executing | 0.000015 | | Copying to tmp table | 0.000761 | | Sending data | 0.000042 | | executing | 0.000014 | | Copying to tmp table | 0.000791 | | Sending data | 0.000024 | | executing | 0.000011 | | Copying to tmp table | 0.000751 | | Sending data | 0.000023 | | executing | 0.000012 | | Copying to tmp table | 0.000761 | | Sending data | 0.000027 | | executing | 0.000012 | | Copying to tmp table | 0.000757 | | Sending data | 0.000024 | | executing | 0.000012 | | Copying to tmp table | 0.000799 | | Sending data | 0.000027 | | executing | 0.000012 | | Copying to tmp table | 0.000765 | | Sending data | 0.000025 | | executing | 0.000012 | | Copying to tmp table | 0.000768 | | Sending data | 0.000023 | | executing | 0.000012 | | Copying to tmp table | 0.000768 | | Sending data | 0.000032 | | executing | 0.000013 | | Copying to tmp table | 0.000767 | | Sending data | 0.000027 | | executing | 0.000013 | | Copying to tmp table | 0.000759 | | Sending data | 0.000024 | | executing | 0.000012 | | Copying to tmp table | 0.000772 | | Sending data | 0.000030 | | executing | 0.000013 | | Copying to tmp table | 0.000769 | | Sending data | 0.000026 | | executing | 0.000012 | | Copying to tmp table | 0.000766 | | Sending data | 0.000024 | | executing | 0.000015 | | Copying to tmp table | 0.000769 | | Sending data | 0.000030 | | executing | 0.000012 | | Copying to tmp table | 0.000777 | | Sending data | 0.000024 | | executing | 0.000012 | | Copying to tmp table | 0.000771 | | Sending data | 0.000026 | | executing | 0.000012 | | Copying to tmp table | 0.000763 | | Sending data | 0.000023 | | executing | 0.000012 | | Copying to tmp table | 0.000768 | | Sending data | 0.000029 | | executing | 0.000014 | | Copying to tmp table | 0.000764 | | Sending data | 0.000024 | | executing | 0.000012 | | Copying to tmp table | 0.000767 | | Sending data | 0.000025 | | executing | 0.000014 | | Copying to tmp table | 0.000803 | | Sending data | 0.000035 | | executing | 0.000015 | | Copying to tmp table | 0.000792 | | Sending data | 0.000027 | | executing | 0.000016 | | Copying to tmp table | 0.000855 | | Sending data | 0.000228 | | executing | 0.000018 | | Copying to tmp table | 0.000966 | | Sending data | 0.000034 | | executing | 0.000013 | | Copying to tmp table | 0.001026 | | Sending data | 0.000027 | | executing | 0.000012 | | Copying to tmp table | 0.000831 | | Sending data | 0.000024 | | executing | 0.000012 | | Copying to tmp table | 0.000835 | | Sending data | 0.000026 | | executing | 0.000013 | | Copying to tmp table | 0.000790 | | Sending data | 0.000030 | | executing | 0.000026 | | Copying to tmp table | 0.001048 | | Sending data | 0.000029 | | executing | 0.000013 | | Copying to tmp table | 0.000889 | | Sending data | 0.000024 | | executing | 0.000011 | | Copying to tmp table | 0.000830 | | Sending data | 0.000025 | | executing | 0.000011 | | Copying to tmp table | 0.000798 | | Sending data | 0.000029 | | executing | 0.000012 | | Copying to tmp table | 0.000807 | | Sending data | 0.000025 | | executing | 0.000012 | | Copying to tmp table | 0.000856 | | Sending data | 0.000028 | | executing | 0.000011 | | Copying to tmp table | 0.000855 | | Sending data | 0.000024 | | executing | 0.000015 | | Copying to tmp table | 0.000843 | | Sending data | 0.000032 | | executing | 0.000018 | | Copying to tmp table | 0.000786 | | Sending data | 0.000025 | | executing | 0.000012 | | Copying to tmp table | 0.000787 | | Sending data | 0.000023 | | executing | 0.000015 | | Copying to tmp table | 0.000841 | | Sending data | 0.000025 | | executing | 0.000015 | | Copying to tmp table | 0.000793 | | Sending data | 0.000028 | | executing | 0.000012 | | Copying to tmp table | 0.000788 | | Sending data | 0.000026 | | executing | 0.000012 | | Copying to tmp table | 0.000805 | | Sending data | 0.000024 | | executing | 0.000012 | | Copying to tmp table | 0.000809 | | Sending data | 0.000030 | | executing | 0.000013 | | Copying to tmp table | 0.000791 | | Sending data | 0.000024 | | executing | 0.000012 | | Copying to tmp table | 0.000816 | | Sending data | 0.000023 | | executing | 0.000013 | | Copying to tmp table | 0.001181 | | Sending data | 0.000032 | | executing | 0.000013 | | Copying to tmp table | 0.000838 | | Sending data | 0.000030 | | executing | 0.000014 | | Copying to tmp table | 0.000895 | | Sending data | 0.000030 | | executing | 0.000011 | | Copying to tmp table | 0.000853 | | Sending data | 0.000024 | | executing | 0.000012 | | Copying to tmp table | 0.000881 | | Sending data | 0.000029 | | executing | 0.000012 | | Copying to tmp table | 0.000857 | | Sending data | 0.000025 | | executing | 0.000012 | | Copying to tmp table | 0.001030 | | Sending data | 0.000028 | | executing | 0.000013 | | Copying to tmp table | 0.000817 | | Sending data | 0.000024 | | executing | 0.000014 | | Copying to tmp table | 0.000802 | | Sending data | 0.000030 | | executing | 0.000013 | | Copying to tmp table | 0.000791 | | Sending data | 0.000025 | | executing | 0.000012 | | Copying to tmp table | 0.000790 | | Sending data | 0.000023 | | executing | 0.000016 | | Copying to tmp table | 0.000833 | | Sending data | 0.000025 | | executing | 0.000012 | | Copying to tmp table | 0.000790 | | Sending data | 0.000033 | | executing | 0.000013 | | Copying to tmp table | 0.000799 | | Sending data | 0.000025 | | executing | 0.000012 | | Copying to tmp table | 0.001036 | | Sending data | 0.000083 | | executing | 0.000013 | | Copying to tmp table | 0.000770 | | Sending data | 0.000026 | | executing | 0.000025 | | Copying to tmp table | 0.001072 | | Sending data | 0.000089 | | executing | 0.000014 | | Copying to tmp table | 0.001004 | | Sending data | 0.000026 | | executing | 0.000012 | | Copying to tmp table | 0.000969 | | Sending data | 0.000027 | | executing | 0.000015 | | Copying to tmp table | 0.001117 | | Sending data | 0.000087 | | executing | 0.000014 | | Copying to tmp table | 0.000919 | | Sending data | 0.000051 | | executing | 0.000042 | | Copying to tmp table | 0.000971 | | Sending data | 0.000026 | | executing | 0.000015 | | Copying to tmp table | 0.001062 | | Sending data | 0.000030 | | executing | 0.000013 | | Copying to tmp table | 0.001026 | | Sending data | 0.000027 | | executing | 0.000012 | | Copying to tmp table | 0.000932 | | Sending data | 0.000026 | | executing | 0.000015 | | Copying to tmp table | 0.000776 | | Sending data | 0.000028 | | executing | 0.000012 | | Copying to tmp table | 0.000751 | | Sending data | 0.000026 | | executing | 0.000012 | | Copying to tmp table | 0.000807 | | Sending data | 0.000025 | | executing | 0.000011 | | Copying to tmp table | 0.000753 | | Sending data | 0.000026 | | executing | 0.000021 | | Copying to tmp table | 0.000753 | | Sending data | 0.000023 | | executing | 0.000011 | | Copying to tmp table | 0.000779 | | Sending data | 0.000023 | | executing | 0.000012 | | Copying to tmp table | 0.000745 | | Sending data | 0.000026 | | executing | 0.000012 | | Copying to tmp table | 0.000789 | | Sending data | 0.000026 | | executing | 0.000012 | | Copying to tmp table | 0.000760 | | Sending data | 0.000024 | | executing | 0.000012 | | Copying to tmp table | 0.000786 | | Sending data | 0.000029 | | executing | 0.000012 | | Copying to tmp table | 0.000747 | | Sending data | 0.000023 | | executing | 0.000017 | | Copying to tmp table | 0.000766 | | Sending data | 0.000023 | | executing | 0.000015 | | Copying to tmp table | 0.000791 | | Sending data | 0.000029 | | executing | 0.000012 | | Copying to tmp table | 0.000755 | | Sending data | 0.000023 | | executing | 0.000012 | | Copying to tmp table | 0.000770 | | Sending data | 0.000023 | | executing | 0.000014 | | Copying to tmp table | 0.000777 | | Sending data | 0.000026 | | executing | 0.000012 | | Copying to tmp table | 0.000762 | | Sending data | 0.000026 | | executing | 0.000012 | | Copying to tmp table | 0.000789 | | Sending data | 0.000026 | | executing | 0.000012 | | Copying to tmp table | 0.000763 | | Sending data | 0.000027 | | executing | 0.000011 | | Copying to tmp table | 0.000756 | | Sending data | 0.000023 | | executing | 0.000014 | | Copying to tmp table | 0.000778 | | Sending data | 0.000024 | | executing | 0.000011 | | Copying to tmp table | 0.000772 | | Sending data | 0.000027 | | executing | 0.000014 | | Copying to tmp table | 0.000788 | | Sending data | 0.000026 | | executing | 0.000012 | | Copying to tmp table | 0.000779 | | Sending data | 0.000022 | | executing | 0.000014 | | Copying to tmp table | 0.000768 | | Sending data | 0.000029 | | executing | 0.000015 | | Copying to tmp table | 0.000766 | | Sending data | 0.000026 | | executing | 0.000011 | | Copying to tmp table | 0.000786 | | Sending data | 0.000023 | | executing | 0.000011 | | Copying to tmp table | 0.000808 | | Sending data | 0.000029 | | executing | 0.000012 | | Copying to tmp table | 0.000758 | | Sending data | 0.000025 | | executing | 0.000013 | | Copying to tmp table | 0.000758 | | Sending data | 0.000024 | | executing | 0.000011 | | Copying to tmp table | 0.000791 | | Sending data | 0.000029 | | executing | 0.000012 | | Copying to tmp table | 0.001012 | | Sending data | 0.000026 | | executing | 0.000012 | | Copying to tmp table | 0.000940 | | Sending data | 0.000024 | | executing | 0.000012 | | Copying to tmp table | 0.000948 | | Sending data | 0.000029 | | executing | 0.000011 | | Copying to tmp table | 0.000961 | | Sending data | 0.000024 | | executing | 0.000012 | | Copying to tmp table | 0.000937 | | Sending data | 0.000026 | | executing | 0.000012 | | Copying to tmp table | 0.000992 | | Sending data | 0.000054 | | executing | 0.000014 | | Copying to tmp table | 0.000900 | | Sending data | 0.000025 | | executing | 0.000016 | | Copying to tmp table | 0.000804 | | Sending data | 0.000029 | | executing | 0.000012 | | Copying to tmp table | 0.000824 | | Sending data | 0.000028 | | executing | 0.000012 | | Copying to tmp table | 0.000835 | | Sending data | 0.000059 | | executing | 0.000012 | | Copying to tmp table | 0.000811 | | Sending data | 0.000024 | | executing | 0.000012 | | Copying to tmp table | 0.000830 | | Sending data | 0.000028 | | executing | 0.000012 | | Copying to tmp table | 0.000803 | | Sending data | 0.000024 | | executing | 0.000012 | | Copying to tmp table | 0.000852 | | Sending data | 0.000025 | | executing | 0.000014 | | Copying to tmp table | 0.000800 | | Sending data | 0.000024 | | executing | 0.000011 | | Copying to tmp table | 0.000830 | | Sending data | 0.000028 | | executing | 0.000012 | | Copying to tmp table | 0.000814 | | Sending data | 0.000025 | | executing | 0.000014 | | Copying to tmp table | 0.000832 | | Sending data | 0.000028 | | executing | 0.000013 | | Copying to tmp table | 0.000884 | | Sending data | 0.000022 | | executing | 0.000011 | | Copying to tmp table | 0.000860 | | Sending data | 0.000027 | | executing | 0.000012 | | Copying to tmp table | 0.000802 | | Sending data | 0.000024 | | executing | 0.000011 | | Copying to tmp table | 0.000810 | | Sending data | 0.000024 | | executing | 0.000012 | | Copying to tmp table | 0.000841 | | Sending data | 0.000044 | | executing | 0.000015 | | Copying to tmp table | 0.001187 | | Sending data | 0.000026 | | executing | 0.000025 | | Copying to tmp table | 0.001132 | | Sending data | 0.000028 | | executing | 0.000012 | | Copying to tmp table | 0.001142 | | Sending data | 0.000025 | | executing | 0.000011 | | Copying to tmp table | 0.001155 | | Sending data | 0.000030 | | executing | 0.000012 | | Copying to tmp table | 0.012009 | | Sending data | 0.000022 | | executing | 0.000014 | | Copying to tmp table | 0.009838 | | Sending data | 0.000025 | | executing | 0.000013 | | Copying to tmp table | 0.000836 | | Sending data | 0.000026 | | executing | 0.000012 | | Copying to tmp table | 0.000869 | | Sending data | 0.000031 | | executing | 0.000012 | | Copying to tmp table | 0.000824 | | Sending data | 0.000024 | | executing | 0.000012 | | Copying to tmp table | 0.000843 | | Sending data | 0.000024 | | executing | 0.000011 | | Copying to tmp table | 0.000829 | | Sending data | 0.000025 | | executing | 0.000013 | | Copying to tmp table | 0.000816 | | Sending data | 0.000026 | | executing | 0.000019 | | Copying to tmp table | 0.000856 | | Sending data | 0.000025 | | executing | 0.000011 | | Copying to tmp table | 0.000818 | | Sending data | 0.000027 | | executing | 0.000012 | | Copying to tmp table | 0.000835 | | Sending data | 0.000028 | | executing | 0.000015 | | Copying to tmp table | 0.000996 | | Sending data | 0.000027 | | executing | 0.000013 | | Copying to tmp table | 0.001013 | | Sending data | 0.000029 | | executing | 0.000012 | | Copying to tmp table | 0.005671 | | Sending data | 0.000029 | | executing | 0.000013 | | Copying to tmp table | 0.001016 | | Sending data | 0.000024 | | executing | 0.000012 | | Copying to tmp table | 0.001017 | | Sending data | 0.000028 | | executing | 0.000012 | | Copying to tmp table | 0.001009 | | Sending data | 0.000024 | | executing | 0.000011 | | Copying to tmp table | 0.001012 | | Sending data | 0.000024 | | executing | 0.000012 | | Copying to tmp table | 0.000996 | | Sending data | 0.000023 | | executing | 0.000011 | | Copying to tmp table | 0.001040 | | Sending data | 0.000028 | | executing | 0.000012 | | Copying to tmp table | 0.001017 | | Sending data | 0.000026 | | executing | 0.000011 | | Copying to tmp table | 0.001045 | | Sending data | 0.000027 | | executing | 0.000014 | | Copying to tmp table | 0.001011 | | Sending data | 0.000025 | | executing | 0.000011 | | Copying to tmp table | 0.001061 | | Sending data | 0.000027 | | executing | 0.000015 | | Copying to tmp table | 0.001002 | | Sending data | 0.000026 | | executing | 0.000011 | | Copying to tmp table | 0.001031 | | Sending data | 0.000028 | | executing | 0.000012 | | Copying to tmp table | 0.001075 | | Sending data | 0.000027 | | executing | 0.000011 | | Copying to tmp table | 0.001125 | | Sending data | 0.000028 | | executing | 0.000011 | | Copying to tmp table | 0.001048 | | Sending data | 0.000023 | | executing | 0.000012 | | Copying to tmp table | 0.000999 | | Sending data | 0.000026 | | executing | 0.000014 | | Copying to tmp table | 0.001082 | | Sending data | 0.000030 | | executing | 0.000012 | | Copying to tmp table | 0.000985 | | Sending data | 0.000023 | | executing | 0.000011 | | Copying to tmp table | 0.001028 | | Sending data | 0.000025 | | executing | 0.000011 | | Copying to tmp table | 0.001087 | | Sending data | 0.000028 | | executing | 0.000013 | | Copying to tmp table | 0.010065 | | Sending data | 0.000020 | | executing | 0.000015 | | Copying to tmp table | 0.010165 | | Sending data | 0.000023 | | executing | 0.000011 | | Copying to tmp table | 0.010001 | | Sending data | 0.000019 | | executing | 0.000011 | | Copying to tmp table | 0.010126 | | Sending data | 0.000019 | | executing | 0.000014 | | Copying to tmp table | 0.010127 | | Sending data | 0.000024 | | executing | 0.000012 | | Copying to tmp table | 0.010187 | | Sending data | 0.000019 | | executing | 0.000011 | | Copying to tmp table | 0.009900 | | Sending data | 0.000020 | | executing | 0.000011 | | Copying to tmp table | 0.010156 | | Sending data | 0.000027 | | executing | 0.000012 | | Copying to tmp table | 0.010310 | | Sending data | 0.000030 | | executing | 0.000014 | | Copying to tmp table | 0.010854 | | Sending data | 0.000022 | | executing | 0.000011 | | Copying to tmp table | 0.011734 | | Sending data | 0.000030 | | executing | 0.000014 | | Copying to tmp table | 0.001254 | | Sending data | 0.000032 | | executing | 0.000014 | | Copying to tmp table | 0.001218 | | Sending data | 0.000049 | | executing | 0.000014 | | Copying to tmp table | 0.011249 | | Sending data | 0.000022 | | executing | 0.000011 | | Copying to tmp table | 0.012473 | | Sending data | 0.000025 | | executing | 0.000011 | | Copying to tmp table | 0.010878 | | Sending data | 0.000021 | | executing | 0.000011 | | Copying to tmp table | 0.010485 | | Sending data | 0.000040 | | executing | 0.000012 | | Copying to tmp table | 0.011120 | | Sending data | 0.000025 | | executing | 0.000013 | | Copying to tmp table | 0.004570 | | Sending data | 0.000031 | | executing | 0.000034 | | Copying to tmp table | 0.004572 | | Sending data | 0.000029 | | executing | 0.000013 | | Copying to tmp table | 0.004425 | | Sending data | 0.000031 | | executing | 0.000012 | | Copying to tmp table | 0.004667 | | Sending data | 0.000030 | | executing | 0.000012 | | Copying to tmp table | 0.004372 | | Sending data | 0.000026 | | executing | 0.000011 | | Copying to tmp table | 0.004513 | | Sending data | 0.000030 | | executing | 0.000019 | | Copying to tmp table | 0.001130 | | Sending data | 0.000026 | | executing | 0.000011 | | Copying to tmp table | 0.001166 | | Sending data | 0.000024 | | executing | 0.000014 | | Copying to tmp table | 0.001158 | | Sending data | 0.000024 | | executing | 0.000012 | | Copying to tmp table | 0.001162 | | Sending data | 0.000034 | | executing | 0.000014 | | Copying to tmp table | 0.001127 | | Sending data | 0.000026 | | executing | 0.000011 | | Copying to tmp table | 0.001141 | | Sending data | 0.000024 | | executing | 0.000011 | | Copying to tmp table | 0.001173 | | Sending data | 0.000026 | | executing | 0.000011 | | Copying to tmp table | 0.001157 | | Sending data | 0.000029 | | executing | 0.000012 | | Copying to tmp table | 0.001149 | | Sending data | 0.000027 | | executing | 0.000014 | | Copying to tmp table | 0.001123 | | Sending data | 0.000025 | | executing | 0.000014 | | Copying to tmp table | 0.001141 | | Sending data | 0.000025 | | executing | 0.000012 | | Copying to tmp table | 0.001163 | | Sending data | 0.000027 | | executing | 0.000011 | | Copying to tmp table | 0.001168 | | Sending data | 0.000025 | | executing | 0.000014 | | Copying to tmp table | 0.001116 | | Sending data | 0.000025 | | executing | 0.000012 | | Copying to tmp table | 0.001354 | | Sending data | 0.000025 | | executing | 0.000015 | | Copying to tmp table | 0.001184 | | Sending data | 0.000029 | | executing | 0.000011 | | Copying to tmp table | 0.009872 | | Sending data | 0.000022 | | executing | 0.000011 | | Copying to tmp table | 0.009862 | | Sending data | 0.000020 | | executing | 0.000013 | | Copying to tmp table | 0.009816 | | Sending data | 0.000024 | | executing | 0.000011 | | Copying to tmp table | 0.001169 | | Sending data | 0.000026 | | executing | 0.000014 | | Copying to tmp table | 0.001136 | | Sending data | 0.000024 | | executing | 0.000011 | | Copying to tmp table | 0.001156 | | Sending data | 0.000025 | | executing | 0.000011 | | Copying to tmp table | 0.001159 | | Sending data | 0.000028 | | executing | 0.000011 | | Copying to tmp table | 0.001160 | | Sending data | 0.000026 | | executing | 0.000012 | | Copying to tmp table | 0.001177 | | Sending data | 0.000026 | | executing | 0.000011 | | Copying to tmp table | 0.001147 | | Sending data | 0.000025 | | executing | 0.000011 | | Copying to tmp table | 0.001168 | | Sending data | 0.000031 | | executing | 0.000015 | | Copying to tmp table | 0.001220 | | Sending data | 0.000028 | | executing | 0.000014 | | Copying to tmp table | 0.001205 | | Sending data | 0.000026 | | executing | 0.000012 | | Copying to tmp table | 0.001216 | | Sending data | 0.000026 | | executing | 0.000012 | | Copying to tmp table | 0.001171 | | Sending data | 0.000029 | | executing | 0.000012 | | Copying to tmp table | 0.001169 | | Sending data | 0.000026 | | executing | 0.000012 | | Copying to tmp table | 0.001211 | | Sending data | 0.000024 | | executing | 0.000014 | | Copying to tmp table | 0.001146 | | Sending data | 0.000029 | | executing | 0.000012 | | Copying to tmp table | 0.001216 | | Sending data | 0.000031 | | executing | 0.000012 | | Copying to tmp table | 0.001170 | | Sending data | 0.000026 | | executing | 0.000011 | | Copying to tmp table | 0.001505 | | Sending data | 0.000028 | | executing | 0.000011 | | Copying to tmp table | 0.001203 | | Sending data | 0.000026 | | executing | 0.000013 | | Copying to tmp table | 0.001222 | | Sending data | 0.000027 | | executing | 0.000014 | | Copying to tmp table | 0.001099 | | Sending data | 0.000024 | | executing | 0.000011 | | Copying to tmp table | 0.001124 | | Sending data | 0.000031 | | executing | 0.000013 | | Copying to tmp table | 0.001046 | | Sending data | 0.000029 | | executing | 0.000012 | | Copying to tmp table | 0.007726 | | Sending data | 0.000028 | | executing | 0.000016 | | Copying to tmp table | 0.007517 | | Sending data | 0.000026 | | executing | 0.000011 | | Copying to tmp table | 0.007525 | | Sending data | 0.000032 | | executing | 0.000014 | | Copying to tmp table | 0.001059 | | Sending data | 0.000024 | | executing | 0.000015 | | Copying to tmp table | 0.001040 | | Sending data | 0.000026 | | executing | 0.000012 | | Copying to tmp table | 0.001050 | | Sending data | 0.000028 | | executing | 0.000011 | | Copying to tmp table | 0.001071 | | Sending data | 0.000025 | | executing | 0.000012 | | Copying to tmp table | 0.001067 | | Sending data | 0.000025 | | executing | 0.000011 | | Copying to tmp table | 0.001066 | | Sending data | 0.000028 | | executing | 0.000011 | | Copying to tmp table | 0.009930 | | Sending data | 0.000022 | | executing | 0.000011 | | Copying to tmp table | 0.010431 | | Sending data | 0.000020 | | executing | 0.000011 | | Copying to tmp table | 0.010160 | | Sending data | 0.000029 | | executing | 0.000013 | | Copying to tmp table | 0.009932 | | Sending data | 0.000021 | | executing | 0.000011 | | Copying to tmp table | 0.009753 | | Sending data | 0.000019 | | executing | 0.000011 | | Copying to tmp table | 0.009743 | | Sending data | 0.000025 | | executing | 0.000011 | | Copying to tmp table | 0.001208 | | Sending data | 0.000031 | | executing | 0.000012 | | Copying to tmp table | 0.001183 | | Sending data | 0.000026 | | executing | 0.000012 | | Copying to tmp table | 0.001189 | | Sending data | 0.000026 | | executing | 0.000014 | | Copying to tmp table | 0.001169 | | Sending data | 0.000028 | | executing | 0.000015 | | Copying to tmp table | 0.001208 | | Sending data | 0.000026 | | executing | 0.000011 | | Copying to tmp table | 0.001208 | | Sending data | 0.000024 | | executing | 0.000011 | | Copying to tmp table | 0.001209 | | Sending data | 0.000026 | | executing | 0.000013 | | Copying to tmp table | 0.001268 | | Sending data | 0.000029 | | executing | 0.000011 | | Copying to tmp table | 0.001199 | | Sending data | 0.000025 | | executing | 0.000011 | | Copying to tmp table | 0.001251 | | Sending data | 0.000027 | | executing | 0.000011 | | Copying to tmp table | 0.001240 | | Sending data | 0.000028 | | executing | 0.000012 | | Copying to tmp table | 0.001239 | | Sending data | 0.000028 | | executing | 0.000011 | | Copying to tmp table | 0.001254 | | Sending data | 0.000025 | | executing | 0.000012 | | Copying to tmp table | 0.001236 | | Sending data | 0.000028 | | executing | 0.000012 | | Copying to tmp table | 0.001289 | | Sending data | 0.000025 | | executing | 0.000012 | | Copying to tmp table | 0.001231 | | Sending data | 0.000028 | | executing | 0.000014 | | Copying to tmp table | 0.001251 | | Sending data | 0.000027 | | executing | 0.000012 | | Copying to tmp table | 0.001215 | | Sending data | 0.000024 | | executing | 0.000011 | | Copying to tmp table | 0.001255 | | Sending data | 0.000025 | | executing | 0.000011 | | Copying to tmp table | 0.001231 | | Sending data | 0.000028 | | executing | 0.000011 | | Copying to tmp table | 0.001257 | | Sending data | 0.000025 | | executing | 0.000012 | | Copying to tmp table | 0.001249 | | Sending data | 0.000024 | | executing | 0.000011 | | Copying to tmp table | 0.001243 | | Sending data | 0.000025 | | executing | 0.000015 | | Copying to tmp table | 0.001264 | | Sending data | 0.000029 | | executing | 0.000011 | | Copying to tmp table | 0.001943 | | Sending data | 0.000027 | | executing | 0.000013 | | Copying to tmp table | 0.001945 | | Sending data | 0.000026 | | executing | 0.000013 | | Copying to tmp table | 0.001925 | | Sending data | 0.000025 | | executing | 0.000012 | | Copying to tmp table | 0.001900 | | Sending data | 0.000031 | | executing | 0.000013 | | Copying to tmp table | 0.001928 | | Sending data | 0.000026 | | executing | 0.000013 | | Copying to tmp table | 0.001925 | | Sending data | 0.000026 | | executing | 0.000011 | | Copying to tmp table | 0.001906 | | Sending data | 0.000025 | | executing | 0.000012 | | Copying to tmp table | 0.001924 | | Sending data | 0.000029 | | executing | 0.000011 | | Copying to tmp table | 0.001953 | | Sending data | 0.000024 | | executing | 0.000012 | | Copying to tmp table | 0.001961 | | Sending data | 0.000027 | | executing | 0.000011 | | Copying to tmp table | 0.001976 | | Sending data | 0.000026 | | executing | 0.000014 | | Copying to tmp table | 0.001970 | | Sending data | 0.000029 | | executing | 0.000011 | | Copying to tmp table | 0.001944 | | Sending data | 0.000024 | | executing | 0.000011 | | Copying to tmp table | 0.001966 | | Sending data | 0.000027 | | executing | 0.000013 | | Copying to tmp table | 0.001947 | | Sending data | 0.000024 | | executing | 0.000011 | | Copying to tmp table | 0.001959 | | Sending data | 0.000029 | | executing | 0.000011 | | Copying to tmp table | 0.001943 | | Sending data | 0.000025 | | executing | 0.000011 | | Copying to tmp table | 0.001968 | | Sending data | 0.000024 | | executing | 0.000011 | | Copying to tmp table | 0.001982 | | Sending data | 0.000028 | | executing | 0.000011 | | Copying to tmp table | 0.001976 | | Sending data | 0.000053 | | executing | 0.000012 | | Copying to tmp table | 0.001976 | | Sending data | 0.000025 | | executing | 0.000013 | | Copying to tmp table | 0.001983 | | Sending data | 0.000029 | | executing | 0.000014 | | Copying to tmp table | 0.001997 | | Sending data | 0.000024 | | executing | 0.000011 | | Copying to tmp table | 0.002011 | | Sending data | 0.000025 | | executing | 0.000013 | | Copying to tmp table | 0.002008 | | Sending data | 0.000030 | | executing | 0.000011 | | Copying to tmp table | 0.002115 | | Sending data | 0.000026 | | executing | 0.000012 | | Copying to tmp table | 0.002088 | | Sending data | 0.000025 | | executing | 0.000011 | | Copying to tmp table | 0.002096 | | Sending data | 0.000029 | | executing | 0.000014 | | Copying to tmp table | 0.002122 | | Sending data | 0.000025 | | executing | 0.000014 | | Copying to tmp table | 0.002097 | | Sending data | 0.000025 | | executing | 0.000011 | | Copying to tmp table | 0.002094 | | Sending data | 0.000031 | | executing | 0.000012 | | Copying to tmp table | 0.002139 | | Sending data | 0.000025 | | executing | 0.000012 | | Copying to tmp table | 0.002141 | | Sending data | 0.000026 | | executing | 0.000011 | | Copying to tmp table | 0.002127 | | Sending data | 0.000028 | | executing | 0.000011 | | Copying to tmp table | 0.002227 | | Sending data | 0.000027 | | executing | 0.000011 | | Copying to tmp table | 0.002212 | | Sending data | 0.000024 | | executing | 0.000012 | | Copying to tmp table | 0.002216 | | Sending data | 0.000030 | | executing | 0.000011 | | Copying to tmp table | 0.002245 | | Sending data | 0.000025 | | executing | 0.000011 | | Copying to tmp table | 0.002250 | | Sending data | 0.000026 | | executing | 0.000012 | | Copying to tmp table | 0.002251 | | Sending data | 0.000029 | | executing | 0.000012 | | Copying to tmp table | 0.002280 | | Sending data | 0.000025 | | executing | 0.000014 | | Copying to tmp table | 0.002293 | | Sending data | 0.000025 | | executing | 0.000012 | | Copying to tmp table | 0.002310 | | Sending data | 0.000028 | | executing | 0.000012 | | Copying to tmp table | 0.002314 | | Sending data | 0.000027 | | executing | 0.000012 | | Copying to tmp table | 0.002319 | | Sending data | 0.000025 | | executing | 0.000011 | | Copying to tmp table | 0.002343 | | Sending data | 0.000029 | | executing | 0.000011 | | Copying to tmp table | 0.002361 | | Sending data | 0.000025 | | executing | 0.000012 | | Copying to tmp table | 0.002376 | | Sending data | 0.000025 | | executing | 0.000012 | | Copying to tmp table | 0.002396 | | Sending data | 0.000028 | | executing | 0.000013 | | Copying to tmp table | 0.002415 | | Sending data | 0.000025 | | executing | 0.000012 | | Copying to tmp table | 0.002426 | | Sending data | 0.000025 | | executing | 0.000012 | | Copying to tmp table | 0.002433 | | Sending data | 0.000030 | | executing | 0.000012 | | Copying to tmp table | 0.002456 | | Sending data | 0.000027 | | executing | 0.000012 | | Copying to tmp table | 0.002406 | | Sending data | 0.000025 | | executing | 0.000011 | | Copying to tmp table | 0.002454 | | Sending data | 0.000031 | | executing | 0.000015 | | Copying to tmp table | 0.002495 | | Sending data | 0.000025 | | executing | 0.000011 | | Copying to tmp table | 0.002507 | | Sending data | 0.000025 | | executing | 0.000011 | | Copying to tmp table | 0.002482 | | Sending data | 0.000029 | | executing | 0.000012 | | Copying to tmp table | 0.002530 | | Sending data | 0.000024 | | executing | 0.000011 | | Copying to tmp table | 0.002538 | | Sending data | 0.000025 | | executing | 0.000011 | | Copying to tmp table | 0.002534 | | Sending data | 0.000028 | | executing | 0.000012 | | Copying to tmp table | 0.002591 | | Sending data | 0.000025 | | executing | 0.000011 | | Copying to tmp table | 0.002565 | | Sending data | 0.000025 | | executing | 0.000011 | | Copying to tmp table | 0.002573 | | Sending data | 0.000028 | | executing | 0.000011 | | Copying to tmp table | 0.003231 | | Sending data | 0.000027 | | executing | 0.000012 | | Copying to tmp table | 0.003248 | | Sending data | 0.000025 | | executing | 0.000012 | | Copying to tmp table | 0.003231 | | Sending data | 0.000028 | | executing | 0.000011 | | Copying to tmp table | 0.003277 | | Sending data | 0.000026 | | executing | 0.000014 | | Copying to tmp table | 0.003275 | | Sending data | 0.000024 | | executing | 0.000011 | | Copying to tmp table | 0.003277 | | Sending data | 0.000029 | | executing | 0.000011 | | Copying to tmp table | 0.003279 | | Sending data | 0.000026 | | executing | 0.000011 | | Copying to tmp table | 0.003272 | | Sending data | 0.000025 | | executing | 0.000011 | | Copying to tmp table | 0.003296 | | Sending data | 0.000028 | | executing | 0.000013 | | Copying to tmp table | 0.003319 | | Sending data | 0.000028 | | executing | 0.000011 | | Copying to tmp table | 0.003289 | | Sending data | 0.000025 | | executing | 0.000012 | | Copying to tmp table | 0.003338 | | Sending data | 0.000029 | | executing | 0.000015 | | Copying to tmp table | 0.003359 | | Sending data | 0.000030 | | executing | 0.000012 | | Copying to tmp table | 0.003421 | | Sending data | 0.000025 | | executing | 0.000011 | | Copying to tmp table | 0.003412 | | Sending data | 0.000031 | | executing | 0.000012 | | Copying to tmp table | 0.003440 | | Sending data | 0.000026 | | executing | 0.000012 | | Copying to tmp table | 0.003438 | | Sending data | 0.000026 | | executing | 0.000011 | | Copying to tmp table | 0.003412 | | Sending data | 0.000028 | | executing | 0.000019 | | Copying to tmp table | 0.003432 | | Sending data | 0.000026 | | executing | 0.000013 | | Copying to tmp table | 0.003504 | | Sending data | 0.000025 | | executing | 0.000014 | | Copying to tmp table | 0.003451 | | Sending data | 0.000030 | | executing | 0.000011 | | Copying to tmp table | 0.003533 | | Sending data | 0.000027 | | executing | 0.000011 | | Copying to tmp table | 0.003504 | | Sending data | 0.000026 | | executing | 0.000031 | | Copying to tmp table | 0.003525 | | Sending data | 0.000029 | | executing | 0.000014 | | Copying to tmp table | 0.003534 | | Sending data | 0.000027 | | executing | 0.000012 | | Copying to tmp table | 0.003535 | | Sending data | 0.000025 | | executing | 0.000012 | | Copying to tmp table | 0.003535 | | Sending data | 0.000028 | | executing | 0.000012 | | Copying to tmp table | 0.003579 | | Sending data | 0.000028 | | executing | 0.000011 | | Copying to tmp table | 0.003594 | | Sending data | 0.000025 | | executing | 0.000011 | | Copying to tmp table | 0.003567 | | Sending data | 0.000031 | | executing | 0.000012 | | Copying to tmp table | 0.003642 | | Sending data | 0.000026 | | executing | 0.000011 | | Copying to tmp table | 0.003649 | | Sending data | 0.000026 | | executing | 0.000011 | | Copying to tmp table | 0.003834 | | Sending data | 0.000031 | | executing | 0.000012 | | Copying to tmp table | 0.003678 | | Sending data | 0.000026 | | executing | 0.000011 | | Copying to tmp table | 0.003697 | | Sending data | 0.000025 | | executing | 0.000011 | | Copying to tmp table | 0.003652 | | Sending data | 0.000031 | | executing | 0.000012 | | Copying to tmp table | 0.003697 | | Sending data | 0.000026 | | executing | 0.000014 | | Copying to tmp table | 0.003737 | | Sending data | 0.000025 | | executing | 0.000012 | | Copying to tmp table | 0.003760 | | Sending data | 0.000032 | | executing | 0.000012 | | Copying to tmp table | 0.003760 | | Sending data | 0.000027 | | executing | 0.000011 | | Copying to tmp table | 0.003806 | | Sending data | 0.000026 | | executing | 0.000011 | | Copying to tmp table | 0.003779 | | Sending data | 0.000027 | | executing | 0.000011 | | Copying to tmp table | 0.003823 | | Sending data | 0.000026 | | executing | 0.000012 | | Copying to tmp table | 0.003827 | | Sending data | 0.000026 | | executing | 0.000015 | | Copying to tmp table | 0.003795 | | Sending data | 0.000031 | | executing | 0.000012 | | Copying to tmp table | 0.003877 | | Sending data | 0.000028 | | executing | 0.000012 | | Copying to tmp table | 0.003847 | | Sending data | 0.000028 | | executing | 0.000011 | | Copying to tmp table | 0.003910 | | Sending data | 0.000026 | | executing | 0.000013 | | Copying to tmp table | 0.003914 | | Sending data | 0.000025 | | executing | 0.000011 | | Copying to tmp table | 0.004090 | | Sending data | 0.000032 | | executing | 0.000012 | | Copying to tmp table | 0.003946 | | Sending data | 0.000027 | | executing | 0.000011 | | Copying to tmp table | 0.003967 | | Sending data | 0.000026 | | executing | 0.000012 | | Copying to tmp table | 0.003979 | | Sending data | 0.000032 | | executing | 0.000013 | | Copying to tmp table | 0.004001 | | Sending data | 0.000026 | | executing | 0.000013 | | Copying to tmp table | 0.003993 | | Sending data | 0.000026 | | executing | 0.000011 | | Copying to tmp table | 0.004004 | | Sending data | 0.000029 | | executing | 0.000012 | | Copying to tmp table | 0.004051 | | Sending data | 0.000026 | | executing | 0.000012 | | Copying to tmp table | 0.004066 | | Sending data | 0.000025 | | executing | 0.000019 | | Copying to tmp table | 0.004026 | | Sending data | 0.000028 | | executing | 0.000011 | | Copying to tmp table | 0.004064 | | Sending data | 0.000026 | | executing | 0.000011 | | Copying to tmp table | 0.004101 | | Sending data | 0.000025 | | executing | 0.000011 | | Copying to tmp table | 0.004109 | | Sending data | 0.000034 | | executing | 0.000013 | | Copying to tmp table | 0.004136 | | Sending data | 0.000026 | | executing | 0.000012 | | Copying to tmp table | 0.004174 | | Sending data | 0.000025 | | executing | 0.000012 | | Copying to tmp table | 0.004160 | | Sending data | 0.000029 | | executing | 0.000012 | | Copying to tmp table | 0.004213 | | Sending data | 0.000029 | | executing | 0.000013 | | Copying to tmp table | 0.004172 | | Sending data | 0.000026 | | executing | 0.000011 | | Copying to tmp table | 0.004169 | | Sending data | 0.000029 | | executing | 0.000011 | | Copying to tmp table | 0.004255 | | Sending data | 0.000026 | | executing | 0.000011 | | Copying to tmp table | 0.004110 | | Sending data | 0.000026 | | executing | 0.000011 | | Copying to tmp table | 0.004291 | | Sending data | 0.000029 | | executing | 0.000013 | | Copying to tmp table | 0.005672 | | Sending data | 0.000025 | | executing | 0.000011 | | Copying to tmp table | 0.005663 | | Sending data | 0.000027 | | executing | 0.000018 | | Copying to tmp table | 0.005858 | | Sending data | 0.000033 | | executing | 0.000011 | | Copying to tmp table | 0.006201 | | Sending data | 0.000033 | | executing | 0.000012 | | Copying to tmp table | 0.006397 | | Sending data | 0.000027 | | executing | 0.000012 | | Copying to tmp table | 0.006090 | | Sending data | 0.000026 | | executing | 0.000011 | | Copying to tmp table | 0.006177 | | Sending data | 0.000032 | | executing | 0.000011 | | Copying to tmp table | 0.006205 | | Sending data | 0.000028 | | executing | 0.000012 | | Copying to tmp table | 0.006165 | | Sending data | 0.000027 | | executing | 0.000014 | | Copying to tmp table | 0.006146 | | Sending data | 0.000027 | | executing | 0.000011 | | Copying to tmp table | 0.005998 | | Sending data | 0.000029 | | executing | 0.000011 | | Copying to tmp table | 0.007848 | | Sending data | 0.000029 | | executing | 0.000011 | | Copying to tmp table | 0.009971 | | Sending data | 0.000024 | | executing | 0.000012 | | Copying to tmp table | 0.010232 | | Sending data | 0.000026 | | executing | 0.000024 | | Copying to tmp table | 0.009858 | | Sending data | 0.000019 | | executing | 0.000011 | | Copying to tmp table | 0.009830 | | Sending data | 0.000027 | | executing | 0.000012 | | Copying to tmp table | 0.009818 | | Sending data | 0.000019 | | executing | 0.000011 | | Copying to tmp table | 0.009871 | | Sending data | 0.000026 | | executing | 0.000012 | | Copying to tmp table | 0.009755 | | Sending data | 0.000019 | | executing | 0.000011 | | Copying to tmp table | 0.009739 | | Sending data | 0.000022 | | executing | 0.000011 | | Copying to tmp table | 0.009790 | | Sending data | 0.000019 | | executing | 0.000011 | | Copying to tmp table | 0.009809 | | Sending data | 0.000024 | | executing | 0.000012 | | Copying to tmp table | 0.009758 | | Sending data | 0.000020 | | executing | 0.000011 | | Copying to tmp table | 0.009803 | | Sending data | 0.000023 | | executing | 0.000022 | | Copying to tmp table | 0.009821 | | Sending data | 0.000019 | | executing | 0.000011 | | Copying to tmp table | 0.009840 | | Sending data | 0.000025 | | executing | 0.000011 | | Copying to tmp table | 0.009906 | | Sending data | 0.000023 | | executing | 0.000024 | | Copying to tmp table | 0.006381 | | Sending data | 0.000029 | | executing | 0.000012 | | Copying to tmp table | 0.006346 | | Sending data | 0.000026 | | executing | 0.000011 | | Copying to tmp table | 0.006338 | | Sending data | 0.000029 | | executing | 0.000017 | | Copying to tmp table | 0.006628 | | Sending data | 0.000026 | | executing | 0.000012 | | Copying to tmp table | 0.006636 | | Sending data | 0.000025 | | executing | 0.000012 | | Copying to tmp table | 0.006658 | | Sending data | 0.000028 | | executing | 0.000011 | | Copying to tmp table | 0.006654 | | Sending data | 0.000029 | | executing | 0.000014 | | Copying to tmp table | 0.006687 | | Sending data | 0.000028 | | executing | 0.000013 | | Copying to tmp table | 0.006725 | | Sending data | 0.000028 | | executing | 0.000012 | | Copying to tmp table | 0.006790 | | Sending data | 0.000030 | | executing | 0.000011 | | Copying to tmp table | 0.006765 | | Sending data | 0.000028 | | executing | 0.000012 | | Copying to tmp table | 0.009740 | | Sending data | 0.000026 | | executing | 0.000012 | | Copying to tmp table | 0.006868 | | Sending data | 0.000032 | | executing | 0.000012 | | Copying to tmp table | 0.006854 | | Sending data | 0.000029 | | executing | 0.000012 | | Copying to tmp table | 0.006892 | | Sending data | 0.000030 | | executing | 0.000011 | | Copying to tmp table | 0.006844 | | Sending data | 0.000029 | | executing | 0.000011 | | Copying to tmp table | 0.006855 | | Sending data | 0.000029 | | executing | 0.000012 | | Copying to tmp table | 0.006886 | | Sending data | 0.000029 | | executing | 0.000012 | | Copying to tmp table | 0.006930 | | Sending data | 0.000028 | | executing | 0.000012 | | Copying to tmp table | 0.006901 | | Sending data | 0.000028 | | executing | 0.000012 | | Copying to tmp table | 0.006893 | | Sending data | 0.000030 | | executing | 0.000011 | | Copying to tmp table | 0.006969 | | Sending data | 0.000031 | | executing | 0.000011 | | Copying to tmp table | 0.006955 | | Sending data | 0.000030 | | executing | 0.000018 | | Copying to tmp table | 0.006884 | | Sending data | 0.000029 | | executing | 0.000012 | | Copying to tmp table | 0.006915 | | Sending data | 0.000029 | | executing | 0.000013 | | Copying to tmp table | 0.006896 | | Sending data | 0.000029 | | executing | 0.000035 | | Copying to tmp table | 0.006932 | | Sending data | 0.000030 | | executing | 0.000013 | | Copying to tmp table | 0.007106 | | Sending data | 0.000029 | | executing | 0.000011 | | Copying to tmp table | 0.006956 | | Sending data | 0.000028 | | executing | 0.000011 | | Copying to tmp table | 0.006981 | | Sending data | 0.000030 | | executing | 0.000012 | | Copying to tmp table | 0.006959 | | Sending data | 0.000030 | | executing | 0.000012 | | Copying to tmp table | 0.007030 | | Sending data | 0.000029 | | executing | 0.000011 | | Copying to tmp table | 0.006991 | | Sending data | 0.000029 | | executing | 0.000012 | | Copying to tmp table | 0.006993 | | Sending data | 0.000025 | | executing | 0.000014 | | Copying to tmp table | 0.009859 | | Sending data | 0.000024 | | executing | 0.000012 | | Copying to tmp table | 0.009830 | | Sending data | 0.000023 | | executing | 0.000011 | | Copying to tmp table | 0.009780 | | Sending data | 0.000023 | | executing | 0.000011 | | Copying to tmp table | 0.009880 | | Sending data | 0.000023 | | executing | 0.000011 | | Copying to tmp table | 0.009821 | | Sending data | 0.000025 | | executing | 0.000011 | | Copying to tmp table | 0.009870 | | Sending data | 0.000022 | | executing | 0.000012 | | Copying to tmp table | 0.009839 | | Sending data | 0.000024 | | executing | 0.000011 | | Copying to tmp table | 0.009832 | | Sending data | 0.000023 | | executing | 0.000011 | | Copying to tmp table | 0.007292 | | Sending data | 0.000026 | | executing | 0.000011 | | Copying to tmp table | 0.007285 | | Sending data | 0.000031 | | executing | 0.000012 | | Copying to tmp table | 0.007162 | | Sending data | 0.000027 | | executing | 0.000012 | | Copying to tmp table | 0.007305 | | Sending data | 0.000031 | | executing | 0.000011 | | Copying to tmp table | 0.007292 | | Sending data | 0.000027 | | executing | 0.000011 | | Copying to tmp table | 0.007300 | | Sending data | 0.000032 | | executing | 0.000014 | | Copying to tmp table | 0.007283 | | Sending data | 0.000027 | | executing | 0.000012 | | Copying to tmp table | 0.007280 | | Sending data | 0.000031 | | executing | 0.000011 | | Copying to tmp table | 0.007316 | | Sending data | 0.000030 | | executing | 0.000013 | | Copying to tmp table | 0.007265 | | Sending data | 0.000032 | | executing | 0.000012 | | Copying to tmp table | 0.007229 | | Sending data | 0.000038 | | executing | 0.000015 | | Copying to tmp table | 0.007243 | | Sending data | 0.000029 | | executing | 0.000011 | | Copying to tmp table | 0.009654 | | Sending data | 0.000023 | | executing | 0.000011 | | Copying to tmp table | 0.007298 | | Sending data | 0.000028 | | executing | 0.000012 | | Copying to tmp table | 0.007334 | | Sending data | 0.000031 | | executing | 0.000011 | | Copying to tmp table | 0.007270 | | Sending data | 0.000027 | | executing | 0.000013 | | Copying to tmp table | 0.007286 | | Sending data | 0.000031 | | executing | 0.000013 | | Copying to tmp table | 0.007370 | | Sending data | 0.000026 | | executing | 0.000011 | | Copying to tmp table | 0.007458 | | Sending data | 0.000030 | | executing | 0.000012 | | Copying to tmp table | 0.007301 | | Sending data | 0.000027 | | executing | 0.000011 | | Copying to tmp table | 0.007558 | | Sending data | 0.000031 | | executing | 0.000012 | | Copying to tmp table | 0.007313 | | Sending data | 0.000029 | | executing | 0.000011 | | Copying to tmp table | 0.007233 | | Sending data | 0.000030 | | executing | 0.000011 | | Copying to tmp table | 0.007283 | | Sending data | 0.000028 | | executing | 0.000011 | | Copying to tmp table | 0.007312 | | Sending data | 0.000033 | | executing | 0.000011 | | Copying to tmp table | 0.007263 | | Sending data | 0.000027 | | executing | 0.000011 | | Copying to tmp table | 0.007331 | | Sending data | 0.000030 | | executing | 0.000015 | | Copying to tmp table | 0.009861 | | Sending data | 0.000024 | | executing | 0.000011 | | Copying to tmp table | 0.007461 | | Sending data | 0.000029 | | executing | 0.000011 | | Copying to tmp table | 0.007316 | | Sending data | 0.000027 | | executing | 0.000011 | | Copying to tmp table | 0.007256 | | Sending data | 0.000030 | | executing | 0.000011 | | Copying to tmp table | 0.007328 | | Sending data | 0.000031 | | executing | 0.000012 | | Copying to tmp table | 0.009758 | | Sending data | 0.000023 | | executing | 0.000011 | | Copying to tmp table | 0.009794 | | Sending data | 0.000022 | | executing | 0.000011 | | Copying to tmp table | 0.007429 | | Sending data | 0.000033 | | executing | 0.000012 | | Copying to tmp table | 0.007536 | | Sending data | 0.000031 | | executing | 0.000016 | | Copying to tmp table | 0.009796 | | Sending data | 0.000023 | | executing | 0.000012 | | Copying to tmp table | 0.009802 | | Sending data | 0.000023 | | executing | 0.000011 | | Copying to tmp table | 0.009763 | | Sending data | 0.000026 | | executing | 0.000012 | | Copying to tmp table | 0.009777 | | Sending data | 0.000024 | | executing | 0.000013 | | Copying to tmp table | 0.009806 | | Sending data | 0.000022 | | executing | 0.000016 | | Copying to tmp table | 0.009785 | | Sending data | 0.000024 | | executing | 0.000011 | | Copying to tmp table | 0.009755 | | Sending data | 0.000027 | | executing | 0.000012 | | Copying to tmp table | 0.009771 | | Sending data | 0.000025 | | executing | 0.000011 | | Copying to tmp table | 0.009739 | | Sending data | 0.000024 | | executing | 0.000011 | | Copying to tmp table | 0.009769 | | Sending data | 0.000025 | | executing | 0.000011 | | Copying to tmp table | 0.010026 | | Sending data | 0.000039 | | executing | 0.000014 | | Copying to tmp table | 0.009803 | | Sending data | 0.000023 | | executing | 0.000012 | | Copying to tmp table | 0.009774 | | Sending data | 0.000023 | | executing | 0.000011 | | Copying to tmp table | 0.009808 | | Sending data | 0.000023 | | executing | 0.000012 | | Copying to tmp table | 0.009801 | | Sending data | 0.000023 | | executing | 0.000012 | | Copying to tmp table | 0.009863 | | Sending data | 0.000026 | | executing | 0.000011 | | Copying to tmp table | 0.009875 | | Sending data | 0.000025 | | executing | 0.000011 | | Copying to tmp table | 0.009796 | | Sending data | 0.000023 | | executing | 0.000011 | | Copying to tmp table | 0.009746 | | Sending data | 0.000023 | | executing | 0.000012 | | Copying to tmp table | 0.009749 | | Sending data | 0.000031 | | executing | 0.000013 | | Copying to tmp table | 0.010474 | | Sending data | 0.000035 | | executing | 0.000012 | | Copying to tmp table | 0.010014 | | Sending data | 0.000025 | | executing | 0.000011 | | Copying to tmp table | 0.007438 | | Sending data | 0.000037 | | executing | 0.000012 | | Copying to tmp table | 0.007523 | | Sending data | 0.000035 | | executing | 0.000012 | | Copying to tmp table | 0.007600 | | Sending data | 0.000034 | | executing | 0.000015 | | Copying to tmp table | 0.007685 | | Sending data | 0.000034 | | executing | 0.000012 | | Copying to tmp table | 0.010204 | | Sending data | 0.000027 | | executing | 0.000019 | | Copying to tmp table | 0.010030 | | Sending data | 0.000026 | | executing | 0.000012 | | Copying to tmp table | 0.010178 | | Sending data | 0.000028 | | executing | 0.000012 | | Copying to tmp table | 0.007682 | | Sending data | 0.000032 | | executing | 0.000011 | | Copying to tmp table | 0.007562 | | Sending data | 0.000033 | | executing | 0.000011 | | Copying to tmp table | 0.007616 | | Sending data | 0.000029 | | executing | 0.000015 | | Copying to tmp table | 0.007688 | | Sending data | 0.000032 | | executing | 0.000012 | | Copying to tmp table | 0.007548 | | Sending data | 0.000028 | | executing | 0.000013 | | Copying to tmp table | 0.007573 | | Sending data | 0.000035 | | executing | 0.000015 | | Copying to tmp table | 0.007553 | | Sending data | 0.000028 | | executing | 0.000019 | | Copying to tmp table | 0.007559 | | Sending data | 0.000037 | | executing | 0.000012 | | Copying to tmp table | 0.007589 | | Sending data | 0.000030 | | executing | 0.000011 | | Copying to tmp table | 0.007623 | | Sending data | 0.000032 | | executing | 0.000014 | | Copying to tmp table | 0.007590 | | Sending data | 0.000030 | | executing | 0.000012 | | Copying to tmp table | 0.007574 | | Sending data | 0.000031 | | executing | 0.000013 | | Copying to tmp table | 0.007824 | | Sending data | 0.000033 | | executing | 0.000012 | | Copying to tmp table | 0.007610 | | Sending data | 0.000032 | | executing | 0.000017 | | Copying to tmp table | 0.007576 | | Sending data | 0.000028 | | executing | 0.000014 | | Copying to tmp table | 0.007578 | | Sending data | 0.000034 | | executing | 0.000013 | | Copying to tmp table | 0.007640 | | Sending data | 0.000028 | | executing | 0.000012 | | Copying to tmp table | 0.007600 | | Sending data | 0.000032 | | executing | 0.000012 | | Copying to tmp table | 0.007640 | | Sending data | 0.000028 | | executing | 0.000011 | | Copying to tmp table | 0.007596 | | Sending data | 0.000034 | | executing | 0.000012 | | Copying to tmp table | 0.007838 | | Sending data | 0.000029 | | executing | 0.000013 | | Copying to tmp table | 0.007869 | | Sending data | 0.000032 | | executing | 0.000012 | | Copying to tmp table | 0.007881 | | Sending data | 0.000028 | | executing | 0.000012 | | Copying to tmp table | 0.007848 | | Sending data | 0.000034 | | executing | 0.000016 | | Copying to tmp table | 0.007829 | | Sending data | 0.000028 | | executing | 0.000011 | | Copying to tmp table | 0.007850 | | Sending data | 0.000032 | | executing | 0.000013 | | Copying to tmp table | 0.007846 | | Sending data | 0.000028 | | executing | 0.000011 | | Copying to tmp table | 0.007762 | | Sending data | 0.000031 | | executing | 0.000012 | | Copying to tmp table | 0.007807 | | Sending data | 0.000028 | | executing | 0.000012 | | Copying to tmp table | 0.007802 | | Sending data | 0.000031 | | executing | 0.000012 | | Copying to tmp table | 0.007949 | | Sending data | 0.000034 | | executing | 0.000012 | | Copying to tmp table | 0.007847 | | Sending data | 0.000027 | | executing | 0.000015 | | Copying to tmp table | 0.007867 | | Sending data | 0.000031 | | executing | 0.000012 | | Copying to tmp table | 0.007910 | | Sending data | 0.000028 | | executing | 0.000013 | | Copying to tmp table | 0.007810 | | Sending data | 0.000030 | | executing | 0.000012 | | Copying to tmp table | 0.007921 | | Sending data | 0.000028 | | executing | 0.000012 | | Copying to tmp table | 0.007937 | | Sending data | 0.000032 | | executing | 0.000012 | | Copying to tmp table | 0.007897 | | Sending data | 0.000027 | | executing | 0.000011 | | Copying to tmp table | 0.007916 | | Sending data | 0.000032 | | executing | 0.000012 | | Copying to tmp table | 0.010635 | | Sending data | 0.000026 | | executing | 0.000012 | | Copying to tmp table | 0.010220 | | Sending data | 0.000024 | | executing | 0.000011 | | Copying to tmp table | 0.009825 | | Sending data | 0.000024 | | executing | 0.000013 | | Copying to tmp table | 0.009864 | | Sending data | 0.000030 | | executing | 0.000012 | | Copying to tmp table | 0.009681 | | Sending data | 0.000025 | | executing | 0.000011 | | Copying to tmp table | 0.009721 | | Sending data | 0.000023 | | executing | 0.000012 | | Copying to tmp table | 0.009716 | | Sending data | 0.000023 | | executing | 0.000013 | | Copying to tmp table | 0.009742 | | Sending data | 0.000024 | | executing | 0.000011 | | Copying to tmp table | 0.009804 | | Sending data | 0.000024 | | executing | 0.000012 | | Copying to tmp table | 0.007737 | | Sending data | 0.000034 | | executing | 0.000012 | | Copying to tmp table | 0.009820 | | Sending data | 0.000024 | | executing | 0.000011 | | Copying to tmp table | 0.009820 | | Sending data | 0.000023 | | executing | 0.000013 | | Copying to tmp table | 0.009869 | | Sending data | 0.000023 | | executing | 0.000011 | | Copying to tmp table | 0.009892 | | Sending data | 0.000024 | | executing | 0.000011 | | Copying to tmp table | 0.009886 | | Sending data | 0.000025 | | executing | 0.000016 | | Copying to tmp table | 0.007693 | | Sending data | 0.000027 | | executing | 0.000011 | | Copying to tmp table | 0.007677 | | Sending data | 0.000034 | | executing | 0.000012 | | Copying to tmp table | 0.008322 | | Sending data | 0.000029 | | executing | 0.000012 | | Copying to tmp table | 0.008416 | | Sending data | 0.000031 | | executing | 0.000014 | | Copying to tmp table | 0.008390 | | Sending data | 0.000028 | | executing | 0.000011 | | Copying to tmp table | 0.008406 | | Sending data | 0.000031 | | executing | 0.000012 | | Copying to tmp table | 0.008321 | | Sending data | 0.000027 | | executing | 0.000012 | | Copying to tmp table | 0.008373 | | Sending data | 0.000029 | | executing | 0.000013 | | Copying to tmp table | 0.007703 | | Sending data | 0.000025 | | executing | 0.000011 | | Copying to tmp table | 0.007655 | | Sending data | 0.000027 | | executing | 0.000012 | | Copying to tmp table | 0.008365 | | Sending data | 0.000025 | | executing | 0.000012 | | Copying to tmp table | 0.008347 | | Sending data | 0.000030 | | executing | 0.000012 | | Copying to tmp table | 0.008336 | | Sending data | 0.000027 | | executing | 0.000012 | | Copying to tmp table | 0.008379 | | Sending data | 0.000029 | | executing | 0.000012 | | Copying to tmp table | 0.007675 | | Sending data | 0.000027 | | executing | 0.000012 | | Copying to tmp table | 0.007683 | | Sending data | 0.000028 | | executing | 0.000012 | | Copying to tmp table | 0.008359 | | Sending data | 0.000027 | | executing | 0.000012 | | Copying to tmp table | 0.008209 | | Sending data | 0.000031 | | executing | 0.000012 | | Copying to tmp table | 0.007731 | | Sending data | 0.000030 | | executing | 0.000013 | | Copying to tmp table | 0.007736 | | Sending data | 0.000030 | | executing | 0.000012 | | Copying to tmp table | 0.008320 | | Sending data | 0.000026 | | executing | 0.000014 | | Copying to tmp table | 0.008398 | | Sending data | 0.000028 | | executing | 0.000015 | | Copying to tmp table | 0.008375 | | Sending data | 0.000027 | | executing | 0.000011 | | Copying to tmp table | 0.008336 | | Sending data | 0.000029 | | executing | 0.000011 | | Copying to tmp table | 0.008401 | | Sending data | 0.000026 | | executing | 0.000011 | | Copying to tmp table | 0.008287 | | Sending data | 0.000050 | | executing | 0.000017 | | Copying to tmp table | 0.008261 | | Sending data | 0.000030 | | executing | 0.000015 | | Copying to tmp table | 0.008195 | | Sending data | 0.000032 | | executing | 0.000011 | | Copying to tmp table | 0.008293 | | Sending data | 0.000026 | | executing | 0.000011 | | Copying to tmp table | 0.008372 | | Sending data | 0.000030 | | executing | 0.000011 | | Copying to tmp table | 0.008322 | | Sending data | 0.000026 | | executing | 0.000011 | | Copying to tmp table | 0.008328 | | Sending data | 0.000028 | | executing | 0.000011 | | Copying to tmp table | 0.008300 | | Sending data | 0.000029 | | executing | 0.000012 | | Copying to tmp table | 0.008361 | | Sending data | 0.000031 | | executing | 0.000012 | | Copying to tmp table | 0.007872 | | Sending data | 0.000025 | | executing | 0.000013 | | Copying to tmp table | 0.007888 | | Sending data | 0.000031 | | executing | 0.000012 | | Copying to tmp table | 0.007905 | | Sending data | 0.000026 | | executing | 0.000011 | | Copying to tmp table | 0.007925 | | Sending data | 0.000031 | | executing | 0.000011 | | Copying to tmp table | 0.007889 | | Sending data | 0.000025 | | executing | 0.000011 | | Copying to tmp table | 0.007861 | | Sending data | 0.000031 | | executing | 0.000011 | | Copying to tmp table | 0.007949 | | Sending data | 0.000026 | | executing | 0.000014 | | Copying to tmp table | 0.007832 | | Sending data | 0.000030 | | executing | 0.000011 | | Copying to tmp table | 0.007857 | | Sending data | 0.000025 | | executing | 0.000011 | | Copying to tmp table | 0.007932 | | Sending data | 0.000032 | | executing | 0.000011 | | Copying to tmp table | 0.007919 | | Sending data | 0.000026 | | executing | 0.000012 | | Copying to tmp table | 0.008259 | | Sending data | 0.000031 | | executing | 0.000011 | | Copying to tmp table | 0.007934 | | Sending data | 0.000029 | | executing | 0.000012 | | Copying to tmp table | 0.007919 | | Sending data | 0.000030 | | executing | 0.000012 | | Copying to tmp table | 0.007972 | | Sending data | 0.000026 | | executing | 0.000014 | | Copying to tmp table | 0.007963 | | Sending data | 0.000034 | | executing | 0.000012 | | Copying to tmp table | 0.008318 | | Sending data | 0.000026 | | executing | 0.000011 | | Copying to tmp table | 0.008338 | | Sending data | 0.000032 | | executing | 0.000012 | | Copying to tmp table | 0.008299 | | Sending data | 0.000032 | | executing | 0.000016 | | Copying to tmp table | 0.009747 | | Sending data | 0.000023 | | executing | 0.000017 | | Copying to tmp table | 0.009698 | | Sending data | 0.000024 | | executing | 0.000011 | | Copying to tmp table | 0.007937 | | Sending data | 0.000027 | | executing | 0.000011 | | Copying to tmp table | 0.007905 | | Sending data | 0.000031 | | executing | 0.000012 | | Copying to tmp table | 0.008536 | | Sending data | 0.000039 | | executing | 0.000014 | | Copying to tmp table | 0.008691 | | Sending data | 0.000040 | | executing | 0.000011 | | Copying to tmp table | 0.008020 | | Sending data | 0.000027 | | executing | 0.000012 | | Copying to tmp table | 0.007684 | | Sending data | 0.000033 | | executing | 0.000016 | | Copying to tmp table | 0.007749 | | Sending data | 0.000026 | | executing | 0.000012 | | Copying to tmp table | 0.007711 | | Sending data | 0.000034 | | executing | 0.000012 | | Copying to tmp table | 0.007653 | | Sending data | 0.000026 | | executing | 0.000011 | | Copying to tmp table | 0.007688 | | Sending data | 0.000031 | | executing | 0.000012 | | Copying to tmp table | 0.007725 | | Sending data | 0.000027 | | executing | 0.000011 | | Copying to tmp table | 0.007905 | | Sending data | 0.000034 | | executing | 0.000012 | | Copying to tmp table | 0.008354 | | Sending data | 0.000027 | | executing | 0.000011 | | Copying to tmp table | 0.008340 | | Sending data | 0.000046 | | executing | 0.000016 | | Copying to tmp table | 0.008342 | | Sending data | 0.000026 | | executing | 0.000011 | | Copying to tmp table | 0.008348 | | Sending data | 0.000029 | | executing | 0.000011 | | Copying to tmp table | 0.008317 | | Sending data | 0.000026 | | executing | 0.000011 | | Copying to tmp table | 0.008342 | | Sending data | 0.000029 | | executing | 0.000013 | | Copying to tmp table | 0.008334 | | Sending data | 0.000026 | | executing | 0.000011 | | Copying to tmp table | 0.008368 | | Sending data | 0.000029 | | executing | 0.000011 | | Copying to tmp table | 0.008330 | | Sending data | 0.000027 | | executing | 0.000011 | | Copying to tmp table | 0.008315 | | Sending data | 0.000029 | | executing | 0.000013 | | Copying to tmp table | 0.008333 | | Sending data | 0.000030 | | executing | 0.000012 | | Copying to tmp table | 0.008377 | | Sending data | 0.000030 | | executing | 0.000012 | | Copying to tmp table | 0.008322 | | Sending data | 0.000026 | | executing | 0.000011 | | Copying to tmp table | 0.008360 | | Sending data | 0.000032 | | executing | 0.000013 | | Copying to tmp table | 0.008336 | | Sending data | 0.000029 | | executing | 0.000012 | | Copying to tmp table | 0.008356 | | Sending data | 0.000029 | | executing | 0.000027 | | Copying to tmp table | 0.008329 | | Sending data | 0.000026 | | executing | 0.000014 | | Copying to tmp table | 0.008335 | | Sending data | 0.000029 | | executing | 0.000011 | | Copying to tmp table | 0.008237 | | Sending data | 0.000025 | | executing | 0.000032 | | Copying to tmp table | 0.008347 | | Sending data | 0.000027 | | executing | 0.000014 | | Copying to tmp table | 0.008353 | | Sending data | 0.000034 | | executing | 0.000012 | | Copying to tmp table | 0.007910 | | Sending data | 0.000026 | | executing | 0.000013 | | Copying to tmp table | 0.007877 | | Sending data | 0.000028 | | executing | 0.000012 | | Copying to tmp table | 0.007915 | | Sending data | 0.000028 | | executing | 0.000011 | | Copying to tmp table | 0.007925 | | Sending data | 0.000027 | | executing | 0.000012 | | Copying to tmp table | 0.007901 | | Sending data | 0.000026 | | executing | 0.000016 | | Copying to tmp table | 0.007821 | | Sending data | 0.000029 | | executing | 0.000011 | | Copying to tmp table | 0.008169 | | Sending data | 0.000025 | | executing | 0.000011 | | Copying to tmp table | 0.008365 | | Sending data | 0.000026 | | executing | 0.000014 | | Copying to tmp table | 0.008381 | | Sending data | 0.000029 | | executing | 0.000011 | | Copying to tmp table | 0.008388 | | Sending data | 0.000025 | | executing | 0.000011 | | Copying to tmp table | 0.008368 | | Sending data | 0.000026 | | executing | 0.000012 | | Copying to tmp table | 0.008345 | | Sending data | 0.000033 | | executing | 0.000012 | | Copying to tmp table | 0.008380 | | Sending data | 0.000025 | | executing | 0.000011 | | Copying to tmp table | 0.008299 | | Sending data | 0.000026 | | executing | 0.000011 | | Copying to tmp table | 0.008265 | | Sending data | 0.000030 | | executing | 0.000011 | | Copying to tmp table | 0.008330 | | Sending data | 0.000026 | | executing | 0.000011 | | Copying to tmp table | 0.008339 | | Sending data | 0.000028 | | executing | 0.000011 | | Copying to tmp table | 0.008406 | | Sending data | 0.000030 | | executing | 0.000012 | | Copying to tmp table | 0.007844 | | Sending data | 0.000043 | | executing | 0.000012 | | Copying to tmp table | 0.007863 | | Sending data | 0.000027 | | executing | 0.000011 | | Copying to tmp table | 0.007772 | | Sending data | 0.000029 | | executing | 0.000011 | | Copying to tmp table | 0.007834 | | Sending data | 0.000028 | | executing | 0.000012 | | Copying to tmp table | 0.007872 | | Sending data | 0.000026 | | executing | 0.000044 | | Copying to tmp table | 0.007881 | | Sending data | 0.000029 | | executing | 0.000030 | | Copying to tmp table | 0.008293 | | Sending data | 0.000025 | | executing | 0.000011 | | Copying to tmp table | 0.008348 | | Sending data | 0.000026 | | executing | 0.000012 | | Copying to tmp table | 0.008292 | | Sending data | 0.000030 | | executing | 0.000012 | | Copying to tmp table | 0.008318 | | Sending data | 0.000025 | | executing | 0.000014 | | Copying to tmp table | 0.008277 | | Sending data | 0.000026 | | executing | 0.000019 | | Copying to tmp table | 0.008359 | | Sending data | 0.000029 | | executing | 0.000011 | | Copying to tmp table | 0.008343 | | Sending data | 0.000025 | | executing | 0.000011 | | Copying to tmp table | 0.008335 | | Sending data | 0.000054 | | executing | 0.000014 | | Copying to tmp table | 0.008314 | | Sending data | 0.000030 | | executing | 0.000012 | | Copying to tmp table | 0.008208 | | Sending data | 0.000025 | | executing | 0.000012 | | Copying to tmp table | 0.008228 | | Sending data | 0.000027 | | executing | 0.000011 | | Copying to tmp table | 0.008218 | | Sending data | 0.000028 | | executing | 0.000012 | | Copying to tmp table | 0.009858 | | Sending data | 0.000039 | | executing | 0.000014 | | Copying to tmp table | 0.009713 | | Sending data | 0.000026 | | executing | 0.000011 | | Copying to tmp table | 0.009656 | | Sending data | 0.000024 | | executing | 0.000013 | | Copying to tmp table | 0.009725 | | Sending data | 0.000019 | | executing | 0.000011 | | Copying to tmp table | 0.009802 | | Sending data | 0.000027 | | executing | 0.000013 | | Copying to tmp table | 0.009775 | | Sending data | 0.000019 | | executing | 0.000023 | | Copying to tmp table | 0.009801 | | Sending data | 0.000024 | | executing | 0.000012 | | Copying to tmp table | 0.009811 | | Sending data | 0.000025 | | executing | 0.000012 | | Copying to tmp table | 0.009789 | | Sending data | 0.000019 | | executing | 0.000014 | | Copying to tmp table | 0.009807 | | Sending data | 0.000024 | | executing | 0.000012 | | Copying to tmp table | 0.009783 | | Sending data | 0.000026 | | executing | 0.000011 | | Copying to tmp table | 0.009797 | | Sending data | 0.000023 | | executing | 0.000011 | | Copying to tmp table | 0.009810 | | Sending data | 0.000025 | | executing | 0.000015 | | Copying to tmp table | 0.007880 | | Sending data | 0.000030 | | executing | 0.000012 | | Copying to tmp table | 0.009745 | | Sending data | 0.000031 | | executing | 0.000012 | | Copying to tmp table | 0.009796 | | Sending data | 0.000023 | | executing | 0.000011 | | Copying to tmp table | 0.009800 | | Sending data | 0.000025 | | executing | 0.000011 | | Copying to tmp table | 0.009831 | | Sending data | 0.000023 | | executing | 0.000015 | | Copying to tmp table | 0.009768 | | Sending data | 0.000032 | | executing | 0.000015 | | Copying to tmp table | 0.009769 | | Sending data | 0.000024 | | executing | 0.000011 | | Copying to tmp table | 0.009814 | | Sending data | 0.000025 | | executing | 0.000013 | | Copying to tmp table | 0.009757 | | Sending data | 0.000022 | | executing | 0.000011 | | Copying to tmp table | 0.009770 | | Sending data | 0.000024 | | executing | 0.000017 | | Copying to tmp table | 0.009806 | | Sending data | 0.000023 | | executing | 0.000011 | | Copying to tmp table | 0.009734 | | Sending data | 0.000023 | | executing | 0.000011 | | Copying to tmp table | 0.009792 | | Sending data | 0.000023 | | executing | 0.000013 | | Copying to tmp table | 0.009761 | | Sending data | 0.000026 | | executing | 0.000012 | | Copying to tmp table | 0.009747 | | Sending data | 0.000024 | | executing | 0.000011 | | Copying to tmp table | 0.009762 | | Sending data | 0.000025 | | executing | 0.000011 | | Copying to tmp table | 0.009796 | | Sending data | 0.000025 | | executing | 0.000011 | | Copying to tmp table | 0.009813 | | Sending data | 0.000034 | | executing | 0.000015 | | Copying to tmp table | 0.009805 | | Sending data | 0.000026 | | executing | 0.000013 | | Copying to tmp table | 0.009761 | | Sending data | 0.000023 | | executing | 0.000012 | | Copying to tmp table | 0.009743 | | Sending data | 0.000027 | | executing | 0.000012 | | Copying to tmp table | 0.009772 | | Sending data | 0.000023 | | executing | 0.000011 | | Copying to tmp table | 0.009962 | | Sending data | 0.000042 | | Sending data | 0.000038 | | end | 0.000012 | | removing tmp table | 0.000016 | | end | 0.000012 | | removing tmp table | 0.000014 | | end | 0.000012 | | query end | 0.000014 | | closing tables | 0.000021 | | freeing items | 0.000029 | | logging slow query | 0.000012 | | cleaning up | 0.000014 | +--------------------------------+----------+ 2565 rows in set (0.02 sec) mysql> explain SELECT DISTINCT g.* FROM groups g,hosts_groups hg,hosts h WHERE ((g.groupid BETWEEN 100000000000000 AND 199999999999999) OR (g.groupid BETWEEN 200000000000000 AND 299999999999999)) AND hg.groupid=g.groupid AND h.hostid=hg.hostid AND h.status=0 AND EXISTS( SELECT DISTINCT i.itemid FROM items i, graphs_items gi WHERE i.hostid=hg.hostid AND i.itemid=gi.itemid); +----+--------------------+-------+--------+-------------------------------+----------------+---------+---------------------+------+------------------------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +----+--------------------+-------+--------+-------------------------------+----------------+---------+---------------------+------+------------------------------+ | 1 | PRIMARY | h | ref | PRIMARY,hosts_2 | hosts_2 | 4 | const | 415 | Using index; Using temporary | | 1 | PRIMARY | hg | ref | hosts_groups_1,hosts_groups_2 | hosts_groups_1 | 8 | zabbix18.h.hostid | 1 | Using where; Using index | | 1 | PRIMARY | g | eq_ref | PRIMARY | PRIMARY | 8 | zabbix18.hg.groupid | 1 | | | 2 | DEPENDENT SUBQUERY | gi | ALL | NULL | NULL | NULL | NULL | 5995 | Using temporary | | 2 | DEPENDENT SUBQUERY | i | eq_ref | PRIMARY,items_1 | PRIMARY | 8 | zabbix18.gi.itemid | 1 | Using where | +----+--------------------+-------+--------+-------------------------------+----------------+---------+---------------------+------+------------------------------+ 5 rows in set (0.00 sec) mysql>