SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002496s ]
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 '16300%' OR `brand` LIKE '16300%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003150s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002096s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12519768 LIMIT 5 [ RunTime:0.001892s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12519768 ORDER BY `minOrder` ASC [ RunTime:0.000577s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002751s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12519768 ORDER BY `unit` DESC [ RunTime:0.006976s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002036s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12519768 LIMIT 2 [ RunTime:0.000306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12519768 ORDER BY `minOrder` ASC [ RunTime:0.000616s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11369663 LIMIT 5 [ RunTime:0.001951s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11369663 ORDER BY `minOrder` ASC [ RunTime:0.015804s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11369663 ORDER BY `unit` DESC [ RunTime:0.000531s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11369663 LIMIT 2 [ RunTime:0.000823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11369663 ORDER BY `minOrder` ASC [ RunTime:0.000650s ]
select * from pdf where partno='1630003' and brandshort='MEC Switches' limit 1 [ RunTime:0.000418s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12519511 LIMIT 5 [ RunTime:0.000700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12519511 ORDER BY `minOrder` ASC [ RunTime:0.008789s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12519511 ORDER BY `unit` DESC [ RunTime:0.001861s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12519511 LIMIT 2 [ RunTime:0.000661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12519511 ORDER BY `minOrder` ASC [ RunTime:0.000758s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12454399 LIMIT 5 [ RunTime:0.000614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12454399 ORDER BY `minOrder` ASC [ RunTime:0.000449s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12454399 ORDER BY `unit` DESC [ RunTime:0.002457s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12454399 LIMIT 2 [ RunTime:0.000301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12454399 ORDER BY `minOrder` ASC [ RunTime:0.000311s ]
select * from pdf where partno='1630008' and brandshort='MEC Switches' limit 1 [ RunTime:0.001470s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11418718 LIMIT 5 [ RunTime:0.002274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11418718 ORDER BY `minOrder` ASC [ RunTime:0.008074s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11418718 ORDER BY `unit` DESC [ RunTime:0.000454s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11418718 LIMIT 2 [ RunTime:0.000509s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11418718 ORDER BY `minOrder` ASC [ RunTime:0.000610s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12456361 LIMIT 5 [ RunTime:0.001325s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12456361 ORDER BY `minOrder` ASC [ RunTime:0.000344s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12456361 ORDER BY `unit` DESC [ RunTime:0.000323s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12456361 LIMIT 2 [ RunTime:0.000362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12456361 ORDER BY `minOrder` ASC [ RunTime:0.000309s ]
select * from pdf where partno='1630000' and brandshort='MEC Switches' limit 1 [ RunTime:0.003130s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12456363 LIMIT 5 [ RunTime:0.003474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12456363 ORDER BY `minOrder` ASC [ RunTime:0.000390s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12456363 ORDER BY `unit` DESC [ RunTime:0.001033s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12456363 LIMIT 2 [ RunTime:0.001424s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12456363 ORDER BY `minOrder` ASC [ RunTime:0.001101s ]
select * from pdf where partno='1630004' and brandshort='MEC Switches' limit 1 [ RunTime:0.001015s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16145498 LIMIT 5 [ RunTime:0.004421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16145498 ORDER BY `minOrder` ASC [ RunTime:0.011968s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16145498 ORDER BY `unit` DESC [ RunTime:0.001322s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16145498 LIMIT 2 [ RunTime:0.000398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16145498 ORDER BY `minOrder` ASC [ RunTime:0.001616s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11370525 LIMIT 5 [ RunTime:0.002581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11370525 ORDER BY `minOrder` ASC [ RunTime:0.002635s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11370525 ORDER BY `unit` DESC [ RunTime:0.000665s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11370525 LIMIT 2 [ RunTime:0.001319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11370525 ORDER BY `minOrder` ASC [ RunTime:0.001845s ]
select * from pdf where partno='1630006' and brandshort='MEC Switches' limit 1 [ RunTime:0.001843s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11370561 LIMIT 5 [ RunTime:0.004452s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11370561 ORDER BY `minOrder` ASC [ RunTime:0.001435s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11370561 ORDER BY `unit` DESC [ RunTime:0.000797s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11370561 LIMIT 2 [ RunTime:0.001663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11370561 ORDER BY `minOrder` ASC [ RunTime:0.000492s ]
select * from pdf where partno='1630002' and brandshort='MEC Switches' limit 1 [ RunTime:0.000554s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17886628 LIMIT 5 [ RunTime:0.004326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17886628 ORDER BY `minOrder` ASC [ RunTime:0.000796s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17886628 ORDER BY `unit` DESC [ RunTime:0.002924s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17886628 LIMIT 2 [ RunTime:0.001374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17886628 ORDER BY `minOrder` ASC [ RunTime:0.005131s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17877128 LIMIT 5 [ RunTime:0.000955s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17877128 ORDER BY `minOrder` ASC [ RunTime:0.000696s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17877128 ORDER BY `unit` DESC [ RunTime:0.000434s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17877128 LIMIT 2 [ RunTime:0.005014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17877128 ORDER BY `minOrder` ASC [ RunTime:0.000492s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12519766 LIMIT 5 [ RunTime:0.001643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12519766 ORDER BY `minOrder` ASC [ RunTime:0.000571s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12519766 ORDER BY `unit` DESC [ RunTime:0.000330s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12519766 LIMIT 2 [ RunTime:0.000589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12519766 ORDER BY `minOrder` ASC [ RunTime:0.002483s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12519734 LIMIT 5 [ RunTime:0.000355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12519734 ORDER BY `minOrder` ASC [ RunTime:0.000337s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12519734 ORDER BY `unit` DESC [ RunTime:0.001547s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12519734 LIMIT 2 [ RunTime:0.000610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12519734 ORDER BY `minOrder` ASC [ RunTime:0.000834s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12519732 LIMIT 5 [ RunTime:0.000337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12519732 ORDER BY `minOrder` ASC [ RunTime:0.000363s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12519732 ORDER BY `unit` DESC [ RunTime:0.001326s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12519732 LIMIT 2 [ RunTime:0.001277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12519732 ORDER BY `minOrder` ASC [ RunTime:0.002156s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12519518 LIMIT 5 [ RunTime:0.002362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12519518 ORDER BY `minOrder` ASC [ RunTime:0.005193s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12519518 ORDER BY `unit` DESC [ RunTime:0.000277s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12519518 LIMIT 2 [ RunTime:0.000233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12519518 ORDER BY `minOrder` ASC [ RunTime:0.000345s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12519472 LIMIT 5 [ RunTime:0.000634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12519472 ORDER BY `minOrder` ASC [ RunTime:0.000423s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12519472 ORDER BY `unit` DESC [ RunTime:0.000390s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12519472 LIMIT 2 [ RunTime:0.000533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12519472 ORDER BY `minOrder` ASC [ RunTime:0.003758s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12519470 LIMIT 5 [ RunTime:0.002098s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12519470 ORDER BY `minOrder` ASC [ RunTime:0.000721s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12519470 ORDER BY `unit` DESC [ RunTime:0.001989s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12519470 LIMIT 2 [ RunTime:0.008174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12519470 ORDER BY `minOrder` ASC [ RunTime:0.002233s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12519363 LIMIT 5 [ RunTime:0.000785s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12519363 ORDER BY `minOrder` ASC [ RunTime:0.002708s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12519363 ORDER BY `unit` DESC [ RunTime:0.002563s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12519363 LIMIT 2 [ RunTime:0.003120s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12519363 ORDER BY `minOrder` ASC [ RunTime:0.001845s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12519329 LIMIT 5 [ RunTime:0.000738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12519329 ORDER BY `minOrder` ASC [ RunTime:0.000545s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12519329 ORDER BY `unit` DESC [ RunTime:0.000423s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12519329 LIMIT 2 [ RunTime:0.001503s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12519329 ORDER BY `minOrder` ASC [ RunTime:0.003458s ]
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 '16300%' OR `brand` LIKE '16300%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002931s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51083071 LIMIT 5 [ RunTime:0.003287s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51083071 ORDER BY `minOrder` ASC [ RunTime:0.002993s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51083071 ORDER BY `unit` DESC [ RunTime:0.002556s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51083071 LIMIT 2 [ RunTime:0.002201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51083071 ORDER BY `minOrder` ASC [ RunTime:0.003714s ]
select * from pdf where partno='1630005' and brandshort='apem' limit 1 [ RunTime:0.003083s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001741s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1630005' OR `brand` LIKE 'apem%' ) ) LIMIT 1 [ RunTime:0.003058s ]
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 '16300%' OR `brand` LIKE '16300%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003173s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58464550 LIMIT 5 [ RunTime:0.001330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58464550 ORDER BY `minOrder` ASC [ RunTime:0.001076s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58464550 ORDER BY `unit` DESC [ RunTime:0.001078s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58464550 LIMIT 2 [ RunTime:0.002205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58464550 ORDER BY `minOrder` ASC [ RunTime:0.000693s ]
select * from pdf where partno='1630003' and brandshort='MEC Switches' limit 1 [ RunTime:0.002964s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1630003' OR `brand` LIKE 'MEC Switches%' ) ) LIMIT 1 [ RunTime:0.005759s ]
SELECT `id` FROM `stock` WHERE `id` <> 58464550 AND `partno` = '1630003' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mec switches%' ) [ RunTime:0.001646s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11369663 [ RunTime:0.003514s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53500742 LIMIT 5 [ RunTime:0.000382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53500742 ORDER BY `minOrder` ASC [ RunTime:0.001125s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53500742 ORDER BY `unit` DESC [ RunTime:0.001210s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53500742 LIMIT 2 [ RunTime:0.003151s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53500742 ORDER BY `minOrder` ASC [ RunTime:0.002896s ]
select * from pdf where partno='163008' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.004218s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '163008' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000405s ]
SELECT `id` FROM `stock` WHERE `id` <> 53500742 AND `partno` = '163008' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000749s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12519518 [ RunTime:0.002696s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53500737 LIMIT 5 [ RunTime:0.005655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53500737 ORDER BY `minOrder` ASC [ RunTime:0.005696s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53500737 ORDER BY `unit` DESC [ RunTime:0.004302s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53500737 LIMIT 2 [ RunTime:0.003756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53500737 ORDER BY `minOrder` ASC [ RunTime:0.001290s ]
select * from pdf where partno='163006' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.003354s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '163006' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.006486s ]
SELECT `id` FROM `stock` WHERE `id` <> 53500737 AND `partno` = '163006' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.003093s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11418718 [ RunTime:0.002286s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58464376 LIMIT 5 [ RunTime:0.000949s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58464376 ORDER BY `minOrder` ASC [ RunTime:0.003760s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58464376 ORDER BY `unit` DESC [ RunTime:0.000749s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58464376 LIMIT 2 [ RunTime:0.004737s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58464376 ORDER BY `minOrder` ASC [ RunTime:0.004383s ]
select * from pdf where partno='1630008' and brandshort='MEC Switches' limit 1 [ RunTime:0.000616s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1630008' OR `brand` LIKE 'MEC Switches%' ) ) LIMIT 1 [ RunTime:0.002680s ]
SELECT `id` FROM `stock` WHERE `id` <> 58464376 AND `partno` = '1630008' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mec switches%' ) [ RunTime:0.003646s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12454399 [ RunTime:0.001920s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58464377 LIMIT 5 [ RunTime:0.006996s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58464377 ORDER BY `minOrder` ASC [ RunTime:0.003083s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58464377 ORDER BY `unit` DESC [ RunTime:0.000758s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58464377 LIMIT 2 [ RunTime:0.005497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58464377 ORDER BY `minOrder` ASC [ RunTime:0.003712s ]
select * from pdf where partno='1630009' and brandshort='MEC Switches' limit 1 [ RunTime:0.002065s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1630009' OR `brand` LIKE 'MEC Switches%' ) ) LIMIT 1 [ RunTime:0.003643s ]
SELECT `id` FROM `stock` WHERE `id` <> 58464377 AND `partno` = '1630009' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mec switches%' ) [ RunTime:0.000883s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58464378 LIMIT 5 [ RunTime:0.000650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58464378 ORDER BY `minOrder` ASC [ RunTime:0.004663s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58464378 ORDER BY `unit` DESC [ RunTime:0.000751s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58464378 LIMIT 2 [ RunTime:0.001708s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58464378 ORDER BY `minOrder` ASC [ RunTime:0.003861s ]
select * from pdf where partno='1630000' and brandshort='MEC Switches' limit 1 [ RunTime:0.000620s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1630000' OR `brand` LIKE 'MEC Switches%' ) ) LIMIT 1 [ RunTime:0.000823s ]
SELECT `id` FROM `stock` WHERE `id` <> 58464378 AND `partno` = '1630000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mec switches%' ) [ RunTime:0.003141s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12456361 [ RunTime:0.000694s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53500626 LIMIT 5 [ RunTime:0.006250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53500626 ORDER BY `minOrder` ASC [ RunTime:0.003398s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53500626 ORDER BY `unit` DESC [ RunTime:0.000686s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53500626 LIMIT 2 [ RunTime:0.001880s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53500626 ORDER BY `minOrder` ASC [ RunTime:0.000538s ]
select * from pdf where partno='163007' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.003713s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '163007' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.001391s ]
SELECT `id` FROM `stock` WHERE `id` <> 53500626 AND `partno` = '163007' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.001468s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12519511 [ RunTime:0.000464s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58464381 LIMIT 5 [ RunTime:0.000439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58464381 ORDER BY `minOrder` ASC [ RunTime:0.001077s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58464381 ORDER BY `unit` DESC [ RunTime:0.000373s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58464381 LIMIT 2 [ RunTime:0.000621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58464381 ORDER BY `minOrder` ASC [ RunTime:0.004799s ]
select * from pdf where partno='1630004' and brandshort='MEC Switches' limit 1 [ RunTime:0.000721s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1630004' OR `brand` LIKE 'MEC Switches%' ) ) LIMIT 1 [ RunTime:0.002712s ]
SELECT `id` FROM `stock` WHERE `id` <> 58464381 AND `partno` = '1630004' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mec switches%' ) [ RunTime:0.000901s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12456363 [ RunTime:0.000386s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58464383 LIMIT 5 [ RunTime:0.000694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58464383 ORDER BY `minOrder` ASC [ RunTime:0.001586s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58464383 ORDER BY `unit` DESC [ RunTime:0.000415s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58464383 LIMIT 2 [ RunTime:0.003826s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58464383 ORDER BY `minOrder` ASC [ RunTime:0.002687s ]
select * from pdf where partno='1630006' and brandshort='MEC Switches' limit 1 [ RunTime:0.000514s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1630006' OR `brand` LIKE 'MEC Switches%' ) ) LIMIT 1 [ RunTime:0.000733s ]
SELECT `id` FROM `stock` WHERE `id` <> 58464383 AND `partno` = '1630006' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mec switches%' ) [ RunTime:0.001517s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11370525 [ RunTime:0.000408s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39204643 LIMIT 5 [ RunTime:0.000672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39204643 ORDER BY `minOrder` ASC [ RunTime:0.001577s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39204643 ORDER BY `unit` DESC [ RunTime:0.000423s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39204643 LIMIT 2 [ RunTime:0.001069s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39204643 ORDER BY `minOrder` ASC [ RunTime:0.001029s ]
select * from pdf where partno='1630012-2' and brandshort='WEC' limit 1 [ RunTime:0.001682s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1630012-2' OR `brand` LIKE 'WEC%' ) ) LIMIT 1 [ RunTime:0.000719s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57439138 LIMIT 5 [ RunTime:0.001074s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57439138 ORDER BY `minOrder` ASC [ RunTime:0.001499s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57439138 ORDER BY `unit` DESC [ RunTime:0.001733s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57439138 LIMIT 2 [ RunTime:0.000483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57439138 ORDER BY `minOrder` ASC [ RunTime:0.002838s ]
select * from pdf where partno='16300' and brandshort='SparkFun Electronics' limit 1 [ RunTime:0.001394s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '16300' OR `brand` LIKE 'SparkFun Electronics%' ) ) LIMIT 1 [ RunTime:0.002468s ]
SELECT `id` FROM `stock` WHERE `id` <> 57439138 AND `partno` = '16300' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sparkfun electronics%' ) [ RunTime:0.003246s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16145498 [ RunTime:0.000358s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58465599 LIMIT 5 [ RunTime:0.002405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58465599 ORDER BY `minOrder` ASC [ RunTime:0.001811s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58465599 ORDER BY `unit` DESC [ RunTime:0.000754s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58465599 LIMIT 2 [ RunTime:0.002285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58465599 ORDER BY `minOrder` ASC [ RunTime:0.001429s ]
select * from pdf where partno='1630002' and brandshort='MEC Switches' limit 1 [ RunTime:0.000463s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1630002' OR `brand` LIKE 'MEC Switches%' ) ) LIMIT 1 [ RunTime:0.000679s ]
SELECT `id` FROM `stock` WHERE `id` <> 58465599 AND `partno` = '1630002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mec switches%' ) [ RunTime:0.002288s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11370561 [ RunTime:0.000465s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58466695 LIMIT 5 [ RunTime:0.000924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58466695 ORDER BY `minOrder` ASC [ RunTime:0.002345s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58466695 ORDER BY `unit` DESC [ RunTime:0.000371s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58466695 LIMIT 2 [ RunTime:0.001721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58466695 ORDER BY `minOrder` ASC [ RunTime:0.002346s ]
select * from pdf where partno='1630058' and brandshort='MEC Switches' limit 1 [ RunTime:0.000867s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1630058' OR `brand` LIKE 'MEC Switches%' ) ) LIMIT 1 [ RunTime:0.001369s ]
SELECT `id` FROM `stock` WHERE `id` <> 58466695 AND `partno` = '1630058' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mec switches%' ) [ RunTime:0.002197s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58466694 LIMIT 5 [ RunTime:0.000439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58466694 ORDER BY `minOrder` ASC [ RunTime:0.001486s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58466694 ORDER BY `unit` DESC [ RunTime:0.000545s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58466694 LIMIT 2 [ RunTime:0.002126s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58466694 ORDER BY `minOrder` ASC [ RunTime:0.001348s ]
select * from pdf where partno='1630057' and brandshort='MEC Switches' limit 1 [ RunTime:0.000913s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1630057' OR `brand` LIKE 'MEC Switches%' ) ) LIMIT 1 [ RunTime:0.000568s ]
SELECT `id` FROM `stock` WHERE `id` <> 58466694 AND `partno` = '1630057' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mec switches%' ) [ RunTime:0.002079s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58466693 LIMIT 5 [ RunTime:0.000403s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58466693 ORDER BY `minOrder` ASC [ RunTime:0.001478s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58466693 ORDER BY `unit` DESC [ RunTime:0.000406s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58466693 LIMIT 2 [ RunTime:0.001664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58466693 ORDER BY `minOrder` ASC [ RunTime:0.000913s ]
select * from pdf where partno='1630053' and brandshort='MEC Switches' limit 1 [ RunTime:0.001209s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1630053' OR `brand` LIKE 'MEC Switches%' ) ) LIMIT 1 [ RunTime:0.000609s ]
SELECT `id` FROM `stock` WHERE `id` <> 58466693 AND `partno` = '1630053' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mec switches%' ) [ RunTime:0.001790s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58466692 LIMIT 5 [ RunTime:0.000387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58466692 ORDER BY `minOrder` ASC [ RunTime:0.001450s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58466692 ORDER BY `unit` DESC [ RunTime:0.000494s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58466692 LIMIT 2 [ RunTime:0.001682s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58466692 ORDER BY `minOrder` ASC [ RunTime:0.001430s ]
select * from pdf where partno='1630050' and brandshort='MEC Switches' limit 1 [ RunTime:0.001259s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1630050' OR `brand` LIKE 'MEC Switches%' ) ) LIMIT 1 [ RunTime:0.000563s ]
SELECT `id` FROM `stock` WHERE `id` <> 58466692 AND `partno` = '1630050' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mec switches%' ) [ RunTime:0.002510s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58466691 LIMIT 5 [ RunTime:0.000473s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58466691 ORDER BY `minOrder` ASC [ RunTime:0.002388s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58466691 ORDER BY `unit` DESC [ RunTime:0.003884s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58466691 LIMIT 2 [ RunTime:0.002670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58466691 ORDER BY `minOrder` ASC [ RunTime:0.002855s ]
select * from pdf where partno='1630042' and brandshort='MEC Switches' limit 1 [ RunTime:0.000866s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1630042' OR `brand` LIKE 'MEC Switches%' ) ) LIMIT 1 [ RunTime:0.000638s ]
SELECT `id` FROM `stock` WHERE `id` <> 58466691 AND `partno` = '1630042' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mec switches%' ) [ RunTime:0.002446s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58466690 LIMIT 5 [ RunTime:0.002989s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58466690 ORDER BY `minOrder` ASC [ RunTime:0.009014s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58466690 ORDER BY `unit` DESC [ RunTime:0.000587s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58466690 LIMIT 2 [ RunTime:0.004877s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58466690 ORDER BY `minOrder` ASC [ RunTime:0.001316s ]
select * from pdf where partno='1630040' and brandshort='MEC Switches' limit 1 [ RunTime:0.004980s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1630040' OR `brand` LIKE 'MEC Switches%' ) ) LIMIT 1 [ RunTime:0.006699s ]
SELECT `id` FROM `stock` WHERE `id` <> 58466690 AND `partno` = '1630040' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mec switches%' ) [ RunTime:0.004933s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12454683 [ RunTime:0.003038s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58466689 LIMIT 5 [ RunTime:0.009320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58466689 ORDER BY `minOrder` ASC [ RunTime:0.005923s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58466689 ORDER BY `unit` DESC [ RunTime:0.002227s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58466689 LIMIT 2 [ RunTime:0.005266s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58466689 ORDER BY `minOrder` ASC [ RunTime:0.026471s ]
select * from pdf where partno='1630038' and brandshort='MEC Switches' limit 1 [ RunTime:0.000756s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1630038' OR `brand` LIKE 'MEC Switches%' ) ) LIMIT 1 [ RunTime:0.007289s ]
SELECT `id` FROM `stock` WHERE `id` <> 58466689 AND `partno` = '1630038' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mec switches%' ) [ RunTime:0.001597s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12454682 [ RunTime:0.008164s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58466688 LIMIT 5 [ RunTime:0.013148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58466688 ORDER BY `minOrder` ASC [ RunTime:0.011705s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58466688 ORDER BY `unit` DESC [ RunTime:0.003521s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58466688 LIMIT 2 [ RunTime:0.007020s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58466688 ORDER BY `minOrder` ASC [ RunTime:0.010385s ]
select * from pdf where partno='1630034' and brandshort='MEC Switches' limit 1 [ RunTime:0.004193s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1630034' OR `brand` LIKE 'MEC Switches%' ) ) LIMIT 1 [ RunTime:0.003380s ]
SELECT `id` FROM `stock` WHERE `id` <> 58466688 AND `partno` = '1630034' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mec switches%' ) [ RunTime:0.006943s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12454681 [ RunTime:0.003294s ]
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 '16300%' OR `brand` LIKE '16300%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017022s ]
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 '16300%' OR `brand` LIKE '16300%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000900s ]
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 '16300%' OR `brand` LIKE '16300%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001066s ]
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 '16300%' OR `brand` LIKE '16300%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004313s ]
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 '16300%' OR `brand` LIKE '16300%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002823s ]
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 '16300%' OR `brand` LIKE '16300%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004243s ]
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 '16300%' OR `brand` LIKE '16300%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002994s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '16300%' OR `brand` LIKE '16300%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001407s ]