/usr/sbin/mariadbd, Version: 10.6.21-MariaDB-log (MariaDB Server). started with: Tcp port: 0 Unix socket: /var/lib/mysql/mysql.sock Time Id Command Argument # Time: 250425 6:38:08 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 8 Schema: excellen_vip3 QC_hit: No # Query_time: 13.608810 Lock_time: 0.000092 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 use `excellen_vip3`; SET timestamp=1745563088; select b.brandid, b.brandname, (select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1') as num from cart_brands b order by b.brandname asc; # Time: 250425 6:38:14 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 27 Schema: excellen_vip3 QC_hit: No # Query_time: 12.715774 Lock_time: 0.000060 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745563094; select b.brandid, b.brandname, (select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1') as num from cart_brands b order by b.brandname asc; # Time: 250425 6:38:16 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 30 Schema: excellen_vip3 QC_hit: No # Query_time: 12.504204 Lock_time: 0.000049 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745563096; select b.brandid, b.brandname, (select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1') as num from cart_brands b order by b.brandname asc; # Time: 250425 6:38:22 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 8 Schema: excellen_vip3 QC_hit: No # Query_time: 10.991640 Lock_time: 0.001593 Rows_sent: 5 Rows_examined: 305729 # Rows_affected: 0 Bytes_sent: 9627 SET timestamp=1745563102; SELECT p.*, pi.* FROM cart_products p LEFT JOIN cart_product_images pi ON (p.productid=pi.imageprodid AND pi.imageisthumb=1) WHERE p.prodvisible=1 AND productid != 142760 AND FIND_IN_SET(158,prodcatids)AND prodavailability='unreserved' AND prodcurrentinv!=0 AND levenshtein_ratio('(480) 480-8080',prodname)>60 ORDER BY levenshtein_ratio('(480) 480-8080',prodname) DESC LIMIT 5; # Time: 250425 6:38:28 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 27 Schema: excellen_vip3 QC_hit: No # Query_time: 12.314357 Lock_time: 0.000049 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745563108; select b.brandid, b.brandname, ( select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1' ) as num from cart_brands b order by b.brandname asc; # Time: 250425 6:38:30 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 30 Schema: excellen_vip3 QC_hit: No # Query_time: 12.638040 Lock_time: 0.000051 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745563110; select b.brandid, b.brandname, ( select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1' ) as num from cart_brands b order by b.brandname asc; # Time: 250425 6:38:33 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 8 Schema: excellen_vip3 QC_hit: No # Query_time: 11.487683 Lock_time: 0.000049 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745563113; select b.brandid, b.brandname, ( select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1' ) as num from cart_brands b order by b.brandname asc; # Time: 250425 6:38:47 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 47 Schema: excellen_vip3 QC_hit: No # Query_time: 11.171689 Lock_time: 0.000067 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745563127; select b.brandid, b.brandname, (select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1') as num from cart_brands b order by b.brandname asc; # Time: 250425 6:38:59 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 47 Schema: excellen_vip3 QC_hit: No # Query_time: 5.838116 Lock_time: 0.000589 Rows_sent: 5 Rows_examined: 305733 # Rows_affected: 0 Bytes_sent: 10757 SET timestamp=1745563139; SELECT p.*, pi.* FROM cart_products p LEFT JOIN cart_product_images pi ON (p.productid=pi.imageprodid AND pi.imageisthumb=1) WHERE p.prodvisible=1 AND productid != 241507 AND FIND_IN_SET(130,prodcatids)AND prodavailability='unreserved' AND prodcurrentinv!=0 AND levenshtein_ratio('(646) 413-6666',prodname)>60 ORDER BY levenshtein_ratio('(646) 413-6666',prodname) DESC LIMIT 5; # Time: 250425 6:38:53 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 54 Schema: excellen_vip3 QC_hit: No # Query_time: 12.811015 Lock_time: 0.000050 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745563133; select b.brandid, b.brandname, (select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1') as num from cart_brands b order by b.brandname asc; # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 56 Schema: excellen_vip3 QC_hit: No # Query_time: 12.797992 Lock_time: 0.000048 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745563133; select b.brandid, b.brandname, (select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1') as num from cart_brands b order by b.brandname asc; # Time: 250425 6:39:05 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 47 Schema: excellen_vip3 QC_hit: No # Query_time: 13.357783 Lock_time: 0.000048 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745563145; select b.brandid, b.brandname, ( select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1' ) as num from cart_brands b order by b.brandname asc; # Time: 250425 6:39:06 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 54 Schema: excellen_vip3 QC_hit: No # Query_time: 13.238631 Lock_time: 0.000062 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745563146; select b.brandid, b.brandname, ( select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1' ) as num from cart_brands b order by b.brandname asc; # Time: 250425 6:39:07 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 56 Schema: excellen_vip3 QC_hit: No # Query_time: 13.135459 Lock_time: 0.000049 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745563147; select b.brandid, b.brandname, ( select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1' ) as num from cart_brands b order by b.brandname asc; # Time: 250425 6:39:27 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 212 Schema: excellen_vip3 QC_hit: No # Query_time: 10.057945 Lock_time: 0.000080 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745563167; select b.brandid, b.brandname, (select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1') as num from cart_brands b order by b.brandname asc; # Time: 250425 6:39:41 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 212 Schema: excellen_vip3 QC_hit: No # Query_time: 10.079187 Lock_time: 0.000104 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745563181; select b.brandid, b.brandname, ( select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1' ) as num from cart_brands b order by b.brandname asc; # Time: 250425 6:39:57 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 373 Schema: excellen_vip3 QC_hit: No # Query_time: 9.952123 Lock_time: 0.000067 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745563197; select b.brandid, b.brandname, (select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1') as num from cart_brands b order by b.brandname asc; # Time: 250425 6:40:11 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 373 Schema: excellen_vip3 QC_hit: No # Query_time: 10.565117 Lock_time: 0.000108 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745563211; select b.brandid, b.brandname, ( select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1' ) as num from cart_brands b order by b.brandname asc; # Time: 250425 6:40:24 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 547 Schema: excellen_vip3 QC_hit: No # Query_time: 10.304028 Lock_time: 0.000101 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745563224; select b.brandid, b.brandname, (select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1') as num from cart_brands b order by b.brandname asc; # Time: 250425 6:40:39 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 547 Schema: excellen_vip3 QC_hit: No # Query_time: 10.459993 Lock_time: 0.000104 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745563239; select b.brandid, b.brandname, ( select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1' ) as num from cart_brands b order by b.brandname asc; # Time: 250425 6:40:52 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 648 Schema: excellen_vip3 QC_hit: No # Query_time: 10.726499 Lock_time: 0.000101 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745563252; select b.brandid, b.brandname, (select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1') as num from cart_brands b order by b.brandname asc; # Time: 250425 6:41:05 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 648 Schema: excellen_vip3 QC_hit: No # Query_time: 10.660122 Lock_time: 0.000047 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745563265; select b.brandid, b.brandname, ( select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1' ) as num from cart_brands b order by b.brandname asc; # Time: 250425 6:41:18 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 765 Schema: excellen_vip3 QC_hit: No # Query_time: 10.262611 Lock_time: 0.000067 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745563278; select b.brandid, b.brandname, (select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1') as num from cart_brands b order by b.brandname asc; # Time: 250425 6:41:29 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 765 Schema: excellen_vip3 QC_hit: No # Query_time: 32.353078 Lock_time: 0.001077 Rows_sent: 5 Rows_examined: 305729 # Rows_affected: 0 Bytes_sent: 9628 SET timestamp=1745563289; SELECT p.*, pi.* FROM cart_products p LEFT JOIN cart_product_images pi ON (p.productid=pi.imageprodid AND pi.imageisthumb=1) WHERE p.prodvisible=1 AND productid != 149286 AND FIND_IN_SET(104,prodcatids)AND prodavailability='unreserved' AND prodcurrentinv!=0 AND levenshtein_ratio('(650) 538-7777',prodname)>60 ORDER BY levenshtein_ratio('(650) 538-7777',prodname) DESC LIMIT 5; # Time: 250425 6:42:02 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 765 Schema: excellen_vip3 QC_hit: No # Query_time: 11.544989 Lock_time: 0.000055 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745563322; select b.brandid, b.brandname, ( select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1' ) as num from cart_brands b order by b.brandname asc; # Time: 250425 6:42:09 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 1039 Schema: excellen_vip3 QC_hit: No # Query_time: 10.134070 Lock_time: 0.000045 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745563329; select b.brandid, b.brandname, (select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1') as num from cart_brands b order by b.brandname asc; # Time: 250425 6:42:19 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 1039 Schema: excellen_vip3 QC_hit: No # Query_time: 32.320676 Lock_time: 0.000604 Rows_sent: 5 Rows_examined: 305729 # Rows_affected: 0 Bytes_sent: 9628 SET timestamp=1745563339; SELECT p.*, pi.* FROM cart_products p LEFT JOIN cart_product_images pi ON (p.productid=pi.imageprodid AND pi.imageisthumb=1) WHERE p.prodvisible=1 AND productid != 149286 AND FIND_IN_SET(104,prodcatids)AND prodavailability='unreserved' AND prodcurrentinv!=0 AND levenshtein_ratio('(650) 538-7777',prodname)>60 ORDER BY levenshtein_ratio('(650) 538-7777',prodname) DESC LIMIT 5; # Time: 250425 6:42:52 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 1039 Schema: excellen_vip3 QC_hit: No # Query_time: 15.698290 Lock_time: 0.000106 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745563372; select b.brandid, b.brandname, ( select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1' ) as num from cart_brands b order by b.brandname asc; # Time: 250425 6:43:01 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 1097 Schema: excellen_vip3 QC_hit: No # Query_time: 11.716553 Lock_time: 0.000047 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745563381; select b.brandid, b.brandname, (select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1') as num from cart_brands b order by b.brandname asc; # Time: 250425 6:43:16 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 1097 Schema: excellen_vip3 QC_hit: No # Query_time: 9.833888 Lock_time: 0.000054 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745563396; select b.brandid, b.brandname, ( select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1' ) as num from cart_brands b order by b.brandname asc; # Time: 250425 6:43:29 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 1250 Schema: excellen_vip3 QC_hit: No # Query_time: 10.509266 Lock_time: 0.000100 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745563409; select b.brandid, b.brandname, (select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1') as num from cart_brands b order by b.brandname asc; # Time: 250425 6:43:45 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 1250 Schema: excellen_vip3 QC_hit: No # Query_time: 10.200080 Lock_time: 0.000104 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745563425; select b.brandid, b.brandname, ( select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1' ) as num from cart_brands b order by b.brandname asc; # Time: 250425 6:43:58 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 1407 Schema: excellen_vip3 QC_hit: No # Query_time: 10.170902 Lock_time: 0.000099 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745563438; select b.brandid, b.brandname, (select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1') as num from cart_brands b order by b.brandname asc; # Time: 250425 6:44:12 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 1407 Schema: excellen_vip3 QC_hit: No # Query_time: 9.771835 Lock_time: 0.000108 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745563452; select b.brandid, b.brandname, ( select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1' ) as num from cart_brands b order by b.brandname asc; # Time: 250425 6:44:24 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 1494 Schema: excellen_vip3 QC_hit: No # Query_time: 9.477407 Lock_time: 0.000066 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745563464; select b.brandid, b.brandname, (select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1') as num from cart_brands b order by b.brandname asc; # Time: 250425 6:44:34 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 1494 Schema: excellen_vip3 QC_hit: No # Query_time: 15.643404 Lock_time: 0.000558 Rows_sent: 5 Rows_examined: 305729 # Rows_affected: 0 Bytes_sent: 9631 SET timestamp=1745563474; SELECT p.*, pi.* FROM cart_products p LEFT JOIN cart_product_images pi ON (p.productid=pi.imageprodid AND pi.imageisthumb=1) WHERE p.prodvisible=1 AND productid != 162595 AND FIND_IN_SET(5582,prodcatids)AND prodavailability='unreserved' AND prodcurrentinv!=0 AND levenshtein_ratio('(645) 645-7878',prodname)>60 ORDER BY levenshtein_ratio('(645) 645-7878',prodname) DESC LIMIT 5; # Time: 250425 6:44:50 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 1494 Schema: excellen_vip3 QC_hit: No # Query_time: 11.084193 Lock_time: 0.000104 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745563490; select b.brandid, b.brandname, ( select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1' ) as num from cart_brands b order by b.brandname asc; # Time: 250425 6:45:05 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 1528 Schema: excellen_vip3 QC_hit: No # Query_time: 9.986463 Lock_time: 0.000087 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745563505; select b.brandid, b.brandname, (select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1') as num from cart_brands b order by b.brandname asc; # Time: 250425 6:45:15 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 1528 Schema: excellen_vip3 QC_hit: No # Query_time: 21.155699 Lock_time: 0.000598 Rows_sent: 5 Rows_examined: 305729 # Rows_affected: 0 Bytes_sent: 9627 SET timestamp=1745563515; SELECT p.*, pi.* FROM cart_products p LEFT JOIN cart_product_images pi ON (p.productid=pi.imageprodid AND pi.imageisthumb=1) WHERE p.prodvisible=1 AND productid != 169493 AND FIND_IN_SET(137,prodcatids)AND prodavailability='unreserved' AND prodcurrentinv!=0 AND levenshtein_ratio('(702) 702-6990',prodname)>60 ORDER BY levenshtein_ratio('(702) 702-6990',prodname) DESC LIMIT 5; # Time: 250425 6:45:37 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 1528 Schema: excellen_vip3 QC_hit: No # Query_time: 11.726740 Lock_time: 0.000104 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745563537; select b.brandid, b.brandname, ( select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1' ) as num from cart_brands b order by b.brandname asc; # Time: 250425 6:45:59 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 2012 Schema: excellen_vip3 QC_hit: No # Query_time: 10.260828 Lock_time: 0.000100 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745563559; select b.brandid, b.brandname, (select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1') as num from cart_brands b order by b.brandname asc; # Time: 250425 6:46:13 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 2012 Schema: excellen_vip3 QC_hit: No # Query_time: 9.908063 Lock_time: 0.000108 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745563573; select b.brandid, b.brandname, ( select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1' ) as num from cart_brands b order by b.brandname asc; # Time: 250425 6:46:26 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 2091 Schema: excellen_vip3 QC_hit: No # Query_time: 10.147488 Lock_time: 0.000099 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745563586; select b.brandid, b.brandname, (select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1') as num from cart_brands b order by b.brandname asc; # Time: 250425 6:46:37 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 2091 Schema: excellen_vip3 QC_hit: No # Query_time: 22.674146 Lock_time: 0.001131 Rows_sent: 5 Rows_examined: 305729 # Rows_affected: 0 Bytes_sent: 9624 SET timestamp=1745563597; SELECT p.*, pi.* FROM cart_products p LEFT JOIN cart_product_images pi ON (p.productid=pi.imageprodid AND pi.imageisthumb=1) WHERE p.prodvisible=1 AND productid != 242213 AND FIND_IN_SET(108,prodcatids)AND prodavailability='unreserved' AND prodcurrentinv!=0 AND levenshtein_ratio('(707) 707-7090',prodname)>60 ORDER BY levenshtein_ratio('(707) 707-7090',prodname) DESC LIMIT 5; # Time: 250425 6:47:00 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 2091 Schema: excellen_vip3 QC_hit: No # Query_time: 11.773595 Lock_time: 0.000102 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745563620; select b.brandid, b.brandname, ( select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1' ) as num from cart_brands b order by b.brandname asc; # Time: 250425 6:47:22 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 2242 Schema: excellen_vip3 QC_hit: No # Query_time: 10.241384 Lock_time: 0.000099 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745563642; select b.brandid, b.brandname, (select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1') as num from cart_brands b order by b.brandname asc; # Time: 250425 6:47:33 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 2242 Schema: excellen_vip3 QC_hit: No # Query_time: 7.887062 Lock_time: 0.001148 Rows_sent: 5 Rows_examined: 305729 # Rows_affected: 0 Bytes_sent: 9622 SET timestamp=1745563653; SELECT p.*, pi.* FROM cart_products p LEFT JOIN cart_product_images pi ON (p.productid=pi.imageprodid AND pi.imageisthumb=1) WHERE p.prodvisible=1 AND productid != 234767 AND FIND_IN_SET(279,prodcatids)AND prodavailability='unreserved' AND prodcurrentinv!=0 AND levenshtein_ratio('(440) 440-4222',prodname)>60 ORDER BY levenshtein_ratio('(440) 440-4222',prodname) DESC LIMIT 5; # Time: 250425 6:47:42 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 2242 Schema: excellen_vip3 QC_hit: No # Query_time: 10.815591 Lock_time: 0.000136 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745563662; select b.brandid, b.brandname, ( select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1' ) as num from cart_brands b order by b.brandname asc; # Time: 250425 6:47:56 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 2425 Schema: excellen_vip3 QC_hit: No # Query_time: 10.551808 Lock_time: 0.000101 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745563676; select b.brandid, b.brandname, (select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1') as num from cart_brands b order by b.brandname asc; # Time: 250425 6:48:11 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 2425 Schema: excellen_vip3 QC_hit: No # Query_time: 9.325716 Lock_time: 0.000048 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745563691; select b.brandid, b.brandname, ( select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1' ) as num from cart_brands b order by b.brandname asc; # Time: 250425 6:48:23 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 2513 Schema: excellen_vip3 QC_hit: No # Query_time: 9.691061 Lock_time: 0.000069 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745563703; select b.brandid, b.brandname, (select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1') as num from cart_brands b order by b.brandname asc; # Time: 250425 6:48:38 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 2513 Schema: excellen_vip3 QC_hit: No # Query_time: 10.131740 Lock_time: 0.000105 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745563718; select b.brandid, b.brandname, ( select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1' ) as num from cart_brands b order by b.brandname asc; # Time: 250425 6:49:02 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 2536 Schema: excellen_vip3 QC_hit: No # Query_time: 11.944155 Lock_time: 0.000080 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745563742; select b.brandid, b.brandname, (select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1') as num from cart_brands b order by b.brandname asc; # Time: 250425 6:49:20 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 2536 Schema: excellen_vip3 QC_hit: No # Query_time: 11.564259 Lock_time: 0.000124 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745563760; select b.brandid, b.brandname, ( select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1' ) as num from cart_brands b order by b.brandname asc; # Time: 250425 6:49:34 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 2728 Schema: excellen_vip3 QC_hit: No # Query_time: 10.952882 Lock_time: 0.000058 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745563774; select b.brandid, b.brandname, (select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1') as num from cart_brands b order by b.brandname asc; # Time: 250425 6:49:50 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 2728 Schema: excellen_vip3 QC_hit: No # Query_time: 10.088583 Lock_time: 0.000049 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745563790; select b.brandid, b.brandname, ( select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1' ) as num from cart_brands b order by b.brandname asc; # Time: 250425 6:50:01 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 2882 Schema: excellen_vip3 QC_hit: No # Query_time: 12.494445 Lock_time: 0.000105 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745563801; select b.brandid, b.brandname, (select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1') as num from cart_brands b order by b.brandname asc; # Time: 250425 6:50:04 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 2901 Schema: excellen_vip3 QC_hit: No # Query_time: 11.893455 Lock_time: 0.000099 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745563804; select b.brandid, b.brandname, (select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1') as num from cart_brands b order by b.brandname asc; # Time: 250425 6:50:15 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 2882 Schema: excellen_vip3 QC_hit: No # Query_time: 11.797755 Lock_time: 0.000049 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745563815; select b.brandid, b.brandname, ( select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1' ) as num from cart_brands b order by b.brandname asc; # Time: 250425 6:50:19 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 2901 Schema: excellen_vip3 QC_hit: No # Query_time: 11.360033 Lock_time: 0.000051 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745563819; select b.brandid, b.brandname, ( select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1' ) as num from cart_brands b order by b.brandname asc; # Time: 250425 6:50:34 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 3087 Schema: excellen_vip3 QC_hit: No # Query_time: 9.892445 Lock_time: 0.000101 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745563834; select b.brandid, b.brandname, (select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1') as num from cart_brands b order by b.brandname asc; # Time: 250425 6:50:44 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 3087 Schema: excellen_vip3 QC_hit: No # Query_time: 14.285513 Lock_time: 0.001164 Rows_sent: 5 Rows_examined: 305729 # Rows_affected: 0 Bytes_sent: 9622 SET timestamp=1745563844; SELECT p.*, pi.* FROM cart_products p LEFT JOIN cart_product_images pi ON (p.productid=pi.imageprodid AND pi.imageisthumb=1) WHERE p.prodvisible=1 AND productid != 221019 AND FIND_IN_SET(183,prodcatids)AND prodavailability='unreserved' AND prodcurrentinv!=0 AND levenshtein_ratio('(208) 208-9809',prodname)>60 ORDER BY levenshtein_ratio('(208) 208-9809',prodname) DESC LIMIT 5; # Time: 250425 6:51:00 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 3087 Schema: excellen_vip3 QC_hit: No # Query_time: 10.514170 Lock_time: 0.000108 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745563860; select b.brandid, b.brandname, ( select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1' ) as num from cart_brands b order by b.brandname asc; # Time: 250425 6:51:23 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 3269 Schema: excellen_vip3 QC_hit: No # Query_time: 10.082857 Lock_time: 0.000092 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745563883; select b.brandid, b.brandname, (select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1') as num from cart_brands b order by b.brandname asc; # Time: 250425 6:51:39 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 3269 Schema: excellen_vip3 QC_hit: No # Query_time: 11.467814 Lock_time: 0.000104 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745563899; select b.brandid, b.brandname, ( select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1' ) as num from cart_brands b order by b.brandname asc; # Time: 250425 6:51:53 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 3431 Schema: excellen_vip3 QC_hit: No # Query_time: 9.772130 Lock_time: 0.000141 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745563913; select b.brandid, b.brandname, (select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1') as num from cart_brands b order by b.brandname asc; # Time: 250425 6:52:07 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 3431 Schema: excellen_vip3 QC_hit: No # Query_time: 10.519842 Lock_time: 0.000111 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745563927; select b.brandid, b.brandname, ( select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1' ) as num from cart_brands b order by b.brandname asc; # Time: 250425 6:52:21 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 3533 Schema: excellen_vip3 QC_hit: No # Query_time: 10.214511 Lock_time: 0.000100 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745563941; select b.brandid, b.brandname, (select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1') as num from cart_brands b order by b.brandname asc; # Time: 250425 6:52:31 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 3533 Schema: excellen_vip3 QC_hit: No # Query_time: 19.992425 Lock_time: 0.000564 Rows_sent: 5 Rows_examined: 305729 # Rows_affected: 0 Bytes_sent: 9625 SET timestamp=1745563951; SELECT p.*, pi.* FROM cart_products p LEFT JOIN cart_product_images pi ON (p.productid=pi.imageprodid AND pi.imageisthumb=1) WHERE p.prodvisible=1 AND productid != 134592 AND FIND_IN_SET(137,prodcatids)AND prodavailability='unreserved' AND prodcurrentinv!=0 AND levenshtein_ratio('(702) 702-2814',prodname)>60 ORDER BY levenshtein_ratio('(702) 702-2814',prodname) DESC LIMIT 5; # Time: 250425 6:52:52 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 3533 Schema: excellen_vip3 QC_hit: No # Query_time: 10.817683 Lock_time: 0.000104 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745563972; select b.brandid, b.brandname, ( select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1' ) as num from cart_brands b order by b.brandname asc; # Time: 250425 6:53:05 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 3569 Schema: excellen_vip3 QC_hit: No # Query_time: 10.533374 Lock_time: 0.000087 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745563985; select b.brandid, b.brandname, (select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1') as num from cart_brands b order by b.brandname asc; # Time: 250425 6:53:21 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 3569 Schema: excellen_vip3 QC_hit: No # Query_time: 9.984030 Lock_time: 0.000096 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745564001; select b.brandid, b.brandname, ( select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1' ) as num from cart_brands b order by b.brandname asc; # Time: 250425 6:53:35 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 3738 Schema: excellen_vip3 QC_hit: No # Query_time: 11.854045 Lock_time: 0.000106 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745564015; select b.brandid, b.brandname, (select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1') as num from cart_brands b order by b.brandname asc; # Time: 250425 6:53:36 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 3755 Schema: excellen_vip3 QC_hit: No # Query_time: 11.307430 Lock_time: 0.000088 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745564016; select b.brandid, b.brandname, (select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1') as num from cart_brands b order by b.brandname asc; # Time: 250425 6:53:53 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 3755 Schema: excellen_vip3 QC_hit: No # Query_time: 10.316274 Lock_time: 0.000102 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745564033; select b.brandid, b.brandname, ( select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1' ) as num from cart_brands b order by b.brandname asc; # Time: 250425 6:54:08 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 3923 Schema: excellen_vip3 QC_hit: No # Query_time: 11.302289 Lock_time: 0.000099 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745564048; select b.brandid, b.brandname, (select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1') as num from cart_brands b order by b.brandname asc; # Time: 250425 6:54:25 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 3923 Schema: excellen_vip3 QC_hit: No # Query_time: 10.442036 Lock_time: 0.000045 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745564065; select b.brandid, b.brandname, ( select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1' ) as num from cart_brands b order by b.brandname asc; # Time: 250425 6:54:38 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 3973 Schema: excellen_vip3 QC_hit: No # Query_time: 9.533388 Lock_time: 0.000065 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745564078; select b.brandid, b.brandname, (select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1') as num from cart_brands b order by b.brandname asc; # Time: 250425 6:54:51 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 3973 Schema: excellen_vip3 QC_hit: No # Query_time: 10.057334 Lock_time: 0.000101 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745564091; select b.brandid, b.brandname, ( select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1' ) as num from cart_brands b order by b.brandname asc; # Time: 250425 6:55:03 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 4002 Schema: excellen_vip3 QC_hit: No # Query_time: 11.106433 Lock_time: 0.000118 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745564103; select b.brandid, b.brandname, (select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1') as num from cart_brands b order by b.brandname asc; # Time: 250425 6:55:19 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 4002 Schema: excellen_vip3 QC_hit: No # Query_time: 10.074876 Lock_time: 0.000109 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745564119; select b.brandid, b.brandname, ( select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1' ) as num from cart_brands b order by b.brandname asc; # Time: 250425 6:55:32 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 4293 Schema: excellen_vip3 QC_hit: No # Query_time: 9.554266 Lock_time: 0.000046 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745564132; select b.brandid, b.brandname, (select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1') as num from cart_brands b order by b.brandname asc; # Time: 250425 6:55:42 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 4293 Schema: excellen_vip3 QC_hit: No # Query_time: 5.204072 Lock_time: 0.001131 Rows_sent: 5 Rows_examined: 305729 # Rows_affected: 0 Bytes_sent: 9627 SET timestamp=1745564142; SELECT p.*, pi.* FROM cart_products p LEFT JOIN cart_product_images pi ON (p.productid=pi.imageprodid AND pi.imageisthumb=1) WHERE p.prodvisible=1 AND productid != 148269 AND FIND_IN_SET(192,prodcatids)AND prodavailability='unreserved' AND prodcurrentinv!=0 AND levenshtein_ratio('(515) 515-9004',prodname)>60 ORDER BY levenshtein_ratio('(515) 515-9004',prodname) DESC LIMIT 5; # Time: 250425 6:55:47 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 4427 Schema: excellen_vip3 QC_hit: No # Query_time: 12.131311 Lock_time: 0.000049 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745564147; select b.brandid, b.brandname, (select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1') as num from cart_brands b order by b.brandname asc; # Time: 250425 6:55:48 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 4293 Schema: excellen_vip3 QC_hit: No # Query_time: 12.296545 Lock_time: 0.000048 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745564148; select b.brandid, b.brandname, ( select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1' ) as num from cart_brands b order by b.brandname asc; # Time: 250425 6:55:50 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 4441 Schema: excellen_vip3 QC_hit: No # Query_time: 12.031935 Lock_time: 0.000069 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745564150; select b.brandid, b.brandname, (select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1') as num from cart_brands b order by b.brandname asc; # Time: 250425 6:56:01 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 4427 Schema: excellen_vip3 QC_hit: No # Query_time: 11.572847 Lock_time: 0.000059 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745564161; select b.brandid, b.brandname, ( select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1' ) as num from cart_brands b order by b.brandname asc; # Time: 250425 6:56:03 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 4518 Schema: excellen_vip3 QC_hit: No # Query_time: 11.989143 Lock_time: 0.000044 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745564163; select b.brandid, b.brandname, (select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1') as num from cart_brands b order by b.brandname asc; # Time: 250425 6:56:08 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 4543 Schema: excellen_vip3 QC_hit: No # Query_time: 11.262257 Lock_time: 0.000047 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745564168; select b.brandid, b.brandname, (select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1') as num from cart_brands b order by b.brandname asc; # Time: 250425 6:56:15 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 4518 Schema: excellen_vip3 QC_hit: No # Query_time: 32.360817 Lock_time: 0.000567 Rows_sent: 5 Rows_examined: 305730 # Rows_affected: 0 Bytes_sent: 9881 SET timestamp=1745564175; SELECT p.*, pi.* FROM cart_products p LEFT JOIN cart_product_images pi ON (p.productid=pi.imageprodid AND pi.imageisthumb=1) WHERE p.prodvisible=1 AND productid != 50460 AND FIND_IN_SET(138,prodcatids)AND prodavailability='unreserved' AND prodcurrentinv!=0 AND levenshtein_ratio('(725) 900-2888',prodname)>60 ORDER BY levenshtein_ratio('(725) 900-2888',prodname) DESC LIMIT 5; # Time: 250425 6:56:48 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 4589 Schema: excellen_vip3 QC_hit: No # Query_time: 14.431550 Lock_time: 0.000102 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745564208; select b.brandid, b.brandname, (select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1') as num from cart_brands b order by b.brandname asc; # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 4518 Schema: excellen_vip3 QC_hit: No # Query_time: 14.516908 Lock_time: 0.000107 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745564208; select b.brandid, b.brandname, ( select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1' ) as num from cart_brands b order by b.brandname asc; # Time: 250425 6:56:54 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 4593 Schema: excellen_vip3 QC_hit: No # Query_time: 12.024102 Lock_time: 0.000045 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745564214; select b.brandid, b.brandname, (select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1') as num from cart_brands b order by b.brandname asc; # Time: 250425 6:57:07 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 4593 Schema: excellen_vip3 QC_hit: No # Query_time: 33.485753 Lock_time: 0.000590 Rows_sent: 5 Rows_examined: 305730 # Rows_affected: 0 Bytes_sent: 9881 SET timestamp=1745564227; SELECT p.*, pi.* FROM cart_products p LEFT JOIN cart_product_images pi ON (p.productid=pi.imageprodid AND pi.imageisthumb=1) WHERE p.prodvisible=1 AND productid != 50460 AND FIND_IN_SET(138,prodcatids)AND prodavailability='unreserved' AND prodcurrentinv!=0 AND levenshtein_ratio('(725) 900-2888',prodname)>60 ORDER BY levenshtein_ratio('(725) 900-2888',prodname) DESC LIMIT 5; # Time: 250425 6:57:35 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 4797 Schema: excellen_vip3 QC_hit: No # Query_time: 12.773114 Lock_time: 0.000064 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745564255; select b.brandid, b.brandname, (select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1') as num from cart_brands b order by b.brandname asc; # Time: 250425 6:57:34 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 4793 Schema: excellen_vip3 QC_hit: No # Query_time: 13.293018 Lock_time: 0.000068 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745564254; select b.brandid, b.brandname, (select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1') as num from cart_brands b order by b.brandname asc; # Time: 250425 6:57:41 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 4593 Schema: excellen_vip3 QC_hit: No # Query_time: 12.629720 Lock_time: 0.000051 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745564261; select b.brandid, b.brandname, ( select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1' ) as num from cart_brands b order by b.brandname asc; # Time: 250425 6:57:47 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 4863 Schema: excellen_vip3 QC_hit: No # Query_time: 11.317200 Lock_time: 0.000053 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745564267; select b.brandid, b.brandname, (select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1') as num from cart_brands b order by b.brandname asc; # Time: 250425 6:57:59 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 4863 Schema: excellen_vip3 QC_hit: No # Query_time: 8.148723 Lock_time: 0.001158 Rows_sent: 5 Rows_examined: 305729 # Rows_affected: 0 Bytes_sent: 9622 SET timestamp=1745564279; SELECT p.*, pi.* FROM cart_products p LEFT JOIN cart_product_images pi ON (p.productid=pi.imageprodid AND pi.imageisthumb=1) WHERE p.prodvisible=1 AND productid != 174700 AND FIND_IN_SET(357,prodcatids)AND prodavailability='unreserved' AND prodcurrentinv!=0 AND levenshtein_ratio('(206) 776-4900',prodname)>60 ORDER BY levenshtein_ratio('(206) 776-4900',prodname) DESC LIMIT 5; # Time: 250425 6:58:01 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 4940 Schema: excellen_vip3 QC_hit: No # Query_time: 11.353540 Lock_time: 0.000048 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745564281; select b.brandid, b.brandname, (select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1') as num from cart_brands b order by b.brandname asc; # Time: 250425 6:58:08 # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 4978 Schema: excellen_vip3 QC_hit: No # Query_time: 12.589177 Lock_time: 0.000045 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745564288; select b.brandid, b.brandname, (select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1') as num from cart_brands b order by b.brandname asc; # User@Host: excellen_shaz[excellen_shaz] @ localhost [] # Thread_id: 4863 Schema: excellen_vip3 QC_hit: No # Query_time: 12.616239 Lock_time: 0.000050 Rows_sent: 15 Rows_examined: 4585905 # Rows_affected: 0 Bytes_sent: 542 SET timestamp=1745564288; select b.brandid, b.brandname, ( select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible='1' ) as num from cart_brands b order by b.brandname asc;