SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003645s ]
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 'MP400%' OR `brand` LIKE 'MP400%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025437s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001478s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19148030 LIMIT 5 [ RunTime:0.008020s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19148030 ORDER BY `minOrder` ASC [ RunTime:0.032218s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004082s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19148030 ORDER BY `unit` DESC [ RunTime:0.011308s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.031676s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19148030 LIMIT 2 [ RunTime:0.009642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19148030 ORDER BY `minOrder` ASC [ RunTime:0.012731s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14228620 LIMIT 5 [ RunTime:0.021326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14228620 ORDER BY `minOrder` ASC [ RunTime:0.058487s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14228620 ORDER BY `unit` DESC [ RunTime:0.021880s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14228620 LIMIT 2 [ RunTime:0.030527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14228620 ORDER BY `minOrder` ASC [ RunTime:0.025575s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19150790 LIMIT 5 [ RunTime:0.014621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19150790 ORDER BY `minOrder` ASC [ RunTime:0.036741s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19150790 ORDER BY `unit` DESC [ RunTime:0.028779s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19150790 LIMIT 2 [ RunTime:0.009741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19150790 ORDER BY `minOrder` ASC [ RunTime:0.016273s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19149409 LIMIT 5 [ RunTime:0.016722s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19149409 ORDER BY `minOrder` ASC [ RunTime:0.019295s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19149409 ORDER BY `unit` DESC [ RunTime:0.033714s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19149409 LIMIT 2 [ RunTime:0.049892s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19149409 ORDER BY `minOrder` ASC [ RunTime:0.027740s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17179248 LIMIT 5 [ RunTime:0.030338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17179248 ORDER BY `minOrder` ASC [ RunTime:0.033772s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17179248 ORDER BY `unit` DESC [ RunTime:0.011337s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17179248 LIMIT 2 [ RunTime:0.008887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17179248 ORDER BY `minOrder` ASC [ RunTime:0.000263s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16077182 LIMIT 5 [ RunTime:0.000715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16077182 ORDER BY `minOrder` ASC [ RunTime:0.000270s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16077182 ORDER BY `unit` DESC [ RunTime:0.000268s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16077182 LIMIT 2 [ RunTime:0.000415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16077182 ORDER BY `minOrder` ASC [ RunTime:0.007453s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16076500 LIMIT 5 [ RunTime:0.010901s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16076500 ORDER BY `minOrder` ASC [ RunTime:0.018775s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16076500 ORDER BY `unit` DESC [ RunTime:0.011503s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16076500 LIMIT 2 [ RunTime:0.007997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16076500 ORDER BY `minOrder` ASC [ RunTime:0.003582s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16076492 LIMIT 5 [ RunTime:0.003769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16076492 ORDER BY `minOrder` ASC [ RunTime:0.010519s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16076492 ORDER BY `unit` DESC [ RunTime:0.001270s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16076492 LIMIT 2 [ RunTime:0.009583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16076492 ORDER BY `minOrder` ASC [ RunTime:0.012861s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15319159 LIMIT 5 [ RunTime:0.019392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15319159 ORDER BY `minOrder` ASC [ RunTime:0.007204s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15319159 ORDER BY `unit` DESC [ RunTime:0.004776s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15319159 LIMIT 2 [ RunTime:0.007697s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15319159 ORDER BY `minOrder` ASC [ RunTime:0.003572s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14229012 LIMIT 5 [ RunTime:0.004536s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14229012 ORDER BY `minOrder` ASC [ RunTime:0.005172s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14229012 ORDER BY `unit` DESC [ RunTime:0.003954s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14229012 LIMIT 2 [ RunTime:0.003935s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14229012 ORDER BY `minOrder` ASC [ RunTime:0.005371s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11270799 LIMIT 5 [ RunTime:0.014512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11270799 ORDER BY `minOrder` ASC [ RunTime:0.007403s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11270799 ORDER BY `unit` DESC [ RunTime:0.001703s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11270799 LIMIT 2 [ RunTime:0.007409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11270799 ORDER BY `minOrder` ASC [ RunTime:0.004415s ]
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 'MP400%' OR `brand` LIKE 'MP400%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024390s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51053486 LIMIT 5 [ RunTime:0.014391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51053486 ORDER BY `minOrder` ASC [ RunTime:0.012763s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51053486 ORDER BY `unit` DESC [ RunTime:0.014309s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51053486 LIMIT 2 [ RunTime:0.007664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51053486 ORDER BY `minOrder` ASC [ RunTime:0.005339s ]
select * from pdf where partno='mp4001ds-lf-z' and brandshort='monolithic power systems mps' limit 1 [ RunTime:0.003323s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002621s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'mp4001ds-lf-z' OR `brand` LIKE 'monolithic power systems (mps)%' ) ) LIMIT 1 [ RunTime:0.005973s ]
SELECT `id` FROM `stock` WHERE `id` <> 51053486 AND `partno` = 'mp4001ds-lf-z' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%monolithic power systems%' ) [ RunTime:0.008063s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51067305 [ RunTime:0.000768s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14228620 [ RunTime:0.000787s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51067305 LIMIT 5 [ RunTime:0.000702s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51067305 ORDER BY `minOrder` ASC [ RunTime:0.005673s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51067305 ORDER BY `unit` DESC [ RunTime:0.000712s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51067305 LIMIT 2 [ RunTime:0.000656s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51067305 ORDER BY `minOrder` ASC [ RunTime:0.002116s ]
select * from pdf where partno='mp4001ds-lf-z' and brandshort='monolithic power systems mps' limit 1 [ RunTime:0.000504s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'mp4001ds-lf-z' OR `brand` LIKE 'monolithic power systems (mps)%' ) ) LIMIT 1 [ RunTime:0.000485s ]
SELECT `id` FROM `stock` WHERE `id` <> 51067305 AND `partno` = 'mp4001ds-lf-z' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%monolithic power systems%' ) [ RunTime:0.001751s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51053486 [ RunTime:0.002777s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14228620 [ RunTime:0.006452s ]
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 'MP400%' OR `brand` LIKE 'MP400%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007119s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63917591 LIMIT 5 [ RunTime:0.000463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63917591 ORDER BY `minOrder` ASC [ RunTime:0.000851s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63917591 ORDER BY `unit` DESC [ RunTime:0.001480s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63917591 LIMIT 2 [ RunTime:0.006071s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63917591 ORDER BY `minOrder` ASC [ RunTime:0.000393s ]
select * from pdf where partno='MP4008GS-Z' and brandshort='Monolithic Power Systems Inc.' limit 1 [ RunTime:0.003786s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MP4008GS-Z' OR `brand` LIKE 'Monolithic Power Systems Inc.%' ) ) LIMIT 1 [ RunTime:0.009230s ]
SELECT `id` FROM `stock` WHERE `id` <> 63917591 AND `partno` = 'MP4008GS-Z' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%monolithic power systems inc.%' ) [ RunTime:0.004338s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19148030 [ RunTime:0.000593s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63918498 LIMIT 5 [ RunTime:0.006935s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63918498 ORDER BY `minOrder` ASC [ RunTime:0.008208s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63918498 ORDER BY `unit` DESC [ RunTime:0.002858s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63918498 LIMIT 2 [ RunTime:0.000656s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63918498 ORDER BY `minOrder` ASC [ RunTime:0.002091s ]
select * from pdf where partno='MP4001DS-LF-Z' and brandshort='Monolithic Power Systems Inc.' limit 1 [ RunTime:0.001459s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MP4001DS-LF-Z' OR `brand` LIKE 'Monolithic Power Systems Inc.%' ) ) LIMIT 1 [ RunTime:0.002435s ]
SELECT `id` FROM `stock` WHERE `id` <> 63918498 AND `partno` = 'MP4001DS-LF-Z' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%monolithic power systems inc.%' ) [ RunTime:0.004905s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14228620 [ RunTime:0.001165s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63920424 LIMIT 5 [ RunTime:0.000586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63920424 ORDER BY `minOrder` ASC [ RunTime:0.005752s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63920424 ORDER BY `unit` DESC [ RunTime:0.000389s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63920424 LIMIT 2 [ RunTime:0.000525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63920424 ORDER BY `minOrder` ASC [ RunTime:0.002428s ]
select * from pdf where partno='MP4000DS-LF-P' and brandshort='Monolithic Power Systems Inc.' limit 1 [ RunTime:0.000632s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MP4000DS-LF-P' OR `brand` LIKE 'Monolithic Power Systems Inc.%' ) ) LIMIT 1 [ RunTime:0.000391s ]
SELECT `id` FROM `stock` WHERE `id` <> 63920424 AND `partno` = 'MP4000DS-LF-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%monolithic power systems inc.%' ) [ RunTime:0.000420s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15319159 [ RunTime:0.000358s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63920207 LIMIT 5 [ RunTime:0.000515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63920207 ORDER BY `minOrder` ASC [ RunTime:0.005794s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63920207 ORDER BY `unit` DESC [ RunTime:0.004339s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63920207 LIMIT 2 [ RunTime:0.001322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63920207 ORDER BY `minOrder` ASC [ RunTime:0.000565s ]
select * from pdf where partno='MP4000DS-LF-Z' and brandshort='Monolithic Power Systems Inc.' limit 1 [ RunTime:0.003342s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MP4000DS-LF-Z' OR `brand` LIKE 'Monolithic Power Systems Inc.%' ) ) LIMIT 1 [ RunTime:0.002120s ]
SELECT `id` FROM `stock` WHERE `id` <> 63920207 AND `partno` = 'MP4000DS-LF-Z' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%monolithic power systems inc.%' ) [ RunTime:0.002765s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16076500 [ RunTime:0.009105s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63920120 LIMIT 5 [ RunTime:0.001268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63920120 ORDER BY `minOrder` ASC [ RunTime:0.007563s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63920120 ORDER BY `unit` DESC [ RunTime:0.000612s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63920120 LIMIT 2 [ RunTime:0.001960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63920120 ORDER BY `minOrder` ASC [ RunTime:0.006718s ]
select * from pdf where partno='MP4008GS-P' and brandshort='Monolithic Power Systems Inc.' limit 1 [ RunTime:0.010749s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MP4008GS-P' OR `brand` LIKE 'Monolithic Power Systems Inc.%' ) ) LIMIT 1 [ RunTime:0.003827s ]
SELECT `id` FROM `stock` WHERE `id` <> 63920120 AND `partno` = 'MP4008GS-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%monolithic power systems inc.%' ) [ RunTime:0.000995s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16076492 [ RunTime:0.004739s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63920118 LIMIT 5 [ RunTime:0.000758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63920118 ORDER BY `minOrder` ASC [ RunTime:0.000764s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63920118 ORDER BY `unit` DESC [ RunTime:0.001618s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63920118 LIMIT 2 [ RunTime:0.004657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63920118 ORDER BY `minOrder` ASC [ RunTime:0.000514s ]
select * from pdf where partno='MP4001DS-LF-P' and brandshort='Monolithic Power Systems Inc.' limit 1 [ RunTime:0.000873s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MP4001DS-LF-P' OR `brand` LIKE 'Monolithic Power Systems Inc.%' ) ) LIMIT 1 [ RunTime:0.002474s ]
SELECT `id` FROM `stock` WHERE `id` <> 63920118 AND `partno` = 'MP4001DS-LF-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%monolithic power systems inc.%' ) [ RunTime:0.001233s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19149409 [ RunTime:0.007742s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42653414 LIMIT 5 [ RunTime:0.002229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42653414 ORDER BY `minOrder` ASC [ RunTime:0.000499s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42653414 ORDER BY `unit` DESC [ RunTime:0.000429s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42653414 LIMIT 2 [ RunTime:0.001679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42653414 ORDER BY `minOrder` ASC [ RunTime:0.000604s ]
select * from pdf where partno='MP400-E' and brandshort='CTS-Frequency Controls' limit 1 [ RunTime:0.002954s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MP400-E' OR `brand` LIKE 'CTS-Frequency Controls%' ) ) LIMIT 1 [ RunTime:0.000614s ]
SELECT `id` FROM `stock` WHERE `id` <> 42653414 AND `partno` = 'MP400-E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts-frequency controls%' ) [ RunTime:0.000515s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11270799 [ RunTime:0.000512s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42634146 LIMIT 5 [ RunTime:0.003238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42634146 ORDER BY `minOrder` ASC [ RunTime:0.000523s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42634146 ORDER BY `unit` DESC [ RunTime:0.000417s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42634146 LIMIT 2 [ RunTime:0.000717s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42634146 ORDER BY `minOrder` ASC [ RunTime:0.000510s ]
select * from pdf where partno='MP400' and brandshort='CTS-Frequency Controls' limit 1 [ RunTime:0.000571s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MP400' OR `brand` LIKE 'CTS-Frequency Controls%' ) ) LIMIT 1 [ RunTime:0.000473s ]
SELECT `id` FROM `stock` WHERE `id` <> 42634146 AND `partno` = 'MP400' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts-frequency controls%' ) [ RunTime:0.000778s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17179248 [ RunTime:0.000497s ]
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 'MP400%' OR `brand` LIKE 'MP400%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001644s ]
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 'MP400%' OR `brand` LIKE 'MP400%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002872s ]
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 'MP400%' OR `brand` LIKE 'MP400%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004644s ]
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 'MP400%' OR `brand` LIKE 'MP400%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009972s ]
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 'MP400%' OR `brand` LIKE 'MP400%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007705s ]
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 'MP400%' OR `brand` LIKE 'MP400%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002338s ]
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 'MP400%' OR `brand` LIKE 'MP400%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004068s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'MP400%' OR `brand` LIKE 'MP400%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.008986s ]