SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001466s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.111' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock?keyword=5152&search=1' [ RunTime:0.001757s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002172s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000667s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001203s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.111' ) [ RunTime:0.000259s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001121s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000236s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001120s ]
SELECT * FROM `stock_search` WHERE `partno` = '5152' LIMIT 1 [ RunTime:0.002319s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-13 17:34:18' WHERE `partno` = '5152' [ RunTime:0.003151s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001794s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5152%' OR `brand` LIKE '5152%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007050s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001557s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13499806 LIMIT 5 [ RunTime:0.006055s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001124s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13499806 ORDER BY `minOrder` ASC [ RunTime:0.004705s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002607s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13499806 ORDER BY `unit` DESC [ RunTime:0.002579s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.007877s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13499806 LIMIT 2 [ RunTime:0.000720s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13499806 ORDER BY `minOrder` ASC [ RunTime:0.001968s ]
select * from pdf where partno='5152C SL002' and brandshort='Alpha Wire' limit 1 [ RunTime:0.013448s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13470996 LIMIT 5 [ RunTime:0.010697s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13470996 ORDER BY `minOrder` ASC [ RunTime:0.009522s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13470996 ORDER BY `unit` DESC [ RunTime:0.001004s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13470996 LIMIT 2 [ RunTime:0.000735s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13470996 ORDER BY `minOrder` ASC [ RunTime:0.000533s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18597088 LIMIT 5 [ RunTime:0.007331s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18597088 ORDER BY `minOrder` ASC [ RunTime:0.004515s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18597088 ORDER BY `unit` DESC [ RunTime:0.012784s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18597088 LIMIT 2 [ RunTime:0.005953s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18597088 ORDER BY `minOrder` ASC [ RunTime:0.000668s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13513483 LIMIT 5 [ RunTime:0.009545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13513483 ORDER BY `minOrder` ASC [ RunTime:0.004878s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13513483 ORDER BY `unit` DESC [ RunTime:0.017543s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13513483 LIMIT 2 [ RunTime:0.000880s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13513483 ORDER BY `minOrder` ASC [ RunTime:0.006176s ]
select * from pdf where partno='5152C SL005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.009658s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16584005 LIMIT 5 [ RunTime:0.009415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16584005 ORDER BY `minOrder` ASC [ RunTime:0.008387s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16584005 ORDER BY `unit` DESC [ RunTime:0.014312s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16584005 LIMIT 2 [ RunTime:0.000671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16584005 ORDER BY `minOrder` ASC [ RunTime:0.000392s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14387818 LIMIT 5 [ RunTime:0.007884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14387818 ORDER BY `minOrder` ASC [ RunTime:0.008966s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14387818 ORDER BY `unit` DESC [ RunTime:0.004547s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14387818 LIMIT 2 [ RunTime:0.001521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14387818 ORDER BY `minOrder` ASC [ RunTime:0.004856s ]
select * from pdf where partno='5152C SL001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.006472s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19825626 LIMIT 5 [ RunTime:0.019821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19825626 ORDER BY `minOrder` ASC [ RunTime:0.009614s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19825626 ORDER BY `unit` DESC [ RunTime:0.019274s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19825626 LIMIT 2 [ RunTime:0.007242s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19825626 ORDER BY `minOrder` ASC [ RunTime:0.007309s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16223413 LIMIT 5 [ RunTime:0.001111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16223413 ORDER BY `minOrder` ASC [ RunTime:0.002023s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16223413 ORDER BY `unit` DESC [ RunTime:0.024065s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16223413 LIMIT 2 [ RunTime:0.014621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16223413 ORDER BY `minOrder` ASC [ RunTime:0.017854s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14642748 LIMIT 5 [ RunTime:0.008794s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14642748 ORDER BY `minOrder` ASC [ RunTime:0.016397s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14642748 ORDER BY `unit` DESC [ RunTime:0.004659s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14642748 LIMIT 2 [ RunTime:0.006028s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14642748 ORDER BY `minOrder` ASC [ RunTime:0.002472s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14642361 LIMIT 5 [ RunTime:0.013060s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14642361 ORDER BY `minOrder` ASC [ RunTime:0.004918s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14642361 ORDER BY `unit` DESC [ RunTime:0.008732s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14642361 LIMIT 2 [ RunTime:0.009552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14642361 ORDER BY `minOrder` ASC [ RunTime:0.004547s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13753638 LIMIT 5 [ RunTime:0.001510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13753638 ORDER BY `minOrder` ASC [ RunTime:0.004743s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13753638 ORDER BY `unit` DESC [ RunTime:0.007266s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13753638 LIMIT 2 [ RunTime:0.000712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13753638 ORDER BY `minOrder` ASC [ RunTime:0.006882s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13505057 LIMIT 5 [ RunTime:0.004927s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13505057 ORDER BY `minOrder` ASC [ RunTime:0.001280s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13505057 ORDER BY `unit` DESC [ RunTime:0.003279s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13505057 LIMIT 2 [ RunTime:0.001707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13505057 ORDER BY `minOrder` ASC [ RunTime:0.000430s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13505056 LIMIT 5 [ RunTime:0.000620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13505056 ORDER BY `minOrder` ASC [ RunTime:0.005070s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13505056 ORDER BY `unit` DESC [ RunTime:0.007802s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13505056 LIMIT 2 [ RunTime:0.000605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13505056 ORDER BY `minOrder` ASC [ RunTime:0.003413s ]
select * from pdf where partno='5152C BK199' and brandshort='Alpha Wire' limit 1 [ RunTime:0.004700s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13341116 LIMIT 5 [ RunTime:0.002111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13341116 ORDER BY `minOrder` ASC [ RunTime:0.000723s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13341116 ORDER BY `unit` DESC [ RunTime:0.003485s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13341116 LIMIT 2 [ RunTime:0.000627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13341116 ORDER BY `minOrder` ASC [ RunTime:0.000425s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13307363 LIMIT 5 [ RunTime:0.001385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13307363 ORDER BY `minOrder` ASC [ RunTime:0.000665s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13307363 ORDER BY `unit` DESC [ RunTime:0.006695s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13307363 LIMIT 2 [ RunTime:0.016363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13307363 ORDER BY `minOrder` ASC [ RunTime:0.000478s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13306643 LIMIT 5 [ RunTime:0.001127s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13306643 ORDER BY `minOrder` ASC [ RunTime:0.009325s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13306643 ORDER BY `unit` DESC [ RunTime:0.000720s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13306643 LIMIT 2 [ RunTime:0.009767s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13306643 ORDER BY `minOrder` ASC [ RunTime:0.003021s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12631961 LIMIT 5 [ RunTime:0.011163s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12631961 ORDER BY `minOrder` ASC [ RunTime:0.008885s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12631961 ORDER BY `unit` DESC [ RunTime:0.002656s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12631961 LIMIT 2 [ RunTime:0.006302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12631961 ORDER BY `minOrder` ASC [ RunTime:0.000893s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12194029 LIMIT 5 [ RunTime:0.005866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12194029 ORDER BY `minOrder` ASC [ RunTime:0.001590s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12194029 ORDER BY `unit` DESC [ RunTime:0.004619s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12194029 LIMIT 2 [ RunTime:0.002903s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12194029 ORDER BY `minOrder` ASC [ RunTime:0.005088s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12034745 LIMIT 5 [ RunTime:0.001539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12034745 ORDER BY `minOrder` ASC [ RunTime:0.000656s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12034745 ORDER BY `unit` DESC [ RunTime:0.003161s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12034745 LIMIT 2 [ RunTime:0.010544s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12034745 ORDER BY `minOrder` ASC [ RunTime:0.001147s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5152%' OR `brand` LIKE '5152%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002083s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32207645 LIMIT 5 [ RunTime:0.002925s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32207645 ORDER BY `minOrder` ASC [ RunTime:0.002089s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32207645 ORDER BY `unit` DESC [ RunTime:0.008156s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32207645 LIMIT 2 [ RunTime:0.000619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32207645 ORDER BY `minOrder` ASC [ RunTime:0.005250s ]
select * from pdf where partno='5152c sl005' and brandshort='alpha wire' limit 1 [ RunTime:0.001009s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002408s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5152c sl005' OR `brand` LIKE 'alpha wire%' ) ) LIMIT 1 [ RunTime:0.011508s ]
SELECT `id` FROM `stock` WHERE `id` <> 32207645 AND `partno` = '5152c sl005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.013334s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13513483 [ RunTime:0.005554s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5152%' OR `brand` LIKE '5152%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009851s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62997623 LIMIT 5 [ RunTime:0.009075s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62997623 ORDER BY `minOrder` ASC [ RunTime:0.000855s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62997623 ORDER BY `unit` DESC [ RunTime:0.000578s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62997623 LIMIT 2 [ RunTime:0.000927s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62997623 ORDER BY `minOrder` ASC [ RunTime:0.000274s ]
select * from pdf where partno='5152C SL002' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000515s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5152C SL002' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.000506s ]
SELECT `id` FROM `stock` WHERE `id` <> 62997623 AND `partno` = '5152C SL002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.000525s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13499806 [ RunTime:0.002303s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58297998 LIMIT 5 [ RunTime:0.001691s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58297998 ORDER BY `minOrder` ASC [ RunTime:0.003457s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58297998 ORDER BY `unit` DESC [ RunTime:0.000489s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58297998 LIMIT 2 [ RunTime:0.000998s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58297998 ORDER BY `minOrder` ASC [ RunTime:0.000519s ]
select * from pdf where partno='5152' and brandshort='Pololu' limit 1 [ RunTime:0.014484s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5152' OR `brand` LIKE 'Pololu%' ) ) LIMIT 1 [ RunTime:0.002419s ]
SELECT `id` FROM `stock` WHERE `id` <> 58297998 AND `partno` = '5152' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pololu%' ) [ RunTime:0.014096s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13470996 [ RunTime:0.005553s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58479737 LIMIT 5 [ RunTime:0.003832s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58479737 ORDER BY `minOrder` ASC [ RunTime:0.003045s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58479737 ORDER BY `unit` DESC [ RunTime:0.000689s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58479737 LIMIT 2 [ RunTime:0.000741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58479737 ORDER BY `minOrder` ASC [ RunTime:0.004655s ]
select * from pdf where partno='5152HQ/MF75090V1-C330-S9A' and brandshort='Sunon Fans' limit 1 [ RunTime:0.003122s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5152HQ/MF75090V1-C330-S9A' OR `brand` LIKE 'Sunon Fans%' ) ) LIMIT 1 [ RunTime:0.004096s ]
SELECT `id` FROM `stock` WHERE `id` <> 58479737 AND `partno` = '5152HQ/MF75090V1-C330-S9A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sunon fans%' ) [ RunTime:0.001100s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18597088 [ RunTime:0.004133s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62998518 LIMIT 5 [ RunTime:0.002176s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62998518 ORDER BY `minOrder` ASC [ RunTime:0.002138s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62998518 ORDER BY `unit` DESC [ RunTime:0.004327s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62998518 LIMIT 2 [ RunTime:0.000608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62998518 ORDER BY `minOrder` ASC [ RunTime:0.000436s ]
select * from pdf where partno='5152C SL005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000609s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5152C SL005' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.002543s ]
SELECT `id` FROM `stock` WHERE `id` <> 62998518 AND `partno` = '5152C SL005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.010331s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13513483 [ RunTime:0.000780s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62842465 LIMIT 5 [ RunTime:0.003877s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62842465 ORDER BY `minOrder` ASC [ RunTime:0.005050s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62842465 ORDER BY `unit` DESC [ RunTime:0.011254s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62842465 LIMIT 2 [ RunTime:0.006991s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62842465 ORDER BY `minOrder` ASC [ RunTime:0.000496s ]
select * from pdf where partno='5152-DKF-0048' and brandshort='Cinch Connectivity Solutions Semflex' limit 1 [ RunTime:0.001506s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5152-DKF-0048' OR `brand` LIKE 'Cinch Connectivity Solutions Semflex%' ) ) LIMIT 1 [ RunTime:0.010341s ]
SELECT `id` FROM `stock` WHERE `id` <> 62842465 AND `partno` = '5152-DKF-0048' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cinch connectivity solutions semflex%' ) [ RunTime:0.005354s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16584005 [ RunTime:0.002665s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62998967 LIMIT 5 [ RunTime:0.000834s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62998967 ORDER BY `minOrder` ASC [ RunTime:0.004993s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62998967 ORDER BY `unit` DESC [ RunTime:0.005533s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62998967 LIMIT 2 [ RunTime:0.006496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62998967 ORDER BY `minOrder` ASC [ RunTime:0.000478s ]
select * from pdf where partno='5152C SL001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000530s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5152C SL001' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.000785s ]
SELECT `id` FROM `stock` WHERE `id` <> 62998967 AND `partno` = '5152C SL001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.008803s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14387818 [ RunTime:0.008127s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63358481 LIMIT 5 [ RunTime:0.007156s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63358481 ORDER BY `minOrder` ASC [ RunTime:0.001309s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63358481 ORDER BY `unit` DESC [ RunTime:0.000682s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63358481 LIMIT 2 [ RunTime:0.007423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63358481 ORDER BY `minOrder` ASC [ RunTime:0.000502s ]
select * from pdf where partno='5152AE' and brandshort='Ohmite' limit 1 [ RunTime:0.006716s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5152AE' OR `brand` LIKE 'Ohmite%' ) ) LIMIT 1 [ RunTime:0.004493s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63076084 LIMIT 5 [ RunTime:0.000791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63076084 ORDER BY `minOrder` ASC [ RunTime:0.001027s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63076084 ORDER BY `unit` DESC [ RunTime:0.004368s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63076084 LIMIT 2 [ RunTime:0.001745s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63076084 ORDER BY `minOrder` ASC [ RunTime:0.007513s ]
select * from pdf where partno='5152W-BOX' and brandshort='Eaton Wiring Devices' limit 1 [ RunTime:0.009164s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5152W-BOX' OR `brand` LIKE 'Eaton Wiring Devices%' ) ) LIMIT 1 [ RunTime:0.008516s ]
SELECT `id` FROM `stock` WHERE `id` <> 63076084 AND `partno` = '5152W-BOX' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton wiring devices%' ) [ RunTime:0.008928s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63076071 LIMIT 5 [ RunTime:0.004499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63076071 ORDER BY `minOrder` ASC [ RunTime:0.005158s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63076071 ORDER BY `unit` DESC [ RunTime:0.005405s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63076071 LIMIT 2 [ RunTime:0.011233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63076071 ORDER BY `minOrder` ASC [ RunTime:0.000984s ]
select * from pdf where partno='5152V-BOX' and brandshort='Eaton Wiring Devices' limit 1 [ RunTime:0.008005s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5152V-BOX' OR `brand` LIKE 'Eaton Wiring Devices%' ) ) LIMIT 1 [ RunTime:0.002402s ]
SELECT `id` FROM `stock` WHERE `id` <> 63076071 AND `partno` = '5152V-BOX' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton wiring devices%' ) [ RunTime:0.002161s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63075991 LIMIT 5 [ RunTime:0.003224s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63075991 ORDER BY `minOrder` ASC [ RunTime:0.005910s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63075991 ORDER BY `unit` DESC [ RunTime:0.002562s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63075991 LIMIT 2 [ RunTime:0.001336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63075991 ORDER BY `minOrder` ASC [ RunTime:0.003368s ]
select * from pdf where partno='5152LA' and brandshort='Eaton Wiring Devices' limit 1 [ RunTime:0.003502s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5152LA' OR `brand` LIKE 'Eaton Wiring Devices%' ) ) LIMIT 1 [ RunTime:0.002301s ]
SELECT `id` FROM `stock` WHERE `id` <> 63075991 AND `partno` = '5152LA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton wiring devices%' ) [ RunTime:0.009165s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63075990 LIMIT 5 [ RunTime:0.004099s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63075990 ORDER BY `minOrder` ASC [ RunTime:0.000895s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63075990 ORDER BY `unit` DESC [ RunTime:0.002306s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63075990 LIMIT 2 [ RunTime:0.001162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63075990 ORDER BY `minOrder` ASC [ RunTime:0.001612s ]
select * from pdf where partno='5152GY-BOX' and brandshort='Eaton Wiring Devices' limit 1 [ RunTime:0.003600s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5152GY-BOX' OR `brand` LIKE 'Eaton Wiring Devices%' ) ) LIMIT 1 [ RunTime:0.002467s ]
SELECT `id` FROM `stock` WHERE `id` <> 63075990 AND `partno` = '5152GY-BOX' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton wiring devices%' ) [ RunTime:0.005513s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63075978 LIMIT 5 [ RunTime:0.004641s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63075978 ORDER BY `minOrder` ASC [ RunTime:0.000817s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63075978 ORDER BY `unit` DESC [ RunTime:0.003045s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63075978 LIMIT 2 [ RunTime:0.004274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63075978 ORDER BY `minOrder` ASC [ RunTime:0.006632s ]
select * from pdf where partno='5152B-BOX' and brandshort='Eaton Wiring Devices' limit 1 [ RunTime:0.010552s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5152B-BOX' OR `brand` LIKE 'Eaton Wiring Devices%' ) ) LIMIT 1 [ RunTime:0.004476s ]
SELECT `id` FROM `stock` WHERE `id` <> 63075978 AND `partno` = '5152B-BOX' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton wiring devices%' ) [ RunTime:0.006364s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63075977 LIMIT 5 [ RunTime:0.001465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63075977 ORDER BY `minOrder` ASC [ RunTime:0.005399s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63075977 ORDER BY `unit` DESC [ RunTime:0.004882s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63075977 LIMIT 2 [ RunTime:0.000397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63075977 ORDER BY `minOrder` ASC [ RunTime:0.000270s ]
select * from pdf where partno='5152BK' and brandshort='Eaton Wiring Devices' limit 1 [ RunTime:0.001507s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5152BK' OR `brand` LIKE 'Eaton Wiring Devices%' ) ) LIMIT 1 [ RunTime:0.002746s ]
SELECT `id` FROM `stock` WHERE `id` <> 63075977 AND `partno` = '5152BK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton wiring devices%' ) [ RunTime:0.001662s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63023409 LIMIT 5 [ RunTime:0.002868s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63023409 ORDER BY `minOrder` ASC [ RunTime:0.009843s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63023409 ORDER BY `unit` DESC [ RunTime:0.002110s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63023409 LIMIT 2 [ RunTime:0.001854s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63023409 ORDER BY `minOrder` ASC [ RunTime:0.001753s ]
select * from pdf where partno='5152C BK199' and brandshort='Alpha Wire' limit 1 [ RunTime:0.001576s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5152C BK199' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.002371s ]
SELECT `id` FROM `stock` WHERE `id` <> 63023409 AND `partno` = '5152C BK199' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.000946s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13505056 [ RunTime:0.002183s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63023407 LIMIT 5 [ RunTime:0.001990s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63023407 ORDER BY `minOrder` ASC [ RunTime:0.006455s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63023407 ORDER BY `unit` DESC [ RunTime:0.009502s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63023407 LIMIT 2 [ RunTime:0.012507s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63023407 ORDER BY `minOrder` ASC [ RunTime:0.001505s ]
select * from pdf where partno='5152C SL199' and brandshort='Alpha Wire' limit 1 [ RunTime:0.005362s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5152C SL199' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.002202s ]
SELECT `id` FROM `stock` WHERE `id` <> 63023407 AND `partno` = '5152C SL199' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.012624s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13505057 [ RunTime:0.003605s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62924794 LIMIT 5 [ RunTime:0.001805s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62924794 ORDER BY `minOrder` ASC [ RunTime:0.009073s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62924794 ORDER BY `unit` DESC [ RunTime:0.003072s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62924794 LIMIT 2 [ RunTime:0.000911s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62924794 ORDER BY `minOrder` ASC [ RunTime:0.005594s ]
select * from pdf where partno='5152-DKF-0036' and brandshort='Cinch Connectivity Solutions Semflex' limit 1 [ RunTime:0.001669s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5152-DKF-0036' OR `brand` LIKE 'Cinch Connectivity Solutions Semflex%' ) ) LIMIT 1 [ RunTime:0.001675s ]
SELECT `id` FROM `stock` WHERE `id` <> 62924794 AND `partno` = '5152-DKF-0036' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cinch connectivity solutions semflex%' ) [ RunTime:0.004689s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14642748 [ RunTime:0.011610s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62922761 LIMIT 5 [ RunTime:0.006365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62922761 ORDER BY `minOrder` ASC [ RunTime:0.001836s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62922761 ORDER BY `unit` DESC [ RunTime:0.005616s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62922761 LIMIT 2 [ RunTime:0.003530s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62922761 ORDER BY `minOrder` ASC [ RunTime:0.000483s ]
select * from pdf where partno='5152-DKF-0024' and brandshort='Cinch Connectivity Solutions Semflex' limit 1 [ RunTime:0.001588s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5152-DKF-0024' OR `brand` LIKE 'Cinch Connectivity Solutions Semflex%' ) ) LIMIT 1 [ RunTime:0.001856s ]
SELECT `id` FROM `stock` WHERE `id` <> 62922761 AND `partno` = '5152-DKF-0024' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cinch connectivity solutions semflex%' ) [ RunTime:0.007637s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14642361 [ RunTime:0.004290s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62844588 LIMIT 5 [ RunTime:0.005613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62844588 ORDER BY `minOrder` ASC [ RunTime:0.011297s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62844588 ORDER BY `unit` DESC [ RunTime:0.009859s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62844588 LIMIT 2 [ RunTime:0.004509s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62844588 ORDER BY `minOrder` ASC [ RunTime:0.005570s ]
select * from pdf where partno='5152-DKF-0012' and brandshort='Cinch Connectivity Solutions Semflex' limit 1 [ RunTime:0.011326s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5152-DKF-0012' OR `brand` LIKE 'Cinch Connectivity Solutions Semflex%' ) ) LIMIT 1 [ RunTime:0.006182s ]
SELECT `id` FROM `stock` WHERE `id` <> 62844588 AND `partno` = '5152-DKF-0012' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cinch connectivity solutions semflex%' ) [ RunTime:0.002577s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13753638 [ RunTime:0.006881s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59945791 LIMIT 5 [ RunTime:0.008221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59945791 ORDER BY `minOrder` ASC [ RunTime:0.004270s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59945791 ORDER BY `unit` DESC [ RunTime:0.003253s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59945791 LIMIT 2 [ RunTime:0.001982s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59945791 ORDER BY `minOrder` ASC [ RunTime:0.000462s ]
select * from pdf where partno='515223-E' and brandshort='TE Connectivity Erni' limit 1 [ RunTime:0.002310s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '515223-E' OR `brand` LIKE 'TE Connectivity Erni%' ) ) LIMIT 1 [ RunTime:0.002716s ]
SELECT `id` FROM `stock` WHERE `id` <> 59945791 AND `partno` = '515223-E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity erni%' ) [ RunTime:0.009232s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12631961 [ RunTime:0.008014s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59494227 LIMIT 5 [ RunTime:0.003422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59494227 ORDER BY `minOrder` ASC [ RunTime:0.002539s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59494227 ORDER BY `unit` DESC [ RunTime:0.000633s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59494227 LIMIT 2 [ RunTime:0.002045s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59494227 ORDER BY `minOrder` ASC [ RunTime:0.005535s ]
select * from pdf where partno='515241-E' and brandshort='TE Connectivity Erni' limit 1 [ RunTime:0.003225s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '515241-E' OR `brand` LIKE 'TE Connectivity Erni%' ) ) LIMIT 1 [ RunTime:0.001204s ]
SELECT `id` FROM `stock` WHERE `id` <> 59494227 AND `partno` = '515241-E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity erni%' ) [ RunTime:0.001532s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16223413 [ RunTime:0.014242s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5152%' OR `brand` LIKE '5152%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001508s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5152%' OR `brand` LIKE '5152%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005878s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5152%' OR `brand` LIKE '5152%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009245s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5152%' OR `brand` LIKE '5152%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001197s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5152%' OR `brand` LIKE '5152%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007979s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5152%' OR `brand` LIKE '5152%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002204s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5152%' OR `brand` LIKE '5152%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001402s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5152%' OR `brand` LIKE '5152%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.009245s ]