SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001337s ]
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 '130118%' OR `brand` LIKE '130118%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010647s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001205s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15234184 LIMIT 5 [ RunTime:0.003252s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15234184 ORDER BY `minOrder` ASC [ RunTime:0.001370s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001207s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15234184 ORDER BY `unit` DESC [ RunTime:0.007200s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002599s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15234184 LIMIT 2 [ RunTime:0.010898s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15234184 ORDER BY `minOrder` ASC [ RunTime:0.008038s ]
select * from pdf where partno='1301180007' and brandshort='Molex' limit 1 [ RunTime:0.009901s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18828400 LIMIT 5 [ RunTime:0.006275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18828400 ORDER BY `minOrder` ASC [ RunTime:0.001147s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18828400 ORDER BY `unit` DESC [ RunTime:0.009045s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18828400 LIMIT 2 [ RunTime:0.021806s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18828400 ORDER BY `minOrder` ASC [ RunTime:0.035257s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18828397 LIMIT 5 [ RunTime:0.015468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18828397 ORDER BY `minOrder` ASC [ RunTime:0.009097s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18828397 ORDER BY `unit` DESC [ RunTime:0.010198s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18828397 LIMIT 2 [ RunTime:0.000682s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18828397 ORDER BY `minOrder` ASC [ RunTime:0.000451s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18828393 LIMIT 5 [ RunTime:0.004816s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18828393 ORDER BY `minOrder` ASC [ RunTime:0.019869s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18828393 ORDER BY `unit` DESC [ RunTime:0.015147s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18828393 LIMIT 2 [ RunTime:0.008624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18828393 ORDER BY `minOrder` ASC [ RunTime:0.004263s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18828339 LIMIT 5 [ RunTime:0.016807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18828339 ORDER BY `minOrder` ASC [ RunTime:0.015130s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18828339 ORDER BY `unit` DESC [ RunTime:0.020187s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18828339 LIMIT 2 [ RunTime:0.005873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18828339 ORDER BY `minOrder` ASC [ RunTime:0.009494s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18828314 LIMIT 5 [ RunTime:0.003726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18828314 ORDER BY `minOrder` ASC [ RunTime:0.000738s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18828314 ORDER BY `unit` DESC [ RunTime:0.017535s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18828314 LIMIT 2 [ RunTime:0.000666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18828314 ORDER BY `minOrder` ASC [ RunTime:0.010196s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18828292 LIMIT 5 [ RunTime:0.008758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18828292 ORDER BY `minOrder` ASC [ RunTime:0.000745s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18828292 ORDER BY `unit` DESC [ RunTime:0.010375s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18828292 LIMIT 2 [ RunTime:0.003401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18828292 ORDER BY `minOrder` ASC [ RunTime:0.006091s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18828277 LIMIT 5 [ RunTime:0.000795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18828277 ORDER BY `minOrder` ASC [ RunTime:0.000880s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18828277 ORDER BY `unit` DESC [ RunTime:0.006252s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18828277 LIMIT 2 [ RunTime:0.001014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18828277 ORDER BY `minOrder` ASC [ RunTime:0.008946s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18828262 LIMIT 5 [ RunTime:0.005740s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18828262 ORDER BY `minOrder` ASC [ RunTime:0.000614s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18828262 ORDER BY `unit` DESC [ RunTime:0.012982s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18828262 LIMIT 2 [ RunTime:0.003314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18828262 ORDER BY `minOrder` ASC [ RunTime:0.000354s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18828200 LIMIT 5 [ RunTime:0.000728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18828200 ORDER BY `minOrder` ASC [ RunTime:0.000436s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18828200 ORDER BY `unit` DESC [ RunTime:0.003905s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18828200 LIMIT 2 [ RunTime:0.000401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18828200 ORDER BY `minOrder` ASC [ RunTime:0.000261s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18828176 LIMIT 5 [ RunTime:0.000440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18828176 ORDER BY `minOrder` ASC [ RunTime:0.000430s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18828176 ORDER BY `unit` DESC [ RunTime:0.010018s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18828176 LIMIT 2 [ RunTime:0.000764s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18828176 ORDER BY `minOrder` ASC [ RunTime:0.000287s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18828156 LIMIT 5 [ RunTime:0.000881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18828156 ORDER BY `minOrder` ASC [ RunTime:0.000532s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18828156 ORDER BY `unit` DESC [ RunTime:0.003561s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18828156 LIMIT 2 [ RunTime:0.000303s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18828156 ORDER BY `minOrder` ASC [ RunTime:0.000202s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18828087 LIMIT 5 [ RunTime:0.006837s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18828087 ORDER BY `minOrder` ASC [ RunTime:0.000678s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18828087 ORDER BY `unit` DESC [ RunTime:0.005254s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18828087 LIMIT 2 [ RunTime:0.000640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18828087 ORDER BY `minOrder` ASC [ RunTime:0.004778s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18827620 LIMIT 5 [ RunTime:0.000806s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18827620 ORDER BY `minOrder` ASC [ RunTime:0.000422s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18827620 ORDER BY `unit` DESC [ RunTime:0.005324s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18827620 LIMIT 2 [ RunTime:0.000367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18827620 ORDER BY `minOrder` ASC [ RunTime:0.000249s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18827619 LIMIT 5 [ RunTime:0.000358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18827619 ORDER BY `minOrder` ASC [ RunTime:0.004659s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18827619 ORDER BY `unit` DESC [ RunTime:0.005107s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18827619 LIMIT 2 [ RunTime:0.000373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18827619 ORDER BY `minOrder` ASC [ RunTime:0.000308s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18827612 LIMIT 5 [ RunTime:0.000367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18827612 ORDER BY `minOrder` ASC [ RunTime:0.000447s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18827612 ORDER BY `unit` DESC [ RunTime:0.005160s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18827612 LIMIT 2 [ RunTime:0.000355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18827612 ORDER BY `minOrder` ASC [ RunTime:0.004731s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18827388 LIMIT 5 [ RunTime:0.000941s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18827388 ORDER BY `minOrder` ASC [ RunTime:0.000385s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18827388 ORDER BY `unit` DESC [ RunTime:0.005310s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18827388 LIMIT 2 [ RunTime:0.001111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18827388 ORDER BY `minOrder` ASC [ RunTime:0.000248s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18827366 LIMIT 5 [ RunTime:0.000373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18827366 ORDER BY `minOrder` ASC [ RunTime:0.004029s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18827366 ORDER BY `unit` DESC [ RunTime:0.005373s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18827366 LIMIT 2 [ RunTime:0.000387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18827366 ORDER BY `minOrder` ASC [ RunTime:0.000257s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18827092 LIMIT 5 [ RunTime:0.000644s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18827092 ORDER BY `minOrder` ASC [ RunTime:0.000397s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18827092 ORDER BY `unit` DESC [ RunTime:0.009431s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18827092 LIMIT 2 [ RunTime:0.000609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18827092 ORDER BY `minOrder` ASC [ RunTime:0.000377s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18827087 LIMIT 5 [ RunTime:0.000596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18827087 ORDER BY `minOrder` ASC [ RunTime:0.000632s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18827087 ORDER BY `unit` DESC [ RunTime:0.007642s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18827087 LIMIT 2 [ RunTime:0.002557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18827087 ORDER BY `minOrder` ASC [ RunTime:0.000376s ]
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 '130118%' OR `brand` LIKE '130118%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001268s ]
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 '130118%' OR `brand` LIKE '130118%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004712s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53827738 LIMIT 5 [ RunTime:0.000393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53827738 ORDER BY `minOrder` ASC [ RunTime:0.000391s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53827738 ORDER BY `unit` DESC [ RunTime:0.002246s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53827738 LIMIT 2 [ RunTime:0.010951s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53827738 ORDER BY `minOrder` ASC [ RunTime:0.000275s ]
select * from pdf where partno='130118' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000403s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001533s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '130118' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000337s ]
SELECT `id` FROM `stock` WHERE `id` <> 53827738 AND `partno` = '130118' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000872s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50291709 LIMIT 5 [ RunTime:0.003633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50291709 ORDER BY `minOrder` ASC [ RunTime:0.001040s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50291709 ORDER BY `unit` DESC [ RunTime:0.004224s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50291709 LIMIT 2 [ RunTime:0.000832s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50291709 ORDER BY `minOrder` ASC [ RunTime:0.000259s ]
select * from pdf where partno='1301180048' and brandshort='Molex' limit 1 [ RunTime:0.001289s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1301180048' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.011719s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50291699 LIMIT 5 [ RunTime:0.000736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50291699 ORDER BY `minOrder` ASC [ RunTime:0.000606s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50291699 ORDER BY `unit` DESC [ RunTime:0.003085s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50291699 LIMIT 2 [ RunTime:0.002609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50291699 ORDER BY `minOrder` ASC [ RunTime:0.000415s ]
select * from pdf where partno='1301180046' and brandshort='Molex' limit 1 [ RunTime:0.001095s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1301180046' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.009076s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50291690 LIMIT 5 [ RunTime:0.000521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50291690 ORDER BY `minOrder` ASC [ RunTime:0.000479s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50291690 ORDER BY `unit` DESC [ RunTime:0.003122s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50291690 LIMIT 2 [ RunTime:0.000355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50291690 ORDER BY `minOrder` ASC [ RunTime:0.000888s ]
select * from pdf where partno='1301180044' and brandshort='Molex' limit 1 [ RunTime:0.001067s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1301180044' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.006680s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50290979 LIMIT 5 [ RunTime:0.001026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50290979 ORDER BY `minOrder` ASC [ RunTime:0.001098s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50290979 ORDER BY `unit` DESC [ RunTime:0.004933s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50290979 LIMIT 2 [ RunTime:0.001818s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50290979 ORDER BY `minOrder` ASC [ RunTime:0.000755s ]
select * from pdf where partno='1301180047' and brandshort='Molex' limit 1 [ RunTime:0.001418s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1301180047' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.006984s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50290977 LIMIT 5 [ RunTime:0.000466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50290977 ORDER BY `minOrder` ASC [ RunTime:0.000481s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50290977 ORDER BY `unit` DESC [ RunTime:0.002992s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50290977 LIMIT 2 [ RunTime:0.002752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50290977 ORDER BY `minOrder` ASC [ RunTime:0.000279s ]
select * from pdf where partno='1301180045' and brandshort='Molex' limit 1 [ RunTime:0.001097s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1301180045' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.006753s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50290949 LIMIT 5 [ RunTime:0.000446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50290949 ORDER BY `minOrder` ASC [ RunTime:0.000495s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50290949 ORDER BY `unit` DESC [ RunTime:0.004914s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50290949 LIMIT 2 [ RunTime:0.000448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50290949 ORDER BY `minOrder` ASC [ RunTime:0.000341s ]
select * from pdf where partno='1301180043' and brandshort='Molex' limit 1 [ RunTime:0.000909s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1301180043' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.006354s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50290634 LIMIT 5 [ RunTime:0.000388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50290634 ORDER BY `minOrder` ASC [ RunTime:0.003051s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50290634 ORDER BY `unit` DESC [ RunTime:0.002911s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50290634 LIMIT 2 [ RunTime:0.000375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50290634 ORDER BY `minOrder` ASC [ RunTime:0.000281s ]
select * from pdf where partno='1301180027' and brandshort='Molex' limit 1 [ RunTime:0.001110s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1301180027' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.006412s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50290564 LIMIT 5 [ RunTime:0.002653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50290564 ORDER BY `minOrder` ASC [ RunTime:0.000686s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50290564 ORDER BY `unit` DESC [ RunTime:0.002811s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50290564 LIMIT 2 [ RunTime:0.001084s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50290564 ORDER BY `minOrder` ASC [ RunTime:0.000477s ]
select * from pdf where partno='1301180026' and brandshort='Molex' limit 1 [ RunTime:0.001626s ]
select foldpath,foldpath2,filename from pdf_file where id=2110678 limit 1 [ RunTime:0.006154s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1301180026' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.007026s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50290553 LIMIT 5 [ RunTime:0.000565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50290553 ORDER BY `minOrder` ASC [ RunTime:0.000654s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50290553 ORDER BY `unit` DESC [ RunTime:0.003861s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50290553 LIMIT 2 [ RunTime:0.000393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50290553 ORDER BY `minOrder` ASC [ RunTime:0.000338s ]
select * from pdf where partno='1301180042' and brandshort='Molex' limit 1 [ RunTime:0.000942s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1301180042' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.009138s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50290546 LIMIT 5 [ RunTime:0.000482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50290546 ORDER BY `minOrder` ASC [ RunTime:0.000437s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50290546 ORDER BY `unit` DESC [ RunTime:0.003135s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50290546 LIMIT 2 [ RunTime:0.000422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50290546 ORDER BY `minOrder` ASC [ RunTime:0.000330s ]
select * from pdf where partno='1301180040' and brandshort='Molex' limit 1 [ RunTime:0.001049s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1301180040' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.009032s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50290523 LIMIT 5 [ RunTime:0.000340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50290523 ORDER BY `minOrder` ASC [ RunTime:0.000414s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50290523 ORDER BY `unit` DESC [ RunTime:0.002904s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50290523 LIMIT 2 [ RunTime:0.000264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50290523 ORDER BY `minOrder` ASC [ RunTime:0.000265s ]
select * from pdf where partno='1301180025' and brandshort='Molex' limit 1 [ RunTime:0.000501s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1301180025' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.000332s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50290522 LIMIT 5 [ RunTime:0.000441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50290522 ORDER BY `minOrder` ASC [ RunTime:0.000385s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50290522 ORDER BY `unit` DESC [ RunTime:0.002191s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50290522 LIMIT 2 [ RunTime:0.002977s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50290522 ORDER BY `minOrder` ASC [ RunTime:0.000283s ]
select * from pdf where partno='1301180028' and brandshort='Molex' limit 1 [ RunTime:0.000786s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1301180028' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.006167s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50290467 LIMIT 5 [ RunTime:0.000502s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50290467 ORDER BY `minOrder` ASC [ RunTime:0.003556s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50290467 ORDER BY `unit` DESC [ RunTime:0.003197s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50290467 LIMIT 2 [ RunTime:0.000364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50290467 ORDER BY `minOrder` ASC [ RunTime:0.000280s ]
select * from pdf where partno='1301180023' and brandshort='Molex' limit 1 [ RunTime:0.000696s ]
select foldpath,foldpath2,filename from pdf_file where id=2110678 limit 1 [ RunTime:0.000735s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1301180023' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.005574s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50290435 LIMIT 5 [ RunTime:0.000530s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50290435 ORDER BY `minOrder` ASC [ RunTime:0.000741s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50290435 ORDER BY `unit` DESC [ RunTime:0.008850s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50290435 LIMIT 2 [ RunTime:0.000610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50290435 ORDER BY `minOrder` ASC [ RunTime:0.000405s ]
select * from pdf where partno='1301180022' and brandshort='Molex' limit 1 [ RunTime:0.000677s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1301180022' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.016865s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50290350 LIMIT 5 [ RunTime:0.000902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50290350 ORDER BY `minOrder` ASC [ RunTime:0.000954s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50290350 ORDER BY `unit` DESC [ RunTime:0.003868s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50290350 LIMIT 2 [ RunTime:0.000634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50290350 ORDER BY `minOrder` ASC [ RunTime:0.000429s ]
select * from pdf where partno='1301180041' and brandshort='Molex' limit 1 [ RunTime:0.000757s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1301180041' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.018936s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50290348 LIMIT 5 [ RunTime:0.001120s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50290348 ORDER BY `minOrder` ASC [ RunTime:0.000894s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50290348 ORDER BY `unit` DESC [ RunTime:0.003997s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50290348 LIMIT 2 [ RunTime:0.000623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50290348 ORDER BY `minOrder` ASC [ RunTime:0.000437s ]
select * from pdf where partno='1301180009' and brandshort='Molex' limit 1 [ RunTime:0.001307s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1301180009' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.007479s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50290344 LIMIT 5 [ RunTime:0.008113s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50290344 ORDER BY `minOrder` ASC [ RunTime:0.001571s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50290344 ORDER BY `unit` DESC [ RunTime:0.007184s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50290344 LIMIT 2 [ RunTime:0.000562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50290344 ORDER BY `minOrder` ASC [ RunTime:0.000291s ]
select * from pdf where partno='1301180039' and brandshort='Molex' limit 1 [ RunTime:0.000902s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1301180039' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.006440s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50290310 LIMIT 5 [ RunTime:0.000502s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50290310 ORDER BY `minOrder` ASC [ RunTime:0.000403s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50290310 ORDER BY `unit` DESC [ RunTime:0.011155s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50290310 LIMIT 2 [ RunTime:0.000402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50290310 ORDER BY `minOrder` ASC [ RunTime:0.000716s ]
select * from pdf where partno='1301180038' and brandshort='Molex' limit 1 [ RunTime:0.001226s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1301180038' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.007711s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50290258 LIMIT 5 [ RunTime:0.000574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50290258 ORDER BY `minOrder` ASC [ RunTime:0.003365s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50290258 ORDER BY `unit` DESC [ RunTime:0.007698s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50290258 LIMIT 2 [ RunTime:0.002069s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50290258 ORDER BY `minOrder` ASC [ RunTime:0.008219s ]
select * from pdf where partno='1301180031' and brandshort='Molex' limit 1 [ RunTime:0.004364s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1301180031' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.016658s ]
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 '130118%' OR `brand` LIKE '130118%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003959s ]
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 '130118%' OR `brand` LIKE '130118%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005533s ]
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 '130118%' OR `brand` LIKE '130118%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006165s ]
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 '130118%' OR `brand` LIKE '130118%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004364s ]
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 '130118%' OR `brand` LIKE '130118%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004295s ]
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 '130118%' OR `brand` LIKE '130118%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006098s ]
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 '130118%' OR `brand` LIKE '130118%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006995s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '130118%' OR `brand` LIKE '130118%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.004697s ]