SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002295s ]
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 '12313%' OR `brand` LIKE '12313%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.041381s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.019957s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12066785 LIMIT 5 [ RunTime:0.028552s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002070s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12066785 ORDER BY `minOrder` ASC [ RunTime:0.020145s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.040435s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12066785 ORDER BY `unit` DESC [ RunTime:0.017759s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.008326s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12066785 LIMIT 2 [ RunTime:0.088056s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12066785 ORDER BY `minOrder` ASC [ RunTime:0.058520s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12561838 LIMIT 5 [ RunTime:0.063660s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12561838 ORDER BY `minOrder` ASC [ RunTime:0.037162s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12561838 ORDER BY `unit` DESC [ RunTime:0.007259s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12561838 LIMIT 2 [ RunTime:0.016012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12561838 ORDER BY `minOrder` ASC [ RunTime:0.020362s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18926988 LIMIT 5 [ RunTime:0.023986s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18926988 ORDER BY `minOrder` ASC [ RunTime:0.012047s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18926988 ORDER BY `unit` DESC [ RunTime:0.011485s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18926988 LIMIT 2 [ RunTime:0.029942s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18926988 ORDER BY `minOrder` ASC [ RunTime:0.013753s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18922829 LIMIT 5 [ RunTime:0.010470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18922829 ORDER BY `minOrder` ASC [ RunTime:0.036491s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18922829 ORDER BY `unit` DESC [ RunTime:0.030367s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18922829 LIMIT 2 [ RunTime:0.015674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18922829 ORDER BY `minOrder` ASC [ RunTime:0.009861s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18922426 LIMIT 5 [ RunTime:0.015431s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18922426 ORDER BY `minOrder` ASC [ RunTime:0.022187s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18922426 ORDER BY `unit` DESC [ RunTime:0.003358s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18922426 LIMIT 2 [ RunTime:0.004602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18922426 ORDER BY `minOrder` ASC [ RunTime:0.003159s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17309946 LIMIT 5 [ RunTime:0.005357s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17309946 ORDER BY `minOrder` ASC [ RunTime:0.019041s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17309946 ORDER BY `unit` DESC [ RunTime:0.015519s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17309946 LIMIT 2 [ RunTime:0.015554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17309946 ORDER BY `minOrder` ASC [ RunTime:0.009325s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17036965 LIMIT 5 [ RunTime:0.001534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17036965 ORDER BY `minOrder` ASC [ RunTime:0.008990s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17036965 ORDER BY `unit` DESC [ RunTime:0.004383s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17036965 LIMIT 2 [ RunTime:0.012274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17036965 ORDER BY `minOrder` ASC [ RunTime:0.013508s ]
select * from pdf where partno='123136312113' and brandshort='Dialight' limit 1 [ RunTime:0.008132s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15451494 LIMIT 5 [ RunTime:0.009594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15451494 ORDER BY `minOrder` ASC [ RunTime:0.011342s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15451494 ORDER BY `unit` DESC [ RunTime:0.022678s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15451494 LIMIT 2 [ RunTime:0.009958s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15451494 ORDER BY `minOrder` ASC [ RunTime:0.003129s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14409319 LIMIT 5 [ RunTime:0.002599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14409319 ORDER BY `minOrder` ASC [ RunTime:0.007865s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14409319 ORDER BY `unit` DESC [ RunTime:0.000562s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14409319 LIMIT 2 [ RunTime:0.000709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14409319 ORDER BY `minOrder` ASC [ RunTime:0.006699s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12185138 LIMIT 5 [ RunTime:0.016992s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12185138 ORDER BY `minOrder` ASC [ RunTime:0.007872s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12185138 ORDER BY `unit` DESC [ RunTime:0.008098s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12185138 LIMIT 2 [ RunTime:0.000849s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12185138 ORDER BY `minOrder` ASC [ RunTime:0.004208s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11438951 LIMIT 5 [ RunTime:0.015398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11438951 ORDER BY `minOrder` ASC [ RunTime:0.004003s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11438951 ORDER BY `unit` DESC [ RunTime:0.009529s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11438951 LIMIT 2 [ RunTime:0.005102s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11438951 ORDER BY `minOrder` ASC [ RunTime:0.003077s ]
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 '12313%' OR `brand` LIKE '12313%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001374s ]
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 '12313%' OR `brand` LIKE '12313%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009815s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64565608 LIMIT 5 [ RunTime:0.004884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64565608 ORDER BY `minOrder` ASC [ RunTime:0.002583s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64565608 ORDER BY `unit` DESC [ RunTime:0.013644s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64565608 LIMIT 2 [ RunTime:0.000779s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64565608 ORDER BY `minOrder` ASC [ RunTime:0.002553s ]
select * from pdf where partno='12313CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.006356s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002520s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '12313CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.009347s ]
SELECT `id` FROM `stock` WHERE `id` <> 64565608 AND `partno` = '12313CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.009471s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12066785 [ RunTime:0.007234s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63130698 LIMIT 5 [ RunTime:0.000516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63130698 ORDER BY `minOrder` ASC [ RunTime:0.000345s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63130698 ORDER BY `unit` DESC [ RunTime:0.000320s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63130698 LIMIT 2 [ RunTime:0.000429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63130698 ORDER BY `minOrder` ASC [ RunTime:0.000866s ]
select * from pdf where partno='12313' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.000499s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '12313' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.000302s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60588816 LIMIT 5 [ RunTime:0.000497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60588816 ORDER BY `minOrder` ASC [ RunTime:0.004416s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60588816 ORDER BY `unit` DESC [ RunTime:0.000316s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60588816 LIMIT 2 [ RunTime:0.000448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60588816 ORDER BY `minOrder` ASC [ RunTime:0.000288s ]
select * from pdf where partno='12313.1' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.007035s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '12313.1' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.000286s ]
SELECT `id` FROM `stock` WHERE `id` <> 60588816 AND `partno` = '12313.1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.000304s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11438951 [ RunTime:0.000267s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60545940 LIMIT 5 [ RunTime:0.001851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60545940 ORDER BY `minOrder` ASC [ RunTime:0.000964s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60545940 ORDER BY `unit` DESC [ RunTime:0.002547s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60545940 LIMIT 2 [ RunTime:0.000451s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60545940 ORDER BY `minOrder` ASC [ RunTime:0.001311s ]
select * from pdf where partno='1231380000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000832s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1231380000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.008378s ]
SELECT `id` FROM `stock` WHERE `id` <> 60545940 AND `partno` = '1231380000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.007817s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15451494 [ RunTime:0.002009s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60542311 LIMIT 5 [ RunTime:0.004321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60542311 ORDER BY `minOrder` ASC [ RunTime:0.007226s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60542311 ORDER BY `unit` DESC [ RunTime:0.003143s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60542311 LIMIT 2 [ RunTime:0.006280s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60542311 ORDER BY `minOrder` ASC [ RunTime:0.000229s ]
select * from pdf where partno='1231360000' and brandshort='Weidmüller' limit 1 [ RunTime:0.002727s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1231360000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.000843s ]
SELECT `id` FROM `stock` WHERE `id` <> 60542311 AND `partno` = '1231360000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.004063s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17309946 [ RunTime:0.005057s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60475579 LIMIT 5 [ RunTime:0.000361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60475579 ORDER BY `minOrder` ASC [ RunTime:0.011683s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60475579 ORDER BY `unit` DESC [ RunTime:0.001605s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60475579 LIMIT 2 [ RunTime:0.008234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60475579 ORDER BY `minOrder` ASC [ RunTime:0.006575s ]
select * from pdf where partno='1231330000' and brandshort='Weidmüller' limit 1 [ RunTime:0.007857s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1231330000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.006983s ]
SELECT `id` FROM `stock` WHERE `id` <> 60475579 AND `partno` = '1231330000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.007522s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12561838 [ RunTime:0.002151s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58552247 LIMIT 5 [ RunTime:0.000643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58552247 ORDER BY `minOrder` ASC [ RunTime:0.007691s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58552247 ORDER BY `unit` DESC [ RunTime:0.000970s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58552247 LIMIT 2 [ RunTime:0.001758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58552247 ORDER BY `minOrder` ASC [ RunTime:0.000430s ]
select * from pdf where partno='12313G' and brandshort='Greenlee Communications' limit 1 [ RunTime:0.002111s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '12313G' OR `brand` LIKE 'Greenlee Communications%' ) ) LIMIT 1 [ RunTime:0.004086s ]
SELECT `id` FROM `stock` WHERE `id` <> 58552247 AND `partno` = '12313G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%greenlee communications%' ) [ RunTime:0.001087s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12185138 [ RunTime:0.002139s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41409766 LIMIT 5 [ RunTime:0.003768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41409766 ORDER BY `minOrder` ASC [ RunTime:0.007208s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41409766 ORDER BY `unit` DESC [ RunTime:0.004184s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41409766 LIMIT 2 [ RunTime:0.000935s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41409766 ORDER BY `minOrder` ASC [ RunTime:0.000441s ]
select * from pdf where partno='123131012103' and brandshort='Dialight' limit 1 [ RunTime:0.000864s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '123131012103' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.005738s ]
SELECT `id` FROM `stock` WHERE `id` <> 41409766 AND `partno` = '123131012103' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.011280s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18926988 [ RunTime:0.000663s ]
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 '12313%' OR `brand` LIKE '12313%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011071s ]
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 '12313%' OR `brand` LIKE '12313%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004237s ]
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 '12313%' OR `brand` LIKE '12313%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009938s ]
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 '12313%' OR `brand` LIKE '12313%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005167s ]
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 '12313%' OR `brand` LIKE '12313%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007327s ]
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 '12313%' OR `brand` LIKE '12313%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006498s ]
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 '12313%' OR `brand` LIKE '12313%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015640s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '12313%' OR `brand` LIKE '12313%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001265s ]