SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001405s ]
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 'ISP321-1%' OR `brand` LIKE 'ISP321-1%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010950s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001533s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18690086 LIMIT 5 [ RunTime:0.021108s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18690086 ORDER BY `minOrder` ASC [ RunTime:0.012116s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002982s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18690086 ORDER BY `unit` DESC [ RunTime:0.009147s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.028074s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18690086 LIMIT 2 [ RunTime:0.006878s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18690086 ORDER BY `minOrder` ASC [ RunTime:0.002294s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18690893 LIMIT 5 [ RunTime:0.006349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18690893 ORDER BY `minOrder` ASC [ RunTime:0.005808s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18690893 ORDER BY `unit` DESC [ RunTime:0.009802s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18690893 LIMIT 2 [ RunTime:0.022306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18690893 ORDER BY `minOrder` ASC [ RunTime:0.012075s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15203810 LIMIT 5 [ RunTime:0.003691s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15203810 ORDER BY `minOrder` ASC [ RunTime:0.006823s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15203810 ORDER BY `unit` DESC [ RunTime:0.007614s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15203810 LIMIT 2 [ RunTime:0.000430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15203810 ORDER BY `minOrder` ASC [ RunTime:0.002481s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14170927 LIMIT 5 [ RunTime:0.032184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14170927 ORDER BY `minOrder` ASC [ RunTime:0.016813s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14170927 ORDER BY `unit` DESC [ RunTime:0.034634s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14170927 LIMIT 2 [ RunTime:0.032479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14170927 ORDER BY `minOrder` ASC [ RunTime:0.019914s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18691653 LIMIT 5 [ RunTime:0.000487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18691653 ORDER BY `minOrder` ASC [ RunTime:0.007082s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18691653 ORDER BY `unit` DESC [ RunTime:0.038339s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18691653 LIMIT 2 [ RunTime:0.011731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18691653 ORDER BY `minOrder` ASC [ RunTime:0.011080s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18691646 LIMIT 5 [ RunTime:0.021875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18691646 ORDER BY `minOrder` ASC [ RunTime:0.040641s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18691646 ORDER BY `unit` DESC [ RunTime:0.047939s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18691646 LIMIT 2 [ RunTime:0.052832s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18691646 ORDER BY `minOrder` ASC [ RunTime:0.006351s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18691626 LIMIT 5 [ RunTime:0.055916s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18691626 ORDER BY `minOrder` ASC [ RunTime:0.028210s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18691626 ORDER BY `unit` DESC [ RunTime:0.041374s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18691626 LIMIT 2 [ RunTime:0.040061s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18691626 ORDER BY `minOrder` ASC [ RunTime:0.021945s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16991537 LIMIT 5 [ RunTime:0.026405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16991537 ORDER BY `minOrder` ASC [ RunTime:0.049031s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16991537 ORDER BY `unit` DESC [ RunTime:0.036491s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16991537 LIMIT 2 [ RunTime:0.010064s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16991537 ORDER BY `minOrder` ASC [ RunTime:0.013989s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16991531 LIMIT 5 [ RunTime:0.005615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16991531 ORDER BY `minOrder` ASC [ RunTime:0.040142s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16991531 ORDER BY `unit` DESC [ RunTime:0.013099s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16991531 LIMIT 2 [ RunTime:0.017287s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16991531 ORDER BY `minOrder` ASC [ RunTime:0.009235s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14171047 LIMIT 5 [ RunTime:0.021083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14171047 ORDER BY `minOrder` ASC [ RunTime:0.004399s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14171047 ORDER BY `unit` DESC [ RunTime:0.006089s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14171047 LIMIT 2 [ RunTime:0.022269s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14171047 ORDER BY `minOrder` ASC [ RunTime:0.000778s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14171040 LIMIT 5 [ RunTime:0.003833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14171040 ORDER BY `minOrder` ASC [ RunTime:0.024071s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14171040 ORDER BY `unit` DESC [ RunTime:0.013158s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14171040 LIMIT 2 [ RunTime:0.001908s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14171040 ORDER BY `minOrder` ASC [ RunTime:0.007377s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18691669 LIMIT 5 [ RunTime:0.009443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18691669 ORDER BY `minOrder` ASC [ RunTime:0.004066s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18691669 ORDER BY `unit` DESC [ RunTime:0.014702s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18691669 LIMIT 2 [ RunTime:0.010549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18691669 ORDER BY `minOrder` ASC [ RunTime:0.001436s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18691671 LIMIT 5 [ RunTime:0.000632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18691671 ORDER BY `minOrder` ASC [ RunTime:0.024016s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18691671 ORDER BY `unit` DESC [ RunTime:0.010420s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18691671 LIMIT 2 [ RunTime:0.007127s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18691671 ORDER BY `minOrder` ASC [ RunTime:0.007891s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18692189 LIMIT 5 [ RunTime:0.014501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18692189 ORDER BY `minOrder` ASC [ RunTime:0.010589s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18692189 ORDER BY `unit` DESC [ RunTime:0.010981s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18692189 LIMIT 2 [ RunTime:0.005917s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18692189 ORDER BY `minOrder` ASC [ RunTime:0.008177s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18692112 LIMIT 5 [ RunTime:0.012072s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18692112 ORDER BY `minOrder` ASC [ RunTime:0.013279s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18692112 ORDER BY `unit` DESC [ RunTime:0.010129s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18692112 LIMIT 2 [ RunTime:0.014199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18692112 ORDER BY `minOrder` ASC [ RunTime:0.003944s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18692111 LIMIT 5 [ RunTime:0.000737s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18692111 ORDER BY `minOrder` ASC [ RunTime:0.006641s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18692111 ORDER BY `unit` DESC [ RunTime:0.004792s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18692111 LIMIT 2 [ RunTime:0.002426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18692111 ORDER BY `minOrder` ASC [ RunTime:0.018585s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18691984 LIMIT 5 [ RunTime:0.006515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18691984 ORDER BY `minOrder` ASC [ RunTime:0.002666s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18691984 ORDER BY `unit` DESC [ RunTime:0.002995s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18691984 LIMIT 2 [ RunTime:0.007613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18691984 ORDER BY `minOrder` ASC [ RunTime:0.003033s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18691971 LIMIT 5 [ RunTime:0.005738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18691971 ORDER BY `minOrder` ASC [ RunTime:0.000637s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18691971 ORDER BY `unit` DESC [ RunTime:0.010520s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18691971 LIMIT 2 [ RunTime:0.011823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18691971 ORDER BY `minOrder` ASC [ RunTime:0.000492s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18691967 LIMIT 5 [ RunTime:0.007906s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18691967 ORDER BY `minOrder` ASC [ RunTime:0.003164s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18691967 ORDER BY `unit` DESC [ RunTime:0.000564s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18691967 LIMIT 2 [ RunTime:0.000507s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18691967 ORDER BY `minOrder` ASC [ RunTime:0.000362s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16991687 LIMIT 5 [ RunTime:0.000849s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16991687 ORDER BY `minOrder` ASC [ RunTime:0.000536s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16991687 ORDER BY `unit` DESC [ RunTime:0.013967s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16991687 LIMIT 2 [ RunTime:0.003802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16991687 ORDER BY `minOrder` ASC [ RunTime:0.000420s ]
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 'ISP321-1%' OR `brand` LIKE 'ISP321-1%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009984s ]
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 'ISP321-1%' OR `brand` LIKE 'ISP321-1%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010109s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64262755 LIMIT 5 [ RunTime:0.000315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64262755 ORDER BY `minOrder` ASC [ RunTime:0.000255s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64262755 ORDER BY `unit` DESC [ RunTime:0.000242s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64262755 LIMIT 2 [ RunTime:0.000204s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64262755 ORDER BY `minOrder` ASC [ RunTime:0.000195s ]
select * from pdf where partno='ISP321-1XGBSMT&R' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.000279s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001231s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ISP321-1XGBSMT&R' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.000254s ]
SELECT `id` FROM `stock` WHERE `id` <> 64262755 AND `partno` = 'ISP321-1XGBSMT&R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.000233s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15203810 [ RunTime:0.000201s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64262748 LIMIT 5 [ RunTime:0.000247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64262748 ORDER BY `minOrder` ASC [ RunTime:0.000210s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64262748 ORDER BY `unit` DESC [ RunTime:0.000201s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64262748 LIMIT 2 [ RunTime:0.000192s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64262748 ORDER BY `minOrder` ASC [ RunTime:0.000193s ]
select * from pdf where partno='ISP321-1XSMT&R' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.000231s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ISP321-1XSMT&R' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.003038s ]
SELECT `id` FROM `stock` WHERE `id` <> 64262748 AND `partno` = 'ISP321-1XSMT&R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.000261s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18690893 [ RunTime:0.000212s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64262745 LIMIT 5 [ RunTime:0.002722s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64262745 ORDER BY `minOrder` ASC [ RunTime:0.002726s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64262745 ORDER BY `unit` DESC [ RunTime:0.007265s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64262745 LIMIT 2 [ RunTime:0.015493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64262745 ORDER BY `minOrder` ASC [ RunTime:0.019697s ]
select * from pdf where partno='ISP321-1XBLSMT&R' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.002241s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ISP321-1XBLSMT&R' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.002057s ]
SELECT `id` FROM `stock` WHERE `id` <> 64262745 AND `partno` = 'ISP321-1XBLSMT&R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.000885s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14170927 [ RunTime:0.000672s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64262731 LIMIT 5 [ RunTime:0.002519s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64262731 ORDER BY `minOrder` ASC [ RunTime:0.002737s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64262731 ORDER BY `unit` DESC [ RunTime:0.006070s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64262731 LIMIT 2 [ RunTime:0.006686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64262731 ORDER BY `minOrder` ASC [ RunTime:0.005818s ]
select * from pdf where partno='ISP321-1BLSMT&R,' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.003718s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ISP321-1BLSMT&R,' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.004018s ]
SELECT `id` FROM `stock` WHERE `id` <> 64262731 AND `partno` = 'ISP321-1BLSMT&R,' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.011516s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18690086 [ RunTime:0.029607s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64267832 LIMIT 5 [ RunTime:0.019246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64267832 ORDER BY `minOrder` ASC [ RunTime:0.018494s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64267832 ORDER BY `unit` DESC [ RunTime:0.004190s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64267832 LIMIT 2 [ RunTime:0.005219s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64267832 ORDER BY `minOrder` ASC [ RunTime:0.002191s ]
select * from pdf where partno='ISP321-1XGB' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.005322s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ISP321-1XGB' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.002177s ]
SELECT `id` FROM `stock` WHERE `id` <> 64267832 AND `partno` = 'ISP321-1XGB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.002068s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18691626 [ RunTime:0.010559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64263152 LIMIT 5 [ RunTime:0.002743s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64263152 ORDER BY `minOrder` ASC [ RunTime:0.008587s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64263152 ORDER BY `unit` DESC [ RunTime:0.000610s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64263152 LIMIT 2 [ RunTime:0.006426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64263152 ORDER BY `minOrder` ASC [ RunTime:0.002288s ]
select * from pdf where partno='ISP321-1XBLSM' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.019625s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ISP321-1XBLSM' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.004430s ]
SELECT `id` FROM `stock` WHERE `id` <> 64263152 AND `partno` = 'ISP321-1XBLSM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.011454s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14171047 [ RunTime:0.002271s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64263144 LIMIT 5 [ RunTime:0.002876s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64263144 ORDER BY `minOrder` ASC [ RunTime:0.002207s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64263144 ORDER BY `unit` DESC [ RunTime:0.006511s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64263144 LIMIT 2 [ RunTime:0.000305s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64263144 ORDER BY `minOrder` ASC [ RunTime:0.003454s ]
select * from pdf where partno='ISP321-1XGBSM' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.003885s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ISP321-1XGBSM' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.005500s ]
SELECT `id` FROM `stock` WHERE `id` <> 64263144 AND `partno` = 'ISP321-1XGBSM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.001265s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18691653 [ RunTime:0.000329s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64263131 LIMIT 5 [ RunTime:0.004629s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64263131 ORDER BY `minOrder` ASC [ RunTime:0.000958s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64263131 ORDER BY `unit` DESC [ RunTime:0.015693s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64263131 LIMIT 2 [ RunTime:0.012633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64263131 ORDER BY `minOrder` ASC [ RunTime:0.000263s ]
select * from pdf where partno='ISP321-1XBLG' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.002382s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ISP321-1XBLG' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.010615s ]
SELECT `id` FROM `stock` WHERE `id` <> 64263131 AND `partno` = 'ISP321-1XBLG' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.000666s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18691646 [ RunTime:0.000387s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64263129 LIMIT 5 [ RunTime:0.000413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64263129 ORDER BY `minOrder` ASC [ RunTime:0.017371s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64263129 ORDER BY `unit` DESC [ RunTime:0.021419s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64263129 LIMIT 2 [ RunTime:0.005490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64263129 ORDER BY `minOrder` ASC [ RunTime:0.001967s ]
select * from pdf where partno='ISP321-1XG' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.001688s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ISP321-1XG' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.001280s ]
SELECT `id` FROM `stock` WHERE `id` <> 64263129 AND `partno` = 'ISP321-1XG' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.000549s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16991537 [ RunTime:0.013053s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64263162 LIMIT 5 [ RunTime:0.006505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64263162 ORDER BY `minOrder` ASC [ RunTime:0.001099s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64263162 ORDER BY `unit` DESC [ RunTime:0.012814s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64263162 LIMIT 2 [ RunTime:0.005410s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64263162 ORDER BY `minOrder` ASC [ RunTime:0.009809s ]
select * from pdf where partno='ISP321-1XGBG' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.004975s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ISP321-1XGBG' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.010638s ]
SELECT `id` FROM `stock` WHERE `id` <> 64263162 AND `partno` = 'ISP321-1XGBG' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.008866s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18691669 [ RunTime:0.006644s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64267839 LIMIT 5 [ RunTime:0.003264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64267839 ORDER BY `minOrder` ASC [ RunTime:0.006250s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64267839 ORDER BY `unit` DESC [ RunTime:0.014232s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64267839 LIMIT 2 [ RunTime:0.034003s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64267839 ORDER BY `minOrder` ASC [ RunTime:0.006476s ]
select * from pdf where partno='ISP321-1XBL' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.020180s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ISP321-1XBL' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.019910s ]
SELECT `id` FROM `stock` WHERE `id` <> 64267839 AND `partno` = 'ISP321-1XBL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.036195s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14171040 [ RunTime:0.011010s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64263772 LIMIT 5 [ RunTime:0.008336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64263772 ORDER BY `minOrder` ASC [ RunTime:0.035548s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64263772 ORDER BY `unit` DESC [ RunTime:0.035232s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64263772 LIMIT 2 [ RunTime:0.013636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64263772 ORDER BY `minOrder` ASC [ RunTime:0.009887s ]
select * from pdf where partno='ISP321-1X' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.009765s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ISP321-1X' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.012015s ]
SELECT `id` FROM `stock` WHERE `id` <> 64263772 AND `partno` = 'ISP321-1X' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.014616s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16991531 [ RunTime:0.004781s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64263165 LIMIT 5 [ RunTime:0.009489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64263165 ORDER BY `minOrder` ASC [ RunTime:0.015881s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64263165 ORDER BY `unit` DESC [ RunTime:0.022272s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64263165 LIMIT 2 [ RunTime:0.019789s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64263165 ORDER BY `minOrder` ASC [ RunTime:0.000612s ]
select * from pdf where partno='ISP321-1XSM' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.005059s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ISP321-1XSM' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.003503s ]
SELECT `id` FROM `stock` WHERE `id` <> 64263165 AND `partno` = 'ISP321-1XSM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.012243s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18691671 [ RunTime:0.004491s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64264639 LIMIT 5 [ RunTime:0.020212s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64264639 ORDER BY `minOrder` ASC [ RunTime:0.009656s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64264639 ORDER BY `unit` DESC [ RunTime:0.012643s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64264639 LIMIT 2 [ RunTime:0.039903s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64264639 ORDER BY `minOrder` ASC [ RunTime:0.004896s ]
select * from pdf where partno='ISP321-1SMT&R' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.012624s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ISP321-1SMT&R' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.024879s ]
SELECT `id` FROM `stock` WHERE `id` <> 64264639 AND `partno` = 'ISP321-1SMT&R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.009787s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18692189 [ RunTime:0.001452s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64264616 LIMIT 5 [ RunTime:0.018831s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64264616 ORDER BY `minOrder` ASC [ RunTime:0.004190s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64264616 ORDER BY `unit` DESC [ RunTime:0.010030s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64264616 LIMIT 2 [ RunTime:0.004717s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64264616 ORDER BY `minOrder` ASC [ RunTime:0.001623s ]
select * from pdf where partno='ISP321-1GBSMT&R' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.006752s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ISP321-1GBSMT&R' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.009760s ]
SELECT `id` FROM `stock` WHERE `id` <> 64264616 AND `partno` = 'ISP321-1GBSMT&R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.010371s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16991687 [ RunTime:0.027018s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64264540 LIMIT 5 [ RunTime:0.012717s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64264540 ORDER BY `minOrder` ASC [ RunTime:0.031893s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64264540 ORDER BY `unit` DESC [ RunTime:0.015591s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64264540 LIMIT 2 [ RunTime:0.018923s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64264540 ORDER BY `minOrder` ASC [ RunTime:0.004768s ]
select * from pdf where partno='ISP321-1GBG' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.014599s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ISP321-1GBG' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.001031s ]
SELECT `id` FROM `stock` WHERE `id` <> 64264540 AND `partno` = 'ISP321-1GBG' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.000859s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16991674 [ RunTime:0.004145s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64264537 LIMIT 5 [ RunTime:0.005633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64264537 ORDER BY `minOrder` ASC [ RunTime:0.004675s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64264537 ORDER BY `unit` DESC [ RunTime:0.004634s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64264537 LIMIT 2 [ RunTime:0.016962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64264537 ORDER BY `minOrder` ASC [ RunTime:0.009135s ]
select * from pdf where partno='ISP321-1SM' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.001394s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ISP321-1SM' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.001606s ]
SELECT `id` FROM `stock` WHERE `id` <> 64264537 AND `partno` = 'ISP321-1SM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.000869s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14171135 [ RunTime:0.001127s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64264527 LIMIT 5 [ RunTime:0.007068s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64264527 ORDER BY `minOrder` ASC [ RunTime:0.039025s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64264527 ORDER BY `unit` DESC [ RunTime:0.013349s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64264527 LIMIT 2 [ RunTime:0.003418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64264527 ORDER BY `minOrder` ASC [ RunTime:0.004484s ]
select * from pdf where partno='ISP321-1BLG' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.001006s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ISP321-1BLG' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.006360s ]
SELECT `id` FROM `stock` WHERE `id` <> 64264527 AND `partno` = 'ISP321-1BLG' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.009565s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15204125 [ RunTime:0.004234s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64264510 LIMIT 5 [ RunTime:0.003531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64264510 ORDER BY `minOrder` ASC [ RunTime:0.000700s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64264510 ORDER BY `unit` DESC [ RunTime:0.004326s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64264510 LIMIT 2 [ RunTime:0.007402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64264510 ORDER BY `minOrder` ASC [ RunTime:0.006643s ]
select * from pdf where partno='ISP321-1G' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.003806s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ISP321-1G' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.011637s ]
SELECT `id` FROM `stock` WHERE `id` <> 64264510 AND `partno` = 'ISP321-1G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.000878s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18692112 [ RunTime:0.003223s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64264509 LIMIT 5 [ RunTime:0.003322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64264509 ORDER BY `minOrder` ASC [ RunTime:0.015004s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64264509 ORDER BY `unit` DESC [ RunTime:0.010762s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64264509 LIMIT 2 [ RunTime:0.004328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64264509 ORDER BY `minOrder` ASC [ RunTime:0.000852s ]
select * from pdf where partno='ISP321-1BLSM' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.005257s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ISP321-1BLSM' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.016380s ]
SELECT `id` FROM `stock` WHERE `id` <> 64264509 AND `partno` = 'ISP321-1BLSM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.008872s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18692111 [ RunTime:0.010912s ]
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 'ISP321-1%' OR `brand` LIKE 'ISP321-1%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005900s ]
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 'ISP321-1%' OR `brand` LIKE 'ISP321-1%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011721s ]
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 'ISP321-1%' OR `brand` LIKE 'ISP321-1%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003584s ]
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 'ISP321-1%' OR `brand` LIKE 'ISP321-1%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006352s ]
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 'ISP321-1%' OR `brand` LIKE 'ISP321-1%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002079s ]
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 'ISP321-1%' OR `brand` LIKE 'ISP321-1%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011853s ]
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 'ISP321-1%' OR `brand` LIKE 'ISP321-1%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001528s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'ISP321-1%' OR `brand` LIKE 'ISP321-1%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001818s ]