SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002488s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000543s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001345s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.121' ) [ RunTime:0.000268s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001090s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000232s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.001588s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000237s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,800,1068,1296,1456,1822,1929,2017,2101,2342,2393,2475,2518,2568) [ RunTime:0.002878s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001352s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `status` = 4 AND `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:0.013106s ]
SELECT `s`.`id` FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE `u`.`lockUser` = '0' AND ( (s.isDisplay = 1) ) AND ( `status` = 4 AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 620,20 [ RunTime:0.004736s ]
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` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE `u`.`lockUser` = '0' AND ( (s.isDisplay = 1) ) AND `s`.`id` IN ('15634','15633','15632','15631','15630','15629','15628','15627','15626','15625','15624','15623','15622','15621','15620','15619','15618','15617','15616','15615') ORDER BY FIELD(s.id, 15634,15633,15632,15631,15630,15629,15628,15627,15626,15625,15624,15623,15622,15621,15620,15619,15618,15617,15616,15615) [ RunTime:0.001399s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001045s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15634 LIMIT 4 [ RunTime:0.002137s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002751s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15634 ORDER BY `minOrder` ASC [ RunTime:0.000742s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.000960s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15634 ORDER BY `unit` DESC [ RunTime:0.001886s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001044s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15634 LIMIT 2 [ RunTime:0.001280s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15634 ORDER BY `minOrder` ASC [ RunTime:0.002002s ]
select * from pdf where partno='C0805C475K4PACTU' and brandshort='KEMET' limit 1 [ RunTime:0.002245s ]
select foldpath,foldpath2,filename from pdf_file where id=1896810 limit 1 [ RunTime:0.001778s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002357s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'C0805C475K4PACTU' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.006687s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15633 LIMIT 4 [ RunTime:0.004990s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15633 ORDER BY `minOrder` ASC [ RunTime:0.010876s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15633 ORDER BY `unit` DESC [ RunTime:0.001414s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15633 LIMIT 2 [ RunTime:0.010495s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15633 ORDER BY `minOrder` ASC [ RunTime:0.001569s ]
select * from pdf where partno='MSS1278-473MLD' and brandshort='COILCRAFT' limit 1 [ RunTime:0.002080s ]
select foldpath,foldpath2,filename from pdf_file where id=1051655 limit 1 [ RunTime:0.000246s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MSS1278-473MLD' OR `brand` LIKE 'COILCRAFT%' ) ) LIMIT 1 [ RunTime:0.003142s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15632 LIMIT 4 [ RunTime:0.000446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15632 ORDER BY `minOrder` ASC [ RunTime:0.002103s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15632 ORDER BY `unit` DESC [ RunTime:0.007954s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15632 LIMIT 2 [ RunTime:0.000750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15632 ORDER BY `minOrder` ASC [ RunTime:0.000581s ]
select * from pdf where partno='ERA3APB332V' and brandshort='PANASONIC' limit 1 [ RunTime:0.006321s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ERA3APB332V' OR `brand` LIKE 'PANASONIC%' ) ) LIMIT 1 [ RunTime:0.009952s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15631 LIMIT 4 [ RunTime:0.004078s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15631 ORDER BY `minOrder` ASC [ RunTime:0.002348s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15631 ORDER BY `unit` DESC [ RunTime:0.005212s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15631 LIMIT 2 [ RunTime:0.005921s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15631 ORDER BY `minOrder` ASC [ RunTime:0.002370s ]
select * from pdf where partno='505570-0701' and brandshort='MOLEX' limit 1 [ RunTime:0.002662s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '505570-0701' OR `brand` LIKE 'MOLEX%' ) ) LIMIT 1 [ RunTime:0.013259s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15630 LIMIT 4 [ RunTime:0.000436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15630 ORDER BY `minOrder` ASC [ RunTime:0.000472s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15630 ORDER BY `unit` DESC [ RunTime:0.000356s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15630 LIMIT 2 [ RunTime:0.002416s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15630 ORDER BY `minOrder` ASC [ RunTime:0.005597s ]
select * from pdf where partno='5103308-1' and brandshort='AMP - TE CONNECTIVITY' limit 1 [ RunTime:0.002091s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5103308-1' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.005686s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15629 LIMIT 4 [ RunTime:0.000358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15629 ORDER BY `minOrder` ASC [ RunTime:0.001327s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15629 ORDER BY `unit` DESC [ RunTime:0.006299s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15629 LIMIT 2 [ RunTime:0.005730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15629 ORDER BY `minOrder` ASC [ RunTime:0.000219s ]
select * from pdf where partno='FPF2700MPX' and brandshort='ONSEMI' limit 1 [ RunTime:0.001865s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FPF2700MPX' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.013437s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15628 LIMIT 4 [ RunTime:0.003620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15628 ORDER BY `minOrder` ASC [ RunTime:0.002653s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15628 ORDER BY `unit` DESC [ RunTime:0.002159s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15628 LIMIT 2 [ RunTime:0.002333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15628 ORDER BY `minOrder` ASC [ RunTime:0.001816s ]
select * from pdf where partno='SHT21' and brandshort='SENSIRION' limit 1 [ RunTime:0.002001s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SHT21' OR `brand` LIKE 'SENSIRION%' ) ) LIMIT 1 [ RunTime:0.005002s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15627 LIMIT 4 [ RunTime:0.001290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15627 ORDER BY `minOrder` ASC [ RunTime:0.002764s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15627 ORDER BY `unit` DESC [ RunTime:0.000508s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15627 LIMIT 2 [ RunTime:0.000353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15627 ORDER BY `minOrder` ASC [ RunTime:0.001705s ]
select * from pdf where partno='647-10-ABEP' and brandshort='WAKEFIELD THERMAL' limit 1 [ RunTime:0.009148s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '647-10-ABEP' OR `brand` LIKE 'WAKEFIELD THERMAL%' ) ) LIMIT 1 [ RunTime:0.022481s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15626 LIMIT 4 [ RunTime:0.003408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15626 ORDER BY `minOrder` ASC [ RunTime:0.009873s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15626 ORDER BY `unit` DESC [ RunTime:0.012588s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15626 LIMIT 2 [ RunTime:0.000632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15626 ORDER BY `minOrder` ASC [ RunTime:0.002282s ]
select * from pdf where partno='BZD27C10P-HE3-08' and brandshort='VISHAY' limit 1 [ RunTime:0.022570s ]
select foldpath,foldpath2,filename from pdf_file where id=1758124 limit 1 [ RunTime:0.006760s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BZD27C10P-HE3-08' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.017112s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15625 LIMIT 4 [ RunTime:0.002165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15625 ORDER BY `minOrder` ASC [ RunTime:0.014797s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15625 ORDER BY `unit` DESC [ RunTime:0.003335s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15625 LIMIT 2 [ RunTime:0.010584s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15625 ORDER BY `minOrder` ASC [ RunTime:0.005106s ]
select * from pdf where partno='SMAJ12A' and brandshort='MULTICOMP PRO' limit 1 [ RunTime:0.010392s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ12A' OR `brand` LIKE 'MULTICOMP PRO%' ) ) LIMIT 1 [ RunTime:0.006227s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15624 LIMIT 4 [ RunTime:0.005157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15624 ORDER BY `minOrder` ASC [ RunTime:0.002902s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15624 ORDER BY `unit` DESC [ RunTime:0.010646s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15624 LIMIT 2 [ RunTime:0.005015s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15624 ORDER BY `minOrder` ASC [ RunTime:0.000270s ]
select * from pdf where partno='90327-0314' and brandshort='MOLEX' limit 1 [ RunTime:0.001352s ]
select foldpath,foldpath2,filename from pdf_file where id=856882 limit 1 [ RunTime:0.004360s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '90327-0314' OR `brand` LIKE 'MOLEX%' ) ) LIMIT 1 [ RunTime:0.018445s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15623 LIMIT 4 [ RunTime:0.003996s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15623 ORDER BY `minOrder` ASC [ RunTime:0.007403s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15623 ORDER BY `unit` DESC [ RunTime:0.002408s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15623 LIMIT 2 [ RunTime:0.001546s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15623 ORDER BY `minOrder` ASC [ RunTime:0.000946s ]
select * from pdf where partno='39-30-1060' and brandshort='MOLEX' limit 1 [ RunTime:0.005396s ]
select foldpath,foldpath2,filename from pdf_file where id=850377 limit 1 [ RunTime:0.012476s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '39-30-1060' OR `brand` LIKE 'MOLEX%' ) ) LIMIT 1 [ RunTime:0.025619s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15622 LIMIT 4 [ RunTime:0.002559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15622 ORDER BY `minOrder` ASC [ RunTime:0.006036s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15622 ORDER BY `unit` DESC [ RunTime:0.000563s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15622 LIMIT 2 [ RunTime:0.001838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15622 ORDER BY `minOrder` ASC [ RunTime:0.003241s ]
select * from pdf where partno='LTC6362CDD#PBF' and brandshort='ANALOG DEVICES' limit 1 [ RunTime:0.005099s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LTC6362CDD#PBF' OR `brand` LIKE 'ANALOG DEVICES%' ) ) LIMIT 1 [ RunTime:0.006471s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15621 LIMIT 4 [ RunTime:0.001083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15621 ORDER BY `minOrder` ASC [ RunTime:0.001955s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15621 ORDER BY `unit` DESC [ RunTime:0.002397s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15621 LIMIT 2 [ RunTime:0.002494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15621 ORDER BY `minOrder` ASC [ RunTime:0.000332s ]
select * from pdf where partno='F611FY156M400ZLH0J' and brandshort='KEMET' limit 1 [ RunTime:0.005284s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'F611FY156M400ZLH0J' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.010210s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15620 LIMIT 4 [ RunTime:0.002243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15620 ORDER BY `minOrder` ASC [ RunTime:0.006806s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15620 ORDER BY `unit` DESC [ RunTime:0.005358s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15620 LIMIT 2 [ RunTime:0.005041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15620 ORDER BY `minOrder` ASC [ RunTime:0.000936s ]
select * from pdf where partno='320564' and brandshort='AMP - TE CONNECTIVITY' limit 1 [ RunTime:0.004005s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '320564' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.013713s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15619 LIMIT 4 [ RunTime:0.001716s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15619 ORDER BY `minOrder` ASC [ RunTime:0.013040s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15619 ORDER BY `unit` DESC [ RunTime:0.011779s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15619 LIMIT 2 [ RunTime:0.006214s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15619 ORDER BY `minOrder` ASC [ RunTime:0.000430s ]
select * from pdf where partno='TJA1042T/3/1J' and brandshort='NXP' limit 1 [ RunTime:0.004232s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TJA1042T/3/1J' OR `brand` LIKE 'NXP%' ) ) LIMIT 1 [ RunTime:0.014765s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15618 LIMIT 4 [ RunTime:0.000477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15618 ORDER BY `minOrder` ASC [ RunTime:0.000984s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15618 ORDER BY `unit` DESC [ RunTime:0.002598s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15618 LIMIT 2 [ RunTime:0.008522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15618 ORDER BY `minOrder` ASC [ RunTime:0.000941s ]
select * from pdf where partno='BTS500101TAEATMA1' and brandshort='INFINEON' limit 1 [ RunTime:0.003172s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BTS500101TAEATMA1' OR `brand` LIKE 'INFINEON%' ) ) LIMIT 1 [ RunTime:0.014559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15617 LIMIT 4 [ RunTime:0.003255s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15617 ORDER BY `minOrder` ASC [ RunTime:0.006254s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15617 ORDER BY `unit` DESC [ RunTime:0.018715s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15617 LIMIT 2 [ RunTime:0.002086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15617 ORDER BY `minOrder` ASC [ RunTime:0.003267s ]
select * from pdf where partno='53-77-2G' and brandshort='BOYD' limit 1 [ RunTime:0.005935s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '53-77-2G' OR `brand` LIKE 'BOYD%' ) ) LIMIT 1 [ RunTime:0.005152s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15616 LIMIT 4 [ RunTime:0.002738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15616 ORDER BY `minOrder` ASC [ RunTime:0.003106s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15616 ORDER BY `unit` DESC [ RunTime:0.000325s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15616 LIMIT 2 [ RunTime:0.002450s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15616 ORDER BY `minOrder` ASC [ RunTime:0.004265s ]
select * from pdf where partno='RC0402FR-07560RL' and brandshort='YAGEO' limit 1 [ RunTime:0.001704s ]
select foldpath,foldpath2,filename from pdf_file where id=1976034 limit 1 [ RunTime:0.001188s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RC0402FR-07560RL' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.005560s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15615 LIMIT 4 [ RunTime:0.001010s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15615 ORDER BY `minOrder` ASC [ RunTime:0.001791s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15615 ORDER BY `unit` DESC [ RunTime:0.007341s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15615 LIMIT 2 [ RunTime:0.003643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15615 ORDER BY `minOrder` ASC [ RunTime:0.000246s ]
select * from pdf where partno='MC421-350002' and brandshort='MULTICOMP PRO' limit 1 [ RunTime:0.021911s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC421-350002' OR `brand` LIKE 'MULTICOMP PRO%' ) ) LIMIT 1 [ RunTime:0.023773s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `status` = 4 AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.013516s ]