SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003433s ]
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 '2519%' OR `brand` LIKE '2519%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029947s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001195s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16419178 LIMIT 5 [ RunTime:0.031586s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16419178 ORDER BY `minOrder` ASC [ RunTime:0.046093s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.021179s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16419178 ORDER BY `unit` DESC [ RunTime:0.023704s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004635s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16419178 LIMIT 2 [ RunTime:0.026903s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16419178 ORDER BY `minOrder` ASC [ RunTime:0.012205s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13529271 LIMIT 5 [ RunTime:0.028583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13529271 ORDER BY `minOrder` ASC [ RunTime:0.011391s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13529271 ORDER BY `unit` DESC [ RunTime:0.005696s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13529271 LIMIT 2 [ RunTime:0.005237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13529271 ORDER BY `minOrder` ASC [ RunTime:0.017253s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13499811 LIMIT 5 [ RunTime:0.016972s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13499811 ORDER BY `minOrder` ASC [ RunTime:0.020187s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13499811 ORDER BY `unit` DESC [ RunTime:0.024067s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13499811 LIMIT 2 [ RunTime:0.047996s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13499811 ORDER BY `minOrder` ASC [ RunTime:0.003629s ]
select * from pdf where partno='25192 BK199' and brandshort='Alpha Wire' limit 1 [ RunTime:0.026018s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13496075 LIMIT 5 [ RunTime:0.029285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13496075 ORDER BY `minOrder` ASC [ RunTime:0.031840s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13496075 ORDER BY `unit` DESC [ RunTime:0.056375s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13496075 LIMIT 2 [ RunTime:0.040368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13496075 ORDER BY `minOrder` ASC [ RunTime:0.015349s ]
select * from pdf where partno='25198 BK199' and brandshort='Alpha Wire' limit 1 [ RunTime:0.030976s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16415356 LIMIT 5 [ RunTime:0.006241s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16415356 ORDER BY `minOrder` ASC [ RunTime:0.002398s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16415356 ORDER BY `unit` DESC [ RunTime:0.014201s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16415356 LIMIT 2 [ RunTime:0.005493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16415356 ORDER BY `minOrder` ASC [ RunTime:0.025645s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13495346 LIMIT 5 [ RunTime:0.075617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13495346 ORDER BY `minOrder` ASC [ RunTime:0.044242s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13495346 ORDER BY `unit` DESC [ RunTime:0.049998s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13495346 LIMIT 2 [ RunTime:0.014811s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13495346 ORDER BY `minOrder` ASC [ RunTime:0.015027s ]
select * from pdf where partno='25194 BK199' and brandshort='Alpha Wire' limit 1 [ RunTime:0.024439s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13495393 LIMIT 5 [ RunTime:0.029556s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13495393 ORDER BY `minOrder` ASC [ RunTime:0.012782s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13495393 ORDER BY `unit` DESC [ RunTime:0.021699s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13495393 LIMIT 2 [ RunTime:0.011711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13495393 ORDER BY `minOrder` ASC [ RunTime:0.001853s ]
select * from pdf where partno='25196 BK199' and brandshort='Alpha Wire' limit 1 [ RunTime:0.002044s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13496861 LIMIT 5 [ RunTime:0.021479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13496861 ORDER BY `minOrder` ASC [ RunTime:0.022234s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13496861 ORDER BY `unit` DESC [ RunTime:0.045082s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13496861 LIMIT 2 [ RunTime:0.009291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13496861 ORDER BY `minOrder` ASC [ RunTime:0.027224s ]
select * from pdf where partno='25196 BK005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.019297s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14354896 LIMIT 5 [ RunTime:0.051560s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14354896 ORDER BY `minOrder` ASC [ RunTime:0.028990s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14354896 ORDER BY `unit` DESC [ RunTime:0.026971s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14354896 LIMIT 2 [ RunTime:0.020090s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14354896 ORDER BY `minOrder` ASC [ RunTime:0.011068s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13807802 LIMIT 5 [ RunTime:0.063784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13807802 ORDER BY `minOrder` ASC [ RunTime:0.032486s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13807802 ORDER BY `unit` DESC [ RunTime:0.015354s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13807802 LIMIT 2 [ RunTime:0.033229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13807802 ORDER BY `minOrder` ASC [ RunTime:0.007292s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14673172 LIMIT 5 [ RunTime:0.002008s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14673172 ORDER BY `minOrder` ASC [ RunTime:0.012627s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14673172 ORDER BY `unit` DESC [ RunTime:0.047599s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14673172 LIMIT 2 [ RunTime:0.003584s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14673172 ORDER BY `minOrder` ASC [ RunTime:0.011768s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13514128 LIMIT 5 [ RunTime:0.013462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13514128 ORDER BY `minOrder` ASC [ RunTime:0.000968s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13514128 ORDER BY `unit` DESC [ RunTime:0.000748s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13514128 LIMIT 2 [ RunTime:0.005578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13514128 ORDER BY `minOrder` ASC [ RunTime:0.006456s ]
select * from pdf where partno='25194 BK005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.001165s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14697109 LIMIT 5 [ RunTime:0.001119s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14697109 ORDER BY `minOrder` ASC [ RunTime:0.007609s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14697109 ORDER BY `unit` DESC [ RunTime:0.003638s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14697109 LIMIT 2 [ RunTime:0.002440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14697109 ORDER BY `minOrder` ASC [ RunTime:0.000455s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14387945 LIMIT 5 [ RunTime:0.000423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14387945 ORDER BY `minOrder` ASC [ RunTime:0.002931s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14387945 ORDER BY `unit` DESC [ RunTime:0.002491s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14387945 LIMIT 2 [ RunTime:0.004816s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14387945 ORDER BY `minOrder` ASC [ RunTime:0.003997s ]
select * from pdf where partno='25192 BK005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000650s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13513153 LIMIT 5 [ RunTime:0.007229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13513153 ORDER BY `minOrder` ASC [ RunTime:0.008339s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13513153 ORDER BY `unit` DESC [ RunTime:0.005571s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13513153 LIMIT 2 [ RunTime:0.006883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13513153 ORDER BY `minOrder` ASC [ RunTime:0.001131s ]
select * from pdf where partno='25198 BK005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.001473s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11434326 LIMIT 5 [ RunTime:0.001983s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11434326 ORDER BY `minOrder` ASC [ RunTime:0.003414s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11434326 ORDER BY `unit` DESC [ RunTime:0.005857s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11434326 LIMIT 2 [ RunTime:0.002213s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11434326 ORDER BY `minOrder` ASC [ RunTime:0.000515s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13514604 LIMIT 5 [ RunTime:0.002139s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13514604 ORDER BY `minOrder` ASC [ RunTime:0.000745s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13514604 ORDER BY `unit` DESC [ RunTime:0.006046s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13514604 LIMIT 2 [ RunTime:0.007587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13514604 ORDER BY `minOrder` ASC [ RunTime:0.000503s ]
select * from pdf where partno='25199/15 BK005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.004129s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13514501 LIMIT 5 [ RunTime:0.016039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13514501 ORDER BY `minOrder` ASC [ RunTime:0.004541s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13514501 ORDER BY `unit` DESC [ RunTime:0.026455s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13514501 LIMIT 2 [ RunTime:0.017391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13514501 ORDER BY `minOrder` ASC [ RunTime:0.008968s ]
select * from pdf where partno='25193 BK005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.023889s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12542846 LIMIT 5 [ RunTime:0.009122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12542846 ORDER BY `minOrder` ASC [ RunTime:0.006052s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12542846 ORDER BY `unit` DESC [ RunTime:0.007690s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12542846 LIMIT 2 [ RunTime:0.011376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12542846 ORDER BY `minOrder` ASC [ RunTime:0.002079s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19263773 LIMIT 5 [ RunTime:0.013302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19263773 ORDER BY `minOrder` ASC [ RunTime:0.016190s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19263773 ORDER BY `unit` DESC [ RunTime:0.011691s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19263773 LIMIT 2 [ RunTime:0.010661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19263773 ORDER BY `minOrder` ASC [ RunTime:0.008352s ]
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 '2519%' OR `brand` LIKE '2519%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017351s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51138065 LIMIT 5 [ RunTime:0.016973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51138065 ORDER BY `minOrder` ASC [ RunTime:0.011194s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51138065 ORDER BY `unit` DESC [ RunTime:0.021116s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51138065 LIMIT 2 [ RunTime:0.023028s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51138065 ORDER BY `minOrder` ASC [ RunTime:0.010038s ]
select * from pdf where partno='25198 bk005' and brandshort='alpha wire' limit 1 [ RunTime:0.005613s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001301s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25198 bk005' OR `brand` LIKE 'alpha wire%' ) ) LIMIT 1 [ RunTime:0.002626s ]
SELECT `id` FROM `stock` WHERE `id` <> 51138065 AND `partno` = '25198 bk005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.002301s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13513153 [ RunTime:0.007750s ]
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 '2519%' OR `brand` LIKE '2519%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030225s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56182117 LIMIT 5 [ RunTime:0.013124s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56182117 ORDER BY `minOrder` ASC [ RunTime:0.019674s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56182117 ORDER BY `unit` DESC [ RunTime:0.032097s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56182117 LIMIT 2 [ RunTime:0.031553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56182117 ORDER BY `minOrder` ASC [ RunTime:0.042526s ]
select * from pdf where partno='25194 BK199' and brandshort='Alpha Wire' limit 1 [ RunTime:0.015546s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25194 BK199' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.030710s ]
SELECT `id` FROM `stock` WHERE `id` <> 56182117 AND `partno` = '25194 BK199' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.049692s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13495346 [ RunTime:0.030460s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56293864 LIMIT 5 [ RunTime:0.019688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56293864 ORDER BY `minOrder` ASC [ RunTime:0.010516s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56293864 ORDER BY `unit` DESC [ RunTime:0.008940s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56293864 LIMIT 2 [ RunTime:0.047886s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56293864 ORDER BY `minOrder` ASC [ RunTime:0.025394s ]
select * from pdf where partno='2519770001' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.015982s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2519770001' OR `brand` LIKE 'TE Connectivity Raychem Cable Protection%' ) ) LIMIT 1 [ RunTime:0.018552s ]
SELECT `id` FROM `stock` WHERE `id` <> 56293864 AND `partno` = '2519770001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity raychem cable protection%' ) [ RunTime:0.038909s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16419178 [ RunTime:0.018187s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53799620 LIMIT 5 [ RunTime:0.015720s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53799620 ORDER BY `minOrder` ASC [ RunTime:0.024723s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53799620 ORDER BY `unit` DESC [ RunTime:0.015985s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53799620 LIMIT 2 [ RunTime:0.014694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53799620 ORDER BY `minOrder` ASC [ RunTime:0.004074s ]
select * from pdf where partno='2519200000' and brandshort='Weidmüller' limit 1 [ RunTime:0.011753s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2519200000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.012728s ]
SELECT `id` FROM `stock` WHERE `id` <> 53799620 AND `partno` = '2519200000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.018110s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53799711 LIMIT 5 [ RunTime:0.008249s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53799711 ORDER BY `minOrder` ASC [ RunTime:0.007895s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53799711 ORDER BY `unit` DESC [ RunTime:0.023680s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53799711 LIMIT 2 [ RunTime:0.008201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53799711 ORDER BY `minOrder` ASC [ RunTime:0.001514s ]
select * from pdf where partno='2519230000' and brandshort='Weidmüller' limit 1 [ RunTime:0.011609s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2519230000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.018325s ]
SELECT `id` FROM `stock` WHERE `id` <> 53799711 AND `partno` = '2519230000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.017386s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56182217 LIMIT 5 [ RunTime:0.014251s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56182217 ORDER BY `minOrder` ASC [ RunTime:0.011718s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56182217 ORDER BY `unit` DESC [ RunTime:0.006460s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56182217 LIMIT 2 [ RunTime:0.010152s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56182217 ORDER BY `minOrder` ASC [ RunTime:0.004413s ]
select * from pdf where partno='25196 BK199' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000753s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25196 BK199' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.013343s ]
SELECT `id` FROM `stock` WHERE `id` <> 56182217 AND `partno` = '25196 BK199' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.005177s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13495393 [ RunTime:0.002469s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56344037 LIMIT 5 [ RunTime:0.003315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56344037 ORDER BY `minOrder` ASC [ RunTime:0.007891s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56344037 ORDER BY `unit` DESC [ RunTime:0.001863s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56344037 LIMIT 2 [ RunTime:0.001987s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56344037 ORDER BY `minOrder` ASC [ RunTime:0.006804s ]
select * from pdf where partno='2519040000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000653s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2519040000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.006251s ]
SELECT `id` FROM `stock` WHERE `id` <> 56344037 AND `partno` = '2519040000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.005261s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16415356 [ RunTime:0.001756s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53799834 LIMIT 5 [ RunTime:0.000925s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53799834 ORDER BY `minOrder` ASC [ RunTime:0.007711s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53799834 ORDER BY `unit` DESC [ RunTime:0.004065s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53799834 LIMIT 2 [ RunTime:0.008913s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53799834 ORDER BY `minOrder` ASC [ RunTime:0.007422s ]
select * from pdf where partno='2519210000' and brandshort='Weidmüller' limit 1 [ RunTime:0.002932s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2519210000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.011144s ]
SELECT `id` FROM `stock` WHERE `id` <> 53799834 AND `partno` = '2519210000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.001027s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53799841 LIMIT 5 [ RunTime:0.006802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53799841 ORDER BY `minOrder` ASC [ RunTime:0.014724s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53799841 ORDER BY `unit` DESC [ RunTime:0.005399s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53799841 LIMIT 2 [ RunTime:0.001237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53799841 ORDER BY `minOrder` ASC [ RunTime:0.004961s ]
select * from pdf where partno='2519190000' and brandshort='Weidmüller' limit 1 [ RunTime:0.010349s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2519190000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.002542s ]
SELECT `id` FROM `stock` WHERE `id` <> 53799841 AND `partno` = '2519190000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.005143s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53799835 LIMIT 5 [ RunTime:0.003182s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53799835 ORDER BY `minOrder` ASC [ RunTime:0.012929s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53799835 ORDER BY `unit` DESC [ RunTime:0.008845s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53799835 LIMIT 2 [ RunTime:0.006235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53799835 ORDER BY `minOrder` ASC [ RunTime:0.000441s ]
select * from pdf where partno='2519250000' and brandshort='Weidmüller' limit 1 [ RunTime:0.002377s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2519250000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.001486s ]
SELECT `id` FROM `stock` WHERE `id` <> 53799835 AND `partno` = '2519250000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.002629s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53800016 LIMIT 5 [ RunTime:0.003460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53800016 ORDER BY `minOrder` ASC [ RunTime:0.002578s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53800016 ORDER BY `unit` DESC [ RunTime:0.013449s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53800016 LIMIT 2 [ RunTime:0.002352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53800016 ORDER BY `minOrder` ASC [ RunTime:0.003857s ]
select * from pdf where partno='2519240000' and brandshort='Weidmüller' limit 1 [ RunTime:0.012615s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2519240000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.022057s ]
SELECT `id` FROM `stock` WHERE `id` <> 53800016 AND `partno` = '2519240000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.002589s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53800013 LIMIT 5 [ RunTime:0.000534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53800013 ORDER BY `minOrder` ASC [ RunTime:0.008934s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53800013 ORDER BY `unit` DESC [ RunTime:0.007339s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53800013 LIMIT 2 [ RunTime:0.007557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53800013 ORDER BY `minOrder` ASC [ RunTime:0.006463s ]
select * from pdf where partno='2519220000' and brandshort='Weidmüller' limit 1 [ RunTime:0.014490s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2519220000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.025389s ]
SELECT `id` FROM `stock` WHERE `id` <> 53800013 AND `partno` = '2519220000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.008727s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56344051 LIMIT 5 [ RunTime:0.015156s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56344051 ORDER BY `minOrder` ASC [ RunTime:0.003796s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56344051 ORDER BY `unit` DESC [ RunTime:0.008932s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56344051 LIMIT 2 [ RunTime:0.019107s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56344051 ORDER BY `minOrder` ASC [ RunTime:0.016458s ]
select * from pdf where partno='2519060000' and brandshort='Weidmüller' limit 1 [ RunTime:0.014927s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2519060000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.009567s ]
SELECT `id` FROM `stock` WHERE `id` <> 56344051 AND `partno` = '2519060000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.013751s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13529271 [ RunTime:0.000467s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56182261 LIMIT 5 [ RunTime:0.024603s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56182261 ORDER BY `minOrder` ASC [ RunTime:0.044832s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56182261 ORDER BY `unit` DESC [ RunTime:0.038815s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56182261 LIMIT 2 [ RunTime:0.023252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56182261 ORDER BY `minOrder` ASC [ RunTime:0.025382s ]
select * from pdf where partno='25198 BK199' and brandshort='Alpha Wire' limit 1 [ RunTime:0.008009s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25198 BK199' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.017140s ]
SELECT `id` FROM `stock` WHERE `id` <> 56182261 AND `partno` = '25198 BK199' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.046176s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13496075 [ RunTime:0.010729s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51422145 LIMIT 5 [ RunTime:0.021558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51422145 ORDER BY `minOrder` ASC [ RunTime:0.011484s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51422145 ORDER BY `unit` DESC [ RunTime:0.033581s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51422145 LIMIT 2 [ RunTime:0.014391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51422145 ORDER BY `minOrder` ASC [ RunTime:0.017129s ]
select * from pdf where partno='2519' and brandshort='Pololu' limit 1 [ RunTime:0.023985s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2519' OR `brand` LIKE 'Pololu%' ) ) LIMIT 1 [ RunTime:0.041051s ]
SELECT `id` FROM `stock` WHERE `id` <> 51422145 AND `partno` = '2519' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pololu%' ) [ RunTime:0.026487s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14354896 [ RunTime:0.020200s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56182511 LIMIT 5 [ RunTime:0.006026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56182511 ORDER BY `minOrder` ASC [ RunTime:0.050485s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56182511 ORDER BY `unit` DESC [ RunTime:0.022161s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56182511 LIMIT 2 [ RunTime:0.023081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56182511 ORDER BY `minOrder` ASC [ RunTime:0.024077s ]
select * from pdf where partno='25196 BK005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.009292s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25196 BK005' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.031033s ]
SELECT `id` FROM `stock` WHERE `id` <> 56182511 AND `partno` = '25196 BK005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.030785s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13496861 [ RunTime:0.019541s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56186796 LIMIT 5 [ RunTime:0.005022s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56186796 ORDER BY `minOrder` ASC [ RunTime:0.044295s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56186796 ORDER BY `unit` DESC [ RunTime:0.015306s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56186796 LIMIT 2 [ RunTime:0.005435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56186796 ORDER BY `minOrder` ASC [ RunTime:0.004195s ]
select * from pdf where partno='25192 BK199' and brandshort='Alpha Wire' limit 1 [ RunTime:0.007617s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25192 BK199' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.002317s ]
SELECT `id` FROM `stock` WHERE `id` <> 56186796 AND `partno` = '25192 BK199' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.008793s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13499811 [ RunTime:0.004270s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56182473 LIMIT 5 [ RunTime:0.009858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56182473 ORDER BY `minOrder` ASC [ RunTime:0.022806s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56182473 ORDER BY `unit` DESC [ RunTime:0.003103s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56182473 LIMIT 2 [ RunTime:0.002702s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56182473 ORDER BY `minOrder` ASC [ RunTime:0.011727s ]
select * from pdf where partno='25192 BK005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.007681s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25192 BK005' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.016406s ]
SELECT `id` FROM `stock` WHERE `id` <> 56182473 AND `partno` = '25192 BK005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.009848s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14387945 [ RunTime:0.033034s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57467293 LIMIT 5 [ RunTime:0.027720s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57467293 ORDER BY `minOrder` ASC [ RunTime:0.033812s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57467293 ORDER BY `unit` DESC [ RunTime:0.038486s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57467293 LIMIT 2 [ RunTime:0.025848s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57467293 ORDER BY `minOrder` ASC [ RunTime:0.005740s ]
select * from pdf where partno='2519-48MM X 55M' and brandshort='3M' limit 1 [ RunTime:0.008119s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2519-48MM X 55M' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.027354s ]
SELECT `id` FROM `stock` WHERE `id` <> 57467293 AND `partno` = '2519-48MM X 55M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.012660s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56185875 LIMIT 5 [ RunTime:0.000709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56185875 ORDER BY `minOrder` ASC [ RunTime:0.007725s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56185875 ORDER BY `unit` DESC [ RunTime:0.009046s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56185875 LIMIT 2 [ RunTime:0.003039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56185875 ORDER BY `minOrder` ASC [ RunTime:0.003720s ]
select * from pdf where partno='25194 BK005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000528s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25194 BK005' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.006158s ]
SELECT `id` FROM `stock` WHERE `id` <> 56185875 AND `partno` = '25194 BK005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.002323s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13514128 [ RunTime:0.004172s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57467315 LIMIT 5 [ RunTime:0.000477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57467315 ORDER BY `minOrder` ASC [ RunTime:0.002594s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57467315 ORDER BY `unit` DESC [ RunTime:0.003474s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57467315 LIMIT 2 [ RunTime:0.003987s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57467315 ORDER BY `minOrder` ASC [ RunTime:0.004276s ]
select * from pdf where partno='2519-72MM X 55M' and brandshort='3M' limit 1 [ RunTime:0.001034s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2519-72MM X 55M' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.004051s ]
SELECT `id` FROM `stock` WHERE `id` <> 57467315 AND `partno` = '2519-72MM X 55M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.000527s ]
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 '2519%' OR `brand` LIKE '2519%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000765s ]
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 '2519%' OR `brand` LIKE '2519%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004837s ]
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 '2519%' OR `brand` LIKE '2519%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003825s ]
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 '2519%' OR `brand` LIKE '2519%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011793s ]
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 '2519%' OR `brand` LIKE '2519%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000832s ]
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 '2519%' OR `brand` LIKE '2519%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000683s ]
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 '2519%' OR `brand` LIKE '2519%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001778s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '2519%' OR `brand` LIKE '2519%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.002470s ]