SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001276s ]
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=HCPL-070A&search=1' [ RunTime:0.009169s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001190s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.003200s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001466s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.000314s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002119s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000270s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001108s ]
SELECT * FROM `stock_search` WHERE `partno` = 'HCPL-070A' LIMIT 1 [ RunTime:0.013209s ]
UPDATE `stock_search` SET `count` = 12 , `updatetime` = '2026-08-19 02:15:52' WHERE `partno` = 'HCPL-070A' [ RunTime:0.018966s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.004521s ]
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 'HCPL-070A%' OR `brand` LIKE 'HCPL-070A%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008568s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.005160s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16991404 LIMIT 5 [ RunTime:0.038936s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001799s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16991404 ORDER BY `minOrder` ASC [ RunTime:0.006672s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001153s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16991404 ORDER BY `unit` DESC [ RunTime:0.029727s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.013462s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16991404 LIMIT 2 [ RunTime:0.030664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16991404 ORDER BY `minOrder` ASC [ RunTime:0.014231s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18690694 LIMIT 5 [ RunTime:0.020997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18690694 ORDER BY `minOrder` ASC [ RunTime:0.025321s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18690694 ORDER BY `unit` DESC [ RunTime:0.042967s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18690694 LIMIT 2 [ RunTime:0.016296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18690694 ORDER BY `minOrder` ASC [ RunTime:0.018783s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15203467 LIMIT 5 [ RunTime:0.039337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15203467 ORDER BY `minOrder` ASC [ RunTime:0.018858s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15203467 ORDER BY `unit` DESC [ RunTime:0.028460s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15203467 LIMIT 2 [ RunTime:0.017802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15203467 ORDER BY `minOrder` ASC [ RunTime:0.009494s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18694575 LIMIT 5 [ RunTime:0.017555s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18694575 ORDER BY `minOrder` ASC [ RunTime:0.020731s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18694575 ORDER BY `unit` DESC [ RunTime:0.011078s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18694575 LIMIT 2 [ RunTime:0.035992s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18694575 ORDER BY `minOrder` ASC [ RunTime:0.032194s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18694478 LIMIT 5 [ RunTime:0.025388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18694478 ORDER BY `minOrder` ASC [ RunTime:0.018363s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18694478 ORDER BY `unit` DESC [ RunTime:0.026520s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18694478 LIMIT 2 [ RunTime:0.058046s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18694478 ORDER BY `minOrder` ASC [ RunTime:0.015251s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18694476 LIMIT 5 [ RunTime:0.042157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18694476 ORDER BY `minOrder` ASC [ RunTime:0.013804s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18694476 ORDER BY `unit` DESC [ RunTime:0.044638s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18694476 LIMIT 2 [ RunTime:0.022228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18694476 ORDER BY `minOrder` ASC [ RunTime:0.013970s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16992385 LIMIT 5 [ RunTime:0.023188s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16992385 ORDER BY `minOrder` ASC [ RunTime:0.002638s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16992385 ORDER BY `unit` DESC [ RunTime:0.013632s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16992385 LIMIT 2 [ RunTime:0.002070s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16992385 ORDER BY `minOrder` ASC [ RunTime:0.029708s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15203016 LIMIT 5 [ RunTime:0.019208s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15203016 ORDER BY `minOrder` ASC [ RunTime:0.019753s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15203016 ORDER BY `unit` DESC [ RunTime:0.003519s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15203016 LIMIT 2 [ RunTime:0.001336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15203016 ORDER BY `minOrder` ASC [ RunTime:0.014073s ]
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 'HCPL-070A%' OR `brand` LIKE 'HCPL-070A%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008185s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51050115 LIMIT 5 [ RunTime:0.002229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51050115 ORDER BY `minOrder` ASC [ RunTime:0.031959s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51050115 ORDER BY `unit` DESC [ RunTime:0.008454s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51050115 LIMIT 2 [ RunTime:0.019208s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51050115 ORDER BY `minOrder` ASC [ RunTime:0.009637s ]
select * from pdf where partno='hcpl-070a-000e' and brandshort='broadcom / avago' limit 1 [ RunTime:0.018481s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002402s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'hcpl-070a-000e' OR `brand` LIKE 'broadcom / avago%' ) ) LIMIT 1 [ RunTime:0.012121s ]
SELECT `id` FROM `stock` WHERE `id` <> 51050115 AND `partno` = 'hcpl-070a-000e' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%broadcom / avago%' ) [ RunTime:0.009178s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51050826 LIMIT 5 [ RunTime:0.002757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51050826 ORDER BY `minOrder` ASC [ RunTime:0.022386s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51050826 ORDER BY `unit` DESC [ RunTime:0.009379s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51050826 LIMIT 2 [ RunTime:0.021259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51050826 ORDER BY `minOrder` ASC [ RunTime:0.032144s ]
select * from pdf where partno='hcpl-070a' and brandshort='broadcom / avago' limit 1 [ RunTime:0.024273s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'hcpl-070a' OR `brand` LIKE 'broadcom / avago%' ) ) LIMIT 1 [ RunTime:0.013451s ]
SELECT `id` FROM `stock` WHERE `id` <> 51050826 AND `partno` = 'hcpl-070a' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%broadcom / avago%' ) [ RunTime:0.026352s ]
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 'HCPL-070A%' OR `brand` LIKE 'HCPL-070A%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037804s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64259841 LIMIT 5 [ RunTime:0.001786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64259841 ORDER BY `minOrder` ASC [ RunTime:0.015298s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64259841 ORDER BY `unit` DESC [ RunTime:0.007997s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64259841 LIMIT 2 [ RunTime:0.016026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64259841 ORDER BY `minOrder` ASC [ RunTime:0.016543s ]
select * from pdf where partno='HCPL-070A-000E' and brandshort='Broadcom Limited' limit 1 [ RunTime:0.031199s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HCPL-070A-000E' OR `brand` LIKE 'Broadcom Limited%' ) ) LIMIT 1 [ RunTime:0.021611s ]
SELECT `id` FROM `stock` WHERE `id` <> 64259841 AND `partno` = 'HCPL-070A-000E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%broadcom limited%' ) [ RunTime:0.023846s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18690694 [ RunTime:0.043117s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64260556 LIMIT 5 [ RunTime:0.026013s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64260556 ORDER BY `minOrder` ASC [ RunTime:0.020834s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64260556 ORDER BY `unit` DESC [ RunTime:0.018555s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64260556 LIMIT 2 [ RunTime:0.058908s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64260556 ORDER BY `minOrder` ASC [ RunTime:0.012357s ]
select * from pdf where partno='HCPL-070A' and brandshort='Broadcom Limited' limit 1 [ RunTime:0.011465s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HCPL-070A' OR `brand` LIKE 'Broadcom Limited%' ) ) LIMIT 1 [ RunTime:0.009262s ]
SELECT `id` FROM `stock` WHERE `id` <> 64260556 AND `partno` = 'HCPL-070A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%broadcom limited%' ) [ RunTime:0.017290s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15203467 [ RunTime:0.018701s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64259844 LIMIT 5 [ RunTime:0.011259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64259844 ORDER BY `minOrder` ASC [ RunTime:0.005070s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64259844 ORDER BY `unit` DESC [ RunTime:0.018842s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64259844 LIMIT 2 [ RunTime:0.008001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64259844 ORDER BY `minOrder` ASC [ RunTime:0.027782s ]
select * from pdf where partno='HCPL-070A-500E' and brandshort='Broadcom Limited' limit 1 [ RunTime:0.019119s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HCPL-070A-500E' OR `brand` LIKE 'Broadcom Limited%' ) ) LIMIT 1 [ RunTime:0.001791s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64270252 LIMIT 5 [ RunTime:0.016461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64270252 ORDER BY `minOrder` ASC [ RunTime:0.027091s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64270252 ORDER BY `unit` DESC [ RunTime:0.031387s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64270252 LIMIT 2 [ RunTime:0.003565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64270252 ORDER BY `minOrder` ASC [ RunTime:0.003011s ]
select * from pdf where partno='HCPL-070A#560' and brandshort='Broadcom Limited' limit 1 [ RunTime:0.008298s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HCPL-070A#560' OR `brand` LIKE 'Broadcom Limited%' ) ) LIMIT 1 [ RunTime:0.005398s ]
SELECT `id` FROM `stock` WHERE `id` <> 64270252 AND `partno` = 'HCPL-070A#560' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%broadcom limited%' ) [ RunTime:0.027957s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16992385 [ RunTime:0.007607s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64270244 LIMIT 5 [ RunTime:0.013632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64270244 ORDER BY `minOrder` ASC [ RunTime:0.001807s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64270244 ORDER BY `unit` DESC [ RunTime:0.023105s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64270244 LIMIT 2 [ RunTime:0.018299s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64270244 ORDER BY `minOrder` ASC [ RunTime:0.023726s ]
select * from pdf where partno='HCPL-070A#500' and brandshort='Broadcom Limited' limit 1 [ RunTime:0.035988s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HCPL-070A#500' OR `brand` LIKE 'Broadcom Limited%' ) ) LIMIT 1 [ RunTime:0.040900s ]
SELECT `id` FROM `stock` WHERE `id` <> 64270244 AND `partno` = 'HCPL-070A#500' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%broadcom limited%' ) [ RunTime:0.040783s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18694575 [ RunTime:0.030983s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64269978 LIMIT 5 [ RunTime:0.016183s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64269978 ORDER BY `minOrder` ASC [ RunTime:0.014648s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64269978 ORDER BY `unit` DESC [ RunTime:0.059666s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64269978 LIMIT 2 [ RunTime:0.105636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64269978 ORDER BY `minOrder` ASC [ RunTime:0.039203s ]
select * from pdf where partno='HCPL-070A-560E' and brandshort='Broadcom Limited' limit 1 [ RunTime:0.071418s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HCPL-070A-560E' OR `brand` LIKE 'Broadcom Limited%' ) ) LIMIT 1 [ RunTime:0.077204s ]
SELECT `id` FROM `stock` WHERE `id` <> 64269978 AND `partno` = 'HCPL-070A-560E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%broadcom limited%' ) [ RunTime:0.047741s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18694476 [ RunTime:0.284078s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64269944 LIMIT 5 [ RunTime:0.115329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64269944 ORDER BY `minOrder` ASC [ RunTime:0.092188s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64269944 ORDER BY `unit` DESC [ RunTime:0.147295s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64269944 LIMIT 2 [ RunTime:0.005946s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64269944 ORDER BY `minOrder` ASC [ RunTime:0.050401s ]
select * from pdf where partno='HCPL-070A-060E' and brandshort='Broadcom Limited' limit 1 [ RunTime:0.026936s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HCPL-070A-060E' OR `brand` LIKE 'Broadcom Limited%' ) ) LIMIT 1 [ RunTime:0.024198s ]
SELECT `id` FROM `stock` WHERE `id` <> 64269944 AND `partno` = 'HCPL-070A-060E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%broadcom limited%' ) [ RunTime:0.134256s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18694478 [ RunTime:0.062860s ]
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 'HCPL-070A%' OR `brand` LIKE 'HCPL-070A%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.074889s ]
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 'HCPL-070A%' OR `brand` LIKE 'HCPL-070A%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.043285s ]
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 'HCPL-070A%' OR `brand` LIKE 'HCPL-070A%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.084683s ]
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 'HCPL-070A%' OR `brand` LIKE 'HCPL-070A%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.109766s ]
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 'HCPL-070A%' OR `brand` LIKE 'HCPL-070A%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.040944s ]
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 'HCPL-070A%' OR `brand` LIKE 'HCPL-070A%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.044269s ]
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 'HCPL-070A%' OR `brand` LIKE 'HCPL-070A%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011089s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'HCPL-070A%' OR `brand` LIKE 'HCPL-070A%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.017705s ]