SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003503s ]
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 '55104%' OR `brand` LIKE '55104%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.071363s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.006515s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18904802 LIMIT 5 [ RunTime:0.043785s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.008638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18904802 ORDER BY `minOrder` ASC [ RunTime:0.054107s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003269s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18904802 ORDER BY `unit` DESC [ RunTime:0.024900s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.012652s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18904802 LIMIT 2 [ RunTime:0.018440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18904802 ORDER BY `minOrder` ASC [ RunTime:0.025602s ]
select * from pdf where partno='5510409F' and brandshort='Dialight' limit 1 [ RunTime:0.051430s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18906398 LIMIT 5 [ RunTime:0.019889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18906398 ORDER BY `minOrder` ASC [ RunTime:0.057290s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18906398 ORDER BY `unit` DESC [ RunTime:0.058245s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18906398 LIMIT 2 [ RunTime:0.052743s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18906398 ORDER BY `minOrder` ASC [ RunTime:0.029379s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18906408 LIMIT 5 [ RunTime:0.061871s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18906408 ORDER BY `minOrder` ASC [ RunTime:0.031992s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18906408 ORDER BY `unit` DESC [ RunTime:0.039570s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18906408 LIMIT 2 [ RunTime:0.098931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18906408 ORDER BY `minOrder` ASC [ RunTime:0.075478s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15250004 LIMIT 5 [ RunTime:0.040409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15250004 ORDER BY `minOrder` ASC [ RunTime:0.074887s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15250004 ORDER BY `unit` DESC [ RunTime:0.014458s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15250004 LIMIT 2 [ RunTime:0.002956s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15250004 ORDER BY `minOrder` ASC [ RunTime:0.003880s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18905608 LIMIT 5 [ RunTime:0.024819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18905608 ORDER BY `minOrder` ASC [ RunTime:0.011906s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18905608 ORDER BY `unit` DESC [ RunTime:0.016082s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18905608 LIMIT 2 [ RunTime:0.016368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18905608 ORDER BY `minOrder` ASC [ RunTime:0.010205s ]
select * from pdf where partno='5510407004F' and brandshort='Dialight' limit 1 [ RunTime:0.005507s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18904201 LIMIT 5 [ RunTime:0.028999s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18904201 ORDER BY `minOrder` ASC [ RunTime:0.003916s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18904201 ORDER BY `unit` DESC [ RunTime:0.019969s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18904201 LIMIT 2 [ RunTime:0.008051s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18904201 ORDER BY `minOrder` ASC [ RunTime:0.006372s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18908374 LIMIT 5 [ RunTime:0.011278s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18908374 ORDER BY `minOrder` ASC [ RunTime:0.004212s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18908374 ORDER BY `unit` DESC [ RunTime:0.020002s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18908374 LIMIT 2 [ RunTime:0.025582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18908374 ORDER BY `minOrder` ASC [ RunTime:0.018408s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18908189 LIMIT 5 [ RunTime:0.042883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18908189 ORDER BY `minOrder` ASC [ RunTime:0.036143s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18908189 ORDER BY `unit` DESC [ RunTime:0.029307s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18908189 LIMIT 2 [ RunTime:0.016647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18908189 ORDER BY `minOrder` ASC [ RunTime:0.008054s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18908188 LIMIT 5 [ RunTime:0.029214s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18908188 ORDER BY `minOrder` ASC [ RunTime:0.015426s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18908188 ORDER BY `unit` DESC [ RunTime:0.012315s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18908188 LIMIT 2 [ RunTime:0.015634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18908188 ORDER BY `minOrder` ASC [ RunTime:0.015757s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18906352 LIMIT 5 [ RunTime:0.028385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18906352 ORDER BY `minOrder` ASC [ RunTime:0.027772s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18906352 ORDER BY `unit` DESC [ RunTime:0.033890s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18906352 LIMIT 2 [ RunTime:0.021130s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18906352 ORDER BY `minOrder` ASC [ RunTime:0.010821s ]
select * from pdf where partno='5510407003F' and brandshort='Dialight' limit 1 [ RunTime:0.023572s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18905695 LIMIT 5 [ RunTime:0.019266s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18905695 ORDER BY `minOrder` ASC [ RunTime:0.039138s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18905695 ORDER BY `unit` DESC [ RunTime:0.033455s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18905695 LIMIT 2 [ RunTime:0.027698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18905695 ORDER BY `minOrder` ASC [ RunTime:0.006759s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18905163 LIMIT 5 [ RunTime:0.053132s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18905163 ORDER BY `minOrder` ASC [ RunTime:0.045637s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18905163 ORDER BY `unit` DESC [ RunTime:0.001090s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18905163 LIMIT 2 [ RunTime:0.010429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18905163 ORDER BY `minOrder` ASC [ RunTime:0.022948s ]
select * from pdf where partno='5510411804F' and brandshort='Dialight' limit 1 [ RunTime:0.016603s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18905162 LIMIT 5 [ RunTime:0.011696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18905162 ORDER BY `minOrder` ASC [ RunTime:0.000456s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18905162 ORDER BY `unit` DESC [ RunTime:0.022310s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18905162 LIMIT 2 [ RunTime:0.004226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18905162 ORDER BY `minOrder` ASC [ RunTime:0.014425s ]
select * from pdf where partno='5510407814F' and brandshort='Dialight' limit 1 [ RunTime:0.005528s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18904960 LIMIT 5 [ RunTime:0.019184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18904960 ORDER BY `minOrder` ASC [ RunTime:0.029231s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18904960 ORDER BY `unit` DESC [ RunTime:0.015430s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18904960 LIMIT 2 [ RunTime:0.044617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18904960 ORDER BY `minOrder` ASC [ RunTime:0.053116s ]
select * from pdf where partno='5510412F' and brandshort='Dialight' limit 1 [ RunTime:0.030925s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18904958 LIMIT 5 [ RunTime:0.026784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18904958 ORDER BY `minOrder` ASC [ RunTime:0.040530s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18904958 ORDER BY `unit` DESC [ RunTime:0.019899s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18904958 LIMIT 2 [ RunTime:0.029748s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18904958 ORDER BY `minOrder` ASC [ RunTime:0.012065s ]
select * from pdf where partno='5510409810F' and brandshort='Dialight' limit 1 [ RunTime:0.021639s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18904956 LIMIT 5 [ RunTime:0.008429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18904956 ORDER BY `minOrder` ASC [ RunTime:0.037885s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18904956 ORDER BY `unit` DESC [ RunTime:0.009891s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18904956 LIMIT 2 [ RunTime:0.020273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18904956 ORDER BY `minOrder` ASC [ RunTime:0.006721s ]
select * from pdf where partno='5510412803F' and brandshort='Dialight' limit 1 [ RunTime:0.025232s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18904954 LIMIT 5 [ RunTime:0.017008s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18904954 ORDER BY `minOrder` ASC [ RunTime:0.027884s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18904954 ORDER BY `unit` DESC [ RunTime:0.034934s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18904954 LIMIT 2 [ RunTime:0.019140s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18904954 ORDER BY `minOrder` ASC [ RunTime:0.011164s ]
select * from pdf where partno='5510409808F' and brandshort='Dialight' limit 1 [ RunTime:0.038896s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18904953 LIMIT 5 [ RunTime:0.013780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18904953 ORDER BY `minOrder` ASC [ RunTime:0.040447s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18904953 ORDER BY `unit` DESC [ RunTime:0.046016s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18904953 LIMIT 2 [ RunTime:0.055652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18904953 ORDER BY `minOrder` ASC [ RunTime:0.003489s ]
select * from pdf where partno='5510409010F' and brandshort='Dialight' limit 1 [ RunTime:0.013375s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18904919 LIMIT 5 [ RunTime:0.003348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18904919 ORDER BY `minOrder` ASC [ RunTime:0.010660s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18904919 ORDER BY `unit` DESC [ RunTime:0.005572s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18904919 LIMIT 2 [ RunTime:0.014221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18904919 ORDER BY `minOrder` ASC [ RunTime:0.016676s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18904918 LIMIT 5 [ RunTime:0.022045s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18904918 ORDER BY `minOrder` ASC [ RunTime:0.026483s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18904918 ORDER BY `unit` DESC [ RunTime:0.014670s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18904918 LIMIT 2 [ RunTime:0.022178s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18904918 ORDER BY `minOrder` ASC [ RunTime:0.030961s ]
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 '55104%' OR `brand` LIKE '55104%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025939s ]
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 '55104%' OR `brand` LIKE '55104%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.077055s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51241826 LIMIT 5 [ RunTime:0.025842s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51241826 ORDER BY `minOrder` ASC [ RunTime:0.045589s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51241826 ORDER BY `unit` DESC [ RunTime:0.048036s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51241826 LIMIT 2 [ RunTime:0.062456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51241826 ORDER BY `minOrder` ASC [ RunTime:0.016807s ]
select * from pdf where partno='5510409F' and brandshort='Dialight' limit 1 [ RunTime:0.012038s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002491s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5510409F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.040771s ]
SELECT `id` FROM `stock` WHERE `id` <> 51241826 AND `partno` = '5510409F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.011579s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18904802 [ RunTime:0.000993s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51242170 LIMIT 5 [ RunTime:0.022854s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51242170 ORDER BY `minOrder` ASC [ RunTime:0.072873s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51242170 ORDER BY `unit` DESC [ RunTime:0.028493s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51242170 LIMIT 2 [ RunTime:0.020167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51242170 ORDER BY `minOrder` ASC [ RunTime:0.048361s ]
select * from pdf where partno='5510411F' and brandshort='Dialight' limit 1 [ RunTime:0.031950s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5510411F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.033006s ]
SELECT `id` FROM `stock` WHERE `id` <> 51242170 AND `partno` = '5510411F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.029869s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18906398 [ RunTime:0.128724s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51242174 LIMIT 5 [ RunTime:0.069574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51242174 ORDER BY `minOrder` ASC [ RunTime:0.047798s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51242174 ORDER BY `unit` DESC [ RunTime:0.015235s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51242174 LIMIT 2 [ RunTime:0.038502s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51242174 ORDER BY `minOrder` ASC [ RunTime:0.010560s ]
select * from pdf where partno='5510403F' and brandshort='Dialight' limit 1 [ RunTime:0.048687s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5510403F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.027238s ]
SELECT `id` FROM `stock` WHERE `id` <> 51242174 AND `partno` = '5510403F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.058789s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18906408 [ RunTime:0.014282s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51241759 LIMIT 5 [ RunTime:0.011476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51241759 ORDER BY `minOrder` ASC [ RunTime:0.025804s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51241759 ORDER BY `unit` DESC [ RunTime:0.005644s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51241759 LIMIT 2 [ RunTime:0.042680s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51241759 ORDER BY `minOrder` ASC [ RunTime:0.008584s ]
select * from pdf where partno='5510407004F' and brandshort='Dialight' limit 1 [ RunTime:0.005497s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5510407004F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.044628s ]
SELECT `id` FROM `stock` WHERE `id` <> 51241759 AND `partno` = '5510407004F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.054427s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18905608 [ RunTime:0.028193s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51242178 LIMIT 5 [ RunTime:0.014936s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51242178 ORDER BY `minOrder` ASC [ RunTime:0.024639s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51242178 ORDER BY `unit` DESC [ RunTime:0.003641s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51242178 LIMIT 2 [ RunTime:0.038709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51242178 ORDER BY `minOrder` ASC [ RunTime:0.053057s ]
select * from pdf where partno='5510407010F' and brandshort='Dialight' limit 1 [ RunTime:0.033026s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5510407010F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.047066s ]
SELECT `id` FROM `stock` WHERE `id` <> 51242178 AND `partno` = '5510407010F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.042786s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15250004 [ RunTime:0.086165s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56213211 LIMIT 5 [ RunTime:0.099260s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56213211 ORDER BY `minOrder` ASC [ RunTime:0.040082s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56213211 ORDER BY `unit` DESC [ RunTime:0.096931s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56213211 LIMIT 2 [ RunTime:0.062277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56213211 ORDER BY `minOrder` ASC [ RunTime:0.000714s ]
select * from pdf where partno='55104 NA199' and brandshort='Alpha Wire' limit 1 [ RunTime:0.019526s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '55104 NA199' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.027532s ]
SELECT `id` FROM `stock` WHERE `id` <> 56213211 AND `partno` = '55104 NA199' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.032873s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13508340 [ RunTime:0.018815s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56212176 LIMIT 5 [ RunTime:0.038005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56212176 ORDER BY `minOrder` ASC [ RunTime:0.020554s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56212176 ORDER BY `unit` DESC [ RunTime:0.068543s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56212176 LIMIT 2 [ RunTime:0.038097s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56212176 ORDER BY `minOrder` ASC [ RunTime:0.008334s ]
select * from pdf where partno='55104 BK199' and brandshort='Alpha Wire' limit 1 [ RunTime:0.048780s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '55104 BK199' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.026897s ]
SELECT `id` FROM `stock` WHERE `id` <> 56212176 AND `partno` = '55104 BK199' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.023431s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14381095 [ RunTime:0.014363s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51246967 LIMIT 5 [ RunTime:0.036399s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51246967 ORDER BY `minOrder` ASC [ RunTime:0.050651s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51246967 ORDER BY `unit` DESC [ RunTime:0.038158s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51246967 LIMIT 2 [ RunTime:0.031245s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51246967 ORDER BY `minOrder` ASC [ RunTime:0.034347s ]
select * from pdf where partno='5510407809F' and brandshort='Dialight' limit 1 [ RunTime:0.082284s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5510407809F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.061675s ]
SELECT `id` FROM `stock` WHERE `id` <> 51246967 AND `partno` = '5510407809F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.025927s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14191897 [ RunTime:0.024472s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51245596 LIMIT 5 [ RunTime:0.081774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51245596 ORDER BY `minOrder` ASC [ RunTime:0.053137s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51245596 ORDER BY `unit` DESC [ RunTime:0.022760s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51245596 LIMIT 2 [ RunTime:0.034374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51245596 ORDER BY `minOrder` ASC [ RunTime:0.025751s ]
select * from pdf where partno='5510407003F' and brandshort='Dialight' limit 1 [ RunTime:0.030175s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5510407003F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.035219s ]
SELECT `id` FROM `stock` WHERE `id` <> 51245596 AND `partno` = '5510407003F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.108742s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18906352 [ RunTime:0.023049s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51244778 LIMIT 5 [ RunTime:0.010117s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51244778 ORDER BY `minOrder` ASC [ RunTime:0.046736s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51244778 ORDER BY `unit` DESC [ RunTime:0.026597s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51244778 LIMIT 2 [ RunTime:0.064972s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51244778 ORDER BY `minOrder` ASC [ RunTime:0.011060s ]
select * from pdf where partno='5510406003F' and brandshort='Dialight' limit 1 [ RunTime:0.029896s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5510406003F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.030506s ]
SELECT `id` FROM `stock` WHERE `id` <> 51244778 AND `partno` = '5510406003F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.055290s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18905695 [ RunTime:0.021248s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51244096 LIMIT 5 [ RunTime:0.028917s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51244096 ORDER BY `minOrder` ASC [ RunTime:0.055178s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51244096 ORDER BY `unit` DESC [ RunTime:0.040421s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51244096 LIMIT 2 [ RunTime:0.062366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51244096 ORDER BY `minOrder` ASC [ RunTime:0.015160s ]
select * from pdf where partno='5510411804F' and brandshort='Dialight' limit 1 [ RunTime:0.019438s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5510411804F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.050135s ]
SELECT `id` FROM `stock` WHERE `id` <> 51244096 AND `partno` = '5510411804F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.035870s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18905163 [ RunTime:0.039547s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51244063 LIMIT 5 [ RunTime:0.040032s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51244063 ORDER BY `minOrder` ASC [ RunTime:0.016117s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51244063 ORDER BY `unit` DESC [ RunTime:0.035679s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51244063 LIMIT 2 [ RunTime:0.043854s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51244063 ORDER BY `minOrder` ASC [ RunTime:0.012156s ]
select * from pdf where partno='5510407814F' and brandshort='Dialight' limit 1 [ RunTime:0.027197s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5510407814F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.015502s ]
SELECT `id` FROM `stock` WHERE `id` <> 51244063 AND `partno` = '5510407814F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.015352s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18905162 [ RunTime:0.004551s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51243883 LIMIT 5 [ RunTime:0.023269s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51243883 ORDER BY `minOrder` ASC [ RunTime:0.031101s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51243883 ORDER BY `unit` DESC [ RunTime:0.006459s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51243883 LIMIT 2 [ RunTime:0.028149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51243883 ORDER BY `minOrder` ASC [ RunTime:0.017858s ]
select * from pdf where partno='5510407813F' and brandshort='Dialight' limit 1 [ RunTime:0.007635s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5510407813F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.024742s ]
SELECT `id` FROM `stock` WHERE `id` <> 51243883 AND `partno` = '5510407813F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.011975s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15249777 [ RunTime:0.005205s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51243803 LIMIT 5 [ RunTime:0.034372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51243803 ORDER BY `minOrder` ASC [ RunTime:0.029091s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51243803 ORDER BY `unit` DESC [ RunTime:0.030276s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51243803 LIMIT 2 [ RunTime:0.022379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51243803 ORDER BY `minOrder` ASC [ RunTime:0.014268s ]
select * from pdf where partno='5510412F' and brandshort='Dialight' limit 1 [ RunTime:0.020782s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5510412F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.038773s ]
SELECT `id` FROM `stock` WHERE `id` <> 51243803 AND `partno` = '5510412F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.045817s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18904960 [ RunTime:0.060677s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51243802 LIMIT 5 [ RunTime:0.034858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51243802 ORDER BY `minOrder` ASC [ RunTime:0.026959s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51243802 ORDER BY `unit` DESC [ RunTime:0.042165s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51243802 LIMIT 2 [ RunTime:0.030353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51243802 ORDER BY `minOrder` ASC [ RunTime:0.018612s ]
select * from pdf where partno='5510409810F' and brandshort='Dialight' limit 1 [ RunTime:0.013369s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5510409810F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.023002s ]
SELECT `id` FROM `stock` WHERE `id` <> 51243802 AND `partno` = '5510409810F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.036639s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18904958 [ RunTime:0.035031s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51243801 LIMIT 5 [ RunTime:0.035701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51243801 ORDER BY `minOrder` ASC [ RunTime:0.023810s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51243801 ORDER BY `unit` DESC [ RunTime:0.011511s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51243801 LIMIT 2 [ RunTime:0.024445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51243801 ORDER BY `minOrder` ASC [ RunTime:0.044003s ]
select * from pdf where partno='5510409808F' and brandshort='Dialight' limit 1 [ RunTime:0.014008s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5510409808F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.023685s ]
SELECT `id` FROM `stock` WHERE `id` <> 51243801 AND `partno` = '5510409808F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.011351s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18904954 [ RunTime:0.013341s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51243768 LIMIT 5 [ RunTime:0.006725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51243768 ORDER BY `minOrder` ASC [ RunTime:0.030467s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51243768 ORDER BY `unit` DESC [ RunTime:0.014073s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51243768 LIMIT 2 [ RunTime:0.044064s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51243768 ORDER BY `minOrder` ASC [ RunTime:0.033472s ]
select * from pdf where partno='5510412803F' and brandshort='Dialight' limit 1 [ RunTime:0.012461s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5510412803F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.037020s ]
SELECT `id` FROM `stock` WHERE `id` <> 51243768 AND `partno` = '5510412803F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.024655s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18904956 [ RunTime:0.038825s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51243765 LIMIT 5 [ RunTime:0.028191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51243765 ORDER BY `minOrder` ASC [ RunTime:0.065913s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51243765 ORDER BY `unit` DESC [ RunTime:0.014872s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51243765 LIMIT 2 [ RunTime:0.027154s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51243765 ORDER BY `minOrder` ASC [ RunTime:0.027267s ]
select * from pdf where partno='5510409010F' and brandshort='Dialight' limit 1 [ RunTime:0.004640s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5510409010F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.017840s ]
SELECT `id` FROM `stock` WHERE `id` <> 51243765 AND `partno` = '5510409010F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.039583s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18904953 [ RunTime:0.011658s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51243746 LIMIT 5 [ RunTime:0.011254s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51243746 ORDER BY `minOrder` ASC [ RunTime:0.016100s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51243746 ORDER BY `unit` DESC [ RunTime:0.011942s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51243746 LIMIT 2 [ RunTime:0.020569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51243746 ORDER BY `minOrder` ASC [ RunTime:0.024661s ]
select * from pdf where partno='5510405822F' and brandshort='Dialight' limit 1 [ RunTime:0.025142s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5510405822F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.040372s ]
SELECT `id` FROM `stock` WHERE `id` <> 51243746 AND `partno` = '5510405822F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.031930s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16014965 [ RunTime:0.023228s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51243725 LIMIT 5 [ RunTime:0.013152s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51243725 ORDER BY `minOrder` ASC [ RunTime:0.009192s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51243725 ORDER BY `unit` DESC [ RunTime:0.008660s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51243725 LIMIT 2 [ RunTime:0.001788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51243725 ORDER BY `minOrder` ASC [ RunTime:0.002119s ]
select * from pdf where partno='5510407811F' and brandshort='Dialight' limit 1 [ RunTime:0.006644s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5510407811F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.002098s ]
SELECT `id` FROM `stock` WHERE `id` <> 51243725 AND `partno` = '5510407811F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.013766s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18904919 [ RunTime:0.008414s ]
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 '55104%' OR `brand` LIKE '55104%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008171s ]
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 '55104%' OR `brand` LIKE '55104%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013412s ]
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 '55104%' OR `brand` LIKE '55104%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.033236s ]
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 '55104%' OR `brand` LIKE '55104%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013794s ]
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 '55104%' OR `brand` LIKE '55104%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005237s ]
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 '55104%' OR `brand` LIKE '55104%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019101s ]
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 '55104%' OR `brand` LIKE '55104%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014718s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '55104%' OR `brand` LIKE '55104%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.020642s ]