SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.005500s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.246' , `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=884&search=1' [ RunTime:0.005748s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.007807s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.007174s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.007615s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.246' ) [ RunTime:0.007661s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.010286s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.007788s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.010899s ]
SELECT * FROM `stock_search` WHERE `partno` = '884' LIMIT 1 [ RunTime:0.001894s ]
UPDATE `stock_search` SET `count` = 9 , `updatetime` = '2026-10-25 03:50:09' WHERE `partno` = '884' [ RunTime:0.013652s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.007864s ]
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 '884%' OR `brand` LIKE '884%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.038902s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.007318s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12043762 LIMIT 5 [ RunTime:0.007844s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.005299s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12043762 ORDER BY `minOrder` ASC [ RunTime:0.000968s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002638s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12043762 ORDER BY `unit` DESC [ RunTime:0.000912s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002266s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12043762 LIMIT 2 [ RunTime:0.000855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12043762 ORDER BY `minOrder` ASC [ RunTime:0.000879s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13319726 LIMIT 5 [ RunTime:0.056188s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13319726 ORDER BY `minOrder` ASC [ RunTime:0.002410s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13319726 ORDER BY `unit` DESC [ RunTime:0.000759s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13319726 LIMIT 2 [ RunTime:0.000788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13319726 ORDER BY `minOrder` ASC [ RunTime:0.000954s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13319207 LIMIT 5 [ RunTime:0.006075s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13319207 ORDER BY `minOrder` ASC [ RunTime:0.011124s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13319207 ORDER BY `unit` DESC [ RunTime:0.006807s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13319207 LIMIT 2 [ RunTime:0.000757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13319207 ORDER BY `minOrder` ASC [ RunTime:0.000776s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13315793 LIMIT 5 [ RunTime:0.005779s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13315793 ORDER BY `minOrder` ASC [ RunTime:0.005927s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13315793 ORDER BY `unit` DESC [ RunTime:0.005161s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13315793 LIMIT 2 [ RunTime:0.011786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13315793 ORDER BY `minOrder` ASC [ RunTime:0.007477s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12044008 LIMIT 5 [ RunTime:0.007307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12044008 ORDER BY `minOrder` ASC [ RunTime:0.011127s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12044008 ORDER BY `unit` DESC [ RunTime:0.002004s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12044008 LIMIT 2 [ RunTime:0.000463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12044008 ORDER BY `minOrder` ASC [ RunTime:0.000457s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13319742 LIMIT 5 [ RunTime:0.003874s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13319742 ORDER BY `minOrder` ASC [ RunTime:0.003623s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13319742 ORDER BY `unit` DESC [ RunTime:0.007751s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13319742 LIMIT 2 [ RunTime:0.002368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13319742 ORDER BY `minOrder` ASC [ RunTime:0.000766s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12043979 LIMIT 5 [ RunTime:0.001231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12043979 ORDER BY `minOrder` ASC [ RunTime:0.000773s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12043979 ORDER BY `unit` DESC [ RunTime:0.003913s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12043979 LIMIT 2 [ RunTime:0.000517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12043979 ORDER BY `minOrder` ASC [ RunTime:0.000474s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13320086 LIMIT 5 [ RunTime:0.002405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13320086 ORDER BY `minOrder` ASC [ RunTime:0.003675s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13320086 ORDER BY `unit` DESC [ RunTime:0.001185s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13320086 LIMIT 2 [ RunTime:0.000706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13320086 ORDER BY `minOrder` ASC [ RunTime:0.000777s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14377917 LIMIT 5 [ RunTime:0.001109s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14377917 ORDER BY `minOrder` ASC [ RunTime:0.000435s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14377917 ORDER BY `unit` DESC [ RunTime:0.000395s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14377917 LIMIT 2 [ RunTime:0.000397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14377917 ORDER BY `minOrder` ASC [ RunTime:0.000401s ]
select * from pdf where partno='88444 0021000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.006392s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16354095 LIMIT 5 [ RunTime:0.004040s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16354095 ORDER BY `minOrder` ASC [ RunTime:0.001432s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16354095 ORDER BY `unit` DESC [ RunTime:0.000921s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16354095 LIMIT 2 [ RunTime:0.000489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16354095 ORDER BY `minOrder` ASC [ RunTime:0.000461s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20071596 LIMIT 5 [ RunTime:0.006463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20071596 ORDER BY `minOrder` ASC [ RunTime:0.007242s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20071596 ORDER BY `unit` DESC [ RunTime:0.007582s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20071596 LIMIT 2 [ RunTime:0.001819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20071596 ORDER BY `minOrder` ASC [ RunTime:0.000725s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13141723 LIMIT 5 [ RunTime:0.003099s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13141723 ORDER BY `minOrder` ASC [ RunTime:0.010398s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13141723 ORDER BY `unit` DESC [ RunTime:0.007498s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13141723 LIMIT 2 [ RunTime:0.001508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13141723 ORDER BY `minOrder` ASC [ RunTime:0.002741s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11881226 LIMIT 5 [ RunTime:0.006384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11881226 ORDER BY `minOrder` ASC [ RunTime:0.007227s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11881226 ORDER BY `unit` DESC [ RunTime:0.007350s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11881226 LIMIT 2 [ RunTime:0.004022s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11881226 ORDER BY `minOrder` ASC [ RunTime:0.000752s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14671949 LIMIT 5 [ RunTime:0.006016s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14671949 ORDER BY `minOrder` ASC [ RunTime:0.007323s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14671949 ORDER BY `unit` DESC [ RunTime:0.004641s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14671949 LIMIT 2 [ RunTime:0.000811s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14671949 ORDER BY `minOrder` ASC [ RunTime:0.000853s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13141726 LIMIT 5 [ RunTime:0.004044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13141726 ORDER BY `minOrder` ASC [ RunTime:0.000753s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13141726 ORDER BY `unit` DESC [ RunTime:0.000650s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13141726 LIMIT 2 [ RunTime:0.000702s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13141726 ORDER BY `minOrder` ASC [ RunTime:0.006744s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17384471 LIMIT 5 [ RunTime:0.004537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17384471 ORDER BY `minOrder` ASC [ RunTime:0.006500s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17384471 ORDER BY `unit` DESC [ RunTime:0.008546s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17384471 LIMIT 2 [ RunTime:0.007530s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17384471 ORDER BY `minOrder` ASC [ RunTime:0.007463s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14693796 LIMIT 5 [ RunTime:0.007407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14693796 ORDER BY `minOrder` ASC [ RunTime:0.000816s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14693796 ORDER BY `unit` DESC [ RunTime:0.000650s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14693796 LIMIT 2 [ RunTime:0.000653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14693796 ORDER BY `minOrder` ASC [ RunTime:0.000746s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13512636 LIMIT 5 [ RunTime:0.007117s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13512636 ORDER BY `minOrder` ASC [ RunTime:0.007148s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13512636 ORDER BY `unit` DESC [ RunTime:0.007284s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13512636 LIMIT 2 [ RunTime:0.000803s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13512636 ORDER BY `minOrder` ASC [ RunTime:0.000772s ]
select * from pdf where partno='88442 002100' and brandshort='Belden Inc.' limit 1 [ RunTime:0.001207s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11858127 LIMIT 5 [ RunTime:0.002497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11858127 ORDER BY `minOrder` ASC [ RunTime:0.006075s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11858127 ORDER BY `unit` DESC [ RunTime:0.009917s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11858127 LIMIT 2 [ RunTime:0.007510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11858127 ORDER BY `minOrder` ASC [ RunTime:0.007504s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13807832 LIMIT 5 [ RunTime:0.007434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13807832 ORDER BY `minOrder` ASC [ RunTime:0.006970s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13807832 ORDER BY `unit` DESC [ RunTime:0.000765s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13807832 LIMIT 2 [ RunTime:0.000764s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13807832 ORDER BY `minOrder` ASC [ RunTime:0.000778s ]
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 '884%' OR `brand` LIKE '884%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002490s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71704916 LIMIT 5 [ RunTime:0.000721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71704916 ORDER BY `minOrder` ASC [ RunTime:0.003493s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71704916 ORDER BY `unit` DESC [ RunTime:0.010877s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71704916 LIMIT 2 [ RunTime:0.003887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71704916 ORDER BY `minOrder` ASC [ RunTime:0.000855s ]
select * from pdf where partno='88442 002100' and brandshort='belden wire & cable' limit 1 [ RunTime:0.001269s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002453s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '88442 002100' OR `brand` LIKE 'belden wire & cable%' ) ) LIMIT 1 [ RunTime:0.020839s ]
SELECT `id` FROM `stock` WHERE `id` <> 71704916 AND `partno` = '88442 002100' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden wire & cable%' ) [ RunTime:0.001338s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71704918 LIMIT 5 [ RunTime:0.000735s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71704918 ORDER BY `minOrder` ASC [ RunTime:0.000819s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71704918 ORDER BY `unit` DESC [ RunTime:0.000678s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71704918 LIMIT 2 [ RunTime:0.000705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71704918 ORDER BY `minOrder` ASC [ RunTime:0.000790s ]
select * from pdf where partno='88444 002100' and brandshort='belden wire & cable' limit 1 [ RunTime:0.001028s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '88444 002100' OR `brand` LIKE 'belden wire & cable%' ) ) LIMIT 1 [ RunTime:0.000902s ]
SELECT `id` FROM `stock` WHERE `id` <> 71704918 AND `partno` = '88444 002100' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden wire & cable%' ) [ RunTime:0.000985s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71704917 LIMIT 5 [ RunTime:0.000715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71704917 ORDER BY `minOrder` ASC [ RunTime:0.000797s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71704917 ORDER BY `unit` DESC [ RunTime:0.000702s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71704917 LIMIT 2 [ RunTime:0.000720s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71704917 ORDER BY `minOrder` ASC [ RunTime:0.000789s ]
select * from pdf where partno='88442 0021000' and brandshort='belden wire & cable' limit 1 [ RunTime:0.001007s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '88442 0021000' OR `brand` LIKE 'belden wire & cable%' ) ) LIMIT 1 [ RunTime:0.000942s ]
SELECT `id` FROM `stock` WHERE `id` <> 71704917 AND `partno` = '88442 0021000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden wire & cable%' ) [ RunTime:0.000985s ]
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 '884%' OR `brand` LIKE '884%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.076733s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70159625 LIMIT 5 [ RunTime:0.010873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70159625 ORDER BY `minOrder` ASC [ RunTime:0.011496s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70159625 ORDER BY `unit` DESC [ RunTime:0.006932s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70159625 LIMIT 2 [ RunTime:0.007534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70159625 ORDER BY `minOrder` ASC [ RunTime:0.005941s ]
select * from pdf where partno='8848' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.008752s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8848' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.007636s ]
SELECT `id` FROM `stock` WHERE `id` <> 70159625 AND `partno` = '8848' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.007446s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12043762 [ RunTime:0.004470s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70171737 LIMIT 5 [ RunTime:0.000792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70171737 ORDER BY `minOrder` ASC [ RunTime:0.004783s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70171737 ORDER BY `unit` DESC [ RunTime:0.010519s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70171737 LIMIT 2 [ RunTime:0.007504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70171737 ORDER BY `minOrder` ASC [ RunTime:0.007558s ]
select * from pdf where partno='884' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.011020s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '884' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.011077s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70159685 LIMIT 5 [ RunTime:0.005924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70159685 ORDER BY `minOrder` ASC [ RunTime:0.009017s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70159685 ORDER BY `unit` DESC [ RunTime:0.010333s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70159685 LIMIT 2 [ RunTime:0.007314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70159685 ORDER BY `minOrder` ASC [ RunTime:0.000971s ]
select * from pdf where partno='8841' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.005579s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8841' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.007323s ]
SELECT `id` FROM `stock` WHERE `id` <> 70159685 AND `partno` = '8841' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.001522s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13319207 [ RunTime:0.000836s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70159689 LIMIT 5 [ RunTime:0.000794s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70159689 ORDER BY `minOrder` ASC [ RunTime:0.000950s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70159689 ORDER BY `unit` DESC [ RunTime:0.000851s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70159689 LIMIT 2 [ RunTime:0.000666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70159689 ORDER BY `minOrder` ASC [ RunTime:0.000869s ]
select * from pdf where partno='8842' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.001654s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8842' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.009729s ]
SELECT `id` FROM `stock` WHERE `id` <> 70159689 AND `partno` = '8842' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.007446s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13319726 [ RunTime:0.007348s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 69799907 LIMIT 5 [ RunTime:0.005108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69799907 ORDER BY `minOrder` ASC [ RunTime:0.002697s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 69799907 ORDER BY `unit` DESC [ RunTime:0.000712s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 69799907 LIMIT 2 [ RunTime:0.000679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69799907 ORDER BY `minOrder` ASC [ RunTime:0.000789s ]
select * from pdf where partno='88442 0021000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.005808s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '88442 0021000' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.001685s ]
SELECT `id` FROM `stock` WHERE `id` <> 69799907 AND `partno` = '88442 0021000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.000707s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13502604 [ RunTime:0.028914s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70159883 LIMIT 5 [ RunTime:0.010148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70159883 ORDER BY `minOrder` ASC [ RunTime:0.007440s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70159883 ORDER BY `unit` DESC [ RunTime:0.007092s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70159883 LIMIT 2 [ RunTime:0.000617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70159883 ORDER BY `minOrder` ASC [ RunTime:0.000898s ]
select * from pdf where partno='8843' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.008267s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8843' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.007278s ]
SELECT `id` FROM `stock` WHERE `id` <> 70159883 AND `partno` = '8843' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.007502s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12043979 [ RunTime:0.000814s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70159918 LIMIT 5 [ RunTime:0.000729s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70159918 ORDER BY `minOrder` ASC [ RunTime:0.004479s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70159918 ORDER BY `unit` DESC [ RunTime:0.010680s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70159918 LIMIT 2 [ RunTime:0.007487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70159918 ORDER BY `minOrder` ASC [ RunTime:0.001124s ]
select * from pdf where partno='8846' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.009439s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8846' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.007325s ]
SELECT `id` FROM `stock` WHERE `id` <> 70159918 AND `partno` = '8846' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.007498s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13319742 [ RunTime:0.000825s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 69801936 LIMIT 5 [ RunTime:0.000913s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69801936 ORDER BY `minOrder` ASC [ RunTime:0.004235s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 69801936 ORDER BY `unit` DESC [ RunTime:0.007320s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 69801936 LIMIT 2 [ RunTime:0.007478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69801936 ORDER BY `minOrder` ASC [ RunTime:0.004119s ]
select * from pdf where partno='88444 0021000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.011026s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '88444 0021000' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.011362s ]
SELECT `id` FROM `stock` WHERE `id` <> 69801936 AND `partno` = '88444 0021000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.011167s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14377917 [ RunTime:0.007386s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 69948605 LIMIT 5 [ RunTime:0.010176s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69948605 ORDER BY `minOrder` ASC [ RunTime:0.007467s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 69948605 ORDER BY `unit` DESC [ RunTime:0.000756s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 69948605 LIMIT 2 [ RunTime:0.000694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69948605 ORDER BY `minOrder` ASC [ RunTime:0.000875s ]
select * from pdf where partno='884468-000' and brandshort='WEC' limit 1 [ RunTime:0.007545s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '884468-000' OR `brand` LIKE 'WEC%' ) ) LIMIT 1 [ RunTime:0.007394s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70160428 LIMIT 5 [ RunTime:0.007542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70160428 ORDER BY `minOrder` ASC [ RunTime:0.007095s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70160428 ORDER BY `unit` DESC [ RunTime:0.000798s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70160428 LIMIT 2 [ RunTime:0.000663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70160428 ORDER BY `minOrder` ASC [ RunTime:0.000880s ]
select * from pdf where partno='8844' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.010928s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8844' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.003952s ]
SELECT `id` FROM `stock` WHERE `id` <> 70160428 AND `partno` = '8844' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.001164s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13320086 [ RunTime:0.000776s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67227201 LIMIT 5 [ RunTime:0.000803s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67227201 ORDER BY `minOrder` ASC [ RunTime:0.006191s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67227201 ORDER BY `unit` DESC [ RunTime:0.010723s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67227201 LIMIT 2 [ RunTime:0.007572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67227201 ORDER BY `minOrder` ASC [ RunTime:0.007614s ]
select * from pdf where partno='88400-064LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.011055s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '88400-064LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.007292s ]
SELECT `id` FROM `stock` WHERE `id` <> 67227201 AND `partno` = '88400-064LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.005164s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16354095 [ RunTime:0.009880s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71323913 LIMIT 5 [ RunTime:0.010259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71323913 ORDER BY `minOrder` ASC [ RunTime:0.007521s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71323913 ORDER BY `unit` DESC [ RunTime:0.006854s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71323913 LIMIT 2 [ RunTime:0.007548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71323913 ORDER BY `minOrder` ASC [ RunTime:0.007531s ]
select * from pdf where partno='884CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.011149s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '884CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.007330s ]
SELECT `id` FROM `stock` WHERE `id` <> 71323913 AND `partno` = '884CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.007513s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 69800070 LIMIT 5 [ RunTime:0.000785s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69800070 ORDER BY `minOrder` ASC [ RunTime:0.006324s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 69800070 ORDER BY `unit` DESC [ RunTime:0.010943s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 69800070 LIMIT 2 [ RunTime:0.007697s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69800070 ORDER BY `minOrder` ASC [ RunTime:0.007513s ]
select * from pdf where partno='88444 002100' and brandshort='Belden Inc.' limit 1 [ RunTime:0.011135s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '88444 002100' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.007431s ]
SELECT `id` FROM `stock` WHERE `id` <> 69800070 AND `partno` = '88444 002100' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.008328s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14387503 [ RunTime:0.006695s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67180030 LIMIT 5 [ RunTime:0.010349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67180030 ORDER BY `minOrder` ASC [ RunTime:0.007493s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67180030 ORDER BY `unit` DESC [ RunTime:0.010598s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67180030 LIMIT 2 [ RunTime:0.001938s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67180030 ORDER BY `minOrder` ASC [ RunTime:0.009114s ]
select * from pdf where partno='8843.0902' and brandshort='SCHURTER Inc.' limit 1 [ RunTime:0.039039s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8843.0902' OR `brand` LIKE 'SCHURTER Inc.%' ) ) LIMIT 1 [ RunTime:0.011036s ]
SELECT `id` FROM `stock` WHERE `id` <> 67180030 AND `partno` = '8843.0902' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%schurter inc.%' ) [ RunTime:0.007413s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16381819 [ RunTime:0.011524s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 68740191 LIMIT 5 [ RunTime:0.000935s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68740191 ORDER BY `minOrder` ASC [ RunTime:0.005760s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 68740191 ORDER BY `unit` DESC [ RunTime:0.010620s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 68740191 LIMIT 2 [ RunTime:0.007533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68740191 ORDER BY `minOrder` ASC [ RunTime:0.007607s ]
select * from pdf where partno='88409-6000' and brandshort='3M' limit 1 [ RunTime:0.001159s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '88409-6000' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.003845s ]
SELECT `id` FROM `stock` WHERE `id` <> 68740191 AND `partno` = '88409-6000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.001106s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11881226 [ RunTime:0.000866s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 68740206 LIMIT 5 [ RunTime:0.000760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68740206 ORDER BY `minOrder` ASC [ RunTime:0.003090s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 68740206 ORDER BY `unit` DESC [ RunTime:0.000772s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 68740206 LIMIT 2 [ RunTime:0.000705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68740206 ORDER BY `minOrder` ASC [ RunTime:0.000895s ]
select * from pdf where partno='88415-6000' and brandshort='3M' limit 1 [ RunTime:0.001073s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '88415-6000' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.003706s ]
SELECT `id` FROM `stock` WHERE `id` <> 68740206 AND `partno` = '88415-6000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.001110s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13141723 [ RunTime:0.000819s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 68931975 LIMIT 5 [ RunTime:0.000790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68931975 ORDER BY `minOrder` ASC [ RunTime:0.015410s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 68931975 ORDER BY `unit` DESC [ RunTime:0.010809s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 68931975 LIMIT 2 [ RunTime:0.007540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68931975 ORDER BY `minOrder` ASC [ RunTime:0.007370s ]
select * from pdf where partno='884A30K05M006' and brandshort='Molex' limit 1 [ RunTime:0.004124s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '884A30K05M006' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.034749s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 68930787 LIMIT 5 [ RunTime:0.007362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68930787 ORDER BY `minOrder` ASC [ RunTime:0.007412s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 68930787 ORDER BY `unit` DESC [ RunTime:0.007173s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 68930787 LIMIT 2 [ RunTime:0.007570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68930787 ORDER BY `minOrder` ASC [ RunTime:0.007573s ]
select * from pdf where partno='884030B30M050' and brandshort='Molex' limit 1 [ RunTime:0.007392s ]
select foldpath,foldpath2,filename from pdf_file where id=1801762 limit 1 [ RunTime:0.007747s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '884030B30M050' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.043415s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 68740241 LIMIT 5 [ RunTime:0.007203s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68740241 ORDER BY `minOrder` ASC [ RunTime:0.007623s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 68740241 ORDER BY `unit` DESC [ RunTime:0.005796s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 68740241 LIMIT 2 [ RunTime:0.007519s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68740241 ORDER BY `minOrder` ASC [ RunTime:0.000909s ]
select * from pdf where partno='88425-6000' and brandshort='3M' limit 1 [ RunTime:0.001291s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '88425-6000' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.003811s ]
SELECT `id` FROM `stock` WHERE `id` <> 68740241 AND `partno` = '88425-6000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.001075s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13141726 [ RunTime:0.000846s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67180031 LIMIT 5 [ RunTime:0.000701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67180031 ORDER BY `minOrder` ASC [ RunTime:0.000943s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67180031 ORDER BY `unit` DESC [ RunTime:0.000700s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67180031 LIMIT 2 [ RunTime:0.000690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67180031 ORDER BY `minOrder` ASC [ RunTime:0.000881s ]
select * from pdf where partno='8843.0901' and brandshort='SCHURTER Inc.' limit 1 [ RunTime:0.004095s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8843.0901' OR `brand` LIKE 'SCHURTER Inc.%' ) ) LIMIT 1 [ RunTime:0.004077s ]
SELECT `id` FROM `stock` WHERE `id` <> 67180031 AND `partno` = '8843.0901' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%schurter inc.%' ) [ RunTime:0.001124s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17384471 [ RunTime:0.000729s ]
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 '884%' OR `brand` LIKE '884%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001797s ]
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 '884%' OR `brand` LIKE '884%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001707s ]
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 '884%' OR `brand` LIKE '884%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001700s ]
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 '884%' OR `brand` LIKE '884%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001604s ]
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 '884%' OR `brand` LIKE '884%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001613s ]
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 '884%' OR `brand` LIKE '884%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001632s ]
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 '884%' OR `brand` LIKE '884%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001748s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '884%' OR `brand` LIKE '884%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.022542s ]