SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001596s ]
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 '60312%' OR `brand` LIKE '60312%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011725s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001169s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12879635 LIMIT 5 [ RunTime:0.002951s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001818s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12879635 ORDER BY `minOrder` ASC [ RunTime:0.007586s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001236s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12879635 ORDER BY `unit` DESC [ RunTime:0.000413s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002699s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12879635 LIMIT 2 [ RunTime:0.000463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12879635 ORDER BY `minOrder` ASC [ RunTime:0.000247s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12880637 LIMIT 5 [ RunTime:0.000854s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12880637 ORDER BY `minOrder` ASC [ RunTime:0.006516s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12880637 ORDER BY `unit` DESC [ RunTime:0.000528s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12880637 LIMIT 2 [ RunTime:0.000320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12880637 ORDER BY `minOrder` ASC [ RunTime:0.001726s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12880680 LIMIT 5 [ RunTime:0.003496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12880680 ORDER BY `minOrder` ASC [ RunTime:0.002230s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12880680 ORDER BY `unit` DESC [ RunTime:0.001689s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12880680 LIMIT 2 [ RunTime:0.000366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12880680 ORDER BY `minOrder` ASC [ RunTime:0.000394s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12875015 LIMIT 5 [ RunTime:0.003332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12875015 ORDER BY `minOrder` ASC [ RunTime:0.014594s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12875015 ORDER BY `unit` DESC [ RunTime:0.000553s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12875015 LIMIT 2 [ RunTime:0.003200s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12875015 ORDER BY `minOrder` ASC [ RunTime:0.006405s ]
select * from pdf where partno='60312202114513' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.006980s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11679064 LIMIT 5 [ RunTime:0.004338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11679064 ORDER BY `minOrder` ASC [ RunTime:0.000923s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11679064 ORDER BY `unit` DESC [ RunTime:0.002924s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11679064 LIMIT 2 [ RunTime:0.003897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11679064 ORDER BY `minOrder` ASC [ RunTime:0.000413s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11683013 LIMIT 5 [ RunTime:0.018737s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11683013 ORDER BY `minOrder` ASC [ RunTime:0.017051s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11683013 ORDER BY `unit` DESC [ RunTime:0.023620s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11683013 LIMIT 2 [ RunTime:0.019890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11683013 ORDER BY `minOrder` ASC [ RunTime:0.000452s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12875475 LIMIT 5 [ RunTime:0.010189s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12875475 ORDER BY `minOrder` ASC [ RunTime:0.005832s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12875475 ORDER BY `unit` DESC [ RunTime:0.025811s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12875475 LIMIT 2 [ RunTime:0.004433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12875475 ORDER BY `minOrder` ASC [ RunTime:0.009917s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12880427 LIMIT 5 [ RunTime:0.005763s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12880427 ORDER BY `minOrder` ASC [ RunTime:0.003498s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12880427 ORDER BY `unit` DESC [ RunTime:0.001701s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12880427 LIMIT 2 [ RunTime:0.000392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12880427 ORDER BY `minOrder` ASC [ RunTime:0.000254s ]
select * from pdf where partno='60312202114508' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.002058s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12874609 LIMIT 5 [ RunTime:0.014679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12874609 ORDER BY `minOrder` ASC [ RunTime:0.000800s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12874609 ORDER BY `unit` DESC [ RunTime:0.001726s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12874609 LIMIT 2 [ RunTime:0.008900s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12874609 ORDER BY `minOrder` ASC [ RunTime:0.000409s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11682249 LIMIT 5 [ RunTime:0.000857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11682249 ORDER BY `minOrder` ASC [ RunTime:0.004349s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11682249 ORDER BY `unit` DESC [ RunTime:0.001993s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11682249 LIMIT 2 [ RunTime:0.000547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11682249 ORDER BY `minOrder` ASC [ RunTime:0.002272s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11681795 LIMIT 5 [ RunTime:0.003157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11681795 ORDER BY `minOrder` ASC [ RunTime:0.005108s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11681795 ORDER BY `unit` DESC [ RunTime:0.002336s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11681795 LIMIT 2 [ RunTime:0.002964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11681795 ORDER BY `minOrder` ASC [ RunTime:0.007179s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12880670 LIMIT 5 [ RunTime:0.001139s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12880670 ORDER BY `minOrder` ASC [ RunTime:0.000536s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12880670 ORDER BY `unit` DESC [ RunTime:0.008874s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12880670 LIMIT 2 [ RunTime:0.008776s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12880670 ORDER BY `minOrder` ASC [ RunTime:0.001146s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11681805 LIMIT 5 [ RunTime:0.002479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11681805 ORDER BY `minOrder` ASC [ RunTime:0.000582s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11681805 ORDER BY `unit` DESC [ RunTime:0.000532s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11681805 LIMIT 2 [ RunTime:0.002691s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11681805 ORDER BY `minOrder` ASC [ RunTime:0.001792s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12874181 LIMIT 5 [ RunTime:0.002904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12874181 ORDER BY `minOrder` ASC [ RunTime:0.001270s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12874181 ORDER BY `unit` DESC [ RunTime:0.006816s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12874181 LIMIT 2 [ RunTime:0.002532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12874181 ORDER BY `minOrder` ASC [ RunTime:0.000399s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12880436 LIMIT 5 [ RunTime:0.000724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12880436 ORDER BY `minOrder` ASC [ RunTime:0.008111s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12880436 ORDER BY `unit` DESC [ RunTime:0.001688s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12880436 LIMIT 2 [ RunTime:0.000649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12880436 ORDER BY `minOrder` ASC [ RunTime:0.000390s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12880790 LIMIT 5 [ RunTime:0.002774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12880790 ORDER BY `minOrder` ASC [ RunTime:0.008149s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12880790 ORDER BY `unit` DESC [ RunTime:0.001988s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12880790 LIMIT 2 [ RunTime:0.000522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12880790 ORDER BY `minOrder` ASC [ RunTime:0.000382s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12881074 LIMIT 5 [ RunTime:0.006009s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12881074 ORDER BY `minOrder` ASC [ RunTime:0.007652s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12881074 ORDER BY `unit` DESC [ RunTime:0.000535s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12881074 LIMIT 2 [ RunTime:0.000367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12881074 ORDER BY `minOrder` ASC [ RunTime:0.000275s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11681985 LIMIT 5 [ RunTime:0.000683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11681985 ORDER BY `minOrder` ASC [ RunTime:0.003524s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11681985 ORDER BY `unit` DESC [ RunTime:0.001248s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11681985 LIMIT 2 [ RunTime:0.000420s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11681985 ORDER BY `minOrder` ASC [ RunTime:0.002918s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12882378 LIMIT 5 [ RunTime:0.005452s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12882378 ORDER BY `minOrder` ASC [ RunTime:0.000904s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12882378 ORDER BY `unit` DESC [ RunTime:0.000601s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12882378 LIMIT 2 [ RunTime:0.000347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12882378 ORDER BY `minOrder` ASC [ RunTime:0.002174s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12881372 LIMIT 5 [ RunTime:0.008139s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12881372 ORDER BY `minOrder` ASC [ RunTime:0.003220s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12881372 ORDER BY `unit` DESC [ RunTime:0.001560s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12881372 LIMIT 2 [ RunTime:0.000406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12881372 ORDER BY `minOrder` ASC [ RunTime:0.001352s ]
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 '60312%' OR `brand` LIKE '60312%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004819s ]
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 '60312%' OR `brand` LIKE '60312%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003154s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61908150 LIMIT 5 [ RunTime:0.000412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61908150 ORDER BY `minOrder` ASC [ RunTime:0.045335s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61908150 ORDER BY `unit` DESC [ RunTime:0.016716s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61908150 LIMIT 2 [ RunTime:0.016460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61908150 ORDER BY `minOrder` ASC [ RunTime:0.003490s ]
select * from pdf where partno='60312202114514' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.008012s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003312s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60312202114514' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.006421s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61908207 LIMIT 5 [ RunTime:0.013654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61908207 ORDER BY `minOrder` ASC [ RunTime:0.019360s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61908207 ORDER BY `unit` DESC [ RunTime:0.004396s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61908207 LIMIT 2 [ RunTime:0.009547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61908207 ORDER BY `minOrder` ASC [ RunTime:0.005189s ]
select * from pdf where partno='60312202114509' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.007837s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60312202114509' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.002462s ]
SELECT `id` FROM `stock` WHERE `id` <> 61908207 AND `partno` = '60312202114509' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.002492s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12880637 [ RunTime:0.001374s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61908047 LIMIT 5 [ RunTime:0.000594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61908047 ORDER BY `minOrder` ASC [ RunTime:0.002083s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61908047 ORDER BY `unit` DESC [ RunTime:0.001213s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61908047 LIMIT 2 [ RunTime:0.003809s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61908047 ORDER BY `minOrder` ASC [ RunTime:0.000405s ]
select * from pdf where partno='60312002114503' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.011483s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60312002114503' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.001377s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61908263 LIMIT 5 [ RunTime:0.006101s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61908263 ORDER BY `minOrder` ASC [ RunTime:0.014472s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61908263 ORDER BY `unit` DESC [ RunTime:0.010167s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61908263 LIMIT 2 [ RunTime:0.023341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61908263 ORDER BY `minOrder` ASC [ RunTime:0.005736s ]
select * from pdf where partno='60312102114506' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.002707s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60312102114506' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.002950s ]
SELECT `id` FROM `stock` WHERE `id` <> 61908263 AND `partno` = '60312102114506' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.008475s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12880670 [ RunTime:0.004902s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61908400 LIMIT 5 [ RunTime:0.007280s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61908400 ORDER BY `minOrder` ASC [ RunTime:0.003240s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61908400 ORDER BY `unit` DESC [ RunTime:0.010821s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61908400 LIMIT 2 [ RunTime:0.005153s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61908400 ORDER BY `minOrder` ASC [ RunTime:0.011900s ]
select * from pdf where partno='60312202114307' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.008659s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60312202114307' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.006442s ]
SELECT `id` FROM `stock` WHERE `id` <> 61908400 AND `partno` = '60312202114307' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.000979s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11679064 [ RunTime:0.001321s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61908077 LIMIT 5 [ RunTime:0.001400s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61908077 ORDER BY `minOrder` ASC [ RunTime:0.001977s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61908077 ORDER BY `unit` DESC [ RunTime:0.002662s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61908077 LIMIT 2 [ RunTime:0.001159s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61908077 ORDER BY `minOrder` ASC [ RunTime:0.004653s ]
select * from pdf where partno='60312242114510' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.004212s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60312242114510' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.001093s ]
SELECT `id` FROM `stock` WHERE `id` <> 61908077 AND `partno` = '60312242114510' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.000782s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12879635 [ RunTime:0.008921s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61908313 LIMIT 5 [ RunTime:0.000825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61908313 ORDER BY `minOrder` ASC [ RunTime:0.000819s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61908313 ORDER BY `unit` DESC [ RunTime:0.002408s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61908313 LIMIT 2 [ RunTime:0.000526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61908313 ORDER BY `minOrder` ASC [ RunTime:0.000373s ]
select * from pdf where partno='60312202114513' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.000838s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60312202114513' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.002156s ]
SELECT `id` FROM `stock` WHERE `id` <> 61908313 AND `partno` = '60312202114513' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.000756s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12875015 [ RunTime:0.008698s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61909117 LIMIT 5 [ RunTime:0.007355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61909117 ORDER BY `minOrder` ASC [ RunTime:0.005132s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61909117 ORDER BY `unit` DESC [ RunTime:0.002606s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61909117 LIMIT 2 [ RunTime:0.006034s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61909117 ORDER BY `minOrder` ASC [ RunTime:0.000395s ]
select * from pdf where partno='60312042114504' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.007638s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60312042114504' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.001695s ]
SELECT `id` FROM `stock` WHERE `id` <> 61909117 AND `partno` = '60312042114504' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.000788s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11681795 [ RunTime:0.007869s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61908327 LIMIT 5 [ RunTime:0.000605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61908327 ORDER BY `minOrder` ASC [ RunTime:0.006028s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61908327 ORDER BY `unit` DESC [ RunTime:0.000605s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61908327 LIMIT 2 [ RunTime:0.002652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61908327 ORDER BY `minOrder` ASC [ RunTime:0.000383s ]
select * from pdf where partno='60312042111532' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.003047s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60312042111532' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.006127s ]
SELECT `id` FROM `stock` WHERE `id` <> 61908327 AND `partno` = '60312042111532' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.001145s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11682823 [ RunTime:0.002654s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61908990 LIMIT 5 [ RunTime:0.003344s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61908990 ORDER BY `minOrder` ASC [ RunTime:0.000937s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61908990 ORDER BY `unit` DESC [ RunTime:0.002058s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61908990 LIMIT 2 [ RunTime:0.000843s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61908990 ORDER BY `minOrder` ASC [ RunTime:0.000373s ]
select * from pdf where partno='60312412114517' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.001338s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60312412114517' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.001031s ]
SELECT `id` FROM `stock` WHERE `id` <> 61908990 AND `partno` = '60312412114517' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.006485s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12874609 [ RunTime:0.001867s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61908969 LIMIT 5 [ RunTime:0.007700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61908969 ORDER BY `minOrder` ASC [ RunTime:0.001502s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61908969 ORDER BY `unit` DESC [ RunTime:0.002333s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61908969 LIMIT 2 [ RunTime:0.007583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61908969 ORDER BY `minOrder` ASC [ RunTime:0.000309s ]
select * from pdf where partno='60312202114512' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.003325s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60312202114512' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.003786s ]
SELECT `id` FROM `stock` WHERE `id` <> 61908969 AND `partno` = '60312202114512' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.001620s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12874181 [ RunTime:0.013546s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61908518 LIMIT 5 [ RunTime:0.008355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61908518 ORDER BY `minOrder` ASC [ RunTime:0.002638s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61908518 ORDER BY `unit` DESC [ RunTime:0.000644s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61908518 LIMIT 2 [ RunTime:0.007223s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61908518 ORDER BY `minOrder` ASC [ RunTime:0.000660s ]
select * from pdf where partno='60312252111535' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.001214s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60312252111535' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.001406s ]
SELECT `id` FROM `stock` WHERE `id` <> 61908518 AND `partno` = '60312252111535' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.007594s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11683013 [ RunTime:0.004326s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61909179 LIMIT 5 [ RunTime:0.001331s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61909179 ORDER BY `minOrder` ASC [ RunTime:0.003273s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61909179 ORDER BY `unit` DESC [ RunTime:0.010126s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61909179 LIMIT 2 [ RunTime:0.001961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61909179 ORDER BY `minOrder` ASC [ RunTime:0.000448s ]
select * from pdf where partno='60312202114508' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.000740s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60312202114508' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.003970s ]
SELECT `id` FROM `stock` WHERE `id` <> 61909179 AND `partno` = '60312202114508' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.002879s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12880427 [ RunTime:0.003350s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61908252 LIMIT 5 [ RunTime:0.003710s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61908252 ORDER BY `minOrder` ASC [ RunTime:0.001122s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61908252 ORDER BY `unit` DESC [ RunTime:0.003445s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61908252 LIMIT 2 [ RunTime:0.004742s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61908252 ORDER BY `minOrder` ASC [ RunTime:0.005265s ]
select * from pdf where partno='60312102114405' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.003774s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60312102114405' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.000991s ]
SELECT `id` FROM `stock` WHERE `id` <> 61908252 AND `partno` = '60312102114405' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.001084s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12880680 [ RunTime:0.005570s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61910375 LIMIT 5 [ RunTime:0.001014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61910375 ORDER BY `minOrder` ASC [ RunTime:0.001286s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61910375 ORDER BY `unit` DESC [ RunTime:0.002023s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61910375 LIMIT 2 [ RunTime:0.000640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61910375 ORDER BY `minOrder` ASC [ RunTime:0.003126s ]
select * from pdf where partno='60312512114515' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.001955s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60312512114515' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.003887s ]
SELECT `id` FROM `stock` WHERE `id` <> 61910375 AND `partno` = '60312512114515' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.001059s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12880790 [ RunTime:0.007519s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61912682 LIMIT 5 [ RunTime:0.003464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61912682 ORDER BY `minOrder` ASC [ RunTime:0.002012s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61912682 ORDER BY `unit` DESC [ RunTime:0.000714s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61912682 LIMIT 2 [ RunTime:0.003168s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61912682 ORDER BY `minOrder` ASC [ RunTime:0.000452s ]
select * from pdf where partno='60312872112545' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.004379s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60312872112545' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.003709s ]
SELECT `id` FROM `stock` WHERE `id` <> 61912682 AND `partno` = '60312872112545' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.008053s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12881372 [ RunTime:0.001607s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61913079 LIMIT 5 [ RunTime:0.000916s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61913079 ORDER BY `minOrder` ASC [ RunTime:0.007502s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61913079 ORDER BY `unit` DESC [ RunTime:0.003670s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61913079 LIMIT 2 [ RunTime:0.004121s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61913079 ORDER BY `minOrder` ASC [ RunTime:0.000461s ]
select * from pdf where partno='60312322114620' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.000956s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60312322114620' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.001332s ]
SELECT `id` FROM `stock` WHERE `id` <> 61913079 AND `partno` = '60312322114620' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.001012s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11681985 [ RunTime:0.008561s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61913853 LIMIT 5 [ RunTime:0.001632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61913853 ORDER BY `minOrder` ASC [ RunTime:0.001523s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61913853 ORDER BY `unit` DESC [ RunTime:0.007034s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61913853 LIMIT 2 [ RunTime:0.000786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61913853 ORDER BY `minOrder` ASC [ RunTime:0.004952s ]
select * from pdf where partno='60312312114616' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.001276s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60312312114616' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.004676s ]
SELECT `id` FROM `stock` WHERE `id` <> 61913853 AND `partno` = '60312312114616' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.001296s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11682249 [ RunTime:0.000592s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61913081 LIMIT 5 [ RunTime:0.010614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61913081 ORDER BY `minOrder` ASC [ RunTime:0.014697s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61913081 ORDER BY `unit` DESC [ RunTime:0.006733s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61913081 LIMIT 2 [ RunTime:0.017563s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61913081 ORDER BY `minOrder` ASC [ RunTime:0.005728s ]
select * from pdf where partno='60312422114521' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.010028s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60312422114521' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.005241s ]
SELECT `id` FROM `stock` WHERE `id` <> 61913081 AND `partno` = '60312422114521' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.000682s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11681989 [ RunTime:0.002235s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61912634 LIMIT 5 [ RunTime:0.000937s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61912634 ORDER BY `minOrder` ASC [ RunTime:0.000626s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61912634 ORDER BY `unit` DESC [ RunTime:0.001333s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61912634 LIMIT 2 [ RunTime:0.007561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61912634 ORDER BY `minOrder` ASC [ RunTime:0.001576s ]
select * from pdf where partno='60312412114518' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.000769s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60312412114518' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.001507s ]
SELECT `id` FROM `stock` WHERE `id` <> 61912634 AND `partno` = '60312412114518' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.010044s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12880436 [ RunTime:0.009726s ]
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 '60312%' OR `brand` LIKE '60312%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030338s ]
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 '60312%' OR `brand` LIKE '60312%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004774s ]
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 '60312%' OR `brand` LIKE '60312%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001186s ]
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 '60312%' OR `brand` LIKE '60312%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006436s ]
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 '60312%' OR `brand` LIKE '60312%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012445s ]
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 '60312%' OR `brand` LIKE '60312%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013933s ]
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 '60312%' OR `brand` LIKE '60312%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005758s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '60312%' OR `brand` LIKE '60312%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.005318s ]