SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001283s ]
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 'MC8022D%' OR `brand` LIKE 'MC8022D%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032534s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003911s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19579761 LIMIT 5 [ RunTime:0.038555s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.006013s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19579761 ORDER BY `minOrder` ASC [ RunTime:0.037659s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.007548s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19579761 ORDER BY `unit` DESC [ RunTime:0.012205s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.010184s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19579761 LIMIT 2 [ RunTime:0.009395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19579761 ORDER BY `minOrder` ASC [ RunTime:0.006967s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19579454 LIMIT 5 [ RunTime:0.017593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19579454 ORDER BY `minOrder` ASC [ RunTime:0.036497s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19579454 ORDER BY `unit` DESC [ RunTime:0.042106s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19579454 LIMIT 2 [ RunTime:0.031297s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19579454 ORDER BY `minOrder` ASC [ RunTime:0.006831s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19579443 LIMIT 5 [ RunTime:0.005317s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19579443 ORDER BY `minOrder` ASC [ RunTime:0.006109s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19579443 ORDER BY `unit` DESC [ RunTime:0.009427s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19579443 LIMIT 2 [ RunTime:0.006022s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19579443 ORDER BY `minOrder` ASC [ RunTime:0.012639s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19579438 LIMIT 5 [ RunTime:0.019718s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19579438 ORDER BY `minOrder` ASC [ RunTime:0.021551s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19579438 ORDER BY `unit` DESC [ RunTime:0.016249s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19579438 LIMIT 2 [ RunTime:0.006895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19579438 ORDER BY `minOrder` ASC [ RunTime:0.000485s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19579419 LIMIT 5 [ RunTime:0.002963s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19579419 ORDER BY `minOrder` ASC [ RunTime:0.006824s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19579419 ORDER BY `unit` DESC [ RunTime:0.000710s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19579419 LIMIT 2 [ RunTime:0.013663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19579419 ORDER BY `minOrder` ASC [ RunTime:0.006358s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19579416 LIMIT 5 [ RunTime:0.013756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19579416 ORDER BY `minOrder` ASC [ RunTime:0.002110s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19579416 ORDER BY `unit` DESC [ RunTime:0.026824s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19579416 LIMIT 2 [ RunTime:0.008597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19579416 ORDER BY `minOrder` ASC [ RunTime:0.012988s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19578801 LIMIT 5 [ RunTime:0.008233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19578801 ORDER BY `minOrder` ASC [ RunTime:0.002334s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19578801 ORDER BY `unit` DESC [ RunTime:0.022208s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19578801 LIMIT 2 [ RunTime:0.003980s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19578801 ORDER BY `minOrder` ASC [ RunTime:0.000754s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19578777 LIMIT 5 [ RunTime:0.009749s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19578777 ORDER BY `minOrder` ASC [ RunTime:0.010232s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19578777 ORDER BY `unit` DESC [ RunTime:0.016175s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19578777 LIMIT 2 [ RunTime:0.018062s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19578777 ORDER BY `minOrder` ASC [ RunTime:0.003351s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19578688 LIMIT 5 [ RunTime:0.009808s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19578688 ORDER BY `minOrder` ASC [ RunTime:0.024925s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19578688 ORDER BY `unit` DESC [ RunTime:0.012153s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19578688 LIMIT 2 [ RunTime:0.028760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19578688 ORDER BY `minOrder` ASC [ RunTime:0.036909s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19578600 LIMIT 5 [ RunTime:0.042448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19578600 ORDER BY `minOrder` ASC [ RunTime:0.009592s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19578600 ORDER BY `unit` DESC [ RunTime:0.032523s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19578600 LIMIT 2 [ RunTime:0.010077s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19578600 ORDER BY `minOrder` ASC [ RunTime:0.006055s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19578585 LIMIT 5 [ RunTime:0.005337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19578585 ORDER BY `minOrder` ASC [ RunTime:0.020955s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19578585 ORDER BY `unit` DESC [ RunTime:0.012389s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19578585 LIMIT 2 [ RunTime:0.003725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19578585 ORDER BY `minOrder` ASC [ RunTime:0.003816s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19578449 LIMIT 5 [ RunTime:0.014630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19578449 ORDER BY `minOrder` ASC [ RunTime:0.007863s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19578449 ORDER BY `unit` DESC [ RunTime:0.010489s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19578449 LIMIT 2 [ RunTime:0.014484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19578449 ORDER BY `minOrder` ASC [ RunTime:0.009369s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19577993 LIMIT 5 [ RunTime:0.002702s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19577993 ORDER BY `minOrder` ASC [ RunTime:0.017268s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19577993 ORDER BY `unit` DESC [ RunTime:0.001249s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19577993 LIMIT 2 [ RunTime:0.012317s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19577993 ORDER BY `minOrder` ASC [ RunTime:0.002404s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17298028 LIMIT 5 [ RunTime:0.008177s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17298028 ORDER BY `minOrder` ASC [ RunTime:0.004489s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17298028 ORDER BY `unit` DESC [ RunTime:0.028875s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17298028 LIMIT 2 [ RunTime:0.002084s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17298028 ORDER BY `minOrder` ASC [ RunTime:0.000433s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16147866 LIMIT 5 [ RunTime:0.003711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16147866 ORDER BY `minOrder` ASC [ RunTime:0.013675s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16147866 ORDER BY `unit` DESC [ RunTime:0.010397s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16147866 LIMIT 2 [ RunTime:0.020801s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16147866 ORDER BY `minOrder` ASC [ RunTime:0.002623s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16147865 LIMIT 5 [ RunTime:0.017349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16147865 ORDER BY `minOrder` ASC [ RunTime:0.013813s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16147865 ORDER BY `unit` DESC [ RunTime:0.046437s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16147865 LIMIT 2 [ RunTime:0.018306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16147865 ORDER BY `minOrder` ASC [ RunTime:0.019843s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15440660 LIMIT 5 [ RunTime:0.013951s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15440660 ORDER BY `minOrder` ASC [ RunTime:0.024932s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15440660 ORDER BY `unit` DESC [ RunTime:0.010537s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15440660 LIMIT 2 [ RunTime:0.015514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15440660 ORDER BY `minOrder` ASC [ RunTime:0.009111s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15440490 LIMIT 5 [ RunTime:0.013019s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15440490 ORDER BY `minOrder` ASC [ RunTime:0.006542s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15440490 ORDER BY `unit` DESC [ RunTime:0.008514s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15440490 LIMIT 2 [ RunTime:0.000764s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15440490 ORDER BY `minOrder` ASC [ RunTime:0.001840s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15440468 LIMIT 5 [ RunTime:0.002517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15440468 ORDER BY `minOrder` ASC [ RunTime:0.017247s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15440468 ORDER BY `unit` DESC [ RunTime:0.009895s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15440468 LIMIT 2 [ RunTime:0.004656s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15440468 ORDER BY `minOrder` ASC [ RunTime:0.002765s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15440437 LIMIT 5 [ RunTime:0.025511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15440437 ORDER BY `minOrder` ASC [ RunTime:0.003063s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15440437 ORDER BY `unit` DESC [ RunTime:0.001271s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15440437 LIMIT 2 [ RunTime:0.003193s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15440437 ORDER BY `minOrder` ASC [ RunTime:0.000493s ]
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 'MC8022D%' OR `brand` LIKE 'MC8022D%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014304s ]
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 'MC8022D%' OR `brand` LIKE 'MC8022D%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013415s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53536779 LIMIT 5 [ RunTime:0.002503s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53536779 ORDER BY `minOrder` ASC [ RunTime:0.014627s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53536779 ORDER BY `unit` DESC [ RunTime:0.027028s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53536779 LIMIT 2 [ RunTime:0.005563s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53536779 ORDER BY `minOrder` ASC [ RunTime:0.022197s ]
select * from pdf where partno='MC8022D/AA' and brandshort='Amphenol Positronic' limit 1 [ RunTime:0.031766s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002805s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC8022D/AA' OR `brand` LIKE 'Amphenol Positronic%' ) ) LIMIT 1 [ RunTime:0.010417s ]
SELECT `id` FROM `stock` WHERE `id` <> 53536779 AND `partno` = 'MC8022D/AA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol positronic%' ) [ RunTime:0.013304s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19577993 [ RunTime:0.005847s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53536481 LIMIT 5 [ RunTime:0.004115s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53536481 ORDER BY `minOrder` ASC [ RunTime:0.018810s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53536481 ORDER BY `unit` DESC [ RunTime:0.026513s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53536481 LIMIT 2 [ RunTime:0.016650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53536481 ORDER BY `minOrder` ASC [ RunTime:0.006698s ]
select * from pdf where partno='MC8022D' and brandshort='Amphenol Positronic' limit 1 [ RunTime:0.000979s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC8022D' OR `brand` LIKE 'Amphenol Positronic%' ) ) LIMIT 1 [ RunTime:0.020859s ]
SELECT `id` FROM `stock` WHERE `id` <> 53536481 AND `partno` = 'MC8022D' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol positronic%' ) [ RunTime:0.014416s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19579761 [ RunTime:0.023878s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53539766 LIMIT 5 [ RunTime:0.003179s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53539766 ORDER BY `minOrder` ASC [ RunTime:0.027947s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53539766 ORDER BY `unit` DESC [ RunTime:0.020535s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53539766 LIMIT 2 [ RunTime:0.012272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53539766 ORDER BY `minOrder` ASC [ RunTime:0.003229s ]
select * from pdf where partno='MC8022DCO' and brandshort='Amphenol Positronic' limit 1 [ RunTime:0.020839s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC8022DCO' OR `brand` LIKE 'Amphenol Positronic%' ) ) LIMIT 1 [ RunTime:0.021270s ]
SELECT `id` FROM `stock` WHERE `id` <> 53539766 AND `partno` = 'MC8022DCO' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol positronic%' ) [ RunTime:0.032114s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19579438 [ RunTime:0.013502s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53539765 LIMIT 5 [ RunTime:0.028842s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53539765 ORDER BY `minOrder` ASC [ RunTime:0.048212s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53539765 ORDER BY `unit` DESC [ RunTime:0.007657s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53539765 LIMIT 2 [ RunTime:0.021946s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53539765 ORDER BY `minOrder` ASC [ RunTime:0.002851s ]
select * from pdf where partno='MC8022DCH' and brandshort='Amphenol Positronic' limit 1 [ RunTime:0.011804s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC8022DCH' OR `brand` LIKE 'Amphenol Positronic%' ) ) LIMIT 1 [ RunTime:0.010548s ]
SELECT `id` FROM `stock` WHERE `id` <> 53539765 AND `partno` = 'MC8022DCH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol positronic%' ) [ RunTime:0.018673s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19579443 [ RunTime:0.014363s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53539764 LIMIT 5 [ RunTime:0.036602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53539764 ORDER BY `minOrder` ASC [ RunTime:0.046084s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53539764 ORDER BY `unit` DESC [ RunTime:0.028406s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53539764 LIMIT 2 [ RunTime:0.036108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53539764 ORDER BY `minOrder` ASC [ RunTime:0.043409s ]
select * from pdf where partno='MC8022DAL' and brandshort='Amphenol Positronic' limit 1 [ RunTime:0.028914s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC8022DAL' OR `brand` LIKE 'Amphenol Positronic%' ) ) LIMIT 1 [ RunTime:0.035970s ]
SELECT `id` FROM `stock` WHERE `id` <> 53539764 AND `partno` = 'MC8022DAL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol positronic%' ) [ RunTime:0.052316s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16147866 [ RunTime:0.017632s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53539760 LIMIT 5 [ RunTime:0.035033s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53539760 ORDER BY `minOrder` ASC [ RunTime:0.025621s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53539760 ORDER BY `unit` DESC [ RunTime:0.057317s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53539760 LIMIT 2 [ RunTime:0.047550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53539760 ORDER BY `minOrder` ASC [ RunTime:0.029747s ]
select * from pdf where partno='MC8022DCU' and brandshort='Amphenol Positronic' limit 1 [ RunTime:0.023053s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC8022DCU' OR `brand` LIKE 'Amphenol Positronic%' ) ) LIMIT 1 [ RunTime:0.011989s ]
SELECT `id` FROM `stock` WHERE `id` <> 53539760 AND `partno` = 'MC8022DCU' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol positronic%' ) [ RunTime:0.014011s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19579454 [ RunTime:0.020626s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53539742 LIMIT 5 [ RunTime:0.038634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53539742 ORDER BY `minOrder` ASC [ RunTime:0.021433s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53539742 ORDER BY `unit` DESC [ RunTime:0.037182s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53539742 LIMIT 2 [ RunTime:0.016138s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53539742 ORDER BY `minOrder` ASC [ RunTime:0.016633s ]
select * from pdf where partno='MC8022DCU/AA' and brandshort='Amphenol Positronic' limit 1 [ RunTime:0.024717s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC8022DCU/AA' OR `brand` LIKE 'Amphenol Positronic%' ) ) LIMIT 1 [ RunTime:0.017149s ]
SELECT `id` FROM `stock` WHERE `id` <> 53539742 AND `partno` = 'MC8022DCU/AA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol positronic%' ) [ RunTime:0.020024s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16147865 [ RunTime:0.011550s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53539738 LIMIT 5 [ RunTime:0.015183s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53539738 ORDER BY `minOrder` ASC [ RunTime:0.013092s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53539738 ORDER BY `unit` DESC [ RunTime:0.011753s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53539738 LIMIT 2 [ RunTime:0.024171s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53539738 ORDER BY `minOrder` ASC [ RunTime:0.004381s ]
select * from pdf where partno='MC8022DCH/AA' and brandshort='Amphenol Positronic' limit 1 [ RunTime:0.011078s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC8022DCH/AA' OR `brand` LIKE 'Amphenol Positronic%' ) ) LIMIT 1 [ RunTime:0.015297s ]
SELECT `id` FROM `stock` WHERE `id` <> 53539738 AND `partno` = 'MC8022DCH/AA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol positronic%' ) [ RunTime:0.001128s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19579416 [ RunTime:0.010840s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53539737 LIMIT 5 [ RunTime:0.018740s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53539737 ORDER BY `minOrder` ASC [ RunTime:0.047619s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53539737 ORDER BY `unit` DESC [ RunTime:0.023572s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53539737 LIMIT 2 [ RunTime:0.030247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53539737 ORDER BY `minOrder` ASC [ RunTime:0.006891s ]
select * from pdf where partno='MC8022DCO/AA' and brandshort='Amphenol Positronic' limit 1 [ RunTime:0.019513s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC8022DCO/AA' OR `brand` LIKE 'Amphenol Positronic%' ) ) LIMIT 1 [ RunTime:0.024528s ]
SELECT `id` FROM `stock` WHERE `id` <> 53539737 AND `partno` = 'MC8022DCO/AA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol positronic%' ) [ RunTime:0.027767s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19579419 [ RunTime:0.096835s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53539709 LIMIT 5 [ RunTime:0.046435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53539709 ORDER BY `minOrder` ASC [ RunTime:0.033577s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53539709 ORDER BY `unit` DESC [ RunTime:0.038778s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53539709 LIMIT 2 [ RunTime:0.017520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53539709 ORDER BY `minOrder` ASC [ RunTime:0.016361s ]
select * from pdf where partno='MC8022DAL/AA' and brandshort='Amphenol Positronic' limit 1 [ RunTime:0.063722s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC8022DAL/AA' OR `brand` LIKE 'Amphenol Positronic%' ) ) LIMIT 1 [ RunTime:0.021169s ]
SELECT `id` FROM `stock` WHERE `id` <> 53539709 AND `partno` = 'MC8022DAL/AA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol positronic%' ) [ RunTime:0.088467s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15440660 [ RunTime:0.040081s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53538862 LIMIT 5 [ RunTime:0.059092s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53538862 ORDER BY `minOrder` ASC [ RunTime:0.025032s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53538862 ORDER BY `unit` DESC [ RunTime:0.027500s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53538862 LIMIT 2 [ RunTime:0.013656s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53538862 ORDER BY `minOrder` ASC [ RunTime:0.004133s ]
select * from pdf where partno='MC8022D-50' and brandshort='Amphenol Positronic' limit 1 [ RunTime:0.014133s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC8022D-50' OR `brand` LIKE 'Amphenol Positronic%' ) ) LIMIT 1 [ RunTime:0.026522s ]
SELECT `id` FROM `stock` WHERE `id` <> 53538862 AND `partno` = 'MC8022D-50' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol positronic%' ) [ RunTime:0.022595s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19578688 [ RunTime:0.016531s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53538775 LIMIT 5 [ RunTime:0.063466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53538775 ORDER BY `minOrder` ASC [ RunTime:0.001786s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53538775 ORDER BY `unit` DESC [ RunTime:0.015768s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53538775 LIMIT 2 [ RunTime:0.056918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53538775 ORDER BY `minOrder` ASC [ RunTime:0.029458s ]
select * from pdf where partno='MC8022D-15' and brandshort='Amphenol Positronic' limit 1 [ RunTime:0.004525s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC8022D-15' OR `brand` LIKE 'Amphenol Positronic%' ) ) LIMIT 1 [ RunTime:0.003557s ]
SELECT `id` FROM `stock` WHERE `id` <> 53538775 AND `partno` = 'MC8022D-15' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol positronic%' ) [ RunTime:0.012705s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19578600 [ RunTime:0.002854s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53538710 LIMIT 5 [ RunTime:0.012415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53538710 ORDER BY `minOrder` ASC [ RunTime:0.016395s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53538710 ORDER BY `unit` DESC [ RunTime:0.026494s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53538710 LIMIT 2 [ RunTime:0.031995s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53538710 ORDER BY `minOrder` ASC [ RunTime:0.009040s ]
select * from pdf where partno='MC8022D/AA-15' and brandshort='Amphenol Positronic' limit 1 [ RunTime:0.015960s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC8022D/AA-15' OR `brand` LIKE 'Amphenol Positronic%' ) ) LIMIT 1 [ RunTime:0.019936s ]
SELECT `id` FROM `stock` WHERE `id` <> 53538710 AND `partno` = 'MC8022D/AA-15' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol positronic%' ) [ RunTime:0.025315s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19578585 [ RunTime:0.044815s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53538709 LIMIT 5 [ RunTime:0.041559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53538709 ORDER BY `minOrder` ASC [ RunTime:0.020139s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53538709 ORDER BY `unit` DESC [ RunTime:0.035970s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53538709 LIMIT 2 [ RunTime:0.051507s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53538709 ORDER BY `minOrder` ASC [ RunTime:0.050748s ]
select * from pdf where partno='MC8022D/AA-50' and brandshort='Amphenol Positronic' limit 1 [ RunTime:0.025215s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC8022D/AA-50' OR `brand` LIKE 'Amphenol Positronic%' ) ) LIMIT 1 [ RunTime:0.021718s ]
SELECT `id` FROM `stock` WHERE `id` <> 53538709 AND `partno` = 'MC8022D/AA-50' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol positronic%' ) [ RunTime:0.038027s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15440490 [ RunTime:0.027028s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53538650 LIMIT 5 [ RunTime:0.023841s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53538650 ORDER BY `minOrder` ASC [ RunTime:0.021481s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53538650 ORDER BY `unit` DESC [ RunTime:0.017390s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53538650 LIMIT 2 [ RunTime:0.006897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53538650 ORDER BY `minOrder` ASC [ RunTime:0.055603s ]
select * from pdf where partno='MC8022D-14' and brandshort='Amphenol Positronic' limit 1 [ RunTime:0.019106s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC8022D-14' OR `brand` LIKE 'Amphenol Positronic%' ) ) LIMIT 1 [ RunTime:0.026146s ]
SELECT `id` FROM `stock` WHERE `id` <> 53538650 AND `partno` = 'MC8022D-14' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol positronic%' ) [ RunTime:0.019586s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17298028 [ RunTime:0.010638s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53538613 LIMIT 5 [ RunTime:0.004996s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53538613 ORDER BY `minOrder` ASC [ RunTime:0.044516s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53538613 ORDER BY `unit` DESC [ RunTime:0.006531s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53538613 LIMIT 2 [ RunTime:0.005836s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53538613 ORDER BY `minOrder` ASC [ RunTime:0.006661s ]
select * from pdf where partno='MC8022D/AA-14' and brandshort='Amphenol Positronic' limit 1 [ RunTime:0.010831s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC8022D/AA-14' OR `brand` LIKE 'Amphenol Positronic%' ) ) LIMIT 1 [ RunTime:0.014158s ]
SELECT `id` FROM `stock` WHERE `id` <> 53538613 AND `partno` = 'MC8022D/AA-14' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol positronic%' ) [ RunTime:0.017433s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15440437 [ RunTime:0.010831s ]
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 'MC8022D%' OR `brand` LIKE 'MC8022D%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019534s ]
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 'MC8022D%' OR `brand` LIKE 'MC8022D%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008515s ]
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 'MC8022D%' OR `brand` LIKE 'MC8022D%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012661s ]
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 'MC8022D%' OR `brand` LIKE 'MC8022D%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012189s ]
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 'MC8022D%' OR `brand` LIKE 'MC8022D%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009418s ]
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 'MC8022D%' OR `brand` LIKE 'MC8022D%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012033s ]
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 'MC8022D%' OR `brand` LIKE 'MC8022D%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004241s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'MC8022D%' OR `brand` LIKE 'MC8022D%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.009488s ]