SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002323s ]
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 'BB15AB%' OR `brand` LIKE 'BB15AB%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021185s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002175s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12441624 LIMIT 5 [ RunTime:0.039857s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.021359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12441624 ORDER BY `minOrder` ASC [ RunTime:0.030615s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.030132s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12441624 ORDER BY `unit` DESC [ RunTime:0.038676s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.010375s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12441624 LIMIT 2 [ RunTime:0.029493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12441624 ORDER BY `minOrder` ASC [ RunTime:0.049443s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12441612 LIMIT 5 [ RunTime:0.007966s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12441612 ORDER BY `minOrder` ASC [ RunTime:0.004667s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12441612 ORDER BY `unit` DESC [ RunTime:0.015243s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12441612 LIMIT 2 [ RunTime:0.012188s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12441612 ORDER BY `minOrder` ASC [ RunTime:0.034520s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17284801 LIMIT 5 [ RunTime:0.086214s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17284801 ORDER BY `minOrder` ASC [ RunTime:0.040146s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17284801 ORDER BY `unit` DESC [ RunTime:0.083573s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17284801 LIMIT 2 [ RunTime:0.035733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17284801 ORDER BY `minOrder` ASC [ RunTime:0.025020s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17272355 LIMIT 5 [ RunTime:0.029172s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17272355 ORDER BY `minOrder` ASC [ RunTime:0.039024s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17272355 ORDER BY `unit` DESC [ RunTime:0.045025s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17272355 LIMIT 2 [ RunTime:0.167872s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17272355 ORDER BY `minOrder` ASC [ RunTime:0.027321s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12415976 LIMIT 5 [ RunTime:0.137848s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12415976 ORDER BY `minOrder` ASC [ RunTime:0.059921s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12415976 ORDER BY `unit` DESC [ RunTime:0.055976s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12415976 LIMIT 2 [ RunTime:0.049481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12415976 ORDER BY `minOrder` ASC [ RunTime:0.038559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12415973 LIMIT 5 [ RunTime:0.104172s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12415973 ORDER BY `minOrder` ASC [ RunTime:0.032539s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12415973 ORDER BY `unit` DESC [ RunTime:0.046235s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12415973 LIMIT 2 [ RunTime:0.097809s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12415973 ORDER BY `minOrder` ASC [ RunTime:0.017457s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12415015 LIMIT 5 [ RunTime:0.060409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12415015 ORDER BY `minOrder` ASC [ RunTime:0.021275s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12415015 ORDER BY `unit` DESC [ RunTime:0.009027s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12415015 LIMIT 2 [ RunTime:0.023421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12415015 ORDER BY `minOrder` ASC [ RunTime:0.052527s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12414945 LIMIT 5 [ RunTime:0.042423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12414945 ORDER BY `minOrder` ASC [ RunTime:0.035953s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12414945 ORDER BY `unit` DESC [ RunTime:0.004899s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12414945 LIMIT 2 [ RunTime:0.025590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12414945 ORDER BY `minOrder` ASC [ RunTime:0.013580s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11349557 LIMIT 5 [ RunTime:0.040183s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11349557 ORDER BY `minOrder` ASC [ RunTime:0.020524s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11349557 ORDER BY `unit` DESC [ RunTime:0.020151s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11349557 LIMIT 2 [ RunTime:0.047467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11349557 ORDER BY `minOrder` ASC [ RunTime:0.017289s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11349552 LIMIT 5 [ RunTime:0.019230s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11349552 ORDER BY `minOrder` ASC [ RunTime:0.022546s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11349552 ORDER BY `unit` DESC [ RunTime:0.033987s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11349552 LIMIT 2 [ RunTime:0.039006s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11349552 ORDER BY `minOrder` ASC [ RunTime:0.009986s ]
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 'BB15AB%' OR `brand` LIKE 'BB15AB%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025718s ]
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 'BB15AB%' OR `brand` LIKE 'BB15AB%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.103203s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43824735 LIMIT 5 [ RunTime:0.075661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43824735 ORDER BY `minOrder` ASC [ RunTime:0.077885s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43824735 ORDER BY `unit` DESC [ RunTime:0.014432s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43824735 LIMIT 2 [ RunTime:0.018192s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43824735 ORDER BY `minOrder` ASC [ RunTime:0.019544s ]
select * from pdf where partno='BB15AB-HA' and brandshort='NKK Switches' limit 1 [ RunTime:0.026590s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002215s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BB15AB-HA' OR `brand` LIKE 'NKK Switches%' ) ) LIMIT 1 [ RunTime:0.036574s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43824715 LIMIT 5 [ RunTime:0.003800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43824715 ORDER BY `minOrder` ASC [ RunTime:0.003762s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43824715 ORDER BY `unit` DESC [ RunTime:0.004366s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43824715 LIMIT 2 [ RunTime:0.005885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43824715 ORDER BY `minOrder` ASC [ RunTime:0.006810s ]
select * from pdf where partno='BB15AB/328-HA' and brandshort='NKK Switches' limit 1 [ RunTime:0.007180s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BB15AB/328-HA' OR `brand` LIKE 'NKK Switches%' ) ) LIMIT 1 [ RunTime:0.011662s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43825790 LIMIT 5 [ RunTime:0.002758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43825790 ORDER BY `minOrder` ASC [ RunTime:0.019605s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43825790 ORDER BY `unit` DESC [ RunTime:0.000528s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43825790 LIMIT 2 [ RunTime:0.018883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43825790 ORDER BY `minOrder` ASC [ RunTime:0.003865s ]
select * from pdf where partno='BB15AB-HC' and brandshort='NKK Switches' limit 1 [ RunTime:0.016044s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BB15AB-HC' OR `brand` LIKE 'NKK Switches%' ) ) LIMIT 1 [ RunTime:0.024991s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43825788 LIMIT 5 [ RunTime:0.017598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43825788 ORDER BY `minOrder` ASC [ RunTime:0.027447s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43825788 ORDER BY `unit` DESC [ RunTime:0.025226s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43825788 LIMIT 2 [ RunTime:0.024308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43825788 ORDER BY `minOrder` ASC [ RunTime:0.002280s ]
select * from pdf where partno='BB15AB-FB' and brandshort='NKK Switches' limit 1 [ RunTime:0.004607s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BB15AB-FB' OR `brand` LIKE 'NKK Switches%' ) ) LIMIT 1 [ RunTime:0.004648s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43825786 LIMIT 5 [ RunTime:0.000887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43825786 ORDER BY `minOrder` ASC [ RunTime:0.005125s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43825786 ORDER BY `unit` DESC [ RunTime:0.014526s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43825786 LIMIT 2 [ RunTime:0.015335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43825786 ORDER BY `minOrder` ASC [ RunTime:0.001375s ]
select * from pdf where partno='BB15AB-FC' and brandshort='NKK Switches' limit 1 [ RunTime:0.002680s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BB15AB-FC' OR `brand` LIKE 'NKK Switches%' ) ) LIMIT 1 [ RunTime:0.003937s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43825785 LIMIT 5 [ RunTime:0.012827s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43825785 ORDER BY `minOrder` ASC [ RunTime:0.011208s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43825785 ORDER BY `unit` DESC [ RunTime:0.008655s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43825785 LIMIT 2 [ RunTime:0.005016s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43825785 ORDER BY `minOrder` ASC [ RunTime:0.003624s ]
select * from pdf where partno='BB15AB-FA' and brandshort='NKK Switches' limit 1 [ RunTime:0.005129s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BB15AB-FA' OR `brand` LIKE 'NKK Switches%' ) ) LIMIT 1 [ RunTime:0.008201s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43825775 LIMIT 5 [ RunTime:0.009739s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43825775 ORDER BY `minOrder` ASC [ RunTime:0.009580s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43825775 ORDER BY `unit` DESC [ RunTime:0.010686s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43825775 LIMIT 2 [ RunTime:0.008457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43825775 ORDER BY `minOrder` ASC [ RunTime:0.017948s ]
select * from pdf where partno='BB15AB-HB' and brandshort='NKK Switches' limit 1 [ RunTime:0.015198s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BB15AB-HB' OR `brand` LIKE 'NKK Switches%' ) ) LIMIT 1 [ RunTime:0.026903s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43825770 LIMIT 5 [ RunTime:0.015591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43825770 ORDER BY `minOrder` ASC [ RunTime:0.047342s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43825770 ORDER BY `unit` DESC [ RunTime:0.026548s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43825770 LIMIT 2 [ RunTime:0.022192s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43825770 ORDER BY `minOrder` ASC [ RunTime:0.020039s ]
select * from pdf where partno='BB15AB1' and brandshort='NKK Switches' limit 1 [ RunTime:0.011509s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BB15AB1' OR `brand` LIKE 'NKK Switches%' ) ) LIMIT 1 [ RunTime:0.026814s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43825759 LIMIT 5 [ RunTime:0.031442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43825759 ORDER BY `minOrder` ASC [ RunTime:0.028275s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43825759 ORDER BY `unit` DESC [ RunTime:0.006773s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43825759 LIMIT 2 [ RunTime:0.000570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43825759 ORDER BY `minOrder` ASC [ RunTime:0.002635s ]
select * from pdf where partno='BB15AB/328' and brandshort='NKK Switches' limit 1 [ RunTime:0.030206s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BB15AB/328' OR `brand` LIKE 'NKK Switches%' ) ) LIMIT 1 [ RunTime:0.031273s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43824703 LIMIT 5 [ RunTime:0.034996s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43824703 ORDER BY `minOrder` ASC [ RunTime:0.035053s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43824703 ORDER BY `unit` DESC [ RunTime:0.000878s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43824703 LIMIT 2 [ RunTime:0.014235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43824703 ORDER BY `minOrder` ASC [ RunTime:0.055101s ]
select * from pdf where partno='BB15AB' and brandshort='NKK Switches' limit 1 [ RunTime:0.051587s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BB15AB' OR `brand` LIKE 'NKK Switches%' ) ) LIMIT 1 [ RunTime:0.023982s ]
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 'BB15AB%' OR `brand` LIKE 'BB15AB%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.085009s ]
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 'BB15AB%' OR `brand` LIKE 'BB15AB%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.065603s ]
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 'BB15AB%' OR `brand` LIKE 'BB15AB%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037651s ]
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 'BB15AB%' OR `brand` LIKE 'BB15AB%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020634s ]
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 'BB15AB%' OR `brand` LIKE 'BB15AB%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.064175s ]
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 'BB15AB%' OR `brand` LIKE 'BB15AB%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028104s ]
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 'BB15AB%' OR `brand` LIKE 'BB15AB%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.038586s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'BB15AB%' OR `brand` LIKE 'BB15AB%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.054311s ]