SHOW FULL COLUMNS FROM `stock` [ RunTime:0.005801s ]
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 '335721%' OR `brand` LIKE '335721%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.060942s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001886s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14527804 LIMIT 5 [ RunTime:0.052515s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14527804 ORDER BY `minOrder` ASC [ RunTime:0.008225s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002531s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14527804 ORDER BY `unit` DESC [ RunTime:0.080697s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.005716s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14527804 LIMIT 2 [ RunTime:0.135737s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14527804 ORDER BY `minOrder` ASC [ RunTime:0.093592s ]
select * from pdf where partno='33572110015001' and brandshort='HARTING' limit 1 [ RunTime:0.126668s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14527788 LIMIT 5 [ RunTime:0.182750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14527788 ORDER BY `minOrder` ASC [ RunTime:0.047640s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14527788 ORDER BY `unit` DESC [ RunTime:0.073673s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14527788 LIMIT 2 [ RunTime:0.084512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14527788 ORDER BY `minOrder` ASC [ RunTime:0.088791s ]
select * from pdf where partno='33572110015004' and brandshort='HARTING' limit 1 [ RunTime:0.103839s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14527784 LIMIT 5 [ RunTime:0.116664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14527784 ORDER BY `minOrder` ASC [ RunTime:0.072523s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14527784 ORDER BY `unit` DESC [ RunTime:0.072374s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14527784 LIMIT 2 [ RunTime:0.037279s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14527784 ORDER BY `minOrder` ASC [ RunTime:0.053539s ]
select * from pdf where partno='33572110060002' and brandshort='HARTING' limit 1 [ RunTime:0.057348s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14527777 LIMIT 5 [ RunTime:0.031310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14527777 ORDER BY `minOrder` ASC [ RunTime:0.057880s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14527777 ORDER BY `unit` DESC [ RunTime:0.083718s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14527777 LIMIT 2 [ RunTime:0.006265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14527777 ORDER BY `minOrder` ASC [ RunTime:0.149543s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14527759 LIMIT 5 [ RunTime:0.162214s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14527759 ORDER BY `minOrder` ASC [ RunTime:0.081698s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14527759 ORDER BY `unit` DESC [ RunTime:0.075091s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14527759 LIMIT 2 [ RunTime:0.060247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14527759 ORDER BY `minOrder` ASC [ RunTime:0.067029s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14527758 LIMIT 5 [ RunTime:0.039355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14527758 ORDER BY `minOrder` ASC [ RunTime:0.046253s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14527758 ORDER BY `unit` DESC [ RunTime:0.024769s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14527758 LIMIT 2 [ RunTime:0.172947s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14527758 ORDER BY `minOrder` ASC [ RunTime:0.083620s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14527749 LIMIT 5 [ RunTime:0.077416s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14527749 ORDER BY `minOrder` ASC [ RunTime:0.061825s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14527749 ORDER BY `unit` DESC [ RunTime:0.050937s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14527749 LIMIT 2 [ RunTime:0.102766s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14527749 ORDER BY `minOrder` ASC [ RunTime:0.080992s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14527426 LIMIT 5 [ RunTime:0.059169s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14527426 ORDER BY `minOrder` ASC [ RunTime:0.038347s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14527426 ORDER BY `unit` DESC [ RunTime:0.036590s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14527426 LIMIT 2 [ RunTime:0.039461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14527426 ORDER BY `minOrder` ASC [ RunTime:0.033595s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14527415 LIMIT 5 [ RunTime:0.043552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14527415 ORDER BY `minOrder` ASC [ RunTime:0.019666s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14527415 ORDER BY `unit` DESC [ RunTime:0.025591s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14527415 LIMIT 2 [ RunTime:0.049060s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14527415 ORDER BY `minOrder` ASC [ RunTime:0.007234s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14527404 LIMIT 5 [ RunTime:0.033535s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14527404 ORDER BY `minOrder` ASC [ RunTime:0.013220s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14527404 ORDER BY `unit` DESC [ RunTime:0.012688s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14527404 LIMIT 2 [ RunTime:0.056338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14527404 ORDER BY `minOrder` ASC [ RunTime:0.066166s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14527397 LIMIT 5 [ RunTime:0.017350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14527397 ORDER BY `minOrder` ASC [ RunTime:0.015460s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14527397 ORDER BY `unit` DESC [ RunTime:0.047496s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14527397 LIMIT 2 [ RunTime:0.040199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14527397 ORDER BY `minOrder` ASC [ RunTime:0.011493s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14527362 LIMIT 5 [ RunTime:0.018051s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14527362 ORDER BY `minOrder` ASC [ RunTime:0.017375s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14527362 ORDER BY `unit` DESC [ RunTime:0.017448s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14527362 LIMIT 2 [ RunTime:0.005406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14527362 ORDER BY `minOrder` ASC [ RunTime:0.019435s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14527341 LIMIT 5 [ RunTime:0.004785s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14527341 ORDER BY `minOrder` ASC [ RunTime:0.005026s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14527341 ORDER BY `unit` DESC [ RunTime:0.006127s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14527341 LIMIT 2 [ RunTime:0.011444s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14527341 ORDER BY `minOrder` ASC [ RunTime:0.005158s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14527312 LIMIT 5 [ RunTime:0.007684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14527312 ORDER BY `minOrder` ASC [ RunTime:0.001368s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14527312 ORDER BY `unit` DESC [ RunTime:0.000760s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14527312 LIMIT 2 [ RunTime:0.003822s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14527312 ORDER BY `minOrder` ASC [ RunTime:0.001308s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14443175 LIMIT 5 [ RunTime:0.006204s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14443175 ORDER BY `minOrder` ASC [ RunTime:0.002835s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14443175 ORDER BY `unit` DESC [ RunTime:0.000867s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14443175 LIMIT 2 [ RunTime:0.000617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14443175 ORDER BY `minOrder` ASC [ RunTime:0.001170s ]
select * from pdf where partno='33572111005001' and brandshort='HARTING' limit 1 [ RunTime:0.002808s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14441747 LIMIT 5 [ RunTime:0.005588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14441747 ORDER BY `minOrder` ASC [ RunTime:0.001601s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14441747 ORDER BY `unit` DESC [ RunTime:0.000665s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14441747 LIMIT 2 [ RunTime:0.003150s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14441747 ORDER BY `minOrder` ASC [ RunTime:0.001663s ]
select * from pdf where partno='33572110405002' and brandshort='HARTING' limit 1 [ RunTime:0.003129s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14441746 LIMIT 5 [ RunTime:0.004328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14441746 ORDER BY `minOrder` ASC [ RunTime:0.004808s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14441746 ORDER BY `unit` DESC [ RunTime:0.000706s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14441746 LIMIT 2 [ RunTime:0.003045s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14441746 ORDER BY `minOrder` ASC [ RunTime:0.001905s ]
select * from pdf where partno='33572110405001' and brandshort='HARTING' limit 1 [ RunTime:0.001571s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13659889 LIMIT 5 [ RunTime:0.002550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13659889 ORDER BY `minOrder` ASC [ RunTime:0.001597s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13659889 ORDER BY `unit` DESC [ RunTime:0.000817s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13659889 LIMIT 2 [ RunTime:0.001223s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13659889 ORDER BY `minOrder` ASC [ RunTime:0.003051s ]
select * from pdf where partno='33572110100001' and brandshort='HARTING' limit 1 [ RunTime:0.007183s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13659880 LIMIT 5 [ RunTime:0.012511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13659880 ORDER BY `minOrder` ASC [ RunTime:0.002161s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13659880 ORDER BY `unit` DESC [ RunTime:0.006974s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13659880 LIMIT 2 [ RunTime:0.004582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13659880 ORDER BY `minOrder` ASC [ RunTime:0.000974s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13659870 LIMIT 5 [ RunTime:0.000914s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13659870 ORDER BY `minOrder` ASC [ RunTime:0.000712s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13659870 ORDER BY `unit` DESC [ RunTime:0.002973s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13659870 LIMIT 2 [ RunTime:0.004983s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13659870 ORDER BY `minOrder` ASC [ RunTime:0.001393s ]
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 '335721%' OR `brand` LIKE '335721%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005603s ]
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 '335721%' OR `brand` LIKE '335721%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005544s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56173009 LIMIT 5 [ RunTime:0.000474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56173009 ORDER BY `minOrder` ASC [ RunTime:0.000797s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56173009 ORDER BY `unit` DESC [ RunTime:0.001181s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56173009 LIMIT 2 [ RunTime:0.000880s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56173009 ORDER BY `minOrder` ASC [ RunTime:0.000456s ]
select * from pdf where partno='33572110950001' and brandshort='HARTING' limit 1 [ RunTime:0.001606s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001122s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '33572110950001' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.005240s ]
SELECT `id` FROM `stock` WHERE `id` <> 56173009 AND `partno` = '33572110950001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.000620s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14527426 [ RunTime:0.000520s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56172993 LIMIT 5 [ RunTime:0.003816s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56172993 ORDER BY `minOrder` ASC [ RunTime:0.000609s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56172993 ORDER BY `unit` DESC [ RunTime:0.000377s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56172993 LIMIT 2 [ RunTime:0.000518s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56172993 ORDER BY `minOrder` ASC [ RunTime:0.000527s ]
select * from pdf where partno='33572110850001' and brandshort='HARTING' limit 1 [ RunTime:0.001263s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '33572110850001' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.000953s ]
SELECT `id` FROM `stock` WHERE `id` <> 56172993 AND `partno` = '33572110850001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.009637s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14527415 [ RunTime:0.004045s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56172972 LIMIT 5 [ RunTime:0.001396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56172972 ORDER BY `minOrder` ASC [ RunTime:0.000547s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56172972 ORDER BY `unit` DESC [ RunTime:0.003903s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56172972 LIMIT 2 [ RunTime:0.001015s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56172972 ORDER BY `minOrder` ASC [ RunTime:0.000649s ]
select * from pdf where partno='33572110750001' and brandshort='HARTING' limit 1 [ RunTime:0.001027s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '33572110750001' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.002817s ]
SELECT `id` FROM `stock` WHERE `id` <> 56172972 AND `partno` = '33572110750001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.001083s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14527404 [ RunTime:0.002540s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56172953 LIMIT 5 [ RunTime:0.004526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56172953 ORDER BY `minOrder` ASC [ RunTime:0.000890s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56172953 ORDER BY `unit` DESC [ RunTime:0.006490s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56172953 LIMIT 2 [ RunTime:0.003111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56172953 ORDER BY `minOrder` ASC [ RunTime:0.000740s ]
select * from pdf where partno='33572110700001' and brandshort='HARTING' limit 1 [ RunTime:0.002850s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '33572110700001' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.004749s ]
SELECT `id` FROM `stock` WHERE `id` <> 56172953 AND `partno` = '33572110700001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.002191s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14527397 [ RunTime:0.004091s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56172933 LIMIT 5 [ RunTime:0.005048s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56172933 ORDER BY `minOrder` ASC [ RunTime:0.001821s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56172933 ORDER BY `unit` DESC [ RunTime:0.002599s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56172933 LIMIT 2 [ RunTime:0.001711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56172933 ORDER BY `minOrder` ASC [ RunTime:0.001532s ]
select * from pdf where partno='33572110660001' and brandshort='HARTING' limit 1 [ RunTime:0.001703s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '33572110660001' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.004308s ]
SELECT `id` FROM `stock` WHERE `id` <> 56172933 AND `partno` = '33572110660001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.008380s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13659215 [ RunTime:0.013788s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56172852 LIMIT 5 [ RunTime:0.042838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56172852 ORDER BY `minOrder` ASC [ RunTime:0.043196s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56172852 ORDER BY `unit` DESC [ RunTime:0.031578s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56172852 LIMIT 2 [ RunTime:0.059562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56172852 ORDER BY `minOrder` ASC [ RunTime:0.028252s ]
select * from pdf where partno='33572110550001' and brandshort='HARTING' limit 1 [ RunTime:0.034762s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '33572110550001' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.023908s ]
SELECT `id` FROM `stock` WHERE `id` <> 56172852 AND `partno` = '33572110550001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.024631s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14527362 [ RunTime:0.025309s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56172828 LIMIT 5 [ RunTime:0.049392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56172828 ORDER BY `minOrder` ASC [ RunTime:0.027242s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56172828 ORDER BY `unit` DESC [ RunTime:0.021553s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56172828 LIMIT 2 [ RunTime:0.097448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56172828 ORDER BY `minOrder` ASC [ RunTime:0.005590s ]
select * from pdf where partno='33572110520001' and brandshort='HARTING' limit 1 [ RunTime:0.053002s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '33572110520001' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.055951s ]
SELECT `id` FROM `stock` WHERE `id` <> 56172828 AND `partno` = '33572110520001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.097160s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13658951 [ RunTime:0.044907s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56172810 LIMIT 5 [ RunTime:0.109242s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56172810 ORDER BY `minOrder` ASC [ RunTime:0.087570s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56172810 ORDER BY `unit` DESC [ RunTime:0.068462s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56172810 LIMIT 2 [ RunTime:0.010424s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56172810 ORDER BY `minOrder` ASC [ RunTime:0.000948s ]
select * from pdf where partno='33572110500001' and brandshort='HARTING' limit 1 [ RunTime:0.003012s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '33572110500001' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.007051s ]
SELECT `id` FROM `stock` WHERE `id` <> 56172810 AND `partno` = '33572110500001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.001611s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13659177 [ RunTime:0.003718s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56172806 LIMIT 5 [ RunTime:0.008298s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56172806 ORDER BY `minOrder` ASC [ RunTime:0.006659s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56172806 ORDER BY `unit` DESC [ RunTime:0.023508s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56172806 LIMIT 2 [ RunTime:0.015777s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56172806 ORDER BY `minOrder` ASC [ RunTime:0.005953s ]
select * from pdf where partno='33572110500002' and brandshort='HARTING' limit 1 [ RunTime:0.005129s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '33572110500002' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.005913s ]
SELECT `id` FROM `stock` WHERE `id` <> 56172806 AND `partno` = '33572110500002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.016115s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13659170 [ RunTime:0.008794s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56172730 LIMIT 5 [ RunTime:0.019713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56172730 ORDER BY `minOrder` ASC [ RunTime:0.006403s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56172730 ORDER BY `unit` DESC [ RunTime:0.003742s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56172730 LIMIT 2 [ RunTime:0.005138s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56172730 ORDER BY `minOrder` ASC [ RunTime:0.003829s ]
select * from pdf where partno='33572110420001' and brandshort='HARTING' limit 1 [ RunTime:0.006008s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '33572110420001' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.003188s ]
SELECT `id` FROM `stock` WHERE `id` <> 56172730 AND `partno` = '33572110420001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.009077s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13658900 [ RunTime:0.001716s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56172705 LIMIT 5 [ RunTime:0.014411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56172705 ORDER BY `minOrder` ASC [ RunTime:0.002721s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56172705 ORDER BY `unit` DESC [ RunTime:0.001902s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56172705 LIMIT 2 [ RunTime:0.005166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56172705 ORDER BY `minOrder` ASC [ RunTime:0.002036s ]
select * from pdf where partno='33572110400001' and brandshort='HARTING' limit 1 [ RunTime:0.008282s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '33572110400001' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.002925s ]
SELECT `id` FROM `stock` WHERE `id` <> 56172705 AND `partno` = '33572110400001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.010427s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13659118 [ RunTime:0.004829s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56172546 LIMIT 5 [ RunTime:0.007368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56172546 ORDER BY `minOrder` ASC [ RunTime:0.007704s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56172546 ORDER BY `unit` DESC [ RunTime:0.000619s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56172546 LIMIT 2 [ RunTime:0.003017s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56172546 ORDER BY `minOrder` ASC [ RunTime:0.002470s ]
select * from pdf where partno='33572110300001' and brandshort='HARTING' limit 1 [ RunTime:0.001609s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '33572110300001' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.013754s ]
SELECT `id` FROM `stock` WHERE `id` <> 56172546 AND `partno` = '33572110300001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.002764s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13659046 [ RunTime:0.005167s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56172532 LIMIT 5 [ RunTime:0.006370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56172532 ORDER BY `minOrder` ASC [ RunTime:0.003056s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56172532 ORDER BY `unit` DESC [ RunTime:0.001192s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56172532 LIMIT 2 [ RunTime:0.001212s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56172532 ORDER BY `minOrder` ASC [ RunTime:0.001801s ]
select * from pdf where partno='33572110300002' and brandshort='HARTING' limit 1 [ RunTime:0.001160s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '33572110300002' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.004369s ]
SELECT `id` FROM `stock` WHERE `id` <> 56172532 AND `partno` = '33572110300002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.001778s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13659033 [ RunTime:0.005012s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56172392 LIMIT 5 [ RunTime:0.007885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56172392 ORDER BY `minOrder` ASC [ RunTime:0.001105s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56172392 ORDER BY `unit` DESC [ RunTime:0.000454s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56172392 LIMIT 2 [ RunTime:0.000442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56172392 ORDER BY `minOrder` ASC [ RunTime:0.001697s ]
select * from pdf where partno='33572110200001' and brandshort='HARTING' limit 1 [ RunTime:0.001283s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '33572110200001' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.003397s ]
SELECT `id` FROM `stock` WHERE `id` <> 56172392 AND `partno` = '33572110200001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.000897s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13659005 [ RunTime:0.001457s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56172368 LIMIT 5 [ RunTime:0.006820s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56172368 ORDER BY `minOrder` ASC [ RunTime:0.001025s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56172368 ORDER BY `unit` DESC [ RunTime:0.000578s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56172368 LIMIT 2 [ RunTime:0.000499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56172368 ORDER BY `minOrder` ASC [ RunTime:0.000757s ]
select * from pdf where partno='33572110105001' and brandshort='HARTING' limit 1 [ RunTime:0.001949s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '33572110105001' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.004363s ]
SELECT `id` FROM `stock` WHERE `id` <> 56172368 AND `partno` = '33572110105001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.004695s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13658921 [ RunTime:0.003553s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56172367 LIMIT 5 [ RunTime:0.007072s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56172367 ORDER BY `minOrder` ASC [ RunTime:0.003542s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56172367 ORDER BY `unit` DESC [ RunTime:0.001607s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56172367 LIMIT 2 [ RunTime:0.000676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56172367 ORDER BY `minOrder` ASC [ RunTime:0.000699s ]
select * from pdf where partno='33572110200002' and brandshort='HARTING' limit 1 [ RunTime:0.004553s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '33572110200002' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.001869s ]
SELECT `id` FROM `stock` WHERE `id` <> 56172367 AND `partno` = '33572110200002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.000958s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14527341 [ RunTime:0.002464s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56172364 LIMIT 5 [ RunTime:0.007161s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56172364 ORDER BY `minOrder` ASC [ RunTime:0.001225s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56172364 ORDER BY `unit` DESC [ RunTime:0.003280s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56172364 LIMIT 2 [ RunTime:0.001485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56172364 ORDER BY `minOrder` ASC [ RunTime:0.000722s ]
select * from pdf where partno='33572110300004' and brandshort='HARTING' limit 1 [ RunTime:0.001437s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '33572110300004' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.002933s ]
SELECT `id` FROM `stock` WHERE `id` <> 56172364 AND `partno` = '33572110300004' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.001541s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13658928 [ RunTime:0.001184s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56172352 LIMIT 5 [ RunTime:0.003340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56172352 ORDER BY `minOrder` ASC [ RunTime:0.001057s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56172352 ORDER BY `unit` DESC [ RunTime:0.001921s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56172352 LIMIT 2 [ RunTime:0.003548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56172352 ORDER BY `minOrder` ASC [ RunTime:0.000753s ]
select * from pdf where partno='33572110180001' and brandshort='HARTING' limit 1 [ RunTime:0.001180s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '33572110180001' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.005054s ]
SELECT `id` FROM `stock` WHERE `id` <> 56172352 AND `partno` = '33572110180001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.002855s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13659829 [ RunTime:0.000735s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56172345 LIMIT 5 [ RunTime:0.007363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56172345 ORDER BY `minOrder` ASC [ RunTime:0.001753s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56172345 ORDER BY `unit` DESC [ RunTime:0.002367s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56172345 LIMIT 2 [ RunTime:0.000994s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56172345 ORDER BY `minOrder` ASC [ RunTime:0.000825s ]
select * from pdf where partno='33572110200003' and brandshort='HARTING' limit 1 [ RunTime:0.001301s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '33572110200003' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.002279s ]
SELECT `id` FROM `stock` WHERE `id` <> 56172345 AND `partno` = '33572110200003' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.001836s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13658874 [ RunTime:0.000927s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56172293 LIMIT 5 [ RunTime:0.000678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56172293 ORDER BY `minOrder` ASC [ RunTime:0.001346s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56172293 ORDER BY `unit` DESC [ RunTime:0.000654s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56172293 LIMIT 2 [ RunTime:0.001080s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56172293 ORDER BY `minOrder` ASC [ RunTime:0.000929s ]
select * from pdf where partno='33572110150001' and brandshort='HARTING' limit 1 [ RunTime:0.000942s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '33572110150001' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.003012s ]
SELECT `id` FROM `stock` WHERE `id` <> 56172293 AND `partno` = '33572110150001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.004130s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14527312 [ RunTime:0.000705s ]
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 '335721%' OR `brand` LIKE '335721%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007428s ]
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 '335721%' OR `brand` LIKE '335721%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001259s ]
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 '335721%' OR `brand` LIKE '335721%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003359s ]
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 '335721%' OR `brand` LIKE '335721%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001147s ]
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 '335721%' OR `brand` LIKE '335721%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001156s ]
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 '335721%' OR `brand` LIKE '335721%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001148s ]
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 '335721%' OR `brand` LIKE '335721%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002307s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '335721%' OR `brand` LIKE '335721%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001648s ]