SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001519s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.133' , `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=6A24-P30-I5&search=1' [ RunTime:0.008751s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001377s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000553s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001527s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.002241s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001543s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.004525s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001580s ]
SELECT * FROM `stock_search` WHERE `partno` = '6A24-P30-I5' LIMIT 1 [ RunTime:0.011888s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-26 15:37:41' WHERE `partno` = '6A24-P30-I5' [ RunTime:0.005472s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001692s ]
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 '6A24-P30-I5%' OR `brand` LIKE '6A24-P30-I5%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026883s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.009250s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16650781 LIMIT 5 [ RunTime:0.024330s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16650781 ORDER BY `minOrder` ASC [ RunTime:0.013953s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.020352s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16650781 ORDER BY `unit` DESC [ RunTime:0.055694s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.008512s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16650781 LIMIT 2 [ RunTime:0.043606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16650781 ORDER BY `minOrder` ASC [ RunTime:0.009446s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16650755 LIMIT 5 [ RunTime:0.023967s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16650755 ORDER BY `minOrder` ASC [ RunTime:0.036679s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16650755 ORDER BY `unit` DESC [ RunTime:0.116137s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16650755 LIMIT 2 [ RunTime:0.031780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16650755 ORDER BY `minOrder` ASC [ RunTime:0.003120s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16650186 LIMIT 5 [ RunTime:0.027393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16650186 ORDER BY `minOrder` ASC [ RunTime:0.073234s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16650186 ORDER BY `unit` DESC [ RunTime:0.036518s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16650186 LIMIT 2 [ RunTime:0.087749s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16650186 ORDER BY `minOrder` ASC [ RunTime:0.070657s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16650087 LIMIT 5 [ RunTime:0.109210s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16650087 ORDER BY `minOrder` ASC [ RunTime:0.083484s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16650087 ORDER BY `unit` DESC [ RunTime:0.045302s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16650087 LIMIT 2 [ RunTime:0.072716s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16650087 ORDER BY `minOrder` ASC [ RunTime:0.000680s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16649991 LIMIT 5 [ RunTime:0.033697s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16649991 ORDER BY `minOrder` ASC [ RunTime:0.021094s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16649991 ORDER BY `unit` DESC [ RunTime:0.082412s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16649991 LIMIT 2 [ RunTime:0.093506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16649991 ORDER BY `minOrder` ASC [ RunTime:0.053288s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16649906 LIMIT 5 [ RunTime:0.030088s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16649906 ORDER BY `minOrder` ASC [ RunTime:0.021837s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16649906 ORDER BY `unit` DESC [ RunTime:0.021498s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16649906 LIMIT 2 [ RunTime:0.022163s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16649906 ORDER BY `minOrder` ASC [ RunTime:0.000572s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16649866 LIMIT 5 [ RunTime:0.028691s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16649866 ORDER BY `minOrder` ASC [ RunTime:0.064110s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16649866 ORDER BY `unit` DESC [ RunTime:0.040773s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16649866 LIMIT 2 [ RunTime:0.031776s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16649866 ORDER BY `minOrder` ASC [ RunTime:0.027817s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16649799 LIMIT 5 [ RunTime:0.039627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16649799 ORDER BY `minOrder` ASC [ RunTime:0.013322s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16649799 ORDER BY `unit` DESC [ RunTime:0.033376s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16649799 LIMIT 2 [ RunTime:0.030508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16649799 ORDER BY `minOrder` ASC [ RunTime:0.019376s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16649725 LIMIT 5 [ RunTime:0.014609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16649725 ORDER BY `minOrder` ASC [ RunTime:0.008238s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16649725 ORDER BY `unit` DESC [ RunTime:0.021786s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16649725 LIMIT 2 [ RunTime:0.065624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16649725 ORDER BY `minOrder` ASC [ RunTime:0.007390s ]
select * from pdf where partno='6A24-P30-I5-M-C' and brandshort='ULTRAVOLT / Advanced Energy' limit 1 [ RunTime:0.019699s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16649381 LIMIT 5 [ RunTime:0.016109s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16649381 ORDER BY `minOrder` ASC [ RunTime:0.027202s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16649381 ORDER BY `unit` DESC [ RunTime:0.003106s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16649381 LIMIT 2 [ RunTime:0.004307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16649381 ORDER BY `minOrder` ASC [ RunTime:0.025119s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14788761 LIMIT 5 [ RunTime:0.018644s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14788761 ORDER BY `minOrder` ASC [ RunTime:0.014511s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14788761 ORDER BY `unit` DESC [ RunTime:0.013600s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14788761 LIMIT 2 [ RunTime:0.006170s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14788761 ORDER BY `minOrder` ASC [ RunTime:0.006493s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14788757 LIMIT 5 [ RunTime:0.011689s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14788757 ORDER BY `minOrder` ASC [ RunTime:0.027342s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14788757 ORDER BY `unit` DESC [ RunTime:0.016076s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14788757 LIMIT 2 [ RunTime:0.011455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14788757 ORDER BY `minOrder` ASC [ RunTime:0.001111s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14788547 LIMIT 5 [ RunTime:0.012656s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14788547 ORDER BY `minOrder` ASC [ RunTime:0.011674s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14788547 ORDER BY `unit` DESC [ RunTime:0.028422s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14788547 LIMIT 2 [ RunTime:0.007356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14788547 ORDER BY `minOrder` ASC [ RunTime:0.003745s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14788538 LIMIT 5 [ RunTime:0.003408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14788538 ORDER BY `minOrder` ASC [ RunTime:0.005843s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14788538 ORDER BY `unit` DESC [ RunTime:0.015302s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14788538 LIMIT 2 [ RunTime:0.005299s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14788538 ORDER BY `minOrder` ASC [ RunTime:0.006064s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14788486 LIMIT 5 [ RunTime:0.003640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14788486 ORDER BY `minOrder` ASC [ RunTime:0.013415s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14788486 ORDER BY `unit` DESC [ RunTime:0.002465s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14788486 LIMIT 2 [ RunTime:0.007617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14788486 ORDER BY `minOrder` ASC [ RunTime:0.002186s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14788353 LIMIT 5 [ RunTime:0.009048s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14788353 ORDER BY `minOrder` ASC [ RunTime:0.004789s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14788353 ORDER BY `unit` DESC [ RunTime:0.011000s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14788353 LIMIT 2 [ RunTime:0.008588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14788353 ORDER BY `minOrder` ASC [ RunTime:0.007708s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14788185 LIMIT 5 [ RunTime:0.005488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14788185 ORDER BY `minOrder` ASC [ RunTime:0.001338s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14788185 ORDER BY `unit` DESC [ RunTime:0.001694s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14788185 LIMIT 2 [ RunTime:0.009316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14788185 ORDER BY `minOrder` ASC [ RunTime:0.011598s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14787884 LIMIT 5 [ RunTime:0.013643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14787884 ORDER BY `minOrder` ASC [ RunTime:0.029397s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14787884 ORDER BY `unit` DESC [ RunTime:0.012379s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14787884 LIMIT 2 [ RunTime:0.008224s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14787884 ORDER BY `minOrder` ASC [ RunTime:0.012578s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14787882 LIMIT 5 [ RunTime:0.017035s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14787882 ORDER BY `minOrder` ASC [ RunTime:0.020648s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14787882 ORDER BY `unit` DESC [ RunTime:0.008211s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14787882 LIMIT 2 [ RunTime:0.004773s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14787882 ORDER BY `minOrder` ASC [ RunTime:0.001751s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14787706 LIMIT 5 [ RunTime:0.034122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14787706 ORDER BY `minOrder` ASC [ RunTime:0.026619s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14787706 ORDER BY `unit` DESC [ RunTime:0.032208s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14787706 LIMIT 2 [ RunTime:0.062700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14787706 ORDER BY `minOrder` ASC [ RunTime:0.009447s ]
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 '6A24-P30-I5%' OR `brand` LIKE '6A24-P30-I5%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.070441s ]
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 '6A24-P30-I5%' OR `brand` LIKE '6A24-P30-I5%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029573s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64370740 LIMIT 5 [ RunTime:0.047583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64370740 ORDER BY `minOrder` ASC [ RunTime:0.036778s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64370740 ORDER BY `unit` DESC [ RunTime:0.035598s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64370740 LIMIT 2 [ RunTime:0.051174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64370740 ORDER BY `minOrder` ASC [ RunTime:0.022570s ]
select * from pdf where partno='6A24-P30-I5' and brandshort='ULTRAVOLT / Advanced Energy' limit 1 [ RunTime:0.045340s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.004632s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6A24-P30-I5' OR `brand` LIKE 'ULTRAVOLT / Advanced Energy%' ) ) LIMIT 1 [ RunTime:0.059202s ]
SELECT `id` FROM `stock` WHERE `id` <> 64370740 AND `partno` = '6A24-P30-I5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ultravolt / advanced energy%' ) [ RunTime:0.010329s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14787146 [ RunTime:0.070625s ]
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 '6A24-P30-I5%' OR `brand` LIKE '6A24-P30-I5%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.035838s ]
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 '6A24-P30-I5%' OR `brand` LIKE '6A24-P30-I5%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030570s ]
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 '6A24-P30-I5%' OR `brand` LIKE '6A24-P30-I5%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037865s ]
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 '6A24-P30-I5%' OR `brand` LIKE '6A24-P30-I5%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.038806s ]
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 '6A24-P30-I5%' OR `brand` LIKE '6A24-P30-I5%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.046570s ]
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 '6A24-P30-I5%' OR `brand` LIKE '6A24-P30-I5%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014379s ]
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 '6A24-P30-I5%' OR `brand` LIKE '6A24-P30-I5%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.072793s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '6A24-P30-I5%' OR `brand` LIKE '6A24-P30-I5%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.016870s ]