SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002283s ]
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 '5194%' OR `brand` LIKE '5194%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.064249s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.011909s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13899501 LIMIT 5 [ RunTime:0.060950s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.021728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13899501 ORDER BY `minOrder` ASC [ RunTime:0.034621s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003462s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13899501 ORDER BY `unit` DESC [ RunTime:0.032440s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.012052s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13899501 LIMIT 2 [ RunTime:0.043879s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13899501 ORDER BY `minOrder` ASC [ RunTime:0.010049s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12511817 LIMIT 5 [ RunTime:0.043974s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12511817 ORDER BY `minOrder` ASC [ RunTime:0.016728s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12511817 ORDER BY `unit` DESC [ RunTime:0.043289s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12511817 LIMIT 2 [ RunTime:0.041737s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12511817 ORDER BY `minOrder` ASC [ RunTime:0.007033s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13471002 LIMIT 5 [ RunTime:0.016277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13471002 ORDER BY `minOrder` ASC [ RunTime:0.027768s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13471002 ORDER BY `unit` DESC [ RunTime:0.068775s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13471002 LIMIT 2 [ RunTime:0.024440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13471002 ORDER BY `minOrder` ASC [ RunTime:0.009619s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14386644 LIMIT 5 [ RunTime:0.072280s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14386644 ORDER BY `minOrder` ASC [ RunTime:0.062195s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14386644 ORDER BY `unit` DESC [ RunTime:0.026403s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14386644 LIMIT 2 [ RunTime:0.049765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14386644 ORDER BY `minOrder` ASC [ RunTime:0.039376s ]
select * from pdf where partno='5194C SL005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.034801s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13513943 LIMIT 5 [ RunTime:0.047458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13513943 ORDER BY `minOrder` ASC [ RunTime:0.011333s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13513943 ORDER BY `unit` DESC [ RunTime:0.028496s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13513943 LIMIT 2 [ RunTime:0.058719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13513943 ORDER BY `minOrder` ASC [ RunTime:0.046782s ]
select * from pdf where partno='5194C SL001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.064567s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19583430 LIMIT 5 [ RunTime:0.025392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19583430 ORDER BY `minOrder` ASC [ RunTime:0.015123s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19583430 ORDER BY `unit` DESC [ RunTime:0.067021s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19583430 LIMIT 2 [ RunTime:0.067304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19583430 ORDER BY `minOrder` ASC [ RunTime:0.022736s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14377831 LIMIT 5 [ RunTime:0.024138s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14377831 ORDER BY `minOrder` ASC [ RunTime:0.139771s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14377831 ORDER BY `unit` DESC [ RunTime:0.023147s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14377831 LIMIT 2 [ RunTime:0.035280s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14377831 ORDER BY `minOrder` ASC [ RunTime:0.026642s ]
select * from pdf where partno='5194C SL002' and brandshort='Alpha Wire' limit 1 [ RunTime:0.061861s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13503767 LIMIT 5 [ RunTime:0.025063s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13503767 ORDER BY `minOrder` ASC [ RunTime:0.047474s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13503767 ORDER BY `unit` DESC [ RunTime:0.062781s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13503767 LIMIT 2 [ RunTime:0.015048s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13503767 ORDER BY `minOrder` ASC [ RunTime:0.003616s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13503761 LIMIT 5 [ RunTime:0.032398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13503761 ORDER BY `minOrder` ASC [ RunTime:0.033326s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13503761 ORDER BY `unit` DESC [ RunTime:0.041530s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13503761 LIMIT 2 [ RunTime:0.010455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13503761 ORDER BY `minOrder` ASC [ RunTime:0.008785s ]
select * from pdf where partno='5194C BK199' and brandshort='Alpha Wire' limit 1 [ RunTime:0.010215s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12500710 LIMIT 5 [ RunTime:0.037840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12500710 ORDER BY `minOrder` ASC [ RunTime:0.020100s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12500710 ORDER BY `unit` DESC [ RunTime:0.025115s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12500710 LIMIT 2 [ RunTime:0.045897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12500710 ORDER BY `minOrder` ASC [ RunTime:0.013736s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12500659 LIMIT 5 [ RunTime:0.028863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12500659 ORDER BY `minOrder` ASC [ RunTime:0.013451s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12500659 ORDER BY `unit` DESC [ RunTime:0.052726s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12500659 LIMIT 2 [ RunTime:0.020227s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12500659 ORDER BY `minOrder` ASC [ RunTime:0.017255s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12500644 LIMIT 5 [ RunTime:0.018184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12500644 ORDER BY `minOrder` ASC [ RunTime:0.029290s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12500644 ORDER BY `unit` DESC [ RunTime:0.013741s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12500644 LIMIT 2 [ RunTime:0.001957s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12500644 ORDER BY `minOrder` ASC [ RunTime:0.004710s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12500640 LIMIT 5 [ RunTime:0.011214s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12500640 ORDER BY `minOrder` ASC [ RunTime:0.022074s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12500640 ORDER BY `unit` DESC [ RunTime:0.014722s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12500640 LIMIT 2 [ RunTime:0.027504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12500640 ORDER BY `minOrder` ASC [ RunTime:0.004186s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12500601 LIMIT 5 [ RunTime:0.001145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12500601 ORDER BY `minOrder` ASC [ RunTime:0.010525s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12500601 ORDER BY `unit` DESC [ RunTime:0.003932s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12500601 LIMIT 2 [ RunTime:0.007972s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12500601 ORDER BY `minOrder` ASC [ RunTime:0.003639s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12500550 LIMIT 5 [ RunTime:0.007847s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12500550 ORDER BY `minOrder` ASC [ RunTime:0.006259s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12500550 ORDER BY `unit` DESC [ RunTime:0.016725s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12500550 LIMIT 2 [ RunTime:0.022833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12500550 ORDER BY `minOrder` ASC [ RunTime:0.004462s ]
select * from pdf where partno='51940-305LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.014305s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12500541 LIMIT 5 [ RunTime:0.004319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12500541 ORDER BY `minOrder` ASC [ RunTime:0.010010s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12500541 ORDER BY `unit` DESC [ RunTime:0.006057s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12500541 LIMIT 2 [ RunTime:0.002165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12500541 ORDER BY `minOrder` ASC [ RunTime:0.000582s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12500494 LIMIT 5 [ RunTime:0.003638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12500494 ORDER BY `minOrder` ASC [ RunTime:0.004727s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12500494 ORDER BY `unit` DESC [ RunTime:0.011922s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12500494 LIMIT 2 [ RunTime:0.009968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12500494 ORDER BY `minOrder` ASC [ RunTime:0.005640s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12500418 LIMIT 5 [ RunTime:0.014233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12500418 ORDER BY `minOrder` ASC [ RunTime:0.003675s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12500418 ORDER BY `unit` DESC [ RunTime:0.006049s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12500418 LIMIT 2 [ RunTime:0.006989s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12500418 ORDER BY `minOrder` ASC [ RunTime:0.002990s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12500339 LIMIT 5 [ RunTime:0.003243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12500339 ORDER BY `minOrder` ASC [ RunTime:0.009487s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12500339 ORDER BY `unit` DESC [ RunTime:0.000443s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12500339 LIMIT 2 [ RunTime:0.001470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12500339 ORDER BY `minOrder` ASC [ RunTime:0.000343s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12500326 LIMIT 5 [ RunTime:0.007820s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12500326 ORDER BY `minOrder` ASC [ RunTime:0.006046s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12500326 ORDER BY `unit` DESC [ RunTime:0.001556s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12500326 LIMIT 2 [ RunTime:0.000444s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12500326 ORDER BY `minOrder` ASC [ RunTime:0.004072s ]
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 '5194%' OR `brand` LIKE '5194%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003827s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32282220 LIMIT 5 [ RunTime:0.002364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32282220 ORDER BY `minOrder` ASC [ RunTime:0.005482s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32282220 ORDER BY `unit` DESC [ RunTime:0.002606s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32282220 LIMIT 2 [ RunTime:0.000944s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32282220 ORDER BY `minOrder` ASC [ RunTime:0.004361s ]
select * from pdf where partno='51943' and brandshort='te connectivity' limit 1 [ RunTime:0.019065s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001355s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '51943' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.018091s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51137912 LIMIT 5 [ RunTime:0.007604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51137912 ORDER BY `minOrder` ASC [ RunTime:0.025723s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51137912 ORDER BY `unit` DESC [ RunTime:0.014282s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51137912 LIMIT 2 [ RunTime:0.004875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51137912 ORDER BY `minOrder` ASC [ RunTime:0.003451s ]
select * from pdf where partno='5194c sl005' and brandshort='alpha wire' limit 1 [ RunTime:0.003424s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5194c sl005' OR `brand` LIKE 'alpha wire%' ) ) LIMIT 1 [ RunTime:0.002943s ]
SELECT `id` FROM `stock` WHERE `id` <> 51137912 AND `partno` = '5194c sl005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.002239s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14386644 [ RunTime:0.015614s ]
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 '5194%' OR `brand` LIKE '5194%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005867s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63503877 LIMIT 5 [ RunTime:0.006103s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63503877 ORDER BY `minOrder` ASC [ RunTime:0.019721s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63503877 ORDER BY `unit` DESC [ RunTime:0.009337s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63503877 LIMIT 2 [ RunTime:0.008548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63503877 ORDER BY `minOrder` ASC [ RunTime:0.002900s ]
select * from pdf where partno='5194TR' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.006041s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5194TR' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.010564s ]
SELECT `id` FROM `stock` WHERE `id` <> 63503877 AND `partno` = '5194TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.007806s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13899501 [ RunTime:0.006063s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60943390 LIMIT 5 [ RunTime:0.008591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60943390 ORDER BY `minOrder` ASC [ RunTime:0.006932s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60943390 ORDER BY `unit` DESC [ RunTime:0.000712s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60943390 LIMIT 2 [ RunTime:0.008422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60943390 ORDER BY `minOrder` ASC [ RunTime:0.003653s ]
select * from pdf where partno='51940-230LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.005611s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '51940-230LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.015767s ]
SELECT `id` FROM `stock` WHERE `id` <> 60943390 AND `partno` = '51940-230LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.008487s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11393949 [ RunTime:0.016065s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60939404 LIMIT 5 [ RunTime:0.017884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60939404 ORDER BY `minOrder` ASC [ RunTime:0.029149s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60939404 ORDER BY `unit` DESC [ RunTime:0.024303s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60939404 LIMIT 2 [ RunTime:0.030023s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60939404 ORDER BY `minOrder` ASC [ RunTime:0.010314s ]
select * from pdf where partno='51943' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.003560s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '51943' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.022342s ]
SELECT `id` FROM `stock` WHERE `id` <> 60939404 AND `partno` = '51943' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.023521s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12511817 [ RunTime:0.009153s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60943024 LIMIT 5 [ RunTime:0.004018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60943024 ORDER BY `minOrder` ASC [ RunTime:0.014422s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60943024 ORDER BY `unit` DESC [ RunTime:0.006218s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60943024 LIMIT 2 [ RunTime:0.007606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60943024 ORDER BY `minOrder` ASC [ RunTime:0.000745s ]
select * from pdf where partno='51940-520LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.006575s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '51940-520LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.035163s ]
SELECT `id` FROM `stock` WHERE `id` <> 60943024 AND `partno` = '51940-520LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.014967s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12489013 [ RunTime:0.025583s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60943054 LIMIT 5 [ RunTime:0.013968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60943054 ORDER BY `minOrder` ASC [ RunTime:0.019087s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60943054 ORDER BY `unit` DESC [ RunTime:0.015301s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60943054 LIMIT 2 [ RunTime:0.002458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60943054 ORDER BY `minOrder` ASC [ RunTime:0.002179s ]
select * from pdf where partno='51940-456LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.021436s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '51940-456LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.035125s ]
SELECT `id` FROM `stock` WHERE `id` <> 60943054 AND `partno` = '51940-456LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.007038s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11392432 [ RunTime:0.011692s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60943082 LIMIT 5 [ RunTime:0.016531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60943082 ORDER BY `minOrder` ASC [ RunTime:0.016595s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60943082 ORDER BY `unit` DESC [ RunTime:0.002369s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60943082 LIMIT 2 [ RunTime:0.010346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60943082 ORDER BY `minOrder` ASC [ RunTime:0.007376s ]
select * from pdf where partno='51940-185LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.017498s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '51940-185LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.003930s ]
SELECT `id` FROM `stock` WHERE `id` <> 60943082 AND `partno` = '51940-185LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.000905s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58297815 LIMIT 5 [ RunTime:0.020432s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58297815 ORDER BY `minOrder` ASC [ RunTime:0.014356s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58297815 ORDER BY `unit` DESC [ RunTime:0.008344s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58297815 LIMIT 2 [ RunTime:0.014369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58297815 ORDER BY `minOrder` ASC [ RunTime:0.000931s ]
select * from pdf where partno='5194' and brandshort='Pololu' limit 1 [ RunTime:0.005062s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5194' OR `brand` LIKE 'Pololu%' ) ) LIMIT 1 [ RunTime:0.014224s ]
SELECT `id` FROM `stock` WHERE `id` <> 58297815 AND `partno` = '5194' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pololu%' ) [ RunTime:0.013398s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13471002 [ RunTime:0.015275s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60943087 LIMIT 5 [ RunTime:0.022933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60943087 ORDER BY `minOrder` ASC [ RunTime:0.035384s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60943087 ORDER BY `unit` DESC [ RunTime:0.030345s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60943087 LIMIT 2 [ RunTime:0.045031s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60943087 ORDER BY `minOrder` ASC [ RunTime:0.003824s ]
select * from pdf where partno='51940-059LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.029472s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '51940-059LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.052977s ]
SELECT `id` FROM `stock` WHERE `id` <> 60943087 AND `partno` = '51940-059LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.090102s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64573584 LIMIT 5 [ RunTime:0.079825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64573584 ORDER BY `minOrder` ASC [ RunTime:0.092982s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64573584 ORDER BY `unit` DESC [ RunTime:0.038298s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64573584 LIMIT 2 [ RunTime:0.092716s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64573584 ORDER BY `minOrder` ASC [ RunTime:0.033898s ]
select * from pdf where partno='5194CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.095947s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5194CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.048186s ]
SELECT `id` FROM `stock` WHERE `id` <> 64573584 AND `partno` = '5194CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.030004s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60944379 LIMIT 5 [ RunTime:0.051256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60944379 ORDER BY `minOrder` ASC [ RunTime:0.014057s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60944379 ORDER BY `unit` DESC [ RunTime:0.075072s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60944379 LIMIT 2 [ RunTime:0.040056s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60944379 ORDER BY `minOrder` ASC [ RunTime:0.013153s ]
select * from pdf where partno='51940-220LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.021214s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '51940-220LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.056392s ]
SELECT `id` FROM `stock` WHERE `id` <> 60944379 AND `partno` = '51940-220LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.049928s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62998871 LIMIT 5 [ RunTime:0.024470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62998871 ORDER BY `minOrder` ASC [ RunTime:0.061942s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62998871 ORDER BY `unit` DESC [ RunTime:0.046110s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62998871 LIMIT 2 [ RunTime:0.023198s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62998871 ORDER BY `minOrder` ASC [ RunTime:0.022154s ]
select * from pdf where partno='5194C SL001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.007374s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5194C SL001' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.029542s ]
SELECT `id` FROM `stock` WHERE `id` <> 62998871 AND `partno` = '5194C SL001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.047911s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13513943 [ RunTime:0.038382s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62998385 LIMIT 5 [ RunTime:0.030241s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62998385 ORDER BY `minOrder` ASC [ RunTime:0.047415s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62998385 ORDER BY `unit` DESC [ RunTime:0.010541s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62998385 LIMIT 2 [ RunTime:0.035856s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62998385 ORDER BY `minOrder` ASC [ RunTime:0.012655s ]
select * from pdf where partno='5194C SL005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.003883s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5194C SL005' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.019534s ]
SELECT `id` FROM `stock` WHERE `id` <> 62998385 AND `partno` = '5194C SL005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.050049s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14386644 [ RunTime:0.004394s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63021605 LIMIT 5 [ RunTime:0.069650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63021605 ORDER BY `minOrder` ASC [ RunTime:0.040697s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63021605 ORDER BY `unit` DESC [ RunTime:0.040859s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63021605 LIMIT 2 [ RunTime:0.021233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63021605 ORDER BY `minOrder` ASC [ RunTime:0.011790s ]
select * from pdf where partno='5194C BK199' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000585s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5194C BK199' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.006673s ]
SELECT `id` FROM `stock` WHERE `id` <> 63021605 AND `partno` = '5194C BK199' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.037819s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13503761 [ RunTime:0.004612s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63021595 LIMIT 5 [ RunTime:0.002677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63021595 ORDER BY `minOrder` ASC [ RunTime:0.006694s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63021595 ORDER BY `unit` DESC [ RunTime:0.009842s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63021595 LIMIT 2 [ RunTime:0.018724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63021595 ORDER BY `minOrder` ASC [ RunTime:0.005407s ]
select * from pdf where partno='5194C SL199' and brandshort='Alpha Wire' limit 1 [ RunTime:0.001261s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5194C SL199' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.010960s ]
SELECT `id` FROM `stock` WHERE `id` <> 63021595 AND `partno` = '5194C SL199' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.004407s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13503767 [ RunTime:0.009887s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63004293 LIMIT 5 [ RunTime:0.008066s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63004293 ORDER BY `minOrder` ASC [ RunTime:0.011249s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63004293 ORDER BY `unit` DESC [ RunTime:0.000931s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63004293 LIMIT 2 [ RunTime:0.003000s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63004293 ORDER BY `minOrder` ASC [ RunTime:0.000587s ]
select * from pdf where partno='5194C SL002' and brandshort='Alpha Wire' limit 1 [ RunTime:0.003596s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5194C SL002' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.000938s ]
SELECT `id` FROM `stock` WHERE `id` <> 63004293 AND `partno` = '5194C SL002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.000867s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14377831 [ RunTime:0.008386s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60950813 LIMIT 5 [ RunTime:0.005461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60950813 ORDER BY `minOrder` ASC [ RunTime:0.000950s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60950813 ORDER BY `unit` DESC [ RunTime:0.000463s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60950813 LIMIT 2 [ RunTime:0.002403s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60950813 ORDER BY `minOrder` ASC [ RunTime:0.001615s ]
select * from pdf where partno='51940-350LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.004171s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '51940-350LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.002756s ]
SELECT `id` FROM `stock` WHERE `id` <> 60950813 AND `partno` = '51940-350LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.003800s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12491368 [ RunTime:0.005653s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60949659 LIMIT 5 [ RunTime:0.001299s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60949659 ORDER BY `minOrder` ASC [ RunTime:0.003424s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60949659 ORDER BY `unit` DESC [ RunTime:0.014201s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60949659 LIMIT 2 [ RunTime:0.006042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60949659 ORDER BY `minOrder` ASC [ RunTime:0.010944s ]
select * from pdf where partno='51940-233LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.003338s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '51940-233LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.010629s ]
SELECT `id` FROM `stock` WHERE `id` <> 60949659 AND `partno` = '51940-233LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.007914s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11394381 [ RunTime:0.002144s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60948812 LIMIT 5 [ RunTime:0.005729s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60948812 ORDER BY `minOrder` ASC [ RunTime:0.003082s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60948812 ORDER BY `unit` DESC [ RunTime:0.012579s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60948812 LIMIT 2 [ RunTime:0.002275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60948812 ORDER BY `minOrder` ASC [ RunTime:0.003927s ]
select * from pdf where partno='51940-062LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.001349s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '51940-062LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.009515s ]
SELECT `id` FROM `stock` WHERE `id` <> 60948812 AND `partno` = '51940-062LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.002335s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11392983 [ RunTime:0.007893s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60948339 LIMIT 5 [ RunTime:0.004429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60948339 ORDER BY `minOrder` ASC [ RunTime:0.000986s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60948339 ORDER BY `unit` DESC [ RunTime:0.006579s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60948339 LIMIT 2 [ RunTime:0.008014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60948339 ORDER BY `minOrder` ASC [ RunTime:0.011690s ]
select * from pdf where partno='51940-027LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.003370s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '51940-027LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.003272s ]
SELECT `id` FROM `stock` WHERE `id` <> 60948339 AND `partno` = '51940-027LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.015316s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11393147 [ RunTime:0.014299s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60948162 LIMIT 5 [ RunTime:0.016309s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60948162 ORDER BY `minOrder` ASC [ RunTime:0.002136s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60948162 ORDER BY `unit` DESC [ RunTime:0.003585s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60948162 LIMIT 2 [ RunTime:0.025983s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60948162 ORDER BY `minOrder` ASC [ RunTime:0.001465s ]
select * from pdf where partno='51940-117LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.003574s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '51940-117LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.011434s ]
SELECT `id` FROM `stock` WHERE `id` <> 60948162 AND `partno` = '51940-117LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.001207s ]
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 '5194%' OR `brand` LIKE '5194%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001484s ]
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 '5194%' OR `brand` LIKE '5194%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011741s ]
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 '5194%' OR `brand` LIKE '5194%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001181s ]
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 '5194%' OR `brand` LIKE '5194%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001168s ]
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 '5194%' OR `brand` LIKE '5194%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018579s ]
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 '5194%' OR `brand` LIKE '5194%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013223s ]
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 '5194%' OR `brand` LIKE '5194%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006739s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5194%' OR `brand` LIKE '5194%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.005132s ]