SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002452s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.002236s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002465s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.113' ) [ RunTime:0.009029s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002571s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.002186s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.003419s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.002010s ]
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.001722s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001771s ]
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.011815s ]
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.023290s ]
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.058424s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.004420s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15994 LIMIT 4 [ RunTime:0.015277s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.016205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15994 ORDER BY `minOrder` ASC [ RunTime:0.014832s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001596s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15994 ORDER BY `unit` DESC [ RunTime:0.002695s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001461s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15994 LIMIT 2 [ RunTime:0.004622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15994 ORDER BY `minOrder` ASC [ RunTime:0.003177s ]
select * from pdf where partno='BTS50301EJAXUMA1' and brandshort='INFINEON' limit 1 [ RunTime:0.001051s ]
select foldpath,foldpath2,filename from pdf_file where id=1761811 limit 1 [ RunTime:0.000913s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001661s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BTS50301EJAXUMA1' OR `brand` LIKE 'INFINEON%' ) ) LIMIT 1 [ RunTime:0.002999s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15993 LIMIT 4 [ RunTime:0.015474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15993 ORDER BY `minOrder` ASC [ RunTime:0.016448s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15993 ORDER BY `unit` DESC [ RunTime:0.022339s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15993 LIMIT 2 [ RunTime:0.000846s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15993 ORDER BY `minOrder` ASC [ RunTime:0.000263s ]
select * from pdf where partno='1N4744A' and brandshort='VISHAY' limit 1 [ RunTime:0.008827s ]
select foldpath,foldpath2,filename from pdf_file where id=307264 limit 1 [ RunTime:0.003449s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N4744A' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.035286s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15992 LIMIT 4 [ RunTime:0.028225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15992 ORDER BY `minOrder` ASC [ RunTime:0.009111s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15992 ORDER BY `unit` DESC [ RunTime:0.017123s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15992 LIMIT 2 [ RunTime:0.002523s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15992 ORDER BY `minOrder` ASC [ RunTime:0.003479s ]
select * from pdf where partno='0475178281' and brandshort='FAIR-RITE' limit 1 [ RunTime:0.031626s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0475178281' OR `brand` LIKE 'FAIR-RITE%' ) ) LIMIT 1 [ RunTime:0.006313s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15991 LIMIT 4 [ RunTime:0.015548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15991 ORDER BY `minOrder` ASC [ RunTime:0.012330s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15991 ORDER BY `unit` DESC [ RunTime:0.015605s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15991 LIMIT 2 [ RunTime:0.009018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15991 ORDER BY `minOrder` ASC [ RunTime:0.006141s ]
select * from pdf where partno='1-1719393-1' and brandshort='TE CONNECTIVITY' limit 1 [ RunTime:0.015381s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1-1719393-1' OR `brand` LIKE 'TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.031951s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15990 LIMIT 4 [ RunTime:0.018754s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15990 ORDER BY `minOrder` ASC [ RunTime:0.017209s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15990 ORDER BY `unit` DESC [ RunTime:0.015805s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15990 LIMIT 2 [ RunTime:0.007194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15990 ORDER BY `minOrder` ASC [ RunTime:0.003077s ]
select * from pdf where partno='RB420DT146' and brandshort='ROHM' limit 1 [ RunTime:0.041618s ]
select foldpath,foldpath2,filename from pdf_file where id=1785790 limit 1 [ RunTime:0.056098s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RB420DT146' OR `brand` LIKE 'ROHM%' ) ) LIMIT 1 [ RunTime:0.075978s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15989 LIMIT 4 [ RunTime:0.018051s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15989 ORDER BY `minOrder` ASC [ RunTime:0.004719s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15989 ORDER BY `unit` DESC [ RunTime:0.006669s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15989 LIMIT 2 [ RunTime:0.003573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15989 ORDER BY `minOrder` ASC [ RunTime:0.029774s ]
select * from pdf where partno='DO5040H-473MLD' and brandshort='COILCRAFT' limit 1 [ RunTime:0.019810s ]
select foldpath,foldpath2,filename from pdf_file where id=1133360 limit 1 [ RunTime:0.006362s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DO5040H-473MLD' OR `brand` LIKE 'COILCRAFT%' ) ) LIMIT 1 [ RunTime:0.003950s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15988 LIMIT 4 [ RunTime:0.068774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15988 ORDER BY `minOrder` ASC [ RunTime:0.014781s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15988 ORDER BY `unit` DESC [ RunTime:0.074139s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15988 LIMIT 2 [ RunTime:0.031310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15988 ORDER BY `minOrder` ASC [ RunTime:0.015031s ]
select * from pdf where partno='NTCLE305E4103SB.' and brandshort='VISHAY' limit 1 [ RunTime:0.022755s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NTCLE305E4103SB.' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.043179s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15987 LIMIT 4 [ RunTime:0.035249s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15987 ORDER BY `minOrder` ASC [ RunTime:0.032750s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15987 ORDER BY `unit` DESC [ RunTime:0.009258s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15987 LIMIT 2 [ RunTime:0.010711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15987 ORDER BY `minOrder` ASC [ RunTime:0.028851s ]
select * from pdf where partno='STC3100IST' and brandshort='STMICROELECTRONICS' limit 1 [ RunTime:0.001013s ]
select foldpath,foldpath2,filename from pdf_file where id=784856 limit 1 [ RunTime:0.014558s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'STC3100IST' OR `brand` LIKE 'STMICROELECTRONICS%' ) ) LIMIT 1 [ RunTime:0.005630s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15986 LIMIT 4 [ RunTime:0.019415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15986 ORDER BY `minOrder` ASC [ RunTime:0.068580s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15986 ORDER BY `unit` DESC [ RunTime:0.037222s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15986 LIMIT 2 [ RunTime:0.040925s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15986 ORDER BY `minOrder` ASC [ RunTime:0.000908s ]
select * from pdf where partno='G17S0900110EU' and brandshort='AMPHENOL COMMUNICATIONS SOLUTIONS' limit 1 [ RunTime:0.072171s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'G17S0900110EU' OR `brand` LIKE 'AMPHENOL COMMUNICATIONS SOLUTIONS%' ) ) LIMIT 1 [ RunTime:0.021365s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15985 LIMIT 4 [ RunTime:0.082319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15985 ORDER BY `minOrder` ASC [ RunTime:0.072590s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15985 ORDER BY `unit` DESC [ RunTime:0.073044s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15985 LIMIT 2 [ RunTime:0.019211s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15985 ORDER BY `minOrder` ASC [ RunTime:0.024518s ]
select * from pdf where partno='MC001810' and brandshort='MULTICOMP' limit 1 [ RunTime:0.039700s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC001810' OR `brand` LIKE 'MULTICOMP%' ) ) LIMIT 1 [ RunTime:0.079303s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15984 LIMIT 4 [ RunTime:0.027933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15984 ORDER BY `minOrder` ASC [ RunTime:0.031425s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15984 ORDER BY `unit` DESC [ RunTime:0.030334s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15984 LIMIT 2 [ RunTime:0.018485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15984 ORDER BY `minOrder` ASC [ RunTime:0.028859s ]
select * from pdf where partno='C1210C106K3RACTU' and brandshort='KEMET' limit 1 [ RunTime:0.023768s ]
select foldpath,foldpath2,filename from pdf_file where id=1157835 limit 1 [ RunTime:0.040781s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'C1210C106K3RACTU' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.029055s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15983 LIMIT 4 [ RunTime:0.033572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15983 ORDER BY `minOrder` ASC [ RunTime:0.067994s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15983 ORDER BY `unit` DESC [ RunTime:0.024055s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15983 LIMIT 2 [ RunTime:0.018983s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15983 ORDER BY `minOrder` ASC [ RunTime:0.008165s ]
select * from pdf where partno='MICA06' and brandshort='LUMBERG' limit 1 [ RunTime:0.056551s ]
select foldpath,foldpath2,filename from pdf_file where id=1099342 limit 1 [ RunTime:0.016724s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MICA06' OR `brand` LIKE 'LUMBERG%' ) ) LIMIT 1 [ RunTime:0.027658s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15982 LIMIT 4 [ RunTime:0.023959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15982 ORDER BY `minOrder` ASC [ RunTime:0.033325s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15982 ORDER BY `unit` DESC [ RunTime:0.013250s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15982 LIMIT 2 [ RunTime:0.025189s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15982 ORDER BY `minOrder` ASC [ RunTime:0.044051s ]
select * from pdf where partno='CRCW04020000Z0ED' and brandshort='VISHAY' limit 1 [ RunTime:0.031195s ]
select foldpath,foldpath2,filename from pdf_file where id=1141018 limit 1 [ RunTime:0.042702s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CRCW04020000Z0ED' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.057529s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15981 LIMIT 4 [ RunTime:0.026248s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15981 ORDER BY `minOrder` ASC [ RunTime:0.031795s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15981 ORDER BY `unit` DESC [ RunTime:0.036897s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15981 LIMIT 2 [ RunTime:0.005830s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15981 ORDER BY `minOrder` ASC [ RunTime:0.011849s ]
select * from pdf where partno='99 9116 00 05' and brandshort='BINDER' limit 1 [ RunTime:0.011642s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '99 9116 00 05' OR `brand` LIKE 'BINDER%' ) ) LIMIT 1 [ RunTime:0.009014s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15980 LIMIT 4 [ RunTime:0.064184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15980 ORDER BY `minOrder` ASC [ RunTime:0.017849s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15980 ORDER BY `unit` DESC [ RunTime:0.022849s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15980 LIMIT 2 [ RunTime:0.026986s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15980 ORDER BY `minOrder` ASC [ RunTime:0.001137s ]
select * from pdf where partno='206433-3' and brandshort='AMP - TE CONNECTIVITY' limit 1 [ RunTime:0.009403s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '206433-3' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.008518s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15979 LIMIT 4 [ RunTime:0.012170s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15979 ORDER BY `minOrder` ASC [ RunTime:0.012583s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15979 ORDER BY `unit` DESC [ RunTime:0.010578s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15979 LIMIT 2 [ RunTime:0.004114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15979 ORDER BY `minOrder` ASC [ RunTime:0.002163s ]
select * from pdf where partno='S80KS2564GACHI040' and brandshort='CYPRESS - INFINEON TECHNOLOGIES' limit 1 [ RunTime:0.014449s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'S80KS2564GACHI040' OR `brand` LIKE 'CYPRESS - INFINEON TECHNOLOGIES%' ) ) LIMIT 1 [ RunTime:0.007881s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15978 LIMIT 4 [ RunTime:0.023788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15978 ORDER BY `minOrder` ASC [ RunTime:0.020622s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15978 ORDER BY `unit` DESC [ RunTime:0.047705s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15978 LIMIT 2 [ RunTime:0.029211s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15978 ORDER BY `minOrder` ASC [ RunTime:0.010310s ]
select * from pdf where partno='74HC4538DB,118' and brandshort='NEXPERIA' limit 1 [ RunTime:0.029373s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '74HC4538DB,118' OR `brand` LIKE 'NEXPERIA%' ) ) LIMIT 1 [ RunTime:0.040605s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15977 LIMIT 4 [ RunTime:0.025809s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15977 ORDER BY `minOrder` ASC [ RunTime:0.021337s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15977 ORDER BY `unit` DESC [ RunTime:0.020810s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15977 LIMIT 2 [ RunTime:0.008884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15977 ORDER BY `minOrder` ASC [ RunTime:0.015048s ]
select * from pdf where partno='WYO472MCMCF0KR' and brandshort='VISHAY' limit 1 [ RunTime:0.029297s ]
select foldpath,foldpath2,filename from pdf_file where id=1480963 limit 1 [ RunTime:0.016514s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WYO472MCMCF0KR' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.035616s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15976 LIMIT 4 [ RunTime:0.022483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15976 ORDER BY `minOrder` ASC [ RunTime:0.033177s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15976 ORDER BY `unit` DESC [ RunTime:0.030401s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15976 LIMIT 2 [ RunTime:0.010492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15976 ORDER BY `minOrder` ASC [ RunTime:0.021135s ]
select * from pdf where partno='234168-1' and brandshort='AMP - TE CONNECTIVITY' limit 1 [ RunTime:0.021117s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '234168-1' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.014868s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15975 LIMIT 4 [ RunTime:0.019387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15975 ORDER BY `minOrder` ASC [ RunTime:0.049505s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15975 ORDER BY `unit` DESC [ RunTime:0.023824s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15975 LIMIT 2 [ RunTime:0.018840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15975 ORDER BY `minOrder` ASC [ RunTime:0.005335s ]
select * from pdf where partno='1-179958-4' and brandshort='AMP - TE CONNECTIVITY' limit 1 [ RunTime:0.006762s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1-179958-4' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.019146s ]
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.005589s ]