SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.005350s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.37' , `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=3246&search=1' [ RunTime:0.003467s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002616s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000389s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002309s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.37' ) [ RunTime:0.000234s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001661s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.002121s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001697s ]
SELECT * FROM `stock_search` WHERE `partno` = '3246' LIMIT 1 [ RunTime:0.001666s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-01 17:20:54' WHERE `partno` = '3246' [ RunTime:0.005276s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001992s ]
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 '3246%' OR `brand` LIKE '3246%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013081s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001178s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19582804 LIMIT 5 [ RunTime:0.003879s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001994s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19582804 ORDER BY `minOrder` ASC [ RunTime:0.004781s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003913s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19582804 ORDER BY `unit` DESC [ RunTime:0.006732s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.007428s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19582804 LIMIT 2 [ RunTime:0.000796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19582804 ORDER BY `minOrder` ASC [ RunTime:0.011572s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19585064 LIMIT 5 [ RunTime:0.005529s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19585064 ORDER BY `minOrder` ASC [ RunTime:0.019705s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19585064 ORDER BY `unit` DESC [ RunTime:0.013698s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19585064 LIMIT 2 [ RunTime:0.012737s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19585064 ORDER BY `minOrder` ASC [ RunTime:0.026787s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13349241 LIMIT 5 [ RunTime:0.029827s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13349241 ORDER BY `minOrder` ASC [ RunTime:0.010843s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13349241 ORDER BY `unit` DESC [ RunTime:0.012439s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13349241 LIMIT 2 [ RunTime:0.005955s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13349241 ORDER BY `minOrder` ASC [ RunTime:0.000809s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16147950 LIMIT 5 [ RunTime:0.001992s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16147950 ORDER BY `minOrder` ASC [ RunTime:0.007300s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16147950 ORDER BY `unit` DESC [ RunTime:0.008178s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16147950 LIMIT 2 [ RunTime:0.005965s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16147950 ORDER BY `minOrder` ASC [ RunTime:0.002467s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13501195 LIMIT 5 [ RunTime:0.003172s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13501195 ORDER BY `minOrder` ASC [ RunTime:0.001738s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13501195 ORDER BY `unit` DESC [ RunTime:0.012748s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13501195 LIMIT 2 [ RunTime:0.010759s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13501195 ORDER BY `minOrder` ASC [ RunTime:0.000335s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19582729 LIMIT 5 [ RunTime:0.005204s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19582729 ORDER BY `minOrder` ASC [ RunTime:0.001950s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19582729 ORDER BY `unit` DESC [ RunTime:0.007654s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19582729 LIMIT 2 [ RunTime:0.007744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19582729 ORDER BY `minOrder` ASC [ RunTime:0.001380s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19585086 LIMIT 5 [ RunTime:0.010261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19585086 ORDER BY `minOrder` ASC [ RunTime:0.002875s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19585086 ORDER BY `unit` DESC [ RunTime:0.011640s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19585086 LIMIT 2 [ RunTime:0.010707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19585086 ORDER BY `minOrder` ASC [ RunTime:0.006135s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12512555 LIMIT 5 [ RunTime:0.003984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12512555 ORDER BY `minOrder` ASC [ RunTime:0.007814s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12512555 ORDER BY `unit` DESC [ RunTime:0.017572s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12512555 LIMIT 2 [ RunTime:0.009016s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12512555 ORDER BY `minOrder` ASC [ RunTime:0.002372s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12562361 LIMIT 5 [ RunTime:0.005510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12562361 ORDER BY `minOrder` ASC [ RunTime:0.011018s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12562361 ORDER BY `unit` DESC [ RunTime:0.018948s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12562361 LIMIT 2 [ RunTime:0.011179s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12562361 ORDER BY `minOrder` ASC [ RunTime:0.008805s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14415478 LIMIT 5 [ RunTime:0.005641s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14415478 ORDER BY `minOrder` ASC [ RunTime:0.005550s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14415478 ORDER BY `unit` DESC [ RunTime:0.010332s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14415478 LIMIT 2 [ RunTime:0.011650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14415478 ORDER BY `minOrder` ASC [ RunTime:0.006015s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12077301 LIMIT 5 [ RunTime:0.009992s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12077301 ORDER BY `minOrder` ASC [ RunTime:0.014283s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12077301 ORDER BY `unit` DESC [ RunTime:0.012549s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12077301 LIMIT 2 [ RunTime:0.016562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12077301 ORDER BY `minOrder` ASC [ RunTime:0.010092s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13513140 LIMIT 5 [ RunTime:0.012744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13513140 ORDER BY `minOrder` ASC [ RunTime:0.015852s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13513140 ORDER BY `unit` DESC [ RunTime:0.008410s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13513140 LIMIT 2 [ RunTime:0.020628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13513140 ORDER BY `minOrder` ASC [ RunTime:0.009985s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13514322 LIMIT 5 [ RunTime:0.005185s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13514322 ORDER BY `minOrder` ASC [ RunTime:0.018822s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13514322 ORDER BY `unit` DESC [ RunTime:0.011358s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13514322 LIMIT 2 [ RunTime:0.011129s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13514322 ORDER BY `minOrder` ASC [ RunTime:0.004432s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11196374 LIMIT 5 [ RunTime:0.011802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11196374 ORDER BY `minOrder` ASC [ RunTime:0.014046s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11196374 ORDER BY `unit` DESC [ RunTime:0.008448s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11196374 LIMIT 2 [ RunTime:0.016035s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11196374 ORDER BY `minOrder` ASC [ RunTime:0.027696s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19585991 LIMIT 5 [ RunTime:0.012764s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19585991 ORDER BY `minOrder` ASC [ RunTime:0.007256s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19585991 ORDER BY `unit` DESC [ RunTime:0.008006s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19585991 LIMIT 2 [ RunTime:0.004527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19585991 ORDER BY `minOrder` ASC [ RunTime:0.001212s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19584482 LIMIT 5 [ RunTime:0.001730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19584482 ORDER BY `minOrder` ASC [ RunTime:0.008634s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19584482 ORDER BY `unit` DESC [ RunTime:0.005124s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19584482 LIMIT 2 [ RunTime:0.008359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19584482 ORDER BY `minOrder` ASC [ RunTime:0.001352s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19584481 LIMIT 5 [ RunTime:0.001063s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19584481 ORDER BY `minOrder` ASC [ RunTime:0.009743s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19584481 ORDER BY `unit` DESC [ RunTime:0.006884s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19584481 LIMIT 2 [ RunTime:0.005535s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19584481 ORDER BY `minOrder` ASC [ RunTime:0.000868s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19584289 LIMIT 5 [ RunTime:0.006064s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19584289 ORDER BY `minOrder` ASC [ RunTime:0.000715s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19584289 ORDER BY `unit` DESC [ RunTime:0.016075s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19584289 LIMIT 2 [ RunTime:0.002295s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19584289 ORDER BY `minOrder` ASC [ RunTime:0.002641s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19584284 LIMIT 5 [ RunTime:0.008523s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19584284 ORDER BY `minOrder` ASC [ RunTime:0.007512s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19584284 ORDER BY `unit` DESC [ RunTime:0.000824s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19584284 LIMIT 2 [ RunTime:0.005930s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19584284 ORDER BY `minOrder` ASC [ RunTime:0.001725s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19584259 LIMIT 5 [ RunTime:0.004654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19584259 ORDER BY `minOrder` ASC [ RunTime:0.004259s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19584259 ORDER BY `unit` DESC [ RunTime:0.003157s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19584259 LIMIT 2 [ RunTime:0.004644s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19584259 ORDER BY `minOrder` ASC [ RunTime:0.002762s ]
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 '3246%' OR `brand` LIKE '3246%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002611s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32282074 LIMIT 5 [ RunTime:0.000856s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32282074 ORDER BY `minOrder` ASC [ RunTime:0.005362s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32282074 ORDER BY `unit` DESC [ RunTime:0.004026s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32282074 LIMIT 2 [ RunTime:0.006299s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32282074 ORDER BY `minOrder` ASC [ RunTime:0.002197s ]
select * from pdf where partno='324615' and brandshort='te connectivity' limit 1 [ RunTime:0.004160s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002794s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '324615' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.038164s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51096855 LIMIT 5 [ RunTime:0.002647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51096855 ORDER BY `minOrder` ASC [ RunTime:0.008559s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51096855 ORDER BY `unit` DESC [ RunTime:0.000672s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51096855 LIMIT 2 [ RunTime:0.002306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51096855 ORDER BY `minOrder` ASC [ RunTime:0.000835s ]
select * from pdf where partno='3246' and brandshort='adafruit' limit 1 [ RunTime:0.009654s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3246' OR `brand` LIKE 'adafruit%' ) ) LIMIT 1 [ RunTime:0.007286s ]
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 '3246%' OR `brand` LIKE '3246%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015447s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57739984 LIMIT 5 [ RunTime:0.001579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57739984 ORDER BY `minOrder` ASC [ RunTime:0.003217s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57739984 ORDER BY `unit` DESC [ RunTime:0.000811s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57739984 LIMIT 2 [ RunTime:0.000508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57739984 ORDER BY `minOrder` ASC [ RunTime:0.001474s ]
select * from pdf where partno='3246CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.000762s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3246CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.001040s ]
SELECT `id` FROM `stock` WHERE `id` <> 57739984 AND `partno` = '3246CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.001015s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13349241 [ RunTime:0.004109s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59348561 LIMIT 5 [ RunTime:0.002441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59348561 ORDER BY `minOrder` ASC [ RunTime:0.007566s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59348561 ORDER BY `unit` DESC [ RunTime:0.000642s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59348561 LIMIT 2 [ RunTime:0.006798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59348561 ORDER BY `minOrder` ASC [ RunTime:0.000495s ]
select * from pdf where partno='324693' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001671s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '324693' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.004881s ]
SELECT `id` FROM `stock` WHERE `id` <> 59348561 AND `partno` = '324693' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.006972s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16147950 [ RunTime:0.000769s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56182802 LIMIT 5 [ RunTime:0.002309s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56182802 ORDER BY `minOrder` ASC [ RunTime:0.009377s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56182802 ORDER BY `unit` DESC [ RunTime:0.004196s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56182802 LIMIT 2 [ RunTime:0.000674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56182802 ORDER BY `minOrder` ASC [ RunTime:0.001923s ]
select * from pdf where partno='3246 SL001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.001563s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3246 SL001' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.007077s ]
SELECT `id` FROM `stock` WHERE `id` <> 56182802 AND `partno` = '3246 SL001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.001387s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13501195 [ RunTime:0.005227s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59348564 LIMIT 5 [ RunTime:0.002116s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59348564 ORDER BY `minOrder` ASC [ RunTime:0.001658s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59348564 ORDER BY `unit` DESC [ RunTime:0.000708s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59348564 LIMIT 2 [ RunTime:0.003615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59348564 ORDER BY `minOrder` ASC [ RunTime:0.000495s ]
select * from pdf where partno='324694' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.002158s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '324694' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000726s ]
SELECT `id` FROM `stock` WHERE `id` <> 59348564 AND `partno` = '324694' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.008425s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19585064 [ RunTime:0.000704s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53823571 LIMIT 5 [ RunTime:0.005638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53823571 ORDER BY `minOrder` ASC [ RunTime:0.001370s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53823571 ORDER BY `unit` DESC [ RunTime:0.000767s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53823571 LIMIT 2 [ RunTime:0.003443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53823571 ORDER BY `minOrder` ASC [ RunTime:0.001578s ]
select * from pdf where partno='324615' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001149s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '324615' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.002787s ]
SELECT `id` FROM `stock` WHERE `id` <> 53823571 AND `partno` = '324615' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.006530s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12512555 [ RunTime:0.005315s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56715177 LIMIT 5 [ RunTime:0.001209s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56715177 ORDER BY `minOrder` ASC [ RunTime:0.002248s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56715177 ORDER BY `unit` DESC [ RunTime:0.000986s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56715177 LIMIT 2 [ RunTime:0.002711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56715177 ORDER BY `minOrder` ASC [ RunTime:0.000369s ]
select * from pdf where partno='3246' and brandshort='Adafruit Industries LLC' limit 1 [ RunTime:0.004262s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3246' OR `brand` LIKE 'Adafruit Industries LLC%' ) ) LIMIT 1 [ RunTime:0.001955s ]
SELECT `id` FROM `stock` WHERE `id` <> 56715177 AND `partno` = '3246' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%adafruit industries llc%' ) [ RunTime:0.004928s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12077301 [ RunTime:0.003506s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56323006 LIMIT 5 [ RunTime:0.004205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56323006 ORDER BY `minOrder` ASC [ RunTime:0.006540s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56323006 ORDER BY `unit` DESC [ RunTime:0.000676s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56323006 LIMIT 2 [ RunTime:0.003442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56323006 ORDER BY `minOrder` ASC [ RunTime:0.000495s ]
select * from pdf where partno='3246' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.002125s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3246' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.002652s ]
SELECT `id` FROM `stock` WHERE `id` <> 56323006 AND `partno` = '3246' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.006553s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14415478 [ RunTime:0.003977s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53648862 LIMIT 5 [ RunTime:0.001737s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53648862 ORDER BY `minOrder` ASC [ RunTime:0.001090s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53648862 ORDER BY `unit` DESC [ RunTime:0.003246s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53648862 LIMIT 2 [ RunTime:0.000559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53648862 ORDER BY `minOrder` ASC [ RunTime:0.000371s ]
select * from pdf where partno='3246861' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.002562s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3246861' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.005673s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53815953 LIMIT 5 [ RunTime:0.000639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53815953 ORDER BY `minOrder` ASC [ RunTime:0.003805s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53815953 ORDER BY `unit` DESC [ RunTime:0.003853s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53815953 LIMIT 2 [ RunTime:0.000898s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53815953 ORDER BY `minOrder` ASC [ RunTime:0.002563s ]
select * from pdf where partno='324605' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.002824s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '324605' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.007089s ]
SELECT `id` FROM `stock` WHERE `id` <> 53815953 AND `partno` = '324605' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.002886s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19582729 [ RunTime:0.001662s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56186126 LIMIT 5 [ RunTime:0.001140s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56186126 ORDER BY `minOrder` ASC [ RunTime:0.004996s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56186126 ORDER BY `unit` DESC [ RunTime:0.000678s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56186126 LIMIT 2 [ RunTime:0.005261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56186126 ORDER BY `minOrder` ASC [ RunTime:0.000614s ]
select * from pdf where partno='3246 SL005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000943s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3246 SL005' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.001936s ]
SELECT `id` FROM `stock` WHERE `id` <> 56186126 AND `partno` = '3246 SL005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.005119s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13513140 [ RunTime:0.003325s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58546382 LIMIT 5 [ RunTime:0.002314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58546382 ORDER BY `minOrder` ASC [ RunTime:0.002794s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58546382 ORDER BY `unit` DESC [ RunTime:0.001748s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58546382 LIMIT 2 [ RunTime:0.005524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58546382 ORDER BY `minOrder` ASC [ RunTime:0.000438s ]
select * from pdf where partno='3246' and brandshort='Klein Tools, Inc.' limit 1 [ RunTime:0.001000s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3246' OR `brand` LIKE 'Klein Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.001528s ]
SELECT `id` FROM `stock` WHERE `id` <> 58546382 AND `partno` = '3246' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%klein tools, inc.%' ) [ RunTime:0.005090s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11196374 [ RunTime:0.000841s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56186575 LIMIT 5 [ RunTime:0.002594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56186575 ORDER BY `minOrder` ASC [ RunTime:0.006662s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56186575 ORDER BY `unit` DESC [ RunTime:0.001391s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56186575 LIMIT 2 [ RunTime:0.001153s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56186575 ORDER BY `minOrder` ASC [ RunTime:0.000403s ]
select * from pdf where partno='3246 SL002' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000818s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3246 SL002' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.002199s ]
SELECT `id` FROM `stock` WHERE `id` <> 56186575 AND `partno` = '3246 SL002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.001031s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13514322 [ RunTime:0.000739s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59389817 LIMIT 5 [ RunTime:0.006475s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59389817 ORDER BY `minOrder` ASC [ RunTime:0.003241s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59389817 ORDER BY `unit` DESC [ RunTime:0.000632s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59389817 LIMIT 2 [ RunTime:0.002623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59389817 ORDER BY `minOrder` ASC [ RunTime:0.000409s ]
select * from pdf where partno='3246862' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000580s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3246862' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.006756s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59388974 LIMIT 5 [ RunTime:0.001035s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59388974 ORDER BY `minOrder` ASC [ RunTime:0.001063s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59388974 ORDER BY `unit` DESC [ RunTime:0.005182s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59388974 LIMIT 2 [ RunTime:0.001025s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59388974 ORDER BY `minOrder` ASC [ RunTime:0.001701s ]
select * from pdf where partno='3246586' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.001052s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3246586' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.003613s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59350501 LIMIT 5 [ RunTime:0.000483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59350501 ORDER BY `minOrder` ASC [ RunTime:0.000853s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59350501 ORDER BY `unit` DESC [ RunTime:0.003387s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59350501 LIMIT 2 [ RunTime:0.000368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59350501 ORDER BY `minOrder` ASC [ RunTime:0.000238s ]
select * from pdf where partno='324621' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001214s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '324621' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.003170s ]
SELECT `id` FROM `stock` WHERE `id` <> 59350501 AND `partno` = '324621' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000664s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19584289 [ RunTime:0.000432s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59350497 LIMIT 5 [ RunTime:0.006007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59350497 ORDER BY `minOrder` ASC [ RunTime:0.000488s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59350497 ORDER BY `unit` DESC [ RunTime:0.000383s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59350497 LIMIT 2 [ RunTime:0.004942s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59350497 ORDER BY `minOrder` ASC [ RunTime:0.000235s ]
select * from pdf where partno='324658' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.003083s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '324658' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.001453s ]
SELECT `id` FROM `stock` WHERE `id` <> 59350497 AND `partno` = '324658' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000856s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19584284 [ RunTime:0.000448s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59350459 LIMIT 5 [ RunTime:0.008026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59350459 ORDER BY `minOrder` ASC [ RunTime:0.001292s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59350459 ORDER BY `unit` DESC [ RunTime:0.000435s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59350459 LIMIT 2 [ RunTime:0.000398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59350459 ORDER BY `minOrder` ASC [ RunTime:0.000529s ]
select * from pdf where partno='324659' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001395s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '324659' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000666s ]
SELECT `id` FROM `stock` WHERE `id` <> 59350459 AND `partno` = '324659' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.003995s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19584259 [ RunTime:0.000624s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59350458 LIMIT 5 [ RunTime:0.000609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59350458 ORDER BY `minOrder` ASC [ RunTime:0.003081s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59350458 ORDER BY `unit` DESC [ RunTime:0.002709s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59350458 LIMIT 2 [ RunTime:0.000489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59350458 ORDER BY `minOrder` ASC [ RunTime:0.001566s ]
select * from pdf where partno='324660' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001156s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '324660' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.007299s ]
SELECT `id` FROM `stock` WHERE `id` <> 59350458 AND `partno` = '324660' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.003078s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19584258 [ RunTime:0.003392s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59350445 LIMIT 5 [ RunTime:0.009434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59350445 ORDER BY `minOrder` ASC [ RunTime:0.001792s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59350445 ORDER BY `unit` DESC [ RunTime:0.000633s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59350445 LIMIT 2 [ RunTime:0.009601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59350445 ORDER BY `minOrder` ASC [ RunTime:0.002977s ]
select * from pdf where partno='324625' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.002018s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '324625' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.010219s ]
SELECT `id` FROM `stock` WHERE `id` <> 59350445 AND `partno` = '324625' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.001129s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15441534 [ RunTime:0.010772s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59349942 LIMIT 5 [ RunTime:0.004252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59349942 ORDER BY `minOrder` ASC [ RunTime:0.005466s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59349942 ORDER BY `unit` DESC [ RunTime:0.005893s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59349942 LIMIT 2 [ RunTime:0.001827s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59349942 ORDER BY `minOrder` ASC [ RunTime:0.000416s ]
select * from pdf where partno='324695' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.002653s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '324695' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.004194s ]
SELECT `id` FROM `stock` WHERE `id` <> 59349942 AND `partno` = '324695' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000932s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19583944 [ RunTime:0.001392s ]
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 '3246%' OR `brand` LIKE '3246%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005507s ]
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 '3246%' OR `brand` LIKE '3246%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007384s ]
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 '3246%' OR `brand` LIKE '3246%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002758s ]
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 '3246%' OR `brand` LIKE '3246%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007145s ]
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 '3246%' OR `brand` LIKE '3246%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002120s ]
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 '3246%' OR `brand` LIKE '3246%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001223s ]
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 '3246%' OR `brand` LIKE '3246%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003231s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '3246%' OR `brand` LIKE '3246%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001499s ]