SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002387s ]
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 '7733%' OR `brand` LIKE '7733%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.055491s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.016993s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16414079 LIMIT 5 [ RunTime:0.040535s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.010907s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16414079 ORDER BY `minOrder` ASC [ RunTime:0.037460s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.012926s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16414079 ORDER BY `unit` DESC [ RunTime:0.033068s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001269s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16414079 LIMIT 2 [ RunTime:0.033463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16414079 ORDER BY `minOrder` ASC [ RunTime:0.013367s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15381584 LIMIT 5 [ RunTime:0.035031s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15381584 ORDER BY `minOrder` ASC [ RunTime:0.018932s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15381584 ORDER BY `unit` DESC [ RunTime:0.020644s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15381584 LIMIT 2 [ RunTime:0.018130s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15381584 ORDER BY `minOrder` ASC [ RunTime:0.008131s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14392590 LIMIT 5 [ RunTime:0.031045s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14392590 ORDER BY `minOrder` ASC [ RunTime:0.033661s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14392590 ORDER BY `unit` DESC [ RunTime:0.017130s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14392590 LIMIT 2 [ RunTime:0.021890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14392590 ORDER BY `minOrder` ASC [ RunTime:0.036045s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12803185 LIMIT 5 [ RunTime:0.004523s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12803185 ORDER BY `minOrder` ASC [ RunTime:0.038513s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12803185 ORDER BY `unit` DESC [ RunTime:0.018782s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12803185 LIMIT 2 [ RunTime:0.037374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12803185 ORDER BY `minOrder` ASC [ RunTime:0.020328s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12803184 LIMIT 5 [ RunTime:0.034194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12803184 ORDER BY `minOrder` ASC [ RunTime:0.007153s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12803184 ORDER BY `unit` DESC [ RunTime:0.036196s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12803184 LIMIT 2 [ RunTime:0.042926s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12803184 ORDER BY `minOrder` ASC [ RunTime:0.002096s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12802953 LIMIT 5 [ RunTime:0.101977s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12802953 ORDER BY `minOrder` ASC [ RunTime:0.034621s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12802953 ORDER BY `unit` DESC [ RunTime:0.014688s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12802953 LIMIT 2 [ RunTime:0.035019s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12802953 ORDER BY `minOrder` ASC [ RunTime:0.001365s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12802651 LIMIT 5 [ RunTime:0.018113s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12802651 ORDER BY `minOrder` ASC [ RunTime:0.010116s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12802651 ORDER BY `unit` DESC [ RunTime:0.003283s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12802651 LIMIT 2 [ RunTime:0.005900s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12802651 ORDER BY `minOrder` ASC [ RunTime:0.001055s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12802631 LIMIT 5 [ RunTime:0.003229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12802631 ORDER BY `minOrder` ASC [ RunTime:0.011628s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12802631 ORDER BY `unit` DESC [ RunTime:0.010911s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12802631 LIMIT 2 [ RunTime:0.000744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12802631 ORDER BY `minOrder` ASC [ RunTime:0.000453s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12798617 LIMIT 5 [ RunTime:0.008732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12798617 ORDER BY `minOrder` ASC [ RunTime:0.019823s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12798617 ORDER BY `unit` DESC [ RunTime:0.019533s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12798617 LIMIT 2 [ RunTime:0.006452s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12798617 ORDER BY `minOrder` ASC [ RunTime:0.012288s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11618019 LIMIT 5 [ RunTime:0.010253s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11618019 ORDER BY `minOrder` ASC [ RunTime:0.008705s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11618019 ORDER BY `unit` DESC [ RunTime:0.011065s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11618019 LIMIT 2 [ RunTime:0.000582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11618019 ORDER BY `minOrder` ASC [ RunTime:0.019887s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11617653 LIMIT 5 [ RunTime:0.010022s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11617653 ORDER BY `minOrder` ASC [ RunTime:0.024377s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11617653 ORDER BY `unit` DESC [ RunTime:0.000393s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11617653 LIMIT 2 [ RunTime:0.005031s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11617653 ORDER BY `minOrder` ASC [ RunTime:0.005008s ]
select * from pdf where partno='77336-616LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.003179s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11617552 LIMIT 5 [ RunTime:0.007993s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11617552 ORDER BY `minOrder` ASC [ RunTime:0.018247s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11617552 ORDER BY `unit` DESC [ RunTime:0.015311s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11617552 LIMIT 2 [ RunTime:0.012640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11617552 ORDER BY `minOrder` ASC [ RunTime:0.020755s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11614913 LIMIT 5 [ RunTime:0.021128s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11614913 ORDER BY `minOrder` ASC [ RunTime:0.006064s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11614913 ORDER BY `unit` DESC [ RunTime:0.018929s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11614913 LIMIT 2 [ RunTime:0.000666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11614913 ORDER BY `minOrder` ASC [ RunTime:0.000368s ]
select * from pdf where partno='77336-610LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.012259s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11612240 LIMIT 5 [ RunTime:0.002014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11612240 ORDER BY `minOrder` ASC [ RunTime:0.006897s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11612240 ORDER BY `unit` DESC [ RunTime:0.008572s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11612240 LIMIT 2 [ RunTime:0.001940s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11612240 ORDER BY `minOrder` ASC [ RunTime:0.001811s ]
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 '7733%' OR `brand` LIKE '7733%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002433s ]
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 '7733%' OR `brand` LIKE '7733%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002198s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64279573 LIMIT 5 [ RunTime:0.003400s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64279573 ORDER BY `minOrder` ASC [ RunTime:0.005437s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64279573 ORDER BY `unit` DESC [ RunTime:0.013015s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64279573 LIMIT 2 [ RunTime:0.008638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64279573 ORDER BY `minOrder` ASC [ RunTime:0.000333s ]
select * from pdf where partno='7733' and brandshort='3M' limit 1 [ RunTime:0.001922s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002417s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7733' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.010943s ]
SELECT `id` FROM `stock` WHERE `id` <> 64279573 AND `partno` = '7733' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.000610s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15381584 [ RunTime:0.002240s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63067065 LIMIT 5 [ RunTime:0.003126s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63067065 ORDER BY `minOrder` ASC [ RunTime:0.001235s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63067065 ORDER BY `unit` DESC [ RunTime:0.000432s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63067065 LIMIT 2 [ RunTime:0.000332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63067065 ORDER BY `minOrder` ASC [ RunTime:0.000253s ]
select * from pdf where partno='7733A 010500' and brandshort='Lumberg Automation' limit 1 [ RunTime:0.001396s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7733A 010500' OR `brand` LIKE 'Lumberg Automation%' ) ) LIMIT 1 [ RunTime:0.001889s ]
SELECT `id` FROM `stock` WHERE `id` <> 63067065 AND `partno` = '7733A 010500' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumberg automation%' ) [ RunTime:0.001759s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14392590 [ RunTime:0.001609s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63067064 LIMIT 5 [ RunTime:0.002429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63067064 ORDER BY `minOrder` ASC [ RunTime:0.001019s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63067064 ORDER BY `unit` DESC [ RunTime:0.001519s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63067064 LIMIT 2 [ RunTime:0.001082s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63067064 ORDER BY `minOrder` ASC [ RunTime:0.000257s ]
select * from pdf where partno='7733A 0101000' and brandshort='Lumberg Automation' limit 1 [ RunTime:0.001510s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7733A 0101000' OR `brand` LIKE 'Lumberg Automation%' ) ) LIMIT 1 [ RunTime:0.002741s ]
SELECT `id` FROM `stock` WHERE `id` <> 63067064 AND `partno` = '7733A 0101000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumberg automation%' ) [ RunTime:0.011631s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16414079 [ RunTime:0.000686s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59915137 LIMIT 5 [ RunTime:0.002683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59915137 ORDER BY `minOrder` ASC [ RunTime:0.003956s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59915137 ORDER BY `unit` DESC [ RunTime:0.005646s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59915137 LIMIT 2 [ RunTime:0.005216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59915137 ORDER BY `minOrder` ASC [ RunTime:0.008458s ]
select * from pdf where partno='77336-060LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.004723s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '77336-060LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.001441s ]
SELECT `id` FROM `stock` WHERE `id` <> 59915137 AND `partno` = '77336-060LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.007168s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11612240 [ RunTime:0.010039s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59915052 LIMIT 5 [ RunTime:0.003024s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59915052 ORDER BY `minOrder` ASC [ RunTime:0.002485s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59915052 ORDER BY `unit` DESC [ RunTime:0.002459s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59915052 LIMIT 2 [ RunTime:0.005962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59915052 ORDER BY `minOrder` ASC [ RunTime:0.003455s ]
select * from pdf where partno='77336-064LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.008484s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '77336-064LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.011544s ]
SELECT `id` FROM `stock` WHERE `id` <> 59915052 AND `partno` = '77336-064LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.016567s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59914063 LIMIT 5 [ RunTime:0.014224s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59914063 ORDER BY `minOrder` ASC [ RunTime:0.017557s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59914063 ORDER BY `unit` DESC [ RunTime:0.006872s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59914063 LIMIT 2 [ RunTime:0.008964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59914063 ORDER BY `minOrder` ASC [ RunTime:0.005131s ]
select * from pdf where partno='77336-020LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.014117s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '77336-020LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.012218s ]
SELECT `id` FROM `stock` WHERE `id` <> 59914063 AND `partno` = '77336-020LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.004987s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12803185 [ RunTime:0.029482s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59914061 LIMIT 5 [ RunTime:0.010822s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59914061 ORDER BY `minOrder` ASC [ RunTime:0.021782s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59914061 ORDER BY `unit` DESC [ RunTime:0.006645s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59914061 LIMIT 2 [ RunTime:0.008575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59914061 ORDER BY `minOrder` ASC [ RunTime:0.003327s ]
select * from pdf where partno='77336-030LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.002738s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '77336-030LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.025187s ]
SELECT `id` FROM `stock` WHERE `id` <> 59914061 AND `partno` = '77336-030LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.012482s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12803184 [ RunTime:0.027957s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59914001 LIMIT 5 [ RunTime:0.010852s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59914001 ORDER BY `minOrder` ASC [ RunTime:0.035486s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59914001 ORDER BY `unit` DESC [ RunTime:0.014300s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59914001 LIMIT 2 [ RunTime:0.031040s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59914001 ORDER BY `minOrder` ASC [ RunTime:0.020055s ]
select * from pdf where partno='77336-634LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.006760s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '77336-634LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.045257s ]
SELECT `id` FROM `stock` WHERE `id` <> 59914001 AND `partno` = '77336-634LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.027766s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59913900 LIMIT 5 [ RunTime:0.067691s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59913900 ORDER BY `minOrder` ASC [ RunTime:0.046630s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59913900 ORDER BY `unit` DESC [ RunTime:0.015086s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59913900 LIMIT 2 [ RunTime:0.021808s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59913900 ORDER BY `minOrder` ASC [ RunTime:0.013983s ]
select * from pdf where partno='77336-134LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.073446s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '77336-134LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.037916s ]
SELECT `id` FROM `stock` WHERE `id` <> 59913900 AND `partno` = '77336-134LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.031519s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11618019 [ RunTime:0.034593s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59913836 LIMIT 5 [ RunTime:0.047074s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59913836 ORDER BY `minOrder` ASC [ RunTime:0.066176s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59913836 ORDER BY `unit` DESC [ RunTime:0.015270s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59913836 LIMIT 2 [ RunTime:0.049746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59913836 ORDER BY `minOrder` ASC [ RunTime:0.021907s ]
select * from pdf where partno='77336-126LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.047101s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '77336-126LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.030752s ]
SELECT `id` FROM `stock` WHERE `id` <> 59913836 AND `partno` = '77336-126LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.029167s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59913579 LIMIT 5 [ RunTime:0.019712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59913579 ORDER BY `minOrder` ASC [ RunTime:0.046426s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59913579 ORDER BY `unit` DESC [ RunTime:0.030848s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59913579 LIMIT 2 [ RunTime:0.008888s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59913579 ORDER BY `minOrder` ASC [ RunTime:0.045651s ]
select * from pdf where partno='77336-426LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.035893s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '77336-426LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.035084s ]
SELECT `id` FROM `stock` WHERE `id` <> 59913579 AND `partno` = '77336-426LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.090219s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12802953 [ RunTime:0.022153s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59913133 LIMIT 5 [ RunTime:0.008781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59913133 ORDER BY `minOrder` ASC [ RunTime:0.026394s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59913133 ORDER BY `unit` DESC [ RunTime:0.056073s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59913133 LIMIT 2 [ RunTime:0.032583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59913133 ORDER BY `minOrder` ASC [ RunTime:0.027992s ]
select * from pdf where partno='77336-620LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.022521s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '77336-620LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.020914s ]
SELECT `id` FROM `stock` WHERE `id` <> 59913133 AND `partno` = '77336-620LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.024146s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12802651 [ RunTime:0.018652s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59913101 LIMIT 5 [ RunTime:0.009014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59913101 ORDER BY `minOrder` ASC [ RunTime:0.029888s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59913101 ORDER BY `unit` DESC [ RunTime:0.015617s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59913101 LIMIT 2 [ RunTime:0.044282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59913101 ORDER BY `minOrder` ASC [ RunTime:0.007365s ]
select * from pdf where partno='77336-120LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.025533s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '77336-120LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.008054s ]
SELECT `id` FROM `stock` WHERE `id` <> 59913101 AND `partno` = '77336-120LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.008489s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12802631 [ RunTime:0.022456s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59912995 LIMIT 5 [ RunTime:0.018582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59912995 ORDER BY `minOrder` ASC [ RunTime:0.012355s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59912995 ORDER BY `unit` DESC [ RunTime:0.001688s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59912995 LIMIT 2 [ RunTime:0.006999s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59912995 ORDER BY `minOrder` ASC [ RunTime:0.007555s ]
select * from pdf where partno='77336-616LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.006022s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '77336-616LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.007501s ]
SELECT `id` FROM `stock` WHERE `id` <> 59912995 AND `partno` = '77336-616LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.003491s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11617653 [ RunTime:0.000932s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59912747 LIMIT 5 [ RunTime:0.004861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59912747 ORDER BY `minOrder` ASC [ RunTime:0.013932s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59912747 ORDER BY `unit` DESC [ RunTime:0.033573s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59912747 LIMIT 2 [ RunTime:0.006851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59912747 ORDER BY `minOrder` ASC [ RunTime:0.000506s ]
select * from pdf where partno='77336-110LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.006484s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '77336-110LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.022360s ]
SELECT `id` FROM `stock` WHERE `id` <> 59912747 AND `partno` = '77336-110LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.039595s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11617552 [ RunTime:0.019502s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59911917 LIMIT 5 [ RunTime:0.023695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59911917 ORDER BY `minOrder` ASC [ RunTime:0.016622s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59911917 ORDER BY `unit` DESC [ RunTime:0.013133s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59911917 LIMIT 2 [ RunTime:0.019427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59911917 ORDER BY `minOrder` ASC [ RunTime:0.014362s ]
select * from pdf where partno='77336-606LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.007904s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '77336-606LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.011808s ]
SELECT `id` FROM `stock` WHERE `id` <> 59911917 AND `partno` = '77336-606LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.027673s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32514776 LIMIT 5 [ RunTime:0.038882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32514776 ORDER BY `minOrder` ASC [ RunTime:0.011207s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32514776 ORDER BY `unit` DESC [ RunTime:0.005240s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32514776 LIMIT 2 [ RunTime:0.025264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32514776 ORDER BY `minOrder` ASC [ RunTime:0.002848s ]
select * from pdf where partno='773388-000' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.005650s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '773388-000' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.002918s ]
SELECT `id` FROM `stock` WHERE `id` <> 32514776 AND `partno` = '773388-000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.002607s ]
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 '7733%' OR `brand` LIKE '7733%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012163s ]
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 '7733%' OR `brand` LIKE '7733%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010816s ]
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 '7733%' OR `brand` LIKE '7733%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017908s ]
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 '7733%' OR `brand` LIKE '7733%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019515s ]
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 '7733%' OR `brand` LIKE '7733%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031664s ]
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 '7733%' OR `brand` LIKE '7733%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022965s ]
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 '7733%' OR `brand` LIKE '7733%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030185s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '7733%' OR `brand` LIKE '7733%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.026068s ]