SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002219s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.153' , `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=17227&search=1' [ RunTime:0.001745s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001224s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000509s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001587s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.153' ) [ RunTime:0.002038s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001207s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.006837s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001204s ]
SELECT * FROM `stock_search` WHERE `partno` = '17227' LIMIT 1 [ RunTime:0.009338s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-16 02:29:42' WHERE `partno` = '17227' [ RunTime:0.005111s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002484s ]
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 '17227%' OR `brand` LIKE '17227%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021207s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.006247s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20078216 LIMIT 5 [ RunTime:0.007434s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001266s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20078216 ORDER BY `minOrder` ASC [ RunTime:0.000683s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.007879s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20078216 ORDER BY `unit` DESC [ RunTime:0.017100s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.007398s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20078216 LIMIT 2 [ RunTime:0.016299s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20078216 ORDER BY `minOrder` ASC [ RunTime:0.005980s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16357533 LIMIT 5 [ RunTime:0.007239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16357533 ORDER BY `minOrder` ASC [ RunTime:0.012704s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16357533 ORDER BY `unit` DESC [ RunTime:0.028051s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16357533 LIMIT 2 [ RunTime:0.014109s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16357533 ORDER BY `minOrder` ASC [ RunTime:0.021632s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15548352 LIMIT 5 [ RunTime:0.031392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15548352 ORDER BY `minOrder` ASC [ RunTime:0.026645s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15548352 ORDER BY `unit` DESC [ RunTime:0.034912s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15548352 LIMIT 2 [ RunTime:0.032022s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15548352 ORDER BY `minOrder` ASC [ RunTime:0.060524s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19630923 LIMIT 5 [ RunTime:0.054509s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19630923 ORDER BY `minOrder` ASC [ RunTime:0.039132s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19630923 ORDER BY `unit` DESC [ RunTime:0.063481s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19630923 LIMIT 2 [ RunTime:0.053564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19630923 ORDER BY `minOrder` ASC [ RunTime:0.015377s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19622331 LIMIT 5 [ RunTime:0.053630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19622331 ORDER BY `minOrder` ASC [ RunTime:0.027635s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19622331 ORDER BY `unit` DESC [ RunTime:0.048607s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19622331 LIMIT 2 [ RunTime:0.018176s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19622331 ORDER BY `minOrder` ASC [ RunTime:0.017185s ]
select * from pdf where partno='1722740000' and brandshort='Weidmüller' limit 1 [ RunTime:0.059847s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19618841 LIMIT 5 [ RunTime:0.025847s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19618841 ORDER BY `minOrder` ASC [ RunTime:0.028498s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19618841 ORDER BY `unit` DESC [ RunTime:0.059510s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19618841 LIMIT 2 [ RunTime:0.022566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19618841 ORDER BY `minOrder` ASC [ RunTime:0.003335s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12875581 LIMIT 5 [ RunTime:0.025432s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12875581 ORDER BY `minOrder` ASC [ RunTime:0.036565s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12875581 ORDER BY `unit` DESC [ RunTime:0.030913s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12875581 LIMIT 2 [ RunTime:0.030546s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12875581 ORDER BY `minOrder` ASC [ RunTime:0.006772s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11682064 LIMIT 5 [ RunTime:0.014699s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11682064 ORDER BY `minOrder` ASC [ RunTime:0.015260s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11682064 ORDER BY `unit` DESC [ RunTime:0.020170s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11682064 LIMIT 2 [ RunTime:0.010910s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11682064 ORDER BY `minOrder` ASC [ RunTime:0.017456s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11450038 LIMIT 5 [ RunTime:0.022044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11450038 ORDER BY `minOrder` ASC [ RunTime:0.018632s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11450038 ORDER BY `unit` DESC [ RunTime:0.017519s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11450038 LIMIT 2 [ RunTime:0.005650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11450038 ORDER BY `minOrder` ASC [ RunTime:0.008177s ]
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 '17227%' OR `brand` LIKE '17227%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007306s ]
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 '17227%' OR `brand` LIKE '17227%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023101s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61909569 LIMIT 5 [ RunTime:0.012300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61909569 ORDER BY `minOrder` ASC [ RunTime:0.023478s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61909569 ORDER BY `unit` DESC [ RunTime:0.021185s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61909569 LIMIT 2 [ RunTime:0.011774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61909569 ORDER BY `minOrder` ASC [ RunTime:0.000436s ]
select * from pdf where partno='172270' and brandshort='Amphenol RF' limit 1 [ RunTime:0.004271s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001620s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '172270' OR `brand` LIKE 'Amphenol RF%' ) ) LIMIT 1 [ RunTime:0.028192s ]
SELECT `id` FROM `stock` WHERE `id` <> 61909569 AND `partno` = '172270' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol rf%' ) [ RunTime:0.007078s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11682064 [ RunTime:0.013273s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60606454 LIMIT 5 [ RunTime:0.011664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60606454 ORDER BY `minOrder` ASC [ RunTime:0.013813s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60606454 ORDER BY `unit` DESC [ RunTime:0.015332s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60606454 LIMIT 2 [ RunTime:0.022008s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60606454 ORDER BY `minOrder` ASC [ RunTime:0.008672s ]
select * from pdf where partno='172276' and brandshort='Amphenol RF' limit 1 [ RunTime:0.012023s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '172276' OR `brand` LIKE 'Amphenol RF%' ) ) LIMIT 1 [ RunTime:0.027858s ]
SELECT `id` FROM `stock` WHERE `id` <> 60606454 AND `partno` = '172276' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol rf%' ) [ RunTime:0.016338s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15548352 [ RunTime:0.027451s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60607663 LIMIT 5 [ RunTime:0.029750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60607663 ORDER BY `minOrder` ASC [ RunTime:0.026219s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60607663 ORDER BY `unit` DESC [ RunTime:0.027753s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60607663 LIMIT 2 [ RunTime:0.021810s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60607663 ORDER BY `minOrder` ASC [ RunTime:0.015169s ]
select * from pdf where partno='172278-10' and brandshort='Amphenol RF' limit 1 [ RunTime:0.017109s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '172278-10' OR `brand` LIKE 'Amphenol RF%' ) ) LIMIT 1 [ RunTime:0.020034s ]
SELECT `id` FROM `stock` WHERE `id` <> 60607663 AND `partno` = '172278-10' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol rf%' ) [ RunTime:0.013082s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20078216 [ RunTime:0.021424s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64567398 LIMIT 5 [ RunTime:0.016626s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64567398 ORDER BY `minOrder` ASC [ RunTime:0.009484s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64567398 ORDER BY `unit` DESC [ RunTime:0.008392s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64567398 LIMIT 2 [ RunTime:0.010600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64567398 ORDER BY `minOrder` ASC [ RunTime:0.000562s ]
select * from pdf where partno='17227' and brandshort='Allied Vision, Inc.' limit 1 [ RunTime:0.005148s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '17227' OR `brand` LIKE 'Allied Vision, Inc.%' ) ) LIMIT 1 [ RunTime:0.021386s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61927236 LIMIT 5 [ RunTime:0.007269s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61927236 ORDER BY `minOrder` ASC [ RunTime:0.005810s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61927236 ORDER BY `unit` DESC [ RunTime:0.000986s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61927236 LIMIT 2 [ RunTime:0.000588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61927236 ORDER BY `minOrder` ASC [ RunTime:0.001357s ]
select * from pdf where partno='172277' and brandshort='Amphenol RF' limit 1 [ RunTime:0.010643s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '172277' OR `brand` LIKE 'Amphenol RF%' ) ) LIMIT 1 [ RunTime:0.007834s ]
SELECT `id` FROM `stock` WHERE `id` <> 61927236 AND `partno` = '172277' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol rf%' ) [ RunTime:0.019811s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12875581 [ RunTime:0.012284s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60632141 LIMIT 5 [ RunTime:0.013713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60632141 ORDER BY `minOrder` ASC [ RunTime:0.004164s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60632141 ORDER BY `unit` DESC [ RunTime:0.000655s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60632141 LIMIT 2 [ RunTime:0.007047s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60632141 ORDER BY `minOrder` ASC [ RunTime:0.001046s ]
select * from pdf where partno='17227.8' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.011759s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '17227.8' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.006762s ]
SELECT `id` FROM `stock` WHERE `id` <> 60632141 AND `partno` = '17227.8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.008456s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60606402 LIMIT 5 [ RunTime:0.005496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60606402 ORDER BY `minOrder` ASC [ RunTime:0.009509s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60606402 ORDER BY `unit` DESC [ RunTime:0.000700s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60606402 LIMIT 2 [ RunTime:0.000507s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60606402 ORDER BY `minOrder` ASC [ RunTime:0.006808s ]
select * from pdf where partno='172278' and brandshort='Amphenol RF' limit 1 [ RunTime:0.028390s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '172278' OR `brand` LIKE 'Amphenol RF%' ) ) LIMIT 1 [ RunTime:0.018771s ]
SELECT `id` FROM `stock` WHERE `id` <> 60606402 AND `partno` = '172278' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol rf%' ) [ RunTime:0.031679s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16357533 [ RunTime:0.020495s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60520914 LIMIT 5 [ RunTime:0.022951s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60520914 ORDER BY `minOrder` ASC [ RunTime:0.017809s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60520914 ORDER BY `unit` DESC [ RunTime:0.013184s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60520914 LIMIT 2 [ RunTime:0.010639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60520914 ORDER BY `minOrder` ASC [ RunTime:0.017499s ]
select * from pdf where partno='1722770000' and brandshort='Weidmüller' limit 1 [ RunTime:0.005593s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1722770000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.017252s ]
SELECT `id` FROM `stock` WHERE `id` <> 60520914 AND `partno` = '1722770000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.018691s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19630923 [ RunTime:0.021130s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60511104 LIMIT 5 [ RunTime:0.010828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60511104 ORDER BY `minOrder` ASC [ RunTime:0.030664s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60511104 ORDER BY `unit` DESC [ RunTime:0.024332s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60511104 LIMIT 2 [ RunTime:0.007952s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60511104 ORDER BY `minOrder` ASC [ RunTime:0.000495s ]
select * from pdf where partno='1722740000' and brandshort='Weidmüller' limit 1 [ RunTime:0.005996s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1722740000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.008969s ]
SELECT `id` FROM `stock` WHERE `id` <> 60511104 AND `partno` = '1722740000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.013585s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19622331 [ RunTime:0.009945s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60507121 LIMIT 5 [ RunTime:0.005326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60507121 ORDER BY `minOrder` ASC [ RunTime:0.026449s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60507121 ORDER BY `unit` DESC [ RunTime:0.009747s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60507121 LIMIT 2 [ RunTime:0.035256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60507121 ORDER BY `minOrder` ASC [ RunTime:0.005789s ]
select * from pdf where partno='1722730000' and brandshort='Weidmüller' limit 1 [ RunTime:0.031779s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1722730000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.011273s ]
SELECT `id` FROM `stock` WHERE `id` <> 60507121 AND `partno` = '1722730000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.009669s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19618841 [ RunTime:0.026026s ]
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 '17227%' OR `brand` LIKE '17227%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019278s ]
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 '17227%' OR `brand` LIKE '17227%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.057943s ]
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 '17227%' OR `brand` LIKE '17227%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030882s ]
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 '17227%' OR `brand` LIKE '17227%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027300s ]
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 '17227%' OR `brand` LIKE '17227%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.036880s ]
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 '17227%' OR `brand` LIKE '17227%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.063776s ]
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 '17227%' OR `brand` LIKE '17227%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009205s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '17227%' OR `brand` LIKE '17227%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.012614s ]