SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002228s ]
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 '1025%' OR `brand` LIKE '1025%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.098884s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002344s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14288104 LIMIT 5 [ RunTime:0.007633s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002118s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14288104 ORDER BY `minOrder` ASC [ RunTime:0.011044s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002115s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14288104 ORDER BY `unit` DESC [ RunTime:0.006407s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003225s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14288104 LIMIT 2 [ RunTime:0.003463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14288104 ORDER BY `minOrder` ASC [ RunTime:0.010543s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12609913 LIMIT 5 [ RunTime:0.008220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12609913 ORDER BY `minOrder` ASC [ RunTime:0.019985s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12609913 ORDER BY `unit` DESC [ RunTime:0.005884s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12609913 LIMIT 2 [ RunTime:0.002651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12609913 ORDER BY `minOrder` ASC [ RunTime:0.006614s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14704526 LIMIT 5 [ RunTime:0.001408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14704526 ORDER BY `minOrder` ASC [ RunTime:0.009084s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14704526 ORDER BY `unit` DESC [ RunTime:0.014960s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14704526 LIMIT 2 [ RunTime:0.008412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14704526 ORDER BY `minOrder` ASC [ RunTime:0.005068s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13242449 LIMIT 5 [ RunTime:0.004905s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13242449 ORDER BY `minOrder` ASC [ RunTime:0.008673s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13242449 ORDER BY `unit` DESC [ RunTime:0.000892s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13242449 LIMIT 2 [ RunTime:0.004059s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13242449 ORDER BY `minOrder` ASC [ RunTime:0.003375s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11481460 LIMIT 5 [ RunTime:0.006891s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481460 ORDER BY `minOrder` ASC [ RunTime:0.006100s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11481460 ORDER BY `unit` DESC [ RunTime:0.010518s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11481460 LIMIT 2 [ RunTime:0.000635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481460 ORDER BY `minOrder` ASC [ RunTime:0.003328s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13403460 LIMIT 5 [ RunTime:0.004117s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13403460 ORDER BY `minOrder` ASC [ RunTime:0.004469s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13403460 ORDER BY `unit` DESC [ RunTime:0.001463s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13403460 LIMIT 2 [ RunTime:0.001001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13403460 ORDER BY `minOrder` ASC [ RunTime:0.001800s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13348291 LIMIT 5 [ RunTime:0.013179s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13348291 ORDER BY `minOrder` ASC [ RunTime:0.002489s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13348291 ORDER BY `unit` DESC [ RunTime:0.000657s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13348291 LIMIT 2 [ RunTime:0.001377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13348291 ORDER BY `minOrder` ASC [ RunTime:0.001311s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11483973 LIMIT 5 [ RunTime:0.005812s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11483973 ORDER BY `minOrder` ASC [ RunTime:0.002305s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11483973 ORDER BY `unit` DESC [ RunTime:0.000619s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11483973 LIMIT 2 [ RunTime:0.007761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11483973 ORDER BY `minOrder` ASC [ RunTime:0.000440s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13436802 LIMIT 5 [ RunTime:0.003076s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13436802 ORDER BY `minOrder` ASC [ RunTime:0.002897s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13436802 ORDER BY `unit` DESC [ RunTime:0.019327s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13436802 LIMIT 2 [ RunTime:0.010468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13436802 ORDER BY `minOrder` ASC [ RunTime:0.004877s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14308420 LIMIT 5 [ RunTime:0.008229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14308420 ORDER BY `minOrder` ASC [ RunTime:0.022836s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14308420 ORDER BY `unit` DESC [ RunTime:0.004487s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14308420 LIMIT 2 [ RunTime:0.010256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14308420 ORDER BY `minOrder` ASC [ RunTime:0.000460s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12613173 LIMIT 5 [ RunTime:0.011810s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12613173 ORDER BY `minOrder` ASC [ RunTime:0.015728s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12613173 ORDER BY `unit` DESC [ RunTime:0.007786s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12613173 LIMIT 2 [ RunTime:0.000819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12613173 ORDER BY `minOrder` ASC [ RunTime:0.008909s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13388576 LIMIT 5 [ RunTime:0.005282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13388576 ORDER BY `minOrder` ASC [ RunTime:0.003027s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13388576 ORDER BY `unit` DESC [ RunTime:0.003609s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13388576 LIMIT 2 [ RunTime:0.003456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13388576 ORDER BY `minOrder` ASC [ RunTime:0.004182s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13401973 LIMIT 5 [ RunTime:0.002613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13401973 ORDER BY `minOrder` ASC [ RunTime:0.003902s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13401973 ORDER BY `unit` DESC [ RunTime:0.002076s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13401973 LIMIT 2 [ RunTime:0.000637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13401973 ORDER BY `minOrder` ASC [ RunTime:0.002547s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12613053 LIMIT 5 [ RunTime:0.010826s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12613053 ORDER BY `minOrder` ASC [ RunTime:0.009715s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12613053 ORDER BY `unit` DESC [ RunTime:0.006648s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12613053 LIMIT 2 [ RunTime:0.019393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12613053 ORDER BY `minOrder` ASC [ RunTime:0.009100s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13401974 LIMIT 5 [ RunTime:0.002851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13401974 ORDER BY `minOrder` ASC [ RunTime:0.019067s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13401974 ORDER BY `unit` DESC [ RunTime:0.019842s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13401974 LIMIT 2 [ RunTime:0.006163s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13401974 ORDER BY `minOrder` ASC [ RunTime:0.004319s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13412768 LIMIT 5 [ RunTime:0.009053s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13412768 ORDER BY `minOrder` ASC [ RunTime:0.009255s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13412768 ORDER BY `unit` DESC [ RunTime:0.015597s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13412768 LIMIT 2 [ RunTime:0.011096s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13412768 ORDER BY `minOrder` ASC [ RunTime:0.003071s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12611687 LIMIT 5 [ RunTime:0.017094s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12611687 ORDER BY `minOrder` ASC [ RunTime:0.017908s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12611687 ORDER BY `unit` DESC [ RunTime:0.004917s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12611687 LIMIT 2 [ RunTime:0.000635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12611687 ORDER BY `minOrder` ASC [ RunTime:0.006724s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12613182 LIMIT 5 [ RunTime:0.005798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12613182 ORDER BY `minOrder` ASC [ RunTime:0.000772s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12613182 ORDER BY `unit` DESC [ RunTime:0.004123s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12613182 LIMIT 2 [ RunTime:0.000608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12613182 ORDER BY `minOrder` ASC [ RunTime:0.001368s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13413130 LIMIT 5 [ RunTime:0.006375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13413130 ORDER BY `minOrder` ASC [ RunTime:0.013740s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13413130 ORDER BY `unit` DESC [ RunTime:0.014909s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13413130 LIMIT 2 [ RunTime:0.025004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13413130 ORDER BY `minOrder` ASC [ RunTime:0.011397s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14294779 LIMIT 5 [ RunTime:0.014702s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14294779 ORDER BY `minOrder` ASC [ RunTime:0.011012s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14294779 ORDER BY `unit` DESC [ RunTime:0.011645s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14294779 LIMIT 2 [ RunTime:0.005722s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14294779 ORDER BY `minOrder` ASC [ RunTime:0.009116s ]
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 '1025%' OR `brand` LIKE '1025%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016000s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51105079 LIMIT 5 [ RunTime:0.024127s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51105079 ORDER BY `minOrder` ASC [ RunTime:0.057107s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51105079 ORDER BY `unit` DESC [ RunTime:0.018874s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51105079 LIMIT 2 [ RunTime:0.031287s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51105079 ORDER BY `minOrder` ASC [ RunTime:0.029600s ]
select * from pdf where partno='10250t2' and brandshort='eaton electrical' limit 1 [ RunTime:0.014636s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002422s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10250t2' OR `brand` LIKE 'eaton electrical%' ) ) LIMIT 1 [ RunTime:0.015547s ]
SELECT `id` FROM `stock` WHERE `id` <> 51105079 AND `partno` = '10250t2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton electrical%' ) [ RunTime:0.009030s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51582999 [ RunTime:0.030222s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51105078 LIMIT 5 [ RunTime:0.011988s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51105078 ORDER BY `minOrder` ASC [ RunTime:0.032804s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51105078 ORDER BY `unit` DESC [ RunTime:0.026791s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51105078 LIMIT 2 [ RunTime:0.051567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51105078 ORDER BY `minOrder` ASC [ RunTime:0.004667s ]
select * from pdf where partno='10250t1' and brandshort='eaton electrical' limit 1 [ RunTime:0.065403s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10250t1' OR `brand` LIKE 'eaton electrical%' ) ) LIMIT 1 [ RunTime:0.025210s ]
SELECT `id` FROM `stock` WHERE `id` <> 51105078 AND `partno` = '10250t1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton electrical%' ) [ RunTime:0.007146s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51583179 [ RunTime:0.018762s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51083160 LIMIT 5 [ RunTime:0.019532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51083160 ORDER BY `minOrder` ASC [ RunTime:0.055717s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51083160 ORDER BY `unit` DESC [ RunTime:0.010887s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51083160 LIMIT 2 [ RunTime:0.010203s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51083160 ORDER BY `minOrder` ASC [ RunTime:0.036232s ]
select * from pdf where partno='10250tk4' and brandshort='eaton electrical' limit 1 [ RunTime:0.016574s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10250tk4' OR `brand` LIKE 'eaton electrical%' ) ) LIMIT 1 [ RunTime:0.015521s ]
SELECT `id` FROM `stock` WHERE `id` <> 51083160 AND `partno` = '10250tk4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton electrical%' ) [ RunTime:0.010115s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51105114 LIMIT 5 [ RunTime:0.023060s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51105114 ORDER BY `minOrder` ASC [ RunTime:0.027222s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51105114 ORDER BY `unit` DESC [ RunTime:0.005458s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51105114 LIMIT 2 [ RunTime:0.020564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51105114 ORDER BY `minOrder` ASC [ RunTime:0.006993s ]
select * from pdf where partno='10250t1c' and brandshort='eaton electrical' limit 1 [ RunTime:0.013353s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10250t1c' OR `brand` LIKE 'eaton electrical%' ) ) LIMIT 1 [ RunTime:0.001103s ]
SELECT `id` FROM `stock` WHERE `id` <> 51105114 AND `partno` = '10250t1c' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton electrical%' ) [ RunTime:0.002265s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51082968 LIMIT 5 [ RunTime:0.000735s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51082968 ORDER BY `minOrder` ASC [ RunTime:0.001554s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51082968 ORDER BY `unit` DESC [ RunTime:0.001769s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51082968 LIMIT 2 [ RunTime:0.018234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51082968 ORDER BY `minOrder` ASC [ RunTime:0.002677s ]
select * from pdf where partno='10250tk2' and brandshort='eaton electrical' limit 1 [ RunTime:0.006170s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10250tk2' OR `brand` LIKE 'eaton electrical%' ) ) LIMIT 1 [ RunTime:0.014965s ]
SELECT `id` FROM `stock` WHERE `id` <> 51082968 AND `partno` = '10250tk2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton electrical%' ) [ RunTime:0.015259s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51105757 LIMIT 5 [ RunTime:0.010199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51105757 ORDER BY `minOrder` ASC [ RunTime:0.001486s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51105757 ORDER BY `unit` DESC [ RunTime:0.001726s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51105757 LIMIT 2 [ RunTime:0.001144s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51105757 ORDER BY `minOrder` ASC [ RunTime:0.000522s ]
select * from pdf where partno='10250t51c' and brandshort='eaton electrical' limit 1 [ RunTime:0.004598s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10250t51c' OR `brand` LIKE 'eaton electrical%' ) ) LIMIT 1 [ RunTime:0.014242s ]
SELECT `id` FROM `stock` WHERE `id` <> 51105757 AND `partno` = '10250t51c' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton electrical%' ) [ RunTime:0.012460s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51105161 LIMIT 5 [ RunTime:0.002444s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51105161 ORDER BY `minOrder` ASC [ RunTime:0.001118s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51105161 ORDER BY `unit` DESC [ RunTime:0.004410s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51105161 LIMIT 2 [ RunTime:0.014118s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51105161 ORDER BY `minOrder` ASC [ RunTime:0.000693s ]
select * from pdf where partno='10250t51' and brandshort='eaton electrical' limit 1 [ RunTime:0.010313s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10250t51' OR `brand` LIKE 'eaton electrical%' ) ) LIMIT 1 [ RunTime:0.002619s ]
SELECT `id` FROM `stock` WHERE `id` <> 51105161 AND `partno` = '10250t51' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton electrical%' ) [ RunTime:0.000824s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51583175 [ RunTime:0.000637s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51105162 LIMIT 5 [ RunTime:0.000578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51105162 ORDER BY `minOrder` ASC [ RunTime:0.001379s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51105162 ORDER BY `unit` DESC [ RunTime:0.037330s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51105162 LIMIT 2 [ RunTime:0.070748s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51105162 ORDER BY `minOrder` ASC [ RunTime:0.044070s ]
select * from pdf where partno='10250t3' and brandshort='eaton electrical' limit 1 [ RunTime:0.008635s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10250t3' OR `brand` LIKE 'eaton electrical%' ) ) LIMIT 1 [ RunTime:0.011596s ]
SELECT `id` FROM `stock` WHERE `id` <> 51105162 AND `partno` = '10250t3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton electrical%' ) [ RunTime:0.013712s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51583180 [ RunTime:0.010831s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51086425 LIMIT 5 [ RunTime:0.020604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51086425 ORDER BY `minOrder` ASC [ RunTime:0.017818s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51086425 ORDER BY `unit` DESC [ RunTime:0.009517s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51086425 LIMIT 2 [ RunTime:0.005351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51086425 ORDER BY `minOrder` ASC [ RunTime:0.004136s ]
select * from pdf where partno='1025401' and brandshort='phoenix contact' limit 1 [ RunTime:0.002713s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1025401' OR `brand` LIKE 'phoenix contact%' ) ) LIMIT 1 [ RunTime:0.006998s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51105164 LIMIT 5 [ RunTime:0.009166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51105164 ORDER BY `minOrder` ASC [ RunTime:0.014190s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51105164 ORDER BY `unit` DESC [ RunTime:0.013224s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51105164 LIMIT 2 [ RunTime:0.005167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51105164 ORDER BY `minOrder` ASC [ RunTime:0.010951s ]
select * from pdf where partno='10250t53' and brandshort='eaton electrical' limit 1 [ RunTime:0.012807s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10250t53' OR `brand` LIKE 'eaton electrical%' ) ) LIMIT 1 [ RunTime:0.016373s ]
SELECT `id` FROM `stock` WHERE `id` <> 51105164 AND `partno` = '10250t53' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton electrical%' ) [ RunTime:0.012444s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51582987 [ RunTime:0.011247s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51105165 LIMIT 5 [ RunTime:0.004498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51105165 ORDER BY `minOrder` ASC [ RunTime:0.007183s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51105165 ORDER BY `unit` DESC [ RunTime:0.012629s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51105165 LIMIT 2 [ RunTime:0.012298s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51105165 ORDER BY `minOrder` ASC [ RunTime:0.004948s ]
select * from pdf where partno='10250t53c' and brandshort='eaton electrical' limit 1 [ RunTime:0.004815s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10250t53c' OR `brand` LIKE 'eaton electrical%' ) ) LIMIT 1 [ RunTime:0.011453s ]
SELECT `id` FROM `stock` WHERE `id` <> 51105165 AND `partno` = '10250t53c' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton electrical%' ) [ RunTime:0.018076s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51083900 LIMIT 5 [ RunTime:0.011448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51083900 ORDER BY `minOrder` ASC [ RunTime:0.007496s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51083900 ORDER BY `unit` DESC [ RunTime:0.002132s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51083900 LIMIT 2 [ RunTime:0.005255s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51083900 ORDER BY `minOrder` ASC [ RunTime:0.020763s ]
select * from pdf where partno='10250t1353' and brandshort='eaton electrical' limit 1 [ RunTime:0.010703s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10250t1353' OR `brand` LIKE 'eaton electrical%' ) ) LIMIT 1 [ RunTime:0.003475s ]
SELECT `id` FROM `stock` WHERE `id` <> 51083900 AND `partno` = '10250t1353' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton electrical%' ) [ RunTime:0.011428s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51579653 [ RunTime:0.003148s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51105756 LIMIT 5 [ RunTime:0.022322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51105756 ORDER BY `minOrder` ASC [ RunTime:0.009092s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51105756 ORDER BY `unit` DESC [ RunTime:0.022251s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51105756 LIMIT 2 [ RunTime:0.004638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51105756 ORDER BY `minOrder` ASC [ RunTime:0.010789s ]
select * from pdf where partno='10250t44' and brandshort='eaton electrical' limit 1 [ RunTime:0.007093s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10250t44' OR `brand` LIKE 'eaton electrical%' ) ) LIMIT 1 [ RunTime:0.002738s ]
SELECT `id` FROM `stock` WHERE `id` <> 51105756 AND `partno` = '10250t44' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton electrical%' ) [ RunTime:0.000904s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51105754 LIMIT 5 [ RunTime:0.002942s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51105754 ORDER BY `minOrder` ASC [ RunTime:0.000764s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51105754 ORDER BY `unit` DESC [ RunTime:0.011839s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51105754 LIMIT 2 [ RunTime:0.000881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51105754 ORDER BY `minOrder` ASC [ RunTime:0.003301s ]
select * from pdf where partno='10250t2c' and brandshort='eaton electrical' limit 1 [ RunTime:0.010242s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10250t2c' OR `brand` LIKE 'eaton electrical%' ) ) LIMIT 1 [ RunTime:0.003890s ]
SELECT `id` FROM `stock` WHERE `id` <> 51105754 AND `partno` = '10250t2c' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton electrical%' ) [ RunTime:0.003492s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51083063 LIMIT 5 [ RunTime:0.000900s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51083063 ORDER BY `minOrder` ASC [ RunTime:0.005547s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51083063 ORDER BY `unit` DESC [ RunTime:0.017810s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51083063 LIMIT 2 [ RunTime:0.009524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51083063 ORDER BY `minOrder` ASC [ RunTime:0.000549s ]
select * from pdf where partno='10250tfl' and brandshort='eaton electrical' limit 1 [ RunTime:0.005769s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10250tfl' OR `brand` LIKE 'eaton electrical%' ) ) LIMIT 1 [ RunTime:0.001023s ]
SELECT `id` FROM `stock` WHERE `id` <> 51083063 AND `partno` = '10250tfl' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton electrical%' ) [ RunTime:0.004700s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51083062 LIMIT 5 [ RunTime:0.004503s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51083062 ORDER BY `minOrder` ASC [ RunTime:0.009788s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51083062 ORDER BY `unit` DESC [ RunTime:0.000702s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51083062 LIMIT 2 [ RunTime:0.015053s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51083062 ORDER BY `minOrder` ASC [ RunTime:0.006506s ]
select * from pdf where partno='10250t5b63' and brandshort='eaton electrical' limit 1 [ RunTime:0.007882s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10250t5b63' OR `brand` LIKE 'eaton electrical%' ) ) LIMIT 1 [ RunTime:0.003173s ]
SELECT `id` FROM `stock` WHERE `id` <> 51083062 AND `partno` = '10250t5b63' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton electrical%' ) [ RunTime:0.015560s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32175446 LIMIT 5 [ RunTime:0.000772s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32175446 ORDER BY `minOrder` ASC [ RunTime:0.001407s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32175446 ORDER BY `unit` DESC [ RunTime:0.002896s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32175446 LIMIT 2 [ RunTime:0.000749s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32175446 ORDER BY `minOrder` ASC [ RunTime:0.000449s ]
select * from pdf where partno='10250ts43' and brandshort='eaton electrical' limit 1 [ RunTime:0.006760s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10250ts43' OR `brand` LIKE 'eaton electrical%' ) ) LIMIT 1 [ RunTime:0.014921s ]
SELECT `id` FROM `stock` WHERE `id` <> 32175446 AND `partno` = '10250ts43' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton electrical%' ) [ RunTime:0.023797s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51471470 [ RunTime:0.011447s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51083697 LIMIT 5 [ RunTime:0.001542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51083697 ORDER BY `minOrder` ASC [ RunTime:0.010017s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51083697 ORDER BY `unit` DESC [ RunTime:0.015641s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51083697 LIMIT 2 [ RunTime:0.001321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51083697 ORDER BY `minOrder` ASC [ RunTime:0.005399s ]
select * from pdf where partno='10250tm67' and brandshort='eaton electrical' limit 1 [ RunTime:0.013395s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10250tm67' OR `brand` LIKE 'eaton electrical%' ) ) LIMIT 1 [ RunTime:0.031163s ]
SELECT `id` FROM `stock` WHERE `id` <> 51083697 AND `partno` = '10250tm67' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton electrical%' ) [ RunTime:0.006471s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51471448 [ RunTime:0.003935s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51105755 LIMIT 5 [ RunTime:0.008078s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51105755 ORDER BY `minOrder` ASC [ RunTime:0.014779s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51105755 ORDER BY `unit` DESC [ RunTime:0.015156s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51105755 LIMIT 2 [ RunTime:0.001794s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51105755 ORDER BY `minOrder` ASC [ RunTime:0.010698s ]
select * from pdf where partno='10250t42' and brandshort='eaton electrical' limit 1 [ RunTime:0.009932s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10250t42' OR `brand` LIKE 'eaton electrical%' ) ) LIMIT 1 [ RunTime:0.010507s ]
SELECT `id` FROM `stock` WHERE `id` <> 51105755 AND `partno` = '10250t42' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton electrical%' ) [ RunTime:0.014253s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51105163 LIMIT 5 [ RunTime:0.010606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51105163 ORDER BY `minOrder` ASC [ RunTime:0.011388s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51105163 ORDER BY `unit` DESC [ RunTime:0.016679s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51105163 LIMIT 2 [ RunTime:0.021042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51105163 ORDER BY `minOrder` ASC [ RunTime:0.011250s ]
select * from pdf where partno='10250t5-1' and brandshort='eaton electrical' limit 1 [ RunTime:0.001758s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10250t5-1' OR `brand` LIKE 'eaton electrical%' ) ) LIMIT 1 [ RunTime:0.023281s ]
SELECT `id` FROM `stock` WHERE `id` <> 51105163 AND `partno` = '10250t5-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton electrical%' ) [ RunTime:0.007777s ]
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 '1025%' OR `brand` LIKE '1025%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.064320s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40461633 LIMIT 5 [ RunTime:0.005633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40461633 ORDER BY `minOrder` ASC [ RunTime:0.001136s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40461633 ORDER BY `unit` DESC [ RunTime:0.000502s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40461633 LIMIT 2 [ RunTime:0.010358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40461633 ORDER BY `minOrder` ASC [ RunTime:0.000400s ]
select * from pdf where partno='1025R-94K' and brandshort='Delevan' limit 1 [ RunTime:0.002812s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1025R-94K' OR `brand` LIKE 'Delevan%' ) ) LIMIT 1 [ RunTime:0.006143s ]
SELECT `id` FROM `stock` WHERE `id` <> 40461633 AND `partno` = '1025R-94K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%delevan%' ) [ RunTime:0.004970s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14288104 [ RunTime:0.004664s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53527137 LIMIT 5 [ RunTime:0.003097s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53527137 ORDER BY `minOrder` ASC [ RunTime:0.010221s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53527137 ORDER BY `unit` DESC [ RunTime:0.001138s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53527137 LIMIT 2 [ RunTime:0.000658s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53527137 ORDER BY `minOrder` ASC [ RunTime:0.000447s ]
select * from pdf where partno='102548-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001351s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '102548-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.004511s ]
SELECT `id` FROM `stock` WHERE `id` <> 53527137 AND `partno` = '102548-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.005981s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12609913 [ RunTime:0.002078s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57431140 LIMIT 5 [ RunTime:0.000748s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57431140 ORDER BY `minOrder` ASC [ RunTime:0.009058s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57431140 ORDER BY `unit` DESC [ RunTime:0.002032s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57431140 LIMIT 2 [ RunTime:0.015828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57431140 ORDER BY `minOrder` ASC [ RunTime:0.000501s ]
select * from pdf where partno='102500021' and brandshort='Sigma Designs Inc.' limit 1 [ RunTime:0.004205s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '102500021' OR `brand` LIKE 'Sigma Designs Inc.%' ) ) LIMIT 1 [ RunTime:0.001105s ]
SELECT `id` FROM `stock` WHERE `id` <> 57431140 AND `partno` = '102500021' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sigma designs inc.%' ) [ RunTime:0.002919s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13242449 [ RunTime:0.006374s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53528367 LIMIT 5 [ RunTime:0.003440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53528367 ORDER BY `minOrder` ASC [ RunTime:0.004088s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53528367 ORDER BY `unit` DESC [ RunTime:0.000712s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53528367 LIMIT 2 [ RunTime:0.002980s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53528367 ORDER BY `minOrder` ASC [ RunTime:0.002437s ]
select * from pdf where partno='102548-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001178s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '102548-3' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.018459s ]
SELECT `id` FROM `stock` WHERE `id` <> 53528367 AND `partno` = '102548-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.010238s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12610778 [ RunTime:0.003118s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40461840 LIMIT 5 [ RunTime:0.005687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40461840 ORDER BY `minOrder` ASC [ RunTime:0.010503s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40461840 ORDER BY `unit` DESC [ RunTime:0.008124s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40461840 LIMIT 2 [ RunTime:0.000762s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40461840 ORDER BY `minOrder` ASC [ RunTime:0.000499s ]
select * from pdf where partno='1025-68K' and brandshort='Delevan' limit 1 [ RunTime:0.003173s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1025-68K' OR `brand` LIKE 'Delevan%' ) ) LIMIT 1 [ RunTime:0.000854s ]
SELECT `id` FROM `stock` WHERE `id` <> 40461840 AND `partno` = '1025-68K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%delevan%' ) [ RunTime:0.008881s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13403460 [ RunTime:0.009500s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53545560 LIMIT 5 [ RunTime:0.009266s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53545560 ORDER BY `minOrder` ASC [ RunTime:0.029584s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53545560 ORDER BY `unit` DESC [ RunTime:0.007540s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53545560 LIMIT 2 [ RunTime:0.001465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53545560 ORDER BY `minOrder` ASC [ RunTime:0.000521s ]
select * from pdf where partno='102541-6' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.008339s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '102541-6' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.001704s ]
SELECT `id` FROM `stock` WHERE `id` <> 53545560 AND `partno` = '102541-6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.004663s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11483973 [ RunTime:0.010910s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40475440 LIMIT 5 [ RunTime:0.005326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40475440 ORDER BY `minOrder` ASC [ RunTime:0.004570s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40475440 ORDER BY `unit` DESC [ RunTime:0.000763s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40475440 LIMIT 2 [ RunTime:0.000691s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40475440 ORDER BY `minOrder` ASC [ RunTime:0.002863s ]
select * from pdf where partno='1025-76K' and brandshort='Delevan' limit 1 [ RunTime:0.010633s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1025-76K' OR `brand` LIKE 'Delevan%' ) ) LIMIT 1 [ RunTime:0.006475s ]
SELECT `id` FROM `stock` WHERE `id` <> 40475440 AND `partno` = '1025-76K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%delevan%' ) [ RunTime:0.003999s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14308420 [ RunTime:0.004421s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57739550 LIMIT 5 [ RunTime:0.004011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57739550 ORDER BY `minOrder` ASC [ RunTime:0.007791s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57739550 ORDER BY `unit` DESC [ RunTime:0.003964s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57739550 LIMIT 2 [ RunTime:0.007275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57739550 ORDER BY `minOrder` ASC [ RunTime:0.002894s ]
select * from pdf where partno='10252CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.006419s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10252CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.003479s ]
SELECT `id` FROM `stock` WHERE `id` <> 57739550 AND `partno` = '10252CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.003089s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13348972 [ RunTime:0.001270s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57738529 LIMIT 5 [ RunTime:0.000913s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57738529 ORDER BY `minOrder` ASC [ RunTime:0.007381s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57738529 ORDER BY `unit` DESC [ RunTime:0.004881s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57738529 LIMIT 2 [ RunTime:0.027736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57738529 ORDER BY `minOrder` ASC [ RunTime:0.003500s ]
select * from pdf where partno='10250CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.001797s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10250CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.009042s ]
SELECT `id` FROM `stock` WHERE `id` <> 57738529 AND `partno` = '10250CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.020032s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13348291 [ RunTime:0.016951s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58104372 LIMIT 5 [ RunTime:0.023914s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58104372 ORDER BY `minOrder` ASC [ RunTime:0.005643s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58104372 ORDER BY `unit` DESC [ RunTime:0.006582s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58104372 LIMIT 2 [ RunTime:0.011345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58104372 ORDER BY `minOrder` ASC [ RunTime:0.006359s ]
select * from pdf where partno='1025-7' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.004514s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1025-7' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.022090s ]
SELECT `id` FROM `stock` WHERE `id` <> 58104372 AND `partno` = '1025-7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.017364s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14274210 [ RunTime:0.001129s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53545491 LIMIT 5 [ RunTime:0.013590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53545491 ORDER BY `minOrder` ASC [ RunTime:0.005984s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53545491 ORDER BY `unit` DESC [ RunTime:0.006748s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53545491 LIMIT 2 [ RunTime:0.009035s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53545491 ORDER BY `minOrder` ASC [ RunTime:0.002555s ]
select * from pdf where partno='102536-7' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.026271s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '102536-7' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.006870s ]
SELECT `id` FROM `stock` WHERE `id` <> 53545491 AND `partno` = '102536-7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.006461s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12613173 [ RunTime:0.004285s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40475161 LIMIT 5 [ RunTime:0.000825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40475161 ORDER BY `minOrder` ASC [ RunTime:0.001240s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40475161 ORDER BY `unit` DESC [ RunTime:0.005246s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40475161 LIMIT 2 [ RunTime:0.009180s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40475161 ORDER BY `minOrder` ASC [ RunTime:0.011843s ]
select * from pdf where partno='1025-02K' and brandshort='Delevan' limit 1 [ RunTime:0.012815s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1025-02K' OR `brand` LIKE 'Delevan%' ) ) LIMIT 1 [ RunTime:0.003010s ]
SELECT `id` FROM `stock` WHERE `id` <> 40475161 AND `partno` = '1025-02K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%delevan%' ) [ RunTime:0.004241s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13401974 [ RunTime:0.002130s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57739333 LIMIT 5 [ RunTime:0.004755s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57739333 ORDER BY `minOrder` ASC [ RunTime:0.001330s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57739333 ORDER BY `unit` DESC [ RunTime:0.001166s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57739333 LIMIT 2 [ RunTime:0.009520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57739333 ORDER BY `minOrder` ASC [ RunTime:0.001533s ]
select * from pdf where partno='10258CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.001253s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10258CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.003600s ]
SELECT `id` FROM `stock` WHERE `id` <> 57739333 AND `partno` = '10258CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.007863s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12066804 [ RunTime:0.013429s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56575498 LIMIT 5 [ RunTime:0.012225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56575498 ORDER BY `minOrder` ASC [ RunTime:0.015452s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56575498 ORDER BY `unit` DESC [ RunTime:0.011944s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56575498 LIMIT 2 [ RunTime:0.000679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56575498 ORDER BY `minOrder` ASC [ RunTime:0.000378s ]
select * from pdf where partno='1025A' and brandshort='Essentra Components' limit 1 [ RunTime:0.001747s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1025A' OR `brand` LIKE 'Essentra Components%' ) ) LIMIT 1 [ RunTime:0.013006s ]
SELECT `id` FROM `stock` WHERE `id` <> 56575498 AND `partno` = '1025A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%essentra components%' ) [ RunTime:0.009736s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53545474 LIMIT 5 [ RunTime:0.000639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53545474 ORDER BY `minOrder` ASC [ RunTime:0.000966s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53545474 ORDER BY `unit` DESC [ RunTime:0.006911s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53545474 LIMIT 2 [ RunTime:0.012276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53545474 ORDER BY `minOrder` ASC [ RunTime:0.006805s ]
select * from pdf where partno='102536-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000974s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '102536-3' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.003645s ]
SELECT `id` FROM `stock` WHERE `id` <> 53545474 AND `partno` = '102536-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.013951s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12613053 [ RunTime:0.020137s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40461933 LIMIT 5 [ RunTime:0.007325s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40461933 ORDER BY `minOrder` ASC [ RunTime:0.001304s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40461933 ORDER BY `unit` DESC [ RunTime:0.014308s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40461933 LIMIT 2 [ RunTime:0.003639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40461933 ORDER BY `minOrder` ASC [ RunTime:0.004912s ]
select * from pdf where partno='1025R-92K' and brandshort='Delevan' limit 1 [ RunTime:0.001251s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1025R-92K' OR `brand` LIKE 'Delevan%' ) ) LIMIT 1 [ RunTime:0.000753s ]
SELECT `id` FROM `stock` WHERE `id` <> 40461933 AND `partno` = '1025R-92K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%delevan%' ) [ RunTime:0.000737s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13438885 [ RunTime:0.005141s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40475162 LIMIT 5 [ RunTime:0.004990s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40475162 ORDER BY `minOrder` ASC [ RunTime:0.018894s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40475162 ORDER BY `unit` DESC [ RunTime:0.001230s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40475162 LIMIT 2 [ RunTime:0.000429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40475162 ORDER BY `minOrder` ASC [ RunTime:0.000271s ]
select * from pdf where partno='1025-52K' and brandshort='Delevan' limit 1 [ RunTime:0.001148s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1025-52K' OR `brand` LIKE 'Delevan%' ) ) LIMIT 1 [ RunTime:0.006302s ]
SELECT `id` FROM `stock` WHERE `id` <> 40475162 AND `partno` = '1025-52K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%delevan%' ) [ RunTime:0.018200s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13401973 [ RunTime:0.018290s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57741800 LIMIT 5 [ RunTime:0.004749s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57741800 ORDER BY `minOrder` ASC [ RunTime:0.002631s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57741800 ORDER BY `unit` DESC [ RunTime:0.002267s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57741800 LIMIT 2 [ RunTime:0.003921s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57741800 ORDER BY `minOrder` ASC [ RunTime:0.000335s ]
select * from pdf where partno='10251CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.002266s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10251CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.000740s ]
SELECT `id` FROM `stock` WHERE `id` <> 57741800 AND `partno` = '10251CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.000735s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13350541 [ RunTime:0.000836s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40475085 LIMIT 5 [ RunTime:0.006313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40475085 ORDER BY `minOrder` ASC [ RunTime:0.000830s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40475085 ORDER BY `unit` DESC [ RunTime:0.000592s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40475085 LIMIT 2 [ RunTime:0.000497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40475085 ORDER BY `minOrder` ASC [ RunTime:0.000305s ]
select * from pdf where partno='1025R-10K' and brandshort='Delevan' limit 1 [ RunTime:0.000688s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1025R-10K' OR `brand` LIKE 'Delevan%' ) ) LIMIT 1 [ RunTime:0.007677s ]
SELECT `id` FROM `stock` WHERE `id` <> 40475085 AND `partno` = '1025R-10K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%delevan%' ) [ RunTime:0.006844s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13412768 [ RunTime:0.005260s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58104373 LIMIT 5 [ RunTime:0.001649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58104373 ORDER BY `minOrder` ASC [ RunTime:0.000530s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58104373 ORDER BY `unit` DESC [ RunTime:0.000725s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58104373 LIMIT 2 [ RunTime:0.002261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58104373 ORDER BY `minOrder` ASC [ RunTime:0.002237s ]
select * from pdf where partno='1025' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.001210s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1025' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.002282s ]
SELECT `id` FROM `stock` WHERE `id` <> 58104373 AND `partno` = '1025' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.000665s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13388576 [ RunTime:0.001432s ]
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 '1025%' OR `brand` LIKE '1025%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007755s ]
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 '1025%' OR `brand` LIKE '1025%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002072s ]
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 '1025%' OR `brand` LIKE '1025%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009101s ]
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 '1025%' OR `brand` LIKE '1025%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016239s ]
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 '1025%' OR `brand` LIKE '1025%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005180s ]
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 '1025%' OR `brand` LIKE '1025%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001747s ]
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 '1025%' OR `brand` LIKE '1025%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001665s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '1025%' OR `brand` LIKE '1025%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.011384s ]