SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001215s ]
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=9649&search=1' [ RunTime:0.005665s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001251s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.003229s ]
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.000344s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002188s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000263s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001657s ]
SELECT * FROM `stock_search` WHERE `partno` = '9649' LIMIT 1 [ RunTime:0.006558s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-27 23:15:44' WHERE `partno` = '9649' [ RunTime:0.017926s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001475s ]
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 '9649%' OR `brand` LIKE '9649%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017756s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001103s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11483701 LIMIT 5 [ RunTime:0.021347s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.014613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11483701 ORDER BY `minOrder` ASC [ RunTime:0.027371s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.007841s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11483701 ORDER BY `unit` DESC [ RunTime:0.037738s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001242s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11483701 LIMIT 2 [ RunTime:0.041448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11483701 ORDER BY `minOrder` ASC [ RunTime:0.029506s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12613354 LIMIT 5 [ RunTime:0.047214s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12613354 ORDER BY `minOrder` ASC [ RunTime:0.022503s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12613354 ORDER BY `unit` DESC [ RunTime:0.040280s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12613354 LIMIT 2 [ RunTime:0.028194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12613354 ORDER BY `minOrder` ASC [ RunTime:0.019599s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12617326 LIMIT 5 [ RunTime:0.034337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12617326 ORDER BY `minOrder` ASC [ RunTime:0.022118s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12617326 ORDER BY `unit` DESC [ RunTime:0.019675s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12617326 LIMIT 2 [ RunTime:0.016856s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12617326 ORDER BY `minOrder` ASC [ RunTime:0.020742s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5434 LIMIT 5 [ RunTime:0.033808s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5434 ORDER BY `minOrder` ASC [ RunTime:0.029252s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 5434 ORDER BY `unit` DESC [ RunTime:0.031082s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 5434 LIMIT 2 [ RunTime:0.032258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5434 ORDER BY `minOrder` ASC [ RunTime:0.018836s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002486s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '964972-1' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.017861s ]
SELECT `id` FROM `stock` WHERE `id` <> 5434 AND `partno` = '964972-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amp - te connectivity%' ) [ RunTime:0.023862s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18710902 LIMIT 5 [ RunTime:0.043827s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18710902 ORDER BY `minOrder` ASC [ RunTime:0.025647s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18710902 ORDER BY `unit` DESC [ RunTime:0.033925s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18710902 LIMIT 2 [ RunTime:0.024164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18710902 ORDER BY `minOrder` ASC [ RunTime:0.004050s ]
select * from pdf where partno='96495' and brandshort='3M' limit 1 [ RunTime:0.026490s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18710884 LIMIT 5 [ RunTime:0.064760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18710884 ORDER BY `minOrder` ASC [ RunTime:0.053440s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18710884 ORDER BY `unit` DESC [ RunTime:0.050153s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18710884 LIMIT 2 [ RunTime:0.027530s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18710884 ORDER BY `minOrder` ASC [ RunTime:0.018607s ]
select * from pdf where partno='96496' and brandshort='3M' limit 1 [ RunTime:0.004324s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16616235 LIMIT 5 [ RunTime:0.014831s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16616235 ORDER BY `minOrder` ASC [ RunTime:0.047489s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16616235 ORDER BY `unit` DESC [ RunTime:0.033177s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16616235 LIMIT 2 [ RunTime:0.026069s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16616235 ORDER BY `minOrder` ASC [ RunTime:0.000398s ]
select * from pdf where partno='96490' and brandshort='Lumberg Automation' limit 1 [ RunTime:0.000771s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16431329 LIMIT 5 [ RunTime:0.008698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16431329 ORDER BY `minOrder` ASC [ RunTime:0.021905s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16431329 ORDER BY `unit` DESC [ RunTime:0.021355s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16431329 LIMIT 2 [ RunTime:0.016621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16431329 ORDER BY `minOrder` ASC [ RunTime:0.025749s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16431328 LIMIT 5 [ RunTime:0.025411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16431328 ORDER BY `minOrder` ASC [ RunTime:0.020482s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16431328 ORDER BY `unit` DESC [ RunTime:0.021535s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16431328 LIMIT 2 [ RunTime:0.012296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16431328 ORDER BY `minOrder` ASC [ RunTime:0.006180s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16431327 LIMIT 5 [ RunTime:0.007023s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16431327 ORDER BY `minOrder` ASC [ RunTime:0.011863s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16431327 ORDER BY `unit` DESC [ RunTime:0.019917s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16431327 LIMIT 2 [ RunTime:0.014095s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16431327 ORDER BY `minOrder` ASC [ RunTime:0.006750s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16431235 LIMIT 5 [ RunTime:0.016704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16431235 ORDER BY `minOrder` ASC [ RunTime:0.010231s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16431235 ORDER BY `unit` DESC [ RunTime:0.000439s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16431235 LIMIT 2 [ RunTime:0.009073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16431235 ORDER BY `minOrder` ASC [ RunTime:0.004523s ]
select * from pdf where partno='96491.5' and brandshort='Pflitsch' limit 1 [ RunTime:0.001023s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16430159 LIMIT 5 [ RunTime:0.006355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16430159 ORDER BY `minOrder` ASC [ RunTime:0.003383s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16430159 ORDER BY `unit` DESC [ RunTime:0.006390s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16430159 LIMIT 2 [ RunTime:0.003062s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16430159 ORDER BY `minOrder` ASC [ RunTime:0.000486s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16430158 LIMIT 5 [ RunTime:0.000737s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16430158 ORDER BY `minOrder` ASC [ RunTime:0.009815s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16430158 ORDER BY `unit` DESC [ RunTime:0.004701s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16430158 LIMIT 2 [ RunTime:0.004624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16430158 ORDER BY `minOrder` ASC [ RunTime:0.000560s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15268857 LIMIT 5 [ RunTime:0.005988s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15268857 ORDER BY `minOrder` ASC [ RunTime:0.001016s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15268857 ORDER BY `unit` DESC [ RunTime:0.001637s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15268857 LIMIT 2 [ RunTime:0.000580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15268857 ORDER BY `minOrder` ASC [ RunTime:0.000436s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14417475 LIMIT 5 [ RunTime:0.001110s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14417475 ORDER BY `minOrder` ASC [ RunTime:0.000979s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14417475 ORDER BY `unit` DESC [ RunTime:0.000604s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14417475 LIMIT 2 [ RunTime:0.000661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14417475 ORDER BY `minOrder` ASC [ RunTime:0.001004s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14417474 LIMIT 5 [ RunTime:0.005769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14417474 ORDER BY `minOrder` ASC [ RunTime:0.009444s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14417474 ORDER BY `unit` DESC [ RunTime:0.001683s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14417474 LIMIT 2 [ RunTime:0.001554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14417474 ORDER BY `minOrder` ASC [ RunTime:0.000428s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14417421 LIMIT 5 [ RunTime:0.001150s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14417421 ORDER BY `minOrder` ASC [ RunTime:0.004381s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14417421 ORDER BY `unit` DESC [ RunTime:0.011645s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14417421 LIMIT 2 [ RunTime:0.001433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14417421 ORDER BY `minOrder` ASC [ RunTime:0.002331s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14417039 LIMIT 5 [ RunTime:0.020336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14417039 ORDER BY `minOrder` ASC [ RunTime:0.004570s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14417039 ORDER BY `unit` DESC [ RunTime:0.032811s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14417039 LIMIT 2 [ RunTime:0.010453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14417039 ORDER BY `minOrder` ASC [ RunTime:0.021728s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14416987 LIMIT 5 [ RunTime:0.019128s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14416987 ORDER BY `minOrder` ASC [ RunTime:0.017830s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14416987 ORDER BY `unit` DESC [ RunTime:0.010616s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14416987 LIMIT 2 [ RunTime:0.003611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14416987 ORDER BY `minOrder` ASC [ RunTime:0.007730s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13547344 LIMIT 5 [ RunTime:0.003268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13547344 ORDER BY `minOrder` ASC [ RunTime:0.007591s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13547344 ORDER BY `unit` DESC [ RunTime:0.010025s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13547344 LIMIT 2 [ RunTime:0.000553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13547344 ORDER BY `minOrder` ASC [ RunTime:0.005785s ]
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 '9649%' OR `brand` LIKE '9649%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001408s ]
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 '9649%' OR `brand` LIKE '9649%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010779s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60361241 LIMIT 5 [ RunTime:0.000842s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60361241 ORDER BY `minOrder` ASC [ RunTime:0.003220s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60361241 ORDER BY `unit` DESC [ RunTime:0.004402s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60361241 LIMIT 2 [ RunTime:0.001752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60361241 ORDER BY `minOrder` ASC [ RunTime:0.001271s ]
select * from pdf where partno='964972-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.004693s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '964972-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000546s ]
SELECT `id` FROM `stock` WHERE `id` <> 60361241 AND `partno` = '964972-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000457s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11483701 [ RunTime:0.000319s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60361346 LIMIT 5 [ RunTime:0.001180s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60361346 ORDER BY `minOrder` ASC [ RunTime:0.013253s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60361346 ORDER BY `unit` DESC [ RunTime:0.006193s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60361346 LIMIT 2 [ RunTime:0.001230s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60361346 ORDER BY `minOrder` ASC [ RunTime:0.000484s ]
select * from pdf where partno='964971-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001157s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '964971-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.002902s ]
SELECT `id` FROM `stock` WHERE `id` <> 60361346 AND `partno` = '964971-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.004744s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12613354 [ RunTime:0.000816s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59945821 LIMIT 5 [ RunTime:0.000708s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59945821 ORDER BY `minOrder` ASC [ RunTime:0.001274s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59945821 ORDER BY `unit` DESC [ RunTime:0.000642s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59945821 LIMIT 2 [ RunTime:0.002009s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59945821 ORDER BY `minOrder` ASC [ RunTime:0.000455s ]
select * from pdf where partno='964976-6' and brandshort='TE Connectivity' limit 1 [ RunTime:0.001705s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '964976-6' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.022677s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63455535 LIMIT 5 [ RunTime:0.001631s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63455535 ORDER BY `minOrder` ASC [ RunTime:0.001308s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63455535 ORDER BY `unit` DESC [ RunTime:0.001241s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63455535 LIMIT 2 [ RunTime:0.002146s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63455535 ORDER BY `minOrder` ASC [ RunTime:0.000455s ]
select * from pdf where partno='9649010' and brandshort='Rittal' limit 1 [ RunTime:0.001567s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9649010' OR `brand` LIKE 'Rittal%' ) ) LIMIT 1 [ RunTime:0.001251s ]
SELECT `id` FROM `stock` WHERE `id` <> 63455535 AND `partno` = '9649010' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rittal%' ) [ RunTime:0.000855s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15268857 [ RunTime:0.000739s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63387869 LIMIT 5 [ RunTime:0.002404s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63387869 ORDER BY `minOrder` ASC [ RunTime:0.004899s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63387869 ORDER BY `unit` DESC [ RunTime:0.000678s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63387869 LIMIT 2 [ RunTime:0.000650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63387869 ORDER BY `minOrder` ASC [ RunTime:0.000414s ]
select * from pdf where partno='9649' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.001363s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9649' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.001142s ]
SELECT `id` FROM `stock` WHERE `id` <> 63387869 AND `partno` = '9649' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.001878s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63147472 LIMIT 5 [ RunTime:0.000584s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63147472 ORDER BY `minOrder` ASC [ RunTime:0.001022s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63147472 ORDER BY `unit` DESC [ RunTime:0.000549s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63147472 LIMIT 2 [ RunTime:0.002555s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63147472 ORDER BY `minOrder` ASC [ RunTime:0.004671s ]
select * from pdf where partno='96490.6.1' and brandshort='Pflitsch' limit 1 [ RunTime:0.004071s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96490.6.1' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.004666s ]
SELECT `id` FROM `stock` WHERE `id` <> 63147472 AND `partno` = '96490.6.1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.010851s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13547344 [ RunTime:0.001642s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63146768 LIMIT 5 [ RunTime:0.007897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63146768 ORDER BY `minOrder` ASC [ RunTime:0.001948s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63146768 ORDER BY `unit` DESC [ RunTime:0.004984s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63146768 LIMIT 2 [ RunTime:0.012881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63146768 ORDER BY `minOrder` ASC [ RunTime:0.001575s ]
select * from pdf where partno='96494.5' and brandshort='Pflitsch' limit 1 [ RunTime:0.000913s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96494.5' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.003881s ]
SELECT `id` FROM `stock` WHERE `id` <> 63146768 AND `partno` = '96494.5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.009961s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16431329 [ RunTime:0.014041s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63146767 LIMIT 5 [ RunTime:0.002319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63146767 ORDER BY `minOrder` ASC [ RunTime:0.000702s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63146767 ORDER BY `unit` DESC [ RunTime:0.000542s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63146767 LIMIT 2 [ RunTime:0.002664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63146767 ORDER BY `minOrder` ASC [ RunTime:0.004192s ]
select * from pdf where partno='96493.5' and brandshort='Pflitsch' limit 1 [ RunTime:0.001112s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96493.5' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.004260s ]
SELECT `id` FROM `stock` WHERE `id` <> 63146767 AND `partno` = '96493.5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.007757s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16431328 [ RunTime:0.004460s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63146766 LIMIT 5 [ RunTime:0.000751s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63146766 ORDER BY `minOrder` ASC [ RunTime:0.002793s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63146766 ORDER BY `unit` DESC [ RunTime:0.000666s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63146766 LIMIT 2 [ RunTime:0.005257s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63146766 ORDER BY `minOrder` ASC [ RunTime:0.002051s ]
select * from pdf where partno='96492.5' and brandshort='Pflitsch' limit 1 [ RunTime:0.000833s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96492.5' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.002966s ]
SELECT `id` FROM `stock` WHERE `id` <> 63146766 AND `partno` = '96492.5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.002931s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16431327 [ RunTime:0.004387s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63146678 LIMIT 5 [ RunTime:0.000611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63146678 ORDER BY `minOrder` ASC [ RunTime:0.002167s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63146678 ORDER BY `unit` DESC [ RunTime:0.000621s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63146678 LIMIT 2 [ RunTime:0.000512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63146678 ORDER BY `minOrder` ASC [ RunTime:0.001030s ]
select * from pdf where partno='96494.4' and brandshort='Pflitsch' limit 1 [ RunTime:0.000907s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96494.4' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.003375s ]
SELECT `id` FROM `stock` WHERE `id` <> 63146678 AND `partno` = '96494.4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.002922s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13547108 [ RunTime:0.000805s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63146677 LIMIT 5 [ RunTime:0.000376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63146677 ORDER BY `minOrder` ASC [ RunTime:0.001729s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63146677 ORDER BY `unit` DESC [ RunTime:0.000622s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63146677 LIMIT 2 [ RunTime:0.000582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63146677 ORDER BY `minOrder` ASC [ RunTime:0.001222s ]
select * from pdf where partno='96493.4' and brandshort='Pflitsch' limit 1 [ RunTime:0.001366s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96493.4' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.007701s ]
SELECT `id` FROM `stock` WHERE `id` <> 63146677 AND `partno` = '96493.4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.006159s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14417475 [ RunTime:0.001491s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63146676 LIMIT 5 [ RunTime:0.000617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63146676 ORDER BY `minOrder` ASC [ RunTime:0.000812s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63146676 ORDER BY `unit` DESC [ RunTime:0.001052s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63146676 LIMIT 2 [ RunTime:0.000586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63146676 ORDER BY `minOrder` ASC [ RunTime:0.000412s ]
select * from pdf where partno='96492.4' and brandshort='Pflitsch' limit 1 [ RunTime:0.001288s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96492.4' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.007685s ]
SELECT `id` FROM `stock` WHERE `id` <> 63146676 AND `partno` = '96492.4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.002295s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14417474 [ RunTime:0.005157s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63146504 LIMIT 5 [ RunTime:0.001587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63146504 ORDER BY `minOrder` ASC [ RunTime:0.002950s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63146504 ORDER BY `unit` DESC [ RunTime:0.002497s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63146504 LIMIT 2 [ RunTime:0.000492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63146504 ORDER BY `minOrder` ASC [ RunTime:0.000366s ]
select * from pdf where partno='96491.5' and brandshort='Pflitsch' limit 1 [ RunTime:0.000500s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96491.5' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.006897s ]
SELECT `id` FROM `stock` WHERE `id` <> 63146504 AND `partno` = '96491.5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.003449s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16431235 [ RunTime:0.001816s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63146459 LIMIT 5 [ RunTime:0.003995s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63146459 ORDER BY `minOrder` ASC [ RunTime:0.007781s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63146459 ORDER BY `unit` DESC [ RunTime:0.002161s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63146459 LIMIT 2 [ RunTime:0.001384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63146459 ORDER BY `minOrder` ASC [ RunTime:0.002290s ]
select * from pdf where partno='96491.4' and brandshort='Pflitsch' limit 1 [ RunTime:0.000912s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96491.4' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.000638s ]
SELECT `id` FROM `stock` WHERE `id` <> 63146459 AND `partno` = '96491.4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.000588s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14417421 [ RunTime:0.000413s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63145093 LIMIT 5 [ RunTime:0.000380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63145093 ORDER BY `minOrder` ASC [ RunTime:0.000478s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63145093 ORDER BY `unit` DESC [ RunTime:0.004491s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63145093 LIMIT 2 [ RunTime:0.001689s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63145093 ORDER BY `minOrder` ASC [ RunTime:0.000352s ]
select * from pdf where partno='96490.5' and brandshort='Pflitsch' limit 1 [ RunTime:0.001762s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96490.5' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.001507s ]
SELECT `id` FROM `stock` WHERE `id` <> 63145093 AND `partno` = '96490.5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.004959s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14417039 [ RunTime:0.001443s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63144911 LIMIT 5 [ RunTime:0.000835s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63144911 ORDER BY `minOrder` ASC [ RunTime:0.002168s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63144911 ORDER BY `unit` DESC [ RunTime:0.001771s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63144911 LIMIT 2 [ RunTime:0.005856s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63144911 ORDER BY `minOrder` ASC [ RunTime:0.000364s ]
select * from pdf where partno='96490.4' and brandshort='Pflitsch' limit 1 [ RunTime:0.000865s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96490.4' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.004833s ]
SELECT `id` FROM `stock` WHERE `id` <> 63144911 AND `partno` = '96490.4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.001273s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14416987 [ RunTime:0.001712s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63143281 LIMIT 5 [ RunTime:0.001978s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63143281 ORDER BY `minOrder` ASC [ RunTime:0.001021s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63143281 ORDER BY `unit` DESC [ RunTime:0.000368s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63143281 LIMIT 2 [ RunTime:0.001154s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63143281 ORDER BY `minOrder` ASC [ RunTime:0.001589s ]
select * from pdf where partno='96491.6.1' and brandshort='Pflitsch' limit 1 [ RunTime:0.000818s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96491.6.1' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.004329s ]
SELECT `id` FROM `stock` WHERE `id` <> 63143281 AND `partno` = '96491.6.1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.005145s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13546195 [ RunTime:0.005788s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63142936 LIMIT 5 [ RunTime:0.001234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63142936 ORDER BY `minOrder` ASC [ RunTime:0.000777s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63142936 ORDER BY `unit` DESC [ RunTime:0.002664s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63142936 LIMIT 2 [ RunTime:0.000497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63142936 ORDER BY `minOrder` ASC [ RunTime:0.000364s ]
select * from pdf where partno='96497.4.1' and brandshort='Pflitsch' limit 1 [ RunTime:0.005342s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96497.4.1' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.004440s ]
SELECT `id` FROM `stock` WHERE `id` <> 63142936 AND `partno` = '96497.4.1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.009506s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16430159 [ RunTime:0.000663s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63142935 LIMIT 5 [ RunTime:0.016536s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63142935 ORDER BY `minOrder` ASC [ RunTime:0.012124s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63142935 ORDER BY `unit` DESC [ RunTime:0.011534s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63142935 LIMIT 2 [ RunTime:0.005693s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63142935 ORDER BY `minOrder` ASC [ RunTime:0.002079s ]
select * from pdf where partno='96496.4.1' and brandshort='Pflitsch' limit 1 [ RunTime:0.006963s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96496.4.1' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.009376s ]
SELECT `id` FROM `stock` WHERE `id` <> 63142935 AND `partno` = '96496.4.1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.004207s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16430158 [ RunTime:0.003217s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63142934 LIMIT 5 [ RunTime:0.000629s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63142934 ORDER BY `minOrder` ASC [ RunTime:0.000638s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63142934 ORDER BY `unit` DESC [ RunTime:0.003380s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63142934 LIMIT 2 [ RunTime:0.010058s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63142934 ORDER BY `minOrder` ASC [ RunTime:0.011068s ]
select * from pdf where partno='96495.4.1' and brandshort='Pflitsch' limit 1 [ RunTime:0.004116s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96495.4.1' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.003882s ]
SELECT `id` FROM `stock` WHERE `id` <> 63142934 AND `partno` = '96495.4.1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.000894s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13546096 [ RunTime:0.001863s ]
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 '9649%' OR `brand` LIKE '9649%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005172s ]
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 '9649%' OR `brand` LIKE '9649%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001701s ]
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 '9649%' OR `brand` LIKE '9649%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017964s ]
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 '9649%' OR `brand` LIKE '9649%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008604s ]
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 '9649%' OR `brand` LIKE '9649%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011323s ]
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 '9649%' OR `brand` LIKE '9649%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007290s ]
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 '9649%' OR `brand` LIKE '9649%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006805s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '9649%' OR `brand` LIKE '9649%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001801s ]