SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002511s ]
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 'NBB10-30GM50-WS%' OR `brand` LIKE 'NBB10-30GM50-WS%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006718s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001423s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18791795 LIMIT 5 [ RunTime:0.000732s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003132s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18791795 ORDER BY `minOrder` ASC [ RunTime:0.002365s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.007263s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18791795 ORDER BY `unit` DESC [ RunTime:0.006002s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.009072s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18791795 LIMIT 2 [ RunTime:0.011760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18791795 ORDER BY `minOrder` ASC [ RunTime:0.014620s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18791793 LIMIT 5 [ RunTime:0.053743s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18791793 ORDER BY `minOrder` ASC [ RunTime:0.024411s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18791793 ORDER BY `unit` DESC [ RunTime:0.062475s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18791793 LIMIT 2 [ RunTime:0.047118s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18791793 ORDER BY `minOrder` ASC [ RunTime:0.018811s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18790229 LIMIT 5 [ RunTime:0.029542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18790229 ORDER BY `minOrder` ASC [ RunTime:0.020190s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18790229 ORDER BY `unit` DESC [ RunTime:0.099358s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18790229 LIMIT 2 [ RunTime:0.053699s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18790229 ORDER BY `minOrder` ASC [ RunTime:0.012068s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18789964 LIMIT 5 [ RunTime:0.047062s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18789964 ORDER BY `minOrder` ASC [ RunTime:0.083976s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18789964 ORDER BY `unit` DESC [ RunTime:0.064371s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18789964 LIMIT 2 [ RunTime:0.018187s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18789964 ORDER BY `minOrder` ASC [ RunTime:0.014806s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18789696 LIMIT 5 [ RunTime:0.029306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18789696 ORDER BY `minOrder` ASC [ RunTime:0.067510s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18789696 ORDER BY `unit` DESC [ RunTime:0.029182s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18789696 LIMIT 2 [ RunTime:0.082225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18789696 ORDER BY `minOrder` ASC [ RunTime:0.016523s ]
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 'NBB10-30GM50-WS%' OR `brand` LIKE 'NBB10-30GM50-WS%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017646s ]
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 'NBB10-30GM50-WS%' OR `brand` LIKE 'NBB10-30GM50-WS%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.049329s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57966048 LIMIT 5 [ RunTime:0.070357s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57966048 ORDER BY `minOrder` ASC [ RunTime:0.065129s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57966048 ORDER BY `unit` DESC [ RunTime:0.040559s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57966048 LIMIT 2 [ RunTime:0.065102s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57966048 ORDER BY `minOrder` ASC [ RunTime:0.035419s ]
select * from pdf where partno='NBB10-30GM50-WS' and brandshort='Pepperl+Fuchs, Inc.' limit 1 [ RunTime:0.086789s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002496s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NBB10-30GM50-WS' OR `brand` LIKE 'Pepperl+Fuchs, Inc.%' ) ) LIMIT 1 [ RunTime:0.078282s ]
SELECT `id` FROM `stock` WHERE `id` <> 57966048 AND `partno` = 'NBB10-30GM50-WS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pepperl+fuchs, inc.%' ) [ RunTime:0.069723s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18791793 [ RunTime:0.024697s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57965878 LIMIT 5 [ RunTime:0.061878s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57965878 ORDER BY `minOrder` ASC [ RunTime:0.050392s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57965878 ORDER BY `unit` DESC [ RunTime:0.024144s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57965878 LIMIT 2 [ RunTime:0.024573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57965878 ORDER BY `minOrder` ASC [ RunTime:0.028320s ]
select * from pdf where partno='NBB10-30GM50-WS-V12' and brandshort='Pepperl+Fuchs, Inc.' limit 1 [ RunTime:0.039330s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NBB10-30GM50-WS-V12' OR `brand` LIKE 'Pepperl+Fuchs, Inc.%' ) ) LIMIT 1 [ RunTime:0.045055s ]
SELECT `id` FROM `stock` WHERE `id` <> 57965878 AND `partno` = 'NBB10-30GM50-WS-V12' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pepperl+fuchs, inc.%' ) [ RunTime:0.057785s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18791795 [ RunTime:0.031093s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56464892 LIMIT 5 [ RunTime:0.060031s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56464892 ORDER BY `minOrder` ASC [ RunTime:0.020482s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56464892 ORDER BY `unit` DESC [ RunTime:0.020101s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56464892 LIMIT 2 [ RunTime:0.061746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56464892 ORDER BY `minOrder` ASC [ RunTime:0.062683s ]
select * from pdf where partno='NBB10-30GM50-WS-T-V93' and brandshort='Pepperl+Fuchs, Inc.' limit 1 [ RunTime:0.052087s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NBB10-30GM50-WS-T-V93' OR `brand` LIKE 'Pepperl+Fuchs, Inc.%' ) ) LIMIT 1 [ RunTime:0.013827s ]
SELECT `id` FROM `stock` WHERE `id` <> 56464892 AND `partno` = 'NBB10-30GM50-WS-T-V93' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pepperl+fuchs, inc.%' ) [ RunTime:0.044190s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57976386 LIMIT 5 [ RunTime:0.028773s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57976386 ORDER BY `minOrder` ASC [ RunTime:0.028555s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57976386 ORDER BY `unit` DESC [ RunTime:0.025869s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57976386 LIMIT 2 [ RunTime:0.025068s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57976386 ORDER BY `minOrder` ASC [ RunTime:0.035631s ]
select * from pdf where partno='NBB10-30GM50-WS-T-Y802857' and brandshort='Pepperl+Fuchs, Inc.' limit 1 [ RunTime:0.015173s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NBB10-30GM50-WS-T-Y802857' OR `brand` LIKE 'Pepperl+Fuchs, Inc.%' ) ) LIMIT 1 [ RunTime:0.012941s ]
SELECT `id` FROM `stock` WHERE `id` <> 57976386 AND `partno` = 'NBB10-30GM50-WS-T-Y802857' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pepperl+fuchs, inc.%' ) [ RunTime:0.028242s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18790229 [ RunTime:0.045384s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57976054 LIMIT 5 [ RunTime:0.022182s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57976054 ORDER BY `minOrder` ASC [ RunTime:0.009488s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57976054 ORDER BY `unit` DESC [ RunTime:0.022134s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57976054 LIMIT 2 [ RunTime:0.022025s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57976054 ORDER BY `minOrder` ASC [ RunTime:0.020066s ]
select * from pdf where partno='NBB10-30GM50-WS 10M' and brandshort='Pepperl+Fuchs, Inc.' limit 1 [ RunTime:0.017929s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NBB10-30GM50-WS 10M' OR `brand` LIKE 'Pepperl+Fuchs, Inc.%' ) ) LIMIT 1 [ RunTime:0.021706s ]
SELECT `id` FROM `stock` WHERE `id` <> 57976054 AND `partno` = 'NBB10-30GM50-WS 10M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pepperl+fuchs, inc.%' ) [ RunTime:0.014343s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18789964 [ RunTime:0.000866s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57975689 LIMIT 5 [ RunTime:0.040126s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57975689 ORDER BY `minOrder` ASC [ RunTime:0.044331s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57975689 ORDER BY `unit` DESC [ RunTime:0.052543s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57975689 LIMIT 2 [ RunTime:0.076765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57975689 ORDER BY `minOrder` ASC [ RunTime:0.049425s ]
select * from pdf where partno='NBB10-30GM50-WS-V93' and brandshort='Pepperl+Fuchs, Inc.' limit 1 [ RunTime:0.020035s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NBB10-30GM50-WS-V93' OR `brand` LIKE 'Pepperl+Fuchs, Inc.%' ) ) LIMIT 1 [ RunTime:0.060950s ]
SELECT `id` FROM `stock` WHERE `id` <> 57975689 AND `partno` = 'NBB10-30GM50-WS-V93' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pepperl+fuchs, inc.%' ) [ RunTime:0.032356s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18789696 [ RunTime:0.015778s ]
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 'NBB10-30GM50-WS%' OR `brand` LIKE 'NBB10-30GM50-WS%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.057457s ]
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 'NBB10-30GM50-WS%' OR `brand` LIKE 'NBB10-30GM50-WS%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.059860s ]
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 'NBB10-30GM50-WS%' OR `brand` LIKE 'NBB10-30GM50-WS%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.093424s ]
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 'NBB10-30GM50-WS%' OR `brand` LIKE 'NBB10-30GM50-WS%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003965s ]
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 'NBB10-30GM50-WS%' OR `brand` LIKE 'NBB10-30GM50-WS%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.042891s ]
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 'NBB10-30GM50-WS%' OR `brand` LIKE 'NBB10-30GM50-WS%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032942s ]
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 'NBB10-30GM50-WS%' OR `brand` LIKE 'NBB10-30GM50-WS%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.041794s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'NBB10-30GM50-WS%' OR `brand` LIKE 'NBB10-30GM50-WS%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.025933s ]