SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001547s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.008442s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001856s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.21' ) [ RunTime:0.000352s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001522s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000318s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000620s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000176s ]
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.000707s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002615s ]
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.000417s ]
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 260,20 [ RunTime:0.008006s ]
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 ('15994','15993','15992','15991','15990','15989','15988','15987','15986','15985','15984','15983','15982','15981','15980','15979','15978','15977','15976','15975') ORDER BY FIELD(s.id, 15994,15993,15992,15991,15990,15989,15988,15987,15986,15985,15984,15983,15982,15981,15980,15979,15978,15977,15976,15975) [ RunTime:0.008305s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002220s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15994 LIMIT 4 [ RunTime:0.002718s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.006185s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15994 ORDER BY `minOrder` ASC [ RunTime:0.002104s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002050s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15994 ORDER BY `unit` DESC [ RunTime:0.005691s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003488s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15994 LIMIT 2 [ RunTime:0.011885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15994 ORDER BY `minOrder` ASC [ RunTime:0.001203s ]
select * from pdf where partno='BTS50301EJAXUMA1' and brandshort='INFINEON' limit 1 [ RunTime:0.003108s ]
select foldpath,foldpath2,filename from pdf_file where id=1761811 limit 1 [ RunTime:0.008219s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002554s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BTS50301EJAXUMA1' OR `brand` LIKE 'INFINEON%' ) ) LIMIT 1 [ RunTime:0.016986s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15993 LIMIT 4 [ RunTime:0.009951s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15993 ORDER BY `minOrder` ASC [ RunTime:0.004750s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15993 ORDER BY `unit` DESC [ RunTime:0.000706s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15993 LIMIT 2 [ RunTime:0.000327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15993 ORDER BY `minOrder` ASC [ RunTime:0.000199s ]
select * from pdf where partno='1N4744A' and brandshort='VISHAY' limit 1 [ RunTime:0.003929s ]
select foldpath,foldpath2,filename from pdf_file where id=307264 limit 1 [ RunTime:0.003963s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N4744A' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.013560s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15992 LIMIT 4 [ RunTime:0.001796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15992 ORDER BY `minOrder` ASC [ RunTime:0.000366s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15992 ORDER BY `unit` DESC [ RunTime:0.001520s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15992 LIMIT 2 [ RunTime:0.008320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15992 ORDER BY `minOrder` ASC [ RunTime:0.000269s ]
select * from pdf where partno='0475178281' and brandshort='FAIR-RITE' limit 1 [ RunTime:0.005153s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0475178281' OR `brand` LIKE 'FAIR-RITE%' ) ) LIMIT 1 [ RunTime:0.010371s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15991 LIMIT 4 [ RunTime:0.000715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15991 ORDER BY `minOrder` ASC [ RunTime:0.000367s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15991 ORDER BY `unit` DESC [ RunTime:0.003657s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15991 LIMIT 2 [ RunTime:0.009285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15991 ORDER BY `minOrder` ASC [ RunTime:0.007348s ]
select * from pdf where partno='1-1719393-1' and brandshort='TE CONNECTIVITY' limit 1 [ RunTime:0.003939s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1-1719393-1' OR `brand` LIKE 'TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.021120s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15990 LIMIT 4 [ RunTime:0.005319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15990 ORDER BY `minOrder` ASC [ RunTime:0.004695s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15990 ORDER BY `unit` DESC [ RunTime:0.000437s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15990 LIMIT 2 [ RunTime:0.000377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15990 ORDER BY `minOrder` ASC [ RunTime:0.001903s ]
select * from pdf where partno='RB420DT146' and brandshort='ROHM' limit 1 [ RunTime:0.008868s ]
select foldpath,foldpath2,filename from pdf_file where id=1785790 limit 1 [ RunTime:0.010747s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RB420DT146' OR `brand` LIKE 'ROHM%' ) ) LIMIT 1 [ RunTime:0.008747s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15989 LIMIT 4 [ RunTime:0.000353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15989 ORDER BY `minOrder` ASC [ RunTime:0.000208s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15989 ORDER BY `unit` DESC [ RunTime:0.000198s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15989 LIMIT 2 [ RunTime:0.000191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15989 ORDER BY `minOrder` ASC [ RunTime:0.000180s ]
select * from pdf where partno='DO5040H-473MLD' and brandshort='COILCRAFT' limit 1 [ RunTime:0.000323s ]
select foldpath,foldpath2,filename from pdf_file where id=1133360 limit 1 [ RunTime:0.000222s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DO5040H-473MLD' OR `brand` LIKE 'COILCRAFT%' ) ) LIMIT 1 [ RunTime:0.000245s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15988 LIMIT 4 [ RunTime:0.000674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15988 ORDER BY `minOrder` ASC [ RunTime:0.004448s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15988 ORDER BY `unit` DESC [ RunTime:0.002673s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15988 LIMIT 2 [ RunTime:0.001878s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15988 ORDER BY `minOrder` ASC [ RunTime:0.004921s ]
select * from pdf where partno='NTCLE305E4103SB.' and brandshort='VISHAY' limit 1 [ RunTime:0.002619s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NTCLE305E4103SB.' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.021255s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15987 LIMIT 4 [ RunTime:0.004253s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15987 ORDER BY `minOrder` ASC [ RunTime:0.006841s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15987 ORDER BY `unit` DESC [ RunTime:0.009156s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15987 LIMIT 2 [ RunTime:0.000570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15987 ORDER BY `minOrder` ASC [ RunTime:0.002371s ]
select * from pdf where partno='STC3100IST' and brandshort='STMICROELECTRONICS' limit 1 [ RunTime:0.002156s ]
select foldpath,foldpath2,filename from pdf_file where id=784856 limit 1 [ RunTime:0.006557s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'STC3100IST' OR `brand` LIKE 'STMICROELECTRONICS%' ) ) LIMIT 1 [ RunTime:0.001519s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15986 LIMIT 4 [ RunTime:0.000528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15986 ORDER BY `minOrder` ASC [ RunTime:0.005410s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15986 ORDER BY `unit` DESC [ RunTime:0.002612s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15986 LIMIT 2 [ RunTime:0.003668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15986 ORDER BY `minOrder` ASC [ RunTime:0.006108s ]
select * from pdf where partno='G17S0900110EU' and brandshort='AMPHENOL COMMUNICATIONS SOLUTIONS' limit 1 [ RunTime:0.012837s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'G17S0900110EU' OR `brand` LIKE 'AMPHENOL COMMUNICATIONS SOLUTIONS%' ) ) LIMIT 1 [ RunTime:0.013166s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15985 LIMIT 4 [ RunTime:0.009159s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15985 ORDER BY `minOrder` ASC [ RunTime:0.006551s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15985 ORDER BY `unit` DESC [ RunTime:0.002219s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15985 LIMIT 2 [ RunTime:0.003464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15985 ORDER BY `minOrder` ASC [ RunTime:0.000308s ]
select * from pdf where partno='MC001810' and brandshort='MULTICOMP' limit 1 [ RunTime:0.004997s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC001810' OR `brand` LIKE 'MULTICOMP%' ) ) LIMIT 1 [ RunTime:0.010083s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15984 LIMIT 4 [ RunTime:0.005059s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15984 ORDER BY `minOrder` ASC [ RunTime:0.001877s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15984 ORDER BY `unit` DESC [ RunTime:0.022275s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15984 LIMIT 2 [ RunTime:0.012616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15984 ORDER BY `minOrder` ASC [ RunTime:0.000494s ]
select * from pdf where partno='C1210C106K3RACTU' and brandshort='KEMET' limit 1 [ RunTime:0.005591s ]
select foldpath,foldpath2,filename from pdf_file where id=1157835 limit 1 [ RunTime:0.008123s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'C1210C106K3RACTU' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.016207s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15983 LIMIT 4 [ RunTime:0.013459s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15983 ORDER BY `minOrder` ASC [ RunTime:0.003121s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15983 ORDER BY `unit` DESC [ RunTime:0.007248s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15983 LIMIT 2 [ RunTime:0.013273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15983 ORDER BY `minOrder` ASC [ RunTime:0.002910s ]
select * from pdf where partno='MICA06' and brandshort='LUMBERG' limit 1 [ RunTime:0.005800s ]
select foldpath,foldpath2,filename from pdf_file where id=1099342 limit 1 [ RunTime:0.003727s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MICA06' OR `brand` LIKE 'LUMBERG%' ) ) LIMIT 1 [ RunTime:0.009802s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15982 LIMIT 4 [ RunTime:0.003935s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15982 ORDER BY `minOrder` ASC [ RunTime:0.003738s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15982 ORDER BY `unit` DESC [ RunTime:0.000964s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15982 LIMIT 2 [ RunTime:0.000410s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15982 ORDER BY `minOrder` ASC [ RunTime:0.000259s ]
select * from pdf where partno='CRCW04020000Z0ED' and brandshort='VISHAY' limit 1 [ RunTime:0.002153s ]
select foldpath,foldpath2,filename from pdf_file where id=1141018 limit 1 [ RunTime:0.007293s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CRCW04020000Z0ED' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.013958s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15981 LIMIT 4 [ RunTime:0.001433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15981 ORDER BY `minOrder` ASC [ RunTime:0.002761s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15981 ORDER BY `unit` DESC [ RunTime:0.000829s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15981 LIMIT 2 [ RunTime:0.000551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15981 ORDER BY `minOrder` ASC [ RunTime:0.000383s ]
select * from pdf where partno='99 9116 00 05' and brandshort='BINDER' limit 1 [ RunTime:0.001727s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '99 9116 00 05' OR `brand` LIKE 'BINDER%' ) ) LIMIT 1 [ RunTime:0.001955s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15980 LIMIT 4 [ RunTime:0.000598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15980 ORDER BY `minOrder` ASC [ RunTime:0.001189s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15980 ORDER BY `unit` DESC [ RunTime:0.004989s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15980 LIMIT 2 [ RunTime:0.014246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15980 ORDER BY `minOrder` ASC [ RunTime:0.004010s ]
select * from pdf where partno='206433-3' and brandshort='AMP - TE CONNECTIVITY' limit 1 [ RunTime:0.001965s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '206433-3' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.006941s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15979 LIMIT 4 [ RunTime:0.003602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15979 ORDER BY `minOrder` ASC [ RunTime:0.005832s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15979 ORDER BY `unit` DESC [ RunTime:0.008458s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15979 LIMIT 2 [ RunTime:0.000922s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15979 ORDER BY `minOrder` ASC [ RunTime:0.000442s ]
select * from pdf where partno='S80KS2564GACHI040' and brandshort='CYPRESS - INFINEON TECHNOLOGIES' limit 1 [ RunTime:0.007532s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'S80KS2564GACHI040' OR `brand` LIKE 'CYPRESS - INFINEON TECHNOLOGIES%' ) ) LIMIT 1 [ RunTime:0.002426s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15978 LIMIT 4 [ RunTime:0.003541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15978 ORDER BY `minOrder` ASC [ RunTime:0.000407s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15978 ORDER BY `unit` DESC [ RunTime:0.000410s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15978 LIMIT 2 [ RunTime:0.000384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15978 ORDER BY `minOrder` ASC [ RunTime:0.003454s ]
select * from pdf where partno='74HC4538DB,118' and brandshort='NEXPERIA' limit 1 [ RunTime:0.000605s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '74HC4538DB,118' OR `brand` LIKE 'NEXPERIA%' ) ) LIMIT 1 [ RunTime:0.000412s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15977 LIMIT 4 [ RunTime:0.000623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15977 ORDER BY `minOrder` ASC [ RunTime:0.002135s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15977 ORDER BY `unit` DESC [ RunTime:0.002363s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15977 LIMIT 2 [ RunTime:0.006310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15977 ORDER BY `minOrder` ASC [ RunTime:0.002686s ]
select * from pdf where partno='WYO472MCMCF0KR' and brandshort='VISHAY' limit 1 [ RunTime:0.005846s ]
select foldpath,foldpath2,filename from pdf_file where id=1480963 limit 1 [ RunTime:0.001861s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WYO472MCMCF0KR' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.020273s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15976 LIMIT 4 [ RunTime:0.000617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15976 ORDER BY `minOrder` ASC [ RunTime:0.008867s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15976 ORDER BY `unit` DESC [ RunTime:0.009022s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15976 LIMIT 2 [ RunTime:0.001633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15976 ORDER BY `minOrder` ASC [ RunTime:0.000391s ]
select * from pdf where partno='234168-1' and brandshort='AMP - TE CONNECTIVITY' limit 1 [ RunTime:0.001953s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '234168-1' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.003027s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15975 LIMIT 4 [ RunTime:0.006295s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15975 ORDER BY `minOrder` ASC [ RunTime:0.003224s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15975 ORDER BY `unit` DESC [ RunTime:0.002604s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15975 LIMIT 2 [ RunTime:0.003588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15975 ORDER BY `minOrder` ASC [ RunTime:0.002861s ]
select * from pdf where partno='1-179958-4' and brandshort='AMP - TE CONNECTIVITY' limit 1 [ RunTime:0.012579s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1-179958-4' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.003906s ]
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.008169s ]