SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001477s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.222' , `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=2121&search=1' [ RunTime:0.007692s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001355s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.004201s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001420s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.222' ) [ RunTime:0.004371s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001077s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.011785s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001575s ]
SELECT * FROM `stock_search` WHERE `partno` = '2121' LIMIT 1 [ RunTime:0.011920s ]
UPDATE `stock_search` SET `count` = 29 , `updatetime` = '2026-08-30 21:06:51' WHERE `partno` = '2121' [ RunTime:0.013454s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001374s ]
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 '2121%' OR `brand` LIKE '2121%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.041116s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002229s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12618947 LIMIT 5 [ RunTime:0.026004s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12618947 ORDER BY `minOrder` ASC [ RunTime:0.028055s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.040390s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12618947 ORDER BY `unit` DESC [ RunTime:0.040559s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.019689s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12618947 LIMIT 2 [ RunTime:0.023597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12618947 ORDER BY `minOrder` ASC [ RunTime:0.011799s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12621594 LIMIT 5 [ RunTime:0.037159s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12621594 ORDER BY `minOrder` ASC [ RunTime:0.038827s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12621594 ORDER BY `unit` DESC [ RunTime:0.038334s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12621594 LIMIT 2 [ RunTime:0.022409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12621594 ORDER BY `minOrder` ASC [ RunTime:0.010413s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12617843 LIMIT 5 [ RunTime:0.018410s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12617843 ORDER BY `minOrder` ASC [ RunTime:0.018784s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12617843 ORDER BY `unit` DESC [ RunTime:0.011965s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12617843 LIMIT 2 [ RunTime:0.002583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12617843 ORDER BY `minOrder` ASC [ RunTime:0.002513s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11488002 LIMIT 5 [ RunTime:0.024153s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11488002 ORDER BY `minOrder` ASC [ RunTime:0.013261s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11488002 ORDER BY `unit` DESC [ RunTime:0.046531s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11488002 LIMIT 2 [ RunTime:0.031254s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11488002 ORDER BY `minOrder` ASC [ RunTime:0.010560s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15488779 LIMIT 5 [ RunTime:0.037922s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15488779 ORDER BY `minOrder` ASC [ RunTime:0.011245s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15488779 ORDER BY `unit` DESC [ RunTime:0.007326s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15488779 LIMIT 2 [ RunTime:0.005795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15488779 ORDER BY `minOrder` ASC [ RunTime:0.004288s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15487473 LIMIT 5 [ RunTime:0.013296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15487473 ORDER BY `minOrder` ASC [ RunTime:0.022082s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15487473 ORDER BY `unit` DESC [ RunTime:0.036101s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15487473 LIMIT 2 [ RunTime:0.008463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15487473 ORDER BY `minOrder` ASC [ RunTime:0.009418s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16225520 LIMIT 5 [ RunTime:0.026561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16225520 ORDER BY `minOrder` ASC [ RunTime:0.021392s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16225520 ORDER BY `unit` DESC [ RunTime:0.027887s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16225520 LIMIT 2 [ RunTime:0.030740s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16225520 ORDER BY `minOrder` ASC [ RunTime:0.007303s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19589311 LIMIT 5 [ RunTime:0.028738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19589311 ORDER BY `minOrder` ASC [ RunTime:0.010639s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19589311 ORDER BY `unit` DESC [ RunTime:0.018806s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19589311 LIMIT 2 [ RunTime:0.019206s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19589311 ORDER BY `minOrder` ASC [ RunTime:0.020986s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15442394 LIMIT 5 [ RunTime:0.028674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15442394 ORDER BY `minOrder` ASC [ RunTime:0.053739s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15442394 ORDER BY `unit` DESC [ RunTime:0.010603s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15442394 LIMIT 2 [ RunTime:0.002971s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15442394 ORDER BY `minOrder` ASC [ RunTime:0.004424s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16148037 LIMIT 5 [ RunTime:0.011415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16148037 ORDER BY `minOrder` ASC [ RunTime:0.014987s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16148037 ORDER BY `unit` DESC [ RunTime:0.007395s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16148037 LIMIT 2 [ RunTime:0.010037s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16148037 ORDER BY `minOrder` ASC [ RunTime:0.017363s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12037014 LIMIT 5 [ RunTime:0.006125s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12037014 ORDER BY `minOrder` ASC [ RunTime:0.005409s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12037014 ORDER BY `unit` DESC [ RunTime:0.021673s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12037014 LIMIT 2 [ RunTime:0.017225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12037014 ORDER BY `minOrder` ASC [ RunTime:0.011361s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15442396 LIMIT 5 [ RunTime:0.005887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15442396 ORDER BY `minOrder` ASC [ RunTime:0.010297s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15442396 ORDER BY `unit` DESC [ RunTime:0.005773s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15442396 LIMIT 2 [ RunTime:0.012094s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15442396 ORDER BY `minOrder` ASC [ RunTime:0.006805s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12039836 LIMIT 5 [ RunTime:0.008762s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12039836 ORDER BY `minOrder` ASC [ RunTime:0.008292s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12039836 ORDER BY `unit` DESC [ RunTime:0.005150s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12039836 LIMIT 2 [ RunTime:0.003456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12039836 ORDER BY `minOrder` ASC [ RunTime:0.014138s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19590162 LIMIT 5 [ RunTime:0.012356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19590162 ORDER BY `minOrder` ASC [ RunTime:0.002935s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19590162 ORDER BY `unit` DESC [ RunTime:0.006651s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19590162 LIMIT 2 [ RunTime:0.032621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19590162 ORDER BY `minOrder` ASC [ RunTime:0.028869s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13416098 LIMIT 5 [ RunTime:0.023105s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13416098 ORDER BY `minOrder` ASC [ RunTime:0.039310s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13416098 ORDER BY `unit` DESC [ RunTime:0.007713s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13416098 LIMIT 2 [ RunTime:0.010112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13416098 ORDER BY `minOrder` ASC [ RunTime:0.047961s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19591091 LIMIT 5 [ RunTime:0.021164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19591091 ORDER BY `minOrder` ASC [ RunTime:0.006817s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19591091 ORDER BY `unit` DESC [ RunTime:0.007098s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19591091 LIMIT 2 [ RunTime:0.003216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19591091 ORDER BY `minOrder` ASC [ RunTime:0.007202s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19591082 LIMIT 5 [ RunTime:0.006590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19591082 ORDER BY `minOrder` ASC [ RunTime:0.011724s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19591082 ORDER BY `unit` DESC [ RunTime:0.029660s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19591082 LIMIT 2 [ RunTime:0.040173s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19591082 ORDER BY `minOrder` ASC [ RunTime:0.011459s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17299778 LIMIT 5 [ RunTime:0.016229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17299778 ORDER BY `minOrder` ASC [ RunTime:0.020265s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17299778 ORDER BY `unit` DESC [ RunTime:0.024435s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17299778 LIMIT 2 [ RunTime:0.026303s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17299778 ORDER BY `minOrder` ASC [ RunTime:0.009303s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19591092 LIMIT 5 [ RunTime:0.022947s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19591092 ORDER BY `minOrder` ASC [ RunTime:0.013904s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19591092 ORDER BY `unit` DESC [ RunTime:0.054935s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19591092 LIMIT 2 [ RunTime:0.052119s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19591092 ORDER BY `minOrder` ASC [ RunTime:0.016492s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19591155 LIMIT 5 [ RunTime:0.011076s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19591155 ORDER BY `minOrder` ASC [ RunTime:0.013467s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19591155 ORDER BY `unit` DESC [ RunTime:0.032865s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19591155 LIMIT 2 [ RunTime:0.037448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19591155 ORDER BY `minOrder` ASC [ RunTime:0.010245s ]
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 '2121%' OR `brand` LIKE '2121%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011228s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32277008 LIMIT 5 [ RunTime:0.046180s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277008 ORDER BY `minOrder` ASC [ RunTime:0.047332s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32277008 ORDER BY `unit` DESC [ RunTime:0.023084s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32277008 LIMIT 2 [ RunTime:0.058802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277008 ORDER BY `minOrder` ASC [ RunTime:0.036197s ]
select * from pdf where partno='212132-0002' and brandshort='molex' limit 1 [ RunTime:0.039163s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.004097s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '212132-0002' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.040750s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32276256 LIMIT 5 [ RunTime:0.019997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276256 ORDER BY `minOrder` ASC [ RunTime:0.025727s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32276256 ORDER BY `unit` DESC [ RunTime:0.030298s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32276256 LIMIT 2 [ RunTime:0.049853s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276256 ORDER BY `minOrder` ASC [ RunTime:0.031205s ]
select * from pdf where partno='212134-0003' and brandshort='molex' limit 1 [ RunTime:0.034728s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '212134-0003' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.057481s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32280856 LIMIT 5 [ RunTime:0.005377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280856 ORDER BY `minOrder` ASC [ RunTime:0.032338s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32280856 ORDER BY `unit` DESC [ RunTime:0.026309s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32280856 LIMIT 2 [ RunTime:0.016123s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280856 ORDER BY `minOrder` ASC [ RunTime:0.008975s ]
select * from pdf where partno='212195-0026' and brandshort='molex' limit 1 [ RunTime:0.011839s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '212195-0026' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.038314s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32280896 LIMIT 5 [ RunTime:0.037057s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280896 ORDER BY `minOrder` ASC [ RunTime:0.013160s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32280896 ORDER BY `unit` DESC [ RunTime:0.001077s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32280896 LIMIT 2 [ RunTime:0.014210s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280896 ORDER BY `minOrder` ASC [ RunTime:0.012772s ]
select * from pdf where partno='212195-0018' and brandshort='molex' limit 1 [ RunTime:0.033450s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '212195-0018' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.019255s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32280892 LIMIT 5 [ RunTime:0.033882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280892 ORDER BY `minOrder` ASC [ RunTime:0.007008s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32280892 ORDER BY `unit` DESC [ RunTime:0.012893s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32280892 LIMIT 2 [ RunTime:0.017877s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280892 ORDER BY `minOrder` ASC [ RunTime:0.002904s ]
select * from pdf where partno='212194-0018' and brandshort='molex' limit 1 [ RunTime:0.005368s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '212194-0018' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.023119s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32280898 LIMIT 5 [ RunTime:0.006272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280898 ORDER BY `minOrder` ASC [ RunTime:0.014712s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32280898 ORDER BY `unit` DESC [ RunTime:0.013462s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32280898 LIMIT 2 [ RunTime:0.023221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280898 ORDER BY `minOrder` ASC [ RunTime:0.000400s ]
select * from pdf where partno='212195-5018' and brandshort='molex' limit 1 [ RunTime:0.002238s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '212195-5018' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.020585s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32280891 LIMIT 5 [ RunTime:0.009063s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280891 ORDER BY `minOrder` ASC [ RunTime:0.005347s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32280891 ORDER BY `unit` DESC [ RunTime:0.020117s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32280891 LIMIT 2 [ RunTime:0.021595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280891 ORDER BY `minOrder` ASC [ RunTime:0.007587s ]
select * from pdf where partno='212194-0006' and brandshort='molex' limit 1 [ RunTime:0.010806s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '212194-0006' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.020236s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32280893 LIMIT 5 [ RunTime:0.010516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280893 ORDER BY `minOrder` ASC [ RunTime:0.000723s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32280893 ORDER BY `unit` DESC [ RunTime:0.019106s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32280893 LIMIT 2 [ RunTime:0.009392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280893 ORDER BY `minOrder` ASC [ RunTime:0.007544s ]
select * from pdf where partno='212195-0006' and brandshort='molex' limit 1 [ RunTime:0.021011s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '212195-0006' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.029900s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32280895 LIMIT 5 [ RunTime:0.000791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280895 ORDER BY `minOrder` ASC [ RunTime:0.000816s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32280895 ORDER BY `unit` DESC [ RunTime:0.009557s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32280895 LIMIT 2 [ RunTime:0.025405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280895 ORDER BY `minOrder` ASC [ RunTime:0.020772s ]
select * from pdf where partno='212195-0012' and brandshort='molex' limit 1 [ RunTime:0.014044s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '212195-0012' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.027455s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32280897 LIMIT 5 [ RunTime:0.015038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280897 ORDER BY `minOrder` ASC [ RunTime:0.036227s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32280897 ORDER BY `unit` DESC [ RunTime:0.007257s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32280897 LIMIT 2 [ RunTime:0.017429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280897 ORDER BY `minOrder` ASC [ RunTime:0.007992s ]
select * from pdf where partno='212195-5010' and brandshort='molex' limit 1 [ RunTime:0.038785s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '212195-5010' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.035047s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32280894 LIMIT 5 [ RunTime:0.000752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280894 ORDER BY `minOrder` ASC [ RunTime:0.041466s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32280894 ORDER BY `unit` DESC [ RunTime:0.020363s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32280894 LIMIT 2 [ RunTime:0.026142s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280894 ORDER BY `minOrder` ASC [ RunTime:0.002342s ]
select * from pdf where partno='212195-0010' and brandshort='molex' limit 1 [ RunTime:0.024695s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '212195-0010' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.041291s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32280890 LIMIT 5 [ RunTime:0.021691s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280890 ORDER BY `minOrder` ASC [ RunTime:0.009473s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32280890 ORDER BY `unit` DESC [ RunTime:0.015336s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32280890 LIMIT 2 [ RunTime:0.006433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280890 ORDER BY `minOrder` ASC [ RunTime:0.024747s ]
select * from pdf where partno='212194-0001' and brandshort='molex' limit 1 [ RunTime:0.002470s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '212194-0001' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.042785s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32280899 LIMIT 5 [ RunTime:0.022313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280899 ORDER BY `minOrder` ASC [ RunTime:0.022485s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32280899 ORDER BY `unit` DESC [ RunTime:0.034271s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32280899 LIMIT 2 [ RunTime:0.010335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280899 ORDER BY `minOrder` ASC [ RunTime:0.008983s ]
select * from pdf where partno='212195-5110' and brandshort='molex' limit 1 [ RunTime:0.010313s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '212195-5110' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.046486s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32281204 LIMIT 5 [ RunTime:0.010160s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281204 ORDER BY `minOrder` ASC [ RunTime:0.035785s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32281204 ORDER BY `unit` DESC [ RunTime:0.045801s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32281204 LIMIT 2 [ RunTime:0.022844s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281204 ORDER BY `minOrder` ASC [ RunTime:0.001256s ]
select * from pdf where partno='212194-0011' and brandshort='molex' limit 1 [ RunTime:0.021575s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '212194-0011' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.044338s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51096719 LIMIT 5 [ RunTime:0.016115s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51096719 ORDER BY `minOrder` ASC [ RunTime:0.020645s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51096719 ORDER BY `unit` DESC [ RunTime:0.019418s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51096719 LIMIT 2 [ RunTime:0.004660s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51096719 ORDER BY `minOrder` ASC [ RunTime:0.009422s ]
select * from pdf where partno='2121' and brandshort='adafruit' limit 1 [ RunTime:0.006969s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2121' OR `brand` LIKE 'adafruit%' ) ) LIMIT 1 [ RunTime:0.003743s ]
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 '2121%' OR `brand` LIKE '2121%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020149s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59934297 LIMIT 5 [ RunTime:0.003359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59934297 ORDER BY `minOrder` ASC [ RunTime:0.005006s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59934297 ORDER BY `unit` DESC [ RunTime:0.004485s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59934297 LIMIT 2 [ RunTime:0.004063s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59934297 ORDER BY `minOrder` ASC [ RunTime:0.007211s ]
select * from pdf where partno='2121320005' and brandshort='Molex' limit 1 [ RunTime:0.004369s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2121320005' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.008854s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59935749 LIMIT 5 [ RunTime:0.008415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59935749 ORDER BY `minOrder` ASC [ RunTime:0.007797s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59935749 ORDER BY `unit` DESC [ RunTime:0.000613s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59935749 LIMIT 2 [ RunTime:0.014026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59935749 ORDER BY `minOrder` ASC [ RunTime:0.000687s ]
select * from pdf where partno='2121320003' and brandshort='Molex' limit 1 [ RunTime:0.003118s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2121320003' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.011469s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59935861 LIMIT 5 [ RunTime:0.000911s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59935861 ORDER BY `minOrder` ASC [ RunTime:0.005995s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59935861 ORDER BY `unit` DESC [ RunTime:0.001990s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59935861 LIMIT 2 [ RunTime:0.001888s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59935861 ORDER BY `minOrder` ASC [ RunTime:0.001589s ]
select * from pdf where partno='2121320004' and brandshort='Molex' limit 1 [ RunTime:0.005221s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2121320004' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.017747s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59434095 LIMIT 5 [ RunTime:0.002261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59434095 ORDER BY `minOrder` ASC [ RunTime:0.001294s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59434095 ORDER BY `unit` DESC [ RunTime:0.009839s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59434095 LIMIT 2 [ RunTime:0.001376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59434095 ORDER BY `minOrder` ASC [ RunTime:0.002211s ]
select * from pdf where partno='2121340004' and brandshort='Molex' limit 1 [ RunTime:0.001417s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2121340004' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.016698s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59935541 LIMIT 5 [ RunTime:0.000762s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59935541 ORDER BY `minOrder` ASC [ RunTime:0.001254s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59935541 ORDER BY `unit` DESC [ RunTime:0.000691s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59935541 LIMIT 2 [ RunTime:0.000513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59935541 ORDER BY `minOrder` ASC [ RunTime:0.000375s ]
select * from pdf where partno='2121320002' and brandshort='Molex' limit 1 [ RunTime:0.002054s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2121320002' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.011254s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59936104 LIMIT 5 [ RunTime:0.005231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59936104 ORDER BY `minOrder` ASC [ RunTime:0.006659s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59936104 ORDER BY `unit` DESC [ RunTime:0.017324s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59936104 LIMIT 2 [ RunTime:0.009254s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59936104 ORDER BY `minOrder` ASC [ RunTime:0.002462s ]
select * from pdf where partno='2121320006' and brandshort='Molex' limit 1 [ RunTime:0.004818s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2121320006' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.021510s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59437736 LIMIT 5 [ RunTime:0.003802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59437736 ORDER BY `minOrder` ASC [ RunTime:0.005339s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59437736 ORDER BY `unit` DESC [ RunTime:0.011951s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59437736 LIMIT 2 [ RunTime:0.017379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59437736 ORDER BY `minOrder` ASC [ RunTime:0.007587s ]
select * from pdf where partno='2121340005' and brandshort='Molex' limit 1 [ RunTime:0.022638s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2121340005' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.033336s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59433967 LIMIT 5 [ RunTime:0.007764s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59433967 ORDER BY `minOrder` ASC [ RunTime:0.001493s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59433967 ORDER BY `unit` DESC [ RunTime:0.005396s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59433967 LIMIT 2 [ RunTime:0.009833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59433967 ORDER BY `minOrder` ASC [ RunTime:0.007714s ]
select * from pdf where partno='2121340003' and brandshort='Molex' limit 1 [ RunTime:0.003289s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2121340003' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.016945s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59434236 LIMIT 5 [ RunTime:0.015229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59434236 ORDER BY `minOrder` ASC [ RunTime:0.019250s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59434236 ORDER BY `unit` DESC [ RunTime:0.019012s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59434236 LIMIT 2 [ RunTime:0.045387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59434236 ORDER BY `minOrder` ASC [ RunTime:0.015661s ]
select * from pdf where partno='2121340006' and brandshort='Molex' limit 1 [ RunTime:0.012676s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2121340006' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.044421s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59433880 LIMIT 5 [ RunTime:0.050928s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59433880 ORDER BY `minOrder` ASC [ RunTime:0.022739s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59433880 ORDER BY `unit` DESC [ RunTime:0.035719s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59433880 LIMIT 2 [ RunTime:0.020653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59433880 ORDER BY `minOrder` ASC [ RunTime:0.012169s ]
select * from pdf where partno='2121340002' and brandshort='Molex' limit 1 [ RunTime:0.001127s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2121340002' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.029518s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63390776 LIMIT 5 [ RunTime:0.049278s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63390776 ORDER BY `minOrder` ASC [ RunTime:0.013881s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63390776 ORDER BY `unit` DESC [ RunTime:0.054933s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63390776 LIMIT 2 [ RunTime:0.048190s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63390776 ORDER BY `minOrder` ASC [ RunTime:0.025175s ]
select * from pdf where partno='2121' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.038053s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2121' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.022376s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60381953 LIMIT 5 [ RunTime:0.025478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60381953 ORDER BY `minOrder` ASC [ RunTime:0.055825s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60381953 ORDER BY `unit` DESC [ RunTime:0.040008s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60381953 LIMIT 2 [ RunTime:0.020607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60381953 ORDER BY `minOrder` ASC [ RunTime:0.013163s ]
select * from pdf where partno='2121940006' and brandshort='Molex' limit 1 [ RunTime:0.024944s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2121940006' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.017847s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60381940 LIMIT 5 [ RunTime:0.008485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60381940 ORDER BY `minOrder` ASC [ RunTime:0.011175s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60381940 ORDER BY `unit` DESC [ RunTime:0.057032s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60381940 LIMIT 2 [ RunTime:0.054926s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60381940 ORDER BY `minOrder` ASC [ RunTime:0.013644s ]
select * from pdf where partno='2121940018' and brandshort='Molex' limit 1 [ RunTime:0.028535s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2121940018' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.048624s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60381756 LIMIT 5 [ RunTime:0.035660s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60381756 ORDER BY `minOrder` ASC [ RunTime:0.033890s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60381756 ORDER BY `unit` DESC [ RunTime:0.044872s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60381756 LIMIT 2 [ RunTime:0.008836s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60381756 ORDER BY `minOrder` ASC [ RunTime:0.001259s ]
select * from pdf where partno='2121955018' and brandshort='Molex' limit 1 [ RunTime:0.024560s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2121955018' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.054166s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60381879 LIMIT 5 [ RunTime:0.059293s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60381879 ORDER BY `minOrder` ASC [ RunTime:0.052015s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60381879 ORDER BY `unit` DESC [ RunTime:0.085859s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60381879 LIMIT 2 [ RunTime:0.027058s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60381879 ORDER BY `minOrder` ASC [ RunTime:0.026807s ]
select * from pdf where partno='2121950006' and brandshort='Molex' limit 1 [ RunTime:0.018436s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2121950006' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.029670s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63393302 LIMIT 5 [ RunTime:0.024096s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63393302 ORDER BY `minOrder` ASC [ RunTime:0.056923s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63393302 ORDER BY `unit` DESC [ RunTime:0.029658s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63393302 LIMIT 2 [ RunTime:0.033709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63393302 ORDER BY `minOrder` ASC [ RunTime:0.005694s ]
select * from pdf where partno='2121-440-AL' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.032814s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2121-440-AL' OR `brand` LIKE 'RAF Electronic Hardware%' ) ) LIMIT 1 [ RunTime:0.037839s ]
SELECT `id` FROM `stock` WHERE `id` <> 63393302 AND `partno` = '2121-440-AL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%raf electronic hardware%' ) [ RunTime:0.012006s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12039836 [ RunTime:0.025294s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40487615 LIMIT 5 [ RunTime:0.035875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40487615 ORDER BY `minOrder` ASC [ RunTime:0.038551s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40487615 ORDER BY `unit` DESC [ RunTime:0.026285s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40487615 LIMIT 2 [ RunTime:0.018250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40487615 ORDER BY `minOrder` ASC [ RunTime:0.000530s ]
select * from pdf where partno='2121-V-RC' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.019931s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2121-V-RC' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.019543s ]
SELECT `id` FROM `stock` WHERE `id` <> 40487615 AND `partno` = '2121-V-RC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.013710s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13416098 [ RunTime:0.028750s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60381757 LIMIT 5 [ RunTime:0.049896s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60381757 ORDER BY `minOrder` ASC [ RunTime:0.012417s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60381757 ORDER BY `unit` DESC [ RunTime:0.000782s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60381757 LIMIT 2 [ RunTime:0.019374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60381757 ORDER BY `minOrder` ASC [ RunTime:0.022838s ]
select * from pdf where partno='2121950018' and brandshort='Molex' limit 1 [ RunTime:0.023020s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2121950018' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.025550s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60382110 LIMIT 5 [ RunTime:0.037357s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60382110 ORDER BY `minOrder` ASC [ RunTime:0.013362s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60382110 ORDER BY `unit` DESC [ RunTime:0.003920s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60382110 LIMIT 2 [ RunTime:0.023179s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60382110 ORDER BY `minOrder` ASC [ RunTime:0.013905s ]
select * from pdf where partno='2121950012' and brandshort='Molex' limit 1 [ RunTime:0.036040s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2121950012' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.019437s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60382104 LIMIT 5 [ RunTime:0.007811s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60382104 ORDER BY `minOrder` ASC [ RunTime:0.005800s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60382104 ORDER BY `unit` DESC [ RunTime:0.015514s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60382104 LIMIT 2 [ RunTime:0.011621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60382104 ORDER BY `minOrder` ASC [ RunTime:0.003829s ]
select * from pdf where partno='2121950016' and brandshort='Molex' limit 1 [ RunTime:0.015786s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2121950016' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.024792s ]
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 '2121%' OR `brand` LIKE '2121%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014148s ]
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 '2121%' OR `brand` LIKE '2121%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004930s ]
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 '2121%' OR `brand` LIKE '2121%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018688s ]
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 '2121%' OR `brand` LIKE '2121%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.040519s ]
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 '2121%' OR `brand` LIKE '2121%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032024s ]
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 '2121%' OR `brand` LIKE '2121%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019596s ]
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 '2121%' OR `brand` LIKE '2121%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018047s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '2121%' OR `brand` LIKE '2121%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.032422s ]