SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003018s ]
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 'a2b%' OR `brand` LIKE 'a2b%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009621s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.016146s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18867167 LIMIT 5 [ RunTime:0.013915s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003785s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18867167 ORDER BY `minOrder` ASC [ RunTime:0.003727s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001135s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18867167 ORDER BY `unit` DESC [ RunTime:0.003882s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.005726s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18867167 LIMIT 2 [ RunTime:0.004347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18867167 ORDER BY `minOrder` ASC [ RunTime:0.001992s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18867297 LIMIT 5 [ RunTime:0.004424s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18867297 ORDER BY `minOrder` ASC [ RunTime:0.009926s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18867297 ORDER BY `unit` DESC [ RunTime:0.001109s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18867297 LIMIT 2 [ RunTime:0.011506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18867297 ORDER BY `minOrder` ASC [ RunTime:0.000225s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16632200 LIMIT 5 [ RunTime:0.024434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16632200 ORDER BY `minOrder` ASC [ RunTime:0.003406s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16632200 ORDER BY `unit` DESC [ RunTime:0.002343s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16632200 LIMIT 2 [ RunTime:0.006003s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16632200 ORDER BY `minOrder` ASC [ RunTime:0.016148s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14717019 LIMIT 5 [ RunTime:0.008394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14717019 ORDER BY `minOrder` ASC [ RunTime:0.010493s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14717019 ORDER BY `unit` DESC [ RunTime:0.011484s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14717019 LIMIT 2 [ RunTime:0.000917s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14717019 ORDER BY `minOrder` ASC [ RunTime:0.005395s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14716981 LIMIT 5 [ RunTime:0.005949s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14716981 ORDER BY `minOrder` ASC [ RunTime:0.013419s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14716981 ORDER BY `unit` DESC [ RunTime:0.026458s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14716981 LIMIT 2 [ RunTime:0.007786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14716981 ORDER BY `minOrder` ASC [ RunTime:0.004176s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14716900 LIMIT 5 [ RunTime:0.009720s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14716900 ORDER BY `minOrder` ASC [ RunTime:0.016743s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14716900 ORDER BY `unit` DESC [ RunTime:0.001526s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14716900 LIMIT 2 [ RunTime:0.000684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14716900 ORDER BY `minOrder` ASC [ RunTime:0.005813s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14716688 LIMIT 5 [ RunTime:0.011222s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14716688 ORDER BY `minOrder` ASC [ RunTime:0.001207s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14716688 ORDER BY `unit` DESC [ RunTime:0.031669s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14716688 LIMIT 2 [ RunTime:0.009568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14716688 ORDER BY `minOrder` ASC [ RunTime:0.025499s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14716687 LIMIT 5 [ RunTime:0.019588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14716687 ORDER BY `minOrder` ASC [ RunTime:0.020925s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14716687 ORDER BY `unit` DESC [ RunTime:0.016122s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14716687 LIMIT 2 [ RunTime:0.000852s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14716687 ORDER BY `minOrder` ASC [ RunTime:0.006309s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14716686 LIMIT 5 [ RunTime:0.024528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14716686 ORDER BY `minOrder` ASC [ RunTime:0.007120s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14716686 ORDER BY `unit` DESC [ RunTime:0.003062s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14716686 LIMIT 2 [ RunTime:0.000641s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14716686 ORDER BY `minOrder` ASC [ RunTime:0.000369s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13826062 LIMIT 5 [ RunTime:0.000809s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13826062 ORDER BY `minOrder` ASC [ RunTime:0.000509s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13826062 ORDER BY `unit` DESC [ RunTime:0.019402s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13826062 LIMIT 2 [ RunTime:0.004306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13826062 ORDER BY `minOrder` ASC [ RunTime:0.002379s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13826021 LIMIT 5 [ RunTime:0.001060s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13826021 ORDER BY `minOrder` ASC [ RunTime:0.002985s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13826021 ORDER BY `unit` DESC [ RunTime:0.005909s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13826021 LIMIT 2 [ RunTime:0.005543s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13826021 ORDER BY `minOrder` ASC [ RunTime:0.000375s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13825906 LIMIT 5 [ RunTime:0.000804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13825906 ORDER BY `minOrder` ASC [ RunTime:0.006719s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13825906 ORDER BY `unit` DESC [ RunTime:0.011345s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13825906 LIMIT 2 [ RunTime:0.002988s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13825906 ORDER BY `minOrder` ASC [ RunTime:0.009453s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13825905 LIMIT 5 [ RunTime:0.003638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13825905 ORDER BY `minOrder` ASC [ RunTime:0.001485s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13825905 ORDER BY `unit` DESC [ RunTime:0.002785s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13825905 LIMIT 2 [ RunTime:0.002322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13825905 ORDER BY `minOrder` ASC [ RunTime:0.004779s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13825777 LIMIT 5 [ RunTime:0.004735s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13825777 ORDER BY `minOrder` ASC [ RunTime:0.007260s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13825777 ORDER BY `unit` DESC [ RunTime:0.000451s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13825777 LIMIT 2 [ RunTime:0.006127s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13825777 ORDER BY `minOrder` ASC [ RunTime:0.004636s ]
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 'a2b%' OR `brand` LIKE 'a2b%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005245s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32232485 LIMIT 5 [ RunTime:0.021836s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32232485 ORDER BY `minOrder` ASC [ RunTime:0.014421s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32232485 ORDER BY `unit` DESC [ RunTime:0.023750s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32232485 LIMIT 2 [ RunTime:0.007502s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32232485 ORDER BY `minOrder` ASC [ RunTime:0.008059s ]
select * from pdf where partno='a2b' and brandshort='vcc' limit 1 [ RunTime:0.005691s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001716s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'a2b' OR `brand` LIKE 'vcc%' ) ) LIMIT 1 [ RunTime:0.005466s ]
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 'a2b%' OR `brand` LIKE 'a2b%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005562s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58126463 LIMIT 5 [ RunTime:0.005001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58126463 ORDER BY `minOrder` ASC [ RunTime:0.002851s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58126463 ORDER BY `unit` DESC [ RunTime:0.000513s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58126463 LIMIT 2 [ RunTime:0.003203s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58126463 ORDER BY `minOrder` ASC [ RunTime:0.004707s ]
select * from pdf where partno='A2B' and brandshort='Visual Communications Company - VCC' limit 1 [ RunTime:0.008991s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A2B' OR `brand` LIKE 'Visual Communications Company - VCC%' ) ) LIMIT 1 [ RunTime:0.002067s ]
SELECT `id` FROM `stock` WHERE `id` <> 58126463 AND `partno` = 'A2B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%visual communications company - vcc%' ) [ RunTime:0.001171s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18867167 [ RunTime:0.000399s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58249131 LIMIT 5 [ RunTime:0.000350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58249131 ORDER BY `minOrder` ASC [ RunTime:0.000786s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58249131 ORDER BY `unit` DESC [ RunTime:0.006672s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58249131 LIMIT 2 [ RunTime:0.009773s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58249131 ORDER BY `minOrder` ASC [ RunTime:0.000935s ]
select * from pdf where partno='A2BY5000-88' and brandshort='Mersen USA Newburyport-MA L.L.C.' limit 1 [ RunTime:0.002533s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A2BY5000-88' OR `brand` LIKE 'Mersen USA Newburyport-MA L.L.C.%' ) ) LIMIT 1 [ RunTime:0.003206s ]
SELECT `id` FROM `stock` WHERE `id` <> 58249131 AND `partno` = 'A2BY5000-88' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mersen usa newburyport-ma l.l.c.%' ) [ RunTime:0.000685s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13826062 [ RunTime:0.000393s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58249068 LIMIT 5 [ RunTime:0.000357s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58249068 ORDER BY `minOrder` ASC [ RunTime:0.002465s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58249068 ORDER BY `unit` DESC [ RunTime:0.002273s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58249068 LIMIT 2 [ RunTime:0.000989s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58249068 ORDER BY `minOrder` ASC [ RunTime:0.000261s ]
select * from pdf where partno='A2BY4000-88' and brandshort='Mersen USA Newburyport-MA L.L.C.' limit 1 [ RunTime:0.001680s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A2BY4000-88' OR `brand` LIKE 'Mersen USA Newburyport-MA L.L.C.%' ) ) LIMIT 1 [ RunTime:0.000491s ]
SELECT `id` FROM `stock` WHERE `id` <> 58249068 AND `partno` = 'A2BY4000-88' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mersen usa newburyport-ma l.l.c.%' ) [ RunTime:0.001156s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16632200 [ RunTime:0.000256s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58248955 LIMIT 5 [ RunTime:0.000328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58248955 ORDER BY `minOrder` ASC [ RunTime:0.000723s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58248955 ORDER BY `unit` DESC [ RunTime:0.002165s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58248955 LIMIT 2 [ RunTime:0.013485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58248955 ORDER BY `minOrder` ASC [ RunTime:0.000292s ]
select * from pdf where partno='A2BY3000-88' and brandshort='Mersen USA Newburyport-MA L.L.C.' limit 1 [ RunTime:0.001020s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A2BY3000-88' OR `brand` LIKE 'Mersen USA Newburyport-MA L.L.C.%' ) ) LIMIT 1 [ RunTime:0.000554s ]
SELECT `id` FROM `stock` WHERE `id` <> 58248955 AND `partno` = 'A2BY3000-88' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mersen usa newburyport-ma l.l.c.%' ) [ RunTime:0.001980s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14716981 [ RunTime:0.000367s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58248866 LIMIT 5 [ RunTime:0.005179s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58248866 ORDER BY `minOrder` ASC [ RunTime:0.000552s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58248866 ORDER BY `unit` DESC [ RunTime:0.005419s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58248866 LIMIT 2 [ RunTime:0.000355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58248866 ORDER BY `minOrder` ASC [ RunTime:0.003354s ]
select * from pdf where partno='A2BY2500-88' and brandshort='Mersen USA Newburyport-MA L.L.C.' limit 1 [ RunTime:0.006708s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A2BY2500-88' OR `brand` LIKE 'Mersen USA Newburyport-MA L.L.C.%' ) ) LIMIT 1 [ RunTime:0.001866s ]
SELECT `id` FROM `stock` WHERE `id` <> 58248866 AND `partno` = 'A2BY2500-88' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mersen usa newburyport-ma l.l.c.%' ) [ RunTime:0.001194s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13826021 [ RunTime:0.002092s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58248605 LIMIT 5 [ RunTime:0.009122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58248605 ORDER BY `minOrder` ASC [ RunTime:0.000288s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58248605 ORDER BY `unit` DESC [ RunTime:0.004987s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58248605 LIMIT 2 [ RunTime:0.004093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58248605 ORDER BY `minOrder` ASC [ RunTime:0.007660s ]
select * from pdf where partno='A2BY2000-88' and brandshort='Mersen USA Newburyport-MA L.L.C.' limit 1 [ RunTime:0.003109s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A2BY2000-88' OR `brand` LIKE 'Mersen USA Newburyport-MA L.L.C.%' ) ) LIMIT 1 [ RunTime:0.015467s ]
SELECT `id` FROM `stock` WHERE `id` <> 58248605 AND `partno` = 'A2BY2000-88' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mersen usa newburyport-ma l.l.c.%' ) [ RunTime:0.003966s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14716900 [ RunTime:0.003104s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58248327 LIMIT 5 [ RunTime:0.005753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58248327 ORDER BY `minOrder` ASC [ RunTime:0.000891s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58248327 ORDER BY `unit` DESC [ RunTime:0.000399s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58248327 LIMIT 2 [ RunTime:0.011117s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58248327 ORDER BY `minOrder` ASC [ RunTime:0.016560s ]
select * from pdf where partno='A2BY1600-88' and brandshort='Mersen USA Newburyport-MA L.L.C.' limit 1 [ RunTime:0.002316s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A2BY1600-88' OR `brand` LIKE 'Mersen USA Newburyport-MA L.L.C.%' ) ) LIMIT 1 [ RunTime:0.004125s ]
SELECT `id` FROM `stock` WHERE `id` <> 58248327 AND `partno` = 'A2BY1600-88' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mersen usa newburyport-ma l.l.c.%' ) [ RunTime:0.025989s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13825906 [ RunTime:0.006928s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58248326 LIMIT 5 [ RunTime:0.012625s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58248326 ORDER BY `minOrder` ASC [ RunTime:0.018994s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58248326 ORDER BY `unit` DESC [ RunTime:0.024973s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58248326 LIMIT 2 [ RunTime:0.005889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58248326 ORDER BY `minOrder` ASC [ RunTime:0.000460s ]
select * from pdf where partno='A2BY1500-88' and brandshort='Mersen USA Newburyport-MA L.L.C.' limit 1 [ RunTime:0.006984s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A2BY1500-88' OR `brand` LIKE 'Mersen USA Newburyport-MA L.L.C.%' ) ) LIMIT 1 [ RunTime:0.010246s ]
SELECT `id` FROM `stock` WHERE `id` <> 58248326 AND `partno` = 'A2BY1500-88' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mersen usa newburyport-ma l.l.c.%' ) [ RunTime:0.008341s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13825905 [ RunTime:0.003815s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58247819 LIMIT 5 [ RunTime:0.002121s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58247819 ORDER BY `minOrder` ASC [ RunTime:0.003965s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58247819 ORDER BY `unit` DESC [ RunTime:0.000619s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58247819 LIMIT 2 [ RunTime:0.000600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58247819 ORDER BY `minOrder` ASC [ RunTime:0.004161s ]
select * from pdf where partno='A2BY1000-88' and brandshort='Mersen USA Newburyport-MA L.L.C.' limit 1 [ RunTime:0.012367s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A2BY1000-88' OR `brand` LIKE 'Mersen USA Newburyport-MA L.L.C.%' ) ) LIMIT 1 [ RunTime:0.012765s ]
SELECT `id` FROM `stock` WHERE `id` <> 58247819 AND `partno` = 'A2BY1000-88' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mersen usa newburyport-ma l.l.c.%' ) [ RunTime:0.008324s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14716688 [ RunTime:0.000697s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58247818 LIMIT 5 [ RunTime:0.014014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58247818 ORDER BY `minOrder` ASC [ RunTime:0.011810s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58247818 ORDER BY `unit` DESC [ RunTime:0.014729s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58247818 LIMIT 2 [ RunTime:0.020217s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58247818 ORDER BY `minOrder` ASC [ RunTime:0.005354s ]
select * from pdf where partno='A2BY1200-88' and brandshort='Mersen USA Newburyport-MA L.L.C.' limit 1 [ RunTime:0.024253s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A2BY1200-88' OR `brand` LIKE 'Mersen USA Newburyport-MA L.L.C.%' ) ) LIMIT 1 [ RunTime:0.004717s ]
SELECT `id` FROM `stock` WHERE `id` <> 58247818 AND `partno` = 'A2BY1200-88' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mersen usa newburyport-ma l.l.c.%' ) [ RunTime:0.003214s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14716687 [ RunTime:0.021532s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58247817 LIMIT 5 [ RunTime:0.032119s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58247817 ORDER BY `minOrder` ASC [ RunTime:0.007351s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58247817 ORDER BY `unit` DESC [ RunTime:0.010437s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58247817 LIMIT 2 [ RunTime:0.004262s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58247817 ORDER BY `minOrder` ASC [ RunTime:0.000499s ]
select * from pdf where partno='A2BY800-88' and brandshort='Mersen USA Newburyport-MA L.L.C.' limit 1 [ RunTime:0.001505s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A2BY800-88' OR `brand` LIKE 'Mersen USA Newburyport-MA L.L.C.%' ) ) LIMIT 1 [ RunTime:0.010243s ]
SELECT `id` FROM `stock` WHERE `id` <> 58247817 AND `partno` = 'A2BY800-88' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mersen usa newburyport-ma l.l.c.%' ) [ RunTime:0.012014s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14716686 [ RunTime:0.013949s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58247390 LIMIT 5 [ RunTime:0.008124s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58247390 ORDER BY `minOrder` ASC [ RunTime:0.008158s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58247390 ORDER BY `unit` DESC [ RunTime:0.000773s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58247390 LIMIT 2 [ RunTime:0.000631s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58247390 ORDER BY `minOrder` ASC [ RunTime:0.005160s ]
select * from pdf where partno='A2BY600-88' and brandshort='Mersen USA Newburyport-MA L.L.C.' limit 1 [ RunTime:0.007879s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A2BY600-88' OR `brand` LIKE 'Mersen USA Newburyport-MA L.L.C.%' ) ) LIMIT 1 [ RunTime:0.003036s ]
SELECT `id` FROM `stock` WHERE `id` <> 58247390 AND `partno` = 'A2BY600-88' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mersen usa newburyport-ma l.l.c.%' ) [ RunTime:0.007122s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13825777 [ RunTime:0.000654s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32698444 LIMIT 5 [ RunTime:0.000627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32698444 ORDER BY `minOrder` ASC [ RunTime:0.009843s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32698444 ORDER BY `unit` DESC [ RunTime:0.004036s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32698444 LIMIT 2 [ RunTime:0.006879s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32698444 ORDER BY `minOrder` ASC [ RunTime:0.000435s ]
select * from pdf where partno='A2BY6000-88' and brandshort='Mersen USA Newburyport-MA L.L.C.' limit 1 [ RunTime:0.002423s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A2BY6000-88' OR `brand` LIKE 'Mersen USA Newburyport-MA L.L.C.%' ) ) LIMIT 1 [ RunTime:0.001380s ]
SELECT `id` FROM `stock` WHERE `id` <> 32698444 AND `partno` = 'A2BY6000-88' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mersen usa newburyport-ma l.l.c.%' ) [ RunTime:0.008795s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14717019 [ RunTime:0.004641s ]
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 'a2b%' OR `brand` LIKE 'a2b%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016004s ]
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 'a2b%' OR `brand` LIKE 'a2b%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009009s ]
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 'a2b%' OR `brand` LIKE 'a2b%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005138s ]
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 'a2b%' OR `brand` LIKE 'a2b%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002721s ]
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 'a2b%' OR `brand` LIKE 'a2b%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005345s ]
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 'a2b%' OR `brand` LIKE 'a2b%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000829s ]
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 'a2b%' OR `brand` LIKE 'a2b%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001453s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'a2b%' OR `brand` LIKE 'a2b%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.000895s ]