SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002815s ]
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 'WLFT 30 015%' OR `brand` LIKE 'WLFT 30 015%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.045942s ]
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 'WLFT 30 015%' OR `brand` LIKE 'WLFT 30 015%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.128969s ]
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 'WLFT 30 015%' OR `brand` LIKE 'WLFT 30 015%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026820s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.006315s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58501131 LIMIT 5 [ RunTime:0.016534s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58501131 ORDER BY `minOrder` ASC [ RunTime:0.025420s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003303s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58501131 ORDER BY `unit` DESC [ RunTime:0.014030s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.009473s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58501131 LIMIT 2 [ RunTime:0.017264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58501131 ORDER BY `minOrder` ASC [ RunTime:0.011771s ]
select * from pdf where partno='WLFT 30 015 24 x 24 Soleriq S19' and brandshort='Fischer Elektronik' limit 1 [ RunTime:0.019459s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002680s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WLFT 30 015 24 x 24 Soleriq S19' OR `brand` LIKE 'Fischer Elektronik%' ) ) LIMIT 1 [ RunTime:0.118522s ]
SELECT `id` FROM `stock` WHERE `id` <> 58501131 AND `partno` = 'WLFT 30 015 24 x 24 Soleriq S19' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fischer elektronik%' ) [ RunTime:0.025721s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58501130 LIMIT 5 [ RunTime:0.007649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58501130 ORDER BY `minOrder` ASC [ RunTime:0.010896s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58501130 ORDER BY `unit` DESC [ RunTime:0.033043s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58501130 LIMIT 2 [ RunTime:0.030882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58501130 ORDER BY `minOrder` ASC [ RunTime:0.026665s ]
select * from pdf where partno='WLFT 30 015 23,85 x 23,85 CXA25XX' and brandshort='Fischer Elektronik' limit 1 [ RunTime:0.034120s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WLFT 30 015 23,85 x 23,85 CXA25XX' OR `brand` LIKE 'Fischer Elektronik%' ) ) LIMIT 1 [ RunTime:0.035030s ]
SELECT `id` FROM `stock` WHERE `id` <> 58501130 AND `partno` = 'WLFT 30 015 23,85 x 23,85 CXA25XX' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fischer elektronik%' ) [ RunTime:0.041552s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58501129 LIMIT 5 [ RunTime:0.017453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58501129 ORDER BY `minOrder` ASC [ RunTime:0.002906s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58501129 ORDER BY `unit` DESC [ RunTime:0.007219s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58501129 LIMIT 2 [ RunTime:0.002172s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58501129 ORDER BY `minOrder` ASC [ RunTime:0.007698s ]
select * from pdf where partno='WLFT 30 015 23,85 x 23,85 CXB25XX' and brandshort='Fischer Elektronik' limit 1 [ RunTime:0.060471s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WLFT 30 015 23,85 x 23,85 CXB25XX' OR `brand` LIKE 'Fischer Elektronik%' ) ) LIMIT 1 [ RunTime:0.030974s ]
SELECT `id` FROM `stock` WHERE `id` <> 58501129 AND `partno` = 'WLFT 30 015 23,85 x 23,85 CXB25XX' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fischer elektronik%' ) [ RunTime:0.021813s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58500526 LIMIT 5 [ RunTime:0.003998s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58500526 ORDER BY `minOrder` ASC [ RunTime:0.007465s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58500526 ORDER BY `unit` DESC [ RunTime:0.017694s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58500526 LIMIT 2 [ RunTime:0.006873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58500526 ORDER BY `minOrder` ASC [ RunTime:0.002602s ]
select * from pdf where partno='WLFT 30 015 20 x 24 GW6DGB' and brandshort='Fischer Elektronik' limit 1 [ RunTime:0.036727s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WLFT 30 015 20 x 24 GW6DGB' OR `brand` LIKE 'Fischer Elektronik%' ) ) LIMIT 1 [ RunTime:0.011480s ]
SELECT `id` FROM `stock` WHERE `id` <> 58500526 AND `partno` = 'WLFT 30 015 20 x 24 GW6DGB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fischer elektronik%' ) [ RunTime:0.023779s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58500525 LIMIT 5 [ RunTime:0.020424s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58500525 ORDER BY `minOrder` ASC [ RunTime:0.005959s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58500525 ORDER BY `unit` DESC [ RunTime:0.037884s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58500525 LIMIT 2 [ RunTime:0.012232s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58500525 ORDER BY `minOrder` ASC [ RunTime:0.015245s ]
select * from pdf where partno='WLFT 30 015 20 x 24 GW6DGE' and brandshort='Fischer Elektronik' limit 1 [ RunTime:0.003979s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WLFT 30 015 20 x 24 GW6DGE' OR `brand` LIKE 'Fischer Elektronik%' ) ) LIMIT 1 [ RunTime:0.010048s ]
SELECT `id` FROM `stock` WHERE `id` <> 58500525 AND `partno` = 'WLFT 30 015 20 x 24 GW6DGE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fischer elektronik%' ) [ RunTime:0.029793s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58500524 LIMIT 5 [ RunTime:0.023265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58500524 ORDER BY `minOrder` ASC [ RunTime:0.012986s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58500524 ORDER BY `unit` DESC [ RunTime:0.008481s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58500524 LIMIT 2 [ RunTime:0.007762s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58500524 ORDER BY `minOrder` ASC [ RunTime:0.000811s ]
select * from pdf where partno='WLFT 30 015 20 x 24 GW6TGB' and brandshort='Fischer Elektronik' limit 1 [ RunTime:0.000971s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WLFT 30 015 20 x 24 GW6TGB' OR `brand` LIKE 'Fischer Elektronik%' ) ) LIMIT 1 [ RunTime:0.006332s ]
SELECT `id` FROM `stock` WHERE `id` <> 58500524 AND `partno` = 'WLFT 30 015 20 x 24 GW6TGB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fischer elektronik%' ) [ RunTime:0.013207s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58500523 LIMIT 5 [ RunTime:0.005026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58500523 ORDER BY `minOrder` ASC [ RunTime:0.004423s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58500523 ORDER BY `unit` DESC [ RunTime:0.003717s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58500523 LIMIT 2 [ RunTime:0.004576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58500523 ORDER BY `minOrder` ASC [ RunTime:0.005388s ]
select * from pdf where partno='WLFT 30 015 20 x 24 GW6DME' and brandshort='Fischer Elektronik' limit 1 [ RunTime:0.014049s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WLFT 30 015 20 x 24 GW6DME' OR `brand` LIKE 'Fischer Elektronik%' ) ) LIMIT 1 [ RunTime:0.009135s ]
SELECT `id` FROM `stock` WHERE `id` <> 58500523 AND `partno` = 'WLFT 30 015 20 x 24 GW6DME' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fischer elektronik%' ) [ RunTime:0.007059s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58500522 LIMIT 5 [ RunTime:0.018600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58500522 ORDER BY `minOrder` ASC [ RunTime:0.012863s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58500522 ORDER BY `unit` DESC [ RunTime:0.015588s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58500522 LIMIT 2 [ RunTime:0.004606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58500522 ORDER BY `minOrder` ASC [ RunTime:0.003984s ]
select * from pdf where partno='WLFT 30 015 20 x 24 Tiger ZENIGATA' and brandshort='Fischer Elektronik' limit 1 [ RunTime:0.022859s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WLFT 30 015 20 x 24 Tiger ZENIGATA' OR `brand` LIKE 'Fischer Elektronik%' ) ) LIMIT 1 [ RunTime:0.068254s ]
SELECT `id` FROM `stock` WHERE `id` <> 58500522 AND `partno` = 'WLFT 30 015 20 x 24 Tiger ZENIGATA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fischer elektronik%' ) [ RunTime:0.034631s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58500521 LIMIT 5 [ RunTime:0.037657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58500521 ORDER BY `minOrder` ASC [ RunTime:0.033819s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58500521 ORDER BY `unit` DESC [ RunTime:0.016572s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58500521 LIMIT 2 [ RunTime:0.049639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58500521 ORDER BY `minOrder` ASC [ RunTime:0.012362s ]
select * from pdf where partno='WLFT 30 015 20 x 24 GW6DGD' and brandshort='Fischer Elektronik' limit 1 [ RunTime:0.024689s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WLFT 30 015 20 x 24 GW6DGD' OR `brand` LIKE 'Fischer Elektronik%' ) ) LIMIT 1 [ RunTime:0.040575s ]
SELECT `id` FROM `stock` WHERE `id` <> 58500521 AND `partno` = 'WLFT 30 015 20 x 24 GW6DGD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fischer elektronik%' ) [ RunTime:0.021972s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58500520 LIMIT 5 [ RunTime:0.023262s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58500520 ORDER BY `minOrder` ASC [ RunTime:0.027592s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58500520 ORDER BY `unit` DESC [ RunTime:0.004750s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58500520 LIMIT 2 [ RunTime:0.050180s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58500520 ORDER BY `minOrder` ASC [ RunTime:0.014012s ]
select * from pdf where partno='WLFT 30 015 20 x 24 LEMWM24780' and brandshort='Fischer Elektronik' limit 1 [ RunTime:0.060936s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WLFT 30 015 20 x 24 LEMWM24780' OR `brand` LIKE 'Fischer Elektronik%' ) ) LIMIT 1 [ RunTime:0.101360s ]
SELECT `id` FROM `stock` WHERE `id` <> 58500520 AND `partno` = 'WLFT 30 015 20 x 24 LEMWM24780' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fischer elektronik%' ) [ RunTime:0.050907s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58500519 LIMIT 5 [ RunTime:0.060623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58500519 ORDER BY `minOrder` ASC [ RunTime:0.023049s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58500519 ORDER BY `unit` DESC [ RunTime:0.018426s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58500519 LIMIT 2 [ RunTime:0.007138s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58500519 ORDER BY `minOrder` ASC [ RunTime:0.051850s ]
select * from pdf where partno='WLFT 30 015 20 x 24 GW6TGC' and brandshort='Fischer Elektronik' limit 1 [ RunTime:0.025546s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WLFT 30 015 20 x 24 GW6TGC' OR `brand` LIKE 'Fischer Elektronik%' ) ) LIMIT 1 [ RunTime:0.073840s ]
SELECT `id` FROM `stock` WHERE `id` <> 58500519 AND `partno` = 'WLFT 30 015 20 x 24 GW6TGC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fischer elektronik%' ) [ RunTime:0.024223s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58500518 LIMIT 5 [ RunTime:0.106320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58500518 ORDER BY `minOrder` ASC [ RunTime:0.094989s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58500518 ORDER BY `unit` DESC [ RunTime:0.023050s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58500518 LIMIT 2 [ RunTime:0.056447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58500518 ORDER BY `minOrder` ASC [ RunTime:0.023773s ]
select * from pdf where partno='WLFT 30 015 20 x 24 CoB1205' and brandshort='Fischer Elektronik' limit 1 [ RunTime:0.026603s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WLFT 30 015 20 x 24 CoB1205' OR `brand` LIKE 'Fischer Elektronik%' ) ) LIMIT 1 [ RunTime:0.016141s ]
SELECT `id` FROM `stock` WHERE `id` <> 58500518 AND `partno` = 'WLFT 30 015 20 x 24 CoB1205' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fischer elektronik%' ) [ RunTime:0.035651s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58500517 LIMIT 5 [ RunTime:0.024687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58500517 ORDER BY `minOrder` ASC [ RunTime:0.019159s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58500517 ORDER BY `unit` DESC [ RunTime:0.015661s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58500517 LIMIT 2 [ RunTime:0.010205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58500517 ORDER BY `minOrder` ASC [ RunTime:0.025649s ]
select * from pdf where partno='WLFT 30 015 20 x 24 CoB1204' and brandshort='Fischer Elektronik' limit 1 [ RunTime:0.023260s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WLFT 30 015 20 x 24 CoB1204' OR `brand` LIKE 'Fischer Elektronik%' ) ) LIMIT 1 [ RunTime:0.023746s ]
SELECT `id` FROM `stock` WHERE `id` <> 58500517 AND `partno` = 'WLFT 30 015 20 x 24 CoB1204' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fischer elektronik%' ) [ RunTime:0.049671s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58500516 LIMIT 5 [ RunTime:0.013895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58500516 ORDER BY `minOrder` ASC [ RunTime:0.020840s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58500516 ORDER BY `unit` DESC [ RunTime:0.006808s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58500516 LIMIT 2 [ RunTime:0.013293s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58500516 ORDER BY `minOrder` ASC [ RunTime:0.005374s ]
select * from pdf where partno='WLFT 30 015 20 x 24 LEMWM24790' and brandshort='Fischer Elektronik' limit 1 [ RunTime:0.010542s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WLFT 30 015 20 x 24 LEMWM24790' OR `brand` LIKE 'Fischer Elektronik%' ) ) LIMIT 1 [ RunTime:0.022902s ]
SELECT `id` FROM `stock` WHERE `id` <> 58500516 AND `partno` = 'WLFT 30 015 20 x 24 LEMWM24790' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fischer elektronik%' ) [ RunTime:0.012589s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58500515 LIMIT 5 [ RunTime:0.016286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58500515 ORDER BY `minOrder` ASC [ RunTime:0.028506s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58500515 ORDER BY `unit` DESC [ RunTime:0.025565s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58500515 LIMIT 2 [ RunTime:0.016724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58500515 ORDER BY `minOrder` ASC [ RunTime:0.001719s ]
select * from pdf where partno='WLFT 30 015 20 x 24 LEMWM24B80' and brandshort='Fischer Elektronik' limit 1 [ RunTime:0.001124s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WLFT 30 015 20 x 24 LEMWM24B80' OR `brand` LIKE 'Fischer Elektronik%' ) ) LIMIT 1 [ RunTime:0.004992s ]
SELECT `id` FROM `stock` WHERE `id` <> 58500515 AND `partno` = 'WLFT 30 015 20 x 24 LEMWM24B80' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fischer elektronik%' ) [ RunTime:0.024616s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58500514 LIMIT 5 [ RunTime:0.004797s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58500514 ORDER BY `minOrder` ASC [ RunTime:0.006303s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58500514 ORDER BY `unit` DESC [ RunTime:0.007268s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58500514 LIMIT 2 [ RunTime:0.009522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58500514 ORDER BY `minOrder` ASC [ RunTime:0.001647s ]
select * from pdf where partno='WLFT 30 015 20 x 24 LEMWM24980' and brandshort='Fischer Elektronik' limit 1 [ RunTime:0.000994s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WLFT 30 015 20 x 24 LEMWM24980' OR `brand` LIKE 'Fischer Elektronik%' ) ) LIMIT 1 [ RunTime:0.004857s ]
SELECT `id` FROM `stock` WHERE `id` <> 58500514 AND `partno` = 'WLFT 30 015 20 x 24 LEMWM24980' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fischer elektronik%' ) [ RunTime:0.007218s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58500513 LIMIT 5 [ RunTime:0.006445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58500513 ORDER BY `minOrder` ASC [ RunTime:0.005598s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58500513 ORDER BY `unit` DESC [ RunTime:0.008450s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58500513 LIMIT 2 [ RunTime:0.007551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58500513 ORDER BY `minOrder` ASC [ RunTime:0.004397s ]
select * from pdf where partno='WLFT 30 015 20 x 24 CoB1208' and brandshort='Fischer Elektronik' limit 1 [ RunTime:0.007531s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WLFT 30 015 20 x 24 CoB1208' OR `brand` LIKE 'Fischer Elektronik%' ) ) LIMIT 1 [ RunTime:0.003306s ]
SELECT `id` FROM `stock` WHERE `id` <> 58500513 AND `partno` = 'WLFT 30 015 20 x 24 CoB1208' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fischer elektronik%' ) [ RunTime:0.012017s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58500512 LIMIT 5 [ RunTime:0.006523s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58500512 ORDER BY `minOrder` ASC [ RunTime:0.028825s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58500512 ORDER BY `unit` DESC [ RunTime:0.013266s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58500512 LIMIT 2 [ RunTime:0.009815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58500512 ORDER BY `minOrder` ASC [ RunTime:0.012627s ]
select * from pdf where partno='WLFT 30 015 20 x 24 GW6DMB' and brandshort='Fischer Elektronik' limit 1 [ RunTime:0.004443s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WLFT 30 015 20 x 24 GW6DMB' OR `brand` LIKE 'Fischer Elektronik%' ) ) LIMIT 1 [ RunTime:0.003328s ]
SELECT `id` FROM `stock` WHERE `id` <> 58500512 AND `partno` = 'WLFT 30 015 20 x 24 GW6DMB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fischer elektronik%' ) [ RunTime:0.001740s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58500511 LIMIT 5 [ RunTime:0.000591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58500511 ORDER BY `minOrder` ASC [ RunTime:0.000641s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58500511 ORDER BY `unit` DESC [ RunTime:0.002379s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58500511 LIMIT 2 [ RunTime:0.003911s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58500511 ORDER BY `minOrder` ASC [ RunTime:0.004909s ]
select * from pdf where partno='WLFT 30 015 20 x 24 GW6DGC' and brandshort='Fischer Elektronik' limit 1 [ RunTime:0.001223s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WLFT 30 015 20 x 24 GW6DGC' OR `brand` LIKE 'Fischer Elektronik%' ) ) LIMIT 1 [ RunTime:0.005592s ]
SELECT `id` FROM `stock` WHERE `id` <> 58500511 AND `partno` = 'WLFT 30 015 20 x 24 GW6DGC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fischer elektronik%' ) [ RunTime:0.001583s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58500510 LIMIT 5 [ RunTime:0.008673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58500510 ORDER BY `minOrder` ASC [ RunTime:0.004493s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58500510 ORDER BY `unit` DESC [ RunTime:0.006660s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58500510 LIMIT 2 [ RunTime:0.007317s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58500510 ORDER BY `minOrder` ASC [ RunTime:0.007828s ]
select * from pdf where partno='WLFT 30 015 20 x 24 GW6DMC' and brandshort='Fischer Elektronik' limit 1 [ RunTime:0.013680s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WLFT 30 015 20 x 24 GW6DMC' OR `brand` LIKE 'Fischer Elektronik%' ) ) LIMIT 1 [ RunTime:0.006793s ]
SELECT `id` FROM `stock` WHERE `id` <> 58500510 AND `partno` = 'WLFT 30 015 20 x 24 GW6DMC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fischer elektronik%' ) [ RunTime:0.002223s ]
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 'WLFT 30 015%' OR `brand` LIKE 'WLFT 30 015%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019860s ]
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 'WLFT 30 015%' OR `brand` LIKE 'WLFT 30 015%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004102s ]
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 'WLFT 30 015%' OR `brand` LIKE 'WLFT 30 015%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016814s ]
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 'WLFT 30 015%' OR `brand` LIKE 'WLFT 30 015%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022879s ]
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 'WLFT 30 015%' OR `brand` LIKE 'WLFT 30 015%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012655s ]
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 'WLFT 30 015%' OR `brand` LIKE 'WLFT 30 015%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020292s ]
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 'WLFT 30 015%' OR `brand` LIKE 'WLFT 30 015%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019013s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'WLFT 30 015%' OR `brand` LIKE 'WLFT 30 015%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.010535s ]