SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002321s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.220' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' [ RunTime:0.007099s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.003574s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.002984s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003466s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.220' ) [ RunTime:0.003231s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002008s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.007072s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001736s ]
SELECT * FROM `stock_search` WHERE `partno` = '980' LIMIT 1 [ RunTime:0.005930s ]
UPDATE `stock_search` SET `count` = 426 , `updatetime` = '2026-06-05 13:01:11' WHERE `partno` = '980' [ RunTime:0.006286s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.004737s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.005990s ]
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.002222s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001231s ]
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.004709s ]
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 320,20 [ RunTime:0.019696s ]
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 ('32325871','32325822','32325033','32324822','32324487','32324140','32323971','32323521','32323353','32323316','32323122','32322880','32322840','32322022','32322021','32321565','32321244','32320662','32320428','32319779') ORDER BY FIELD(s.id, 32325871,32325822,32325033,32324822,32324487,32324140,32323971,32323521,32323353,32323316,32323122,32322880,32322840,32322022,32322021,32321565,32321244,32320662,32320428,32319779) [ RunTime:0.027802s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002480s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32325871 LIMIT 4 [ RunTime:0.007493s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004028s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32325871 ORDER BY `minOrder` ASC [ RunTime:0.019773s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.014580s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32325871 ORDER BY `unit` DESC [ RunTime:0.013866s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.010720s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32325871 LIMIT 2 [ RunTime:0.027762s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32325871 ORDER BY `minOrder` ASC [ RunTime:0.007384s ]
select * from pdf where partno='980-2002-312' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.046055s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002319s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '980-2002-312' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.029640s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32325822 LIMIT 4 [ RunTime:0.012782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32325822 ORDER BY `minOrder` ASC [ RunTime:0.019359s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32325822 ORDER BY `unit` DESC [ RunTime:0.037891s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32325822 LIMIT 2 [ RunTime:0.016483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32325822 ORDER BY `minOrder` ASC [ RunTime:0.025604s ]
select * from pdf where partno='980-9500-278' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.017737s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '980-9500-278' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.067786s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32325033 LIMIT 4 [ RunTime:0.030313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32325033 ORDER BY `minOrder` ASC [ RunTime:0.043294s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32325033 ORDER BY `unit` DESC [ RunTime:0.043190s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32325033 LIMIT 2 [ RunTime:0.111846s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32325033 ORDER BY `minOrder` ASC [ RunTime:0.031904s ]
select * from pdf where partno='9808667005' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.089804s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9808667005' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.024473s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32324822 LIMIT 4 [ RunTime:0.030259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32324822 ORDER BY `minOrder` ASC [ RunTime:0.037098s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32324822 ORDER BY `unit` DESC [ RunTime:0.042401s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32324822 LIMIT 2 [ RunTime:0.078053s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32324822 ORDER BY `minOrder` ASC [ RunTime:0.025049s ]
select * from pdf where partno='9800000176' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.012348s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9800000176' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.028766s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32324487 LIMIT 4 [ RunTime:0.052478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32324487 ORDER BY `minOrder` ASC [ RunTime:0.040393s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32324487 ORDER BY `unit` DESC [ RunTime:0.038373s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32324487 LIMIT 2 [ RunTime:0.034999s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32324487 ORDER BY `minOrder` ASC [ RunTime:0.010780s ]
select * from pdf where partno='9800000179' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.012294s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9800000179' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.064933s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32324140 LIMIT 4 [ RunTime:0.052384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32324140 ORDER BY `minOrder` ASC [ RunTime:0.033587s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32324140 ORDER BY `unit` DESC [ RunTime:0.047517s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32324140 LIMIT 2 [ RunTime:0.041736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32324140 ORDER BY `minOrder` ASC [ RunTime:0.019222s ]
select * from pdf where partno='980-8553-001' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.032132s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '980-8553-001' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.033070s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32323971 LIMIT 4 [ RunTime:0.015160s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32323971 ORDER BY `minOrder` ASC [ RunTime:0.036803s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32323971 ORDER BY `unit` DESC [ RunTime:0.013942s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32323971 LIMIT 2 [ RunTime:0.012242s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32323971 ORDER BY `minOrder` ASC [ RunTime:0.000547s ]
select * from pdf where partno='9808667085' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.005352s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9808667085' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.021167s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32323521 LIMIT 4 [ RunTime:0.007537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32323521 ORDER BY `minOrder` ASC [ RunTime:0.011663s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32323521 ORDER BY `unit` DESC [ RunTime:0.012229s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32323521 LIMIT 2 [ RunTime:0.011436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32323521 ORDER BY `minOrder` ASC [ RunTime:0.000837s ]
select * from pdf where partno='9800000180' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.009113s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9800000180' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.003499s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32323353 LIMIT 4 [ RunTime:0.017558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32323353 ORDER BY `minOrder` ASC [ RunTime:0.003420s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32323353 ORDER BY `unit` DESC [ RunTime:0.006565s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32323353 LIMIT 2 [ RunTime:0.007957s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32323353 ORDER BY `minOrder` ASC [ RunTime:0.006786s ]
select * from pdf where partno='9800001382' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.015353s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9800001382' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.010542s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32323316 LIMIT 4 [ RunTime:0.008833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32323316 ORDER BY `minOrder` ASC [ RunTime:0.003293s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32323316 ORDER BY `unit` DESC [ RunTime:0.001159s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32323316 LIMIT 2 [ RunTime:0.010537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32323316 ORDER BY `minOrder` ASC [ RunTime:0.006386s ]
select * from pdf where partno='980-8568-000' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.008070s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '980-8568-000' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.005811s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32323122 LIMIT 4 [ RunTime:0.018278s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32323122 ORDER BY `minOrder` ASC [ RunTime:0.006114s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32323122 ORDER BY `unit` DESC [ RunTime:0.014618s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32323122 LIMIT 2 [ RunTime:0.006786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32323122 ORDER BY `minOrder` ASC [ RunTime:0.006837s ]
select * from pdf where partno='9800001215' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.015904s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9800001215' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.010416s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32322880 LIMIT 4 [ RunTime:0.011898s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32322880 ORDER BY `minOrder` ASC [ RunTime:0.007660s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32322880 ORDER BY `unit` DESC [ RunTime:0.011125s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32322880 LIMIT 2 [ RunTime:0.010468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32322880 ORDER BY `minOrder` ASC [ RunTime:0.016098s ]
select * from pdf where partno='9800005090' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.017120s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9800005090' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.040357s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32322840 LIMIT 4 [ RunTime:0.013484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32322840 ORDER BY `minOrder` ASC [ RunTime:0.017486s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32322840 ORDER BY `unit` DESC [ RunTime:0.020830s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32322840 LIMIT 2 [ RunTime:0.004834s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32322840 ORDER BY `minOrder` ASC [ RunTime:0.010987s ]
select * from pdf where partno='9808665000' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.014422s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9808665000' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.005694s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32322022 LIMIT 4 [ RunTime:0.020070s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32322022 ORDER BY `minOrder` ASC [ RunTime:0.030352s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32322022 ORDER BY `unit` DESC [ RunTime:0.043771s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32322022 LIMIT 2 [ RunTime:0.018059s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32322022 ORDER BY `minOrder` ASC [ RunTime:0.015909s ]
select * from pdf where partno='9800000174' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.025521s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9800000174' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.014382s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32322021 LIMIT 4 [ RunTime:0.000975s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32322021 ORDER BY `minOrder` ASC [ RunTime:0.004623s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32322021 ORDER BY `unit` DESC [ RunTime:0.000676s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32322021 LIMIT 2 [ RunTime:0.002952s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32322021 ORDER BY `minOrder` ASC [ RunTime:0.003367s ]
select * from pdf where partno='9800000177' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.001225s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9800000177' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.014649s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32321565 LIMIT 4 [ RunTime:0.000788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32321565 ORDER BY `minOrder` ASC [ RunTime:0.003587s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32321565 ORDER BY `unit` DESC [ RunTime:0.004796s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32321565 LIMIT 2 [ RunTime:0.013719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32321565 ORDER BY `minOrder` ASC [ RunTime:0.000475s ]
select * from pdf where partno='9800000194' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.007769s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9800000194' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.009154s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32321244 LIMIT 4 [ RunTime:0.003755s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32321244 ORDER BY `minOrder` ASC [ RunTime:0.009191s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32321244 ORDER BY `unit` DESC [ RunTime:0.000689s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32321244 LIMIT 2 [ RunTime:0.002833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32321244 ORDER BY `minOrder` ASC [ RunTime:0.006126s ]
select * from pdf where partno='9800006053' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.006292s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9800006053' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.002559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32320662 LIMIT 4 [ RunTime:0.001542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32320662 ORDER BY `minOrder` ASC [ RunTime:0.001100s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32320662 ORDER BY `unit` DESC [ RunTime:0.001261s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32320662 LIMIT 2 [ RunTime:0.002177s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32320662 ORDER BY `minOrder` ASC [ RunTime:0.000436s ]
select * from pdf where partno='980-0000-408' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.001885s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '980-0000-408' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.009774s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32320428 LIMIT 4 [ RunTime:0.003142s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32320428 ORDER BY `minOrder` ASC [ RunTime:0.009562s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32320428 ORDER BY `unit` DESC [ RunTime:0.001998s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32320428 LIMIT 2 [ RunTime:0.005514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32320428 ORDER BY `minOrder` ASC [ RunTime:0.004057s ]
select * from pdf where partno='980-8576-000' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.009562s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '980-8576-000' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.006424s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32319779 LIMIT 4 [ RunTime:0.002466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32319779 ORDER BY `minOrder` ASC [ RunTime:0.001030s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32319779 ORDER BY `unit` DESC [ RunTime:0.006800s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32319779 LIMIT 2 [ RunTime:0.004367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32319779 ORDER BY `minOrder` ASC [ RunTime:0.000466s ]
select * from pdf where partno='9800000172' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.001853s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9800000172' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.000859s ]
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.000582s ]