SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002976s ]
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 'XBI%' OR `brand` LIKE 'XBI%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020913s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.021591s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12405725 LIMIT 5 [ RunTime:0.050666s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.019575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12405725 ORDER BY `minOrder` ASC [ RunTime:0.022854s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005545s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12405725 ORDER BY `unit` DESC [ RunTime:0.057639s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.014883s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12405725 LIMIT 2 [ RunTime:0.060169s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12405725 ORDER BY `minOrder` ASC [ RunTime:0.029521s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12407384 LIMIT 5 [ RunTime:0.028170s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12407384 ORDER BY `minOrder` ASC [ RunTime:0.038209s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12407384 ORDER BY `unit` DESC [ RunTime:0.034681s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12407384 LIMIT 2 [ RunTime:0.026465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12407384 ORDER BY `minOrder` ASC [ RunTime:0.024627s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12409574 LIMIT 5 [ RunTime:0.037993s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12409574 ORDER BY `minOrder` ASC [ RunTime:0.015457s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12409574 ORDER BY `unit` DESC [ RunTime:0.016935s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12409574 LIMIT 2 [ RunTime:0.024158s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12409574 ORDER BY `minOrder` ASC [ RunTime:0.003841s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12406250 LIMIT 5 [ RunTime:0.018205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12406250 ORDER BY `minOrder` ASC [ RunTime:0.020725s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12406250 ORDER BY `unit` DESC [ RunTime:0.038253s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12406250 LIMIT 2 [ RunTime:0.027079s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12406250 ORDER BY `minOrder` ASC [ RunTime:0.024073s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12407843 LIMIT 5 [ RunTime:0.022972s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12407843 ORDER BY `minOrder` ASC [ RunTime:0.032445s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12407843 ORDER BY `unit` DESC [ RunTime:0.028666s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12407843 LIMIT 2 [ RunTime:0.013930s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12407843 ORDER BY `minOrder` ASC [ RunTime:0.022917s ]
select * from pdf where partno='XBIB-U-SS' and brandshort='Digi' limit 1 [ RunTime:0.039730s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18914457 LIMIT 5 [ RunTime:0.043551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18914457 ORDER BY `minOrder` ASC [ RunTime:0.055571s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18914457 ORDER BY `unit` DESC [ RunTime:0.053268s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18914457 LIMIT 2 [ RunTime:0.060471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18914457 ORDER BY `minOrder` ASC [ RunTime:0.031577s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12409617 LIMIT 5 [ RunTime:0.028835s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12409617 ORDER BY `minOrder` ASC [ RunTime:0.019286s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12409617 ORDER BY `unit` DESC [ RunTime:0.040548s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12409617 LIMIT 2 [ RunTime:0.057109s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12409617 ORDER BY `minOrder` ASC [ RunTime:0.013193s ]
select * from pdf where partno='XBIB-R' and brandshort='Digi' limit 1 [ RunTime:0.078143s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12407845 LIMIT 5 [ RunTime:0.076398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12407845 ORDER BY `minOrder` ASC [ RunTime:0.039436s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12407845 ORDER BY `unit` DESC [ RunTime:0.138515s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12407845 LIMIT 2 [ RunTime:0.111795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12407845 ORDER BY `minOrder` ASC [ RunTime:0.094477s ]
select * from pdf where partno='XBIB-U-DEV' and brandshort='Digi' limit 1 [ RunTime:0.072969s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12407844 LIMIT 5 [ RunTime:0.057696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12407844 ORDER BY `minOrder` ASC [ RunTime:0.066582s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12407844 ORDER BY `unit` DESC [ RunTime:0.080105s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12407844 LIMIT 2 [ RunTime:0.194452s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12407844 ORDER BY `minOrder` ASC [ RunTime:0.028228s ]
select * from pdf where partno='XBIB-R-DEV' and brandshort='Digi' limit 1 [ RunTime:0.051344s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11344804 LIMIT 5 [ RunTime:0.063689s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11344804 ORDER BY `minOrder` ASC [ RunTime:0.125881s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11344804 ORDER BY `unit` DESC [ RunTime:0.204869s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11344804 LIMIT 2 [ RunTime:0.151013s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11344804 ORDER BY `minOrder` ASC [ RunTime:0.003104s ]
select * from pdf where partno='XBIB-U' and brandshort='Digi' limit 1 [ RunTime:0.051351s ]
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 'XBI%' OR `brand` LIKE 'XBI%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.034854s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51108131 LIMIT 5 [ RunTime:0.034759s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51108131 ORDER BY `minOrder` ASC [ RunTime:0.081056s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51108131 ORDER BY `unit` DESC [ RunTime:0.147224s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51108131 LIMIT 2 [ RunTime:0.051279s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51108131 ORDER BY `minOrder` ASC [ RunTime:0.030593s ]
select * from pdf where partno='xbib-cu-th' and brandshort='digi' limit 1 [ RunTime:0.064254s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002647s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'xbib-cu-th' OR `brand` LIKE 'digi%' ) ) LIMIT 1 [ RunTime:0.123734s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51112165 LIMIT 5 [ RunTime:0.050115s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51112165 ORDER BY `minOrder` ASC [ RunTime:0.089219s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51112165 ORDER BY `unit` DESC [ RunTime:0.072257s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51112165 LIMIT 2 [ RunTime:0.093386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51112165 ORDER BY `minOrder` ASC [ RunTime:0.119580s ]
select * from pdf where partno='xbib-u' and brandshort='digi' limit 1 [ RunTime:0.095114s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'xbib-u' OR `brand` LIKE 'digi%' ) ) LIMIT 1 [ RunTime:0.120945s ]
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 'XBI%' OR `brand` LIKE 'XBI%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.144272s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64817131 LIMIT 5 [ RunTime:0.039704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64817131 ORDER BY `minOrder` ASC [ RunTime:0.049746s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64817131 ORDER BY `unit` DESC [ RunTime:0.026785s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64817131 LIMIT 2 [ RunTime:0.065323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64817131 ORDER BY `minOrder` ASC [ RunTime:0.035695s ]
select * from pdf where partno='XBIB-C-GPS' and brandshort='Digi' limit 1 [ RunTime:0.029753s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'XBIB-C-GPS' OR `brand` LIKE 'Digi%' ) ) LIMIT 1 [ RunTime:0.030554s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64816848 LIMIT 5 [ RunTime:0.106962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64816848 ORDER BY `minOrder` ASC [ RunTime:0.062862s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64816848 ORDER BY `unit` DESC [ RunTime:0.031539s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64816848 LIMIT 2 [ RunTime:0.023153s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64816848 ORDER BY `minOrder` ASC [ RunTime:0.013007s ]
select * from pdf where partno='XBIB-CU-TH' and brandshort='Digi' limit 1 [ RunTime:0.017044s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'XBIB-CU-TH' OR `brand` LIKE 'Digi%' ) ) LIMIT 1 [ RunTime:0.051593s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64816981 LIMIT 5 [ RunTime:0.060189s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64816981 ORDER BY `minOrder` ASC [ RunTime:0.047398s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64816981 ORDER BY `unit` DESC [ RunTime:0.068708s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64816981 LIMIT 2 [ RunTime:0.032772s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64816981 ORDER BY `minOrder` ASC [ RunTime:0.050400s ]
select * from pdf where partno='XBIB-C-SMT' and brandshort='Digi' limit 1 [ RunTime:0.023202s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'XBIB-C-SMT' OR `brand` LIKE 'Digi%' ) ) LIMIT 1 [ RunTime:0.082554s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64816982 LIMIT 5 [ RunTime:0.103285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64816982 ORDER BY `minOrder` ASC [ RunTime:0.070551s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64816982 ORDER BY `unit` DESC [ RunTime:0.121960s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64816982 LIMIT 2 [ RunTime:0.070726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64816982 ORDER BY `minOrder` ASC [ RunTime:0.063535s ]
select * from pdf where partno='XBIB-C-MMT' and brandshort='Digi' limit 1 [ RunTime:0.017013s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'XBIB-C-MMT' OR `brand` LIKE 'Digi%' ) ) LIMIT 1 [ RunTime:0.118836s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64821474 LIMIT 5 [ RunTime:0.101002s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64821474 ORDER BY `minOrder` ASC [ RunTime:0.110995s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64821474 ORDER BY `unit` DESC [ RunTime:0.113344s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64821474 LIMIT 2 [ RunTime:0.043530s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64821474 ORDER BY `minOrder` ASC [ RunTime:0.019992s ]
select * from pdf where partno='XBIB-U-DEV' and brandshort='Digi' limit 1 [ RunTime:0.012651s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'XBIB-U-DEV' OR `brand` LIKE 'Digi%' ) ) LIMIT 1 [ RunTime:0.018138s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64821473 LIMIT 5 [ RunTime:0.058362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64821473 ORDER BY `minOrder` ASC [ RunTime:0.076391s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64821473 ORDER BY `unit` DESC [ RunTime:0.048678s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64821473 LIMIT 2 [ RunTime:0.048045s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64821473 ORDER BY `minOrder` ASC [ RunTime:0.023994s ]
select * from pdf where partno='XBIB-R-DEV' and brandshort='Digi' limit 1 [ RunTime:0.052903s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'XBIB-R-DEV' OR `brand` LIKE 'Digi%' ) ) LIMIT 1 [ RunTime:0.023061s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64821407 LIMIT 5 [ RunTime:0.066426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64821407 ORDER BY `minOrder` ASC [ RunTime:0.104258s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64821407 ORDER BY `unit` DESC [ RunTime:0.060442s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64821407 LIMIT 2 [ RunTime:0.015203s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64821407 ORDER BY `minOrder` ASC [ RunTime:0.101930s ]
select * from pdf where partno='XBIB-U' and brandshort='Digi' limit 1 [ RunTime:0.040703s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'XBIB-U' OR `brand` LIKE 'Digi%' ) ) LIMIT 1 [ RunTime:0.125300s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58119058 LIMIT 5 [ RunTime:0.123419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58119058 ORDER BY `minOrder` ASC [ RunTime:0.106155s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58119058 ORDER BY `unit` DESC [ RunTime:0.082623s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58119058 LIMIT 2 [ RunTime:0.183373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58119058 ORDER BY `minOrder` ASC [ RunTime:0.064044s ]
select * from pdf where partno='XBI' and brandshort='Matrix Orbital' limit 1 [ RunTime:0.122431s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'XBI' OR `brand` LIKE 'Matrix Orbital%' ) ) LIMIT 1 [ RunTime:0.066375s ]
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 'XBI%' OR `brand` LIKE 'XBI%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026778s ]
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 'XBI%' OR `brand` LIKE 'XBI%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.117709s ]
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 'XBI%' OR `brand` LIKE 'XBI%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.044164s ]
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 'XBI%' OR `brand` LIKE 'XBI%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018421s ]
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 'XBI%' OR `brand` LIKE 'XBI%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.043680s ]
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 'XBI%' OR `brand` LIKE 'XBI%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.057130s ]
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 'XBI%' OR `brand` LIKE 'XBI%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.110593s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'XBI%' OR `brand` LIKE 'XBI%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.086032s ]