patrickkasie
Verified User
Dear DirectAdmin forum,
I have noticed a spike of MySQL queries being lined up without understanding why or how they are happening. Is this a problem, or is this regular use? My first instinct is that this is not normal behavior I'm looking at here.
I acknowledge the similar IP addresses starting with 93. It has also happened with IP addresses starting with 102 or 105 on a later date.
I have noticed a spike of MySQL queries being lined up without understanding why or how they are happening. Is this a problem, or is this regular use? My first instinct is that this is not normal behavior I'm looking at here.
I acknowledge the similar IP addresses starting with 93. It has also happened with IP addresses starting with 102 or 105 on a later date.
Code:
This is an automated message notifying you that the 5 minute load average on your system is 27.37.
This has exceeded the 10 threshold.
One Minute - 74.01
Five Minutes - 27.37
Fifteen Minutes - 10.07
top - 20:11:01 up 1 day, 9:17, 0 users, load average: 76.09, 28.58, 10.55
Tasks: 292 total, 82 running, 210 sleeping, 0 stopped, 0 zombie
%Cpu(s): 58.6 us, 41.4 sy, 0.0 ni, 0.0 id, 0.0 wa, 0.0 hi, 0.0 si, 0.0 st
KiB Mem : 3879968 total, 226212 free, 2738632 used, 915124 buff/cache
KiB Swap: 1048572 total, 1036992 free, 11580 used. 835240 avail Mem
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
860 mysql 20 0 1669508 275684 6996 S 56.3 7.1 109:26.67 /usr/sbin/mysqld
24945 crystal 20 0 298764 23476 5040 R 2.9 0.6 0:02.15 php-fpm: pool crystal
24950 crystal 20 0 298764 23460 5036 R 2.9 0.6 0:02.10 php-fpm: pool crystal
24954 crystal 20 0 302860 27304 5036 R 2.9 0.7 0:01.68 php-fpm: pool crystal
24962 crystal 20 0 302860 27328 5032 R 2.9 0.7 0:01.66 php-fpm: pool crystal
24968 crystal 20 0 302860 26248 5040 R 2.9 0.7 0:01.54 php-fpm: pool crystal
24984 crystal 20 0 300748 23932 5036 R 2.9 0.6 0:01.32 php-fpm: pool crystal
25027 crystal 20 0 302860 26052 5036 R 2.9 0.7 0:01.48 php-fpm: pool crystal
25189 crystal 20 0 300812 24264 5040 R 2.9 0.6 0:01.31 php-fpm: pool crystal
25191 crystal 20 0 302796 26220 5036 R 2.9 0.7 0:01.49 php-fpm: pool crystal
25192 crystal 20 0 300812 24236 5040 R 2.9 0.6 0:01.33 php-fpm: pool crystal
25195 crystal 20 0 302860 25492 5036 R 2.9 0.7 0:01.42 php-fpm: pool crystal
25230 crystal 20 0 298700 22776 5024 R 2.9 0.6 0:01.30 php-fpm: pool crystal
25251 crystal 20 0 300748 24704 5036 R 2.9 0.6 0:01.32 php-fpm: pool crystal
24943 crystal 20 0 298700 23464 5036 R 1.9 0.6 0:02.09 php-fpm: pool crystal
24944 crystal 20 0 298764 23488 5040 R 1.9 0.6 0:02.15 php-fpm: pool crystal
24946 crystal 20 0 300812 24344 5044 R 1.9 0.6 0:02.18 php-fpm: pool crystal
24949 crystal 20 0 302860 25736 5036 R 1.9 0.7 0:01.50 php-fpm: pool crystal
24951 crystal 20 0 298764 23448 5036 R 1.9 0.6 0:02.01 php-fpm: pool crystal
24957 crystal 20 0 302796 27132 5016 R 1.9 0.7 0:01.65 php-fpm: pool crystal
24960 crystal 20 0 299176 23688 5036 R 1.9 0.6 0:01.89 php-fpm: pool crystal
24967 crystal 20 0 298764 23372 5032 R 1.9 0.6 0:01.67 php-fpm: pool crystal
24969 crystal 20 0 298764 23280 5036 R 1.9 0.6 0:01.73 php-fpm: pool crystal
Connection counts:
1 114.119.139.70
1 40.77.167.33
1 40.77.167.43
1 50.225.222.218
1 54.36.148.12
1 54.36.148.46
1 66.249.76.134
1 92.67.140.57
1 93.158.91.250
1 93.158.91.252
2 93.158.91.239
2 93.158.91.241
2 93.158.91.244
2 93.158.91.253
IP '93.158.91.253' currently has '2' connections
Connection info for '93.158.91.253':
tcp6 32 0 37.97.169.253:443 93.158.91.253:50571 CLOSE_WAIT
tcp6 0 0 37.97.169.253:443 93.158.91.253:48789 TIME_WAIT
Top Memory Usage:
mysql 860 5.4 7.1 1669508 275684 ? Ssl Jan30 109:31 /usr/sbin/mysqld
root 1636 0.0 2.4 333132 93136 ? S 03:11 0:00 spamd child
root 1635 0.0 2.4 333132 93136 ? S 03:11 0:00 spamd child
root 1632 0.0 2.4 333132 96092 ? Ss 03:11 0:12 spamd
named 2538 0.0 1.5 247492 60372 ? Ssl Jan30 0:01 /usr/sbin/named -u named -c /etc/named.conf
apache 28805 0.1 0.9 2163116 35752 ? Sl 00:11 1:44 /usr/sbin/httpd -DFOREGROUND
apache 28643 0.1 0.8 2294360 34056 ? Sl 00:11 1:32 /usr/sbin/httpd -DFOREGROUND
root 868 0.0 0.7 1930680 27700 ? Ssl Jan30 0:41 /usr/local/directadmin/directadmin server --syslog
crystal 25027 1.3 0.7 302860 27432 ? S 20:09 0:01 php-fpm: pool crystal
crystal 24977 1.4 0.7 302860 27400 ? R 20:09 0:01 php-fpm: pool crystal
Virtual Memory Info:
procs -----------------------memory---------------------- ---swap-- -----io---- -system-- --------cpu-------- -----timestamp-----
r b swpd free buff cache si so bi bo in cs us sy id wa st CET
42 0 11580 150044 24 916824 0 0 66 44 24 96 6 4 90 0 0 2024-01-31 20:11:09
32 0 11580 169440 24 916856 0 0 12 457 2617 7832 60 40 0 0 0 2024-01-31 20:11:10
58 0 11580 165660 24 916876 0 0 80 318 2480 7666 59 41 0 0 0 2024-01-31 20:11:11
Current MySQL Queries
21901 crystal_db localhost crystal_db Query 0 Sending data SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '297' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) 0.000
21904 crystal_db localhost crystal_db Query 0 Sending data SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '297' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) 0.000
21905 crystal_db localhost crystal_db Query 0 Sending data SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '107' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) 0.000
21906 crystal_db localhost crystal_db Query 0 Sending data SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '59' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) 0.000
21909 crystal_db localhost crystal_db Query 0 Sending data SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '300' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) 0.000
21913 crystal_db localhost crystal_db Query 0 Sending data SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '199' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) 0.000
21917 crystal_db localhost crystal_db Query 0 Sending data SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '211' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) 0.000
21918 crystal_db localhost crystal_db Sleep 0 NULL 0.000
21919 crystal_db localhost crystal_db Query 0 Sending data SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '189' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) 0.000
21921 crystal_db localhost crystal_db Query 0 Sending data SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '85' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) 0.000
21923 crystal_db localhost crystal_db Sleep 0 NULL 0.000
21925 crystal_db localhost crystal_db Query 0 Removing tmp table SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '1') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '244' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) 0.000
21926 crystal_db localhost crystal_db Query 0 Sending data SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '279' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) 0.000
21927 crystal_db localhost crystal_db Query 0 Sending data SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '85' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) 0.000
21928 crystal_db localhost crystal_db Query 0 Sending data SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '107' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) 0.000
21929 crystal_db localhost crystal_db Query 0 Removing tmp table SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '245' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) 0.000
21930 crystal_db localhost crystal_db Query 0 Sending data SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '0' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) 0.000
21931 crystal_db localhost crystal_db Query 0 Sending data SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '101' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' 0.000
21932 crystal_db localhost crystal_db Query 0 Sending data SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '221' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) 0.000
21933 crystal_db localhost crystal_db Sleep 0 NULL 0.000
21935 crystal_db localhost crystal_db Query 0 Sending data SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '221' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) 0.000
21936 crystal_db localhost crystal_db Query 0 Sending data SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '151' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) 0.000
21937 crystal_db localhost crystal_db Query 0 Sending data SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '159' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) 0.000
21938 crystal_db localhost crystal_db Query 0 Sending data SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '179' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) 0.000
21939 crystal_db localhost crystal_db Query 0 Sending data SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '269' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' 0.000
21940 crystal_db localhost crystal_db Query 0 Sending data SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '225' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) 0.000
21941 crystal_db localhost crystal_db Query 0 Sending data SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '308' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) 0.000
21942 crystal_db localhost crystal_db Query 0 Sending data SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '127' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) 0.000
21943 crystal_db localhost crystal_db Query 0 Sending data SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '115' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) 0.000
21944 crystal_db localhost crystal_db Query 0 Removing tmp table SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '270' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) 0.000
21945 crystal_db localhost crystal_db Query 0 Sending data SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '67' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) 0.000
21946 crystal_db localhost crystal_db Query 0 Sending data SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '67' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) 0.000
21947 crystal_db localhost crystal_db Query 0 Sending data SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '59' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) 0.000
21948 crystal_db localhost crystal_db Query 0 Sending data SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '304' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) 0.000
21949 crystal_db localhost crystal_db Query 0 Sending data SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '319' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) 0.000
21950 crystal_db localhost crystal_db Query 0 Sending data SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '293' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) 0.000
21951 crystal_db localhost crystal_db Query 0 Sending data SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '298' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) 0.000
21952 crystal_db localhost crystal_db Query 0 Sending data SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '310' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) 0.000
21953 crystal_db localhost crystal_db Query 0 Sending data SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '91' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) 0.000
21954 crystal_db localhost crystal_db Query 0 Sending data SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '179' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) 0.000
21955 crystal_db localhost crystal_db Query 0 Sending data SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '173' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) 0.000
21956 crystal_db localhost crystal_db Query 0 Sending data SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '103' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) 0.000
21957 crystal_db localhost crystal_db Query 0 Sending data SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '91' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) 0.000
21958 crystal_db localhost crystal_db Query 0 Sending data SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '308' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) 0.000
21960 crystal_db localhost crystal_db Query 0 Sending data SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '99' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) 0.000
21961 crystal_db localhost crystal_db Query 0 Sending data SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '61' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) 0.000
21962 crystal_db localhost crystal_db Query 0 Sending data SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '167' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) 0.000
21963 crystal_db localhost crystal_db Query 0 Sending data SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '115' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) 0.000
21964 crystal_db localhost crystal_db Query 0 Sending data SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '274' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) 0.000
21965 crystal_db localhost crystal_db Query 0 Sending data SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '113' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) 0.000
21966 crystal_db localhost crystal_db Query 0 Sending data SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '239' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) 0.000
21967 crystal_db localhost crystal_db Query 0 Sending data SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '101' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' 0.000
21968 crystal_db localhost crystal_db Query 0 Sending data SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '111' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) 0.000
21969 crystal_db localhost crystal_db Query 0 Sending data SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '179' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) 0.000
21970 crystal_db localhost crystal_db Query 0 Sending data SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '308' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) 0.000
21971 crystal_db localhost crystal_db Query 0 Sending data SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '195' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) 0.000
21972 crystal_db localhost crystal_db Query 0 Sending data SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '167' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) 0.000
21973 crystal_db localhost crystal_db Query 0 Sending data SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '320' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) 0.000
21974 crystal_db localhost crystal_db Query 0 Sending data SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '167' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' 0.000
21975 crystal_db localhost crystal_db Query 0 Sending data SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '113' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) 0.000
21976 crystal_db localhost crystal_db Query 0 Sending data SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '296' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) 0.000
21977 crystal_db localhost crystal_db Query 0 Sending data SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '298' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) 0.000
21978 crystal_db localhost crystal_db Query 0 Sending data SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '75' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) 0.000
21979 crystal_db localhost crystal_db Query 0 Sending data SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '199' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) 0.000
21980 crystal_db localhost crystal_db Query 0 Sending data SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '298' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) 0.000
21981 crystal_db localhost crystal_db Query 0 Sending data SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '89' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' 0.000
21982 crystal_db localhost crystal_db Query 0 Sending data SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '269' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' 0.000
21983 crystal_db localhost crystal_db Query 0 Sending data SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '67' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) 0.000
21984 crystal_db localhost crystal_db Query 0 Removing tmp table SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '83' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) 0.000
21985 crystal_db localhost crystal_db Query 0 Sending data SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '269' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) 0.000
21986 crystal_db localhost crystal_db Query 0 Removing tmp table SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '207' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) 0.000
21987 crystal_db localhost crystal_db Sleep 0 NULL 0.000
21988 crystal_db localhost crystal_db Sleep 0 NULL 0.000
21989 crystal_db localhost crystal_db Sleep 0 NULL 0.000
21990 crystal_db localhost crystal_db Sleep 0 NULL 0.000
21991 crystal_db localhost crystal_db Sleep 0 NULL 0.000
21992 crystal_db localhost crystal_db Sleep 0 NULL 0.000
21993 crystal_db localhost crystal_db Sleep 0 NULL 0.000
21994 crystal_db localhost crystal_db Sleep 0 NULL 0.000
21995 crystal_db localhost crystal_db Sleep 0 NULL 0.000
21996 crystal_db localhost crystal_db Sleep 0 NULL 0.000
21997 crystal_db localhost crystal_db Sleep 0 NULL 0.000
21998 crystal_db localhost crystal_db Sleep 1 NULL 0.000
21999 crystal_db localhost crystal_db Sleep 0 NULL 0.000
22000 crystal_db localhost crystal_db Sleep 1 NULL 0.000
22001 crystal_db localhost crystal_db Sleep 0 NULL 0.000
22002 crystal_db localhost crystal_db Sleep 0 NULL 0.000
22003 crystal_db localhost crystal_db Sleep 1 NULL 0.000
22004 crystal_db localhost crystal_db Sleep 2 NULL 0.000
22005 crystal_db localhost crystal_db Sleep 0 NULL 0.000
22006 crystal_db localhost crystal_db Query 0 Sending data SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '131' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' 0.000
22008 crystal_db localhost crystal_db Sleep 0 NULL 0.000
22009 crystal_db localhost crystal_db Sleep 0 NULL 0.000
22010 crystal_db localhost crystal_db Sleep 0 NULL 0.000
22011 crystal_db localhost crystal_db Sleep 0 NULL 0.000
22012 crystal_db localhost crystal_db Sleep 0 NULL 0.000
22013 da_admin localhost NULL Query 0 starting SHOW FULL PROCESSLIST 0.000
================================
Automated Message Generated by DirectAdmin 1.658