SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001345s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000567s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002213s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.21' ) [ RunTime:0.009462s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001813s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000337s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000235s ]
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.000374s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002064s ]
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.010265s ]
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.014324s ]
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.013297s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.004300s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15634 LIMIT 4 [ RunTime:0.004599s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15634 ORDER BY `minOrder` ASC [ RunTime:0.001702s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001711s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15634 ORDER BY `unit` DESC [ RunTime:0.001261s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001698s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15634 LIMIT 2 [ RunTime:0.001041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15634 ORDER BY `minOrder` ASC [ RunTime:0.000245s ]
select * from pdf where partno='C0805C475K4PACTU' and brandshort='KEMET' limit 1 [ RunTime:0.003316s ]
select foldpath,foldpath2,filename from pdf_file where id=1896810 limit 1 [ RunTime:0.010683s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002218s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'C0805C475K4PACTU' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.008040s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15633 LIMIT 4 [ RunTime:0.004154s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15633 ORDER BY `minOrder` ASC [ RunTime:0.005199s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15633 ORDER BY `unit` DESC [ RunTime:0.011856s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15633 LIMIT 2 [ RunTime:0.012941s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15633 ORDER BY `minOrder` ASC [ RunTime:0.007234s ]
select * from pdf where partno='MSS1278-473MLD' and brandshort='COILCRAFT' limit 1 [ RunTime:0.015537s ]
select foldpath,foldpath2,filename from pdf_file where id=1051655 limit 1 [ RunTime:0.010084s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MSS1278-473MLD' OR `brand` LIKE 'COILCRAFT%' ) ) LIMIT 1 [ RunTime:0.004798s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15632 LIMIT 4 [ RunTime:0.005204s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15632 ORDER BY `minOrder` ASC [ RunTime:0.001596s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15632 ORDER BY `unit` DESC [ RunTime:0.000262s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15632 LIMIT 2 [ RunTime:0.000445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15632 ORDER BY `minOrder` ASC [ RunTime:0.000391s ]
select * from pdf where partno='ERA3APB332V' and brandshort='PANASONIC' limit 1 [ RunTime:0.001235s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ERA3APB332V' OR `brand` LIKE 'PANASONIC%' ) ) LIMIT 1 [ RunTime:0.012894s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15631 LIMIT 4 [ RunTime:0.007720s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15631 ORDER BY `minOrder` ASC [ RunTime:0.001977s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15631 ORDER BY `unit` DESC [ RunTime:0.006023s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15631 LIMIT 2 [ RunTime:0.000634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15631 ORDER BY `minOrder` ASC [ RunTime:0.000293s ]
select * from pdf where partno='505570-0701' and brandshort='MOLEX' limit 1 [ RunTime:0.002094s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '505570-0701' OR `brand` LIKE 'MOLEX%' ) ) LIMIT 1 [ RunTime:0.015008s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15630 LIMIT 4 [ RunTime:0.002990s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15630 ORDER BY `minOrder` ASC [ RunTime:0.001484s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15630 ORDER BY `unit` DESC [ RunTime:0.004045s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15630 LIMIT 2 [ RunTime:0.000378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15630 ORDER BY `minOrder` ASC [ RunTime:0.000268s ]
select * from pdf where partno='5103308-1' and brandshort='AMP - TE CONNECTIVITY' limit 1 [ RunTime:0.004120s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5103308-1' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.005888s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15629 LIMIT 4 [ RunTime:0.003489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15629 ORDER BY `minOrder` ASC [ RunTime:0.000390s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15629 ORDER BY `unit` DESC [ RunTime:0.000396s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15629 LIMIT 2 [ RunTime:0.009921s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15629 ORDER BY `minOrder` ASC [ RunTime:0.008268s ]
select * from pdf where partno='FPF2700MPX' and brandshort='ONSEMI' limit 1 [ RunTime:0.007476s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FPF2700MPX' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.018503s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15628 LIMIT 4 [ RunTime:0.000518s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15628 ORDER BY `minOrder` ASC [ RunTime:0.002766s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15628 ORDER BY `unit` DESC [ RunTime:0.011746s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15628 LIMIT 2 [ RunTime:0.004798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15628 ORDER BY `minOrder` ASC [ RunTime:0.007291s ]
select * from pdf where partno='SHT21' and brandshort='SENSIRION' limit 1 [ RunTime:0.013645s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SHT21' OR `brand` LIKE 'SENSIRION%' ) ) LIMIT 1 [ RunTime:0.022841s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15627 LIMIT 4 [ RunTime:0.012248s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15627 ORDER BY `minOrder` ASC [ RunTime:0.014808s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15627 ORDER BY `unit` DESC [ RunTime:0.018833s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15627 LIMIT 2 [ RunTime:0.007222s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15627 ORDER BY `minOrder` ASC [ RunTime:0.010955s ]
select * from pdf where partno='647-10-ABEP' and brandshort='WAKEFIELD THERMAL' limit 1 [ RunTime:0.005307s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '647-10-ABEP' OR `brand` LIKE 'WAKEFIELD THERMAL%' ) ) LIMIT 1 [ RunTime:0.007328s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15626 LIMIT 4 [ RunTime:0.006010s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15626 ORDER BY `minOrder` ASC [ RunTime:0.000395s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15626 ORDER BY `unit` DESC [ RunTime:0.002204s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15626 LIMIT 2 [ RunTime:0.001822s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15626 ORDER BY `minOrder` ASC [ RunTime:0.003748s ]
select * from pdf where partno='BZD27C10P-HE3-08' and brandshort='VISHAY' limit 1 [ RunTime:0.001381s ]
select foldpath,foldpath2,filename from pdf_file where id=1758124 limit 1 [ RunTime:0.008915s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BZD27C10P-HE3-08' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.012105s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15625 LIMIT 4 [ RunTime:0.001433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15625 ORDER BY `minOrder` ASC [ RunTime:0.004486s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15625 ORDER BY `unit` DESC [ RunTime:0.001727s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15625 LIMIT 2 [ RunTime:0.002859s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15625 ORDER BY `minOrder` ASC [ RunTime:0.002744s ]
select * from pdf where partno='SMAJ12A' and brandshort='MULTICOMP PRO' limit 1 [ RunTime:0.010165s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ12A' OR `brand` LIKE 'MULTICOMP PRO%' ) ) LIMIT 1 [ RunTime:0.009401s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15624 LIMIT 4 [ RunTime:0.000939s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15624 ORDER BY `minOrder` ASC [ RunTime:0.002919s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15624 ORDER BY `unit` DESC [ RunTime:0.003982s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15624 LIMIT 2 [ RunTime:0.022831s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15624 ORDER BY `minOrder` ASC [ RunTime:0.002378s ]
select * from pdf where partno='90327-0314' and brandshort='MOLEX' limit 1 [ RunTime:0.003037s ]
select foldpath,foldpath2,filename from pdf_file where id=856882 limit 1 [ RunTime:0.003298s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '90327-0314' OR `brand` LIKE 'MOLEX%' ) ) LIMIT 1 [ RunTime:0.005195s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15623 LIMIT 4 [ RunTime:0.005860s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15623 ORDER BY `minOrder` ASC [ RunTime:0.018185s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15623 ORDER BY `unit` DESC [ RunTime:0.008515s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15623 LIMIT 2 [ RunTime:0.003962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15623 ORDER BY `minOrder` ASC [ RunTime:0.000310s ]
select * from pdf where partno='39-30-1060' and brandshort='MOLEX' limit 1 [ RunTime:0.005994s ]
select foldpath,foldpath2,filename from pdf_file where id=850377 limit 1 [ RunTime:0.003333s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '39-30-1060' OR `brand` LIKE 'MOLEX%' ) ) LIMIT 1 [ RunTime:0.030966s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15622 LIMIT 4 [ RunTime:0.000405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15622 ORDER BY `minOrder` ASC [ RunTime:0.001686s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15622 ORDER BY `unit` DESC [ RunTime:0.015716s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15622 LIMIT 2 [ RunTime:0.032690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15622 ORDER BY `minOrder` ASC [ RunTime:0.025431s ]
select * from pdf where partno='LTC6362CDD#PBF' and brandshort='ANALOG DEVICES' limit 1 [ RunTime:0.005791s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LTC6362CDD#PBF' OR `brand` LIKE 'ANALOG DEVICES%' ) ) LIMIT 1 [ RunTime:0.002057s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15621 LIMIT 4 [ RunTime:0.003072s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15621 ORDER BY `minOrder` ASC [ RunTime:0.002121s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15621 ORDER BY `unit` DESC [ RunTime:0.010682s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15621 LIMIT 2 [ RunTime:0.002632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15621 ORDER BY `minOrder` ASC [ RunTime:0.000281s ]
select * from pdf where partno='F611FY156M400ZLH0J' and brandshort='KEMET' limit 1 [ RunTime:0.008051s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'F611FY156M400ZLH0J' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.008904s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15620 LIMIT 4 [ RunTime:0.007164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15620 ORDER BY `minOrder` ASC [ RunTime:0.000599s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15620 ORDER BY `unit` DESC [ RunTime:0.010418s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15620 LIMIT 2 [ RunTime:0.001273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15620 ORDER BY `minOrder` ASC [ RunTime:0.000432s ]
select * from pdf where partno='320564' and brandshort='AMP - TE CONNECTIVITY' limit 1 [ RunTime:0.002032s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '320564' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.004554s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15619 LIMIT 4 [ RunTime:0.006370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15619 ORDER BY `minOrder` ASC [ RunTime:0.038996s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15619 ORDER BY `unit` DESC [ RunTime:0.011629s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15619 LIMIT 2 [ RunTime:0.044760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15619 ORDER BY `minOrder` ASC [ RunTime:0.009231s ]
select * from pdf where partno='TJA1042T/3/1J' and brandshort='NXP' limit 1 [ RunTime:0.002260s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TJA1042T/3/1J' OR `brand` LIKE 'NXP%' ) ) LIMIT 1 [ RunTime:0.011401s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15618 LIMIT 4 [ RunTime:0.016424s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15618 ORDER BY `minOrder` ASC [ RunTime:0.000617s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15618 ORDER BY `unit` DESC [ RunTime:0.001777s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15618 LIMIT 2 [ RunTime:0.000426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15618 ORDER BY `minOrder` ASC [ RunTime:0.001540s ]
select * from pdf where partno='BTS500101TAEATMA1' and brandshort='INFINEON' limit 1 [ RunTime:0.010971s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BTS500101TAEATMA1' OR `brand` LIKE 'INFINEON%' ) ) LIMIT 1 [ RunTime:0.012751s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15617 LIMIT 4 [ RunTime:0.001100s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15617 ORDER BY `minOrder` ASC [ RunTime:0.007512s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15617 ORDER BY `unit` DESC [ RunTime:0.000425s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15617 LIMIT 2 [ RunTime:0.008190s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15617 ORDER BY `minOrder` ASC [ RunTime:0.000429s ]
select * from pdf where partno='53-77-2G' and brandshort='BOYD' limit 1 [ RunTime:0.003696s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '53-77-2G' OR `brand` LIKE 'BOYD%' ) ) LIMIT 1 [ RunTime:0.000931s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15616 LIMIT 4 [ RunTime:0.000357s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15616 ORDER BY `minOrder` ASC [ RunTime:0.000403s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15616 ORDER BY `unit` DESC [ RunTime:0.000449s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15616 LIMIT 2 [ RunTime:0.001137s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15616 ORDER BY `minOrder` ASC [ RunTime:0.015007s ]
select * from pdf where partno='RC0402FR-07560RL' and brandshort='YAGEO' limit 1 [ RunTime:0.001358s ]
select foldpath,foldpath2,filename from pdf_file where id=1976034 limit 1 [ RunTime:0.000252s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RC0402FR-07560RL' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.003336s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15615 LIMIT 4 [ RunTime:0.000864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15615 ORDER BY `minOrder` ASC [ RunTime:0.000686s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15615 ORDER BY `unit` DESC [ RunTime:0.000349s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15615 LIMIT 2 [ RunTime:0.000337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15615 ORDER BY `minOrder` ASC [ RunTime:0.000247s ]
select * from pdf where partno='MC421-350002' and brandshort='MULTICOMP PRO' limit 1 [ RunTime:0.003336s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC421-350002' OR `brand` LIKE 'MULTICOMP PRO%' ) ) LIMIT 1 [ RunTime:0.001224s ]
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.006985s ]