SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002084s ]
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 '12329%' OR `brand` LIKE '12329%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.040012s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.005759s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12066791 LIMIT 5 [ RunTime:0.077154s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.014066s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12066791 ORDER BY `minOrder` ASC [ RunTime:0.045049s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001997s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12066791 ORDER BY `unit` DESC [ RunTime:0.023276s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.019756s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12066791 LIMIT 2 [ RunTime:0.030323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12066791 ORDER BY `minOrder` ASC [ RunTime:0.019669s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11445459 LIMIT 5 [ RunTime:0.003712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11445459 ORDER BY `minOrder` ASC [ RunTime:0.036624s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11445459 ORDER BY `unit` DESC [ RunTime:0.034844s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11445459 LIMIT 2 [ RunTime:0.007063s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11445459 ORDER BY `minOrder` ASC [ RunTime:0.012612s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12241010 LIMIT 5 [ RunTime:0.026973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12241010 ORDER BY `minOrder` ASC [ RunTime:0.029124s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12241010 ORDER BY `unit` DESC [ RunTime:0.024848s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12241010 LIMIT 2 [ RunTime:0.058604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12241010 ORDER BY `minOrder` ASC [ RunTime:0.009363s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19650703 LIMIT 5 [ RunTime:0.006264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19650703 ORDER BY `minOrder` ASC [ RunTime:0.024032s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19650703 ORDER BY `unit` DESC [ RunTime:0.011585s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19650703 LIMIT 2 [ RunTime:0.025833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19650703 ORDER BY `minOrder` ASC [ RunTime:0.008921s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19639048 LIMIT 5 [ RunTime:0.080858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19639048 ORDER BY `minOrder` ASC [ RunTime:0.017487s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19639048 ORDER BY `unit` DESC [ RunTime:0.042832s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19639048 LIMIT 2 [ RunTime:0.014513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19639048 ORDER BY `minOrder` ASC [ RunTime:0.020255s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17509233 LIMIT 5 [ RunTime:0.018458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17509233 ORDER BY `minOrder` ASC [ RunTime:0.009321s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17509233 ORDER BY `unit` DESC [ RunTime:0.042243s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17509233 LIMIT 2 [ RunTime:0.013024s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17509233 ORDER BY `minOrder` ASC [ RunTime:0.008471s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17509231 LIMIT 5 [ RunTime:0.008554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17509231 ORDER BY `minOrder` ASC [ RunTime:0.007066s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17509231 ORDER BY `unit` DESC [ RunTime:0.003930s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17509231 LIMIT 2 [ RunTime:0.000425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17509231 ORDER BY `minOrder` ASC [ RunTime:0.011587s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17508896 LIMIT 5 [ RunTime:0.013656s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17508896 ORDER BY `minOrder` ASC [ RunTime:0.019173s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17508896 ORDER BY `unit` DESC [ RunTime:0.015036s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17508896 LIMIT 2 [ RunTime:0.011961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17508896 ORDER BY `minOrder` ASC [ RunTime:0.028249s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17508893 LIMIT 5 [ RunTime:0.022906s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17508893 ORDER BY `minOrder` ASC [ RunTime:0.008401s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17508893 ORDER BY `unit` DESC [ RunTime:0.015000s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17508893 LIMIT 2 [ RunTime:0.044064s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17508893 ORDER BY `minOrder` ASC [ RunTime:0.023612s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17508862 LIMIT 5 [ RunTime:0.022056s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17508862 ORDER BY `minOrder` ASC [ RunTime:0.009445s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17508862 ORDER BY `unit` DESC [ RunTime:0.000664s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17508862 LIMIT 2 [ RunTime:0.000640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17508862 ORDER BY `minOrder` ASC [ RunTime:0.015326s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16621027 LIMIT 5 [ RunTime:0.018040s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16621027 ORDER BY `minOrder` ASC [ RunTime:0.009600s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16621027 ORDER BY `unit` DESC [ RunTime:0.003823s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16621027 LIMIT 2 [ RunTime:0.008102s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16621027 ORDER BY `minOrder` ASC [ RunTime:0.006616s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16621026 LIMIT 5 [ RunTime:0.004641s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16621026 ORDER BY `minOrder` ASC [ RunTime:0.011725s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16621026 ORDER BY `unit` DESC [ RunTime:0.011553s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16621026 LIMIT 2 [ RunTime:0.002339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16621026 ORDER BY `minOrder` ASC [ RunTime:0.001631s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16621025 LIMIT 5 [ RunTime:0.002169s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16621025 ORDER BY `minOrder` ASC [ RunTime:0.002382s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16621025 ORDER BY `unit` DESC [ RunTime:0.002332s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16621025 LIMIT 2 [ RunTime:0.023724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16621025 ORDER BY `minOrder` ASC [ RunTime:0.005875s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16621024 LIMIT 5 [ RunTime:0.016406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16621024 ORDER BY `minOrder` ASC [ RunTime:0.023559s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16621024 ORDER BY `unit` DESC [ RunTime:0.006772s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16621024 LIMIT 2 [ RunTime:0.007452s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16621024 ORDER BY `minOrder` ASC [ RunTime:0.009033s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13808288 LIMIT 5 [ RunTime:0.020131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13808288 ORDER BY `minOrder` ASC [ RunTime:0.021969s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13808288 ORDER BY `unit` DESC [ RunTime:0.017677s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13808288 LIMIT 2 [ RunTime:0.016435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13808288 ORDER BY `minOrder` ASC [ RunTime:0.006752s ]
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 '12329%' OR `brand` LIKE '12329%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018975s ]
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 '12329%' OR `brand` LIKE '12329%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.035331s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64558990 LIMIT 5 [ RunTime:0.026910s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64558990 ORDER BY `minOrder` ASC [ RunTime:0.017873s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64558990 ORDER BY `unit` DESC [ RunTime:0.004754s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64558990 LIMIT 2 [ RunTime:0.024496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64558990 ORDER BY `minOrder` ASC [ RunTime:0.010998s ]
select * from pdf where partno='12329CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.030428s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002614s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '12329CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.023371s ]
SELECT `id` FROM `stock` WHERE `id` <> 64558990 AND `partno` = '12329CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.013109s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12066791 [ RunTime:0.012339s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60488422 LIMIT 5 [ RunTime:0.036748s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60488422 ORDER BY `minOrder` ASC [ RunTime:0.014593s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60488422 ORDER BY `unit` DESC [ RunTime:0.035389s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60488422 LIMIT 2 [ RunTime:0.043304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60488422 ORDER BY `minOrder` ASC [ RunTime:0.016140s ]
select * from pdf where partno='1232900' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.008914s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1232900' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.058999s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60488588 LIMIT 5 [ RunTime:0.036285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60488588 ORDER BY `minOrder` ASC [ RunTime:0.043201s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60488588 ORDER BY `unit` DESC [ RunTime:0.046869s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60488588 LIMIT 2 [ RunTime:0.064588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60488588 ORDER BY `minOrder` ASC [ RunTime:0.020306s ]
select * from pdf where partno='1232902' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.019823s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1232902' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.030875s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60488705 LIMIT 5 [ RunTime:0.035477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60488705 ORDER BY `minOrder` ASC [ RunTime:0.057615s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60488705 ORDER BY `unit` DESC [ RunTime:0.048418s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60488705 LIMIT 2 [ RunTime:0.006146s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60488705 ORDER BY `minOrder` ASC [ RunTime:0.015998s ]
select * from pdf where partno='1232904' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.021205s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1232904' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.029546s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60488653 LIMIT 5 [ RunTime:0.052605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60488653 ORDER BY `minOrder` ASC [ RunTime:0.039566s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60488653 ORDER BY `unit` DESC [ RunTime:0.104837s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60488653 LIMIT 2 [ RunTime:0.053077s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60488653 ORDER BY `minOrder` ASC [ RunTime:0.026026s ]
select * from pdf where partno='1232903' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.057185s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1232903' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.065656s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60488524 LIMIT 5 [ RunTime:0.069971s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60488524 ORDER BY `minOrder` ASC [ RunTime:0.064704s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60488524 ORDER BY `unit` DESC [ RunTime:0.050075s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60488524 LIMIT 2 [ RunTime:0.039963s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60488524 ORDER BY `minOrder` ASC [ RunTime:0.022885s ]
select * from pdf where partno='1232901' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.022082s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1232901' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.020193s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63212959 LIMIT 5 [ RunTime:0.032040s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63212959 ORDER BY `minOrder` ASC [ RunTime:0.070810s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63212959 ORDER BY `unit` DESC [ RunTime:0.019395s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63212959 LIMIT 2 [ RunTime:0.015124s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63212959 ORDER BY `minOrder` ASC [ RunTime:0.003569s ]
select * from pdf where partno='12329' and brandshort='Allied Vision, Inc.' limit 1 [ RunTime:0.035016s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '12329' OR `brand` LIKE 'Allied Vision, Inc.%' ) ) LIMIT 1 [ RunTime:0.025847s ]
SELECT `id` FROM `stock` WHERE `id` <> 63212959 AND `partno` = '12329' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%allied vision, inc.%' ) [ RunTime:0.064434s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12241010 [ RunTime:0.012795s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60552271 LIMIT 5 [ RunTime:0.016622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60552271 ORDER BY `minOrder` ASC [ RunTime:0.020827s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60552271 ORDER BY `unit` DESC [ RunTime:0.032076s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60552271 LIMIT 2 [ RunTime:0.061833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60552271 ORDER BY `minOrder` ASC [ RunTime:0.017983s ]
select * from pdf where partno='12329.1' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.031739s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '12329.1' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.046682s ]
SELECT `id` FROM `stock` WHERE `id` <> 60552271 AND `partno` = '12329.1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.024595s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19650703 [ RunTime:0.030628s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60532867 LIMIT 5 [ RunTime:0.039612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60532867 ORDER BY `minOrder` ASC [ RunTime:0.035584s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60532867 ORDER BY `unit` DESC [ RunTime:0.013865s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60532867 LIMIT 2 [ RunTime:0.032292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60532867 ORDER BY `minOrder` ASC [ RunTime:0.019151s ]
select * from pdf where partno='1232980000' and brandshort='Weidmüller' limit 1 [ RunTime:0.009144s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1232980000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.064996s ]
SELECT `id` FROM `stock` WHERE `id` <> 60532867 AND `partno` = '1232980000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.043998s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19639048 [ RunTime:0.025387s ]
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 '12329%' OR `brand` LIKE '12329%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.059366s ]
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 '12329%' OR `brand` LIKE '12329%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018072s ]
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 '12329%' OR `brand` LIKE '12329%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014470s ]
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 '12329%' OR `brand` LIKE '12329%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.034540s ]
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 '12329%' OR `brand` LIKE '12329%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.048135s ]
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 '12329%' OR `brand` LIKE '12329%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026461s ]
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 '12329%' OR `brand` LIKE '12329%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022046s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '12329%' OR `brand` LIKE '12329%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.004073s ]