SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002365s ]
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 '10A24-P30-I10%' OR `brand` LIKE '10A24-P30-I10%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011685s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003383s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17849221 LIMIT 5 [ RunTime:0.034581s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17849221 ORDER BY `minOrder` ASC [ RunTime:0.012365s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001168s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17849221 ORDER BY `unit` DESC [ RunTime:0.012798s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.007176s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17849221 LIMIT 2 [ RunTime:0.009876s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17849221 ORDER BY `minOrder` ASC [ RunTime:0.022066s ]
select * from pdf where partno='10A24-P30-I10-F-M-C' and brandshort='ULTRAVOLT / Advanced Energy' limit 1 [ RunTime:0.027983s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17849027 LIMIT 5 [ RunTime:0.010800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17849027 ORDER BY `minOrder` ASC [ RunTime:0.022617s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17849027 ORDER BY `unit` DESC [ RunTime:0.033194s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17849027 LIMIT 2 [ RunTime:0.029857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17849027 ORDER BY `minOrder` ASC [ RunTime:0.039195s ]
select * from pdf where partno='10A24-P30-I10-25PPM-F-M-C' and brandshort='ULTRAVOLT / Advanced Energy' limit 1 [ RunTime:0.037197s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17848899 LIMIT 5 [ RunTime:0.040666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848899 ORDER BY `minOrder` ASC [ RunTime:0.076647s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17848899 ORDER BY `unit` DESC [ RunTime:0.085384s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17848899 LIMIT 2 [ RunTime:0.017136s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848899 ORDER BY `minOrder` ASC [ RunTime:0.017908s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17848614 LIMIT 5 [ RunTime:0.077050s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848614 ORDER BY `minOrder` ASC [ RunTime:0.013425s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17848614 ORDER BY `unit` DESC [ RunTime:0.028072s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17848614 LIMIT 2 [ RunTime:0.026643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848614 ORDER BY `minOrder` ASC [ RunTime:0.017275s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17848387 LIMIT 5 [ RunTime:0.019807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848387 ORDER BY `minOrder` ASC [ RunTime:0.039172s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17848387 ORDER BY `unit` DESC [ RunTime:0.021843s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17848387 LIMIT 2 [ RunTime:0.063781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848387 ORDER BY `minOrder` ASC [ RunTime:0.003036s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17848243 LIMIT 5 [ RunTime:0.042153s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848243 ORDER BY `minOrder` ASC [ RunTime:0.036685s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17848243 ORDER BY `unit` DESC [ RunTime:0.020111s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17848243 LIMIT 2 [ RunTime:0.018220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17848243 ORDER BY `minOrder` ASC [ RunTime:0.037243s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16800333 LIMIT 5 [ RunTime:0.055194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16800333 ORDER BY `minOrder` ASC [ RunTime:0.038998s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16800333 ORDER BY `unit` DESC [ RunTime:0.026240s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16800333 LIMIT 2 [ RunTime:0.021396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16800333 ORDER BY `minOrder` ASC [ RunTime:0.003235s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16800313 LIMIT 5 [ RunTime:0.016772s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16800313 ORDER BY `minOrder` ASC [ RunTime:0.007510s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16800313 ORDER BY `unit` DESC [ RunTime:0.000698s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16800313 LIMIT 2 [ RunTime:0.000591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16800313 ORDER BY `minOrder` ASC [ RunTime:0.005703s ]
select * from pdf where partno='10A24-P30-I10-F-M-E' and brandshort='ULTRAVOLT / Advanced Energy' limit 1 [ RunTime:0.001216s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16800252 LIMIT 5 [ RunTime:0.005714s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16800252 ORDER BY `minOrder` ASC [ RunTime:0.003416s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16800252 ORDER BY `unit` DESC [ RunTime:0.011894s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16800252 LIMIT 2 [ RunTime:0.011955s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16800252 ORDER BY `minOrder` ASC [ RunTime:0.008870s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16650399 LIMIT 5 [ RunTime:0.015600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16650399 ORDER BY `minOrder` ASC [ RunTime:0.011171s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16650399 ORDER BY `unit` DESC [ RunTime:0.017289s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16650399 LIMIT 2 [ RunTime:0.004398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16650399 ORDER BY `minOrder` ASC [ RunTime:0.000291s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16650208 LIMIT 5 [ RunTime:0.000714s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16650208 ORDER BY `minOrder` ASC [ RunTime:0.014867s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16650208 ORDER BY `unit` DESC [ RunTime:0.011216s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16650208 LIMIT 2 [ RunTime:0.030360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16650208 ORDER BY `minOrder` ASC [ RunTime:0.002359s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16649290 LIMIT 5 [ RunTime:0.002635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16649290 ORDER BY `minOrder` ASC [ RunTime:0.000446s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16649290 ORDER BY `unit` DESC [ RunTime:0.016501s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16649290 LIMIT 2 [ RunTime:0.009709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16649290 ORDER BY `minOrder` ASC [ RunTime:0.002235s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15009997 LIMIT 5 [ RunTime:0.018206s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15009997 ORDER BY `minOrder` ASC [ RunTime:0.007349s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15009997 ORDER BY `unit` DESC [ RunTime:0.014713s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15009997 LIMIT 2 [ RunTime:0.012124s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15009997 ORDER BY `minOrder` ASC [ RunTime:0.014983s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14789020 LIMIT 5 [ RunTime:0.034391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14789020 ORDER BY `minOrder` ASC [ RunTime:0.006681s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14789020 ORDER BY `unit` DESC [ RunTime:0.007888s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14789020 LIMIT 2 [ RunTime:0.002314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14789020 ORDER BY `minOrder` ASC [ RunTime:0.000345s ]
select * from pdf where partno='10A24-P30-I10-25PPM-F-M' and brandshort='ULTRAVOLT / Advanced Energy' limit 1 [ RunTime:0.003544s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14788910 LIMIT 5 [ RunTime:0.010676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14788910 ORDER BY `minOrder` ASC [ RunTime:0.016140s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14788910 ORDER BY `unit` DESC [ RunTime:0.018019s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14788910 LIMIT 2 [ RunTime:0.006374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14788910 ORDER BY `minOrder` ASC [ RunTime:0.000370s ]
select * from pdf where partno='10A24-P30-I10-F-M-H' and brandshort='ULTRAVOLT / Advanced Energy' limit 1 [ RunTime:0.000811s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14788840 LIMIT 5 [ RunTime:0.001636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14788840 ORDER BY `minOrder` ASC [ RunTime:0.000728s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14788840 ORDER BY `unit` DESC [ RunTime:0.002547s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14788840 LIMIT 2 [ RunTime:0.006055s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14788840 ORDER BY `minOrder` ASC [ RunTime:0.000465s ]
select * from pdf where partno='10A24-P30-I10-F-M' and brandshort='ULTRAVOLT / Advanced Energy' limit 1 [ RunTime:0.001394s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14788771 LIMIT 5 [ RunTime:0.000664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14788771 ORDER BY `minOrder` ASC [ RunTime:0.002257s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14788771 ORDER BY `unit` DESC [ RunTime:0.002353s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14788771 LIMIT 2 [ RunTime:0.001904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14788771 ORDER BY `minOrder` ASC [ RunTime:0.000207s ]
select * from pdf where partno='10A24-P30-I10-F-M-HLP' and brandshort='ULTRAVOLT / Advanced Energy' limit 1 [ RunTime:0.000456s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14788532 LIMIT 5 [ RunTime:0.001946s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14788532 ORDER BY `minOrder` ASC [ RunTime:0.002931s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14788532 ORDER BY `unit` DESC [ RunTime:0.000758s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14788532 LIMIT 2 [ RunTime:0.002864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14788532 ORDER BY `minOrder` ASC [ RunTime:0.002747s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14788149 LIMIT 5 [ RunTime:0.003210s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14788149 ORDER BY `minOrder` ASC [ RunTime:0.001162s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14788149 ORDER BY `unit` DESC [ RunTime:0.001184s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14788149 LIMIT 2 [ RunTime:0.000321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14788149 ORDER BY `minOrder` ASC [ RunTime:0.000202s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14070251 LIMIT 5 [ RunTime:0.000591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14070251 ORDER BY `minOrder` ASC [ RunTime:0.007771s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14070251 ORDER BY `unit` DESC [ RunTime:0.005535s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14070251 LIMIT 2 [ RunTime:0.001157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14070251 ORDER BY `minOrder` ASC [ RunTime:0.000228s ]
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 '10A24-P30-I10%' OR `brand` LIKE '10A24-P30-I10%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001367s ]
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 '10A24-P30-I10%' OR `brand` LIKE '10A24-P30-I10%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000773s ]
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 '10A24-P30-I10%' OR `brand` LIKE '10A24-P30-I10%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008596s ]
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 '10A24-P30-I10%' OR `brand` LIKE '10A24-P30-I10%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001339s ]
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 '10A24-P30-I10%' OR `brand` LIKE '10A24-P30-I10%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000814s ]
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 '10A24-P30-I10%' OR `brand` LIKE '10A24-P30-I10%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007329s ]
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 '10A24-P30-I10%' OR `brand` LIKE '10A24-P30-I10%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001025s ]
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 '10A24-P30-I10%' OR `brand` LIKE '10A24-P30-I10%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009664s ]
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 '10A24-P30-I10%' OR `brand` LIKE '10A24-P30-I10%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000974s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10A24-P30-I10%' OR `brand` LIKE '10A24-P30-I10%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.003522s ]