SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002498s ]
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 'P32-1%' OR `brand` LIKE 'P32-1%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.046140s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.011301s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18853764 LIMIT 5 [ RunTime:0.029460s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18853764 ORDER BY `minOrder` ASC [ RunTime:0.008366s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003045s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18853764 ORDER BY `unit` DESC [ RunTime:0.014981s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002297s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18853764 LIMIT 2 [ RunTime:0.007358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18853764 ORDER BY `minOrder` ASC [ RunTime:0.016426s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11147768 LIMIT 5 [ RunTime:0.025545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11147768 ORDER BY `minOrder` ASC [ RunTime:0.004089s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11147768 ORDER BY `unit` DESC [ RunTime:0.006426s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11147768 LIMIT 2 [ RunTime:0.030535s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11147768 ORDER BY `minOrder` ASC [ RunTime:0.006547s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12163419 LIMIT 5 [ RunTime:0.041617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12163419 ORDER BY `minOrder` ASC [ RunTime:0.045347s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12163419 ORDER BY `unit` DESC [ RunTime:0.065293s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12163419 LIMIT 2 [ RunTime:0.039962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12163419 ORDER BY `minOrder` ASC [ RunTime:0.013894s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12163384 LIMIT 5 [ RunTime:0.012638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12163384 ORDER BY `minOrder` ASC [ RunTime:0.039444s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12163384 ORDER BY `unit` DESC [ RunTime:0.029039s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12163384 LIMIT 2 [ RunTime:0.047949s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12163384 ORDER BY `minOrder` ASC [ RunTime:0.011289s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12163383 LIMIT 5 [ RunTime:0.028174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12163383 ORDER BY `minOrder` ASC [ RunTime:0.011849s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12163383 ORDER BY `unit` DESC [ RunTime:0.023286s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12163383 LIMIT 2 [ RunTime:0.022312s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12163383 ORDER BY `minOrder` ASC [ RunTime:0.011444s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12163376 LIMIT 5 [ RunTime:0.010037s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12163376 ORDER BY `minOrder` ASC [ RunTime:0.042724s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12163376 ORDER BY `unit` DESC [ RunTime:0.023622s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12163376 LIMIT 2 [ RunTime:0.012344s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12163376 ORDER BY `minOrder` ASC [ RunTime:0.028367s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12163349 LIMIT 5 [ RunTime:0.025510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12163349 ORDER BY `minOrder` ASC [ RunTime:0.021794s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12163349 ORDER BY `unit` DESC [ RunTime:0.009426s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12163349 LIMIT 2 [ RunTime:0.025705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12163349 ORDER BY `minOrder` ASC [ RunTime:0.013083s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12163348 LIMIT 5 [ RunTime:0.003786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12163348 ORDER BY `minOrder` ASC [ RunTime:0.008199s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12163348 ORDER BY `unit` DESC [ RunTime:0.011662s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12163348 LIMIT 2 [ RunTime:0.005441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12163348 ORDER BY `minOrder` ASC [ RunTime:0.013603s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12163347 LIMIT 5 [ RunTime:0.000972s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12163347 ORDER BY `minOrder` ASC [ RunTime:0.012530s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12163347 ORDER BY `unit` DESC [ RunTime:0.013732s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12163347 LIMIT 2 [ RunTime:0.021213s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12163347 ORDER BY `minOrder` ASC [ RunTime:0.004164s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12163343 LIMIT 5 [ RunTime:0.014176s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12163343 ORDER BY `minOrder` ASC [ RunTime:0.005148s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12163343 ORDER BY `unit` DESC [ RunTime:0.016321s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12163343 LIMIT 2 [ RunTime:0.009145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12163343 ORDER BY `minOrder` ASC [ RunTime:0.011455s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12163342 LIMIT 5 [ RunTime:0.016499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12163342 ORDER BY `minOrder` ASC [ RunTime:0.001680s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12163342 ORDER BY `unit` DESC [ RunTime:0.000658s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12163342 LIMIT 2 [ RunTime:0.000714s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12163342 ORDER BY `minOrder` ASC [ RunTime:0.000597s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12163315 LIMIT 5 [ RunTime:0.004007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12163315 ORDER BY `minOrder` ASC [ RunTime:0.009401s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12163315 ORDER BY `unit` DESC [ RunTime:0.000826s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12163315 LIMIT 2 [ RunTime:0.011819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12163315 ORDER BY `minOrder` ASC [ RunTime:0.000603s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12163314 LIMIT 5 [ RunTime:0.001350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12163314 ORDER BY `minOrder` ASC [ RunTime:0.005755s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12163314 ORDER BY `unit` DESC [ RunTime:0.002427s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12163314 LIMIT 2 [ RunTime:0.000625s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12163314 ORDER BY `minOrder` ASC [ RunTime:0.000423s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12163313 LIMIT 5 [ RunTime:0.000662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12163313 ORDER BY `minOrder` ASC [ RunTime:0.000658s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12163313 ORDER BY `unit` DESC [ RunTime:0.000600s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12163313 LIMIT 2 [ RunTime:0.004448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12163313 ORDER BY `minOrder` ASC [ RunTime:0.009396s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12163312 LIMIT 5 [ RunTime:0.005726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12163312 ORDER BY `minOrder` ASC [ RunTime:0.013562s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12163312 ORDER BY `unit` DESC [ RunTime:0.005813s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12163312 LIMIT 2 [ RunTime:0.000729s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12163312 ORDER BY `minOrder` ASC [ RunTime:0.018417s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12163204 LIMIT 5 [ RunTime:0.014176s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12163204 ORDER BY `minOrder` ASC [ RunTime:0.001976s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12163204 ORDER BY `unit` DESC [ RunTime:0.000813s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12163204 LIMIT 2 [ RunTime:0.002431s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12163204 ORDER BY `minOrder` ASC [ RunTime:0.000473s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12163203 LIMIT 5 [ RunTime:0.001955s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12163203 ORDER BY `minOrder` ASC [ RunTime:0.017113s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12163203 ORDER BY `unit` DESC [ RunTime:0.004395s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12163203 LIMIT 2 [ RunTime:0.007331s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12163203 ORDER BY `minOrder` ASC [ RunTime:0.000483s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12163202 LIMIT 5 [ RunTime:0.002086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12163202 ORDER BY `minOrder` ASC [ RunTime:0.002213s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12163202 ORDER BY `unit` DESC [ RunTime:0.002708s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12163202 LIMIT 2 [ RunTime:0.000917s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12163202 ORDER BY `minOrder` ASC [ RunTime:0.001345s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12163198 LIMIT 5 [ RunTime:0.006835s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12163198 ORDER BY `minOrder` ASC [ RunTime:0.003645s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12163198 ORDER BY `unit` DESC [ RunTime:0.003633s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12163198 LIMIT 2 [ RunTime:0.008901s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12163198 ORDER BY `minOrder` ASC [ RunTime:0.000477s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12163185 LIMIT 5 [ RunTime:0.000877s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12163185 ORDER BY `minOrder` ASC [ RunTime:0.000771s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12163185 ORDER BY `unit` DESC [ RunTime:0.003824s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12163185 LIMIT 2 [ RunTime:0.009714s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12163185 ORDER BY `minOrder` ASC [ RunTime:0.005477s ]
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 'P32-1%' OR `brand` LIKE 'P32-1%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005497s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51084431 LIMIT 5 [ RunTime:0.000680s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51084431 ORDER BY `minOrder` ASC [ RunTime:0.003262s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51084431 ORDER BY `unit` DESC [ RunTime:0.011095s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51084431 LIMIT 2 [ RunTime:0.000662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51084431 ORDER BY `minOrder` ASC [ RunTime:0.000604s ]
select * from pdf where partno='p32-1026' and brandshort='trumeter' limit 1 [ RunTime:0.003916s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002695s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'p32-1026' OR `brand` LIKE 'trumeter%' ) ) LIMIT 1 [ RunTime:0.005651s ]
SELECT `id` FROM `stock` WHERE `id` <> 51084431 AND `partno` = 'p32-1026' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%trumeter%' ) [ RunTime:0.011600s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18853764 [ RunTime:0.008282s ]
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 'P32-1%' OR `brand` LIKE 'P32-1%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019783s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57269110 LIMIT 5 [ RunTime:0.010019s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57269110 ORDER BY `minOrder` ASC [ RunTime:0.007388s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57269110 ORDER BY `unit` DESC [ RunTime:0.001903s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57269110 LIMIT 2 [ RunTime:0.001065s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57269110 ORDER BY `minOrder` ASC [ RunTime:0.002613s ]
select * from pdf where partno='P32-1026' and brandshort='Trumeter' limit 1 [ RunTime:0.005928s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P32-1026' OR `brand` LIKE 'Trumeter%' ) ) LIMIT 1 [ RunTime:0.000925s ]
SELECT `id` FROM `stock` WHERE `id` <> 57269110 AND `partno` = 'P32-1026' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%trumeter%' ) [ RunTime:0.010878s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18853764 [ RunTime:0.002782s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41602373 LIMIT 5 [ RunTime:0.000517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41602373 ORDER BY `minOrder` ASC [ RunTime:0.007723s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41602373 ORDER BY `unit` DESC [ RunTime:0.001576s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41602373 LIMIT 2 [ RunTime:0.004623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41602373 ORDER BY `minOrder` ASC [ RunTime:0.000474s ]
select * from pdf where partno='P32-1T' and brandshort='Polytron' limit 1 [ RunTime:0.001775s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P32-1T' OR `brand` LIKE 'Polytron%' ) ) LIMIT 1 [ RunTime:0.004989s ]
SELECT `id` FROM `stock` WHERE `id` <> 41602373 AND `partno` = 'P32-1T' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%polytron%' ) [ RunTime:0.008862s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11147768 [ RunTime:0.003109s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57569810 LIMIT 5 [ RunTime:0.000665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57569810 ORDER BY `minOrder` ASC [ RunTime:0.003759s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57569810 ORDER BY `unit` DESC [ RunTime:0.000651s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57569810 LIMIT 2 [ RunTime:0.002206s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57569810 ORDER BY `minOrder` ASC [ RunTime:0.004226s ]
select * from pdf where partno='P32-150SAX/MHIA' and brandshort='Polytron' limit 1 [ RunTime:0.004032s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P32-150SAX/MHIA' OR `brand` LIKE 'Polytron%' ) ) LIMIT 1 [ RunTime:0.000758s ]
SELECT `id` FROM `stock` WHERE `id` <> 57569810 AND `partno` = 'P32-150SAX/MHIA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%polytron%' ) [ RunTime:0.000803s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12163419 [ RunTime:0.003879s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57569758 LIMIT 5 [ RunTime:0.000743s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57569758 ORDER BY `minOrder` ASC [ RunTime:0.000691s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57569758 ORDER BY `unit` DESC [ RunTime:0.001946s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57569758 LIMIT 2 [ RunTime:0.004549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57569758 ORDER BY `minOrder` ASC [ RunTime:0.000469s ]
select * from pdf where partno='P32-150SXE/MHIA' and brandshort='Polytron' limit 1 [ RunTime:0.001118s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P32-150SXE/MHIA' OR `brand` LIKE 'Polytron%' ) ) LIMIT 1 [ RunTime:0.006232s ]
SELECT `id` FROM `stock` WHERE `id` <> 57569758 AND `partno` = 'P32-150SXE/MHIA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%polytron%' ) [ RunTime:0.002264s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11181412 [ RunTime:0.008308s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57569757 LIMIT 5 [ RunTime:0.000658s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57569757 ORDER BY `minOrder` ASC [ RunTime:0.008138s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57569757 ORDER BY `unit` DESC [ RunTime:0.003420s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57569757 LIMIT 2 [ RunTime:0.002051s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57569757 ORDER BY `minOrder` ASC [ RunTime:0.000485s ]
select * from pdf where partno='P32-150SXA/MHIA' and brandshort='Polytron' limit 1 [ RunTime:0.003011s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P32-150SXA/MHIA' OR `brand` LIKE 'Polytron%' ) ) LIMIT 1 [ RunTime:0.000733s ]
SELECT `id` FROM `stock` WHERE `id` <> 57569757 AND `partno` = 'P32-150SXA/MHIA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%polytron%' ) [ RunTime:0.001958s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12163384 [ RunTime:0.006332s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57569756 LIMIT 5 [ RunTime:0.001620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57569756 ORDER BY `minOrder` ASC [ RunTime:0.007655s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57569756 ORDER BY `unit` DESC [ RunTime:0.001019s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57569756 LIMIT 2 [ RunTime:0.002092s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57569756 ORDER BY `minOrder` ASC [ RunTime:0.001464s ]
select * from pdf where partno='P32-150SX/MHIA' and brandshort='Polytron' limit 1 [ RunTime:0.001388s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P32-150SX/MHIA' OR `brand` LIKE 'Polytron%' ) ) LIMIT 1 [ RunTime:0.001767s ]
SELECT `id` FROM `stock` WHERE `id` <> 57569756 AND `partno` = 'P32-150SX/MHIA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%polytron%' ) [ RunTime:0.001087s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12163383 [ RunTime:0.001146s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57569755 LIMIT 5 [ RunTime:0.000628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57569755 ORDER BY `minOrder` ASC [ RunTime:0.001022s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57569755 ORDER BY `unit` DESC [ RunTime:0.000487s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57569755 LIMIT 2 [ RunTime:0.000453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57569755 ORDER BY `minOrder` ASC [ RunTime:0.002307s ]
select * from pdf where partno='P32-150SW/MHIA' and brandshort='Polytron' limit 1 [ RunTime:0.001224s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P32-150SW/MHIA' OR `brand` LIKE 'Polytron%' ) ) LIMIT 1 [ RunTime:0.004219s ]
SELECT `id` FROM `stock` WHERE `id` <> 57569755 AND `partno` = 'P32-150SW/MHIA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%polytron%' ) [ RunTime:0.011742s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11181411 [ RunTime:0.002977s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57569754 LIMIT 5 [ RunTime:0.000504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57569754 ORDER BY `minOrder` ASC [ RunTime:0.000518s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57569754 ORDER BY `unit` DESC [ RunTime:0.008476s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57569754 LIMIT 2 [ RunTime:0.017813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57569754 ORDER BY `minOrder` ASC [ RunTime:0.004148s ]
select * from pdf where partno='P32-150SQX/MHIA' and brandshort='Polytron' limit 1 [ RunTime:0.001244s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P32-150SQX/MHIA' OR `brand` LIKE 'Polytron%' ) ) LIMIT 1 [ RunTime:0.010199s ]
SELECT `id` FROM `stock` WHERE `id` <> 57569754 AND `partno` = 'P32-150SQX/MHIA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%polytron%' ) [ RunTime:0.022005s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11181410 [ RunTime:0.006893s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57569724 LIMIT 5 [ RunTime:0.003279s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57569724 ORDER BY `minOrder` ASC [ RunTime:0.030069s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57569724 ORDER BY `unit` DESC [ RunTime:0.015076s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57569724 LIMIT 2 [ RunTime:0.009694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57569724 ORDER BY `minOrder` ASC [ RunTime:0.017789s ]
select * from pdf where partno='P32-18SQX/MHIA' and brandshort='Polytron' limit 1 [ RunTime:0.014017s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P32-18SQX/MHIA' OR `brand` LIKE 'Polytron%' ) ) LIMIT 1 [ RunTime:0.022498s ]
SELECT `id` FROM `stock` WHERE `id` <> 57569724 AND `partno` = 'P32-18SQX/MHIA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%polytron%' ) [ RunTime:0.016865s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12163376 [ RunTime:0.022818s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57569723 LIMIT 5 [ RunTime:0.026272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57569723 ORDER BY `minOrder` ASC [ RunTime:0.015184s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57569723 ORDER BY `unit` DESC [ RunTime:0.019592s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57569723 LIMIT 2 [ RunTime:0.021906s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57569723 ORDER BY `minOrder` ASC [ RunTime:0.009420s ]
select * from pdf where partno='P32-18SAX/MHIA' and brandshort='Polytron' limit 1 [ RunTime:0.010130s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P32-18SAX/MHIA' OR `brand` LIKE 'Polytron%' ) ) LIMIT 1 [ RunTime:0.028293s ]
SELECT `id` FROM `stock` WHERE `id` <> 57569723 AND `partno` = 'P32-18SAX/MHIA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%polytron%' ) [ RunTime:0.017006s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11181396 [ RunTime:0.029915s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57569684 LIMIT 5 [ RunTime:0.019614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57569684 ORDER BY `minOrder` ASC [ RunTime:0.022921s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57569684 ORDER BY `unit` DESC [ RunTime:0.009783s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57569684 LIMIT 2 [ RunTime:0.013529s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57569684 ORDER BY `minOrder` ASC [ RunTime:0.014880s ]
select * from pdf where partno='P32-18SXA/MHIA' and brandshort='Polytron' limit 1 [ RunTime:0.038940s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P32-18SXA/MHIA' OR `brand` LIKE 'Polytron%' ) ) LIMIT 1 [ RunTime:0.021633s ]
SELECT `id` FROM `stock` WHERE `id` <> 57569684 AND `partno` = 'P32-18SXA/MHIA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%polytron%' ) [ RunTime:0.042508s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12163349 [ RunTime:0.044526s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57569683 LIMIT 5 [ RunTime:0.042026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57569683 ORDER BY `minOrder` ASC [ RunTime:0.055842s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57569683 ORDER BY `unit` DESC [ RunTime:0.034845s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57569683 LIMIT 2 [ RunTime:0.033025s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57569683 ORDER BY `minOrder` ASC [ RunTime:0.013119s ]
select * from pdf where partno='P32-18SX/MHIA' and brandshort='Polytron' limit 1 [ RunTime:0.032230s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P32-18SX/MHIA' OR `brand` LIKE 'Polytron%' ) ) LIMIT 1 [ RunTime:0.013999s ]
SELECT `id` FROM `stock` WHERE `id` <> 57569683 AND `partno` = 'P32-18SX/MHIA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%polytron%' ) [ RunTime:0.043848s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12163348 [ RunTime:0.051459s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57569682 LIMIT 5 [ RunTime:0.057619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57569682 ORDER BY `minOrder` ASC [ RunTime:0.022332s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57569682 ORDER BY `unit` DESC [ RunTime:0.008157s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57569682 LIMIT 2 [ RunTime:0.025020s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57569682 ORDER BY `minOrder` ASC [ RunTime:0.023031s ]
select * from pdf where partno='P32-18SW/MHIA' and brandshort='Polytron' limit 1 [ RunTime:0.020592s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P32-18SW/MHIA' OR `brand` LIKE 'Polytron%' ) ) LIMIT 1 [ RunTime:0.053018s ]
SELECT `id` FROM `stock` WHERE `id` <> 57569682 AND `partno` = 'P32-18SW/MHIA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%polytron%' ) [ RunTime:0.031668s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12163347 [ RunTime:0.031510s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57569680 LIMIT 5 [ RunTime:0.025787s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57569680 ORDER BY `minOrder` ASC [ RunTime:0.018011s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57569680 ORDER BY `unit` DESC [ RunTime:0.022044s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57569680 LIMIT 2 [ RunTime:0.030521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57569680 ORDER BY `minOrder` ASC [ RunTime:0.007071s ]
select * from pdf where partno='P32-18SXE/MHIA' and brandshort='Polytron' limit 1 [ RunTime:0.043945s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P32-18SXE/MHIA' OR `brand` LIKE 'Polytron%' ) ) LIMIT 1 [ RunTime:0.005735s ]
SELECT `id` FROM `stock` WHERE `id` <> 57569680 AND `partno` = 'P32-18SXE/MHIA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%polytron%' ) [ RunTime:0.027911s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12163343 [ RunTime:0.020277s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57569679 LIMIT 5 [ RunTime:0.034843s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57569679 ORDER BY `minOrder` ASC [ RunTime:0.053920s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57569679 ORDER BY `unit` DESC [ RunTime:0.012264s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57569679 LIMIT 2 [ RunTime:0.017915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57569679 ORDER BY `minOrder` ASC [ RunTime:0.006063s ]
select * from pdf where partno='P32-18SQ/MHIA' and brandshort='Polytron' limit 1 [ RunTime:0.006227s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P32-18SQ/MHIA' OR `brand` LIKE 'Polytron%' ) ) LIMIT 1 [ RunTime:0.004126s ]
SELECT `id` FROM `stock` WHERE `id` <> 57569679 AND `partno` = 'P32-18SQ/MHIA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%polytron%' ) [ RunTime:0.035422s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12163342 [ RunTime:0.022266s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57569674 LIMIT 5 [ RunTime:0.008856s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57569674 ORDER BY `minOrder` ASC [ RunTime:0.013204s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57569674 ORDER BY `unit` DESC [ RunTime:0.021553s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57569674 LIMIT 2 [ RunTime:0.034568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57569674 ORDER BY `minOrder` ASC [ RunTime:0.009146s ]
select * from pdf where partno='P32-1AX/MHIA' and brandshort='Polytron' limit 1 [ RunTime:0.030779s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P32-1AX/MHIA' OR `brand` LIKE 'Polytron%' ) ) LIMIT 1 [ RunTime:0.020229s ]
SELECT `id` FROM `stock` WHERE `id` <> 57569674 AND `partno` = 'P32-1AX/MHIA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%polytron%' ) [ RunTime:0.065580s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57569629 LIMIT 5 [ RunTime:0.024120s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57569629 ORDER BY `minOrder` ASC [ RunTime:0.042783s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57569629 ORDER BY `unit` DESC [ RunTime:0.023211s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57569629 LIMIT 2 [ RunTime:0.007670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57569629 ORDER BY `minOrder` ASC [ RunTime:0.011324s ]
select * from pdf where partno='P32-18XA/MHIA' and brandshort='Polytron' limit 1 [ RunTime:0.019187s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P32-18XA/MHIA' OR `brand` LIKE 'Polytron%' ) ) LIMIT 1 [ RunTime:0.001794s ]
SELECT `id` FROM `stock` WHERE `id` <> 57569629 AND `partno` = 'P32-18XA/MHIA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%polytron%' ) [ RunTime:0.009390s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12163315 [ RunTime:0.032029s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57569628 LIMIT 5 [ RunTime:0.024901s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57569628 ORDER BY `minOrder` ASC [ RunTime:0.006211s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57569628 ORDER BY `unit` DESC [ RunTime:0.002079s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57569628 LIMIT 2 [ RunTime:0.003335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57569628 ORDER BY `minOrder` ASC [ RunTime:0.004296s ]
select * from pdf where partno='P32-18X/MHIA' and brandshort='Polytron' limit 1 [ RunTime:0.016195s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P32-18X/MHIA' OR `brand` LIKE 'Polytron%' ) ) LIMIT 1 [ RunTime:0.012893s ]
SELECT `id` FROM `stock` WHERE `id` <> 57569628 AND `partno` = 'P32-18X/MHIA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%polytron%' ) [ RunTime:0.026235s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12163314 [ RunTime:0.005319s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57569627 LIMIT 5 [ RunTime:0.009981s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57569627 ORDER BY `minOrder` ASC [ RunTime:0.007812s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57569627 ORDER BY `unit` DESC [ RunTime:0.013345s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57569627 LIMIT 2 [ RunTime:0.003680s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57569627 ORDER BY `minOrder` ASC [ RunTime:0.001728s ]
select * from pdf where partno='P32-18S/MHIA' and brandshort='Polytron' limit 1 [ RunTime:0.005888s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P32-18S/MHIA' OR `brand` LIKE 'Polytron%' ) ) LIMIT 1 [ RunTime:0.001518s ]
SELECT `id` FROM `stock` WHERE `id` <> 57569627 AND `partno` = 'P32-18S/MHIA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%polytron%' ) [ RunTime:0.001317s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12163313 [ RunTime:0.006365s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57569626 LIMIT 5 [ RunTime:0.007532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57569626 ORDER BY `minOrder` ASC [ RunTime:0.004672s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57569626 ORDER BY `unit` DESC [ RunTime:0.000556s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57569626 LIMIT 2 [ RunTime:0.013105s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57569626 ORDER BY `minOrder` ASC [ RunTime:0.013786s ]
select * from pdf where partno='P32-12QX/MHIA' and brandshort='Polytron' limit 1 [ RunTime:0.005173s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P32-12QX/MHIA' OR `brand` LIKE 'Polytron%' ) ) LIMIT 1 [ RunTime:0.001000s ]
SELECT `id` FROM `stock` WHERE `id` <> 57569626 AND `partno` = 'P32-12QX/MHIA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%polytron%' ) [ RunTime:0.002893s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11181361 [ RunTime:0.004845s ]
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 'P32-1%' OR `brand` LIKE 'P32-1%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001884s ]
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 'P32-1%' OR `brand` LIKE 'P32-1%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012465s ]
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 'P32-1%' OR `brand` LIKE 'P32-1%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008266s ]
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 'P32-1%' OR `brand` LIKE 'P32-1%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004103s ]
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 'P32-1%' OR `brand` LIKE 'P32-1%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005213s ]
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 'P32-1%' OR `brand` LIKE 'P32-1%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007663s ]
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 'P32-1%' OR `brand` LIKE 'P32-1%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002023s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'P32-1%' OR `brand` LIKE 'P32-1%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.004723s ]