SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002579s ]
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 'w3011%' OR `brand` LIKE 'w3011%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.098745s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.026174s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12406548 LIMIT 5 [ RunTime:0.165295s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.050658s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12406548 ORDER BY `minOrder` ASC [ RunTime:0.143161s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.056539s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12406548 ORDER BY `unit` DESC [ RunTime:0.066944s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.047769s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12406548 LIMIT 2 [ RunTime:0.251183s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12406548 ORDER BY `minOrder` ASC [ RunTime:0.062912s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14715874 LIMIT 5 [ RunTime:0.085152s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14715874 ORDER BY `minOrder` ASC [ RunTime:0.183816s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14715874 ORDER BY `unit` DESC [ RunTime:0.121305s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14715874 LIMIT 2 [ RunTime:0.084842s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14715874 ORDER BY `minOrder` ASC [ RunTime:0.065978s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13258289 LIMIT 5 [ RunTime:0.080177s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13258289 ORDER BY `minOrder` ASC [ RunTime:0.051030s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13258289 ORDER BY `unit` DESC [ RunTime:0.046362s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13258289 LIMIT 2 [ RunTime:0.099394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13258289 ORDER BY `minOrder` ASC [ RunTime:0.069114s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11346202 LIMIT 5 [ RunTime:0.025513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11346202 ORDER BY `minOrder` ASC [ RunTime:0.166889s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11346202 ORDER BY `unit` DESC [ RunTime:0.046573s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11346202 LIMIT 2 [ RunTime:0.034328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11346202 ORDER BY `minOrder` ASC [ RunTime:0.019838s ]
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 'w3011%' OR `brand` LIKE 'w3011%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.098117s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51114288 LIMIT 5 [ RunTime:0.141811s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51114288 ORDER BY `minOrder` ASC [ RunTime:0.127853s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51114288 ORDER BY `unit` DESC [ RunTime:0.082855s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51114288 LIMIT 2 [ RunTime:0.114683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51114288 ORDER BY `minOrder` ASC [ RunTime:0.035613s ]
select * from pdf where partno='w3011' and brandshort='pulse electronics' limit 1 [ RunTime:0.010003s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002651s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'w3011' OR `brand` LIKE 'pulse electronics%' ) ) LIMIT 1 [ RunTime:0.015211s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32304236 LIMIT 5 [ RunTime:0.026765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32304236 ORDER BY `minOrder` ASC [ RunTime:0.006891s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32304236 ORDER BY `unit` DESC [ RunTime:0.043862s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32304236 LIMIT 2 [ RunTime:0.046893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32304236 ORDER BY `minOrder` ASC [ RunTime:0.012420s ]
select * from pdf where partno='w3011' and brandshort='pulse electronics' limit 1 [ RunTime:0.017978s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'w3011' OR `brand` LIKE 'pulse electronics%' ) ) LIMIT 1 [ RunTime:0.002465s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32296108 LIMIT 5 [ RunTime:0.058947s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32296108 ORDER BY `minOrder` ASC [ RunTime:0.067545s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32296108 ORDER BY `unit` DESC [ RunTime:0.005447s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32296108 LIMIT 2 [ RunTime:0.012022s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32296108 ORDER BY `minOrder` ASC [ RunTime:0.035274s ]
select * from pdf where partno='w3011' and brandshort='pulse electronics' limit 1 [ RunTime:0.032294s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'w3011' OR `brand` LIKE 'pulse electronics%' ) ) LIMIT 1 [ RunTime:0.020055s ]
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 'w3011%' OR `brand` LIKE 'w3011%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.054275s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64223176 LIMIT 5 [ RunTime:0.026095s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64223176 ORDER BY `minOrder` ASC [ RunTime:0.111283s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64223176 ORDER BY `unit` DESC [ RunTime:0.096908s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64223176 LIMIT 2 [ RunTime:0.053955s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64223176 ORDER BY `minOrder` ASC [ RunTime:0.029883s ]
select * from pdf where partno='W3011A' and brandshort='Pulse Electronics' limit 1 [ RunTime:0.055435s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'W3011A' OR `brand` LIKE 'Pulse Electronics%' ) ) LIMIT 1 [ RunTime:0.115308s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64223177 LIMIT 5 [ RunTime:0.025169s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64223177 ORDER BY `minOrder` ASC [ RunTime:0.173307s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64223177 ORDER BY `unit` DESC [ RunTime:0.064681s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64223177 LIMIT 2 [ RunTime:0.141242s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64223177 ORDER BY `minOrder` ASC [ RunTime:0.048102s ]
select * from pdf where partno='W3011' and brandshort='Pulse Electronics' limit 1 [ RunTime:0.095650s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'W3011' OR `brand` LIKE 'Pulse Electronics%' ) ) LIMIT 1 [ RunTime:0.020588s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64819156 LIMIT 5 [ RunTime:0.036869s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64819156 ORDER BY `minOrder` ASC [ RunTime:0.074328s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64819156 ORDER BY `unit` DESC [ RunTime:0.063511s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64819156 LIMIT 2 [ RunTime:0.076989s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64819156 ORDER BY `minOrder` ASC [ RunTime:0.042050s ]
select * from pdf where partno='W3011A-K' and brandshort='Pulse Electronics' limit 1 [ RunTime:0.109548s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'W3011A-K' OR `brand` LIKE 'Pulse Electronics%' ) ) LIMIT 1 [ RunTime:0.043377s ]
SELECT `id` FROM `stock` WHERE `id` <> 64819156 AND `partno` = 'W3011A-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pulse electronics%' ) [ RunTime:0.048272s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12406548 [ RunTime:0.066881s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64230274 LIMIT 5 [ RunTime:0.091997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64230274 ORDER BY `minOrder` ASC [ RunTime:0.093018s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64230274 ORDER BY `unit` DESC [ RunTime:0.066914s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64230274 LIMIT 2 [ RunTime:0.069100s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64230274 ORDER BY `minOrder` ASC [ RunTime:0.019572s ]
select * from pdf where partno='W3011Q' and brandshort='Pulse Electronics' limit 1 [ RunTime:0.064306s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'W3011Q' OR `brand` LIKE 'Pulse Electronics%' ) ) LIMIT 1 [ RunTime:0.048699s ]
SELECT `id` FROM `stock` WHERE `id` <> 64230274 AND `partno` = 'W3011Q' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pulse electronics%' ) [ RunTime:0.021239s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13258289 [ RunTime:0.044505s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58245307 LIMIT 5 [ RunTime:0.071595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58245307 ORDER BY `minOrder` ASC [ RunTime:0.063493s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58245307 ORDER BY `unit` DESC [ RunTime:0.108074s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58245307 LIMIT 2 [ RunTime:0.077596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58245307 ORDER BY `minOrder` ASC [ RunTime:0.027600s ]
select * from pdf where partno='W301112' and brandshort='Mersen USA Newburyport-MA L.L.C.' limit 1 [ RunTime:0.110213s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'W301112' OR `brand` LIKE 'Mersen USA Newburyport-MA L.L.C.%' ) ) LIMIT 1 [ RunTime:0.017512s ]
SELECT `id` FROM `stock` WHERE `id` <> 58245307 AND `partno` = 'W301112' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mersen usa newburyport-ma l.l.c.%' ) [ RunTime:0.054756s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14715874 [ RunTime:0.062678s ]
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 'w3011%' OR `brand` LIKE 'w3011%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.066723s ]
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 'w3011%' OR `brand` LIKE 'w3011%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.090901s ]
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 'w3011%' OR `brand` LIKE 'w3011%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.118577s ]
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 'w3011%' OR `brand` LIKE 'w3011%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.034433s ]
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 'w3011%' OR `brand` LIKE 'w3011%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.067910s ]
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 'w3011%' OR `brand` LIKE 'w3011%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.099621s ]
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 'w3011%' OR `brand` LIKE 'w3011%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.148592s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'w3011%' OR `brand` LIKE 'w3011%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.087815s ]