SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002429s ]
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 'S206%' OR `brand` LIKE 'S206%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024006s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003893s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19666372 LIMIT 5 [ RunTime:0.010909s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.009353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19666372 ORDER BY `minOrder` ASC [ RunTime:0.023920s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001444s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19666372 ORDER BY `unit` DESC [ RunTime:0.040842s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003853s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19666372 LIMIT 2 [ RunTime:0.011619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19666372 ORDER BY `minOrder` ASC [ RunTime:0.000687s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18585902 LIMIT 5 [ RunTime:0.000749s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18585902 ORDER BY `minOrder` ASC [ RunTime:0.005488s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18585902 ORDER BY `unit` DESC [ RunTime:0.001462s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18585902 LIMIT 2 [ RunTime:0.000908s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18585902 ORDER BY `minOrder` ASC [ RunTime:0.008453s ]
select * from pdf where partno='S2065KTP' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.033749s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16003290 LIMIT 5 [ RunTime:0.002408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16003290 ORDER BY `minOrder` ASC [ RunTime:0.016978s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16003290 ORDER BY `unit` DESC [ RunTime:0.005148s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16003290 LIMIT 2 [ RunTime:0.001846s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16003290 ORDER BY `minOrder` ASC [ RunTime:0.006518s ]
select * from pdf where partno='S2065JTP' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.005469s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15178336 LIMIT 5 [ RunTime:0.002650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15178336 ORDER BY `minOrder` ASC [ RunTime:0.009166s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15178336 ORDER BY `unit` DESC [ RunTime:0.003041s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15178336 LIMIT 2 [ RunTime:0.007713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15178336 ORDER BY `minOrder` ASC [ RunTime:0.005027s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13827011 LIMIT 5 [ RunTime:0.008043s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13827011 ORDER BY `minOrder` ASC [ RunTime:0.007470s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13827011 ORDER BY `unit` DESC [ RunTime:0.018155s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13827011 LIMIT 2 [ RunTime:0.000877s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13827011 ORDER BY `minOrder` ASC [ RunTime:0.003805s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12177285 LIMIT 5 [ RunTime:0.001618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12177285 ORDER BY `minOrder` ASC [ RunTime:0.004391s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12177285 ORDER BY `unit` DESC [ RunTime:0.001909s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12177285 LIMIT 2 [ RunTime:0.000714s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12177285 ORDER BY `minOrder` ASC [ RunTime:0.000499s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11190757 LIMIT 5 [ RunTime:0.001572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11190757 ORDER BY `minOrder` ASC [ RunTime:0.008084s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11190757 ORDER BY `unit` DESC [ RunTime:0.007355s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11190757 LIMIT 2 [ RunTime:0.002866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11190757 ORDER BY `minOrder` ASC [ RunTime:0.000465s ]
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 'S206%' OR `brand` LIKE 'S206%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002071s ]
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 'S206%' OR `brand` LIKE 'S206%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008572s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49473818 LIMIT 5 [ RunTime:0.000753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49473818 ORDER BY `minOrder` ASC [ RunTime:0.018787s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49473818 ORDER BY `unit` DESC [ RunTime:0.009840s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49473818 LIMIT 2 [ RunTime:0.014292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49473818 ORDER BY `minOrder` ASC [ RunTime:0.000542s ]
select * from pdf where partno='S206SP' and brandshort='Seek Thermal' limit 1 [ RunTime:0.006103s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002694s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'S206SP' OR `brand` LIKE 'Seek Thermal%' ) ) LIMIT 1 [ RunTime:0.003626s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36667654 LIMIT 5 [ RunTime:0.007755s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36667654 ORDER BY `minOrder` ASC [ RunTime:0.003151s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36667654 ORDER BY `unit` DESC [ RunTime:0.002314s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36667654 LIMIT 2 [ RunTime:0.002447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36667654 ORDER BY `minOrder` ASC [ RunTime:0.000457s ]
select * from pdf where partno='S206SP' and brandshort='Seek Thermal' limit 1 [ RunTime:0.000588s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'S206SP' OR `brand` LIKE 'Seek Thermal%' ) ) LIMIT 1 [ RunTime:0.003413s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51756953 LIMIT 5 [ RunTime:0.005560s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51756953 ORDER BY `minOrder` ASC [ RunTime:0.003051s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51756953 ORDER BY `unit` DESC [ RunTime:0.005192s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51756953 LIMIT 2 [ RunTime:0.005185s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51756953 ORDER BY `minOrder` ASC [ RunTime:0.006839s ]
select * from pdf where partno='S2065J' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.005651s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'S2065J' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.003364s ]
SELECT `id` FROM `stock` WHERE `id` <> 51756953 AND `partno` = 'S2065J' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.002227s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15178336 [ RunTime:0.000433s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51706575 LIMIT 5 [ RunTime:0.008693s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51706575 ORDER BY `minOrder` ASC [ RunTime:0.029922s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51706575 ORDER BY `unit` DESC [ RunTime:0.006500s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51706575 LIMIT 2 [ RunTime:0.000692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51706575 ORDER BY `minOrder` ASC [ RunTime:0.002996s ]
select * from pdf where partno='S206E' and brandshort='Swanstrom Tools USA' limit 1 [ RunTime:0.008443s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'S206E' OR `brand` LIKE 'Swanstrom Tools USA%' ) ) LIMIT 1 [ RunTime:0.009841s ]
SELECT `id` FROM `stock` WHERE `id` <> 51706575 AND `partno` = 'S206E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%swanstrom tools usa%' ) [ RunTime:0.001426s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12177285 [ RunTime:0.000792s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51706478 LIMIT 5 [ RunTime:0.005863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51706478 ORDER BY `minOrder` ASC [ RunTime:0.012829s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51706478 ORDER BY `unit` DESC [ RunTime:0.012235s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51706478 LIMIT 2 [ RunTime:0.002242s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51706478 ORDER BY `minOrder` ASC [ RunTime:0.000958s ]
select * from pdf where partno='S206' and brandshort='Swanstrom Tools USA' limit 1 [ RunTime:0.000479s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'S206' OR `brand` LIKE 'Swanstrom Tools USA%' ) ) LIMIT 1 [ RunTime:0.000470s ]
SELECT `id` FROM `stock` WHERE `id` <> 51706478 AND `partno` = 'S206' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%swanstrom tools usa%' ) [ RunTime:0.001014s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11190757 [ RunTime:0.008766s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51349775 LIMIT 5 [ RunTime:0.000683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51349775 ORDER BY `minOrder` ASC [ RunTime:0.002870s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51349775 ORDER BY `unit` DESC [ RunTime:0.008620s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51349775 LIMIT 2 [ RunTime:0.010974s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51349775 ORDER BY `minOrder` ASC [ RunTime:0.001613s ]
select * from pdf where partno='S206901' and brandshort='Mersen USA Newburyport-MA L.L.C.' limit 1 [ RunTime:0.004020s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'S206901' OR `brand` LIKE 'Mersen USA Newburyport-MA L.L.C.%' ) ) LIMIT 1 [ RunTime:0.005844s ]
SELECT `id` FROM `stock` WHERE `id` <> 51349775 AND `partno` = 'S206901' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mersen usa newburyport-ma l.l.c.%' ) [ RunTime:0.002953s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13827011 [ RunTime:0.014500s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44114824 LIMIT 5 [ RunTime:0.000417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44114824 ORDER BY `minOrder` ASC [ RunTime:0.000321s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44114824 ORDER BY `unit` DESC [ RunTime:0.000297s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44114824 LIMIT 2 [ RunTime:0.000270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44114824 ORDER BY `minOrder` ASC [ RunTime:0.000286s ]
select * from pdf where partno='S2060' and brandshort='Microchip Technology' limit 1 [ RunTime:0.000322s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'S2060' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.000321s ]
SELECT `id` FROM `stock` WHERE `id` <> 44114824 AND `partno` = 'S2060' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.001709s ]
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 'S206%' OR `brand` LIKE 'S206%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001442s ]
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 'S206%' OR `brand` LIKE 'S206%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001060s ]
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 'S206%' OR `brand` LIKE 'S206%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015934s ]
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 'S206%' OR `brand` LIKE 'S206%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005080s ]
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 'S206%' OR `brand` LIKE 'S206%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009733s ]
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 'S206%' OR `brand` LIKE 'S206%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002415s ]
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 'S206%' OR `brand` LIKE 'S206%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004823s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'S206%' OR `brand` LIKE 'S206%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.009098s ]