SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001317s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.87' , `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=P6KE300&search=1' [ RunTime:0.003770s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002079s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000504s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001582s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.87' ) [ RunTime:0.006394s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001503s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.001458s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001967s ]
SELECT * FROM `stock_search` WHERE `partno` = 'P6KE300' LIMIT 1 [ RunTime:0.017377s ]
UPDATE `stock_search` SET `count` = 3 , `updatetime` = '2026-08-18 08:03:42' WHERE `partno` = 'P6KE300' [ RunTime:0.012704s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001406s ]
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 'P6KE300%' OR `brand` LIKE 'P6KE300%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023098s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001456s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13915942 LIMIT 5 [ RunTime:0.018278s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13915942 ORDER BY `minOrder` ASC [ RunTime:0.014464s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002832s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13915942 ORDER BY `unit` DESC [ RunTime:0.034498s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003171s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13915942 LIMIT 2 [ RunTime:0.017076s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13915942 ORDER BY `minOrder` ASC [ RunTime:0.015744s ]
select * from pdf where partno='P6KE300A' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.030325s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16674382 LIMIT 5 [ RunTime:0.019874s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16674382 ORDER BY `minOrder` ASC [ RunTime:0.032686s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16674382 ORDER BY `unit` DESC [ RunTime:0.026551s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16674382 LIMIT 2 [ RunTime:0.019594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16674382 ORDER BY `minOrder` ASC [ RunTime:0.010604s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13905604 LIMIT 5 [ RunTime:0.045749s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905604 ORDER BY `minOrder` ASC [ RunTime:0.018737s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13905604 ORDER BY `unit` DESC [ RunTime:0.033317s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13905604 LIMIT 2 [ RunTime:0.041720s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905604 ORDER BY `minOrder` ASC [ RunTime:0.009780s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13905093 LIMIT 5 [ RunTime:0.034329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905093 ORDER BY `minOrder` ASC [ RunTime:0.027646s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13905093 ORDER BY `unit` DESC [ RunTime:0.025380s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13905093 LIMIT 2 [ RunTime:0.015882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905093 ORDER BY `minOrder` ASC [ RunTime:0.033873s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14821396 LIMIT 5 [ RunTime:0.050721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14821396 ORDER BY `minOrder` ASC [ RunTime:0.034863s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14821396 ORDER BY `unit` DESC [ RunTime:0.037283s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14821396 LIMIT 2 [ RunTime:0.038099s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14821396 ORDER BY `minOrder` ASC [ RunTime:0.008914s ]
select * from pdf where partno='P6KE300CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.039752s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14800071 LIMIT 5 [ RunTime:0.009413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800071 ORDER BY `minOrder` ASC [ RunTime:0.037760s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14800071 ORDER BY `unit` DESC [ RunTime:0.016137s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14800071 LIMIT 2 [ RunTime:0.044413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800071 ORDER BY `minOrder` ASC [ RunTime:0.010475s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16661183 LIMIT 5 [ RunTime:0.036194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16661183 ORDER BY `minOrder` ASC [ RunTime:0.030738s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16661183 ORDER BY `unit` DESC [ RunTime:0.018443s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16661183 LIMIT 2 [ RunTime:0.007261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16661183 ORDER BY `minOrder` ASC [ RunTime:0.005974s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14800125 LIMIT 5 [ RunTime:0.003878s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800125 ORDER BY `minOrder` ASC [ RunTime:0.027090s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14800125 ORDER BY `unit` DESC [ RunTime:0.015611s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14800125 LIMIT 2 [ RunTime:0.020476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800125 ORDER BY `minOrder` ASC [ RunTime:0.004154s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13905170 LIMIT 5 [ RunTime:0.010559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905170 ORDER BY `minOrder` ASC [ RunTime:0.003724s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13905170 ORDER BY `unit` DESC [ RunTime:0.011183s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13905170 LIMIT 2 [ RunTime:0.003935s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905170 ORDER BY `minOrder` ASC [ RunTime:0.000391s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13933022 LIMIT 5 [ RunTime:0.008213s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13933022 ORDER BY `minOrder` ASC [ RunTime:0.023678s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13933022 ORDER BY `unit` DESC [ RunTime:0.017425s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13933022 LIMIT 2 [ RunTime:0.002834s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13933022 ORDER BY `minOrder` ASC [ RunTime:0.002408s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14803664 LIMIT 5 [ RunTime:0.018206s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803664 ORDER BY `minOrder` ASC [ RunTime:0.042685s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14803664 ORDER BY `unit` DESC [ RunTime:0.054548s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14803664 LIMIT 2 [ RunTime:0.019838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803664 ORDER BY `minOrder` ASC [ RunTime:0.010938s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16691119 LIMIT 5 [ RunTime:0.014907s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691119 ORDER BY `minOrder` ASC [ RunTime:0.046138s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16691119 ORDER BY `unit` DESC [ RunTime:0.020943s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16691119 LIMIT 2 [ RunTime:0.019209s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691119 ORDER BY `minOrder` ASC [ RunTime:0.033526s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16690196 LIMIT 5 [ RunTime:0.017226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16690196 ORDER BY `minOrder` ASC [ RunTime:0.039871s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16690196 ORDER BY `unit` DESC [ RunTime:0.022883s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16690196 LIMIT 2 [ RunTime:0.020469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16690196 ORDER BY `minOrder` ASC [ RunTime:0.017891s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16690195 LIMIT 5 [ RunTime:0.016951s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16690195 ORDER BY `minOrder` ASC [ RunTime:0.012050s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16690195 ORDER BY `unit` DESC [ RunTime:0.038373s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16690195 LIMIT 2 [ RunTime:0.031661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16690195 ORDER BY `minOrder` ASC [ RunTime:0.005154s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16688726 LIMIT 5 [ RunTime:0.053490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16688726 ORDER BY `minOrder` ASC [ RunTime:0.060076s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16688726 ORDER BY `unit` DESC [ RunTime:0.025282s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16688726 LIMIT 2 [ RunTime:0.023210s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16688726 ORDER BY `minOrder` ASC [ RunTime:0.015368s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16688725 LIMIT 5 [ RunTime:0.047037s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16688725 ORDER BY `minOrder` ASC [ RunTime:0.022148s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16688725 ORDER BY `unit` DESC [ RunTime:0.043599s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16688725 LIMIT 2 [ RunTime:0.020142s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16688725 ORDER BY `minOrder` ASC [ RunTime:0.007503s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16687890 LIMIT 5 [ RunTime:0.042760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16687890 ORDER BY `minOrder` ASC [ RunTime:0.039110s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16687890 ORDER BY `unit` DESC [ RunTime:0.042242s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16687890 LIMIT 2 [ RunTime:0.064018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16687890 ORDER BY `minOrder` ASC [ RunTime:0.034011s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16687889 LIMIT 5 [ RunTime:0.024325s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16687889 ORDER BY `minOrder` ASC [ RunTime:0.056661s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16687889 ORDER BY `unit` DESC [ RunTime:0.065576s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16687889 LIMIT 2 [ RunTime:0.027034s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16687889 ORDER BY `minOrder` ASC [ RunTime:0.019798s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16687102 LIMIT 5 [ RunTime:0.055811s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16687102 ORDER BY `minOrder` ASC [ RunTime:0.031054s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16687102 ORDER BY `unit` DESC [ RunTime:0.038731s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16687102 LIMIT 2 [ RunTime:0.043188s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16687102 ORDER BY `minOrder` ASC [ RunTime:0.016222s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16687101 LIMIT 5 [ RunTime:0.048222s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16687101 ORDER BY `minOrder` ASC [ RunTime:0.044113s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16687101 ORDER BY `unit` DESC [ RunTime:0.040363s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16687101 LIMIT 2 [ RunTime:0.006170s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16687101 ORDER BY `minOrder` ASC [ RunTime:0.002843s ]
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 'P6KE300%' OR `brand` LIKE 'P6KE300%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005981s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51141419 LIMIT 5 [ RunTime:0.002952s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51141419 ORDER BY `minOrder` ASC [ RunTime:0.016459s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51141419 ORDER BY `unit` DESC [ RunTime:0.016497s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51141419 LIMIT 2 [ RunTime:0.019548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51141419 ORDER BY `minOrder` ASC [ RunTime:0.013937s ]
select * from pdf where partno='p6ke300ca-e3/54' and brandshort='vishay semiconductors' limit 1 [ RunTime:0.025509s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001747s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'p6ke300ca-e3/54' OR `brand` LIKE 'vishay semiconductors%' ) ) LIMIT 1 [ RunTime:0.004819s ]
SELECT `id` FROM `stock` WHERE `id` <> 51141419 AND `partno` = 'p6ke300ca-e3/54' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay semiconductors%' ) [ RunTime:0.003016s ]
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 'P6KE300%' OR `brand` LIKE 'P6KE300%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018081s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42116997 LIMIT 5 [ RunTime:0.020057s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42116997 ORDER BY `minOrder` ASC [ RunTime:0.025735s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42116997 ORDER BY `unit` DESC [ RunTime:0.028732s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42116997 LIMIT 2 [ RunTime:0.027730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42116997 ORDER BY `minOrder` ASC [ RunTime:0.000962s ]
select * from pdf where partno='P6KE300A' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.011812s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE300A' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.015720s ]
SELECT `id` FROM `stock` WHERE `id` <> 42116997 AND `partno` = 'P6KE300A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.003493s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13915942 [ RunTime:0.001334s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42118069 LIMIT 5 [ RunTime:0.020895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42118069 ORDER BY `minOrder` ASC [ RunTime:0.033980s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42118069 ORDER BY `unit` DESC [ RunTime:0.009542s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42118069 LIMIT 2 [ RunTime:0.014371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42118069 ORDER BY `minOrder` ASC [ RunTime:0.006150s ]
select * from pdf where partno='P6KE300CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.005144s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE300CA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.012376s ]
SELECT `id` FROM `stock` WHERE `id` <> 42118069 AND `partno` = 'P6KE300CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.011747s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14821396 [ RunTime:0.035192s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42155571 LIMIT 5 [ RunTime:0.016083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42155571 ORDER BY `minOrder` ASC [ RunTime:0.012721s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42155571 ORDER BY `unit` DESC [ RunTime:0.025271s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42155571 LIMIT 2 [ RunTime:0.015979s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42155571 ORDER BY `minOrder` ASC [ RunTime:0.020940s ]
select * from pdf where partno='P6KE300A' and brandshort='STMicroelectronics' limit 1 [ RunTime:0.009440s ]
select foldpath,foldpath2,filename from pdf_file where id=654502 limit 1 [ RunTime:0.013750s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE300A' OR `brand` LIKE 'STMicroelectronics%' ) ) LIMIT 1 [ RunTime:0.009641s ]
SELECT `id` FROM `stock` WHERE `id` <> 42155571 AND `partno` = 'P6KE300A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%stmicroelectronics%' ) [ RunTime:0.019316s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16674382 [ RunTime:0.034797s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42150441 LIMIT 5 [ RunTime:0.062620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42150441 ORDER BY `minOrder` ASC [ RunTime:0.029932s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42150441 ORDER BY `unit` DESC [ RunTime:0.022029s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42150441 LIMIT 2 [ RunTime:0.011055s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42150441 ORDER BY `minOrder` ASC [ RunTime:0.012188s ]
select * from pdf where partno='P6KE300A' and brandshort='Fairchild Semiconductor' limit 1 [ RunTime:0.028846s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE300A' OR `brand` LIKE 'Fairchild Semiconductor%' ) ) LIMIT 1 [ RunTime:0.021848s ]
SELECT `id` FROM `stock` WHERE `id` <> 42150441 AND `partno` = 'P6KE300A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fairchild semiconductor%' ) [ RunTime:0.025772s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13905604 [ RunTime:0.024693s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42141897 LIMIT 5 [ RunTime:0.013362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42141897 ORDER BY `minOrder` ASC [ RunTime:0.018850s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42141897 ORDER BY `unit` DESC [ RunTime:0.025125s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42141897 LIMIT 2 [ RunTime:0.024026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42141897 ORDER BY `minOrder` ASC [ RunTime:0.002736s ]
select * from pdf where partno='P6KE300A' and brandshort='Diotec Semiconductor' limit 1 [ RunTime:0.045222s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE300A' OR `brand` LIKE 'Diotec Semiconductor%' ) ) LIMIT 1 [ RunTime:0.015847s ]
SELECT `id` FROM `stock` WHERE `id` <> 42141897 AND `partno` = 'P6KE300A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diotec semiconductor%' ) [ RunTime:0.062262s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13905093 [ RunTime:0.049775s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42141898 LIMIT 5 [ RunTime:0.025756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42141898 ORDER BY `minOrder` ASC [ RunTime:0.029755s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42141898 ORDER BY `unit` DESC [ RunTime:0.040181s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42141898 LIMIT 2 [ RunTime:0.052617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42141898 ORDER BY `minOrder` ASC [ RunTime:0.043887s ]
select * from pdf where partno='P6KE300CA' and brandshort='Diotec Semiconductor' limit 1 [ RunTime:0.050177s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE300CA' OR `brand` LIKE 'Diotec Semiconductor%' ) ) LIMIT 1 [ RunTime:0.046693s ]
SELECT `id` FROM `stock` WHERE `id` <> 42141898 AND `partno` = 'P6KE300CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diotec semiconductor%' ) [ RunTime:0.062343s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14800071 [ RunTime:0.028954s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42118262 LIMIT 5 [ RunTime:0.045193s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42118262 ORDER BY `minOrder` ASC [ RunTime:0.068981s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42118262 ORDER BY `unit` DESC [ RunTime:0.045627s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42118262 LIMIT 2 [ RunTime:0.039177s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42118262 ORDER BY `minOrder` ASC [ RunTime:0.025485s ]
select * from pdf where partno='P6KE300CA' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.032499s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE300CA' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.047720s ]
SELECT `id` FROM `stock` WHERE `id` <> 42118262 AND `partno` = 'P6KE300CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.017745s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16661183 [ RunTime:0.056558s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42123473 LIMIT 5 [ RunTime:0.005796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42123473 ORDER BY `minOrder` ASC [ RunTime:0.026412s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42123473 ORDER BY `unit` DESC [ RunTime:0.043942s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42123473 LIMIT 2 [ RunTime:0.016989s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42123473 ORDER BY `minOrder` ASC [ RunTime:0.026141s ]
select * from pdf where partno='P6KE300CA/B' and brandshort='YAGEO' limit 1 [ RunTime:0.064556s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE300CA/B' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.021932s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42123321 LIMIT 5 [ RunTime:0.016996s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42123321 ORDER BY `minOrder` ASC [ RunTime:0.003021s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42123321 ORDER BY `unit` DESC [ RunTime:0.011520s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42123321 LIMIT 2 [ RunTime:0.016212s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42123321 ORDER BY `minOrder` ASC [ RunTime:0.013946s ]
select * from pdf where partno='P6KE300A/B' and brandshort='YAGEO' limit 1 [ RunTime:0.027382s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE300A/B' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.035649s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42155568 LIMIT 5 [ RunTime:0.015111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42155568 ORDER BY `minOrder` ASC [ RunTime:0.006117s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42155568 ORDER BY `unit` DESC [ RunTime:0.024909s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42155568 LIMIT 2 [ RunTime:0.014236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42155568 ORDER BY `minOrder` ASC [ RunTime:0.009863s ]
select * from pdf where partno='P6KE300ARL' and brandshort='STMicroelectronics' limit 1 [ RunTime:0.032971s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE300ARL' OR `brand` LIKE 'STMicroelectronics%' ) ) LIMIT 1 [ RunTime:0.030572s ]
SELECT `id` FROM `stock` WHERE `id` <> 42155568 AND `partno` = 'P6KE300ARL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%stmicroelectronics%' ) [ RunTime:0.020272s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13933022 [ RunTime:0.028429s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42173766 LIMIT 5 [ RunTime:0.026531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42173766 ORDER BY `minOrder` ASC [ RunTime:0.027521s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42173766 ORDER BY `unit` DESC [ RunTime:0.007959s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42173766 LIMIT 2 [ RunTime:0.020331s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42173766 ORDER BY `minOrder` ASC [ RunTime:0.011025s ]
select * from pdf where partno='P6KE300CA' and brandshort='SMC Diode Solutions' limit 1 [ RunTime:0.018007s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE300CA' OR `brand` LIKE 'SMC Diode Solutions%' ) ) LIMIT 1 [ RunTime:0.020458s ]
SELECT `id` FROM `stock` WHERE `id` <> 42173766 AND `partno` = 'P6KE300CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%smc diode solutions%' ) [ RunTime:0.011213s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14803664 [ RunTime:0.002765s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42292498 LIMIT 5 [ RunTime:0.016012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42292498 ORDER BY `minOrder` ASC [ RunTime:0.018377s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42292498 ORDER BY `unit` DESC [ RunTime:0.016468s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42292498 LIMIT 2 [ RunTime:0.026080s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42292498 ORDER BY `minOrder` ASC [ RunTime:0.005582s ]
select * from pdf where partno='P6KE300CA-E3/73' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.006347s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE300CA-E3/73' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.029782s ]
SELECT `id` FROM `stock` WHERE `id` <> 42292498 AND `partno` = 'P6KE300CA-E3/73' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.015271s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42290532 LIMIT 5 [ RunTime:0.033024s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42290532 ORDER BY `minOrder` ASC [ RunTime:0.024197s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42290532 ORDER BY `unit` DESC [ RunTime:0.024258s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42290532 LIMIT 2 [ RunTime:0.012515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42290532 ORDER BY `minOrder` ASC [ RunTime:0.029759s ]
select * from pdf where partno='P6KE300CA-E3/54' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.059214s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE300CA-E3/54' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.028384s ]
SELECT `id` FROM `stock` WHERE `id` <> 42290532 AND `partno` = 'P6KE300CA-E3/54' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.037868s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14816956 [ RunTime:0.044433s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42284434 LIMIT 5 [ RunTime:0.056049s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42284434 ORDER BY `minOrder` ASC [ RunTime:0.050568s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42284434 ORDER BY `unit` DESC [ RunTime:0.022326s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42284434 LIMIT 2 [ RunTime:0.033673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42284434 ORDER BY `minOrder` ASC [ RunTime:0.015042s ]
select * from pdf where partno='P6KE300A-E3/73' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.014643s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE300A-E3/73' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.025769s ]
SELECT `id` FROM `stock` WHERE `id` <> 42284434 AND `partno` = 'P6KE300A-E3/73' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.028395s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42283524 LIMIT 5 [ RunTime:0.024159s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42283524 ORDER BY `minOrder` ASC [ RunTime:0.016247s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42283524 ORDER BY `unit` DESC [ RunTime:0.017113s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42283524 LIMIT 2 [ RunTime:0.027765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42283524 ORDER BY `minOrder` ASC [ RunTime:0.012021s ]
select * from pdf where partno='P6KE300A-E3/54' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.035243s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE300A-E3/54' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.052687s ]
SELECT `id` FROM `stock` WHERE `id` <> 42283524 AND `partno` = 'P6KE300A-E3/54' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.038128s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14815377 [ RunTime:0.030138s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42274072 LIMIT 5 [ RunTime:0.013803s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42274072 ORDER BY `minOrder` ASC [ RunTime:0.022327s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42274072 ORDER BY `unit` DESC [ RunTime:0.010383s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42274072 LIMIT 2 [ RunTime:0.022200s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42274072 ORDER BY `minOrder` ASC [ RunTime:0.015337s ]
select * from pdf where partno='P6KE300CA-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.074672s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE300CA-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.030547s ]
SELECT `id` FROM `stock` WHERE `id` <> 42274072 AND `partno` = 'P6KE300CA-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.008381s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13917841 [ RunTime:0.041815s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42268496 LIMIT 5 [ RunTime:0.058230s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42268496 ORDER BY `minOrder` ASC [ RunTime:0.052459s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42268496 ORDER BY `unit` DESC [ RunTime:0.033418s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42268496 LIMIT 2 [ RunTime:0.026261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42268496 ORDER BY `minOrder` ASC [ RunTime:0.024945s ]
select * from pdf where partno='P6KE300CA-BP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.042971s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE300CA-BP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.073656s ]
SELECT `id` FROM `stock` WHERE `id` <> 42268496 AND `partno` = 'P6KE300CA-BP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.101181s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14814648 [ RunTime:0.080561s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42268494 LIMIT 5 [ RunTime:0.070796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42268494 ORDER BY `minOrder` ASC [ RunTime:0.030788s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42268494 ORDER BY `unit` DESC [ RunTime:0.022755s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42268494 LIMIT 2 [ RunTime:0.047677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42268494 ORDER BY `minOrder` ASC [ RunTime:0.012327s ]
select * from pdf where partno='P6KE300CA-AP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.031018s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE300CA-AP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.022046s ]
SELECT `id` FROM `stock` WHERE `id` <> 42268494 AND `partno` = 'P6KE300CA-AP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.029403s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14814647 [ RunTime:0.014307s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42266334 LIMIT 5 [ RunTime:0.013091s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42266334 ORDER BY `minOrder` ASC [ RunTime:0.014539s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42266334 ORDER BY `unit` DESC [ RunTime:0.035925s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42266334 LIMIT 2 [ RunTime:0.032967s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42266334 ORDER BY `minOrder` ASC [ RunTime:0.016865s ]
select * from pdf where partno='P6KE300CA-HF' and brandshort='Comchip Technology' limit 1 [ RunTime:0.034653s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE300CA-HF' OR `brand` LIKE 'Comchip Technology%' ) ) LIMIT 1 [ RunTime:0.001055s ]
SELECT `id` FROM `stock` WHERE `id` <> 42266334 AND `partno` = 'P6KE300CA-HF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%comchip technology%' ) [ RunTime:0.026291s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14815420 [ RunTime:0.009985s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42266333 LIMIT 5 [ RunTime:0.003232s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42266333 ORDER BY `minOrder` ASC [ RunTime:0.003846s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42266333 ORDER BY `unit` DESC [ RunTime:0.006500s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42266333 LIMIT 2 [ RunTime:0.015233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42266333 ORDER BY `minOrder` ASC [ RunTime:0.008043s ]
select * from pdf where partno='P6KE300CA-G' and brandshort='Comchip Technology' limit 1 [ RunTime:0.011519s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE300CA-G' OR `brand` LIKE 'Comchip Technology%' ) ) LIMIT 1 [ RunTime:0.012138s ]
SELECT `id` FROM `stock` WHERE `id` <> 42266333 AND `partno` = 'P6KE300CA-G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%comchip technology%' ) [ RunTime:0.009543s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13917813 [ RunTime:0.013438s ]
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 'P6KE300%' OR `brand` LIKE 'P6KE300%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026339s ]
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 'P6KE300%' OR `brand` LIKE 'P6KE300%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.042483s ]
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 'P6KE300%' OR `brand` LIKE 'P6KE300%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014759s ]
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 'P6KE300%' OR `brand` LIKE 'P6KE300%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027572s ]
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 'P6KE300%' OR `brand` LIKE 'P6KE300%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008517s ]
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 'P6KE300%' OR `brand` LIKE 'P6KE300%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014144s ]
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 'P6KE300%' OR `brand` LIKE 'P6KE300%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011989s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'P6KE300%' OR `brand` LIKE 'P6KE300%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.004383s ]