SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002374s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.180' , `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=10A24-N30-I5&search=1' [ RunTime:0.001942s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002212s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000581s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001494s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.180' ) [ RunTime:0.000227s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001154s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.008141s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002710s ]
SELECT * FROM `stock_search` WHERE `partno` = '10A24-N30-I5' LIMIT 1 [ RunTime:0.015845s ]
UPDATE `stock_search` SET `count` = 3 , `updatetime` = '2026-08-08 23:02:01' WHERE `partno` = '10A24-N30-I5' [ RunTime:0.005827s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002259s ]
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 '10A24-N30-I5%' OR `brand` LIKE '10A24-N30-I5%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021154s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.009221s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17849342 LIMIT 5 [ RunTime:0.010218s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003907s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17849342 ORDER BY `minOrder` ASC [ RunTime:0.017248s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.009984s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17849342 ORDER BY `unit` DESC [ RunTime:0.030184s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001309s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17849342 LIMIT 2 [ RunTime:0.006386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17849342 ORDER BY `minOrder` ASC [ RunTime:0.000952s ]
select * from pdf where partno='10A24-N30-I5-25PPM-F-M-C' and brandshort='ULTRAVOLT / Advanced Energy' limit 1 [ RunTime:0.019443s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17849219 LIMIT 5 [ RunTime:0.003398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17849219 ORDER BY `minOrder` ASC [ RunTime:0.036589s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17849219 ORDER BY `unit` DESC [ RunTime:0.017162s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17849219 LIMIT 2 [ RunTime:0.022539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17849219 ORDER BY `minOrder` ASC [ RunTime:0.014394s ]
select * from pdf where partno='10A24-N30-I5-F-M-C' and brandshort='ULTRAVOLT / Advanced Energy' limit 1 [ RunTime:0.005508s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17848913 LIMIT 5 [ RunTime:0.010669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848913 ORDER BY `minOrder` ASC [ RunTime:0.039240s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17848913 ORDER BY `unit` DESC [ RunTime:0.024800s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17848913 LIMIT 2 [ RunTime:0.029906s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848913 ORDER BY `minOrder` ASC [ RunTime:0.008296s ]
select * from pdf where partno='10A24-N30-I5-F-M-E' and brandshort='ULTRAVOLT / Advanced Energy' limit 1 [ RunTime:0.011091s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17848898 LIMIT 5 [ RunTime:0.064268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848898 ORDER BY `minOrder` ASC [ RunTime:0.021590s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17848898 ORDER BY `unit` DESC [ RunTime:0.044052s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17848898 LIMIT 2 [ RunTime:0.017668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848898 ORDER BY `minOrder` ASC [ RunTime:0.013304s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17848866 LIMIT 5 [ RunTime:0.015738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848866 ORDER BY `minOrder` ASC [ RunTime:0.060066s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17848866 ORDER BY `unit` DESC [ RunTime:0.025997s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17848866 LIMIT 2 [ RunTime:0.033318s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848866 ORDER BY `minOrder` ASC [ RunTime:0.029886s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17848728 LIMIT 5 [ RunTime:0.014675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848728 ORDER BY `minOrder` ASC [ RunTime:0.031458s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17848728 ORDER BY `unit` DESC [ RunTime:0.008727s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17848728 LIMIT 2 [ RunTime:0.014161s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848728 ORDER BY `minOrder` ASC [ RunTime:0.018479s ]
select * from pdf where partno='10A24-N30-I5-25PPM-F-M-E' and brandshort='ULTRAVOLT / Advanced Energy' limit 1 [ RunTime:0.029806s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17848613 LIMIT 5 [ RunTime:0.017499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848613 ORDER BY `minOrder` ASC [ RunTime:0.011328s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17848613 ORDER BY `unit` DESC [ RunTime:0.022330s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17848613 LIMIT 2 [ RunTime:0.021919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848613 ORDER BY `minOrder` ASC [ RunTime:0.016759s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17848218 LIMIT 5 [ RunTime:0.020820s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848218 ORDER BY `minOrder` ASC [ RunTime:0.024820s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17848218 ORDER BY `unit` DESC [ RunTime:0.014051s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17848218 LIMIT 2 [ RunTime:0.016687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848218 ORDER BY `minOrder` ASC [ RunTime:0.007080s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17847977 LIMIT 5 [ RunTime:0.013578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17847977 ORDER BY `minOrder` ASC [ RunTime:0.018297s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17847977 ORDER BY `unit` DESC [ RunTime:0.003559s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17847977 LIMIT 2 [ RunTime:0.042112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17847977 ORDER BY `minOrder` ASC [ RunTime:0.012034s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16800285 LIMIT 5 [ RunTime:0.002249s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16800285 ORDER BY `minOrder` ASC [ RunTime:0.013411s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16800285 ORDER BY `unit` DESC [ RunTime:0.021094s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16800285 LIMIT 2 [ RunTime:0.018720s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16800285 ORDER BY `minOrder` ASC [ RunTime:0.007078s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16650728 LIMIT 5 [ RunTime:0.025474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16650728 ORDER BY `minOrder` ASC [ RunTime:0.023777s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16650728 ORDER BY `unit` DESC [ RunTime:0.010061s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16650728 LIMIT 2 [ RunTime:0.022844s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16650728 ORDER BY `minOrder` ASC [ RunTime:0.013193s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16650497 LIMIT 5 [ RunTime:0.056140s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16650497 ORDER BY `minOrder` ASC [ RunTime:0.037804s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16650497 ORDER BY `unit` DESC [ RunTime:0.009725s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16650497 LIMIT 2 [ RunTime:0.020674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16650497 ORDER BY `minOrder` ASC [ RunTime:0.016912s ]
select * from pdf where partno='10A24-N30-I5-25PPM-F-M' and brandshort='ULTRAVOLT / Advanced Energy' limit 1 [ RunTime:0.019262s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16650487 LIMIT 5 [ RunTime:0.029496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16650487 ORDER BY `minOrder` ASC [ RunTime:0.091990s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16650487 ORDER BY `unit` DESC [ RunTime:0.057648s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16650487 LIMIT 2 [ RunTime:0.031456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16650487 ORDER BY `minOrder` ASC [ RunTime:0.021142s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16650397 LIMIT 5 [ RunTime:0.025751s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16650397 ORDER BY `minOrder` ASC [ RunTime:0.077477s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16650397 ORDER BY `unit` DESC [ RunTime:0.007626s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16650397 LIMIT 2 [ RunTime:0.075874s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16650397 ORDER BY `minOrder` ASC [ RunTime:0.013042s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16650264 LIMIT 5 [ RunTime:0.053622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16650264 ORDER BY `minOrder` ASC [ RunTime:0.023612s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16650264 ORDER BY `unit` DESC [ RunTime:0.022431s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16650264 LIMIT 2 [ RunTime:0.010831s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16650264 ORDER BY `minOrder` ASC [ RunTime:0.024120s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15010029 LIMIT 5 [ RunTime:0.036802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15010029 ORDER BY `minOrder` ASC [ RunTime:0.016026s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15010029 ORDER BY `unit` DESC [ RunTime:0.012034s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15010029 LIMIT 2 [ RunTime:0.056761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15010029 ORDER BY `minOrder` ASC [ RunTime:0.010931s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15010000 LIMIT 5 [ RunTime:0.027652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15010000 ORDER BY `minOrder` ASC [ RunTime:0.052417s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15010000 ORDER BY `unit` DESC [ RunTime:0.004591s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15010000 LIMIT 2 [ RunTime:0.025951s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15010000 ORDER BY `minOrder` ASC [ RunTime:0.009278s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14788915 LIMIT 5 [ RunTime:0.069305s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14788915 ORDER BY `minOrder` ASC [ RunTime:0.037021s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14788915 ORDER BY `unit` DESC [ RunTime:0.028956s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14788915 LIMIT 2 [ RunTime:0.017026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14788915 ORDER BY `minOrder` ASC [ RunTime:0.008695s ]
select * from pdf where partno='10A24-N30-I5-25PPM-F-M-HLP' and brandshort='ULTRAVOLT / Advanced Energy' limit 1 [ RunTime:0.036224s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14788839 LIMIT 5 [ RunTime:0.031925s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14788839 ORDER BY `minOrder` ASC [ RunTime:0.052576s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14788839 ORDER BY `unit` DESC [ RunTime:0.019440s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14788839 LIMIT 2 [ RunTime:0.047540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14788839 ORDER BY `minOrder` ASC [ RunTime:0.016679s ]
select * from pdf where partno='10A24-N30-I5-F-M' and brandshort='ULTRAVOLT / Advanced Energy' limit 1 [ RunTime:0.016437s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14788690 LIMIT 5 [ RunTime:0.032538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14788690 ORDER BY `minOrder` ASC [ RunTime:0.012106s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14788690 ORDER BY `unit` DESC [ RunTime:0.009464s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14788690 LIMIT 2 [ RunTime:0.017122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14788690 ORDER BY `minOrder` ASC [ RunTime:0.023885s ]
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 '10A24-N30-I5%' OR `brand` LIKE '10A24-N30-I5%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018634s ]
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 '10A24-N30-I5%' OR `brand` LIKE '10A24-N30-I5%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.035897s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64315360 LIMIT 5 [ RunTime:0.028284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64315360 ORDER BY `minOrder` ASC [ RunTime:0.019107s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64315360 ORDER BY `unit` DESC [ RunTime:0.047499s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64315360 LIMIT 2 [ RunTime:0.036689s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64315360 ORDER BY `minOrder` ASC [ RunTime:0.013267s ]
select * from pdf where partno='10A24-N30-I5' and brandshort='ULTRAVOLT / Advanced Energy' limit 1 [ RunTime:0.025989s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001917s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10A24-N30-I5' OR `brand` LIKE 'ULTRAVOLT / Advanced Energy%' ) ) LIMIT 1 [ RunTime:0.012570s ]
SELECT `id` FROM `stock` WHERE `id` <> 64315360 AND `partno` = '10A24-N30-I5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ultravolt / advanced energy%' ) [ RunTime:0.051292s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13868732 [ RunTime:0.072059s ]
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 '10A24-N30-I5%' OR `brand` LIKE '10A24-N30-I5%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.035007s ]
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 '10A24-N30-I5%' OR `brand` LIKE '10A24-N30-I5%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.052649s ]
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 '10A24-N30-I5%' OR `brand` LIKE '10A24-N30-I5%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.096249s ]
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 '10A24-N30-I5%' OR `brand` LIKE '10A24-N30-I5%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029359s ]
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 '10A24-N30-I5%' OR `brand` LIKE '10A24-N30-I5%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.033054s ]
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 '10A24-N30-I5%' OR `brand` LIKE '10A24-N30-I5%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025052s ]
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 '10A24-N30-I5%' OR `brand` LIKE '10A24-N30-I5%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.034318s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10A24-N30-I5%' OR `brand` LIKE '10A24-N30-I5%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.034661s ]