SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001893s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.174' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' [ RunTime:0.010461s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001640s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000750s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002188s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.174' ) [ RunTime:0.009968s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001691s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.013744s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001724s ]
SELECT * FROM `stock_search` WHERE `partno` = '980' LIMIT 1 [ RunTime:0.046188s ]
UPDATE `stock_search` SET `count` = 1240 , `updatetime` = '2026-06-07 01:07:58' WHERE `partno` = '980' [ RunTime:0.050339s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.019804s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.021591s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,800,1068,1296,1456,1822,1929,2017,2101,2342,2393,2475,2518,2568) [ RunTime:0.034644s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002029s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `partno` LIKE '980%' AND `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:0.042849s ]
SELECT `s`.`id` FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE `u`.`lockUser` = '0' AND ( (s.isDisplay = 1) ) AND ( `partno` LIKE '980%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 360,20 [ RunTime:0.053009s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE `u`.`lockUser` = '0' AND ( (s.isDisplay = 1) ) AND `s`.`id` IN ('32318643','32318388','32318367','32317723','32317370','32316504','32316300','32315971','32315698','32315428','32315193','32315010','32314936','32314925','32314924','32314751','32314477','32314476','32314439','32314287') ORDER BY FIELD(s.id, 32318643,32318388,32318367,32317723,32317370,32316504,32316300,32315971,32315698,32315428,32315193,32315010,32314936,32314925,32314924,32314751,32314477,32314476,32314439,32314287) [ RunTime:0.098974s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002159s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32318643 LIMIT 4 [ RunTime:0.117158s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.033245s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32318643 ORDER BY `minOrder` ASC [ RunTime:0.034866s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005205s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32318643 ORDER BY `unit` DESC [ RunTime:0.047154s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.005479s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32318643 LIMIT 2 [ RunTime:0.048833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32318643 ORDER BY `minOrder` ASC [ RunTime:0.020807s ]
select * from pdf where partno='9800000325' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.024751s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.004116s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9800000325' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.028098s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32318388 LIMIT 4 [ RunTime:0.033375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32318388 ORDER BY `minOrder` ASC [ RunTime:0.071270s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32318388 ORDER BY `unit` DESC [ RunTime:0.063689s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32318388 LIMIT 2 [ RunTime:0.044129s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32318388 ORDER BY `minOrder` ASC [ RunTime:0.023552s ]
select * from pdf where partno='9800000289' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.022939s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9800000289' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.045072s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32318367 LIMIT 4 [ RunTime:0.073738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32318367 ORDER BY `minOrder` ASC [ RunTime:0.074663s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32318367 ORDER BY `unit` DESC [ RunTime:0.050534s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32318367 LIMIT 2 [ RunTime:0.072301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32318367 ORDER BY `minOrder` ASC [ RunTime:0.014137s ]
select * from pdf where partno='980-8666-007' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.065922s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '980-8666-007' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.046578s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32317723 LIMIT 4 [ RunTime:0.075908s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32317723 ORDER BY `minOrder` ASC [ RunTime:0.066241s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32317723 ORDER BY `unit` DESC [ RunTime:0.042090s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32317723 LIMIT 2 [ RunTime:0.010189s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32317723 ORDER BY `minOrder` ASC [ RunTime:0.032204s ]
select * from pdf where partno='9800000326' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.007549s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9800000326' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.026815s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32317370 LIMIT 4 [ RunTime:0.014762s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32317370 ORDER BY `minOrder` ASC [ RunTime:0.023489s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32317370 ORDER BY `unit` DESC [ RunTime:0.060938s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32317370 LIMIT 2 [ RunTime:0.045386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32317370 ORDER BY `minOrder` ASC [ RunTime:0.063311s ]
select * from pdf where partno='980-8666-003' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.021392s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '980-8666-003' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.021248s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32316504 LIMIT 4 [ RunTime:0.026372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32316504 ORDER BY `minOrder` ASC [ RunTime:0.022943s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32316504 ORDER BY `unit` DESC [ RunTime:0.092166s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32316504 LIMIT 2 [ RunTime:0.045469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32316504 ORDER BY `minOrder` ASC [ RunTime:0.010847s ]
select * from pdf where partno='9800005076' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.021406s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9800005076' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.059154s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32316300 LIMIT 4 [ RunTime:0.034779s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32316300 ORDER BY `minOrder` ASC [ RunTime:0.068316s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32316300 ORDER BY `unit` DESC [ RunTime:0.045190s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32316300 LIMIT 2 [ RunTime:0.032204s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32316300 ORDER BY `minOrder` ASC [ RunTime:0.067938s ]
select * from pdf where partno='980-8560-000' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.035096s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '980-8560-000' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.076742s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32315971 LIMIT 4 [ RunTime:0.086993s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32315971 ORDER BY `minOrder` ASC [ RunTime:0.113187s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32315971 ORDER BY `unit` DESC [ RunTime:0.033012s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32315971 LIMIT 2 [ RunTime:0.059932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32315971 ORDER BY `minOrder` ASC [ RunTime:0.046990s ]
select * from pdf where partno='980-8559-000' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.023279s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '980-8559-000' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.032677s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32315698 LIMIT 4 [ RunTime:0.073052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32315698 ORDER BY `minOrder` ASC [ RunTime:0.031953s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32315698 ORDER BY `unit` DESC [ RunTime:0.043701s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32315698 LIMIT 2 [ RunTime:0.020011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32315698 ORDER BY `minOrder` ASC [ RunTime:0.014160s ]
select * from pdf where partno='980-8666-000' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.060687s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '980-8666-000' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.103267s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32315428 LIMIT 4 [ RunTime:0.070173s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32315428 ORDER BY `minOrder` ASC [ RunTime:0.229293s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32315428 ORDER BY `unit` DESC [ RunTime:0.037166s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32315428 LIMIT 2 [ RunTime:0.149136s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32315428 ORDER BY `minOrder` ASC [ RunTime:0.001310s ]
select * from pdf where partno='9808563001' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.025896s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9808563001' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.068266s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32315193 LIMIT 4 [ RunTime:0.143900s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32315193 ORDER BY `minOrder` ASC [ RunTime:0.326471s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32315193 ORDER BY `unit` DESC [ RunTime:0.079929s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32315193 LIMIT 2 [ RunTime:0.016453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32315193 ORDER BY `minOrder` ASC [ RunTime:0.027892s ]
select * from pdf where partno='980-8551-000' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.096338s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '980-8551-000' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.051262s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32315010 LIMIT 4 [ RunTime:0.043239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32315010 ORDER BY `minOrder` ASC [ RunTime:0.070173s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32315010 ORDER BY `unit` DESC [ RunTime:0.049105s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32315010 LIMIT 2 [ RunTime:0.085997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32315010 ORDER BY `minOrder` ASC [ RunTime:0.075294s ]
select * from pdf where partno='980-8557-000' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.024564s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '980-8557-000' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.027284s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32314936 LIMIT 4 [ RunTime:0.015836s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32314936 ORDER BY `minOrder` ASC [ RunTime:0.032326s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32314936 ORDER BY `unit` DESC [ RunTime:0.030494s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32314936 LIMIT 2 [ RunTime:0.051009s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32314936 ORDER BY `minOrder` ASC [ RunTime:0.001755s ]
select * from pdf where partno='980-8556-000' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.057370s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '980-8556-000' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.013374s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32314925 LIMIT 4 [ RunTime:0.033627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32314925 ORDER BY `minOrder` ASC [ RunTime:0.049700s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32314925 ORDER BY `unit` DESC [ RunTime:0.024885s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32314925 LIMIT 2 [ RunTime:0.022342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32314925 ORDER BY `minOrder` ASC [ RunTime:0.022249s ]
select * from pdf where partno='980-8666-004' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.027165s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '980-8666-004' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.023915s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32314924 LIMIT 4 [ RunTime:0.017904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32314924 ORDER BY `minOrder` ASC [ RunTime:0.001410s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32314924 ORDER BY `unit` DESC [ RunTime:0.020128s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32314924 LIMIT 2 [ RunTime:0.007253s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32314924 ORDER BY `minOrder` ASC [ RunTime:0.013690s ]
select * from pdf where partno='980-8558-000' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.010675s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '980-8558-000' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.016668s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32314751 LIMIT 4 [ RunTime:0.020463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32314751 ORDER BY `minOrder` ASC [ RunTime:0.011115s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32314751 ORDER BY `unit` DESC [ RunTime:0.004516s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32314751 LIMIT 2 [ RunTime:0.005010s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32314751 ORDER BY `minOrder` ASC [ RunTime:0.001309s ]
select * from pdf where partno='980-8666-005' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.001863s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '980-8666-005' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.002703s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32314477 LIMIT 4 [ RunTime:0.001076s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32314477 ORDER BY `minOrder` ASC [ RunTime:0.004694s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32314477 ORDER BY `unit` DESC [ RunTime:0.006121s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32314477 LIMIT 2 [ RunTime:0.001099s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32314477 ORDER BY `minOrder` ASC [ RunTime:0.001359s ]
select * from pdf where partno='980-8553-000' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.001180s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '980-8553-000' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.005479s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32314476 LIMIT 4 [ RunTime:0.000981s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32314476 ORDER BY `minOrder` ASC [ RunTime:0.000800s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32314476 ORDER BY `unit` DESC [ RunTime:0.000498s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32314476 LIMIT 2 [ RunTime:0.008606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32314476 ORDER BY `minOrder` ASC [ RunTime:0.007687s ]
select * from pdf where partno='980-8554-000' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.016894s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '980-8554-000' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.009673s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32314439 LIMIT 4 [ RunTime:0.030422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32314439 ORDER BY `minOrder` ASC [ RunTime:0.009129s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32314439 ORDER BY `unit` DESC [ RunTime:0.042439s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32314439 LIMIT 2 [ RunTime:0.030031s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32314439 ORDER BY `minOrder` ASC [ RunTime:0.028250s ]
select * from pdf where partno='980-8555-000' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.058356s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '980-8555-000' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.033737s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32314287 LIMIT 4 [ RunTime:0.018798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32314287 ORDER BY `minOrder` ASC [ RunTime:0.004605s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32314287 ORDER BY `unit` DESC [ RunTime:0.003505s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32314287 LIMIT 2 [ RunTime:0.000714s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32314287 ORDER BY `minOrder` ASC [ RunTime:0.000707s ]
select * from pdf where partno='980-8550-000' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.002271s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '980-8550-000' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.005686s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE '980%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.008352s ]