SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002603s ]
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 '60004%' OR `brand` LIKE '60004%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.048806s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001357s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12172819 LIMIT 5 [ RunTime:0.013989s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12172819 ORDER BY `minOrder` ASC [ RunTime:0.036882s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001445s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12172819 ORDER BY `unit` DESC [ RunTime:0.008798s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.009526s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12172819 LIMIT 2 [ RunTime:0.028928s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12172819 ORDER BY `minOrder` ASC [ RunTime:0.014718s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13325706 LIMIT 5 [ RunTime:0.036816s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325706 ORDER BY `minOrder` ASC [ RunTime:0.033858s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13325706 ORDER BY `unit` DESC [ RunTime:0.063561s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13325706 LIMIT 2 [ RunTime:0.037407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325706 ORDER BY `minOrder` ASC [ RunTime:0.015863s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19022320 LIMIT 5 [ RunTime:0.046774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19022320 ORDER BY `minOrder` ASC [ RunTime:0.028826s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19022320 ORDER BY `unit` DESC [ RunTime:0.059308s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19022320 LIMIT 2 [ RunTime:0.036154s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19022320 ORDER BY `minOrder` ASC [ RunTime:0.016112s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17079042 LIMIT 5 [ RunTime:0.033800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17079042 ORDER BY `minOrder` ASC [ RunTime:0.026704s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17079042 ORDER BY `unit` DESC [ RunTime:0.032883s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17079042 LIMIT 2 [ RunTime:0.043207s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17079042 ORDER BY `minOrder` ASC [ RunTime:0.028848s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13307953 LIMIT 5 [ RunTime:0.011286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13307953 ORDER BY `minOrder` ASC [ RunTime:0.026298s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13307953 ORDER BY `unit` DESC [ RunTime:0.021322s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13307953 LIMIT 2 [ RunTime:0.008846s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13307953 ORDER BY `minOrder` ASC [ RunTime:0.003593s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12047721 LIMIT 5 [ RunTime:0.014916s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12047721 ORDER BY `minOrder` ASC [ RunTime:0.015927s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12047721 ORDER BY `unit` DESC [ RunTime:0.015036s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12047721 LIMIT 2 [ RunTime:0.004174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12047721 ORDER BY `minOrder` ASC [ RunTime:0.007872s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12015232 LIMIT 5 [ RunTime:0.007556s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12015232 ORDER BY `minOrder` ASC [ RunTime:0.018473s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12015232 ORDER BY `unit` DESC [ RunTime:0.011157s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12015232 LIMIT 2 [ RunTime:0.012545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12015232 ORDER BY `minOrder` ASC [ RunTime:0.007944s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11235888 LIMIT 5 [ RunTime:0.013220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11235888 ORDER BY `minOrder` ASC [ RunTime:0.016631s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11235888 ORDER BY `unit` DESC [ RunTime:0.066801s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11235888 LIMIT 2 [ RunTime:0.006986s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11235888 ORDER BY `minOrder` ASC [ RunTime:0.015883s ]
select * from pdf where partno='60004-003' and brandshort='Sensata-BEI Encoders' limit 1 [ RunTime:0.022949s ]
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 '60004%' OR `brand` LIKE '60004%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030752s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51128128 LIMIT 5 [ RunTime:0.015129s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51128128 ORDER BY `minOrder` ASC [ RunTime:0.024167s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51128128 ORDER BY `unit` DESC [ RunTime:0.019509s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51128128 LIMIT 2 [ RunTime:0.015771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51128128 ORDER BY `minOrder` ASC [ RunTime:0.006841s ]
select * from pdf where partno='60004-003' and brandshort='bei sensors' limit 1 [ RunTime:0.014834s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002708s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60004-003' OR `brand` LIKE 'bei sensors%' ) ) LIMIT 1 [ RunTime:0.021484s ]
SELECT `id` FROM `stock` WHERE `id` <> 51128128 AND `partno` = '60004-003' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bei sensors%' ) [ RunTime:0.007404s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51081835 LIMIT 5 [ RunTime:0.051532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51081835 ORDER BY `minOrder` ASC [ RunTime:0.054924s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51081835 ORDER BY `unit` DESC [ RunTime:0.019981s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51081835 LIMIT 2 [ RunTime:0.011862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51081835 ORDER BY `minOrder` ASC [ RunTime:0.004452s ]
select * from pdf where partno='60004-006' and brandshort='bei sensors' limit 1 [ RunTime:0.013749s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60004-006' OR `brand` LIKE 'bei sensors%' ) ) LIMIT 1 [ RunTime:0.004585s ]
SELECT `id` FROM `stock` WHERE `id` <> 51081835 AND `partno` = '60004-006' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bei sensors%' ) [ RunTime:0.006738s ]
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 '60004%' OR `brand` LIKE '60004%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028120s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58513022 LIMIT 5 [ RunTime:0.003023s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58513022 ORDER BY `minOrder` ASC [ RunTime:0.001753s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58513022 ORDER BY `unit` DESC [ RunTime:0.016078s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58513022 LIMIT 2 [ RunTime:0.004070s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58513022 ORDER BY `minOrder` ASC [ RunTime:0.018081s ]
select * from pdf where partno='60004' and brandshort='Excel Blades' limit 1 [ RunTime:0.012511s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60004' OR `brand` LIKE 'Excel Blades%' ) ) LIMIT 1 [ RunTime:0.016257s ]
SELECT `id` FROM `stock` WHERE `id` <> 58513022 AND `partno` = '60004' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%excel blades%' ) [ RunTime:0.020541s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12172819 [ RunTime:0.005111s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56513955 LIMIT 5 [ RunTime:0.000758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56513955 ORDER BY `minOrder` ASC [ RunTime:0.019731s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56513955 ORDER BY `unit` DESC [ RunTime:0.005347s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56513955 LIMIT 2 [ RunTime:0.011758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56513955 ORDER BY `minOrder` ASC [ RunTime:0.007630s ]
select * from pdf where partno='60004-004' and brandshort='Sensata-BEI Encoders' limit 1 [ RunTime:0.010108s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60004-004' OR `brand` LIKE 'Sensata-BEI Encoders%' ) ) LIMIT 1 [ RunTime:0.010177s ]
SELECT `id` FROM `stock` WHERE `id` <> 56513955 AND `partno` = '60004-004' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sensata-bei encoders%' ) [ RunTime:0.009210s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19022320 [ RunTime:0.025773s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56263773 LIMIT 5 [ RunTime:0.007200s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56263773 ORDER BY `minOrder` ASC [ RunTime:0.020880s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56263773 ORDER BY `unit` DESC [ RunTime:0.011600s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56263773 LIMIT 2 [ RunTime:0.015013s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56263773 ORDER BY `minOrder` ASC [ RunTime:0.002844s ]
select * from pdf where partno='6000487' and brandshort='Altech Corporation' limit 1 [ RunTime:0.033782s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6000487' OR `brand` LIKE 'Altech Corporation%' ) ) LIMIT 1 [ RunTime:0.026109s ]
SELECT `id` FROM `stock` WHERE `id` <> 56263773 AND `partno` = '6000487' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%altech corporation%' ) [ RunTime:0.016303s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13325706 [ RunTime:0.020347s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57629588 LIMIT 5 [ RunTime:0.052472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57629588 ORDER BY `minOrder` ASC [ RunTime:0.015097s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57629588 ORDER BY `unit` DESC [ RunTime:0.007463s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57629588 LIMIT 2 [ RunTime:0.020373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57629588 ORDER BY `minOrder` ASC [ RunTime:0.007341s ]
select * from pdf where partno='600043589' and brandshort='Belden Inc.' limit 1 [ RunTime:0.016718s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '600043589' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.014792s ]
SELECT `id` FROM `stock` WHERE `id` <> 57629588 AND `partno` = '600043589' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.032853s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17079042 [ RunTime:0.004437s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56562033 LIMIT 5 [ RunTime:0.001720s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56562033 ORDER BY `minOrder` ASC [ RunTime:0.008361s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56562033 ORDER BY `unit` DESC [ RunTime:0.019492s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56562033 LIMIT 2 [ RunTime:0.001833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56562033 ORDER BY `minOrder` ASC [ RunTime:0.006362s ]
select * from pdf where partno='6000428' and brandshort='Altech Corporation' limit 1 [ RunTime:0.003641s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6000428' OR `brand` LIKE 'Altech Corporation%' ) ) LIMIT 1 [ RunTime:0.008234s ]
SELECT `id` FROM `stock` WHERE `id` <> 56562033 AND `partno` = '6000428' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%altech corporation%' ) [ RunTime:0.023463s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12047721 [ RunTime:0.007154s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56399434 LIMIT 5 [ RunTime:0.002780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56399434 ORDER BY `minOrder` ASC [ RunTime:0.006896s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56399434 ORDER BY `unit` DESC [ RunTime:0.007835s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56399434 LIMIT 2 [ RunTime:0.044032s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56399434 ORDER BY `minOrder` ASC [ RunTime:0.015511s ]
select * from pdf where partno='60004-003' and brandshort='Sensata-BEI Encoders' limit 1 [ RunTime:0.008615s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60004-003' OR `brand` LIKE 'Sensata-BEI Encoders%' ) ) LIMIT 1 [ RunTime:0.001481s ]
SELECT `id` FROM `stock` WHERE `id` <> 56399434 AND `partno` = '60004-003' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sensata-bei encoders%' ) [ RunTime:0.009095s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11235888 [ RunTime:0.020649s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56399433 LIMIT 5 [ RunTime:0.010325s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56399433 ORDER BY `minOrder` ASC [ RunTime:0.013162s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56399433 ORDER BY `unit` DESC [ RunTime:0.027811s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56399433 LIMIT 2 [ RunTime:0.050097s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56399433 ORDER BY `minOrder` ASC [ RunTime:0.017153s ]
select * from pdf where partno='60004-002' and brandshort='Sensata-BEI Encoders' limit 1 [ RunTime:0.044186s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60004-002' OR `brand` LIKE 'Sensata-BEI Encoders%' ) ) LIMIT 1 [ RunTime:0.029204s ]
SELECT `id` FROM `stock` WHERE `id` <> 56399433 AND `partno` = '60004-002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sensata-bei encoders%' ) [ RunTime:0.056614s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32359657 LIMIT 5 [ RunTime:0.037866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32359657 ORDER BY `minOrder` ASC [ RunTime:0.014684s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32359657 ORDER BY `unit` DESC [ RunTime:0.021336s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32359657 LIMIT 2 [ RunTime:0.014563s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32359657 ORDER BY `minOrder` ASC [ RunTime:0.008454s ]
select * from pdf where partno='6000465' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.007707s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6000465' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.006805s ]
SELECT `id` FROM `stock` WHERE `id` <> 32359657 AND `partno` = '6000465' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.005420s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12015232 [ RunTime:0.027343s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32345075 LIMIT 5 [ RunTime:0.017200s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32345075 ORDER BY `minOrder` ASC [ RunTime:0.020641s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32345075 ORDER BY `unit` DESC [ RunTime:0.032978s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32345075 LIMIT 2 [ RunTime:0.015774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32345075 ORDER BY `minOrder` ASC [ RunTime:0.006854s ]
select * from pdf where partno='6000459' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.043492s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6000459' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.017697s ]
SELECT `id` FROM `stock` WHERE `id` <> 32345075 AND `partno` = '6000459' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.039313s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13307953 [ RunTime:0.016040s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32330978 LIMIT 5 [ RunTime:0.005269s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32330978 ORDER BY `minOrder` ASC [ RunTime:0.022648s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32330978 ORDER BY `unit` DESC [ RunTime:0.039622s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32330978 LIMIT 2 [ RunTime:0.029752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32330978 ORDER BY `minOrder` ASC [ RunTime:0.004690s ]
select * from pdf where partno='6000449' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.023383s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6000449' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.032850s ]
SELECT `id` FROM `stock` WHERE `id` <> 32330978 AND `partno` = '6000449' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.046867s ]
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 '60004%' OR `brand` LIKE '60004%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018308s ]
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 '60004%' OR `brand` LIKE '60004%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.036489s ]
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 '60004%' OR `brand` LIKE '60004%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016354s ]
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 '60004%' OR `brand` LIKE '60004%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031686s ]
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 '60004%' OR `brand` LIKE '60004%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017397s ]
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 '60004%' OR `brand` LIKE '60004%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006514s ]
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 '60004%' OR `brand` LIKE '60004%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004087s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '60004%' OR `brand` LIKE '60004%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.032095s ]