SHOW FULL COLUMNS FROM `stock` [ RunTime:0.004520s ]
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 '16001%' OR `brand` LIKE '16001%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.050125s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002984s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12513390 LIMIT 5 [ RunTime:0.021118s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12513390 ORDER BY `minOrder` ASC [ RunTime:0.011005s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001200s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12513390 ORDER BY `unit` DESC [ RunTime:0.011105s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001128s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12513390 LIMIT 2 [ RunTime:0.014430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12513390 ORDER BY `minOrder` ASC [ RunTime:0.014247s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12627261 LIMIT 5 [ RunTime:0.010800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12627261 ORDER BY `minOrder` ASC [ RunTime:0.011929s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12627261 ORDER BY `unit` DESC [ RunTime:0.021557s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12627261 LIMIT 2 [ RunTime:0.019642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12627261 ORDER BY `minOrder` ASC [ RunTime:0.006936s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11486448 LIMIT 5 [ RunTime:0.039143s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11486448 ORDER BY `minOrder` ASC [ RunTime:0.037284s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11486448 ORDER BY `unit` DESC [ RunTime:0.022488s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11486448 LIMIT 2 [ RunTime:0.007267s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11486448 ORDER BY `minOrder` ASC [ RunTime:0.013992s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11414594 LIMIT 5 [ RunTime:0.026818s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11414594 ORDER BY `minOrder` ASC [ RunTime:0.008140s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11414594 ORDER BY `unit` DESC [ RunTime:0.023299s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11414594 LIMIT 2 [ RunTime:0.024234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11414594 ORDER BY `minOrder` ASC [ RunTime:0.019831s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12627267 LIMIT 5 [ RunTime:0.008657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12627267 ORDER BY `minOrder` ASC [ RunTime:0.030950s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12627267 ORDER BY `unit` DESC [ RunTime:0.024318s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12627267 LIMIT 2 [ RunTime:0.029234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12627267 ORDER BY `minOrder` ASC [ RunTime:0.002051s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11010 LIMIT 5 [ RunTime:0.002439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11010 ORDER BY `minOrder` ASC [ RunTime:0.021100s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11010 ORDER BY `unit` DESC [ RunTime:0.021338s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11010 LIMIT 2 [ RunTime:0.002056s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11010 ORDER BY `minOrder` ASC [ RunTime:0.002887s ]
select * from pdf where partno='160013' and brandshort='AMP - TE CONNECTIVITY' limit 1 [ RunTime:0.028145s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001208s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '160013' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.020042s ]
SELECT `id` FROM `stock` WHERE `id` <> 11010 AND `partno` = '160013' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amp - te connectivity%' ) [ RunTime:0.021927s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12159073 LIMIT 5 [ RunTime:0.019106s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12159073 ORDER BY `minOrder` ASC [ RunTime:0.014567s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12159073 ORDER BY `unit` DESC [ RunTime:0.006074s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12159073 LIMIT 2 [ RunTime:0.005403s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12159073 ORDER BY `minOrder` ASC [ RunTime:0.004035s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16196975 LIMIT 5 [ RunTime:0.007555s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16196975 ORDER BY `minOrder` ASC [ RunTime:0.017088s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16196975 ORDER BY `unit` DESC [ RunTime:0.006589s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16196975 LIMIT 2 [ RunTime:0.001827s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16196975 ORDER BY `minOrder` ASC [ RunTime:0.000453s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19774113 LIMIT 5 [ RunTime:0.001192s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19774113 ORDER BY `minOrder` ASC [ RunTime:0.000681s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19774113 ORDER BY `unit` DESC [ RunTime:0.000592s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19774113 LIMIT 2 [ RunTime:0.001978s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19774113 ORDER BY `minOrder` ASC [ RunTime:0.001067s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19799177 LIMIT 5 [ RunTime:0.000995s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19799177 ORDER BY `minOrder` ASC [ RunTime:0.002357s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19799177 ORDER BY `unit` DESC [ RunTime:0.000698s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19799177 LIMIT 2 [ RunTime:0.001050s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19799177 ORDER BY `minOrder` ASC [ RunTime:0.003104s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19793840 LIMIT 5 [ RunTime:0.001169s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19793840 ORDER BY `minOrder` ASC [ RunTime:0.011210s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19793840 ORDER BY `unit` DESC [ RunTime:0.014555s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19793840 LIMIT 2 [ RunTime:0.007123s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19793840 ORDER BY `minOrder` ASC [ RunTime:0.003480s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19793839 LIMIT 5 [ RunTime:0.010748s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19793839 ORDER BY `minOrder` ASC [ RunTime:0.016049s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19793839 ORDER BY `unit` DESC [ RunTime:0.020831s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19793839 LIMIT 2 [ RunTime:0.006780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19793839 ORDER BY `minOrder` ASC [ RunTime:0.007270s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19780050 LIMIT 5 [ RunTime:0.001113s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19780050 ORDER BY `minOrder` ASC [ RunTime:0.000600s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19780050 ORDER BY `unit` DESC [ RunTime:0.000519s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19780050 LIMIT 2 [ RunTime:0.013496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19780050 ORDER BY `minOrder` ASC [ RunTime:0.005406s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19660047 LIMIT 5 [ RunTime:0.000974s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19660047 ORDER BY `minOrder` ASC [ RunTime:0.001168s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19660047 ORDER BY `unit` DESC [ RunTime:0.000543s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19660047 LIMIT 2 [ RunTime:0.000800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19660047 ORDER BY `minOrder` ASC [ RunTime:0.003358s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18914740 LIMIT 5 [ RunTime:0.001257s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18914740 ORDER BY `minOrder` ASC [ RunTime:0.000957s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18914740 ORDER BY `unit` DESC [ RunTime:0.009965s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18914740 LIMIT 2 [ RunTime:0.000511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18914740 ORDER BY `minOrder` ASC [ RunTime:0.000370s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18914206 LIMIT 5 [ RunTime:0.000875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18914206 ORDER BY `minOrder` ASC [ RunTime:0.002732s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18914206 ORDER BY `unit` DESC [ RunTime:0.000551s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18914206 LIMIT 2 [ RunTime:0.003755s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18914206 ORDER BY `minOrder` ASC [ RunTime:0.005524s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16412672 LIMIT 5 [ RunTime:0.000939s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16412672 ORDER BY `minOrder` ASC [ RunTime:0.000552s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16412672 ORDER BY `unit` DESC [ RunTime:0.003044s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16412672 LIMIT 2 [ RunTime:0.003161s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16412672 ORDER BY `minOrder` ASC [ RunTime:0.001189s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16412666 LIMIT 5 [ RunTime:0.000551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16412666 ORDER BY `minOrder` ASC [ RunTime:0.000543s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16412666 ORDER BY `unit` DESC [ RunTime:0.000498s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16412666 LIMIT 2 [ RunTime:0.000475s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16412666 ORDER BY `minOrder` ASC [ RunTime:0.000391s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16412607 LIMIT 5 [ RunTime:0.000859s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16412607 ORDER BY `minOrder` ASC [ RunTime:0.000600s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16412607 ORDER BY `unit` DESC [ RunTime:0.001766s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16412607 LIMIT 2 [ RunTime:0.015937s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16412607 ORDER BY `minOrder` ASC [ RunTime:0.005940s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16216636 LIMIT 5 [ RunTime:0.002605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16216636 ORDER BY `minOrder` ASC [ RunTime:0.001435s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16216636 ORDER BY `unit` DESC [ RunTime:0.000619s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16216636 LIMIT 2 [ RunTime:0.000490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16216636 ORDER BY `minOrder` ASC [ RunTime:0.002969s ]
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 '16001%' OR `brand` LIKE '16001%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013637s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32268269 LIMIT 5 [ RunTime:0.006473s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32268269 ORDER BY `minOrder` ASC [ RunTime:0.013539s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32268269 ORDER BY `unit` DESC [ RunTime:0.005778s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32268269 LIMIT 2 [ RunTime:0.001417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32268269 ORDER BY `minOrder` ASC [ RunTime:0.000537s ]
select * from pdf where partno='160014-0013' and brandshort='molex' limit 1 [ RunTime:0.002054s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '160014-0013' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.012023s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32267778 LIMIT 5 [ RunTime:0.002514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267778 ORDER BY `minOrder` ASC [ RunTime:0.004604s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32267778 ORDER BY `unit` DESC [ RunTime:0.000644s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32267778 LIMIT 2 [ RunTime:0.002199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267778 ORDER BY `minOrder` ASC [ RunTime:0.002986s ]
select * from pdf where partno='160013-6604' and brandshort='molex' limit 1 [ RunTime:0.003581s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '160013-6604' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.012452s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32267777 LIMIT 5 [ RunTime:0.011861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267777 ORDER BY `minOrder` ASC [ RunTime:0.000806s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32267777 ORDER BY `unit` DESC [ RunTime:0.011235s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32267777 LIMIT 2 [ RunTime:0.011506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267777 ORDER BY `minOrder` ASC [ RunTime:0.005776s ]
select * from pdf where partno='160013-0623' and brandshort='molex' limit 1 [ RunTime:0.005942s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '160013-0623' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.010753s ]
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 '16001%' OR `brand` LIKE '16001%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006117s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60644001 LIMIT 5 [ RunTime:0.001682s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60644001 ORDER BY `minOrder` ASC [ RunTime:0.002433s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60644001 ORDER BY `unit` DESC [ RunTime:0.010588s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60644001 LIMIT 2 [ RunTime:0.014991s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60644001 ORDER BY `minOrder` ASC [ RunTime:0.007271s ]
select * from pdf where partno='160018-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001089s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '160018-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.003413s ]
SELECT `id` FROM `stock` WHERE `id` <> 60644001 AND `partno` = '160018-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000751s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12513390 [ RunTime:0.000474s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60644165 LIMIT 5 [ RunTime:0.000451s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60644165 ORDER BY `minOrder` ASC [ RunTime:0.005205s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60644165 ORDER BY `unit` DESC [ RunTime:0.003181s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60644165 LIMIT 2 [ RunTime:0.013838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60644165 ORDER BY `minOrder` ASC [ RunTime:0.002742s ]
select * from pdf where partno='160013' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.010694s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '160013' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.019893s ]
SELECT `id` FROM `stock` WHERE `id` <> 60644165 AND `partno` = '160013' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.013413s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11414594 [ RunTime:0.015558s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59936958 LIMIT 5 [ RunTime:0.006574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59936958 ORDER BY `minOrder` ASC [ RunTime:0.011147s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59936958 ORDER BY `unit` DESC [ RunTime:0.002646s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59936958 LIMIT 2 [ RunTime:0.009324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59936958 ORDER BY `minOrder` ASC [ RunTime:0.008880s ]
select * from pdf where partno='1600140011' and brandshort='Molex' limit 1 [ RunTime:0.020871s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1600140011' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.030165s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59944764 LIMIT 5 [ RunTime:0.034250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59944764 ORDER BY `minOrder` ASC [ RunTime:0.028660s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59944764 ORDER BY `unit` DESC [ RunTime:0.013040s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59944764 LIMIT 2 [ RunTime:0.010730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59944764 ORDER BY `minOrder` ASC [ RunTime:0.013647s ]
select * from pdf where partno='160014-0014' and brandshort='WEC' limit 1 [ RunTime:0.010285s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '160014-0014' OR `brand` LIKE 'WEC%' ) ) LIMIT 1 [ RunTime:0.029267s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59941525 LIMIT 5 [ RunTime:0.003553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59941525 ORDER BY `minOrder` ASC [ RunTime:0.015854s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59941525 ORDER BY `unit` DESC [ RunTime:0.016505s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59941525 LIMIT 2 [ RunTime:0.005011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59941525 ORDER BY `minOrder` ASC [ RunTime:0.008275s ]
select * from pdf where partno='1600140012' and brandshort='Molex' limit 1 [ RunTime:0.014543s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1600140012' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.035993s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59945121 LIMIT 5 [ RunTime:0.008508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59945121 ORDER BY `minOrder` ASC [ RunTime:0.007715s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59945121 ORDER BY `unit` DESC [ RunTime:0.000755s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59945121 LIMIT 2 [ RunTime:0.001815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59945121 ORDER BY `minOrder` ASC [ RunTime:0.000462s ]
select * from pdf where partno='1600140013' and brandshort='Molex' limit 1 [ RunTime:0.002588s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1600140013' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.017227s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63002329 LIMIT 5 [ RunTime:0.002561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63002329 ORDER BY `minOrder` ASC [ RunTime:0.006792s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63002329 ORDER BY `unit` DESC [ RunTime:0.002553s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63002329 LIMIT 2 [ RunTime:0.001374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63002329 ORDER BY `minOrder` ASC [ RunTime:0.003106s ]
select * from pdf where partno='1600117' and brandshort='LAPP' limit 1 [ RunTime:0.002491s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1600117' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.001822s ]
SELECT `id` FROM `stock` WHERE `id` <> 63002329 AND `partno` = '1600117' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.002473s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13497421 [ RunTime:0.006226s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59450879 LIMIT 5 [ RunTime:0.000928s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59450879 ORDER BY `minOrder` ASC [ RunTime:0.009360s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59450879 ORDER BY `unit` DESC [ RunTime:0.000708s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59450879 LIMIT 2 [ RunTime:0.009684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59450879 ORDER BY `minOrder` ASC [ RunTime:0.002130s ]
select * from pdf where partno='1600130641' and brandshort='Molex' limit 1 [ RunTime:0.001005s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1600130641' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.015521s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59939493 LIMIT 5 [ RunTime:0.013075s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59939493 ORDER BY `minOrder` ASC [ RunTime:0.022997s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59939493 ORDER BY `unit` DESC [ RunTime:0.007045s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59939493 LIMIT 2 [ RunTime:0.013861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59939493 ORDER BY `minOrder` ASC [ RunTime:0.001886s ]
select * from pdf where partno='1600140014' and brandshort='Molex' limit 1 [ RunTime:0.005511s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1600140014' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.029492s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63001687 LIMIT 5 [ RunTime:0.026815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63001687 ORDER BY `minOrder` ASC [ RunTime:0.012993s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63001687 ORDER BY `unit` DESC [ RunTime:0.005167s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63001687 LIMIT 2 [ RunTime:0.021321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63001687 ORDER BY `minOrder` ASC [ RunTime:0.014448s ]
select * from pdf where partno='16001233' and brandshort='LAPP' limit 1 [ RunTime:0.011774s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '16001233' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.014042s ]
SELECT `id` FROM `stock` WHERE `id` <> 63001687 AND `partno` = '16001233' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.019608s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14375091 [ RunTime:0.020944s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58568178 LIMIT 5 [ RunTime:0.007695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58568178 ORDER BY `minOrder` ASC [ RunTime:0.004984s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58568178 ORDER BY `unit` DESC [ RunTime:0.005231s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58568178 LIMIT 2 [ RunTime:0.008720s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58568178 ORDER BY `minOrder` ASC [ RunTime:0.004128s ]
select * from pdf where partno='16001' and brandshort='Excel Blades' limit 1 [ RunTime:0.000783s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '16001' OR `brand` LIKE 'Excel Blades%' ) ) LIMIT 1 [ RunTime:0.009362s ]
SELECT `id` FROM `stock` WHERE `id` <> 58568178 AND `partno` = '16001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%excel blades%' ) [ RunTime:0.007737s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12159073 [ RunTime:0.006589s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59452592 LIMIT 5 [ RunTime:0.020312s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59452592 ORDER BY `minOrder` ASC [ RunTime:0.011563s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59452592 ORDER BY `unit` DESC [ RunTime:0.030818s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59452592 LIMIT 2 [ RunTime:0.023373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59452592 ORDER BY `minOrder` ASC [ RunTime:0.007576s ]
select * from pdf where partno='1600130623' and brandshort='Molex' limit 1 [ RunTime:0.020645s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1600130623' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.036802s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59450502 LIMIT 5 [ RunTime:0.033003s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59450502 ORDER BY `minOrder` ASC [ RunTime:0.010719s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59450502 ORDER BY `unit` DESC [ RunTime:0.014434s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59450502 LIMIT 2 [ RunTime:0.001953s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59450502 ORDER BY `minOrder` ASC [ RunTime:0.001609s ]
select * from pdf where partno='1600136601' and brandshort='Molex' limit 1 [ RunTime:0.004453s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1600136601' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.020549s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63007573 LIMIT 5 [ RunTime:0.003131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63007573 ORDER BY `minOrder` ASC [ RunTime:0.005343s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63007573 ORDER BY `unit` DESC [ RunTime:0.000687s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63007573 LIMIT 2 [ RunTime:0.006506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63007573 ORDER BY `minOrder` ASC [ RunTime:0.009966s ]
select * from pdf where partno='1600118' and brandshort='LAPP' limit 1 [ RunTime:0.001406s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1600118' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.004521s ]
SELECT `id` FROM `stock` WHERE `id` <> 63007573 AND `partno` = '1600118' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.025174s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14375734 [ RunTime:0.019368s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63060231 LIMIT 5 [ RunTime:0.005520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63060231 ORDER BY `minOrder` ASC [ RunTime:0.005762s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63060231 ORDER BY `unit` DESC [ RunTime:0.003918s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63060231 LIMIT 2 [ RunTime:0.014811s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63060231 ORDER BY `minOrder` ASC [ RunTime:0.004522s ]
select * from pdf where partno='1600189' and brandshort='LAPP' limit 1 [ RunTime:0.024168s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1600189' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.013118s ]
SELECT `id` FROM `stock` WHERE `id` <> 63060231 AND `partno` = '1600189' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.003841s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63059423 LIMIT 5 [ RunTime:0.007953s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63059423 ORDER BY `minOrder` ASC [ RunTime:0.008425s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63059423 ORDER BY `unit` DESC [ RunTime:0.014301s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63059423 LIMIT 2 [ RunTime:0.003031s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63059423 ORDER BY `minOrder` ASC [ RunTime:0.013798s ]
select * from pdf where partno='1600193' and brandshort='LAPP' limit 1 [ RunTime:0.021460s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1600193' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.005416s ]
SELECT `id` FROM `stock` WHERE `id` <> 63059423 AND `partno` = '1600193' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.035071s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63058399 LIMIT 5 [ RunTime:0.006546s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63058399 ORDER BY `minOrder` ASC [ RunTime:0.001651s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63058399 ORDER BY `unit` DESC [ RunTime:0.007690s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63058399 LIMIT 2 [ RunTime:0.004387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63058399 ORDER BY `minOrder` ASC [ RunTime:0.007982s ]
select * from pdf where partno='1600195' and brandshort='LAPP' limit 1 [ RunTime:0.005045s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1600195' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.009009s ]
SELECT `id` FROM `stock` WHERE `id` <> 63058399 AND `partno` = '1600195' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.001826s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63058094 LIMIT 5 [ RunTime:0.020742s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63058094 ORDER BY `minOrder` ASC [ RunTime:0.019471s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63058094 ORDER BY `unit` DESC [ RunTime:0.006180s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63058094 LIMIT 2 [ RunTime:0.006504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63058094 ORDER BY `minOrder` ASC [ RunTime:0.003195s ]
select * from pdf where partno='1600194' and brandshort='LAPP' limit 1 [ RunTime:0.001999s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1600194' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.005309s ]
SELECT `id` FROM `stock` WHERE `id` <> 63058094 AND `partno` = '1600194' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.006003s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63036743 LIMIT 5 [ RunTime:0.008483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63036743 ORDER BY `minOrder` ASC [ RunTime:0.026300s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63036743 ORDER BY `unit` DESC [ RunTime:0.002981s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63036743 LIMIT 2 [ RunTime:0.008980s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63036743 ORDER BY `minOrder` ASC [ RunTime:0.007034s ]
select * from pdf where partno='16001283' and brandshort='LAPP' limit 1 [ RunTime:0.007937s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '16001283' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.006698s ]
SELECT `id` FROM `stock` WHERE `id` <> 63036743 AND `partno` = '16001283' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.020412s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14384084 [ RunTime:0.031607s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63035986 LIMIT 5 [ RunTime:0.012044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63035986 ORDER BY `minOrder` ASC [ RunTime:0.012921s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63035986 ORDER BY `unit` DESC [ RunTime:0.001138s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63035986 LIMIT 2 [ RunTime:0.000769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63035986 ORDER BY `minOrder` ASC [ RunTime:0.003258s ]
select * from pdf where partno='16001163' and brandshort='LAPP' limit 1 [ RunTime:0.022126s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '16001163' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.003453s ]
SELECT `id` FROM `stock` WHERE `id` <> 63035986 AND `partno` = '16001163' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.014011s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13511567 [ RunTime:0.009099s ]
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 '16001%' OR `brand` LIKE '16001%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009256s ]
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 '16001%' OR `brand` LIKE '16001%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011837s ]
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 '16001%' OR `brand` LIKE '16001%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002558s ]
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 '16001%' OR `brand` LIKE '16001%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015224s ]
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 '16001%' OR `brand` LIKE '16001%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006915s ]
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 '16001%' OR `brand` LIKE '16001%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015648s ]
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 '16001%' OR `brand` LIKE '16001%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025982s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '16001%' OR `brand` LIKE '16001%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.009346s ]