SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002391s ]
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 '1020100%' OR `brand` LIKE '1020100%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.086312s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.022154s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12561384 LIMIT 5 [ RunTime:0.034205s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12561384 ORDER BY `minOrder` ASC [ RunTime:0.053660s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002279s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12561384 ORDER BY `unit` DESC [ RunTime:0.051091s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.039867s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12561384 LIMIT 2 [ RunTime:0.030913s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12561384 ORDER BY `minOrder` ASC [ RunTime:0.033568s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19512609 LIMIT 5 [ RunTime:0.033446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19512609 ORDER BY `minOrder` ASC [ RunTime:0.045284s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19512609 ORDER BY `unit` DESC [ RunTime:0.043030s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19512609 LIMIT 2 [ RunTime:0.066976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19512609 ORDER BY `minOrder` ASC [ RunTime:0.005140s ]
select * from pdf where partno='102010048' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.035581s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17267508 LIMIT 5 [ RunTime:0.013065s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17267508 ORDER BY `minOrder` ASC [ RunTime:0.045270s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17267508 ORDER BY `unit` DESC [ RunTime:0.059817s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17267508 LIMIT 2 [ RunTime:0.070147s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17267508 ORDER BY `minOrder` ASC [ RunTime:0.014209s ]
select * from pdf where partno='102010027' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.026168s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19513366 LIMIT 5 [ RunTime:0.063443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19513366 ORDER BY `minOrder` ASC [ RunTime:0.020731s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19513366 ORDER BY `unit` DESC [ RunTime:0.025933s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19513366 LIMIT 2 [ RunTime:0.015251s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19513366 ORDER BY `minOrder` ASC [ RunTime:0.001601s ]
select * from pdf where partno='102010026' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.007478s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14724073 LIMIT 5 [ RunTime:0.013437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14724073 ORDER BY `minOrder` ASC [ RunTime:0.013479s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14724073 ORDER BY `unit` DESC [ RunTime:0.002012s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14724073 LIMIT 2 [ RunTime:0.010737s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14724073 ORDER BY `minOrder` ASC [ RunTime:0.000343s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19513025 LIMIT 5 [ RunTime:0.004627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19513025 ORDER BY `minOrder` ASC [ RunTime:0.003490s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19513025 ORDER BY `unit` DESC [ RunTime:0.009718s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19513025 LIMIT 2 [ RunTime:0.004047s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19513025 ORDER BY `minOrder` ASC [ RunTime:0.005217s ]
select * from pdf where partno='102010000' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.000438s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19513008 LIMIT 5 [ RunTime:0.000712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19513008 ORDER BY `minOrder` ASC [ RunTime:0.000395s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19513008 ORDER BY `unit` DESC [ RunTime:0.004922s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19513008 LIMIT 2 [ RunTime:0.003398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19513008 ORDER BY `minOrder` ASC [ RunTime:0.010626s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19512990 LIMIT 5 [ RunTime:0.004274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19512990 ORDER BY `minOrder` ASC [ RunTime:0.000407s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19512990 ORDER BY `unit` DESC [ RunTime:0.002091s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19512990 LIMIT 2 [ RunTime:0.016575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19512990 ORDER BY `minOrder` ASC [ RunTime:0.000427s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19512885 LIMIT 5 [ RunTime:0.000902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19512885 ORDER BY `minOrder` ASC [ RunTime:0.012460s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19512885 ORDER BY `unit` DESC [ RunTime:0.007962s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19512885 LIMIT 2 [ RunTime:0.006241s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19512885 ORDER BY `minOrder` ASC [ RunTime:0.002000s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19512808 LIMIT 5 [ RunTime:0.001577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19512808 ORDER BY `minOrder` ASC [ RunTime:0.008636s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19512808 ORDER BY `unit` DESC [ RunTime:0.001355s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19512808 LIMIT 2 [ RunTime:0.000808s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19512808 ORDER BY `minOrder` ASC [ RunTime:0.000937s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19512793 LIMIT 5 [ RunTime:0.002791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19512793 ORDER BY `minOrder` ASC [ RunTime:0.008416s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19512793 ORDER BY `unit` DESC [ RunTime:0.008310s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19512793 LIMIT 2 [ RunTime:0.010878s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19512793 ORDER BY `minOrder` ASC [ RunTime:0.000633s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19512777 LIMIT 5 [ RunTime:0.005579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19512777 ORDER BY `minOrder` ASC [ RunTime:0.001144s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19512777 ORDER BY `unit` DESC [ RunTime:0.010125s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19512777 LIMIT 2 [ RunTime:0.002112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19512777 ORDER BY `minOrder` ASC [ RunTime:0.000547s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19512443 LIMIT 5 [ RunTime:0.001141s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19512443 ORDER BY `minOrder` ASC [ RunTime:0.011637s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19512443 ORDER BY `unit` DESC [ RunTime:0.015943s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19512443 LIMIT 2 [ RunTime:0.002580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19512443 ORDER BY `minOrder` ASC [ RunTime:0.000446s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17267690 LIMIT 5 [ RunTime:0.000911s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17267690 ORDER BY `minOrder` ASC [ RunTime:0.002129s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17267690 ORDER BY `unit` DESC [ RunTime:0.002978s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17267690 LIMIT 2 [ RunTime:0.000579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17267690 ORDER BY `minOrder` ASC [ RunTime:0.000419s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17267662 LIMIT 5 [ RunTime:0.009736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17267662 ORDER BY `minOrder` ASC [ RunTime:0.004641s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17267662 ORDER BY `unit` DESC [ RunTime:0.000428s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17267662 LIMIT 2 [ RunTime:0.000603s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17267662 ORDER BY `minOrder` ASC [ RunTime:0.000559s ]
select * from pdf where partno='102010019' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.000515s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17267611 LIMIT 5 [ RunTime:0.006346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17267611 ORDER BY `minOrder` ASC [ RunTime:0.007976s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17267611 ORDER BY `unit` DESC [ RunTime:0.016040s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17267611 LIMIT 2 [ RunTime:0.000693s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17267611 ORDER BY `minOrder` ASC [ RunTime:0.007139s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17267592 LIMIT 5 [ RunTime:0.001285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17267592 ORDER BY `minOrder` ASC [ RunTime:0.000674s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17267592 ORDER BY `unit` DESC [ RunTime:0.009158s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17267592 LIMIT 2 [ RunTime:0.015071s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17267592 ORDER BY `minOrder` ASC [ RunTime:0.004306s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13374341 LIMIT 5 [ RunTime:0.001193s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13374341 ORDER BY `minOrder` ASC [ RunTime:0.001217s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13374341 ORDER BY `unit` DESC [ RunTime:0.000658s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13374341 LIMIT 2 [ RunTime:0.000574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13374341 ORDER BY `minOrder` ASC [ RunTime:0.000424s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12407487 LIMIT 5 [ RunTime:0.000947s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12407487 ORDER BY `minOrder` ASC [ RunTime:0.000614s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12407487 ORDER BY `unit` DESC [ RunTime:0.008553s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12407487 LIMIT 2 [ RunTime:0.014961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12407487 ORDER BY `minOrder` ASC [ RunTime:0.009029s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12404173 LIMIT 5 [ RunTime:0.006331s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12404173 ORDER BY `minOrder` ASC [ RunTime:0.009539s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12404173 ORDER BY `unit` DESC [ RunTime:0.017732s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12404173 LIMIT 2 [ RunTime:0.022430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12404173 ORDER BY `minOrder` ASC [ RunTime:0.008387s ]
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 '1020100%' OR `brand` LIKE '1020100%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019087s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51111516 LIMIT 5 [ RunTime:0.013109s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51111516 ORDER BY `minOrder` ASC [ RunTime:0.011503s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51111516 ORDER BY `unit` DESC [ RunTime:0.004809s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51111516 LIMIT 2 [ RunTime:0.014630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51111516 ORDER BY `minOrder` ASC [ RunTime:0.002800s ]
select * from pdf where partno='102010026' and brandshort='seeed studio' limit 1 [ RunTime:0.005267s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002384s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '102010026' OR `brand` LIKE 'seeed studio%' ) ) LIMIT 1 [ RunTime:0.020133s ]
SELECT `id` FROM `stock` WHERE `id` <> 51111516 AND `partno` = '102010026' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed studio%' ) [ RunTime:0.027223s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51110636 LIMIT 5 [ RunTime:0.004174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51110636 ORDER BY `minOrder` ASC [ RunTime:0.024097s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51110636 ORDER BY `unit` DESC [ RunTime:0.028982s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51110636 LIMIT 2 [ RunTime:0.016151s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51110636 ORDER BY `minOrder` ASC [ RunTime:0.017096s ]
select * from pdf where partno='102010088' and brandshort='seeed studio' limit 1 [ RunTime:0.015685s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '102010088' OR `brand` LIKE 'seeed studio%' ) ) LIMIT 1 [ RunTime:0.000936s ]
SELECT `id` FROM `stock` WHERE `id` <> 51110636 AND `partno` = '102010088' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed studio%' ) [ RunTime:0.000855s ]
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 '1020100%' OR `brand` LIKE '1020100%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005099s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60467920 LIMIT 5 [ RunTime:0.003532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60467920 ORDER BY `minOrder` ASC [ RunTime:0.006273s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60467920 ORDER BY `unit` DESC [ RunTime:0.002180s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60467920 LIMIT 2 [ RunTime:0.000375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60467920 ORDER BY `minOrder` ASC [ RunTime:0.002952s ]
select * from pdf where partno='1020100000' and brandshort='Weidmüller' limit 1 [ RunTime:0.001426s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1020100000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.006551s ]
SELECT `id` FROM `stock` WHERE `id` <> 60467920 AND `partno` = '1020100000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.004885s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12561384 [ RunTime:0.002890s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64017213 LIMIT 5 [ RunTime:0.000413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64017213 ORDER BY `minOrder` ASC [ RunTime:0.000816s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64017213 ORDER BY `unit` DESC [ RunTime:0.009845s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64017213 LIMIT 2 [ RunTime:0.003047s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64017213 ORDER BY `minOrder` ASC [ RunTime:0.002327s ]
select * from pdf where partno='102010027' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.000602s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '102010027' OR `brand` LIKE 'Seeed Technology Co., Ltd%' ) ) LIMIT 1 [ RunTime:0.000844s ]
SELECT `id` FROM `stock` WHERE `id` <> 64017213 AND `partno` = '102010027' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed technology co., ltd%' ) [ RunTime:0.011448s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17267508 [ RunTime:0.004169s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64017251 LIMIT 5 [ RunTime:0.001751s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64017251 ORDER BY `minOrder` ASC [ RunTime:0.007588s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64017251 ORDER BY `unit` DESC [ RunTime:0.004366s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64017251 LIMIT 2 [ RunTime:0.005115s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64017251 ORDER BY `minOrder` ASC [ RunTime:0.003728s ]
select * from pdf where partno='102010048' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.001214s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '102010048' OR `brand` LIKE 'Seeed Technology Co., Ltd%' ) ) LIMIT 1 [ RunTime:0.001543s ]
SELECT `id` FROM `stock` WHERE `id` <> 64017251 AND `partno` = '102010048' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed technology co., ltd%' ) [ RunTime:0.003364s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19512609 [ RunTime:0.006927s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64017332 LIMIT 5 [ RunTime:0.006665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64017332 ORDER BY `minOrder` ASC [ RunTime:0.026901s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64017332 ORDER BY `unit` DESC [ RunTime:0.001608s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64017332 LIMIT 2 [ RunTime:0.008633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64017332 ORDER BY `minOrder` ASC [ RunTime:0.000463s ]
select * from pdf where partno='102010026' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.000737s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '102010026' OR `brand` LIKE 'Seeed Technology Co., Ltd%' ) ) LIMIT 1 [ RunTime:0.002099s ]
SELECT `id` FROM `stock` WHERE `id` <> 64017332 AND `partno` = '102010026' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed technology co., ltd%' ) [ RunTime:0.000932s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19513366 [ RunTime:0.000672s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41866152 LIMIT 5 [ RunTime:0.000604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41866152 ORDER BY `minOrder` ASC [ RunTime:0.004328s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41866152 ORDER BY `unit` DESC [ RunTime:0.010556s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41866152 LIMIT 2 [ RunTime:0.000627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41866152 ORDER BY `minOrder` ASC [ RunTime:0.000434s ]
select * from pdf where partno='1020100' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000965s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1020100' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.004753s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64820831 LIMIT 5 [ RunTime:0.001572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64820831 ORDER BY `minOrder` ASC [ RunTime:0.001319s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64820831 ORDER BY `unit` DESC [ RunTime:0.000619s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64820831 LIMIT 2 [ RunTime:0.000591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64820831 ORDER BY `minOrder` ASC [ RunTime:0.007398s ]
select * from pdf where partno='102010021' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.001212s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '102010021' OR `brand` LIKE 'Seeed Technology Co., Ltd%' ) ) LIMIT 1 [ RunTime:0.001809s ]
SELECT `id` FROM `stock` WHERE `id` <> 64820831 AND `partno` = '102010021' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed technology co., ltd%' ) [ RunTime:0.001165s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12407487 [ RunTime:0.000509s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64414132 LIMIT 5 [ RunTime:0.007185s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64414132 ORDER BY `minOrder` ASC [ RunTime:0.001284s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64414132 ORDER BY `unit` DESC [ RunTime:0.010631s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64414132 LIMIT 2 [ RunTime:0.004018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64414132 ORDER BY `minOrder` ASC [ RunTime:0.005680s ]
select * from pdf where partno='102010012' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.002168s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '102010012' OR `brand` LIKE 'Seeed Technology Co., Ltd%' ) ) LIMIT 1 [ RunTime:0.000268s ]
SELECT `id` FROM `stock` WHERE `id` <> 64414132 AND `partno` = '102010012' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed technology co., ltd%' ) [ RunTime:0.000360s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13374341 [ RunTime:0.000310s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64054829 LIMIT 5 [ RunTime:0.000415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64054829 ORDER BY `minOrder` ASC [ RunTime:0.001192s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64054829 ORDER BY `unit` DESC [ RunTime:0.002572s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64054829 LIMIT 2 [ RunTime:0.005290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64054829 ORDER BY `minOrder` ASC [ RunTime:0.000294s ]
select * from pdf where partno='102010002' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.000707s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '102010002' OR `brand` LIKE 'Seeed Technology Co., Ltd%' ) ) LIMIT 1 [ RunTime:0.000526s ]
SELECT `id` FROM `stock` WHERE `id` <> 64054829 AND `partno` = '102010002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed technology co., ltd%' ) [ RunTime:0.006940s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12394364 [ RunTime:0.006381s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64048554 LIMIT 5 [ RunTime:0.004594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64048554 ORDER BY `minOrder` ASC [ RunTime:0.014538s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64048554 ORDER BY `unit` DESC [ RunTime:0.000426s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64048554 LIMIT 2 [ RunTime:0.002108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64048554 ORDER BY `minOrder` ASC [ RunTime:0.002217s ]
select * from pdf where partno='102010023' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.000975s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '102010023' OR `brand` LIKE 'Seeed Technology Co., Ltd%' ) ) LIMIT 1 [ RunTime:0.000525s ]
SELECT `id` FROM `stock` WHERE `id` <> 64048554 AND `partno` = '102010023' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed technology co., ltd%' ) [ RunTime:0.001109s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12404173 [ RunTime:0.003258s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64028440 LIMIT 5 [ RunTime:0.000841s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64028440 ORDER BY `minOrder` ASC [ RunTime:0.006632s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64028440 ORDER BY `unit` DESC [ RunTime:0.002580s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64028440 LIMIT 2 [ RunTime:0.001550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64028440 ORDER BY `minOrder` ASC [ RunTime:0.000291s ]
select * from pdf where partno='102010028' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.000623s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '102010028' OR `brand` LIKE 'Seeed Technology Co., Ltd%' ) ) LIMIT 1 [ RunTime:0.001364s ]
SELECT `id` FROM `stock` WHERE `id` <> 64028440 AND `partno` = '102010028' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed technology co., ltd%' ) [ RunTime:0.005813s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11341533 [ RunTime:0.004240s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64019838 LIMIT 5 [ RunTime:0.000360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64019838 ORDER BY `minOrder` ASC [ RunTime:0.000728s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64019838 ORDER BY `unit` DESC [ RunTime:0.004964s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64019838 LIMIT 2 [ RunTime:0.001682s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64019838 ORDER BY `minOrder` ASC [ RunTime:0.003929s ]
select * from pdf where partno='102010088' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.002903s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '102010088' OR `brand` LIKE 'Seeed Technology Co., Ltd%' ) ) LIMIT 1 [ RunTime:0.000482s ]
SELECT `id` FROM `stock` WHERE `id` <> 64019838 AND `partno` = '102010088' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed technology co., ltd%' ) [ RunTime:0.000500s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17267690 [ RunTime:0.000380s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64019683 LIMIT 5 [ RunTime:0.001695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64019683 ORDER BY `minOrder` ASC [ RunTime:0.001174s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64019683 ORDER BY `unit` DESC [ RunTime:0.001307s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64019683 LIMIT 2 [ RunTime:0.000851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64019683 ORDER BY `minOrder` ASC [ RunTime:0.000293s ]
select * from pdf where partno='102010019' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.000495s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '102010019' OR `brand` LIKE 'Seeed Technology Co., Ltd%' ) ) LIMIT 1 [ RunTime:0.000484s ]
SELECT `id` FROM `stock` WHERE `id` <> 64019683 AND `partno` = '102010019' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed technology co., ltd%' ) [ RunTime:0.000466s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17267662 [ RunTime:0.000269s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64019661 LIMIT 5 [ RunTime:0.000392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64019661 ORDER BY `minOrder` ASC [ RunTime:0.001612s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64019661 ORDER BY `unit` DESC [ RunTime:0.002906s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64019661 LIMIT 2 [ RunTime:0.000348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64019661 ORDER BY `minOrder` ASC [ RunTime:0.001191s ]
select * from pdf where partno='102010000' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.000504s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '102010000' OR `brand` LIKE 'Seeed Technology Co., Ltd%' ) ) LIMIT 1 [ RunTime:0.000462s ]
SELECT `id` FROM `stock` WHERE `id` <> 64019661 AND `partno` = '102010000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed technology co., ltd%' ) [ RunTime:0.004391s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19513025 [ RunTime:0.000303s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64019636 LIMIT 5 [ RunTime:0.009982s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64019636 ORDER BY `minOrder` ASC [ RunTime:0.003292s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64019636 ORDER BY `unit` DESC [ RunTime:0.007944s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64019636 LIMIT 2 [ RunTime:0.000737s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64019636 ORDER BY `minOrder` ASC [ RunTime:0.000289s ]
select * from pdf where partno='102010007' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.001334s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '102010007' OR `brand` LIKE 'Seeed Technology Co., Ltd%' ) ) LIMIT 1 [ RunTime:0.004868s ]
SELECT `id` FROM `stock` WHERE `id` <> 64019636 AND `partno` = '102010007' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed technology co., ltd%' ) [ RunTime:0.006451s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19513008 [ RunTime:0.002457s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64019615 LIMIT 5 [ RunTime:0.003815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64019615 ORDER BY `minOrder` ASC [ RunTime:0.013361s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64019615 ORDER BY `unit` DESC [ RunTime:0.021565s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64019615 LIMIT 2 [ RunTime:0.026527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64019615 ORDER BY `minOrder` ASC [ RunTime:0.013516s ]
select * from pdf where partno='102010017' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.011848s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '102010017' OR `brand` LIKE 'Seeed Technology Co., Ltd%' ) ) LIMIT 1 [ RunTime:0.002830s ]
SELECT `id` FROM `stock` WHERE `id` <> 64019615 AND `partno` = '102010017' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed technology co., ltd%' ) [ RunTime:0.019233s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19512990 [ RunTime:0.005548s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64019482 LIMIT 5 [ RunTime:0.003646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64019482 ORDER BY `minOrder` ASC [ RunTime:0.011229s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64019482 ORDER BY `unit` DESC [ RunTime:0.007920s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64019482 LIMIT 2 [ RunTime:0.006159s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64019482 ORDER BY `minOrder` ASC [ RunTime:0.001655s ]
select * from pdf where partno='102010006' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.000916s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '102010006' OR `brand` LIKE 'Seeed Technology Co., Ltd%' ) ) LIMIT 1 [ RunTime:0.010247s ]
SELECT `id` FROM `stock` WHERE `id` <> 64019482 AND `partno` = '102010006' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed technology co., ltd%' ) [ RunTime:0.001310s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19512885 [ RunTime:0.000429s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64019392 LIMIT 5 [ RunTime:0.000494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64019392 ORDER BY `minOrder` ASC [ RunTime:0.003407s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64019392 ORDER BY `unit` DESC [ RunTime:0.001521s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64019392 LIMIT 2 [ RunTime:0.002671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64019392 ORDER BY `minOrder` ASC [ RunTime:0.009736s ]
select * from pdf where partno='102010009' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.015738s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '102010009' OR `brand` LIKE 'Seeed Technology Co., Ltd%' ) ) LIMIT 1 [ RunTime:0.005231s ]
SELECT `id` FROM `stock` WHERE `id` <> 64019392 AND `partno` = '102010009' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed technology co., ltd%' ) [ RunTime:0.032660s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17267611 [ RunTime:0.019433s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64019369 LIMIT 5 [ RunTime:0.019776s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64019369 ORDER BY `minOrder` ASC [ RunTime:0.033038s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64019369 ORDER BY `unit` DESC [ RunTime:0.009992s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64019369 LIMIT 2 [ RunTime:0.022917s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64019369 ORDER BY `minOrder` ASC [ RunTime:0.009631s ]
select * from pdf where partno='102010008' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.007387s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '102010008' OR `brand` LIKE 'Seeed Technology Co., Ltd%' ) ) LIMIT 1 [ RunTime:0.023103s ]
SELECT `id` FROM `stock` WHERE `id` <> 64019369 AND `partno` = '102010008' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed technology co., ltd%' ) [ RunTime:0.038102s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19512808 [ RunTime:0.011595s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64019350 LIMIT 5 [ RunTime:0.004914s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64019350 ORDER BY `minOrder` ASC [ RunTime:0.003929s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64019350 ORDER BY `unit` DESC [ RunTime:0.002410s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64019350 LIMIT 2 [ RunTime:0.005885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64019350 ORDER BY `minOrder` ASC [ RunTime:0.000574s ]
select * from pdf where partno='102010020' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.010022s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '102010020' OR `brand` LIKE 'Seeed Technology Co., Ltd%' ) ) LIMIT 1 [ RunTime:0.024266s ]
SELECT `id` FROM `stock` WHERE `id` <> 64019350 AND `partno` = '102010020' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed technology co., ltd%' ) [ RunTime:0.007624s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19512777 [ RunTime:0.004128s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64019341 LIMIT 5 [ RunTime:0.003599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64019341 ORDER BY `minOrder` ASC [ RunTime:0.033927s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64019341 ORDER BY `unit` DESC [ RunTime:0.005279s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64019341 LIMIT 2 [ RunTime:0.013115s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64019341 ORDER BY `minOrder` ASC [ RunTime:0.002846s ]
select * from pdf where partno='102010004' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.008723s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '102010004' OR `brand` LIKE 'Seeed Technology Co., Ltd%' ) ) LIMIT 1 [ RunTime:0.008135s ]
SELECT `id` FROM `stock` WHERE `id` <> 64019341 AND `partno` = '102010004' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed technology co., ltd%' ) [ RunTime:0.008816s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19512793 [ RunTime:0.011178s ]
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 '1020100%' OR `brand` LIKE '1020100%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028448s ]
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 '1020100%' OR `brand` LIKE '1020100%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007486s ]
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 '1020100%' OR `brand` LIKE '1020100%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.034329s ]
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 '1020100%' OR `brand` LIKE '1020100%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016613s ]
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 '1020100%' OR `brand` LIKE '1020100%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007757s ]
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 '1020100%' OR `brand` LIKE '1020100%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004938s ]
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 '1020100%' OR `brand` LIKE '1020100%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005234s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '1020100%' OR `brand` LIKE '1020100%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.030824s ]