SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002188s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000648s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001635s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.131' ) [ RunTime:0.004117s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001725s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.005961s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001142s ]
SELECT * FROM `stock_search` WHERE `partno` = '980' LIMIT 1 [ RunTime:0.000927s ]
UPDATE `stock_search` SET `count` = 20 , `updatetime` = '2026-06-05 09:53:09' WHERE `partno` = '980' [ RunTime:0.001249s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000236s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000226s ]
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.000414s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001515s ]
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.028169s ]
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 140,20 [ RunTime:0.015864s ]
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 ('33395460','14386177','33483847','32280672','12221334','32532143','14375348','12628962','32532193','32530887','32532149','32532202','33483540','33408493','11911357','33408334','16487081','14493635','12221732','33483512') ORDER BY FIELD(s.id, 33395460,14386177,33483847,32280672,12221334,32532143,14375348,12628962,32532193,32530887,32532149,32532202,33483540,33408493,11911357,33408334,16487081,14493635,12221732,33483512) [ RunTime:0.103516s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001644s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33395460 LIMIT 4 [ RunTime:0.022407s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001870s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33395460 ORDER BY `minOrder` ASC [ RunTime:0.012511s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001505s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33395460 ORDER BY `unit` DESC [ RunTime:0.012397s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.000996s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33395460 LIMIT 2 [ RunTime:0.020302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33395460 ORDER BY `minOrder` ASC [ RunTime:0.003771s ]
select * from pdf where partno='9808-0-15-01-16-27-04-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.014792s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003236s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9808-0-15-01-16-27-04-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.009380s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14386177 LIMIT 4 [ RunTime:0.013621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14386177 ORDER BY `minOrder` ASC [ RunTime:0.010788s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14386177 ORDER BY `unit` DESC [ RunTime:0.046754s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14386177 LIMIT 2 [ RunTime:0.024323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14386177 ORDER BY `minOrder` ASC [ RunTime:0.004772s ]
select * from pdf where partno='9806 060100' and brandshort='Belden Inc.' limit 1 [ RunTime:0.051090s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33483847 LIMIT 4 [ RunTime:0.027274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33483847 ORDER BY `minOrder` ASC [ RunTime:0.022811s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33483847 ORDER BY `unit` DESC [ RunTime:0.044899s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33483847 LIMIT 2 [ RunTime:0.038273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33483847 ORDER BY `minOrder` ASC [ RunTime:0.012086s ]
select * from pdf where partno='980-2000-354' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.032940s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '980-2000-354' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.018155s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32280672 LIMIT 4 [ RunTime:0.063254s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280672 ORDER BY `minOrder` ASC [ RunTime:0.025656s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32280672 ORDER BY `unit` DESC [ RunTime:0.018589s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32280672 LIMIT 2 [ RunTime:0.013830s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280672 ORDER BY `minOrder` ASC [ RunTime:0.005046s ]
select * from pdf where partno='9801-0-15-80-23-80-10-0' and brandshort='mill-max' limit 1 [ RunTime:0.042938s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9801-0-15-80-23-80-10-0' OR `brand` LIKE 'mill-max%' ) ) LIMIT 1 [ RunTime:0.020821s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12221334 LIMIT 4 [ RunTime:0.020815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12221334 ORDER BY `minOrder` ASC [ RunTime:0.013270s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12221334 ORDER BY `unit` DESC [ RunTime:0.022955s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12221334 LIMIT 2 [ RunTime:0.012957s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12221334 ORDER BY `minOrder` ASC [ RunTime:0.019201s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32532143 LIMIT 4 [ RunTime:0.013139s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32532143 ORDER BY `minOrder` ASC [ RunTime:0.019717s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32532143 ORDER BY `unit` DESC [ RunTime:0.016924s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32532143 LIMIT 2 [ RunTime:0.015442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32532143 ORDER BY `minOrder` ASC [ RunTime:0.008583s ]
select * from pdf where partno='980-9I51A-00NS00-C' and brandshort='ATGBICS' limit 1 [ RunTime:0.004958s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '980-9I51A-00NS00-C' OR `brand` LIKE 'ATGBICS%' ) ) LIMIT 1 [ RunTime:0.034328s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14375348 LIMIT 4 [ RunTime:0.049036s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14375348 ORDER BY `minOrder` ASC [ RunTime:0.043749s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14375348 ORDER BY `unit` DESC [ RunTime:0.052127s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14375348 LIMIT 2 [ RunTime:0.080010s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14375348 ORDER BY `minOrder` ASC [ RunTime:0.071988s ]
select * from pdf where partno='9804 060100' and brandshort='Belden Inc.' limit 1 [ RunTime:0.047502s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12628962 LIMIT 4 [ RunTime:0.009860s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12628962 ORDER BY `minOrder` ASC [ RunTime:0.006768s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12628962 ORDER BY `unit` DESC [ RunTime:0.025119s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12628962 LIMIT 2 [ RunTime:0.005617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12628962 ORDER BY `minOrder` ASC [ RunTime:0.002797s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32532193 LIMIT 4 [ RunTime:0.004077s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32532193 ORDER BY `minOrder` ASC [ RunTime:0.016868s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32532193 ORDER BY `unit` DESC [ RunTime:0.012630s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32532193 LIMIT 2 [ RunTime:0.019558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32532193 ORDER BY `minOrder` ASC [ RunTime:0.009952s ]
select * from pdf where partno='980-9I30I-00NM00-C' and brandshort='ATGBICS' limit 1 [ RunTime:0.024192s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '980-9I30I-00NM00-C' OR `brand` LIKE 'ATGBICS%' ) ) LIMIT 1 [ RunTime:0.019682s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32530887 LIMIT 4 [ RunTime:0.034855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32530887 ORDER BY `minOrder` ASC [ RunTime:0.031075s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32530887 ORDER BY `unit` DESC [ RunTime:0.028151s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32530887 LIMIT 2 [ RunTime:0.041393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32530887 ORDER BY `minOrder` ASC [ RunTime:0.008842s ]
select * from pdf where partno='980-9I042-00C000-C' and brandshort='ATGBICS' limit 1 [ RunTime:0.013579s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '980-9I042-00C000-C' OR `brand` LIKE 'ATGBICS%' ) ) LIMIT 1 [ RunTime:0.004207s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32532149 LIMIT 4 [ RunTime:0.003971s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32532149 ORDER BY `minOrder` ASC [ RunTime:0.003896s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32532149 ORDER BY `unit` DESC [ RunTime:0.002615s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32532149 LIMIT 2 [ RunTime:0.010373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32532149 ORDER BY `minOrder` ASC [ RunTime:0.016898s ]
select * from pdf where partno='980-9I510-00NS00-C' and brandshort='ATGBICS' limit 1 [ RunTime:0.004342s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '980-9I510-00NS00-C' OR `brand` LIKE 'ATGBICS%' ) ) LIMIT 1 [ RunTime:0.027861s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32532202 LIMIT 4 [ RunTime:0.015244s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32532202 ORDER BY `minOrder` ASC [ RunTime:0.008847s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32532202 ORDER BY `unit` DESC [ RunTime:0.022395s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32532202 LIMIT 2 [ RunTime:0.009880s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32532202 ORDER BY `minOrder` ASC [ RunTime:0.019111s ]
select * from pdf where partno='980-9I30H-00NM00-C' and brandshort='ATGBICS' limit 1 [ RunTime:0.005182s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '980-9I30H-00NM00-C' OR `brand` LIKE 'ATGBICS%' ) ) LIMIT 1 [ RunTime:0.012469s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33483540 LIMIT 4 [ RunTime:0.004350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33483540 ORDER BY `minOrder` ASC [ RunTime:0.012833s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33483540 ORDER BY `unit` DESC [ RunTime:0.030009s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33483540 LIMIT 2 [ RunTime:0.014523s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33483540 ORDER BY `minOrder` ASC [ RunTime:0.016873s ]
select * from pdf where partno='980-2000-345' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.023893s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '980-2000-345' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.024821s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33408493 LIMIT 4 [ RunTime:0.007501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33408493 ORDER BY `minOrder` ASC [ RunTime:0.003549s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33408493 ORDER BY `unit` DESC [ RunTime:0.013270s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33408493 LIMIT 2 [ RunTime:0.012649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33408493 ORDER BY `minOrder` ASC [ RunTime:0.009999s ]
select * from pdf where partno='980-8558-001' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.013383s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '980-8558-001' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.006205s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11911357 LIMIT 4 [ RunTime:0.021040s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11911357 ORDER BY `minOrder` ASC [ RunTime:0.013061s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11911357 ORDER BY `unit` DESC [ RunTime:0.009643s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11911357 LIMIT 2 [ RunTime:0.030306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11911357 ORDER BY `minOrder` ASC [ RunTime:0.007046s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33408334 LIMIT 4 [ RunTime:0.006523s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33408334 ORDER BY `minOrder` ASC [ RunTime:0.038432s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33408334 ORDER BY `unit` DESC [ RunTime:0.026970s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33408334 LIMIT 2 [ RunTime:0.021111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33408334 ORDER BY `minOrder` ASC [ RunTime:0.005221s ]
select * from pdf where partno='980-8557-000' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.011531s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '980-8557-000' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.013069s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16487081 LIMIT 4 [ RunTime:0.012932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16487081 ORDER BY `minOrder` ASC [ RunTime:0.014574s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16487081 ORDER BY `unit` DESC [ RunTime:0.020351s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16487081 LIMIT 2 [ RunTime:0.013378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16487081 ORDER BY `minOrder` ASC [ RunTime:0.005880s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14493635 LIMIT 4 [ RunTime:0.006901s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14493635 ORDER BY `minOrder` ASC [ RunTime:0.025206s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14493635 ORDER BY `unit` DESC [ RunTime:0.023002s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14493635 LIMIT 2 [ RunTime:0.006146s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14493635 ORDER BY `minOrder` ASC [ RunTime:0.006345s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12221732 LIMIT 4 [ RunTime:0.012725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12221732 ORDER BY `minOrder` ASC [ RunTime:0.002976s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12221732 ORDER BY `unit` DESC [ RunTime:0.014417s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12221732 LIMIT 2 [ RunTime:0.019968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12221732 ORDER BY `minOrder` ASC [ RunTime:0.002066s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33483512 LIMIT 4 [ RunTime:0.024300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33483512 ORDER BY `minOrder` ASC [ RunTime:0.016576s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33483512 ORDER BY `unit` DESC [ RunTime:0.016697s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33483512 LIMIT 2 [ RunTime:0.003468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33483512 ORDER BY `minOrder` ASC [ RunTime:0.000451s ]
select * from pdf where partno='980-2000-352' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.011004s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '980-2000-352' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.016507s ]
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.004735s ]